MySQL Trouble

Discussion in 'PSA 2.5 Troubleshooting and Problems' started by BurtonHost, Apr 17, 2002.

  1. BurtonHost

    BurtonHost Guest

    Hi,

    When i try to restart PSA.. i am getting the following about MySQL

    psa: named has been restarted
    Remaining processes:
    PID TTY STAT TIME COMMAND
    30444 ? S 0:04 /usr/local/psa/mysql/libexec/mysqld --basedir=/usr/local/psa/mysql --datadir=/usr/local/psa/mysql/var --u
    30446 ? S 0:05 /usr/local/psa/mysql/libexec/mysqld --basedir=/usr/local/psa/mysql --datadir=/usr/local/psa/mysql/var --u
    30447 ? S 0:00 /usr/local/psa/mysql/libexec/mysqld --basedir=/usr/local/psa/mysql --datadir=/usr/local/psa/mysql/var --u
    4344 ? S 0:00 /usr/local/psa/mysql/libexec/mysqld --basedir=/usr/local/psa/mysql --datadir=/usr/local/psa/mysql/var --u
    4345 ? S 0:00 /usr/local/psa/mysql/libexec/mysqld --basedir=/usr/local/psa/mysql --datadir=/usr/local/psa/mysql/var --u
    4356 ? S 0:00 /usr/local/psa/mysql/libexec/mysqld --basedir=/usr/local/psa/mysql --datadir=/usr/local/psa/mysql/var --u
    4368 ? S 0:00 /usr/local/psa/mysql/libexec/mysqld --basedir=/usr/local/psa/mysql --datadir=/usr/local/psa/mysql/var --u
    4370 ? S 0:00 /usr/local/psa/mysql/libexec/mysqld --basedir=/usr/local/psa/mysql --datadir=/usr/local/psa/mysql/var --u
    4692 ? S 0:00 /usr/local/psa/mysql/libexec/mysqld --basedir=/usr/local/psa/mysql --datadir=/usr/local/psa/mysql/var --u
    4703 ? S 0:00 /usr/local/psa/mysql/libexec/mysqld --basedir=/usr/local/psa/mysql --datadir=/usr/local/psa/mysql/var --u
    5222 ? S 0:00 /usr/local/psa/mysql/libexec/mysqld --basedir=/usr/local/psa/mysql --datadir=/usr/local/psa/mysql/var --u
    5283 ? S 0:00 /usr/local/psa/mysql/libexec/mysqld --basedir=/usr/local/psa/mysql --datadir=/usr/local/psa/mysql/var --u
    5301 ? S 0:00 /usr/local/psa/mysql/libexec/mysqld --basedir=/usr/local/psa/mysql --datadir=/usr/local/psa/mysql/var --u
    5306 ? S 0:00 /usr/local/psa/mysql/libexec/mysqld --basedir=/usr/local/psa/mysql --datadir=/usr/local/psa/mysql/var --u
    5320 ? S 0:00 /usr/local/psa/mysql/libexec/mysqld --basedir=/usr/local/psa/mysql --datadir=/usr/local/psa/mysql/var --u
    5339 ? S 0:00 /usr/local/psa/mysql/libexec/mysqld --basedir=/usr/local/psa/mysql --datadir=/usr/local/psa/mysql/var --u
    5348 ? S 0:00 /usr/local/psa/mysql/libexec/mysqld --basedir=/usr/local/psa/mysql --datadir=/usr/local/psa/mysql/var --u
    5363 ? S 0:00 /usr/local/psa/mysql/libexec/mysqld --basedir=/usr/local/psa/mysql --datadir=/usr/local/psa/mysql/var --u
    5365 ? S 0:00 /usr/local/psa/mysql/libexec/mysqld --basedir=/usr/local/psa/mysql --datadir=/usr/local/psa/mysql/var --u
    5381 ? S 0:00 /usr/local/psa/mysql/libexec/mysqld --basedir=/usr/local/psa/mysql --datadir=/usr/local/psa/mysql/var --u
    5385 ? S 0:00 /usr/local/psa/mysql/libexec/mysqld --basedir=/usr/local/psa/mysql --datadir=/usr/local/psa/mysql/var --u
    5392 ? S 0:00 /usr/local/psa/mysql/libexec/mysqld --basedir=/usr/local/psa/mysql --datadir=/usr/local/psa/mysql/var --u
    5402 ? S 0:00 /usr/local/psa/mysql/libexec/mysqld --basedir=/usr/local/psa/mysql --datadir=/usr/local/psa/mysql/var --u
    5404 ? S 0:00 /usr/local/psa/mysql/libexec/mysqld --basedir=/usr/local/psa/mysql --datadir=/usr/local/psa/mysql/var --u
    5535 ? S 0:00 /usr/local/psa/mysql/libexec/mysqld --basedir=/usr/local/psa/mysql --datadir=/usr/local/psa/mysql/var --u
    5539 ? S 0:00 /usr/local/psa/mysql/libexec/mysqld --basedir=/usr/local/psa/mysql --datadir=/usr/local/psa/mysql/var --u
    5541 ? S 0:00 /usr/local/psa/mysql/libexec/mysqld --basedir=/usr/local/psa/mysql --datadir=/usr/local/psa/mysql/var --u
    5570 ? S 0:00 /usr/local/psa/mysql/libexec/mysqld --basedir=/usr/local/psa/mysql --datadir=/usr/local/psa/mysql/var --u
    5580 ? S 0:00 /usr/local/psa/mysql/libexec/mysqld --basedir=/usr/local/psa/mysql --datadir=/usr/local/psa/mysql/var --u
    5687 ? S 0:00 /usr/local/psa/mysql/libexec/mysqld --basedir=/usr/local/psa/mysql --datadir=/usr/local/psa/mysql/var --u
    5688 ? S 0:00 /usr/local/psa/mysql/libexec/mysqld --basedir=/usr/local/psa/mysql --datadir=/usr/local/psa/mysql/var --u
    5689 ? S 0:00 /usr/local/psa/mysql/libexec/mysqld --basedir=/usr/local/psa/mysql --datadir=/usr/local/psa/mysql/var --u
    5690 ? S 0:00 /usr/local/psa/mysql/libexec/mysqld --basedir=/usr/local/psa/mysql --datadir=/usr/local/psa/mysql/var --u
    5691 ? S 0:00 /usr/local/psa/mysql/libexec/mysqld --basedir=/usr/local/psa/mysql --datadir=/usr/local/psa/mysql/var --u
    5694 ? S 0:00 /usr/local/psa/mysql/libexec/mysqld --basedir=/usr/local/psa/mysql --datadir=/usr/local/psa/mysql/var --u
    5712 ? S 0:00 /usr/local/psa/mysql/libexec/mysqld --basedir=/usr/local/psa/mysql --datadir=/usr/local/psa/mysql/var --u
    5719 ? S 0:00 /usr/local/psa/mysql/libexec/mysqld --basedir=/usr/local/psa/mysql --datadir=/usr/local/psa/mysql/var --u
    5720 ? S 0:00 /usr/local/psa/mysql/libexec/mysqld --basedir=/usr/local/psa/mysql --datadir=/usr/local/psa/mysql/var --u
    5806 ? S 0:00 /usr/local/psa/mysql/libexec/mysqld --basedir=/usr/local/psa/mysql --datadir=/usr/local/psa/mysql/var --u
    5827 ? S 0:00 /usr/local/psa/mysql/libexec/mysqld --basedir=/usr/local/psa/mysql --datadir=/usr/local/psa/mysql/var --u
    5829 ? S 0:00 /usr/local/psa/mysql/libexec/mysqld --basedir=/usr/local/psa/mysql --datadir=/usr/local/psa/mysql/var --u
    5868 ? S 0:00 /usr/local/psa/mysql/libexec/mysqld --basedir=/usr/local/psa/mysql --datadir=/usr/local/psa/mysql/var --u
    6283 ? S 0:00 /usr/local/psa/mysql/libexec/mysqld --basedir=/usr/local/psa/mysql --datadir=/usr/local/psa/mysql/var --u
    6444 ? S 0:00 /usr/local/psa/mysql/libexec/mysqld --basedir=/usr/local/psa/mysql --datadir=/usr/local/psa/mysql/var --u
    30444 30446 30447 4344 4345 4356 4368 4370 4692 4703 5222 5283 5301 5306 5320 5339 5348 5363 5365 5381 5385 5392 5402 5404 5535 5539 5541 5570 5580 5687 5688 5689 5690 5691 5694 5712 5719 5720 5806 5827 5829 5868 6283 6444 6842
    psa: failed to restart mysql
    psa: admin server has been restarted
    psa: Apache server has been restarted
    psa: Qmail server has been restarted
    psa: Courier-IMAP server has been restarted
    psa: stunnel daemon has been restarted

    Any ideas on what the problem may be? Any Solutions? Greatly received!

    Thanks
     
  2. serve-you.net

    serve-you.net Guru

    Messages:
    1,896
    Do you have the same problem when you stop psa, wait 30 seconds, then start, rather than just a restart?
     
  3. BurtonHost

    BurtonHost Guest

    Even when I stop PSA.. processes of MySQL are still running...
     
  4. serve-you.net

    serve-you.net Guru

    Messages:
    1,896
    Something is still trying to access a db probably. You can manually kill all of the mysql processes by doing a kill -9 on the PID's or just reboot.
     
  5. BurtonHost

    BurtonHost Guest

    Thanks, working fine now :)
     

Share This Page