mysqld upgrade=FORCE with error code = 1136, error message = 'Column count doesn't match value count at row 1'
Even the --FORCE options fails. I can't try any of the work-arounds I've Googled as it requires mysqld to be running to edit any tables. Any other work around available?
(base) [root@storm ~]# /usr/sbin/mysqld upgrade=FORCE --user=mysql --log-error-verbosity=3
2019-10-28T14:38:29.036174Z 0 [Note] [MY-010949] [Server] Basedir set to /usr/.
2019-10-28T14:38:29.036193Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.18) starting as process 28939
2019-10-28T14:38:29.049241Z 0 [Note] [MY-012366] [InnoDB] Using Linux native AIO
2019-10-28T14:38:29.049682Z 0 [Note] [MY-010747] [Server] Plugin 'FEDERATED' is disabled.
2019-10-28T14:38:29.052099Z 1 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available
2019-10-28T14:38:29.052238Z 1 [Note] [MY-012943] [InnoDB] Mutexes and rw_locks use GCC atomic builtins
2019-10-28T14:38:29.052327Z 1 [Note] [MY-012944] [InnoDB] Uses event mutexes
2019-10-28T14:38:29.052415Z 1 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier
2019-10-28T14:38:29.052526Z 1 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.11
2019-10-28T14:38:29.053243Z 1 [Note] [MY-013251] [InnoDB] Number of pools: 1
2019-10-28T14:38:29.053634Z 1 [Note] [MY-012951] [InnoDB] Using CPU crc32 instructions
2019-10-28T14:38:29.054948Z 1 [Note] [MY-012203] [InnoDB] Directories to scan './;./;./'
2019-10-28T14:38:29.055157Z 1 [Note] [MY-012204] [InnoDB] Scanning './'
2019-10-28T14:38:29.087663Z 1 [Note] [MY-012208] [InnoDB] Completed space ID check of 1594 files.
2019-10-28T14:38:29.088579Z 1 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 128.000000M, instances = 1, chunk size =128.000000M
2019-10-28T14:38:29.102575Z 1 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool
2019-10-28T14:38:29.104757Z 0 [Note] [MY-011952] [InnoDB] If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-10-28T14:38:29.171064Z 1 [Note] [MY-013086] [InnoDB] Starting to parse redo log at lsn = 223676446, whereas checkpoint_lsn = 223676771
2019-10-28T14:38:29.172551Z 1 [Note] [MY-013083] [InnoDB] Log background threads are being started...
2019-10-28T14:38:29.173218Z 1 [Note] [MY-012532] [InnoDB] Applying a batch of 0 redo log records ...
2019-10-28T14:38:29.173385Z 1 [Note] [MY-012535] [InnoDB] Apply batch completed!
2019-10-28T14:38:29.173719Z 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_001'.
2019-10-28T14:38:29.174134Z 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_002'.
2019-10-28T14:38:29.180002Z 1 [Note] [MY-012910] [InnoDB] Opened 2 existing undo tablespaces.
2019-10-28T14:38:29.180198Z 1 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 71944
2019-10-28T14:38:29.195009Z 1 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables
2019-10-28T14:38:29.195188Z 1 [Note] [MY-012265] [InnoDB] Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-10-28T14:38:29.203223Z 1 [Note] [MY-012266] [InnoDB] File './ibtmp1' size is now 12 MB.
2019-10-28T14:38:29.203476Z 1 [Note] [MY-011825] [InnoDB] Scanning temp tablespace dir:'./#innodb_temp/'
2019-10-28T14:38:29.237686Z 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.
2019-10-28T14:38:29.238259Z 1 [Note] [MY-012976] [InnoDB] 8.0.18 started; log sequence number 223676771
2019-10-28T14:38:29.247899Z 1 [Note] [MY-013327] [Server] MySQL server upgrading from version '80017' to '80018'.
2019-10-28T14:38:29.319770Z 1 [Note] [MY-012357] [InnoDB] Reading DD tablespace files
2019-10-28T14:38:29.380092Z 1 [Note] [MY-012356] [InnoDB] Validated 1596/1596 tablespaces
2019-10-28T14:38:29.963232Z 1 [Note] [MY-010006] [Server] Using data dictionary with version '80017'.
2019-10-28T14:38:30.013173Z 4 [System] [MY-013381] [Server] Server upgrade from '80017' to '80018' started.
2019-10-28T14:38:30.013443Z 4 [Note] [MY-013386] [Server] Running queries to upgrade MySQL server.
2019-10-28T14:38:31.546993Z 4 [ERROR] [MY-013178] [Server] Execution of server-side SQL statement '#
# SQL commands for creating the user in MySQL Server which can be used by the
# internal server session service
# Notes:
# This user is disabled for login
# This user has:
# Select privileges into performance schema tables the mysql.user table.
# SUPER, PERSIST_RO_VARIABLES_ADMIN, SYSTEM_VARIABLES_ADMIN, BACKUP_ADMIN,
# CLONE_ADMIN, SHUTDOWN privileges
#
INSERT IGNORE INTO mysql.user VALUES ('localhost','mysql.session','N','N','N','N','N','N','N','Y','N','N','N','N','N','N','N','Y','N','N','N','N','N','N','N','N','N','N','N','N','N','','','','',0,0,0,0,'caching_sha2_password','$A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED','N',CURRENT_TIMESTAMP,NULL,'Y', 'N', 'N', NULL, NULL, NULL, NULL);
' failed with error code = 1136, error message = 'Column count doesn't match value count at row 1'.
2019-10-28T14:38:31.549337Z 0 [ERROR] [MY-013380] [Server] Failed to upgrade server.
2019-10-28T14:38:31.549954Z 0 [ERROR] [MY-010119] [Server] Aborting
2019-10-28T14:38:31.748888Z 0 [Note] [MY-012330] [InnoDB] FTS optimize thread exiting.
2019-10-28T14:38:31.752714Z 0 [Note] [MY-010120] [Server] Binlog end
2019-10-28T14:38:31.752894Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysqlx_cache_cleaner'
2019-10-28T14:38:31.752956Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysqlx'
2019-10-28T14:38:31.753419Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'ngram'
2019-10-28T14:38:31.753483Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'BLACKHOLE'
2019-10-28T14:38:31.753550Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'ARCHIVE'
2019-10-28T14:38:31.753620Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'TempTable'
2019-10-28T14:38:31.753710Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'PERFORMANCE_SCHEMA'
2019-10-28T14:38:31.753897Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'MRG_MYISAM'
2019-10-28T14:38:31.753986Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'MyISAM'
2019-10-28T14:38:31.754081Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_SESSION_TEMP_TABLESPACES'
2019-10-28T14:38:31.754181Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CACHED_INDEXES'
2019-10-28T14:38:31.754285Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_VIRTUAL'
2019-10-28T14:38:31.754396Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_COLUMNS'
2019-10-28T14:38:31.754511Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLESPACES'
2019-10-28T14:38:31.754638Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_INDEXES'
2019-10-28T14:38:31.754766Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLESTATS'
2019-10-28T14:38:31.754902Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TABLES'
2019-10-28T14:38:31.755041Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2019-10-28T14:38:31.755186Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2019-10-28T14:38:31.755337Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_CONFIG'
2019-10-28T14:38:31.755495Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2019-10-28T14:38:31.755664Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_DELETED'
2019-10-28T14:38:31.755833Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2019-10-28T14:38:31.756008Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_METRICS'
2019-10-28T14:38:31.756187Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2019-10-28T14:38:31.756374Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2019-10-28T14:38:31.756566Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2019-10-28T14:38:31.756771Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_BUFFER_PAGE'
2019-10-28T14:38:31.756975Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2019-10-28T14:38:31.757184Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2019-10-28T14:38:31.757399Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMPMEM_RESET'
2019-10-28T14:38:31.757621Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMPMEM'
2019-10-28T14:38:31.757859Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP_RESET'
2019-10-28T14:38:31.758096Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_CMP'
2019-10-28T14:38:31.758343Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'INNODB_TRX'
2019-10-28T14:38:31.758597Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'InnoDB'
2019-10-28T14:38:31.758892Z 0 [Note] [MY-013072] [InnoDB] Starting shutdown...
2019-10-28T14:38:32.462730Z 0 [Note] [MY-013084] [InnoDB] Log background threads are being closed...
2019-10-28T14:38:32.886538Z 0 [Note] [MY-012980] [InnoDB] Shutdown completed; log sequence number 226896237
2019-10-28T14:38:32.887816Z 0 [Note] [MY-012255] [InnoDB] Removed temporary tablespace data file: "ibtmp1"
2019-10-28T14:38:32.887964Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'MEMORY'
2019-10-28T14:38:32.888073Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'CSV'
2019-10-28T14:38:32.888193Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'sha2_cache_cleaner'
2019-10-28T14:38:32.888301Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'caching_sha2_password'
2019-10-28T14:38:32.888413Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'sha256_password'
2019-10-28T14:38:32.888523Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'mysql_native_password'
2019-10-28T14:38:32.888804Z 0 [Note] [MY-010733] [Server] Shutting down plugin 'binlog'
2019-10-28T14:38:32.889616Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.18) MySQL Community Server - GPL.
systemctl status mysqld.service
● mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: failed (Result: exit-code) since Mon 2019-10-28 10:34:48 EDT; 3s ago
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Process: 27516 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
Process: 27553 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS (code=exited, status=1/FAILURE)
Main PID: 27553 (code=exited, status=1/FAILURE)
Status: "Server upgrade complete"
Error: 2 (No such file or directory)
Oct 28 10:34:46ourdomain.edu mysqld[27553]: # CLONE_ADMIN, SHUTDOWN privileges
Oct 28 10:34:46ourdomain.edu mysqld[27553]: #
Oct 28 10:34:46ourdomain.edu mysqld[27553]: INSERT IGNORE INTO mysql.user VALUES ('localhost','mysql.session','N','N','N','N','N','N','N','Y','N','N','N','N','N','N','N','Y','N','N','N','N','N','N','N','N','N','N','N','N','N','','','','',0,0,0,0,'caching_sha2_password','$A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED','N',CURRENT_TIMESTAMP,NULL,'Y', 'N', 'N', NULL, NULL, NULL, NULL);
Oct 28 10:34:46ourdomain.edu mysqld[27553]: ' failed with error code = 1136, error message = 'Column count doesn't match value count at row 1'.
Oct 28 10:34:46ourdomain.edu mysqld[27553]: 2019-10-28T14:34:46.796166Z 0 [ERROR] [MY-013380] [Server] Failed to upgrade server.
Oct 28 10:34:46ourdomain.edu mysqld[27553]: 2019-10-28T14:34:46.796379Z 0 [ERROR] [MY-010119] [Server] Aborting
Oct 28 10:34:48ourdomain.edu mysqld[27553]: 2019-10-28T14:34:48.227233Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.18) MySQL Community Server - GPL.
Oct 28 10:34:48ourdomain.edu systemd[1]: mysqld.service: Main process exited, code=exited, status=1/FAILURE
Oct 28 10:34:48ourdomain.edu systemd[1]: mysqld.service: Failed with result 'exit-code'.
Oct 28 10:34:48ourdomain.edu systemd[1]: Failed to start MySQL Server.