"no such table: main.idx_{table}_{col}" Exception when writing Spatialite about geoalchemy2

[adrien-berchet]

Hi @Danaozhong
Thanks for your report!
Could you please provide a complete example in one piece so we just have to copy/paste it to reproduce your issue please? Also, could you run your code with echo=True passed to create_engine and post the result here? It will be much easier to understand what's going on with this.
Thanks

[Danaozhong]

Sure!
Here is a logfile created with echo=True.
complete_log.txt
A minimum example can be found here: https://github.com/Danaozhong/geoalchemy2-spatialite-example

[adrien-berchet]

I'm surprised by this line in your log:

updateTableTriggers: "no such module: rtree"

I think that, because of this, the spatial index is marked as enabled for your table but the creation of the tables actually containing the index values fails. So when you want to insert a new geometry, SpatiaLite tries to create a new index entry but fails since the required table does not exist.
Is it possible that your SpatiaLite was compiled without the R*Tree module?

[adrien-berchet]

@Danaozhong I tested your script and it works properly for me. So I really think this issue comes from your SpatiaLite library that is not properly installed or compiled. Did you try to perform the same operations manually using raw SQL (so without GeoAlchemy2)?

[Danaozhong]

Thank you, it seems that the root cause is indeed the way the SpatiaLite library was compiled.

[adrien-berchet]

Ok, great!
I close this issue but don't hesitate to reopen it if you have any other question on this.