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

        Issue Links

          Activity

            The test will be skipped in Jenkins FreeBSD builds of 10.6.

            elenst Elena Stepanova added a comment - The test will be skipped in Jenkins FreeBSD builds of 10.6.

            more logs can be found as attachments to MENT-1717

            tturenko Timofey Turenko added a comment - more logs can be found as attachments to MENT-1717
            tturenko Timofey Turenko added a comment - syslog (2).tar.gz mtr (2).log logs (2).tar.gz logs from 23.07.0 added

            logs from CS 11.1.1 added

            mtr.log syslog.tar.gz logs.tar.gz

            tturenko Timofey Turenko added a comment - logs from CS 11.1.1 added mtr.log syslog.tar.gz logs.tar.gz

            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.