John,
Wednesday, October 23, 2002, 7:06:57 PM, you wrote:
$ perror 144
144 = Table is crashed and last repair failed
Your table is corrupted, try to repair it with REPAIR TABLE or
myisamchk:
http://www.mysql.com/doc/en/Repair.html
JP Hmm. REPAIR TABLE gives
JP | mydb.IDRefs |
John,
Wednesday, October 23, 2002, 1:17:54 PM, you wrote:
JP This morning our MySQL exited for no good reason!
JP mysql.err:
JP 021020 17:25:53
JP 021020 17:
JP 021022 18:20:16 mysqld ended
JP mysql.log:
JP 021022 18:20:09
JP 243748 Connect mysql_user@localhost on
JP 243748 Init DB
JP 021022 18:20:16 mysqld ended
JP 243749 Query INSERT INTO IDRefs
JP VALUES('5136110c98b89de5d389df0754182ff2','','',NOW(),'Not
available','','')
MySQL server always crashes on this query? What is the structure of
the table IDRefs?
Not always, just a few times in the last few days
Another error!
PHP starts to output the error Too many references: cannot splice - error
144
When logging into mysql, I get:
Didn't find any fields in table IDRefs
started with -A, I get:
cannot open file: IDRefs.MYD (error: 144)
optimize table IDRefs;
Can't open file: 'IDRefs.MYD'. (errno: 13)
will want to get in touch with the System Administrator.
I hope this has been helpful.
Victor
-Original Message-
From: John P
To: [EMAIL PROTECTED]
Sent: 10/23/02 9:21 AM
Subject: Re: INSERT query crashes MySQL
Another error!
PHP starts to output the error Too many references: cannot
perror 144
144 = Table crashed and last repair failed
perror 13
Error code 13: Permission denied
It looks to me like mysql does not own all the files, and can't repair
the table.
John P wrote:
Another error!
PHP starts to output the error Too many references: cannot splice - error
144
When
Error 144 that the table is crashed and the last repair failed. You should
run a check and optimize on this table if possible. Error 13 indicates
that
you do not have permission to access the file. If you are the System
Administrator you may want to check the file permissions. Otherwise, you
John,
Wednesday, October 23, 2002, 5:21:38 PM, you wrote:
JP PHP starts to output the error Too many references: cannot splice - error
JP 144
JP When logging into mysql, I get:
JP Didn't find any fields in table IDRefs
JP started with -A, I get:
JP cannot open file: IDRefs.MYD (error: 144)
$
$ perror 144
144 = Table is crashed and last repair failed
Your table is corrupted, try to repair it with REPAIR TABLE or
myisamchk:
http://www.mysql.com/doc/en/Repair.html
Hmm. REPAIR TABLE gives
| mydb.IDRefs | repair | error| Can't create new tempfile:
'./mydb/IDRefs.TMD' |