ourdelta-developers team mailing list archive

[Sergey Petrunia <psergey@xxxxxxxxxxxx>]

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