Mysql not starting after fresh install on Solaris 11

[Marion]

Hello, 

1st install of a dimstat server on a Solaris 11 and 1st time it's not working ;)

I installed with all default except the port which is 4999 because the serveur is a domain controler and console is using port 5000 to 5100.

When I start mysql I have the following message :

#./mysql.server start

*

* MySQL Database Server

*

  => Log output  : /apps/mysql/data/mysqld.log

  => Local socket: /apps/mysql/data/mysql.sock

  => Admin Access: root# /apps/mysql/bin/mysql -S /apps/mysql/data/mysql.sock

Starting...

140721 17:57:04 mysqld_safe Logging to '/apps/mysql/data/mysqld.log'.

140721 17:57:04 mysqld_safe Starting mysqld daemon with databases from /apps/mysql/data

140721 17:57:04 mysqld_safe mysqld from pid file /apps/mysql/data/mysqld.pid ended

# ps -ef | grep mysql

     root 15003 14699   0 17:57:26 pts/1       0:00 grep mysql

# more /apps/mysql/data/mysqld.log

140721 17:37:10 mysqld_safe Starting mysqld daemon with databases from /apps/mysql/data

140721 17:37:10 [ERROR] Initialization of transaction delegates failed. Please report a bug.

140721 17:37:10 [ERROR] Aborting

140721 17:37:10 [Note] /apps/mysql/bin/mysqld: Shutdown complete

140721 17:37:10 mysqld_safe mysqld from pid file /apps/mysql/data/mysqld.pid ended

140721 17:52:32 mysqld_safe Starting mysqld daemon with databases from /apps/mysql/data

140721 17:52:32 [ERROR] Initialization of transaction delegates failed. Please report a bug.

140721 17:52:32 [ERROR] Aborting

140721 17:52:32 [Note] /apps/mysql/bin/mysqld: Shutdown complete

140721 17:52:32 mysqld_safe mysqld from pid file /apps/mysql/data/mysqld.pid ended

140721 17:57:04 mysqld_safe Starting mysqld daemon with databases from /apps/mysql/data

140721 17:57:04 [ERROR] Initialization of transaction delegates failed. Please report a bug.

140721 17:57:04 [ERROR] Aborting

140721 17:57:04 [Note] /apps/mysql/bin/mysqld: Shutdown complete

140721 17:57:04 mysqld_safe mysqld from pid file /apps/mysql/data/mysqld.pid ended

Someone had this problem before ?

Thanks

[Dimitri]

Hi Marion,

Unfortunately this is a known and old issue on Solaris 11 (you may search within older messages and find the first report and workaround by Amir)..

Over a time I was able to analyze this issue more in depth and finally discovered what happens exactly here (and since Solaris 11 only).. - just that since Solaris 11 there is no more any expected order of thread execution when they are created many at once and in parallel ;-)) -- and there is nothing wrong from the OS concept, just that MySQL code was not aware about ;-)) and that's why you see these all strange error messages, because during initialization phase some MySQL internal threads finishing their steps ahead of others, etc. 

The bug was open and fixed very quickly, but it was too late for me to ship the fixed binary within a dim_STAT tarball ;-))

So, the most simple fix:

  - download the latest MySQL 5.5 tarball for Solaris 11 on your platform

  - copy from this tarball the "mysqld" binary to the /apps/mysql/bin

  - start dim_STAT Server ;-)

Note: new "mysqld" may complain about a shorter than expected internal file with error messages -- in this case copy the latest file from the MySQL tarball too..

Rgds,

-Dimitri

--
You received this message because you are subscribed to the Google Groups "dim_STAT" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dimstat+u...@googlegroups.com.
To post to this group, send email to dim...@googlegroups.com.
Visit this group at http://groups.google.com/group/dimstat.
For more options, visit https://groups.google.com/d/optout.

[Marion]

Hi Dimitri,

Thanks, did the upgrade and it works fine as usual ;)

I was presenting the tool and explaining that installation is very simple and it just works when I got the issue ;)

Rgds,

Marion

To unsubscribe from this group and stop receiving emails from it, send an email to dimstat+unsubscribe@googlegroups.com.