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

Re: Win32 hard crash problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Win32 hard crash problem
Date: 2006-08-31 21:50:39
Message-ID: 24567.1157061039@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
"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.

> Any thoughts?

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

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Joshua D. DrakeDate: 2006-08-31 21:59:23
Subject: Re: Win32 hard crash problem
Previous:From: Bruce MomjianDate: 2006-08-31 21:48:55
Subject: Re: [GENERAL] Thought provoking piece on

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