[Eisfair] Fehler nach Umstellung auf MariaDB103

Benjamin Heide benjamin.heide at freenet.de
So Mär 22 17:50:34 CET 2020


Im mysql.log ist selbiges zu finden:

│Version: '10.3.20-MariaDB'  Socket: '/run/mysql/103/mysql.sock'  Port: 
3306  eisfair-1 build 
                                                        ▒
│2020-03-22 16:43:18 0 [Note] InnoDB: Buffer pool(s) load completed at 
200322 16:43:18 
                                                         ▒
│2020-03-22 16:43:53 0 [Note] /usr/lib/mysql/103/bin/mysqld (unknown): 
Normal heruntergefahren 
                                                         ▒
│2020-03-22 16:43:53 0 [Note] InnoDB: FTS optimize thread exiting. 
 
                                                        ▒
│2020-03-22 16:43:53 0 [Note] InnoDB: Starting shutdown... 
 
                                                        ▒
│2020-03-22 16:43:53 0 [Note] InnoDB: Dumping buffer pool(s) to 
/srv/mysql/103/ib_buffer_pool 
                                                                ▒
│2020-03-22 16:43:54 0 [Note] InnoDB: Instance 0, restricted to 2047 
pages due to innodb_buf_pool_dump_pct=25 
                                                           ▒
│2020-03-22 16:43:54 0 [Note] InnoDB: Buffer pool(s) dump completed at 
200322 16:43:53 
                                                         ▒
│2020-03-22 16:43:55 0 [Note] InnoDB: Shutdown completed; log sequence 
number 8174432835; transaction id 11760 
                                                         ▒
│2020-03-22 16:43:55 0 [Note] InnoDB: Removed temporary tablespace data 
file: "ibtmp1" 
                                                        ▒
│2020-03-22 16:43:55 0 [Note] /usr/lib/mysql/103/bin/mysqld: 
Herunterfahren beendet 
                                                                   ▒
│ 
 
                                                        ▒
│2020-03-22 16:44:19 0 [Note] InnoDB: Using Linux native AIO 
 
                                                        ▒
│2020-03-22 16:44:19 0 [Note] InnoDB: Mutexes and rw_locks use GCC 
atomic builtins 
                                                             ▒
│2020-03-22 16:44:19 0 [Note] InnoDB: Uses event mutexes 
 
                                                        ▒
│2020-03-22 16:44:19 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 
 
                                                        ▒
│2020-03-22 16:44:19 0 [Note] InnoDB: Number of pools: 1 
 
                                                        ▒
│2020-03-22 16:44:19 0 [Note] InnoDB: Using generic crc32 instructions 
 
                                                        ▒
│2020-03-22 16:44:19 0 [Note] InnoDB: Initializing buffer pool, total 
size = 128M, instances = 1, chunk size = 128M 
                                                          ▒
│2020-03-22 16:44:19 0 [Note] InnoDB: Completed initialization of buffer 
pool 
                                                       ▒
│2020-03-22 16:44:19 0 [Note] InnoDB: If the mysqld execution user is 
authorized, page cleaner thread priority can be changed. See the man 
page of setpriority().                                       ▒
│2020-03-22 16:44:19 0 [Note] InnoDB: 128 out of 128 rollback segments 
are active. 
                                                         ▒
│2020-03-22 16:44:19 0 [Note] InnoDB: Creating shared tablespace for 
temporary tables 
                                                           ▒
│2020-03-22 16:44:19 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 
MB. Physically writing the file full; Please wait ... 
                                                       ▒
│2020-03-22 16:44:19 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 
 
                                                        ▒
│2020-03-22 16:44:19 0 [Note] InnoDB: 10.3.20 started; log sequence 
number 8174432835; transaction id 11762 
                                                            ▒
│2020-03-22 16:44:19 0 [Note] InnoDB: Loading buffer pool(s) from 
/srv/mysql/103/ib_buffer_pool 
                                                              ▒
│2020-03-22 16:44:19 0 [Note] Plugin 'FEEDBACK' is disabled. 
 
                                                        ▒
│2020-03-22 16:44:19 0 [Note] Server socket created on IP: '::'. 
 
                                                        ▒
│2020-03-22 16:44:19 0 [ERROR] Incorrect definition of table 
mysql.event: expected column 'sql_mode' at position 14 to have type 
set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGN▒
│2020-03-22 16:44:19 0 [ERROR] mysqld: Event Scheduler: An error 
occurred when initializing system tables. Disabling the Event Scheduler. 
                                                               ▒
│2020-03-22 16:44:19 0 [Note] Reading of all Master_info entries 
succeeded 
                                                               ▒
│2020-03-22 16:44:19 0 [Note] Added new Master_info '' to hash table 
 
                                                        ▒
│2020-03-22 16:44:19 0 [Note] /usr/lib/mysql/103/bin/mysqld: bereit für 
Verbindungen. 
                                                        ▒
│Version: '10.3.20-MariaDB'  Socket: '/run/mysql/103/mysql.sock'  Port: 
3306  eisfair-1 build 
                                                        ▒
│2020-03-22 16:44:19 0 [Note] InnoDB: Buffer pool(s) load completed at 
200322 16:44:19 
                                                         ▒
│2020-03-22 16:59:45 1336 [ERROR] Spaltenanzahl von mysql.proc falsch. 
21 erwartet, aber 20 gefunden. Tabelle ist wahrscheinlich beschädigt


Mehr Informationen über die Mailingliste Eisfair