Cloudron Forum

After recent updates I am unable to generate share links anymore with the files I upload.

t 29 17:27:58 cubby:routes:shares createShare: /other uploads/pictures/_DSC2635.JPG receiver:link +876ms
Oct 29 17:27:58 cubby:shares create: uid-e20b0e31-8bb7-4c2a-a579-4860069b7733 /other uploads/pictures/_DSC2635.JPG receiver:link readonly:true expiresAt:none +876ms
Oct 29 17:27:58 {
Oct 29 17:27:58 path: '/api/v1/shares',
Oct 29 17:27:58 status: 500,
Oct 29 17:27:58 error: HttpError: NOT NULL constraint failed: shares.created_at
Oct 29 17:27:58 at MainError.toHttpError (file:///app/code/backend/mainerror.js:75:16)
Oct 29 17:27:58 at createShare (file:///app/code/backend/routes/shares.js:165:38)
Oct 29 17:27:58     at process.processTicksAndRejections (node:internal/process/task_queues:104:5) {
Oct 29 17:27:58 status: 500,
Oct 29 17:27:58 internalError: MainError: NOT NULL constraint failed: shares.created_at
Oct 29 17:27:58 at Object.query (file:///app/code/backend/database.js:74:15)
Oct 29 17:27:58 at Object.create (file:///app/code/backend/shares.js:146:20)
Oct 29 17:27:58 at createShare (file:///app/code/backend/routes/shares.js:164:48)
Oct 29 17:27:58     at process.processTicksAndRejections (node:internal/process/task_queues:104:5) {
Oct 29 17:27:58 reason: 'Database Error',
Oct 29 17:27:58 details: { code: 'SQLITE_CONSTRAINT_NOTNULL' },
Oct 29 17:27:58 nestedError: SqliteError: NOT NULL constraint failed: shares.created_at
Oct 29 17:27:58 at execute (file:///app/code/backend/database.js:41:30)
Oct 29 17:27:58 at Object.query (file:///app/code/backend/database.js:72:16)
Oct 29 17:27:58 at Object.create (file:///app/code/backend/shares.js:146:20)
Oct 29 17:27:58 at createShare (file:///app/code/backend/routes/shares.js:164:48)
Oct 29 17:27:58     at process.processTicksAndRejections (node:internal/process/task_queues:104:5) {
Oct 29 17:27:58 code: 'SQLITE_CONSTRAINT_NOTNULL'
Oct 29 17:27:58 }

I've been trying to use streaming within N8N on a ai agent chat node. I've enabled the streaming options on both the chat and ai agent, but it only ever seems to use the method of sending the full completion when the process finishes.

The logs only seems to point out the following message when I use it, but I don't think it's related.
Sep 30 07:41:49 Custom data value over 512 characters long. Truncating to 512 characters.
Sep 30 08:02:51 Custom data value over 512 characters long. Truncating to 512 characters.

Is there something more I need to do here to get streaming within the chat node since this is running in cloudron?

@girish I'll send in a ticket through the cloudron dashboard.

@girish thanks for the heads up. I disabled auto updates for now. As far as my dns goes, no I don't have anything special just normal a records.
This particular setup has two domains on it, but I would think that wouldn't be a factor.
As far as my Ubuntu version it's on 22.04.2.

@girish ahh, I'm on 7.4.3, is 7.5 required? And yes I can access the cloudron management.

I get the white page while it attempts something, and then I get hit with the page
status "Internal Server Error"
message "Issuer.discover() failed.\n RequestError: connect ECONNREFUSED x.x.x.x:443\n RequestError: connect ECONNREFUSED x.x.x.x:443"

@ccfu oooh ok. The list won't become active until it hits a real box. Ok, that makes a lot more sense now. I appreciate it.

@ccfu Ok, I've just trying to be proactive but if it's not such a bad thing currently then that is fine with me. I run one for a relative and I don't want them to freak out about spam emails if it happens to come in. haha

Ideally I would just block everything out of country since nothing will be applicable for the email I am in charge of. Don't know if that is possible or not.

Hi

I've been seeing these coming in for a while now, and I have put in rules to block these from coming in, but I think my wildcards are not working. Is there a better way to do this?
file:///home/pfs/Pictures/Screenshot%20from%202023-05-30%2011-19-17.png

@robi You are correct, poweredge r720xd

@robi I'm not hosting it in the cloud. Sorry I should have made that clear.

@robi Cloudron and all the apps run on a R720XD

@girish ok, it must really be using that much then. Seems pretty crazy, but I will check with Jellfin devs regarding this.

@girish as requested

{"BlockIO":"171GB / 83.4GB","CPUPerc":"0.14%","Container":"2058a37598b0","ID":"2058a37598b013a36a5a3d05a362e96dc4ad212dec1d5db162e372979bc47c38","MemPerc":"84.77%","MemUsage":"24.68GiB / 29.12GiB","Name":"7d771f27-4c9e-48ff-b0ff-3c742305adb3","NetIO":"1.27GB / 410GB","PIDs":"57"}

@girish Here you are

CONTAINER ID NAME CPU % MEM USAGE / LIMIT MEM % NET I/O BLOCK I/O PIDS
2058a37598b0 7d771f27-4c9e-48ff-b0ff-3c742305adb3 2.28% 27.12GiB / 29.12GiB 93.14% 1.01GB / 263GB 132GB / 65.5GB 56

@girish It looks like there might be a miss representation on the graphs?

My performance appears to be ok for moment on it. so my correlation might be off in terms of my issue, but I think here it might be not picking up the correct ram usages. What do you think?

@jdaviescoates Jellyfin has cron jobs to remove transcoded cache or recently activity that is no longer used. I don't believe it has to do with the media, but I feel it will be hard to locate the problem.

@girish When it gets back up I will check this

@nebulon This would be Jellyfin specifically.

A week or so will go by and my ram usage will increase to this large amount, and it doesn't seem to help the app as it starts to hang, or not be very responsive.

Restarts of the app corrects the usage.