MySQL Forums
Forum List  »  Newbie

MySQL Crash
Posted by: M
Date: May 06, 2005 03:16PM

Greetings:

I was packing my tables full of goodies today, via the command line client, and when I initialized my -- INSERT INTO TABLE -- mysql sat with a blank stare with the cursor blinking at me. I waited, waited, and finally after 5 minutes realized something wasn't right. I didn't have proper Foreign Key constraints. I aborted the mission, only to stumble back and realize I was unable to provide the correct password for any user.

-A friendly telnet to 3306 responded with "couldn't connect to port 23"
-A telnet to localhost "Could not open a connection to host on port 23"
-When rebooting, MySQL Admin states "the service is running" although it's clearly not. It then frets about being shutdown or started. It's as though the service has a spirit there, but nothing else.

It seems as though we're looking for the wrong socket or something....I hope the tables aren't corrupted though I'm expecting the worst.

This doesn't look pretty:

050506 14:35:40 [ERROR] C:\MySQL\bin\mysqld-nt: Forcing close of thread 1 user: 'root'
050506 14:36:58 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
050506 14:37:09 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 2183745893.

Then:

InnoDB: Apply batch completed
InnoDB: 1 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 7549945 row operations to undo
InnoDB: Trx id counter is 0 11776
InnoDB: Starting rollback of uncommitted transactions
InnoDB: Rolling back trx with id 0 11366, 7549945 rows to undo
InnoDB: Progress in percents: 1

Someone, please help me if you have any clue.

Thank you for your time,

Marc

Options: ReplyQuote


Subject
Written By
Posted
MySQL Crash
M
May 06, 2005 03:16PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.