Re: [HY000] no error information; Error while preparing parameters

> 3 февр. 2017 г., в 16:50, Inoue, Hiroshi <h-inoue(at)dream(dot)email(dot)ne(dot)jp> написал(а):
>
> On 2017/02/03 17:06, Daniil Megrabyan wrote:
>> Hi,
>>
>> _Sometimes_ I’m getting very «informative» error message on SQLExecute(). The query is quite easy, but I’m guessing that error comes from the driver(or driver manager though?). What should I check?
>
> Could you take mylog output and send it to me?

[123145489756160]**** PGAPI_AllocStmt: hdbc = 0x10308cc00, stmt = 0x10101ca00
[123145489756160]CC_add_statement: self=0x10308cc00, stmt=0x10101ca00
[123145489756160][[SQLGetStmtAttr]] Handle=16894464 10010
[123145489756160]PGAPI_GetStmtAttr Handle=0x10101ca00 10010
[123145489756160][[SQLGetStmtAttr]] Handle=16894464 10011
[123145489756160]PGAPI_GetStmtAttr Handle=0x10101ca00 10011
[123145489756160][[SQLGetStmtAttr]] Handle=16894464 10012
[123145489756160]PGAPI_GetStmtAttr Handle=0x10101ca00 10012
[123145489756160][[SQLGetStmtAttr]] Handle=16894464 10013
[123145489756160]PGAPI_GetStmtAttr Handle=0x10101ca00 10013
[123145489756160][[SQLSetStmtAttr]] Handle=0x10101ca00 6,1
[123145489756160]PGAPI_SetStmtAttr Handle=0x10101ca00 6,1(0x1)
[123145489756160]PGAPI_SetStmtOption: entering...
[123145489756160]SetStmtOption(): SQL_CURSOR_TYPE = 1 [123145489756160]-> 1
[123145489756160][SQLPrepare][123145489756160]PGAPI_Prepare: entering...
[123145489756160]**** PGAPI_Prepare: STMT_ALLOCATED, copy
[123145489756160][SQLExecute][123145489756160]PGAPI_Execute: entering...1
[123145489756160]PGAPI_Execute: clear errors...
[123145489756160]PGAPI_NumParams: entering...
[123145489756160]SC_scanQueryAndCountParams: entering...
[123145489756160]prepareParameters was not called, prepare state:7
[123145489756160]SC_recycle_statement: self= 0x10101ca00
[123145489756160]PDATA_free_params: ENTER, self=0x10101cd30
[123145489756160]Exec_with_parameters_resolved: copying statement params: trans_status=1, len=109, stmt='INSERT INTO Core_Message(channel_id, date, member_id, reply_id)
VALUES(18, '2017-02-04 14:01:22', 4, NULL)
'
[123145489756160] stmt_with_params = '(null)'
[123145489756160]about to begin SC_execute
[123145489756160]libpq_bind_and_exec: bind stmt=0x10101ca00
[123145489756160]libpq_bind_and_exec: execute stmt=0x10101ca00
[123145489756160]SC_scanQueryAndCountParams: entering...
[123145489756160]SC_scanQueryAndCountParams: entering...
[123145489756160]process_statements:parsed for the first command length=-1(-1) num_p=0
[123145489756160]ParseAndDescribeWithLibpq: plan_name=_PLAN0x10101ca00 query=INSERT INTO Core_Message(channel_id, date, member_id, reply_id)
VALUES(18, '2017-02-04 14:01:22', 4, NULL)

[123145489756160]in QR_Constructor
[123145489756160]exit QR_Constructor
[123145489756160]ParseWithLibpq: plan_name=_PLAN0x10101ca00 query=INSERT INTO Core_Message(channel_id, date, member_id, reply_id)
VALUES(18, '2017-02-04 14:01:22', 4, NULL)

[123145489756160]notice/error message len=20
[123145489756160]CC_on_abort in
[123145489756160]SC_set_Result(101ca00, c3c5e0)[123145489756160]QResult: enter DESTRUCTOR
[123145489756160]STATEMENT ERROR: func=desc_params_and_sync, desc='', errnum=1, errmsg='Error while preparing parameters'
[123145489756160]CONN ERROR: func=desc_params_and_sync, desc='', errnum=108, errmsg='(NULL)'
[123145489756160]CC_on_abort in
[123145489756160]retval=-1
[123145489756160][[SQLGetDiagRec]]
[123145489756160]PGAPI_GetDiagRec entering type=3 rec=1
[123145489756160]ER_ReturnError: status = 1, msg = #no error information;
Error while preparing parameters#
[123145489756160] szSqlState = 'HY000',len=54, szError='no error information;
Error while preparing parameters'
[123145489756160]PGAPI_GetDiagRec exiting 0
[123145489756160][[SQLGetDiagRec]]
[123145489756160]PGAPI_GetDiagRec entering type=3 rec=2
[123145489756160]ER_ReturnError: status = 1, msg = #no error information;
Error while preparing parameters#
[123145489756160]PGAPI_GetDiagRec exiting 100
[123145489756160][[SQLFreeHandle]][123145489756160]PGAPI_FreeStmt: entering...hstmt=0x10101ca00, fOption=1
[123145489756160]QResult: enter DESTRUCTOR
[123145489756160]QResult: in QR_close_result
[123145489756160]QResult: free memory in, fcount=0
[123145489756160]QResult: free memory out
[123145489756160]QResult: exit close_result
[123145489756160]QResult: exit DESTRUCTOR
[123145489756160]SC_init_Result(101ca00)[123145489756160]SC_Destructor: self=0x10101ca00, self->result=0x0, self->hdbc=0x10308cc00
[123145489756160]APD_free_params: ENTER, self=0x10101cbd0
[123145489756160]IPD_free_params: ENTER, self=0x10101cc40
[123145489756160]PDATA_free_params: ENTER, self=0x10101cd30
[123145489756160]SC_Destructor: EXIT

— Daniil A Megrabyan —