error executing 'show variables' and 'show table status from [table]'
hello, I'm running version 4.0.3-beta-max-log on SunOS 5.8 (Generic_108528-15 sun4u sparc SUNW,Sun-Fire-280R) output from mysqlshow -V: mysqlshow Ver 9.4 Distrib 4.0.3-beta, for sun-solaris2.8 (sparc) I'm finding that executing either 'show variables' from a mysql session or 'mysqladmin -variables' from a shell prompt crashes the database. the database then restarts. this appears to be 100% repeatable on my install. Also, I cannot execute 'show table status from [tablename]'. All of my tables happen to be InnoDB tables. However, executing only 'show table status' or 'mysqlshow --status' works fine. any help you all can give wold be appreciated. thanks jeff mathis -- Jeff Mathis, Ph.D. 505-995-1434 The Prediction Company [EMAIL PROTECTED] 525 Camino de los Marquez, Ste 6http://www.predict.com Santa Fe, NM 87505 - 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
Error with SHOW VARIABLES
Description: When I issue a SHOW VARIABLES request using the standard command line client, I get a ERROR 2013: Lost connection to MySQL server during query. The server error log reports: mysqld got signal 10; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. and restarts. How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:Super-User Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Error with SHOW VARIABLES Severity: Priority: Category: mysql Class: Release: mysql-3.23.42 (Source distribution) Environment: System: SunOS www3 5.8 Generic_108528-15 sun4u sparc SUNW,Ultra-250 Architecture: sun4 Some paths: /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gcc /usr/ucb/cc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: -rw-r--r-- 1 root bin 1764484 Jul 8 23:17 /lib/libc.a lrwxrwxrwx 1 root root 11 Aug 25 2000 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1146204 Jul 8 23:17 /lib/libc.so.1 -rw-r--r-- 1 root bin 1764484 Jul 8 23:17 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Aug 25 2000 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1146204 Jul 8 23:17 /usr/lib/libc.so.1 Configure command: ./configure --with-mysqld-user=mysql - 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