problemi mysql-server-5.0 [trovato il problema, non la soluzione]
dunque...
ho fatto un po' di prove... dando un ps aux ottengo
--------------------------
root@v2410:/home/hfish# ps aux | grep sql
root 2854 0.0 0.1 2672 1344 ? S 10:50 0:00
/bin/sh /usr/bin/mysqld_safe
mysql 2891 0.0 1.6 127232 16812 ? Sl 10:50 0: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 2892 0.0 0.0 1560 500 ? S 10:50 0:00
logger -p daemon.err -t mysqld_safe -i -t mysqld
root 15436 0.0 0.1 3672 1312 pts/1 S 11:06 0:00
/bin/sh /usr/bin/mysqld_safe
mysql 15475 0.0 0.9 74836 9868 pts/1 Sl 11:06 0: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 15476 0.0 0.0 2744 564 pts/1 S 11:06 0:00
logger -p daemon.err -t mysqld_safe -i -t mysqld
root 16440 0.0 0.0 2876 772 pts/1 S+ 11:06 0:00 grep sql
root@v2410:/home/hfish#
---------------------------------------
per far funzionare tutto correttamente basta uccidere i vari processi
e quindi ridare un /etc/init.d/mysql start
la soluzione ovviamente aggira il problema, senza risolverlo...
consigli?
grazie
luca
2007/1/20, Luca Costantino <luca.costantino@gmail.com>:
buongiorno lista
ecco l'output
------------------------
root@v2410:/home/hfish# cat /var/log/syslog | grep sql
Jan 20 11:00:28 localhost mysqld_safe[2802]: started
Jan 20 11:00:28 localhost mysqld[2805]: 070120 11:00:28 InnoDB:
Started; log sequence number 0 43665
Jan 20 11:00:29 localhost mysqld[2805]: 070120 11:00:29 [Note]
/usr/sbin/mysqld: ready for connections.
Jan 20 11:00:29 localhost mysqld[2805]: Version: '5.0.32-Debian_2-log'
socket: '/var/run/mysqld/mysqld.sock' port: 3306 Debian etch
distribution
Jan 20 11:00:30 localhost /etc/mysql/debian-start[2851]: Checking for
crashed MySQL tables.
Jan 20 11:00:30 localhost /etc/mysql/debian-start[2870]: Upgrading
MySQL tables if necessary.
Jan 20 11:00:34 localhost /etc/mysql/debian-start[2873]: This script
updates all the mysql privilege tables to be usable by
Jan 20 11:00:34 localhost /etc/mysql/debian-start[2873]: MySQL 4.0 and above.
Jan 20 11:00:34 localhost /etc/mysql/debian-start[2873]:
Jan 20 11:00:34 localhost /etc/mysql/debian-start[2873]: This is
needed if you want to use the new GRANT functions,
Jan 20 11:00:34 localhost /etc/mysql/debian-start[2873]: CREATE
AGGREGATE FUNCTION, stored procedures, or
Jan 20 11:00:34 localhost /etc/mysql/debian-start[2873]: more secure
passwords in 4.1
Jan 20 11:00:34 localhost /etc/mysql/debian-start[2873]:
Jan 20 11:00:34 localhost /etc/mysql/debian-start[2873]: done
Jan 20 10:13:49 localhost mysqld_safe[16269]: started
Jan 20 10:13:49 localhost mysqld[16272]: InnoDB: Unable to lock
./ibdata1, error: 11
Jan 20 10:13:49 localhost mysqld[16272]: InnoDB: Check that you do not
already have another mysqld process
Jan 20 10:13:49 localhost mysqld[16272]: InnoDB: using the same InnoDB
data or log files.
Jan 20 10:13:49 localhost mysqld[16272]: 070120 10:13:49 InnoDB:
Retrying to lock the first data file
Jan 20 10:13:50 localhost mysqld[16272]: InnoDB: Unable to lock
./ibdata1, error: 11
Jan 20 10:13:50 localhost mysqld[16272]: InnoDB: Check that you do not
already have another mysqld process
Jan 20 10:13:50 localhost mysqld[16272]: InnoDB: using the same InnoDB
data or log files.
-----------------------------------
e giù decine e decine di errori simili... unable to lock blah blah blah....
provo a documentarmi un po', intanto se qualcuno ha già avuto lo
stesso problema o cmq sa come risolvere, gliene sarei molto grato
ciao
luca
Il 19/01/07, Paolo Nesti Poggi<pnp@italyflash.com> ha scritto:
> prova a ripartire e poi guarda in syslog
>
> tail /var/log/syslog
>
> dovresti trovare lì una spegazione
>
> /Paolo
--
Usate BCC!
La paura ha creato gli dei (Lucrezio, De rerum natura)
There's no place like 127.0.0.1
God is real, unless declared integer
#394944 Linux User (Proudly Debian Powered)
Chiave pubblica http://luca.costantino.googlepages.com/
--
Usate BCC!
La paura ha creato gli dei (Lucrezio, De rerum natura)
There's no place like 127.0.0.1
God is real, unless declared integer
#394944 Linux User (Proudly Debian Powered)
Chiave pubblica http://luca.costantino.googlepages.com/
Reply to: