summaryrefslogtreecommitdiff
path: root/mysql-test/include/mtr_warnings.sql
Commit message (Collapse)AuthorAgeFilesLines
* Merge 10.7 into 10.8Marko Mäkelä2022-08-301-1/+1
|\
| * Merge 10.5 into 10.6Marko Mäkelä2022-08-251-1/+1
| |\
| | * update a global_suppressions() listSergei Golubchik2022-08-251-1/+1
| | | | | | | | | | | | followup for "remove invalid options from warning messages"
* | | Merge 10.7 into 10.8Marko Mäkelä2022-07-281-0/+4
|\ \ \ | |/ /
| * | Merge 10.5 into 10.6Marko Mäkelä2022-07-271-0/+4
| |\ \ | | |/
| | * MDEV-28495 InnoDB corruption due to lack of file lockingMarko Mäkelä2022-07-271-0/+4
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Starting with commit da094188f60bf67e3d90227304a4ea256fe2630f (MDEV-24393), MariaDB will no longer acquire advisory file locks on InnoDB data files by default, because it would create a large number of entries in Linux /proc/locks. The motivation for acquiring the file locks is to prevent accidental concurrent startup of multiple server processes on the same data files. Such mistake still turns out to be relatively common, based on corruption bug reports from the community. To prevent corruption due to concurrent startup attempts, the Aria storage engine would unconditionally acquire an advisory lock on one of its log files. Solution: InnoDB will always lock its system tablespace files. (Ever since commit 685d958e38b825ad9829be311f26729cccf37c46 the InnoDB log file will not necessarily be open while the server is running, because it can be accessed via memory-mapped I/O.) If more protection is desired, then the option --external-locking can be used. The mandatory advisory lock also fixes intermittent failures of some crash recovery tests. It turns out that when the mtr test harness kills and restarts the server, it will not actually ensure that the old process has terminated before starting the new one.
* | | MDEV-28866: mariadb-upgrade to 10.8 mysql.column_stats hist_type + histogram ↵Daniel Black2022-07-121-1/+0
|/ / | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | errors The incorrect type of mysql.column_stats caused the server during the upgrade of every other table to complain: [ERROR] Incorrect definition of table mysql.column_stats: expected column 'hist_type' at position 9 and expected column 'histogram' at position 10 to have type longblob. To prevent these verbose server errors, we upgrade the mysql.column_stats table first. Consequently limit "Incorrect definition of table mysql.*" to the appropriate set of limited test cases. The rpl_gtid_errorhandling.result changes the GTID number by one because of the added early suppression (adding a table row). Reviewer: Vicențiu Ciorbaru Fixes MariaDB/mariadb-docker#438
* | MDEV-22189: Change error messages inside code to have mariadb instead ofRucha Deodhar2021-05-241-2/+2
|/ | | | | | | mysql Fix: Changed error messages, rerecorded results and changed other relevant files.
* Merge 10.2 into 10.3Marko Mäkelä2019-05-141-1/+1
|\
| * Merge 10.1 into 10.2Marko Mäkelä2019-05-131-1/+1
| |\
| | * Merge branch '5.5' into 10.1Vicențiu Ciorbaru2019-05-111-1/+1
| | |\
| | | * Update FSF AddressVicențiu Ciorbaru2019-05-111-1/+1
| | | | | | | | | | | | | | | | * Update wrong zip-code
| | | * Fix too agressive long semaphore wait output and add guard against introducingJan Lindström2014-07-241-0/+1
| | | | | | | | | | | | | | | | | | | | compression failures on insert buffer.
* | | | MDEV-14429 sql_safe_updates in my.cnf not workSergei Golubchik2018-11-061-1/+1
| | | | | | | | | | | | | | | | add a test case
* | | | MDEV-12501 -- set --maturity-level by defaultVesa Pentti2017-12-091-0/+6
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | * Note: breaking change; since this commit, a plugin that has worked so far might get rejected due to plugin maturity * mariabackup is not affected (allows all plugins) * VERSION file defines SERVER_MATURITY, which defines the corresponding numeric value as SERVER_MATURITY_LEVEL in include/mysql_version.h * The default value for 'plugin_maturity' is SERVER_MATURITY_LEVEL - 1 * Logs a warning if a plugin has maturity lower than SERVER_MATURITY_LEVEL * Tests suppress the plugin maturity warning * Tests use --plugin-maturity=unknown by default so as not to fail due to the stricter plugin maturity handling
* | | | Revert "MDEV-12501 -- set --maturity-level by default"Vesa Pentti2017-12-051-6/+0
| | | | | | | | | | | | | | | | This reverts commit 1af2d7ba235305ffd4c24a47cccafd5fe6815d9e.
* | | | MDEV-12501 -- set --maturity-level by defaultVesa Pentti2017-12-041-0/+6
|/ / / | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | * Note: breaking change; since this commit, a plugin that has worked so far might get rejected due to plugin maturity * mariabackup is not affected (allows all plugins) * VERSION file defines SERVER_MATURITY, which defines the corresponding numeric value as SERVER_MATURITY_LEVEL in include/mysql_version.h * The default value for 'plugin_maturity' is SERVER_MATURITY_LEVEL - 1 * Logs a warning if a plugin has maturity lower than SERVER_MATURITY_LEVEL * Tests suppress the plugin maturity warning * Tests use --plugin-maturity=unknown by default so as not to fail due to the stricter plugin maturity handling
* | | Merge branch '10.1' into 10.2Sergei Golubchik2017-03-301-0/+1
|\ \ \ | |/ /
| * | Merge 10.0 into 10.1Marko Mäkelä2017-02-081-0/+1
| |\ \
| | * | Flush suppressions table to prevent corruption when server is killedElena Stepanova2017-02-011-0/+1
| | | |
* | | | MDEV-7660 - MySQL WL#6671 "Improve scalability by not using thr_lock.c locksSergey Vojtovich2016-11-031-8/+0
|/ / / | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | for InnoDB tables" Don't use thr_lock.c locks for InnoDB tables. Below is list of changes that were needed to implement this: - HANDLER OPEN acquireis MDL_SHARED_READ instead of MDL_SHARED - HANDLER READ calls external_lock() even if SE is not going to be locked by THR_LOCK - InnoDB lock wait timeouts are now honored which are much shorter by default than server lock wait timeouts (1 year vs 50 seconds) - with @@autocommit= 1 LOCK TABLES disables autocommit implicitely, though user still sees @@autocommt= 1 - the above starts implicit transaction - transactions started by LOCK TABLES are now rolled back on disconnect (previously everything was committed due to autocommit) - transactions started by LOCK TABLES are now rolled back by ROLLBACK (previously everything was committed due to autocommit) - it is now impossible to change BINLOG_FORMAT under LOCK TABLES (at least to statement) due to running transaction - LOCK TABLES WRITE is additionally handled by MDL - ...in contrast LOCK TABLES READ protection against DML is pure InnoDB - combining transactional and non-transactional tables under LOCK TABLES may cause rolled back changes in transactional table and "committed" changes in non-transactional table - user may disable innodb_table_locks, which will cause LOCK TABLES to be noop basically Removed tests for BUG#45143 and BUG#55930 which cover InnoDB + THR_LOCK. To operate properly these tests require code flow to go through THR_LOCK debug sync points, which is not the case after this patch. These tests are removed by WL#6671 as well. An alternative is to port them to different storage engine.
* | | Merge branch '10.0' into 10.1Sergei Golubchik2016-03-211-1/+1
|\ \ \ | |/ /
| * | Fix spelling: occurred, execute, which etcOtto Kekäläinen2016-03-041-1/+1
| | |
* | | MDEV-3929 Add system variable explicit_defaults_for_timestamp for ↵Alexander Barkov2015-09-221-0/+3
| | | | | | | | | | | | compatibility with MySQL
* | | Merge MDEV-7975 into 10.1Kristian Nielsen2015-04-141-0/+6
|\ \ \ | |/ /
| * | MDEV-7975: sporadic failure in test case rpl.rpl_gtid_startposKristian Nielsen2015-04-141-0/+6
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Add some suppressions that were missing. They are for if a STOP SLAVE is executed early during IO thread startup, when it is negotiating with the master. The master connection may be killed in the middle of a mysql_real_query(), which is not a test failure if it is a network error. This also caught one real code error, fixed with this commit: The I/O thread would fail to automatically reconnect if a network error happened while fetching the value of @@GLOBAL.gtid_domain_id.
* | | Merge 10.0.14 into 10.1Sergei Golubchik2014-10-151-0/+1
|\ \ \ | |/ /
| * | Merge InnoDB fixes from 5.5 revisions 4229, 4230, 4233, 4237 and 4238 i.e.Jan Lindström2014-07-251-0/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 4229: MDEV-5670: Assertion failure in file buf0lru.c line 2355 Add more status information if repeatable. 4230: MDEV-5673: Crash while parallel dropping multiple tables under heavy load Improve long semaphore wait output to include all semaphore waits and try to find out if there is a sequence of waiters. 4233: Fix compiler errors on product build. 4237: Fix too agressive long semaphore wait output and add guard against introducing compression failures on insert buffer. 4238: Fix test failure caused by simulated compression failure on IBUF_DUMMY table.
* | | MDEV-34 delete storage/ndb and sql/*ndb* (and collateral changes)Sergei Golubchik2014-10-111-4/+0
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | remove: * NDB from everywhere * IM from mtr-v1 * packaging/rpm-oel and packaging/rpm-uln * few unused spec files * plug.in file * .bzrignore
* | | cleanup: remove galera/wsrep magic from mtrSergei Golubchik2014-10-011-8/+0
| | |
* | | MDEV-6247: Merge 10.0-galera to 10.1.Jan Lindström2014-08-261-0/+8
|/ / | | | | | | | | | | | | | | | | Merged lp:maria/maria-10.0-galera up to revision 3879. Added a new functions to handler API to forcefully abort_transaction, producing fake_trx_id, get_checkpoint and set_checkpoint for XA. These were added for future possiblity to add more storage engines that could use galera replication.
* | MDEV-5080 Assertion `strcmp(share->unique_file_name,filename) || ↵Sergei Golubchik2013-11-041-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | share->last_version' fails at /storage/myisam/mi_open.c:67 extend table names discovery (ha_discover_table_names() and Discovered_table_list) to return or optionally filter out temporary tables ("#sql..."). SHOW commands and I_S tables typically want temp table filtered out, while DROP DATABASE wants to see them too. additonally, remove the supression for the warning "Invalid (old?) table or database name" from mtr, and add it to .test files as needed (we need to test that this warning does *not* happen in drop.test)
* | Instead of writing "Errcode" to the log for Slave errors, use "Internal ↵Michael Widenius2013-05-031-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | MariaDB error code" This makes it clear that the error code has nothing to do with errno. mysql-test/include/mtr_warnings.sql: Fixed suppression for new slave error messages mysql-test/lib/My/Test.pm: Use 'send' instead of 'print' to avoid errors about "wrong class ... back attempt" mysql-test/lib/v1/mtr_report.pl: Fixed suppression for new slave error messages mysql-test/mysql-test-run.pl: Fixed suppression for new slave error messages Removed warning from perl 5.16.2 about arrays mysql-test/r/flush_read_lock.result: Fixed suppression for new slave error messages sql/rpl_reporting.cc: Instead of writing "Errcode" to the log for Slave errors, use "Internal MariaDB error code"
* | Merge mariadb-5.5 -> 10.0-base.Igor Babaev2012-12-161-1/+0
|\ \ | |/
| * MDEV-531 : Warning: Forcing close of thread ... in rpl_binlog_indexVladislav Vaintroub2012-11-021-1/+0
| | | | | | | | | | | | Use post_kill_notification in for one_thread_per_connection scheduler, the same as already used in threadpool, to reliably wake a thread stuck in read() or in different poll() variations.
* | MDEV-225: Replace with dummy events an event that is not understood by a ↵unknown2012-06-221-0/+2
|/ | | | | | | | | | | | | | | slave to which it should be sent Add function to replace arbitrary event with dummy event. Add code which uses this to fix the bug that enabling row_annotate events on the master breaks slaves which do not request such events. Add that slaves set a variable @mariadb_slave_capability to inform the master in a robust way about which events it can, and cannot, handle. Add tests.
* mergeSergei Golubchik2012-01-161-1/+1
|\
| * MDEV-63 - attempt to fix the warning exclusionVladislav Vaintroub2012-01-091-1/+1
| |
* | 5.3 mergeSergei Golubchik2012-01-131-1/+1
|\ \ | |/ |/|
| * Merge with 5.2.Michael Widenius2011-12-111-0/+15
| |\ | | | | | | | | | no_error handling for select (used by INSERT ... SELECT) still needs to be fixed, but I will do that in a separate commit
| | * Initail merge with MySQL 5.1 (XtraDB still needs to be merged)Michael Widenius2011-11-211-0/+15
| | |\ | | | | | | | | | | | | Fixed up copyright messages.
* | | \ mysql-5.5.18 mergeSergei Golubchik2011-11-031-0/+15
|\ \ \ \
| * \ \ \ Merge from mysql-5.1 to mysql-5.5.Jon Olav Hauglid2011-07-041-14/+14
| |\ \ \ \ | | | |_|/ | | |/| |
| | * | | Fix MTR broken by last push.Jon Olav Hauglid2011-07-041-14/+14
| | | | |
| | * | | Updated/added copyright headersKent Boortz2011-07-031-47/+2
| | |\ \ \
| * | \ \ \ Updated/added copyright headersKent Boortz2011-06-301-0/+15
| |\ \ \ \ \ | | |/ / / /
| | * | | | Updated/added copyright headersKent Boortz2011-06-301-0/+15
| | | | | |
* | | | | | merge with 5.3Sergei Golubchik2011-10-191-1/+11
|\ \ \ \ \ \ | | |_|_|/ / | |/| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | sql/sql_insert.cc: CREATE ... IF NOT EXISTS may do nothing, but it is still not a failure. don't forget to my_ok it. ****** CREATE ... IF NOT EXISTS may do nothing, but it is still not a failure. don't forget to my_ok it. sql/sql_table.cc: small cleanup ****** small cleanup
| * | | | | Merge with MariaDB 5.2Michael Widenius2011-05-101-39/+1
| |\ \ \ \ \ | | | |_|_|/ | | |/| | |
| | * | | | Merge with MySQL 5.1.57/58Michael Widenius2011-05-021-46/+1
| | |\ \ \ \ | | | | |_|/ | | | |/| | | | | | | | Moved some BSD string functions from Unireg
View Lorry Controller Status