sys-error.log
admin-blue · 最近 500 行 · 已读取 64.0 KiB
SELECT
m.id, m.name, m.password, m.withdraw_password, m.real_name, m.avatar, m.parent, m.reg_time, m.last_login_time,
m.last_login_ip, m.last_login_region, m.app_version, m.status, m.vip_level, m.invite_code,
m.enter_invite_code, m.team_code, m.agent_team_id, m.team_role,
m.team_agent_identity, m.referrer_agent_id,
m.developer_name, m.recruiter_user_id,
mt.title AS team_name,
m.site_code, m.agent_code,
COALESCE(s.name_zn, m.site_code) AS site_name,
m.from_source, m.from_domain, m.is_agent, m.from_ip, m.from_ip_region,
m.is_site_admin_binding,
m.commission_plan_id, m.google_key,
case when m.google_key is not null and m.google_key != '' then '0' else '1' end as google_auth_status,
m.last_active_time, m.last_entry_venue,
m.user_type, m.agent_level, m.star_level, m.agent_remark,
m.phone, m.email, m.qq, m.wechat,
m.promotion_code, m.commission_rate,
m.bear_all_operation_expense, m.bear_operation_expense_types,
m.settlement_cycle,
m.min_withdraw_amount, m.max_withdraw_amount, m.agent_status,
m.total_valid_bet_amount,
m.vip_raw_total_valid_bet_amount, m.vip_turnover_adjustment,
m.remain_level_start_date,
m.current_remain_level_bet_amount,
cp.plan_name AS commission_plan_name,
pu.name AS parent_agent_name,
pu.agent_level AS parent_agent_level,
pu.star_level AS parent_agent_star_level,
m.agent_domain,
/* 子数量 */
(SELECT COUNT(*) FROM member_user
WHERE agent_code = m.id AND IFNULL(user_type,1) = 1) AS sub_agent_count,
(SELECT COUNT(*) FROM member_user
WHERE agent_code = m.id AND IFNULL(user_type,0) = 0) AS sub_member_count
,
(SELECT mar.actual_amount
FROM member_account_record mar
WHERE mar.member_id = m.id
AND mar.transaction_type = 1
AND mar.status = 3
ORDER BY mar.id ASC
LIMIT 1) AS first_deposit_amount
FROM member_user m
LEFT JOIN member_team mt ON m.team_code = mt.team_code
LEFT JOIN site s ON m.site_code = s.code
LEFT JOIN commission_plan cp ON m.commission_plan_id = cp.id
LEFT JOIN member_user pu ON m.agent_code = pu.id
) u
where u.id = ? [1861]
01:34:32.616 [http-nio-9080-exec-20] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:34:33.103 [http-nio-9080-exec-43] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:34:33.446 [http-nio-9080-exec-59] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:34:35.169 [http-nio-9080-exec-4] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:34:35.250 [http-nio-9080-exec-85] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:34:38.044 [http-nio-9080-exec-83] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:34:38.309 [http-nio-9080-exec-51] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:34:41.721 [http-nio-9080-exec-73] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:34:43.400 [http-nio-9080-exec-83] ERROR c.a.d.f.s.StatFilter - [internalAfterStatementExecute,518] - slow sql 5352 millis. SELECT u.* FROM (
SELECT
m.id, m.name, m.password, m.withdraw_password, m.real_name, m.avatar, m.parent, m.reg_time, m.last_login_time,
m.last_login_ip, m.last_login_region, m.app_version, m.status, m.vip_level, m.invite_code,
m.enter_invite_code, m.team_code, m.agent_team_id, m.team_role,
m.team_agent_identity, m.referrer_agent_id,
m.developer_name, m.recruiter_user_id,
mt.title AS team_name,
m.site_code, m.agent_code,
COALESCE(s.name_zn, m.site_code) AS site_name,
m.from_source, m.from_domain, m.is_agent, m.from_ip, m.from_ip_region,
m.is_site_admin_binding,
m.commission_plan_id, m.google_key,
case when m.google_key is not null and m.google_key != '' then '0' else '1' end as google_auth_status,
m.last_active_time, m.last_entry_venue,
m.user_type, m.agent_level, m.star_level, m.agent_remark,
m.phone, m.email, m.qq, m.wechat,
m.promotion_code, m.commission_rate,
m.bear_all_operation_expense, m.bear_operation_expense_types,
m.settlement_cycle,
m.min_withdraw_amount, m.max_withdraw_amount, m.agent_status,
m.total_valid_bet_amount,
m.vip_raw_total_valid_bet_amount, m.vip_turnover_adjustment,
m.remain_level_start_date,
m.current_remain_level_bet_amount,
cp.plan_name AS commission_plan_name,
pu.name AS parent_agent_name,
pu.agent_level AS parent_agent_level,
pu.star_level AS parent_agent_star_level,
m.agent_domain,
/* 子数量 */
(SELECT COUNT(*) FROM member_user
WHERE agent_code = m.id AND IFNULL(user_type,1) = 1) AS sub_agent_count,
(SELECT COUNT(*) FROM member_user
WHERE agent_code = m.id AND IFNULL(user_type,0) = 0) AS sub_member_count
,
(SELECT mar.actual_amount
FROM member_account_record mar
WHERE mar.member_id = m.id
AND mar.transaction_type = 1
AND mar.status = 3
ORDER BY mar.id ASC
LIMIT 1) AS first_deposit_amount
FROM member_user m
LEFT JOIN member_team mt ON m.team_code = mt.team_code
LEFT JOIN site s ON m.site_code = s.code
LEFT JOIN commission_plan cp ON m.commission_plan_id = cp.id
LEFT JOIN member_user pu ON m.agent_code = pu.id
) u
where u.id = ? [3994]
01:34:44.996 [http-nio-9080-exec-8] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:34:45.779 [http-nio-9080-exec-55] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:34:46.760 [http-nio-9080-exec-34] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:34:47.942 [http-nio-9080-exec-33] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:34:48.614 [http-nio-9080-exec-16] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:34:48.884 [http-nio-9080-exec-2] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:34:50.086 [http-nio-9080-exec-9] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:34:51.282 [http-nio-9080-exec-18] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:34:54.840 [http-nio-9080-exec-54] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:34:55.843 [http-nio-9080-exec-42] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:34:56.216 [http-nio-9080-exec-69] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:34:56.223 [http-nio-9080-exec-44] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:34:59.735 [http-nio-9080-exec-35] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:35:00.570 [http-nio-9080-exec-64] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:35:01.488 [http-nio-9080-exec-21] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:35:03.482 [http-nio-9080-exec-7] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:35:03.854 [http-nio-9080-exec-52] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:35:04.913 [http-nio-9080-exec-78] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:35:04.931 [http-nio-9080-exec-100] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:35:05.172 [http-nio-9080-exec-90] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:35:05.214 [http-nio-9080-exec-69] ERROR c.a.d.f.s.StatFilter - [internalAfterStatementExecute,518] - slow sql 8987 millis. SELECT u.* FROM (
SELECT
m.id, m.name, m.password, m.withdraw_password, m.real_name, m.avatar, m.parent, m.reg_time, m.last_login_time,
m.last_login_ip, m.last_login_region, m.app_version, m.status, m.vip_level, m.invite_code,
m.enter_invite_code, m.team_code, m.agent_team_id, m.team_role,
m.team_agent_identity, m.referrer_agent_id,
m.developer_name, m.recruiter_user_id,
mt.title AS team_name,
m.site_code, m.agent_code,
COALESCE(s.name_zn, m.site_code) AS site_name,
m.from_source, m.from_domain, m.is_agent, m.from_ip, m.from_ip_region,
m.is_site_admin_binding,
m.commission_plan_id, m.google_key,
case when m.google_key is not null and m.google_key != '' then '0' else '1' end as google_auth_status,
m.last_active_time, m.last_entry_venue,
m.user_type, m.agent_level, m.star_level, m.agent_remark,
m.phone, m.email, m.qq, m.wechat,
m.promotion_code, m.commission_rate,
m.bear_all_operation_expense, m.bear_operation_expense_types,
m.settlement_cycle,
m.min_withdraw_amount, m.max_withdraw_amount, m.agent_status,
m.total_valid_bet_amount,
m.vip_raw_total_valid_bet_amount, m.vip_turnover_adjustment,
m.remain_level_start_date,
m.current_remain_level_bet_amount,
cp.plan_name AS commission_plan_name,
pu.name AS parent_agent_name,
pu.agent_level AS parent_agent_level,
pu.star_level AS parent_agent_star_level,
m.agent_domain,
/* 子数量 */
(SELECT COUNT(*) FROM member_user
WHERE agent_code = m.id AND IFNULL(user_type,1) = 1) AS sub_agent_count,
(SELECT COUNT(*) FROM member_user
WHERE agent_code = m.id AND IFNULL(user_type,0) = 0) AS sub_member_count
,
(SELECT mar.actual_amount
FROM member_account_record mar
WHERE mar.member_id = m.id
AND mar.transaction_type = 1
AND mar.status = 3
ORDER BY mar.id ASC
LIMIT 1) AS first_deposit_amount
FROM member_user m
LEFT JOIN member_team mt ON m.team_code = mt.team_code
LEFT JOIN site s ON m.site_code = s.code
LEFT JOIN commission_plan cp ON m.commission_plan_id = cp.id
LEFT JOIN member_user pu ON m.agent_code = pu.id
) u
where u.id = ? [2939]
01:35:08.315 [http-nio-9080-exec-95] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:35:11.599 [http-nio-9080-exec-58] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:35:11.722 [http-nio-9080-exec-96] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:35:12.833 [http-nio-9080-exec-72] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:35:16.764 [http-nio-9080-exec-61] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:35:18.613 [http-nio-9080-exec-30] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:35:18.874 [http-nio-9080-exec-89] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:35:20.078 [http-nio-9080-exec-51] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:35:21.297 [http-nio-9080-exec-56] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:35:24.844 [http-nio-9080-exec-81] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:35:25.841 [http-nio-9080-exec-83] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:35:29.737 [http-nio-9080-exec-36] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:35:30.557 [http-nio-9080-exec-86] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:35:31.769 [http-nio-9080-exec-63] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:35:31.774 [http-nio-9080-exec-65] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:35:31.802 [http-nio-9080-exec-14] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:35:32.137 [http-nio-9080-exec-9] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:35:33.456 [http-nio-9080-exec-15] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:35:35.175 [http-nio-9080-exec-48] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:35:35.407 [http-nio-9080-exec-94] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:35:35.414 [http-nio-9080-exec-13] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:35:35.720 [http-nio-9080-exec-12] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:35:38.307 [http-nio-9080-exec-37] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:35:41.734 [http-nio-9080-exec-53] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:35:45.273 [http-nio-9080-exec-52] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:35:45.399 [http-nio-9080-exec-79] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:35:45.583 [http-nio-9080-exec-28] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:35:46.771 [http-nio-9080-exec-31] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:35:47.938 [http-nio-9080-exec-75] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:35:48.612 [http-nio-9080-exec-100] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:35:48.895 [http-nio-9080-exec-90] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:35:50.082 [http-nio-9080-exec-58] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:35:51.293 [http-nio-9080-exec-22] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:35:51.444 [http-nio-9080-exec-29] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:35:54.844 [http-nio-9080-exec-10] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:35:55.842 [http-nio-9080-exec-32] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:35:58.883 [http-nio-9080-exec-85] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:35:59.733 [http-nio-9080-exec-89] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:01.482 [http-nio-9080-exec-56] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:01.902 [http-nio-9080-exec-73] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:03.456 [http-nio-9080-exec-50] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:03.845 [http-nio-9080-exec-81] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:03.900 [http-nio-9080-exec-85] ERROR c.a.d.f.s.StatFilter - [internalAfterStatementExecute,518] - slow sql 4743 millis. SELECT u.* FROM (
SELECT
m.id, m.name, m.password, m.withdraw_password, m.real_name, m.avatar, m.parent, m.reg_time, m.last_login_time,
m.last_login_ip, m.last_login_region, m.app_version, m.status, m.vip_level, m.invite_code,
m.enter_invite_code, m.team_code, m.agent_team_id, m.team_role,
m.team_agent_identity, m.referrer_agent_id,
m.developer_name, m.recruiter_user_id,
mt.title AS team_name,
m.site_code, m.agent_code,
COALESCE(s.name_zn, m.site_code) AS site_name,
m.from_source, m.from_domain, m.is_agent, m.from_ip, m.from_ip_region,
m.is_site_admin_binding,
m.commission_plan_id, m.google_key,
case when m.google_key is not null and m.google_key != '' then '0' else '1' end as google_auth_status,
m.last_active_time, m.last_entry_venue,
m.user_type, m.agent_level, m.star_level, m.agent_remark,
m.phone, m.email, m.qq, m.wechat,
m.promotion_code, m.commission_rate,
m.bear_all_operation_expense, m.bear_operation_expense_types,
m.settlement_cycle,
m.min_withdraw_amount, m.max_withdraw_amount, m.agent_status,
m.total_valid_bet_amount,
m.vip_raw_total_valid_bet_amount, m.vip_turnover_adjustment,
m.remain_level_start_date,
m.current_remain_level_bet_amount,
cp.plan_name AS commission_plan_name,
pu.name AS parent_agent_name,
pu.agent_level AS parent_agent_level,
pu.star_level AS parent_agent_star_level,
m.agent_domain,
/* 子数量 */
(SELECT COUNT(*) FROM member_user
WHERE agent_code = m.id AND IFNULL(user_type,1) = 1) AS sub_agent_count,
(SELECT COUNT(*) FROM member_user
WHERE agent_code = m.id AND IFNULL(user_type,0) = 0) AS sub_member_count
,
(SELECT mar.actual_amount
FROM member_account_record mar
WHERE mar.member_id = m.id
AND mar.transaction_type = 1
AND mar.status = 3
ORDER BY mar.id ASC
LIMIT 1) AS first_deposit_amount
FROM member_user m
LEFT JOIN member_team mt ON m.team_code = mt.team_code
LEFT JOIN site s ON m.site_code = s.code
LEFT JOIN commission_plan cp ON m.commission_plan_id = cp.id
LEFT JOIN member_user pu ON m.agent_code = pu.id
) u
where u.id = ? [4339]
01:36:05.172 [http-nio-9080-exec-34] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:07.140 [http-nio-9080-exec-85] ERROR c.a.d.f.s.StatFilter - [internalAfterStatementExecute,518] - slow sql 3148 millis. select a.id, a.member_user_id, a.balance, a.commission_amount,
a.venue_code, a.is_main, a.status, a.amount_frozen,
a.withdrawable_amount, a.locked_amount, a.full_withdraw_required_turnover,
a.turnover_rule_version, a.turnover_rule_activated_at,
a.venue_transfer_revision,
a.yuebao_principal_amount, a.yuebao_interest_amount
from member_account a
where a.member_user_id = ? and a.is_main = 1
for update [4339]
01:36:07.253 [http-nio-9080-exec-16] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:08.314 [http-nio-9080-exec-2] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:11.530 [http-nio-9080-exec-47] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:11.732 [http-nio-9080-exec-26] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:12.895 [http-nio-9080-exec-9] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:16.760 [http-nio-9080-exec-49] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:18.611 [http-nio-9080-exec-35] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:18.882 [http-nio-9080-exec-12] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:20.083 [http-nio-9080-exec-88] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:21.287 [http-nio-9080-exec-77] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:24.869 [http-nio-9080-exec-11] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:25.834 [http-nio-9080-exec-79] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:29.737 [http-nio-9080-exec-75] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:30.564 [http-nio-9080-exec-74] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:31.763 [http-nio-9080-exec-95] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:31.766 [http-nio-9080-exec-97] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:31.799 [http-nio-9080-exec-58] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:32.265 [http-nio-9080-exec-96] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:33.462 [http-nio-9080-exec-72] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:35.165 [http-nio-9080-exec-23] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:35.351 [http-nio-9080-exec-71] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:38.315 [http-nio-9080-exec-4] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:41.104 [http-nio-9080-exec-80] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:41.108 [http-nio-9080-exec-17] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:41.117 [http-nio-9080-exec-56] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:41.359 [http-nio-9080-exec-73] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:41.556 [http-nio-9080-exec-87] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:41.733 [http-nio-9080-exec-82] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:42.008 [http-nio-9080-exec-50] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:43.186 [http-nio-9080-exec-93] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:43.187 [http-nio-9080-exec-1] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:43.190 [http-nio-9080-exec-8] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:43.347 [http-nio-9080-exec-83] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:45.789 [http-nio-9080-exec-39] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:46.767 [http-nio-9080-exec-26] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:47.660 [http-nio-9080-exec-62] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:47.984 [http-nio-9080-exec-65] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:48.614 [http-nio-9080-exec-9] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:48.886 [http-nio-9080-exec-84] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:49.181 [http-nio-9080-exec-36] ERROR c.a.d.f.s.StatFilter - [internalAfterStatementExecute,518] - slow sql 4736 millis. SELECT u.* FROM (
SELECT
m.id, m.name, m.password, m.withdraw_password, m.real_name, m.avatar, m.parent, m.reg_time, m.last_login_time,
m.last_login_ip, m.last_login_region, m.app_version, m.status, m.vip_level, m.invite_code,
m.enter_invite_code, m.team_code, m.agent_team_id, m.team_role,
m.team_agent_identity, m.referrer_agent_id,
m.developer_name, m.recruiter_user_id,
mt.title AS team_name,
m.site_code, m.agent_code,
COALESCE(s.name_zn, m.site_code) AS site_name,
m.from_source, m.from_domain, m.is_agent, m.from_ip, m.from_ip_region,
m.is_site_admin_binding,
m.commission_plan_id, m.google_key,
case when m.google_key is not null and m.google_key != '' then '0' else '1' end as google_auth_status,
m.last_active_time, m.last_entry_venue,
m.user_type, m.agent_level, m.star_level, m.agent_remark,
m.phone, m.email, m.qq, m.wechat,
m.promotion_code, m.commission_rate,
m.bear_all_operation_expense, m.bear_operation_expense_types,
m.settlement_cycle,
m.min_withdraw_amount, m.max_withdraw_amount, m.agent_status,
m.total_valid_bet_amount,
m.vip_raw_total_valid_bet_amount, m.vip_turnover_adjustment,
m.remain_level_start_date,
m.current_remain_level_bet_amount,
cp.plan_name AS commission_plan_name,
pu.name AS parent_agent_name,
pu.agent_level AS parent_agent_level,
pu.star_level AS parent_agent_star_level,
m.agent_domain,
/* 子数量 */
(SELECT COUNT(*) FROM member_user
WHERE agent_code = m.id AND IFNULL(user_type,1) = 1) AS sub_agent_count,
(SELECT COUNT(*) FROM member_user
WHERE agent_code = m.id AND IFNULL(user_type,0) = 0) AS sub_member_count
,
(SELECT mar.actual_amount
FROM member_account_record mar
WHERE mar.member_id = m.id
AND mar.transaction_type = 1
AND mar.status = 3
ORDER BY mar.id ASC
LIMIT 1) AS first_deposit_amount
FROM member_user m
LEFT JOIN member_team mt ON m.team_code = mt.team_code
LEFT JOIN site s ON m.site_code = s.code
LEFT JOIN commission_plan cp ON m.commission_plan_id = cp.id
LEFT JOIN member_user pu ON m.agent_code = pu.id
) u
where u.id = ? [3994]
01:36:50.074 [http-nio-9080-exec-48] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:51.289 [http-nio-9080-exec-94] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:53.892 [http-nio-9080-exec-36] ERROR c.a.d.f.s.StatFilter - [internalAfterStatementExecute,518] - slow sql 4678 millis. SELECT u.* FROM (
SELECT
m.id, m.name, m.password, m.withdraw_password, m.real_name, m.avatar, m.parent, m.reg_time, m.last_login_time,
m.last_login_ip, m.last_login_region, m.app_version, m.status, m.vip_level, m.invite_code,
m.enter_invite_code, m.team_code, m.agent_team_id, m.team_role,
m.team_agent_identity, m.referrer_agent_id,
m.developer_name, m.recruiter_user_id,
mt.title AS team_name,
m.site_code, m.agent_code,
COALESCE(s.name_zn, m.site_code) AS site_name,
m.from_source, m.from_domain, m.is_agent, m.from_ip, m.from_ip_region,
m.is_site_admin_binding,
m.commission_plan_id, m.google_key,
case when m.google_key is not null and m.google_key != '' then '0' else '1' end as google_auth_status,
m.last_active_time, m.last_entry_venue,
m.user_type, m.agent_level, m.star_level, m.agent_remark,
m.phone, m.email, m.qq, m.wechat,
m.promotion_code, m.commission_rate,
m.bear_all_operation_expense, m.bear_operation_expense_types,
m.settlement_cycle,
m.min_withdraw_amount, m.max_withdraw_amount, m.agent_status,
m.total_valid_bet_amount,
m.vip_raw_total_valid_bet_amount, m.vip_turnover_adjustment,
m.remain_level_start_date,
m.current_remain_level_bet_amount,
cp.plan_name AS commission_plan_name,
pu.name AS parent_agent_name,
pu.agent_level AS parent_agent_level,
pu.star_level AS parent_agent_star_level,
m.agent_domain,
/* 子数量 */
(SELECT COUNT(*) FROM member_user
WHERE agent_code = m.id AND IFNULL(user_type,1) = 1) AS sub_agent_count,
(SELECT COUNT(*) FROM member_user
WHERE agent_code = m.id AND IFNULL(user_type,0) = 0) AS sub_member_count
,
(SELECT mar.actual_amount
FROM member_account_record mar
WHERE mar.member_id = m.id
AND mar.transaction_type = 1
AND mar.status = 3
ORDER BY mar.id ASC
LIMIT 1) AS first_deposit_amount
FROM member_user m
LEFT JOIN member_team mt ON m.team_code = mt.team_code
LEFT JOIN site s ON m.site_code = s.code
LEFT JOIN commission_plan cp ON m.commission_plan_id = cp.id
LEFT JOIN member_user pu ON m.agent_code = pu.id
) u
where u.id = ? [3994]
01:36:53.905 [http-nio-9080-exec-62] ERROR c.a.d.f.s.StatFilter - [internalAfterStatementExecute,518] - slow sql 6231 millis. update member_user
set last_active_time = now()
where id = ? [3994]
01:36:54.837 [http-nio-9080-exec-88] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:55.846 [http-nio-9080-exec-77] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:36:59.741 [http-nio-9080-exec-7] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:37:00.950 [http-nio-9080-exec-52] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:37:01.479 [http-nio-9080-exec-28] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:37:02.153 [http-nio-9080-exec-46] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:37:02.283 [http-nio-9080-exec-31] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:37:03.460 [http-nio-9080-exec-69] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:37:03.615 [http-nio-9080-exec-74] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:37:03.843 [http-nio-9080-exec-38] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:37:05.171 [http-nio-9080-exec-22] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:37:08.307 [http-nio-9080-exec-43] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'
01:37:08.727 [http-nio-9080-exec-74] ERROR c.a.d.f.s.StatFilter - [internalAfterStatementExecute,518] - slow sql 4676 millis. SELECT u.* FROM (
SELECT
m.id, m.name, m.password, m.withdraw_password, m.real_name, m.avatar, m.parent, m.reg_time, m.last_login_time,
m.last_login_ip, m.last_login_region, m.app_version, m.status, m.vip_level, m.invite_code,
m.enter_invite_code, m.team_code, m.agent_team_id, m.team_role,
m.team_agent_identity, m.referrer_agent_id,
m.developer_name, m.recruiter_user_id,
mt.title AS team_name,
m.site_code, m.agent_code,
COALESCE(s.name_zn, m.site_code) AS site_name,
m.from_source, m.from_domain, m.is_agent, m.from_ip, m.from_ip_region,
m.is_site_admin_binding,
m.commission_plan_id, m.google_key,
case when m.google_key is not null and m.google_key != '' then '0' else '1' end as google_auth_status,
m.last_active_time, m.last_entry_venue,
m.user_type, m.agent_level, m.star_level, m.agent_remark,
m.phone, m.email, m.qq, m.wechat,
m.promotion_code, m.commission_rate,
m.bear_all_operation_expense, m.bear_operation_expense_types,
m.settlement_cycle,
m.min_withdraw_amount, m.max_withdraw_amount, m.agent_status,
m.total_valid_bet_amount,
m.vip_raw_total_valid_bet_amount, m.vip_turnover_adjustment,
m.remain_level_start_date,
m.current_remain_level_bet_amount,
cp.plan_name AS commission_plan_name,
pu.name AS parent_agent_name,
pu.agent_level AS parent_agent_level,
pu.star_level AS parent_agent_star_level,
m.agent_domain,
/* 子数量 */
(SELECT COUNT(*) FROM member_user
WHERE agent_code = m.id AND IFNULL(user_type,1) = 1) AS sub_agent_count,
(SELECT COUNT(*) FROM member_user
WHERE agent_code = m.id AND IFNULL(user_type,0) = 0) AS sub_member_count
,
(SELECT mar.actual_amount
FROM member_account_record mar
WHERE mar.member_id = m.id
AND mar.transaction_type = 1
AND mar.status = 3
ORDER BY mar.id ASC
LIMIT 1) AS first_deposit_amount
FROM member_user m
LEFT JOIN member_team mt ON m.team_code = mt.team_code
LEFT JOIN site s ON m.site_code = s.code
LEFT JOIN commission_plan cp ON m.commission_plan_id = cp.id
LEFT JOIN member_user pu ON m.agent_code = pu.id
) u
where u.id = ? [3994]
01:37:09.297 [http-nio-9080-exec-59] ERROR c.r.f.w.s.TokenService - [getLoginUser,144] - 获取用户信息异常'JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.'