+ Responder ao Tópico



  1. #1
    grilo
    Visitante

    Padrão mysqld...failed

    Tou tentando fazer uma conexao remota no mysql.

    no servidor eu digito
    #mysql -u root -p

    dai funciona legal.
    mas qd eu tento restarta o mysql ele da uma flha dai nao consegui acessa-lo remoto.

    net256:~# /etc/init.d/mysql stop
    Starting MySQL database server: mysql...failed.
    net256:~#

    vejam o log

    net256:/var/log# cat mysql.log |more

    mysqld, Version: 3.23.49-log, started with:
    Tcp port: 0 Unix socket: /var/run/mysqld/mysqld.sock
    Time Id Command Argument
    mysqld, Version: 3.23.49-log, started with:
    Tcp port: 0 Unix socket: /var/run/mysqld/mysqld.sock
    Time Id Command Argument
    041221 9:16:54 1 Connect Access denied for user: 'debian-sys-maint@localhost' (Using passwo
    rd: YES)
    2 Connect Access denied for user: 'debian-sys-maint@localhost' (Using passwo
    rd: YES)
    041221 9:16:56 3 Connect Access denied for user: 'debian-sys-maint@localhost' (Using passwo
    rd: YES)
    041221 9:16:57 4 Connect Access denied for user: 'debian-sys-maint@localhost' (Using passwo
    rd: YES)
    041221 9:16:58 5 Connect Access denied for user: 'debian-sys-maint@localhost' (Using passwo
    rd: YES)
    041221 9:17:00 6 Connect Access denied for user: 'debian-sys-maint@localhost' (Using passwo
    rd: YES)
    041221 9:17:01 7 Connect Access denied for user: 'debian-sys-maint@localhost' (Using passwo
    rd: YES)
    041221 9:17:02 8 Connect Access denied for user: 'debian-sys-maint@localhost' (Using passwo
    rd: YES)
    041221 9:17:03 9 Connect Access denied for user: 'debian-sys-maint@localhost' (Using passwo
    rd: YES)


    net256:/var/log/mysql# cat mysql.err
    A mysqld process already exists at Tue Dec 21 08:29:30 BRST 2004
    A mysqld process already exists at Tue Dec 21 08:31:30 BRST 2004
    A mysqld process already exists at Tue Dec 21 08:31:48 BRST 2004
    A mysqld process already exists at Tue Dec 21 08:37:18 BRST 2004
    A mysqld process already exists at Tue Dec 21 08:59:31 BRST 2004
    A mysqld process already exists at Tue Dec 21 09:08:05 BRST 2004
    A mysqld process already exists at Tue Dec 21 09:09:45 BRST 2004
    A mysqld process already exists at Tue Dec 21 09:11:33 BRST 2004
    A mysqld process already exists at Tue Dec 21 09:13:38 BRST 2004
    A mysqld process already exists at Tue Dec 21 09:16:57 BRST 2004
    041221 09:58:44 mysqld ended

    041221 09:59:33 mysqld started
    /usr/sbin/mysqld: ready for connections
    A mysqld process already exists at Tue Dec 21 11:59:28 BRST 2004
    net256:/var/log/mysql#

    alguem pode me ajudar?


    obrigado.

  2. #2

    Padrão mysqld...failed

    Mate todos os processos que estao rodando o mysql.

    daí tenta "startar" ele, caso ele não "start" manda o log.


    Pedro Henrique

  3. #3

    Padrão mysqld...failed

    Digita:
    ps aux | grep mysql
    observa o nome do executável do mysql que está em memória
    pode ser mysqld, mysqld-max, etc ...

    e depois dá um killall -9 nome_executavel_mysql

    service mysqld start

  4. #4
    grilo
    Visitante

    Padrão mysqld...failed

    meu mysql.err

    Number of processes running now: 0
    041223 15:48:55 mysqld restarted
    /usr/sbin/mysqld: ready for connections

    Number of processes running now: 0
    041223 15:49:17 mysqld restarted
    /usr/sbin/mysqld: ready for connections

    Number of processes running now: 0
    041223 15:49:24 mysqld restarted
    /usr/sbin/mysqld: ready for connections

    Number of processes running now: 0
    041223 15:49:50 mysqld restarted
    /usr/sbin/mysqld: ready for connections

    Number of processes running now: 2
    mysqld process hanging, pid 10231 - killed
    mysqld process hanging, pid 10230 - killed
    041223 15:50:05 mysqld restarted
    /usr/sbin/mysqld: ready for connections

    Number of processes running now: 2
    mysqld process hanging, pid 10264 - killed
    mysqld process hanging, pid 10263 - killed
    041223 15:50:21 mysqld restarted
    /usr/sbin/mysqld: ready for connections

    Number of processes running now: 0
    041223 15:50:50 mysqld restarted
    /usr/sbin/mysqld: ready for connections

    Number of processes running now: 2
    mysqld process hanging, pid 10318 - killed
    mysqld process hanging, pid 10317 - killed
    041223 15:51:09 mysqld restarted
    /usr/sbin/mysqld: ready for connections

    Number of processes running now: 0
    041223 15:51:35 mysqld restarted
    /usr/sbin/mysqld: ready for connections

    Number of processes running now: 0
    041223 15:51:58 mysqld restarted
    /usr/sbin/mysqld: ready for connections

    Number of processes running now: 3
    mysqld process hanging, pid 10388 - killed
    mysqld process hanging, pid 10387 - killed
    mysqld process hanging, pid 10386 - killed
    041223 15:53:23 mysqld restarted
    /usr/sbin/mysqld: ready for connections

    Number of processes running now: 0
    041223 15:53:53 mysqld restarted
    /usr/sbin/mysqld: ready for connections
    041223 16:09:14 mysqld started
    /usr/sbin/mysqld: ready for connections

    ##############################
    mysql.log

    /usr/sbin/mysqld, Version: 3.23.49-log, started with:
    Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
    Time Id Command Argument
    /usr/sbin/mysqld, Version: 3.23.49-log, started with:
    Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
    Time Id Command Argument
    /usr/sbin/mysqld, Version: 3.23.49-log, started with:
    Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
    Time Id Command Argument
    /usr/sbin/mysqld, Version: 3.23.49-log, started with:
    Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
    Time Id Command Argument
    /usr/sbin/mysqld, Version: 3.23.49-log, started with:
    Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
    Time Id Command Argument
    /usr/sbin/mysqld, Version: 3.23.49-log, started with:
    Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
    Time Id Command Argument
    /usr/sbin/mysqld, Version: 3.23.49-log, started with:
    Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
    Time Id Command Argument
    /usr/sbin/mysqld, Version: 3.23.49-log, started with:
    Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
    Time Id Command Argument
    /usr/sbin/mysqld, Version: 3.23.49-log, started with:
    Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
    Time Id Command Argument
    /usr/sbin/mysqld, Version: 3.23.49-log, started with:
    Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
    Time Id Command Argument
    /usr/sbin/mysqld, Version: 3.23.49-log, started with:
    Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
    Time Id Command Argument
    /usr/sbin/mysqld, Version: 3.23.49-log, started with:
    Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
    Time Id Command Argument
    /usr/sbin/mysqld, Version: 3.23.49-log, started with:
    Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
    Time Id Command Argument
    041223 16:09:15 1 Connect Access denied for user: 'debian-sys-maint@localhost' (Using password: YES)
    041223 16:09:16 2 Connect Access denied for user: 'debian-sys-maint@localhost' (Using password: YES)
    041223 16:09:17 3 Connect Access denied for user: 'debian-sys-maint@localhost' (Using password: YES)
    041223 16:09:18 4 Connect Access denied for user: 'debian-sys-maint@localhost' (Using password: YES)
    041223 16:09:19 5 Connect Access denied for user: 'debian-sys-maint@localhost' (Using password: YES)
    041223 16:09:20 6 Connect Access denied for user: 'debian-sys-maint@localhost' (Using password: YES)
    041223 16:10:10 7 Connect root@localhost on
    7 Init DB mural
    7 Query select count(*) from mural ORDER BY id DESC
    7 Query SELECT * FROM mural ORDER BY id DESC limit 0,10
    7 Query SELECT * FROM mural
    7 Query SELECT * FROM filtro
    7 Query SELECT * FROM filtro
    7 Query SELECT * FROM filtro
    7 Query SELECT * FROM filtro
    7 Query SELECT * FROM filtro
    7 Query SELECT * FROM filtro
    7 Query SELECT * FROM filtro
    7 Query SELECT * FROM filtro
    7 Query SELECT * FROM filtro
    7 Query SELECT * FROM filtro
    7 Quit


    o erro ainda persiste...
    net256:~# /etc/init.d/mysql start
    Starting MySQL database server: mysql...failed.
    net256:~#

  5. #5

  6. #6
    grilo
    Visitante

    Padrão mysqld...failed

    Citação Postado originalmente por fred_m
    manda a saida do comando ps auxw
    ps auxw

    USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
    root 1 0.0 0.1 1272 436 ? S Dec21 0:06 init [2]
    root 2 0.0 0.0 0 0 ? SW Dec21 0:00 [keventd]
    root 3 0.0 0.0 0 0 ? SWN Dec21 0:00 [ksoftirqd_CPU0]
    root 4 0.0 0.0 0 0 ? SW Dec21 0:02 [kswapd]
    root 5 0.0 0.0 0 0 ? SW Dec21 0:00 [bdflush]
    root 6 0.0 0.0 0 0 ? SW Dec21 0:00 [kupdated]
    root 7 0.0 0.0 0 0 ? SW Dec21 0:00 [i2oevtd]
    root 43 0.0 0.0 0 0 ? SW Dec21 0:00 [khubd]
    root 102 0.0 0.0 0 0 ? SW Dec21 0:00 [eth0]
    daemon 107 0.0 0.2 1384 524 ? S Dec21 0:00 /sbin/portmap
    root 262 0.0 0.3 2036 776 ? S Dec21 0:00 /sbin/syslogd
    root 265 0.0 0.4 2060 1224 ? S Dec21 0:00 /sbin/klogd
    root 272 0.0 0.3 2008 880 ? S Dec21 0:00 /usr/sbin/pppd call dsl-provider
    root 274 0.0 0.1 1272 468 ? S Dec21 1:04 /usr/sbin/pppoe -I eth1 -T 80 -m 1452
    root 278 0.0 0.2 1444 692 ? S Dec21 0:00 /sbin/rpc.statd
    root 284 0.0 0.0 0 0 ? SW Dec21 0:00 [kapmd]
    root 286 0.0 0.1 1268 480 ? S Dec21 0:00 /usr/sbin/apmd -P /etc/apm/apmd_proxy
    root 310 0.0 0.2 2228 716 ? S Dec21 0:00 /usr/sbin/couriertcpd -address=0 -stderrlogger=/usr/sbin/courierlogger -maxprocs=40 -maxperip=4 -pid=/var/run/courier/imapd.pid -nodnslookup -noidentlookup 143 /usr/lib/courier/courier/imaplogin /usr/lib/courier/authlib/authdaemon /usr/bin/imapd Maildir
    root 314 0.0 0.1 1424 320 ? S Dec21 0:00 /usr/sbin/courierlogger imaplogin
    root 318 0.0 0.2 2228 720 ? S Dec21 0:00 /usr/sbin/couriertcpd -pid=/var/run/courier/pop3d.pid -stderrlogger=/usr/sbin/courierlogger -maxprocs=40 -maxperip=4 -nodnslookup -noidentlookup -address=0 110 /usr/lib/courier/courier/courierpop3login /usr/lib/courier/authlib/authdaemon /usr/lib/courier/courier/courierpop3d Maildir
    root 321 0.0 0.1 1432 444 ? S Dec21 0:00 /usr/sbin/courierlogger courierpop3login
    root 329 0.0 0.2 1728 660 ? S< Dec21 0:00 /usr/sbin/diald -f /var/cache/diald/options.dsl-provider
    root 349 0.0 0.2 1988 696 ? S Dec21 0:00 /usr/sbin/inetd
    news 381 0.0 0.3 2176 896 ? S Dec21 0:00 /bin/sh /usr/lib/news/bin/rc.news
    root 392 0.0 0.2 2044 740 ? S Dec21 0:00 /usr/sbin/lpd
    root 605 0.0 0.2 2484 576 ? S Dec21 0:00 /usr/lib/postfix/master
    postfix 610 0.0 0.3 2488 976 ? S Dec21 0:00 qmgr -l -t fifo -u -c
    root 611 0.0 0.2 2700 736 ? S Dec21 0:01 /usr/sbin/nmbd -D
    root 613 0.0 0.3 3584 796 ? S Dec21 0:00 /usr/sbin/smbd -D
    root 619 0.0 0.2 2784 540 ? S Dec21 0:00 /usr/sbin/sshd
    www-data 629 3.8 1.8 33300 4700 ? S Dec21 127:37 /usr/lib/jdk1.1/bin/i686/green_threads/java -Djava.security.policy=/usr/share/tomcat/conf/tomcat.policy -Dtomcat.home=/usr/share/tomcat org/apache/tomcat/startup/Main start
    root 638 0.0 0.1 4236 488 ? S Dec21 0:00 /usr/bin/X11/xfs -daemon
    website 773 0.0 0.3 3620 1004 ? S Dec21 0:00 proftpd (accepting connections)
    daemon 784 0.0 0.2 1384 516 ? S Dec21 0:00 /usr/sbin/atd
    root 787 0.0 0.2 1652 608 ? S Dec21 0:00 /usr/sbin/cron
    root 791 0.0 0.5 136752 1332 ? S Dec21 0:00 /usr/sbin/apache
    root 817 0.0 0.1 1252 400 tty1 S Dec21 0:00 /sbin/getty 38400 tty1
    root 818 0.0 0.1 1252 400 tty2 S Dec21 0:00 /sbin/getty 38400 tty2
    root 819 0.0 0.1 1252 400 tty3 S Dec21 0:00 /sbin/getty 38400 tty3
    root 820 0.0 0.1 1252 400 tty4 S Dec21 0:00 /sbin/getty 38400 tty4
    root 821 0.0 0.1 1252 400 tty5 S Dec21 0:00 /sbin/getty 38400 tty5
    root 824 0.0 0.1 1252 400 tty6 S Dec21 0:00 /sbin/getty 38400 tty6
    news 841 0.0 0.4 2200 1116 ? S Dec21 0:00 /bin/sh /usr/lib/news/bin/innwatch
    nobody 985 0.0 0.1 1560 456 ? S Dec21 0:00 noip2-Linux -c /root/noip/noip.conf
    root 9168 0.0 0.6 4072 1732 ? S 09:11 0:01 /usr/sbin/smbd -D
    root 9478 0.0 0.7 4004 1832 ? S 13:29 0:00 /usr/sbin/smbd -D
    www-data 9846 0.0 1.7 138428 4428 ? S 14:52 0:00 /usr/sbin/apache
    www-data 9850 0.0 1.7 138488 4492 ? S 14:52 0:00 /usr/sbin/apache
    www-data 9856 0.0 1.7 138456 4460 ? S 14:55 0:00 /usr/sbin/apache
    root 9919 0.0 0.4 3876 1168 ? S 15:16 0:00 /usr/sbin/squid -D -sYC
    proxy 9922 0.0 3.3 14984 8556 ? S 15:16 0:05 (squid) -D -sYC
    proxy 9923 0.0 0.2 1872 760 ? S 15:16 0:00 (ncsa_auth) /etc/squid/passwd
    proxy 9924 0.0 0.1 1800 468 ? S 15:16 0:00 (ncsa_auth) /etc/squid/passwd
    proxy 9925 0.0 0.1 1800 468 ? S 15:16 0:00 (ncsa_auth) /etc/squid/passwd
    proxy 9926 0.0 0.1 1800 468 ? S 15:16 0:00 (ncsa_auth) /etc/squid/passwd
    proxy 9927 0.0 0.1 1800 468 ? S 15:16 0:00 (ncsa_auth) /etc/squid/passwd
    proxy 10038 0.0 0.1 1244 304 ? S 15:16 0:00 (unlinkd)
    www-data 10039 0.0 1.7 138476 4548 ? S 15:16 0:00 /usr/sbin/apache
    www-data 10040 0.0 1.7 138504 4552 ? S 15:16 0:00 /usr/sbin/apache
    www-data 10041 0.0 1.6 138444 4308 ? S 15:16 0:00 /usr/sbin/apache
    root 10493 0.0 0.7 6416 1800 ? S 15:56 0:00 /usr/sbin/sshd
    root 10495 0.0 0.4 2228 1272 pts/3 S 15:56 0:00 -bash
    postfix 10499 0.0 0.3 2436 1000 ? S 15:58 0:00 pickup -l -t fifo -u -c
    root 10524 0.0 0.3 2052 968 pts/3 S 16:09 0:00 /bin/sh /usr/bin/safe_mysqld
    mysql 10562 0.0 1.9 36520 4856 pts/3 S 16:09 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking
    mysql 10564 0.0 1.9 36520 4856 pts/3 S 16:09 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking
    mysql 10565 0.0 1.9 36520 4856 pts/3 S 16:09 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking
    mysql 10566 0.0 1.9 36520 4856 pts/3 S 16:09 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking
    www-data 10640 0.0 1.6 138428 4268 ? S 16:46 0:00 /usr/sbin/apache
    www-data 10646 0.0 1.6 138412 4284 ? S 16:55 0:00 /usr/sbin/apache
    news 10659 0.0 0.1 1528 508 ? S 17:00 0:00 sleep 600
    root 10669 0.0 0.6 3564 1596 pts/3 R 17:08 0:00 ps auxw

  7. #7

    Padrão mysqld...failed

    tente :

    killall -9 /usr/bin/safe_mysqld
    ou
    killall -9 safe_mysqld

    killall -9 /usr/sbin/mysqld
    ou
    killall -9 mysqld

    Faça isso e depois envie a saida do comando novamente.

  8. #8
    grilo
    Visitante

    Padrão mysqld...failed

    Citação Postado originalmente por fred_m
    tente :

    killall -9 /usr/bin/safe_mysqld
    ou
    killall -9 safe_mysqld

    killall -9 /usr/sbin/mysqld
    ou
    killall -9 mysqld

    Faça isso e depois envie a saida do comando novamente.
    killall -9 /usr/bin/safe_mysqld
    saida
    net256:~# killall -9 /usr/bin/safe_mysqld
    /usr/bin/safe_mysqld: no process killed
    net256:~#


    killall -9 safe_mysqld
    saida:
    net256:~# killall -9 safe_mysqld
    net256:~#


    killall -9 /usr/sbin/mysqld
    saida
    net256:~# killall -9 /usr/sbin/mysqld
    /usr/sbin/mysqld: no process killed
    net256:~#



    killall -9 mysqld
    saida
    net256:~# killall -9 mysqld
    net256:~#


    Tentei restarta ele de novo e deu falha
    net256:~# /etc/init.d/mysql restart
    Stopping MySQL database server: mysqld.
    Starting MySQL database server: mysqld...failed.
    net256:~#

  9. #9

    Padrão mysqld...failed

    Você já tentou reinicar o servidor ???

  10. #10
    grilo
    Visitante

    Padrão mysqld...failed

    Citação Postado originalmente por fred_m
    Você já tentou reinicar o servidor ???
    ja reiniciei e ainda continua a falha.


    tem q fazer alguma coniguraçao pra isto funcionar? qual?

  11. #11

    Padrão mysqld...failed

    Faz o seguinte, vamos ao extremo. Faz um bckup de tuas bases, remove o mysql e depois reinstala ele.

  12. #12
    grilo
    Visitante

    Padrão mysqld...failed

    Citação Postado originalmente por fred_m
    Faz o seguinte, vamos ao extremo. Faz um bckup de tuas bases, remove o mysql e depois reinstala ele.
    desistalei o mysql-server pelo apt-get
    #apt-get remove mysql-server

    depois instalei ele de novo pelo apte-get

    #apt-get install mysql-server
    #mysqladmin -u root -p 'newpassword'

    eu entro nele e trabalho tranquilo, mas se eu tentar restarta ele o erro persiste, eu tenho q instalar algo mais? so instalei o mysql-server pelo apt-get e nao configurei mais nada..

    uso debian 3, e tou querendo conectar remoto nele..

  13. #13

    Padrão mysqld...failed

    instala o mysql-client.

    Qual a versão do mysql que você está instalando ???

  14. #14
    grilo
    Visitante

    Padrão mysqld...failed

    Citação Postado originalmente por fred_m
    instala o mysql-client.

    Qual a versão do mysql que você está instalando ???
    prontinho ja ta instalado o client mas o erro persiste

  15. #15

    Padrão mysqld...failed

    A saida do arquivio mysqld.log é a mesma informado acima??

    Qual a versão do mysql ???

    você pode tentar usar uma versão anterior.

  16. #16
    grilo
    Visitante

    Padrão mysqld...failed

    kra beleza, ja deu tudo certo, uso o MySQL 3.23.49-log

    depois q reinstalei dai funcionou..


    obrigado