Last post 5 hours 11 min ago

Posts last week 141

Average response time last week 4 hours 42 min

All time posts 67824

All time tickets 10480

All time avg. posts per day 21

Helpdesk is open from Monday through Friday CET

Please create an (free) account to post any question in the support area.

Please check the development versions area. Look at the changelog, maybe your specific problem has been resolved already!

All tickets are private and they cannot be viewed by anyone. We have made public only a few tickets that we found helpful, after removing private information from them.

#8347 – The table 'kiss_forseo_errors' is full

Posted in ‘4SEO’

This is a public ticket. Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Tuesday, 30 November 2021 11:47 UTC

ulysses

Seems data went full and gave the indication that it might be somethign within this component..

Working on fixing it,but wanted to ask if you have had this error develop recently and new of a way to repair.

As it appear our database is full

bitnami@bitnami-joomla-f733:~$ df -h

Filesystem Size Used Avail Use% Mounted on

udev 2.7G 0 2.7G 0% /dev
tmpfs 547M 57M 491M 11% /run
/dev/sda1 50G 48G 0 100% /
tmpfs 2.7G 0 2.7G 0% /dev/shm
tmpfs 5.0M 0 5.0M 0% /run/lock
tmpfs 2.7G 0 2.7G 0% /sys/fs/cgroup

I have added;

$ binlog_expire_logs_seconds=86400

Already had this one in my my.cnf file
$ expire_logs_days=7

Tuesday, 30 November 2021 11:51 UTC

wb_weeblr

Working on fixing it,but wanted to ask if you have had this error develop recently and new of a way to repair.

As it appear our database is full

I have never seen this since I started developping Joomla extensions in 2007. It's extremely rare these days that hosting company actually limit the size of database, especially to such a small number, less than 500MB.

However, I don't thing it's not your database that's full, it's your entire hosting disk space:

/dev/sda1 50G 48G 0 100% /

so it's not so much about cleaning the database (500 MB) than finding what's taking many GB on the disk (many photos, old backups, many sites?)

Another question is: why do you have so many errors recorded. Did you enabled Collect external 404 errors in 4SEO settings?

Best regards

Yannick Gaultier

weeblr.com / @weeblr

Tuesday, 30 November 2021 12:33 UTC

ulysses

Went in a deleted a bunch of things in order to get me into the backend of the website again.
Removed cache saved in JCH optimize (7G).

Brought the server down to:
/dev/sda1 50G 38G 9.9G 80% /

Another question is: why do you have so many errors recorded. Did you enabled Collect external 404 errors in 4SEO settings?

I do not have collect external 404 errors enabled.

And not sure why so many errors are being recorded.

Do you know how I can set this to avoid the server doing the same thing again?

Tuesday, 30 November 2021 12:41 UTC

ulysses

I did notice quite a few mysqld.log files being saved..
Perhaps, I need to adjust something within my.cnf or php.ini files?

Would you mind taking a look at it and let me know if you see something that is missing or needs adjusting, please?

Also, I have read its not safe to delete these current mysql.log.gz files, is this correct?

How can I remove them; as I believe this has something to do with my space allocation..

- not quite sure..

Tuesday, 30 November 2021 12:43 UTC

ulysses

had an issue attaching php.txt file..

Trying again on this next reply..

Tuesday, 30 November 2021 12:44 UTC

ulysses

php file didn't get attached for security purposes..

So just included a shared google link..

https://drive.google.com/file/xxxx

hope this helps..

Tuesday, 30 November 2021 13:24 UTC

wb_weeblr

Do you know how I can set this to avoid the server doing the same thing again?

I don't see anything related to 4SEO in what you listed above, so I would say no.

I did notice quite a few mysqld.log files being saved..

Perhaps, I need to adjust something within my.cnf or php.ini files?

That would be something on your server, I really can't advise on that.

Would you mind taking a look at it and let me know if you see something that is missing or needs adjusting, please?

Also, I have read its not safe to delete these current mysql.log.gz files, is this correct?

How can I remove them; as I believe this has something to do with my space allocation..

I definitely cannot give you advice on setting up your server, only on how to use 4SEO. The only thing I can see on your screen shot is that the logs files are extremely small, a few bytes, so if JCH is taking up 7GB, you probably don't care about log files which are a few bytes only.

had an issue attaching php.txt file..

Absolutely, these files are not allowed to be uploaded here, depending on their mime/type. But again, I can't give advice on how to setup your server.

Best regards

Yannick Gaultier

weeblr.com / @weeblr

Friday, 31 December 2021 05:34 UTC

system

This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.

This ticket is closed, therefore read-only. You can no longer reply to it. If you need to provide more information, please open a new ticket and mention this ticket's number.