Bug #1404
Core crashes with error about locked database when creating a new network
0%
Description
I don't know exactly how to reproduce this bug, but my quasselcore crashed when a user tried to create a network. Here's the log (I didn't have debug messages enabled at the time):
22176 2016-04-06 22:54:53 Error: unhandled Error in QSqlQuery! 22177 2016-04-06 22:54:53 Error: last Query: INSERT INTO buffer (userid, networkid, buffername, buffercname, buffertype, joined)VALUES (:userid, :networkid, :buffername, :buffercname, :buffertype, :joined) 22178 2016-04-06 22:54:53 Error: executed Query: INSERT INTO buffer (userid, networkid, buffername, buffercname, buffertype, joined)VALUES (?, ?, ?, ?, ?, ?) 22179 2016-04-06 22:54:53 Error: bound Values: :buffercname='', :buffername='', :buffertype=1, :joined=0, :networkid=12, :userid=2 22180 2016-04-06 22:54:53 Error: Error Number: 5 22181 2016-04-06 22:54:53 Error: Error Message: database is locked Unable to fetch row 22182 2016-04-06 22:54:53 Error: Driver Message: Unable to fetch row 22183 2016-04-06 22:54:53 Error: DB Message: database is locked 22184 2016-04-06 22:54:53 Error: ASSERT: "!createBuffer" in file /var/tmp/portage/net-irc/quassel-0.12.2-r4/work/quassel-0.12.2/src/core/coresession.cpp, line 323
After the crash, the assignment between identities and networks was messed up in my account (not the one that presumably caused the crash). I had two identities, with one only in use by one network, and that assignment "shifted" after the crash. It wasn't critical in my case, but this could be quite annoying or embarassing.
Also, the Version field in this bug tracker doesn't allow me to select my version of quassel, so that field contains garbage.
History
#1 Updated by YtvwlD over 8 years ago
I might have encoutered the same issue. After adding a network my Core crashed immediately and crashes frequently and mostly won't come up.
I'm currently transferring my database to Postgres - perhaps that'll help.
#2 Updated by wrtlprnft over 8 years ago
I should have mentioned that so far, I've exclusively used sqlite (version 3.12.0) with quassel.
#3 Updated by Robsdedude over 8 years ago
I've encountered the same issue as well. Core couldn't recover. All client side tries to connect resulted in a 'connection refused'. Nor further log messages after that crash. Restarting the core fixed it. Running version v0.12.4 (dist-90183ee) on Debian Jessie.