From: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | Markus Wollny <Markus(dot)Wollny(at)computec(dot)de> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: S1010 function sequence error after ODBC-driver-upgrade |
Date: | 2003-11-09 23:52:13 |
Message-ID: | 3FAED32D.9C6ADB7C@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Could you send me the Mylog debug output ?
regards,
Hiroshi Inoue
http://www.geocities.jp/inocchichichi/psqlodbc/
Markus Wollny wrote:
>
> Hello!
>
> We upgraded the PostgreSQL-ODBC-drivers on our webservers last friday;
> installed version before the upgrade was 7.3.100, I upgraded to 7.3.200.
> We've got PostgreSQL 7.3.4 running on linux-servers; the ODBC-driver ist
> used on Windows 2000 Server, running IIS or Apache 2.0 and ColdFusion
> 5.0.
>
> Since upgrading, we very often get ODBC Error Code = S1010 (Function
> sequence error). This happens on some (but not all) tables when
> attempting to do several UPDATEs or DELETEs in one script. The error is
> persistent - it doesn't help to restart the server; VACUUM ANALYZE on
> the same table works flawlessly, so does doing the exact same queries
> via PGAdminII (not so very recent version and thus older ODBC-drivers,
> too).
>
> When creating a new table, inserting a dozen rows or so and then trying
> updates or deletes on this table in a ColdFusion-script, everything
> works just fine, so we cannot willingly reproduce the symptoms on any
> more than the affected production-tables.
>
> I read up on the subject of S1010 a bit and I found suggestions that one
> reason might be "SQLExecute" being called before "SQLPrepare". I
> installed the new PostgreSQL-ODBC driver via control panel and
> reinstalled 7.3.100 on one server - but that didn't help at all. I don't
> know if uninstalling an reinstalling the old version does provide pro a
> "clean" rollback of all ODBC-driver-components to the previous version -
> so I'm not sure, if not some remains of the 7.3.200-install do still
> cause this problem.
>
> I am absolutely sure that we didn't change anything else but this
> ODBC-driver-update on our webservers since before the errors occured
> until first occurrence - no Windows Update, no ColdFusion-Patches, no
> changing of any settings.
>
> Could you give me some hints as to where and what to check next and
> maybe how to assure a complete removal of any system-changes the update
> might have caused?
>
> Thank you very much!
From | Date | Subject | |
---|---|---|---|
Next Message | Markus Wollny | 2003-11-10 00:09:38 | Re: S1010 function sequence error after ODBC-driver-upgrade |
Previous Message | Markus Wollny | 2003-11-09 22:31:53 | S1010 function sequence error after ODBC-driver-upgrade |