Answer the question
In order to leave comments, you need to log in
Mysql replication suddenly dropped?
Everything worked until today.
Relay_Master_Log_File: mysql-bin.000847
Slave_IO_Running: Yes
Slave_SQL_Running: No
[Note] Slave I/O thread: connected to master '[email protected]:3306',replication started in log 'mysql-bin.000847' at position 89963134
160707 11:19:09 [ERROR] Slave SQL: Error executing row event: 'Table 'mybase.delayed_jobs' doesn't exist', Error_code: 1146
160707 11:19:09 [Warning] Slave: Table 'mybase.delayed_jobs' doesn't exist Error_code: 1146
160707 11:19:09 [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.000847' position 89963134
Last_SQL_Errno: 1146
Last_SQL_Error: Error executing row event: 'Table 'mybase.delayed_jobs' doesn't exist'
Answer the question
In order to leave comments, you need to log in
'Table 'mybase.delayed_jobs' doesn't exist'
Doesn't this line mean anything to you? =)
Check that the master and the slave have this table. Apparently it was created somewhere but was not logged or you changed the name of the database.
Maybe even dropped it on the slave.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question