kopano-dbadm kc-1375 fails



  • 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 ?



  • 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?



  • 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)
    


  • This post is deleted!


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



  • Thanks, ill do a check tody on this one.



  • 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.



  • 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.


Log in to reply