Re: [ODBC] [HY000] no error information; Error while preparingparameters
От | Daniil Megrabyan |
---|---|
Тема | Re: [ODBC] [HY000] no error information; Error while preparingparameters |
Дата | |
Msg-id | FBB46514-C539-4929-8FB1-B75E2E895FF7@gmail.com обсуждение исходный текст |
Ответ на | Re: [ODBC] [HY000] no error information; Error while preparingparameters ("Inoue, Hiroshi" <h-inoue@dream.email.ne.jp>) |
Ответы |
Re: [ODBC] [HY000] no error information; Error while preparingparameters
("Inoue, Hiroshi" <h-inoue@dream.email.ne.jp>)
|
Список | pgsql-odbc |
> 3 февр. 2017 г., в 16:50, Inoue, Hiroshi <h-inoue@dream.email.ne.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 thaterror 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 —
В списке pgsql-odbc по дате отправления:
Следующее
От: "Inoue, Hiroshi"Дата:
Сообщение: Re: [ODBC] [HY000] no error information; Error while preparingparameters