[IMPALA-5396] When query is loading metadata it can't be cancelled

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Duplicate
• Affects Version/s: Impala 2.9.0
• Fix Version/s: Product Backlog
• Component/s: Distributed Exec
• Labels: bugbash-2017-05-31
• Epic Color: ghx-label-3
• Assignee: Unassigned
• Reporter: Mostafa Mokhtar
• Created: 31/May/17 16:06
• Updated: 31/May/17 19:13
• Resolved: 31/May/17 19:13

Description

Repro
1) invalidate metadata [TABLE_WITH_LOTS_OF_PARTITIONS]
2) explain select count from [TABLE_WITH_LOTS_OF_PARTITIONS]
3) Try to cancel query from WebUI or by hitting Cntrl+C from impala-shell
4) Query continues to run

From the impalad log

I0531 09:01:05.915901 87243 status.cc:122] Cancelled from Impala's debug web interface
    @           0x83c119  impala::Status::Status()
    @           0xae52b1  impala::ImpalaHttpHandler::CancelQueryHandler()
    @           0xbf445a  impala::Webserver::RenderUrlWithTemplate()
    @           0xbf59a7  impala::Webserver::BeginRequestCallback()
    @           0xc08bb0  (unknown)
    @           0xc0b32d  (unknown)
    @           0xc0b9bd  (unknown)
    @       0x3797407aa1  (unknown)
    @       0x37970e893d  (unknown)
I0531 09:01:05.916215 87243 impala-server.cc:937] UnregisterQuery(): query_id=1e4c74789ce48762:ff89116000000000
I0531 09:01:05.916532 87243 impala-server.cc:1022] Cancel(): query_id=1e4c74789ce48762:ff89116000000000
I0531 09:01:05.922346 87243 status.cc:122] Query not yet running
    @           0x83c119  impala::Status::Status()
    @           0xb0a3e0  impala::ClientRequestState::Cancel()
    @           0xab8098  impala::ImpalaServer::CancelInternal()
    @           0xac60f9  impala::ImpalaServer::UnregisterQuery()
    @           0xae52e0  impala::ImpalaHttpHandler::CancelQueryHandler()
    @           0xbf445a  impala::Webserver::RenderUrlWithTemplate()
    @           0xbf59a7  impala::Webserver::BeginRequestCallback()
    @           0xc08bb0  (unknown)
    @           0xc0b32d  (unknown)
    @           0xc0b9bd  (unknown)
    @       0x3797407aa1  (unknown)
    @       0x37970e893d  (unknown)

I also noted a of messages like this printed to the log,

I0531 09:03:57.527807 88936 status.cc:122] Query plan is not ready.
    @           0x83c119  impala::Status::Status()
    @           0xab871c  impala::ImpalaServer::GetRuntimeProfileStr()
    @           0xae781c  impala::ImpalaHttpHandler::QueryProfileEncodedHandler()
    @           0xbf445a  impala::Webserver::RenderUrlWithTemplate()
    @           0xbf59a7  impala::Webserver::BeginRequestCallback()
    @           0xc08bb0  (unknown)
    @           0xc0b32d  (unknown)
    @           0xc0b9bd  (unknown)
    @       0x3797407aa1  (unknown)
    @       0x37970e893d  (unknown)

Issue Links

• duplicates: IMPALA-915 Ability to cancel queries while in the FE.