[ https://issues.apache.org/jira/browse/HAWQ-418?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ruilong Huo resolved HAWQ-418. ------------------------------ Resolution: Fixed This issue has been fixed. > Core dump when COPY data into table without any column > ------------------------------------------------------ > > Key: HAWQ-418 > URL: https://issues.apache.org/jira/browse/HAWQ-418 > Project: Apache HAWQ > Issue Type: Bug > Components: External Tables > Affects Versions: 2.0.0-beta-incubating > Reporter: Ruilong Huo > Assignee: Ruilong Huo > Fix For: 2.0.0 > > > It core dump when COPY data into table without any column. > 1. Reproduction steps > {noformat} > gptest=# CREATE TABLE t(); > CREATE TABLE > gptest=# > gptest=# COPY t FROM STDIN CSV DELIMITER ',' HEADER; > Enter data to be copied followed by a newline. > End with a backslash and a period on a line by itself. > >> aaa,bbb > >> ccc,ddd > >> \. > server closed the connection unexpectedly > This probably means the server terminated abnormally > before or while processing the request. > The connection to the server was lost. Attempting reset: Failed. > !> > {noformat} > 2. Call stack > {noformat} > [gpadmin@localhost apache-hawq]$ sudo gdb > /data/workspace/hawq-2.0/hawq-db-devel/bin/postgres -c > /var/crash/user/core.postgres.118117.1455687934.11.501.501 > (gdb) bt > #0 0x00000038cc20f5db in raise () from /lib64/libpthread.so.0 > #1 0x00000000009dce9f in SafeHandlerForSegvBusIll (processName=0xd4ad53 > "Master process", postgres_signal_arg=11) at elog.c:4515 > #2 0x00000000009dd0cc in StandardHandlerForSigillSigsegvSigbus_OnMainThread > (processName=0xd4ad53 "Master process", postgres_signal_arg=11) at elog.c:4593 > #3 0x00000000008f084a in CdbProgramErrorHandler (postgres_signal_arg=11) at > postgres.c:3423 > #4 <signal handler called> > #5 0x000000000068ec36 in CopyReadAttributesCSV (cstate=0x2657458, > nulls=0x26ba8f0 "~", attr_offsets=0x26ba930, num_phys_attrs=0, attr=0x0) at > copy.c:5612 > #6 0x00000000006875c4 in CopyFromDispatch (cstate=0x2657458, err_segnos=0x0) > at copy.c:3300 > #7 0x0000000000682502 in DoCopy (stmt=0x2569758, queryString=0x2568978 "COPY > t FROM STDIN CSV DELIMITER ',' HEADER;") at copy.c:1639 > #8 0x00000000008fb2f5 in ProcessUtility (parsetree=0x2569758, > queryString=0x25ef618 "COPY t FROM STDIN CSV DELIMITER ',' HEADER;", > params=0x0, isTopLevel=1 '\001', dest=0x2569d00, completionTag=0x7fffd5a17f20 > "") > at utility.c:1076 > #9 0x00000000008f8586 in PortalRunUtility (portal=0x25aac58, > utilityStmt=0x2569758, isTopLevel=1 '\001', dest=0x2569d00, > completionTag=0x7fffd5a17f20 "") at pquery.c:1887 > #10 0x00000000008f8848 in PortalRunMulti (portal=0x25aac58, isTopLevel=1 > '\001', dest=0x2569d00, altdest=0x2569d00, completionTag=0x7fffd5a17f20 "") > at pquery.c:1997 > #11 0x00000000008f7c61 in PortalRun (portal=0x25aac58, > count=9223372036854775807, isTopLevel=1 '\001', dest=0x2569d00, > altdest=0x2569d00, completionTag=0x7fffd5a17f20 "") at pquery.c:1514 > #12 0x00000000008edb6b in exec_simple_query (query_string=0x2568978 "COPY t > FROM STDIN CSV DELIMITER ',' HEADER;", seqServerHost=0x0, seqServerPort=-1) > at postgres.c:1741 > #13 0x00000000008f2831 in PostgresMain (argc=4, argv=0x249ae30, > username=0x249ac30 "gpadmin") at postgres.c:4724 > #14 0x0000000000898b38 in BackendRun (port=0x247e700) at postmaster.c:5890 > #15 0x0000000000897fc2 in BackendStartup (port=0x247e700) at postmaster.c:5483 > #16 0x0000000000891fef in ServerLoop () at postmaster.c:2162 > #17 0x00000000008910b2 in PostmasterMain (argc=9, argv=0x2485940) at > postmaster.c:1454 > #18 0x00000000007aafb6 in main (argc=9, argv=0x2485940) at main.c:226 > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)