Forum Stats

  • 3,824,917 Users
  • 2,260,439 Discussions
  • 7,896,346 Comments

Discussions

Upgrade from 5.7 to 8.0 fails - "Operating system error number 2 in a file operation."

Upgrading from 5.7 to 8.0 (finally) but have hit an issue and need help diagnosing it.

Error messages (IMO) not particulary helpful. I'm guessing it may be a locale issue?

ownership and mode of files/dirs in DB have been checked.

Any help/ideas appreciated.

---8<

2022-01-26T11:53:33.130737Z mysqld_safe Logging to '/nextcloud/mysql/data/ytc1-cloud.dyndns.org.err'.

2022-01-26T11:53:33.216703Z mysqld_safe Starting mysqld daemon with databases from /nextcloud/mysql/data

2022-01-26T11:53:33.806990Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.

2022-01-26T11:53:33.807040Z 0 [System] [MY-010116] [Server] /usr/mysql/8.0/bin/mysqld (mysqld 8.0.28) starting as process 22376

2022-01-26T11:53:34.131076Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.

2022-01-26T11:53:34.131255Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.

2022-01-26T11:53:42.145832Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.

[email protected]:/etc/mysql/8.0# tail -f /nextcloud/mysql/data/ytc1-cloud.dyndns.org.err

2022-01-26T11:06:41.550620Z 0 [Note] /usr/mysql/5.7/bin/mysqld: Shutdown complete   <<<<<<<<<<<<<<<<<<<<<<<<<<<<Shutdown of 5.7

2022-01-26T11:06:41.858895Z mysqld_safe mysqld from pid file /nextcloud/mysql/data/ytc1-cloud.dyndns.org.pid ended

2022-01-26T11:53:33.130737Z mysqld_safe Logging to '/nextcloud/mysql/data/ytc1-cloud.dyndns.org.err'.

2022-01-26T11:53:33.216703Z mysqld_safe Starting mysqld daemon with databases from /nextcloud/mysql/data

2022-01-26T11:53:33.806990Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.

2022-01-26T11:53:33.807040Z 0 [System] [MY-010116] [Server] /usr/mysql/8.0/bin/mysqld (mysqld 8.0.28) starting as process 22376

2022-01-26T11:53:34.131076Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.

2022-01-26T11:53:34.131255Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.

2022-01-26T11:53:42.145832Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.

2022-01-26T11:54:05.382533Z 2 [Warning] [MY-010772] [Server] db.opt file not found for test database. Using default Character set.

2022-01-26T11:54:17.685637Z 2 [System] [MY-011003] [Server] Finished populating Data Dictionary tables with data.

2022-01-26T11:54:33.267006Z mysqld_safe Logging to '/nextcloud/mysql/data/ytc1-cloud.dyndns.org.err'.

2022-01-26T11:54:33.337932Z mysqld_safe Starting mysqld daemon with databases from /nextcloud/mysql/data

2022-01-26T11:54:33.749523Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.

2022-01-26T11:54:33.749541Z 0 [System] [MY-010116] [Server] /usr/mysql/8.0/bin/mysqld (mysqld 8.0.28) starting as process 22697

2022-01-26T11:54:33.783506Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.

2022-01-26T11:54:36.294303Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.

2022-01-26T11:54:41.942993Z 4 [System] [MY-013381] [Server] Server upgrade from '50700' to '80028' started.

2022-01-26T11:54:43.336463Z 4 [ERROR] [MY-012592] [InnoDB] Operating system error number 2 in a file operation.

2022-01-26T11:54:43.336671Z 4 [ERROR] [MY-012593] [InnoDB] The error means the system cannot find the path specified.

2022-01-26T11:54:43.336786Z 4 [ERROR] [MY-012646] [InnoDB] File ./mysql/#sql-58a9_4.ibd: 'rename' returned OS error 71.

2022-01-26T11:54:43.456072Z 4 [ERROR] [MY-013178] [Server] Execution of server-side SQL statement 'ALTER TABLE proxies_priv MODIFY Host char(255) CHARACTER SET ASCII DEFAULT '' NOT NULL, ENGINE=InnoDB; ' failed with error code = 1025, error message = 'Error on rename of './mysql/#sql-58a9_4' to './mysql/proxies_priv' (errno: 168 - Unknown (generic) error from engine)'.

2022-01-26T11:54:43.473322Z 0 [ERROR] [MY-013380] [Server] Failed to upgrade server.

2022-01-26T11:54:43.473584Z 0 [ERROR] [MY-010119] [Server] Aborting

2022-01-26T11:54:48.336150Z 0 [System] [MY-010910] [Server] /usr/mysql/8.0/bin/mysqld: Shutdown complete (mysqld 8.0.28) MySQL Community Server (GPL) - SFE build.

2022-01-26T11:54:48.481787Z mysqld_safe mysqld from pid file /nextcloud/mysql/data/ytc1-cloud.dyndns.org.pid ended

2022-01-26T11:54:48.772282Z mysqld_safe Logging to '/nextcloud/mysql/data/ytc1-cloud.dyndns.org.err'.

2022-01-26T11:54:48.827317Z mysqld_safe Starting mysqld daemon with databases from /nextcloud/mysql/data

2022-01-26T11:54:49.241899Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.

2022-01-26T11:54:49.241917Z 0 [System] [MY-010116] [Server] /usr/mysql/8.0/bin/mysqld (mysqld 8.0.28) starting as process 22887

2022-01-26T11:54:49.310599Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.

2022-01-26T11:54:49.958726Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.

2022-01-26T11:54:50.161779Z 4 [System] [MY-013381] [Server] Server upgrade from '50700' to '80028' started.

2022-01-26T11:54:50.650606Z 4 [ERROR] [MY-012592] [InnoDB] Operating system error number 2 in a file operation.

2022-01-26T11:54:50.650797Z 4 [ERROR] [MY-012593] [InnoDB] The error means the system cannot find the path specified.

2022-01-26T11:54:50.650891Z 4 [ERROR] [MY-012646] [InnoDB] File ./mysql/#sql-5967_4.ibd: 'rename' returned OS error 71.

2022-01-26T11:54:50.723701Z 4 [ERROR] [MY-013178] [Server] Execution of server-side SQL statement 'ALTER TABLE proxies_priv MODIFY Host char(255) CHARACTER SET ASCII DEFAULT '' NOT NULL, ENGINE=InnoDB; ' failed with error code = 1025, error message = 'Error on rename of './mysql/#sql-5967_4' to './mysql/proxies_priv' (errno: 168 - Unknown (generic) error from engine)'.

2022-01-26T11:54:50.739215Z 0 [ERROR] [MY-013380] [Server] Failed to upgrade server.

2022-01-26T11:54:50.739781Z 0 [ERROR] [MY-010119] [Server] Aborting

2022-01-26T11:54:52.063518Z 0 [System] [MY-010910] [Server] /usr/mysql/8.0/bin/mysqld: Shutdown complete (mysqld 8.0.28) MySQL Community Server (GPL) - SFE build.

2022-01-26T11:54:52.203698Z mysqld_safe mysqld from pid file /nextcloud/mysql/data/ytc1-cloud.dyndns.org.pid ended

2022-01-26T11:54:53.028409Z mysqld_safe Logging to '/nextcloud/mysql/data/ytc1-cloud.dyndns.org.err'.

2022-01-26T11:54:53.081270Z mysqld_safe Starting mysqld daemon with databases from /nextcloud/mysql/data

2022-01-26T11:54:53.499455Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.

2022-01-26T11:54:53.499473Z 0 [System] [MY-010116] [Server] /usr/mysql/8.0/bin/mysqld (mysqld 8.0.28) starting as process 23048

2022-01-26T11:54:53.534081Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.

2022-01-26T11:54:54.773954Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.

2022-01-26T11:54:55.002496Z 4 [System] [MY-013381] [Server] Server upgrade from '50700' to '80028' started.

2022-01-26T11:54:55.580124Z 4 [ERROR] [MY-012592] [InnoDB] Operating system error number 2 in a file operation.

2022-01-26T11:54:55.580366Z 4 [ERROR] [MY-012593] [InnoDB] The error means the system cannot find the path specified.

2022-01-26T11:54:55.580479Z 4 [ERROR] [MY-012646] [InnoDB] File ./mysql/#sql-5a08_4.ibd: 'rename' returned OS error 71.

2022-01-26T11:54:55.676823Z 4 [ERROR] [MY-013178] [Server] Execution of server-side SQL statement 'ALTER TABLE proxies_priv MODIFY Host char(255) CHARACTER SET ASCII DEFAULT '' NOT NULL, ENGINE=InnoDB; ' failed with error code = 1025, error message = 'Error on rename of './mysql/#sql-5a08_4' to './mysql/proxies_priv' (errno: 168 - Unknown (generic) error from engine)'.

2022-01-26T11:54:55.694562Z 0 [ERROR] [MY-013380] [Server] Failed to upgrade server.

2022-01-26T11:54:55.695140Z 0 [ERROR] [MY-010119] [Server] Aborting

2022-01-26T11:54:56.710009Z 0 [System] [MY-010910] [Server] /usr/mysql/8.0/bin/mysqld: Shutdown complete (mysqld 8.0.28) MySQL Community Server (GPL) - SFE build.

2022-01-26T11:54:56.850695Z mysqld_safe mysqld from pid file /nextcloud/mysql/data/ytc1-cloud.dyndns.org.pid ended

---8<

Comments