Replies: 3 comments 5 replies
-
It is a column type of bytea in postgres so effectively around a 1G limit. That is the largest column type for postgres. Who/why are you getting documents of that size? It seems like the wrong protocol (HL7) and tool (mirth with any database since it is typically considered bad practice to store large blobs in DBs) to deliver large content items. Curious. You would typically transfer and store the data via blob services like AWS S3. you might get an HL7 message with a pointer to the location of the large file to download or retrieve via whatever mechanism the blob storage supports. |
Beta Was this translation helpful? Give feedback.
-
Still having the problem because mySQL is no option for the customer. I tried another thing but it doesn't work. I'm using this test code in the preprocessor of my channel to filter big files: `logger.error('TEST BEGIN'); const b = message.length * 2; logger.error(kb); if(kb > 1000000) The channel runs in production mode. I'm getting this error: As far as I know the message will be stored AFTER the preprocessor in production mode. There is no log entry. I think the error is thrown before the preprocessor gets called. Here is the full error: Any ideas? |
Beta Was this translation helpful? Give feedback.
-
I forgot to say one thing. The channel has a TCP Listener as source, not a file reader! The hl7 mdm message has an embedded pdf and the source system has no chance to check whether the file ist to big or not. |
Beta Was this translation helpful? Give feedback.
-
Hi together,
we're using PostgreSQL 15 for all of our mirth servers. We ran into the problem that it is not possible to send MDM messages that are bigger than 1 GB to the mirth server (TCP, MLLP, document is base64 encoded, embedded). We're using the attachment handler (regex). As far as I know the maxiumum filed size of postgres is 1GB so that is possible that this may be the problem. MySQL can have 4GB columns (LONGTEXT or LONGBLOB).
Does anyone else has this problem? Is it better to use MySQL or an other database to handle this problem?
Kind regards
Beta Was this translation helpful? Give feedback.
All reactions