Error 2006: MySQL server has gone away No connection.

[kzn]

Hello,I am using php+mysql to store files in a MySQL database as BLOBs.I am experiencing a problem, and i hope someone here will havea clue on how to get rid of this.
the error is : 2006, MySQL server has gone away

It happens each time I try to submit an INSERT command in wich a filein binary form wich is more than 4Mb large ...I hope someone will have a clue on this ...Regards

 

[majlumbo]

Check the current value for MAX_ALLOWED_PACKET

Increasing the value should help. Try 16M (or even greater).

The new settings for max_allowed_packet do not take effect until the MySQL service is restarted.

See here:

http://dev.mysql.com/doc/refman/5.5/en/packet-too-large.html

 

[kzn]

Hi Thanks for the reply, I have made all the changes but still getting the same error. Can anyone make heads or tails of the two files below: my.cnf and mysql error file

Thanks in advance.

Here is my.cnf file
[root@alfie etc]# cat my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

# Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
# symbolic-links=0
max_allowed_packet = 64m

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



Here is the mysql error file
[root@alfie etc]# cat /var/log/mysqld.log
110809 21:49:02 mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
110809 21:49:02 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
110809 21:49:02 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
110809 21:49:02 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
110809 21:49:02 InnoDB: Started; log sequence number 0 0
110809 21:49:02 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distr
110809 22:56:01 [Note] /usr/libexec/mysqld: Normal shutdown

110809 22:56:01 InnoDB: Starting shutdown...
110809 22:56:02 InnoDB: Shutdown completed; log sequence number 0 43655
110809 22:56:02 [Note] /usr/libexec/mysqld: Shutdown complete

110809 22:56:02 mysqld ended

110809 22:57:32 mysqld started
110809 22:57:32 InnoDB: Started; log sequence number 0 43655
110809 22:57:32 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distr
110816 22:46:30 [Note] /usr/libexec/mysqld: Normal shutdown

110816 22:46:30 InnoDB: Starting shutdown...
110816 22:46:30 InnoDB: Shutdown completed; log sequence number 0 43655
110816 22:46:30 [Note] /usr/libexec/mysqld: Shutdown complete

110816 22:46:30 mysqld ended

110816 22:47:58 mysqld started
110816 22:47:58 InnoDB: Started; log sequence number 0 43655
110816 22:47:58 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distr
110831 17:05:43 [Note] /usr/libexec/mysqld: Normal shutdown

110831 17:05:43 InnoDB: Starting shutdown...
110831 17:05:45 InnoDB: Shutdown completed; log sequence number 0 43655
110831 17:05:45 [Note] /usr/libexec/mysqld: Shutdown complete

110831 17:05:45 mysqld ended

110831 17:07:13 mysqld started
110831 17:07:14 InnoDB: Started; log sequence number 0 43655
110831 17:07:14 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distr
111027 11:52:36 [Note] /usr/libexec/mysqld: Normal shutdown

111027 11:52:36 InnoDB: Starting shutdown...
111027 11:52:37 InnoDB: Shutdown completed; log sequence number 0 43655
111027 11:52:37 [Note] /usr/libexec/mysqld: Shutdown complete

111027 11:52:37 mysqld ended

111027 11:54:04 mysqld started
111027 11:54:05 InnoDB: Started; log sequence number 0 43655
111027 11:54:05 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distr
111027 12:03:38 [Note] /usr/libexec/mysqld: Normal shutdown

111027 12:03:38 InnoDB: Starting shutdown...
111027 12:03:39 InnoDB: Shutdown completed; log sequence number 0 43655
111027 12:03:39 [Note] /usr/libexec/mysqld: Shutdown complete

111027 12:03:39 mysqld ended

111027 12:05:22 mysqld started
111027 12:05:23 InnoDB: Started; log sequence number 0 43655
111027 12:05:23 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distr
111027 13:06:06 [Note] /usr/libexec/mysqld: Normal shutdown

111027 13:06:06 InnoDB: Starting shutdown...
111027 13:06:08 InnoDB: Shutdown completed; log sequence number 0 43655
111027 13:06:08 [Note] /usr/libexec/mysqld: Shutdown complete

111027 13:06:08 mysqld ended

111108 19:19:49 mysqld started
111108 19:19:49 InnoDB: Started; log sequence number 0 43655
111108 19:19:49 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distr
111126 11:12:55 [Note] /usr/libexec/mysqld: Normal shutdown

111126 11:12:55 InnoDB: Starting shutdown...
111126 11:12:56 InnoDB: Shutdown completed; log sequence number 0 43655
111126 11:12:56 [Note] /usr/libexec/mysqld: Shutdown complete

111126 11:12:56 mysqld ended

111128 13:50:11 mysqld started
111128 13:50:13 InnoDB: Started; log sequence number 0 43655
111128 13:50:13 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distr
111129 14:28:09 [Note] /usr/libexec/mysqld: Normal shutdown

111129 14:28:09 InnoDB: Starting shutdown...
111129 14:28:10 InnoDB: Shutdown completed; log sequence number 0 43655
111129 14:28:10 [Note] /usr/libexec/mysqld: Shutdown complete

111129 14:28:10 mysqld ended

111129 14:29:38 mysqld started
111129 14:29:39 InnoDB: Started; log sequence number 0 43655
111129 14:29:39 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distr
111205 14:34:58 [Note] /usr/libexec/mysqld: Normal shutdown

111205 14:34:58 InnoDB: Starting shutdown...
111205 14:34:58 InnoDB: Shutdown completed; log sequence number 0 43655
111205 14:34:58 [Note] /usr/libexec/mysqld: Shutdown complete

111205 14:34:58 mysqld ended

111205 14:34:59 mysqld started
111205 14:34:59 InnoDB: Started; log sequence number 0 43655
111205 14:34:59 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distr
111205 14:44:08 [Note] /usr/libexec/mysqld: Normal shutdown

111205 14:44:08 InnoDB: Starting shutdown...
111205 14:44:09 InnoDB: Shutdown completed; log sequence number 0 43655
111205 14:44:09 [Note] /usr/libexec/mysqld: Shutdown complete

111205 14:44:09 mysqld ended

111205 14:44:10 mysqld started
111205 14:44:10 InnoDB: Started; log sequence number 0 43655
111205 14:44:10 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distr
[root@alfie etc]#