You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@nifi.apache.org by David Dumas <da...@effilab.com> on 2018/07/23 08:53:21 UTC
NiFi <-> PrestoDB - Header is too large
Hello everyone,
We're having an issue with NiFi 1.7.1 and PrestoDB using JDBC 0.206, we are
performing an SQL statement multiple times, after multiple tries we have
the folowing error:
*NiFi logs*
Caused by: java.lang.RuntimeException: Error starting query at
http://192.168.1.18:8080/v1/statement returned an invalid response:
JsonResponse{statusCode=431, statusMessage=Request Header Fields Too Large,
headers={connection=[close], content-length=[74],
content-type=[text/html;charset=iso-8859-1]},
hasValue=false} [Error: <h1>Bad Message 431</h1><pre>reason: Request Header
Fields Too Large</pre>]
at com.facebook.presto.jdbc.internal.client.StatementClientV1.
requestFailedException(StatementClientV1.java:436)
at com.facebook.presto.jdbc.internal.client.StatementClientV1.<init>(
StatementClientV1.java:132)
at com.facebook.presto.jdbc.internal.client.StatementClientFactory.
newStatementClient(StatementClientFactory.java:24)
at com.facebook.presto.jdbc.QueryExecutor.startQuery(
QueryExecutor.java:46)
at com.facebook.presto.jdbc.PrestoConnection.startQuery(
PrestoConnection.java:682)
at com.facebook.presto.jdbc.PrestoStatement.internalExecute(
PrestoStatement.java:237)
... 17 common frames omitted
*PrestoDB coordinator logs*
WARN http-worker-485915 org.eclipse.jetty.http.HttpParser Header
is too large 8193>8192
[image: logo]
*David Dumas* | DevOps engineer
david@effilab.com
01 46 09 31 90
204 Rond Point du Pont-de-Sèvres,
92100 Boulogne-Billancourt
[image: website] <http://www.effilab.com/> [image: Facebook]
<https://facebook.com/Effilab> [image: Twitter]
<https://twitter.com/Effilab> [image: LinkedIn]
<https://www.linkedin.com/company/effilab-agency>
Re: NiFi <-> PrestoDB - Header is too large
Posted by da...@effilab.com,
da...@effilab.com.
PrestoDB issue opened by my colleague:
https://github.com/prestodb/presto/issues/11110
Fix will be pushed in PrestoDB JDBC driver.
On 2018/07/23 08:53:21, David Dumas <da...@effilab.com> wrote:
> Hello everyone,
>
>
> We're having an issue with NiFi 1.7.1 and PrestoDB using JDBC 0.206, we are
> performing an SQL statement multiple times, after multiple tries we have
> the folowing error:
>
> *NiFi logs*
>
> Caused by: java.lang.RuntimeException: Error starting query at
> http://192.168.1.18:8080/v1/statement returned an invalid response:
> JsonResponse{statusCode=431, statusMessage=Request Header Fields Too Large,
> headers={connection=[close], content-length=[74],
> content-type=[text/html;charset=iso-8859-1]},
> hasValue=false} [Error: <h1>Bad Message 431</h1><pre>reason: Request Header
> Fields Too Large</pre>]
> at com.facebook.presto.jdbc.internal.client.StatementClientV1.
> requestFailedException(StatementClientV1.java:436)
> at com.facebook.presto.jdbc.internal.client.StatementClientV1.<init>(
> StatementClientV1.java:132)
> at com.facebook.presto.jdbc.internal.client.StatementClientFactory.
> newStatementClient(StatementClientFactory.java:24)
> at com.facebook.presto.jdbc.QueryExecutor.startQuery(
> QueryExecutor.java:46)
> at com.facebook.presto.jdbc.PrestoConnection.startQuery(
> PrestoConnection.java:682)
> at com.facebook.presto.jdbc.PrestoStatement.internalExecute(
> PrestoStatement.java:237)
> ... 17 common frames omitted
>
> *PrestoDB coordinator logs*
>
> WARN http-worker-485915 org.eclipse.jetty.http.HttpParser Header
> is too large 8193>8192
>
> [image: logo]
> *David Dumas* | DevOps engineer
> david@effilab.com
> 01 46 09 31 90
> 204 Rond Point du Pont-de-Sèvres,
> 92100 Boulogne-Billancourt
> [image: website] <http://www.effilab.com/> [image: Facebook]
> <https://facebook.com/Effilab> [image: Twitter]
> <https://twitter.com/Effilab> [image: LinkedIn]
> <https://www.linkedin.com/company/effilab-agency>
>