Skip site navigation (1) Skip section navigation (2)

Re: BUG #3750: Invalid frontend message type 112

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Christian Ullrich <chris(at)chrullrich(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3750: Invalid frontend message type 112
Date: 2007-11-15 18:40:47
Message-ID: 473C92AF.90503@hagander.net (view raw or flat)
Thread:
Lists: pgsql-bugs
Christian Ullrich wrote:
> The following bug has been logged online:
> 
> Bug reference:      3750
> Logged by:          Christian Ullrich
> Email address:      chris(at)chrullrich(dot)net
> PostgreSQL version: 8.3-beta2
> Operating system:   Windows Server 2003
> Description:        Invalid frontend message type 112
> Details: 
> 
> I'm running 8.3-beta2 (on WS2003, the client is XP Prof.) to experiment with
> SSPI auth against AD. There is a persistent problem when using SSPI:
> Authentication appears to work, but the connection fails at the first
> query.
> 
> psql tells me about an "invalid frontend message type 112". Most of the
> time, that error comes as the first line of output from psql (above the
> "Welcome to" line), sometimes it is displayed later:
> 
> Welcome to psql 8.3beta2, the PostgreSQL interactive terminal.
> 
> Type:  \copyright for distribution terms
>        \h for help with SQL commands
>        \? for help with psql commands
>        \g or terminate with semicolon to execute query
>        \q to quit
> 
> test=>
> test=> select 1;
> server closed the connection unexpectedly
>         This probably means the server terminated abnormally before or while
> processing the request.
> The connection to the server was lost. Attempting reset: FATAL:  invalid
> frontend message type 112
> Succeeded.
> 
> When I use another authentication method, all is well.
> 
> I can provide a network trace of the connection on request.

Strange, it's been running fine for me :-( Couple of questions:

Does it work if you run the client on the same machine as the server?

How's your AD set up - single domain, or multiple?

Do you get anything in the server logs (please check both eventlog and
the pg_log directory)

And yes, please send me a network trace off-list. (send the rest of the
responses on-list in case someone else has a good idea :-P)

//Magnus


In response to

Responses

pgsql-bugs by date

Next:From: Blanco, JoseDate: 2007-11-15 19:09:10
Subject: Strange problem with an index.
Previous:From: Christian UllrichDate: 2007-11-15 18:22:03
Subject: BUG #3750: Invalid frontend message type 112

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group