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

> 5 февр. 2017 г., в 3:26, Inoue, Hiroshi <h-inoue(at)dream(dot)email(dot)ne(dot)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 manager blames 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 —