From: Khimenko Victor
Date: March 22 1999 5:58pm
Subject: MySQLd locks while creating simple table
List-Archive: http://lists.mysql.com/mysql/784
Message-Id: <AB_IezsyI4@khim.sch57.msk.ru>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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