Bug #13172 csv test fails with an assertion failure on QNX
Submitted: 14 Sep 2005 10:56 Modified: 29 Sep 2008 22:03
Reporter: Lenz Grimmer Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.13-pre OS:Other (QNX 6.2.1)
Assigned to: Jim Winstead CPU Architecture:Any

[14 Sep 2005 10:56] Lenz Grimmer
Description:
The "csv" test fails on QNX with the following output (from a non-debug build):

10717: csv                             [ fail ]
10718: Errors are (from /home/mysqldev/buildqnx2/test/mysql-max-5.0.13-beta-nto-qnx6.2.1-i386/mysql-test/var/log/mysqltest-time) :
10719: mysqltest: At line 20: unable to execute statement 'INSERT INTO t1 VALUES (9410,9412)': Woops, blew up opening a mapped file (mysql_stmt_errno=48 returned=1)
10720: (the last lines may be the most important ones)

Using a debug binary, the output differs a bit:

TEST                            RESULT
-------------------------------------------------------

csv                             [ fail ]
Errors are (from /home/mysqldev/tmp/mysql-5.0.13-beta/mysql-test/var/log/mysqltest-time) :
mysqltest: At line 20: query 'INSERT INTO t1 VALUES (9410,9412)' failed: 2013: Lost connection to MySQL server during query

var/log/master.err contains:

050914 13:47:50 [Note] /home/mysqldev/tmp/mysql-5.0.13-beta/sql/mysqld: ready for connections.
Version: '5.0.13-beta-debug-log'  socket: '/home/mysqldev/tmp/mysql-5.0.13-beta/mysql-test/var/tmp/m
aster.sock'  port: 9306  MySQL Community Edition - Debug (GPL)
examples/ha_tina.cc:127 0 -- assertion failed
mysqld got signal 6;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail.

key_buffer_size=1048576
read_buffer_size=131072
max_used_connections=1
max_connections=100
threads_connected=1
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 39423 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

How to repeat:
Compile a binary on QNX with the CSV storage engine enabled, observe the failure
[18 Oct 2005 22:19] Jim Winstead
QNX's mmap() does not support the functionality required by the CSV storage engine, so it simply can't work on that platform. A later version of MySQL may include a non-mmap()-based CSV implementation.
[29 Sep 2008 22:03] Konstantin Osipov
Apart from improving CSV, we no longer run our tests on QNX.