Re: Info-cyrus Digest, Vol 98, Issue 4 Update

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Index of Archives]     [Cyrus SASL]     [Squirrel Mail]     [Asterisk PBX]     [Video For Linux]     [Photo]     [Yosemite News]     [gtk]     [KDE]     [Gimp on Windows]     [Steve's Art]

  Powered by Linux