[MDEV-13842] innodb.innodb-index failed in buildbot - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Blocker
Resolution: Fixed
Affects Version/s: 10.3(EOL)
Fix Version/s: 10.3.5
Component/s: Compiling, Storage Engine - InnoDB, Tests
Labels:
None

Description

http://buildbot.askmonty.org/buildbot/builders/kvm-bintar-centos5-x86/builds/7587/steps/test/logs/stdio

innodb.innodb-index 'innodb'             w2 [ fail ]

        Test ended at 2017-09-18 16:17:20

CURRENT_TEST: innodb.innodb-index

--- /usr/local/mariadb-10.3.2-linux-i686/mysql-test/suite/innodb/r/innodb-index.result	2017-09-18 14:09:46.000000000 +0200

+++ /usr/local/mariadb-10.3.2-linux-i686/mysql-test/suite/innodb/r/innodb-index.reject	2017-09-18 16:17:19.000000000 +0200

@@ -1198,6 +1198,8 @@

 SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE

 subsystem = 'ddl' and count_reset > 0;

 name	count_reset

+ddl_online_create_index	4294967296

+ddl_pending_alter_table	4294967296

 SET GLOBAL innodb_monitor_reset = module_ddl;

 drop table t1;

 create table t1(f1 int not null, f2 int not null,

@@ -1211,6 +1213,8 @@

 SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE

 subsystem = 'ddl' and count_reset > 0;

 name	count_reset

+ddl_online_create_index	4294967296

+ddl_pending_alter_table	4294967296

 SET GLOBAL innodb_monitor_reset = module_ddl;

 drop table t1;

 create table t480(a serial)engine=innodb;

@@ -1241,6 +1245,8 @@

 SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE

 subsystem = 'ddl' and count_reset > 0;

 name	count_reset

+ddl_online_create_index	4294967296

+ddl_pending_alter_table	4294967296

 SET GLOBAL innodb_monitor_reset = module_ddl;

 # Skip sort

 # Change PK from (f1,f2,f3,f4) to (f1,f2,added_columns)

@@ -1251,6 +1257,8 @@

 SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE

 subsystem = 'ddl' and count_reset > 0;

 name	count_reset

+ddl_online_create_index	4294967296

+ddl_pending_alter_table	4294967296

 SET GLOBAL innodb_monitor_reset = module_ddl;

 # Skip sort

 # Change PK from (f1,f2,f5,f6) to (f1,f2,f5)

@@ -1262,6 +1270,8 @@

 SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE

 subsystem = 'ddl' and count_reset > 0;

 name	count_reset

+ddl_online_create_index	4294967296

+ddl_pending_alter_table	4294967296

 SET GLOBAL innodb_monitor_reset = module_ddl;

 # Skip sort

 # Reusing the same PK

@@ -1271,6 +1281,8 @@

 SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE

 subsystem = 'ddl' and count_reset > 0;

 name	count_reset

+ddl_online_create_index	4294967296

+ddl_pending_alter_table	4294967296

 SET GLOBAL innodb_monitor_reset = module_ddl;

 # Skip sort

 # Reusing the same pk

@@ -1280,6 +1292,8 @@

 SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE

 subsystem = 'ddl' and count_reset > 0;

 name	count_reset

+ddl_online_create_index	4294967296

+ddl_pending_alter_table	4294967296

 SET GLOBAL innodb_monitor_reset = module_ddl;

 # Must sort

 # Change PK from (f1,f2,f5) to (f1,f5)

@@ -1291,6 +1305,8 @@

 SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE

 subsystem = 'ddl' and count_reset > 0;

 name	count_reset

+ddl_online_create_index	4294967296

+ddl_pending_alter_table	4294967296

 ddl_sort_file_alter_table	2

 SET GLOBAL innodb_monitor_reset = module_ddl;

 # Skip sort

@@ -1302,6 +1318,8 @@

 SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE

 subsystem = 'ddl' and count_reset > 0;

 name	count_reset

+ddl_online_create_index	4294967296

+ddl_pending_alter_table	4294967296

 SET GLOBAL innodb_monitor_reset = module_ddl;

 # Skip sort

 # Reusing the same pk

@@ -1312,6 +1330,8 @@

 SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE

 subsystem = 'ddl' and count_reset > 0;

 name	count_reset

+ddl_online_create_index	4294967296

+ddl_pending_alter_table	4294967296

 SET GLOBAL innodb_monitor_reset = module_ddl;

 # Skip sort

 # Change PK from (f1,f4,f2n) to (f1,f4,added_column,f2n)

@@ -1322,6 +1342,8 @@

 SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE

 subsystem = 'ddl' and count_reset > 0;

 name	count_reset

+ddl_online_create_index	4294967296

+ddl_pending_alter_table	4294967296

 ddl_sort_file_alter_table	2

 SET GLOBAL innodb_monitor_reset = module_ddl;

 # Skip sort

@@ -1332,6 +1354,8 @@

 SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE

 subsystem = 'ddl' and count_reset > 0;

 name	count_reset

+ddl_online_create_index	4294967296

+ddl_pending_alter_table	4294967296

 SET GLOBAL innodb_monitor_reset = module_ddl;

 # Skip sort

 # Reusing the same pk

@@ -1341,6 +1365,8 @@

 SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE

 subsystem = 'ddl' and count_reset > 0;

 name	count_reset

+ddl_online_create_index	4294967296

+ddl_pending_alter_table	4294967296

 SET GLOBAL innodb_monitor_reset = module_ddl;

 # Skip sort

 # Reusing the same pk

@@ -1350,6 +1376,8 @@

 SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE

 subsystem = 'ddl' and count_reset > 0;

 name	count_reset

+ddl_online_create_index	4294967296

+ddl_pending_alter_table	4294967296

 SET GLOBAL innodb_monitor_reset = module_ddl;

 # Skip sort

 # Optimize table

@@ -1361,6 +1389,8 @@

 SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE

 subsystem = 'ddl' and count_reset > 0;

 name	count_reset

+ddl_online_create_index	4294967296

+ddl_pending_alter_table	4294967296

 SET GLOBAL innodb_monitor_reset = module_ddl;

 # Sort files used for adding secondary index

 alter table t1 drop primary key, add primary key(f1,f5,f7), add index

@@ -1370,6 +1400,8 @@

 SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE

 subsystem = 'ddl' and count_reset > 0;

 name	count_reset

+ddl_online_create_index	4294967296

+ddl_pending_alter_table	4294967296

 SET GLOBAL innodb_monitor_reset = module_ddl;

 # No sort files used for dropping secondary index

 alter table t1 drop primary key, add primary key(f1,f5),drop index i;

@@ -1378,6 +1410,8 @@

 SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE

 subsystem = 'ddl' and count_reset > 0;

 name	count_reset

+ddl_online_create_index	4294967296

+ddl_pending_alter_table	4294967296

 SET GLOBAL innodb_monitor_reset = module_ddl;

 # Skip sort

 # Change PK(f1,f5) to (f1,added_columns) and drop f5

@@ -1388,6 +1422,8 @@

 SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE

 subsystem = 'ddl' and count_reset > 0;

 name	count_reset

+ddl_online_create_index	4294967296

+ddl_pending_alter_table	4294967296

 SET GLOBAL innodb_monitor_reset = module_ddl;

 # Must sort

 # Change PK(f1,f12) to (f1,existing_columns)

@@ -1397,6 +1433,8 @@

 SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE

 subsystem = 'ddl' and count_reset > 0;

 name	count_reset

+ddl_online_create_index	4294967296

+ddl_pending_alter_table	4294967296

 ddl_sort_file_alter_table	2

 SET GLOBAL innodb_monitor_reset = module_ddl;

 # Skip sort

@@ -1408,6 +1446,8 @@

 SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE

 subsystem = 'ddl' and count_reset > 0;

 name	count_reset

+ddl_online_create_index	4294967296

+ddl_pending_alter_table	4294967296

 SET GLOBAL innodb_monitor_reset = module_ddl;

 # Adding Secondary index alone.

 alter table t1 add key(f1);

@@ -1416,6 +1456,8 @@

 SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE

 subsystem = 'ddl' and count_reset > 0;

 name	count_reset

+ddl_online_create_index	4294967296

+ddl_pending_alter_table	4294967296

 SET GLOBAL innodb_monitor_reset = module_ddl;

 # Must sort

 # Change PK(f1,f3) to (existing_column,f1)

@@ -1425,6 +1467,8 @@

 SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE

 subsystem = 'ddl' and count_reset > 0;

 name	count_reset

+ddl_online_create_index	4294967296

+ddl_pending_alter_table	4294967296

 ddl_sort_file_alter_table	3

 SET GLOBAL innodb_monitor_reset = module_ddl;

 # Skip sort for PK.

@@ -1437,6 +1481,8 @@

 SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE

 subsystem = 'ddl' and count_reset > 0;

 name	count_reset

+ddl_online_create_index	4294967296

+ddl_pending_alter_table	4294967296

 SET GLOBAL innodb_monitor_reset = module_ddl;

 # Skip sort for PK.

 # Change PK(f5n,f6n,f4,f1) to

@@ -1449,6 +1495,8 @@

 SELECT name, count_reset FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE

 subsystem = 'ddl' and count_reset > 0;

 name	count_reset

+ddl_online_create_index	4294967296

+ddl_pending_alter_table	4294967296

 SET GLOBAL innodb_monitor_reset = module_ddl;

 SET GLOBAL innodb_monitor_disable = module_ddl;

 select count(*) from t1;

mysqltest: Result length mismatch

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

10.2.txt
2 kB
2018-02-07 10:19
10.3.txt
2 kB
2018-02-07 10:19

Issue Links

relates to

MDEV-13656 10.3 does not build on CentOS 5 x86 (old-glibc bintar cannot be built)

Closed

Activity

People

Assignee:: Sergei Golubchik

Reporter:: Alice Sherepa

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2017-09-19 07:32

Updated:: 2018-02-13 12:21

Resolved:: 2018-02-13 12:21

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.