dunque... ho fatto un po' di prove... dando un ps aux ottengo
-------------------------- [EMAIL PROTECTED]:/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 [EMAIL PROTECTED]:/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 <[EMAIL PROTECTED]>:
buongiorno lista ecco l'output ------------------------ [EMAIL PROTECTED]:/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<[EMAIL PROTECTED]> 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/
