{"action":"created","issue":{"url":"https://api.github.com/repos/greenplum-db/gpdb/issues/5161","repository_url":"https://api.github.com/repos/greenplum-db/gpdb","labels_url":"https://api.github.com/repos/greenplum-db/gpdb/issues/5161/labels{/name}","comments_url":"https://api.github.com/repos/greenplum-db/gpdb/issues/5161/comments","events_url":"https://api.github.com/repos/greenplum-db/gpdb/issues/5161/events","html_url":"https://github.com/greenplum-db/gpdb/issues/5161","id":332655749,"node_id":"MDU6SXNzdWUzMzI2NTU3NDk=","number":5161,"title":"hang for select from heap table","user":{"login":"zwj19991999","id":16750841,"node_id":"MDQ6VXNlcjE2NzUwODQx","avatar_url":"https://avatars3.githubusercontent.com/u/16750841?v=4","gravatar_id":"","url":"https://api.github.com/users/zwj19991999","html_url":"https://github.com/zwj19991999","followers_url":"https://api.github.com/users/zwj19991999/followers","following_url":"https://api.github.com/users/zwj19991999/following{/other_user}","gists_url":"https://api.github.com/users/zwj19991999/gists{/gist_id}","starred_url":"https://api.github.com/users/zwj19991999/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zwj19991999/subscriptions","organizations_url":"https://api.github.com/users/zwj19991999/orgs","repos_url":"https://api.github.com/users/zwj19991999/repos","events_url":"https://api.github.com/users/zwj19991999/events{/privacy}","received_events_url":"https://api.github.com/users/zwj19991999/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":10,"created_at":"2018-06-15T06:04:14Z","updated_at":"2018-06-20T08:19:50Z","closed_at":null,"author_association":"NONE","body":"### Greenplum version or build\r\n5.7.0 and 5.8.1\r\n### OS version and uname -a\r\n3.10.0-514.26.2.el7.x86_64 #1\r\n### autoconf options used ( config.status --config )\r\n\r\n### Installation information ( pg_config )\r\n\r\nBINDIR = /data/welab/gpadmin-app/greenplum-db/bin\r\nDOCDIR = /data/welab/gpadmin-app/greenplum-db/doc/postgresql\r\nHTMLDIR = /data/welab/gpadmin-app/greenplum-db/doc/postgresql\r\nINCLUDEDIR = /data/welab/gpadmin-app/greenplum-db/include\r\nPKGINCLUDEDIR = /data/welab/gpadmin-app/greenplum-db/include/postgresql\r\nINCLUDEDIR-SERVER = /data/welab/gpadmin-app/greenplum-db/include/postgresql/server\r\nLIBDIR = /data/welab/gpadmin-app/greenplum-db/lib\r\nPKGLIBDIR = /data/welab/gpadmin-app/greenplum-db/lib/postgresql\r\nLOCALEDIR = /data/welab/gpadmin-app/greenplum-db/share/locale\r\nMANDIR = /data/welab/gpadmin-app/greenplum-db/share/man\r\nSHAREDIR = /data/welab/gpadmin-app/greenplum-db/share/postgresql\r\nSYSCONFDIR = /data/welab/gpadmin-app/greenplum-db/etc/postgresql\r\nPGXS = /data/welab/gpadmin-app/greenplum-db/lib/postgresql/pgxs/src/makefiles/pgxs.mk\r\nCC = gcc\r\nCPPFLAGS = -D_GNU_SOURCE -I/data/welab/gpadmin-app/greenplum-db/include\r\nCFLAGS = -O3 -std=gnu99 -Wall -Wmissing-prototypes -Wpointer-arith -Wendif-labels -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -fno-aggressive-loop-optimizations -Wno-unused-but-set-variable -Wno-address -g -ggdb -pg -DLINUX_PROFILE -I/data/welab/gpadmin-app/greenplum-db/include\r\nCFLAGS_SL = -fpic\r\nLDFLAGS = -Wl,--as-needed -Wl,-rpath,'/home/gpadmin/app/greenplum-db/lib',--enable-new-dtags -L/data/welab/gpadmin-app/greenplum-db/lib\r\nLDFLAGS_SL =\r\nLIBS = -lpgport -lgpopt -lnaucrates -lgpdbcost -lgpos -lxerces-c -lxml2 -lpam -lrt -lkrb5 -lcom_err -lgssapi_krb5 -lcrypt -ldl -lm -L/data/welab/gpadmin-app/greenplum-db/lib\r\nVERSION = PostgreSQL 8.3.23\r\n\r\n### Expected behavior\r\n\r\nselect heap table should get back all data\r\n\r\n### Actual behavior\r\n\r\nselect heap table can`t get data, it hang.\r\n\r\n### Step to reproduce the behavior\r\n\r\n2018-06-15 13:49:54.971298 CST,\"gpadmin\",\"bdldb\",p31052,th1388382336,\"[local]\",,2018-06-15 13:49:50 CST,0,con35,cmd1,seg-1,,dx7,,sx1,\"LOG\",\"00000\",\"statement: select * from test;\",,,,,,\"select * from test;\",0,,\"postgres.c\",1577,\r\n2018-06-15 13:49:55.127673 CST,\"gpadmin\",\"bdldb\",p31052,th1388382336,\"[local]\",,2018-06-15 13:49:50 CST,0,con35,cmd2,seg-1,,dx7,,sx1,\"FATAL\",\"XX000\",\"Unexpected internal error (elog.c:4482)\",\"FailedAssertion(\"\"!(depth > 0)\"\", File: \"\"elog.c\"\", Line: 4482)\",\"Process 31052 will wait for gp_debug_linger=120 seconds before termination.\r\nNote that its locks and other resources will not be released until then.\",,,,\"select * from test;\",0,,\"elog.c\",4482,\"Stack trace:\r\n1    0x9c6000 postgres errstart (elog.c:521)\r\n2    0x9bb0d9 postgres ExceptionalCondition (assert.c:40)\r\n3    0x9c98f4 postgres gp_backtrace (discriminator 2)\r\n4    0x9c9b1f postgres StandardHandlerForSigillSigsegvSigbus_OnMainThread (elog.c:4618)\r\n5    0x7f154ef3d6d0 libpthread.so.0 <symbol not found> + 0x4ef3d6d0\r\n6    0x7f154e497dd6 libc.so.6 <symbol not found> + 0x4e497dd6\r\n7    0xa5606e postgres CvtChunksToTup (tupser.c:1010)\r\n8    0xa5352a postgres RecvTupleFrom (cdbmotion.c:99)\r\n9    0x70a1a3 postgres ExecMotion (nodeMotion.c:405)\r\n10   0x6d12e9 postgres ExecProcNode (execProcnode.c:1012)\r\n11   0x6cde03 postgres <symbol not found> (tuptable.h:156)\r\n12   0x6ce66e postgres ExecutorRun (execMain.c:914)\r\n13   0x89e39a postgres <symbol not found> (pquery.c:1163)\r\n14   0x8a039b postgres PortalRun (pquery.c:986)\r\n15   0x89a8ab postgres <symbol not found> (postgres.c:1770)\r\n16   0x89cf0b postgres PostgresMain (postgres.c:4943)\r\n17   0x82ed8f postgres <symbol not found> (postmaster.c:6375)\r\n18   0x83157a postgres PostmasterMain (postmaster.c:1533)\r\n19   0x4ca56d postgres main (main.c:206)\r\n20   0x7f154e364445 libc.so.6 __libc_start_main + 0xf5\r\n21   0x4caad1 postgres <symbol not found> + 0x4caad1\r\n"},"comment":{"url":"https://api.github.com/repos/greenplum-db/gpdb/issues/comments/398665394","html_url":"https://github.com/greenplum-db/gpdb/issues/5161#issuecomment-398665394","issue_url":"https://api.github.com/repos/greenplum-db/gpdb/issues/5161","id":398665394,"node_id":"MDEyOklzc3VlQ29tbWVudDM5ODY2NTM5NA==","user":{"login":"zwj19991999","id":16750841,"node_id":"MDQ6VXNlcjE2NzUwODQx","avatar_url":"https://avatars3.githubusercontent.com/u/16750841?v=4","gravatar_id":"","url":"https://api.github.com/users/zwj19991999","html_url":"https://github.com/zwj19991999","followers_url":"https://api.github.com/users/zwj19991999/followers","following_url":"https://api.github.com/users/zwj19991999/following{/other_user}","gists_url":"https://api.github.com/users/zwj19991999/gists{/gist_id}","starred_url":"https://api.github.com/users/zwj19991999/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zwj19991999/subscriptions","organizations_url":"https://api.github.com/users/zwj19991999/orgs","repos_url":"https://api.github.com/users/zwj19991999/repos","events_url":"https://api.github.com/users/zwj19991999/events{/privacy}","received_events_url":"https://api.github.com/users/zwj19991999/received_events","type":"User","site_admin":false},"created_at":"2018-06-20T08:19:49Z","updated_at":"2018-06-20T08:19:49Z","author_association":"NONE","body":"two of these machines is ok, the other machines will hang.\r\nwe are reinitialize on these had changed machine.\r\n\r\nall is fine when use 'select * from gp_segment_configuration'\r\nit show the segment status is 'u',no problem.\r\n________________________________\r\n发件人: Tang Pengzhou <notifications@github.com>\r\n发送时间: 2018年6月20日 15:36\r\n收件人: greenplum-db/gpdb\r\n抄送: zhang; Mention\r\n主题: Re: [greenplum-db/gpdb] hang for select from heap table (#5161)\r\n\r\n\r\nwhat's the output of \"select * from gp_segment_configuration\"?\r\n\r\n―\r\nYou are receiving this because you were mentioned.\r\nReply to this email directly, view it on GitHub<https://github.com/greenplum-db/gpdb/issues/5161#issuecomment-398653800>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AP-Y-dDtiggOT4pleigfffRa-Pk4djrZks5t-fuEgaJpZM4UpDid>.\r\n"}}
{"actor":{"display_login":"zwj19991999"}}