Bug #41265 MTR fails with the message: "Socket file path is too long"
Submitted: 5 Dec 2008 15:32 Modified: 12 Dec 2008 7:55
Reporter: Alfranio Junior Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Tests Severity:S3 (Non-critical)
Version:6.0-rpl OS:Any
Assigned to: CPU Architecture:Any

[5 Dec 2008 15:32] Alfranio Junior
Description:
ndb.ndb_alter_table2                     [ fail ]
        Test ended at 2008-12-05 13:57:58

CURRENT_TEST: ndb.ndb_alter_table2
081205 16:54:50 [Warning] The syntax '--log' is deprecated and will be removed in MySQL 7.0. Please use '--general-log --general-log-file' instead.
081205 16:54:50 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in MySQL 7.0. Please use '--slow-query-log --slow-query-log-file' instead.
081205 16:54:50 [Note] Plugin 'InnoDB' disabled by command line option
081205 16:54:50 [Note] NDB: NodeID is 192, management server 'localhost:12500'
081205 16:54:58 [Note] NDB[0]: all storage nodes connected
081205 16:54:58 [Note] Starting MySQL Cluster Binlog Thread
081205 16:54:58 [ERROR] The socket file path is too long (> 107): /home/acorreia/workspace.sun/repository.mysql/bzrwork/merge/mysql-6.0-rpl/mysql-test/var/tmp/mysqld.1.1.sock
081205 16:54:58 [ERROR] Aborting

081205 16:54:59 [Note] Stopping Cluster Binlog

Failed to start mysqld.1.1

How to repeat:
Set a socket file path longer than 107 characters by either changing one of the following parameters:

  tmpdir=DIR            The directory where temporary files are stored
                        (default: ./var/tmp).

  vardir=DIR            The directory where files generated from the test run
                        is stored (default: ./var). Specifying a ramdisk or
                        tmpfs will speed up tests.

or by installing the code/source in directory with a long path.

Suggested fix:
Create the socket files in temporary directories (e.g. /tmp).
[5 Dec 2008 15:34] Alfranio Junior
See also BUG#35735
[5 Dec 2008 16:33] Alfranio Junior
The ERROR seems to be related to MTR which does not handle long socket file paths.The The problem is not restricted to the ndb.ndb_alter_table2.test. 

In fact MTR stops running right after the failure of ndb.ndb_alter_table2 with the following message:

081205 16:54:59 [Note] Stopping Cluster Binlog

Failed to start mysqld.1.1

- saving '/home/acorreia/workspace.sun/repository.mysql/bzrwork/merge/mysql-6.0-rpl/mysql-test/var/log/ndb.ndb_alter_table2/' to '/home/acorreia/workspace.sun/repository.mysql/bzrwork/merge/mysql-6.0-rpl/mysql-test/var/log/ndb.ndb_alter_table2/' 

Too many tests(10) failed! Terminating...
mysql-test-run: *** ERROR: Test suite aborted
[8 Dec 2008 8:31] Sveta Smirnova
Thank you for the report.

What is the difference between bug #35735 and this one?
[12 Dec 2008 7:55] Sveta Smirnova
Thank you for the feedback.

So this is duplicate of bug #35735. Regarding to status of  bug #35735: it is "Patch Queued", so fix is not in main tree yet. Please wait when bug is closed.