Cloudron Forum

Would love to have Grist on Cloudron, thank's for trying @walski

imo this app is great for when not wanting the full resource hog that is the Mastodon package. @girish / @nebulon, are you interested in packaging?

@murgero It's not clear to me how to do that. I tried

ALTER DATABASE mydb CONNECTION LIMIT 0;
and

SELECT pg_terminate_backend(pid)
FROM pg_stat_activity
WHERE datname = 'mydb';

but I only managed to lock myself out before being able to
DROP DATABASE mydb;

How should I drop the database? No matter what I try I get

ERROR: cannot drop the currently open database`

So I can enter a terminal in the GTS container, access and drop its db from there?

Yes plz

Though it’s a little sad that there’s a kanban app, a wiki app, a tables app etc but no way to use these as views of the same data.

@girish Setting

[indexer]
ISSUE_INDEXER_TYPE=db

in app.ini solved the issue immediately. Thanks alot!

Now I'm curious to know what db means in this context (but the urgency is gone ). Should the Cloudron package have db as ISSUE_INDEXER_TYPE out of the box, for example?

Some Cloudron app config data got alot of legacy files from earlier versions, so sometimes it's hard to know what the true good defaults are.

@jdaviescoates Not yet, unfortunately.

Discourse 3.0 was released a week ago. Awaiting the greatness coming to Cloudron.

@nj Thanks for packaging ERPNext. Its potential is vast.

Trying out different features of it I notice that there seem to be several modules missing when compared to the ERPNext docs.

For example Automation is missing. (Though I can reach and use event producers by searching for it, or reaching /app/event-producer directly)

Perhaps that's all in order if your app is packing the core app only?

@girish Must've got it wrong somehow. Anyway, --debug only adds one line of little insight:

sudo -u git /home/git/gitea/gitea -c /run/gitea/app.ini manager flush-queues --debug
2023/01/16 09:45:29 ...dules/git/command.go:213:Run() [D] /usr/bin/git version
flush timeout with non-empty queues: issue_indexer

@fbartels I have skimmed the logs but I haven't seen any abnormalities (though logs are quite verbose). I don't know what a stacktrace is.

@girish said in Issue indexer queue not getting processed, 8000+ unfinished jobs:

--debug

With what command? At least not gitea manager flush-queues.

The queue has still not being processed, but 13000 flush workes (and probably counting) have seemingly been added.

I’d really appreciate some help before this instance blows up

I went ahead and tried to flush the queue:

sudo -u git /home/git/gitea/gitea -c /run/gitea/app.ini  manager flush-queues --timeout 20m

but even with that generous timeout value it timed out:

flush timeout with non-empty queues: issue_indexer

I've little to no idea of what I'm doing here btw.

This instance is a couple of years old, so it's been through some updates, and one server migration.

I tried deleting /app/data/appdata/indexers in order to try and rebuild the indexing but since found that workers do not process that queue anyway. The issue indexer work queue is building up without getting worked on. Adding workers manually doesn’t help.

I found a note for a recommendation from the 1.15 release, stating:

It is recommended to ensure that queues are empty before upgrading using gitea manager flush-queues or on the admin pages.

Should I do that?

First Forgejo release is out.

@murgero So if I drop the table it just gets recreated?

I was also considering trying install to domain.tld, then move it to a subdomain.

I did remove the mediaLinks line in the manifest file and it all worked. Now my issue is that I can't configure account-domain before the app boots up, making it seemingly impossible to change:

# DO NOT change this after your server has already run once, or you will break things!

Any advice?

Great job so far

@murgero Hey, I'm getting

App installation error: Invalid CloudronManifest.json: Format validation failed (Invalid URL) @ /mediaLinks/0

when running cloudron install --image=mitchellurgero/org.urgero.gts:latest.

@murgero That is awesome! You think it's ready for app store soon?