Kontact oder Kmail: mysql.err

--nextPart13487912.uLZWGnKmhe
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain; charset="utf-8"; protected-headers="v1"
From: Matthias =?ISO-8859-1?Q?M=FCller?= <[email protected]>
To: KDE Mailingliste <[email protected]>
Subject: Kontact oder Kmail: mysql.err
Date: Mon, 08 Apr 2024 11:11:03 +0200
Message-ID: <2179199.irdbgypaU6@gandalf>
MIME-Version: 1.0

Hallo an Alle,

Im Rahmen einer geplanten Migration auf einen neuen Rechner, wollte ich mei=
n=20
Heimatverzeichnis sichern.
Da ich diverse cache-Verzeichnisse und temp. Daten nicht mitsichern wollte,=
=20
habe ich mir angesehen was da f=C3=BCr Zeug rumliegt, das nicht gesichert w=
erden=20
muss.
Zu meiner Verwunderung habe ich eine Belegung von ca 70 GB, bei einer=20
Gesamtgr=C3=B6=C3=9Fe von ca 93 GB, fest gestellt.=20
Daraufhin habe ich mit filelight mal angesehn, was da so rum liegt.
Ich war einigerma=C3=9Fen erstaunt, dass es eine Datei "mysql.err.old" mit =
einer=20
Gr=C3=B6=C3=9Fe von ca 38 GB gibt. Aktuell ist diese Datei ca 300 MB gro=C3=
=9F.
Inhalt (Auszug):
> 2024-04-05 15:04:50 0 [Note] Starting MariaDB 10.11.6-MariaDB-0+deb12u1=20
source revision  as process 2578
> 2024-04-05 15:04:50 0 [Warning] option 'innodb-log-buffer-size': unsigned=
=20
value 1048576 adjusted to 2097152
> 2024-04-05 15:04:50 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
> 2024-04-05 15:04:50 0 [Note] InnoDB: Number of transaction pools: 1
> 2024-04-05 15:04:50 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
> 2024-04-05 15:04:50 0 [Note] InnoDB: Using liburing
> 2024-04-05 15:04:50 0 [Note] InnoDB: Initializing buffer pool, total size=
 =3D=20
128.000MiB, chunk size =3D 2.000MiB
> 2024-04-05 15:04:50 0 [Note] InnoDB: Completed initialization of buffer p=
ool
> 2024-04-05 15:04:50 0 [Note] InnoDB: Buffered log writes (block size=3D51=
2=20
bytes)
> 2024-04-05 15:04:50 0 [Note] InnoDB: End of log at LSN=3D1819222431
> 2024-04-05 15:04:50 0 [Note] InnoDB: 128 rollback segments are active.
> 2024-04-05 15:04:50 0 [Note] InnoDB: Setting file './ibtmp1' size to=20
12.000MiB. Physically writing the file full; Please wait ...
> 2024-04-05 15:04:50 0 [Note] InnoDB: File './ibtmp1' size is now 12.000Mi=
B.
> 2024-04-05 15:04:50 0 [Note] InnoDB: log sequence number 1819222431;=20
transaction id 5567216
> 2024-04-05 15:04:50 0 [Note] Plugin 'FEEDBACK' is disabled.
> 2024-04-05 15:04:50 0 [Note] InnoDB: Loading buffer pool(s) from /home/
matththo/.local/share/akonadi/db_data/ib_buffer_pool
> 2024-04-05 15:04:50 0 [Note] /usr/sbin/mysqld: ready for connections.
> Version: '10.11.6-MariaDB-0+deb12u1'  socket: '/run/user/1001/akonadi/
mysql.socket'  port: 0  Debian 12
> 2024-04-05 15:04:51 0 [Note] InnoDB: Buffer pool(s) load completed at 240=
405=20
15:04:51
> 2024-04-05 15:04:51 4 [ERROR] Incorrect definition of table=20
mysql.column_stats: expected column 'hist_type' at position 9 to have type=
=20
enum('SINGLE_PREC_HB','DOUBLE_PREC_HB','JSON_HB'), found type=20
enum('SINGLE_PREC_HB','DOUBLE_PREC_HB').
> 2024-04-05 15:04:51 4 [ERROR] Incorrect definition of table=20
mysql.column_stats: expected column 'histogram' at position 10 to have type=
=20
longblob, found type varbinary(255).
> 2024-04-05 15:04:51=20

=2E.. So geht es dann etwa 1495220 Zeilen weiter bis dann irgendwann das hi=
er=20
kommt. Das war der Zeitpunkt als ich den Rechner herunter gefahren habe.

> 2024-04-07 23:18:49 54 [ERROR] Incorrect definition of table=20
mysql.column_stats: expected column 'histogram' at position 10 to have type=
=20
longblob, found type varbinary(255).
> 2024-04-07 23:20:03 0 [Note] /usr/sbin/mysqld (initiated by: unknown):=20
Normal shutdown
> 2024-04-07 23:20:03 0 [Note] InnoDB: FTS optimize thread exiting.
> 2024-04-07 23:20:03 0 [Note] InnoDB: Starting shutdown...
> 2024-04-07 23:20:03 0 [Note] InnoDB: Dumping buffer pool(s) to /home/
matththo/.local/share/akonadi/db_data/ib_buffer_pool
> 2024-04-07 23:20:03 0 [Note] InnoDB: Restricted to 2016 pages due to=20
innodb_buf_pool_dump_pct=3D25
> 2024-04-07 23:20:03 0 [Note] InnoDB: Buffer pool(s) dump completed at 240=
407=20
23:20:03
> 2024-04-07 23:20:03 0 [Note] InnoDB: Removed temporary tablespace data fi=
le:=20
"./ibtmp1"
> 2024-04-07 23:20:03 0 [Note] InnoDB: Shutdown completed; log sequence num=
ber=20
1824103844; transaction id 5584188
> 2024-04-07 23:20:03 0 [Note] /usr/sbin/mysqld: Shutdown complete

Kann mir irgend jemand erkl=C3=A4ren, was das ist?
Wie kann ich das beheben, au=C3=9Fer cronjob zum regelm=C3=A4=C3=9Figen l=
=C3=B6schen?

=2D-=20
Mit freundlichen Gr=C3=BC=C3=9Fen
Matthias M=C3=BCller

Diese Mail ist mit OpenPGP signiert!
Zum =C3=BCberpr=C3=BCfen der Signatur, der Integrit=C3=A4t und Authentizit=
=C3=A4t
meiner Mails kann man OpenPGP (https://www.openpgp.org/) installieren.
Bitte s Gb festgestllt enden Sie als Antwort auf meine E-Mails reine Text-
Nachrichten!
--nextPart13487912.uLZWGnKmhe
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: This is a digitally signed message part.
Content-Transfer-Encoding: 7Bit

-----BEGIN PGP SIGNATURE-----

iQEzBAABCgAdFiEEDEJU0AzJfv2xvgnzBDNAWhrmAZsFAmYTtKcACgkQBDNAWhrm
AZsHoAgArhSv/njQKTNPu1kp1gFDNM78Qpd0tbJrFYkbZpv8UssVPN0jYvJZGSKx
MO0O3/FBWmGeMNdEZoKRuPR1XQ69rESxJVyOFU6ISMdMJfmbhi9Se5zHNSLEySJ2
SbNXEjcI4eIrTdige8Frcmo6RZNOI5MyoOJmcWtRpz5PHiBwZhaHsw/XpfEl7GA2
J6WVdTBqkYnRvX7AQjPDuC5jKsj8O6cBRWUxHXLGzb75g1zZdnp0xYrdjE4M7p/X
9lVfseAqMihJV/cNsNkJMYN1W8eCT948aYVKQ7kwOxM8WpZnLfnz6X0GJGOapQK0
SPiEJxm8UX50hxiNENx2any4o85Axg==
=n1Tg
-----END PGP SIGNATURE-----

--nextPart13487912.uLZWGnKmhe--