This forum uses cookies
This forum makes use of cookies to store your login information if you are registered, and your last visit if you are not. Cookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. Cookies on this forum also track the specific topics you have read and when you last read them. Please confirm whether you accept or reject these cookies being set.

A cookie will be stored in your browser regardless of choice to prevent you being asked this question again. You will be able to change your cookie settings at any time using the link in the footer.

SQL Error: MySQL server has gone away
#1
[Not Solved] SQL Error: MySQL server has gone away
Hai,

I'm facing SQL Error: MySQL server has gone away on my sentora. Any one expert can help me? How to fix this?
Reply
Thanks given by:
#2
[Not Solved] RE: SQL Error: MySQL server has gone away
this error come after i do this on my centos server

code : php -q /etc/sentora/panel/bin/daemon.php
Reply
Thanks given by:
#3
[Not Solved] RE: SQL Error: MySQL server has gone away
(09-20-2016, 11:33 AM)khussairiee Wrote: Hai,

I'm facing SQL Error: MySQL server has gone away on my sentora. Any one expert can help me? How to fix this?

(09-20-2016, 12:17 PM)khussairiee Wrote: this error come after i do this on my centos server

code : php -q /etc/sentora/panel/bin/daemon.php

when the process checking disk, below the exactly 

Mail Quota Count Checking Disk and Mail usage...

hd_path/var/sentora/hostdata/

vmailpath/var/sentora/vmail
SQL Error: MySQL server has gone away
Reply
Thanks given by:
#4
[Not Solved] RE: SQL Error: MySQL server has gone away
Do you have enough disk space?

(Moved to ZPanel support forum)
-TGates - Head of Support

SEARCH the Forums or read the DOCUMENTATION before posting!
Modules Maintained: 13 - Module Installs: 108k+

Find my support helpful? Donate HERE
Help me to help you by getting your domains using this link:
GoDaddy - Domains
Reply
Thanks given by:
#5
[Not Solved] RE: SQL Error: MySQL server has gone away
(09-21-2016, 04:54 AM)TGates Wrote: Do you have enough disk space?

(Moved to ZPanel support forum)

Yes
Reply
Thanks given by:
#6
[Not Solved] RE: SQL Error: MySQL server has gone away
(09-21-2016, 07:03 AM)khussairiee Wrote:
(09-21-2016, 04:54 AM)TGates Wrote: Do you have enough disk space?

(Moved to ZPanel support forum)

Yes

this is log;

160921  4:10:03 [Note] Plugin 'FEDERATED' is disabled.
160921  4:10:03 InnoDB: The InnoDB memory heap is disabled
160921  4:10:03 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160921  4:10:03 InnoDB: Compressed tables use zlib 1.2.3
160921  4:10:03 InnoDB: Using Linux native AIO
160921  4:10:03 InnoDB: Initializing buffer pool, size = 128.0M
160921  4:10:03 InnoDB: Completed initialization of buffer pool
160921  4:10:03 InnoDB: highest supported file format is Barracuda.
160921  4:10:03  InnoDB: Waiting for the background threads to start
160921  4:10:04 InnoDB: 5.5.52 started; log sequence number 2101539088
160921  4:10:04 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
160921  4:10:04 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
160921  4:10:04 [Note] Server socket created on IP: '0.0.0.0'.
160921  4:10:04 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create$
160921  4:10:04 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong stru$
160921  4:10:04 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong stru$
160921  4:10:04 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong$
160921  4:10:04 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
160921  4:10:04 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structu$
160921  4:10:04 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
160921  4:10:04 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong struct$
160921  4:10:04 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
160921  4:10:04 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_$
160921  4:10:04 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has th$
160921  4:10:04 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_nam$
160921  4:10:04 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wron$
160921  4:10:04 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong $
160921  4:10:04 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
160921  4:10:04 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
160921  4:10:04 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
Reply
Thanks given by:
#7
[Not Solved] RE: SQL Error: MySQL server has gone away
If you can help I will give the root password
Reply
Thanks given by:
#8
[Not Solved] RE: SQL Error: MySQL server has gone away
Centos 7 and zPanel... why not Sentora?
I did not know that zPanel was compatible with Centos7.
=------=
My Sentora DemoMy GithubAuxio Github
Zentora themeS-Type themeCstyleX theme
flat-color-iconssmall-n-flat-icons
=------=


Like my work? Consider [Image: btn_donate_SM.gif]
Reply
Thanks given by:
#9
[Not Solved] RE: SQL Error: MySQL server has gone away
Good point Ron-e, also one of the issues is explained right in the log:

Code:
160921  4:10:04 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create$

If this is a newer install or if you only have a couple cients/sites, I would back up the files and databases and do a frsh OS and Sentora install then restore the sites (Sorry, no automatic way to restore the sites.)
-TGates - Head of Support

SEARCH the Forums or read the DOCUMENTATION before posting!
Modules Maintained: 13 - Module Installs: 108k+

Find my support helpful? Donate HERE
Help me to help you by getting your domains using this link:
GoDaddy - Domains
Reply
Thanks given by:
#10
[Not Solved] RE: SQL Error: MySQL server has gone away
getting error when add Database to user
mysql user->edit->add database error is" page not working"
please help me to solve this issue.
Reply
Thanks given by:


Possibly Related Threads...
Thread Author Replies Views Last Post
can not use FTP showing error ali.rao 3 739 02-24-2017, 12:55 AM
Last Post: TGates
Error message in phpMyAdmin!! chiefody 1 387 02-04-2017, 06:09 AM
Last Post: TGates
Setting up different mail server for one domain in zpanel david768 0 592 12-11-2016, 07:30 PM
Last Post: david768

Forum Jump:


Users browsing this thread: 1 Guest(s)