Info-cyrus Digest, Vol 98, Issue 4 Update
Rudolf Gabler
rug at usm.lmu.de
Wed Jan 14 06:35:09 EST 2015
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 at lists.andrew.cmu.edu
> On 11 Sep 2013, at 18:00, info-cyrus-request at lists.andrew.cmu.edu wrote:
>
> Send Info-cyrus mailing list submissions to
> info-cyrus at lists.andrew.cmu.edu
>
> 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 at lists.andrew.cmu.edu
>
> You can reach the person managing the list at
> info-cyrus-owner at lists.andrew.cmu.edu
>
> 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 at usm.lmu.de>
> Subject: mysql problem
> To: info-cyrus at lists.andrew.cmu.edu
> Message-ID: <ADBE1AB6-540B-4FA2-ADBE-98FDA0973586 at usm.lmu.de>
> 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 at fastmail.fm>
> Subject: Re: mysql problem
> To: info-cyrus at lists.andrew.cmu.edu
> Cc: Ken Murchison <murch at andrew.cmu.edu>
> Message-ID:
> <1378892613.11046.20578185.3FFF81BF at webmail.messagingengine.com>
> 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 at fastmail.fm
>
>
> ------------------------------
>
> Message: 3
> Date: Wed, 11 Sep 2013 07:00:09 -0400
> From: Ken Murchison <murch at andrew.cmu.edu>
> Subject: Re: mysql problem
> To: Bron Gondwana <brong at fastmail.fm>
> Cc: info-cyrus at lists.andrew.cmu.edu
> Message-ID: <52304D39.2030804 at andrew.cmu.edu>
> 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 at ispn.net>
> Subject: Re: mysql problem
> To: info-cyrus at lists.andrew.cmu.edu
> Message-ID: <523075C5.80705 at ispn.net>
> 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 at lists.andrew.cmu.edu
> https://lists.andrew.cmu.edu/mailman/listinfo/info-cyrus
>
>
> End of Info-cyrus Digest, Vol 98, Issue 4
> *****************************************
>
More information about the Info-cyrus
mailing list