The mailing list for listmasters using Sympa

["O. Menkens" <address@concealed>]

Hi Amos,

Please check my original posting (https://listes.renater.fr/sympa/arc/sympa-users/2014-09/msg00018.html). Here I describe a patch, that helped me to display the mysql error in the sympa logfile. Perhaps there is another mysql issue on your side.

Olaf M.

P.S.: Our my.cnf has max_allowed_packet = 32M, which seems to be sufficient for our mailing lists.


Am 12.11.2014 23:46, schrieb Amos:

So, we've gone through a couple of rounds with the DBAs increasing the packet size from 16mb to 128mb, and yet just got the error message again.  I have to ask, what do folks typically set the max packet size in MySQL for Sympa?  I know this is going to be related to the largest size of a message.  Still, I would have thought that 128mb would have been plenty.

Sigh.  Never had this issue with PostgreSQL.

On Tue, Nov 11, 2014 at 11:06 AM, Amos <address@concealed> wrote:

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.