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

Inconsistent MariaDB error codes 0, 1045, 2003 when using RESET MASTER and init_connect

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.4(EOL), 10.5, 10.6, 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL), 11.3(EOL), 11.4
    • 10.5, 10.6, 10.11
    • Replication

    Description

      # Requires standard m/s setup, use CLI on master to replay the SQL
      RESET MASTER;
      SET GLOBAL init_connect="foo";
      CREATE TABLE t1 (c1 INT, c2 BINARY (25) NOT NULL, c3 SMALLINT(4) NULL, c4 BINARY (15) NOT NULL PRIMARY KEY, c5 SMALLINT NOT NULL UNIQUE KEY,c6 DEC(10,8) NOT NULL DEFAULT 3.141592) ENGINE=MyISAM;
      CREATE TABLE t2 (a INT, b SMALLINT NOT NULL, c CHAR(12) NOT NULL, d VARCHAR(64) NOT NULL, e VARCHAR(89), f VARCHAR(5), g LONGBLOB NOT NULL, h BLOB, id BIGINT NOT NULL, KEY(b), KEY(e), PRIMARY KEY(id)) ENGINE=MyISAM;
      

      Leads to (various examples, see end-of-line error codes):

      11.3.2 63fb478f88e0061d149f5cdd3c4d21d4a35c7bd9 (Debug, Slave)

      2024-02-02 11:37:36 5 [ERROR] Slave I/O: error reconnecting to master 'repl_user@127.0.0.1:11699' - retry-time: 60  maximum-retries: 100000  message: , Internal MariaDB error code: 0
      

      10.4.33 1b747ffd05dd524f8d43b35a2b583dc4c00d767b (Optimized, Slave)

      2024-02-02 11:37:36 10 [ERROR] Slave I/O: error reconnecting to master 'repl_user@127.0.0.1:10826' - retry-time: 60  maximum-retries: 86400  message: Can't connect to MySQL server on '127.0.0.1' (111 "Connection refused"), Internal MariaDB error code: 2003
      

      10.6.17 9f40f02a8dda7f2becdc6e752557559e7835546d (Optimized)

      2024-02-02 11:36:00 5 [ERROR] Slave I/O: error connecting to master 'repl_user@127.0.0.1:12014' - retry-time: 60  maximum-retries: 100000  message: Access denied for user 'repl_user'@'localhost' (using password: YES), Internal MariaDB error code: 1045
      

      This significantly complicates replication testing automation.

      Attachments

        Issue Links

          Activity

            People

              Elkin Andrei Elkin
              Roel Roel Van de Paar
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.