Re: FW: ODBC 9.3.0210 not commiting, Discard ALL

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