HY000 database is locked
Closed this issue · 2 comments
Original report by AndyB (Bitbucket: AndyB, GitHub: AndyB).
In release 1.7alpha4, generate maps is failing with a database is locked error message.
Original comment by Nicholas Santos (Bitbucket: nickrsan, GitHub: nickrsan).
I haven't been able to reliably reproduce this except when another exception occurs too, so I wasn't able to confirm that it's what occurred. In response, I've converted the map documents to not using the same databases (seems that this form of feature class is still evolving heavily in ArcGIS - the "Query Feature Layer" - they're read only as of 10.2). That should cut down on use of the sqlite database of ArcMap. I also switched the PISCES ORM into autocommit mode so that when PyODBC transactions occur, the database shouldn't be locked (except maybe in the case of a few of the multiple cursor items since they share a connection? Something to watch out for). Just some notes here - not going to mark this as resolved for a while yet.