prepared statement for MyISAM tables fail in replication

Bug #1041029 reported by Seppo Jaakola
14
This bug affects 2 people
Affects Status Importance Assigned to Milestone
MySQL patches by Codership
Confirmed
Low
Unassigned

Bug Description

Server side prepared statements for tables of MyISAM engine, and myisam replication enabled by wsrep_replicate_myisam, cause problems in replication:

120823 2:39:09 [ERROR] Slave SQL: Error 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?, ?, ?)' at line 1' on query. Default database: 'test'. Query: 'INSERT INTO image_sound (ID, my_element1, my_picture) VALUES (?, ?, ?)', Error_code: 1064
120823 2:39:09 [Warning] WSREP: RBR event 1 Query apply warning: 1, 47987
120823 2:39:09 [Warning] WSREP: Ignoring error for TO isolated action: source: e71b252a-ece9-11e1-0800-ee3859a0aa03 version: 2 local: 0 state: CERTIFYING flags: 65 conn_id: 1027 trx_id: -1 seqnos (l: 8, g: 47987, s: 47986, d: 47986, ts: 1345703949458426109)

Positional parameters are not spelled out in the replication.

Revision history for this message
Seppo Jaakola (seppo-jaakola) wrote :

Server side PS is needed to reproduce, issue confirmed with python/oursql test

Changed in codership-mysql:
importance: Undecided → Low
status: New → Confirmed
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.