This application discloses a
database-based method, apparatus, and
system for
web service log analysis and error tracing, comprising: acquiring runtime exception logs containing thread ID,
timestamp, and
call stack, and interface access logs containing interface name, thread ID, interface entry
timestamp, and
response time; accurately matching the two types of log records based on the condition that the thread IDs are the same and the runtime exception
timestamp is within the window formed by the interface entry timestamp and the interface entry timestamp plus the
response time; associating the matched interface with the responsible developer based on a pre-defined interface-developer mapping relationship; and finally pushing the error details and developer information to the corresponding terminal. This application utilizes the thread ID + time window matching mechanism and responsibility mapping to automate the entire process from error discovery and responsibility determination to dispatch, solving the problems of difficult
error location, unclear responsibility attribution, and low dispatch efficiency in large-scale development teams, and significantly shortening the
problem resolution cycle.