mysql always gets lock and stops ruuning

mojamoi

Well-Known Member
Jul 23, 2007
186
0
66
Hi,

Here are log files


I always have to delete the lock and restart mysql

and create mysql.sock


/var/liv/mysql/host.err

131106 12:32:24 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
131106 12:32:24 [Note] Plugin 'FEDERATED' is disabled.
131106 12:32:24 InnoDB: The InnoDB memory heap is disabled
131106 12:32:24 InnoDB: Mutexes and rw_locks use GCC atomic builtins
131106 12:32:24 InnoDB: Compressed tables use zlib 1.2.3
131106 12:32:24 InnoDB: Using Linux native AIO
131106 12:32:24 InnoDB: Initializing buffer pool, size = 128.0M
131106 12:32:24 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
131106 12:32:24 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
131106 12:32:24 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
131106 12:32:24 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
131106 12:32:25 InnoDB: Waiting for the background threads to start
131106 12:32:26 InnoDB: 5.5.32 started; log sequence number 0
131106 12:32:26 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
131106 12:32:26 [Note] - '0.0.0.0' resolves to '0.0.0.0';
131106 12:32:26 [Note] Server socket created on IP: '0.0.0.0'.
131106 12:32:26 [Note] Event Scheduler: Loaded 0 events
131106 12:32:26 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.32-cll' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
131106 12:32:39 mysqld_safe A mysqld process already exists
131107 4:27:48 [Warning] IP address '57.221.45.166' could not be resolved: Name or service not known
 

Sreejit

Member
Apr 11, 2011
20
0
51
cPanel Access Level
Root Administrator
Is there an innodb issue with your database? Are you deleting the innodb files and then restarting mysql? You can take a look at below url's for recovering data.

MySQL :: MySQL 5.0 Reference Manual :: 14.2.5.2 Forcing InnoDB Recovery
https://dev.mysql.com/doc/refman/5.5/en/innodb-recovery.html


InnoDB: The first specified data file ./ibdata1 did not exist:
131106 12:32:24 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
131106 12:32:24 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,201
363
Hello :)

Could you elaborate on what behavior you notice when MySQL stops responding? Also, which specific files are you deleting? Note that you should not manually delete the "ib_logfile1" file.

Thank you.