All,

using ICE since many month know, I have to say I’m very pleased.

After upgrading to 3.3.1 though I run into a major issue. I have one server which has a mix of brighthouse and myisam tables where binary logging is enabled (I need it to have the myisam tables replicated) which worked just fine so far and loading was never an issue but now getting this error:

Command:
LOAD DATA INFILE ‘/tmp/file.txt’ INTO TABLE pseudo_table_date FIELDS TERMINATED BY ‘;’

Error:
/tmp/file.txt - 0: ERROR 1598 (HY000) at line 1: Binary logging not possible. Message: Statement cannot be logged to the binary log in row-based nor statement-based format

Can anyone help me in determining why suddenly this error is seen and what to do to workaround it?

I tried to cheat on mysql by adding
binlog-ignore-db=pseudo_db_workaround
to my-ib.cnf file and created this pseude db and tried to “use pseudo_db_workaround” before issuing the command (changed with my database prefix in front of the table name) in the hope that mysql wouldn’t look at the statements for binary logging where the database is ignored (as read in the inet) but it didn’t work either. Still getting same error…

This is really hurting me right now as I don’t want to reimport a few billion of rows to fallback :(

Any help will be appreciated.

Regards

m@rk

All,

found a workaround:
I make sure in my application that I have only updates to brighthouse tables and do each import in a seperate session, while beginning each session with “SET SQL_LOG_BIN = 0;”.

Of course you have to make sure that really really no updates to other tables happen in the same session… Seems to work for me so far…

Regards
m@rk