Re: [ODBC] [HY000] no error information; Error while preparingparameters
От | Daniil Megrabyan |
---|---|
Тема | Re: [ODBC] [HY000] no error information; Error while preparingparameters |
Дата | |
Msg-id | 4C08BA12-B60A-4A91-B45A-E56E767C86CE@gmail.com обсуждение исходный текст |
Ответ на | Re: [ODBC] [HY000] no error information; Error while preparingparameters ("Inoue, Hiroshi" <h-inoue@dream.email.ne.jp>) |
Список | pgsql-odbc |
> 5 февр. 2017 г., в 3:26, Inoue, Hiroshi <h-inoue@dream.email.ne.jp> написал(а): > > Thanks. > Unfortunately I can't reproduce your case. > > Though I found a suspicious place thanks to the mylog you sent, there is not enough > information in the log unfortunately. > > Could you build the drivers from source? I have built from the latest sources and got the same stuff. But! I’ve noticed another error occurred before — driver managerblames encoding and UTF8-data becomes a question mark. odbc trace: Exit:[SQL_SUCCESS] [ODBC][43276][1486279223.490067][SQLAllocHandle.c][540] Entry: Handle Type = 3 Input Handle = 0x10286c200 [ODBC][43276][1486279223.490282][SQLAllocHandle.c][1085] Exit:[SQL_SUCCESS] Output Handle = 0x10101ca00 [ODBC][43276][1486279223.490374][SQLSetStmtAttr.c][265] Entry: Statement = 0x10101ca00 Attribute = SQL_ATTR_CURSOR_TYPE Value = 0x1 StrLen = 0 [ODBC][43276][1486279223.490567][SQLSetStmtAttr.c][928] Exit:[SQL_SUCCESS] [ODBC][43276][1486279223.490748][SQLPrepare.c][196] Entry: Statement = 0x10101ca00 SQL = [INSERT INTO Core_TextMessage(message_id, text) VALUES(32, '?') ][length = 65 (SQL_NTS)] [ODBC][43276][1486279223.490868][SQLPrepare.c][377] Exit:[SQL_SUCCESS] [ODBC][43276][1486279223.491009][SQLExecute.c][187] Entry: Statement = 0x10101ca00 [ODBC][43276][1486279223.531171][SQLExecute.c][357] Exit:[SQL_ERROR] DIAG [22021] ERROR: invalid byte sequence for encoding "UTF8": 0xd0 0x27; Error while preparing parameters [ODBC][43276][1486279223.531656][SQLFreeHandle.c][381] Entry: Handle Type = 3 Input Handle = 0x10101ca00 [ODBC][43276][1486279223.532054][SQLFreeHandle.c][494] mylog: [123145375444992][[SQLAllocHandle]][123145375444992]PGAPI_AllocStmt: entering... [123145375444992]**** PGAPI_AllocStmt: hdbc = 0x1030a3200, stmt = 0x101000600 [123145375444992]CC_add_statement: self=0x1030a3200, stmt=0x101000600 [123145375444992][[SQLGetStmtAttr]] Handle=16778752 10010 [123145375444992]PGAPI_GetStmtAttr Handle=0x101000600 10010 [123145375444992][[SQLGetStmtAttr]] Handle=16778752 10011 [123145375444992]PGAPI_GetStmtAttr Handle=0x101000600 10011 [123145375444992][[SQLGetStmtAttr]] Handle=16778752 10012 [123145375444992]PGAPI_GetStmtAttr Handle=0x101000600 10012 [123145375444992][[SQLGetStmtAttr]] Handle=16778752 10013 [123145375444992]PGAPI_GetStmtAttr Handle=0x101000600 10013 [123145375444992][[SQLSetStmtAttr]] Handle=0x101000600 6,1 [123145375444992]PGAPI_SetStmtAttr Handle=0x101000600 6,1(0x1) [123145375444992]PGAPI_SetStmtOption: entering... [123145375444992]SetStmtOption(): SQL_CURSOR_TYPE = 1 [123145375444992]-> 1 [123145375444992][SQLPrepare][123145375444992]PGAPI_Prepare: entering... [123145375444992]**** PGAPI_Prepare: STMT_ALLOCATED, copy [123145375444992][SQLExecute][123145375444992]PGAPI_Execute: entering...1 [123145375444992]PGAPI_Execute: clear errors... [123145375444992]PGAPI_NumParams: entering... [123145375444992]SC_scanQueryAndCountParams: entering... [123145375444992]prepareParameters was not called, prepare state:7 [123145375444992]SC_recycle_statement: self= 0x101000600 [123145375444992]PDATA_free_params: ENTER, self=0x101000938 [123145375444992]Exec_with_parameters_resolved: copying statement params: trans_status=1, len=65, stmt='INSERT INTO Core_TextMessage(message_id,text) VALUES(32, '?') ' [123145375444992] stmt_with_params = '(null)' [123145375444992]about to begin SC_execute [123145375444992]libpq_bind_and_exec: bind stmt=0x101000600 [123145375444992]libpq_bind_and_exec: execute stmt=0x101000600 [123145375444992]SC_scanQueryAndCountParams: entering... [123145375444992]SC_scanQueryAndCountParams: entering... [123145375444992]process_statements:parsed for the first command length=-1(-1) num_p=0 [123145375444992]ParseAndDescribeWithLibpq: plan_name=_PLAN0x101000600 query=INSERT INTO Core_TextMessage(message_id, text) VALUES(32, '?') [123145375444992]in QR_Constructor [123145375444992]exit QR_Constructor [123145375444992]ParseWithLibpq: plan_name=_PLAN0x101000600 query=INSERT INTO Core_TextMessage(message_id, text) VALUES(32, '?') [123145375444992]error message len=59 [123145375444992]SC_set_Result(1000600, 93b160)[123145375444992]QResult: enter DESTRUCTOR [123145375444992]STATEMENT ERROR: func=desc_params_and_sync, desc='', errnum=1, errmsg='Error while preparing parameters' [123145375444992]CONN ERROR: func=desc_params_and_sync, desc='', errnum=110, errmsg='(NULL)' [123145375444992]CC_on_abort in [123145375444992]retval=-1 [123145375444992][[SQLGetDiagRec]] [123145375444992]PGAPI_GetDiagRec entering type=3 rec=1 [123145375444992]ER_ReturnError: status = 1, msg = #ERROR: invalid byte sequence for encoding "UTF8": 0xd0 0x27; Error while preparing parameters# [123145375444992] szSqlState = '22021',len=93, szError='ERROR: invalid byte sequence for encoding "UTF8": 0xd0 0x27; Error while preparing parameters' [123145375444992]PGAPI_GetDiagRec exiting 0 [123145375444992][[SQLGetDiagRec]] [123145375444992]PGAPI_GetDiagRec entering type=3 rec=2 [123145375444992]ER_ReturnError: status = 1, msg = #ERROR: invalid byte sequence for encoding "UTF8": 0xd0 0x27; Error while preparing parameters# [123145375444992]PGAPI_GetDiagRec exiting 100 [123145375444992][[SQLFreeHandle]][123145375444992]PGAPI_FreeStmt: entering...hstmt=0x101000600, fOption=1 [123145375444992]QResult: enter DESTRUCTOR [123145375444992]QResult: in QR_close_result [123145375444992]QResult: free memory in, fcount=0 [123145375444992]QResult: free memory out [123145375444992]QResult: exit close_result [123145375444992]QResult: exit DESTRUCTOR [123145375444992]SC_init_Result(1000600)[123145375444992]SC_Destructor: self=0x101000600, self->result=0x0, self->hdbc=0x1030a3200 [123145375444992]APD_free_params: ENTER, self=0x1010007d0 [123145375444992]IPD_free_params: ENTER, self=0x101000840 [123145375444992]PDATA_free_params: ENTER, self=0x101000938 [123145375444992]SC_Destructor: EXIT [123145375444992][[SQLAllocHandle]][123145375444992]PGAPI_AllocStmt: entering... [123145375444992]**** PGAPI_AllocStmt: hdbc = 0x1030a3200, stmt = 0x10101ca00 [123145375444992]CC_add_statement: self=0x1030a3200, stmt=0x10101ca00 [123145375444992][[SQLGetStmtAttr]] Handle=16894464 10010 [123145375444992]PGAPI_GetStmtAttr Handle=0x10101ca00 10010 [123145375444992][[SQLGetStmtAttr]] Handle=16894464 10011 [123145375444992]PGAPI_GetStmtAttr Handle=0x10101ca00 10011 [123145375444992][[SQLGetStmtAttr]] Handle=16894464 10012 [123145375444992]PGAPI_GetStmtAttr Handle=0x10101ca00 10012 [123145375444992][[SQLGetStmtAttr]] Handle=16894464 10013 [123145375444992]PGAPI_GetStmtAttr Handle=0x10101ca00 10013 [123145375444992][[SQLSetStmtAttr]] Handle=0x10101ca00 6,1 [123145375444992]PGAPI_SetStmtAttr Handle=0x10101ca00 6,1(0x1) [123145375444992]PGAPI_SetStmtOption: entering... [123145375444992]SetStmtOption(): SQL_CURSOR_TYPE = 1 [123145375444992]-> 1 [123145375444992][SQLPrepare][123145375444992]PGAPI_Prepare: entering... [123145375444992]**** PGAPI_Prepare: STMT_ALLOCATED, copy [123145375444992][SQLExecute][123145375444992]PGAPI_Execute: entering...1 [123145375444992]PGAPI_Execute: clear errors... [123145375444992]PGAPI_NumParams: entering... [123145375444992]SC_scanQueryAndCountParams: entering... [123145375444992]prepareParameters was not called, prepare state:7 [123145375444992]SC_recycle_statement: self= 0x10101ca00 [123145375444992]PDATA_free_params: ENTER, self=0x10101cd38 [123145375444992]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(25, '2017-02-05 10:20:38', 4, NULL) ' [123145375444992] stmt_with_params = '(null)' [123145375444992]about to begin SC_execute [123145375444992]libpq_bind_and_exec: bind stmt=0x10101ca00 [123145375444992]libpq_bind_and_exec: execute stmt=0x10101ca00 [123145375444992]SC_scanQueryAndCountParams: entering... [123145375444992]SC_scanQueryAndCountParams: entering... [123145375444992]process_statements:parsed for the first command length=-1(-1) num_p=0 [123145375444992]ParseAndDescribeWithLibpq: plan_name=_PLAN0x10101ca00 query=INSERT INTO Core_Message(channel_id, date, member_id,reply_id) VALUES(25, '2017-02-05 10:20:38', 4, NULL) [123145375444992]in QR_Constructor [123145375444992]exit QR_Constructor [123145375444992]ParseWithLibpq: plan_name=_PLAN0x10101ca00 query=INSERT INTO Core_Message(channel_id, date, member_id, reply_id) VALUES(25, '2017-02-05 10:20:38', 4, NULL) [123145375444992]error message len=20 [123145375444992]CC_on_abort in [123145375444992]SC_set_Result(101ca00, d0f920)[123145375444992]QResult: enter DESTRUCTOR [123145375444992]STATEMENT ERROR: func=desc_params_and_sync, desc='', errnum=1, errmsg='Error while preparing parameters' [123145375444992]CONN ERROR: func=desc_params_and_sync, desc='', errnum=113, errmsg='(NULL)' [123145375444992]CC_on_abort in [123145375444992]retval=-1 [123145375444992][[SQLGetDiagRec]] [123145375444992]PGAPI_GetDiagRec entering type=3 rec=1 [123145375444992]ER_ReturnError: status = 1, msg = #no error information; Error while preparing parameters# [123145375444992] szSqlState = 'HY000',len=54, szError='no error information; Error while preparing parameters' [123145375444992]PGAPI_GetDiagRec exiting 0 [123145375444992][[SQLGetDiagRec]] [123145375444992]PGAPI_GetDiagRec entering type=3 rec=2 [123145375444992]ER_ReturnError: status = 1, msg = #no error information; Error while preparing parameters# [123145375444992]PGAPI_GetDiagRec exiting 100 [123145375444992][[SQLFreeHandle]][123145375444992]PGAPI_FreeStmt: entering...hstmt=0x10101ca00, fOption=1 [123145375444992]QResult: enter DESTRUCTOR [123145375444992]QResult: in QR_close_result [123145375444992]QResult: free memory in, fcount=0 [123145375444992]QResult: free memory out [123145375444992]QResult: exit close_result [123145375444992]QResult: exit DESTRUCTOR [123145375444992]SC_init_Result(101ca00)[123145375444992]SC_Destructor: self=0x10101ca00, self->result=0x0, self->hdbc=0x1030a3200 [123145375444992]APD_free_params: ENTER, self=0x10101cbd0 [123145375444992]IPD_free_params: ENTER, self=0x10101cc40 [123145375444992]PDATA_free_params: ENTER, self=0x10101cd38 [123145375444992]SC_Destructor: EXIT [123145375444992][[SQLGetDiagRec]] [123145375444992]PGAPI_GetDiagRec entering type=2 rec=1 [123145375444992]**** PGAPI_ConnectError: hdbc=0x1030a3200 <512> [123145375444992]enter CC_get_error [123145375444992]exit CC_get_error [123145375444992]CC_Get_error returned nothing. [123145375444992]PGAPI_GetDiagRec exiting 100 — Daniil A Megrabyan —
В списке pgsql-odbc по дате отправления:
Предыдущее
От: "Inoue, Hiroshi"Дата:
Сообщение: Re: [ODBC] [HY000] no error information; Error while preparingparameters
Следующее
От: Daniil MegrabyanДата:
Сообщение: Re: [ODBC] [HY000] no error information; Error while preparingparameters