myslqd_safe & is not starting. pls help

myslqd_safe & is not starting. pls help

am 14.01.2010 06:54:47 von sac.faizal

--00163683240875f074047d1987d3
Content-Type: text/plain; charset=ISO-8859-1

hi

anyone can help. its urgent. iam trying to start mysql server but it is not
starting.

bash-2.03# ./mysqld_safe &
[2] 3422
bash-2.03# Starting mysqld daemon with databases from /usr/local/mysql/var
STOPPING server from pid file /usr/local/mysql/var/andd141.pid
100114 11:31:22 mysqld ended

log error
--------------------
bash-2.03# more andd141.err
100114 11:31:19 mysqld started
100114 11:31:20 InnoDB: Started; log sequence number 0 44957717
/usr/local/mysql/libexec/mysqld: File './mysql-bin.000025' not found
(Errcode: 13)
100114 11:31:20 [ERROR] Failed to open log (file './mysql-bin.000025', errno
13)
100114 11:31:20 [ERROR] Could not open log file
100114 11:31:20 [ERROR] Can't init tc log
100114 11:31:20 [ERROR] Aborting

100114 11:31:20 InnoDB: Starting shutdown...
100114 11:31:22 InnoDB: Shutdown completed; log sequence number 0 44957717
100114 11:31:22 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

100114 11:31:22 mysqld ended

--------------------



Cheers
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com

--00163683240875f074047d1987d3--

Re: myslqd_safe & is not starting. pls help

am 14.01.2010 11:43:58 von Joerg Bruehe

Hi Faizal, all!


F.A.I.Z.A.L wrote:
> hi
>=20
> anyone can help. its urgent. iam trying to start mysql server but i=
t is not
> starting.

Just read the output:

>=20
> bash-2.03# ./mysqld_safe &
> [2] 3422
> bash-2.03# Starting mysqld daemon with databases from /usr/local/my=
sql/var
> STOPPING server from pid file /usr/local/mysql/var/andd141.pid
> 100114 11:31:22 mysqld ended
>=20
> log error
> --------------------
> bash-2.03# more andd141.err
> 100114 11:31:19 mysqld started
> 100114 11:31:20 InnoDB: Started; log sequence number 0 44957717
> /usr/local/mysql/libexec/mysqld: File './mysql-bin.000025' not foun=
d
> (Errcode: 13)
> 100114 11:31:20 [ERROR] Failed to open log (file './mysql-bin.00002=
5', errno
> 13)
^^ ^^^^^^^^^^^^^^^^^^

Assuming this is Linux:
joerg:~> find /usr/include -name 'errno*' | xargs fgrep 13
... ((some irrelevant lines))
/usr/include/asm-generic/errno-base.h:#define EACCES 13
/* Permission denied */

Call "man 2 open" and search for "EACCES", and you will find:
| EACCES The requested access to the file is not allowed, or search
permission is denied for one of
| the directories in the path prefix of pathname, or th=
e
file did not exist yet and write
| access to the parent directory is not allowed. (See also
path_resolution(7).)

Then take appropriate action.


HTH,
Jörg

--=20
Joerg Bruehe, MySQL Build Team, Joerg.Bruehe@Sun.COM
Sun Microsystems GmbH, Komturstraße 18a, D-12099 Berlin
Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Wolf Frenkel
Vorsitzender des Aufsichtsrates: Martin Haering Muenchen: HRB1610=
28


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: myslqd_safe & is not starting. pls help

am 14.01.2010 14:31:23 von sac.faizal

--002354470674639f6e047d1fe88f
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

hi thanks for your response..

this is solaris 8 machine. thanks a lot. i found the problem and resolved..

problem is: access problem in file system

'./mysql-bin.000025' is created in root.root but it should be in
mysql.mysql (user.group). i changed this to mysql, then service started...

thanks again..


Cheers
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com


On Thu, Jan 14, 2010 at 4:13 PM, Joerg Bruehe wrote:

> Hi Faizal, all!
>
>
> F.A.I.Z.A.L wrote:
> > hi
> >
> > anyone can help. its urgent. iam trying to start mysql server but it is
> not
> > starting.
>
> Just read the output:
>
> >
> > bash-2.03# ./mysqld_safe &
> > [2] 3422
> > bash-2.03# Starting mysqld daemon with databases from
> /usr/local/mysql/var
> > STOPPING server from pid file /usr/local/mysql/var/andd141.pid
> > 100114 11:31:22 mysqld ended
> >
> > log error
> > --------------------
> > bash-2.03# more andd141.err
> > 100114 11:31:19 mysqld started
> > 100114 11:31:20 InnoDB: Started; log sequence number 0 44957717
> > /usr/local/mysql/libexec/mysqld: File './mysql-bin.000025' not found
> > (Errcode: 13)
> > 100114 11:31:20 [ERROR] Failed to open log (file './mysql-bin.000025',
> errno
> > 13)
> ^^ ^^^^^^^^^^^^^^^^^^
>
> Assuming this is Linux:
> joerg:~> find /usr/include -name 'errno*' | xargs fgrep 13
> ... ((some irrelevant lines))
> /usr/include/asm-generic/errno-base.h:#define EACCES 13
> /* Permission denied */
>
> Call "man 2 open" and search for "EACCES", and you will find:
> | EACCES The requested access to the file is not allowed, or search
> permission is denied for one of
> | the directories in the path prefix of pathname, or the
> file did not exist yet and write
> | access to the parent directory is not allowed. (See also
> path_resolution(7).)
>
> Then take appropriate action.
>
>
> HTH,
> Jörg
>
> --
> Joerg Bruehe, MySQL Build Team, Joerg.Bruehe@Sun.COM
> Sun Microsystems GmbH, Komturstraße 18a, D-12099 Berlin
> Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Wolf Frenkel
> Vorsitzender des Aufsichtsrates: Martin Haering Muenchen: HRB161028
>
>

--002354470674639f6e047d1fe88f--