search

ucd-cws / PISCES

Software for tracking and analyzing fish species range data
Other
0 stars 2 forks source link

HY000 database is locked #95

Closed nickrsan closed 9 years ago

nickrsan commented 9 years ago

Original report by AndyB (Bitbucket: AndyB, GitHub: AndyB).

In release 1.7alpha4, generate maps is failing with a database is locked error message.

2014-10-27 10_53_57-.png

nickrsan commented 9 years ago

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.

nickrsan commented 9 years ago

Original comment by Nicholas Santos (Bitbucket: nickrsan, GitHub: nickrsan).

OK, marking this as resolved now. Andy, reopen if you've seen this other times recently. Thanks!