Bug#537709: mysql-server-5.0: During system startup /etc/init.d/mysql doesn't create pid and socket

2009-07-24 Thread Christian Hammers
severity 537709 normal
tags 537709 + unreproducible moreinfo
stop

Hello

Don't worry that I'm downgrading the bug it's just that this problem has
not been reported by anyone else so I suspect that there is something
unexpected on your system. Apart from that consider upgrading to lenny!

Can you send a df -h to see if maybe /var is 100% full?

Do you use selinux or any other security mechanisms on your server?

Gives grep mysql /var/log/auth.log /var/log/kern.log anything?

Does ls -la /var/run/mysqld look like this:
  drwxr-xr-x  2 mysql root  4096 24. Jul 06:41 .
  drwxr-xr-x 31 root  root  4096 24. Jul 06:41 ..
Maybe it is not owned by the mysql user.

If all fails to 'strace -e trace=file -o mysqld.trace /usr/sbin/mysqld and
then do grep var/run mysqld.trace.

bye,

-christian-




-- 
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org



Bug#537709: mysql-server-5.0: During system startup /etc/init.d/mysql doesn't create pid and socket

2009-07-20 Thread Iñaki Baz Castillo
Package: mysql-server-5.0
Version: 5.0.32-7etch10
Severity: grave
Justification: renders package unusable



-- System Information:
Debian Release: 4.0
  APT prefers oldstable
  APT policy: (500, 'oldstable')
Architecture: i386 (i686)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.6.18-4-686
Locale: LANG=es_ES.UTF-8, LC_CTYPE=es_ES.UTF-8 (charmap=UTF-8)

Versions of packages mysql-server-5.0 depends on:
ii  adduser   3.102  Add and remove users and groups
ii  debconf [debconf-2.0] 1.5.11etch2Debian configuration management sy
ii  libc6 2.3.6.ds1-13   GNU C Library: Shared libraries
ii  libdbi-perl   1.53-1 Perl5 database interface by Tim Bu
ii  libgcc1   1:4.1.1-21 GCC support library
ii  libmysqlclient15off   5.0.32-7etch10 mysql database client library
ii  libncurses5   5.5-5  Shared libraries for terminal hand
ii  libreadline5  5.2-2  GNU readline and history libraries
ii  libstdc++64.1.1-21   The GNU Standard C++ Library v3
ii  libwrap0  7.6.dbs-13 Wietse Venema's TCP wrappers libra
ii  lsb-base  3.1-23.1   Linux Standard Base 3.1 init scrip
ii  mysql-client-5.0  5.0.32-7etch10 mysql database client binaries
ii  mysql-common  5.0.32-7etch10 mysql database common files (e.g. 
ii  passwd1:4.0.18.1-6   change and administer password and
ii  perl  5.8.8-7etch6   Larry Wall's Practical Extraction 
ii  psmisc22.3-1 Utilities that use the proc filesy
ii  zlib1g1:1.2.3-13 compression library - runtime

Versions of packages mysql-server-5.0 recommends:
ii  mailx1:8.1.2-0.20050715cvs-1 A simple mail user agent

-- debconf information:
  mysql-server-5.0/really_downgrade: false
  mysql-server-5.0/need_sarge_compat: false
  mysql-server-5.0/start_on_boot: true
  mysql-server/error_setting_password:
  mysql-server-5.0/nis_warning:
  mysql-server-5.0/postrm_remove_databases: false
  mysql-server-5.0/need_sarge_compat_done: true


When the system startups and /etc/init.d/mysql is executed with start
parameter, something goes wrong and pidfile and socket are not created
under /var/run/mysqld.

I use a fresh and default mysql-server-5.0 installation.

Syslogs says that /etc/mysql/


ps output:
---
 p root      2475     1  0 10:47 ?        00:00:00 /bin/sh
/usr/bin/mysqld_safe
mysql     2512  2475  0 10:47 ?        
00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql
--user=mysql --pid-file=/var/run/mysqld/mysqld.pid
--skip-external-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock
root      2513  2475  0 10:47 ?        00:00:00 logger -p daemon.err -t
mysqld_safe -i -t mysqld
---


Note that netstat says that there is a UNIX socket which in fact
doesn't exist!:
--
~# netstat -panx | grep mysql
unix  2  [ ACC ] STREAM LISTENING 4707 2512/mysqld
~# ls -l /var/run/mysqld/
total 0
---


Of course, /etc/init.d/mysql stop doesn't work since no pid file is
found.


If I kill mysqld process manually (and mysqld_safe) then I can start the
server with /etc/init.d/mysql start and then it starts correctly (it
generates the pid and socket in /var/run/mysqld).

The same problem occurs also in a 64 bits system.

These are my repositories:
---
deb http://ftp.rediris.es/debian/ etch main contrib non-free
deb http://security.debian.org/ etch/updates main contrib non-free
deb http://www.backports.org/debian etch-backports main contrib non-free
--



-- 
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org