[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='', len=2, value=2, cbMax=2 [11208-1.919][SQLGetInfoW][11208-1.919]PGAPI_GetInfo: entering...fInfoType=24 [11208-1.919]PGAPI_GetInfo: p='', len=2, value=2, cbMax=2 [11208-1.919][SQLGetInfoW][11208-1.919]PGAPI_GetInfo: entering...fInfoType=81 [11208-1.919]PGAPI_GetInfo: p='', 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