stamattina il mio server mi ha fatto una bella sorpresina: mysql non funziona più!!! E sono veramente preoccupato.
Fino a ieri funzionava alla grande e non ho effettuato alcun upgrade.
Ecco il mio sistema:
- Il sistema si basa su Ubuntu 21.10
mysql Ver 8.0.29-0ubuntu0.21.10.1 for Linux on x86_64 ((Ubuntu))
PHP 7.4.29 (cli) (built: Apr 21 2022 10:16:53) ( NTS )
sudo service mysql status :
Codice: Seleziona tutto
● mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
Active: activating (start) since Wed 2022-05-04 09:48:23 CEST; 10s ago
Process: 133190 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
Main PID: 133198 (mysqld)
Status: "Server upgrade complete"
Tasks: 28 (limit: 9150)
Memory: 524.8M
CPU: 10.297s
CGroup: /system.slice/mysql.service
└─133198 /usr/sbin/mysqld
May 04 09:48:23 www systemd[1]: Starting MySQL Community Server…
Codice: Seleziona tutto
2022-05-04T07:50:07.920365Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.29-0ubuntu0.21.10.1) (Ubuntu).
2022-05-04T07:50:08.684332Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.29-0ubuntu0.21.10.1) starting as process 134046
2022-05-04T07:50:08.697736Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-05-04T07:50:10.243141Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2022-05-04T07:50:10.936460Z 4 [System] [MY-013381] [Server] Server upgrade from '80028' to '80029' started.
2022-05-04T07:50:18.538809Z 4 [ERROR] [MY-013178] [Server] Execution of server-side SQL statement 'INSERT IGNORE INTO mysql.db VALUES ('localhost', 'performance_schema', 'mysql.session','Y','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N'); ' failed with error code = 1136, error message = 'Column count doesn't match value count at row 1'.
2022-05-04T07:50:18.552450Z 0 [ERROR] [MY-013380] [Server] Failed to upgrade server.
2022-05-04T07:50:18.553508Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-05-04T07:50:21.124845Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.29-0ubuntu0.21.10.1) (Ubuntu).
2022-05-04T07:50:21.892473Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.29-0ubuntu0.21.10.1) starting as process 134150
2022-05-04T07:50:21.906139Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-05-04T07:50:23.434553Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2022-05-04T07:50:24.153331Z 4 [System] [MY-013381] [Server] Server upgrade from '80028' to '80029' started.
2022-05-04T07:50:31.349952Z 4 [ERROR] [MY-013178] [Server] Execution of server-side SQL statement 'INSERT IGNORE INTO mysql.db VALUES ('localhost', 'performance_schema', 'mysql.session','Y','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N'); ' failed with error code = 1136, error message = 'Column count doesn't match value count at row 1'.
2022-05-04T07:50:31.362600Z 0 [ERROR] [MY-013380] [Server] Failed to upgrade server.
2022-05-04T07:50:31.363018Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-05-04T07:50:33.893128Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.29-0ubuntu0.21.10.1) (Ubuntu).
2022-05-04T07:50:34.652438Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.29-0ubuntu0.21.10.1) starting as process 134256
2022-05-04T07:50:34.667287Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-05-04T07:50:36.225308Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2022-05-04T07:50:36.952830Z 4 [System] [MY-013381] [Server] Server upgrade from '80028' to '80029' started.
2022-05-04T07:50:44.000846Z 4 [ERROR] [MY-013178] [Server] Execution of server-side SQL statement 'INSERT IGNORE INTO mysql.db VALUES ('localhost', 'performance_schema', 'mysql.session','Y','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N'); ' failed with error code = 1136, error message = 'Column count doesn't match value count at row 1'.
2022-05-04T07:50:44.008435Z 0 [ERROR] [MY-013380] [Server] Failed to upgrade server.
2022-05-04T07:50:44.008713Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-05-04T07:50:46.752662Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.29-0ubuntu0.21.10.1) (Ubuntu).
2022-05-04T07:50:47.395325Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.29-0ubuntu0.21.10.1) starting as process 134361
2022-05-04T07:50:47.407467Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-05-04T07:50:48.835756Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2022-05-04T07:50:49.548436Z 4 [System] [MY-013381] [Server] Server upgrade from '80028' to '80029' started.
Cosa posso fare senza perdere i dati salvati su mysql?