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...

-- 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 --

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...