Problems upgrading to mysql 8.4 from 5.7
- Go to: [ bottom of page ] [ top of archives ] [ this month ]
Date: Sun, 11 Aug 2024 21:56:41 UTC
I've just upgraded from the latest patch level of FreeBSD 12 to 13.3-p5. The only problem so far has been the MySQL upgrade. I didn't find any detailed instructions, I did vet the existing 5.7 db files as instructed on the MySQL site. Some instructions said to do a binary upgrade and start the MySQL server, which would upgrade the DB files. That's not happening. The upgrade process deleted 5.7. I used pkg to get mysql84. service mysql-server start The error log leaves a message about not being able to open mysql.ibd, which doesn't exist and I guess never has. Any help most urgently requested. Thanks! Pam Here's the logfile: 2024-08-11T21:44:30.6NZ mysqld_safe Logging to '/var/db/mysql/ns.ssr.com.err'. 2024-08-11T21:44:30.6NZ mysqld_safe Starting mysqld daemon with databases from /var/db/mysql 2024-08-11T21:44:30.688377Z 0 [System] [MY-015015] [Server] MySQL Server - start. 2024-08-11T21:44:30.899150Z 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 2024-08-11T21:44:30.899204Z 0 [System] [MY-010116] [Server] /usr/local/libexec/mysqld (mysqld 8.4.0) starting as process 7738 2024-08-11T21:44:30.944078Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2024-08-11T21:44:31.708765Z 1 [ERROR] [MY-012592] [InnoDB] Operating system error number 2 in a file operation. 2024-08-11T21:44:31.708803Z 1 [ERROR] [MY-012593] [InnoDB] The error means the system cannot find the path specified. 2024-08-11T21:44:31.708823Z 1 [ERROR] [MY-012216] [InnoDB] Cannot open datafile for read-only: 'mysql.ibd' OS error: 71 mysqld: Can't open file: 'mysql.ibd' (errno: 0 - ) 2024-08-11T21:44:31.764666Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 2024-08-11T21:44:31.764879Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2024-08-11T21:44:31.764911Z 0 [ERROR] [MY-010119] [Server] Aborting 2024-08-11T21:44:31.766104Z 0 [System] [MY-010910] [Server] /usr/local/libexec/mysqld: Shutdown complete (mysqld 8.4.0) Source distribution. 2024-08-11T21:44:31.766134Z 0 [System] [MY-015016] [Server] MySQL Server - end. 2024-08-11T21:44:31.6NZ mysqld_safe mysqld from pid file /var/db/mysql/ns.ssr.com.pid ended