[GENERAL] Out of memory error

Поиск
Список
Период
Сортировка
От Chris Roberts
Тема [GENERAL] Out of memory error
Дата
Msg-id YQBPR01MB0531E94B5BFBDBD1C0B35EF2D5840@YQBPR01MB0531.CANPRD01.PROD.OUTLOOK.COM
обсуждение исходный текст
Ответы Re: [GENERAL] Out of memory error
Список pgsql-general

Hello,

 

My deployment is Postgres 9.3.5 on a Windows machine.

 

Would someone tell me why I am seeing the following Postgres logs?

 

07:56:20 EST LOG:  00000: execute <unnamed>: SELECT * FROM "c3p0"

07:56:20 EST LOCATION:  exec_execute_message, src\backend\tcop\postgres.c:1906

07:56:20 EST LOG:  00000: execute <unnamed>: SELECT * FROM "c3p0"

07:56:20 EST LOCATION:  exec_execute_message, src\backend\tcop\postgres.c:1906

07:56:20 EST LOG:  00000: execute <unnamed>: SELECT * FROM "c3p0"

07:56:20 EST LOCATION:  exec_execute_message, src\backend\tcop\postgres.c:1906

07:56:20 EST LOG:  08P00: incomplete message from client

07:56:20 EST LOCATION:  pq_getmessage, src\backend\libpq\pqcomm.c:1143

07:56:20 EST ERROR:  54000: out of memory

07:56:20 EST DETAIL:  Cannot enlarge string buffer containing 0 bytes by 1157627900 more bytes.

07:56:20 EST LOCATION:  enlargeStringInfo, src\backend\lib\stringinfo.c:268

07:56:20 EST LOG:  00000: disconnection: session time: 0:01:59.960 user=xxxxxxx database=xxxxxx host=xxx.xxx.xxx.xxx port=57736

 

What is happening here? Is it of concern? Will tuning the DB memory parameters help avoid this?

 

Thanks,

Chris

В списке pgsql-general по дате отправления:

Предыдущее
От: Julien Rouhaud
Дата:
Сообщение: Re: How to config start/stop scripts in a different data dir for CentOS7/systemctl/PG9.6
Следующее
От: Metare Solve
Дата:
Сообщение: Looking for an online mentor