,
Muhluri
-Original Message-
From: James Turton
Sent: Thursday, 12 October 2023 13:43
To: muhl...@ntokoto.co.za
Subject: Re: ChannelClosedException
Also, please look in the Drillbit logs. The query may be encountering invalid
data and failing when you remove your LIMIT clause. Are you
to share the bigger files?
Regards,
Muhluri
-Original Message-
From: James Turton
Sent: Friday, 13 October 2023 10:16
To: user@drill.apache.org; muhl...@ntokoto.co.za
Subject: Re: ChannelClosedException
Going further, it looks like your entire Drillbit is crashing so this is
something
-
From: James Turton
Sent: Friday, 13 October 2023 10:16
To: user@drill.apache.org; muhl...@ntokoto.co.za
Subject: Re: ChannelClosedException
Going further, it looks like your entire Drillbit is crashing so this is
something severe, perhaps an out-of-memory situation. The sqlline.log file
should
: James Turton
Sent: Friday, 13 October 2023 10:16
To: user@drill.apache.org; muhl...@ntokoto.co.za
Subject: Re: ChannelClosedException
Going further, it looks like your entire Drillbit is crashing so this is
something severe, perhaps an out-of-memory situation. The sqlline.log file
should provide
is QuerySurge. I am getting the same error message in both platforms.
Regards,
Muhluri
-Original Message-
From: James Turton
Sent: Thursday, 12 October 2023 13:43
To: muhl...@ntokoto.co.za
Subject: Re: ChannelClosedException
Also, please look in the Drillbit logs. The query may be
: ChannelClosedException
Also, please look in the Drillbit logs. The query may be encountering invalid
data and failing when you remove your LIMIT clause. Are you using DBeaver to
submit your queries btw? That error looks familiar...
On 2023/10/10 15:58, Charles Givre wrote:
Hi Desmond,
Can you share a
; Sent: Thursday, 12 October 2023 13:43
> To: muhl...@ntokoto.co.za
> Subject: Re: ChannelClosedException
>
> Also, please look in the Drillbit logs. The query may be encountering invalid
> data and failing when you remove your LIMIT clause. Are you using DBeaver to
> submit you
: ChannelClosedException
Also, please look in the Drillbit logs. The query may be encountering invalid
data and failing when you remove your LIMIT clause. Are you using DBeaver to
submit your queries btw? That error looks familiar...
On 2023/10/10 15:58, Charles Givre wrote:
> Hi Desmond,
> C
: ChannelClosedException
Also, please look in the Drillbit logs. The query may be encountering invalid
data and failing when you remove your LIMIT clause. Are you using DBeaver to
submit your queries btw? That error looks familiar...
On 2023/10/10 15:58, Charles Givre wrote:
> Hi Desmond,
> Can you share
i...@gmail.com> >
Date: Tue, 10 Oct 2023, 3:59 pm
To: user@drill.apache.org <mailto:user@drill.apache.org>
Cc: Desmond Mathebula mailto:desm...@ntokoto.co.za> >
Subject: Re: ChannelClosedException
Hi Desmond,
Can you share a bit more? What version of Drill are you running? Ja
Also, please look in the Drillbit logs. The query may be encountering
invalid data and failing when you remove your LIMIT clause. Are you
using DBeaver to submit your queries btw? That error looks familiar...
On 2023/10/10 15:58, Charles Givre wrote:
Hi Desmond,
Can you share a bit more? What
Hi Desmond,
Can you share a bit more? What version of Drill are you running? Java? etc.
What data are you trying to query?
Best,
-- C
> On Oct 10, 2023, at 2:02 AM,
> wrote:
>
> Hi Team,
>
>
>
> When I run a Query for a limited number of records it returns the results.
> When I rem
Hi Team,
When I run a Query for a limited number of records it returns the results.
When I remove the limit on the Query it fails with below error. May you
please assist.
Exception: SQL_EXCEPTION java.sql.SQLException: CONNECTION ERROR: Connection
<--> (user client) closed unexpectedly.
Hi everyone,
I have seen the same exception.
It happens when running concurrent queries on the same table with a relatively
large LIMIT size (5,000,000 ~ 10,000,000), using JDBC.
The exception was found in both sqline session and jdbc, and on different
storage plugins (local filesystem/hdfs/h
For the said error ID, are there more messages in the log, which could give
out more information?
Could you also share the query & profile (full JSON) for the query? May be
you put it up on gist and share a link. Someone here could take a look.
Try and increase the value for DRILL_MAX_DIRECT_MEMO
Hi Abhishek,
It is probably due to OOM. Here is the log :
[Error Id: b58b4918-3ed7-465b-8a16-1bdff8e0fc7f ]
org.apache.drill.common.exceptions.UserException: SYSTEM
ERROR:ChannelClosedException
[Error Id: b58b4918-3ed7-465b-8a16-1bdff8e0fc7f ]
atorg.apache.drill.common.exceptions.UserExcep
Hi Boris,
Can you share relevant logs? The exception you shared is not the actual
cause of failure - rather an after effect. You can ignore those.
If I could suspect, I'd say it could be due to OOM (given it being a
complex query).
Regards,
Abhishek
On Wed, Sep 16, 2015 at 9:59 AM, Boris Chmiel
Hi everyone,While running a huge query with many joins, Drill reach SYSTEM
ERROR : ChannelclosedExceptionDoes anyone experience the same error and have a
clue about how to solve it? Thanks
18 matches
Mail list logo