{"action":"created","issue":{"url":"https://api.github.com/repos/pg-strom/devel/issues/167","labels_url":"https://api.github.com/repos/pg-strom/devel/issues/167/labels{/name}","comments_url":"https://api.github.com/repos/pg-strom/devel/issues/167/comments","events_url":"https://api.github.com/repos/pg-strom/devel/issues/167/events","html_url":"https://github.com/pg-strom/devel/issues/167","id":97048668,"number":167,"title":"(JP) TPC-DSのNo.64のクエリーのEXPLAINでSEGV","user":{"login":"taiki-k","id":7201219,"avatar_url":"https://avatars.githubusercontent.com/u/7201219?v=3","gravatar_id":"","url":"https://api.github.com/users/taiki-k","html_url":"https://github.com/taiki-k","followers_url":"https://api.github.com/users/taiki-k/followers","following_url":"https://api.github.com/users/taiki-k/following{/other_user}","gists_url":"https://api.github.com/users/taiki-k/gists{/gist_id}","starred_url":"https://api.github.com/users/taiki-k/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/taiki-k/subscriptions","organizations_url":"https://api.github.com/users/taiki-k/orgs","repos_url":"https://api.github.com/users/taiki-k/repos","events_url":"https://api.github.com/users/taiki-k/events{/privacy}","received_events_url":"https://api.github.com/users/taiki-k/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2015-07-24T13:06:30Z","updated_at":"2015-08-04T02:14:35Z","closed_at":"2015-08-04T02:14:35Z","body":"TPC-DSのNo.64のクエリーをEXPLAINしたところ、SEGVでクラッシュしました。\r\nデバッグシンボルなしでコンパイルされているもので発生したため、詳しい情報は取得できませんでした。\r\n後日調査して、追記します。\r\n\r\n* (簡易)バックトレース\r\n```\r\n#0  0x000000000067d17d in cost_qual_eval ()\r\n#1  0x00007f2536da4f82 in create_gpujoin_path.isra.4 () from /usr/local/pgsql9.5a1/lib/pg_strom.so\r\n#2  0x00007f2536da87cc in try_gpujoin_path () from /usr/local/pgsql9.5a1/lib/pg_strom.so\r\n#3  0x00007f2536da8ac6 in gpujoin_add_join_path () from /usr/local/pgsql9.5a1/lib/pg_strom.so\r\n#4  0x0000000000688be8 in add_paths_to_joinrel ()\r\n#5  0x000000000068a528 in make_join_rel ()\r\n#6  0x000000000066c6e0 in gimme_tree ()\r\n#7  0x000000000066ca54 in geqo_eval ()\r\n#8  0x000000000066d098 in random_init_pool ()\r\n#9  0x000000000066ccbe in geqo ()\r\n#10 0x0000000000671764 in make_one_rel ()\r\n#11 0x0000000000698db6 in query_planner ()\r\n#12 0x000000000069aea3 in grouping_planner ()\r\n#13 0x000000000069e680 in subquery_planner ()\r\n#14 0x00000000006a61bb in SS_process_ctes ()\r\n#15 0x000000000069dc68 in subquery_planner ()\r\n#16 0x000000000069edab in standard_planner ()\r\n#17 0x00007f2536d8beb5 in pgstrom_planner_entrypoint () from /usr/local/pgsql9.5a1/lib/pg_strom.so\r\n#18 0x0000000000753b08 in pg_plan_query ()\r\n#19 0x00000000005a00d9 in ExplainQuery ()\r\n#20 0x000000000075abf1 in standard_ProcessUtility ()\r\n#21 0x0000000000757475 in PortalRunUtility ()\r\n#22 0x0000000000757efd in FillPortalStore ()\r\n#23 0x00000000007596d7 in PortalRun ()\r\n#24 0x0000000000756697 in PostgresMain ()\r\n#25 0x0000000000467e49 in ServerLoop ()\r\n#26 0x00000000006dca89 in PostmasterMain ()\r\n#27 0x000000000046a1cd in main ()\r\n```\r\n"},"comment":{"url":"https://api.github.com/repos/pg-strom/devel/issues/comments/127456582","html_url":"https://github.com/pg-strom/devel/issues/167#issuecomment-127456582","issue_url":"https://api.github.com/repos/pg-strom/devel/issues/167","id":127456582,"user":{"login":"kaigai","id":216210,"avatar_url":"https://avatars.githubusercontent.com/u/216210?v=3","gravatar_id":"","url":"https://api.github.com/users/kaigai","html_url":"https://github.com/kaigai","followers_url":"https://api.github.com/users/kaigai/followers","following_url":"https://api.github.com/users/kaigai/following{/other_user}","gists_url":"https://api.github.com/users/kaigai/gists{/gist_id}","starred_url":"https://api.github.com/users/kaigai/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kaigai/subscriptions","organizations_url":"https://api.github.com/users/kaigai/orgs","repos_url":"https://api.github.com/users/kaigai/repos","events_url":"https://api.github.com/users/kaigai/events{/privacy}","received_events_url":"https://api.github.com/users/kaigai/received_events","type":"User","site_admin":false},"created_at":"2015-08-04T02:14:35Z","updated_at":"2015-08-04T02:14:35Z","body":"一旦こちらはクローズ。"}}