| 1 |
# Testcase for the following bugs |
| 2 |
# Bug#16691130 - ASSERT WHEN INNODB_LOG_GROUP_HOME_DIR DOES NOT EXIST |
| 3 |
# Bug#16418661 - CHANGING NAME IN FOR INNODB_DATA_FILE_PATH SHOULD NOT SUCCEED WITH LOG FILES |
| 4 |
# Write tmp/log_file/my.cnf |
| 5 |
# Start mysqld without the possibility to create undo tablespaces |
| 6 |
# because a directory exists named 'undo_002'. |
| 7 |
Pattern "\[ERROR\] .*MY-\d+.* File .*ibdata1: 'open' returned OS error 71. Cannot continue operation" found |
| 8 |
auto.cnf |
| 9 |
undo_002 |
| 10 |
# Start mysqld to create tablespaces according to my.cnf |
| 11 |
# Backup the datadir |
| 12 |
# 1. Start mysqld with non existent innodb_log_group_home_dir |
| 13 |
Pattern "\[ERROR\] .* Failed to list redo log files in the redo log directory .path.to.non-existent" found |
| 14 |
Pattern "\[ERROR\] .* Aborting" found |
| 15 |
# 2. Start mysqld without ibdata1 |
| 16 |
Pattern "\[ERROR\] .* File .*ibdata1: 'open' returned OS error 71. Cannot continue operation" found |
| 17 |
# 3. Start mysqld without ibdata2 |
| 18 |
Pattern "\[ERROR\] .* Tablespace size stored in header is \d+ pages, but" found |
| 19 |
Pattern "\[ERROR\] .* Aborting" found |
| 20 |
# 4. Start mysqld without ibdata1 & ibdata2 |
| 21 |
Pattern "\[ERROR\] .* File .*ibdata1: 'open' returned OS error 71. Cannot continue operation" found |
| 22 |
# 5. Start mysqld without ibdata*, #ib_redo* and undo_00* |
| 23 |
Pattern "\[ERROR\] .* File .*ibdata1: 'open' returned OS error 71. Cannot continue operation" found |
| 24 |
# 6. Start mysqld without undo_002 |
| 25 |
Pattern "\[Note\] .* Creating UNDO Tablespace .*undo_002" found |
| 26 |
# 7. Start mysqld without undo_001, undo_002 |
| 27 |
Pattern "\[Note\] .* Creating UNDO Tablespace .*undo_001" found |
| 28 |
Pattern "\[Note\] .* Creating UNDO Tablespace .*undo_002" found |
| 29 |
# 8. Start mysqld without #ib_redo* |
| 30 |
Pattern "\[Note\] .* Apply batch completed" found |
| 31 |
# 9. Add new datafile at the end |
| 32 |
Pattern "\[Note\] .* File.*ibdata3. size is now 20 MB" found |
| 33 |
# 10. Show that --innodb-undo-directory cannot be an ancestor of the datadir |
| 34 |
Pattern "\[ERROR\] .* The innodb_undo_directory is not allowed to be an ancestor of the datadir" found |
| 35 |
# 11. Try to initialize InnoDB in directory which has log files |
| 36 |
Pattern "--initialize specified but the redo log directory .* has redo log files inside" found |
| 37 |
# 12. Rename log file after shutdown and start MySQL (should succeed) |
| 38 |
Pattern "[ERROR].*innodb-unknown-parameter-12.*" found |
| 39 |
# Cleanup |
| 40 |
# restart |