Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-3976

Errors in MTR tests main.variables-big, main.information_schema-big, innodb.innodb_bug14676111

    Details

      Description

      name : main.variables-big
      comment : "
      Server [mysqld.1 - pid: 2844
      result : fail
        output : CURRENT_TEST: main.variables-big
      --- /github/inikep-ps/mysql-test/r/variables-big.result    2018-04-27 16:04:29.989791353 +0300
      +++ /github/inikep-ps/mysql-test/r/variables-big.reject    2018-04-27 19:47:27.430521028 +0300
      @@ -1,22 +1,22 @@
       SET @def_var= @@session.transaction_prealloc_size;
       SET SESSION transaction_prealloc_size=1024*1024*1024*1;
       SHOW PROCESSLIST;
      -Id    User    Host    db    Command    Time    State    Info
      -<Id>    root    <Host>    test    Query    <Time>    NULL    SHOW PROCESSLIST
      +Id    User    Host    db    Command    Time    State    Info    Rows_sent    Rows_examined    Rows_read
      +<Id>    root    <Host>    test    Query    <Time>    NULL    SHOW PROCESSLIST    0    0    0
      
      name : main.information_schema-big
      start_time : 2018-04-27T16:47:24Z
        output : CURRENT_TEST: main.information_schema-big
      --- /github/inikep-ps/mysql-test/r/information_schema-big.result    2018-04-27 16:04:29.949792210 +0300
      +++ /github/inikep-ps/mysql-test/r/information_schema-big.reject    2018-04-27 19:47:33.218399092 +0300
      @@ -20,14 +20,17 @@
       AND t.table_name NOT LIKE 'innodb%';
       table_name    column_name
       CHARACTER_SETS    CHARACTER_SET_NAME
      +CLIENT_STATISTICS    CLIENT
       COLLATIONS    COLLATION_NAME
       COLLATION_CHARACTER_SET_APPLICABILITY    COLLATION_NAME
       COLUMNS    TABLE_SCHEMA
       COLUMN_PRIVILEGES    TABLE_SCHEMA
      +INDEX_STATISTICS    TABLE_SCHEMA
       ENGINES    ENGINE
       EVENTS    EVENT_SCHEMA
       FILES    TABLE_SCHEMA
       GLOBAL_STATUS    VARIABLE_NAME
      +GLOBAL_TEMPORARY_TABLES    TABLE_SCHEMA
       GLOBAL_VARIABLES    VARIABLE_NAME
       KEY_COLUMN_USAGE    CONSTRAINT_SCHEMA
       PARAMETERS    SPECIFIC_SCHEMA
      @@ -37,6 +40,7 @@
       PROFILING    QUERY_ID
       REFERENTIAL_CONSTRAINTS    CONSTRAINT_SCHEMA
       ROUTINES    ROUTINE_SCHEMA
      +QUERY_RESPONSE_TIME    time
       SCHEMATA    SCHEMA_NAME
       SCHEMA_PRIVILEGES    TABLE_SCHEMA
       SESSION_STATUS    VARIABLE_NAME
      @@ -46,9 +50,14 @@
       TABLESPACES    TABLESPACE_NAME
       TABLE_CONSTRAINTS    CONSTRAINT_SCHEMA
       TABLE_PRIVILEGES    TABLE_SCHEMA
      +TABLE_STATISTICS    TABLE_SCHEMA
      +TEMPORARY_TABLES    TABLE_SCHEMA
      +THREAD_STATISTICS    THREAD_ID
       TRIGGERS    TRIGGER_SCHEMA
       USER_PRIVILEGES    GRANTEE
      +USER_STATISTICS    USER
       VIEWS    TABLE_SCHEMA
      +XTRADB_ADMIN_COMMAND    result_message
       SELECT t.table_name, c1.column_name
       FROM information_schema.tables t
       INNER JOIN
      
      CURRENT_TEST: innodb.innodb_bug14676111
      --- /github/inikep-ps/mysql-test/suite/innodb/r/innodb_bug14676111.result	2018-04-27 16:04:30.065789728 +0300
      +++ /github/inikep-ps/mysql-test/suite/innodb/r/innodb_bug14676111.reject	2018-04-30 12:24:11.646636539 +0300
      @@ -28,12 +28,14 @@
       5.0000
       set global innodb_limit_optimistic_insert_debug = 10000;
       delete from t1 where a=2;
      +Timeout in wait_condition.inc for SELECT VARIABLE_VALUE < 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS
      +WHERE VARIABLE_NAME = 'INNODB_PURGE_TRX_ID_AGE'
       analyze table t1;
       Table	Op	Msg_type	Msg_text
       test.t1	analyze	status	OK
       select DATA_LENGTH / 16384 from information_schema.TABLES where TABLE_SCHEMA = 'test' and TABLE_NAME = 't1';
       DATA_LENGTH / 16384
      -3.0000
      +5.0000
       insert into t1 values (2);
       delete from t1 where a=2;
       analyze table t1;
      @@ -41,13 +43,15 @@
       test.t1	analyze	status	OK
       select DATA_LENGTH / 16384 from information_schema.TABLES where TABLE_SCHEMA = 'test' and TABLE_NAME = 't1';
       DATA_LENGTH / 16384
      -2.0000
      +3.0000
       insert into t1 values (2);
       delete from t1 where a=2;
      +Timeout in wait_condition.inc for SELECT VARIABLE_VALUE < 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS
      +WHERE VARIABLE_NAME = 'INNODB_PURGE_TRX_ID_AGE'
       analyze table t1;
       Table	Op	Msg_type	Msg_text
       test.t1	analyze	status	OK
       select DATA_LENGTH / 16384 from information_schema.TABLES where TABLE_SCHEMA = 'test' and TABLE_NAME = 't1';
       DATA_LENGTH / 16384
      -1.0000
      +3.0000
       drop table t1;
      

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  przemyslaw.skibinski Przemyslaw Skibinski
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 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 - 4 hours
                    4h