>Description:
I'm new to MySQL, and am porting an application from msql. Apologies
in advance for blatant ignorance on my part.
Apparantly the code that increments the counter on whether
a table has been modified is broken. myisamchk reports that:
"myisamchk: warning: 1 clients is using or hasn't closed the
table properly"
when I don't think it should. Also, note that the configuration
is somewhat non-standard.
>How-To-Repeat:
mysqladmin create foo
echo "CREATE TABLE try ( user CHAR(9), message TEXT) \g" | mysql foo
echo "INSERT INTO try VALUES ('hi', 'sailor') \g" | mysql foo
myisamchk /usr/local/storm/MySQL/var/foo/*.MYI
>Fix:
Fix 1:
$ mysql foo
mysql> flush tables;
mysql> quit
Fix 2:
$ mysqladmin shutdown
$ safe_mysqld &
All of these are only temporary. After inserting/updating to the
table, the warning from myisamchk reappears.
>Submitter-Id: <submitter ID>
Huh?
>Originator:
David Harrison
>Organization:
Dept. of Physics, Univ. of Toronto.
>MySQL support: [none | licence | email support | extended email support ]
none
>Synopsis:
myisamchk reports tables not closed properly
>Severity:
Don't know.
>Priority:
Don't know.
>Category: mysql
>Class:
sw-bug
>Release: mysql-3.23.40 (Source distribution)
>Server: /usr/local/storm/MySQL/bin/mysqladmin Ver 8.21 Distrib 3.23.40, for
>pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.40-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/tmp/mysql.sock
Uptime: 17 hours 21 min 20 sec
Threads: 1 Questions: 214 Slow queries: 0 Opens: 45 Flush tables: 2 Open tables:
11 Queries per second avg: 0.003
>Environment:
System: Linux storm.physics.utoronto.ca 2.2.16-4.lfssmp #1 SMP Wed Jul 12 14:00:26 EDT
2000 i686 unknown
Architecture: i686
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/i386-redhat-linux/egcs-2.91.66/specs
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Nov 19 2000 /lib/libc.so.6 -> libc-2.1.3.so
-rwxr-xr-x 1 root root 4101324 Feb 29 2000 /lib/libc-2.1.3.so
-rw-r--r-- 1 root root 20272704 Feb 29 2000 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Feb 29 2000 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr/local/storm/MySQL
--with-mysqld-user=storm --with-unix-socket-path=/var/tmp/mysql.sock
--with-tcp-port=3307
Perl: This is perl, version 5.005_03 built for i386-linux
---------------------------------------------------------------------
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
