BUG #13858: Server with debugger installed consumes 100% of one CPU core

From: sergey-v(at)mail(dot)ru
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #13858: Server with debugger installed consumes 100% of one CPU core
Date: 2016-01-09 13:02:30
Message-ID: 20160109130230.4397.31006@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 13858
Logged by: Sergey
Email address: sergey-v(at)mail(dot)ru
PostgreSQL version: 9.5.0
Operating system: Windows 7 x64
Description:

It happened few times today - after some period and I'm not sure which
particular my actions, one of the postgres.exe process starts eating 100% of
one CPU core.

I've found only way to fix that - kill that process, because normal control
functions do not work (i.e. stopping server from pgAdmin).

Last time i've capture the call stack of the thread consuming the CPU (via
https://technet.microsoft.com/en-us/sysinternals/processexplorer):

ntoskrnl.exe!memset+0x61a
ntoskrnl.exe!KeWaitForMultipleObjects+0xd52
ntoskrnl.exe!KeWaitForMutexObject+0x19f
ntoskrnl.exe!_misaligned_access+0xba4
ntoskrnl.exe!_misaligned_access+0x1821
ntoskrnl.exe!KiCheckForKernelApcDelivery+0x25
ntoskrnl.exe!MmProbeAndLockPages+0xbc6
afd.sys+0x460f3
afd.sys+0x45963
ntoskrnl.exe!NtMapViewOfSection+0x15b7
ntoskrnl.exe!NtDeviceIoControlFile+0x56
ntoskrnl.exe!KeSynchronizeExecution+0x3a23
ntdll.dll!ZwDeviceIoControlFile+0xa
mswsock.dll+0x174d
WS2_32.dll!WSARecv+0x169
postgres.exe!pgwin32_recv+0x79
plugin_debugger.dll!BreakpointFreeSession+0x3f1
plugin_debugger.dll!pg_finfo_pldbg_set_global_breakpoint+0xd6e
plpgsql.dll!exec_get_datum_type_info+0xd65
plpgsql.dll!exec_get_datum_type_info+0xcff
plpgsql.dll!exec_get_datum_type_info+0x142a
plpgsql.dll!exec_get_datum_type_info+0xe14
plpgsql.dll!exec_get_datum_type_info+0xcff
plpgsql.dll!exec_get_datum_type_info+0x142a
plpgsql.dll!exec_get_datum_type_info+0xe14
plpgsql.dll!exec_get_datum_type_info+0xbbb
plpgsql.dll!plpgsql_exec_function+0x2e6
plpgsql.dll!plpgsql_call_handler+0x11f
postgres.exe!ExecProject+0x1ea8
postgres.exe!ExecProject+0x1f60
postgres.exe!ExecProject+0x47fa
postgres.exe!ExecProject+0x166
postgres.exe!ExecResult+0xb4
postgres.exe!ExecProcNode+0x82
postgres.exe!EvalPlanQualEnd+0x8cd
postgres.exe!standard_ExecutorRun+0xa8
postgres.exe!PortalRunFetch+0x64b
postgres.exe!PortalRun+0x1c7
postgres.exe!get_stats_option_name+0x2a19
postgres.exe!PostgresMain+0x703
postgres.exe!ShmemBackendArrayAllocation+0x2a6a
postgres.exe!SubPostmasterMain+0x273
postgres.exe!main+0x480
postgres.exe!pgwin32_popen+0x130b
kernel32.dll!BaseThreadInitThunk+0xd
ntdll.dll!RtlUserThreadStart+0x21

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alexey Lesovsky 2016-01-09 16:45:02 BUG #13818: PostgreSQL crashes after cronjob runs as "postgres"
Previous Message Tom Lane 2016-01-09 05:09:39 Re: Odd "operator does not exist" message