CODEWITHSUNDEEP
sqldatabasevoltdb
S_C
S_C

Reputation: 167

VOLTDB ERROR: SQL ERROR More than 100 MB of temp table memory used while executing SQL

I'm getting this error while querying a 10,000,000 database in VoltDB. Any idea on how to get around it?

VOLTDB ERROR: SQL ERROR More than 100 MB of temp table memory used while executing SQL.

Upvotes: 0

Views: 510

Answers (1)

Andrew
Andrew

Reputation: 311

You need to increase the temp table memory in your configuration file. It is 100 MB by default. See the temp table section of the docs here for more information: https://docs.voltdb.com/AdminGuide/HostConfigDBOpts.php

Full Disclosure: I work at VoltDB.

Upvotes: 1

Related Questions