 | MentDB Weak MQL Functions |
Back to MQL Functions root
Go to MentDB Weak
Go to Innov-AI
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
To write a message into the log system
Parameters
text: The text - string - required
text: The text - string - required
admin
log trace test;
mentdb
1
log write <msg> <status> <clientKey> <clientValue>
Description
To write a message into MySQL
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
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
To show last write text into the log system
Parameters
nbLine: The number of line - integer - not required
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
To show the current log id
admin
log current id
mentdb
1
log retention day
Description
To show the log retention day
To show the log retention day
admin
log retention day
mentdb
50
log remove
Description
To remove logs with retention day
To remove logs with retention day
admin
log remove;
mentdb
1
log archive size
Description
To show the size for one archive file
To show the size for one archive file
admin
log archive size
mentdb
30
log archive path
Description
Get the path to save archives
Get the path to save archives
admin
log archive path
mentdb
archives/logs
log reset <code>
Description
To reset the log system
To reset the log system
Parameters
code: The code to reset all tables (18061980) - integer - not required
code: The code to reset all tables (18061980) - integer - not required
admin
log reset "xxx";
mentdb
1
log search <status> <script> <c_key> <c_value> <msgFilter> <dtMin> <dtMax> <dtOrder> <page> <nbByPage>
Description
To search log
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
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
To show log throught the time
Parameters
nodename: The node name - string - not required
pid: The process id - string - required
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>"}
French Technology© 2004-2012 - 2022