Collecting Logs from GeminiDB Mongo

This function is currently available only to whitelisted users. If needed, submit a service ticket to GeminiDB. For details, see Submitting a Service Ticket.

Structuring Template Details of GeminiDB Mongo Error Logs

GeminiDB Mongo error log example

**Table 1** Structuring template example
Template Name	Example Log
GeminiDB Mongo error logs	{"log_type":"error_log","severity":"Error","log_time":"2022-08-22T09:33:15.142+0000","raw_message":"E QUERY [ClusterDisasterBackupChangeJob] Get global setting disasterBackup failed.","instance_id": "5b67dc63ba824145aae1f12ff51e58b8in02","node_id": "686a791e690e4db3af591ec4b6f72916no02"}

Table 1 Structuring template example

Template Name

Example Log

GeminiDB Mongo error logs

{"log_type":"error_log","severity":"Error","log_time":"2022-08-22T09:33:15.142+0000","raw_message":"E QUERY    [ClusterDisasterBackupChangeJob] Get global setting disasterBackup failed.","instance_id": "5b67dc63ba824145aae1f12ff51e58b8in02","node_id": "686a791e690e4db3af591ec4b6f72916no02"}

Structuring fields and description

**Table 2** Structuring fields
Field	Example	Description	Type
log_type	error_log	Log type	string
severity	Error	Log level.	string
log_time	2022-08-22T09:33:15.142+0000	Time when a log was generated	string
raw_message	E QUERY [ClusterDisasterBackupChangeJob] Get global setting disasterBackup failed.	Log content	string
instance_id	5b67dc63ba824145aae1f12ff51e58b8in02	Instance ID	string
node_id	686a791e690e4db3af591ec4b6f72916no02	Node ID	string

Structuring Template Details of GeminiDB Mongo Slow Query Logs

GeminiDB Mongo slow query log example

**Table 3** Structuring template example
Template Name	Example Log
GeminiDB Mongo slow query logs	{"log_type":"slow_log","log_time":"2022-08-20T10:04:03.204000Z","namespace":"data0820.table","database":"data0820","collection":"table","operate_type":"insert","docs_scanned":0,"docs_returned":0,"n_deleted":0,"n_matched":0,"n_modified":0,"n_inserted":10,"cost_time":555,"lock_time":0,"whole_message":{"op":"insert","ns":"data0820.usrtable","command":"{N}","ninserted":1,"keysInserted":1,"numYield":0,"locks":{"Global":{"acquireCount":{"r":5,"w":5}},"Database":{"acquireCount":{"w":4,"W":1}},"Collection":{"acquireCount":{"w":2}},"oplog":{"acquireCount":{"w":2}}},"responseLength":230,"protocol":"op_msg","millis":555,"ts":{"$date":1660989843204},"client":"192.168.0.64","appName":"MongoDBShell","allUsers":[{"user":"rwuser","db":"admin"}],"user":"rwuser@admin"},"instance_id":"5b67dc63ba824145aae1f12ff51e58b8in02","node_id":"686a791e690e4db3af591ec4b6f72916no02"}

Table 3 Structuring template example

Template Name

Example Log

GeminiDB Mongo slow query logs

{"log_type":"slow_log","log_time":"2022-08-20T10:04:03.204000Z","namespace":"data0820.table","database":"data0820","collection":"table","operate_type":"insert","docs_scanned":0,"docs_returned":0,"n_deleted":0,"n_matched":0,"n_modified":0,"n_inserted":10,"cost_time":555,"lock_time":0,"whole_message":{"op":"insert","ns":"data0820.usrtable","command":"{N}","ninserted":1,"keysInserted":1,"numYield":0,"locks":{"Global":{"acquireCount":{"r":5,"w":5}},"Database":{"acquireCount":{"w":4,"W":1}},"Collection":{"acquireCount":{"w":2}},"oplog":{"acquireCount":{"w":2}}},"responseLength":230,"protocol":"op_msg","millis":555,"ts":{"$date":1660989843204},"client":"192.168.0.64","appName":"MongoDBShell","allUsers":[{"user":"rwuser","db":"admin"}],"user":"rwuser@admin"},"instance_id":"5b67dc63ba824145aae1f12ff51e58b8in02","node_id":"686a791e690e4db3af591ec4b6f72916no02"}

Structuring fields and description

**Table 4** Structuring fields
Field	Example	Description	Type
log_type	slow_log	Log type	string
log_time	2022-08-20T10:04:03.204000Z	Time when a slow query log was generated	string
namespace	data0820.table	Namespace	string
database	data0820	Database name	string
collection	table	Table name	string
operate_type	insert	Operation type	string
docs_scanned	0	Number of scanned rows in the database	long
docs_returned	0	Number of rows in the query result	long
n_deleted	0	Number of deleted rows	long
n_matched	0	Number of matched rows updated	long
n_modified	0	Actual updated rows	long
n_inserted	10	Inserted rows	long
cost_time	555	Time spent on the operation	long
lock_time	0	wait_lock time	long
whole_message	{"op":"insert","ns":"data0820.usrtable","command":"{N}","ninserted":1,"keysInserted":1,"numYield":0,"locks":{"Global":{"acquireCount":{"r":5,"w":5}},"Database":{"acquireCount":{"w":4,"W":1}},"Collection":{"acquireCount":{"w":2}},"oplog":{"acquireCount":{"w":2}}},"responseLength":230,"protocol":"op_msg","millis":555,"ts":{"$date":1660989843204},"client":"192.168.0.64","appName":"MongoDBShell","allUsers":[{"user":"rwuser","db":"admin"}],"user":"rwuser@admin"}	Original log information	string
instance_id	5b67dc63ba824145aae1f12ff51e58b8in02	Instance ID	string
node_id	686a791e690e4db3af591ec4b6f72916no02	Node ID	string