• Our team is looking to connect with folks who use email services provided by Plesk, or a premium service. If you'd like to be part of the discovery process and share your experiences, we invite you to complete this short screening survey. If your responses match the persona we are looking for, you'll receive a link to schedule a call at your convenience. We look forward to hearing from you!
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

Mysql Issue

Y

YasinA

New Pleskian
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.
 
Do you have any error messages in Event Viewer related to problem with MySQL starting?
 
What sort of these errors? Is there errors in Event Viewer? Can you post them here?
 
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
 
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
Click to expand...

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
Click to expand...
Click to expand...

how solve this problem
please help me
best regards
russell
 
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
 
You must log in or register to reply here.

Similar threads

abanico
Issue Cannot upgrade Plesk, error with mariadb-maxscale in installer
Replies
4
Views
530
Raul A.
R
J
Question Change default Mysql/Mariadb port - backup issue
Replies
4
Views
2K
Kaspar@Plesk
Kaspar@Plesk
Z
Issue Scheduled Backup: Not working anymore and access rights issues since 18.0.66
Replies
14
Views
1K
zamkc
Z
S
Issue Too many connections (Several plesk servers same problem in the last week)
Replies
8
Views
2K
SalvadorS
S
C
Question VM with Plesk and Ubuntu: Ubuntu Upgrade 22.04-LTS to 24.04-LTS fails
Replies
3
Views
1K
chris-taylor
C
Back
Top