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

hander socket writes do not result in binary log entries

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.5, 10.11.7
    • 10.5, 10.11
    • Replication
    • None

    Description

      Using test case from MDEV-10013

      --plugin-maturity=beta --log-bin --plugin_load_add=handlersocket --handlersocket_port=9998 --handlersocket_port_wr=9999
      

      compiled from source in MDEV-10013 as attached

      $ ./mdev10013
      Successfully connected to the server
      open_index operation successful,  &{0xc00007a020 1 PRIMARY test t1 [i] 0  0 0 0 0  0 { false}  [] [] []}
      

      $ client/mariadb-binlog  /tmp/build-mariadb-server-10.5-datadir/bark-bin.000001 
      /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
      /*!40019 SET @@session.max_insert_delayed_threads=0*/;
      /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
      DELIMITER /*!*/;
      # at 4
      #240423  8:52:57 server id 1  end_log_pos 256 CRC32 0xcf7d97d9 	Start: binlog v 4, server v 10.5.25-MariaDB-log created 240423  8:52:57 at startup
      ROLLBACK/*!*/;
      BINLOG '
      SeomZg8BAAAA/AAAAAABAAAAAAQAMTAuNS4yNS1NYXJpYURCLWxvZwAAAAAAAAAAAAAAAAAAAAAA
      AAAAAAAAAAAAAAAAAABJ6iZmEzgNAAgAEgAEBAQEEgAA5AAEGggAAAAICAgCAAAACgoKAAAAAAAA
      AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
      AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
      AAAAAAAAAAAEEwQADQgICAoKCgHZl33P
      '/*!*/;
      # at 256
      #240423  8:52:57 server id 1  end_log_pos 285 CRC32 0x9dbe4c76 	Gtid list []
      # at 285
      #240423  8:52:57 server id 1  end_log_pos 327 CRC32 0x5b9e3247 	Binlog checkpoint bark-bin.000001
      # at 327
      #240423  8:53:21 server id 1  end_log_pos 369 CRC32 0xec9d63b6 	GTID 0-1-1 ddl
      /*!100101 SET @@session.skip_parallel_replication=0*//*!*/;
      /*!100001 SET @@session.gtid_domain_id=0*//*!*/;
      /*!100001 SET @@session.server_id=1*//*!*/;
      /*!100001 SET @@session.gtid_seq_no=1*//*!*/;
      # at 369
      #240423  8:53:21 server id 1  end_log_pos 541 CRC32 0x057d538e 	Query	thread_id=21	exec_time=0	error_code=0
      use `test`/*!*/;
      SET TIMESTAMP=1713826401/*!*/;
      SET @@session.pseudo_thread_id=21/*!*/;
      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=0/*!*/;
      SET @@session.sql_mode=1411383296/*!*/;
      SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
      /*!\C utf8 *//*!*/;
      SET @@session.character_set_client=utf8,@@session.collation_connection=33,@@session.collation_server=8/*!*/;
      SET @@session.lc_time_names=0/*!*/;
      SET @@session.collation_database=DEFAULT/*!*/;
      CREATE TABLE `t1` (    `i` int(11) NOT NULL,    PRIMARY KEY (`i`)  ) ENGINE=InnoDB DEFAULT CHARSET=latin1
      /*!*/;
      # at 541
      #240423  8:56:38 server id 1  end_log_pos 564 CRC32 0x9a4b8f03 	Stop
      DELIMITER ;
      # End of log file
      ROLLBACK /* added by mysqlbinlog */;
      /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
      /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              danblack Daniel Black
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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