Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.2(EOL)
-
None
Description
|
10.2 e44ca6cc9c300cbdf93c64110bd8cf2be8125379 |
innodb.temp_table_savepoint 'innodb' w4 [ fail ]
|
Test ended at 2018-05-07 11:22:28
|
|
|
CURRENT_TEST: innodb.temp_table_savepoint
|
--- /usr/share/mysql/mysql-test/suite/innodb/r/temp_table_savepoint.result 2018-05-07 08:45:39.000000000 -0400
|
+++ /run/shm/var/4/log/temp_table_savepoint.reject 2018-05-07 11:22:27.889709285 -0400
|
@@ -167,7 +167,7 @@
|
20
|
select count(*) from t2;
|
count(*)
|
-20
|
+21
|
select count(*) from t4;
|
count(*)
|
20
|
@@ -198,6 +198,7 @@
|
140
|
select c1 from t2;
|
c1
|
+4
|
11
|
12
|
13
|
|
|
mysqltest: Result length mismatch
|
Attachments
Issue Links
- duplicates
-
-
- Closed
-
Activity
For what it is worth, Valgrind did not report anything:
|
10.2 a4e7800701d0764fe4cbb85b81d7c7cb54677334 |
./mtr --valgrind innodb.temp_table_savepoint
|
…
|
innodb.temp_table_savepoint 'innodb' [ pass ] 262941
|
valgrind_report [ pass ]
|
|
10.3 21b12e33594f9f943d1c3678005f034858af2b03 |
innodb.temp_table_savepoint 'innodb' [ pass ] 242603
|
valgrind_report [ pass ]
|
I cannot repeat this locally.
I suspect that this failure depends on the preceding tests that were run since the latest restart. Here is a relevant except from the buildbot log file:
|
10.2 e44ca6cc9c300cbdf93c64110bd8cf2be8125379 |
worker[4] > Restart [mysqld.1 - pid: 29170, winpid: 29170] - running with different options '--innodb --innodb-cmpmem --innodb-cmp-per-index --innodb-trx --innodb-locks --innodb-metrics --innodb-buffer-pool-stats --innodb-buffer-page --innodb-buffer-page-lru --innodb-sys-columns --innodb-sys-fields --innodb-sys-foreign --innodb-sys-foreign-cols --innodb-sys-indexes --innodb-sys-tables --innodb-sys-virtual' != '--innodb --innodb-cmpmem --innodb-cmp-per-index --innodb-trx --innodb-locks --innodb-metrics --innodb-buffer-pool-stats --innodb-buffer-page --innodb-buffer-page-lru --innodb-sys-columns --innodb-sys-fields --innodb-sys-foreign --innodb-sys-foreign-cols --innodb-sys-indexes --innodb-sys-tables --innodb-sys-virtual'
|
funcs_1.innodb_bitdata 'innodb' w4 [ pass ] 2
|
funcs_1.innodb_cursors 'innodb' w4 [ pass ] 1
|
funcs_1.innodb_func_view 'innodb' w4 [ pass ] 698
|
funcs_1.innodb_storedproc_02 'innodb' w4 [ pass ] 245
|
funcs_1.innodb_storedproc_03 'innodb' w4 [ pass ] 133
|
funcs_1.innodb_storedproc_06 'innodb' w4 [ pass ] 192
|
funcs_1.innodb_storedproc_07 'innodb' w4 [ pass ] 87
|
funcs_1.innodb_storedproc_08 'innodb' w4 [ pass ] 74
|
funcs_1.innodb_storedproc_10 'innodb' w4 [ pass ] 93
|
funcs_1.innodb_trig_0102 'innodb' w4 [ pass ] 125
|
funcs_1.innodb_trig_03 'innodb' w4 [ pass ] 154
|
funcs_1.innodb_trig_03e 'innodb' w4 [ pass ] 268
|
funcs_1.innodb_trig_0407 'innodb' w4 [ pass ] 154
|
funcs_1.innodb_trig_08 'innodb' w4 [ pass ] 233
|
funcs_1.innodb_trig_09 'innodb' w4 [ pass ] 28
|
funcs_1.innodb_trig_1011ext 'innodb' w4 [ pass ] 103
|
funcs_1.innodb_trig_frkey 'innodb' w4 [ pass ] 28
|
funcs_1.innodb_views 'innodb' w4 [ pass ] 1692
|
funcs_1.is_basics_mixed 'innodb' w4 [ pass ] 205
|
funcs_1.is_cml_innodb 'innodb' w4 [ pass ] 10
|
funcs_1.is_columns_innodb 'innodb' w4 [ pass ] 168
|
funcs_1.is_columns_is 'innodb' w4 [ pass ] 47
|
funcs_1.is_columns_is_embedded 'innodb' w4 [ skipped ] Test requires: embedded server
|
funcs_1.is_columns_mysql 'innodb' w4 [ pass ] 44
|
funcs_1.is_engines_innodb 'innodb' w4 [ pass ] 1
|
funcs_1.is_key_column_usage 'innodb' w4 [ pass ] 93
|
funcs_1.is_key_column_usage_embedded 'innodb' w4 [ skipped ] Test requires: embedded server
|
funcs_1.is_statistics_mysql 'innodb' w4 [ pass ] 7
|
funcs_1.is_statistics_mysql_embedded 'innodb' w4 [ skipped ] Test requires: embedded server
|
funcs_1.is_table_constraints 'innodb' w4 [ pass ] 119
|
funcs_1.is_table_constraints_mysql 'innodb' w4 [ pass ] 9
|
funcs_1.is_table_constraints_mysql_embedded 'innodb' w4 [ skipped ] Test requires: embedded server
|
funcs_1.is_tables_innodb 'innodb' w4 [ pass ] 9
|
funcs_1.is_tables_mysql 'innodb' w4 [ pass ] 14
|
funcs_1.is_tables_mysql_embedded 'innodb' w4 [ skipped ] Test requires: embedded server
|
gcol.gcol_blocked_sql_funcs_innodb 'innodb' w4 [ pass ] 113
|
gcol.gcol_bugfixes 'innodb' w4 [ pass ] 131
|
gcol.gcol_handler_innodb 'innodb' w4 [ pass ] 5
|
gcol.gcol_ins_upd_innodb 'innodb' w4 [ pass ] 155
|
gcol.gcol_keys_innodb 'innodb' w4 [ pass ] 414
|
gcol.gcol_non_stored_columns_innodb 'innodb' w4 [ pass ] 77
|
gcol.gcol_rejected_innodb 'innodb' w4 [ pass ] 2
|
gcol.gcol_select_innodb 'innodb' w4 [ pass ] 167
|
gcol.gcol_supported_sql_funcs_innodb 'innodb' w4 [ pass ] 932
|
gcol.gcol_trigger_sp_innodb 'innodb' w4 [ pass ] 26
|
gcol.gcol_update 'innodb' w4 [ pass ] 213
|
gcol.gcol_view_innodb 'innodb' w4 [ pass ] 78
|
gcol.innodb_prefix_index_check 'innodb' w4 [ pass ] 3
|
gcol.innodb_virtual_blob 'innodb' w4 [ pass ] 11
|
gcol.innodb_virtual_fk 'innodb' w4 [ pass ] 449
|
gcol.innodb_virtual_fk_restart 'innodb' w4 [ pass ] 5725
|
gcol.innodb_virtual_index 'innodb' w4 [ pass ] 149
|
gcol.innodb_virtual_purge 'innodb' w4 [ pass ] 157
|
gcol.innodb_virtual_stats 'innodb' w4 [ pass ] 23
|
gcol.innodb_wl8114 'innodb' w4 [ pass ] 20
|
gcol.main_alter_table 'innodb' w4 [ pass ] 18
|
gcol.main_mysqldump 'innodb' w4 [ pass ] 223
|
handler.innodb 'innodb' w4 [ pass ] 3504
|
innodb.add_constraint 'innodb' w4 [ pass ] 16
|
innodb.alter_key_block_size-11757 'innodb' w4 [ pass ] 15
|
innodb.alter_rename_existing 'innodb' w4 [ pass ] 68
|
innodb.alter_table 'innodb' w4 [ pass ] 9
|
innodb.autoinc_persist 'innodb' w4 [ pass ] 13725
|
innodb.blob_unique2pk 'innodb' w4 [ pass ] 16
|
innodb.count_distinct 'innodb' w4 [ pass ] 12
|
innodb.create-index 'innodb' w4 [ pass ] 21
|
innodb.deadlock_detect 'innodb' w4 [ pass ] 2780
|
innodb.default_row_format_alter 'innodb' w4 [ pass ] 32
|
innodb.default_row_format_compatibility 'innodb' w4 [ pass ] 62
|
innodb.dropdb 'innodb' w4 [ pass ] 1
|
innodb.foreign_key 'innodb' w4 [ pass ] 5580
|
innodb.help_url 'innodb' w4 [ pass ] 2
|
innodb.innochecksum 'innodb' w4 [ pass ] 2043
|
innodb.innodb-agregate 'innodb' w4 [ pass ] 4
|
innodb.innodb-alter-autoinc 'innodb' w4 [ pass ] 98
|
innodb.innodb-alter-timestamp 'innodb' w4 [ pass ] 96
|
innodb.innodb-analyze 'innodb' w4 [ pass ] 8
|
innodb.innodb-autoinc-18274 'innodb' w4 [ pass ] 10
|
innodb.innodb-autoinc-44030 'innodb' w4 [ pass ] 2746
|
innodb.innodb-autoinc-61209 'innodb' w4 [ pass ] 4
|
innodb.innodb-autoinc-optimize 'innodb' w4 [ pass ] 8
|
innodb.innodb-blob 'innodb' w4 [ skipped ] debug_sync is not available
|
innodb.innodb-bug-14068765 'innodb' w4 [ pass ] 86
|
innodb.innodb-bug-14084530 'innodb' w4 [ pass ] 100
|
innodb.innodb-corrupted-table 'innodb' w4 [ pass ] 2880
|
innodb.innodb-dict 'innodb' w4 [ pass ] 50
|
innodb.innodb-fk 'innodb' w4 [ pass ] 5126
|
innodb.innodb-fk-virtual 'innodb' w4 [ pass ] 18
|
innodb.innodb-fk-warnings 'innodb' w4 [ pass ] 38
|
innodb.innodb-fkcheck 'innodb' w4 [ pass ] 28
|
innodb.innodb-get-fk 'innodb' w4 [ pass ] 9046
|
innodb.innodb-index 'innodb' w4 [ pass ] 7732
|
innodb.innodb-index-online-delete 'innodb' w4 [ skipped ] debug_sync is not available
|
innodb.innodb-index-online-purge 'innodb' w4 [ skipped ] debug_sync is not available
|
innodb.innodb-index_ucs2 'innodb' w4 [ pass ] 35
|
innodb.innodb-isolation 'innodb' w4 [ pass ] 5859
|
innodb.innodb-lock 'innodb' w4 [ pass ] 2080
|
innodb.innodb-on-duplicate-update 'innodb' w4 [ pass ] 25
|
innodb.innodb-online-alter-gis 'innodb' w4 [ pass ] 24
|
innodb.innodb-page_compression_bzip2 'innodb' w4 [ skipped ] Test requires InnoDB compiled with libbz2
|
line
|
2018-05-07 11:17:15 139986734040864 [Warning] option 'table_open_cache': unsigned value 1 adjusted to 10
|
2018-05-07 11:17:15 139986734040864 [Warning] Buffered warning: option 'max_connections': unsigned value 2 adjusted to 10
|
^ Found warnings in /run/shm/var/2/log/mysqld.1.err
|
ok
|
|
|
innodb.innodb-page_compression_default 'innodb' w4 [ pass ] 8815
|
innodb.innodb-page_compression_lz4 'innodb' w4 [ skipped ] Test requires InnoDB compiled with liblz4
|
innodb.innodb-page_compression_lzma 'innodb' w4 [ skipped ] Test requires InnoDB compiled with liblzma
|
innodb.innodb-page_compression_lzo 'innodb' w4 [ skipped ] Test requires InnoDB compiled with liblzo
|
innodb.innodb-page_compression_snappy 'innodb' w4 [ skipped ] Test requires InnoDB compiled with libsnappy
|
innodb.innodb-page_compression_tables 'innodb' w4 [ pass ] 4379
|
innodb.innodb-page_compression_zip 'innodb' w4 [ pass ] 10440
|
innodb.innodb-replace 'innodb' w4 [ pass ] 17
|
innodb.innodb-stats-initialize-failure 'innodb' w4 [ skipped ] debug_sync is not available
|
innodb.innodb-stats-sample 'innodb' w4 [ pass ] 820
|
innodb.innodb-timeout 'innodb' w4 [ pass ] 4579
|
innodb.innodb-truncate 'innodb' w4 [ pass ] 109
|
innodb.innodb-ucs2 'innodb' w4 [ pass ] 163
|
innodb.innodb-update-insert 'innodb' w4 [ pass ] 20
|
innodb.innodb-virtual-columns 'innodb' w4 [ pass ] 45
|
innodb.innodb-virtual-columns2 'innodb' w4 [ pass ] 9
|
innodb.innodb-wl5522 'innodb' w4 [ pass ] 8164
|
innodb.innodb-wl5522-1 'innodb' w4 [ pass ] 1588
|
innodb.innodb-xa 'innodb' w4 [ pass ] 10
|
innodb.innodb_blob_truncate 'innodb' w4 [ pass ] 41
|
innodb.innodb_bug12661768 'innodb' w4 [ pass ] 7
|
innodb.innodb_bug12902967 'innodb' w4 [ pass ] 2742
|
innodb.innodb_bug13510739 'innodb' w4 [ pass ] 3
|
innodb.innodb_bug14704286 'innodb' w4 [ pass ] 820
|
innodb.innodb_bug21704 'innodb' w4 [ pass ] 21
|
innodb.innodb_bug27216817 'innodb' w4 [ pass ] 47
|
innodb.innodb_bug30423 'innodb' w4 [ pass ] 3136
|
innodb.innodb_bug34053 'innodb' w4 [ pass ] 49
|
innodb.innodb_bug34300 'innodb' w4 [ pass ] 393
|
innodb.innodb_bug35220 'innodb' w4 [ pass ] 9
|
innodb.innodb_bug38231 'innodb' w4 [ pass ] 41
|
innodb.innodb_bug40360 'innodb' w4 [ pass ] 7
|
innodb.innodb_bug40565 'innodb' w4 [ pass ] 3
|
innodb.innodb_bug41904 'innodb' w4 [ pass ] 5
|
innodb.innodb_bug42101 'innodb' w4 [ pass ] 24
|
innodb.innodb_bug42419 'innodb' w4 [ pass ] 219
|
innodb.innodb_bug44032 'innodb' w4 [ pass ] 3
|
innodb.innodb_bug44369 'innodb' w4 [ pass ] 1
|
innodb.innodb_bug44571 'innodb' w4 [ pass ] 4
|
innodb.innodb_bug45357 'innodb' w4 [ pass ] 9
|
innodb.innodb_bug46000 'innodb' w4 [ pass ] 4
|
innodb.innodb_bug46676 'innodb' w4 [ pass ] 29
|
innodb.innodb_bug47167 'innodb' w4 [ pass ] 2852
|
innodb.innodb_bug47621 'innodb' w4 [ pass ] 16
|
innodb.innodb_bug47622 'innodb' w4 [ pass ] 28
|
innodb.innodb_bug47777 'innodb' w4 [ pass ] 36
|
innodb.innodb_bug48024 'innodb' w4 [ pass ] 36
|
innodb.innodb_bug49164 'innodb' w4 [ pass ] 5
|
innodb.innodb_bug51378 'innodb' w4 [ pass ] 29
|
innodb.innodb_bug51920 'innodb' w4 [ pass ] 6
|
innodb.innodb_bug52199 'innodb' w4 [ pass ] 4
|
innodb.innodb_bug52663 'innodb' w4 [ pass ] 50922
|
innodb.innodb_bug53046 'innodb' w4 [ pass ] 8
|
innodb.innodb_bug53290 'innodb' w4 [ pass ] 1298
|
innodb.innodb_bug53592 'innodb' w4 [ pass ] 45
|
innodb.innodb_bug54044 'innodb' w4 [ pass ] 6
|
innodb.innodb_bug56143 'innodb' w4 [ pass ] 906
|
innodb.innodb_bug56716 'innodb' w4 [ pass ] 17
|
innodb.innodb_bug57252 'innodb' w4 [ pass ] 5
|
innodb.innodb_bug57255 'innodb' w4 [ pass ] 229
|
innodb.innodb_bug57904 'innodb' w4 [ pass ] 5
|
innodb.innodb_bug59307 'innodb' w4 [ pass ] 16
|
innodb.innodb_bug59410 'innodb' w4 [ pass ] 6
|
innodb.innodb_bug59641 'innodb' w4 [ pass ] 6227
|
innodb.innodb_bug59733 'innodb' w4 [ pass ] 182
|
innodb.innodb_bug60229 'innodb' w4 [ pass ] 13
|
innodb.innodb_bug68148 'innodb' w4 [ pass ] 2830
|
innodb.innodb_ctype_big5 'innodb' w4 [ pass ] 99
|
innodb.innodb_ctype_latin1 'innodb' w4 [ pass ] 157
|
innodb.innodb_ctype_utf8 'innodb' w4 [ pass ] 50
|
innodb.innodb_defragment_small 'innodb' w4 [ pass ] 19
|
innodb.innodb_file_format 'innodb' w4 [ pass ] 2776
|
innodb.innodb_force_recovery 'innodb' w4 [ pass ] 16122
|
innodb.innodb_gis 'innodb' w4 [ pass ] 182
|
innodb.innodb_information_schema 'innodb' w4 [ pass ] 347
|
innodb.innodb_multi_update 'innodb' w4 [ pass ] 21
|
innodb.innodb_notembedded 'innodb' w4 [ pass ] 216
|
innodb.innodb_prefix_index_restart_server 'innodb' w4 [ pass ] 8365
|
innodb.innodb_stats 'innodb' w4 [ pass ] 152
|
innodb.innodb_stats_create_on_corrupted 'innodb' w4 [ pass ] 2762
|
innodb.innodb_stats_create_table 'innodb' w4 [ pass ] 29
|
innodb.innodb_stats_drop_locked 'innodb' w4 [ pass ] 2288
|
innodb.innodb_stats_fetch 'innodb' w4 [ pass ] 28
|
innodb.innodb_stats_fetch_corrupted 'innodb' w4 [ pass ] 2745
|
innodb.innodb_stats_fetch_nonexistent 'innodb' w4 [ pass ] 17
|
innodb.innodb_stats_rename_table 'innodb' w4 [ pass ] 16
|
innodb.innodb_stats_rename_table_if_exists 'innodb' w4 [ pass ] 406
|
innodb.log_corruption 'innodb' w4 [ pass ] 46003
|
innodb.log_file 'innodb' w4 [ pass ] 40364
|
innodb.log_file_name 'innodb' w4 [ pass ] 25756
|
innodb.mdev-117 'innodb' w4 [ pass ] 45
|
innodb.monitor 'innodb' w4 [ pass ] 84
|
innodb.mvcc 'innodb' w4 [ pass ] 106
|
innodb.read_only_recovery 'innodb' w4 [ pass ] 5830
|
innodb.readahead 'innodb' w4 [ pass ] 2836
|
innodb.recovery_shutdown 'innodb' w4 [ pass ] 4551
|
innodb.row_format_redundant 'innodb' w4 [ pass ] 13712
|
innodb.row_lock 'innodb' w4 [ pass ] 131
|
innodb.strict_mode 'innodb' w4 [ pass ] 66
|
innodb.system_tables 'innodb' w4 [ pass ] 2957
|
innodb.table_index_statistics 'innodb' w4 [ pass ] 43
|
innodb.temp_table 'innodb' w4 [ pass ] 324
|
innodb.temp_table_savepoint 'innodb' w4 [ fail ]
|
The test is using stored procedures to insert into the tables. There is also some INSERT…ON DUPLICATE KEY UPDATE. Does the test fail repeatably? I’d tend to believe that the bug must be outside InnoDB, in the SQL layer.