Fix suggestion:

add into my.cnf line "binlog_format=mixed".

We should also check with PBXT devs whether their engine really cannot
work with statement-based replication.

-- 
mariadb .debs: default configuration makes it impossible to use pbxt
https://bugs.launchpad.net/bugs/454300
You received this bug notification because you are a member of OurDelta-
developers, which is the registrant for OurDelta.

Status in OurDelta - Builds for MySQL,MariaDB: New

Bug description:
Current deb packaging configures the server in a way that makes it impossible 
to use PBXT:

MySQL [boom]> create table tpbxt (a int) engine=pbxt;
Query OK, 0 rows affected (0.85 sec)

MySQL [boom]> show create table tpbxt\G
*************************** 1. row ***************************
       Table: tpbxt
Create Table: CREATE TABLE `tpbxt` (
  `a` int(11) DEFAULT NULL
) ENGINE=PBXT DEFAULT CHARSET=latin1
1 row in set (0.00 sec)

MySQL [boom]> insert into tpbxt values(10);
ERROR 1598 (HY000): Binary logging not possible. Message: Statement-based 
format required for this statement, but not allowed by this combination of 
engines

_______________________________________________
Mailing list: https://launchpad.net/~ourdelta-developers
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~ourdelta-developers
More help   : https://help.launchpad.net/ListHelp

Reply via email to