SQL Error: MySQL server has gone away

[khussairiee]

Hai,

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

[khussairiee]

this error come after i do this on my centos server

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

[khussairiee]

Hai,

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

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

[TGates]

Do you have enough disk space?

(Moved to ZPanel support forum)

[khussairiee]

Do you have enough disk space?

(Moved to ZPanel support forum)

Yes

[khussairiee]

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

[khussairiee]

If you can help I will give the root password

[Ron-e]

Centos 7 and zPanel... why not Sentora?
I did not know that zPanel was compatible with Centos7.

[TGates]

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.)

[vthink.mehul]

getting error when add Database to user
mysql user->edit->add database error is" page not working"
please help me to solve this issue.