hi,
I was running myisamchk and ismchk on my databases and I got the following
error:
warning: 1 clients is using or hasn't closed the table properly
what does this mean ?
how to prevent it ?
Who can help me out ?`
kind regards
Koen Gogne
[EMAIL PROTECTED]
I was running myisamchk and ismchk on my databases and I got the
following error:
warning: 1 clients is using or hasn't closed the table properly
You aren't running (my)isamchk with mysqld running are you? If so, you
shouldn't be.. or at least running on tables that are being used/open and
I can't believe MySQL is behaviouring that way and giving that kind of errors.
I've tried MySQL versions 3.23.33 and 3.22.27 both in Solaris and RedHat linux,
all with the same results.
Can anyone please help?
Thx in advance,
Joan
The tests consists in:
* creating a table,
* to insert 2
Never run isamchk with the server running.
Joan Vidal wrote:
I can't believe MySQL is behaviouring that way and giving that kind of errors.
I've tried MySQL versions 3.23.33 and 3.22.27 both in Solaris and RedHat linux,
all with the same results.
Can anyone please help?
Thx in advance,
Hi
Can anybody tell me what this error means
user@server#isamckh -av {database}/*.ISM
isamchk: error: 22 when opening ISAM-table '{database}/tax.ISM'(all
tables)
System is RedHat 7.0 i386 SMP Standard Kernel
mysql-3.22.32 standard compile from source --prefix=/usr/local
Ive tried
Stuart Fox wrote:
Hi
Can anybody tell me what this error means
user@server#isamckh -av {database}/*.ISM
isamchk: error: 22 when opening ISAM-table '{database}/tax.ISM'(all
tables)
If this was part of a script, then database was a variable that
contained the full
path
"Gerald L. Clark" wrote:
Stuart Fox wrote:
Hi
Can anybody tell me what this error means
user@server#isamckh -av {database}/*.ISM
isamchk: error: 22 when opening ISAM-table '{database}/tax.ISM'(all
tables)
If this was part of a script, then database was