[Akonadi] [Bug 456983] mysql.err.old grows too large (over 20 GB)
https://bugs.kde.org/show_bug.cgi?id=456983 Carl Schwan changed: What|Removed |Added Latest Commit|https://invent.kde.org/pim/ |https://invent.kde.org/pim/ |akonadi/-/commit/897d583942 |akonadi/-/commit/d1738fa348 |e7acb2bce5b65b56a6c0c19260d |e79bc4abf781f0512ef256460d7 |6f9 |8b2 --- Comment #14 from Carl Schwan --- Git commit d1738fa348e79bc4abf781f0512ef256460d78b2 by Carl Schwan. Committed on 19/10/2023 at 17:09. Pushed by carlschwan into branch 'master'. Only keep mysql log from the last session Previously mysql.err.old would grow infinively and reaching multiple dozens of gigabit in some cases. With this change we keep the log from the current session in mysql.err and from the previous session in mysql.err.old only. M +1-1src/server/storage/dbconfigmysql.cpp https://invent.kde.org/pim/akonadi/-/commit/d1738fa348e79bc4abf781f0512ef256460d78b2 -- You are receiving this mail because: You are the assignee for the bug.
[Akonadi] [Bug 456983] mysql.err.old grows too large (over 20 GB)
https://bugs.kde.org/show_bug.cgi?id=456983 Carl Schwan changed: What|Removed |Added Latest Commit|https://invent.kde.org/pim/ |https://invent.kde.org/pim/ |akonadi/-/commit/9cda58ef90 |akonadi/-/commit/897d583942 |45b567c54feea774f73d045949e |e7acb2bce5b65b56a6c0c19260d |6c8 |6f9 Status|ASSIGNED|RESOLVED Resolution|--- |FIXED --- Comment #13 from Carl Schwan --- Git commit 897d583942e7acb2bce5b65b56a6c0c19260d6f9 by Carl Schwan. Committed on 19/10/2023 at 17:10. Pushed by carlschwan into branch 'release/23.08'. Only keep mysql log from the last session Previously mysql.err.old would grow infinively and reaching multiple dozens of gigabit in some cases. With this change we keep the log from the current session in mysql.err and from the previous session in mysql.err.old only. (cherry picked from commit d1738fa348e79bc4abf781f0512ef256460d78b2) M +1-1src/server/storage/dbconfigmysql.cpp https://invent.kde.org/pim/akonadi/-/commit/897d583942e7acb2bce5b65b56a6c0c19260d6f9 -- You are receiving this mail because: You are the assignee for the bug.
[Akonadi] [Bug 456983] mysql.err.old grows too large (over 20 GB)
https://bugs.kde.org/show_bug.cgi?id=456983 Bug Janitor Service changed: What|Removed |Added Resolution|FIXED |--- Status|NEEDSINFO |ASSIGNED --- Comment #12 from Bug Janitor Service --- A possibly relevant merge request was started @ https://invent.kde.org/pim/akonadi/-/merge_requests/146 -- You are receiving this mail because: You are the assignee for the bug.
[Akonadi] [Bug 456983] mysql.err.old grows too large (over 20 GB)
https://bugs.kde.org/show_bug.cgi?id=456983 --- Comment #11 from Sebastian Turzański --- (In reply to ratijas from comment #10) > One obvious solution to this bug would be to configure MySQL for log > rotation and other file size limits. It's not reasonable to allow it to grow > in Gigabytes. I completely agree, there should be a default low limit like 100MB but i guess this for a dedicated MYSQL instance that handles akonadi db so the config should be somehow in akonadi. Don't know the design so I'm guessing it's not for user to mess with it. -- You are receiving this mail because: You are the assignee for the bug.
[Akonadi] [Bug 456983] mysql.err.old grows too large (over 20 GB)
https://bugs.kde.org/show_bug.cgi?id=456983 Sebastian Turzański changed: What|Removed |Added Status|REOPENED|NEEDSINFO Resolution|--- |FIXED --- Comment #9 from Sebastian Turzański --- I had to delete the file and so far (since yesterday) it remains small (kiloBytes) I will keep en eye on it next time, I suggest to mark the bug as needsInfo. -- You are receiving this mail because: You are the assignee for the bug.
[Akonadi] [Bug 456983] mysql.err.old grows too large (over 20 GB)
https://bugs.kde.org/show_bug.cgi?id=456983 --- Comment #8 from Carl Schwan --- (In reply to Sebastian Turzański from comment #7) > please reopen > this is still the case with current > > Linux/KDE Plasma: 5.27.8 > (available in About System) > KDE Plasma Version: 5.27.8 > KDE Frameworks Version: 5.110.0 > Qt Version: 5.15.10 > > mysql error log grew to 90GB ! Do you see some lines inside the log which repeats very often? -- You are receiving this mail because: You are the assignee for the bug.
[Akonadi] [Bug 456983] mysql.err.old grows too large (over 20 GB)
https://bugs.kde.org/show_bug.cgi?id=456983 Sebastian Turzański changed: What|Removed |Added CC||dpba...@wp.pl Status|RESOLVED|REOPENED Resolution|FIXED |--- Ever confirmed|0 |1 --- Comment #7 from Sebastian Turzański --- please reopen this is still the case with current Linux/KDE Plasma: 5.27.8 (available in About System) KDE Plasma Version: 5.27.8 KDE Frameworks Version: 5.110.0 Qt Version: 5.15.10 mysql error log grew to 90GB ! -- You are receiving this mail because: You are the assignee for the bug.
[Akonadi] [Bug 456983] mysql.err.old grows too large (over 20 GB)
https://bugs.kde.org/show_bug.cgi?id=456983 Carl Schwan changed: What|Removed |Added Version Fixed In||23.04.0 Status|REPORTED|RESOLVED Latest Commit||https://invent.kde.org/pim/ ||akonadi/-/commit/9cda58ef90 ||45b567c54feea774f73d045949e ||6c8 Resolution|--- |FIXED CC||c...@carlschwan.eu --- Comment #6 from Carl Schwan --- The '> 2022-10-11 23:42:45 181 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'histogram' at position 10 to have type longblob, found type varbinary(255).' issue was fixed with https://invent.kde.org/pim/akonadi/-/commit/9cda58ef9045b567c54feea774f73d045949e6c8 -- You are receiving this mail because: You are the assignee for the bug.
[Akonadi] [Bug 456983] mysql.err.old grows too large (over 20 GB)
https://bugs.kde.org/show_bug.cgi?id=456983 michele mazza changed: What|Removed |Added CC||michele.ma...@gmail.com -- You are receiving this mail because: You are the assignee for the bug.
[Akonadi] [Bug 456983] mysql.err.old grows too large (over 20 GB)
https://bugs.kde.org/show_bug.cgi?id=456983 Iyán Méndez Veiga changed: What|Removed |Added See Also||https://bugs.kde.org/show_b ||ug.cgi?id=460172 -- You are receiving this mail because: You are the assignee for the bug.
[Akonadi] [Bug 456983] mysql.err.old grows too large (over 20 GB)
https://bugs.kde.org/show_bug.cgi?id=456983 --- Comment #5 from Iyán Méndez Veiga --- I changed the driver to QPSQL. Will see if it gets better than using MariaDB. -- You are receiving this mail because: You are the assignee for the bug.
[Akonadi] [Bug 456983] mysql.err.old grows too large (over 20 GB)
https://bugs.kde.org/show_bug.cgi?id=456983 --- Comment #4 from Iyán Méndez Veiga --- I was about to report a new bug about this. I was running out of space, didn't know why, and I checked my disk with du (forgot about Filelight :S), and I saw a .local/share/akonadi/db_data/mysql.err.old of 81 GiB and and a growing .local/share/akonadi/db_data/mysql.err of already 1.5 GiB. -- You are receiving this mail because: You are the assignee for the bug.
[Akonadi] [Bug 456983] mysql.err.old grows too large (over 20 GB)
https://bugs.kde.org/show_bug.cgi?id=456983 Iyán Méndez Veiga changed: What|Removed |Added CC||m...@iyanmv.com -- You are receiving this mail because: You are the assignee for the bug.
[Akonadi] [Bug 456983] mysql.err.old grows too large (over 20 GB)
https://bugs.kde.org/show_bug.cgi?id=456983
Knut Hildebrandt changed:
What|Removed |Added
CC||knut.hildebra...@gmx.de
--- Comment #3 from Knut Hildebrandt ---
Same here and that already for an while and long before the right now installed
Akonadi version came out.
Akonadi: 22.08.1-2
mariadb: 10.9.3-1
Operating System: Manjaro Linux
KDE Plasma Version: 5.25.5
KDE Frameworks Version: 5.98.0
Qt Version: 5.15.6
Kernel Version: 5.10.148-1-MANJARO (64-bit)
Graphics Platform: X11
BTW, I've got thousands of error messages like the ones I paste here including
the messages generated by the shutdown of Akonadi:
...
2022-10-24 20:07:45 67 [ERROR] Incorrect definition of table
mysql.column_stats: expected column 'hist_type' at position 9 to have type
enum('SINGLE_PREC_HB','DOUBLE_PREC_HB','JSON_HB'), found type
enum('SINGLE_PREC_HB','DOUBLE_PREC_HB').
2022-10-24 20:07:45 67 [ERROR] Incorrect definition of table
mysql.column_stats: expected column 'histogram' at position 10 to have type
longblob, found type varbinary(255).
2022-10-24 20:07:45 67 [ERROR] Incorrect definition of table
mysql.column_stats: expected column 'hist_type' at position 9 to have type
enum('SINGLE_PREC_HB','DOUBLE_PREC_HB','JSON_HB'), found type
enum('SINGLE_PREC_HB','DOUBLE_PREC_HB').
2022-10-24 20:07:45 67 [ERROR] Incorrect definition of table
mysql.column_stats: expected column 'histogram' at position 10 to have type
longblob, found type varbinary(255).
2022-10-24 20:07:45 67 [ERROR] Incorrect definition of table
mysql.column_stats: expected column 'hist_type' at position 9 to have type
enum('SINGLE_PREC_HB','DOUBLE_PREC_HB','JSON_HB'), found type
enum('SINGLE_PREC_HB','DOUBLE_PREC_HB').
2022-10-24 20:07:45 67 [ERROR] Incorrect definition of table
mysql.column_stats: expected column 'histogram' at position 10 to have type
longblob, found type varbinary(255).
2022-10-24 20:07:51 0 [Note] /usr/bin/mysqld (initiated by: unknown): Normal
shutdown
2022-10-24 20:07:51 0 [Note] InnoDB: FTS optimize thread exiting.
2022-10-24 20:07:51 0 [Note] InnoDB: Starting shutdown...
2022-10-24 20:07:51 0 [Note] InnoDB: Dumping buffer pool(s) to
/home/knut/.local/share/akonadi/db_data/ib_buffer_pool
2022-10-24 20:07:51 0 [Note] InnoDB: Restricted to 2016 pages due to
innodb_buf_pool_dump_pct=25
2022-10-24 20:07:51 0 [Note] InnoDB: Buffer pool(s) dump completed at 221024
20:07:51
2022-10-24 20:07:51 0 [Note] InnoDB: Removed temporary tablespace data file:
"./ibtmp1"
2022-10-24 20:07:51 0 [Note] InnoDB: Shutdown completed; log sequence number
25265153099; transaction id 170786390
2022-10-24 20:07:51 0 [Note] /usr/bin/mysqld: Shutdown complete
At startup there are a couple of warnings before the error messages start
again:
2022-10-24 20:27:12 0 [Warning] option 'innodb-log-buffer-size': unsigned value
1048576 adjusted to 2097152
2022-10-24 20:27:12 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2022-10-24 20:27:12 0 [Note] InnoDB: Number of transaction pools: 1
2022-10-24 20:27:12 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-10-24 20:27:12 0 [Note] InnoDB: Using Linux native AIO
2022-10-24 20:27:12 0 [Note] InnoDB: Initializing buffer pool, total size =
128.000MiB, chunk size = 2.000MiB
2022-10-24 20:27:12 0 [Note] InnoDB: Completed initialization of buffer pool
2022-10-24 20:27:12 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
2022-10-24 20:27:12 0 [Note] InnoDB: 128 rollback segments are active.
2022-10-24 20:27:12 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB.
Physically writing the file full; Please wait ...
2022-10-24 20:27:12 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2022-10-24 20:27:12 0 [Note] InnoDB: log sequence number 25265153099;
transaction id 170786391
2022-10-24 20:27:12 0 [Note] InnoDB: Loading buffer pool(s) from
/home/knut/.local/share/akonadi/db_data/ib_buffer_pool
2022-10-24 20:27:12 1 [Warning] InnoDB: Table mysql.innodb_table_stats has
length mismatch in the column name table_name. Please run mariadb-upgrade
2022-10-24 20:27:12 1 [Warning] InnoDB: Table mysql.innodb_index_stats has
length mismatch in the column name table_name. Please run mariadb-upgrade
2022-10-24 20:27:12 0 [Note] /usr/bin/mysqld: ready for connections.
Version: '10.9.3-MariaDB' socket: '/run/user/1000/akonadi/mysql.socket' port:
0 Arch Linux
2022-10-24 20:27:12 0 [Note] InnoDB: Buffer pool(s) load completed at 221024
20:27:12
2022-10-24 20:27:12 4 [Warning] InnoDB: Table mysql.innodb_table_stats has
length mismatch in the column name table_name. Please run mariadb-upgrade
2022-10-24 20:27:12 4 [Warning] InnoDB: Table mysql.innodb_index_stats has
length mismatch in the column name table_name. Please run mariadb-upgrade
2022-10-24 20:27:12 4 [Warning] InnoDB: Table mysql.innodb_table_stats has
length mismatch in the column name table_name. Please run
[Akonadi] [Bug 456983] mysql.err.old grows too large (over 20 GB)
https://bugs.kde.org/show_bug.cgi?id=456983 desaparecido changed: What|Removed |Added CC||luis.davila...@gmail.com -- You are receiving this mail because: You are the assignee for the bug.
