re: Re: INSERT query crashes MySQL

2002-10-24 Thread Victoria Reznichenko
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

Re: INSERT query crashes MySQL

2002-10-23 Thread John P
> $ 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.T

re: Re: INSERT query crashes MySQL

2002-10-23 Thread Victoria Reznichenko
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:

Re: INSERT query crashes MySQL

2002-10-23 Thread John P
> 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, yo

Re: INSERT query crashes MySQL

2002-10-23 Thread gerald_clark
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" Whe

RE: INSERT query crashes MySQL

2002-10-23 Thread Victor Pendleton
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: c

Re: INSERT query crashes MySQL

2002-10-23 Thread John P
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'. (errn

Re: INSERT query crashes MySQL

2002-10-23 Thread John P
> 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 fe

re: INSERT query crashes MySQL

2002-10-23 Thread Victoria Reznichenko
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

INSERT query crashes MySQL

2002-10-23 Thread John P
This morning our MySQL exited for no good reason! mysql.err: 021020 17:25:53 021020 17: 021022 18:20:16 mysqld ended mysql.log: 021022 18:20:09 243748 Connect mysql_user@localhost on 243748 Init DB mydb 243749 Connect [EMAIL PROTECTED] on 243749 Init DB mydb 243748 Quit 243749 Qu