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

galera.galera_gcs_fc_limit fails in buildbot with timeout or Interrupted system call

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.1(EOL), 10.2(EOL)
    • N/A
    • Galera, Tests
    • None

    Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-deb-jessie-amd64/builds/2791

      galera.galera_gcs_fc_limit 'innodb_plugin' w1 [ fail ]  timeout after 900 seconds
              Test ended at 2017-09-19 10:26:05
       
      Test case timeout after 900 seconds
       
      == /dev/shm/var/1/log/galera_gcs_fc_limit.log == 
      CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
      INSERT INTO t1 VALUES (1);
      SELECT COUNT(*) = 1 FROM t1;
      COUNT(*) = 1
      1
      SET GLOBAL wsrep_provider_options = 'gcs.fc_limit=1';
      LOCK TABLE t1 WRITE;
      INSERT INTO t1 VALUES (2);
      INSERT INTO t1 VALUES (3);
      INSERT INTO t1 VALUES (4);
       
       == /dev/shm/var/1/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 '/dev/shm/var/tmp/1/mysqld.1.sock' (111 "Connection refused")
       
       == /dev/shm/var/1/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 '/dev/shm/var/tmp/1/mysqld.2.sock' (111 "Connection refused")
      

      Alternative failure:
      http://buildbot.askmonty.org/buildbot/builders/kvm-deb-stretch-x86/builds/1424/steps/mtr/logs/stdio

      galera.galera_gcs_fc_limit 'xtradb'      w2 [ fail ]  Found warnings/errors in server log file!
              Test ended at 2017-10-25 03:05:05
      line
      2017-10-25  3:05:01 2954881856 [Warning] WSREP: Failed to report last committed 1666, -4 (Interrupted system call)
      ^ Found warnings in /dev/shm/var/2/log/mysqld.1.err
      ok
      

      Attachments

        Issue Links

          Activity

            alice Alice Sherepa added a comment -

            failed in 10.2 http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos6-x86/builds/5878/steps/mtr/logs/stdio

            galera.galera_gcs_fc_limit 'innodb'      w1 [ fail ]
                    Test ended at 2017-11-07 23:43:34
             
            CURRENT_TEST: galera.galera_gcs_fc_limit
            --- /usr/share/mysql-test/suite/galera/r/galera_gcs_fc_limit.result	2017-11-07 23:06:45.000000000 +0200
            +++ /dev/shm/var/1/log/galera_gcs_fc_limit.reject	2017-11-07 23:43:33.873051981 +0200
            @@ -12,6 +12,18 @@
             INSERT INTO t1 VALUES (4);
             INSERT INTO t1 VALUES (5);
             connection node_1a;
            +Timeout in wait_condition.inc for SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE = 'query end' AND INFO = 'INSERT INTO t1 VALUES (5)';
            +Id	User	Host	db	Command	Time	State	Info	Progress
            +1	system user		NULL	Sleep	45	committed 1945	NULL	0.000
            +2	system user		NULL	Sleep	211	wsrep aborter idle	NULL	0.000
            +3	system user		NULL	Daemon	NULL	InnoDB purge coordinator	NULL	0.000
            +4	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000
            +5	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000
            +6	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000
            +7	system user		NULL	Daemon	NULL	InnoDB shutdown handler	NULL	0.000
            +299	root	localhost	test	Sleep	43		NULL	0.000
            +300	root	localhost:36908	test	Sleep	33		NULL	0.000
            +301	root	localhost:37050	test	Query	0	init	show full processlist	0.000
             connection node_2;
             UNLOCK TABLES;
             connection node_1;
             
            mysqltest: Result length mismatch
            

            alice Alice Sherepa added a comment - failed in 10.2 http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos6-x86/builds/5878/steps/mtr/logs/stdio galera.galera_gcs_fc_limit 'innodb' w1 [ fail ] Test ended at 2017-11-07 23:43:34   CURRENT_TEST: galera.galera_gcs_fc_limit --- /usr/share/mysql-test/suite/galera/r/galera_gcs_fc_limit.result 2017-11-07 23:06:45.000000000 +0200 +++ /dev/shm/var/1/log/galera_gcs_fc_limit.reject 2017-11-07 23:43:33.873051981 +0200 @@ -12,6 +12,18 @@ INSERT INTO t1 VALUES (4); INSERT INTO t1 VALUES (5); connection node_1a; +Timeout in wait_condition.inc for SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE = 'query end' AND INFO = 'INSERT INTO t1 VALUES (5)'; +Id User Host db Command Time State Info Progress +1 system user NULL Sleep 45 committed 1945 NULL 0.000 +2 system user NULL Sleep 211 wsrep aborter idle NULL 0.000 +3 system user NULL Daemon NULL InnoDB purge coordinator NULL 0.000 +4 system user NULL Daemon NULL InnoDB purge worker NULL 0.000 +5 system user NULL Daemon NULL InnoDB purge worker NULL 0.000 +6 system user NULL Daemon NULL InnoDB purge worker NULL 0.000 +7 system user NULL Daemon NULL InnoDB shutdown handler NULL 0.000 +299 root localhost test Sleep 43 NULL 0.000 +300 root localhost:36908 test Sleep 33 NULL 0.000 +301 root localhost:37050 test Query 0 init show full processlist 0.000 connection node_2; UNLOCK TABLES; connection node_1;   mysqltest: Result length mismatch

            People

              jplindst Jan Lindström (Inactive)
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.