Tom Lane wrote:
"Joshua D. Drake" <[EMAIL PROTECTED]> 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/
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
