You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hawq.apache.org by "Ruilong Huo (JIRA)" <ji...@apache.org> on 2016/02/19 05:32:18 UTC
[jira] [Closed] (HAWQ-418) Core dump when COPY data into table
without any column
[ https://issues.apache.org/jira/browse/HAWQ-418?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ruilong Huo closed HAWQ-418.
----------------------------
> 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)