MENTDB  
BACK
MQL Functions | MentDB Weak
Log

You have a log engine in rolling.

log tracelog writelog showlog current idlog retention daylog removelog archive sizelog archive pathlog resetlog searchlog show_time

log trace <text>

Description

    To write a message into the log system

Parameters

    text:   The text - string - required
admin
log trace test;
mentdb
1

log write <msg> <status> <clientKey> <clientValue>

Description

    To write a message into MySQL

Parameters

    msg:   The message to write - string - required
    status:   The status - string - required
    clientKey:   The client key - string - required
    clientValue:   The client value - string - required
admin
log write "My message ..." OK "cmd" 425;
mentdb
1

log show <nbLine>

Description

    To show last write text into the log system

Parameters

    nbLine:   The number of line - integer - not required
admin
log show 5;
mentdb
2017-06-05 10:35:42.375+0400: 43<br>2017-06-05 10:35:42.375+0400: 44<br>2017-06-05 10:35:42.380+0400: 1: your messffage ...<br>2017-06-05 10:35:42.896+0400: test<br>
admin
log show
mentdb
2017-06-05 10:35:42.375+0400: 43<br>2017-06-05 10:35:42.375+0400: 44<br>2017-06-05 10:35:42.380+0400: 1: your messffage ...<br>2017-06-05 10:35:42.896+0400: test<br>

log current id

Description

    To show the current log id

admin
log current id
mentdb
1

log retention day

Description

    To show the log retention day

admin
log retention day
mentdb
50

log remove

Description

    To remove logs with retention day

admin
log remove;
mentdb
1

log archive size

Description

    To show the size for one archive file

admin
log archive size
mentdb
30

log archive path

Description

    Get the path to save archives

admin
log archive path
mentdb
archives/logs

log reset <code>

Description

    To reset the log system

Parameters

    code:   The code to reset all tables (18061980) - integer - not required
admin
log reset "xxx";
mentdb
1
Description

    To search log

Parameters

    status:   The status (ok|ko) - string - required
    script:   The script (can be null) - string - required
    c_key:   The client key - string - required
    c_value:   The client value - string - required
    msgFilter:   The message filter - string - required
    dtMin:   The min date - string - required
    dtMax:   The max date - string - required
    dtOrder:   The order (ASC|DESC) - string - required
    page:   The page - number - required
    nbByPage:   The number of line by page - number - required
admin
log search "ko" 
	null 
	null 
	null 
	null 
	(date datedifft (concat (date sysdate) " 00:00:00") "DAY" 0)
	(concat (date sysdate) " 23:59:59") 
	ASC 1 5;
mentdb
{"column_types":["STRING","STRING","STRING","STRING","STRING","STRING","STRING","STRING","LONG"],"data":[],"columns":["dtInsert","status","script","parent_pid","pid","c_key","c_val","msg","id"],"title":"log "}"

log show_time <nodename> <pid>

Description

    To show log throught the time

Parameters

    nodename:   The node name - string - not required
    pid:   The process id - string - required
admin
log show_time 17
mentdb
{"column_types":["STRING","STRING","STRING","STRING","STRING","STRING","STRING","STRING","LONG"],"data":[{"msg":"[---- Begin script ----]","c_val":"","dtInsert":"2018-01-09 15:44:40","parent_pid":"","pid":"17","id":"887","c_key":"","script":"boot.execute.on.start.post","status":"ok"},{"msg":"[---- End script ----]","c_val":"","dtInsert":"2018-01-09 15:44:40","parent_pid":"","pid":"17","id":"888","c_key":"","script":"boot.execute.on.start.post","status":"ok"},{"msg":"[---- Begin script ----]","c_val":"","dtInsert":"2018-01-22 07:12:22","parent_pid":"","pid":"17","id":"1307","c_key":"","script":"boot.execute.on.start.post","status":"ok"},{"msg":"[---- End script ----]","c_val":"","dtInsert":"2018-01-22 07:12:22","parent_pid":"","pid":"17","id":"1308","c_key":"","script":"boot.execute.on.start.post","status":"ok"},{"msg":"[---- Begin script ----]","c_val":"","dtInsert":"2018-02-13 16:08:54","parent_pid":"","pid":"17","id":"2589","c_key":"","script":"boot.execute.on.start.post","status":"ok"},{"msg":"[---- End script ----]","c_val":"","dtInsert":"2018-02-13 16:08:54","parent_pid":"","pid":"17","id":"2590","c_key":"","script":"boot.execute.on.start.post","status":"ok"},{"msg":"[---- Begin script ----]","c_val":"","dtInsert":"2018-02-20 10:15:29","parent_pid":"","pid":"17","id":"2781","c_key":"","script":"boot.execute.on.start.post","status":"ok"},{"msg":"[---- End script ----]","c_val":"","dtInsert":"2018-02-20 10:15:29","parent_pid":"","pid":"17","id":"2782","c_key":"","script":"boot.execute.on.start.post","status":"ok"},{"msg":"[---- Begin script ----]","c_val":"","dtInsert":"2018-02-23 13:51:35","parent_pid":"","pid":"17","id":"3029","c_key":"","script":"boot.execute.on.start.post","status":"ok"},{"msg":"[---- End script ----]","c_val":"","dtInsert":"2018-02-23 13:51:35","parent_pid":"","pid":"17","id":"3030","c_key":"","script":"boot.execute.on.start.post","status":"ok"}],"columns":["dtInsert","status","script","parent_pid","pid","c_key","c_val","msg","id"],"title":"PID <17>"}

© 2012 - 2022