MySQL Forums
Forum List  »  Spanish

Error_code: 1146
Posted by: Byron Gallardo
Date: August 20, 2020 04:10PM

Buenas tardes, tuve el error 1146, que afecto a 2 nodos esclavos en innodbcluster (group replication), solucione el error restaurando un respaldo del primario en ambos nodos quedando operativos nuevamente (la tabla a la que hace referencia el error si existe),lei que pudo ser por una query invalida o que no existe en mysql, pero este error me detuvo la replica hacia los nodos esclavos dejandolos en modo missing, sin poder volver a reintegrarlos con rejoinInstance, que pudo ser o como evitarlo a futuro? adjunto el error del log.


[ERROR] Slave SQL for channel 'group_replication_applier': Error executing row event: 'Table 'prepago_ocp43_dev.wp_options' doesn't e
xist', Error_code: 1146
[Warning] Slave: Table 'prepago_ocp43_dev.wp_options' doesn't exist Error_code: 1146
[ERROR] Plugin group_replication reported: 'The applier thread execution was aborted. Unable to process more transactions, this membe
r will now leave the group.'
[ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopp
ed at log 'FIRST' position 731.
[ERROR] Plugin group_replication reported: 'Fatal error during execution on the Applier process of Group Replication. The server will now leave the group.'
[ERROR] Plugin group_replication reported: 'The server was automatically set into read only mode after an error was detected.'
[Note] Plugin group_replication reported: 'Going to wait for view modification'
[Note] Plugin group_replication reported: 'The group replication applier thread was killed'
[Note] Plugin group_replication reported: 'Group membership changed: This member has left the group.'

Saludos y Gracias!

Options: ReplyQuote


Subject
Views
Written By
Posted
Error_code: 1146
291
August 20, 2020 04:10PM
62
August 20, 2020 04:13PM
59
August 20, 2020 05:23PM
76
August 20, 2020 07:10PM
61
August 20, 2020 08:32PM
78
August 20, 2020 09:02PM
70
August 24, 2020 12:11PM
57
August 24, 2020 03:44PM


Sorry, only registered users may post in this forum.

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.