[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='', 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='', 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='', 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...