gplogfilter [log_files]
- Reference: https://gpdb.docs.pivotal.io/5180/utility_guide/admin_utilities/gplogfilter.html
- common options:
- -t : finds all ERROR, FATAL or PANIC
- -f 'string' : finds entries with string
- -F 'string' : finds entries without string
Example: Find today errors on master host
- cd $MASTER_DATA_DIRECTORIES/pg_log
- gplogfilter -t gpdb-$(date +%Y-%m-%d)-*.csv
Sample Output:
2019-04-29 11:51:03.846319 AEST|gpadmin|postgres|p18431|th2011295872|127.0.0.1|31865|2019-04-29 11:51:02 AEST|0|con227127|cmd200|seg-1||dx9770770||sx24|ERROR: |2BP01|role "n123456" cannot be dropped because some objects depend on it|1 objects in database test
| column | description | value in the above example |
| logtime | the timestamp | 2019-04-29 11:51:03.846319 AEST |
| loguser | database user | gpadmin |
| logdatabase | database name | postgres |
| logpid | process id | p18431 |
| logthread | thread count | th2011295872 |
| loghost | host name | 127.0.0.1 |
| logport | port | 31865 |
| logsessiontime | Time session connection was opened | 2019-04-29 11:51:02 AEST |
| logtransaction | Global transaction id | 0 |
| logsession | session identifier | con227127 |
| logcmdcount | The command number within a session | cmd200 |
| logsegment | The segment content identifier | seg-1| |
| logslice | The slice id | |
| logdistxact | Distributed transaction id | dx9770770 |
| loglocalxact | Local transaction id | |
| logsubxact | Subtransaction id | sx24 |
| logseverity | LOG,ERROR,FATAL,PANIC,DEBUG1 or DEBUG2 | ERROR |
| logstate | SQL state code (error code) | 2BP01 = dependent_objects_still_exist |
| logmessage | log or error message | role "n123456" cannot be dropped because some objects depend on it |
| logdetail | detail message associated with an error | 1 objects in database test |