[Eisfair] Fehler nach Umstellung auf MariaDB103
Benjamin Heide
benjamin.heide at freenet.de
So Mär 22 19:53:12 CET 2020
Am 22.03.2020 um 19:45 schrieb Holger Bruenjes:
> Hallo Benjamin
>
> Am 22/03/2020 um 19.35 schrieb Benjamin Heide:
>
>> nüx
>
> installier es nochmal drueber
>
> Holger
>
>
2020-03-22 19:50:23 0 [Note] /usr/lib/mysql/103/bin/mysqld (unknown):
Normal heruntergefahren
▒
│2020-03-22 19:50:23 0 [Note] InnoDB: FTS optimize thread exiting.
▒
│2020-03-22 19:50:23 0 [Note] InnoDB: Starting shutdown...
▒
│2020-03-22 19:50:23 0 [Note] InnoDB: Dumping buffer pool(s) to
/srv/mysql/103/ib_buffer_pool
▒
│2020-03-22 19:50:23 0 [Note] InnoDB: Instance 0, restricted to 2047
pages due to innodb_buf_pool_dump_pct=25
▒
│2020-03-22 19:50:23 0 [Note] InnoDB: Buffer pool(s) dump completed at
200322 19:50:23
▒
│2020-03-22 19:50:24 0 [Note] InnoDB: Shutdown completed; log sequence
number 8178845517; transaction id 31369
▒
│2020-03-22 19:50:24 0 [Note] InnoDB: Removed temporary tablespace data
file: "ibtmp1"
▒
│2020-03-22 19:50:24 0 [Note] /usr/lib/mysql/103/bin/mysqld:
Herunterfahren beendet
▒
│
▒
│2020-03-22 19:50:48 6 [ERROR] Spaltenanzahl von mysql.proc falsch. 21
erwartet, aber 20 gefunden. Tabelle ist wahrscheinlich beschädigt
▒
│2020-03-22 19:50:48 6 [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▒
│ERROR: 1136 Anzahl der Felder stimmt nicht mit der Anzahl der Werte in
Zeile 1 überein
▒
│2020-03-22 19:50:48 0 [ERROR] Aborting
▒
│
▒
│2020-03-22 19:50:50 0 [Note] InnoDB: Using Linux native AIO
▒
│2020-03-22 19:50:50 0 [Note] InnoDB: Mutexes and rw_locks use GCC
atomic builtins
▒
│2020-03-22 19:50:50 0 [Note] InnoDB: Uses event mutexes
▒
│2020-03-22 19:50:50 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
▒
│2020-03-22 19:50:50 0 [Note] InnoDB: Number of pools: 1
▒
│2020-03-22 19:50:50 0 [Note] InnoDB: Using generic crc32 instructions
▒
│2020-03-22 19:50:50 0 [Note] InnoDB: Initializing buffer pool, total
size = 128M, instances = 1, chunk size = 128M
▒
│2020-03-22 19:50:50 0 [Note] InnoDB: Completed initialization of buffer
pool
▒
│2020-03-22 19:50:50 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 19:50:51 0 [Note] InnoDB: 128 out of 128 rollback segments
are active.
▒
│2020-03-22 19:50:51 0 [Note] InnoDB: Creating shared tablespace for
temporary tables
▒
│2020-03-22 19:50:51 0 [Note] InnoDB: Setting file './ibtmp1' size to 12
MB. Physically writing the file full; Please wait ...
▒
│2020-03-22 19:50:51 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
▒
│2020-03-22 19:50:51 0 [Note] InnoDB: Waiting for purge to start
▒
│2020-03-22 19:50:51 0 [Note] InnoDB: 10.3.20 started; log sequence
number 8178845526; transaction id 31371
▒
│2020-03-22 19:50:51 0 [Note] InnoDB: Loading buffer pool(s) from
/srv/mysql/103/ib_buffer_pool
▒
│2020-03-22 19:50:51 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-03-22 19:50:51 0 [Note] Server socket created on IP: '::'.
▒
│2020-03-22 19:50:51 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 19:50:51 0 [ERROR] mysqld: Event Scheduler: An error
occurred when initializing system tables. Disabling the Event Scheduler.
▒
│2020-03-22 19:50:51 0 [Note] Reading of all Master_info entries
succeeded
▒
│2020-03-22 19:50:51 0 [Note] Added new Master_info '' to hash table
▒
│2020-03-22 19:50:51 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 19:50:51 0 [Note] InnoDB: Buffer pool(s) load completed at
200322 19:50:51
▒
│2020-03-22 19:50:51 9 [Warning] Benutzer 'root'@'localhost' hat keine
Zugriffsberechtigung (verwendetes Passwort: Nein)
▒
│2020-03-22 19:50:51 0 [Note] /usr/lib/mysql/103/bin/mysqld (unknown):
Normal heruntergefahren
▒
│2020-03-22 19:50:51 0 [Note] InnoDB: FTS optimize thread exiting.
▒
│2020-03-22 19:50:51 0 [Note] InnoDB: Starting shutdown...
▒
│2020-03-22 19:50:51 0 [Note] InnoDB: Dumping buffer pool(s) to
/srv/mysql/103/ib_buffer_pool
▒
│2020-03-22 19:50:51 0 [Note] InnoDB: Instance 0, restricted to 2047
pages due to innodb_buf_pool_dump_pct=25
▒
│2020-03-22 19:50:51 0 [Note] InnoDB: Buffer pool(s) dump completed at
200322 19:50:51
▒
│2020-03-22 19:50:52 0 [Note] InnoDB: Shutdown completed; log sequence
number 8178845535; transaction id 31372
▒
│2020-03-22 19:50:52 0 [Note] InnoDB: Removed temporary tablespace data
file: "ibtmp1"
▒
│2020-03-22 19:50:52 0 [Note] /usr/lib/mysql/103/bin/mysqld:
Herunterfahren beendet
▒
│
▒
│2020-03-22 19:50:57 0 [Note] InnoDB: Using Linux native AIO
▒
│2020-03-22 19:50:57 0 [Note] InnoDB: Mutexes and rw_locks use GCC
atomic builtins
▒
│2020-03-22 19:50:57 0 [Note] InnoDB: Uses event mutexes
▒
│2020-03-22 19:50:57 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
▒
│2020-03-22 19:50:57 0 [Note] InnoDB: Number of pools: 1
▒
│2020-03-22 19:50:57 0 [Note] InnoDB: Using generic crc32 instructions
▒
│2020-03-22 19:50:57 0 [Note] InnoDB: Initializing buffer pool, total
size = 128M, instances = 1, chunk size = 128M
▒
│2020-03-22 19:50:57 0 [Note] InnoDB: Completed initialization of buffer
pool
▒
│2020-03-22 19:50:57 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 19:50:57 0 [Note] InnoDB: 128 out of 128 rollback segments
are active.
▒
│2020-03-22 19:50:57 0 [Note] InnoDB: Creating shared tablespace for
temporary tables
▒
│2020-03-22 19:50:57 0 [Note] InnoDB: Setting file './ibtmp1' size to 12
MB. Physically writing the file full; Please wait ...
▒
│2020-03-22 19:50:57 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
▒
│2020-03-22 19:50:57 0 [Note] InnoDB: 10.3.20 started; log sequence
number 8178845535; transaction id 31371
▒
│2020-03-22 19:50:57 0 [Note] InnoDB: Loading buffer pool(s) from
/srv/mysql/103/ib_buffer_pool
▒
│2020-03-22 19:50:57 0 [Note] Plugin 'FEEDBACK' is disabled.
▒
│2020-03-22 19:50:57 0 [Note] Server socket created on IP: '::'.
│2020-03-22 19:50:57 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 19:50:57 0 [ERROR] mysqld: Event Scheduler: An error
occurred when initializing system tables. Disabling the Event Scheduler.
▒
│2020-03-22 19:50:57 0 [Note] Reading of all Master_info entries
succeeded
▒
│2020-03-22 19:50:57 0 [Note] Added new Master_info '' to hash table
▒
│2020-03-22 19:50:57 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 19:50:57 0 [Note] InnoDB: Buffer pool(s) load completed at
200322 19:50:57
▒
│
▒
│
▒
│
Mehr Informationen über die Mailingliste Eisfair