maria-discuss team mailing list archive

Thread
Date

Slave SQL: Fatal error: ... Slave SQL Thread stopped with incomplete event group having non-transactional changes

To: Mailing-List mariadb <maria-discuss@xxxxxxxxxxxxxxxxxxx>
From: Reindl Harald <h.reindl@xxxxxxxxxxxxx>
Date: Thu, 29 Oct 2015 11:31:52 +0100
Openpgp: id=13540402D67A7F71C6E974EA866063CF7F780279; url=https://arrakis.thelounge.net/gpg/h.reindl_thelounge.net.pub.txt
Organization: the lounge interactive design
User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.3.0

* why does that happen at all instead finish whatever
  is not finished after get SIGTERM

* "try to restart the slave with --slave-exec-mode=IDEMPOTENT"
  must be a joke when "slave-exec-mode = IDEMPOTENT" is part
  of my.cnf for years *because* of that failure happening randomly
  when stop a slave at a wrong moment

151029 9:15:44 [ERROR] Slave SQL: Fatal error: ... Slave SQL Threadstopped with incomplete event group having non-transactional changes. Ifthe group consists solely of row-based events, you can try to restartthe slave with --slave-exec-mode=IDEMPOTENT, which ignores duplicatekey, key not found, and similar errors (see documentation for details).Gtid 0-1-2058483, Internal MariaDB error code: 1593

Attachment: signature.asc
Description: OpenPGP digital signature