Page 1 of 1

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

Posted: Sat 25. Jan 2025, 23:45
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.

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

Posted: Sun 26. Jan 2025, 09:07
by Tobi
Probably you ran out of Webspace.

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

Posted: Sun 26. Jan 2025, 15:32
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

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

Posted: Mon 27. Jan 2025, 09:59
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.