[MDEV-4751] Tracking test failures in 10.0-monty Created: 2013-07-03 Updated: 2013-07-15 Resolved: 2013-07-15 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | 10.0.4 |
| Type: | Bug | Priority: | Major |
| Reporter: | Sergei Petrunia | Assignee: | Sergei Golubchik |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Attachments: |
|
||||||||
| Issue Links: |
|
||||||||
| Description |
|
This is just to track test failures in 10.0-monty as they are fixed. |
| Comments |
| Comment by Sergei Petrunia [ 2013-07-03 ] |
|
Current status for 'main' testsuite: Completed: Failed 99/630 tests, 84.29% were successful. Failing test(s): main.partition_cache main.innodb_mysql_lock2 main.partition_binlog main.partition_cache_innodb main.partition main.partition_not_windows main.lock main.partition_column main.ctype_utf8mb4_innodb main.partition_innodb main.partition_innodb_plugin main.mysql_client_test main.mysql_client_test_nonblock main.log_tables main.log_state main.commit_1innodb main.mysqldump main.sp_trans main.partition_debug_sync main.partition_error main.partition_grant main.partition_hash main.partition_mgm main.mdl_sync main.partition_mgm_err main.partition_myisam main.partition_range main.partition_sync main.partition_truncate main.plugin_auth main.strict main.ctype_cp932_binlog_stm main.status main.union main.myisam main.merge_mmap main.row-checksum-old main.temp_table main.1st main.alter_table main.grant main.handlersocket main.analyze main.check main.create main.limit_rows_examined main.ctype_errors main.events_2 main.func_crypt main.plugin main.ps_ddl main.repair main.signal main.signal_demo3 main.sp main.sp-big main.sp-bugs main.sp-code main.sp-destruct main.sp-error main.system_mysql_db main.trigger main.statistics main.alter_table_online main.alter_table_trans main.cache_innodb main.commit main.flush_read_lock main.function_defaults main.group_min_max_innodb main.index_intersect_innodb main.innodb_ext_key main.innodb_icp main.truncate_coverage main.type_decimal main.upgrade main.view main.lock_multi main.subselect2 main.log_slow main.subselect_innodb main.merge main.subselect_sj2 main.mysqld--help main.subselect_sj2_jcl6 main.subselect_sj2_mat main.system_mysql_db_fix40123 main.system_mysql_db_fix50030 main.system_mysql_db_fix50117 main.type_bit_innodb main.innodb_mysql_sync main.join_outer_innodb main.log_tables_upgrade main.mysql_upgrade main.mysql_upgrade_ssl main.mysqlcheck main.range_vs_index_merge_innodb main.read_only_innodb main.row-checksum |
| Comment by Sergei Petrunia [ 2013-07-03 ] |
|
revision 3530: Completed: Failed 127/630 tests, 79.84% were successful. Failing test(s): main.partition_cache main.innodb_mysql_lock2 main.partition_cache_innodb main.partition_binlog main.partition_innodb main.partition_innodb_plugin main.partition_not_blackhole main.lock main.partition_column main.partition main.partition_not_windows main.mysql_client_test main.partition_error main.partition_grant main.partition_hash main.partition_mgm main.partition_mgm_err main.partition_myisam main.partition_range main.partition_sync main.partition_truncate main.commit_1innodb main.mysqldump main.row-checksum-old main.sp_trans main.select_pkeycache main.ctype_cp932_binlog_stm main.status main.union main.warnings main.partition_disabled main.plugin_auth main.myisam main.merge_mmap main.temp_table main.1st main.partition_debug_sync main.alter_table main.analyze main.cast main.mysql_client_test_nonblock main.check main.create main.ctype_errors main.log_tables main.log_state main.ctype_tis620 main.ctype_ujis main.func_time main.ctype_utf8mb4_heap main.ctype_utf8mb4_myisam main.gis-rtree main.grant main.drop main.error_simulation main.events_2 main.handlersocket main.func_crypt main.key main.limit_rows_examined main.plugin main.profiling main.ps_ddl main.read_only main.rename main.repair main.select main.select_jcl6 main.signal main.signal_demo2 main.signal_demo3 main.sp main.sp-big main.sp-bugs main.sp-code main.sp-destruct main.sp-dynamic main.sp-error main.sp-prelocking main.sp-vars main.subselect main.subselect4 main.statistics main.subselect_no_mat main.alter_table_online main.alter_table_trans main.subselect_no_opts main.subselect_no_scache main.subselect_no_semijoin main.cache_innodb main.system_mysql_db main.commit main.trigger main.flush_read_lock main.func_analyse main.function_defaults main.group_min_max_innodb main.innodb_icp main.truncate_coverage main.type_date main.type_decimal main.type_newdecimal main.upgrade main.view main.range_vs_index_merge_innodb main.read_only_innodb main.row-checksum main.subselect2 main.lock_multi main.log_slow main.subselect_innodb main.subselect_sj2 main.merge main.myisam-system main.subselect_sj2_jcl6 main.mysqld--help main.subselect_sj2_mat main.system_mysql_db_fix40123 main.system_mysql_db_fix50030 main.system_mysql_db_fix50117 main.type_bit_innodb main.innodb_mysql_sync main.join_outer_innodb main.log_tables_upgrade main.mysql_upgrade main.mysql_upgrade_ssl main.mysqlcheck |
| Comment by Sergei Petrunia [ 2013-07-03 ] |
|
Run on what became rev. 3535: Completed: Failed 121/631 tests, 80.82% were successful. Failing test(s): main.partition_binlog main.partition_cache main.partition_not_blackhole main.lock main.innodb_mysql_lock2 main.partition main.partition_cache_innodb main.partition_not_windows main.partition_column main.partition_error main.partition_innodb main.partition_innodb_plugin main.mysql_client_test main.log_state main.innodb_ignore_builtin main.commit_1innodb main.mysqldump main.mysql_client_test_nonblock main.sp_trans main.log_tables main.ctype_cp932_binlog_stm main.status main.union main.warnings main.partition_disabled main.select_pkeycache main.row-checksum-old main.merge_mmap main.plugin_auth main.alter_table_online main.myisam main.alter_table_trans main.temp_table main.cache_innodb main.commit main.statistics main.drop main.error_simulation main.gis-rtree main.events_2 main.grant main.handlersocket main.func_crypt main.key main.func_time main.limit_rows_examined main.merge main.partition_debug_sync main.partition_grant main.partition_hash main.partition_mgm main.partition_mgm_err main.myisam-system main.partition_myisam main.partition_range main.partition_sync main.mysqld--help main.partition_truncate main.plugin main.rename main.profiling main.repair main.ps_ddl main.select main.read_only main.sp-error main.sp-prelocking main.select_jcl6 main.signal main.signal_demo2 main.sp-vars main.signal_demo3 main.sp main.sp-big main.sp-bugs main.sp-code main.sp-destruct main.sp-dynamic main.subselect main.subselect4 main.subselect_no_mat main.subselect_no_opts main.subselect_no_scache main.system_mysql_db main.subselect_no_semijoin main.type_date main.type_decimal main.type_newdecimal main.trigger main.upgrade main.view main.group_min_max_innodb main.1st main.alter_table main.analyze main.flush_read_lock main.cast main.func_analyse main.function_defaults main.check main.create main.ctype_errors main.ctype_tis620 main.ctype_ujis main.ctype_utf8mb4_heap main.ctype_utf8mb4_myisam main.subselect2 main.subselect_innodb main.system_mysql_db_fix40123 main.system_mysql_db_fix50030 main.system_mysql_db_fix50117 main.read_only_innodb main.row-checksum main.truncate_coverage main.lock_multi main.log_slow main.innodb_mysql_sync main.log_tables_upgrade main.mysql_upgrade main.mysql_upgrade_ssl main.mysqlcheck |
| Comment by Sergei Petrunia [ 2013-07-03 ] |
|
For revision 3538: Completed: Failed 78/630 tests, 87.62% were successful. Failing test(s): main.partition_binlog main.partition main.mysql_client_test main.mysql_client_test_nonblock main.log_state main.innodb_ignore_builtin main.log_tables main.commit_1innodb main.mysqldump main.row-checksum-old main.plugin_auth main.alter_table_online main.alter_table_trans main.sp_trans main.commit main.ctype_cp932_binlog_stm main.select_pkeycache main.status main.partition_disabled main.myisam main.merge_mmap main.drop main.func_crypt main.func_time main.partition_debug_sync main.partition_mgm_err main.partition_myisam main.gis-rtree main.partition_truncate main.grant main.handlersocket main.flush_read_lock main.function_defaults main.group_min_max_innodb main.merge main.limit_rows_examined main.myisam-system main.mysqld--help main.log_slow main.plugin main.repair main.ps_ddl main.select main.sp-error main.select_jcl6 main.signal main.signal_demo2 main.signal_demo3 main.sp main.sp-big main.sp-bugs main.sp-code main.sp-destruct main.sp-dynamic main.subselect4 main.system_mysql_db main.type_date main.type_decimal main.upgrade main.view main.log_tables_upgrade main.mysql_upgrade main.mysql_upgrade_ssl main.mysqlcheck main.statistics main.row-checksum main.1st main.alter_table main.analyze main.cast main.check main.create main.ctype_errors main.system_mysql_db_fix40123 main.system_mysql_db_fix50030 main.system_mysql_db_fix50117 main.truncate_coverage main.innodb_mysql_sync |
| Comment by Sergei Petrunia [ 2013-07-04 ] |
|
revision 3539: Completed: Failed 70/630 tests, 88.89% were successful. Failing test(s): main.partition_binlog main.log_state main.innodb_ignore_builtin main.log_tables main.commit_1innodb main.mysqldump main.sp_trans main.mysql_client_test main.mysql_client_test_nonblock main.row-checksum-old main.alter_table_online main.alter_table_trans main.commit main.ctype_cp932_binlog_stm main.select_pkeycache main.status main.plugin_auth main.myisam main.merge_mmap main.statistics main.grant main.handlersocket main.1st main.alter_table main.limit_rows_examined main.analyze main.cast main.func_crypt main.log_slow main.check main.create main.func_time main.ctype_errors main.plugin main.merge main.ps_ddl main.repair main.mysqld--help main.select main.sp-error main.select_jcl6 main.signal main.signal_demo3 main.sp main.sp-big main.sp-bugs main.sp-code main.sp-destruct main.system_mysql_db main.upgrade main.view main.partition_mgm_err main.partition_myisam main.group_min_max_innodb main.partition_truncate main.function_defaults main.log_tables_upgrade main.mysql_upgrade main.mysql_upgrade_ssl main.mysqlcheck main.partition_debug_sync main.row-checksum main.system_mysql_db_fix40123 main.system_mysql_db_fix50030 main.system_mysql_db_fix50117 main.type_decimal main.flush_read_lock main.truncate_coverage main.type_date main.innodb_mysql_sync |
| Comment by Sergei Petrunia [ 2013-07-04 ] |
|
revision 3542: Completed: Failed 65/630 tests, 89.68% were successful. Failing test(s): main.partition_binlog main.log_tables main.innodb_ignore_builtin main.log_state main.commit_1innodb main.mysql_client_test_nonblock main.mysql_client_test main.mysqldump main.sp_trans main.row-checksum-old main.plugin_auth main.alter_table_online main.alter_table_trans main.commit main.ctype_cp932_binlog_stm main.select_pkeycache main.status main.myisam main.merge_mmap main.1st main.alter_table main.analyze main.cast main.func_crypt main.check main.create main.ctype_errors main.func_time main.flush_read_lock main.handlersocket main.group_min_max_innodb main.merge main.limit_rows_examined main.plugin main.repair main.ps_ddl main.partition_debug_sync main.select main.partition_mgm_err main.partition_myisam main.partition_truncate main.sp-error main.select_jcl6 main.signal main.signal_demo3 main.sp main.sp-big main.sp-bugs main.sp-code main.sp-destruct main.upgrade main.type_date main.type_decimal main.view main.log_tables_upgrade main.mysql_upgrade_ssl main.mysql_upgrade main.statistics main.mysqlcheck main.system_mysql_db_fix40123 main.system_mysql_db_fix50030 main.system_mysql_db_fix50117 main.row-checksum main.truncate_coverage main.innodb_mysql_sync |
| Comment by Sergei Petrunia [ 2013-07-04 ] |
|
Revision 3547: Check of testcase failed for: main.fix_priv_tables main.plugin_auth Completed: Failed 61/630 tests, 90.32% were successful. Failing test(s): main.partition_binlog main.innodb_ignore_builtin main.log_tables main.commit_1innodb main.mysqldump main.sp_trans main.mysql_client_test main.mysql_client_test_nonblock main.row-checksum-old main.ctype_cp932_binlog_stm main.select_pkeycache main.status main.alter_table_online main.myisam main.alter_table_trans main.merge_mmap main.commit main.1st main.alter_table main.analyze main.cast main.check main.create main.flush_read_lock main.group_min_max_innodb main.func_crypt main.partition_debug_sync main.partition_mgm_err main.partition_myisam main.func_time main.partition_truncate main.merge main.statistics main.repair main.plugin main.limit_rows_examined main.ps_ddl main.select main.select_jcl6 main.signal main.sp-error main.signal_demo3 main.sp main.sp-big main.sp-bugs main.sp-code main.sp-destruct main.upgrade main.view main.type_date main.type_decimal main.mysql_upgrade_ssl main.mysqlcheck main.mysql_upgrade main.system_mysql_db_fix40123 main.system_mysql_db_fix50030 main.system_mysql_db_fix50117 main.row-checksum main.truncate_coverage main.innodb_mysql_sync main.log_tables_upgrade |
| Comment by Sergei Petrunia [ 2013-07-04 ] |
|
Revision 3548: Completed: Failed 60/630 tests, 90.48% were successful. Failing test(s): main.partition_binlog main.innodb_ignore_builtin main.commit_1innodb main.mysqldump main.sp_trans main.mysql_client_test main.mysql_client_test_nonblock main.ctype_cp932_binlog_stm main.select_pkeycache main.status main.row-checksum-old main.alter_table_online main.alter_table_trans main.commit main.statistics main.myisam main.merge_mmap main.func_crypt main.func_time main.merge main.limit_rows_examined main.plugin main.repair main.ps_ddl main.select main.sp-error main.select_jcl6 main.signal main.signal_demo3 main.sp main.sp-big main.sp-bugs main.sp-code main.sp-destruct main.upgrade main.view main.partition_debug_sync main.partition_mgm_err main.partition_myisam main.partition_truncate main.group_min_max_innodb main.log_tables_upgrade main.mysql_upgrade main.mysql_upgrade_ssl main.mysqlcheck main.row-checksum main.system_mysql_db_fix40123 main.system_mysql_db_fix50030 main.system_mysql_db_fix50117 main.alter_table main.analyze main.cast main.1st main.check main.create main.type_decimal main.truncate_coverage main.type_date main.flush_read_lock main.innodb_mysql_sync |
| Comment by Sergei Petrunia [ 2013-07-04 ] |
|
Total: 60 test failures === SP error handling (11 tests) == == DATETIME type differences (8 tests) == == CREATE VIEW/TABLE, ALTER TABLE error vs no-error difference (6 tests) == == Table open/close problem (5 tests) == == Merge storage engine (2 tests) == == Unknown/isolated reason (20 tests) == main.statistics - main.partition_binlog - ALTER TABLE, end_statement assert == mysql.slave_XXX system tables (8 tests) (ALL FIXED) == |
| Comment by Sergei Petrunia [ 2013-07-05 ] |
|
Revision: 3554 Completed: Failed 47/630 tests, 92.54% were successful. Failing test(s): main.partition_binlog main.commit_1innodb main.mysqldump main.sp_trans main.mysql_client_test main.mysql_client_test_nonblock main.alter_table_online main.alter_table_trans main.commit main.status main.select_pkeycache main.ctype_cp932_binlog_stm main.merge_mmap main.myisam main.statistics main.func_time main.alter_table main.limit_rows_examined main.plugin main.analyze main.cast main.ps_ddl main.check main.repair main.sp main.sp-big main.sp-bugs main.create main.sp-code main.sp-destruct main.select main.sp-error main.select_jcl6 main.signal main.signal_demo3 main.merge main.upgrade main.view main.partition_mgm_err main.partition_myisam main.partition_truncate main.group_min_max_innodb main.type_date main.partition_debug_sync main.flush_read_lock main.truncate_coverage main.innodb_mysql_sync |
| Comment by Sergei Petrunia [ 2013-07-05 ] |
|
Revision: 3555 === SP error handling (11 tests) == == DATETIME type differences (8 tests) == == CREATE VIEW/TABLE, ALTER TABLE error vs no-error difference (6 tests) == == Table open/close problem (5 tests) == == Merge storage engine (2 tests) == == Unknown/isolated reason (14 tests) == main.partition_binlog - ALTER TABLE, end_statement assert |
| Comment by Sergei Petrunia [ 2013-07-05 ] |
|
Revision: 3563 Failing test(s): main.partition_binlog main.commit_1innodb main.mysql_client_test main.mysql_client_test_nonblock main.alter_table_online main.alter_table_trans main.select_pkeycache main.status main.statistics main.flush_read_lock main.merge_mmap main.myisam main.func_time main.alter_table main.analyze main.cast main.merge main.check main.create main.plugin main.repair main.ps_ddl main.select main.select_jcl6 main.signal main.signal_demo3 main.sp main.type_date main.trigger main.upgrade main.partition_mgm_err main.partition_myisam main.partition_truncate main.partition_debug_sync main.truncate_coverage main.innodb_mysql_sync |
| Comment by Sergei Petrunia [ 2013-07-05 ] |
|
Revision: 3563 === SP error handling (5 tests) == == DATETIME type differences (8 tests) == == CREATE VIEW/TABLE, ALTER TABLE error vs no-error difference (6 tests) == == Table open/close problem (5 tests) == == Merge storage engine (2 tests) == == Unknown/isolated reason (11 tests) == main.statistics - |
| Comment by Sergei Petrunia [ 2013-07-06 ] |
|
main.sp test failure shows both problem handled by Sanja (extra warnings) AND other kinds of problems, like -Outer (good) |
| Comment by Sergei Petrunia [ 2013-07-08 ] |
|
Investigated the problem with test result differences like this: -Note 1031 Table storage engine for 't1' doesn't have this option The cause is as follows: MySQL 5.6 (and MariaDB up to 10.0 around April 2013), had this error: Then, Sergei has changed the message to give more details: ER_ILLEGAL_HA The merge made a mess of this (some error calls with ER_ILLEGAL_HA provide I was able to fix all of the calls to provide all three parameters (table, db, plugin_ref plugin= ha_resolve_by_name(thd, &handler_name); Here, I don't see where I could get db_name and table_name from. |
| Comment by Sergei Petrunia [ 2013-07-08 ] |
|
Discussed with Sergei, resolved by changing to use ER_UNKNOWN_STORAGE_ENGINE. |
| Comment by Sergei Petrunia [ 2013-07-08 ] |
|
Revision: 3574 Completed: Failed 35/630 tests, 94.44% were successful. Failing test(s): main.partition_binlog main.commit_1innodb main.mysql_client_test main.mysql_client_test_nonblock main.alter_table_online main.select_pkeycache main.status main.flush_read_lock main.merge_mmap main.myisam main.statistics main.func_time main.alter_table main.plugin main.analyze main.cast main.ps_ddl main.check main.repair main.create main.sp main.select main.merge main.select_jcl6 main.signal main.signal_demo3 main.trigger main.type_date main.partition_mgm_err main.partition_myisam main.partition_truncate main.partition_debug_sync main.truncate_coverage main.upgrade main.innodb_mysql_sync (As compared to previous run, alter_table_trans no longer fails) |
| Comment by Sergei Petrunia [ 2013-07-08 ] |
|
revision-id: psergey@askmonty.org-20130708162127-k5fm0vhtr3klucqo Failing test(s): main.partition_binlog main.commit_1innodb main.mysql_client_test main.mysql_client_test_nonblock main.alter_table_online main.status main.select_pkeycache main.flush_read_lock main.func_time main.merge main.plugin main.repair main.ps_ddl main.select main.select_jcl6 main.signal main.signal_demo3 main.type_date main.upgrade main.partition_debug_sync main.partition_mgm_err main.partition_myisam main.partition_truncate main.statistics main.alter_table main.analyze main.cast main.check main.create main.truncate_coverage main.innodb_mysql_sync |
| Comment by Sergei Petrunia [ 2013-07-09 ] |
|
Revision 3579: Completed: Failed 30/630 tests, 95.24% were successful. Failing test(s): main.partition_binlog main.commit_1innodb main.mysql_client_test_nonblock main.mysql_client_test main.alter_table_online main.select_pkeycache main.status main.flush_read_lock main.alter_table main.analyze main.cast main.check main.create main.func_time main.plugin main.merge main.repair main.ps_ddl main.select main.partition_debug_sync main.partition_mgm_err main.partition_myisam main.select_jcl6 main.signal main.signal_demo3 main.type_date main.upgrade main.statistics main.truncate_coverage main.innodb_mysql_sync |
| Comment by Sergei Petrunia [ 2013-07-09 ] |
|
Revision 3579: === SP error handling (4 tests) == == DATETIME type differences (8 tests) == == DML error vs no-error difference (3 tests) == == Assert in open_temporary_table (5 tests) == == Wrong errno (3 tests) == == Unknown/isolated reason (8 tests) == |
| Comment by Sergei Petrunia [ 2013-07-09 ] |
|
Revision: 3580 Failing test(s): main.commit_1innodb main.alter_table_online main.mysql_client_test_nonblock main.mysql_client_test main.status main.select_pkeycache main.statistics main.func_time main.flush_read_lock main.plugin main.repair main.ps_ddl main.merge main.select main.signal main.signal_demo3 main.select_jcl6 main.type_date main.upgrade main.analyze main.alter_table main.cast main.check main.create main.truncate_coverage main.innodb_mysql_sync |
| Comment by Sergei Petrunia [ 2013-07-09 ] |
|
Revision: 3581 Failing test(s): main.commit_1innodb main.alter_table_online main.mysql_client_test_nonblock main.mysql_client_test main.status main.select_pkeycache main.statistics main.func_time main.plugin main.ps_ddl main.flush_read_lock main.select main.select_jcl6 main.signal main.signal_demo3 main.type_date main.upgrade main.cast main.alter_table main.create main.truncate_coverage main.innodb_mysql_sync |
| Comment by Sergei Petrunia [ 2013-07-09 ] |
|
Revision: 3581 Failing test(s): main.commit_1innodb main.alter_table_online main.mysql_client_test_nonblock main.mysql_client_test main.status main.select_pkeycache main.statistics main.func_time main.plugin main.ps_ddl main.flush_read_lock main.select main.select_jcl6 main.signal main.signal_demo3 main.type_date main.upgrade main.cast main.alter_table main.create main.truncate_coverage main.innodb_mysql_sync === SP error handling (3 tests) == == DATETIME type differences (8 tests) == == DML error vs no-error difference (3 tests) == == Unknown/isolated reason (8 tests) == |
| Comment by Sergei Golubchik [ 2013-07-15 ] |
|
all existing tests pass |