[MDEV-16182] innodb.temp_table_savepoint failed in buildbot with wrong result Created: 2018-05-15  Updated: 2019-09-30  Resolved: 2019-09-30

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB, Tests
Affects Version/s: 10.2
Fix Version/s: 10.2.18, 10.3.10, 10.4.0

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Marko Mäkelä
Resolution: Duplicate Votes: 0
Labels: None

Issue Links:
Duplicate
duplicates MDEV-16868 Same query gives different results Closed

 Description   

http://buildbot.askmonty.org/buildbot/builders/kvm-deb-wheezy-amd64/builds/13484/steps/mtr/logs/stdio

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



 Comments   
Comment by Marko Mäkelä [ 2018-05-15 ]

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.

Comment by Marko Mäkelä [ 2018-05-17 ]

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 ]

Comment by Marko Mäkelä [ 2019-09-30 ]

I think that this shares a root cause with MDEV-16868.

Generated at Thu Feb 08 08:26:59 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.