Unable to increase upload size above 2GB Matrix

[luckow]

quick question: What is the purpose of uploading such large files?

[girish]

@Muhanand looks like a known problem . See https://github.com/element-hq/synapse/issues/12023

[Muhanand]

@luckow video files

[girish]

@Muhanand I think luckow means to ask why upload such large files to a chat , instead of say some filehosting program like say nextcloud

[Muhanand]

@girish family group chats
telegram used to allow 20gb now it's 2gb still not bad

[robi]

Might be best to link in chat to videos hosted on peertube or similar. Then transcoding can happen and other video optimizations based on device.

[Muhanand]

@girish said in Unable to increase upload size above 2GB Matrix:

@Muhanand looks like a known problem . See https://github.com/element-hq/synapse/issues/12023

seems to be the same, it didn't work in a e2e room, but started the upload in an unencrypted room, still failed but it started.
I setup a matrix server without cloudron a couple months ago and it didn't have this issue
don't know if this is from synapse or cloudron tbh

[girish]

@Muhanand per the bug report, it fails for encrypted and unencrypted rooms (in the description of the issue).

[Muhanand]

@girish Thank you, seems to be a bug with Synapse then

[Muhanand]

Found a solution in the old bug report, only issue is that it doesn't work in e2e rooms
here is the solution https://github.com/matrix-org/synapse/issues/12023#issuecomment-1044337550

That seemed to work because when uploading to an unencrypted room the upload does start, but when uploading in a e2e room it just failed (doesn't even start uploading) Does anyone have an idea on how we can make this work in e2e rooms as well?

btw for anyone trying to apply it do the following
1, go to the terminal. 2, click postgress then type psql and press enter.
3, paste in the following to change media_length from integer to bigint

ALTER TABLE local_media_repository
ALTER COLUMN media_length TYPE bigint;

you can use the following to check if the change was applied

SELECT data_type
FROM information_schema.columns
WHERE table_name = 'local_media_repository'
AND column_name = 'media_length';