Re: Postgre driver(9.06.04.00) connected to Amazon redshift, is returning wrong count in SQLRowCount
"Asif Shaikh" <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.odbc |
|---|---|
| Message-ID | <OF2EEE9C90.581E3981-ON00258183.00419910-65258183.00423B76@notes.na.collabserv.com> |
Hi Hiroshi Inoue, PFA, my test run logs. Thanks & Regards Asif G. Shaikh From: "Inoue, Hiroshi" <[email protected]> To: Asif Shaikh <[email protected]> Cc: [email protected] Date: 08/21/2017 02:20 PM Subject: Re: [ODBC] Postgre driver(9.06.04.00) connected to Amazon redshift, is returning wrong count in SQLRowCount Hi, On 2017/08/21 17:21, Asif Shaikh wrote: Hi Hiroshi Inoue, Can you please help me understand where can I find Mylog output for my test. I could not go to office today as I am still not quite well. I will check with my team member tomorrow about how the old driver worked for him. If you can edit connection strings, please add *;debug=1* to the connection string. On Windows You can find mylog_xxxxxx.log under root directory after execution. regards, Hiroshi Inoue Thanks & Regards Asif G. Shaikh From: "Inoue, Hiroshi" <[email protected]> To: Asif Shaikh <[email protected]> Cc: [email protected] Date: 08/18/2017 07:54 PM Subject: Re: [ODBC] Postgre driver(9.06.04.00) connected to Amazon redshift, is returning wrong count in SQLRowCount On 2017/08/18 22:47, Asif Shaikh wrote: Hi Hiroshi Inoue, Thanks for the reply and I am sorry for replying late on this. Actually I was on a sick leave today. Your statement :- I see the result * SQLRowCount=2 * here. --> Yes, this looks to be correct count. In my case, the variable rowc doesn't get any value and still holds the initial value which is -1 in your test program. One of my team member informed me that he tried the 8.02.05 driver with our application on RHEL and that actually worked whereas the driver 9.06.04 didn't work on the same setup. So based on what I understood from his that the driver 9.06.04 is not working for him whereas the old driver 8.02.05 works. Unfortunately, I could not get all the details on this. I will get all the details on this on Monday and will get back to you. Meanwhile, is it possible for you to test your sample program with driver 9.06.04 to connect to Amazon redshift db and see if that reproduces the issue for you too? Could take Mylog output of your test and send it to me directly? regards, Hiroshi Inoue Thanks & Regards Asif G. Shaikh From: "Inoue, Hiroshi" <[email protected]> To: Asif Shaikh <[email protected]> Cc: [email protected] Date: 08/17/2017 06:53 PM Subject: Re: [ODBC] Postgre driver(9.06.04.00) connected to Amazon redshift, is returning wrong count in SQLRowCount On 2017/08/17 21:30, Asif Shaikh wrote: I just built your code on 32 bit and used the 32 bit postgre driver(8.02.05) but still it gave me same issue. :-( When you tried, did you connect to Amazon redshift using the postgre driver? I see the result * SQLRowCount=2 * here. Isn't it an expected result? Anyway I am testing with my local server The server's response to the command *select .. into .. from ..* is *SELECT 2*. If the response of Amazon redshift is different, the driver does nothing. regards, Hiroshi Inoue From: Asif Shaikh/India/IBM To: "Inoue, Hiroshi" <[email protected]> Cc: [email protected] Date: 08/17/2017 05:48 PM Subject: Re: [ODBC] Postgre driver(9.06.04.00) connected to Amazon redshift, is returning wrong count in SQLRowCount Hi Hiroshi Inoue, I see the same error with the code you sent. Did you build your application for 64 bit and used 64 bit postgre driver(9.06.04.00) ? Thanks & Regards Asif G. Shaikh -- Sent via pgsql-odbc mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-odbc
mylog_11508_64bit-driver(09.06.04).log
(application/octet-stream, 9.6 KB)
[11208-0.000]CC_connect: entering...
[11208-0.000]sslmode=disable
[11208-0.000]LIBPQ_CC_connect: entering...
[11208-0.000]Driver Version='09.06.0400,Jul 18 2017' linking 1800 dynamic Multithread library
[11208-0.000]LIBPQ_CC_connect: DSN = 'PostgreSQL35W', server = 'ac.cw8sq5fw9re9.us-west-2.redshift.amazonaws.com', port = '5439', database = 'acdb', username = 'acuser', password='xxxxx'
[11208-0.000]connecting to the database using ac.cw8sq5fw9re9.us-west-2.redshift.amazonaws.com as the server and pqopt={}
[11208-0.967]libpq connection to the database established.
[11208-0.967]protocol=3
[11208-0.967]Server version=8.0.2
[11208-0.967]LIBPQ_connect: retuning 1
[11208-0.967]CC_send_query: conn=000000000030DF80, query='SET DateStyle = 'ISO';SET extra_float_digits = 2;show transaction_isolation'
[11208-0.967]CC_send_query_append:query_len=75
[11208-0.983]in QR_Constructor
[11208-0.983]exit QR_Constructor
[11208-1.295]send_query: ok - 'C' - SET
[11208-1.295]send_query: setting cmdbuffer = 'SET'
[11208-1.295]send_query: returning res = 0000000000322F00
[11208-1.295]send_query: ok - 'C' - SET
[11208-1.295]in QR_Constructor
[11208-1.295]exit QR_Constructor
[11208-1.295]send_query: setting cmdbuffer = 'SET'
[11208-1.295]send_query: returning res = 0000000000320B60
[11208-1.295]in QR_Constructor
[11208-1.295]exit QR_Constructor
[11208-1.295]send_query: 'T' no result_in: res = 0000000000320CD0
[11208-1.295]num_fields = 1
[11208-1.295]in QR_set_num_fields
[11208-1.295]exit QR_set_num_fields
[11208-1.295]QR_from_PGResult: fieldname='transaction_isolation', adtid=1043, adtsize=-1, atttypmod=65535 (rel,att)=(0,0)
[11208-1.295]REALLOC: old_count = 0, size = 0
[11208-1.295]qresult: len=12, buffer='serializable'
[11208-1.295]isolation 8 to be 0
[11208-1.295]QResult: enter DESTRUCTOR
[11208-1.295]QResult: in QR_close_result
[11208-1.295]QResult: free memory in, fcount=0
[11208-1.295]QResult: free memory out
[11208-1.295]QResult: free memory in, fcount=0
[11208-1.295]QResult: free memory out
[11208-1.295]QResult: free memory in, fcount=1
[11208-1.295]QResult: free memory out
[11208-1.295]QResult: exit close_result
[11208-1.295]QResult: exit DESTRUCTOR
[11208-1.295]CC_send_settings: entering...
[11208-1.295]CC_lookup_lo: entering...
[11208-1.295]CC_send_query: conn=000000000030DF80, query='select oid, typbasetype from pg_type where typname = 'lo''
[11208-1.311]CC_send_query_append:query_len=57
[11208-1.311]in QR_Constructor
[11208-1.311]exit QR_Constructor
[11208-1.607]num_fields = 2
[11208-1.607]in QR_set_num_fields
[11208-1.607]exit QR_set_num_fields
[11208-1.607]QR_from_PGResult: fieldname='oid', adtid=26, adtsize=4, atttypmod=-1 (rel,att)=(1247,-2)
[11208-1.607]QR_from_PGResult: fieldname='typbasetype', adtid=26, adtsize=4, atttypmod=-1 (rel,att)=(1247,19)
[11208-1.607]QResult: enter DESTRUCTOR
[11208-1.607]QResult: in QR_close_result
[11208-1.607]QResult: free memory in, fcount=0
[11208-1.607]QResult: free memory out
[11208-1.607]QResult: exit close_result
[11208-1.607]QResult: exit DESTRUCTOR
[11208-1.607]Got the large object oid: -999
[11208-1.607]CC_send_query: conn=000000000030DF80, query='set client_encoding to 'UTF8''
[11208-1.607]CC_send_query_append:query_len=29
[11208-1.607]in QR_Constructor
[11208-1.607]exit QR_Constructor
[11208-1.903]send_query: ok - 'C' - SET
[11208-1.903]send_query: setting cmdbuffer = 'SET'
[11208-1.903]send_query: returning res = 0000000000322F00
[11208-1.903]QResult: enter DESTRUCTOR
[11208-1.903]QResult: in QR_close_result
[11208-1.903]QResult: free memory in, fcount=0
[11208-1.903]QResult: free memory out
[11208-1.903]QResult: exit close_result
[11208-1.903]QResult: exit DESTRUCTOR
[11208-1.903]conn->unicode=7 Client Encoding='UTF8' (Code 6)
[11208-1.919]CC_connect: returning...1
[11208-1.919]szConnStrOut = 'DSN=PostgreSQL35W;DATABASE=acdb;SERVER=ac.cw8sq5fw9re9.us-west-2.redshift.amazonaws.com;PORT=5439;UID=acuser;PWD=Unica%2a0123;SSLmode=disable;ReadOnly=0;Protocol=7.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;Fetch=100;UnknownSizes=0;MaxVarcharSize=255;MaxLongVarcharSize=8190;Debug=1;CommLog=0;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;ExtraSysTablePrefixes=;LFConversion=1;UpdatableCursors=1;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinary=1;UseServerSidePrepare=1;LowerCaseIdentifier=0;GssAuthUseGSS=0;XaOpt=1' len=570,4096
[11208-1.919]PGAPI_DriverConnect: returning 0
[11208-1.919][SQLGetDiagRecW][11208-1.919]PGAPI_GetDiagRec entering type=2 rec=1
[11208-1.919]**** PGAPI_ConnectError: hdbc=000000000030DF80 <0>
[11208-1.919]enter CC_get_error
[11208-1.919]exit CC_get_error
[11208-1.919]CC_Get_error returned nothing.
[11208-1.919]PGAPI_GetDiagRec exiting 100
[11208-1.919][SQLGetFunctions][11208-1.919][SQLGetInfoW][11208-1.919]PGAPI_GetInfo: entering...fInfoType=23
[11208-1.919]PGAPI_GetInfo: p='<NULL>', len=2, value=2, cbMax=2
[11208-1.919][SQLGetInfoW][11208-1.919]PGAPI_GetInfo: entering...fInfoType=24
[11208-1.919]PGAPI_GetInfo: p='<NULL>', len=2, value=2, cbMax=2
[11208-1.919][SQLGetInfoW][11208-1.919]PGAPI_GetInfo: entering...fInfoType=81
[11208-1.919]PGAPI_GetInfo: p='<NULL>', len=4, value=15, cbMax=4
[11208-1.919][[SQLAllocHandle]][11208-1.919]PGAPI_AllocStmt: entering...
[11208-1.919]**** PGAPI_AllocStmt: hdbc = 000000000030DF80, stmt = 0000000000322A00
[11208-1.919]CC_add_statement: self=000000000030DF80, stmt=0000000000322A00
[11208-1.919][SQLGetStmtAttrW][11208-1.919]PGAPI_GetStmtAttr Handle=0000000000322A00 10010
[11208-1.919][SQLGetStmtAttrW][11208-1.919]PGAPI_GetStmtAttr Handle=0000000000322A00 10011
[11208-1.919][SQLGetStmtAttrW][11208-1.919]PGAPI_GetStmtAttr Handle=0000000000322A00 10012
[11208-1.919][SQLGetStmtAttrW][11208-1.919]PGAPI_GetStmtAttr Handle=0000000000322A00 10013
[11208-5.413][SQLExecDirectW][11208-5.413] newlen=74[11208-5.413] ucs2_to_utf8:olen=74 utf8str=SELECT DISTINCT customer_id INTO asif_test_redshift9 FROM asif_test_source
[11208-5.413]PGAPI_ExecDirect: entering...1
[11208-5.413]SC_recycle_statement: self= 0000000000322A00
[11208-5.413]**** PGAPI_ExecDirect: hstmt=0000000000322A00, statement='SELECT DISTINCT customer_id INTO asif_test_redshift9 FROM asif_test_source'
[11208-5.413]PGAPI_ExecDirect: calling PGAPI_Execute...
[11208-5.413]PGAPI_Execute: entering...1
[11208-5.413]PGAPI_Execute: clear errors...
[11208-5.413]PGAPI_NumParams: entering...
[11208-5.413]SC_scanQueryAndCountParams: entering...
[11208-5.413]prepareParameters was not called, prepare state:8
[11208-5.413]SC_recycle_statement: self= 0000000000322A00
[11208-5.413]Exec_with_parameters_resolved: copying statement params: trans_status=1, len=74, stmt='SELECT DISTINCT customer_id INTO asif_test_redshift9 FROM asif_test_source'
[11208-5.413] stmt_with_params = 'SELECT DISTINCT customer_id INTO asif_test_redshift9 FROM asif_test_source'
[11208-5.413]about to begin SC_execute
[11208-5.413] Sending SELECT statement on stmt=0000000000322A00, cursor_name='SQL_CUR0000000000322A00' qflag=0,1
[11208-5.413]CC_send_query: conn=000000000030DF80, query='SELECT DISTINCT customer_id INTO asif_test_redshift9 FROM asif_test_source'
[11208-5.413]CC_send_query_append:query_len=74
[11208-5.413]in QR_Constructor
[11208-5.413]exit QR_Constructor
[11208-7.223]send_query: ok - 'C' - SELECT
[11208-7.223]send_query: setting cmdbuffer = 'SELECT'
[11208-7.223]send_query: returning res = 0000000000323060
[11208-7.223]send_query: ok - 'C' - SELECT
[11208-7.223]in QR_Constructor
[11208-7.223]exit QR_Constructor
[11208-7.223]send_query: setting cmdbuffer = 'SELECT'
[11208-7.223]send_query: returning res = 0000000000320C60
[11208-7.223] done sending the query:
[11208-7.223]SC_set_Result(322a00, 323060)[11208-7.223]QResult: enter DESTRUCTOR
[11208-7.223]retval=0
[11208-7.223]PGAPI_ExecDirect: returned 0 from PGAPI_Execute
[11208-9.033][SQLRowCount][11208-9.033]PGAPI_RowCount: entering...
[11208-13.042][[SQLFreeHandle]][11208-13.042]PGAPI_FreeStmt: entering...hstmt=0000000000322A00, fOption=1
[11208-13.042]QResult: enter DESTRUCTOR
[11208-13.042]QResult: in QR_close_result
[11208-13.042]QResult: free memory in, fcount=0
[11208-13.042]QResult: free memory out
[11208-13.042]QResult: free memory in, fcount=0
[11208-13.042]QResult: free memory out
[11208-13.042]QResult: exit close_result
[11208-13.042]QResult: exit DESTRUCTOR
[11208-13.042]SC_init_Result(322a00)[11208-13.042]SC_Destructor: self=0000000000322A00, self->result=0000000000000000, self->hdbc=000000000030DF80
[11208-13.042]APD_free_params: ENTER, self=0000000000322BD0
[11208-13.042]IPD_free_params: ENTER, self=0000000000322C40
[11208-13.042]PDATA_free_params: ENTER, self=0000000000322D38
[11208-13.042]SC_Destructor: EXIT
[11208-13.042][SQLDisconnect for 000000000030DF80][11208-13.042]PGAPI_Disconnect: entering...
[11208-13.042]PGAPI_Disconnect: about to CC_cleanup
[11208-13.042]in CC_Cleanup, self=000000000030DF80
[11208-13.042]after PQfinish
[11208-13.042]CC_conninfo_init opt=1
[11208-13.042]exit CC_Cleanup
[11208-13.042]PGAPI_Disconnect: done CC_cleanup
[11208-13.042]PGAPI_Disconnect: returning...
[11208-13.042][[SQLFreeHandle]][11208-13.042]PGAPI_FreeConnect: entering...
[11208-13.042]**** in PGAPI_FreeConnect: hdbc=000000000030DF80
[11208-13.042]enter CC_Destructor, self=000000000030DF80
[11208-13.042]in CC_Cleanup, self=000000000030DF80
[11208-13.057]after PQfinish
[11208-13.057]CC_conninfo_init opt=1
[11208-13.057]exit CC_Cleanup
[11208-13.057]after CC_Cleanup
[11208-13.057]after free statement holders
[11208-13.057]exit CC_Destructor
[11208-13.057]PGAPI_FreeConnect: returning...
[11208-13.057][[SQLFreeHandle]][11208-13.057]**** in PGAPI_FreeEnv: env = 0000000000301270 **
[11208-13.057]in EN_Destructor, self=0000000000301270
[11208-13.057]clearing conns count=128
[11208-13.057]exit EN_Destructor: rv = 1
[11208-13.057] ok
[11208-13.057]DETACHING PSQLODBC35W.DLL
mylog_2184_32bit-driver(8.02.04)).log
(application/octet-stream, 9.2 KB)
[11492-0.000]calling getDSNdefaults [11492-0.000]CC_connect: entering... [11492-0.000]sslmode=disable [11492-0.000]original_CC_connect: entering... [11492-0.015]Driver Version='08.02.0500,200709120001' linking 1310 static Multithread library [11492-0.015]original_CC_connect: DSN = 'PostgreSQL30W', server = 'ac.cw8sq5fw9re9.us-west-2.redshift.amazonaws.com', port = '5439', database = 'acdb', username = 'acuser', password='xxxxx' [11492-0.015]connecting to the server socket... [11492-0.358](0)(null) ERRNO=0 [11492-0.358]connection to the server socket succeeded. [11492-0.358]startup client_encoding=UTF8 [11492-0.358]sizeof startup packet = 96 [11492-0.358]sent the authentication block successfully. [11492-0.374]gonna do authentication [11492-0.374]read -1, global_socket_buffersize=4096 [11492-0.374]Lasterror=10035 [11492-0.670]read 13, global_socket_buffersize=4096 [11492-0.670]auth got 'R' [11492-0.670]areq = 5 salt=c634f0ba00 [11492-0.670]in AUTH_REQ_MD5 [11492-0.686]read -1, global_socket_buffersize=4096 [11492-0.686]Lasterror=10035 [11492-0.967]read 404, global_socket_buffersize=4096 [11492-0.967]auth got 'R' [11492-0.967]areq = 0 salt=0000000000 [11492-0.967]auth got 'S' [11492-0.967]auth got 'S' [11492-0.967]auth got 'S' [11492-0.967]auth got 'S' [11492-0.967]auth got 'S' [11492-0.967]auth got 'S' [11492-0.967]auth got 'S' [11492-0.967]Got the PostgreSQL version string: '8.0.2' [11492-0.967]Extracted PostgreSQL version number: '8.0' [11492-0.967]auth got 'S' [11492-0.967]auth got 'S' [11492-0.967]auth got 'S' [11492-0.967]auth got 'S' [11492-0.967]auth got 'S' [11492-0.967]auth got 'S' [11492-0.967]auth got 'S' [11492-0.967]auth got 'K' [11492-0.967]auth got 'Z' [11492-0.967]CC_send_settings: entering... [11492-0.967]PGAPI_AllocStmt: entering... [11492-0.967]**** PGAPI_AllocStmt: hdbc = 01F14BD0, stmt = 01F19838 [11492-0.967]CC_add_statement: self=01F14BD0, stmt=01F19838 [11492-0.967]PGAPI_FreeStmt: entering...hstmt=01F19838, fOption=1 [11492-0.967]QResult: enter DESTRUCTOR [11492-0.967]SC_init_Result(1f19838)[11492-0.967]SC_Destructor: self=01F19838, self->result=00000000, self->hdbc=01F14BD0 [11492-0.967]APD_free_params: ENTER, self=01F19938 [11492-0.967]IPD_free_params: ENTER, self=01F19978 [11492-0.967]PDATA_free_params: ENTER, self=01F199DC [11492-0.967]SC_Destructor: EXIT [11492-0.967]CC_lookup_lo: entering... [11492-0.967]CC_send_query: conn=01F14BD0, query='select oid, typbasetype from pg_type where typname = 'lo'' [11492-0.967]send_query: done sending query 63bytes flushed [11492-0.967]in QR_Constructor [11492-0.967]exit QR_Constructor [11492-0.967]read -1, global_socket_buffersize=4096 [11492-0.967]Lasterror=10035 [11492-1.263]read 77, global_socket_buffersize=4096 [11492-1.263]send_query: got id = 'T' [11492-1.263]QR_fetch_tuples: cursor = '', self->cursor=00000000 [11492-1.263]num_fields = 2 [11492-1.263]READING ATTTYPMOD [11492-1.263]CI_read_fields: fieldname='oid', adtid=26, adtsize=4, atttypmod=-1 (rel,att)=(1247,65534) [11492-1.263]READING ATTTYPMOD [11492-1.263]CI_read_fields: fieldname='typbasetype', adtid=26, adtsize=4, atttypmod=-1 (rel,att)=(1247,19) [11492-1.263]QR_fetch_tuples: past CI_read_fields: num_fields = 2 [11492-1.263]MALLOC: tuple_size = 100, size = 1600 [11492-1.263]QR_next_tuple: inTuples = true, falling through: fcount = 0, fetch_number = 0 [11492-1.263]end of tuple list -- setting inUse to false: this = 01F11DA0 SELECT [11492-1.279]_QR_next_tuple: 'C' fetch_total = 0 & this_fetch = 0 [11492-1.279]QR_next_tuple: backend_rows < CACHE_SIZE: brows = 0, cache_size = 0 [11492-1.279]QR_next_tuple: reached eof now [11492-1.279]_QR_next_tuple: 'C': DONE (fcount == 0) [11492-1.279]send_query: got id = 'Z' [11492-1.279]QResult: enter DESTRUCTOR [11492-1.279]QResult: in QR_close_result [11492-1.279]QResult: free memory in, fcount=0 [11492-1.279]QResult: free memory out [11492-1.279]QResult: enter DESTRUCTOR [11492-1.279]QResult: exit close_result [11492-1.279]QResult: exit DESTRUCTOR [11492-1.279]Got the large object oid: -999 [11492-1.279]CC_lookup_characterset: entering... [11492-1.279]conn->unicode=3 [11492-1.279]CC_connect: returning... [11492-1.279]szConnStrOut = 'DSN=PostgreSQL30W;DATABASE=acdb;SERVER=ac.cw8sq5fw9re9.us-west-2.redshift.amazonaws.com;PORT=5439;UID=acuser;PWD=xxxxxxxxxx;SSLmode=disable;ReadOnly=0;Protocol=7.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=255;MaxLongVarcharSize=8190;Debug=1;CommLog=0;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinary=0;UseServerSidePrepare=0;LowerCaseIdentifier=0;XaOpt=1;AB=10;' len=647,4096 [11492-1.279]PGAPI_DriverConnect: returning 0 [11492-1.279][SQLGetDiagRecW][11492-1.279]PGAPI_GetDiagRec entering type=2 rec=1 [11492-1.279]**** PGAPI_ConnectError: hdbc=01F14BD0 <0> [11492-1.279]enter CC_get_error [11492-1.279]enter CC_create_errormsg [11492-1.279]msg = '' [11492-1.279]exit CC_create_errormsg [11492-1.279]exit CC_get_error [11492-1.279]CC_Get_error returned nothing. [11492-1.279]PGAPI_GetDiagRec exiting 100 [11492-1.279][SQLGetFunctions][11492-1.279][SQLGetInfoW(30)][11492-1.279]PGAPI_GetInfo: entering...fInfoType=23 [11492-1.279]PGAPI_GetInfo: p='<NULL>', len=2, value=2, cbMax=2 [11492-1.279][SQLGetInfoW(30)][11492-1.279]PGAPI_GetInfo: entering...fInfoType=24 [11492-1.279]PGAPI_GetInfo: p='<NULL>', len=2, value=2, cbMax=2 [11492-1.279][SQLGetInfoW(30)][11492-1.279]PGAPI_GetInfo: entering...fInfoType=81 [11492-1.279]PGAPI_GetInfo: p='<NULL>', len=4, value=15, cbMax=4 [11492-1.279][[SQLAllocHandle]][11492-1.279]PGAPI_AllocStmt: entering... [11492-1.279]**** PGAPI_AllocStmt: hdbc = 01F14BD0, stmt = 01F18818 [11492-1.279]CC_add_statement: self=01F14BD0, stmt=01F18818 [11492-1.279][SQLGetStmtAttrW][11492-1.279]PGAPI_GetStmtAttr Handle=01F18818 10010 [11492-1.279][SQLGetStmtAttrW][11492-1.279]PGAPI_GetStmtAttr Handle=01F18818 10011 [11492-1.279][SQLGetStmtAttrW][11492-1.279]PGAPI_GetStmtAttr Handle=01F18818 10012 [11492-1.279][SQLGetStmtAttrW][11492-1.279]PGAPI_GetStmtAttr Handle=01F18818 10013 [11492-2.527][SQLExecDirectW][11492-2.527]PGAPI_ExecDirect: entering...1 [11492-2.527]SC_recycle_statement: self= 01F18818 [11492-2.527]**** PGAPI_ExecDirect: hstmt=01F18818, statement='SELECT DISTINCT customer_id INTO asif_test_redshift10 FROM asif_test_source' [11492-2.527]PGAPI_ExecDirect: calling PGAPI_Execute... [11492-2.527]PGAPI_Execute: entering...1 [11492-2.527]PGAPI_Execute: clear errors... [11492-2.527]PGAPI_NumParams: entering... [11492-2.527]SC_scanQueryAndCountParams: entering... [11492-2.527]prepareParameters 0 end [11492-2.527]SC_recycle_statement: self= 01F18818 [11492-2.527]Exec_with_parameters_resolved: copying statement params: trans_status=1, len=75, stmt='SELECT DISTINCT customer_id INTO asif_test_redshift10 FROM asif_test_source' [11492-2.527] stmt_with_params = 'SELECT DISTINCT customer_id INTO asif_test_redshift10 FROM asif_test_source' [11492-2.527]about to begin SC_execute [11492-2.527] Sending SELECT statement on stmt=01F18818, cursor_name='SQL_CUR01F18818' qflag=0,1 [11492-2.527]CC_send_query: conn=01F14BD0, query='SELECT DISTINCT customer_id INTO asif_test_redshift10 FROM asif_test_source' [11492-2.527]send_query: done sending query 81bytes flushed [11492-2.527]in QR_Constructor [11492-2.542]exit QR_Constructor [11492-2.542]read -1, global_socket_buffersize=4096 [11492-2.542]Lasterror=10035 [11492-3.135]read 30, global_socket_buffersize=4096 [11492-3.135]send_query: got id = 'C' [11492-3.135]send_query: ok - 'C' - SELECT [11492-3.135]send_query: setting cmdbuffer = 'SELECT' [11492-3.135]send_query: returning res = 01F11DC0 [11492-3.135]send_query: got id = 'C' [11492-3.135]send_query: ok - 'C' - SELECT [11492-3.135]in QR_Constructor [11492-3.135]exit QR_Constructor [11492-3.135]send_query: setting cmdbuffer = 'SELECT' [11492-3.135]send_query: returning res = 01F19BB0 [11492-3.135]send_query: got id = 'Z' [11492-3.135] done sending the query: [11492-3.135]SC_set_Result(1f18818, 1f11dc0)[11492-3.135]QResult: enter DESTRUCTOR [11492-3.135]retval=0 [11492-3.135]PGAPI_ExecDirect: returned 0 from PGAPI_Execute [11492-5.007][SQLRowCount][11492-5.007]PGAPI_RowCount: entering... [11492-8.564][[SQLFreeHandle]][11492-8.564]PGAPI_FreeStmt: entering...hstmt=01F18818, fOption=1 [11492-8.564]QResult: enter DESTRUCTOR [11492-8.564]QResult: in QR_close_result [11492-8.564]QResult: free memory in, fcount=0 [11492-8.564]QResult: free memory out [11492-8.564]QResult: enter DESTRUCTOR [11492-8.564]QResult: in QR_close_result [11492-8.564]QResult: free memory in, fcount=0 [11492-8.564]QResult: free memory out [11492-8.564]QResult: enter DESTRUCTOR [11492-8.564]QResult: exit close_result [11492-8.564]QResult: exit DESTRUCTOR [11492-8.564]QResult: exit close_result [11492-8.564]QResult: exit DESTRUCTOR [11492-8.564]SC_init_Result(1f18818)[11492-8.564]SC_Destructor: self=01F18818, self->result=00000000, self->hdbc=01F14BD0 [11492-8.564]APD_free_params: ENTER, self=01F18918 [11492-8.564]IPD_free_params: ENTER, self=01F18958 [11492-8.564]PDATA_free_params: ENTER, self=01F189BC [11492-8.564]SC_Destructor: EXIT [11492-8.564][SQLDisconnect for 01F14BD0][11492-8.564]PGAPI_Disconnect: entering...