[HAWQ-1077] Table insert hangs due to stack overwrite which is caused by a bug in ao snappy code

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.1.0.0-incubating
• Assignee: Paul Guo
• Reporter: Paul Guo
• Created: 26/Sep/16 08:41
• Updated: 18/Feb/17 05:26
• Resolved: 22/Dec/16 06:53

Description

It hang when try to insert large data into append-only table with compression. To be specific, the QE process spins at compression phase. Per RCA, there is stack overwritten in append-only table ith snappy compression.

The call stack is as following:

#0  0x00000000008607c4 in gp_trycompress_new (sourceData=0x2eec5b0 "\340\352\356\002", sourceLen=0,
    compressedBuffer=0xa2b3b4 "\311\303UH\211\345H\211}\370H\213E\370\307@<", compressedBufferWithOverrrunLen=38253,
    maxCompressedLen=32767, compressedLen=0xf8c800a29636, compressLevel=0, compressor=0x5d9cdf <snappy_compress_internal>,
    compressionState=0x2eee690) at gp_compress.c:56
#1  0x0000000000a2a1c6 in AppendOnlyStorageWrite_CompressAppend (storageWrite=0x2eec558,
    sourceData=0x33efa68 "ata value for text data typelarge data value for text data typelarge data value for text data typelarge data value for text data typelarge data value for text data typelarge data value for text data t"..., sourceLen=0,
    executorBlockKind=2, itemCount=0, compressedLen=0x7fffa7804f74, bufferLen=0x7fffa7804f70) at cdbappendonlystoragewrite.c:1255
#2  0x0000000000a2ae1b in AppendOnlyStorageWrite_Content (storageWrite=0x2eec558, content=0x33e7a70 "\242\241:\200\351\003",
    contentLen=3842464, executorBlockKind=2, rowCount=1) at cdbappendonlystoragewrite.c:1868
#3  0x000000000056b805 in appendonly_insert (aoInsertDesc=0x2eec460, instup=0x33e7a70, tupleOid=0x7fffa7805094,
    aoTupleId=0x7fffa7805080) at appendonlyam.c:2030

Issue Links

• links to: GitHub Pull Request #937