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

Sporadic buildbot failures in rpl.rpl_semi_sync_uninstall_plugin, 2013: 'Lost connection to MySQL server

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Fix
    • 5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL)
    • N/A
    • Tests

    Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-deb-trusty-amd64/builds/606/steps/test_4/logs/stdio

      CURRENT_TEST: rpl.rpl_semi_sync_uninstall_plugin
      --- /usr/share/mysql/mysql-test/suite/rpl/r/rpl_semi_sync_uninstall_plugin.result	2014-11-19 07:12:09.000000000 +0000
      +++ /run/shm/var/4/log/rpl_semi_sync_uninstall_plugin.reject	2014-11-19 15:00:33.507204650 +0000
      @@ -20,28 +20,22 @@
       rpl_semi_sync_slave	DELETED
       [connection master]
       UNINSTALL PLUGIN rpl_semi_sync_master;
      -Warnings:
      -Warning	1620	Plugin is busy and will be uninstalled on shutdown
       select plugin_name,plugin_status from information_schema.plugins where plugin_name like 'rpl_%';
       plugin_name	plugin_status
      -rpl_semi_sync_master	DELETED
       CREATE TABLE t1(i int);
       INSERT INTO t1 values (2);
       DROP TABLE t1;
       [connection slave]
       show status like "Rpl_semi_sync_slave_status";
       Variable_name	Value
      -Rpl_semi_sync_slave_status	ON
      +Rpl_semi_sync_slave_status	OFF
       [connection master]
       show status like "Rpl_semi_sync_master_status";
       Variable_name	Value
      -Rpl_semi_sync_master_status	ON
       show status like "Rpl_semi_sync_master_clients";
       Variable_name	Value
      -Rpl_semi_sync_master_clients	1
       select plugin_name,plugin_status from information_schema.plugins where plugin_name like 'rpl_%';
       plugin_name	plugin_status
      -rpl_semi_sync_master	DELETED
       [connection slave]
       include/stop_slave.inc
       select plugin_name,plugin_status from information_schema.plugins where plugin_name like 'rpl_%';
       
      mysqltest: Result length mismatch
       
       - saving '/run/shm/var/4/log/rpl.rpl_semi_sync_uninstall_plugin-stmt/' to '/run/shm/var/log/rpl.rpl_semi_sync_uninstall_plugin-stmt/'
       
      Retrying test rpl.rpl_semi_sync_uninstall_plugin, attempt(2/3)...
       
      worker[4] > Restart  - not started
      worker[4] > Restart  - not started
      ***Warnings generated in error logs during shutdown after running tests: rpl.rpl_semi_sync_uninstall_plugin
       
      141119 15:00:33 [Warning] Master server does not support semi-sync, fallback to asynchronous replication
       
      worker[4] > Restart [mysqld.1 - pid: 19176, winpid: 19176] - running with different options '--binlog-format=statement --log-bin=master-bin --log-bin=master-bin' != '--log-bin=master-bin --binlog-format=statement --log-bin=master-bin'
      rpl.rpl_semi_sync_uninstall_plugin 'stmt' w4 [ retry-pass ]    130
      

      Also observed on 10.0, 10.1

      Another kind – timeout:
      http://buildbot.askmonty.org/buildbot/builders/labrador/builds/4438/steps/test/logs/stdio

      rpl.rpl_semi_sync_uninstall_plugin 'stmt' [ fail ]  timeout after 900 seconds
              Test ended at 2015-01-06 17:51:50
       
      Test case timeout after 900 seconds
       
      == /private/var/lib/buildslave/maria-slave/labrador/build/mysql-test/var/log/rpl_semi_sync_uninstall_plugin.log == 
      UNINSTALL PLUGIN rpl_semi_sync_master;
      CREATE TABLE t1(i int);
      INSERT INTO t1 values (1);
      DROP TABLE t1;
      [connection slave]
      include/install_semisync.inc
      [connection slave]
      UNINSTALL PLUGIN rpl_semi_sync_slave;
      Warnings:
      Warning	1620	Plugin is busy and will be uninstalled on shutdown
      select plugin_name,plugin_status from information_schema.plugins where plugin_name like 'rpl_%';
      plugin_name	plugin_status
      rpl_semi_sync_slave	DELETED
      [connection master]
      UNINSTALL PLUGIN rpl_semi_sync_master;
      select plugin_name,plugin_status from information_schema.plugins where plugin_name like 'rpl_%';
      plugin_name	plugin_status
      CREATE TABLE t1(i int);
      INSERT INTO t1 values (2);
      DROP TABLE t1;
       
       == /private/var/lib/buildslave/maria-slave/labrador/build/mysql-test/var/tmp/analyze-timeout-mysqld.1.err ==
      mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/private/var/lib/buildslave/maria-slave/labrador/build/mysql-test/var/tmp/mysqld.1.sock' (61 "Connection refused")
       
       == /private/var/lib/buildslave/maria-slave/labrador/build/mysql-test/var/tmp/analyze-timeout-mysqld.2.err ==
      mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/private/var/lib/buildslave/maria-slave/labrador/build/mysql-test/var/tmp/mysqld.2.sock' (61 "Connection refused")
      

      Attachments

        Issue Links

          Activity

            People

              Elkin Andrei Elkin
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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