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

main.log_tables fails sporadically in buildbot #2

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 10.1
    • Fix Version/s: 10.1.4
    • Component/s: Tests
    • Labels:
      None

      Description

      http://buildbot.askmonty.org/buildbot/builders/p8-rhel71-bintar/builds/229/steps/test/logs/stdio

      main.log_tables                          w2 [ fail ]
              Test ended at 2015-04-04 04:37:52
      
      CURRENT_TEST: main.log_tables
      mysqltest: At line 833: query 'call `db_17876.archiveSlowLog`()' failed: 1136: Column count doesn't match value count at row 1
      
      The result from queries just before the failure was:
      < snip >
      INSERT INTO
      `db_17876.general_log_data`
                  VALUES(event_time, user_host, thread_id, server_id,
      command_type, argument);
      END;
      END IF;
      END;
      UNTIL done END REPEAT;
      CLOSE cur1;
      TRUNCATE mysql.general_log;
      END //
      SET GLOBAL general_log = ON;
      SET GLOBAL slow_query_log = ON;
      select "put something into general_log";
      put something into general_log
      put something into general_log
      select "... and something more ...";
      ... and something more ...
      ... and something more ...
      call `db_17876.archiveSlowLog`();
      
      More results from queries before failure can be found in /home/buildbot/maria-slave/power8-vlp06-bintar/build/mysql-test/var/2/log/log_tables.log
      

      Same problem as in MDEV-7431, but 10.1 flavor: mysql.slow_log has one more column there.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

              Show
              elenst Elena Stepanova added a comment - Pushed into 10.1: https://github.com/MariaDB/server/commit/eb83e9405f9f537ff49f6d325942133460aa510c

                People

                • Assignee:
                  elenst Elena Stepanova
                  Reporter:
                  elenst Elena Stepanova
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - 0 minutes
                    0m
                    Logged:
                    Time Spent - 20 minutes
                    20m