GP - PANIC / FATAL / ERROR message report

Generating the report to gather FATAL/PANIC/ERROR messages in the cluster in the last 2 days
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

Popular posts from this blog

GP - Kerberos errors and resolutions

How to set Optimizer at database level in greenplum

GP - SQL Joins