[Eisfair] Umstieg MariaDB 10.3 auf 11.0?

[Dirk Alberti]

Hallo Marcus,

Am 20.09.24 um 18:27 schrieb Marcus Röckrath:
> Hallo Dirk,
> 
> Dirk Alberti wrote:
> 
>>> Auf jeden Fall musste ich die im Howto erwähnte Manipulation des Backups
>>> der systeminternen mysql-DB machen, damit das Backup mit 11.0 kompatibel
>>> ist.
>>>
>>> Hast du das getan?
>>
>> Nein, das konnte ich nicht, weil wie erwähnt nicht zu sehen ist, was
>> nachgetragen werde muss.
> 
> Habe gerade nachgesehen: Die roten Markierungen sind da wohl beim Umstieg
> auf das neue System verloren gegangen bzw. in solchen Code-Boxen gehen wohl
> Farben nicht.
> 
> Habe das nun mit Kommentaren versehen; schau mal, ob es diese Zeilen sind,
> die im alten mysqlDB-Backup fehlen.
> 

also geht es nur um die zwei Zeilen

DROP TABLE IF EXISTS `global_priv`;

DROP VIEW IF EXISTS `user`;


Ok, die habe ich ergänzt.


> Dann führe das Upgrade erneut durch.
> 


Um das Restore durchzuführen müsste doch aber MariaDB 11.0 bestimmt 
laufen, doch daran scheitert es. Es startet nicht.

Activate configuration now (y/n) [yes]?
  * Restarting MariaDB/MySQL database: server 11.0 ...
Job for mariadb110.service failed because the control process exited 
with error code.
See "systemctl status mariadb110.service" and "journalctl -xeu 
mariadb110.service" for details. 
  [ FAIL ]
Press ENTER to continue ^[[21~



Die Ausgaben der Befehle bringen keine wirklichen Aufschlüsse:



× mariadb110.service - MariaDB/MySQL database: server 11.0
      Loaded: loaded (/usr/lib/systemd/system/mariadb110.service; 
enabled; preset: disabled)
      Active: failed (Result: exit-code) since Fri 2024-09-20 19:12:37 
CEST; 7min ago
    Duration: 11min 9.231s
     Process: 3073 
ExecStart=/usr/lib/systemd/scripts/mysql-common-mariadb-start mariadb110 
(code=exited, status=1/FAILURE)
         CPU: 41ms

Sep 20 19:12:37 eisfair systemd[1]: Starting MariaDB/MySQL database: 
server 11.0...
Sep 20 19:12:37 eisfair systemd[1]: mariadb110.service: Control process 
exited, code=exited, status=1/FAILURE
Sep 20 19:12:37 eisfair systemd[1]: mariadb110.service: Failed with 
result 'exit-code'.
Sep 20 19:12:37 eisfair systemd[1]: Failed to start MariaDB/MySQL 
database: server 11.0.



und


  The unit mariadb110.service has entered the 'failed' state with result 
'exit-code'.


Na das weiß ich selber, dass mariadb110 nicht läuft.


/var/log/mysqld/110/mysqld.log:

 

2024-09-20 17:07:07 0 [Note] Starting MariaDB 11.0.6-MariaDB source 
revision 466ae1cf81f54b729058357bb19c4cf3982e1367 as process 8730
2024-09-20 17:07:07 0 [Note] InnoDB: Compressed tables use zlib 1.3.1
2024-09-20 17:07:07 0 [Note] InnoDB: Number of transaction pools: 1
2024-09-20 17:07:07 0 [Note] InnoDB: Using generic crc32 instructions
2024-09-20 17:07:07 0 [Note] InnoDB: Using Linux native AIO
2024-09-20 17:07:07 0 [Note] InnoDB: Initializing buffer pool, total 
size = 128.000MiB, chunk size = 2.000MiB
2024-09-20 17:07:07 0 [Note] InnoDB: Completed initialization of buffer pool
2024-09-20 17:07:07 0 [Note] InnoDB: File system buffers for log 
disabled (block size=512 bytes)
2024-09-20 17:07:07 0 [Note] InnoDB: Starting crash recovery from 
checkpoint LSN=18006
2024-09-20 17:07:07 0 [Note] InnoDB: End of log at LSN=37808
2024-09-20 17:07:07 0 [Note] InnoDB: To recover: 146 pages
2024-09-20 17:07:07 0 [Note] InnoDB: Opened 3 undo tablespaces
2024-09-20 17:07:07 0 [Note] InnoDB: 128 rollback segments in 3 undo 
tablespaces are active.
2024-09-20 17:07:07 0 [Note] InnoDB: Removed temporary tablespace data 
file: "./ibtmp1"
2024-09-20 17:07:07 0 [Note] InnoDB: Setting file './ibtmp1' size to 
12.000MiB. Physically writing the file full; Please wait ...
2024-09-20 17:07:07 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2024-09-20 17:07:07 0 [Note] InnoDB: log sequence number 37808; 
transaction id 4
2024-09-20 17:07:07 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-09-20 17:07:07 0 [Note] Plugin 'wsrep-provider' is disabled.
2024-09-20 17:07:07 0 [ERROR] Could not open mysql.plugin table: 
"Tabelle 'mysql.plugin' existiert nicht". Some plugins may be not loaded
2024-09-20 17:07:07 0 [Note] InnoDB: Loading buffer pool(s) from 
/srv/mysql/110/ib_buffer_pool
2024-09-20 17:07:07 0 [Note] InnoDB: Cannot open 
'/srv/mysql/110/ib_buffer_pool' for reading: No such file or directory
2024-09-20 17:07:07 0 [ERROR] Can't open and lock privilege tables: 
Tabelle 'mysql.servers' existiert nicht
2024-09-20 17:07:07 0 [ERROR] Fatal error: Can't open and lock privilege 
tables: Tabelle 'mysql.db' existiert nicht
2024-09-20 17:07:07 0 [ERROR] Aborting
2024-09-20 17:07:17 0 [Warning] Signal handler thread did not exit in a 
timely manner. Continuing to wait for it to stop..