sys-error.2026-08-14.log

01:04:41.868 [OkHttp https://bsc-mainnet.core.chainstack.com/...] WARN  c.r.s.s.i.NexusDepositServiceImpl - [scheduleNexusWebSocketReconnect,604] - NEXUS WebSocket reconnect scheduled in 5000 ms: failure code=0, message=null
01:30:21.428 [schedule-pool-44] ERROR c.a.d.f.s.StatFilter - [internalAfterStatementExecute,518] - slow sql 21424 millis. select
      a.id agent_id, a.site_code, cast(a.id as char) agent_code, a.name agent_name,
      p.id parent_agent_id, p.name parent_agent_name, cast(p.id as char) parent_agent_code,
      case when a.agent_level is not null and a.agent_level > 0 then '多层级代理'
           when a.star_level is not null and a.star_level > 0 then '星级代理' else '代理' end agent_type,
      a.agent_status, a.reg_time agent_reg_time, m.id member_id,
      coalesce((select sum(coalesce(r.actual_amount, r.amount_cny, r.amount, 0))
        from member_account_record r where r.member_id = m.id and r.transaction_type = 1 and r.status = 3
          and r.create_time   >=   a.reg_time), 0) deposit_amount,
      coalesce((select sum(coalesce(b.valid_bet_amount, 0)) from bet_records b
        where b.member_id = m.id and b.bet_at   >=   a.reg_time), 0) valid_bet_amount,
      coalesce((select sum(coalesce(rr.rebate_amount, 0)) from member_user_rebate_record rr
        where rr.member_user_id = m.id and rr.stat_date   >=   date(a.reg_time)), 0) rebate_amount,
      (select min(r.create_time) from member_account_record r where r.member_id = m.id
        and r.transaction_type = 1 and r.status = 3 and r.create_time   >=   a.reg_time) first_deposit_time,
      case when exists(
        select 1 from member_login_log own join member_login_log other on other.ipaddr = own.ipaddr
          and other.member_id != own.member_id and other.login_time   >=   date_sub(now(), interval 3 month)
        where own.member_id = m.id and own.ipaddr is not null and own.ipaddr != ''
          and own.login_time   >=   date_sub(now(), interval 3 month)
      ) then 1 else 0 end shared_ip,
      case when exists(
        select 1 from member_login_log own join member_login_log other on other.device_fingerprint = own.device_fingerprint
          and other.member_id != own.member_id and other.login_time   >=   date_sub(now(), interval 3 month)
        where own.member_id = m.id and own.device_fingerprint is not null and own.device_fingerprint != ''
          and own.login_time   >=   date_sub(now(), interval 3 month)
      ) then 1 else 0 end shared_device,
      case when exists(
        select 1 from member_coin_address own join member_coin_address other on other.address = own.address
          and other.member_user_id != own.member_user_id and other.create_time   >=   date_sub(now(), interval 3 month)
        where own.member_user_id = m.id and own.status = 1 and other.status = 1
          and own.address is not null and own.address != '' and own.create_time   >=   date_sub(now(), interval 3 month)
      ) then 1 else 0 end shared_coin_address
    from member_user a
    left join member_user p on p.id = a.agent_code
    left join member_user m on m.agent_code = a.id
      and coalesce(m.user_type, 0) != 1 and coalesce(m.is_agent, 0) != 1
    where (coalesce(a.user_type, 0) = 1 or coalesce(a.is_agent, 0) = 1)
      and a.reg_time   <   date_sub(now(), interval 7 day)
      and a.reg_time   >=   date_sub(now(), interval 31 day) []
02:17:41.406 [OkHttp https://bsc-mainnet.core.chainstack.com/...] WARN  c.r.s.s.i.NexusDepositServiceImpl - [scheduleNexusWebSocketReconnect,604] - NEXUS WebSocket reconnect scheduled in 5000 ms: failure code=0, message=null
05:23:06.154 [OkHttp https://bsc-mainnet.core.chainstack.com/...] WARN  c.r.s.s.i.NexusDepositServiceImpl - [scheduleNexusWebSocketReconnect,604] - NEXUS WebSocket reconnect scheduled in 5000 ms: failure code=0, message=null
05:32:50.811 [OkHttp https://bsc-mainnet.core.chainstack.com/...] WARN  c.r.s.s.i.NexusDepositServiceImpl - [scheduleNexusWebSocketReconnect,604] - NEXUS WebSocket reconnect scheduled in 5000 ms: failure code=0, message=null
06:17:51.426 [OkHttp https://bsc-mainnet.core.chainstack.com/...] WARN  c.r.s.s.i.NexusDepositServiceImpl - [scheduleNexusWebSocketReconnect,604] - NEXUS WebSocket reconnect scheduled in 5000 ms: failure code=0, message=null
07:04:01.303 [OkHttp https://bsc-mainnet.core.chainstack.com/...] WARN  c.r.s.s.i.NexusDepositServiceImpl - [scheduleNexusWebSocketReconnect,604] - NEXUS WebSocket reconnect scheduled in 5000 ms: failure code=0, message=null
08:08:38.288 [OkHttp https://bsc-mainnet.core.chainstack.com/...] ERROR c.a.d.f.s.StatFilter - [internalAfterStatementExecute,518] - slow sql 2039 millis. insert ignore into nexus_deposit_tx (
            tx_hash, log_index, block_number, from_address, to_address, to_address_lower, amount,
            confirmations, matched_order_no, match_status, raw_log_json, create_time
        ) values (
            ?, ?, ?, ?, ?, ?, ?,
            ?, ?, ?, ?, sysdate()
        ) ["0x0e4609a0cd17d6fb68902fedce62d2e8ce92de88443e67a3870bce133d842dc6",498,115789897,"0x661f1ae9f771ac618f1e37ff80aa6c6a3ce8ebac","0x1c766f7e74978cc4908477069ce4cfa570c131d3","0x1c766f7e74978cc4908477069ce4cfa570c131d3",4.189925650855471337,1,null,"UNMATCHED","{\"address\":\"0x91e366a00289a4b5d962651ed01b00c0a74d6689\",\"topics\":[\"0xddf252ad1be2c89b69c2b068fc37..."]
08:08:46.610 [OkHttp WebSocket https://bsc-mainnet.core.chainstack.com/... ping] WARN  c.r.s.s.i.NexusDepositServiceImpl - [scheduleNexusWebSocketReconnect,604] - NEXUS WebSocket reconnect scheduled in 5000 ms: failure code=0, message=sent ping but didn't receive pong within 20000ms (after 192 successful ping/pongs)
08:09:35.815 [schedule-pool-39] WARN  c.r.s.s.i.NexusDepositServiceImpl - [scanChainOnce,521] - NEXUS scan catch-up pending: fromBlock=115789956, toBlock=115790045, safeBlock=115790048, remainingBlocks=3
13:32:27.769 [OkHttp https://bsc-mainnet.core.chainstack.com/...] WARN  c.r.s.s.i.NexusDepositServiceImpl - [scheduleNexusWebSocketReconnect,604] - NEXUS WebSocket reconnect scheduled in 5000 ms: failure code=0, message=null