Re: Win32 hard crash problem

["Joshua D. Drake" <jd(at)commandprompt(dot)com>]

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/