Author Topic: Mysql not starting  (Read 500 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
Mysql not starting
« on: June 18, 2024, 11:51:14 AM »
without touching anything on server today i wake up with this error contacted CWP support and they said i have do something but i think just some package got updated
Warning: mysqli_connect(): (HY000/2002): No such file or directory in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0

Warning: mysqli_connect(): (HY000/2002): No such file or directory in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0

Warning: mysqli_connect(): (HY000/2002): No such file or directory in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0

Warning: mysqli_connect(): (HY000/2002): No such file or directory in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0


Trying to start mysql server, please wait!
Try to restart Control Web Panel with command: sh /scripts/restart_cwpsrv

**Check your MySQL root password in: /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php and /root/.my.cnf
You can reset the MySQL root password fast with this command: /scripts/mysql_pwd_reset -q
do anyone have a solution why the db server would broke]
i found this topic but it`s pretty old and i don`t know will it recover all databases
https://forum.centos-webpanel.com/mysql/failed-to-start-mariadb-10-1-42-database-server/

Offline
*****
Re: Mysql not starting
« Reply #1 on: June 18, 2024, 02:38:20 PM »
Is the MySQL root password correct in both of the two files suggested to check?

Offline
*
Re: Mysql not starting
« Reply #2 on: June 18, 2024, 03:00:56 PM »
yes identical
this is what i see in the log
Code: [Select]
1a87b900 InnoDB: Page dump in ascii and hex (16384 bytes):
nection established from mta0.minotbuildersupply.com[158.255.213.61]: TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)
000000500000000000000000000005d113363b200070000000000000000000000000000000118d2ae00000000000000000200f20000000000000006000000000000002d000000000000002e000000


1a87b900 InnoDB: uncompressed page, stored checksum in field1 1113216988, calculated checksums for field1: crc32 2577802008, innodb 1113216988, none 37359285
ing TRX_SYS
ansaction system page
80235419904 [Note] InnoDB: It is also possible that your operating system has corrupted its own file cache and rebooting your computer removes the error. If
80235419904 [ERROR] InnoDB: Ending processing because of a corrupt database page.
1a87b900  InnoDB: Assertion failure in thread 140480235419904 in file ha_innodb.cc line 21950
 generate a memory trap.
d bug report to https://jira.mariadb.org/
ted assertion failures or crashes, even
r the mysqld startup, there may be
e InnoDB tablespace. Please refer to
.com/doc/refman/5.6/en/forcing-innodb-recovery.html
covery.
mysqld got signal 6 ;
u hit a bug. It is also possible that this binary
it was linked against is corrupt, improperly built,
rror can also be caused by malfunctioning hardware.
https://mariadb.com/kb/en/reporting-bugs
scrape up some info that will hopefully help
t since we have already crashed,
wrong and this may fail.
MariaDB
8
« Last Edit: June 18, 2024, 03:52:19 PM by dani521 »

Offline
*
Re: Mysql not starting
« Reply #3 on: June 19, 2024, 07:52:24 AM »
if someone can help with broken innodb there is mysql backups i`am willing to pay to anyone who can help because CWP support from 10 hours already ticket is status in progress and no anyone is in the machine i am leaving my phone for viber number +359877461396