Re: PostgreSQL: SQLSetPos fails with SetPos update return error.

Hi,

I didn’t send the complete traces since it is huge (upto 200MB). If you still need them, let me know how to share it?
Please provide some feedback as this needs to be resolved to complete our product release.

Thanks,
Sekhar

From: Venkatesan, Sekhar
Sent: Tuesday, April 19, 2016 3:54 PM
To: 'Inoue, Hiroshi'
Cc: Tsunakawa, Takayuki; Adrian Klaver; Joshua D. Drake; pgsql-odbc(at)postgresql(dot)org
Subject: RE: [ODBC] PostgreSQL: SQLSetPos fails with SetPos update return error.

Hi Hiroshi,

Thanks for the response.
Below is the snippet of the MyLog output. Let me know what you find.
FYI: After I enable DB partitioning feature , I see this problem.

++++++++++++++++++++
[42328-902.543]libpq_bind_and_exec: execute stmt=000000000338A150
[42328-902.543]SC_scanQueryAndCountParams: entering...
[42328-902.543]SC_scanQueryAndCountParams: entering...
[42328-902.543]process_statements:parsed for the first command length=-1(-1) num_p=72
[42328-902.543]in QR_Constructor
[42328-902.543]exit QR_Constructor
[42328-902.543]num_fields = 1
[42328-902.543]in QR_set_num_fields
[42328-902.543]exit QR_set_num_fields
[42328-902.543]QR_from_PGResult: fieldname='ctid', adtid=27, adtsize=6, atttypmod=-1 (rel,att)=(710649,-1)
[42328-902.543]REALLOC: old_count = 0, size = 0
[42328-902.543]qresult: len=6, buffer='(0,18)'
[42328-902.543]qresult: len=5, buffer='(0,6)'
[42328-902.543]extend_column_bindings: entering ... self=000000000338A230, bindings_allocated=0, num_columns=1
[42328-902.543]exit extend_column_bindings=00000000017C1EE0
[42328-902.543]SC_set_Result(338a150, 3d49950)[42328-902.543]QResult: enter DESTRUCTOR
[42328-902.543]retval=0
[42328-902.543]PGAPI_ExecDirect: returned 0 from PGAPI_Execute
[42328-902.543]pos_update_callback in
[42328-902.543]STATEMENT ERROR: func=irow_update, desc='', errnum=7, errmsg='SetPos update return error'
[42328-902.543]CONN ERROR: func=irow_update, desc='', errnum=0, errmsg='(NULL)'
[42328-902.543]PGAPI_FreeStmt: entering...hstmt=000000000338A150, fOption=1
[42328-902.543]QResult: enter DESTRUCTOR
[42328-902.543]QResult: in QR_close_result
[42328-902.543]QResult: free memory in, fcount=2
[42328-902.543]QResult: free memory out
[42328-902.543]QResult: exit close_result
[42328-902.543]QResult: exit DESTRUCTOR
[42328-902.543]SC_init_Result(338a150)[42328-902.543]SC_Destructor: self=000000000338A150, self->result=0000000000000000, self->hdbc=00000000003D9020
[42328-902.543]reset_a_column_binding: entering ... self=000000000338A230, bindings_allocated=1, icol=1
[42328-902.543]APD_free_params: ENTER, self=000000000338A310
[42328-902.543]APD_free_params: EXIT
[42328-902.559]IPD_free_params: ENTER, self=000000000338A380
[42328-902.559]IPD_free_params: EXIT
[42328-902.559]PDATA_free_params: ENTER, self=000000000338A470
[42328-902.559]PDATA_free_params: EXIT
[42328-902.559]SC_Destructor: EXIT
[42328-902.559]PGAPI_SetPos returning -1
[42328-902.559][SQLGetDiagRecW][42328-902.559]PGAPI_GetDiagRec entering type=3 rec=1
[42328-902.559]ER_ReturnError: status = 7, msg = #SetPos update return error#
[42328-902.559] szSqlState = 'HY000',len=26, szError='SetPos update return error'
[42328-902.559]PGAPI_GetDiagRec exiting 0
[42328-902.559][[SQLFreeHandle]][42328-902.559]PGAPI_FreeStmt: entering...hstmt=0000000003388950, fOption=1
[42328-902.559]QResult: enter DESTRUCTOR
[42328-902.559]QResult: in QR_close_result
[42328-902.559]QResult: free memory in, fcount=1
[42328-902.559]CC_send_query: conn=00000000003D9020, query='DEALLOCATE "_KEYSET_0000000003238830"'
[42328-902.559]in QR_Constructor
[42328-902.559]exit QR_Constructor
[42328-902.559]send_query: ok - 'C' - SAVEPOINT
[42328-902.559]send_query: setting cmdbuffer = 'SAVEPOINT'
[42328-902.559]send_query: ok - 'C' - DEALLOCATE
[42328-902.559]send_query: setting cmdbuffer = 'DEALLOCATE'
[42328-902.559]send_query: returning res = 0000000003D496B0
[42328-902.559]send_query: ok - 'C' - RELEASE
[42328-902.559]in QR_Constructor
[42328-902.559]exit QR_Constructor
[42328-902.559]send_query: setting cmdbuffer = 'RELEASE'
[42328-902.559]send_query: returning res = 0000000003D48ED0
[42328-902.559]QResult: enter DESTRUCTOR
[42328-902.559]QResult: in QR_close_result
[42328-902.559]QResult: free memory in, fcount=0
[42328-902.559]QResult: free memory out
++++++++++++++++

From: Inoue, Hiroshi [mailto:h-inoue(at)dream(dot)email(dot)ne(dot)jp]
Sent: Tuesday, April 19, 2016 3:11 PM
To: Venkatesan, Sekhar
Cc: Tsunakawa, Takayuki; Adrian Klaver; Joshua D. Drake; pgsql-odbc(at)postgresql(dot)org<mailto:pgsql-odbc(at)postgresql(dot)org>
Subject: Re: [ODBC] PostgreSQL: SQLSetPos fails with SetPos update return error.

Hi Sekhar,
On 2016/04/19 15:53, Venkatesan, Sekhar wrote:
Hi Guys,

I am hitting a peculiar error when trying to update a row in PostgreSQL database using odbc SQLSetPos call.
I read in PostgreSQL forums that it doesn’t support POSITIONED UPDATE.

The error being returned is:

STATE=HY000, CODE=7, MSG=SetPos update return error\n" ...} }

Are there any other error messages?
If there's no other message, could you take Mylog output and send it to me?

regards,
Hiroshi Inoue