https://sourceforge.net/p/sqlgrey/support-requests/5/2011-02-24T09:57:26ZRecent changes to 5: Error in log2011-02-24T09:57:26Z2011-02-24T09:57:26ZAnonymoushttps://sourceforge.net/u/userid-None/https://sourceforge.net907f0b88d006bd48b12e486c6252f71f3eb8b496

<div class="markdown_content"><p>Dear all,</p> <p>i've found this three kind of error during normal work with sqlgrey:</p> <p>First One:</p> <p>Feb 23 03:15:28 [sqlgrey] dbaccess: error: couldn't get now() from DB: Too many connections_<br /> Feb 23 03:15:28 [sqlgrey] dbaccess: error: couldn't access domain_awl table: Too many connections_<br /> Feb 23 03:15:28 [sqlgrey] dbaccess: error: couldn't get now() from DB: Too many connections_<br /> Feb 23 03:15:28 [sqlgrey] dbaccess: error: couldn't access domain_awl table: Too many connections_<br /> Feb 23 03:15:28 [sqlgrey] dbaccess: error: couldn't get now() from DB: Too many connections_<br /> Feb 23 03:15:28 [sqlgrey] dbaccess: error: couldn't access domain_awl table: Too many connections_</p> <p>Second Warn:</p> <p>Feb 23 02:25:12 [sqlgrey] dbaccess: warning: couldn't do query:_UPDATE domain_awl SET last_seen = NOW(), first_seen = first_seen WHERE sender_domain = NULL AND src = NULL:_Too many connections, reconnecting to DB_<br /> Feb 23 02:25:12 [sqlgrey] dbaccess: warning: couldn't do query:_UPDATE domain_awl SET last_seen = NOW(), first_seen = first_seen WHERE sender_domain = NULL AND src = NULL:_Too many connections, reconnecting to DB_</p> <p>Third:<br /> Feb 23 21:07:49 [sqlgrey] dbaccess: warning: couldn't do query:_UPDATE from_awl SET last_seen = NOW(), first_seen = first_seen WHERE sender_name = 'maría073' AND sender_domain = '3016.jp' AND src = '79.163.190.114':_Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=', reconnecting to DB_<br /> Feb 23 21:07:50 [sqlgrey] dbaccess: warning: couldn't do query:_UPDATE from_awl SET last_seen = NOW(), first_seen = first_seen WHERE sender_name = 'maría073' AND sender_domain = '3016.jp' AND src = '79.163.190.114':_Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=', reconnecting to DB_<br /> Feb 23 21:07:50 [sqlgrey] dbaccess: warning: couldn't do query:_UPDATE from_awl SET last_seen = NOW(), first_seen = first_seen WHERE sender_name = 'maría073' AND sender_domain = '3016.jp' AND src = '79.163.190.114':_Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=', reconnecting to DB_</p> <p>It look strange because the db won't grow up, and stll on 200MB.</p> <p>Any suggestions ?</p> <p>Rgs<br /> Maximilian</p></div>