The error may involve defaultParameterMap
The error occurred while setting parameters
SQL: select t.order_id as orderId, t.account_id as userId,t.agent_id as agentId, t.act_agent_id as actAgentId, ai.agent_name as agentName,ai.vip_code as vipCode,t.business_line as businessLineInt,t.symbol_id as symbolId, t.token_id as tokenId,t.delegate_type as delegateType,t.business_source as businessSource,t.delegate_count as delegateCount,t.delegate_price as delegatePrice,t.dealt_count as dealtCount, t.average_deal_price as averageDealPrice,t.total_profits as totalProfits,t.total_fee as totalFee, t.child_user_id as childUserId,t.status,t.is_api as isApi,t.is_trace_user as isTraceUser, t.trusteeship_uid as trusteeshipUid, t.whether_trusteeship as whetherTrusteeship, ai.user_id as agentUserId, t.update_time as updateTime from tb_contract_history_order_new t LEFT JOIN agent_info ai ON t.agent_id= ai.id where 1=1 and t.whether_trusteeship = ? and t.delegate_type in ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) and ai.id in ( select child_agent_id from agent_relation_view where parent_agent_id in ( ? ) ) and t.update_time >= ? and t.update_time < ? order by t.update_time desc LIMIT ?
Cause: java.sql.SQLSyntaxErrorException: Unknown thread id: 255899
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Unknown thread id: 255899
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239) ~[spring-jdbc-5.2.14.RELEASE.jar!/:5.2.14.RELEASE]
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) ~[spring-jdbc-5.2.14.RELEASE.jar!/:5.2.14.RELEASE]
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73) ~[mybatis-spring-1.3.2.jar!/:1.3.2]
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446) ~[mybatis-spring-1.3.2.jar!/:1.3.2]