-
-
Notifications
You must be signed in to change notification settings - Fork 141
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
bug: StoneDB MTR main and innodb test error #277
Labels
A-bug
Something isn't working
Comments
zsp108
changed the title
bug: StoneDB MTR main Result content mismatch
bug: StoneDB MTR main test error
Jul 21, 2022
zsp108
changed the title
bug: StoneDB MTR main test error
bug: StoneDB MTR main and innodb test error
Jul 24, 2022
mergify bot
added a commit
that referenced
this issue
Aug 1, 2022
…and innodb mtr_test(#277) (#335) * fix(mtr):fix innodb mtr and mv some test to test/innodb * fix(mtr):move character_set to test/main/ fix(mtr):mv main mtr character_set test to test/main/cahracter_set fix(mtr):mv myisam error mtr-test to test/main/myisam fix(mtr):add optimizer_switch to include/default_mysqld.cnf * fix(mtr):fix main mtr optimizer_switch amd mv some test to test/main Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com>
xiaoguangye
pushed a commit
to xiaoguangye/stonedb
that referenced
this issue
Aug 5, 2022
# This is the 1st commit message: rich doc to fix env dependence "not found" (stoneatom#316) # This is the commit message #2: fix(mtr): make the mtr passed (stoneatom#315) (stoneatom#317) [summary] How to run: ./mysql-test-run.pl --suite=stonedb --nowarnings --force --nocheck-testcases 1. test cases below are failed, we ignored them first: issue410 issue415 issue433 issue446 issue515 load.test 2. Sys variables next are not set correctly, they should be added to `/mysql-test/include/default_mysqld.cnf`. stonedb_insert_delayed = 0 stonedb_ini_allowmysqlquerypath=1 3.check-testcases: A new MTR option to enforce strict cleanup: https://dev.mysql.com/blog-archive/fail-check-testcases-a-new-mtr-option-to-enforce-strict-cleanup In `mtr` comment: ``` Some options that control enabling a feature for normal test runs, can be turned off by prepending 'no' to the option, e.g. --notimer. This applies to reorder, timer, check-testcases and warnings. ``` Currently we turn off it first to make mtr run success. Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com> # This is the commit message #3: feat(stonedb): update the copyright date time (stoneatom#321) (stoneatom#324) # This is the commit message #4: fix(core): fix crash when executing sql. (stoneatom#327) (stoneatom#328) Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com> # This is the commit message #5: feat(index): Unified class member variable name with google style (stoneatom#311) (stoneatom#312) [summary] Class member name will be like: class TableInfo { ... private: std::string table_name_; // OK - underscore at end. static Pool<TableInfo>* pool_; // OK. }; Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com> # This is the commit message #6: fix(mtr):move character_set to test.character_set, fix main mtr_test and innodb mtr_test(stoneatom#277) (stoneatom#335) * fix(mtr):fix innodb mtr and mv some test to test/innodb * fix(mtr):move character_set to test/main/ fix(mtr):mv main mtr character_set test to test/main/cahracter_set fix(mtr):mv myisam error mtr-test to test/main/myisam fix(mtr):add optimizer_switch to include/default_mysqld.cnf * fix(mtr):fix main mtr optimizer_switch amd mv some test to test/main Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com>
xiaoguangye
added a commit
to xiaoguangye/stonedb
that referenced
this issue
Aug 5, 2022
# This is the 1st commit message: rich doc to fix env dependence "not found" (stoneatom#316) # This is the commit message #2: fix(mtr): make the mtr passed (stoneatom#315) (stoneatom#317) [summary] How to run: ./mysql-test-run.pl --suite=stonedb --nowarnings --force --nocheck-testcases 1. test cases below are failed, we ignored them first: issue410 issue415 issue433 issue446 issue515 load.test 2. Sys variables next are not set correctly, they should be added to `/mysql-test/include/default_mysqld.cnf`. stonedb_insert_delayed = 0 stonedb_ini_allowmysqlquerypath=1 3.check-testcases: A new MTR option to enforce strict cleanup: https://dev.mysql.com/blog-archive/fail-check-testcases-a-new-mtr-option-to-enforce-strict-cleanup In `mtr` comment: ``` Some options that control enabling a feature for normal test runs, can be turned off by prepending 'no' to the option, e.g. --notimer. This applies to reorder, timer, check-testcases and warnings. ``` Currently we turn off it first to make mtr run success. Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com> # This is the commit message #3: feat(stonedb): update the copyright date time (stoneatom#321) (stoneatom#324) # This is the commit message #4: fix(core): fix crash when executing sql. (stoneatom#327) (stoneatom#328) Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com> # This is the commit message #5: feat(index): Unified class member variable name with google style (stoneatom#311) (stoneatom#312) [summary] Class member name will be like: class TableInfo { ... private: std::string table_name_; // OK - underscore at end. static Pool<TableInfo>* pool_; // OK. }; Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com> # This is the commit message #6: fix(mtr):move character_set to test.character_set, fix main mtr_test and innodb mtr_test(stoneatom#277) (stoneatom#335) * fix(mtr):fix innodb mtr and mv some test to test/innodb * fix(mtr):move character_set to test/main/ fix(mtr):mv main mtr character_set test to test/main/cahracter_set fix(mtr):mv myisam error mtr-test to test/main/myisam fix(mtr):add optimizer_switch to include/default_mysqld.cnf * fix(mtr):fix main mtr optimizer_switch amd mv some test to test/main Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com> # This is the commit message #7: feat(tianmu): stonedb namespace to tianmu (stoneatom#337) [summary] 1. Change all engine stonedb to tianmu 2. Change SDB to tianmu 3. Also include mysql-test 4. Change file magic number to TianmuTB # This is the commit message stoneatom#8: fix bugs of stoneatom#309 and stoneatom#310 (stoneatom#313) Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com>
xiaoguangye
added a commit
to xiaoguangye/stonedb
that referenced
this issue
Aug 10, 2022
# This is the 1st commit message: fix(core): Double prepare on lex unit for cts with union(stoneatom#226) fix(core): MTR + Double prepare on lex unit for ctas with union(stoneatom#226) # This is the commit message #2: rich doc to fix env dependence "not found" (stoneatom#316) # This is the commit message #3: fix(mtr): make the mtr passed (stoneatom#315) (stoneatom#317) [summary] How to run: ./mysql-test-run.pl --suite=stonedb --nowarnings --force --nocheck-testcases 1. test cases below are failed, we ignored them first: issue410 issue415 issue433 issue446 issue515 load.test 2. Sys variables next are not set correctly, they should be added to `/mysql-test/include/default_mysqld.cnf`. stonedb_insert_delayed = 0 stonedb_ini_allowmysqlquerypath=1 3.check-testcases: A new MTR option to enforce strict cleanup: https://dev.mysql.com/blog-archive/fail-check-testcases-a-new-mtr-option-to-enforce-strict-cleanup In `mtr` comment: ``` Some options that control enabling a feature for normal test runs, can be turned off by prepending 'no' to the option, e.g. --notimer. This applies to reorder, timer, check-testcases and warnings. ``` Currently we turn off it first to make mtr run success. Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com> # This is the commit message #4: feat(stonedb): update the copyright date time (stoneatom#321) (stoneatom#324) # This is the commit message #5: fix(core): fix crash when executing sql. (stoneatom#327) (stoneatom#328) Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com> # This is the commit message #6: feat(index): Unified class member variable name with google style (stoneatom#311) (stoneatom#312) [summary] Class member name will be like: class TableInfo { ... private: std::string table_name_; // OK - underscore at end. static Pool<TableInfo>* pool_; // OK. }; Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com> # This is the commit message #7: fix(mtr):move character_set to test.character_set, fix main mtr_test and innodb mtr_test(stoneatom#277) (stoneatom#335) * fix(mtr):fix innodb mtr and mv some test to test/innodb * fix(mtr):move character_set to test/main/ fix(mtr):mv main mtr character_set test to test/main/cahracter_set fix(mtr):mv myisam error mtr-test to test/main/myisam fix(mtr):add optimizer_switch to include/default_mysqld.cnf * fix(mtr):fix main mtr optimizer_switch amd mv some test to test/main Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com>
xiaoguangye
pushed a commit
to xiaoguangye/stonedb
that referenced
this issue
Aug 11, 2022
…and innodb mtr_test(stoneatom#277) (stoneatom#335) * fix(mtr):fix innodb mtr and mv some test to test/innodb * fix(mtr):move character_set to test/main/ fix(mtr):mv main mtr character_set test to test/main/cahracter_set fix(mtr):mv myisam error mtr-test to test/main/myisam fix(mtr):add optimizer_switch to include/default_mysqld.cnf * fix(mtr):fix main mtr optimizer_switch amd mv some test to test/main Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com>
xiaoguangye
added a commit
to xiaoguangye/stonedb
that referenced
this issue
Aug 11, 2022
# This is the 1st commit message: fix(core): Double prepare on lex unit for cts with union(stoneatom#226) fix(core): MTR + Double prepare on lex unit for ctas with union(stoneatom#226) # This is the commit message #2: rich doc to fix env dependence "not found" (stoneatom#316) # This is the commit message #3: fix(mtr): make the mtr passed (stoneatom#315) (stoneatom#317) [summary] How to run: ./mysql-test-run.pl --suite=stonedb --nowarnings --force --nocheck-testcases 1. test cases below are failed, we ignored them first: issue410 issue415 issue433 issue446 issue515 load.test 2. Sys variables next are not set correctly, they should be added to `/mysql-test/include/default_mysqld.cnf`. stonedb_insert_delayed = 0 stonedb_ini_allowmysqlquerypath=1 3.check-testcases: A new MTR option to enforce strict cleanup: https://dev.mysql.com/blog-archive/fail-check-testcases-a-new-mtr-option-to-enforce-strict-cleanup In `mtr` comment: ``` Some options that control enabling a feature for normal test runs, can be turned off by prepending 'no' to the option, e.g. --notimer. This applies to reorder, timer, check-testcases and warnings. ``` Currently we turn off it first to make mtr run success. Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com> # This is the commit message #4: feat(stonedb): update the copyright date time (stoneatom#321) (stoneatom#324) # This is the commit message #5: fix(core): fix crash when executing sql. (stoneatom#327) (stoneatom#328) Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com> # This is the commit message #6: feat(index): Unified class member variable name with google style (stoneatom#311) (stoneatom#312) [summary] Class member name will be like: class TableInfo { ... private: std::string table_name_; // OK - underscore at end. static Pool<TableInfo>* pool_; // OK. }; Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com> # This is the commit message #7: fix(mtr):move character_set to test.character_set, fix main mtr_test and innodb mtr_test(stoneatom#277) (stoneatom#335) * fix(mtr):fix innodb mtr and mv some test to test/innodb * fix(mtr):move character_set to test/main/ fix(mtr):mv main mtr character_set test to test/main/cahracter_set fix(mtr):mv myisam error mtr-test to test/main/myisam fix(mtr):add optimizer_switch to include/default_mysqld.cnf * fix(mtr):fix main mtr optimizer_switch amd mv some test to test/main Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com>
xiaoguangye
pushed a commit
to xiaoguangye/stonedb
that referenced
this issue
Aug 11, 2022
…and innodb mtr_test(stoneatom#277) (stoneatom#335) * fix(mtr):fix innodb mtr and mv some test to test/innodb * fix(mtr):move character_set to test/main/ fix(mtr):mv main mtr character_set test to test/main/cahracter_set fix(mtr):mv myisam error mtr-test to test/main/myisam fix(mtr):add optimizer_switch to include/default_mysqld.cnf * fix(mtr):fix main mtr optimizer_switch amd mv some test to test/main Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com>
xiaoguangye
added a commit
to xiaoguangye/stonedb
that referenced
this issue
Aug 11, 2022
fix(core): MTR + Double prepare on lex unit for ctas with union(stoneatom#226) rich doc to fix env dependence "not found" (stoneatom#316) fix(mtr): make the mtr passed (stoneatom#315) (stoneatom#317) [summary] How to run: ./mysql-test-run.pl --suite=stonedb --nowarnings --force --nocheck-testcases 1. test cases below are failed, we ignored them first: issue410 issue415 issue433 issue446 issue515 load.test 2. Sys variables next are not set correctly, they should be added to `/mysql-test/include/default_mysqld.cnf`. stonedb_insert_delayed = 0 stonedb_ini_allowmysqlquerypath=1 3.check-testcases: A new MTR option to enforce strict cleanup: https://dev.mysql.com/blog-archive/fail-check-testcases-a-new-mtr-option-to-enforce-strict-cleanup In `mtr` comment: ``` Some options that control enabling a feature for normal test runs, can be turned off by prepending 'no' to the option, e.g. --notimer. This applies to reorder, timer, check-testcases and warnings. ``` Currently we turn off it first to make mtr run success. Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com> feat(stonedb): update the copyright date time (stoneatom#321) (stoneatom#324) fix(core): fix crash when executing sql. (stoneatom#327) (stoneatom#328) Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com> feat(index): Unified class member variable name with google style (stoneatom#311) (stoneatom#312) [summary] Class member name will be like: class TableInfo { ... private: std::string table_name_; // OK - underscore at end. static Pool<TableInfo>* pool_; // OK. }; Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com> fix(mtr):move character_set to test.character_set, fix main mtr_test and innodb mtr_test(stoneatom#277) (stoneatom#335) * fix(mtr):fix innodb mtr and mv some test to test/innodb * fix(mtr):move character_set to test/main/ fix(mtr):mv main mtr character_set test to test/main/cahracter_set fix(mtr):mv myisam error mtr-test to test/main/myisam fix(mtr):add optimizer_switch to include/default_mysqld.cnf * fix(mtr):fix main mtr optimizer_switch amd mv some test to test/main Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com> fix(mtr): Add more ctas queries for the same bug-fix from code-analysis perspectives(stoneatom#226) fix bugs of stoneatom#309 and stoneatom#310 (stoneatom#313) Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com> fix(core): Double prepare on lex unit for cts with union(stoneatom#226) (stoneatom#365) fix(core): MTR + Double prepare on lex unit for ctas with union(stoneatom#226) fix(mtr):mtr result stonedb change to tianmu(stoneatom#359) (stoneatom#368) * fix(mtr):mysqlpump*.test sys_stoendb to sys_tianmu fix(mtr):fix main result stonedb to tianmu fix(mtr):mv innodb_fts.ngram_1 to test/innodb_fts fix(mtr):fix mtr funcs_1 stonedb to tianmu fix(mtr):fix innodb mtr result stonedb change to tianmu fix(mtr):fix perfschema mtr result stonedb change to tianmu * fix(mtr):fix mtr stoendb change to tianmu Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com> fix(tianmu): fix group_concat_max_len warning (stoneatom#338) (stoneatom#363) Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com> docs(stonedb): update docs and fix bugs (stoneatom#373) * docs(Quick Deployment and Compiling Methods): update docs Make the document more user-friendly for new users * fix(docs): Let the official website pictures can be adaptive * Update compile-using-ubuntu2004.md In the install make step, add the go to directory:cd make-3.82 * Update compile-using-redhat7.md In the install make step, add the go to directory:cd make-3.82 * Update compile-using-centos7.md In the install make step, add the go to directory:cd make-3.82 Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com> Co-authored-by: haitaoguan <[email protected]> feat(doc):doc add innodb backup to stonedb demonstrate(stoneatom#353) (stoneatom#355) * feat(doc):doc add innodb backup to stonedb demonstrate * fix(doc):fix mydumper and mysqldump doc Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com> feat(innodb): To support compiling innodb as C++ 17(stoneatom#375) (stoneatom#376) To support innodb is compiled as C++ 17. For now, tianmu is compiling as C++17, and C++17 has became mainstream of C++ standard. Therefore, now, we star to support to compile Innodb as C++17 in stonedb. This is backport from MySQL, which commit id is: 1a8a111d8f855a31d0aeffc8f02309b2b82dd410 and bug# is #32907274 Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com> fix stonedb for optimize exists subquery and deep memory copy stoneatom#369 (stoneatom#330, stoneatom#329, stoneatom#340, stoneatom#332) (stoneatom#369) * fix stonedb for optimize exists subquery and deep memcopy copy * Update parameterized_filter.cpp fix ParameterizedFilter deep copy mind memory leak * fix subquery when this is in sql * fix code readability and defensive * use shallow memory when paral hash join by class DimensionGroupMultiMaterialized Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com> feat(stonedb): To support gcc 9 and adds `WITH_ROCKSDB` and `WITH_MARISA` to specify where (stoneatom#377) rocksdb and marisa installed, respectively. Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com> fix(mtr): Add test cases for NULL value select on UNIQUE constraint(stoneatom#281) (stoneatom#379) * fix(core): Double prepare on lex unit for cts with union(stoneatom#226) fix(core): MTR + Double prepare on lex unit for ctas with union(stoneatom#226) * fix(mtr): Add test cases for NULL value select on UNIQUE constraint(stoneatom#281) Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com> fix bug stoneatom#342 (stoneatom#346) Co-authored-by: dfx <duanfuxiang> Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com> Doc(stonedb): Added extensions deccriptions in topics related to backup and recovery for O&M Guide(stoneatom#360) (stoneatom#361) * updated some code snippets in Install RocksDB step Signed-off-by: xuejiao-joy <[email protected]> * some description here Signed-off-by: xuejiao-joy <[email protected]> Co-authored-by: Yuting <[email protected]> Co-authored-by: mergify[bot] <37929162+mergify[bot]@users.noreply.github.com> fix(mtr): Add more ctas queries for the same bug-fix from code-analysis perspectives(stoneatom#226)
15 tasks
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Describe the problem
StoneDB MTR suite=main Completed: Failed 45/780 tests, 94.23% were successful.
Failing test(s): main.derived main.myisam_explain_json_non_select_all main.insert main.join_outer_bka main.partition_locking main.query_cache_type_functionality main.gis main.mysqlpump_basic main.sort_buffer_size_functionality main.join_cache_nojb main.table_definition_cache_functionality main.mysqld_daemon main.table_open_cache_functionality main.events_1 main.join_cache_bka main.index_merge_myisam main.ssl_crl main.mysql_plugin main.mysqld_safe main.heap main.innodb_log_file_size_functionality main.opt_hints_subquery main.myisampack main.gis-precise main.information_schema main.myisam main.filter_single_col_idx_small main.grant_user_lock main.func_gconcat main.myisam_explain_json_non_select_none main.join_cache_bnl main.group_by_fd_no_prot main.query_cache_size_functionality main.mysqlpump_bugs main.filter_single_col_idx_big main.join_outer_bka_nixbnl main.optimizer_switch main.mysqlpump_extended main.ssl_ca main.join_cache_bka_nixbnl main.create main.mysqldump main.group_by main.mysql_client_test main.query_cache
StoneDB MTR suite=innodb
Completed: Failed 12/215 tests, 94.42% were successful.
Failing test(s): innodb.log_file innodb.log_file_name innodb.innodb_page_size_func innodb.innodb-wl5980-linux innodb.innodb-system-table-view innodb.optimizer_temporary_table innodb.log_file_size_1 innodb.alter_kill innodb.log_corruption innodb.partition-upgrade innodb.innodb-wl6445-2 innodb.tablespace_portability
Expected behavior
Completed: All X tests were successful.
How To Reproduce
./mtr --suite=main--force --max-test-fail=0 --retry=0
./mtr --suite=innodb --force --max-test-fail=0 --retry=0
Environment
Are you interested in submitting a PR to solve the problem?
The text was updated successfully, but these errors were encountered: