Mysql Issue

[YasinA]

Hello

Yesterday my mysql service stopped with an unknown reason and i cannot restart it also i cannot connect it, the error when i try to enter pma

#1135 - Can't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug

Any help would be ver nice.

 

[IgorG]

Do you have any error messages in Event Viewer related to problem with MySQL starting?

 

[YasinA]

After i restart mysql it gives too many connections error.

 

[IgorG]

What sort of these errors? Is there errors in Event Viewer? Can you post them here?

 

[YasinA]

There are a lot of errors but all of them same

Failed to connect to database: Too many connections
at (MySQLDatabaseProvider::connect line 214)
at execute console command --del-user(vconsoleapp::start line 129)
at execute "C:\Program Files (x86)\Parallels\Plesk\/admin/bin/mysqlmng" --del-user "--server=localhost" "--port=3306" "--login=admin" "--password=*" "--user-login=karamurat"(vconsoleapp::run line 140)
Execute file name: C:\Program Files (x86)\Parallels\Plesk\admin\bin\mysqlmng.exe

 

[IgorG]

Try to increase max_connections in my.cnf file and start MySQL server again. More details here http://dev.mysql.com/doc/refman/5.1/en/too-many-connections.html

 

[rasoolp]

mysqld: Disk is full writing

Disk is full writing mysql and

df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda3 20G 7.4G 12G 40% /
/dev/sda5 2.0G 61M 1.8G 4% /tmp
/dev/sda2 241G 215G 14G 95% /var
/dev/sda1 122M 12M 104M 11% /boot
tmpfs 2.0G 0 2.0G 0% /dev/shm
//192.168.100.10/pourghaderi
455G 347G 108G 77% /hardshare
tmpfs 2.0G 0 2.0G 0% /usr/local/psa/handlers/before-local
tmpfs 2.0G 0 2.0G 0% /usr/local/psa/handlers/before-queue
tmpfs 2.0G 0 2.0G 0% /usr/local/psa/handlers/before-remote
tmpfs 2.0G 34M 2.0G 2% /usr/local/psa/handlers/info
tmpfs 2.0G 0 2.0G 0% /usr/local/psa/handlers/before-local
tmpfs 2.0G 0 2.0G 0% /usr/local/psa/handlers/before-queue
tmpfs 2.0G 0 2.0G 0% /usr/local/psa/handlers/before-remote
tmpfs 2.0G 34M 2.0G 2% /usr/local/psa/handlers/info
tmpfs 2.0G 39M 2.0G 2% /usr/local/psa/handlers/spool

mysql log file

mysql

120314 18:22:23 [ERROR] /usr/libexec/mysqld: Disk is full writing './iccomco_mehrdad/Av_pagenotfound.MYD' (Errcode: 28). Waiting for someone to free space... Retry in 60 secs
120314 18:23:22 [ERROR] /usr/libexec/mysqld: Disk is full writing './altincoir_admin/jos_TeraWurflCache.MYD' (Errcode: 28). Waiting for someone to free space... Retry in 60 secs
120314 18:23:42 [ERROR] /usr/libexec/mysqld: Disk is full writing './behnamch_/jos_jstats_referrer.MYD' (Errcode: 28). Waiting for someone to free space... Retry in 60 secs
120314 18:25:20 [ERROR] /usr/libexec/mysqld: Disk is full writing './whmcs/tblactivitylog.MYD' (Errcode: 28). Waiting for someone to free space... Retry in 60 secs
120314 18:27:52 [ERROR] /usr/libexec/mysqld: Disk is full writing './rotomationus_roto1/jos_session.MYD' (Errcode: 28). Waiting for someone to free space... Retry in 60 secs
120314 18:28:03 [ERROR] /usr/libexec/mysqld: Disk is full writing './tdkarajcom_/jos_content.MYD' (Errcode: 28). Waiting for someone to free space... Retry in 60 secs
120314 18:32:23 [ERROR] /usr/libexec/mysqld: Disk is full writing './iccomco_mehrdad/Av_pagenotfound.MYD' (Errcode: 28). Waiting for someone to free space... Retry in 60 secs
120314 18:33:22 [ERROR] /usr/libexec/mysqld: Disk is full writing './altincoir_admin/jos_TeraWurflCache.MYD' (Errcode: 28). Waiting for someone to free space... Retry in 6120314 19:25:52 InnoDB: Starting shutdown...
120314 19:25:54 InnoDB: Shutdown completed; log sequence number 0 4214366075
120314 19:25:54 [Note] /usr/libexec/mysqld: Shutdown complete

120314 19:25:55 mysqld ended

120314 19:25:55 mysqld started
120314 19:25:55 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
120314 19:25:55 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
120314 19:25:55 InnoDB: Started; log sequence number 0 4214366075
120314 19:25:55 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77-log' socket: '/var/lib/mysql/mysql.sock' port: 0 Source distribution
120314 19:26:12 [ERROR] /usr/libexec/mysqld: Table './behnamch_/jos_jstats_visits' is marked as crashed and should be repaired
120314 19:26:12 [ERROR] /usr/libexec/mysqld: Table './behnamch_/jos_jstats_visits' is marked as crashed and should be repaired
120314 19:27:52 [ERROR] /usr/libexec/mysqld: Table './behnamch_/jos_jstats_visits' is marked as crashed and should be repaired
120314 19:27:52 [ERROR] /usr/libexec/mysqld: Table './behnamch_/jos_jstats_visits' is marked as crashed and should be repaired
120314 19:31:14 [ERROR] /usr/libexec/mysqld: Table './tdkarajcom_/jos_content' is marked as crashed and should be repaired
120314 19:31:14 [ERROR] /usr/libexec/mysqld: Table './tdkarajcom_/jos_content' is marked as crashed and should be repaired
120314 19:31:14 [ERROR] /usr/libexec/mysqld: Table './tdkarajcom_/jos_content' is marked as crashed and should be repaired
120314 19:31:14 [ERROR] /usr/libexec/mysqld: Table './tdkarajcom_/jos_content' is marked as crashed and should be repaired
120314 19:31:41 [ERROR] /usr/libexec/mysqld: Table './tdkarajcom_/jos_content' is marked as crashed and should be repaired
120314 19:31:41 [ERROR] /usr/libexec/mysqld: Table './tdkarajcom_/jos_content' is marked as crashed and should be repaired
120314 19:31:41 [ERROR] /usr/libexec/mysqld: Table './tdkarajcom_/jos_content' is marked as crashed and should be repaired
120314 19:31:41 [ERROR] /usr/libexec/mysqld: Table './tdkarajcom_/jos_content' is marked as crashed and should be repaired
120314 19:31:48 [ERROR] /usr/libexec/mysqld: Table './tdkarajcom_/jos_content' is marked as crashed and should be repaired
120314 19:31:48 [ERROR] /usr/libexec/mysqld: Table './tdkarajcom_/jos_content' is marked as crashed and should be repaired
120314 19:31:48 [ERROR] /usr/libexec/mysqld: Table './tdkarajcom_/jos_content' is marked as crashed and should be repaired
120314 19:31:48 [ERROR] /usr/libexec/mysqld: Table './tdkarajcom_/jos_content' is marked as crashed and should be repaired
120314 19

how solve this problem
please help me
best regards
russell

 

[HaroldT]

Getting same thing. Whole site went down and parallel control panel to. Can't access anything !Here is the Error:

ERROR: PleskFatalException Unable to connect to database: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections 0: common_func.php3:95 psaerror(string 'Unable to connect to database: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections') 1: auth.php3:124