[MCOL-12] working_dml/qa_sub/mts_insert_select.sql fails Created: 2016-05-03  Updated: 2023-10-26  Resolved: 2016-06-02

Status: Closed
Project: MariaDB ColumnStore
Component/s: ?
Affects Version/s: None
Fix Version/s: 1.0.0

Type: Bug Priority: Major
Reporter: Dipti Joshi (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None


 Description   

ERROR 1663 (HY000) at line 82 in file: 'working_dml/qa_sub/mts_insert_select.sql': Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.

 Comments   
Comment by Dipti Joshi (Inactive) [ 2016-05-10 ]

dleeyh What BINLOG_FORMAT you used when running this query ?

Comment by Daniel Lee (Inactive) [ 2016-05-10 ]

Binlog format was set to row, that's the default set during installation.

I think we should change it to statement. Also, the test stack that I setup was did not have two UMs so we don't need to setup replication in this case.

Comment by Dipti Joshi (Inactive) [ 2016-05-23 ]

(1) For Single UM system replication should not be enabled

(2) For multi-UM further analysis is needed

Comment by Dipti Joshi (Inactive) [ 2016-05-23 ]

dleeyh- Please test this with multi-UM

Comment by Dipti Joshi (Inactive) [ 2016-05-31 ]

dleeyh Please provide update on this for Multi-UM case

Comment by Daniel Lee (Inactive) [ 2016-05-31 ]

Build tested:

mscadmin> getsoft
getsoftwareinfo Tue May 31 18:45:33 2016

Name : mariadb-columnstore-platform Relocations: (not relocatable)
Version : 1.0 Vendor: MariaDB Corporation Ab
Release : 0 Build Date: Fri 27 May 2016 04:07:53 PM EDT
Install Date: Tue 31 May 2016 06:33:12 PM EDT Build Host: srvbuilder
Group : Applications Source RPM: mariadb-columnstore-1.0-0.src.rpm

There is an issue with multi UM/PM combo configuration installation and bug MCOL-94 has been opened for it. It needs to be fixed before this bug can be tested again.

Comment by Dipti Joshi (Inactive) [ 2016-06-01 ]

dleeyhNow that MCOL-94 is in QA review assigned to you - can this be tested again now ?

Comment by Daniel Lee (Inactive) [ 2016-06-02 ]

Build verified:

mscadmin> getsoft
getsoftwareinfo Thu Jun 2 15:19:20 2016

Name : mariadb-columnstore-platform Relocations: (not relocatable)
Version : 1.0 Vendor: MariaDB Corporation Ab
Release : 0 Build Date: Thu 02 Jun 2016 12:12:01 PM EDT
Install Date: Thu 02 Jun 2016 03:09:33 PM EDT Build Host: srvbuilder
Group : Applications Source RPM: mariadb-columnstore-1.0-0.src.rpm

binlog_format=row
Installed 2-node UMPM combo stack. Tested DDL and DML statements and verified the schemas are in sync.

Generated at Thu Feb 08 02:17:51 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.