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

Re: Win32 hard crash problem

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Win32 hard crash problem
Date: 2006-08-31 21:59:23
Message-ID: 44F75BBB.8080404@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Tom Lane wrote:
> "Joshua D. Drake" <jd(at)commandprompt(dot)com> writes:
>> Dave Cramer and I have dealt with a company today running 8.1.4 on 
>> Windows 2003. The application is a web app that runs via JDBC/Hibernate.
>> The application will function perfectly for about 2/3 weeks and then we 
>> will receive a:
>> "server sent data (\"D\" message) without prior row description (\"T\" 
>> message)");
> 
> That sounds suspiciously close to the time from boot to wraparound of
> GetTickCount:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sysinfo/base/gettickcount.asp
> M$ list this as 49 days but that's the time to wrap clear around to
> zero; the value overflows and goes negative in 24.85 days if I've
> done the math correctly.
> 
> My bet is something depending on GetTickCount to measure elapsed time
> (and no, it's not used in the core Postgres code, but you've got plenty
> of other possible culprits in that stack).
> 
> BTW, are you sure this is coming from JDBC?  I see the exact same
> message text in libpq:
>  libpq_gettext("server sent data (\"D\" message) without prior row description (\"T\" message)\n"));
> Maybe the JDBC driver uses the identical message wording but my thought
> is to look for something going through libpq.

The error is server side. I was just describing the environment.

> 
>> Any thoughts?
> 
> I suppose "get a real operating system" won't go over well?

Tried that, I got nervous laughter on the other end ;)

Joshua D. Drake

> 
> 			regards, tom lane
> 


-- 

    === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
    Providing the most comprehensive  PostgreSQL solutions since 1997
              http://www.commandprompt.com/



In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2006-08-31 22:01:44
Subject: Re: Win32 hard crash problem
Previous:From: Tom LaneDate: 2006-08-31 21:50:39
Subject: Re: Win32 hard crash problem

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