GP - PANIC / FATAL / ERROR message report
Generating the report to gather FATAL/PANIC/ERROR messages in the cluster in the last 2 days
am limit search interval to `2 days`, this can be increased as required.
NOTE: This SQL will take time to execute(time depends on how big the log file size is)
SELECT
logseverity AS "Severity",
logdatabase AS "Database name",
substr(logmessage, 1, 80) AS "Message",
count(*) AS "# of occurrence"
FROM
gp_toolkit.gp_log_system
WHERE
logseverity in ('ERROR','FATAL','PANIC')
AND logtime between now() - interval '2 days'
AND now()
AND logmessage not like '%check_greenplum%'
GROUP BY
logseverity,logdatabase,logmessage
ORDER BY 4 DESC ;
In above SQL ;am limit search interval to `2 days`, this can be increased as required.
NOTE: This SQL will take time to execute(time depends on how big the log file size is)
Comments
Post a Comment