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
Triage: Needs Triage: D3 (Medium)

[9 Feb 2011 6:17] Anitha Gopi
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
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

 - 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:
[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...

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.