hubzilla server failure

Sat, 13 Jan 2024 19:49:49 +0100

adminsforum@hubzilla.org

od wrote the following post Sat, 13 Jan 2024 19:49:03 +0100

hubzilla server failure

Personal hubzilla server has failed: " Apologies but this site is unavailable at the moment. Please try again later. "
Have restarted postgresql, apache; error continues.
Please any other actions to investigate?

show all 16 comments

Sat, 13 Jan 2024 22:22:08 +0100

Marshall Sutherland

dwatney@hub.farthinghalearms.com

check the logs for clues

Sun, 14 Jan 2024 13:11:46 +0100

od@zotum.net

Thanks. Changed line:
'...transport_security_header...' to 0, because modules 'activitypub' were installed.
Postgresql and apache2 were already in operation; this line changed allowed hubzilla to start.
Next problem (!) is that content is not being collated from 'connections'. Even this forum. From the 'stream filter' option, the 'hubzilla support forum' shows only content from 29 days ago. Only later posts (e.g. this post) become visible when the title hyperlink 'hubzilla support forum' is activated.
Stream from connections continues to be blank.

Mon, 15 Jan 2024 00:37:20 +0100

od@zotum.net

Server failed again...

Fri, 19 Jan 2024 20:09:40 +0100

od@zotum.net

Spin?
The virtual private server is full. Which parts of the postgresql database are responsible for use of disk space resource?
Which postgresq tables may be deleted via command terminal instruction?

Fri, 19 Jan 2024 20:41:35 +0100

Harald Eilertsen

harald@hub.volse.no

@od

Spin?

Sorry for the confusing word :) I mean, do you get the message immediately, or does it take a while (about half a minute) before you get it.

All of the database is stored on disk. The biggest tables are usually the item and config tables, at least if you don't store photos in the databse, in which case it will probably be bigger.

Not sure I would delete them though. The database is what stores pretty much all the content on your hub.

You may be able to reclaim some space by compacting the db, but not sure how well that works if the db is already full.

Do check the Maintenance section in the PostgreSQL manual. Especially the parts on vacuuming and reclaiming disk space.

And be sure to back up the database before doing anything risky!

The best option is probably to get more space for your hub.

Sat, 20 Jan 2024 20:58:22 +0100

od@zotum.net

Problem solved.
Used 'ls -trSs' which showed that hubzilla logs consumed 19gb!!!
Deleted.

Sat, 20 Jan 2024 21:45:36 +0100

Harald Eilertsen

harald@hub.volse.no

@od Ah, yunohost?

Sun, 21 Jan 2024 11:12:37 +0100

od@zotum.net

Nothing to do with vps provider. Hubzilla bug

Sun, 21 Jan 2024 11:20:46 +0100

Harald Eilertsen

harald@hub.volse.no

@od I agree it's not the vps provider, but when enabling logging it's normal to also add some log rotation so these things don't happen. For some reason the yunohost package for Hubzilla don't do that.

Don't know if that's how you've set it up, but in any case, I'd recommend to enable log rotation in your logging setup.

Sun, 21 Jan 2024 17:56:14 +0100

Scott M. Stolz

scott@loves.tech

Ideally, Hubzilla would warn you that the logs files are getting too large. But, it also would be ideal if Yunohost automatically set up log rotation. And some documentation that mentions setting up log rotation. There are a couple of things that could be done to prevent something like this from happening.

Sun, 21 Jan 2024 18:01:38 +0100

Harald Eilertsen

harald@hub.volse.no

@Scott M. Stolz

And some documentation that mentions setting up log rotation.

See /help/en/admin/administrator_guide#Troubleshooting

You have to scroll a bit down. This should probably be moved somewhere else than under the troubleshooting heading.

Sun, 21 Jan 2024 18:08:24 +0100

Scott M. Stolz

scott@loves.tech

@Harald Eilertsen

ee
#^https://authorship.studio/help/en/admin/administrator_guide#Troubleshooting

You have to scroll a bit down. This should probably be moved somewhere else than under the troubleshooting heading.

And we have to fix that bug where the URL redirects to the about page if there is the language indicator such as en in the URL. If you remove the /en from the URL, it works.

#^https://authorship.studio/help/admin/administrator_guide#Troubleshooting

Sun, 21 Jan 2024 18:17:16 +0100

Harald Eilertsen

harald@hub.volse.no

@Scott M. Stolz Yep, one of the things I want to have a look at. Bloody annoying when I'm trying to update the docs and want to to check how it looks.

Sat, 27 Apr 2024 19:49:54 +0200

od@zotum.net

@Marshall Sutherland
@Grouchy

Used 'ls -trSs' which showed that hubzilla logs consumed 19gb!!!

Is there a way to configure this server to delete this file automatically, for example when a certain file size is reached?

Sat, 27 Apr 2024 19:56:53 +0200

Marshall Sutherland

dwatney@hub.farthinghalearms.com

There is a logrot add-on which will let you specify how large files get before rotation and how many to retain.

Sun, 26 May 2024 12:36:35 +0200

od@zotum.net

@Marshall Sutherland
Have decided to try a 'cronjob' command to delete the file frequently. Will see soon if the task was written correctly! :)