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. mtr-vardir.tar.gz
          1.40 MB
        3. mtr (2).log
          89 kB
        4. syslog (2).tar.gz
          25 kB
        5. logs (2).tar.gz
          9.95 MB
        6. syslog.tar.gz
          19 kB
        7. mtr.log
          45 kB
        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.