pombase / canto

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

spurious canto errors #791

Closed pombase-admin closed 9 years ago

pombase-admin commented 9 years ago

Oddity in live pombe canto:

Just today, I've been getting error messages on some of the occasions when I change a session's status. It's mainly upon restarting approval or reactivating the session, but I'm not sure those are the only actions that have triggered 'em; I am pretty sure it hasn't happened every time I've tried one of those actions.

I'm also confident that the messages are spurious because when I go back to the summary page, the intended action has worked. Because it works, it's more of an annoyance than anything else for me, but I can see it scaring community curators.

Here's an example from c29f51c4cc86096d/reactivate_session/: Error 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/Canto/Track/StatusStorage.pm line 111 There has been an internal error. The problem has been logged and will be investigated.

Original comment by: mah11

pombase-admin commented 9 years ago

I've been getting errors today too. I've been trying (but failing) to see something consistent about them.

I've been getting them when adding a new phenotype (at different stages of the process). Sometimes the phenotype has been added, and sometimes not.

Original comment by: Antonialock

pombase-admin commented 9 years ago

I haven't done any phenotypes today (slogging through the biogrid corrections, and wow it's boring), so I don't know whether I would get errors if I tried. Will update this ticket if/when ...

Original comment by: mah11

pombase-admin commented 9 years ago

aha, just got one adding an interaction

1f991e4ad5694cb6 about a minute ago (16:57 BST)

Original comment by: mah11

pombase-admin commented 9 years ago

Original comment by: kimrutherford

pombase-admin commented 9 years ago

Yuck! That's for the report. I'll get right on it.

Original comment by: kimrutherford

pombase-admin commented 9 years ago

This probably happened because I updated the database library that Canto uses. It's a another hard to fix thing because it's tricky to reproduce the problem reliably and I can't reproduce it at all on my laptop.

So I've now gone through and upgraded everything Canto related I can find, including Perl, the Perl libraries it uses and the version of Linux it's running on. It's possible that will fix the problem. If not at least it's now running the same versions of everything as my laptop which will make debugging easier.

Changing the Linux version was a major move and some of the libraries haven't been updated in a couple of years. Everything seems fine but please let me know if anything seems weird. I'll be online from 8am-ish your time to fix any problems.

The UniProt and demo tools are still offline while I finish moving them.

Original comment by: kimrutherford

pombase-admin commented 9 years ago

Original comment by: ValWood

pombase-admin commented 9 years ago

Kim thinks this is fixed. Please submit a new ticket if this bug recurs.

Original comment by: ValWood