MySQL Forums
Forum List  »  Backup

Backup Causes Server To Crash
Posted by: T Fong
Date: June 28, 2010 10:48AM

Hi, every time I make a backup of my sql database it causes my server to crash. When I look at the mysql processes it shows a lot of queries with a locked state. They keep stacking up until the server overloads and crashes. At random times the server crashes and always reboots.

383783 cracking localhost cracking_cracker Query 1 Writing to net SELECT /*!40001 SQL_NO_CACHE */ * FROM `customavatar`
383786 cracking_geo localhost cracking_cracker Query 12 Locked UPDATE post SET thankscache = '' WHERE postid = 361005 LIMIT 1
383787 cracking_geo localhost cracking_cracker Query 12 Locked SELECT post.postid FROM post AS post WHERE post.threadid = 77659 AND post.visible = 1
383788 cracking_geo localhost cracking_cracker Query 12 Locked SELECT post.postid FROM post AS post WHERE post.threadid = 198679 AND post.visible = 1
383792 cracking_geo localhost cracking_cracker Query 11 Locked SELECT post.postid FROM post AS post WHERE post.threadid = 229051 AND post.visible = 1
383796 cracking_geo localhost cracking_cracker Query 8 Locked SELECT user.username, (user.options & 512) AS invisible, user.usergroupid, session.userid, ses
383797 cracking_geo localhost cracking_cracker Sleep 11 NULL
383800 cracking_geo localhost cracking_cracker Query 10 Locked UPDATE session SET lastactivity = 1277743447, location = '/forumdisplay.php?f=67', inforum = 67
383801 cracking_geo localhost cracking_cracker Query 10 Locked SELECT post.postid FROM post AS post WHERE post.threadid = 246616 AND post.visible = 1
383802 cracking_geo localhost cracking_cracker Query 10 Locked SELECT * FROM session WHERE sessionhash = '5bd4b0d5b19f400a9c25b34205fa6c40' AND lastac
383803 cracking_geo localhost cracking_cracker Sleep 10 NULL
383804 cracking_geo localhost cracking_cracker Query 10 Locked SELECT * FROM session WHERE sessionhash = '61d04f10295d2fe9ba9f0a03631de34d' AND lastac
383805 cracking_geo localhost cracking_cracker Query 10 Locked SELECT * FROM session WHERE sessionhash = '516fe22b4f31a8efdc4a0ed088ee2518' AND lastac
383806 cracking_geo localhost cracking_cracker Query 9 Locked SELECT * FROM session WHERE sessionhash = '46531a221a159f4e8c78e88e48b3ce70' AND lastac
383807 cracking_geo localhost cracking_cracker Query 8 Locked SELECT * FROM session WHERE sessionhash = '0931c75078eca964ebc2ed34ea2c52a7' AND lastac
383808 cracking_geo localhost cracking_cracker Query 8 Locked SELECT * FROM session WHERE sessionhash = '731ca4c641cc901e1b524e0aaf2a2dbc' AND lastac
383809 cracking_geo localhost cracking_cracker Query 7 Locked SELECT * FROM session WHERE sessionhash = '0931c75078eca964ebc2ed34ea2c52a7' AND lastac
383810 cracking_geo localhost cracking_cracker Query 7 Locked SELECT * FROM session WHERE sessionhash = '55f8292c8d50b4cf1b3bbb266cda9593' AND lastac
383811 cracking_geo localhost cracking_cracker Query 7 Locked SELECT * FROM session WHERE sessionhash = '7ca366358de1e94fdc9619378bf28658' AND lastac
383812 cracking_geo localhost cracking_cracker Query 6 Locked SELECT * FROM session WHERE sessionhash = '5eb0ac5e0913eb0e07ef92ff02284dd9' AND lastac
383813 cracking_geo localhost cracking_cracker Query 6 Locked SELECT * FROM session WHERE sessionhash = '641f4830929a5c6bce6c30732dac9d4c' AND lastac
383814 cracking_geo localhost cracking_cracker Query 6 Locked SELECT * FROM session WHERE sessionhash = '690b1fb74bd4f2184027bdea96b8bab1' AND lastac
383815 cracking_geo localhost cracking_cracker Query 6 Locked SELECT * FROM session WHERE sessionhash = '21c0401b8235222db800a96959523246' AND lastac
383816 cracking_geo localhost cracking_cracker Query 6 Locked SELECT * FROM session WHERE sessionhash = '61d04f10295d2fe9ba9f0a03631de34d' AND lastac
383817 cracking_geo localhost cracking_cracker Query 6 Locked SELECT * FROM session WHERE sessionhash = '77b13bb74b4e2289cf9e37ed4014cb96' AND lastac
383818 cracking_geo localhost cracking_cracker Sleep 4 NULL
383819 cracking_geo localhost cracking_cracker Query 3 Locked UPDATE session SET lastactivity = 1277743454, location = '/forumdisplay.php?f=7', inforum = 7,
383820 cracking_geo localhost cracking_cracker Query 4 Locked SELECT * FROM session WHERE sessionhash = 'a42496ac188b8b7402d15847d5879e2a' AND lastac
383821 cracking_geo localhost cracking_cracker Query 3 Locked SELECT post.*, IF(post.visible = 2, 1, 0) AS isdeleted, editlog.userid AS edit_userid, ed
383822 cracking_geo localhost cracking_cracker Query 3 Locked SELECT * FROM session WHERE sessionhash = '0931c75078eca964ebc2ed34ea2c52a7' AND lastac
383823 cracking_geo localhost cracking_cracker Query 3 Locked SELECT * FROM session WHERE userid = 0 AND host = '117.199.133.141' AND idhash = '
383824 cracking_geo localhost cracking_cracker Query 2 Locked SELECT * FROM session WHERE sessionhash = '13031106beecac9e440d7dc32aced91a' AND lastac
383825 cracking_geo localhost cracking_cracker Query 2 Locked SELECT * FROM session WHERE sessionhash = 'ef4582b4d51d2b6ec6643f9ec5432599' AND lastac
383826 cracking_geo localhost cracking_cracker Query 1 Locked SELECT * FROM session WHERE userid = 0 AND host = '125.231.209.167' AND idhash = '
383827 cracking_geo localhost cracking_cracker Query 1 Locked SELECT * FROM session WHERE sessionhash = 'b3d763400dd83a78e0440d34ca975fa1' AND lastac
383828 root localhost NULL Query 0 NULL SHOW PROCESSLIST


My mysql error log has shows this.


InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
100624 15:48:43 InnoDB: Unable to open the first data file
InnoDB: Error in opening ./ibdata1
100624 15:48:43 InnoDB: Operating system error number 11 in a file operation.
InnoDB: Error number 11 means 'Resource temporarily unavailable'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.0/en/operating-system-error-codes.html
InnoDB: Could not open or create data files.
InnoDB: If you tried to add new data files, and it failed here,
InnoDB: you should now edit innodb_data_file_path in my.cnf back
InnoDB: to what it was, and remove the new ibdata files InnoDB created
InnoDB: in this failed attempt. InnoDB only wrote those files full of
InnoDB: zeros, but did not yet use them in any way. But be careful: do not
InnoDB: remove old data files which contain your precious data!
100624 15:48:43 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
100624 15:48:43 [ERROR] Do you already have another mysqld server running on port: 3306 ?
100624 15:48:43 [ERROR] Aborting

100624 15:48:43 [Note] /usr/sbin/mysqld: Shutdown complete

100624 15:48:43 mysqld ended

100624 15:49:29 mysqld started
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
100624 15:49:29 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...
100624 15:49:29 InnoDB: Started; log sequence number 0 72693
100624 15:49:29 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.90-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)
100624 15:49:39 [Note] /usr/sbin/mysqld: Normal shutdown

100624 15:49:39 InnoDB: Starting shutdown...
100624 15:49:40 InnoDB: Shutdown completed; log sequence number 0 72693
100624 15:49:40 [Note] /usr/sbin/mysqld: Shutdown complete

100624 15:49:40 mysqld ended

100624 15:49:41 mysqld started
100624 15:49:41 InnoDB: Started; log sequence number 0 72693
100624 15:49:41 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.90-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)
100624 20:05:38 [Note] /usr/sbin/mysqld: Normal shutdown

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9163 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9159 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9157 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9156 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9155 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9154 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9153 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9151 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9146 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9145 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9144 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9142 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9141 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9139 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9138 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9135 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9134 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9133 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9132 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9131 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9130 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9127 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9126 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9125 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9124 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9123 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9122 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9121 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9120 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9119 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9118 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9117 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9116 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9115 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9114 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9113 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9112 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9111 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9110 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9109 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9108 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9107 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9106 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9105 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9104 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9103 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9102 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9101 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9100 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9099 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9098 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9097 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9096 user: 'cracking_geo'

100624 20:05:50 [Warning] /usr/sbin/mysqld: Forcing close of thread 9095 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9094 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9093 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9092 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9091 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9090 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9089 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9088 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9087 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9086 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9085 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9084 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9083 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9082 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9080 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9079 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9078 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9077 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9076 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9075 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9073 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9072 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9071 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9069 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9068 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9067 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9066 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9064 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9063 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9062 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9061 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9060 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9059 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9057 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9056 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9055 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9054 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9053 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9051 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9050 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9049 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9048 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9046 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9044 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9043 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9041 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9040 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9039 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9037 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9036 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9035 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9033 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9032 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9030 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9029 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9028 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9027 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9026 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9025 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9024 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9023 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9022 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9021 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9018 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9017 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9016 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9015 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9014 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9013 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9011 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9010 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9009 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9008 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9006 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9005 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9003 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9002 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9001 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 9000 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 8999 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 8997 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 8996 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 8995 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 8993 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 8992 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 8991 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 8987 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 8985 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 8984 user: 'cracking_geo'

100624 20:05:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 8983 user: 'cracking_geo'

100624 20:10:05 mysqld started
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
100624 20:10:06 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...
100624 20:10:06 InnoDB: Started; log sequence number 0 72719
100624 20:10:06 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.90-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)
100624 20:34:34 [Note] /usr/sbin/mysqld: Normal shutdown

100624 20:34:34 [ERROR] /usr/sbin/mysqld: Sort aborted
100624 20:34:36 InnoDB: Starting shutdown...
100624 20:34:39 InnoDB: Shutdown completed; log sequence number 0 72729
100624 20:34:39 [Note] /usr/sbin/mysqld: Shutdown complete

100624 20:34:39 mysqld ended

100624 20:34:40 mysqld started
100624 20:34:40 InnoDB: Started; log sequence number 0 72729
100624 20:34:40 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.90-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)
100624 20:42:27 [Note] /usr/sbin/mysqld: Normal shutdown

100624 20:42:29 InnoDB: Starting shutdown...
100624 20:42:30 InnoDB: Shutdown completed; log sequence number 0 72729
100624 20:42:30 [Note] /usr/sbin/mysqld: Shutdown complete

100624 20:42:30 mysqld ended

100624 20:42:39 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100624 20:42:39 [Warning] /usr/sbin/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100624 20:42:39 [Warning] '--safe-show-database' is deprecated and will be removed in a future release. Please use 'GRANT SHOW DATABASES' instead.
100624 20:42:39 [Note] Plugin 'FEDERATED' is disabled.
100624 20:42:39 InnoDB: Started; log sequence number 0 72729
100624 20:42:39 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50090, now running 50146. Please use mysql_upgrade to fix this error.
100624 20:42:39 [ERROR] mysql.user has no `Event_priv` column at position 29
100624 20:42:39 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
100624 20:42:39 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.46' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
100624 20:42:42 [Note] /usr/sbin/mysqld: Normal shutdown

100624 20:42:42 InnoDB: Starting shutdown...
100624 20:42:44 InnoDB: Shutdown completed; log sequence number 0 72729
100624 20:42:44 [Note] /usr/sbin/mysqld: Shutdown complete

100624 20:42:44 mysqld_safe mysqld from pid file /var/lib/mysql/host.crackingforum.com.pid ended
100624 20:42:45 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100624 20:42:45 [Warning] /usr/sbin/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100624 20:42:45 [Warning] '--safe-show-database' is deprecated and will be removed in a future release. Please use 'GRANT SHOW DATABASES' instead.
100624 20:42:45 [Note] Plugin 'FEDERATED' is disabled.
100624 20:42:45 InnoDB: Started; log sequence number 0 72729
100624 20:42:45 [Note] Event Scheduler: Loaded 0 events
100624 20:42:45 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.46' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
100624 21:09:13 [Note] /usr/sbin/mysqld: Normal shutdown

100624 21:09:13 [Note] Event Scheduler: Purging the queue. 0 events
100624 21:09:13 [ERROR] /usr/sbin/mysqld: Sort aborted
100624 21:09:15 InnoDB: Starting shutdown...
100624 21:09:16 InnoDB: Shutdown completed; log sequence number 0 72729
100624 21:09:16 [Note] /usr/sbin/mysqld: Shutdown complete

Options: ReplyQuote


Subject
Views
Written By
Posted
Backup Causes Server To Crash
3496
June 28, 2010 10:48AM
1534
July 06, 2010 09:41PM


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.