>Description: using mysql 3.23.41 when attempting to insert a large file (around 17 MB) into a longblob field i get the following error ERROR 2006 at line 1: MySQL server has gone away
our mysqld init script contains the following line: /usr/bin/safe_mysqld -O key_buffer=16M -O table_cache=128 -O sort_buffer=4M -O record_buffer=4M -O max_allowed_packet=64M -O max_connections=200 & our table schema looks like the following: DROP TABLE IF EXISTS file; CREATE TABLE file ( id int(10) unsigned NOT NULL default '0', data longblob ) TYPE=MyISAM; we are base-64 encoding the file before inserting it into the database we've tried: - increasing all the values in our init script - using php to upload the file and insert into the database - using java (jdbc) to insert the file - using the command line to insert the file ALL HAVE FAILED Note: - we can give you this file upon request >How-To-Repeat: 1. Get a large file (15+ MB) 2. Create schema as above 3. base-64 encode the file 4. insert into the table >Fix: unknown >Submitter-Id: <submitter ID> >Originator: >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: large blob inserts fail even when setting max-allowed-packet to 64M >Severity: serious >Priority: high >Category: mysql >Class: sw-bug >Release: mysql-3.23.41 (Source distribution) >Server: /usr/bin/mysqladmin Ver 8.21 Distrib 3.23.41, for redhat-linux-gnu on i386 Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.41 Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 54 min 43 sec Threads: 3 Questions: 1406 Slow queries: 0 Opens: 849 Flush tables: 1 Open tables: 128 Queries per second avg: 0.428 >Environment: System: Linux abe.commnav.com 2.4.7-10 #1 Thu Sep 6 17:27:27 EDT 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 20000731 (Red Hat Linux 7.1 2.96-98) Compilation info: CC='gcc' CFLAGS='-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE' CXX='c++' CXXFLAGS='-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Mar 1 05:22 /lib/libc.so.6 -> libc-2.2.4.so -rwxr-xr-x 1 root root 5723311 Dec 8 09:04 /lib/libc-2.2.4.so -rw-r--r-- 1 root root 27314296 Dec 8 09:02 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Dec 8 09:02 /usr/lib/libc.so Configure command: ./configure i386-redhat-linux --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin --sbindir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --includedir=/usr/include --libdir=/usr/lib --libexecdir=/usr/libexec --localstatedir=/var --sharedstatedir=/usr/com --mandir=/usr/share/man --infodir=/usr/share/info --without-debug --without-readline --enable-shared --with-extra-charsets=complex --with-bench --localstatedir=/var/lib/mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --with-mysqld-user=mysql --with-extra-charsets=all --disable-assember --with-berkeley-db --enable-large-files=yes --enable-largefile=yes --with-thread-safe-client --enable-assembler --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php