search

pombase / canto

The PomBase community curation tool
https://curation.pombase.org
Other
19 stars 7 forks source link

error messages #650

Closed pombase-admin closed 9 years ago

pombase-admin commented 10 years ago

been getting many today.

This one is from where I clicked to add a phenotype (from a gene page in the tool) . I have also been getting them after selecting a phenotype term (before adding the allele) I dont know if that one throws a different error though. Will cross-check next time I get one.

Internal error DBIx::Class::ResultSet::delete(): DBI Exception: DBD::SQLite::st execute failed: database is locked [for Statement "DELETE FROM cursprop WHERE ( ( ( curs = ? AND type = ? ) AND curs = ? ) )"] at lib/PomCur/Track/StatusStorage.pm line 109

Original comment by: Antonialock

pombase-admin commented 10 years ago

3 more error messages

Original comment by: ValWood

pombase-admin commented 10 years ago

Original comment by: kimrutherford

pombase-admin commented 10 years ago

After a lot of googling, I've found a database option that should fix things (hopefully). It was deep in the documentation and seems to basically be an "avoid 'database is locked' error" option (although the documentation doesn't say that). It's not the default because it makes things a bit slower. I'd rather have it work.

I hope that fixes it! Let me know if this happens again.

(Note to self: added the sqlite_use_immediate_transaction option to connect)

Original comment by: kimrutherford