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 mydb
JP> 243749 Connect [EMAIL PROTECTED] on
JP> 243749 Init DB mydb
JP> 243748 Quit
JP> 243749 Query INSERT INTO IDRefs
JP> VALUES('5136110c98b89de5d389df0754182ff2','','',NOW(),'Not available','','')
JP> When I logged into mysql manually, there was an error relating to the IDRefs
JP> table, (can't remember exactly but it was something like "Cannot get data of
JP> table structure" - I was in a rush to get things up and running!). I deleted
JP> the contents of this table and used OPTIMIZE and it has worked OK since
JP> then.
JP> However, a similar crash occured on Sunday, but I didn't investigate it
JP> fully. So, why is this INSERT query causing MySQL to crash? The table it
JP> uses is the one that keeps track of users and their shopping bag (online web
JP> ordering facility).
JP> There was plenty of disk space on the server, Solaris 2.7, using mysql
JP> 3.23.51.
MySQL server always crashes on this query? What is the structure of
the table IDRefs?
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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
