>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
