Error with old version of sqlite3—what is the minimum recommended version?

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Error with old version of sqlite3—what is the minimum recommended version?

rsgoncalves
Hi, we're running into an issue (stack trace below) in Owlready2 (v0.36) when used in a system with sqlite3 v3.7.17, and when input ontologies are rather large — in general, functions are very slow. Using a newer version of sqlite3 this error doesn't seem occur and the package seems performant (e.g., in my local environment I've got sqlite3 v3.36.0 and I don't get the same slowness and error).

Is there a minimum version of sqlite3 that you recommend be installed for optimal performance of owlready2?

Thank you.

Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/n/www/text2term.hms.harvard.edu/support/home/virtual-environment/lib/python3.9/site-packages/owlready2/namespace.py", line 1010, in load
    if self.world.graph.indexed: self._load_properties()
  File "/n/www/text2term.hms.harvard.edu/support/home/virtual-environment/lib/python3.9/site-packages/owlready2/namespace.py", line 1035, in _load_properties
    if prop._check_update(self) and _LOG_LEVEL:
  File "/n/www/text2term.hms.harvard.edu/support/home/virtual-environment/lib/python3.9/site-packages/owlready2/prop.py", line 121, in _check_update
    if issubclass(Prop, ObjectProperty):
  File "/n/www/text2term.hms.harvard.edu/support/home/virtual-environment/lib/python3.9/site-packages/owlready2/entity.py", line 419, in issubclass_owlready
    Class_parents = set(Class.namespace.world._get_obj_triples_transitive_sp(Class.storid, Class._rdfs_is_a))
  File "/n/www/text2term.hms.harvard.edu/support/home/virtual-environment/lib/python3.9/site-packages/owlready2/triplelite.py", line 843, in _get_obj_triples_transitive_sp
    for (x,) in self.execute("""
sqlite3.OperationalError: near "WITH": syntax error
Reply | Threaded
Open this post in threaded view
|

Re: Error with old version of sqlite3—what is the minimum recommended version?

Jiba
Administrator
Hi,

I recommend the highest version, at least 3.33.

3.7.17 seems very old!

Jiba