| Bug #60035 | main.insert_select fails due to error in log files | ||
|---|---|---|---|
| Submitted: | 9 Feb 2011 6:17 | Modified: | 21 May 2011 18:49 |
| Reporter: | Anitha Gopi | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: DML | Severity: | S3 (Non-critical) |
| Version: | mysql-trunk | OS: | Solaris (10 x86_64) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | pb2 | ||
[9 Feb 2011 6:19]
Anitha Gopi
Error log file
Attachment: warnings-mysqld.1.err (application/octet-stream, text), 265 bytes.
[9 Feb 2011 8:33]
Valeriy Kravchuk
Does not fail for me with current mysql-trunk on 32-but Ubuntu 10.04.
[10 Feb 2011 4:04]
Anitha Gopi
Also seen on Linux. http://pb2.norway.sun.com/?template=mysql_show_test_failure&search=yes&push_id=2008503&tes... Valerie, You may not be able to reproduce with your build. This is seen only on daily-trunk which uses release build . Download the release binary from pb2 and run the test. You may have to use --debug-server option
[16 Feb 2011 6:58]
Sergey Vojtovich
It requires non-standard mysqld binary name, like "mysqld-debug" in the provided example.
The problem is wrong suppression:
call mtr.add_suppression("mysqld: The table '.*#sql.*' is full");
[16 Feb 2011 15:35]
Bjørn Munch
This will be a trivial follow-up to Bug #59979, don't bother to migrate.
Description: main.insert_select fails with the following error in daily-trunk run main.insert_select w5 [ fail ] Found warnings/errors in server log file! Test ended at 2011-02-09 01:11:45 line 110209 3:11:45 [ERROR] /export/home/pb2/test/sb_2-2966910-1297208546.2/mysql-5.6.2-m5-solaris10-x86_64/bin/mysqld-debug: The table '/tmp/mtr-9024/var-n_mix/tmp/5/mysqld.1/#sql5e52_88_b' is full ^ Found warnings in /tmp/mtr-9024/var-n_mix/5/log/mysqld.1.err ok - saving '/tmp/mtr-9024/var-n_mix/5/log/main.insert_select/' to '/tmp/mtr-9024/var-n_mix/log/main.insert_select/' Retrying test main.insert_select, attempt(2/3)... The failure is seen only in daily runs which use release build. This was first seen on Feb 9tth in the daily-run that turned ob server-debug option. See Bug#59979. This will force MTR to use debug binaries of server and plugins. Ideally this should not have had any impact. Even before this change daily runs were on debug binary. This was managed by PB2 which was overwriting mysqld with mysqld-debug How to repeat: http://pb2.norway.sun.com/?template=mysql_show_test_failure&test_failure_id=3502393