[rt-devel] Attachment insert failed: MySQL server has gone away

[David Hanson]

On Wed, Oct 17, 2012 at 3:54 PM, Alex Vandiver <alexmv at bestpractical.com> wrote:
>
> On Wed, 2012-10-17 at 15:37 -0500, David Hanson wrote:
> > [snip]
>
> Please keep replies on-list so others can see and benefit from them, as
> well as contribute.
>
> > The my.cnf file:
> >
> >
> > [mysqld]
> > # Settings user and group are ignored when systemd is used.
> > # If you need to run mysqld under different user or group,
> > # customize your systemd unit file for mysqld according to the
> > # instructions in http://fedoraproject.org/wiki/Systemd
> > datadir=/var/lib/mysql
> > socket=/var/lib/mysql/mysql.sock
> > # Disabling symbolic-links is recommended to prevent assorted security
> > risks
> > symbolic-links=0
> >
> >
> > [mysqld_safe]
> > log-error=/var/log/mysqld.log
> > pid-file=/var/run/mysqld/mysqld.pid
> > max_allowed_packet=100M
>
> I agree that that looks not-wrong.  Double-check with `show variables
> like 'max_allowed_packet'`, to be sure.
>  - Alex
>
>
>
> --------
> Final RT training for 2012 in Atlanta, GA - October 23 & 24
>   http://bestpractical.com/training
>
> We're hiring! http://bestpractical.com/jobs

Thanks for the suggestion. That was able to lead me in the right
direction. Its a silly mistake, but that variable needs to be in the
[mysqld] section instead of the [mysqld_safe] section of the
configuration. So the my.cnf below works for me:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
symbolic-links=0
max_allowed_packet=100M

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Thanks,
David