MySQL Forums
Forum List  »  Newbie

error 134
Posted by: khalid touati
Date: October 27, 2009 11:47AM

Hi Guys,
i have an error taht miss up everything using mysql in my server, including websites of course.
here is the thing: the error start with a table as it says here in the logs:

091023 12:45:40 [ERROR] Got error 134 when reading table './otrs/user_preferences'
091023 12:46:02 [ERROR] Got error 134 when reading table './otrs/user_preferences'
091023 12:46:11 [ERROR] Got error 134 when reading table './otrs/user_preferences'
091023 12:46:17 [ERROR] Got error 134 when reading table './otrs/user_preferences'
091023 12:46:23 [ERROR] Got error 134 when reading table './otrs/user_preferences'
091023 14:26:06 [Note] /usr/sbin/mysqld: Normal shutdown

091023 14:26:08 InnoDB: Starting shutdown...
091023 14:26:12 InnoDB: Shutdown completed; log sequence number 1 3966143693
091023 14:26:12 [Note] /usr/sbin/mysqld: Shutdown complete

091023 14:26:12 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=/var/run/mysqld/mysqld-bin' to avoid this problem.
091023 14:26:13 InnoDB: Started; log sequence number 1 3966143693
091023 14:26:13 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.44-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Gentoo Linux mysql-5.0.44-r2

this error make that when you connect to website it says "mysql cannot connect to database", so i restared the mysql and i get the warning below it stays normal for few hours like 6 hours and the cycle get launched again.
any idea that can get ma out of the cycle please!!?

Options: ReplyQuote


Subject
Written By
Posted
error 134
October 27, 2009 11:47AM
October 31, 2009 12:00AM


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.