Debug on Pacemaker and MySQL

command.log

[root@centillion ~]# tail -15  /var/log/mysqld.log
/usr/libexec/mysqld: Can't create/write to file '/tmp/ibIHAE2V' (Errcode: 28)
151019 17:32:13  InnoDB: Error: unable to create temporary file; errno: 28
/usr/libexec/mysqld: File './mysql-bin.000032' not found (Errcode: 28)
151019 17:32:13 [ERROR] Could not use mysql-bin for logging (error 28). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it.
151019 17:32:13 [ERROR] Aborting

151019 17:32:13 [Note] /usr/libexec/mysqld: Shutdown complete

151019 17:32:13  mysqld ended

/usr/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
/usr/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
/usr/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
/usr/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
/usr/libexec/mysqld: Retry in 60 secs. Message reprinted in 600 secs
[root@centillion ~]# uname -a
Linux centillion.db01 2.6.18-274.el5 #1 SMP Fri Jul 22 04:43:29 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux
[root@centillion ~]# LC_ALL=C df
Filesystem           1K-blocks      Used Available Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
                      36533824  34649092         0 100% /
/dev/sda1               101086     12959     82908  14% /boot
tmpfs                  1029412         0   1029412   0% /dev/shm

mysql_192.168.10.136.log

> 150826 17:05:40  InnoDB: Setting file ./ibdata1 size to 10 MB
> InnoDB: Database physically writes the file full: wait...
> 150826 17:05:43  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...
> 150826 17:05:44  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
> 150827 10:46:25 [ERROR] Slave I/O thread: error connecting to master '[email protected]:3306': Error: 'Lost connection to MySQL server at 'reading initial communication packet', system error: 113'  errno: 2013  retry-time: 60  retries: 86400
> 151009 17:31:23 [ERROR] Slave: Error 'Duplicate entry '6-1442548800' for key 1' on query. Default database: 'gaitame_chart2'. Query: 'INSERT INTO data_1 (period_id,utime,open,high,low,close,update_time,insert_time) VALUES  (6, 1442548800, 119.952, 119.965, 119.951, 119.957, 1442548803, 1442548803)', Error_code: 1062
> 151009 17:31:23 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql-bin.000021' position 763118621
> 151010 11:34:58 [ERROR] Slave: Error 'Duplicate entry '6-1442548800' for key 1' on query. Default database: 'gaitame_chart2'. Query: 'INSERT INTO data_1 (period_id,utime,open,high,low,close,update_time,insert_time) VALUES  (6, 1442548800, 119.952, 119.965, 119.951, 119.957, 1442548803, 1442548803)', Error_code: 1062
> 151010 11:34:58 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql-bin.000021' position 763118621
> 151015 16:09:20 [ERROR] Slave: Error 'Duplicate entry '6-1442548800' for key 1' on query. Default database: 'gaitame_chart2'. Query: 'INSERT INTO data_1 (period_id,utime,open,high,low,close,update_time,insert_time) VALUES  (6, 1442548800, 119.952, 119.965, 119.951, 119.957, 1442548803, 1442548803)', Error_code: 1062
> 151015 16:09:20 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql-bin.000021' position 763118621