Presto Analytics Intermittent behaviour: Assert failed: db must support tuples

Question

I’m trying to use Datomic analytics on Metabase, but after loading forever I’m checking schema and tables with presto CLI.

When getting columns from this table using small dev db I’m getting results but from a larger database with same schema I’m getting this error.

And I have no :db.type/tuple in my schema.

DESCRIBE Tenant;
Query 20221113_173617_00004_a7wmw failed: Assert failed: db must support tuples - see https://docs.datomic.com/client-api/datomic.client.api.html#var-administer-system
(:db/tupleTypes ret)

My metaschema.edn is:

{:tables {:tenant/name {:name Tenant}}
 :joins {}}

Any clues why?

Answer 1

Victor,

Is the DB you are running analytics against an older DB? Meaning was it created before our release of Tuples? We released tuples with 0.9.5927 which was in June of 2019. If your DB was created prior to that date you may need to run:

https://docs.datomic.com/on-prem/operation/deployment.html#upgrading-schema

Thanks,
Jaret

Comments

Perfect Jaret, that was precisely the issue, larger db was not yet upgraded.

After running '(d/administer-system {:uri ... :action :upgrade-schema} )' Presto now can query the db normally.

Thanks!
Victor