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