Fani38

Registered
Jan 13, 2020
1
0
0
Turkey
cPanel Access Level
Root Administrator
i have a problem i cant restart mysql

Code:
symbolic-links=0

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
innodb_buffer_pool_size=134217728
max_allowed_packet=268435456
open_files_limit=10000
innodb_file_per_table=1
sql_mode
here mysqld.log

Code:
2020-01-13T02:48:49.779732Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

2020-01-13T02:48:49.780054Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.

2020-01-13T02:48:49.780631Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.29) starting as process 25742 ...

2020-01-13T02:48:49.788323Z 0 [Note] InnoDB: PUNCH HOLE support available

2020-01-13T02:48:49.788394Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2020-01-13T02:48:49.788405Z 0 [Note] InnoDB: Uses event mutexes

2020-01-13T02:48:49.788414Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier

2020-01-13T02:48:49.788421Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11

2020-01-13T02:48:49.788435Z 0 [Note] InnoDB: Using Linux native AIO

2020-01-13T02:48:49.789044Z 0 [Note] InnoDB: Number of pools: 1

2020-01-13T02:48:49.789311Z 0 [Note] InnoDB: Using CPU crc32 instructions

2020-01-13T02:48:49.801831Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M

2020-01-13T02:48:49.818709Z 0 [Note] InnoDB: Completed initialization of buffer pool

2020-01-13T02:48:49.823730Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().

2020-01-13T02:48:49.853775Z 0 [Note] InnoDB: Highest supported file format is Barracuda.

2020-01-13T02:48:50.203416Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2020-01-13T02:48:50.203651Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2020-01-13T02:48:50.391418Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.

2020-01-13T02:48:50.393270Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.

2020-01-13T02:48:50.393309Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.

2020-01-13T02:48:50.394846Z 0 [Note] InnoDB: Waiting for purge to start

2020-01-13T02:48:50.445128Z 0 [Note] InnoDB: 5.7.29 started; log sequence number 38307564

2020-01-13T02:48:50.447088Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool

2020-01-13T02:48:50.447413Z 0 [Note] Plugin 'FEDERATED' is disabled.

2020-01-13T02:48:50.501258Z 0 [Note] InnoDB: Buffer pool(s) load completed at 200112 21:48:50

2020-01-13T02:48:50.509982Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.

2020-01-13T02:48:50.510042Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.

2020-01-13T02:48:50.528514Z 0 [Warning] CA certificate ca.pem is self signed.

2020-01-13T02:48:50.528647Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.

2020-01-13T02:48:50.533896Z 0 [Note] Server hostname (bind-address): '*'; port: 3306

2020-01-13T02:48:50.534046Z 0 [Note] IPv6 is available.

2020-01-13T02:48:50.534079Z 0 [Note]   - '::' resolves to '::';

2020-01-13T02:48:50.534106Z 0 [Note] Server socket created on IP: '::'.

2020-01-13T02:48:50.598600Z 0 [Note] Event Scheduler: Loaded 0 events

2020-01-13T02:48:50.599264Z 0 [Note] /usr/sbin/mysqld: ready for connections.

Version: '5.7.29'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)

2020-01-13T02:48:55.287767Z 3 [Note] Got an error reading communication packets

2020-01-13T02:48:55.391281Z 5 [Note] Got an error reading communication packets

2020-01-13T02:49:08.774729Z 0 [Note] Giving 1 client threads a chance to die gracefully

2020-01-13T02:49:08.774785Z 0 [Note] Shutting down slave threads

2020-01-13T02:49:10.774943Z 0 [Note] Forcefully disconnecting 1 remaining clients

2020-01-13T02:49:10.775000Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 12  user: 'root'



2020-01-13T02:49:10.775080Z 0 [Note] Event Scheduler: Purging the queue. 0 events

2020-01-13T02:49:10.775410Z 0 [Note] Binlog end

2020-01-13T02:49:10.779530Z 0 [Note] Shutting down plugin 'ngram'

2020-01-13T02:49:10.779559Z 0 [Note] Shutting down plugin 'partition'

2020-01-13T02:49:10.779564Z 0 [Note] Shutting down plugin 'BLACKHOLE'

2020-01-13T02:49:10.779569Z 0 [Note] Shutting down plugin 'ARCHIVE'

2020-01-13T02:49:10.779579Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'

2020-01-13T02:49:10.779605Z 0 [Note] Shutting down plugin 'MRG_MYISAM'

2020-01-13T02:49:10.779612Z 0 [Note] Shutting down plugin 'MyISAM'

2020-01-13T02:49:10.779624Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'

2020-01-13T02:49:10.779629Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'

2020-01-13T02:49:10.779632Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'

2020-01-13T02:49:10.779635Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'

2020-01-13T02:49:10.779638Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'

2020-01-13T02:49:10.779641Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'

2020-01-13T02:49:10.779644Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'

2020-01-13T02:49:10.779647Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'

2020-01-13T02:49:10.779650Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'

2020-01-13T02:49:10.779654Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'

2020-01-13T02:49:10.779657Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'

2020-01-13T02:49:10.779660Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'

2020-01-13T02:49:10.779663Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'

2020-01-13T02:49:10.779666Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'

2020-01-13T02:49:10.779669Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'

2020-01-13T02:49:10.779672Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'

2020-01-13T02:49:10.779675Z 0 [Note] Shutting down plugin 'INNODB_METRICS'

2020-01-13T02:49:10.779678Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'

2020-01-13T02:49:10.779681Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'

2020-01-13T02:49:10.779685Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'

2020-01-13T02:49:10.779688Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'

2020-01-13T02:49:10.779691Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'

2020-01-13T02:49:10.779694Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'

2020-01-13T02:49:10.779697Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'

2020-01-13T02:49:10.779700Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'

2020-01-13T02:49:10.779704Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'

2020-01-13T02:49:10.779707Z 0 [Note] Shutting down plugin 'INNODB_CMP'

2020-01-13T02:49:10.779710Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'

2020-01-13T02:49:10.779713Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'

2020-01-13T02:49:10.779716Z 0 [Note] Shutting down plugin 'INNODB_TRX'

2020-01-13T02:49:10.779719Z 0 [Note] Shutting down plugin 'InnoDB'

2020-01-13T02:49:10.779831Z 0 [Note] InnoDB: FTS optimize thread exiting.

2020-01-13T02:49:10.779957Z 0 [Note] InnoDB: Starting shutdown...

2020-01-13T02:49:10.880233Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool

2020-01-13T02:49:10.881016Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 200112 21:49:10

2020-01-13T02:49:12.622078Z 0 [Note] InnoDB: Shutdown completed; log sequence number 38392424

2020-01-13T02:49:12.626875Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"

2020-01-13T02:49:12.626915Z 0 [Note] Shutting down plugin 'MEMORY'

2020-01-13T02:49:12.626927Z 0 [Note] Shutting down plugin 'CSV'

2020-01-13T02:49:12.626935Z 0 [Note] Shutting down plugin 'sha256_password'

2020-01-13T02:49:12.626941Z 0 [Note] Shutting down plugin 'mysql_native_password'

2020-01-13T02:49:12.627372Z 0 [Note] Shutting down plugin 'binlog'

2020-01-13T02:49:12.628694Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
i cant restart from server

Code:
Waiting for “mysql” to start ………Unrecognized configuration options may have caused the MySQL startup errors. The system has attempted to auto-update your MySQL configuration file for your MySQL version. This should resolve any errors that stem from an outdated MySQL configuration file. …Unrecognized configuration options may have caused the MySQL startup errors. The system has attempted to auto-update your MySQL configuration file for your MySQL version. This should resolve any errors that stem from an outdated MySQL configuration file. …failed.

Cpanel::Exception::Services::StartError Service Status

Service Error
(XID v92pt3) The “mysql” service failed to start.

Startup Log
Jan 13 02:04:10 server17.bilnet.com.tr systemd[1]: Starting MySQL Server...

Log Messages
2020-01-13T02:49:12.628694Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
2020-01-13T02:49:10.775000Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 12 user: 'root'
2020-01-13T02:48:50.599264Z 0 [Note] /usr/sbin/mysqld: ready for connections.
2020-01-13T02:48:45.997992Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

mysql has failed. Contact your system administrator if the service does not automagically recover.
 
Last edited:

cPanelLauren

Product Owner II
Staff member
Nov 14, 2017
13,266
1,304
363
Houston
I believe this is related to the fact the sql_mode line is incorrect. This either shouldn't be present or should note the mode. If you remove
sql_mode (or comment it out) then attempt to restart MySQL what is the output?