MySQL - Query Error: The table 'event_logs' is full

General discussions around KeyHelp.
Post Reply
picaditto
Posts: 8
Joined: Tue 14. Jan 2025, 00:24

MySQL - Query Error: The table 'event_logs' is full

Post by picaditto »

Hello to all,

When i try to login i get these error "MySQL - Query Error: The table 'event_logs' is full"
Try to restart and now no user UI

Any help please.
User avatar
Tobi
Community Moderator
Posts: 3230
Joined: Thu 5. Jan 2017, 13:24

Re: MySQL - Query Error: The table 'event_logs' is full

Post by Tobi »

Probably you ran out of Webspace.
Gruß,
Tobi


-----------------------------
wewoco.de
Das Forum für Reseller, Digital-Agenturen, Bildschirmarbeiter und Mäuseschubser
picaditto
Posts: 8
Joined: Tue 14. Jan 2025, 00:24

Re: MySQL - Query Error: The table 'event_logs' is full

Post by picaditto »

Thanks for the reply, i dont think is that.


root@hera ~ # df -h
Filesystem Size Used Avail Use% Mounted on
tmpfs 6.3G 2.8M 6.3G 1% /run
/dev/md2 906G 11G 849G 2% /
tmpfs 32G 64K 32G 1% /dev/shm
tmpfs 5.0M 0 5.0M 0% /run/lock
/dev/md1 989M 186M 753M 20% /boot
tmpfs 6.3G 12K 6.3G 1% /run/user/0
User avatar
Alexander
Keyweb AG
Posts: 4448
Joined: Wed 20. Jan 2016, 02:23

Re: MySQL - Query Error: The table 'event_logs' is full

Post by Alexander »

Hello,

more information about your database setup are needed.

Have you changed anything regarding your database setup, changed config values etc.?
How many records does the event_log table have?
Have you turned on "KeyHelp Admin area -> System status -> Event logs -> Options -> Do not delete records" (in general, what are your settings configurated there)?
Check your innoDB table limits (https://dev.mysql.com/doc/refman/8.4/en ... limit.html)
Are there any related errors here /var/log/keyhelp/php-error.log?

You can truncate the `keyhelp`.`event_logs` table without problems, this way you can likely access KeyHelp again.
Mit freundlichen Grüßen / Best regards
Alexander Mahr

**************************************************************
Keyweb AG - Die Hosting Marke
Neuwerkstr. 45/46, 99084 Erfurt / Germany
http://www.keyweb.de - http://www.keyhelp.de
**************************************************************
Post Reply