| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Richard Broersma <richard(dot)broersma(at)gmail(dot)com> |
| Cc: | PostgreSQL - General ML <pgsql-general(at)postgresql(dot)org>, pgsql-odbc(at)postgresql(dot)org |
| Subject: | Re: what gives: SELECT INVALID SELECT STATEMENT TO FORCE ODBC DRIVER TO UNPREPARED STATE |
| Date: | 2008-06-11 07:07:28 |
| Message-ID: | 484F79B0.5060401@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general pgsql-odbc |
Richard Broersma wrote:
> Server logs below. Notice how an error raised in a connection to the
> proj02u20411 database forces the transaction in the instrumentation
> database to rollback.
> Can anyone explain why connections that as far as PG should conserned
> are unrelated are actually interferring with one another?
I don't see any errors on proj...
> --------------------------------------------------------------------------------
[snip]
> 2008-06-10 15:04:52instrumentation ERROR: syntax error at or near
> "SELECT" at character 16
> 2008-06-10 15:04:52instrumentation STATEMENT: SELECT INVALID SELECT
> STATEMENT TO FORCE ODBC DRIVER TO UNPREPARED STATE
> 2008-06-10 15:04:52instrumentation LOG: statement: ROLLBACK
That appears to be a deliberate bad query issued by something (above the
odbc layer?). I think you've got something sending "SELECT INVALID
SELECT STATEMENT TO FORCE ODBC DRIVER TO UNPREPARED STATE" as a query to
force a rollback. Why it's not just sending "ROLLBACK" I don't know.
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Devendra Singh Rawat | 2008-06-11 07:42:45 | Re: Disk Space issue |
| Previous Message | Praveen Kumar (TUV) | 2008-06-11 06:14:44 | Re: Disk Space issue |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2008-06-11 08:14:40 | Re: [ANNOUNCE] PostgreSQL Software Catalogue |
| Previous Message | Richard Huxton | 2008-06-11 07:03:34 | Re: encoding confusion |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Volkan YAZICI | 2008-06-11 08:21:46 | "No Mapping exists" Error |
| Previous Message | Richard Broersma | 2008-06-11 04:06:13 | what gives: SELECT INVALID SELECT STATEMENT TO FORCE ODBC DRIVER TO UNPREPARED STATE |