Mysql not accepting some mails



  • fetchmail, postfix, kopano are working 100 to 200 of our daily mails.
    But in the mailq remain daily 8 to 12 mails.
    The deferred mails are not specifically big or html, mixed or containing binaries.
    Nor is postfix complaining the content as beeing not standard conform.

    postfix says: 450 mailbox temporarily not available

    dagent says: Unable to deliver message to "zentrale": disk error (80040116)

    server.log says:

    [error  ] SQL [00454463] Failed: MySQL server has gone away, Query Size: 1028280, Query: "REPLACE INTO properties (hierarchyid,tag,type,properties.val_ulong,properties.val_string,properties.val_binary,properties.val_double,properties.val_longint,properties.val_hi,properties.val_lo) VALUES(415741,34062,30,null,'JAS STD',null,null,null,null,null),(415741,34065,30,null,'notjunk:1;V01:K0:2qWpGnVIiKI=:v4qQb0q7HSuM6C4pvbP7Lk+eKw H7f9iz/RTEk6Si2eAFYQYhhMaHQ
    [...]
    \0\0\0\0<AC>!<A9>P@<D3><EE>H<B3>^Y<FB><A7>S0D%^A\0\0\0^F\0\0\0^F\0\0\0lBPUbAt6Ts+NIwBUW9QXuw==\0\0\0\0',null,null,null,null),(415741,64,30,null,'Zentrale',null,null,null,null,null),(415741,65,258,null,null,'\0\0\0\0<81>+^_<A4><BE><A3>^P^Y<9D>n\0<DD>^A^OT^B\0\0^A<80>E\0u\0
    [..]
    Sun Jun 17 06:48:18 2018: [warning] SQL [00454477] info: Try to reconnect
    Sun Jun 17 06:48:18 2018: [warning] SQL [00454281] info: Try to reconnect
    Sun Jun 17 06:48:18 2018: [error  ] SQL [00454479] Failed: MySQL server has gone away, Query Size: 1324594, Query: "REPLACE INTO properties (hierarchyid,tag,type,properties.val_ulong,properties.val_string,properties.val_binary,properties.va
    [...]
    

    At present there is no mention in the mariadb error.log.

    10.1.26-MariaDB-0+deb9u1 Debian 9.1
    kopano Version 8.6.80.45-0+ amd64

    Any suggestions?

    Thanks, if anybody has a clue!

    Klaus


  • Kopano

    Hi @kkappel ,

    @kkappel said in Mysql not accepting some mails:

    kopano Version 8.6.80.45-0+ amd64

    you are using quite an old version. This was a known issues on Debian 9 a while ago that we meanwhile have fixed. Therefore I advise to upgrade.



  • Hi there,

    unfort. in Univention 4.3.1 there ist still kopano 8.4.5.0 the newest version available.

    Is there any reference to where to find more information about this bug? Some workaround?

    Thanks
    lacroix


  • Kopano

    When running Univention and you have a Kopano subscription, then you can update your Kopano version through https://wiki.z-hub.io/display/K4U/Updating+Kopano+packages+directly+from+the+Kopano+download+server.

    The related Jira issue was https://jira.kopano.io/browse/KC-1053

    If you don’t have a Kopano subscription, then there is currenly an update for the Univention app in the pipeline. If everything goes well, then is should be online beginning of next week.



  • Thanks a lot for pointing that out!

    Upgrade to 8.6.80.1055-0+156.1_amd64.deb did the job!

    If anyone is interested in our repository: http://apt.jugendhilfe-wuemmetal.de

    While updating dagent did not work out of the box. I had to remove:
    #server_bind = 127.0.0.1
    #lmtp_port = 2003
    which helped to start the daemon.

    Great Work,
    we love Kopano!

    Klaus Kappel



  • I did a downgrade from the unmaintained repo. Downgraded libmariadb2 to 2.0.0-1 , but SQL server is not on the same host. This seems a problem with the client library only.

    #ucr set repository/online/unmaintained=yes
    #aptitude install libmariadb2=2.0.0-1


  • Kopano

    @lacroix why that downgrade? the update is available since monday. did it not solve your issue?



  • @felix no I missed that. So this is good news. Thanks.


Log in to reply