Forum: Building VoltDB Applications

Post: join between 2 table failed (more than 100MB of temp table memory used while executi

join between 2 table failed (more than 100MB of temp table memory used while executi
shetty_ritesh
May 7, 2010
Hi ,

I took 2 huge tables 1 with 5 million records and one with 1 million records. I did a join between them and i get the following error

[java] org.voltdb.client.ProcCallException:
[java] ===============================================================================
[java] VOLTDB ERROR: SQL ERROR
[java] More than 100MB of temp table memory used while executing SQL. Aborting.
[java] at com.dnbgp.company.SelectTopTen.run(SelectTopTen.java:21)
[java] ===============================================================================
[java]
[java] at org.voltdb.client.SyncCallback.result(SyncCallback.java:82)
[java] at org.voltdb.client.ClientImpl.callProcedure(ClientImpl.java:148)
[java] at com.dnbgp.company.TopTenCompanies.getTopten(TopTenCompanies.java:96)
[java] at com.dnbgp.company.TopTenCompanies.main(TopTenCompanies.java:59)
[java] Caused by: org.voltdb.exceptions.SQLException: More than 100MB of temp table memory used while executing SQL. Aborting.
[java] at org.voltdb.exceptions.SerializableException$SerializableExceptions$3.deserializeException(SerializableException.java:66)
[java] at org.voltdb.exceptions.SerializableException.deserializeFromBuffer(SerializableException.java:183)
[java] at org.voltdb.ClientResponseImpl.readExternal(ClientResponseImpl.java:114)
[java] at org.voltdb.messaging.FastDeserializer.readObject(FastDeserializer.java:100)
[java] at org.voltdb.client.Distributer$NodeConnection.handleMessage(Distributer.java:205)
[java] at org.voltdb.network.VoltPort.call(VoltPort.java:142)
[java] at org.voltdb.network.VoltNetwork$3.run(VoltNetwork.java:466)
[java] at org.voltdb.network.VoltNetwork.invokeCallbacks(VoltNetwork.java:499)
[java] at org.voltdb.network.VoltNetwork.run(VoltNetwork.java:351)
[java] at java.lang.Thread.run(Thread.java:619)
re: join issue
tcallaghan
May 7, 2010
Ritesh,

Can you please email your application in its current state and point out which stored procedure is failing? Send it to ersupport@voltdb.com

Thanks,
-Tim
re: join between 2 table failed (more than 100MB of temp table m
tcallaghan
May 10, 2010
Ritesh,

I have reviewed your code. You have a single-partition stored procedure that is joining two single-partition tables, but the tables do not have a common partition key.
Please see this post for more information.

-Tim