• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

ERROR: PleskFatalException: Unable to connect to database: mysql_connect(): No such f

I

IFFIOLEN

New Pleskian
Hi,

My problem is as follows
ERROR: PleskFatalException: Unable to connect to database: mysql_connect(): No such file or directory (auth.php:142)
Click to expand...

I am a new user Parallel pleski. Please help how do I get the panel to work.

Sry my bad english.

I've tried the following things

# /etc/init.d/mysql start
[FAIL] Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
Click to expand...
and
# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Click to expand...
and
# ls -l /var/run/ | grep mysqld
drwxr-xr-x 2 mysql root 40 Feb 15 06:29 mysqld
Click to expand...
ning sellega ei saa mingit vastust
# ls -l | grep mysql
Click to expand...
and
# ps -ef |grep mysql
root 23242 16722 0 06:38 pts/0 00:00:00 grep mysql
Click to expand...
and
# apt-get install mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
mysql-server is already the newest version.
The following packages were automatically installed and are no longer required:
libidn11:i386 libssh2-1:i386
Use 'apt-get autoremove' to remove them.
0 upgraded, 0 newly installed, 0 to remove and 3 not upgraded.
Click to expand...


/tmp/plesk_11.5.30_reset_instance_data.log LOG
START Doing reset_instance_data --psa-init AT Fri Feb 14 17:12:46 EET 2014
Trying to start service mysql... /usr/sbin/mysqld is stopped
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
invoke-rc.d: initscript mysql, action "start" failed.

WARNING!
Some problems are found during start(see log file: /tmp/plesk_11.5.30_reset_instance_data.log)

Continue...

Trying to establish test connection... ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
[...]
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
failed

ERROR while trying to establish test connection
Check the error reason(see log file: /tmp/plesk_11.5.30_reset_instance_data.log), fix and try again

START Doing reset_instance_data --psa-init AT Sat Feb 15 06:47:06 EET 2014
Trying to start service mysql... /usr/sbin/mysqld is stopped
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
invoke-rc.d: initscript mysql, action "start" failed.

WARNING!
Some problems are found during start(see log file: /tmp/plesk_11.5.30_reset_instance_data.log)

Continue...

Trying to establish test connection... ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
[...]
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
failed

ERROR while trying to establish test connection
Check the error reason(see log file: /tmp/plesk_11.5.30_reset_instance_data.log), fix and try again
Click to expand...


/var/log/mysql is empty

/etc/mysql/my.cnf
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock



[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0

[mysqld]
local-infile=0



user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
set-variable=max_connections=200



key_buffer = 16M
ft_min_word = 3
max_allowed_packet = 20M
thread_stack = 192K
thread_cache_size = 8


myisam-recover = BACKUP



query_cache_limit = 1M
query_cache_size = 20M



expire_logs_days = 10
max_binlog_size = 100M



[mysqldump]
quick
quote-names
max_allowed_packet = 16M

[mysql]


[isamchk]
key_buffer = 16M

!includedir /etc/mysql/conf.d/
Click to expand...
 
Last edited:
Hi,

Thank you for responding, but this file is not mysqld.log

There is a file mysql.log 0bytes and mysql folder empty

In the meantime, I got back to work mysql server but has lost all databases. Parallel Plesk can not use mysql and databases(I do not have copies of these backup).
 
Last edited:
IFFIOLEN said:
Hi,

Thank you for responding, but this file is not mysqld.log

There is a file mysql.log 0bytes and mysql folder empty

In the meantime, I got back to work mysql server but has lost all databases. Parallel Plesk can not use mysql and databases(I do not have copies of these backup).

The panel still does not work https://78.46.75.53:8443/login_up.php3
Click to expand...

I have the same issue.

# /etc/init.d/psa restart

Code: 
Stopping sw-engine-fpm:                                    [  OK  ]
Starting sw-engine-fpm:                                    [  OK  ]
*** glibc detected *** /usr/libexec/mysqld: double free or corruption (fasttop): 0x090a9a88 ***
======= Backtrace: =========
/lib/libc.so.6[0xb7344d35]
/lib/libc.so.6(cfree+0x59)[0xb7348da9]
/usr/libexec/mysqld(my_free+0x1d)[0x842930d]
/usr/libexec/mysqld(_ZN16Security_context7destroyEv+0x131)[0x817fd31]
/usr/libexec/mysqld(_ZN3THDD0Ev+0x17b)[0x8182eab]
/usr/libexec/mysqld(_Z10delete_thdP3THD+0x2e)[0x81226de]
/usr/libexec/mysqld(_Z10unlink_thdP3THD+0xa6)[0x812a1e6]
/usr/libexec/mysqld(_Z29one_thread_per_connection_endP3THDb+0x29)[0x812a239]
/usr/libexec/mysqld(_Z24do_handle_one_connectionP3THD+0xe7)[0x825fbf7]
/usr/libexec/mysqld(handle_one_connection+0x5d)[0x825fd4d]
/lib/libpthread.so.0[0xb773c912]
/lib/libc.so.6(clone+0x5e)[0xb73b07ce]
======= Memory map: ========
08048000-0893c000 r-xp 00000000 00:27 23074003                           /usr/libexec/mysqld
0893c000-08a05000 rw-p 008f4000 00:27 23074003                           /usr/libexec/mysqld
08a05000-090da000 rw-p 00000000 00:00 0                                  [heap]
a21ce000-a21cf000 ---p 00000000 00:00 0 
a21cf000-a2bcf000 rw-p 00000000 00:00 0 
a2bcf000-a2bd0000 ---p 00000000 00:00 0 
a2bd0000-a35d0000 rw-p 00000000 00:00 0 
a35d0000-a35d1000 ---p 00000000 00:00 0 
a35d1000-a3fd1000 rw-p 00000000 00:00 0 
a3fd1000-a3fd2000 ---p 00000000 00:00 0 
a3fd2000-a4c60000 rw-p 00000000 00:00 0 
a4e00000-a4e44000 rw-p 00000000 00:00 0 
a4e44000-a4f00000 ---p 00000000 00:00 0 
a4f0e000-a4f0f000 ---p 00000000 00:00 0 
a4f0f000-a4f3f000 rw-p 00000000 00:00 0 
a4f3f000-a4f40000 ---p 00000000 00:00 0 
a4f40000-a4f70000 rw-p 00000000 00:00 0 
a4f70000-a4f71000 ---p 00000000 00:00 0 
a4f71000-a5971000 rw-p 00000000 00:00 0 
a5971000-a5972000 ---p 00000000 00:00 0 
a5972000-a6372000 rw-p 00000000 00:00 0 
a6372000-a6373000 ---p 00000000 00:00 0 
a6373000-a6d73000 rw-p 00000000 00:00 0 
a6d73000-a6d74000 ---p 00000000 00:00 0 
a6d74000-a7774000 rw-p 00000000 00:00 0 
a7774000-a7775000 ---p 00000000 00:00 0 
a7775000-a8175000 rw-p 00000000 00:00 0 
a8175000-a8176000 ---p 00000000 00:00 0 
a8176000-a8b76000 rw-p 00000000 00:00 0 
a8b76000-a8b77000 ---p 00000000 00:00 0 
a8b77000-a9577000 rw-p 00000000 00:00 0 
a9577000-a9578000 ---p 00000000 00:00 0 
a9578000-a9f78000 rw-p 00000000 00:00 0 
a9f78000-a9f79000 ---p 00000000 00:00 0 
a9f79000-b676a000 rw-p 00000000 00:00 0 
b676a000-b6774000 r-xp 00000000 00:27 18483633                           /lib/libnss_files-2.5.so
b6774000-b6775000 r--p 00009000 00:27 18483633                           /lib/libnss_files-2.5.so
b6775000-b6776000 rw-p 0000a000 00:27 18483633                           /lib/libnss_files-2.5.so
b6776000-b6777000 ---p 00000000 00:00 0 
b6777000-b7179000 rw-p 00000000 00:00 0 
b7179000-b71b1000 r-xp 00000000 00:27 18483658                           /lib/libsepol.so.1
b71b1000-b71b2000 rw-p 00038000 00:27 18483658                           /lib/libsepol.so.1
b71b2000-b71c8000 r-xp 00000000 00:27 18483656                           /lib/libselinux.so.1
b71c8000-b71ca000 rw-p 00015000 00:27 18483656                           /lib/libselinux.so.1
b71ca000-b71cc000 r-xp 00000000 00:27 18483620                           /lib/libkeyutils-1.2.so
b71cc000-b71cd000 rw-p 00001000 00:27 18483620                           /lib/libkeyutils-1.2.so
b71cd000-b71d5000 r-xp 00000000 00:27 23073681                           /usr/lib/libkrb5support.so.0.1
b71d5000-b71d6000 rw-p 00007000 00:27 23073681                           /usr/lib/libkrb5support.so.0.1
b71d6000-b71d7000 rw-p 00000000 00:00 0 
b71d7000-b71e8000 r-xp 00000000 00:27 18483652                           /lib/libresolv-2.5.so
b71e8000-b71e9000 r--p 00010000 00:27 18483652                           /lib/libresolv-2.5.so
b71e9000-b71ea000 rw-p 00011000 00:27 18483652                           /lib/libresolv-2.5.so
b71ea000-b71ec000 rw-p 00000000 00:00 0 
b71ec000-b7212000 r-xp 00000000 00:27 23073655                           /usr/lib/libk5crypto.so.3.1
b7212000-b7213000 rw-p 00025000 00:27 23073655                           /usr/lib/libk5crypto.so.3.1
b7213000-b7215000 r-xp 00000000 00:27 18483570                           /lib/libcom_err.so.2.1
b7215000-b7216000 rw-p 00001000 00:27 18483570                           /lib/libcom_err.so.2.1
b7216000-b72aa000 r-xp 00000000 00:27 23073677                           /usr/lib/libkrb5.so.3.3
b72aa000-b72ad000 rw-p 00093000 00:27 23073677                           /usr/lib/libkrb5.so.3.3
b72ad000-b72d9000 r-xp 00000000 00:27 23073598                           /usr/lib/libgssapi_krb5.so.2.2
b72d9000-b72da000 rw-p 0002c000 00:27 23073598                           /usr/lib/libgssapi_krb5.so.2.2
b72da000-b72db000 rw-p 00000000 00:00 0 
b72db000-b7432000 r-xp 00000000 00:27 18483563                           /lib/libc-2.5.so
b7432000-b7434000 r--p 00157000 00:27 18483563                           /lib/libc-2.5.so
b7434000-b7435000 rw-p 00159000 00:27 18483563                           /lib/libc-2.5.so
b7435000-b7438000 rw-p 00000000 00:00 0 
b7438000-b7443000 r-xp 00000000 00:27 18483602                           /lib/libgcc_s-4.1.2-20080825.so.1
b7443000-b7444000 rw-p 0000a000 00:27 18483602                           /lib/libgcc_s-4.1.2-20080825.so.1
b7444000-b746b000 r-xp 00000000 00:27 18483625                           /lib/libm-2.5.so
b746b000-b746c000 r--p 00026000 00:27 18483625                           /lib/libm-2.5.so
b746c000-b746d000 rw-p 00027000 00:27 18483625                           /lib/libm-2.5.so
b746d000-b754b000 r-xp 00000000 00:27 23074006                           /usr/lib/libstdc++.so.6.0.8
b754b000-b754e000 r--p 000dd000 00:27 23074006                           /usr/lib/libstdc++.so.6.0.8
b754e000-b7550000 rw-p 000e0000 00:27 23074006                           /usr/lib/libstdc++.so.6.0.8
b7550000-b7556000 rw-p 00000000 00:00 0 
b7556000-b7680000 r-xp 00000000 00:27 18483540                           /lib/libcrypto.so.0.9.8e
b7680000-b7694000 rw-p 00129000 00:27 18483540                           /lib/libcrypto.so.0.9.8e
b7694000-b7697000 rw-p 00000000 00:00 0 
b7697000-b76dd000 r-xp 00000000 00:27 18483574                           /lib/libssl.so.0.9.8e
b76dd000-b76e1000 rw-p 00045000 00:27 18483574                           /lib/libssl.so.0.9.8e
b76e1000-b76e2000 rw-p 00000000 00:00 0 
b76e2000-b76e5000 r-xp 00000000 00:27 18483588                           /lib/libdl-2.5.so
b76e5000-b76e6000 r--p 00002000 00:27 18483588                           /lib/libdl-2.5.so
b76e6000-b76e7000 rw-p 00003000 00:27 18483588                           /lib/libdl-2.5.so
b76e7000-b76f0000 r-xp 00000000 00:27 18483571                           /lib/libcrypt-2.5.so
b76f0000-b76f1000 r--p 00008000 00:27 18483571                           /lib/libcrypt-2.5.so
b76f1000-b76f2000 rw-p 00009000 00:27 18483571                           /lib/libcrypt-2.5.so
b76f2000-b7719000 rw-p 00000000 00:00 0 
b7719000-b7720000 r-xp 00000000 00:27 18483654                           /lib/librt-2.5.so
b7720000-b7721000 r--p 00007000 00:27 18483654                           /lib/librt-2.5.so
b7721000-b7722000 rw-p 00008000 00:27 18483654                           /lib/librt-2.5.soWarning: Using unique option prefix pass instead of password is deprecated and will be removed in a future release. Please use the full name instead.
ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 104
 
Continued...


/var/log/mysqld.log

Code: 
140221 23:04:59  InnoDB: Unable to open the first data file
InnoDB: Error in opening ./ibdata1
140221 23:04:59  InnoDB: Operating system error number 11 in a file operation.
InnoDB: Error number 11 means 'Resource temporarily unavailable'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.html
140221 23:04:59 InnoDB: Could not open or create data files.
140221 23:04:59 InnoDB: If you tried to add new data files, and it failed here,
140221 23:04:59 InnoDB: you should now edit innodb_data_file_path in my.cnf back
140221 23:04:59 InnoDB: to what it was, and remove the new ibdata files InnoDB created
140221 23:04:59 InnoDB: in this failed attempt. InnoDB only wrote those files full of
140221 23:04:59 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
140221 23:04:59 InnoDB: remove old data files which contain your precious data!
140221 23:04:59 [ERROR] Plugin 'InnoDB' init function returned error.
140221 23:04:59 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140221 23:04:59 [ERROR] Unknown/unsupported storage engine: InnoDB
140221 23:04:59 [ERROR] Aborting

140221 23:04:59 [Note] /usr/libexec/mysqld: Shutdown complete

InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
140221 23:04:59  InnoDB: Unable to open the first data file
InnoDB: Error in opening ./ibdata1
140221 23:04:59  InnoDB: Operating system error number 11 in a file operation.
InnoDB: Error number 11 means 'Resource temporarily unavailable'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.html
140221 23:04:59 InnoDB: Could not open or create data files.
140221 23:04:59 InnoDB: If you tried to add new data files, and it failed here,
140221 23:04:59 InnoDB: you should now edit innodb_data_file_path in my.cnf back
140221 23:04:59 InnoDB: to what it was, and remove the new ibdata files InnoDB created
140221 23:04:59 InnoDB: in this failed attempt. InnoDB only wrote those files full of
140221 23:04:59 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
140221 23:04:59 InnoDB: remove old data files which contain your precious data!
140221 23:04:59 [ERROR] Plugin 'InnoDB' init function returned error.
140221 23:04:59 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140221 23:04:59 [ERROR] Unknown/unsupported storage engine: InnoDB
140221 23:04:59 [ERROR] Aborting

140221 23:04:59 [Note] /usr/libexec/mysqld: Shutdown complete

140221 23:04:59 mysqld_safe Number of processes running now: 1
140221 23:04:59 mysqld_safe Number of processes running now: 1
140221 23:04:59 mysqld_safe mysqld process hanging, pid 16088 - killed
140221 23:04:59 mysqld_safe mysqld process hanging, pid 16088 - killed
140221 23:04:59 mysqld_safe mysqld restarted
140221 23:04:59 mysqld_safe mysqld restarted
140221 23:04:59 [Note] libgovernor.so not found
140221 23:04:59 [Note] libgovernor.so not found
140221 23:04:59 [Note] Plugin 'FEDERATED' is disabled.
140221 23:04:59 [Note] Plugin 'FEDERATED' is disabled.
140221 23:04:59 InnoDB: The InnoDB memory heap is disabled
140221 23:04:59 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
140221 23:04:59 InnoDB: Compressed tables use zlib 1.2.3
140221 23:04:59 InnoDB: Using Linux native AIO
140221 23:04:59 InnoDB: The InnoDB memory heap is disabled
140221 23:04:59 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
140221 23:04:59 InnoDB: Compressed tables use zlib 1.2.3
140221 23:04:59 InnoDB: Using Linux native AIO
140221 23:04:59 InnoDB: Initializing buffer pool, size = 128.0M
140221 23:04:59 InnoDB: Initializing buffer pool, size = 128.0M
140221 23:04:59 InnoDB: Completed initialization of buffer pool
140221 23:04:59 InnoDB: Completed initialization of buffer pool
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
140221 23:04:59  InnoDB: Assertion failure in thread 3072145808 in file fil0fil.c line 834
InnoDB: Failing assertion: ret
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
06:04:59 UTC - mysqld got signal 6 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed, 
something is definitely wrong and this may fail.

key_buffer_size=16777216
read_buffer_size=131072
max_used_connections=0
max_threads=151
thread_count=0
connection_count=0
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 346113 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0 thread_stack 0x30000
140221 23:04:59 InnoDB: highest supported file format is Barracuda.
/usr/libexec/mysqld(my_print_stacktrace+0x33)[0x842d8a3]
/usr/libexec/mysqld(handle_fatal_signal+0x42b)[0x82dd86b]
[0xb77b9500]
[0xb77b9420]
/lib/libc.so.6(gsignal+0x50)[0xb735fe30]
/lib/libc.so.6(abort+0x101)[0xb7361741]
/usr/libexec/mysqld[0x856c5f4]
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
140221 23:04:59  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
/usr/libexec/mysqld[0x856ed27]
/usr/libexec/mysqld[0x84ee915]
/usr/libexec/mysqld[0x84b3d8b]
/usr/libexec/mysqld(_Z24ha_initialize_handlertonP13st_plugin_int+0x4e)[0x82dfa1e]
/usr/libexec/mysqld[0x81ba5c7]
/usr/libexec/mysqld(_Z11plugin_initPiPPci+0xb98)[0x81bdd78]
/usr/libexec/mysqld[0x812d02b]
/usr/libexec/mysqld(_Z11mysqld_mainiPPc+0x6dd)[0x812e14d]
/usr/libexec/mysqld(main+0x32)[0x8122692]
/lib/libc.so.6(__libc_start_main+0xdc)[0xb734cebc]
/usr/libexec/mysqld[0x81225a1]
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
140221 23:04:59 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
140221 23:04:59  InnoDB: Waiting for the background threads to start
140221 23:05:00 InnoDB: 5.5.36 started; log sequence number 120238272
140221 23:05:00 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
140221 23:05:00 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
140221 23:05:00 [Note] Server socket created on IP: '0.0.0.0'.
140221 23:05:00 [Note] Event Scheduler: Loaded 0 events
140221 23:05:00 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.36-cll-lve'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL) by Atomicorp
140221 23:06:40 mysqld_safe Number of processes running now: 0
140221 23:06:40 mysqld_safe mysqld restarted
140221 23:06:40 [Note] libgovernor.so not found
140221 23:06:40 [Note] Plugin 'FEDERATED' is disabled.
140221 23:06:40 InnoDB: The InnoDB memory heap is disabled
140221 23:06:40 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
140221 23:06:40 InnoDB: Compressed tables use zlib 1.2.3
140221 23:06:40 InnoDB: Using Linux native AIO
140221 23:06:40 InnoDB: Initializing buffer pool, size = 128.0M
140221 23:06:40 InnoDB: Completed initialization of buffer pool
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.

InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
140221 23:08:20  InnoDB: Unable to open the first data file
InnoDB: Error in opening ./ibdata1
140221 23:08:20  InnoDB: Operating system error number 11 in a file operation.
InnoDB: Error number 11 means 'Resource temporarily unavailable'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.html
140221 23:08:20 InnoDB: Could not open or create data files.
140221 23:08:20 InnoDB: If you tried to add new data files, and it failed here,
140221 23:08:20 InnoDB: you should now edit innodb_data_file_path in my.cnf back
140221 23:08:20 InnoDB: to what it was, and remove the new ibdata files InnoDB created
140221 23:08:20 InnoDB: in this failed attempt. InnoDB only wrote those files full of
140221 23:08:20 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
140221 23:08:20 InnoDB: remove old data files which contain your precious data!
140221 23:08:20 [ERROR] Plugin 'InnoDB' init function returned error.
140221 23:08:20 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140221 23:08:20 [ERROR] Unknown/unsupported storage engine: InnoDB
140221 23:08:20 [ERROR] Aborting

140221 23:08:20 [Note] /usr/libexec/mysqld: Shutdown complete
 
Many thanks to you experts in this forum, very helpful and quick answers to your hand. Burn off your support system here.

Within one week, the answer can not be. If you are unable to respond to feedback, do not offer help here. I got answers faster to your problem in Google
 
Last edited:
IFFIOLEN said:
Many thanks to you experts in this forum, very helpful and quick answers to your hand. Burn off your support system here.

Within one week, the answer can not be. If you are unable to respond to feedback, do not offer help here. I got answers faster to your problem in Google
Click to expand...

What are you expecting, for them to restore your databases or something? They likely have many other things going on and need to look at the reason for the errors. It's not like you were very proactive about the whole situation either; I don't disagree with you about getting a response, but customer service is a thing of the past in modern times unfortunately.
 
Same problem for me.

ERROR: PleskFatalException: Unable to connect to database: mysql_connect(): Resource temporarily unavailable (auth.php:142)

Server DOWN all the night.
I had to reboot (hardware) the server.

...and every time I reboot the server (sometime the provider do it automatically) mysql don't go up by itself because it was not close correctly.

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Maybe this should be fixed and mysql.sock move elsewhere when plesk restart
 
femotvaff said:
Same problem for me.

ERROR: PleskFatalException: Unable to connect to database: mysql_connect(): Resource temporarily unavailable (auth.php:142)

Server DOWN all the night.
I had to reboot (hardware) the server.

...and every time I reboot the server (sometime the provider do it automatically) mysql don't go up by itself because it was not close correctly.

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Maybe this should be fixed and mysql.sock move elsewhere when plesk restart
Click to expand...

What sort of error do you have in mysql log?
 
IgorG, if you want I can give you root access,
now the server is responding only for few minute than crashes... the configuration is the default one :( it's plesk 11.5
only installed linux update to try to resolve crash problems.
 
femotvaff said:
IgorG, if you want I can give you root access,
now the server is responding only for few minute than crashes... the configuration is the default one :( it's plesk 11.5
only installed linux update to try to resolve crash problems.
Click to expand...
Send root credentials to me in PM, please. I will try to find a reason.
 
Some news about that? Yesterday I updated Plesk from #35 to the last #40 (if I'm not getting wrong, I'm on mobile right now).

Today, since I found the main VPS domain down for server maintenance (?) I check Plesk and give me this error after login:

ERROR: PleskFatalException: Unable to connect to database: mysql_connect(): No such file or directory (auth.php:149)
 
You must log in or register to reply here.

Similar threads

Amadex
Resolved Problems with MariaDB update on CloudLinux 8
Replies
3
Views
2K
Nikolay
Nikolay
S
Resolved Error 500 Plesk\Exception\Database DB query failed: SQLSTATE[HY000] [2002] No such file or directory
Replies
10
Views
349
Shasam
S
P
Resolved Failed to start MariaDB database server.
Replies
2
Views
8K
pattolentno
P
M
Resolved Server Error 500 Plesk\Exception\Database
Replies
2
Views
1K
mrcx
M
F
Question Having difficulties setting up MySQL docker for use in Plesk
Replies
3
Views
2K
aronaugust
A
Back
Top