Обсуждение: 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
On Fri, Mar 28, 2014 at 11:19 AM, Inoue, Hiroshi <inoue@tpf.co.jp> wrote: > (2014/03/28 5:07), Barry Bell wrote: >> 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? > > Could you send me corresponding Mylog output? Your driver settings (the .ini file) would be welcome as well to be able to reproduce the problem and to understand what is happening. Regards, -- Michael
Hi Barry,
My reply seems to have been rejected.
So I reply to ML.
(2014/03/29 1:10), Barry Bell wrote:
> Only "ini" I could find was "postgressql-sdbc.uno"
> [Bootstrap]
> PQ_LOGLEVEL=NONE
>
> Hope this helps, Connection string:
> "Driver={PostgreSQL
ANSI};Server=hhl-pgdev.harte-hanks.com;Port=65432;Database=db;Uid=u;Pwd=p;BI=2;TextAsLongVarchar=1;UnknownSizes=2;UseServerSidePrepare=1;B0=254;B7=1;C5=0;AB=8;"
>
> For the ODBC driver log:
> vfp9 2928-f338 ENTER SQLExecDirect
> HSTMT 0x009C8C08
> UCHAR * 0x053B3568 [ -3] "\ 9\ 9\ 9Insert into autorunlog (
recordid,program,description,starttime,endtime,records) values ( "nextval"('autorunlog_seq'),? ,? ,? ,? ,? )\ 0"
> SDWORD -3
>
> vfp9 2928-f338 EXIT SQLExecDirect with return code 0 (SQL_SUCCESS)
> HSTMT 0x009C8C08
> UCHAR * 0x053B3568 [ -3] "\ 9\ 9\ 9Insert into autorunlog (
recordid,program,description,starttime,endtime,records) values ( "nextval"('autorunlog_seq'),? ,? ,? ,? ,? )\ 0"
> SDWORD -3
Hmm what I really wanted was Mylog output.
You can take the log by adding ;Debug=1 or ;B2=1 to your
connection string.
> 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 ms parse <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 ms bind <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 ms execute <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 ms statement: DISCARD ALL",,,,,,,,"exec_simple_query, postgres.c:1125",""
Unfortunately I can find no problem in the above log.
Do some errors occur after this?
regards,
Hiroshi Inoue
(2014/03/31 23:56), Barry Bell wrote: > I am not getting any error. > Just that the inserts are not commiting. > (They do commit with ver 9.3.100) How do you confirm it? > Where would I see the " was Mylog output."? Root Directory(C:\) or user directory(C:\Users\your_user_name). regatrds, Hiroshi Inoue
(2014/04/01 4:01), Barry Bell wrote: > Confirmed using a query through PGadmin > (PGadmin does not use the ODBC driver and does the query against the DB) > When I run it with 9.3.0100, I do see the records inserted, Hmm I can't find any suspicious part in the log. The insertion seems to be completed. Could you send me the Mylog with 9.3.0100 also? regards, Hiroshi Inoue > > Barry Bell > Senior Developer/Analyst > Logistics > Harte Hanks > 1525 NW 3rd ST > Deerfield Beach FL, 33442 > 954-429-3771 Ext 267 office > 954-281-1464 fax > > hartehanks.com / linkedin / twitter / facebook -- I am using the free version of SPAMfighter. SPAMfighter has removed 7183 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
I am not getting any error.
Just that the inserts are not commiting.
(They do commit with ver 9.3.100)
Where would I see the " was Mylog output."?
Barry Bell
-----Original Message-----
From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Hiroshi Inoue
Sent: Sunday, March 30, 2014 11:23 PM
To: pgsql-odbc@postgresql.org
Subject: Re: FW: [ODBC] ODBC 9.3.0210 not commiting, Discard ALL
Hi Barry,
My reply seems to have been rejected.
So I reply to ML.
(2014/03/29 1:10), Barry Bell wrote:
> Only "ini" I could find was "postgressql-sdbc.uno"
> [Bootstrap]
> PQ_LOGLEVEL=NONE
>
> Hope this helps, Connection string:
> "Driver={PostgreSQL
ANSI};Server=hhl-pgdev.harte-hanks.com;Port=65432;Database=db;Uid=u;Pwd=p;BI=2;TextAsLongVarchar=1;UnknownSizes=2;UseServerSidePrepare=1;B0=254;B7=1;C5=0;AB=8;"
>
> For the ODBC driver log:
> vfp9 2928-f338 ENTER SQLExecDirect
> HSTMT 0x009C8C08
> UCHAR * 0x053B3568 [ -3] "\ 9\ 9\ 9Insert into autorunlog (
recordid,program,description,starttime,endtime,records) values ( "nextval"('autorunlog_seq'),? ,? ,? ,? ,? )\ 0"
> SDWORD -3
>
> vfp9 2928-f338 EXIT SQLExecDirect with return code 0 (SQL_SUCCESS)
> HSTMT 0x009C8C08
> UCHAR * 0x053B3568 [ -3] "\ 9\ 9\ 9Insert into autorunlog (
recordid,program,description,starttime,endtime,records) values ( "nextval"('autorunlog_seq'),? ,? ,? ,? ,? )\ 0"
> SDWORD -3
Hmm what I really wanted was Mylog output.
You can take the log by adding ;Debug=1 or ;B2=1 to your connection string.
> 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 ms parse <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 ms bind <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 ms execute <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 ms statement: DISCARD ALL",,,,,,,,"exec_simple_query, postgres.c:1125",""
Unfortunately I can find no problem in the above log.
Do some errors occur after this?
regards,
Hiroshi Inoue
--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
Confirmed using a query through PGadmin (PGadmin does not use the ODBC driver and does the query against the DB) When I run it with 9.3.0100, I do see the records inserted, Barry Bell Senior Developer/Analyst Logistics Harte Hanks 1525 NW 3rd ST Deerfield Beach FL, 33442 954-429-3771 Ext 267 office 954-281-1464 fax hartehanks.com / linkedin / twitter / facebook -----Original Message----- From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Hiroshi Inoue Sent: Monday, March 31, 2014 2:55 PM To: Barry Bell; pgsql-odbc@postgresql.org Subject: Re: FW: [ODBC] ODBC 9.3.0210 not commiting, Discard ALL (2014/03/31 23:56), Barry Bell wrote: > I am not getting any error. > Just that the inserts are not commiting. > (They do commit with ver 9.3.100) How do you confirm it? > Where would I see the " was Mylog output."? Root Directory(C:\) or user directory(C:\Users\your_user_name). regatrds, Hiroshi Inoue -- Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-odbc
Вложения
I have been unable to reproduce this issue. (Running the same code as last week now commits without any issues). We do refresh the data on our test system over the weekend. I will keep testing to see if I can make it happen again, But for now no issues. -----Original Message----- From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Hiroshi Inoue Sent: Monday, March 31, 2014 2:55 PM To: Barry Bell; pgsql-odbc@postgresql.org Subject: Re: FW: [ODBC] ODBC 9.3.0210 not commiting, Discard ALL (2014/03/31 23:56), Barry Bell wrote: > I am not getting any error. > Just that the inserts are not commiting. > (They do commit with ver 9.3.100) How do you confirm it? > Where would I see the " was Mylog output."? Root Directory(C:\) or user directory(C:\Users\your_user_name). regatrds, Hiroshi Inoue -- Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-odbc