Author Topic: mysql errors  (Read 568 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
mysql errors
« on: February 21, 2017, 12:09:46 PM »
Hello,
I have cwp pro.

The last few days my websites have been having a mysql issues where mysql is not running or accepting connections.

If I restart mysql it's good, but I received this error when restarting mysql.

I don't know what it is or why it is happening.

Warning: Error while sending QUERY packet. PID=3704 in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0
MySQL server has gone away
Warning: [obfuscated]() expects parameter 1 to be resource, boolean given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0

Offline
*
Re: mysql errors
« Reply #1 on: February 21, 2017, 11:48:49 PM »
you need to check mysql error log file
AntiDDoS Protection (web + mail)
http://centos-webpanel.com/website-ddos-protection-proxy

Join our Development Team and get paid !
http://centos-webpanel.com/develope-modules-for-cwp


Services Monitoring & RBL Monitoring
http://centos-webpanel.com/services-monitor


Do you need Fast and FREE Support included for your CWP linux server?
http://centos-webpanel.com/noc-partner-list
Installation Instructions
http://centos-webpanel.com/installation-instructions
Get Fast Support Here
http://centos-webpanel.com/support-services

Offline
*
Re: mysql errors
« Reply #2 on: February 24, 2017, 09:43:12 AM »
open my.cnf file and send here your configuration.

It's funny that: centos-webpanel.com has cPanel and not CWP installed.

Offline
*
Re: mysql errors
« Reply #3 on: April 08, 2017, 12:16:52 AM »
Hi all got same issue here since doing the recommended updates

Message id [26d5ea909561240a7c55d72cfaafc9e0]: Bad or Corrupted MySQL Databases/Tables detected!


Warning: Error while sending QUERY packet. PID=23789 in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0

Warning: [obfuscated]() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0

Warning: [obfuscated]() expects parameter 1 to be mysqli_result, boolean given in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0

  GNU nano 2.0.9                               File: /var/log/mysqld.log                                                                   

161220 09:58:50 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
161220  9:58:50  InnoDB: Initializing buffer pool, size = 8.0M
161220  9:58:50  InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
161220  9:58:50  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
161220  9:58:51  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
161220  9:58:51  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
161220  9:58:51  InnoDB: Started; log sequence number 0 0
161220  9:58:51 [Note] Event Scheduler: Loaded 0 events
161220  9:58:51 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
161220  9:58:52 [Note] /usr/libexec/mysqld: Normal shutdown