From: | <paul(dot)malm(at)lfv(dot)se> |
---|---|
To: | <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Memory alloc exception |
Date: | 2021-06-15 11:09:12 |
Message-ID: | 1d5fe4184f914a86aabca8ede3cbcc38@lfv.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi list,
I get this error when running a SQL statement in my Java application.
ERROR: Invalid memory alloc request size 1683636507
Location: File: d:\pginstaller.auto\postgres.windows-x64\src\backend\utils\mmgr\mcxt.c, Routine: MemoryContextAlloc, Line: 779
Server SQLState: XX000
I think it has something with to do with PostgreSQL
This is how I had my postgrsql.conf:
shared_buffers = 128MB
#huge_pages = try
#temp_buffers = 8MB
#max_prepared_transactions = 0
#work_mem = 6MB
work_mem = 64MB
#maintenance_work_mem = 64MB
maintenance_work_mem = 64MB
Then I changed to this postgrsql.conf:
shared_buffers = 4096MB
#huge_pages = try
#temp_buffers = 8MB
#max_prepared_transactions = 0
#work_mem = 6MB
work_mem = 256MB
#maintenance_work_mem = 64MB
maintenance_work_mem = 256MB
And got this error instead:
Org.postgresql.util.PSQLException: AnI/O error occurred while sending to the backend.
Any ideas?
Kind regards,
Paul
From | Date | Subject | |
---|---|---|---|
Next Message | Ron | 2021-06-15 11:23:27 | Re: Memory alloc exception |
Previous Message | Ron | 2021-06-15 11:07:57 | Re: Losing data because of problematic configuration? |