Too many logs are written on Windows (LOG: could not reserveshared memory region (addr=%p) for child %p:)

Поиск
Список
Период
Сортировка
От Takahashi, Ryohei
Тема Too many logs are written on Windows (LOG: could not reserveshared memory region (addr=%p) for child %p:)
Дата
Msg-id EE586BE92A4AFB45B03310C2A0C0565D6D0FE960@G01JPEXMBKW03
обсуждение исходный текст
Ответы Re: Too many logs are written on Windows (LOG: could not reserveshared memory region (addr=%p) for child %p:)  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Hi,


My customer uses PostgreSQL on Windows and hits the problem that following log is written to the server logs too
frequently(250 thousand times per day).
 
"LOG:  could not reserve shared memory region (addr=%p) for child %p:"

This log is written when pgwin32_ReserveSharedMemoryRegion() in win32_shmem.c fails. If fails, internal_forkexec() in
postmaster.cretries up to 100 times. In most of my customer cases, internal_forkexec() finally succeeded to
pgwin32_ReserveSharedMemoryRegion()by retrying.
 

According to the comment of internal_forkexec(), pgwin32_ReserveSharedMemoryRegion() sometimes fails if ASLR is active.
Ifso, I think administrators are not interested in this log since it is a normal event. 
 

I think the log level should not be "LOG", but should be lower level such as "DEBUG1".


Regards,
Ryohei Takahashi




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

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: New function pg_stat_statements_reset_query() to reset statisticsof a specific query
Следующее
От: Amit Langote
Дата:
Сообщение: Re: typo fix