[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