errorFile.2026-05-25.log 1.5 KB

1234567891011
  1. 2026-05-25 07:48:06.509 ERROR c.c.r.backend.aspect.DaoMapperAop - 出错方法:getTradeHistoryCount---错误原因:
  2. ### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202607' doesn't exist
  3. ### The error may exist in class path resource [mapper/TradeShardingDao.xml]
  4. ### The error may involve com.crm.ib.dao.mapper.TradeShardingDao.getTradeHistoryCount-Inline
  5. ### The error occurred while setting parameters
  6. ### SQL: select count(*) from trade_history_MT4_202607 trade left join custom_login ca on trade.login=ca.login left join user_info agent on ca.agent_id = agent.id WHERE agent.ib_no like concat(?,'%') and trade.close_time >= ? and trade.close_time < ? and agent.group_id=? and agent.stamp like binary concat(?,'%')
  7. ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202607' doesn't exist
  8. ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202607' doesn't exist
  9. 2026-05-25 07:48:06.524 ERROR java.lang.RuntimeException - 出错类:com.crm.ib.service.impl.TradeHistoryShardingServiceImpluccess
  10. ,出错方法getListuccess
  11. java.lang.RuntimeException: system erroruccess,异常行号:48