Re: BUG #6201: Windows User Log Off Causes Backend Exception 0xC0000142

> From: Craig Ringer [mailto:ringerc(at)ringerc(dot)id(dot)au]
> Sent: Friday, September 09, 2011 7:53 PM
>
> On 10/09/2011 4:59 AM, Jerome Schulteis wrote:
> > The following bug has been logged online:
> >
> > Bug reference: 6201
> > Logged by: Jerome Schulteis
> > Email address: jerome(dot)schulteis(at)edstrom(dot)com
> > PostgreSQL version: 9.0.4
> > Operating system: Windows XP Pro SP3
> > Description: Windows User Log Off Causes Backend Exception
> 0xC0000142
> > Details:
> >
> > It does not happen on every log off, but if the Windows console user
> > logs off of the server at just the wrong time while a backend is
> > starting up, the backend terminates with exception 0xC0000142
> > (STATUS_DLL_INIT_FAILED), and the PostgreSQL Windows service stops
> > (shared memory block is still in use):
> I wonder which DLL failed? It seems that PostgreSQL doesn't print the
> message the operating system generates for these errors. For example, it
> should be printing:
>
> "{DLL Initialization Failed} Initialization of the dynamic link library %hs failed.
> The process is terminating abnormally."
>
> ... where %hs is the DLL name or path. I should have a play with that once I
> finish moving house...
>
>
> Do you have any antivirus or antimalware products on the system?

This was on a VirtualBox VM with no antivirus; originally seen on a real machine running ESET 4.0.

> Do you have a Logitech webcam? Their webcam effects app adds a hook DLL
> to every process on the system, and I've seen it cause issues with MinGW
> among other things before.

There is no webcam on the system.

> If you launch a trivial process like "notepad.exe" then launch Process
> Explorer from SysInternals, select notepad.exe and press control-D to
> show the DLL list, what non-Microsoft DLLs are shown? You can copy and
> paste the list.

All of the DLLs for notepad.exe are either Microsoft or .nls.

> If you examine a running postgres.exe backend (one of the processess
> listed UNDER the main "postgres.exe" which is the postmaster) the same
> way, what non-Microsoft DLLs are shown there? Note that you may have to
> run Process Explorer as administrator to view the DLL list for
> postgres.exe. Ignore any DLLs ending in ".NLS" .
>
> For bonus points, verify each Microsoft DLL as having a valid signature
> by double-clicking on it in the list, and report any DLLs that fail
> verification.

All Microsoft DLLs verified. The following are all of the non-Microsoft non-.nls DLLs:

iconv.dll LGPLed libiconv for Windows NT/2000/XP and Windows 95/98/ME Free Software Foundation 1.9.0.0
libeay32.dll OpenSSL Shared Library The OpenSSL Project, http://www.openssl.org/ 0.9.8.12
libiconv-2.dll LGPLed libiconv for Windows NT/2000/XP/Vista and Windows 95/98/ME Free Software Foundation 1.12.0.0
libintl-8.dll LGPLed libintl for Windows NT/2000/XP/Vista and Windows 95/98/ME Free Software Foundation 0.17.0.0
libxml2.dll
postgres.exe PostgreSQL Server PostgreSQL Global Development Group 9.0.4.11104
ssleay32.dll OpenSSL Shared Library The OpenSSL Project, http://www.openssl.org/ 0.9.8.12
zlib1.dll zlib data compression library 1.2.3.0

> --
> Craig Ringer

Thanks for looking into this.