messageserver5 database disk image is malformed [answered]

asked 2020-01-09 10:33:46 +0200

krisko gravatar image

Hello all, for a while now I am unable to add any generic email or Gmail account. From the logs I can see some connection refused and I this the issue is in the messageserver5 daemon, which is not running and cannot be started because it's DB is corrupted. Could some one point me where is the DB and if its save t just remove it (I guess it will be recreated somehow).

Jan 09 09:24:41 Sailfish systemd[1346]: Started messageserver5.
Jan 09 09:24:41 Sailfish Msgsrv[6709]: [Warning] void QCopClient::connectToServer() QLocalSocket::ConnectionRefusedError "QLocalSocket::connectToServer: Connection refused"
Jan 09 09:24:41 Sailfish invoker[6904]: [6709] Jan 09 09:24:41 [Warning] void QCopClient::connectToServer() QLocalSocket::ConnectionRefusedError "QLocalSocket::connectToServer: Connection refused"
Jan 09 09:24:41 Sailfish Msgsrv[6709]: [Debug] Messaging :  MessageServer ctor begin
Jan 09 09:24:41 Sailfish invoker[6904]: [6709] Jan 09 09:24:41 [Debug] Messaging :  MessageServer ctor begin
Jan 09 09:24:41 Sailfish Msgsrv[6709]: [Debug] Messaging :  opening database
Jan 09 09:24:41 Sailfish invoker[6904]: [6709] Jan 09 09:24:41 [Debug] Messaging :  opening database
Jan 09 09:24:41 Sailfish Msgsrv[6709]: [Warning] Failed to create versioninfo table - query: "CREATE TABLE versioninfo (   tableName NVARCHAR (255) NOT NULL,   versionNum INTEGER NOT NULL,   lastUpdated NVARCHAR(20) NOT NULL,   PRIMARY KEY(tableName, versionNum))" - error: "database disk image is malformed Unable to execute statement"
Jan 09 09:24:41 Sailfish invoker[6904]: [6709] Jan 09 09:24:41 [Warning] Failed to create versioninfo table - query: "CREATE TABLE versioninfo (   tableName NVARCHAR (255) NOT NULL,   versionNum INTEGER NOT NULL,   lastUpdated NVARCHAR(20) NOT NULL,   PRIMARY KEY(tableName, versionNum))" - error: "database disk image is malformed Unable to execute statement"
Jan 09 09:24:41 Sailfish Msgsrv[6709]: [Critical] Messaging DB Invalid: Messaging cannot operate due to database incompatibilty!
Jan 09 09:24:41 Sailfish invoker[6904]: [6709] Jan 09 09:24:41 [Critical] Messaging DB Invalid: Messaging cannot operate due to database incompatibilty!
Jan 09 09:24:41 Sailfish mapplauncherd[1448]: Boosted process (pid=6709) was terminated due to signal 6
edit retag flag offensive reopen delete

The question has been closed for the following reason "the question is answered, an answer was accepted" by krisko
close date 2020-01-09 11:08:25.349843

Comments

The database is in ~/.qmf/database/qmailstore.db. I don't know if you can erase it safely. At least, make a copy before.

Damien Caliste ( 2020-01-09 10:37:28 +0200 )edit

That was it! Thank you! After one year, I can finally add email accounts! I've created backup from the database folder, restarted the messageserver5 service and I had to change owner for signond folder and start the signond daemon

$ mv ~/.qmf/database{,.bak}
$ systemctl --user restart messageserver5.service
# chown -R privileged.privileged /home/nemo/.config/signond
$ signond &
krisko ( 2020-01-09 11:07:55 +0200 )edit