Application, System, and Mobile App crash logs.

Table schema

Name Type Description
type TEXT Type of crash log
pid BIGINT Process (or thread) ID of the crashed process
path TEXT Path to the crashed process
crash_path TEXT Location of log file
identifier TEXT Identifier of the crashed process
version TEXT Version info of the crashed process
parent BIGINT Parent PID of the crashed process
responsible TEXT Process responsible for the crashed process
uid INTEGER User ID of the crashed process
datetime TEXT Date/Time at which the crash occurred
crashed_thread BIGINT Thread ID which crashed
stack_trace TEXT Most recent frame from the stack trace
exception_type TEXT Exception type of the crash
exception_codes TEXT Exception codes from the crash
exception_notes TEXT Exception notes from the crash
registers TEXT The value of the system registers

Query examples

select * from users join crashes using (uid)