Subject: The mailing list for listmasters using Sympa
List archive
- From: Amos <address@concealed>
- To: "address@concealed" <address@concealed>
- Subject: [sympa-users] mysql_auto_reconnect ? Sympa 6.1.23
- Date: Tue, 11 Nov 2014 11:06:18 -0600
Out of curiosity, why is this done?
# mysql:
# - At first, reset "mysql_auto_reconnect" driver attribute.
# connect() sets it to true not according to \%attr argument
# when the processes are running under mod_perl or CGI environment so
# that "SET NAMES utf8" will be skipped.
# - Set client-side character set to "utf8" or "utf8mb4".
if ($param->{'db_type'} eq 'mysql') {
$dbh->{'mysql_auto_reconnect'} = 0;
Since moving from PostgreSQL to MySQL, started to sporadically (like once a day) receive messages of the form:
err Bulk::store() Unable to add message in bulkspool_table "INSERT INTO bulkspool_table ... MySQL server has gone away
Not sure why the mysql_auto_reconnect is set to 0. I noticed (and translated) the French comment at the bottom of http://www.sympa.org/faq/database However, this came to light because at about the time of the Bulk::store message above, we get an email that Sympa "has encountered an internal server error."
Can this just be safely ignored?
Thanks.
-
[sympa-users] mysql_auto_reconnect ? Sympa 6.1.23,
Amos, 11/11/2014
-
Re: [sympa-users] mysql_auto_reconnect ? Sympa 6.1.23,
Amos, 11/12/2014
- Re: [sympa-users] mysql_auto_reconnect ? Sympa 6.1.23, O. Menkens, 11/13/2014
- Re: [sympa-users] mysql_auto_reconnect ? Sympa 6.1.23, Adam Bernstein, 11/14/2014
-
Re: [sympa-users] mysql_auto_reconnect ? Sympa 6.1.23,
Amos, 11/12/2014
Archive powered by MHonArc 2.6.19+.