Re: mysql problem
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 br...@fastmail.fm 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
Re: mysql problem
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 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
Re: mysql problem
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 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
RE: mysql problem
You can check the following link for more details: http://dev.mysql.com/doc/refman/5.0/en/gone-away.html But I have to agree, most likely your hitting a bug. I normally get this in code I've written where I make a request to the server after I have closed the connection. I would suggest enabling logging on the mysql server and look to see what the last myql queries cyrus makes before this happens, this may give you some clues as to where it's happening. Date: Wed, 11 Sep 2013 08:53:09 -0500 From: bl...@ispn.net To: info-cyrus@lists.andrew.cmu.edu Subject: Re: mysql problem 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 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 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
Re: MySQL problem
On Mon, 2003-06-02 at 14:08, Vasili G. Yanov wrote: I have successfully compiled and installed Sendmail 8.2.19 + Cyrus Imap 2.1.9 + Cyrus SASL 2.1.7. I store users in sasl2.db. After all I decide store all users in MySQL, for this I recompile sasl2 with --with-mysql. Now when I try to authorize I get error: unable to dlopen /usr/lib/sasl2//libmysql.so: /usr/lib/sasl2//libmysql.so: Undefined symbol mysql_connect Your probably using mysql4 in which case that should be a different call. When I get a new version of cyrus somewhere ill patch the code. -- Simon Loader
Re: MySQL problem
On Mon, 3 Jun 2003, Simon Loader wrote: Your probably using mysql4 in which case that should be a different call. When I get a new version of cyrus somewhere ill patch the code. The code is fixed in CVS. -Rob -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Rob Siemborski * Andrew Systems Group * Cyert Hall 207 * 412-268-7456 Research Systems Programmer * /usr/contributed Gatekeeper