Control Web Panel

WebPanel => CentOS 6 Problems => Topic started by: amicheals on February 21, 2017, 12:09:46 PM

Title: mysql errors
Post by: amicheals 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

Title: Re: mysql errors
Post by: Administrator on February 21, 2017, 11:48:49 PM

you need to check mysql error log file

Title: Re: mysql errors
Post by: botonakis on February 24, 2017, 09:43:12 AM

open my.cnf file and send here your configuration.

Title: Re: mysql errors
Post by: markacole 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