summaryrefslogtreecommitdiff
path: root/mysql-test/r/mysql_upgrade.result
Commit message (Collapse)AuthorAgeFilesLines
* MDEV-13274 mysql_upgrade fails if dbname+tablename+partioname > 64 charsSergei Golubchik2017-07-201-1/+22
| | | | | | InnoDB fix will come in MDEV-13360. Here I just fix upgrades from old unfixed InnoDBs - bad data makes the following copying ALTER TABLE to fail.
* Merge branch '5.5' into 10.0Sergei Golubchik2015-12-131-1/+8
|\
| * Merge branch 'mysql/5.5' into 5.5Sergei Golubchik2015-12-091-0/+7
| |\
| | * DESCRIPTIONShishir Jaiswal2015-10-291-1/+7
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | =========== When doing an upgrade, you execute mysql_upgrade. If mysql_upgrade fails to connect or it connects with a user without the proper privileges, it will return the error: FATAL ERROR: Upgrade failed which is not very informative. ANALYSIS ======== In main() and check_version_match(), the condition for errors are clubbed together and throw the same error msg. The functions need to be splitted up and the corresponding error msgs have to be displayed. FIX === Splitted the functions and added the specific error msg.
| | * Bug#11827359 60223: MYSQL_UPGRADE PROBLEM WITHNirbhay Choubey2011-11-151-0/+33
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | OPTION SKIP-WRITE-BINLOG System tables were not getting upgraded when mysql_upgrade was run with --skip-write-binlog option. (Same for --write-binlog.) Also, with this option, mysql_upgrade_info file was not getting created after the upgrade. mysql_upgrade makes use of mysql client tool in order to run upgrade scripts, while doing so it passes some of the command line options (used to start mysql_upgrade) directly to mysql client. The reason behind this bug being, some options like skip-write-binlog and upgrade-system-tables were being passed to mysql tool along with other options, and hence mysql execution failed due presence of these invalid options. Fixed this issue by filtering out the above mentioned options from the list of options that will be passed to mysql and mysqlcheck tools. However, since --write-binlog is supported by mysqlcheck, this option would be used explicitly while running mysqlcheck. (not part of patch, already there) Checking the contents of general log after the upgrade is not doable via an mtr test. So performed manual test. Added a test to verify the creation of mysql_upgrade_info.
| | * Bug #57916: Fix the naming of the proxy_priv tableGeorgi Kodinov2010-11-021-6/+6
| | | | | | | | | | | | | | | | | | | | | | | | 1. Fixed the name of the table to proxies_priv 2. Fixed the column names to be of the form Capitalized_lowecarse instead of Capitalized_Capitalized 3. Added Timestamp and Grantor columns 4. Added tests to plugin_auth to check the table structure 5. Updated the existing tests
| | * mergeGeorgi Kodinov2010-10-041-36/+12
| | |\
| | | * Bug #56494 Segfault in upgrade_shared_lock_to_exclusive() forJon Olav Hauglid2010-09-221-36/+12
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | REPAIR of merge table Bug #56422 CHECK TABLE run when the table is locked reports corruption along with timeout The crash happened if a table maintenance statement (ANALYZE TABLE, REPAIR TABLE, etc.) was executed on a MERGE table and opening and locking a child table failed. This could for example happen if a child table did not exist or if a lock timeout happened while waiting for a conflicting metadata lock to disappear. Since opening and locking the MERGE table and its children failed, the tables would be closed and the metadata locks released. However, TABLE_LIST::table for the MERGE table would still be set, with its value invalid since the tables had been closed. This caused the table maintenance statement to try to continue and upgrade the metadata lock on the MERGE table. But since the lock already had been released, this caused a segfault. This patch fixes the problem by setting TABLE_LIST::table to NULL if open_and_lock_tables() fails. This prevents maintenance statements from continuing and trying to upgrade the metadata lock. The patch includes a 5.5 version of the fix for Bug #46339 crash on REPAIR TABLE merge table USE_FRM. This bug caused REPAIR TABLE ... USE_FRM to give an assert when used on merge tables. The patch also enables the CHECK TABLE statement for log tables. Before, CHECK TABLE for log tables gave ER_CANT_LOCK_LOG_TABLE, yet still counted the statement as successfully executed. With the changes to table maintenance statement error handling in this patch, CHECK TABLE would no longer be considered as successful in this case. This would have caused upgrade scripts to mistakenly think that the general and slow logs are corrupted and have to be repaired. Enabling CHECK TABLES for log tables prevents this from happening. Finally, the patch changes the error message from "Corrupt" to "Operation failed" for a number of issues not related to table corruption. For example "Lock wait timeout exceeded" and "Deadlock found trying to get lock". Test cases added to merge.test and check.test.
| | * | WL#1054: Pluggable authentication supportGeorgi Kodinov2010-08-091-0/+6
| | |/ | | | | | | | | | Merged the implementation to a new base tree.
| | * mergeGeorgi Kodinov2010-07-051-0/+42
| | |\
| | | * Bug #53613: mysql_upgrade incorrectly revokes TRIGGER privilege on given tableGeorgi Kodinov2010-07-011-0/+42
| | | | | | | | | | | | | | | | | | | | | | | | Fixed an incomplete historical ALTER TABLE MODIFY trimming the trigger privilege bit from mysql.tables_priv.Table_priv column. Removed the duplicate ALTER TABLE MODIFY. Test suite added.
| | * | Manual merge of mysql-5.1-bugteam into mysql-trunk-merge.Alexey Kopytov2009-12-111-0/+42
| | |\ \ | | | |/
| | | * Bug#41569: mysql_upgrade (ver 5.1) add 3 fields to mysql.proc table but does ↵Davi Arnaut2009-12-041-3/+3
| | | | | | | | | | | | | | | | | | | | | | | | not set values Post-merge fix: Redirect stderr to a file as to avoid buffering problems due to redirecting stderr to stdout.
| | | * This is a patch for bug#41569.lars-erik.bjork@sun.com2009-12-031-0/+42
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | "mysql_upgrade (ver 5.1) add 3 fields to mysql.proc table but does not set values". mysql_upgrade (ver 5.1) adds 3 fields (character_set_client, collation_connection and db_collation) to the mysql.proc table, but does not set any values. When we run stored procedures, which were created with mysql 5.0, a warning is logged into the error log. The solution to this is for mysql_upgrade to set default best guess values for these fields. A warning is also written during upgrade, to make the user aware that default values are set.
| | * | mysql_upgrade test fixedAlexey Botchkov2009-10-291-3/+0
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | per-file comments: mysql-test/r/mysql_upgrade.result result updated mysql-test/t/mysql_upgrade.test --skip-verbose option added to the call
| | * | WL#4991 mysql_upgrade --fix-privilege-tablesAlexey Botchkov2009-10-281-0/+4
| | |/ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | (backport) mysql_upgrade script accepts --upgrade-system-tables option, fixing only system tables in this case. per-file comments: client/mysql_upgrade.c WL#4991 mysql_upgrade --fix-privilege-tables --upgrade-system-tables option added. if it is set, the tool won't look for the mysqlcheck then run_mysqlcheck_fixnames() and run_mysqlcheck_upgrade won't be called. mysql-test/r/mysql_upgrade.result WL#4991 mysql_upgrade --fix-privilege-tables test result added mysql-test/t/mysql_upgrade.test WL#4991 mysql_upgrade --fix-privilege-tables test case added
| | * WL#4189 mtr.pl v2Magnus Svensson2009-01-261-4/+0
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | - rewrite "check warnings" to be faster by not creating a full join between error_log and suspicious_patterns while running REGEXP. Instead add a column to error_log that will be set to 1 to indicate a warning and run the 6 REGEXP's we have for suspicious lines as 6 separate full table scans. - Remove the "suspicious_patterns" table from mtr db - Use 'xykls37' as separator when loading the error log, that line should hopefully never exist in a line that should be a warning
| | * merging 5.1 -> 5.1 rpl. 3 of 4 conflicts are resolved similarly to ↵Andrei Elkin2008-11-121-1/+1
| | |\ | | | | | | | | | | | | | | | | 6.0->6.0-rpl merging. mysql_upgrade results changed due to the error messesge of mysqlcheck has changed.
| | * | Fixing result file for mysql_upgrade test.Mats Kindahl2008-10-301-8/+8
| | | |
| | * | Post-merge fixes to fix test cases.Mats Kindahl2008-10-291-9/+9
| | | |
| | * | BUG#39853: lowercase_table3 fails on powermacg5 in rpl treeSven Sandberg2008-10-131-8/+8
| | | | | | | | | | | | | | | | | | | | | | | | Problem: during a refactoring of mtr, a pattern for suppressing a warning from lowercase_table3 was lost. Fix: re-introduce the suppression. Problem 2: suppression was misspelt as supression. Fixed by adding a p.
| | * | Check warnings in servers error log as part of test casemsvensson@pilot.mysql.com2008-04-081-0/+12
| | |/
| | * Bug#30487 mysql_upgrade reports misleading errorsmsvensson@pilot.(none)2007-08-271-8/+24
| | | | | | | | | | | | | | | - Update result file to include these "misleading errors", better to run mysql_upgrade with them than not at all.
| | * Bug#28401 mysql_upgrade Failed with STRICT_ALL_TABLES, ANSI_QUOTES and ↵msvensson@pilot.blaudden2007-05-191-0/+6
| | | | | | | | | | | | | | | | | | NO_ZERO_DATE - Upgrade result file for 5.1
| | * Merge pilot.blaudden:/home/msvensson/mysql/bug28401/my50-bug28401msvensson@pilot.blaudden2007-05-191-0/+19
| | |\ | | | | | | | | | | | | into pilot.blaudden:/home/msvensson/mysql/bug28401/my51-bug28401
| | | * Bug #28401 mysql_upgrade Failed with STRICT_ALL_TABLES, ANSI_QUOTES and ↵msvensson@pilot.blaudden2007-05-191-0/+19
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | NO_ZERO_DATE - The SQL commands used by mysql_upgrade are written to be run with sql_mode set to '' - thus the scripts should change sql_mode for the session to make sure the SQL is legal.
| | * | Merge pilot.blaudden:/home/msvensson/mysql/mysql-5.0-maintmsvensson@pilot.blaudden2007-04-191-1/+1
| | |\ \ | | | |/ | | | | | | | | into pilot.blaudden:/home/msvensson/mysql/mysql-5.1-maint
| | | * Add replace for varying errnomsvensson@pilot.blaudden2007-04-191-1/+1
| | | |
| | * | Merge pilot.blaudden:/home/msvensson/mysql/mysql-5.0-maintmsvensson@pilot.blaudden2007-04-191-1/+1
| | |\ \ | | | |/ | | | | | | | | into pilot.blaudden:/home/msvensson/mysql/mysql-5.1-maint
| | | * mysql_upgrade portability fixesmsvensson@pilot.blaudden2007-04-191-1/+1
| | | |
| | * | Update mysql_upgrade tests for 5.1msvensson@pilot.blaudden2007-04-181-0/+18
| | |/ | | | | | | | | | | | | | | | Add "two liner" to mysqld --bootstrap that allows wo write scripts that can be run both by mysql and mysqld --bootstrap Remove duplicate create of MySQL system tables
| | * Bug#25452 mysql_upgrade access deniedmsvensson@pilot.blaudden2007-04-181-61/+26
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | - Improve mysql_upgrade and add comments describing it's logic - Don't look for mysql and mysqlcheck randomly, use dir where mysql_upgrade was started from - Don't look for mysql_fix_privilege_tables.sql randomly, compile in the mysql_fix_privilege_tables.sql file and use that to upgrade the system tables of MySQL - Check for any unexpected error returned from runnning the mysql_fix_privilege_tables SQL - Fix bug#26639, bug#24248 and bug#25405
| | * Bug#20166 mysql-test-run.pl does not test system privilege tables creationmsvensson@pilot.blaudden2007-02-261-30/+0
| | | | | | | | | | | | | | | | | | - Use mysql_system_tables.sql to create MySQL system tables in all places where we create them(mysql_install_db, mysql-test-run-pl and mysql_fix_privilege_tables.sql)
| | * Make it possible for .test suites to run "mysql_upgrade"msvensson@neptunus.(none)2006-11-131-0/+127
| | | | | | | | Add new test file mysql_upgrade.test
| * mysql_upgrade cleanupSergei Golubchik2015-12-081-1/+1
| |
* | Merge branch '5.5' into 10.0Sergei Golubchik2015-05-041-43/+54
|\ \ | |/
| * post-merge fixesSergei Golubchik2015-04-291-9/+12
| |
| * mysqlcheck fix-view-algorithm -> upgrade-viewsDaniel Black2015-04-141-8/+8
| | | | | | | | | | | | | | | | Change mysqlcheck option to upgrade-views={NO,YES,FROM_MYSQL} mysql_upgrade now runs upgrade-views=yes to perform a checksum of all views and add mariadb-version by default. upgrade-views=from_mysql if MySQL is detected as teh origin version.
| * correct phase numbering in test resultsDaniel Black2015-04-131-25/+33
| |
| * MDEV-6178 mysql_upgrade breaks databases with long user namesElena Stepanova2014-04-281-0/+83
| | | | | | | | | | | | Added a 5.5-specific test which involves manual modification of system tables. The problem itself was fixed in MDEV-6068
* | MDEV-6984 Can't migrate from MySQL 5.6.21 to MariaDB 10Sergei Golubchik2014-11-191-34/+43
| | | | | | | | | | | | | | | | in mysql_upgrade: do FLUSH PRIVILEGES at the end, not together with mysql_fix_privilege_tables mysql-test/t/mysql_upgrade-6984.opt: use a dummy second option to force server restart after the test
* | If one uses 3 --verbose options to mysql_upgrade or mysqlcheck one will now ↵Michael Widenius2014-08-141-25/+34
| | | | | | | | | | | | | | | | | | | | | | | | | | | | get on stdout all ALTER, RENAME and CHECK commands that mysqlcheck executes. If one uses 4 --verbose to mysql_upgrade it will also write out all mysqlcheck commands invoked. mysql-test/r/mysql_upgrade.result: Updated results from changing phases mysql-test/r/mysql_upgrade_no_innodb.result: dated results from changing phases mysql-test/r/mysql_upgrade_ssl.result: dated results from changing phases
* | MDEV-6535 Ordering of mysql_upgrade tasks is not optimalSergei Golubchik2014-08-061-58/+96
| | | | | | | | first update system tables, then the rest
* | MDEV-6178 mysql_upgrade breaks databases with long user namesElena Stepanova2014-04-281-0/+61
| | | | | | | | | | Added a test, the problem itself was fixed in MDEV-6068
* | 10.0-base mergeSergei Golubchik2014-02-031-0/+3
|\ \
| * \ 5.5 mergeSergei Golubchik2014-02-011-0/+3
| |\ \ | | |/
| | * Fix for MDEV-5547: Bad error message when moving very old .frm files to ↵Michael Widenius2014-01-221-0/+3
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | MariaDB 5.5. mysql_upgrade --help now also prints out --default options and variable values. mysql_upgrade now prints permission errors. mysql_upgrade doesn't print some non essential info if --silent is used. Added handler error message about incompatible versions Fixed that mysqlbug and mysql_install_db have the executable flag set. Removed executable flag for some non executable files. Changed in mysql_install_db askmonty.org to mariadb.com. Ensured that all client executables prints --default options the same way. Allow REPAIR ... USE_FRM for old .frm files if the are still compatible. Extended shown error for storage engine messages. client/mysql.cc: print_defaults() should be first (as in all other programs) client/mysql_upgrade.c: --help now also prints out --default options and variable values Print out error if wrong permissions Don't print info if --silent client/mysqladmin.cc: print_defaults() should be first (as in all other programs) client/mysqlbinlog.cc: Added print_defaults() to --help client/mysqlcheck.c: Added empty line in --help client/mysqlimport.c: Added empty line in --help client/mysqlshow.c: Made --help compatible client/mysqlslap.c: Made --help compatible client/mysqltest.cc: Added print_defaults() to --help include/handler_ername.h: Added handler error message include/my_base.h: Added handler error message mysql-test/r/mysql_upgrade.result: Updated results mysql-test/r/repair.result: Added test case for better error messages mysql-test/std_data/host_old.MYD: Added test case for better error messages mysql-test/std_data/host_old.MYI: Added test case for better error messages mysql-test/std_data/host_old.frm: Added test case for better error messages mysql-test/t/repair.test: Added test case for better error messages mysys/my_handler_errors.h: Added handler error message scripts/CMakeLists.txt: Fixed that mysqlbug and mysql_install_db have the executable flag set scripts/mysql_install_db.sh: askmonty.org -> mariadb.com sql/ha_partition.cc: Sometimes table_type() can be called for errors even if partition didn't manage to open any files sql/handler.cc: Write clear text for not handled, but defined error messages. sql/share/errmsg-utf8.txt: Extended shown error for storage engine messages sql/sql_admin.cc: Allow REPAIR ... USE_FRM for old .frm files if the are still compatible storage/myisam/ha_myisam.cc: Use new error message
* | | 10.0-base merge (roles)Sergei Golubchik2013-10-291-0/+7
|\ \ \ | |/ /
| * | Fixes for mysql-test failuresSergei Golubchik2013-10-181-0/+7
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | mysql-test/r/acl_roles_show_grants.result: one can do SHOW GRANTS for himself mysql-test/t/acl_roles_set_role-table-column-priv.test: correct error message mysql-test/t/acl_roles_show_grants.test: one can SHOW GRANTS for himself sql/sql_acl.cc: bugfixing: * don't assign with && - it can shortcut and the second assignment won't be executed * correct the test in check_grant_all_columns() - want_access should not be modified * sql/sql_cmd.h.OTHER: add new commands at the end sql/sql_db.cc: don't call acl_get() if all privileges are already satisfied (crashes when run with --skip-grants, because acl data stuctures aren't initialized) sql/sql_parse.cc: * test for current_user in get_current_user() * map explicitly specified user@host to current_user
* | | 10.0-monty mergeSergei Golubchik2013-07-211-28/+0
|\ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | includes: * remove some remnants of "Bug#14521864: MYSQL 5.1 TO 5.5 BUGS PARTITIONING" * introduce LOCK_share, now LOCK_ha_data is strictly for engines * rea_create_table() always creates .par file (even in "frm-only" mode) * fix a 5.6 bug, temp file leak on dummy ALTER TABLE
View Lorry Controller Status