MetaMiner Query Agent Logs¶
LOGBack configuration for MetaMiner Query Agent is specified by the Dlogback.configurationFile vmarg system variable in MetaMinerQueryAgent.ini file.
Its default value is MetaMinerQueryAgent.logback.xml
By default, the most of MetaMiner Query Agent logs are stored in <METAMINER INSTALLATION DIRECTORY>\server\logs, but you can define alternative locations by changing MetaMinerQueryAgent.logback.xml, all paths in this file are relative to the <METAMINER INSTALLATION DIRECTORY>\server directory.
Query Agent Main Log¶
This is the main Query Agent log. Use it to diagnose any problem with Query Agent.
| Appender | FILE |
| Config | MetaMinerQueryAgent.logback.xml |
| Default Output | file |
| Default Filename | queryagent.log |
| Default Level | DEBUG for MetaMiner modules, WARN for others |
| Default Rotation/Retention | max 5MB, max 10 volumes |
| Default Encoder (format) | %date{dd.MM;HH:mm:ss.SSS} [%thread] %-5level %logger{35} - %msg%n |
Example:
21.09;06:46:46.728 [QueryServiceAgent Query Worker Thread-2] DEBUG com.infolytik.server.service.Zed - Query Request 1937 from user1234. Processing query: 647d0294-52fd-4782-8e83-ddc90c598ea6
Query: SELECT DISTINCT wb.env_id
,s.name AS ...
21.09;06:46:46.732 [QueryServiceAgent Query Worker Thread-2] ERROR com.infolytik.server.service.Zej - Failed to execute query 647d0294-52fd-4782-8e83-ddc90c598ea6:org.postgresql.util.PSQLException: ERROR: missing FROM-clause entry for table "tableau"
Position: 517
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2477)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2190)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:300)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:428)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:354)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:301)
at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:287)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:264)
at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:231)
at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
at com.infolytik.server.service.Zej.Za(Zej.java:165)
at com.infolytik.server.service.Zej.Za(Zej.java:115)
at com.infolytik.server.service.Zed.Za(Zed.java:746)
at com.infolytik.server.service.Zed.Zb(Zed.java:62)
at com.infolytik.server.service.Zeh.run(Zeh.java:525)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Query Agent Loader Log¶
This is the log of the Windows OS executable which runs MetaMiner Query Agent process. The loader sends logging information to stdout and stderr streams. This information is then written to a log file.
| Appender | STDOUT, STDERR |
| Config | MetaMinerQueryAgent.ini and MetaMinerQueryAgent.logback.xml |
| Ini config variable | log |
| Default Output | console, redirected to a file |
| Default Filename | queryagent.start.log |
| Default Level | DEBUG |
| Default Encoder (format) | %-4relative [%thread] %-5level %logger{35} - %msg %n |
Example:
[info] Module Name: C:\Program Files\Infolytik\MetaMiner\server\metaminerqueryagent.exe
[info] Module INI: C:\Program Files\Infolytik\MetaMiner\server\metaminerqueryagent.ini
[info] Module Dir: C:\Program Files\Infolytik\MetaMiner\server\
[info] INI Dir: C:\Program Files\Infolytik\MetaMiner\server\
[info] Working directory set to: C:\Program Files\Infolytik\MetaMiner\server
[info] Configured vm.location: ..\jre\bin\server\jvm.dll
[info] Found VM: C:\Program Files\Infolytik\MetaMiner\jre\bin\server\jvm.dll
[info] Expanding Classpath: lib\*.jar
Query Agent Long Query Log¶
This is a database connection slow log. When some database query is longer than a threshold, it is logged here. Normally, it is empty.
| Appender | QUERY_SERVICE_LONG_QUERY_FILE |
| Config | MetaMinerQueryAgent.logback.xml |
| Default Output | file |
| Default Filename | queryagentlongquery.log |
| Default Level | DEBUG for MetaMiner modules, WARN for others |
| Default Rotation/Retention | max 5MB, max 10 volumes |
| Default Encoder (format) | %date{dd.MM;HH:mm:ss.SSS} [%thread] %-5level %logger{35} - %msg%n |
Query Agent Query Log¶
MetaMiner Query Agent dumps all queries into this log. You can quickly see the original SQL and the execution status: success or error. Use it to determine which queries run smoothly and which fail and why.
| Appender | QUERY_SERVICE_QUERY_FILE |
| Config | MetaMinerQueryAgent.logback.xml |
| Default Output | file |
| Default Filename | queryagentquery.log |
| Default Level | DEBUG for MetaMiner modules, WARN for others |
| Default Rotation/Retention | max 5MB, max 10 volumes |
| Default Encoder (format) | %date{dd.MM;HH:mm:ss.SSS} [%thread] %-5level %logger{35} - %msg%n |
Example:
21.09;05:53:52.835 [QueryServiceAgent Query Worker Thread-0] ERROR com.infolytik.server.service.Zed - Unable to retrieve result set for query: SELECT *
FROM (
SELECT wb.ENV_ID, wb.luid,wb.name wb_name,v.name,USER_ID
, (vs.time) --The time of the most recent access of the specified view by the specified user.
FROM workbooks wb
INNER JOIN views v ON v.workbook_id = wb.id
LEFT OUTER JOIN views_stats vs ON vs.view_id = v.id
GROUP BY wb.name, wb.luid
) vs
WHERE vs.last_access_view > '2020-09-01'
AND wb.env_id = 1627301360850
--OR vs.last_access_view IS NULL
ORDER BY 1
com.infolytik.netty.ServerException: ERROR: relation "workbooks" does not exist
Position: 183
at com.infolytik.server.service.Zej.Za(Zej.java:149)
at com.infolytik.server.service.Zed.Za(Zed.java:746)
at com.infolytik.server.service.Zed.Zb(Zed.java:62)
at com.infolytik.server.service.Zeh.run(Zeh.java:525)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)