MySQL folks,
I posted a full bug report yesterday, but I'm afraid that my problem might
get lost in the details. It also had the wrong reply email address. Here's
a summary:
Under a variety of circumstances, creates and inserts of a
table with many columns, 2304 to be exact, hang the server. The
symptoms are that the mysqld thread gets a signal 11, and the client
never completes.
This behavior is seen on different servers, and from the perl and
C API's and from the MySQL command line. The create query is 74 kB long
and the insert query is 39 kB.
The hangs seem to be history dependent. If many inserts are done
rapidly, the server is more likely to hang.
The tables use an auto-incremented primary key.
Any help would be appreciated. Getting sort of desparate here.
>How-To-Repeat:
The following commands:
mysql test < create.sql
mysql test < insert.sql
mysql test < insert.sql
mysql test < insert.sql
.
.
.
executed rapidly from the shell seems to reliably hang the
server. Here create.sql and insert.sql can be found at
http://www.jlab.org/~marki/mysql_bug/create.sql
http://www.jlab.org/~marki/mysql_bug/insert.sql
Server: /usr/bin/mysqladmin Ver 8.23 Distrib 3.23.49, for redhat-linux-gnu on
i386
System: Linux claspc14.jlab.org 2.4.18-3 #1 Thu Apr 18 07:37:53 EDT 2002 i686 unknown
Architecture: i686
-- Mark
--
Mark M. Ito, Thomas Jefferson National Accelerator Facility
12000 Jefferson Ave., Mail Stop 12H, Newport News, VA 23606
Email: [EMAIL PROTECTED], Phone: (757)269-5295
---------------------------------------------------------------------
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
