mysql problem

[Ken Murchison]

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