kopano-dbadm kc-1375 fails

Guizmo

I tried to run the kc-1375 and it fails with the following log :

Sat Oct 12 12:50:11 2019: [notice ] kc1375: purging problematic-looking IMAP envelopes...
Sat Oct 12 12:52:43 2019: [error  ] 0x55b623daecf8: SQL Failed: BIGINT UNSIGNED value is out of range in '(`kopano`.`p`.`tag` - 34049)', Query: "DELETE p FROM properties AS p INNER JOIN names AS n ON p.tag-34049=n.id WHERE n.guid=0x08F1F5003F8EC746AF275E201C3249E7 AND n.nameid=1 AND p.type=30 AND p.val_string LIKE '% (((%))) %'"
Sat Oct 12 12:52:43 2019: [error  ] KDatabase::I_Update() query failed: "BIGINT UNSIGNED value is out of range in '(`kopano`.`p`.`tag` - 34049)'", query: DELETE p FROM properties AS p INNER JOIN names AS n ON p.tag-34049=n.id WHERE n.guid=0x08F1F5003F8EC746AF725E201C2349E7 AND n.nameid=1 AND p.type=30 AND p.val_string LIKE '% (((%))) %'
Sat Oct 12 12:52:43 2019: [error  ] dbadm: action failed: disk error (80000007)

I guess I have corruption somewhere, any suggestion on the way to fix this ?

mcostan

when did start happening, did you run an upgrade?

What happens if you take a full dump of the database, does it succeed? And if you restore it and then try to run the command again, does it work?

thctlo

I have simular atm, as extra info, my database ( was mysql ) now mariadb, and started with zarafa 7.1.
now running : kopano 8.7.83.106.59c4d1516-0+58.1

kopano-dbadm kc-1375

2019-10-18T15:35:02.853459: [notice ] kc1375: purging problematic-looking IMAP envelopes...
2019-10-18T15:35:06.493292: [error  ] 0x5560a1af3c38: SQL Failed: BIGINT UNSIGNED value is out of range in '(`db_zarafa`.`p`.`tag` - 34049)', Query: "DELETE p FROM properties AS p INNER JOIN names AS n ON p.tag-34049=n.id WHERE n.guid=0x08F1F5003F8EC746AF725E201C2349E7 AND n.nameid=1 AND p.type=30 AND p.val_string LIKE '% (((%))) %'"
2019-10-18T15:35:06.493350: [error  ] KDatabase::I_Update() query failed: "BIGINT UNSIGNED value is out of range in '(`dbzarafa`.`p`.`tag` - 34049)'", query: DELETE p FROM properties AS p INNER JOIN names AS n ON p.tag-34049=n.id WHERE n.guid=0x08F1F5003F8EC746AF725E201C2349E7 AND n.nameid=1 AND p.type=30 AND p.val_string LIKE '% (((%))) %'
2019-10-18T15:35:06.493385: [error  ] dbadm: action failed: disk error (80000007)

jengelh

This post is deleted!

jengelh

Resolved with kopanocore-8.7.7-10-gde0ceb8bd, kopanocore-8.7.85-15-g3b4cbac2e.

thctlo

Thanks, ill do a check tody on this one.

thctlo

hmm. that resulted in

2019-11-11T13:22:39.572895: [kopano-dagent|T14201] [=======] LMTP service will now exit
2019-11-11T13:22:39.609848: [kopano-dagent|T2766] [=======] Starting kopano-dagent version 8.7.85 (pid 2766 uid 999) (LMTP mode)
2019-11-11T13:22:39.610073: [kopano-dagent|T2766] [warning] K-1558: Unable to limit socket 0.0.0.0%lo:2003 to lo: Operation not permitted
2019-11-11T13:22:39.610118: [kopano-dagent|T2766] [warning] K-1558: Unable to limit socket [::]%lo:2003 to lo: Operation not permitted

Updated…

If you run kopano-dagent.service with overrides.
remove the file with : LimitNOFILE=

systemctl daemon-reload
systemctl start kopano-dagent

And it starts as it should.

thctlo

Ok, today i installed : 8.7.85.25.66501f583-0+164.1

And Yes, this version works great.
All problems i had solved… Thanks for the great work.