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

galera.mariadb_tzinfo_to_sql fails on FreeBSD with wrong result

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 11.1.1, 10.6
    • 10.6
    • Galera, Platform FreeBSD, Tests
    • None
    • debian buster aarch64 debian buster amd64 rhel 7 amd64 rhel 8 aarch64 rhel 8 amd64 rocky 9 aarch64 rocky 9 amd64 sles 12 amd64 sles 15 amd64 ubuntu focal amd64 ubuntu jammy aarch64

    Description

      https://es-jenkins.mariadb.net/job/Test-Package//42995/artifact/test-MTR-galera.log/*view*

      10.6-enterprise 053503c

      galera.mariadb_tzinfo_to_sql 'innodb'    w3 [ fail ]
              Test ended at 2022-05-28 23:52:19
       
      CURRENT_TEST: galera.mariadb_tzinfo_to_sql
      --- /tmp/workspace/Test-Package/mysql-test/suite/galera/r/mariadb_tzinfo_to_sql.result	2022-05-28 23:32:08.000000000 +0000
      +++ /tmp/workspace/Test-Package/mysql-test/suite/galera/r/mariadb_tzinfo_to_sql.reject	2022-05-28 23:52:18.919881000 +0000
      @@ -138,19 +138,21 @@
       connection node_1;
       Warnings:
       Warning	1478	Table storage engine 'MyISAM' does not support the create option 'TRANSACTIONAL=1'
      +Warnings:
      +Warning	1478	Table storage engine 'MyISAM' does not support the create option 'TRANSACTIONAL=1'
       'binlog advanced as expected'
       SELECT @wsrep_is_on,  @wsrep_cannot_replicate_tz, @save_wsrep_on, @save_sql_log_bin, @@WSREP_ON, @@SQL_LOG_BIN;
       @wsrep_is_on	@wsrep_cannot_replicate_tz	@save_wsrep_on	@save_sql_log_bin	@@WSREP_ON	@@SQL_LOG_BIN
      -1	0	1	1	1	1
      +1	1	1	1	1	1
       SELECT g.VARIABLE_NAME, g.VARIABLE_VALUE - b.VARIABLE_VALUE AS diff
       FROM information_schema.global_status g
       JOIN baseline b USING (VARIABLE_NAME)
       ORDER BY g.VARIABLE_NAME;
       VARIABLE_NAME	diff
      -COM_ALTER_TABLE	2
      -COM_BEGIN	0
      +COM_ALTER_TABLE	8
      +COM_BEGIN	1
       COM_INSERT	6
      -COM_LOCK_TABLES	1
      +COM_LOCK_TABLES	0
       COM_TRUNCATE	4
       SELECT COUNT(*) FROM time_zone;
       COUNT(*)
      @@ -176,13 +178,13 @@
       2
       SELECT COUNT(*) FROM time_zone_name;
       COUNT(*)
      -0
      +2
       SELECT COUNT(*) FROM time_zone_transition;
       COUNT(*)
       0
       SELECT COUNT(*) FROM time_zone_transition_type;
       COUNT(*)
      -0
      +2
       SELECT COUNT(*) FROM time_zone_leap_second;
       COUNT(*)
       0
       
      mysqltest: Result length mismatch
      

      The test doesn't fail on CS when it's built from ports, but it is an essentially different build, so it's not a fair comparison.

      Attachments

        1. test-MTR-galera.log
          97 kB
        2. syslog (2).tar.gz
          25 kB
        3. syslog.tar.gz
          19 kB
        4. mtr-vardir.tar.gz
          1.40 MB
        5. mtr (2).log
          89 kB
        6. mtr.log
          45 kB
        7. logs (2).tar.gz
          9.95 MB
        8. logs.tar.gz
          9.53 MB

        Issue Links

          Activity

            People

              sysprg Julius Goryavsky
              elenst Elena Stepanova
              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.