Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
create table t1 (a int primary key, b geometry) engine=innodb; |
insert into t1 values (1, ST_GeomFromText('POINT(1 1)')); |
Generate binary log with above commands when binlog-format=ROW and read the file using mariadb-binlog.
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; |
/*!40019 SET @@session.max_delayed_threads=0*/; |
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; |
DELIMITER /*!*/; |
# at 4 |
#260702 11:48:22 server id 1 end_log_pos 257 CRC32 0xb30df587 Start: binlog v 4, server v 13.1.0-MariaDB-debug-log created 260702 11:48:22 at startup |
# Warning: this binlog is either in use or was not closed properly. |
ROLLBACK/*!*/; |
BINLOG ' |
rgJGag8BAAAA/QAAAAEBAAABAAQAMTMuMS4wLU1hcmlhREItZGVidWctbG9nAAAAAAAAAAAAAAAA
|
AAAAAAAAAAAAAAAAAACuAkZqEzgNAAgAEgAEBAQEEgAA5QAEGggAAAAICAgCAAAACgoKAAAAAAAA
|
CgoKAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
|
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
|
AAAAAAAAAAAEEwQADQgICAoKCgkBh/UNsw==
|
'/*!*/; |
# at 257 |
#260702 11:48:22 server id 1 end_log_pos 286 CRC32 0x272aeb0b Gtid list []
|
# at 286 |
#260702 11:48:22 server id 1 end_log_pos 330 CRC32 0xf7939a79 Binlog checkpoint master-bin.000001 |
# at 330 |
#260702 11:49:21 server id 1 end_log_pos 372 CRC32 0xdac95356 GTID 0-1-1 ddl thread_id=4
|
/*M!100101 SET @@session.skip_parallel_replication=0*//*!*/; |
/*M!100001 SET @@session.gtid_domain_id=0*//*!*/; |
/*M!100001 SET @@session.server_id=1*//*!*/; |
/*M!100001 SET @@session.gtid_seq_no=1*//*!*/; |
# at 372 |
#260702 11:49:21 server id 1 end_log_pos 514 CRC32 0x97ccc123 Query thread_id=4 exec_time=0 error_code=0 xid=6
|
use `test`/*!*/; |
SET TIMESTAMP=1782973161/*!*/; |
SET @@session.pseudo_thread_id=4/*!*/; |
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1, @@session.check_constraint_checks=1, @@session.sql_if_exists=0, @@session.explicit_defaults_for_timestamp=1, @@session.system_versioning_insert_history=0/*!*/; |
SET @@session.sql_mode=1411383296/*!*/; |
SET @@session.auto_increment_increment=10, @@session.auto_increment_offset=2/*!*/; |
/*!\C utf8mb4 *//*!*/; |
SET @@session.character_set_client=utf8mb4,@@session.collation_connection=2304,@@session.collation_server=2304/*!*/; |
SET @@session.lc_time_names=0/*!*/; |
SET @@session.collation_database=DEFAULT/*!*/; |
create table t1 (a int primary key, b geometry) engine=innodb |
/*!*/; |
# at 514 |
#260702 11:49:21 server id 1 end_log_pos 556 CRC32 0x733545cc GTID 0-1-2 trans thread_id=4
|
/*M!100001 SET @@session.gtid_seq_no=2*//*!*/; |
START TRANSACTION |
/*!*/; |
# at 556 |
# at 635 |
#260702 11:49:21 server id 1 end_log_pos 0 CRC32 0x27ae7ba3 Annotate_rows:
|
#Q> insert into t1 values (1, ST_GeomFromText('POINT(1 1)')) |
#260702 11:49:21 server id 1 end_log_pos 0 CRC32 0xcc8ae9c8 Table_map: `test`.`t1` mapped to number 18 |
# at 682 |
|
|
Error decoding row image while converting event for --flashback (could not determine field length): event=Write_rows_v1, column=1, column_type=255, metadata=4 |
#260702 11:49:21 server id 1 end_log_pos 0 CRC32 0x00e5aaae Write_rows: table id 18 flags: STMT_END_F |
|
|
BINLOG ' |
6QJGahMBAAAALwAAAAAAAAAAABIAAAAAAAEABHRlc3QAAnQxAAID/wEEAsjpisw=
|
6QJGahcBAAAAQwAAAAAAAAAAABIAAAAAAAEAAgP8AQAAABkAAAAAAAAAAQEAAAAAAAAAAADwPwAA
|
AAAAAPA/rqrlAA==
|
'/*!*/; |
# Number of rows: 1 |
# at 749 |
#260702 11:49:21 server id 1 end_log_pos 780 CRC32 0x73f494e4 Xid = 7
|
COMMIT/*!*/; |
DELIMITER ;
|
# End of log file |
ROLLBACK /* added by mysqlbinlog */; |
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; |
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; |
|
Flaskback error is seen even without --flashback option
Error is seen only in the git branch of MDEV-20749 fix - https://github.com/MariaDB/server/pull/4767
Attachments
Issue Links
- is caused by
-
MDEV-20749 Improve error reporting of mysqlbinlog when used with --flashback
-
- In Testing
-
-
MDEV-40511 mariadb-binlog does not count GEOMETRY rows correctly
-
- Open
-
- split to
-
MDEV-40511 mariadb-binlog does not count GEOMETRY rows correctly
-
- Open
-