MYSQL server is not running, DATABSE ERROR

[Sahil Malik]

hi dim,
I did a fresh installation dimSTAT v9 on Solaris 10.86 but mysql server would refuse to startup and batch load not found

root@sys051 # ./dim_STAT-Server start
================[ dim_STAT-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...
130320 11:48:14 mysqld_safe Logging to '/apps/mysql/data/mysqld.log'.
130320 11:48:14 mysqld_safe Starting mysqld daemon with databases from /apps/mysql/data
Killed
130320 11:48:14 mysqld_safe mysqld from pid file /apps/mysql/data/mysqld.pid ended
Done.
================[ Checking for dead/killed collects... ]================
  *
  ### DATABASE ERROR: ### Cannot open database: dim ERR: -1  SQLERR: ### No more cursors OR Can't connect to local MySQL server through socket '/apps/mysql/data/m

  ### DATABASE ERROR: ### DATABASE Query ERROR: QUERY:  select * from dim_STAT where  state != 0 and state != 2; ; ### ERRMSG: ### No more cursors OR Can't connect to local MySQL server through socket '/apps/mysql/data/m

  *
================[ Done ]================
Starting HTTP server from: /apps/httpd
Done.
================[ dim_STAT-Server: start -- done. ]================

PLEASE help..
please

-- Sahil

[Dimitri]

Hi Sahil,

and is there any error messages within /apps/mysql/data/mysqld.log file?

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?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

[Sahil Malik]

Hi dim
Reply thnaks for reply...

I am new in this..

Will u please tell me how to check for the same..

--Sahil

You received this message because you are subscribed to a topic in the Google Groups "dim_STAT" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/dimstat/x4HX996_LiE/unsubscribe?hl=en.
To unsubscribe from this group and all its topics, send an email to dimstat+u...@googlegroups.com.

[Dimitri]

Hi Sahil,

as you see from your own message, when you're starting dim_STAT-Server
script it'll write you the following info about MySQL server:

root@sys051 # ./dim_STAT-Server start
================[ dim_STAT-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...

So, all messages related to MySQL server will go to the
"/apps/mysql/data/mysqld.log" file in your case..

Now, just syaty in terminal window (no.1):
$ tail -f /apps/mysql/data/mysqld.log

and in another (no.2) try to start dim_STAT server again:
root@sys051 # ./dim_STAT-Server start

and look for any new message appearing in the terminal window no.1
what do you see?

[Sahil Malik]

hi dim,

these are the outcomes in both windows:

root@sys051 # tail -f/apps/mysql/data/mysql.log
usage: tail [+/-[n][lbc][f]] [file]
       tail [+/-[n][l][r|f]] [file]

root@sys051 # ./dim_STAT-Server start
================[ dim_STAT-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...

130321 05:54:24 mysqld_safe Logging to '/apps/mysql/data/mysqld.log'.
130321 05:54:24 mysqld_safe Starting mysqld daemon with databases from /apps/mysql/data
Killed
130321 05:54:24 mysqld_safe mysqld from pid file /apps/mysql/data/mysqld.pid ended

Done.
================[ Checking for dead/killed collects... ]================
  *
  ### DATABASE ERROR: ### Cannot open database: dim ERR: -1  SQLERR: ### No more cursors OR Can't connect to local MySQL server through socket '/apps/mysql/data/m

  ### DATABASE ERROR: ### DATABASE Query ERROR: QUERY:  select * from dim_STAT where  state != 0 and state != 2; ; ### ERRMSG: ### No more cursors OR Can't connect to local MySQL server through socket '/apps/mysql/data/m

  *
================[ Done ]================
Starting HTTP server from: /apps/httpd
Done.
================[ dim_STAT-Server: start -- done. ]================

root@sys051 # ./dim_STAT-Server stop
================[ dim_STAT-Server: stop ]================
================[ Checking for ACTIVE collects... ]================
================[ MySQL Server is not running... ]================

*
* 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

Stopping...
No mysqld pid file found. Looked for /apps/mysql/data/mysqld.pid.
Done.
Killing HTTP server with pid: 7323
Done.
================[ Killing Clients... ]================
================[ dim_STAT-Server: stop -- done. ]================

Have to figure it out soon..

-- sahil

[Sahil Malik]

hi dim,

and do i need to add STAT-service kit on mine too ??

On Wednesday, 20 March 2013 16:21:14 UTC+5:30, Sahil Malik wrote:

[Dimitri]

Sahil,

you've missed a space in "tail -f .." after "-f" (between -f and filename) :-)
$ tail -f /apps/mysql/data/mysql.log

but well, doesn't matter - just send a whole
"/apps/mysql/data/mysql.log" file here as attachment, it should not be
big yet..

Rgds,
-Dimitri

[Sahil Malik]

hi dim,

there is no such mysql.log but instead there is mysqld.log, i am send it to you as attachment.

 

Thanks and regards

--sahil

You received this message because you are subscribed to a topic in the Google Groups "dim_STAT" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/dimstat/x4HX996_LiE/unsubscribe?hl=en.
To unsubscribe from this group and all its topics, send an email to dimstat+u...@googlegroups.com.

[Dimitri]

Hi Sahil,

well, if you'll follow back this thread, then you'll see that "d" in
the mysqld.lod was lost by you, and then I've just done a copy+paste
from your message to explain you that you've missed a space between
"-f" and file name ;-)

from the log file it's seen that you're missing a right libz library..
(seems like the present libz.so.1 library is not matching the required
format)..

just do:
$ ldd /apps/mysql/bin/mysqld

and see what is missed from the shared libs (send the output here too).

I have no idea why the right library may be missed on a "standard"
Solaris 10.. - as a workaround, you may simply install a newer MySQL
version on your server -- see details from Amir:
http://groups.google.com/group/dimstat/browse_thread/thread/e7de912987153c84%3Fhl%3Den&usg=AFQjCNFz2SdVDUsAXs9iPyp9DVFlBQy2vQ

Rgds,
-Dimitri

[Sahil Malik]

hi dim,
here is the output of
ldd /apps/mysql/bin/mysqld
is :
libmtmalloc.so.1 =>      /usr/lib/libmtmalloc.so.1
        libthread.so.1 =>        /lib/libthread.so.1
        libz.so.1 =>     /usr/lib/libz.so.1
        libz.so.1 (SUNW_1.2) =>  (version not found)
        libnsl.so.1 =>   /lib/libnsl.so.1
        librt.so.1 =>    /lib/librt.so.1
        libsocket.so.1 =>        /lib/libsocket.so.1
        libstdc++.so.6 =>        /usr/sfw/lib/libstdc++.so.6
        libm.so.2 =>     /lib/libm.so.2
        libgcc_s.so.1 =>         /usr/sfw/lib/libgcc_s.so.1
        libc.so.1 =>     /lib/libc.so.1
        libmp.so.2 =>    /lib/libmp.so.2
        libmd5.so.1 =>   /lib/libmd5.so.1
        libscf.so.1 =>   /lib/libscf.so.1
        libaio.so.1 =>   /lib/libaio.so.1
        libdoor.so.1 =>  /lib/libdoor.so.1
        libuutil.so.1 =>         /lib/libuutil.so.1

so now do i just have to upgrade my mysql using that link ??
or any other steps do i have to follow ?

thanks and regards
--sahil

[Dimitri]

Hi Sahil,

I think you have only 2 options:
- find a working libz.so (from an older/newer server?) -- which
Solaris 10 version do you use? - if it happens on the latest Solaris
10 then it's not good, as it seems to break the famous backward binary
compatibility we always were proud in Solaris.. (maybe Amir may
comment here since he's working directly with Solaris dev?)..

- otherwise, install latest "official" mysql distribution for your system..

Rgds,
-Dimitri

[Sahil Malik]

hi dim,

i am using Solaris 10 11/06 s10x_u3wos_10 X86.

i'll try out by those.

thanks and regards

--sahil

[Dimitri]

Hi Sahil,

it may be my fault also as it's possible that I've prepared my Solaris 10 /x64 build on the Solaris10-update4, while you have yet an update3.. (I don't remember now exactly which update version I've used, but remember that update4 was the most common on our servers during this time)..

Rgds,

-Dimitri

[Sahil Malik]

hi dim,

so now should i go for solaris update4 and "official" mysql OR to linux ( which version? )

for any dim_STAT version.

Regards

--Sahil

[Dimitri]

Hi Sahil,

you may:

  - install latest MySQL 5.5 or 5.6 on your current server (probably the most simple option)

  - upgrade your Solaris 10 to the latest update (update 3 is so old...)

  - or use Linux (but be sure first it'll support your HW, etc. - probably the most hard way if you want to do it on the same HW server)..

Rgds,

-Dimitri

[Sahil Malik]

hi dim,

any particular version in case of linux??

regards

--sahil

[Dimitri]

Hi Sahil,

Personally on my Linux VM I'm using Xubuntu 32bit -- it's pretty compact, using less 2GB on disk and able to run within 256MB RAM -- pretty ideal for VM :-)   -- while for a real machine choose one which you're more familiar with: Oracle Linux, Ubuntu, RegHat/ Fedora/ CentOS, openSUSE, etc.. - depending which one is better supporting your HW (then to find missed by default 32bit libs will be another story)..

Rgds,

-Dimitri