Mantis - mysql5
Viewing Issue Advanced Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
5136 regular use block always 2014-01-01 19:19 2014-03-09 12:24
Reporter: pfelecan Platform:  
Assigned To: laurent OS:  
Priority: high OS Version:  
Status: closed Product Version:  
Product Build: Resolution: fixed  
Projection: none      
ETA: none Fixed in Version:  
Summary: 0005136: server doesn't start anymore
Description: Since the upgrade on December 23 the installation of this package puts the service in maintenance mode.

The log has the following line:

The server quit without updating PID file (/var/opt/csw/mysql5/host.pid).

After a cursory exploration I restricted the cause to the first line of /opt/csw/bin/mysqld_safe which is:

#!/bin/./ash

Can you please correct and test this issue?
Steps To Reproduce:
Additional Information: # uname -a
SunOS host 5.10 Generic_147441-01 i86pc i386 i86pc Solaris
# pkginfo -l CSWmysql5
   PKGINST: CSWmysql5
      NAME: mysql5 - Multithreaded SQL database
  CATEGORY: application
      ARCH: i386
   VERSION: 5.5.35,REV=2013.12.23
   BASEDIR: /
    VENDOR: http://www.mysql.com/ [^] packaged for CSW by Laurent Blume
    PSTAMP: laurent@unstable10x-20131223223644
  INSTDATE: Dec 31 2013 12:08
   HOTLINE: http://www.opencsw.org/bugtrack/ [^]
     EMAIL: laurent@opencsw.org
    STATUS: completely installed
     FILES: 255 installed pathnames
                  10 shared pathnames
                  23 linked files# pkginfo -l CSWmysql5
   PKGINST: CSWmysql5
      NAME: mysql5 - Multithreaded SQL database
  CATEGORY: application
      ARCH: i386
   VERSION: 5.5.35,REV=2013.12.23
   BASEDIR: /
    VENDOR: http://www.mysql.com/ [^] packaged for CSW by Laurent Blume
    PSTAMP: laurent@unstable10x-20131223223644
  INSTDATE: Dec 31 2013 12:08
   HOTLINE: http://www.opencsw.org/bugtrack/ [^]
     EMAIL: laurent@opencsw.org
    STATUS: completely installed
     FILES: 255 installed pathnames
                  10 shared pathnames
                  23 linked files
                  45 directories
                  85 executables
              295372 blocks used (approx)

                  45 directories
                  85 executables
              295372 blocks used (approx)
Relationships
Attached Files:
Issue History
Date Modified Username Field Change
2014-01-01 19:19 pfelecan New Issue
2014-01-02 13:43 laurent Status new => assigned
2014-01-02 13:43 laurent Assigned To => laurent
2014-01-02 13:45 laurent Note Added: 0010670
2014-01-02 13:45 laurent Note Added: 0010671
2014-01-02 13:45 laurent Status assigned => resolved
2014-01-02 13:45 laurent Resolution open => fixed
2014-01-02 14:26 pfelecan Note Added: 0010672
2014-01-02 14:36 laurent Note Added: 0010673
2014-01-02 14:59 pfelecan Note Added: 0010674
2014-01-02 15:30 laurent Note Added: 0010675
2014-03-09 12:24 laurent Note Added: 0010760
2014-03-09 12:24 laurent Status resolved => closed

Notes
(0010670)
laurent   
2014-01-02 13:45   
The 32 bit version of the script was improperly modified during the post-install phase (needed for the 64-bit version architecture subdirectories).
A fixed package has been uploaded.
(0010671)
laurent   
2014-01-02 13:45   
Package tested from experimental and uploaded to unstable.
(0010672)
pfelecan   
2014-01-02 14:26   
Thank you.

However, it's a little bit strange as I run in 64bit environment:

# isainfo
amd64 i386
# isainfo -k -v
64-bit amd64 kernel modules
(0010673)
laurent   
2014-01-02 14:36   
When I took over to introduce 64 bit, and after some discussion, it was decided the default would stay 32 bit to not break existing installations (there is a potential binary DB incompatibility from 32 to 64 when some specific datatypes are used).

To make it follow the kernel default ISA, the following line must be set in csw.conf:

mysql5_arch=kernel
(0010674)
pfelecan   
2014-01-02 14:59   
Thank you for this information. I should read the documentation...

Now, that I'm reading it, I'm a little bit flabbergasted, in /opt/csw/share/doc/mysql5/README.CSW the following:

  * The preferred architecture can be set using mysql5_arch=<arch> in csw.conf:
    the default is to use the kernel's.

confuses me as I'm running a 64 bit kernel.
(0010675)
laurent   
2014-01-02 15:30   
Definitely wrong information. Fixed.
(0010760)
laurent   
2014-03-09 12:24   
Looks good.