2.4 KiB
mylog.timestamp 14:38:05.279 mylog.thread pool-4-thread-1 mylog.level INFO mylog.class c.f.e.d.c.SESServiceV2 mylog.method_line lambda$init$1,227 mylog.message Received message: ...
时间戳 - 程 - 日志等级 - [用户邮箱] [会话id] ip 错误描述 or 错误堆栈信息 or 其它
17:17:14.571 [http-nio-8080-exec-89] ERROR c.f.f.w.e.GlobalExceptionHandler - [handleServiceException,81] - 用户不存在/密码错误 堆栈信息
17:17:14.589 [schedule-pool-18] DEBUG c.f.s.m.S.insertLogininfor - [debug,135] - <== Updates: 1
17:17:14.580 [schedule-pool-18] INFO sys-user - [run,56] - [121.35.103.19]XX XX[rachel][Error][用户不存在/密码错误]
17:54:47.494 [Druid-ConnectionPool-Create-530523470] ERROR c.a.d.p.DruidDataSource - [run,2948] - create connection SQLException, url: jdbc:mysql://172.24.16.3:3306/creator_contact_record? 堆栈信息
17:30:05.980 [http-nio-8070-exec-64] DEBUG c.f.s.m.a.A.getDataBoard - [debug,135] - ==> Preparing: WITH TaskStats AS ( SELECT MIN(aeat.id) AS taskId, COUNT(DISTINCT aeatc.id) AS taskCount, COUNT(DISTINCT CASE WHEN aeatc.push_status = 1 THEN aeatc.id ELSE NULL END) AS invitedTalentCount, COUNT(DISTINCT CASE WHEN aeatc.push_status = 1 AND DATE(aeatc.create_time) = CURDATE() THEN aeatc.id ELSE NULL END) AS newInvitedTalentCount, COUNT(DISTINCT CASE WHEN aecm.open_status = 1 THEN aecm.id ELSE NULL END) AS openCount, COUNT(DISTINCT CASE WHEN aeatc.reply_status = 1 THEN aeatc.id ELSE NULL END) AS repliedCount, COUNT(DISTINCT CASE WHEN aeatc.reply_status = 1 AND DATE(aeatc.update_time) = CURDATE() THEN aeatc.id ELSE NULL END) AS newRepliedCount, MAX(aeat.task_status) as taskStatus, MAX(aeat.target_creator_count) as targetCreatorCount, MAX(aeat.execution_time) as executionTime, MAX(aeat.execution_days) as executionDays FROM agent_email_admin_task aeat JOIN agent_email_admin_task_creator aeatc ON aeat.id = aeatc.task_id AND aeatc.email_address NOT IN ( ? , ? , ? ) left join agent_email_chat_message aecm on aeat.id = aecm.task_id AND aecm.creator_email NOT IN ( ? , ? , ? ) WHERE aeat.dialogue_id = ? ) SELECT taskId, taskCount, invitedTalentCount, newInvitedTalentCount, openCount, repliedCount, newRepliedCount, CASE WHEN invitedTalentCount > 0 THEN ROUND((repliedCount / invitedTalentCount) * 100 , 2)/100 ELSE 0 END AS replyRate, taskStatus, targetCreatorCount, executionTime, executionDays FROM TaskStats