MySQL Forums
Forum List  »  General

mysqld upgrade=FORCE with error code = 1136, error message = 'Column count doesn't match value count at row 1'
Posted by: Rob Kudyba
Date: October 28, 2019 08:50AM

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.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.