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

galera.mariadb_tzinfo_to_sql fails on FreeBSD with wrong result

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

        Issue Links

          Activity

            elenst Elena Stepanova created issue -
            tturenko Timofey Turenko made changes -
            Field Original Value New Value
            Affects Version/s 10.6.11-6 [ 28428 ]
            janlindstrom Jan Lindström made changes -
            Assignee Jan Lindström [ jplindst ] Julius Goryavsky [ sysprg ]
            tturenko Timofey Turenko made changes -
            Attachment syslog (2).tar.gz [ 71446 ]
            Attachment mtr (2).log [ 71447 ]
            Attachment logs (2).tar.gz [ 71448 ]
            tturenko Timofey Turenko made changes -
            Attachment mtr.log [ 71529 ]
            Attachment syslog.tar.gz [ 71530 ]
            Attachment logs.tar.gz [ 71531 ]
            tturenko Timofey Turenko made changes -
            Component/s Galera [ 10124 ]
            Component/s Platform FreeBSD [ 10139 ]
            Component/s Tests [ 10800 ]
            Component/s Galera [ 14918 ]
            Component/s Platform FreeBSD [ 18806 ]
            Component/s Tests [ 14999 ]
            Fix Version/s 10.6 [ 24028 ]
            Fix Version/s 10.6 [ 24027 ]
            Key MENT-1523 MDEV-31900
            Affects Version/s 11.1.1 [ 28704 ]
            Affects Version/s 10.6 [ 24028 ]
            Affects Version/s 10.6 [ 24027 ]
            Affects Version/s 10.6.11-6 [ 28428 ]
            Project MariaDB Enterprise [ 11500 ] MariaDB Server [ 10000 ]
            tturenko Timofey Turenko made changes -
            Environment 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
            danblack Daniel Black made changes -

            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.