Forum: Building VoltDB Clients

Post: More than 75 MB of temp table memory used while executing SQL

More than 75 MB of temp table memory used while executing SQL
dl_zhenglp
May 16, 2012
Can you help me?

I found this error:
2012-05-16 09:29:47,440 INFO [ExecutionSite:0001] SQL: More than 75 MB of temp table memory used while executing SQL. This may indicate an operation that should be broken into smaller chunks.
2012-05-16 09:29:48,203 INFO [ExecutionSite:0002] SQL: More than 75 MB of temp table memory used while executing SQL. This may indicate an operation that should be broken into smaller chunks.
2012-05-16 09:30:17,114 FATAL [Volt Network] HOST: Fatal error from id,hostname(1,voltdbserver2): Mismatched results received for partition: 0
from execution site: 1
Original results: header size: 305
status code: -128 column count: 31
cols (KHBS:INTEGER), (KHBH:STRING), (KHMC:STRING), (YDBZ:STRING), (KHLXDM:STRING), (JJLXDM:STRING), (XYDJDM:STRING), (XYFZ:INTEGER), (JZDJDM:STRING), (FXDJDM:STRING), (VIPBZ:STRING), (VIPDJDM:STRING), (QYWZ:STRING), (QYGM:STRING), (QYJJ:STRING), (ZCZBJ:INTEGER), (ZCZJ:INTEGER), (FRDB:STRING), (JYFW:STRING), (ZYCP:STRING), (SCGY:STRING), (CN:STRING), (ZYYL:STRING), (GYLY:STRING), (XSE:INTEGER), (XSQY:STRING), (ZYBDXM:STRING), (DFZQYCBBL:FLOAT), (CYFLDM:STRING), (DQBM:STRING), (GDDWBS:INTEGER),
rows -
16912,盘锦供电公司,1695833479.83256936024603896427985148359,是,02, 8E7EFD, 13096A,10730, 15C26B, 8B1B2C, 947116, 6CC412,3744874338,2256214896,6879659524,123,123,7069364778,1145455438,7022532873,4496104228,2065287330,4722652412,3938078651,0,1706640210,4162950904,1.1,8999643, 838A7E,0
16914,盘锦供电公司,2173597476.21909651807152668797157511305,是,02, 2FCF31, 713FB6,6955, 7972FC, 5DBF00, 85E511, 929549,7952333331,2927305902,9296374204,123,123,79439879,8953106518,6618778374,7783551015,4323581234,8592008778,1581458526,0,8977968231,8342544397,1.1,1335064, 448F9C,0
16916,盘锦供电公司,1096375520.61418272429596884902229184413,是,02, 6AF94D, 564D0D,35086, 745ECD, 4FD6E5, 32F7CB, 84BA02,9707988375,9548267433,9960518821,123,123,2160143309,60770091,9954367191,2054150390,9694270496,9626726197,1425043156,0,8084660520,6700231451,1.1,2186390, 8EE91C,0
Need more information
nshi
May 16, 2012
Hi,

The first two warning messages were printed because some of the SQL queries were doing large reads from the partition. There is a limit of 100MB temp table in a single read. If you are not sure whether you will hit this limit or not, you can try to break down the read into smaller read operations by getting a range at a time.

Regarding the result mismatch, can you send me the DDL and client code so that I can try to reproduce it here? You can send them to my email if you want, nshi at voltdb.com. It would also help if you can send me the full log of the database and let me know the order of operations you did to reproduce this, like if there were any rejoins prior to the failure, etc.

Thanks.

Ning