Resolved URGENT: DB query failed: SQLSTATE[HY000] [2002] No such file or directory

[Murat Tamer]

I though I solved the problem but after waiting a couple of hours, plesk stopped again. I checked the /etc/mysql/my.cnf and bind-address is there again. Plesk reconfigurator changes the file every time.

 

[Murat Tamer]

yes it was from mysql log.
/var/log/mysql/error.log output like that:
I figured it out that if you disable ipv6, multiple failures are going on with plesk. As this was my first plesk installation, I just figured it. I reinstalled fresh ubuntu and did not disable ipv6, now plesk works fine.
Solved.

 

[tacobellrd]

who can help me

Server Error

500 Plesk\Exception\Database​

DB query failed: SQLSTATE[HY000]: General error: 1036 Table 'SessionContexts' is read only, query was: DELETE FROM `SessionContexts` WHERE (`sessionId` IN (SELECT `sessions`.`sess_id` FROM `sessions` WHERE (`modified` + `lifetime` < 1658424876)))

Type	Plesk\Exception\Database
Message	DB query failed: SQLSTATE[HY000]: General error: 1036 Table 'SessionContexts' is read only, query was: DELETE FROM `SessionContexts` WHERE (`sessionId` IN (SELECT `sessions`.`sess_id` FROM `sessions` WHERE (`modified` + `lifetime` < 1658424876)))
File	Mysql.php
Line	79

 

[IgorG]

who can help me

Server Error

500 Plesk\Exception\Database​

DB query failed: SQLSTATE[HY000]: General error: 1036 Table 'SessionContexts' is read only, query was: DELETE FROM `SessionContexts` WHERE (`sessionId` IN (SELECT `sessions`.`sess_id` FROM `sessions` WHERE (`modified` + `lifetime` < 1658424876)))

Type	Plesk\Exception\Database
Message	DB query failed: SQLSTATE[HY000]: General error: 1036 Table 'SessionContexts' is read only, query was: DELETE FROM `SessionContexts` WHERE (`sessionId` IN (SELECT `sessions`.`sess_id` FROM `sessions` WHERE (`modified` + `lifetime` < 1658424876)))
File	Mysql.php
Line	79

The reason why Plesk could not be started is because of the following Unable to login Plesk: 1015 Can't lock file (errno: 165 - Table is read only):
InnoDB databases were in a non-finished recovery process, which caused InnoDB to be set in read-only mode.
Complete the InnoDB recovery process: For Plesk for Linux or contact Plesk Support Team: https://support.plesk.com/hc/en-us/articles/213953025-How-to-get-support-directly-from-Plesk-

 

[tacobellrd]

Jul 25 09:28:51 ns519632.ip-158-69-54.net mariadbd[24145]: stack_bottom = 0x0 thread_stack 0x49000
Jul 25 09:28:51 ns519632.ip-158-69-54.net mariadbd[24145]: ??:0(my_print_stacktrace)[0x55b712533a6e]
Jul 25 09:28:51 ns519632.ip-158-69-54.net mariadbd[24145]: ??:0(handle_fatal_signal)[0x55b711f281a7]
Jul 25 09:28:51 ns519632.ip-158-69-54.net mariadbd[24145]: sigaction.c:0(__restore_rt)[0x7f788ff2b630]
Jul 25 09:28:51 ns519632.ip-158-69-54.net mariadbd[24145]: :0(__GI_raise)[0x7f788f376387]
Jul 25 09:28:51 ns519632.ip-158-69-54.net mariadbd[24145]: :0(__GI_abort)[0x7f788f377a78]
Jul 25 09:28:51 ns519632.ip-158-69-54.net mariadbd[24145]: /usr/sbin/mariadbd(+0x66ece5)[0x55b711bf5ce5]
Jul 25 09:28:51 ns519632.ip-158-69-54.net mariadbd[24145]: ??:0(std:air<std::_Rb_tree_iterator<unsigned int>, bool> std::_Rb_tree<unsigned int, unsigned int, std::_Identity<unsigned int>, std::less<unsigne
Jul 25 09:28:51 ns519632.ip-158-69-54.net mariadbd[24145]: ??:0(void std::__introsort_loop<unsigned char**, long>(unsigned char**, unsigned char**, long))[0x55b71233a687]
Jul 25 09:28:51 ns519632.ip-158-69-54.net mariadbd[24145]: ??:0(wsrep_notify_status(wsrep::server_state::state, wsrep::view const*))[0x55b7122256b7]
Jul 25 09:28:51 ns519632.ip-158-69-54.net mariadbd[24145]: ??:0(ha_initialize_handlerton(st_plugin_int*))[0x55b711f2aca0]
Jul 25 09:28:51 ns519632.ip-158-69-54.net mariadbd[24145]: ??:0(sys_var_pluginvar::sys_var_pluginvar(sys_var_chain*, char const*, st_plugin_int*, st_mysql_sys_var*, char const*))[0x55b711d2dfe0]
Jul 25 09:28:51 ns519632.ip-158-69-54.net mariadbd[24145]: ??:0(plugin_init(int*, char**, int))[0x55b711d2f263]
Jul 25 09:28:51 ns519632.ip-158-69-54.net mariadbd[24145]: ??:0(unireg_abort)[0x55b711c4aa4e]
Jul 25 09:28:51 ns519632.ip-158-69-54.net mariadbd[24145]: ??:0(mysqld_main(int, char**))[0x55b711c50a23]
Jul 25 09:28:51 ns519632.ip-158-69-54.net mariadbd[24145]: ??:0(__libc_start_main)[0x7f788f362555]
Jul 25 09:28:51 ns519632.ip-158-69-54.net mariadbd[24145]: ??:0(_start)[0x55b711c45203]
Jul 25 09:28:51 ns519632.ip-158-69-54.net mariadbd[24145]: The manual page at How to Produce a Full Stack Trace for mysqld contains
Jul 25 09:28:51 ns519632.ip-158-69-54.net mariadbd[24145]: information that should help you find out what is causing the crash.
Jul 25 09:28:51 ns519632.ip-158-69-54.net mariadbd[24145]: Writing a core file...
Jul 25 09:28:51 ns519632.ip-158-69-54.net mariadbd[24145]: Working directory at /var/lib/mysql
Jul 25 09:28:51 ns519632.ip-158-69-54.net mariadbd[24145]: Resource Limits:
Jul 25 09:28:51 ns519632.ip-158-69-54.net mariadbd[24145]: Limit Soft Limit Hard Limit Units
Jul 25 09:28:51 ns519632.ip-158-69-54.net mariadbd[24145]: Max cpu time unlimited unlimited seconds
Jul 25 09:28:51 ns519632.ip-158-69-54.net mariadbd[24145]: Max file size unlimited unlimited bytes
Jul 25 09:28:51 ns519632.ip-158-69-54.net mariadbd[24145]: Max data size unlimited unlimited bytes
Jul 25 09:28:51 ns519632.ip-158-69-54.net mariadbd[24145]: Max stack size 8388608 unlimited bytes
Jul 25 09:28:51 ns519632.ip-158-69-54.net mariadbd[24145]: Max core file size 0 unlimited bytes
Jul 25 09:28:51 ns519632.ip-158-69-54.net mariadbd[24145]: Max resident set unlimited unlimited bytes
Jul 25 09:28:51 ns519632.ip-158-69-54.net mariadbd[24145]: Max processes 126835 126835 processes
Jul 25 09:28:51 ns519632.ip-158-69-54.net mariadbd[24145]: Max open files 8192 8192 files
Jul 25 09:28:51 ns519632.ip-158-69-54.net mariadbd[24145]: Max locked memory 65536 65536 bytes
Jul 25 09:28:51 ns519632.ip-158-69-54.net mariadbd[24145]: Max address space unlimited unlimited bytes
Jul 25 09:28:51 ns519632.ip-158-69-54.net mariadbd[24145]: Max file locks unlimited unlimited locks
Jul 25 09:28:51 ns519632.ip-158-69-54.net mariadbd[24145]: Max pending signals 126835 126835 signals
Jul 25 09:28:51 ns519632.ip-158-69-54.net mariadbd[24145]: Max msgqueue size 819200 819200 bytes
Jul 25 09:28:51 ns519632.ip-158-69-54.net mariadbd[24145]: Max nice priority 0 0
Jul 25 09:28:51 ns519632.ip-158-69-54.net mariadbd[24145]: Max realtime priority 0 0
Jul 25 09:28:51 ns519632.ip-158-69-54.net mariadbd[24145]: Max realtime timeout unlimited unlimited us
Jul 25 09:28:51 ns519632.ip-158-69-54.net mariadbd[24145]: Core pattern: core
Jul 25 09:28:51 ns519632.ip-158-69-54.net systemd[1]: mariadb.service: main process exited, code=killed, status=6/ABRT
Jul 25 09:28:51 ns519632.ip-158-69-54.net systemd[1]: Failed to start MariaDB 10.5.16 database server.
-- Subject: Unit mariadb.service has failed
-- Defined-By: systemd
-- Support: systemd-devel Info Page
--
-- Unit mariadb.service has failed.
--
-- The result is failed.
Jul 25 09:28:51 ns519632.ip-158-69-54.net systemd[1]: Unit mariadb.service entered failed state.
Jul 25 09:28:51 ns519632.ip-158-69-54.net systemd[1]: mariadb.service failed.
Jul 25 09:28:51 ns519632.ip-158-69-54.net polkitd[474]: Unregistered Authentication Agent for unix-process:24064:33199201 (system bus name :1.33475, object path /org/freedesktop/PolicyKit1/AuthenticationAgen
Jul 25 09:28:51 ns519632.ip-158-69-54.net sudo[24058]: pam_unix(sudo:session): session closed for user root
Jul 25 09:28:53 ns519632.ip-158-69-54.net systemd[1]: plesk-web-socket.service holdoff time over, scheduling restart.
Jul 25 09:28:53 ns519632.ip-158-69-54.net systemd[1]: Stopped Plesk Web Socket Service.
-- Subject: Unit plesk-web-socket.service has finished shutting down
-- Defined-By: systemd
-- Support: systemd-devel Info Page
--
-- Unit plesk-web-socket.service has finished shutting down.

 

[IgorG]

It looks like the database is still corrupted.
I suggest you contact Plesk Support Team. They will fix it directly on your server.

 

[tacobellrd]

I try to do it and the license does not pass I do not understand why

 

[Maarten]

What kind of warning do you get when you enter your license code?

 

[tacobellrd]

What kind of warning do you get when you enter your license code?

 

[Maarten]

Did you enter a trial license?

You should have seen an option to purchase a support subscription from Plesk. It has a free trial period of 1 month:

 

[tacobellrd]

That option apparently isn't there anymore.

Submit a request – Plesk Help Center

support.plesk.com

 

[Maarten]

Your license is invalid. If you enter a valid license (even without a support option), you'll see the message below:



Please get in touch with Plesk via this form:

Licensing and Purchase support

How can we help? Licensing and Purchase support Name* First Last Company Name*Country*-- Please Select --AfghanistanÅland IslandsAlbaniaAlgeriaAmerican SamoaAndorraAngolaAnguillaAntarcticaAntigua and...

www.plesk.com

 

[Kaspar]

View attachment 21304

Looks like there a one digit missing from the license key. There should be 4 digits after the last dot.

 

[tacobellrd]

Look like there a one digit missing from the license key. There should be 4 digits after the last dot.

if I put it and as you want

 

[tacobellrd]

Your license is invalid. If you enter a valid license (even without a support option), you'll see the message below:

View attachment 21308

Please get in touch with Plesk via this form:

Licensing and Purchase support

How can we help? Licensing and Purchase support Name* First Last Company Name*Country*-- Please Select --AfghanistanÅland IslandsAlbaniaAlgeriaAmerican SamoaAndorraAngolaAnguillaAntarcticaAntigua and...

www.plesk.com

ok several days ago I filled it out and I have not had an answer

 

[Maarten]

if I put it and as you want

Not sure what you mean. Can you rephrase that please?

 

[tacobellrd]

that you selected the option to pay and nothing

Not sure what you mean. Can you rephrase that please?