mariadb .debs: default configuration makes it impossible to use pbxt
Bug #454300 reported by
Sergey Petrunia
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OurDelta |
New
|
Undecided
|
Unassigned |
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
*******
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
To post a comment you must log in.
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.