• Home
  • Get help
  • Ask a question
Last post 39 min ago
Posts last week 81
Average response time last week 44 min
All time posts 70355
All time tickets 10859
All time avg. posts per day 20
Collected over 9 years 7 months 15 days and updated each hour automatically. Last updated 2024-11-22 03:18 UTC

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

 

 

 
Edited by on Friday, 31 December 2021 05:36 UTC
Tuesday, 30 November 2021 11:51 UTC
wb_weeblr

Hi

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?

 

 

 

 

 
Edited by on Friday, 31 December 2021 05:36 UTC
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..

 
Edited by on Friday, 31 December 2021 05:36 UTC
Tuesday, 30 November 2021 12:43 UTC
ulysses

had an issue attaching php.txt file..

Trying again on this next reply..

 
Edited by on Friday, 31 December 2021 05:36 UTC
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/[redacted]

hope this helps..

 

 
Edited by wb_cati on Tuesday, 04 January 2022 09:45 UTC
Tuesday, 30 November 2021 13:24 UTC
wb_weeblr

Hi

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.
Edited by on Friday, 31 December 2021 05:34 UTC
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.