Hi below my problem in 2013, now with 2.4.17-caldev-beta10, mariadb and recompile, the "mysql connection problem" vanished and cyrus is working as expected. Regards, Rudi Gabler info-cyrus@xxxxxxxxxxxxxxxxxxxx > On 11 Sep 2013, at 18:00, info-cyrus-request@xxxxxxxxxxxxxxxxxxxx wrote: > > Send Info-cyrus mailing list submissions to > info-cyrus@xxxxxxxxxxxxxxxxxxxx > > To subscribe or unsubscribe via the World Wide Web, visit > https://lists.andrew.cmu.edu/mailman/listinfo/info-cyrus > or, via email, send a message with subject or body 'help' to > info-cyrus-request@xxxxxxxxxxxxxxxxxxxx > > You can reach the person managing the list at > info-cyrus-owner@xxxxxxxxxxxxxxxxxxxx > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Info-cyrus digest..." > > > Today's Topics: > > 1. mysql problem (Rudolf Gabler) > 2. Re: mysql problem (Bron Gondwana) > 3. Re: mysql problem (Ken Murchison) > 4. Re: mysql problem (Blake Hudson) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 11 Sep 2013 09:46:17 +0200 > From: Rudolf Gabler <rug@xxxxxxxxxx> > Subject: mysql problem > To: info-cyrus@xxxxxxxxxxxxxxxxxxxx > Message-ID: <ADBE1AB6-540B-4FA2-ADBE-98FDA0973586@xxxxxxxxxx> > Content-Type: text/plain; charset="windows-1252" > > Hi, > > the cyrus-imapd-2.4.17-caldav-beta6 release shows the following: > > After a fresh start with a mysql database for several purposes > > duplicate_db: sql > mboxlist_db: sql > quota_db: sql > tlscache_db: sql > > the system is running as expected. After approximately the 10 imaps contact suddenly the following occurs: > > Sep 11 09:43:29 xmailer imaps[8168]: DBERROR: SQL query failed: MySQL server has gone away > Sep 11 09:43:29 xmailer imaps[8168]: DBERROR: SQL failed SELECT * FROM mailboxes_db WHERE dbkey = 'user?.. > > But the local mysql server is o.k. and running. After a restart of cyrus (/etc/init.d/cyrus-imapd restart) everything is working until the next appr. 10 connection times by the user. > > If I use sqlite instead everything is stable for at least a month. > > Any hint what may occur? > > Regards, > > Rudi Gabler > -------------- next part -------------- > A non-text attachment was scrubbed... > Name: signature.asc > Type: application/pgp-signature > Size: 495 bytes > Desc: Message signed with OpenPGP using GPGMail > Url : http://lists.andrew.cmu.edu/pipermail/info-cyrus/attachments/20130911/7b0ff055/attachment-0001.bin > > ------------------------------ > > Message: 2 > Date: Wed, 11 Sep 2013 19:43:33 +1000 > From: Bron Gondwana <brong@xxxxxxxxxxx> > Subject: Re: mysql problem > To: info-cyrus@xxxxxxxxxxxxxxxxxxxx > Cc: Ken Murchison <murch@xxxxxxxxxxxxxx> > Message-ID: > <1378892613.11046.20578185.3FFF81BF@xxxxxxxxxxxxxxxxxxxxxxxxxxx> > Content-Type: text/plain; charset="utf-8" > > On Wed, Sep 11, 2013, at 05:46 PM, Rudolf Gabler wrote: >> Hi, >> >> the cyrus-imapd-2.4.17-caldav-beta6 release shows the following: >> >> After a fresh start with a mysql database for several purposes >> >> duplicate_db: sql >> mboxlist_db: sql >> quota_db: sql >> tlscache_db: sql >> >> the system is running as expected. After approximately the 10 imaps contact suddenly the following occurs: >> >> Sep 11 09:43:29 xmailer imaps[8168]: DBERROR: SQL query failed: MySQL server has gone away >> Sep 11 09:43:29 xmailer imaps[8168]: DBERROR: SQL failed SELECT * FROM mailboxes_db WHERE dbkey = 'user?.. >> >> But the local mysql server is o.k. and running. After a restart of cyrus (/etc/init.d/cyrus-imapd restart) everything is working until the next appr. 10 connection times by the user. > > Smells like connection handle leakage, or leakage of some other finite resource in the mysql library. > >> Any hint what may occur? > > Ken - any ideas? You know this code better than I do. > > Bron. > > -- > Bron Gondwana > brong@xxxxxxxxxxx > > > ------------------------------ > > Message: 3 > Date: Wed, 11 Sep 2013 07:00:09 -0400 > From: Ken Murchison <murch@xxxxxxxxxxxxxx> > Subject: Re: mysql problem > To: Bron Gondwana <brong@xxxxxxxxxxx> > Cc: info-cyrus@xxxxxxxxxxxxxxxxxxxx > Message-ID: <52304D39.2030804@xxxxxxxxxxxxxx> > Content-Type: text/plain; charset=UTF-8; format=flowed > > On 9/11/13 5:43 AM, Bron Gondwana wrote: >> On Wed, Sep 11, 2013, at 05:46 PM, Rudolf Gabler wrote: >>> Hi, >>> >>> the cyrus-imapd-2.4.17-caldav-beta6 release shows the following: >>> >>> After a fresh start with a mysql database for several purposes >>> >>> duplicate_db: sql >>> mboxlist_db: sql >>> quota_db: sql >>> tlscache_db: sql >>> >>> the system is running as expected. After approximately the 10 imaps contact suddenly the following occurs: >>> >>> Sep 11 09:43:29 xmailer imaps[8168]: DBERROR: SQL query failed: MySQL server has gone away >>> Sep 11 09:43:29 xmailer imaps[8168]: DBERROR: SQL failed SELECT * FROM mailboxes_db WHERE dbkey = 'user?.. >>> >>> But the local mysql server is o.k. and running. After a restart of cyrus (/etc/init.d/cyrus-imapd restart) everything is working until the next appr. 10 connection times by the user. >> Smells like connection handle leakage, or leakage of some other finite resource in the mysql library. >> >>> Any hint what may occur? >> Ken - any ideas? You know this code better than I do. >> >> Bron. >> > > No, I don't have any ideas. I don't have any experience using MySQL for > all Cyrus databases (or any Cyrus db for that matter), and the *DAV code > uses SQLite, not mySQL, and does so directly without going through the > cyrusdb API. > > -- > Kenneth Murchison > Principal Systems Software Engineer > Carnegie Mellon University > > > > ------------------------------ > > Message: 4 > Date: Wed, 11 Sep 2013 08:53:09 -0500 > From: Blake Hudson <blake@xxxxxxxx> > Subject: Re: mysql problem > To: info-cyrus@xxxxxxxxxxxxxxxxxxxx > Message-ID: <523075C5.80705@xxxxxxxx> > Content-Type: text/plain; charset=UTF-8; format=flowed > > Rudolf Gabler wrote the following on 9/11/2013 2:46 AM: >> the system is running as expected. After approximately the 10 imaps contact suddenly the following occurs: >> >> Sep 11 09:43:29 xmailer imaps[8168]: DBERROR: SQL query failed: MySQL server has gone away >> Sep 11 09:43:29 xmailer imaps[8168]: DBERROR: SQL failed SELECT * FROM mailboxes_db WHERE dbkey = 'user?.. >> >> But the local mysql server is o.k. and running. After a restart of cyrus (/etc/init.d/cyrus-imapd restart) everything is working until the next appr. 10 connection times by the user. >> >> If I use sqlite instead everything is stable for at least a month. >> >> Any hint what may occur? >> > > I'm not familiar with using MySQL for anything more than authentication > so I'm not sure how Cyrus makes it's db connections, but is there a > limit on the number of allowed client connections in my.cnf - or per > user on the MySQL account you're using for Cyrus? > > When Cyrus is broke, can you login to MySQL, use the Cyrus databases, > and run the queries that Cyrus would? > > --Blake > > > ------------------------------ > > _______________________________________________ > Info-cyrus mailing list > Info-cyrus@xxxxxxxxxxxxxxxxxxxx > https://lists.andrew.cmu.edu/mailman/listinfo/info-cyrus > > > End of Info-cyrus Digest, Vol 98, Issue 4 > ***************************************** > ---- Cyrus Home Page: http://www.cyrusimap.org/ List Archives/Info: http://lists.andrew.cmu.edu/pipermail/info-cyrus/ To Unsubscribe: https://lists.andrew.cmu.edu/mailman/listinfo/info-cyrus
