[4467355648]parse leng=151 [4467355648]SendDescribeRequest:plan_name=_PLAN0x7f8552f3bcb0 [4467355648]describe leng=21 [4467355648]*** LEAVE_CONN_CS [140210608634616] *** [4467355648] stmt_with_params = '(null)' [4467355648]about to begin SC_execute [4467355648]SendBindRequest: plan_name=_PLAN0x7f8552f3bcb0 [4467355648]num_params=0 proc_return=0 [4467355648]num_p=0 [4467355648]bind leng=50 [4467355648]SendExecuteRequest: plan_name=_PLAN0x7f8552f3bcb0 count=0 [4467355648]execute leng=24 [4467355648]Close leng=21 [4467355648]get_Result=0x0 0x0 0 [4467355648]in QR_Constructor [4467355648]exit QR_Constructor [4467355648]read -1, global_socket_buffersize=4096 [4467355648]Lasterror=35 [4467355648]!!! poll ret=1 revents=1 [4467355648]read 47, global_socket_buffersize=4096 [4467355648]desc id=1[4467355648] response_length=0 [4467355648]desc id=t[4467355648] response_length=2 [4467355648]num_params=0 info=0 [4467355648]extend_iparameter_bindings: entering ... self=0x7f8552f3bec8, parameters_allocated=0, num_params=0 [4467355648]exit extend_iparameter_bindings=0x0 [4467355648]desc id=n[4467355648] response_length=0 [4467355648]desc id=2[4467355648] response_length=0 [4467355648]desc id=C[4467355648] response_length=9 [4467355648]command response=SELECT 1 [4467355648]SendSyncAndReceive: reached eof now [4467355648]desc id=3[4467355648] response_length=0 [4467355648]desc id=Z[4467355648] response_length=1 [4467355648]*** LEAVE_CONN_CS [140210608634616] *** [4467355648]0x7f8552f3bcb0->SC_set_rowstart -1->-1(unknown) [4467355648]:stmt result=-1 [4467355648]!!0x7f8552f3bcb0->SC_is_concat_pre=8 res=0x7f8552f07090 [4467355648]SC_set_Result(52f3bcb0, 52f07090)[4467355648]QResult: enter DESTRUCTOR [4467355648]*** LEAVE_CONN_CS [140210608634616] *** [4467355648]retval=0 [4467355648]DiscardStatementSvp:0x7f8552f3bcb0->accessed=1 is_in=0 is_rb=1 is_tc=0 [4467355648]*** LEAVE_CONN_CS [140210608634616] *** [4467355648][SQLNumResultCols][4467355648]StartRollbackState:0x7f8552f3bcb0->internal=0 [4467355648]PGAPI_NumResultCols: entering... [4467355648]SC_pre_execute: status = 3 [4467355648]PGAPI_NumResultCols: result = 0x7f8552f07090, status = 3, numcols = 0 [4467355648]DiscardStatementSvp:0x7f8552f3bcb0->accessed=0 is_in=0 is_rb=1 is_tc=0 [140735257568016][[SQLFreeHandle]][140735257568016]*** ENTER_CONN_CS [140210608634616] *** [140735257568016]PGAPI_FreeStmt: entering...hstmt=0x7f8552f3bcb0, fOption=1 [140735257568016]QResult: enter DESTRUCTOR [140735257568016]QResult: in QR_close_result [140735257568016]QResult: free memory in, fcount=0 [140735257568016]QResult: free memory out [140735257568016]QResult: exit close_result [140735257568016]QResult: exit DESTRUCTOR [140735257568016]SC_init_Result(52f3bcb0)[140735257568016]SC_Destructor: self=0x7f8552f3bcb0, self->result=0x0, self->hdbc=0x7f8553857000 [140735257568016]*** ENTER_CONN_CS [140210608634616] *** [140735257568016]CC_send_query: conn=0x7f8553857000, query='DEALLOCATE "_PLAN0x7f8552f3bcb0"' [140735257568016]leng=33 [140735257568016]send_query: done sending query 38bytes flushed [140735257568016]in QR_Constructor [140735257568016]exit QR_Constructor [140735257568016]read -1, global_socket_buffersize=4096 [140735257568016]Lasterror=35 [140735257568016]!!! poll ret=1 revents=1 [140735257568016]read 22, global_socket_buffersize=4096 [140735257568016]send_query: got id = 'C' [140735257568016]send_query response_length=11 [140735257568016]send_query: ok - 'C' - DEALLOCATE [140735257568016]send_query: setting cmdbuffer = 'DEALLOCATE' [140735257568016]send_query: returning res = 0x7f8552ebe6e0 [140735257568016]send_query: got id = 'Z' [140735257568016]send_query response_length=1 [140735257568016]*** LEAVE_CONN_CS [140210608634616] *** [140735257568016]QResult: enter DESTRUCTOR [140735257568016]QResult: in QR_close_result [140735257568016]QResult: free memory in, fcount=0 [140735257568016]QResult: free memory out [140735257568016]QResult: exit close_result [140735257568016]QResult: exit DESTRUCTOR [140735257568016]*** LEAVE_CONN_CS [140210608634616] *** [140735257568016]ARDFields_free 0x7f8552f3bd90 bookmark=0x7f8552f3cb10[140735257568016] hey[140735257568016]ARD_unbind_cols freeall=1 allocated=0 bindings=0x0[140735257568016]APD_free_params: ENTER, self=0x7f8552f3be58 [140735257568016]IPD_free_params: ENTER, self=0x7f8552f3bec8 [140735257568016]GDATA_unbind_cols freeall=1 allocated=0 gdata=0x0[140735257568016]PDATA_free_params: ENTER, self=0x7f8552f3bf90 [140735257568016]SC_Destructor: EXIT [140735257568016]*** LEAVE_CONN_CS [140210608634616] *** [140735257568016][SQLGetConnectAttrW][140735257568016]*** ENTER_CONN_CS [140210608634616] *** [140735257568016]PGAPI_GetConnectAttr 1209 [140735257568016]*** LEAVE_CONN_CS [140210608634616] *** [140735257568016][SQLGetConnectAttrW][140735257568016]*** ENTER_CONN_CS [140210608634616] *** [140735257568016]PGAPI_GetConnectAttr 1209 [140735257568016]*** LEAVE_CONN_CS [140210608634616] *** [4467892224][[SQLAllocHandle]][4467892224]*** ENTER_CONN_CS [140210608634616] *** [4467892224]PGAPI_AllocStmt: entering... [4467892224]0x7f8555001e00->SC_set_rowstart 0->-1(unknown) [4467892224]:stmt result=-1 [4467892224]**** PGAPI_AllocStmt: hdbc = 0x7f8553857000, stmt = 0x7f8555001e00 [4467892224]CC_add_statement: self=0x7f8553857000, stmt=0x7f8555001e00 [4467892224]*** LEAVE_CONN_CS [140210608634616] *** [4467892224][SQLGetStmtAttrW][4467892224]StartRollbackState:0x7f8555001e00->internal=0 [4467892224]PGAPI_GetStmtAttr Handle=0x7f8555001e00 10010 [4467892224]DiscardStatementSvp:0x7f8555001e00->accessed=0 is_in=0 is_rb=1 is_tc=0 [4467892224][SQLGetStmtAttrW][4467892224]StartRollbackState:0x7f8555001e00->internal=0 [4467892224]PGAPI_GetStmtAttr Handle=0x7f8555001e00 10011 [4467892224]DiscardStatementSvp:0x7f8555001e00->accessed=0 is_in=0 is_rb=1 is_tc=0 [4467892224][SQLGetStmtAttrW][4467892224]StartRollbackState:0x7f8555001e00->internal=0 [4467892224]PGAPI_GetStmtAttr Handle=0x7f8555001e00 10012 [4467892224]DiscardStatementSvp:0x7f8555001e00->accessed=0 is_in=0 is_rb=1 is_tc=0 [4467892224][SQLGetStmtAttrW][4467892224]StartRollbackState:0x7f8555001e00->internal=0 [4467892224]PGAPI_GetStmtAttr Handle=0x7f8555001e00 10013 [4467892224]DiscardStatementSvp:0x7f8555001e00->accessed=0 is_in=0 is_rb=1 is_tc=0 [4467892224][SQLPrepareW][4467892224]StartRollbackState:0x7f8555001e00->internal=0 [4467892224]PGAPI_Prepare: entering... [4467892224]**** PGAPI_Prepare: STMT_ALLOCATED, copy [4467892224]malloc size=31 [4467892224]str=0x7f8552ed06f0 [4467892224]SQLPrepare return=0 [4467892224]DiscardStatementSvp:0x7f8555001e00->accessed=0 is_in=0 is_rb=1 is_tc=0 [4467892224][SQLExecute][4467892224]StartRollbackState:0x7f8555001e00->internal=0 [4467892224]PGAPI_Execute: entering...1 [4467892224]PGAPI_Execute: clear errors... [4467892224]PGAPI_NumParams: entering... [4467892224]num_params=-1,-1 [4467892224]SC_scanQueryAndCountParams: entering... [4467892224]num_params=0,0 [4467892224]prepareParameters was not called, prepare state:7 [4467892224]SC_recycle_statement: self= 0x7f8555001e00 [4467892224]SC_clear_parse_status [4467892224]0x7f8555001e00->SC_set_rowstart -1->-1(unknown) [4467892224]:stmt result=-1 [4467892224]SC_recycle_statement statement=0x7f8555001e00 ommitted=0 [4467892224]PDATA_free_params: ENTER, self=0x7f85550020e0 [4467892224]Exec_with_parameters_resolved: copying statement params: trans_status=1, len=31, stmt='DROP TABLE "#Tableau_1_Connect"' [4467892224]*** ENTER_CONN_CS [140210608634616] *** [4467892224]prepare_before_exec=1 srv=1 [4467892224]copy_statement_with_parameters: enter prepared=0 [4467892224]prep_params [4467892224]SendParseRequest: plan_name=_PLAN0x7f8555001e00 query=DROP TABLE "#Tableau_1_Connect" [4467892224]*** ENTER_CONN_CS [140210608634616] *** [4467892224]SetStatementSvp:0x7f8555001e00->accessed=1 [4467892224]sta_pidx=0 end_pidx=-1 num_p=0 [4467892224]parse leng=54 [4467892224]SendDescribeRequest:plan_name=_PLAN0x7f8555001e00 [4467892224]describe leng=21 [4467892224]*** LEAVE_CONN_CS [140210608634616] *** [4467892224] stmt_with_params = '(null)' [4467892224]about to begin SC_execute [4467892224]SendBindRequest: plan_name=_PLAN0x7f8555001e00 [4467892224]num_params=0 proc_return=0 [4467892224]num_p=0 [4467892224]bind leng=50 [4467892224]SendExecuteRequest: plan_name=_PLAN0x7f8555001e00 count=0 [4467892224]execute leng=24 [4467892224]Close leng=21 [4467892224]get_Result=0x0 0x0 0 [4467892224]in QR_Constructor [4467892224]exit QR_Constructor [4467892224]read -1, global_socket_buffersize=4096 [4467892224]Lasterror=35 [4467892224]!!! poll ret=1 revents=1 [4467892224]read 49, global_socket_buffersize=4096 [4467892224]desc id=1[4467892224] response_length=0 [4467892224]desc id=t[4467892224] response_length=2 [4467892224]num_params=0 info=0 [4467892224]extend_iparameter_bindings: entering ... self=0x7f8555002018, parameters_allocated=0, num_params=0 [4467892224]exit extend_iparameter_bindings=0x0 [4467892224]desc id=n[4467892224] response_length=0 [4467892224]desc id=2[4467892224] response_length=0 [4467892224]desc id=C[4467892224] response_length=11 [4467892224]command response=DROP TABLE [4467892224]desc id=3[4467892224] response_length=0 [4467892224]desc id=Z[4467892224] response_length=1 [4467892224]*** LEAVE_CONN_CS [140210608634616] *** [4467892224]0x7f8555001e00->SC_set_rowstart -1->-1(unknown) [4467892224]:stmt result=-1 [4467892224]!!0x7f8555001e00->SC_is_concat_pre=8 res=0x7f85550022c0 [4467892224]SC_set_Result(55001e00, 550022c0)[4467892224]QResult: enter DESTRUCTOR [4467892224]*** LEAVE_CONN_CS [140210608634616] *** [4467892224]retval=0 [4467892224]DiscardStatementSvp:0x7f8555001e00->accessed=1 is_in=0 is_rb=1 is_tc=0 [4467892224]*** LEAVE_CONN_CS [140210608634616] *** [4467892224][SQLNumResultCols][4467892224]StartRollbackState:0x7f8555001e00->internal=0 [4467892224]PGAPI_NumResultCols: entering... [4467892224]SC_pre_execute: status = 3 [4467892224]PGAPI_NumResultCols: result = 0x7f85550022c0, status = 3, numcols = 0 [4467892224]DiscardStatementSvp:0x7f8555001e00->accessed=0 is_in=0 is_rb=1 is_tc=0 [140735257568016][[SQLFreeHandle]][140735257568016]*** ENTER_CONN_CS [140210608634616] *** [140735257568016]PGAPI_FreeStmt: entering...hstmt=0x7f8555001e00, fOption=1 [140735257568016]QResult: enter DESTRUCTOR [140735257568016]QResult: in QR_close_result [140735257568016]QResult: free memory in, fcount=0 [140735257568016]QResult: free memory out [140735257568016]QResult: exit close_result [140735257568016]QResult: exit DESTRUCTOR [140735257568016]SC_init_Result(55001e00)[140735257568016]SC_Destructor: self=0x7f8555001e00, self->result=0x0, self->hdbc=0x7f8553857000 [140735257568016]*** ENTER_CONN_CS [140210608634616] *** [140735257568016]CC_send_query: conn=0x7f8553857000, query='DEALLOCATE "_PLAN0x7f8555001e00"' [140735257568016]leng=33 [140735257568016]send_query: done sending query 38bytes flushed [140735257568016]in QR_Constructor [140735257568016]exit QR_Constructor [140735257568016]read -1, global_socket_buffersize=4096 [140735257568016]Lasterror=35 [140735257568016]!!! poll ret=1 revents=1 [140735257568016]read 22, global_socket_buffersize=4096 [140735257568016]send_query: got id = 'C' [140735257568016]send_query response_length=11 [140735257568016]send_query: ok - 'C' - DEALLOCATE [140735257568016]send_query: setting cmdbuffer = 'DEALLOCATE' [140735257568016]send_query: returning res = 0x7f85550022c0 [140735257568016]send_query: got id = 'Z' [140735257568016]send_query response_length=1 [140735257568016]*** LEAVE_CONN_CS [140210608634616] *** [140735257568016]QResult: enter DESTRUCTOR [140735257568016]QResult: in QR_close_result [140735257568016]QResult: free memory in, fcount=0 [140735257568016]QResult: free memory out [140735257568016]QResult: exit close_result [140735257568016]QResult: exit DESTRUCTOR [140735257568016]*** LEAVE_CONN_CS [140210608634616] *** [140735257568016]ARDFields_free 0x7f8555001ee0 bookmark=0x7f8552ebd370[140735257568016] hey[140735257568016]ARD_unbind_cols freeall=1 allocated=0 bindings=0x0[140735257568016]APD_free_params: ENTER, self=0x7f8555001fa8 [140735257568016]IPD_free_params: ENTER, self=0x7f8555002018 [140735257568016]GDATA_unbind_cols freeall=1 allocated=0 gdata=0x0[140735257568016]PDATA_free_params: ENTER, self=0x7f85550020e0 [140735257568016]SC_Destructor: EXIT [140735257568016]*** LEAVE_CONN_CS [140210608634616] *** [140735257568016][SQLGetConnectAttrW][140735257568016]*** ENTER_CONN_CS [140210608634616] *** [140735257568016]PGAPI_GetConnectAttr 1209 [140735257568016]*** LEAVE_CONN_CS [140210608634616] *** [140735257568016][SQLGetConnectAttrW][140735257568016]*** ENTER_CONN_CS [140210608634616] *** [140735257568016]PGAPI_GetConnectAttr 1209 [140735257568016]*** LEAVE_CONN_CS [140210608634616] *** [140735257568016][SQLGetConnectAttrW][140735257568016]*** ENTER_CONN_CS [140210608634616] *** [140735257568016]PGAPI_GetConnectAttr 1209 [140735257568016]*** LEAVE_CONN_CS [140210608634616] *** [140735257568016][SQLGetConnectAttrW][140735257568016]*** ENTER_CONN_CS [140210608634616] *** [140735257568016]PGAPI_GetConnectAttr 1209 [140735257568016]*** LEAVE_CONN_CS [140210608634616] *** [4468428800][[SQLAllocHandle]][4468428800]*** ENTER_CONN_CS [140210608634616] *** [4468428800]PGAPI_AllocStmt: entering... [4468428800]0x7f8552f3bcb0->SC_set_rowstart 0->-1(unknown) [4468428800]:stmt result=-1 [4468428800]**** PGAPI_AllocStmt: hdbc = 0x7f8553857000, stmt = 0x7f8552f3bcb0 [4468428800]CC_add_statement: self=0x7f8553857000, stmt=0x7f8552f3bcb0 [4468428800]*** LEAVE_CONN_CS [140210608634616] *** [4468428800][SQLGetStmtAttrW][4468428800]StartRollbackState:0x7f8552f3bcb0->internal=0 [4468428800]PGAPI_GetStmtAttr Handle=0x7f8552f3bcb0 10010 [4468428800]DiscardStatementSvp:0x7f8552f3bcb0->accessed=0 is_in=0 is_rb=1 is_tc=0 [4468428800][SQLGetStmtAttrW][4468428800]StartRollbackState:0x7f8552f3bcb0->internal=0 [4468428800]PGAPI_GetStmtAttr Handle=0x7f8552f3bcb0 10011 [4468428800]DiscardStatementSvp:0x7f8552f3bcb0->accessed=0 is_in=0 is_rb=1 is_tc=0 [4468428800][SQLGetStmtAttrW][4468428800]StartRollbackState:0x7f8552f3bcb0->internal=0 [4468428800]PGAPI_GetStmtAttr Handle=0x7f8552f3bcb0 10012 [4468428800]DiscardStatementSvp:0x7f8552f3bcb0->accessed=0 is_in=0 is_rb=1 is_tc=0 [4468428800][SQLGetStmtAttrW][4468428800]StartRollbackState:0x7f8552f3bcb0->internal=0 [4468428800]PGAPI_GetStmtAttr Handle=0x7f8552f3bcb0 10013 [4468428800]DiscardStatementSvp:0x7f8552f3bcb0->accessed=0 is_in=0 is_rb=1 is_tc=0 [4468428800][SQLPrepareW][4468428800]StartRollbackState:0x7f8552f3bcb0->internal=0 [4468428800]PGAPI_Prepare: entering... [4468428800]**** PGAPI_Prepare: STMT_ALLOCATED, copy [4468428800]malloc size=93 [4468428800]str=0x7f8552f2c420 [4468428800]SQLPrepare return=0 [4468428800]DiscardStatementSvp:0x7f8552f3bcb0->accessed=0 is_in=0 is_rb=1 is_tc=0 [4468428800][SQLExecute][4468428800]StartRollbackState:0x7f8552f3bcb0->internal=0 [4468428800]PGAPI_Execute: entering...1 [4468428800]PGAPI_Execute: clear errors... [4468428800]PGAPI_NumParams: entering... [4468428800]num_params=-1,-1 [4468428800]SC_scanQueryAndCountParams: entering... [4468428800]num_params=0,0 [4468428800]prepareParameters was not called, prepare state:7 [4468428800]SC_recycle_statement: self= 0x7f8552f3bcb0 [4468428800]SC_clear_parse_status [4468428800]0x7f8552f3bcb0->SC_set_rowstart -1->-1(unknown) [4468428800]:stmt result=-1 [4468428800]SC_recycle_statement statement=0x7f8552f3bcb0 ommitted=0 [4468428800]PDATA_free_params: ENTER, self=0x7f8552f3bf90 [4468428800]Exec_with_parameters_resolved: copying statement params: trans_status=1, len=93, stmt='CREATE LOCAL TEMPORARY TABLE "#Tableau_2_Connect" ( "COL" INTEGER ) ON COMMIT PRESERVE ROWS' [4468428800]*** ENTER_CONN_CS [140210608634616] *** [4468428800]prepare_before_exec=1 srv=1 [4468428800]copy_statement_with_parameters: enter prepared=0 [4468428800]prep_params [4468428800]SendParseRequest: plan_name=_PLAN0x7f8552f3bcb0 query=CREATE LOCAL TEMPORARY TABLE "#Tableau_2_Connect" ( "COL" INTEGER ) ON COMMIT PRESERVE ROWS [4468428800]*** ENTER_CONN_CS [140210608634616] *** [4468428800]SetStatementSvp:0x7f8552f3bcb0->accessed=1 [4468428800]sta_pidx=0 end_pidx=-1 num_p=0 [4468428800]parse leng=116 [4468428800]SendDescribeRequest:plan_name=_PLAN0x7f8552f3bcb0 [4468428800]describe leng=21 [4468428800]*** LEAVE_CONN_CS [140210608634616] *** [4468428800] stmt_with_params = '(null)' [4468428800]about to begin SC_execute [4468428800]SendBindRequest: plan_name=_PLAN0x7f8552f3bcb0 [4468428800]num_params=0 proc_return=0 [4468428800]num_p=0 [4468428800]bind leng=50 [4468428800]SendExecuteRequest: plan_name=_PLAN0x7f8552f3bcb0 count=0 [4468428800]execute leng=24 [4468428800]Close leng=21 [4468428800]get_Result=0x0 0x0 0 [4468428800]in QR_Constructor [4468428800]exit QR_Constructor [4468428800]read -1, global_socket_buffersize=4096 [4468428800]Lasterror=35 [4468428800]!!! poll ret=1 revents=1 [4468428800]read 51, global_socket_buffersize=4096 [4468428800]desc id=1[4468428800] response_length=0 [4468428800]desc id=t[4468428800] response_length=2 [4468428800]num_params=0 info=0 [4468428800]extend_iparameter_bindings: entering ... self=0x7f8552f3bec8, parameters_allocated=0, num_params=0 [4468428800]exit extend_iparameter_bindings=0x0 [4468428800]desc id=n[4468428800] response_length=0 [4468428800]desc id=2[4468428800] response_length=0 [4468428800]desc id=C[4468428800] response_length=13 [4468428800]command response=CREATE TABLE [4468428800]desc id=3[4468428800] response_length=0 [4468428800]desc id=Z[4468428800] response_length=1 [4468428800]*** LEAVE_CONN_CS [140210608634616] *** [4468428800]0x7f8552f3bcb0->SC_set_rowstart -1->-1(unknown) [4468428800]:stmt result=-1 [4468428800]!!0x7f8552f3bcb0->SC_is_concat_pre=8 res=0x7f8552f11630 [4468428800]SC_set_Result(52f3bcb0, 52f11630)[4468428800]QResult: enter DESTRUCTOR [4468428800]*** LEAVE_CONN_CS [140210608634616] *** [4468428800]retval=0 [4468428800]DiscardStatementSvp:0x7f8552f3bcb0->accessed=1 is_in=0 is_rb=1 is_tc=0 [4468428800]*** LEAVE_CONN_CS [140210608634616] *** [4468428800][SQLNumResultCols][4468428800]StartRollbackState:0x7f8552f3bcb0->internal=0 [4468428800]PGAPI_NumResultCols: entering... [4468428800]SC_pre_execute: status = 3 [4468428800]PGAPI_NumResultCols: result = 0x7f8552f11630, status = 3, numcols = 0 [4468428800]DiscardStatementSvp:0x7f8552f3bcb0->accessed=0 is_in=0 is_rb=1 is_tc=0 [140735257568016][[SQLFreeHandle]][140735257568016]*** ENTER_CONN_CS [140210608634616] *** [140735257568016]PGAPI_FreeStmt: entering...hstmt=0x7f8552f3bcb0, fOption=1 [140735257568016]QResult: enter DESTRUCTOR [140735257568016]QResult: in QR_close_result [140735257568016]QResult: free memory in, fcount=0 [140735257568016]QResult: free memory out [140735257568016]QResult: exit close_result [140735257568016]QResult: exit DESTRUCTOR [140735257568016]SC_init_Result(52f3bcb0)[140735257568016]SC_Destructor: self=0x7f8552f3bcb0, self->result=0x0, self->hdbc=0x7f8553857000 [140735257568016]*** ENTER_CONN_CS [140210608634616] *** [140735257568016]CC_send_query: conn=0x7f8553857000, query='DEALLOCATE "_PLAN0x7f8552f3bcb0"' [140735257568016]leng=33 [140735257568016]send_query: done sending query 38bytes flushed [140735257568016]in QR_Constructor [140735257568016]exit QR_Constructor [140735257568016]read -1, global_socket_buffersize=4096 [140735257568016]Lasterror=35 [140735257568016]!!! poll ret=1 revents=1 [140735257568016]read 22, global_socket_buffersize=4096 [140735257568016]send_query: got id = 'C' [140735257568016]send_query response_length=11 [140735257568016]send_query: ok - 'C' - DEALLOCATE [140735257568016]send_query: setting cmdbuffer = 'DEALLOCATE' [140735257568016]send_query: returning res = 0x7f8552f11630 [140735257568016]send_query: got id = 'Z' [140735257568016]send_query response_length=1 [140735257568016]*** LEAVE_CONN_CS [140210608634616] *** [140735257568016]QResult: enter DESTRUCTOR [140735257568016]QResult: in QR_close_result [140735257568016]QResult: free memory in, fcount=0 [140735257568016]QResult: free memory out [140735257568016]QResult: exit close_result [140735257568016]QResult: exit DESTRUCTOR [140735257568016]*** LEAVE_CONN_CS [140210608634616] *** [140735257568016]ARDFields_free 0x7f8552f3bd90 bookmark=0x7f8552f1b000[140735257568016] hey[140735257568016]ARD_unbind_cols freeall=1 allocated=0 bindings=0x0[140735257568016]APD_free_params: ENTER, self=0x7f8552f3be58 [140735257568016]IPD_free_params: ENTER, self=0x7f8552f3bec8 [140735257568016]GDATA_unbind_cols freeall=1 allocated=0 gdata=0x0[140735257568016]PDATA_free_params: ENTER, self=0x7f8552f3bf90 [140735257568016]SC_Destructor: EXIT [140735257568016]*** LEAVE_CONN_CS [140210608634616] *** [140735257568016][SQLGetConnectAttrW][140735257568016]*** ENTER_CONN_CS [140210608634616] *** [140735257568016]PGAPI_GetConnectAttr 1209 [140735257568016]*** LEAVE_CONN_CS [140210608634616] *** [140735257568016][SQLGetConnectAttrW][140735257568016]*** ENTER_CONN_CS [140210608634616] *** [140735257568016]PGAPI_GetConnectAttr 1209 [140735257568016]*** LEAVE_CONN_CS [140210608634616] *** [140735257568016][SQLGetConnectAttrW][140735257568016]*** ENTER_CONN_CS [140210608634616] *** [140735257568016]PGAPI_GetConnectAttr 102 [140735257568016]PGAPI_GetConnectOption: entering... [140735257568016]*** LEAVE_CONN_CS [140210608634616] *** [140735257568016][SQLSetConnectAttrW][140735257568016]*** ENTER_CONN_CS [140210608634616] *** [140735257568016]PGAPI_SetConnectAttr for 0x7f8553857000: 102 0x0 [140735257568016]PGAPI_SetConnectOption: entering fOption = 102 vParam = 0 [140735257568016]PGAPI_SetConnectOption: AUTOCOMMIT: transact_status=1, vparam=0 [140735257568016]CC_set_autocommit: 1->0 [140735257568016]*** LEAVE_CONN_CS [140210608634616] *** [140735257568016][SQLGetConnectAttrW][140735257568016]*** ENTER_CONN_CS [140210608634616] *** [140735257568016]PGAPI_GetConnectAttr 102 [140735257568016]PGAPI_GetConnectOption: entering... [140735257568016]*** LEAVE_CONN_CS [140210608634616] *** [140735257568016][SQLGetConnectAttrW][140735257568016]*** ENTER_CONN_CS [140210608634616] *** [140735257568016]PGAPI_GetConnectAttr 1209 [140735257568016]*** LEAVE_CONN_CS [140210608634616] *** [4468965376][[SQLAllocHandle]][4468965376]*** ENTER_CONN_CS [140210608634616] *** [4468965376]PGAPI_AllocStmt: entering... [4468965376]0x7f8552c26760->SC_set_rowstart 0->-1(unknown) [4468965376]:stmt result=-1 [4468965376]**** PGAPI_AllocStmt: hdbc = 0x7f8553857000, stmt = 0x7f8552c26760 [4468965376]CC_add_statement: self=0x7f8553857000, stmt=0x7f8552c26760 [4468965376]*** LEAVE_CONN_CS [140210608634616] *** [4468965376][SQLGetStmtAttrW][4468965376]StartRollbackState:0x7f8552c26760->internal=0 [4468965376]PGAPI_GetStmtAttr Handle=0x7f8552c26760 10010 [4468965376]DiscardStatementSvp:0x7f8552c26760->accessed=0 is_in=0 is_rb=1 is_tc=0 [4468965376][SQLGetStmtAttrW][4468965376]StartRollbackState:0x7f8552c26760->internal=0 [4468965376]PGAPI_GetStmtAttr Handle=0x7f8552c26760 10011 [4468965376]DiscardStatementSvp:0x7f8552c26760->accessed=0 is_in=0 is_rb=1 is_tc=0 [4468965376][SQLGetStmtAttrW][4468965376]StartRollbackState:0x7f8552c26760->internal=0 [4468965376]PGAPI_GetStmtAttr Handle=0x7f8552c26760 10012 [4468965376]DiscardStatementSvp:0x7f8552c26760->accessed=0 is_in=0 is_rb=1 is_tc=0 [4468965376][SQLGetStmtAttrW][4468965376]StartRollbackState:0x7f8552c26760->internal=0 [4468965376]PGAPI_GetStmtAttr Handle=0x7f8552c26760 10013 [4468965376]DiscardStatementSvp:0x7f8552c26760->accessed=0 is_in=0 is_rb=1 is_tc=0 [4468965376][SQLPrepareW][4468965376]StartRollbackState:0x7f8552c26760->internal=0 [4468965376]PGAPI_Prepare: entering... [4468965376]**** PGAPI_Prepare: STMT_ALLOCATED, copy [4468965376]malloc size=51 [4468965376]str=0x7f8552c26e60 [4468965376]SQLPrepare return=0 [4468965376]DiscardStatementSvp:0x7f8552c26760->accessed=0 is_in=0 is_rb=1 is_tc=0 [4468965376][SQLExecute][4468965376]StartRollbackState:0x7f8552c26760->internal=0 [4468965376]PGAPI_Execute: entering...1 [4468965376]PGAPI_Execute: clear errors... [4468965376]PGAPI_NumParams: entering... [4468965376]num_params=-1,-1 [4468965376]SC_scanQueryAndCountParams: entering... [4468965376]num_params=0,0 [4468965376]prepareParameters was not called, prepare state:7 [4468965376]SC_recycle_statement: self= 0x7f8552c26760 [4468965376]SC_clear_parse_status [4468965376]0x7f8552c26760->SC_set_rowstart -1->-1(unknown) [4468965376]:stmt result=-1 [4468965376]SC_recycle_statement statement=0x7f8552c26760 ommitted=0 [4468965376]PDATA_free_params: ENTER, self=0x7f8552c26a40 [4468965376]Exec_with_parameters_resolved: copying statement params: trans_status=0, len=51, stmt='INSERT INTO "#Tableau_2_Connect" ("COL") VALUES (1)' [4468965376]*** ENTER_CONN_CS [140210608634616] *** [4468965376]prepare_before_exec=1 srv=1 [4468965376]copy_statement_with_parameters: enter prepared=0 [4468965376]prep_params [4468965376]SendParseRequest: plan_name=_PLAN0x7f8552c26760 query=INSERT INTO "#Tableau_2_Connect" ("COL") VALUES (1) [4468965376]*** ENTER_CONN_CS [140210608634616] *** [4468965376]SetStatementSvp:0x7f8552c26760->accessed=1 [4468965376]CC_send_query: conn=0x7f8553857000, query='BEGIN' [4468965376]leng=6 [4468965376]send_query: done sending query 11bytes flushed [4468965376]in QR_Constructor [4468965376]exit QR_Constructor [4468965376]read -1, global_socket_buffersize=4096 [4468965376]Lasterror=35 [4468965376]!!! poll ret=1 revents=1 [4468965376]read 17, global_socket_buffersize=4096 [4468965376]send_query: got id = 'C' [4468965376]send_query response_length=6 [4468965376]send_query: ok - 'C' - BEGIN [4468965376]send_query: setting cmdbuffer = 'BEGIN' [4468965376]send_query: returning res = 0x7f8552c26c20 [4468965376]send_query: got id = 'Z' [4468965376]send_query response_length=1 [4468965376]*** LEAVE_CONN_CS [140210608634616] *** [4468965376]CC_begin: sending BEGIN! [4468965376]QResult: enter DESTRUCTOR [4468965376]QResult: in QR_close_result [4468965376]QResult: free memory in, fcount=0 [4468965376]QResult: free memory out [4468965376]QResult: exit close_result [4468965376]QResult: exit DESTRUCTOR [4468965376]sta_pidx=0 end_pidx=-1 num_p=0 [4468965376]parse leng=74 [4468965376]SendDescribeRequest:plan_name=_PLAN0x7f8552c26760 [4468965376]describe leng=21 [4468965376]*** LEAVE_CONN_CS [140210608634616] *** [4468965376] stmt_with_params = '(null)' [4468965376]about to begin SC_execute [4468965376]SendBindRequest: plan_name=_PLAN0x7f8552c26760 [4468965376]num_params=0 proc_return=0 [4468965376]num_p=0 [4468965376]bind leng=50 [4468965376]SendExecuteRequest: plan_name=_PLAN0x7f8552c26760 count=0 [4468965376]execute leng=24 [4468965376]Close leng=21 [4468965376]get_Result=0x0 0x0 0 [4468965376]in QR_Constructor [4468965376]exit QR_Constructor [4468965376]read -1, global_socket_buffersize=4096 [4468965376]Lasterror=35 [4468965376]!!! poll ret=1 revents=1 [4468965376]read 49, global_socket_buffersize=4096 [4468965376]desc id=1[4468965376] response_length=0 [4468965376]desc id=t[4468965376] response_length=2 [4468965376]num_params=0 info=0 [4468965376]extend_iparameter_bindings: entering ... self=0x7f8552c26978, parameters_allocated=0, num_params=0 [4468965376]exit extend_iparameter_bindings=0x0 [4468965376]desc id=n[4468965376] response_length=0 [4468965376]desc id=2[4468965376] response_length=0 [4468965376]desc id=C[4468965376] response_length=11 [4468965376]command response=INSERT 0 1 [4468965376]desc id=3[4468965376] response_length=0 [4468965376]desc id=Z[4468965376] response_length=1 [4468965376]*** LEAVE_CONN_CS [140210608634616] *** [4468965376]0x7f8552c26760->SC_set_rowstart -1->-1(unknown) [4468965376]:stmt result=-1 [4468965376]!!0x7f8552c26760->SC_is_concat_pre=8 res=0x7f8552f36cc0 [4468965376]SC_set_Result(52c26760, 52f36cc0)[4468965376]QResult: enter DESTRUCTOR [4468965376]*** LEAVE_CONN_CS [140210608634616] *** [4468965376]retval=0 [4468965376]DiscardStatementSvp:0x7f8552c26760->accessed=1 is_in=1 is_rb=1 is_tc=0 [4468965376]ret=0 [4468965376]*** LEAVE_CONN_CS [140210608634616] *** [4468965376][SQLNumResultCols][4468965376]StartRollbackState:0x7f8552c26760->internal=0 [4468965376]PGAPI_NumResultCols: entering... [4468965376]SC_pre_execute: status = 3 [4468965376]PGAPI_NumResultCols: result = 0x7f8552f36cc0, status = 3, numcols = 0 [4468965376]DiscardStatementSvp:0x7f8552c26760->accessed=0 is_in=1 is_rb=1 is_tc=0 [140735257568016][[SQLFreeHandle]][140735257568016]*** ENTER_CONN_CS [140210608634616] *** [140735257568016]PGAPI_FreeStmt: entering...hstmt=0x7f8552c26760, fOption=1 [140735257568016]QResult: enter DESTRUCTOR [140735257568016]QResult: in QR_close_result [140735257568016]QResult: free memory in, fcount=0 [140735257568016]QResult: free memory out [140735257568016]QResult: exit close_result [140735257568016]QResult: exit DESTRUCTOR [140735257568016]SC_init_Result(52c26760)[140735257568016]SC_Destructor: self=0x7f8552c26760, self->result=0x0, self->hdbc=0x7f8553857000 [140735257568016]*** ENTER_CONN_CS [140210608634616] *** [140735257568016]CC_send_query: conn=0x7f8553857000, query='DEALLOCATE "_PLAN0x7f8552c26760"' [140735257568016]leng=83 [140735257568016]send_query: done sending query 88bytes flushed [140735257568016]in QR_Constructor [140735257568016]exit QR_Constructor [140735257568016]read -1, global_socket_buffersize=4096 [140735257568016]Lasterror=35 [140735257568016]!!! poll ret=1 revents=1 [140735257568016]read 50, global_socket_buffersize=4096 [140735257568016]send_query: got id = 'C' [140735257568016]send_query response_length=10 [140735257568016]send_query: ok - 'C' - SAVEPOINT [140735257568016]send_query: setting cmdbuffer = 'SAVEPOINT' [140735257568016]Discarded the first SAVEPOINT [140735257568016]send_query: got id = 'C' [140735257568016]send_query response_length=11 [140735257568016]send_query: ok - 'C' - DEALLOCATE [140735257568016]send_query: setting cmdbuffer = 'DEALLOCATE' [140735257568016]send_query: returning res = 0x7f8552f36cc0 [140735257568016]send_query: got id = 'C' [140735257568016]send_query response_length=8 [140735257568016]send_query: ok - 'C' - RELEASE [140735257568016]in QR_Constructor [140735257568016]exit QR_Constructor [140735257568016]send_query: setting cmdbuffer = 'RELEASE' [140735257568016]send_query: returning res = 0x7f8552f3c9b0 [140735257568016]send_query: got id = 'Z' [140735257568016]send_query response_length=1 [140735257568016]*** LEAVE_CONN_CS [140210608634616] *** [140735257568016]QResult: enter DESTRUCTOR [140735257568016]QResult: in QR_close_result [140735257568016]QResult: free memory in, fcount=0 [140735257568016]QResult: free memory out [140735257568016]QResult: free memory in, fcount=0 [140735257568016]QResult: free memory out [140735257568016]QResult: exit close_result [140735257568016]QResult: exit DESTRUCTOR [140735257568016]*** LEAVE_CONN_CS [140210608634616] *** [140735257568016]ARDFields_free 0x7f8552c26840 bookmark=0x7f8552c259e0[140735257568016] hey[140735257568016]ARD_unbind_cols freeall=1 allocated=0 bindings=0x0[140735257568016]APD_free_params: ENTER, self=0x7f8552c26908 [140735257568016]IPD_free_params: ENTER, self=0x7f8552c26978 [140735257568016]GDATA_unbind_cols freeall=1 allocated=0 gdata=0x0[140735257568016]PDATA_free_params: ENTER, self=0x7f8552c26a40 [140735257568016]SC_Destructor: EXIT [140735257568016]*** LEAVE_CONN_CS [140210608634616] *** [140735257568016][SQLGetConnectAttrW][140735257568016]*** ENTER_CONN_CS [140210608634616] *** [140735257568016]PGAPI_GetConnectAttr 1209 [140735257568016]*** LEAVE_CONN_CS [140210608634616] *** [140735257568016][[SQLEndTran]][140735257568016]*** ENTER_CONN_CS [140210608634616] *** [140735257568016]entering PGAPI_Transact: hdbc=0x7f8553857000, henv=0x0 [140735257568016]PGAPI_Transact: sending on conn 0x7f8553857000 '0' [140735257568016]CC_send_query: conn=0x7f8553857000, query='COMMIT' [140735257568016]leng=7 [140735257568016]send_query: done sending query 12bytes flushed [140735257568016]in QR_Constructor [140735257568016]exit QR_Constructor [140735257568016]read -1, global_socket_buffersize=4096 [140735257568016]Lasterror=35 [140735257568016]!!! poll ret=1 revents=1 [140735257568016]read 18, global_socket_buffersize=4096 [140735257568016]send_query: got id = 'C' [140735257568016]send_query response_length=7 [140735257568016]send_query: ok - 'C' - COMMIT [140735257568016]send_query: setting cmdbuffer = 'COMMIT' [140735257568016]send_query: returning res = 0x7f8552ece580 [140735257568016]send_query: got id = 'Z' [140735257568016]send_query response_length=1 [140735257568016]*** LEAVE_CONN_CS [140210608634616] *** [140735257568016]CC_commit: sending COMMIT! [140735257568016]QResult: enter DESTRUCTOR [140735257568016]QResult: in QR_close_result [140735257568016]QResult: free memory in, fcount=0 [140735257568016]QResult: free memory out [140735257568016]QResult: exit close_result [140735257568016]QResult: exit DESTRUCTOR [140735257568016]*** LEAVE_CONN_CS [140210608634616] *** [140735257568016][SQLSetConnectAttrW][140735257568016]*** ENTER_CONN_CS [140210608634616] *** [140735257568016]PGAPI_SetConnectAttr for 0x7f8553857000: 102 0x1 [140735257568016]PGAPI_SetConnectOption: entering fOption = 102 vParam = 1 [140735257568016]PGAPI_SetConnectOption: AUTOCOMMIT: transact_status=0, vparam=1 [140735257568016]CC_set_autocommit: 0->1 [140735257568016]*** LEAVE_CONN_CS [140210608634616] *** [140735257568016][SQLGetConnectAttrW][140735257568016]*** ENTER_CONN_CS [140210608634616] *** [140735257568016]PGAPI_GetConnectAttr 1209 [140735257568016]*** LEAVE_CONN_CS [140210608634616] *** [140735257568016][SQLGetConnectAttrW][140735257568016]*** ENTER_CONN_CS [140210608634616] *** [140735257568016]PGAPI_GetConnectAttr 1209 [140735257568016]*** LEAVE_CONN_CS [140210608634616] *** [140735257568016][SQLGetConnectAttrW][140735257568016]*** ENTER_CONN_CS [140210608634616] *** [140735257568016]PGAPI_GetConnectAttr 1209 [140735257568016]*** LEAVE_CONN_CS [140210608634616] *** [4465209344][[SQLAllocHandle]][4465209344]*** ENTER_CONN_CS [140210608634616] *** [4465209344]PGAPI_AllocStmt: entering... [4465209344]0x7f8552f3bcb0->SC_set_rowstart 0->-1(unknown) [4465209344]:stmt result=-1 [4465209344]**** PGAPI_AllocStmt: hdbc = 0x7f8553857000, stmt = 0x7f8552f3bcb0 [4465209344]CC_add_statement: self=0x7f8553857000, stmt=0x7f8552f3bcb0 [4465209344]*** LEAVE_CONN_CS [140210608634616] *** [4465209344][SQLGetStmtAttrW][4465209344]StartRollbackState:0x7f8552f3bcb0->internal=0 [4465209344]PGAPI_GetStmtAttr Handle=0x7f8552f3bcb0 10010 [4465209344]DiscardStatementSvp:0x7f8552f3bcb0->accessed=0 is_in=0 is_rb=1 is_tc=0 [4465209344][SQLGetStmtAttrW][4465209344]StartRollbackState:0x7f8552f3bcb0->internal=0 [4465209344]PGAPI_GetStmtAttr Handle=0x7f8552f3bcb0 10011 [4465209344]DiscardStatementSvp:0x7f8552f3bcb0->accessed=0 is_in=0 is_rb=1 is_tc=0 [4465209344][SQLGetStmtAttrW][4465209344]StartRollbackState:0x7f8552f3bcb0->internal=0 [4465209344]PGAPI_GetStmtAttr Handle=0x7f8552f3bcb0 10012 [4465209344]DiscardStatementSvp:0x7f8552f3bcb0->accessed=0 is_in=0 is_rb=1 is_tc=0 [4465209344][SQLGetStmtAttrW][4465209344]StartRollbackState:0x7f8552f3bcb0->internal=0 [4465209344]PGAPI_GetStmtAttr Handle=0x7f8552f3bcb0 10013 [4465209344]DiscardStatementSvp:0x7f8552f3bcb0->accessed=0 is_in=0 is_rb=1 is_tc=0 [4465209344][SQLPrepareW][4465209344]StartRollbackState:0x7f8552f3bcb0->internal=0 [4465209344]PGAPI_Prepare: entering... [4465209344]**** PGAPI_Prepare: STMT_ALLOCATED, copy [4465209344]malloc size=74 [4465209344]str=0x7f8552f1ce50 [4465209344]SQLPrepare return=0 [4465209344]DiscardStatementSvp:0x7f8552f3bcb0->accessed=0 is_in=0 is_rb=1 is_tc=0 [4465209344][SQLExecute][4465209344]StartRollbackState:0x7f8552f3bcb0->internal=0 [4465209344]PGAPI_Execute: entering...1 [4465209344]PGAPI_Execute: clear errors... [4465209344]PGAPI_NumParams: entering... [4465209344]num_params=-1,-1 [4465209344]SC_scanQueryAndCountParams: entering... [4465209344]num_params=0,0 [4465209344]prepareParameters was not called, prepare state:7 [4465209344]SC_recycle_statement: self= 0x7f8552f3bcb0 [4465209344]SC_clear_parse_status [4465209344]0x7f8552f3bcb0->SC_set_rowstart -1->-1(unknown) [4465209344]:stmt result=-1 [4465209344]SC_recycle_statement statement=0x7f8552f3bcb0 ommitted=0 [4465209344]PDATA_free_params: ENTER, self=0x7f8552f3bf90 [4465209344]Exec_with_parameters_resolved: copying statement params: trans_status=1, len=74, stmt='CREATE INDEX "_tidx_#Tableau_2_Connect_1a" ON "#Tableau_2_Connect" ("COL")' [4465209344]*** ENTER_CONN_CS [140210608634616] *** [4465209344]prepare_before_exec=1 srv=1 [4465209344]copy_statement_with_parameters: enter prepared=0 [4465209344]prep_params [4465209344]SendParseRequest: plan_name=_PLAN0x7f8552f3bcb0 query=CREATE INDEX "_tidx_#Tableau_2_Connect_1a" ON "#Tableau_2_Connect" ("COL") [4465209344]*** ENTER_CONN_CS [140210608634616] *** [4465209344]SetStatementSvp:0x7f8552f3bcb0->accessed=1 [4465209344]sta_pidx=0 end_pidx=-1 num_p=0 [4465209344]parse leng=97 [4465209344]SendDescribeRequest:plan_name=_PLAN0x7f8552f3bcb0 [4465209344]describe leng=21 [4465209344]*** LEAVE_CONN_CS [140210608634616] *** [4465209344] stmt_with_params = '(null)' [4465209344]about to begin SC_execute [4465209344]SendBindRequest: plan_name=_PLAN0x7f8552f3bcb0 [4465209344]num_params=0 proc_return=0 [4465209344]num_p=0 [4465209344]bind leng=50 [4465209344]SendExecuteRequest: plan_name=_PLAN0x7f8552f3bcb0 count=0 [4465209344]execute leng=24 [4465209344]Close leng=21 [4465209344]get_Result=0x0 0x0 0 [4465209344]in QR_Constructor [4465209344]exit QR_Constructor [4465209344]read -1, global_socket_buffersize=4096 [4465209344]Lasterror=35 [4465209344]!!! poll ret=1 revents=1 [4465209344]read 51, global_socket_buffersize=4096 [4465209344]desc id=1[4465209344] response_length=0 [4465209344]desc id=t[4465209344] response_length=2 [4465209344]num_params=0 info=0 [4465209344]extend_iparameter_bindings: entering ... self=0x7f8552f3bec8, parameters_allocated=0, num_params=0 [4465209344]exit extend_iparameter_bindings=0x0 [4465209344]desc id=n[4465209344] response_length=0 [4465209344]desc id=2[4465209344] response_length=0 [4465209344]desc id=C[4465209344] response_length=13 [4465209344]command response=CREATE INDEX [4465209344]desc id=3[4465209344] response_length=0 [4465209344]desc id=Z[4465209344] response_length=1 [4465209344]*** LEAVE_CONN_CS [140210608634616] *** [4465209344]0x7f8552f3bcb0->SC_set_rowstart -1->-1(unknown) [4465209344]:stmt result=-1 [4465209344]!!0x7f8552f3bcb0->SC_is_concat_pre=8 res=0x7f8552f2c820 [4465209344]SC_set_Result(52f3bcb0, 52f2c820)[4465209344]QResult: enter DESTRUCTOR [4465209344]*** LEAVE_CONN_CS [140210608634616] *** [4465209344]retval=0 [4465209344]DiscardStatementSvp:0x7f8552f3bcb0->accessed=1 is_in=0 is_rb=1 is_tc=0 [4465209344]*** LEAVE_CONN_CS [140210608634616] *** [4465209344][SQLNumResultCols][4465209344]StartRollbackState:0x7f8552f3bcb0->internal=0 [4465209344]PGAPI_NumResultCols: entering... [4465209344]SC_pre_execute: status = 3 [4465209344]PGAPI_NumResultCols: result = 0x7f8552f2c820, status = 3, numcols = 0 [4465209344]DiscardStatementSvp:0x7f8552f3bcb0->accessed=0 is_in=0 is_rb=1 is_tc=0 [140735257568016][[SQLFreeHandle]][140735257568016]*** ENTER_CONN_CS [140210608634616] *** [140735257568016]PGAPI_FreeStmt: entering...hstmt=0x7f8552f3bcb0, fOption=1 [140735257568016]QResult: enter DESTRUCTOR [140735257568016]QResult: in QR_close_result [140735257568016]QResult: free memory in, fcount=0 [140735257568016]QResult: free memory out [140735257568016]QResult: exit close_result [140735257568016]QResult: exit DESTRUCTOR [140735257568016]SC_init_Result(52f3bcb0)[140735257568016]SC_Destructor: self=0x7f8552f3bcb0, self->result=0x0, self->hdbc=0x7f8553857000 [140735257568016]*** ENTER_CONN_CS [140210608634616] *** [140735257568016]CC_send_query: conn=0x7f8553857000, query='DEALLOCATE "_PLAN0x7f8552f3bcb0"' [140735257568016]leng=33 [140735257568016]send_query: done sending query 38bytes flushed [140735257568016]in QR_Constructor [140735257568016]exit QR_Constructor [140735257568016]read -1, global_socket_buffersize=4096 [140735257568016]Lasterror=35 [140735257568016]!!! poll ret=1 revents=1 [140735257568016]read 22, global_socket_buffersize=4096 [140735257568016]send_query: got id = 'C' [140735257568016]send_query response_length=11 [140735257568016]send_query: ok - 'C' - DEALLOCATE [140735257568016]send_query: setting cmdbuffer = 'DEALLOCATE' [140735257568016]send_query: returning res = 0x7f8552c25460 [140735257568016]send_query: got id = 'Z' [140735257568016]send_query response_length=1 [140735257568016]*** LEAVE_CONN_CS [140210608634616] *** [140735257568016]QResult: enter DESTRUCTOR [140735257568016]QResult: in QR_close_result [140735257568016]QResult: free memory in, fcount=0 [140735257568016]QResult: free memory out [140735257568016]QResult: exit close_result [140735257568016]QResult: exit DESTRUCTOR [140735257568016]*** LEAVE_CONN_CS [140210608634616] *** [140735257568016]ARDFields_free 0x7f8552f3bd90 bookmark=0x7f8552f30e20[140735257568016] hey[140735257568016]ARD_unbind_cols freeall=1 allocated=0 bindings=0x0[140735257568016]APD_free_params: ENTER, self=0x7f8552f3be58 [140735257568016]IPD_free_params: ENTER, self=0x7f8552f3bec8 [140735257568016]GDATA_unbind_cols freeall=1 allocated=0 gdata=0x0[140735257568016]PDATA_free_params: ENTER, self=0x7f8552f3bf90 [140735257568016]SC_Destructor: EXIT [140735257568016]*** LEAVE_CONN_CS [140210608634616] *** [140735257568016][SQLGetConnectAttrW][140735257568016]*** ENTER_CONN_CS [140210608634616] *** [140735257568016]PGAPI_GetConnectAttr 1209 [140735257568016]*** LEAVE_CONN_CS [140210608634616] *** [140735257568016][SQLGetConnectAttrW][140735257568016]*** ENTER_CONN_CS [140210608634616] *** [140735257568016]PGAPI_GetConnectAttr 1209 [140735257568016]*** LEAVE_CONN_CS [140210608634616] *** [140735257568016][SQLGetConnectAttrW][140735257568016]*** ENTER_CONN_CS [140210608634616] *** [140735257568016]PGAPI_GetConnectAttr 1209 [140735257568016]*** LEAVE_CONN_CS [140210608634616] *** [4465745920][[SQLAllocHandle]][4465745920]*** ENTER_CONN_CS [140210608634616] *** [4465745920]PGAPI_AllocStmt: entering... [4465745920]0x7f8552f3bcb0->SC_set_rowstart 0->-1(unknown) [4465745920]:stmt result=-1 [4465745920]**** PGAPI_AllocStmt: hdbc = 0x7f8553857000, stmt = 0x7f8552f3bcb0 [4465745920]CC_add_statement: self=0x7f8553857000, stmt=0x7f8552f3bcb0 [4465745920]*** LEAVE_CONN_CS [140210608634616] *** [4465745920][SQLGetStmtAttrW][4465745920]StartRollbackState:0x7f8552f3bcb0->internal=0 [4465745920]PGAPI_GetStmtAttr Handle=0x7f8552f3bcb0 10010 [4465745920]DiscardStatementSvp:0x7f8552f3bcb0->accessed=0 is_in=0 is_rb=1 is_tc=0 [4465745920][SQLGetStmtAttrW][4465745920]StartRollbackState:0x7f8552f3bcb0->internal=0 [4465745920]PGAPI_GetStmtAttr Handle=0x7f8552f3bcb0 10011 [4465745920]DiscardStatementSvp:0x7f8552f3bcb0->accessed=0 is_in=0 is_rb=1 is_tc=0 [4465745920][SQLGetStmtAttrW][4465745920]StartRollbackState:0x7f8552f3bcb0->internal=0 [4465745920]PGAPI_GetStmtAttr Handle=0x7f8552f3bcb0 10012 [4465745920]DiscardStatementSvp:0x7f8552f3bcb0->accessed=0 is_in=0 is_rb=1 is_tc=0 [4465745920][SQLGetStmtAttrW][4465745920]StartRollbackState:0x7f8552f3bcb0->internal=0 [4465745920]PGAPI_GetStmtAttr Handle=0x7f8552f3bcb0 10013 [4465745920]DiscardStatementSvp:0x7f8552f3bcb0->accessed=0 is_in=0 is_rb=1 is_tc=0 [4465745920][SQLPrepareW][4465745920]StartRollbackState:0x7f8552f3bcb0->internal=0 [4465745920]PGAPI_Prepare: entering... [4465745920]**** PGAPI_Prepare: STMT_ALLOCATED, copy [4465745920]malloc size=31 [4465745920]str=0x7f8552f30fa0 [4465745920]SQLPrepare return=0 [4465745920]DiscardStatementSvp:0x7f8552f3bcb0->accessed=0 is_in=0 is_rb=1 is_tc=0 [4465745920][SQLExecute][4465745920]StartRollbackState:0x7f8552f3bcb0->internal=0 [4465745920]PGAPI_Execute: entering...1 [4465745920]PGAPI_Execute: clear errors... [4465745920]PGAPI_NumParams: entering... [4465745920]num_params=-1,-1 [4465745920]SC_scanQueryAndCountParams: entering... [4465745920]num_params=0,0 [4465745920]prepareParameters was not called, prepare state:7 [4465745920]SC_recycle_statement: self= 0x7f8552f3bcb0 [4465745920]SC_clear_parse_status [4465745920]0x7f8552f3bcb0->SC_set_rowstart -1->-1(unknown) [4465745920]:stmt result=-1 [4465745920]SC_recycle_statement statement=0x7f8552f3bcb0 ommitted=0 [4465745920]PDATA_free_params: ENTER, self=0x7f8552f3bf90 [4465745920]Exec_with_parameters_resolved: copying statement params: trans_status=1, len=31, stmt='DROP TABLE "#Tableau_2_Connect"' [4465745920]*** ENTER_CONN_CS [140210608634616] *** [4465745920]prepare_before_exec=1 srv=1 [4465745920]copy_statement_with_parameters: enter prepared=0 [4465745920]prep_params [4465745920]SendParseRequest: plan_name=_PLAN0x7f8552f3bcb0 query=DROP TABLE "#Tableau_2_Connect" [4465745920]*** ENTER_CONN_CS [140210608634616] *** [4465745920]SetStatementSvp:0x7f8552f3bcb0->accessed=1 [4465745920]sta_pidx=0 end_pidx=-1 num_p=0 [4465745920]parse leng=54 [4465745920]SendDescribeRequest:plan_name=_PLAN0x7f8552f3bcb0 [4465745920]describe leng=21 [4465745920]*** LEAVE_CONN_CS [140210608634616] *** [4465745920] stmt_with_params = '(null)' [4465745920]about to begin SC_execute [4465745920]SendBindRequest: plan_name=_PLAN0x7f8552f3bcb0 [4465745920]num_params=0 proc_return=0 [4465745920]num_p=0 [4465745920]bind leng=50 [4465745920]SendExecuteRequest: plan_name=_PLAN0x7f8552f3bcb0 count=0 [4465745920]execute leng=24 [4465745920]Close leng=21 [4465745920]get_Result=0x0 0x0 0 [4465745920]in QR_Constructor [4465745920]exit QR_Constructor [4465745920]read -1, global_socket_buffersize=4096 [4465745920]Lasterror=35 [4465745920]!!! poll ret=1 revents=1 [4465745920]read 49, global_socket_buffersize=4096 [4465745920]desc id=1[4465745920] response_length=0 [4465745920]desc id=t[4465745920] response_length=2 [4465745920]num_params=0 info=0 [4465745920]extend_iparameter_bindings: entering ... self=0x7f8552f3bec8, parameters_allocated=0, num_params=0 [4465745920]exit extend_iparameter_bindings=0x0 [4465745920]desc id=n[4465745920] response_length=0 [4465745920]desc id=2[4465745920] response_length=0 [4465745920]desc id=C[4465745920] response_length=11 [4465745920]command response=DROP TABLE [4465745920]desc id=3[4465745920] response_length=0 [4465745920]desc id=Z[4465745920] response_length=1 [4465745920]*** LEAVE_CONN_CS [140210608634616] *** [4465745920]0x7f8552f3bcb0->SC_set_rowstart -1->-1(unknown) [4465745920]:stmt result=-1 [4465745920]!!0x7f8552f3bcb0->SC_is_concat_pre=8 res=0x7f8552f335c0 [4465745920]SC_set_Result(52f3bcb0, 52f335c0)[4465745920]QResult: enter DESTRUCTOR [4465745920]*** LEAVE_CONN_CS [140210608634616] *** [4465745920]retval=0 [4465745920]DiscardStatementSvp:0x7f8552f3bcb0->accessed=1 is_in=0 is_rb=1 is_tc=0 [4465745920]*** LEAVE_CONN_CS [140210608634616] *** [4465745920][SQLNumResultCols][4465745920]StartRollbackState:0x7f8552f3bcb0->internal=0 [4465745920]PGAPI_NumResultCols: entering... [4465745920]SC_pre_execute: status = 3 [4465745920]PGAPI_NumResultCols: result = 0x7f8552f335c0, status = 3, numcols = 0 [4465745920]DiscardStatementSvp:0x7f8552f3bcb0->accessed=0 is_in=0 is_rb=1 is_tc=0 [140735257568016][[SQLFreeHandle]][140735257568016]*** ENTER_CONN_CS [140210608634616] *** [140735257568016]PGAPI_FreeStmt: entering...hstmt=0x7f8552f3bcb0, fOption=1 [140735257568016]QResult: enter DESTRUCTOR [140735257568016]QResult: in QR_close_result [140735257568016]QResult: free memory in, fcount=0 [140735257568016]QResult: free memory out [140735257568016]QResult: exit close_result [140735257568016]QResult: exit DESTRUCTOR [140735257568016]SC_init_Result(52f3bcb0)[140735257568016]SC_Destructor: self=0x7f8552f3bcb0, self->result=0x0, self->hdbc=0x7f8553857000 [140735257568016]*** ENTER_CONN_CS [140210608634616] *** [140735257568016]CC_send_query: conn=0x7f8553857000, query='DEALLOCATE "_PLAN0x7f8552f3bcb0"' [140735257568016]leng=33 [140735257568016]send_query: done sending query 38bytes flushed [140735257568016]in QR_Constructor [140735257568016]exit QR_Constructor [140735257568016]read -1, global_socket_buffersize=4096 [140735257568016]Lasterror=35 [140735257568016]!!! poll ret=1 revents=1 [140735257568016]read 22, global_socket_buffersize=4096 [140735257568016]send_query: got id = 'C' [140735257568016]send_query response_length=11 [140735257568016]send_query: ok - 'C' - DEALLOCATE [140735257568016]send_query: setting cmdbuffer = 'DEALLOCATE' [140735257568016]send_query: returning res = 0x7f8552d0d570 [140735257568016]send_query: got id = 'Z' [140735257568016]send_query response_length=1 [140735257568016]*** LEAVE_CONN_CS [140210608634616] *** [140735257568016]QResult: enter DESTRUCTOR [140735257568016]QResult: in QR_close_result [140735257568016]QResult: free memory in, fcount=0 [140735257568016]QResult: free memory out [140735257568016]QResult: exit close_result [140735257568016]QResult: exit DESTRUCTOR [140735257568016]*** LEAVE_CONN_CS [140210608634616] *** [140735257568016]ARDFields_free 0x7f8552f3bd90 bookmark=0x7f8552f1ed00[140735257568016] hey[140735257568016]ARD_unbind_cols freeall=1 allocated=0 bindings=0x0[140735257568016]APD_free_params: ENTER, self=0x7f8552f3be58 [140735257568016]IPD_free_params: ENTER, self=0x7f8552f3bec8 [140735257568016]GDATA_unbind_cols freeall=1 allocated=0 gdata=0x0[140735257568016]PDATA_free_params: ENTER, self=0x7f8552f3bf90 [140735257568016]SC_Destructor: EXIT [140735257568016]*** LEAVE_CONN_CS [140210608634616] *** [140735257568016][SQLGetConnectAttrW][140735257568016]*** ENTER_CONN_CS [140210608634616] *** [140735257568016]PGAPI_GetConnectAttr 1209 [140735257568016]*** LEAVE_CONN_CS [140210608634616] *** [140735257568016][SQLGetConnectAttrW][140735257568016]*** ENTER_CONN_CS [140210608634616] *** [140735257568016]PGAPI_GetConnectAttr 1209 [140735257568016]*** LEAVE_CONN_CS [140210608634616] *** [140735257568016][SQLGetConnectAttrW][140735257568016]*** ENTER_CONN_CS [140210608634616] *** [140735257568016]PGAPI_GetConnectAttr 1209 [140735257568016]*** LEAVE_CONN_CS [140210608634616] *** [4466282496][[SQLAllocHandle]][4466282496]*** ENTER_CONN_CS [140210608634616] *** [4466282496]PGAPI_AllocStmt: entering... [4466282496]0x7f8552d17100->SC_set_rowstart 0->-1(unknown) [4466282496]:stmt result=-1 [4466282496]**** PGAPI_AllocStmt: hdbc = 0x7f8553857000, stmt = 0x7f8552d17100 [4466282496]CC_add_statement: self=0x7f8553857000, stmt=0x7f8552d17100 [4466282496]*** LEAVE_CONN_CS [140210608634616] *** [4466282496][SQLGetStmtAttrW][4466282496]StartRollbackState:0x7f8552d17100->internal=0 [4466282496]PGAPI_GetStmtAttr Handle=0x7f8552d17100 10010 [4466282496]DiscardStatementSvp:0x7f8552d17100->accessed=0 is_in=0 is_rb=1 is_tc=0 [4466282496][SQLGetStmtAttrW][4466282496]StartRollbackState:0x7f8552d17100->internal=0 [4466282496]PGAPI_GetStmtAttr Handle=0x7f8552d17100 10011 [4466282496]DiscardStatementSvp:0x7f8552d17100->accessed=0 is_in=0 is_rb=1 is_tc=0 [4466282496][SQLGetStmtAttrW][4466282496]StartRollbackState:0x7f8552d17100->internal=0 [4466282496]PGAPI_GetStmtAttr Handle=0x7f8552d17100 10012 [4466282496]DiscardStatementSvp:0x7f8552d17100->accessed=0 is_in=0 is_rb=1 is_tc=0 [4466282496][SQLGetStmtAttrW][4466282496]StartRollbackState:0x7f8552d17100->internal=0 [4466282496]PGAPI_GetStmtAttr Handle=0x7f8552d17100 10013 [4466282496]DiscardStatementSvp:0x7f8552d17100->accessed=0 is_in=0 is_rb=1 is_tc=0 [4466282496][SQLPrepareW][4466282496]StartRollbackState:0x7f8552d17100->internal=0 [4466282496]PGAPI_Prepare: entering... [4466282496]**** PGAPI_Prepare: STMT_ALLOCATED, copy [4466282496]malloc size=290 [4466282496]str=0x7f8552d174e0 [4466282496]SQLPrepare return=0 [4466282496]DiscardStatementSvp:0x7f8552d17100->accessed=0 is_in=0 is_rb=1 is_tc=0 [4466282496][SQLExecute][4466282496]StartRollbackState:0x7f8552d17100->internal=0 [4466282496]PGAPI_Execute: entering...1 [4466282496]PGAPI_Execute: clear errors... [4466282496]PGAPI_NumParams: entering... [4466282496]num_params=-1,-1 [4466282496]SC_scanQueryAndCountParams: entering... [4466282496]num_params=0,0 [4466282496]prepareParameters was not called, prepare state:11 [4466282496]SC_recycle_statement: self= 0x7f8552d17100 [4466282496]SC_clear_parse_status [4466282496]0x7f8552d17100->SC_set_rowstart -1->-1(unknown) [4466282496]:stmt result=-1 [4466282496]SC_recycle_statement statement=0x7f8552d17100 ommitted=0 [4466282496]PDATA_free_params: ENTER, self=0x7f8552d173e0 [4466282496]Exec_with_parameters_resolved: copying statement params: trans_status=1, len=290, stmt='SELECT "Securities"."Industry" AS "none:Industry:nk" FROM "public"."Staples" "Staples" FULL JOIN "public"."Starbucks" "Starbucks" ON ("Staples"."Item Count" = "Starbucks"."Item Count") FULL JOIN "public"."Securities" "Securities" ON ("Starbucks"."Date" = "Securities"."Date") GROUP BY 1' [4466282496]*** ENTER_CONN_CS [140210608634616] *** [4466282496]prepare_before_exec=0 srv=1 [4466282496]copy_statement_with_parameters: enter prepared=0 [4466282496] stmt_with_params = 'declare "SQL_CUR0x7f8552d17100" cursor with hold for SELECT "Securities"."Industry" AS "none:Industry:nk" FROM "public"."Staples" "Staples" FULL JOIN "public"."Starbucks" "Starbucks" ON ("Staples"."Item Count" = "Starbucks"."Item Count") FULL JOIN "public"."Securities" "Securities" ON ("Starbucks"."Date" = "Securities"."Date") GROUP BY 1' [4466282496]about to begin SC_execute [4466282496] about to begin a transaction on statement = 0x7f8552d17100 [4466282496] Sending SELECT statement on stmt=0x7f8552d17100, cursor_name='SQL_CUR0x7f8552d17100' qflag=4,1 [4466282496]SC_get_ancestor in stmt=0x7f8552d17100 [4466282496]CC_send_query_append: conn=0x7f8553857000, query='declare "SQL_CUR0x7f8552d17100" cursor with hold for SELECT "Securities"."Industry" AS "none:Industry:nk" FROM "public"."Staples" "Staples" FULL JOIN "public"."Starbucks" "Starbucks" ON ("Staples"."Item Count" = "Starbucks"."Item Count") FULL JOIN "public"."Securities" "Securities" ON ("Starbucks"."Date" = "Securities"."Date") GROUP BY 1'+'fetch 100 in "SQL_CUR0x7f8552d17100"' [4466282496]SC_get_ancestor in stmt=0x7f8552d17100 [4466282496]*** ENTER_CONN_CS [140210608634616] *** [4466282496]SetStatementSvp:0x7f8552d17100->accessed=1 [4466282496]leng=387 [4466282496]send_query: done sending query 392bytes flushed [4466282496]in QR_Constructor [4466282496]exit QR_Constructor [4466282496]read -1, global_socket_buffersize=4096 [4466282496]Lasterror=35 [140735257568016][SQLCancel][140735257568016]PGAPI_Cancel: entering... [140735257568016]DiscardStatementSvp:0x7f8552d17100->accessed=1 is_in=0 is_rb=1 is_tc=0 [140735257568016]*** LEAVE_CONN_CS [140210608634616] *** [4466282496]!!! poll ret=1 revents=1 [4466282496]read 154, global_socket_buffersize=4096 [4466282496]send_query: got id = 'C' [4466282496]send_query response_length=6 [4466282496]send_query: ok - 'C' - BEGIN [4466282496]send_query: setting cmdbuffer = 'BEGIN' [4466282496]send_query: got id = 'C' [4466282496]send_query response_length=15 [4466282496]send_query: ok - 'C' - DECLARE CURSOR [4466282496]send_query: setting cmdbuffer = 'DECLARE CURSOR' [4466282496]send_query: returning res = 0x7f8552d18140 [4466282496]send_query: got id = 'E' [4466282496]send_query response_length=112 [4466282496]handle_error_message protocol=7.4 [4466282496]new_format=1 [4466282496]send_query: 'E' - SERROR [4466282496]send_query: 'E' - C57014 [4466282496]send_query: 'E' - Mcanceling statement due to user request [4466282496]send_query: 'E' - F.\src\backend\tcop\postgres.c [4466282496]send_query: 'E' - L2960 [4466282496]send_query: 'E' - RProcessInterrupts [4466282496]send_query: got id = 'Z' [4466282496]send_query response_length=1 [4466282496]*** LEAVE_CONN_CS [140210608634616] *** [4466282496] done sending the query: [4466282496]*** LEAVE_CONN_CS [140210608634616] *** [4466282496]0x7f8552d17100->SC_set_rowstart -1->-1(unknown) [4466282496]:stmt result=-1 [4466282496]SC_set_Result(52d17100, 52d18140)[4466282496]QResult: enter DESTRUCTOR [4466282496]STATEMENT ERROR: func=SC_execute, desc='(null)', errnum=7, errmsg='Error while executing the query' [4466282496]CONN ERROR: func=SC_execute, desc='(null)', errnum=110, errmsg='ERROR: canceling statement due to user request' [4466282496]*** LEAVE_CONN_CS [140210608634616] *** [4466282496]retval=-1 [4466282496]DiscardStatementSvp:0x7f8552d17100->accessed=0 is_in=1 is_rb=0 is_tc=0 [4466282496][SQLGetDiagRecW][4466282496]PGAPI_GetDiagRec entering type=3 rec=1 [4466282496]ER_ReturnError: status = 7, msg = #ERROR: canceling statement due to user request; Error while executing the query# [4466282496] szSqlState = '57014',len=79, szError='ERROR: canceling statement due to user request; Error while executing the query' [4466282496]PGAPI_GetDiagRec exiting 0 [4466282496][SQLGetDiagRecW][4466282496]PGAPI_GetDiagRec entering type=3 rec=2 [4466282496]ER_ReturnError: status = 7, msg = #ERROR: canceling statement due to user request; Error while executing the query# [4466282496]PGAPI_GetDiagRec exiting 100 [140735257568016][[SQLFreeHandle]][140735257568016]*** ENTER_CONN_CS [140210608634616] ***