Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-40236

ERROR when reading GEOMETRY datatype

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None
    • Replication
    • 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

          Activity

            People

              ParadoxV5 Jimmy Hú
              Deepthi ES Deepthi Eranti Sreenivas
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Time Spent - 2h 5m Remaining Estimate - 3.5h
                  3.5h
                  Logged:
                  Time Spent - 2h 5m Remaining Estimate - 3.5h
                  2h 5m

                  Git Integration

                    Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.