Mysql Replication Killed by the rawSQL plugin

Classic Servoy
1

I don’t know if anyone else has come across this, but yesterday i used the rawsql plugin for the first time to back populate my online database.

I ran a fairly simple query just populating 'Hello" into a couple of fields in a specific records.

This worked fine on my master database (MYSQL 5.0.41), but then jammed the slave when replicating.

It appears the error may be related to double quotes or something, but i am having it sent to me. There is no error on the master server and the data went in fine.

Hs anyone else seen this before using the RawSQL plugin?

var args = new Array();
args[0] = 'Hello1'
args[1] = 'Hello2'
args[2] = 'Hello3'
args[3] = 147403


var done = plugins.rawSQL.executeSQL("reportwriter_server","so_appointments","update so_appointments set rw_preview=?, rw_final_report=?, rw_accounts_invoice=?, rwrec=7 WHERE id=?",args)

This comes up without an error and the data goes into the Master database fine. It is only the replication that jams with an error?

Any thoughts?

David

2

You are giving the RAW sql plugin more credit than it deserves! All it does is pass your sql to the backend database, nothing more nothing less. So if anything jams you might want to get in contact with mysql. Are you updating rows that are in an update and locked? that might jam it.

3

Thanks Jan,

i have retested this and i think i must have had an error in one of my initial test scripts that stopped the replication as it seems to work fine now.

David