Troubleshooting Analytics Support
Monitoring Analytics Server
The Presto server provides a live monitoring dashboard that shows running
and completed queries. You can access the dashboard by visiting localhost:8989
in a web browser.
Debug CLI
The SQL CLI is recommended for troubleshooting analytics connection and configuration issues.
Launch the CLI in debug mode:
./presto --server <local-ip OR localhost>:8989 --debug
Checking Analytics Server Status
In the debug CLI, run the following system queries:
SHOW SCHEMAS FROM system; SHOW TABLES FROM system.runtime;
If these queries work correctly your analytics system is up and functioning correctly.
If you do not see results from these queries, you should ensure that you have both Peer Server and Presto server running.
Troubleshooting Configuration Issues
If you encounter a schemaName is null
error when using the CLI,
you may have a catalog or metaschema configuration issue.
Run the following query in the debug CLI:
SELECT * FROM system.metadata.catalogs;
The results of this query will include all catalog~s that are available in the
analytics system. You should see [[file:analytics-configuring.html#configuring-catalog][your catalog]]
listed in the results. If you do not, you should ensure that you have
[[file:analytics-configuring.html#configuring-catalog][created]] your catalog properties file correctly. Be sure
that you have the correct directory structure (a ~catalog
and a datomic
directory).
Another possible cause of this error is that your metaschema file is not properly formatted edn or is not correctly located. Also, verify that your metaschema file ends with a .edn extension.
Troubleshooting Metaschema
If you are able to connect using your catalog and schema, but don't see your expected tables, you likely have a misconfiguration of your metaschema file.
Metaschemas are dynamically associated with Datomic databases and errors or typos in metaschemas can prevent association, resulting in the lack of any Presto tables.
Start the SQL CLI with your catalog and schema names and run the following:
SHOW tables;
You should see at least two tables: db__idents
and db__attrs
, which are both automatically generated
for any Datomic database.
You can examine the contents of these tables with:
SELECT * FROM db__idents; SELECT * FROM db__attrs;
The contents of these tables indicate the attributes and idents that Datomic analytics was able to read
from your Datomic database. If you do not see any additional tables, your metaschema does not match the
schema of this Datomic database. Ensure that all attributes listed in your metaschema file exist in your
Datomic database (or in the two db__
tables in Presto) and that you have not accidentially mistyped or
included an attribute that is not present in your database.