# Troubleshooting **URL:** https://forum.datomic.com/c/datomic-pro/troubleshooting/15.md [Latest](https://forum.datomic.com/latest.md) · [Categories](https://forum.datomic.com/categories.md) --- ## [About the Troubleshooting category](https://forum.datomic.com/t/about-the-troubleshooting-category/98)
**Author:** [@marshall](https://forum.datomic.com/u/marshall)\ **Replies:** 0
Troubleshooting Datomic On-Prem --- ## [Backup to other S3-compatible storages](https://forum.datomic.com/t/backup-to-other-s3-compatible-storages/2579)
**Author:** [@maxweber](https://forum.datomic.com/u/maxweber)\ **Replies:** 4\ **Last updated:** [July 28, 2025, 8:15am UTC](https://forum.datomic.com/t/backup-to-other-s3-compatible-storages/2579 "2025-07-28T08:15:02Z")
At the moment you are forced to use AWS S3 or the file system for Datomic backups. The latest Datomic Pro version uses the aws-s3-1.x SDK where it is not possible to change the S3\_ENDPOINT via an env var. This option has… --- ## [Performance degradation and heap overflow with large collection binding input](https://forum.datomic.com/t/performance-degradation-and-heap-overflow-with-large-collection-binding-input/2572)
**Author:** [@nikolayandr](https://forum.datomic.com/u/nikolayandr)\ **Replies:** 5\ **Last updated:** [July 18, 2025, 11:58am UTC](https://forum.datomic.com/t/performance-degradation-and-heap-overflow-with-large-collection-binding-input/2572 "2025-07-18T11:58:41Z")
Hi everyone, I’m working on a query pattern where I pass a large number of entity IDs into the query as a collection binding. Here’s a simplified version of the query: \[:find ?MaterialImpl1 :in $ \[?MaterialImpl1 ...\] … --- ## [OutOfMemoryError on both sides peer and transactor](https://forum.datomic.com/t/outofmemoryerror-on-both-sides-peer-and-transactor/2546)
**Author:** [@nikolayandr](https://forum.datomic.com/u/nikolayandr)\ **Replies:** 1\ **Last updated:** [February 27, 2025, 4:36pm UTC](https://forum.datomic.com/t/outofmemoryerror-on-both-sides-peer-and-transactor/2546 "2025-02-27T16:36:14Z")
Hi datomic team, are there any ideas what might happen when peer and transaction indicates about OutOfMemoryError, according lo the logs below I see it it somehow related to indexing, we started to get these errors recen… --- ## [Strange behavior when transacting historical data](https://forum.datomic.com/t/strange-behavior-when-transacting-historical-data/2485)
**Author:** [@Mikhail](https://forum.datomic.com/u/Mikhail)\ **Replies:** 6\ **Last updated:** [October 29, 2024, 10:10pm UTC](https://forum.datomic.com/t/strange-behavior-when-transacting-historical-data/2485 "2024-10-29T22:10:33Z")
I am trying to transact historical data from a Postgres database, and stumbled upon this strange case. Here’s the minimal example: (def uri (str "datomic:mem://" (str (gensym "mem-db-")))) (def schema \[{:db/id … --- ## [Jetty max threads error when enabling ping /health](https://forum.datomic.com/t/jetty-max-threads-error-when-enabling-ping-health/603)
**Author:** [@nestrada](https://forum.datomic.com/u/nestrada)\ **Replies:** 24\ **Last updated:** [October 14, 2024, 11:28am UTC](https://forum.datomic.com/t/jetty-max-threads-error-when-enabling-ping-health/603 "2024-10-14T11:28:11Z")
Hello, I’m running datomic pro within a Kubernetes cluster and I wanted to set up a liveness probe using the /health HTTP endpoint described here : java.lang.RuntimeException: Unable to start ping endpoint localhost:99… --- ## [Errors after upgrading to datomic pro 1.0.7180 from 1.0.7075](https://forum.datomic.com/t/errors-after-upgrading-to-datomic-pro-1-0-7180-from-1-0-7075/2454)
**Author:** [@nikolayandr](https://forum.datomic.com/u/nikolayandr)\ **Replies:** 4\ **Last updated:** [September 6, 2024, 3:46pm UTC](https://forum.datomic.com/t/errors-after-upgrading-to-datomic-pro-1-0-7180-from-1-0-7075/2454 "2024-09-06T15:46:07Z")
After upgrading to the newest datomic version we see in logs a huge amount of the next records: Exception in thread "async-dispatch-22" java.lang.ClassCastException: class clojure.core.async.impl.ioc\_macros$aset\_object … --- ## [Trying to make an excise work](https://forum.datomic.com/t/trying-to-make-an-excise-work/2411)
**Author:** [@wim.deblauwe](https://forum.datomic.com/u/wim.deblauwe)\ **Replies:** 5\ **Last updated:** [May 25, 2024, 12:07pm UTC](https://forum.datomic.com/t/trying-to-make-an-excise-work/2411 "2024-05-25T12:07:18Z")
I am trying out excise like this: First, I create a schema and some test data (I am using the Clojure REPL to run this) (require '\[datomic.client.api :as d\]) (def client (d/client {:server-type :datomic-local … --- ## [Buildup of datomic.index.TransposedData instances in heap causing crashes, unsure how to clear](https://forum.datomic.com/t/buildup-of-datomic-index-transposeddata-instances-in-heap-causing-crashes-unsure-how-to-clear/2365)
**Author:** [@DanDonley](https://forum.datomic.com/u/DanDonley)\ **Replies:** 5\ **Last updated:** [February 26, 2024, 4:15pm UTC](https://forum.datomic.com/t/buildup-of-datomic-index-transposeddata-instances-in-heap-causing-crashes-unsure-how-to-clear/2365 "2024-02-26T16:15:05Z")
We’ve been seeing frequent application crashes as a result of our app running out of memory. We looked at our metrics in AWS and found a strange pattern where the memory would spike periodically, then plateau. When the p… --- ## [Single-arity q, No :find clause specified](https://forum.datomic.com/t/single-arity-q-no-find-clause-specified/2330)
**Author:** [@sims](https://forum.datomic.com/u/sims)\ **Replies:** 4\ **Last updated:** [October 31, 2023, 11:11am UTC](https://forum.datomic.com/t/single-arity-q-no-find-clause-specified/2330 "2023-10-31T11:11:07Z")
Hello, I’m having trouble with the single-arity form of q. If I give this form, I get results: (d/q '\[:find ?e :where \[?e :account/account-number 123123\]\] db) =\> #{\[17592186045483\]} If I use the single-arity version,… --- ## [Datomic Console parse query contains hex string error](https://forum.datomic.com/t/datomic-console-parse-query-contains-hex-string-error/2313)
**Author:** [@muyinliu](https://forum.datomic.com/u/muyinliu)\ **Replies:** 1\ **Last updated:** [August 29, 2023, 11:44am UTC](https://forum.datomic.com/t/datomic-console-parse-query-contains-hex-string-error/2313 "2023-08-29T11:44:47Z")
Datomic Console parse query contains hex string error, e.g. \[:find ?e :where \[?e :movie/title "0x1"\] \] will be parse to: \[:find ?e :where \[?e :movie/title 1\] \] But the expected result is keep it as string "0x1". … --- ## [Lookup refs used within a transaction are resolved against not the last state of DB](https://forum.datomic.com/t/lookup-refs-used-within-a-transaction-are-resolved-against-not-the-last-state-of-db/2114)
**Author:** [@nikolayandr](https://forum.datomic.com/u/nikolayandr)\ **Replies:** 5\ **Last updated:** [August 29, 2023, 11:34am UTC](https://forum.datomic.com/t/lookup-refs-used-within-a-transaction-are-resolved-against-not-the-last-state-of-db/2114 "2023-08-29T11:34:32Z")
Hi, the next case was met by executing simultaneous transactions where one of transaction used lookup ref to resolve entity to be updated: Create entity e1 with unique attribute value \[:User/name "User-1"\] Retract ent… --- ## [Datomic Console NOT parse not-clause correctly](https://forum.datomic.com/t/datomic-console-not-parse-not-clause-correctly/2314)
**Author:** [@muyinliu](https://forum.datomic.com/u/muyinliu)\ **Replies:** 0\ **Last updated:** [August 21, 2023, 1:11pm UTC](https://forum.datomic.com/t/datomic-console-not-parse-not-clause-correctly/2314 "2023-08-21T13:11:36Z")
Datomic Console NOT parse not-clause correctly, e.g. query \[:find (count ?e) :where \[?e :artist/name ?name\] (not \[(clojure.string/includes? ?name "Foo")\]) \] will be parsed to: \[:find (count ?e) :where \[?e :artist… --- ## [AMQ219010: Connection is destroyed issue](https://forum.datomic.com/t/amq219010-connection-is-destroyed-issue/2060)
**Author:** [@deivydasofc](https://forum.datomic.com/u/deivydasofc)\ **Replies:** 5\ **Last updated:** [March 14, 2022, 12:03pm UTC](https://forum.datomic.com/t/amq219010-connection-is-destroyed-issue/2060 "2022-03-14T12:03:24Z")
Datomic version: 1.0.6362 After some time of working, clojure service is getting issues with failed connection to transactor: org.apache.activemq.artemis.api.core.ActiveMQNotConnectedException: AMQ219006: Channel disco… --- ## [New peer stuck long before connection initialization](https://forum.datomic.com/t/new-peer-stuck-long-before-connection-initialization/1848)
**Author:** [@DevynKong](https://forum.datomic.com/u/DevynKong)\ **Replies:** 0\ **Last updated:** [April 28, 2021, 8:32am UTC](https://forum.datomic.com/t/new-peer-stuck-long-before-connection-initialization/1848 "2021-04-28T08:32:56Z")
Dear team, with Datomic version - 0.9.6014 + PG11 Previously we were setup a peer running with 2 transactors (1 primary + 1 standby) connecting to PostgreSQL, everything goes well with the peer. Recently, we were abou… --- ## [Bad query performance or OOM for queries executing joining between two variables](https://forum.datomic.com/t/bad-query-performance-or-oom-for-queries-executing-joining-between-two-variables/1699)
**Author:** [@nikolayandr](https://forum.datomic.com/u/nikolayandr)\ **Replies:** 4\ **Last updated:** [November 25, 2020, 6:53pm UTC](https://forum.datomic.com/t/bad-query-performance-or-oom-for-queries-executing-joining-between-two-variables/1699 "2020-11-25T18:53:48Z")
I have the schema which can be described by the next relations Order 1-\>\* User 1-\>1 Address, in EDN it is is described by the next attributes: { :db/ident :User/address :db/valueType :db.type/ref :db/isComponent tru… --- ## [Datomic Pro not working on macOs Big Sur(11.0.1)](https://forum.datomic.com/t/datomic-pro-not-working-on-macos-big-sur-11-0-1/1689)
**Author:** [@abhinav](https://forum.datomic.com/u/abhinav)\ **Replies:** 1\ **Last updated:** [November 17, 2020, 2:07pm UTC](https://forum.datomic.com/t/datomic-pro-not-working-on-macos-big-sur-11-0-1/1689 "2020-11-17T14:07:50Z")
It fails when trying to connect or create db. strangely these work in bin/repl (d/connect uri) Execution error (ActiveMQConnectionTimedOutException) at org.apache.activemq.artemis.core.client.impl.ServerLocatorImpl/cr… --- ## [Stale data with dev storage protocol?](https://forum.datomic.com/t/stale-data-with-dev-storage-protocol/1581)
**Author:** [@miwal](https://forum.datomic.com/u/miwal)\ **Replies:** 2\ **Last updated:** [August 16, 2020, 6:03pm UTC](https://forum.datomic.com/t/stale-data-with-dev-storage-protocol/1581 "2020-08-16T18:03:48Z")
I’m using on-prem and the dev storage protocol running locally for development, with the client api. I’m rewriting a traditional (no-js) web application to use Datomic and Ring. I’m using a POST request which issues a t… --- ## [What is the format specification for \`datomic.databases\` in the catalog for presto/analytics?](https://forum.datomic.com/t/what-is-the-format-specification-for-datomic-databases-in-the-catalog-for-presto-analytics/1533)
**Author:** [@pieterbreed](https://forum.datomic.com/u/pieterbreed)\ **Replies:** 0\ **Last updated:** [July 23, 2020, 9:19am UTC](https://forum.datomic.com/t/what-is-the-format-specification-for-datomic-databases-in-the-catalog-for-presto-analytics/1533 "2020-07-23T09:19:43Z")
What is the format specification for datomic.databases in the catalog for presto/analytics? I’ve been through the on-prem docs for analytics a few times, but I can’t an example of this being specified. I’ve tried: dato… --- ## [Pull xform extensions](https://forum.datomic.com/t/pull-xform-extensions/1525)
**Author:** [@nestrada](https://forum.datomic.com/u/nestrada)\ **Replies:** 4\ **Last updated:** [July 21, 2020, 9:56am UTC](https://forum.datomic.com/t/pull-xform-extensions/1525 "2020-07-21T09:56:03Z")
Hello, I’m using datomic on-prem version 1.0.6165 and I’m trying to make use of the xform feature in the pull api. It states specifically that : The fn is either a fully qualified function allowed under the :xforms … --- ## [ClassNotFoundException com.amazonaws.services.dynamodbv2.model.SSESpecification with Datomic Pro 1.0.6165 and the currently recommended \[com.amazonaws/aws-java-sdk-dynamodb "1.11.82"\]](https://forum.datomic.com/t/classnotfoundexception-com-amazonaws-services-dynamodbv2-model-ssespecification-with-datomic-pro-1-0-6165-and-the-currently-recommended-com-amazonaws-aws-java-sdk-dynamodb-1-11-82/1481)
**Author:** [@vvvvalvalval](https://forum.datomic.com/u/vvvvalvalval)\ **Replies:** 1\ **Last updated:** [June 8, 2020, 8:59pm UTC](https://forum.datomic.com/t/classnotfoundexception-com-amazonaws-services-dynamodbv2-model-ssespecification-with-datomic-pro-1-0-6165-and-the-currently-recommended-com-amazonaws-aws-java-sdk-dynamodb-1-11-82/1481 "2020-06-08T20:59:33Z")
In summary: I strongly suspect that \[com.datomic/datomic-pro "1.0.6165"\] requires a more recent version of com.amazonaws/aws-java-sdk-dynamodb than 1.11.82, which is the currently recommended version in the docs : https:… --- ## [Meta of tx-data gets lost with non-dev transactor](https://forum.datomic.com/t/meta-of-tx-data-gets-lost-with-non-dev-transactor/1471)
**Author:** [@fjolne](https://forum.datomic.com/u/fjolne)\ **Replies:** 0\ **Last updated:** [May 27, 2020, 6:26pm UTC](https://forum.datomic.com/t/meta-of-tx-data-gets-lost-with-non-dev-transactor/1471 "2020-05-27T18:26:00Z")
Some of our tx functions use Clojure meta for additional context, and that works fine with dev transactor. However, in production environment (namely, with JDBC storage) meta appears to be lost and tx function receives d… --- ## [Entities Excision doesn’t take effect](https://forum.datomic.com/t/entities-excision-doesn-t-take-effect/1440)
**Author:** [@Devyn](https://forum.datomic.com/u/Devyn)\ **Replies:** 1\ **Last updated:** [May 8, 2020, 2:12pm UTC](https://forum.datomic.com/t/entities-excision-doesn-t-take-effect/1440 "2020-05-08T14:12:31Z")
Dear Datomic support, After I tried to excise some of specific entities and got the transact success result, found that the excision doesn’t take effect (space did not free up, can still touch the entities) even if i ra… --- ## ["Uri: Command Not Found" When Trying To Run "load-seattle-mem.bsh"](https://forum.datomic.com/t/uri-command-not-found-when-trying-to-run-load-seattle-mem-bsh/1385)
**Author:** [@JimLynchCodes](https://forum.datomic.com/u/JimLynchCodes)\ **Replies:** 15\ **Last updated:** [March 20, 2020, 1:51pm UTC](https://forum.datomic.com/t/uri-command-not-found-when-trying-to-run-load-seattle-mem-bsh/1385 "2020-03-20T13:51:28Z")
Hello! I recently download Datomic free and am able to run the server! I am also able to run the datamic console locally, but it seems there are no data / databases there! I am assuming the “load-seattle-mem.bsh” file… --- ## [HTTP 503 error with console + free edition](https://forum.datomic.com/t/http-503-error-with-console-free-edition/1070)
**Author:** [@gdanov](https://forum.datomic.com/u/gdanov)\ **Replies:** 2\ **Last updated:** [March 17, 2020, 3:27pm UTC](https://forum.datomic.com/t/http-503-error-with-console-free-edition/1070 "2020-03-17T15:27:33Z")
Hi, I downloaded datomic-free-0.9.5703.21 and datomic-console-0.1.216 then run bin/install-console in the console folder in the transactor dir run bin/console -p 8080 free datomic:free://localhost:4334/ and I can s… --- ## [\[Analytics\] Query big decimal column/scale option not working?](https://forum.datomic.com/t/analytics-query-big-decimal-column-scale-option-not-working/1376)
**Author:** [@iku000888](https://forum.datomic.com/u/iku000888)\ **Replies:** 2\ **Last updated:** [March 6, 2020, 2:27am UTC](https://forum.datomic.com/t/analytics-query-big-decimal-column-scale-option-not-working/1376 "2020-03-06T02:27:35Z")
Datomic version = 0.9.5981 Presto cli version = 323 I have a currency entity that has a component attribute amount that is a bigdec. I specified the scale as :currency/amount {:scale {:amount 4}} in the meta schema,… --- ## [Impossible to use d/as-of with java.util.Date](https://forum.datomic.com/t/impossible-to-use-d-as-of-with-java-util-date/1305)
**Author:** [@erikvanvelzen](https://forum.datomic.com/u/erikvanvelzen)\ **Replies:** 1\ **Last updated:** [February 4, 2020, 3:32pm UTC](https://forum.datomic.com/t/impossible-to-use-d-as-of-with-java-util-date/1305 "2020-02-04T15:32:17Z")
All the documentation says this should be possible: (def db (d/db conn)) =\> #'datomic-demo.entry/db (def new-db (d/as-of db (java.util.Date.))) =\> #'datomic-demo.entry/new-db (d/pull new-db '\[\*\] 17592186045421) Execut… --- ## [Can read but can't transact (on-premise peer lib)](https://forum.datomic.com/t/can-read-but-cant-transact-on-premise-peer-lib/1289)
**Author:** [@Device](https://forum.datomic.com/u/Device)\ **Replies:** 1\ **Last updated:** [December 16, 2019, 5:26pm UTC](https://forum.datomic.com/t/can-read-but-cant-transact-on-premise-peer-lib/1289 "2019-12-16T17:26:36Z")
Hello, I have a database that has reach a state where reads are working normally but every transaction throws a nullpointerexception with the following report (also part of log below): {:clojure.main/message "Executio… --- ## [Datomic Analytics: uri type not mapping correctly](https://forum.datomic.com/t/datomic-analytics-uri-type-not-mapping-correctly/1218)
**Author:** [@Joe](https://forum.datomic.com/u/Joe)\ **Replies:** 1\ **Last updated:** [November 4, 2019, 1:42pm UTC](https://forum.datomic.com/t/datomic-analytics-uri-type-not-mapping-correctly/1218 "2019-11-04T13:42:21Z")
Hi All, We’re trying out Datomic Analytics, and while it’s looking really promising, we’re having a couple of issues. One of them is that URI schema types don’t seem to map correctly from Datomic to Presto, I assume the… --- ## [Peer-server problem: Could not find datomic in catalog](https://forum.datomic.com/t/peer-server-problem-could-not-find-datomic-in-catalog/1160)
**Author:** [@luizsol](https://forum.datomic.com/u/luizsol)\ **Replies:** 1\ **Last updated:** [October 16, 2019, 3:51pm UTC](https://forum.datomic.com/t/peer-server-problem-could-not-find-datomic-in-catalog/1160 "2019-10-16T15:51:15Z")
Hi everyone. So here is my situation: I’m trying to start using datomic in my company’s projects so in order to do this I’m trying to deploy a on-premisses containerized solution using Posgresql and the Datomic Pro Start… [Next page](https://forum.datomic.com/c/datomic-pro/troubleshooting/15.md?page=1)