From: | "Inoue, Hiroshi" <inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | Barry Bell <Barry(dot)Bell(at)hartehanks(dot)com> |
Cc: | "'pgsql-odbc(at)postgresql(dot)org'" <pgsql-odbc(at)postgresql(dot)org>, Dev Kumkar <devdas(dot)kumkar(at)gmail(dot)com>, "Hiroshi Saito (hiroshi(at)winpg(dot)jp)" <hiroshi(at)winpg(dot)jp> |
Subject: | Re: FW: ODBC 9.3.0210 not commiting, Discard ALL |
Date: | 2014-03-28 02:19:27 |
Message-ID: | 5334DC2F.40808@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hi Barry,
Could you send me corresponding Mylog output?
regards,
Hiroshi Inoue
(2014/03/28 5:07), Barry Bell wrote:
> After installing PostgresSQL ODBC driver ver 9.3.0210 32-bit on a
> windows 7.
>
> Queries are all coming out the same,
>
> But any insert statements are not commiting.
>
> Database log shows “DISCARD ALL”, inserts are getting executed but rollback.
>
> (being call for Foxpro, see DB Log below).
>
> Uninstalling 9.3.0210 and Reverting back to 9.3.0100 fixes the issue.
>
> Can you please correct this ASAP?
>
> DBLOG
>
> 2014-03-27 15:55:55.336
> EDT,"","",2566,"localhost:51398",53348244.a06,50,"PARSE",2014-03-27
> 15:55:48 EDT,9/417,0,LOG,00000,"duration: 0.241 msparse <unnamed>:
> Insert into autorunlog (
> recordid,program,description,starttime,endtime,records ) values (
> ""nextval""('autorunlog_seq'),$1 ,$2 ,$3 ,$4
> ,$5)",,,,,,,,"exec_parse_message, postgres.c:1391",""
>
> 2014-03-27 15:55:55.336
> EDT,"hits","hits",2566,"localhost:51398",53348244.a06,51,"BIND",2014-03-27
> 15:55:48 EDT,9/417,0,LOG,00000,"duration: 0.040 msbind <unnamed>: Insert
> into autorunlog ( recordid,program,description,starttime,endtime,records
> ) values ( ""nextval""('autorunlog_seq'),$1 ,$2 ,$3 ,$4
> ,$5)","parameters: $1 = 'DOEFUELPRICES', $2 = 'DOE Fuel Prices Update',
> $3 = '2014-03-27 15:55:47', $4 = '2014-03-27 15:55:55', $5 =
> '0'",,,,,,,"exec_bind_message, postgres.c:1771",""
>
> 2014-03-27 15:55:55.337
> EDT,"","",2566,"localhost:51398",53348244.a06,52,"INSERT",2014-03-27
> 15:55:48 EDT,9/417,7419304,LOG,00000,"duration: 0.233 msexecute
> <unnamed>: Insert into autorunlog (
> recordid,program,description,starttime,endtime,records ) values (
> ""nextval""('autorunlog_seq'),$1 ,$2 ,$3 ,$4 ,$5)","parameters: $1 =
> 'DOEFUELPRICES', $2 = 'DOE Fuel Prices Update', $3 = '2014-03-27
> 15:55:47', $4 = '2014-03-27 15:55:55', $5 =
> '0'",,,,,,,"exec_execute_message, postgres.c:1991",""
>
> 2014-03-27 15:55:55.346
> EDT,"","",2566,"localhost:51398",53348244.a06,53,"DISCARD
> ALL",2014-03-27 15:55:48 EDT,9/0,0,LOG,00000,"duration: 8.486
> msstatement:DISCARD ALL",,,,,,,,"exec_simple_query, postgres.c:1125",""
>
> *Barry Bell*
--
I am using the free version of SPAMfighter.
SPAMfighter has removed 7014 of my spam emails to date.
Get the free SPAMfighter here: http://www.spamfighter.com/len
Do you have a slow PC? Try a Free scan
http://www.spamfighter.com/SLOW-PCfighter?cid=sigen
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2014-03-28 03:30:34 | Re: FW: ODBC 9.3.0210 not commiting, Discard ALL |
Previous Message | Dev Kumkar | 2014-03-27 22:30:55 | Re: ODBC settings |