[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: File out21-jul5-1.log    
Issue Links:
PartOf
is part of MDEV-3932 5.6 merge Closed

 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) ==
main.sp_trans
main.status
main.ps_ddl
main.sp-error
main.signal
main.signal_demo3
main.sp
main.sp-big
main.sp-bugs
main.sp-code
main.sp-destruct
^^ Sanja needs to discuss with Monty ^^

== DATETIME type differences (8 tests) ==
main.func_time
main.select
main.select_jcl6
main.cast
main.type_date
main.select_pkeycache
main.mysql_client_test - test_wl4166_3, DATETIME and warnings.
main.mysql_client_test_nonblock - test_wl4166_3, DATETIME and warnings.
^^ Discussed with Bar. There were related fixes, he will be able to look on Monday^^

== CREATE VIEW/TABLE, ALTER TABLE error vs no-error difference (6 tests) ==
main.alter_table_online
main.alter_table_trans
main.upgrade
main.view
main.partition_truncate
main.create

== Table open/close problem (5 tests) ==
main.plugin
main.repair
main.alter_table
main.analyze
main.check

== Merge storage engine (2 tests) ==
main.merge_mmap
main.merge

== Unknown/isolated reason (20 tests) ==
main.innodb_ignore_builtin - unknown option '--skip-innodb-stats-persistent' - FIXED.
main.type_decimal - NOTE vs Warning, simple, standalone - FIXED
main.row-checksum - Warning code difference - FIXED
main.row-checksum-old - Warning code is different - FIXED
main.func_crypt - function returns different value (standalone) - FIXED
main.mysqldump - client memory leaks, different system tables - FIXED

main.statistics - MDEV-4758, ALTER TABLE + EITS

main.partition_binlog - ALTER TABLE, end_statement assert
main.commit_1innodb - Unknown
main.ctype_cp932_binlog_stm - Unknown, standalone
main.commit - Unknown, standalone
main.myisam - Warnings (non SP)
main.limit_rows_examined - SP problem
main.partition_debug_sync - Unknown, standalone
main.partition_mgm_err - Unknown, standalone
main.partition_myisam - A warning is gone (standalone?)
main.group_min_max_innodb - EXPLAIN difference
main.truncate_coverage - Unknown
main.flush_read_lock - Unknown
main.innodb_mysql_sync - Unknown

== mysql.slave_XXX system tables (8 tests) (ALL FIXED) ==
main.log_tables_upgrade
main.mysql_upgrade
main.mysql_upgrade_ssl
main.mysqlcheck
main.system_mysql_db_fix40123
main.system_mysql_db_fix50030
main.system_mysql_db_fix50117
main.1st

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
Total: 46 test failures

=== SP error handling (11 tests) ==
main.sp_trans
main.status
main.ps_ddl
main.sp-error
main.signal
main.signal_demo3
main.sp
main.sp-big
main.sp-bugs
main.sp-code
main.sp-destruct
^^ Sanja needs to discuss with Monty ^^

== DATETIME type differences (8 tests) ==
main.func_time
main.select
main.select_jcl6
main.cast
main.type_date
main.select_pkeycache
main.mysql_client_test - test_wl4166_3, DATETIME and warnings.
main.mysql_client_test_nonblock - test_wl4166_3, DATETIME and warnings.
^^ Discussed with Bar. There were related fixes, he will be able to look on Monday^^

== CREATE VIEW/TABLE, ALTER TABLE error vs no-error difference (6 tests) ==
main.alter_table_online
main.alter_table_trans
main.upgrade
main.view
main.partition_truncate
main.create

== Table open/close problem (5 tests) ==
main.plugin
main.repair
main.alter_table
main.analyze
main.check

== Merge storage engine (2 tests) ==
main.merge_mmap
main.merge

== Unknown/isolated reason (14 tests) ==
main.group_min_max_innodb - EXPLAIN difference - FIXED
main.limit_rows_examined - SP problem - FIXED
main.statistics - MDEV-4758, ALTER TABLE + EITS

main.partition_binlog - ALTER TABLE, end_statement assert
main.commit_1innodb - Unknown
main.ctype_cp932_binlog_stm - Unknown, standalone
main.commit - Unknown, standalone
main.myisam - Warnings (non SP)
main.partition_debug_sync - Unknown, standalone
main.partition_mgm_err - Unknown, standalone
main.partition_myisam - A warning is gone (standalone?)
main.truncate_coverage - Unknown
main.flush_read_lock - Unknown
main.innodb_mysql_sync - Unknown

Comment by Sergei Petrunia [ 2013-07-05 ]

Revision: 3563
Completed: Failed 36/630 tests, 94.29% 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.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
Completed: Failed 36/630 tests, 94.29% were successful.

=== SP error handling (5 tests) ==
main.status
main.ps_ddl
main.signal
main.signal_demo3
main.sp - FIXED
^ These still remain after Sanja's fix for SP+error handling ^

== DATETIME type differences (8 tests) ==
main.func_time
main.select
main.select_jcl6
main.cast
main.type_date
main.select_pkeycache
main.mysql_client_test - test_wl4166_3, DATETIME and warnings.
main.mysql_client_test_nonblock - test_wl4166_3, DATETIME and warnings.
^^ Discussed with Bar. There were related fixes, he will be able to look on Monday^^

== CREATE VIEW/TABLE, ALTER TABLE error vs no-error difference (6 tests) ==
main.alter_table_online
main.alter_table_trans - FIXED
main.upgrade
main.partition_truncate
main.create

== Table open/close problem (5 tests) ==
main.plugin
main.repair
main.alter_table
main.analyze
main.check

== Merge storage engine (2 tests) ==
main.merge_mmap
main.merge

== Unknown/isolated reason (11 tests) ==
main.myisam - Warnings (non SP) - FIXED

main.statistics - MDEV-4758, ALTER TABLE + EITS
main.partition_binlog - ALTER TABLE, end_statement assert
main.commit_1innodb - Unknown
main.partition_debug_sync - Unknown, standalone
main.partition_mgm_err - Unknown, standalone
main.partition_myisam - A warning is gone (standalone?)
main.truncate_coverage - Unknown
main.flush_read_lock - Unknown
main.innodb_mysql_sync - Unknown
main.trigger: Unknown, SP crash, started to fail recently.

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)
+Inner (bad)
...
select row_count()|
row_count()
--1
+0
... etc

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
+Note 1031 Table storage engine for 'InnoDB' 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:
ER_ILLEGAL_HA
eng "Table storage engine for '%-.192s' doesn't have this option"

Then, Sergei has changed the message to give more details:

ER_ILLEGAL_HA
eng "Storage engine %s of the table %`s.%`s doesn't have this option"

The merge made a mess of this (some error calls with ER_ILLEGAL_HA provide
parameters for old pattern string, some provide for the new).

I was able to fix all of the calls to provide all three parameters (table, db,
storage engine), except one in execute_ddl_log_action():

plugin_ref plugin= ha_resolve_by_name(thd, &handler_name);
if (!plugin)
{
my_error(ER_ILLEGAL_HA, MYF(0), ddl_log_entry->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)
(Some tests in non-main test suite also have been fixed but they are not visible here)

Comment by Sergei Petrunia [ 2013-07-08 ]

revision-id: psergey@askmonty.org-20130708162127-k5fm0vhtr3klucqo
Completed: Failed 31/630 tests, 95.08% 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.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:
Completed: Failed 30/630 tests, 95.24% were successful.

=== SP error handling (4 tests) ==
main.ps_ddl - Some result difference
main.signal - Caused SPs catching/handling errors?
main.signal_demo3 - Caused SPs catching/handling errors?

== DATETIME type differences (8 tests) ==
main.func_time
main.select
main.select_jcl6
main.cast
main.type_date
main.select_pkeycache
main.mysql_client_test - test_wl4166_3, DATETIME and warnings.
main.mysql_client_test_nonblock - test_wl4166_3, DATETIME and warnings.
^^ Discussed with Bar. There were related fixes, he will be able to look on Monday^^

== DML error vs no-error difference (3 tests) ==
main.alter_table_online - 'alter online ....' succeeded - should have failed
main.upgrade - query 'create table ...' succeeded - should have failed
main.create - query 'create table ...' succeeded - should have failed

== Assert in open_temporary_table (5 tests) ==
main.flush_read_lock - Assert in open_temporary_table, sql_base.cc:6488
main.analyze - Assert in open_temporary_table, sql_base.cc:6488
main.check - Assert in open_temporary_table, sql_base.cc:6488
main.merge - Assert in open_temporary_table, sql_base.cc:6488
main.repair - Assert in open_temporary_table, sql_base.cc:6488

== Wrong errno (3 tests) ==
main.status - Access denied check, wrong errno
main.partition_binlog - FIXED wrong errno
main.partition_mgm_err - FIXED 'ALTER TABLE t1 ADD PARTITION PARTITIONS 1024' failed with wrong errno

== Unknown/isolated reason (8 tests) ==
main.statistics - MDEV-4758, ALTER TABLE + EITS
main.plugin - Crash when DROP-ing a table whose plugin was unloaded
main.alter_table - Assert in mi_open.c:67: test_if_reopen
main.commit_1innodb - Unknown
main.partition_debug_sync - query 'reap' failed: 1213: Deadlock found when trying to get lock;
main.partition_myisam - Warning "expressions in (sub)partitioning function not allowed" is gone
main.truncate_coverage - debug sync point wait timed out
main.innodb_mysql_sync - timeout with "alter_table_manage_keys SIGNAL manage WAIT_FOR query"

Comment by Sergei Petrunia [ 2013-07-09 ]

Revision: 3580
Completed: Failed 26/630 tests, 95.87% were successful.

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
Completed: Failed 22/630 tests, 96.51% were successful.

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
Completed: Failed 22/630 tests, 96.51% were successful.

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) ==
main.ps_ddl - Some result difference
main.signal - Caused SPs catching/handling errors?
main.signal_demo3 - Caused SPs catching/handling errors?

== DATETIME type differences (8 tests) ==
main.func_time
main.select
main.select_jcl6
main.cast
main.type_date
main.select_pkeycache
main.mysql_client_test - test_wl4166_3, DATETIME and warnings.
main.mysql_client_test_nonblock - test_wl4166_3, DATETIME and warnings.
^^ Discussed with Bar. There were related fixes, he will be able to look on Monday^^

== DML error vs no-error difference (3 tests) ==
main.alter_table_online - 'alter online ....' succeeded - should have failed
main.upgrade - query 'create table ...' succeeded - should have failed
main.create - query 'create table ...' succeeded - should have failed

== Unknown/isolated reason (8 tests) ==
main.statistics - MDEV-4758, ALTER TABLE + EITS
main.plugin - Crash when DROP-ing a table whose plugin was unloaded
main.alter_table - Assert in mi_open.c:67: test_if_reopen
main.commit_1innodb - Unknown
main.truncate_coverage - debug sync point wait timed out
main.innodb_mysql_sync - timeout with "alter_table_manage_keys SIGNAL manage WAIT_FOR query"
main.flush_read_lock - FTRWL problem
main.status - Access denied check, wrong error code

Comment by Sergei Golubchik [ 2013-07-15 ]

all existing tests pass

Generated at Thu Feb 08 06:58:53 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.