1. Request Header Fields Too Large
; uncategorized SQLException; SQL state [null]; error code [0]; Error executing query; nested exception is java.sql.SQLException: Error executing query
...
reason: Request Header Fields Too Large
...
解决办法:修改preoto的config.properties,增加参数:http-server.max-request-header-size=5MB,修改完成后重启presto(最好连应用一起重启)
2.Error fetching next at xxx returned an invalid response: JsonResponse{statusCode=500, statusMessage=Server Error, headers={connection=[close]}, hasValue=false} [Error: ]
### Cause: java.sql.SQLException: Error executing query
; uncategorized SQLException; SQL state [null]; error code [0]; Error executing query; nested exception is java.sql.SQLException: Error executing query
...
Caused by: java.lang.RuntimeException: Error fetching next at http://123.123.123.123:9080/v1/statement/queued/20201116_122530_00085_jybpp/2?slug=xa38a60b1053e4d6093e7c1d56550091b returned an invalid response: JsonResponse{statu
sCode=500, statusMessage=Server Error, headers={connection=[close]}, hasValue=false} [Error: ]
at com.facebook.presto.jdbc.internal.client.StatementClientV1.requestFailedException(StatementClientV1.java:446) ~[presto-jdbc-0.243.2.jar!/:0.243.2-128118e]
at com.facebook.presto.jdbc.internal.client.StatementClientV1.advance(StatementClientV1.java:386) ~[presto-jdbc-0.243.2.jar!/:0.243.2-128118e]
at com.facebook.presto.jdbc.PrestoResultSet.getColumns(PrestoResultSet.java:1743) ~[presto-jdbc-0.243.2.jar!/:0.243.2-128118e]
at com.facebook.presto.jdbc.PrestoResultSet.<init>(PrestoResultSet.java:121) ~[presto-jdbc-0.243.2.jar!/:0.243.2-128118e]
at com.facebook.presto.jdbc.PrestoStatement.internalExecute(PrestoStatement.java:250) ~[presto-jdbc-0.243.2.jar!/:0.243.2-128118e]
... 137 common frames omitted
异常信息与第一个错误基本一样,区别是没有request header部分信息
解决办法:修改preoto的config.properties,增加参数:http-server.max-response-header-size=5MB,修改完成后重启presto(最好连应用一起重启)