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

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

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Not a Bug
    • Affects Version/s: 10.4.3
    • Fix Version/s: N/A
    • Component/s: Galera, Tests
    • Labels:
    • Environment:
      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

              People

              Assignee:
              jplindst Jan Lindström
              Reporter:
              stepan.patryshev Stepan Patryshev
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: