[
https://issues.apache.org/jira/browse/HAWQ-218?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ruilong Huo resolved HAWQ-218.
------------------------------
Resolution: Fixed
Fix Version/s: 2.0.0
The resolution is: 1) after using planner to generate query plan, calculate
datalocality accordingly, and allocate virtual segment and resource for query;
2) if the plan generated in 1) shows that the query need to be executed on
entry database, it fall back to planner to generate query plan for execution.
> Core dump while selecting data from partitioned table with where condition
> that belongs to no partition
> -------------------------------------------------------------------------------------------------------
>
> Key: HAWQ-218
> URL: https://issues.apache.org/jira/browse/HAWQ-218
> Project: Apache HAWQ
> Issue Type: Bug
> Components: Core
> Affects Versions: 2.0.0-beta-incubating
> Reporter: Ruilong Huo
> Assignee: Ruilong Huo
> Priority: Critical
> Fix For: 2.0.0
>
>
> HAWQ core dump while selecting data from partitioned table with where
> condition that belongs to no partition
> Reproduction steps:
> Step 1: prepare schema and data
> {noformat}
> create table foo(a int, b int, c int) partition by range (b) (start (1) end
> (101) every (10));
> insert into foo select generate_series(1,5), generate_series(1,100),
> generate_series(1,10);
> analyze foo;
> {noformat}
> Step 2: run query
> {noformat}
> gptest=# select * from foo where b = 150;
> FATAL: Unexpected internal error (dispatcher.c:456)
> DETAIL: FailedAssertion("!(resource)", File: "dispatcher.c", Line: 456)
> HINT: Process 29088 will wait for gp_debug_linger=120 seconds before
> termination.
> Note that its locks and other resources will not be released until then.
> 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: Succeeded.
> {noformat}
> Step 3: call stack in core dump
> {noformat}
> (gdb) bt
> #0 0x00000038cbe32625 in raise () from /lib64/libc.so.6
> #1 0x00000038cbe33e05 in abort () from /lib64/libc.so.6
> #2 0x00000000009dc10c in ExceptionalCondition (conditionName=0xe06c0e
> "!(resource)", errorType=0xe06be3 "FailedAssertion", fileName=0xe06bc0
> "dispatcher.c", lineNumber=456) at assert.c:60
> #3 0x0000000000b82260 in initialize_dispatch_data (resource=0x0,
> dispatch_to_all_cached_executors=0 '\000') at dispatcher.c:456
> #4 0x000000000071ac23 in ExecutorStart (queryDesc=0x28b5460, eflags=0) at
> execMain.c:908
> #5 0x00000000008ff7df in PortalStart (portal=0x28d3498, params=0x0,
> snapshot=0x0, seqServerHost=0x0, seqServerPort=-1) at pquery.c:1222
> #6 0x00000000008f5e76 in exec_simple_query (query_string=0x26b0198 "select *
> from foo where b = 150;", seqServerHost=0x0, seqServerPort=-1) at
> postgres.c:1680
> #7 0x00000000008fab80 in PostgresMain (argc=4, argv=0x25fac28,
> username=0x25faa80 "gpadmin") at postgres.c:4688
> #8 0x00000000008a0ec3 in BackendRun (port=0x25adc80) at postmaster.c:5834
> #9 0x00000000008a034d in BackendStartup (port=0x25adc80) at postmaster.c:5427
> #10 0x000000000089a9d9 in ServerLoop () at postmaster.c:2129
> #11 0x0000000000899a9c in PostmasterMain (argc=9, argv=0x25c4940) at
> postmaster.c:1421
> #12 0x00000000007b3472 in main (argc=9, argv=0x25c4940) at main.c:226
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
