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 [2]
16
CentOS 7 Problems / Re: how to debug mariadb crash?
« on: April 11, 2019, 06:43:47 AM »
Which logs to check is a my main question )
journalctl -u mariadb shows
Apr 11 06:05:19 cwp2 systemd[1]: mariadb.service: main process exited, code=killed, status=9/KILL
Apr 11 06:05:19 cwp2 systemd[1]: Unit mariadb.service entered failed state.
Apr 11 06:05:19 cwp2 systemd[1]: mariadb.service failed.
Apr 11 06:05:24 cwp2 systemd[1]: mariadb.service holdoff time over, scheduling restart.
Apr 11 06:05:50 cwp2 systemd[1]: Stopped MariaDB 10.1.38 database server.
Apr 11 06:07:49 cwp2 systemd[1]: Starting MariaDB 10.1.38 database server...
Apr 11 06:07:49 cwp2 systemd[1]: mariadb.service start-pre operation timed out. Terminating.
Apr 11 06:09:21 cwp2 systemd[1]: mariadb.service stop-final-sigterm timed out. Skipping SIGKILL. Entering failed mode.
Apr 11 06:09:22 cwp2 systemd[1]: Failed to start MariaDB 10.1.38 database server.
Apr 11 06:09:22 cwp2 systemd[1]: Unit mariadb.service entered failed state.
Apr 11 06:09:22 cwp2 systemd[1]: mariadb.service failed.
I've added 4gb extra memory...
journalctl -u mariadb shows
Apr 11 06:05:19 cwp2 systemd[1]: mariadb.service: main process exited, code=killed, status=9/KILL
Apr 11 06:05:19 cwp2 systemd[1]: Unit mariadb.service entered failed state.
Apr 11 06:05:19 cwp2 systemd[1]: mariadb.service failed.
Apr 11 06:05:24 cwp2 systemd[1]: mariadb.service holdoff time over, scheduling restart.
Apr 11 06:05:50 cwp2 systemd[1]: Stopped MariaDB 10.1.38 database server.
Apr 11 06:07:49 cwp2 systemd[1]: Starting MariaDB 10.1.38 database server...
Apr 11 06:07:49 cwp2 systemd[1]: mariadb.service start-pre operation timed out. Terminating.
Apr 11 06:09:21 cwp2 systemd[1]: mariadb.service stop-final-sigterm timed out. Skipping SIGKILL. Entering failed mode.
Apr 11 06:09:22 cwp2 systemd[1]: Failed to start MariaDB 10.1.38 database server.
Apr 11 06:09:22 cwp2 systemd[1]: Unit mariadb.service entered failed state.
Apr 11 06:09:22 cwp2 systemd[1]: mariadb.service failed.
I've added 4gb extra memory...
17
CentOS 7 Problems / Re: how to debug mariadb crash?
« on: April 09, 2019, 02:49:57 PM »
I think too that is is must be stable of course, my question was how to understand why it is being crashed. Right now process was dead again but can locate no info why in logs (
18
CentOS 7 Problems / how to debug mariadb crash?
« on: April 09, 2019, 09:03:35 AM »
Hi
on my server mariadb is often being crashed and not restarted.
how to find a problem why it's crashed and is there any watchdog which will restart the service if any problem?
status shows the following
[root@cwp2 scripts]# service mariadb status
Redirecting to /bin/systemctl status mariadb.service
Б≈▐ mariadb.service - MariaDB 10.1.38 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: active (running) since Tue 2019-04-09 11:49:09 EEST; 11min ago
Docs: man:mysqld(
https://mariadb.com/kb/en/library/systemd/
Process: 7664 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 7616 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: 7611 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Main PID: 7630 (mysqld)
Status: "Taking your SQL requests now..."
CGroup: /system.slice/mariadb.service
Б■■Б■─7630 /usr/sbin/mysqld
Apr 09 11:59:11 cwp2 mysqld[7630]: 2019-04-09 11:59:11 140547070831360 [ERROR] Got error 127 when reading table './geekshop_shop/oc_product'
Apr 09 11:59:17 cwp2 mysqld[7630]: 2019-04-09 11:59:17 140547070831360 [ERROR] Got error 127 when reading table './geekshop_shop/oc_product'
Apr 09 11:59:33 cwp2 mysqld[7630]: 2019-04-09 11:59:33 140547070831360 [ERROR] Got error 127 when reading table './geekshop_shop/oc_product'
Apr 09 11:59:36 cwp2 mysqld[7630]: 2019-04-09 11:59:36 140547070831360 [ERROR] Got error 127 when reading table './ida_sport/cache'
Apr 09 11:59:36 cwp2 mysqld[7630]: 2019-04-09 11:59:36 140547070831360 [ERROR] Got error 127 when reading table './ida_sport/cache'
Apr 09 11:59:43 cwp2 mysqld[7630]: 2019-04-09 11:59:43 140547070831360 [ERROR] Got error 127 when reading table './geekshop_shop/oc_product'
Apr 09 11:59:49 cwp2 mysqld[7630]: 2019-04-09 11:59:49 140547070831360 [ERROR] Got error 127 when reading table './geekshop_shop/oc_product'
Apr 09 11:59:57 cwp2 mysqld[7630]: 2019-04-09 11:59:57 140547070831360 [ERROR] Got error 127 when reading table './geekshop_shop/oc_product'
Apr 09 12:00:04 cwp2 mysqld[7630]: 2019-04-09 12:00:04 140547070831360 [ERROR] Got error 127 when reading table './geekshop_shop/oc_product'
Apr 09 12:00:11 cwp2 mysqld[7630]: 2019-04-09 12:00:11 140547088923392 [ERROR] Got error 127 when reading table './geekshop_shop/oc_product'
on my server mariadb is often being crashed and not restarted.
how to find a problem why it's crashed and is there any watchdog which will restart the service if any problem?
status shows the following
[root@cwp2 scripts]# service mariadb status
Redirecting to /bin/systemctl status mariadb.service
Б≈▐ mariadb.service - MariaDB 10.1.38 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: active (running) since Tue 2019-04-09 11:49:09 EEST; 11min ago
Docs: man:mysqld(
https://mariadb.com/kb/en/library/systemd/
Process: 7664 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 7616 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: 7611 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Main PID: 7630 (mysqld)
Status: "Taking your SQL requests now..."
CGroup: /system.slice/mariadb.service
Б■■Б■─7630 /usr/sbin/mysqld
Apr 09 11:59:11 cwp2 mysqld[7630]: 2019-04-09 11:59:11 140547070831360 [ERROR] Got error 127 when reading table './geekshop_shop/oc_product'
Apr 09 11:59:17 cwp2 mysqld[7630]: 2019-04-09 11:59:17 140547070831360 [ERROR] Got error 127 when reading table './geekshop_shop/oc_product'
Apr 09 11:59:33 cwp2 mysqld[7630]: 2019-04-09 11:59:33 140547070831360 [ERROR] Got error 127 when reading table './geekshop_shop/oc_product'
Apr 09 11:59:36 cwp2 mysqld[7630]: 2019-04-09 11:59:36 140547070831360 [ERROR] Got error 127 when reading table './ida_sport/cache'
Apr 09 11:59:36 cwp2 mysqld[7630]: 2019-04-09 11:59:36 140547070831360 [ERROR] Got error 127 when reading table './ida_sport/cache'
Apr 09 11:59:43 cwp2 mysqld[7630]: 2019-04-09 11:59:43 140547070831360 [ERROR] Got error 127 when reading table './geekshop_shop/oc_product'
Apr 09 11:59:49 cwp2 mysqld[7630]: 2019-04-09 11:59:49 140547070831360 [ERROR] Got error 127 when reading table './geekshop_shop/oc_product'
Apr 09 11:59:57 cwp2 mysqld[7630]: 2019-04-09 11:59:57 140547070831360 [ERROR] Got error 127 when reading table './geekshop_shop/oc_product'
Apr 09 12:00:04 cwp2 mysqld[7630]: 2019-04-09 12:00:04 140547070831360 [ERROR] Got error 127 when reading table './geekshop_shop/oc_product'
Apr 09 12:00:11 cwp2 mysqld[7630]: 2019-04-09 12:00:11 140547088923392 [ERROR] Got error 127 when reading table './geekshop_shop/oc_product'
19
Information / Login as a client without password or view / modify client's settings under root
« on: June 15, 2018, 10:58:08 AM »
Hi
Is there a way to become client's user from under root login or view / modify their settings directly?
Thanks,
D
Is there a way to become client's user from under root login or view / modify their settings directly?
Thanks,
D
20
How to / Re: how to create domain alias
« on: May 31, 2017, 07:57:42 AM »
I have the same question. .htaccess redirect is not an answer because the redirect is not an alias.
21
CentOS 6 Problems / Re: CentOS6 Upgrade
« on: May 27, 2017, 06:17:32 AM »I have the same problem
SSL: error:0B080074:x509 certificate routines:X509_check_private_key:key values mismatch
Please advice which mismatch could cause this error?
try to update your hostname from cwp, just like you would change it.
Varnish issue is related with yum repository issue so you need to check you update on your server.
The hostname is not cwp, or which hostname we talking about?
[root@vps04002 ~]# more /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
127.0.0.1 vps04002.net.xxx.xx
127.0.0.1 autoreply.vps04002.net.xxx.xx
xx.xxx.xx.76 vps04002.net.xxx.xx
Should I change some hostname in CWP settings?
22
CentOS 6 Problems / Re: CentOS6 Upgrade
« on: April 29, 2017, 01:19:28 PM »
I have the same problem
SSL: error:0B080074:x509 certificate routines:X509_check_private_key:key values mismatch
Please advice which mismatch could cause this error?
SSL: error:0B080074:x509 certificate routines:X509_check_private_key:key values mismatch
Please advice which mismatch could cause this error?
23
Apache / Re: larger than the configured limit of 10240000.How to change the content size lim?
« on: September 26, 2016, 11:39:02 AM »
Hi
Where do I find this file?
[root@vps04002 ~]# locate modsecurity.conf
/usr/local/src/modsecurity-2.8.0/modsecurity.conf-recommended
/usr/local/src/modsecurity-2.8.0/iis/wix/modsecurity.conf
Seems I don't have any actual config file with given name...
Where do I find this file?
[root@vps04002 ~]# locate modsecurity.conf
/usr/local/src/modsecurity-2.8.0/modsecurity.conf-recommended
/usr/local/src/modsecurity-2.8.0/iis/wix/modsecurity.conf
Seems I don't have any actual config file with given name...
24
Apache / larger than the configured limit of 10240000.How to change the content size lim?
« on: September 20, 2016, 07:05:54 AM »
Hi
Unable to ulpoad large files with POST on a hosted website, getting the following error in logs
Requested content-length of 12758446 is larger than the configured limit of 10240000
How do I change this limit ?
Thanks
Unable to ulpoad large files with POST on a hosted website, getting the following error in logs
Requested content-length of 12758446 is larger than the configured limit of 10240000
How do I change this limit ?
Thanks
25
Apache / Alias for a site name
« on: April 06, 2016, 06:46:26 AM »
Hi
How do I add the website name alias? domain.com is my default site name, but I would like to make without redirects this website answers also for a domain2.com and new.domain3.com names? Should I add these aliases directly to vhost's configuration file or there is some way to do it in the panel?
Thanks,
Gosha.
How do I add the website name alias? domain.com is my default site name, but I would like to make without redirects this website answers also for a domain2.com and new.domain3.com names? Should I add these aliases directly to vhost's configuration file or there is some way to do it in the panel?
Thanks,
Gosha.
Pages: 1 [2]
