>Description:
Just try to use attached script. At least here mysqld
3.22.16gamma .. 3.22.20 locks reliable :-((
Both when accessed via JDBC and when accessed via mysql program...
>How-To-Repeat:
-- cut --
CREATE TABLE merch_users_tables (
userName varchar(128) DEFAULT '' NOT NULL,
tableName varchar(255) DEFAULT '' NOT NULL,
orderBy text,
orderDirection enum('asc','desc') DEFAULT 'asc' NOT NULL,
tableStructure text,
PRIMARY KEY (userName,tableName)
);
INSERT INTO merch_users_tables VALUES
('development','custom5','ecomm_info','asc','ecomm_info,notes');
INSERT INTO merch_users_tables VALUES
('development','custom2','ecomm_info','asc','ecomm_info,notes');
INSERT INTO merch_users_tables VALUES
('development','custom3','ecomm_info','asc','ecomm_info,notes');
INSERT INTO merch_users_tables VALUES ('development','one \"\"
more','top_level_cat','asc','top_level_cat,contract,aff_code_info,aff_code_status,driver_developer,driver_status,driver_eta,xxxx_sales_rep,merch_sales_rep,merch_tech_contact,merch_url,prod_url,cust_svc_emai,flat_file_loc,refresh_freq,uop_status,ecomm_info,merch_prod_count,notes');
INSERT INTO merch_users_tables VALUES
('sales','ALL','merch_name','asc','merch_name,priority,top_level_cat,type,contract,aff_code_info,aff_code_status,driver_developer,driver_status,driver_eta,xxxx_sales_rep,merch_sales_rep,merch_tech_contact,merch_url,prod_url,cust_svc_emai,flat_file_loc,refresh_freq,uop_status,ecomm_info,merch_prod_count,notes');
INSERT INTO merch_users_tables VALUES ('sales','merch &
notes','merch_name','asc','merch_name,notes');
-- cut --
>Fix:
Downgrade to 3.21.x ?
>Originator: khim@stripped
>MySQL support: none
>Synopsis: hangs with plain insert...
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.22.20a (Source distribution)
>Environment:
System: Linux khim.sch57.msk.ru 2.2.2-ac5 #1 SMP Sat Feb 27 12:19:08 EET 1999 i586 unknown
Architecture: i586
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/i586-ksi-linux/egcs-2.90.29/specs
gcc version egcs-2.90.29 980515 (egcs-1.0.3 release)
Compilation info: CC='gcc' CFLAGS='-O2 -mcpu=pentium -march=pentium -pipe
-fomit-frame-pointer' CXX='gcc' CXXFLAGS='-O2 -mcpu=pentium -march=pentium -pipe
-fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS=''
Configure command: ./configure --without-debug --without-readline --enable-shared
--enable-assembler --with-unix-socket-path=/var/lib/mysql/mysql.sock
--with-mysqld-user=mysql --prefix=/ --exec-prefix=/usr --with-charset=koi8_ukr
--libexecdir=/usr/sbin --infodir=/usr/info --sysconfdir=/etc --datadir=/usr/share
--localstatedir=/var/lib/mysql --includedir=/usr/include --mandir=/usr/man
i586-ksi-linux-gnu
Plus:
-- cut --
diff -uNr mysql-3.22.4-beta.orig/include/nisam.h mysql-3.22.4-beta/include/nisam.h
--- mysql-3.22.4-beta.orig/include/nisam.h Mon Mar 9 02:39:20 1998
+++ mysql-3.22.4-beta/include/nisam.h Thu Jul 9 12:20:50 1998
@@ -27,7 +27,7 @@
#define N_MAXKEY 16 /* Max allowed keys */
#define N_MAXKEY_SEG 16 /* Max segments for key */
-#define N_MAX_KEY_LENGTH 256 /* May be increased up to 500 */
+#define N_MAX_KEY_LENGTH 500 /* May be increased up to 500 */
#define N_MAX_KEY_BUFF (N_MAX_KEY_LENGTH+N_MAXKEY_SEG+sizeof(double)-1)
#define N_MAX_POSSIBLE_KEY_BUFF 500+9
-- cut --
Perl: This is perl, version 5.004_04 built for ksi-linux
`ps -axf | grep mysql` after hang:
-- cut --
900 p1 S 0:00 sh /usr/sbin/safe_mysqld --user=mysql --pid-file=/var/lib/my
912 p1 S N 0:00 \_ /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql -L
914 p1 Z N 0:00 \_ (mysqld <zombie>)
915 p1 S N 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql -Lengl
-- cut --
P.S. I'm not on list, so send replies to me directly...
