Mysql is not starting

santosh

My Server was working fine till now but a few hours ago MySQL has stopped and it is not starting whatsoever.
I tried pressing the start button, restarting the server, trying to start with the command line.
Please help me. @aaPanel_Jose

aaPanel_thisyear

santosh Hello, the server command line executes the following command screenshot to have a look

/etc/init. d/mysqld start

santosh

aaPanel_thisyear Hello, I tried running this command, its giving me this error

zuantou

santosh Sorry, the command given by colleague was incorrectly added with a space and could not be executed. The following is correct, please re-execute/etc/init.d/mysqld start

zuantou

santosh cat /www/server/data/*.err|grep -i -C 10 error
I checked your latest screenshot, I think providing us with log information will help to solve your problem

aaPanel_thisyear

santosh Hello, the server command line executes the following command to see the log information

cat /www/server/data/*. err | grep -i -C 10 error

santosh

zuantou Hello,
Here it the screenshot or log information, log continuously keeps on populating with new log

santosh

aaPanel_thisyear here is screenshot

zuantou

I noticed that the date recorded in the log you provided is last year 😅
Can you provide the last updated log information

santosh

zuantou its just keep on loading, i will wait it to complete loading and send new screenshot

santosh

zuantou this log is from mysql

`2022-01-28T16:14:16.773363Z 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2022-01-28T16:14:16.773472Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2022-01-28T16:14:16.773476Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2022-01-28T16:14:16.773496Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2022-01-28T16:14:16.773527Z 0 [Note] /www/server/mysql/bin/mysqld (mysqld 5.7.34-log) starting as process 7332 ...
2022-01-28T16:14:16.782023Z 0 [Note] InnoDB: PUNCH HOLE support available
2022-01-28T16:14:16.782069Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-01-28T16:14:16.782073Z 0 [Note] InnoDB: Uses event mutexes
2022-01-28T16:14:16.782076Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2022-01-28T16:14:16.782080Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-01-28T16:14:16.782083Z 0 [Note] InnoDB: Using Linux native AIO
2022-01-28T16:14:16.782273Z 0 [Note] InnoDB: Number of pools: 1
2022-01-28T16:14:16.782344Z 0 [Note] InnoDB: Using CPU crc32 instructions
2022-01-28T16:14:16.783772Z 0 [Note] InnoDB: Initializing buffer pool, total size = 384M, instances = 1, chunk size = 128M
2022-01-28T16:14:16.798510Z 0 [Note] InnoDB: Completed initialization of buffer pool
2022-01-28T16:14:16.801216Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2022-01-28T16:14:16.812813Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2022-01-28T16:14:16.825187Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-01-28T16:14:16.825334Z 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-01-28T16:14:16.837167Z 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
2022-01-28T16:14:16.837700Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2022-01-28T16:14:16.837706Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2022-01-28T16:14:16.837988Z 0 [Note] InnoDB: Waiting for purge to start
2022-01-28T16:14:16.888150Z 0 [Note] InnoDB: 5.7.34 started; log sequence number 27668443
2022-01-28T16:14:16.888352Z 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2022-01-28T16:14:16.888525Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220128 16:14:16
2022-01-28T16:14:16.888534Z 0 [Note] Plugin 'FEDERATED' is disabled.
mysqld: File './mysql-bin.000204' not found (Errcode: 2 - No such file or directory)
2022-01-28T16:14:16.889357Z 0 [ERROR] Failed to open log (file './mysql-bin.000204', errno 2)
2022-01-28T16:14:16.889362Z 0 [ERROR] Could not open log file
2022-01-28T16:14:16.889365Z 0 [ERROR] Can't init tc log
2022-01-28T16:14:16.889368Z 0 [ERROR] Aborting

2022-01-28T16:14:16.889375Z 0 [Note] Binlog end
2022-01-28T16:14:16.889461Z 0 [Note] Shutting down plugin 'ngram'
2022-01-28T16:14:16.889467Z 0 [Note] Shutting down plugin 'partition'
2022-01-28T16:14:16.889470Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2022-01-28T16:14:16.889473Z 0 [Note] Shutting down plugin 'ARCHIVE'
2022-01-28T16:14:16.889476Z 0 [Note] Shutting down plugin 'CSV'
2022-01-28T16:14:16.889479Z 0 [Note] Shutting down plugin 'MyISAM'
2022-01-28T16:14:16.889488Z 0 [Note] Shutting down plugin 'MEMORY'
2022-01-28T16:14:16.889492Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2022-01-28T16:14:16.889495Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2022-01-28T16:14:16.889498Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2022-01-28T16:14:16.889500Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2022-01-28T16:14:16.889503Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2022-01-28T16:14:16.889506Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2022-01-28T16:14:16.889508Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2022-01-28T16:14:16.889511Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2022-01-28T16:14:16.889513Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2022-01-28T16:14:16.889516Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2022-01-28T16:14:16.889518Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2022-01-28T16:14:16.889521Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2022-01-28T16:14:16.889523Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2022-01-28T16:14:16.889525Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2022-01-28T16:14:16.889528Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2022-01-28T16:14:16.889530Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2022-01-28T16:14:16.889533Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2022-01-28T16:14:16.889535Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2022-01-28T16:14:16.889538Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2022-01-28T16:14:16.889540Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2022-01-28T16:14:16.889542Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2022-01-28T16:14:16.889545Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2022-01-28T16:14:16.889547Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2022-01-28T16:14:16.889550Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2022-01-28T16:14:16.889552Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2022-01-28T16:14:16.889555Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2022-01-28T16:14:16.889557Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2022-01-28T16:14:16.889560Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2022-01-28T16:14:16.889562Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2022-01-28T16:14:16.889564Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2022-01-28T16:14:16.889567Z 0 [Note] Shutting down plugin 'InnoDB'
2022-01-28T16:14:16.889611Z 0 [Note] InnoDB: FTS optimize thread exiting.
2022-01-28T16:14:16.889656Z 0 [Note] InnoDB: Starting shutdown...
2022-01-28T16:14:16.989873Z 0 [Note] InnoDB: Dumping buffer pool(s) to /www/server/data/ib_buffer_pool
2022-01-28T16:14:16.990116Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 220128 16:14:16
2022-01-28T16:14:18.501555Z 0 [Note] InnoDB: Shutdown completed; log sequence number 27668462
2022-01-28T16:14:18.503281Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-01-28T16:14:18.503306Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2022-01-28T16:14:18.503317Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2022-01-28T16:14:18.503391Z 0 [Note] Shutting down plugin 'sha256_password'
2022-01-28T16:14:18.503395Z 0 [Note] Shutting down plugin 'mysql_native_password'
2022-01-28T16:14:18.503526Z 0 [Note] Shutting down plugin 'binlog'
2022-01-28T16:14:18.504753Z 0 [Note] /www/server/mysql/bin/mysqld: Shutdown complete`

this error is given when i try to login to phpmyadmin

zuantou

santosh Thank you for your patience, please don't worry, the reason for your database startup failure is very common
Please make a full backup of your server first, then try the following
cp -p /www/server/data/mysql-bin.index /www/backup cat /dev/null > /www/server/data/mysql-bin.index /etc/init.d/mysqld start

santosh

zuantou @aaPanel_thisyear
my server MySQL start after clearing the log, its working fine now, thank you for the prompt reply and support