mariadb .debs: default configuration makes it impossible to use pbxt

Bug #454300 reported by Sergey Petrunia
6
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
*************************** 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

Revision history for this message
Sergey Petrunia (sergefp) wrote :

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.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.