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

galera.galera_transaction_replay: Test failure: mysqltest: Result length mismatch

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.4.3
    • N/A
    • Galera, Tests
    • OS: CentOS Linux release 7.6.1810 (Core).

    Description

      MariaDB Server: 10.4.3-MariaDB-debug built from sources, branch=10.4, commit: c568e25379600db8af4bd39df4761ba0fbc1a14e.
      Galera4 lib 26.4.0(r4477): debug built from sources, commit: 9bd47835d0fcdcf2f041da39dbe5b98ff738ff10.

      Run:

      ./mtr --suite galera --force --big-test --max-test-fail=0
      

      stdout.log: (attached 190227_stdout_laptop.log)

      galera.galera_transaction_replay 'innodb' [ fail ]
       
      --- /home/stepan/galera/git/10.4/server/mysql-test/suite/galera/r/galera_transaction_replay.result	2019-01-23 13:58:38.940427700 +0200
      +++ /home/stepan/galera/git/10.4/server/mysql-test/suite/galera/r/galera_transaction_replay.reject	2019-02-27 14:18:21.129113700 +0200
      @@ -24,11 +24,37 @@
       COMMIT;
       connection node_1a;
       SET SESSION wsrep_on = 0;
      +Timeout in wait_condition.inc for SELECT 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_debug_sync_waiters' AND VARIABLE_VALUE = 'apply_monitor_slave_enter_sync commit_monitor_master_enter_sync'
      +Id	User	Host	db	Command	Time	State	Info	Progress
      +1	system user		NULL	Sleep	922	wsrep aborter idle	NULL	0.000
      +3	system user		NULL	Sleep	12	After apply log event	NULL	0.000
      +2	system user		NULL	Sleep	922	Waiting on cond	NULL	0.000
      +6	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000
      +5	system user		NULL	Daemon	NULL	InnoDB purge coordinator	NULL	0.000
      +7	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000
      +4	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000
      +8	system user		NULL	Daemon	NULL	InnoDB shutdown handler	NULL	0.000
      +784	root	localhost	test	Sleep	12		NULL	0.000
      +785	root	localhost:32956	test	Query	10	Init	COMMIT	0.000
      +786	root	localhost:32958	test	Query	0	Init	show full processlist	0.000
       SET SESSION wsrep_on = 1;
       SET GLOBAL wsrep_provider_options = 'dbug=';
       SET GLOBAL wsrep_provider_options = 'dbug=d,abort_trx_end';
       SET GLOBAL wsrep_provider_options = 'signal=apply_monitor_slave_enter_sync';
       SET SESSION wsrep_on = 0;
      +Timeout in wait_condition.inc for SELECT 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_debug_sync_waiters' AND VARIABLE_VALUE = 'abort_trx_end commit_monitor_master_enter_sync'
      +Id	User	Host	db	Command	Time	State	Info	Progress
      +1	system user		NULL	Sleep	932	wsrep aborter idle	NULL	0.000
      +3	system user		NULL	Sleep	10	Update_rows_log_event::find_row(1228)	UPDATE t1 SET f2 = 'c' WHERE f1 = 2	0.000
      +2	system user		NULL	Sleep	932	Waiting on cond	NULL	0.000
      +6	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000
      +5	system user		NULL	Daemon	NULL	InnoDB purge coordinator	NULL	0.000
      +7	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000
      +4	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000
      +8	system user		NULL	Daemon	NULL	InnoDB shutdown handler	NULL	0.000
      +784	root	localhost	test	Sleep	22		NULL	0.000
      +785	root	localhost:32956		Busy	20	Init	NULL	0.000
      +786	root	localhost:32958	test	Query	0	Init	show full processlist	0.000
       SET SESSION wsrep_on = 1;
       SET GLOBAL wsrep_provider_options = 'dbug=';
       SET GLOBAL wsrep_provider_options = 'signal=abort_trx_end';
       
      mysqltest: Result length mismatch
      

      See also attached 190227_galera.galera_transaction_replay-innodb.zip.

      Note: This test is failed sporadically.

      Attachments

        Issue Links

          Activity

            This failure is not reproduced on buildbot. And on my machines the last failure was on 26.03.2019, but only being run with the suite, not on standalone running.

            stepan.patryshev Stepan Patryshev (Inactive) added a comment - This failure is not reproduced on buildbot. And on my machines the last failure was on 26.03.2019, but only being run with the suite, not on standalone running.

            Can't repeat locally or in buildbot.

            jplindst Jan Lindström (Inactive) added a comment - Can't repeat locally or in buildbot.

            People

              jplindst Jan Lindström (Inactive)
              stepan.patryshev Stepan Patryshev (Inactive)
              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.