errorFile.2024-11-01.log 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110
  1. 2024-11-01 11:31:58.580 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_202501' 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_202501 trade left join custom_login ca on trade.login=ca.login left join user_info agent on ca.agent_id = agent.id WHERE ca.agent_id = ? and 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_202501' doesn't exist
  8. ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist
  9. 2024-11-01 11:31:58.581 ERROR java.lang.RuntimeException - 出错类:com.crm.ib.service.impl.TradeHistoryShardingServiceImpluccess
  10. ,出错方法getListuccess
  11. java.lang.RuntimeException: system erroruccess,异常行号:48
  12. 2024-11-01 11:32:06.275 ERROR c.c.r.backend.aspect.DaoMapperAop - 出错方法:getTradeHistoryCount---错误原因:
  13. ### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist
  14. ### The error may exist in class path resource [mapper/TradeShardingDao.xml]
  15. ### The error may involve com.crm.ib.dao.mapper.TradeShardingDao.getTradeHistoryCount-Inline
  16. ### The error occurred while setting parameters
  17. ### SQL: select count(*) from trade_history_MT4_202501 trade left join custom_login ca on trade.login=ca.login left join user_info agent on ca.agent_id = agent.id WHERE ca.agent_id = ? and agent.ib_no like concat(?,'%') and trade.close_time >= ? and trade.close_time < ? and agent.group_id=? and agent.stamp like binary concat(?,'%')
  18. ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist
  19. ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist
  20. 2024-11-01 11:32:06.276 ERROR java.lang.RuntimeException - 出错类:com.crm.ib.service.impl.TradeHistoryShardingServiceImpluccess
  21. ,出错方法getListuccess
  22. java.lang.RuntimeException: system erroruccess,异常行号:48
  23. 2024-11-01 11:32:11.252 ERROR c.c.r.backend.aspect.DaoMapperAop - 出错方法:getTradeHistoryCount---错误原因:
  24. ### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist
  25. ### The error may exist in class path resource [mapper/TradeShardingDao.xml]
  26. ### The error may involve com.crm.ib.dao.mapper.TradeShardingDao.getTradeHistoryCount-Inline
  27. ### The error occurred while setting parameters
  28. ### SQL: select count(*) from trade_history_MT4_202501 trade left join custom_login ca on trade.login=ca.login left join user_info agent on ca.agent_id = agent.id WHERE ca.agent_id = ? and agent.ib_no like concat(?,'%') and trade.close_time >= ? and trade.close_time < ? and agent.group_id=? and agent.stamp like binary concat(?,'%')
  29. ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist
  30. ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist
  31. 2024-11-01 11:32:11.253 ERROR java.lang.RuntimeException - 出错类:com.crm.ib.service.impl.TradeHistoryShardingServiceImpluccess
  32. ,出错方法getListuccess
  33. java.lang.RuntimeException: system erroruccess,异常行号:48
  34. 2024-11-01 11:32:14.140 ERROR c.c.r.backend.aspect.DaoMapperAop - 出错方法:getTradeHistoryCount---错误原因:
  35. ### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist
  36. ### The error may exist in class path resource [mapper/TradeShardingDao.xml]
  37. ### The error may involve com.crm.ib.dao.mapper.TradeShardingDao.getTradeHistoryCount-Inline
  38. ### The error occurred while setting parameters
  39. ### SQL: select count(*) from trade_history_MT4_202501 trade left join custom_login ca on trade.login=ca.login left join user_info agent on ca.agent_id = agent.id WHERE ca.agent_id = ? and agent.ib_no like concat(?,'%') and trade.close_time >= ? and trade.close_time < ? and agent.group_id=? and agent.stamp like binary concat(?,'%')
  40. ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist
  41. ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist
  42. 2024-11-01 11:32:14.140 ERROR java.lang.RuntimeException - 出错类:com.crm.ib.service.impl.TradeHistoryShardingServiceImpluccess
  43. ,出错方法getListuccess
  44. java.lang.RuntimeException: system erroruccess,异常行号:48
  45. 2024-11-01 11:32:23.128 ERROR c.c.r.backend.aspect.DaoMapperAop - 出错方法:getTradeHistoryCount---错误原因:
  46. ### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist
  47. ### The error may exist in class path resource [mapper/TradeShardingDao.xml]
  48. ### The error may involve com.crm.ib.dao.mapper.TradeShardingDao.getTradeHistoryCount-Inline
  49. ### The error occurred while setting parameters
  50. ### SQL: select count(*) from trade_history_MT4_202501 trade left join custom_login ca on trade.login=ca.login left join user_info agent on ca.agent_id = agent.id WHERE ca.agent_id = ? and agent.ib_no like concat(?,'%') and trade.close_time >= ? and trade.close_time < ? and agent.group_id=? and agent.stamp like binary concat(?,'%')
  51. ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist
  52. ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist
  53. 2024-11-01 11:32:23.128 ERROR java.lang.RuntimeException - 出错类:com.crm.ib.service.impl.TradeHistoryShardingServiceImpluccess
  54. ,出错方法getListuccess
  55. java.lang.RuntimeException: system erroruccess,异常行号:48
  56. 2024-11-01 11:34:27.430 ERROR c.c.r.backend.aspect.DaoMapperAop - 出错方法:getTradeHistoryCount---错误原因:
  57. ### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202510' doesn't exist
  58. ### The error may exist in class path resource [mapper/TradeShardingDao.xml]
  59. ### The error may involve com.crm.ib.dao.mapper.TradeShardingDao.getTradeHistoryCount-Inline
  60. ### The error occurred while setting parameters
  61. ### SQL: select count(*) from trade_history_MT4_202510 trade left join custom_login ca on trade.login=ca.login left join user_info agent on ca.agent_id = agent.id WHERE ca.agent_id = ? and agent.ib_no like concat(?,'%') and trade.close_time >= ? and trade.close_time < ? and agent.group_id=? and agent.stamp like binary concat(?,'%')
  62. ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202510' doesn't exist
  63. ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202510' doesn't exist
  64. 2024-11-01 11:34:27.430 ERROR java.lang.RuntimeException - 出错类:com.crm.ib.service.impl.TradeHistoryShardingServiceImpluccess
  65. ,出错方法getListuccess
  66. java.lang.RuntimeException: system erroruccess,异常行号:48
  67. 2024-11-01 11:34:28.956 ERROR c.c.r.backend.aspect.DaoMapperAop - 出错方法:getTradeHistoryCount---错误原因:
  68. ### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202510' doesn't exist
  69. ### The error may exist in class path resource [mapper/TradeShardingDao.xml]
  70. ### The error may involve com.crm.ib.dao.mapper.TradeShardingDao.getTradeHistoryCount-Inline
  71. ### The error occurred while setting parameters
  72. ### SQL: select count(*) from trade_history_MT4_202510 trade left join custom_login ca on trade.login=ca.login left join user_info agent on ca.agent_id = agent.id WHERE ca.agent_id = ? and agent.ib_no like concat(?,'%') and trade.close_time >= ? and trade.close_time < ? and agent.group_id=? and agent.stamp like binary concat(?,'%')
  73. ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202510' doesn't exist
  74. ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202510' doesn't exist
  75. 2024-11-01 11:34:28.957 ERROR java.lang.RuntimeException - 出错类:com.crm.ib.service.impl.TradeHistoryShardingServiceImpluccess
  76. ,出错方法getListuccess
  77. java.lang.RuntimeException: system erroruccess,异常行号:48
  78. 2024-11-01 11:36:41.150 ERROR c.c.r.backend.aspect.DaoMapperAop - 出错方法:getTradeHistoryCount---错误原因:
  79. ### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist
  80. ### The error may exist in class path resource [mapper/TradeShardingDao.xml]
  81. ### The error may involve com.crm.ib.dao.mapper.TradeShardingDao.getTradeHistoryCount-Inline
  82. ### The error occurred while setting parameters
  83. ### SQL: select count(*) from trade_history_MT4_202501 trade left join custom_login ca on trade.login=ca.login left join user_info agent on ca.agent_id = agent.id WHERE ca.agent_id = ? and agent.ib_no like concat(?,'%') and trade.close_time >= ? and trade.close_time < ? and agent.group_id=? and agent.stamp like binary concat(?,'%')
  84. ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist
  85. ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist
  86. 2024-11-01 11:36:41.150 ERROR java.lang.RuntimeException - 出错类:com.crm.ib.service.impl.TradeHistoryShardingServiceImpluccess
  87. ,出错方法getListuccess
  88. java.lang.RuntimeException: system erroruccess,异常行号:48
  89. 2024-11-01 11:39:45.654 ERROR c.c.r.backend.aspect.DaoMapperAop - 出错方法:getTradeHistoryCount---错误原因:
  90. ### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist
  91. ### The error may exist in class path resource [mapper/TradeShardingDao.xml]
  92. ### The error may involve com.crm.ib.dao.mapper.TradeShardingDao.getTradeHistoryCount-Inline
  93. ### The error occurred while setting parameters
  94. ### SQL: select count(*) from trade_history_MT4_202501 trade left join custom_login ca on trade.login=ca.login left join user_info agent on ca.agent_id = agent.id WHERE ca.agent_id = ? and agent.ib_no like concat(?,'%') and trade.close_time >= ? and trade.close_time < ? and agent.group_id=? and agent.stamp like binary concat(?,'%')
  95. ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist
  96. ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist
  97. 2024-11-01 11:39:45.654 ERROR java.lang.RuntimeException - 出错类:com.crm.ib.service.impl.TradeHistoryShardingServiceImpluccess
  98. ,出错方法getListuccess
  99. java.lang.RuntimeException: system erroruccess,异常行号:48
  100. 2024-11-01 11:40:09.772 ERROR c.c.r.backend.aspect.DaoMapperAop - 出错方法:getTradeHistoryCount---错误原因:
  101. ### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist
  102. ### The error may exist in class path resource [mapper/TradeShardingDao.xml]
  103. ### The error may involve com.crm.ib.dao.mapper.TradeShardingDao.getTradeHistoryCount-Inline
  104. ### The error occurred while setting parameters
  105. ### SQL: select count(*) from trade_history_MT4_202501 trade left join custom_login ca on trade.login=ca.login left join user_info agent on ca.agent_id = agent.id WHERE ca.agent_id = ? and agent.ib_no like concat(?,'%') and trade.close_time >= ? and trade.close_time < ? and agent.group_id=? and agent.stamp like binary concat(?,'%')
  106. ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist
  107. ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202501' doesn't exist
  108. 2024-11-01 11:40:09.772 ERROR java.lang.RuntimeException - 出错类:com.crm.ib.service.impl.TradeHistoryShardingServiceImpluccess
  109. ,出错方法getListuccess
  110. java.lang.RuntimeException: system erroruccess,异常行号:48