Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Pages: [1]
1
MySQL / Innodb not running even after force recovery
« on: January 21, 2020, 08:39:08 AM »
Hello Friends
My innodb crashed somehow on sunday without doing anything. Now its not working at all.
I tried skipping innodb and try to work on MYISAM but my all database on production is using innodb. By using MYISAM i take the backup of my websites database and all other databases visible like root, mysql,postfix etc.
But now what to do with innodb. Till it is not recovered my production websites remain down and thats pretty problem to me.
Anybody any suggestion.
Maria DB status
# systemctl -l status mariadb.service
● mariadb.service - MariaDB 10.1.36 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: failed (Result: exit-code) since Tue 2020-01-21 13:42:21 IST; 23s ago
Docs: man:mysqld(
https://mariadb.com/kb/en/library/systemd/
Process: 25311 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 6079 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Process: 6064 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
Process: 6061 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Main PID: 6079 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"
Jan 21 13:42:21 mysqld[6079]: 2020-01-21 13:42:21 140010481858816 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
Jan 21 13:42:21 mysqld[6079]: 2020-01-21 13:42:21 140010481858816 [ERROR] Plugin 'InnoDB' init function returned error.
Jan 21 13:42:21 mysqld[6079]: 2020-01-21 13:42:21 140010481858816 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Jan 21 13:42:21 mysqld[6079]: 2020-01-21 13:42:21 140010481858816 [Note] Plugin 'FEEDBACK' is disabled.
Jan 21 13:42:21 mysqld[6079]: 2020-01-21 13:42:21 140010481858816 [ERROR] Unknown/unsupported storage engine: InnoDB
Jan 21 13:42:21 mysqld[6079]: 2020-01-21 13:42:21 140010481858816 [ERROR] Aborting
Jan 21 13:42:21 systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
Jan 21 13:42:21 systemd[1]: Failed to start MariaDB 10.1.36 database server.
Jan 21 13:42:21 systemd[1]: Unit mariadb.service entered failed state.
Jan 21 13:42:21 systemd[1]: mariadb.service failed.
My innodb crashed somehow on sunday without doing anything. Now its not working at all.
I tried skipping innodb and try to work on MYISAM but my all database on production is using innodb. By using MYISAM i take the backup of my websites database and all other databases visible like root, mysql,postfix etc.
But now what to do with innodb. Till it is not recovered my production websites remain down and thats pretty problem to me.
Anybody any suggestion.
Maria DB status
# systemctl -l status mariadb.service
● mariadb.service - MariaDB 10.1.36 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: failed (Result: exit-code) since Tue 2020-01-21 13:42:21 IST; 23s ago
Docs: man:mysqld(
https://mariadb.com/kb/en/library/systemd/
Process: 25311 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 6079 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Process: 6064 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
Process: 6061 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Main PID: 6079 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"
Jan 21 13:42:21 mysqld[6079]: 2020-01-21 13:42:21 140010481858816 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
Jan 21 13:42:21 mysqld[6079]: 2020-01-21 13:42:21 140010481858816 [ERROR] Plugin 'InnoDB' init function returned error.
Jan 21 13:42:21 mysqld[6079]: 2020-01-21 13:42:21 140010481858816 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Jan 21 13:42:21 mysqld[6079]: 2020-01-21 13:42:21 140010481858816 [Note] Plugin 'FEEDBACK' is disabled.
Jan 21 13:42:21 mysqld[6079]: 2020-01-21 13:42:21 140010481858816 [ERROR] Unknown/unsupported storage engine: InnoDB
Jan 21 13:42:21 mysqld[6079]: 2020-01-21 13:42:21 140010481858816 [ERROR] Aborting
Jan 21 13:42:21 systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
Jan 21 13:42:21 systemd[1]: Failed to start MariaDB 10.1.36 database server.
Jan 21 13:42:21 systemd[1]: Unit mariadb.service entered failed state.
Jan 21 13:42:21 systemd[1]: mariadb.service failed.
2
CentOS 6 Problems / Re: CentOS6 Upgrade
« on: August 28, 2017, 06:25:19 AM »
Hello Admin
my cwp version is little then this you mentioned
CWP version: 0.9.8.155
so can i use the same procedure to upgrade or something else
my cwp version is little then this you mentioned
CWP version: 0.9.8.155
so can i use the same procedure to upgrade or something else
3
CentOS 6 Problems / Web server consumed all space without touching the server in last many days
« on: November 20, 2016, 05:26:28 PM »
Hello Guys
I just found something i rarely check my server after installing CWP I love CWP but i found disk space going used automatically OR say my disk space filled without any uses without anyone touching it i don't know why. Can anybody help or need anymore information to solve this problem please its urgent
i need someone help urgent
I just found something i rarely check my server after installing CWP I love CWP but i found disk space going used automatically OR say my disk space filled without any uses without anyone touching it i don't know why. Can anybody help or need anymore information to solve this problem please its urgent
i need someone help urgent
4
PHP / PHP GD Library Update
« on: August 22, 2016, 09:17:50 PM »
Hello
Anyone know how to update GD library from 2.1.0 to 2.2.3
If you know exact solution. Please post asap
Anyone know how to update GD library from 2.1.0 to 2.2.3
If you know exact solution. Please post asap
5
Apache / Re: Letsencrypt Manager - install error
« on: July 28, 2016, 07:48:59 AM »
Same problem here - "WARNING! Letsenycrpt Certificate installation failed, please check /etc/letsencrypt/live/stnsolution.com !"
6
Migration from other control panels / Migration from Sentora to CWP
« on: July 06, 2016, 04:49:11 PM »
Hello
i was using sentora on my vps and having few domains i want to migrate from sentora to cwp. Please if anyone from cwp developer could help me.
I need you help urgently due to my vps renewal i dont want to renew that vps and like to move from sentora to cwp.
i was using sentora on my vps and having few domains i want to migrate from sentora to cwp. Please if anyone from cwp developer could help me.
I need you help urgently due to my vps renewal i dont want to renew that vps and like to move from sentora to cwp.
7
Other / Cwp Admin Message Error
« on: July 06, 2016, 06:57:51 AM »
Hi
When i check my cwp admin messages page its shows error. Here is the error in Quote
"Fatal error: Uncaught exception 'DOMException' with message 'Hierarchy Request Error' in /usr/local/cwpsrv/htdocs/resources/admin/include/phpQuery-onefile.php(1) : eval()'d code(1) : eval()'d code:174 Stack trace: #0 /usr/local/cwpsrv/htdocs/resources/admin/include/phpQuery-onefile.php(1) : eval()'d code(1) : eval()'d code(174): DOMNode->appendChild(Object(DOMDocument)) #1 /usr/local/cwpsrv/htdocs/resources/admin/include/phpQuery-onefile.php(1) : eval()'d code(1) : eval()'d code(205): phpQueryObject->KiD430gATlP3VV('//title') #2 /usr/local/cwpsrv/htdocs/resources/admin/include/phpQuery-onefile.php(1) : eval()'d code(1) : eval()'d code(426): phpQueryObject->find('title') #3 /usr/local/cwpsrv/htdocs/resources/admin/modules/admin_messages.php(1) : eval()'d code(1) : eval()'d code(12): phpQueryObject->offsetGet('title') #4 /usr/local/cwpsrv/htdocs/resources/admin/modules/admin_messages.php(1) : eval()'d code(1): eval() #5 /usr/local/cwpsrv/htdocs/resources/admin/modules/admin_messages.php(1): eval() #6 /usr/local/cwpsrv/htdoc in /usr/local/cwpsrv/htdocs/resources/admin/include/phpQuery-onefile.php(1) : eval()'d code(1) : eval()'d code on line 174"
Please solve in update or give mesolution for this if it coming in my panel only
When i check my cwp admin messages page its shows error. Here is the error in Quote
"Fatal error: Uncaught exception 'DOMException' with message 'Hierarchy Request Error' in /usr/local/cwpsrv/htdocs/resources/admin/include/phpQuery-onefile.php(1) : eval()'d code(1) : eval()'d code:174 Stack trace: #0 /usr/local/cwpsrv/htdocs/resources/admin/include/phpQuery-onefile.php(1) : eval()'d code(1) : eval()'d code(174): DOMNode->appendChild(Object(DOMDocument)) #1 /usr/local/cwpsrv/htdocs/resources/admin/include/phpQuery-onefile.php(1) : eval()'d code(1) : eval()'d code(205): phpQueryObject->KiD430gATlP3VV('//title') #2 /usr/local/cwpsrv/htdocs/resources/admin/include/phpQuery-onefile.php(1) : eval()'d code(1) : eval()'d code(426): phpQueryObject->find('title') #3 /usr/local/cwpsrv/htdocs/resources/admin/modules/admin_messages.php(1) : eval()'d code(1) : eval()'d code(12): phpQueryObject->offsetGet('title') #4 /usr/local/cwpsrv/htdocs/resources/admin/modules/admin_messages.php(1) : eval()'d code(1): eval() #5 /usr/local/cwpsrv/htdocs/resources/admin/modules/admin_messages.php(1): eval() #6 /usr/local/cwpsrv/htdoc in /usr/local/cwpsrv/htdocs/resources/admin/include/phpQuery-onefile.php(1) : eval()'d code(1) : eval()'d code on line 174"
Please solve in update or give mesolution for this if it coming in my panel only
Pages: [1]
