Re: Win32 hard crash problem

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/