You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@kyuubi.apache.org by "A-little-bit-of-data (via GitHub)" <gi...@apache.org> on 2023/06/07 06:08:07 UTC
[GitHub] [kyuubi] A-little-bit-of-data commented on issue #4930: [Bug] TRINO Error operating EXECUTE_STATEMENT, broken pipe(Write failed)
A-little-bit-of-data commented on issue #4930:
URL: https://github.com/apache/kyuubi/issues/4930#issuecomment-1579960622
> /opt/kyuubi/work/admin
the log :
2023-06-07 13:47:28.314 INFO org.apache.kyuubi.util.SignalRegister: Registering signal handler for TERM
2023-06-07 13:47:28.317 INFO org.apache.kyuubi.util.SignalRegister: Registering signal handler for HUP
2023-06-07 13:47:28.317 INFO org.apache.kyuubi.util.SignalRegister: Registering signal handler for INT
2023-06-07 13:47:28.455 WARN org.apache.hadoop.util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable
2023-06-07 13:47:28.678 INFO org.apache.kyuubi.Utils: Loading Kyuubi properties from /opt/kyuubi/conf/kyuubi-defaults.conf
2023-06-07 13:47:28.706 INFO org.apache.kyuubi.util.ThreadUtils: TrinoSessionManager-exec-pool: pool size: 100, wait queue size: 100, thread keepalive time: 60000 ms
2023-06-07 13:47:28.713 INFO org.apache.kyuubi.engine.trino.operation.TrinoOperationManager: Service[TrinoOperationManager] is initialized.
2023-06-07 13:47:28.714 INFO org.apache.kyuubi.engine.trino.session.TrinoSessionManager: Service[TrinoSessionManager] is initialized.
2023-06-07 13:47:28.714 INFO org.apache.kyuubi.engine.trino.TrinoBackendService: Service[TrinoBackendService] is initialized.
2023-06-07 13:47:28.750 INFO org.apache.kyuubi.engine.trino.TrinoTBinaryFrontendService: Initializing TrinoTBinaryFrontend on kyuubi-86c95975c7-nx59s:46789 with [500, 999] worker threads
2023-06-07 13:47:28.790 INFO org.apache.curator.framework.imps.CuratorFrameworkImpl: Starting
2023-06-07 13:47:28.794 INFO org.apache.zookeeper.ZooKeeper: Client environment:zookeeper.version=3.4.14-4c25d480e66aadd371de8bd2fd8da255ac140bcf, built on 03/06/2019 16:18 GMT
2023-06-07 13:47:28.795 INFO org.apache.zookeeper.ZooKeeper: Client environment:host.name=kyuubi-86c95975c7-nx59s
2023-06-07 13:47:28.795 INFO org.apache.zookeeper.ZooKeeper: Client environment:java.version=1.8.0_362
2023-06-07 13:47:28.795 INFO org.apache.zookeeper.ZooKeeper: Client environment:java.vendor=Temurin
2023-06-07 13:47:28.795 INFO org.apache.zookeeper.ZooKeeper: Client environment:java.home=/opt/java/openjdk/jre
2023-06-07 13:47:28.795 INFO org.apache.zookeeper.ZooKeeper: Client environment:java.class.path=/opt/kyuubi/externals/engines/trino/kyuubi-trino-engine_2.12-1.7.0.jar:/opt/kyuubi/externals/engines/trino/HikariCP-4.0.3.jar:/opt/kyuubi/externals/engines/trino/ST4-4.3.4.jar:/opt/kyuubi/externals/engines/trino/animal-sniffer-annotations-1.21.jar:/opt/kyuubi/externals/engines/trino/annotations-4.1.1.4.jar:/opt/kyuubi/externals/engines/trino/antlr-runtime-3.5.3.jar:/opt/kyuubi/externals/engines/trino/commons-lang3-3.12.0.jar:/opt/kyuubi/externals/engines/trino/commons-logging-1.1.3.jar:/opt/kyuubi/externals/engines/trino/curator-client-2.12.0.jar:/opt/kyuubi/externals/engines/trino/curator-framework-2.12.0.jar:/opt/kyuubi/externals/engines/trino/curator-recipes-2.12.0.jar:/opt/kyuubi/externals/engines/trino/error_prone_annotations-2.14.0.jar:/opt/kyuubi/externals/engines/trino/failsafe-2.4.4.jar:/opt/kyuubi/externals/engines/trino/failureaccess-1.0.1.jar:/opt/kyuubi/externals/engines/tr
ino/grpc-api-1.48.0.jar:/opt/kyuubi/externals/engines/trino/grpc-context-1.48.0.jar:/opt/kyuubi/externals/engines/trino/grpc-core-1.48.0.jar:/opt/kyuubi/externals/engines/trino/grpc-grpclb-1.48.0.jar:/opt/kyuubi/externals/engines/trino/grpc-netty-1.48.0.jar:/opt/kyuubi/externals/engines/trino/grpc-protobuf-1.48.0.jar:/opt/kyuubi/externals/engines/trino/grpc-protobuf-lite-1.48.0.jar:/opt/kyuubi/externals/engines/trino/grpc-stub-1.48.0.jar:/opt/kyuubi/externals/engines/trino/gson-2.9.0.jar:/opt/kyuubi/externals/engines/trino/guava-31.1-jre.jar:/opt/kyuubi/externals/engines/trino/hadoop-client-api-3.3.4.jar:/opt/kyuubi/externals/engines/trino/hadoop-client-runtime-3.3.4.jar:/opt/kyuubi/externals/engines/trino/hive-service-rpc-3.1.3.jar:/opt/kyuubi/externals/engines/trino/j2objc-annotations-1.3.jar:/opt/kyuubi/externals/engines/trino/jackson-annotations-2.14.2.jar:/opt/kyuubi/externals/engines/trino/jackson-core-2.14.2.jar:/opt/kyuubi/externals/engines/trino/jackson-databind-2.14.2.jar:
/opt/kyuubi/externals/engines/trino/jackson-datatype-jdk8-2.14.2.jar:/opt/kyuubi/externals/engines/trino/jackson-module-scala_2.12-2.14.2.jar:/opt/kyuubi/externals/engines/trino/jcl-over-slf4j-1.7.36.jar:/opt/kyuubi/externals/engines/trino/jetcd-api-0.7.3.jar:/opt/kyuubi/externals/engines/trino/jetcd-common-0.7.3.jar:/opt/kyuubi/externals/engines/trino/jetcd-core-0.7.3.jar:/opt/kyuubi/externals/engines/trino/jetcd-grpc-0.7.3.jar:/opt/kyuubi/externals/engines/trino/jsr305-3.0.2.jar:/opt/kyuubi/externals/engines/trino/jul-to-slf4j-1.7.36.jar:/opt/kyuubi/externals/engines/trino/kyuubi-common_2.12-1.7.0.jar:/opt/kyuubi/externals/engines/trino/kyuubi-events_2.12-1.7.0.jar:/opt/kyuubi/externals/engines/trino/kyuubi-ha_2.12-1.7.0.jar:/opt/kyuubi/externals/engines/trino/kyuubi-trino-engine_2.12-1.7.0.jar:/opt/kyuubi/externals/engines/trino/libfb303-0.9.3.jar:/opt/kyuubi/externals/engines/trino/libthrift-0.9.3.jar:/opt/kyuubi/externals/engines/trino/log4j-1.2-api-2.19.0.jar:/opt/kyuubi/exter
nals/engines/trino/log4j-api-2.19.0.jar:/opt/kyuubi/externals/engines/trino/log4j-core-2.19.0.jar:/opt/kyuubi/externals/engines/trino/log4j-slf4j-impl-2.19.0.jar:/opt/kyuubi/externals/engines/trino/netty-buffer-4.1.87.Final.jar:/opt/kyuubi/externals/engines/trino/netty-codec-4.1.87.Final.jar:/opt/kyuubi/externals/engines/trino/netty-codec-dns-4.1.87.Final.jar:/opt/kyuubi/externals/engines/trino/netty-codec-http-4.1.87.Final.jar:/opt/kyuubi/externals/engines/trino/netty-codec-http2-4.1.87.Final.jar:/opt/kyuubi/externals/engines/trino/netty-codec-socks-4.1.87.Final.jar:/opt/kyuubi/externals/engines/trino/netty-common-4.1.87.Final.jar:/opt/kyuubi/externals/engines/trino/netty-handler-4.1.87.Final.jar:/opt/kyuubi/externals/engines/trino/netty-handler-proxy-4.1.87.Final.jar:/opt/kyuubi/externals/engines/trino/netty-resolver-4.1.87.Final.jar:/opt/kyuubi/externals/engines/trino/netty-resolver-dns-4.1.87.Final.jar:/opt/kyuubi/externals/engines/trino/netty-transport-4.1.87.Final.jar:/opt/kyu
ubi/externals/engines/trino/netty-transport-classes-epoll-4.1.87.Final.jar:/opt/kyuubi/externals/engines/trino/netty-transport-native-epoll-4.1.87.Final-linux-aarch_64.jar:/opt/kyuubi/externals/engines/trino/netty-transport-native-epoll-4.1.87.Final-linux-x86_64.jar:/opt/kyuubi/externals/engines/trino/netty-transport-native-unix-common-4.1.87.Final.jar:/opt/kyuubi/externals/engines/trino/okhttp-3.14.9.jar:/opt/kyuubi/externals/engines/trino/okhttp-urlconnection-3.14.9.jar:/opt/kyuubi/externals/engines/trino/okio-1.17.2.jar:/opt/kyuubi/externals/engines/trino/paranamer-2.8.jar:/opt/kyuubi/externals/engines/trino/perfmark-api-0.25.0.jar:/opt/kyuubi/externals/engines/trino/proto-google-common-protos-2.9.0.jar:/opt/kyuubi/externals/engines/trino/protobuf-java-3.21.7.jar:/opt/kyuubi/externals/engines/trino/protobuf-java-util-3.21.7.jar:/opt/kyuubi/externals/engines/trino/scala-library-2.12.17.jar:/opt/kyuubi/externals/engines/trino/slf4j-api-1.7.36.jar:/opt/kyuubi/externals/engines/trino
/trino-client-363.jar:/opt/kyuubi/externals/engines/trino/units-1.6.jar:/opt/kyuubi/externals/engines/trino/vertx-core-4.3.2.jar:/opt/kyuubi/externals/engines/trino/vertx-grpc-4.3.2.jar:/opt/kyuubi/externals/engines/trino/zookeeper-3.4.14.jar
2023-06-07 13:47:28.795 INFO org.apache.zookeeper.ZooKeeper: Client environment:java.library.path=/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib
2023-06-07 13:47:28.795 INFO org.apache.zookeeper.ZooKeeper: Client environment:java.io.tmpdir=/tmp
2023-06-07 13:47:28.795 INFO org.apache.zookeeper.ZooKeeper: Client environment:java.compiler=<NA>
2023-06-07 13:47:28.795 INFO org.apache.zookeeper.ZooKeeper: Client environment:os.name=Linux
2023-06-07 13:47:28.795 INFO org.apache.zookeeper.ZooKeeper: Client environment:os.arch=amd64
2023-06-07 13:47:28.795 INFO org.apache.zookeeper.ZooKeeper: Client environment:os.version=5.4.17-2136.307.3.1.el8uek.x86_64
2023-06-07 13:47:28.795 INFO org.apache.zookeeper.ZooKeeper: Client environment:user.name=root
2023-06-07 13:47:28.795 INFO org.apache.zookeeper.ZooKeeper: Client environment:user.home=/root
2023-06-07 13:47:28.795 INFO org.apache.zookeeper.ZooKeeper: Client environment:user.dir=/opt/kyuubi/work/admin
2023-06-07 13:47:28.796 INFO org.apache.zookeeper.ZooKeeper: Initiating client connection, connectString=kyuubi-86c95975c7-nx59s:2181 sessionTimeout=60000 watcher=org.apache.curator.ConnectionState@201b6b6f
2023-06-07 13:47:28.806 INFO org.apache.kyuubi.ha.client.EngineServiceDiscovery: Service[EngineServiceDiscovery] is initialized.
2023-06-07 13:47:28.806 INFO org.apache.kyuubi.engine.trino.TrinoTBinaryFrontendService: Service[TrinoTBinaryFrontend] is initialized.
2023-06-07 13:47:28.806 INFO org.apache.kyuubi.engine.trino.TrinoSqlEngine: Service[TrinoSQLEngine] is initialized.
2023-06-07 13:47:28.807 INFO org.apache.zookeeper.ClientCnxn: Opening socket connection to server kyuubi-86c95975c7-nx59s/172.20.92.79:2181. Will not attempt to authenticate using SASL (unknown error)
2023-06-07 13:47:28.811 INFO org.apache.zookeeper.ClientCnxn: Socket connection established to kyuubi-86c95975c7-nx59s/172.20.92.79:2181, initiating session
2023-06-07 13:47:28.814 INFO org.apache.zookeeper.ClientCnxn: Session establishment complete on server kyuubi-86c95975c7-nx59s/172.20.92.79:2181, sessionid = 0x10240e15f740002, negotiated timeout = 60000
2023-06-07 13:47:28.818 INFO org.apache.curator.framework.state.ConnectionStateManager: State change: CONNECTED
2023-06-07 13:47:28.820 INFO org.apache.kyuubi.ha.client.zookeeper.ZookeeperDiscoveryClient: Zookeeper client connection state changed to: CONNECTED
2023-06-07 13:47:28.857 INFO org.apache.kyuubi.engine.trino.event.handler.TrinoJsonLoggingEventHandler: Logging kyuubi events to file:/tmp/kyuubi/events/trino_engine/day=20230607/Trino-kyuubi-86c95975c7-nx59s.json
2023-06-07 13:47:29.172 INFO org.apache.kyuubi.engine.trino.operation.TrinoOperationManager: Service[TrinoOperationManager] is started.
2023-06-07 13:47:29.172 INFO org.apache.kyuubi.engine.trino.session.TrinoSessionManager: Service[TrinoSessionManager] is started.
2023-06-07 13:47:29.172 INFO org.apache.kyuubi.engine.trino.TrinoBackendService: Service[TrinoBackendService] is started.
2023-06-07 13:47:29.245 INFO org.apache.kyuubi.ha.client.zookeeper.ZookeeperDiscoveryClient: Created a /kyuubi_1.7.0_USER_TRINO/admin/default/serviceUri=kyuubi-86c95975c7-nx59s:46789;version=1.7.0;refId=1a38d5b0-2f1d-486f-bca2-da78371d63cc;sequence=0000000000 on ZooKeeper for KyuubiServer uri: kyuubi-86c95975c7-nx59s:46789
2023-06-07 13:47:29.246 INFO org.apache.kyuubi.ha.client.EngineServiceDiscovery: Service[EngineServiceDiscovery] is started.
2023-06-07 13:47:29.246 INFO org.apache.kyuubi.engine.trino.TrinoTBinaryFrontendService: Service[TrinoTBinaryFrontend] is started.
2023-06-07 13:47:29.246 INFO org.apache.kyuubi.engine.trino.TrinoSqlEngine: Service[TrinoSQLEngine] is started.
2023-06-07 13:47:29.448 INFO org.apache.kyuubi.engine.trino.TrinoTBinaryFrontendService: Client protocol version:HIVE_CLI_SERVICE_PROTOCOL_V10
2023-06-07 13:47:29.454 INFO org.apache.kyuubi.engine.trino.session.TrinoSessionManager: Opening session for admin@172.20.92.79
2023-06-07 13:47:29.599 INFO org.apache.kyuubi.engine.trino.event.handler.TrinoJsonLoggingEventHandler: Logging kyuubi events to file:/tmp/kyuubi/events/trino_session/day=20230607/Trino-kyuubi-86c95975c7-nx59s.json
2023-06-07 13:47:29.613 INFO org.apache.kyuubi.engine.trino.session.TrinoSessionManager: admin's session with SessionHandle [78a28437-ff95-45b8-979a-97732bc04faa] is opened, current opening sessions 1
2023-06-07 13:47:32.841 INFO org.apache.kyuubi.operation.log.OperationLog: Creating operation log file /opt/kyuubi/work/engine_operation_logs/78a28437-ff95-45b8-979a-97732bc04faa/0d3cb82b-fcdd-49fa-9a50-bb8d10780006
2023-06-07 13:47:32.850 INFO org.apache.kyuubi.engine.trino.event.handler.TrinoJsonLoggingEventHandler: Logging kyuubi events to file:/tmp/kyuubi/events/trino_operation/day=20230607/Trino-kyuubi-86c95975c7-nx59s.json
2023-06-07 13:47:32.870 INFO org.apache.kyuubi.engine.trino.operation.ExecuteStatement: Processing admin's query[0d3cb82b-fcdd-49fa-9a50-bb8d10780006]: PENDING_STATE -> RUNNING_STATE, statement:
use default
2023-06-07 13:47:32.894 INFO org.apache.kyuubi.engine.trino.TrinoStatement: Execute with Trino query id: 20230607_054732_00021_gvgri
2023-06-07 13:47:32.894 INFO org.apache.kyuubi.engine.trino.operation.ExecuteStatement: Execute in full collect mode
2023-06-07 13:47:32.899 INFO org.apache.kyuubi.engine.trino.operation.ExecuteStatement: Processing admin's query[0d3cb82b-fcdd-49fa-9a50-bb8d10780006]: RUNNING_STATE -> FINISHED_STATE, time taken: 0.028 seconds
2023-06-07 13:47:32.984 INFO org.apache.kyuubi.engine.trino.TrinoTBinaryFrontendService: Session [SessionHandle [78a28437-ff95-45b8-979a-97732bc04faa]] disconnected without closing properly, close it now
2023-06-07 13:47:32.984 INFO org.apache.kyuubi.engine.trino.session.TrinoSessionManager: admin's session with SessionHandle [78a28437-ff95-45b8-979a-97732bc04faa] is closed, current opening sessions 0
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@kyuubi.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@kyuubi.apache.org
For additional commands, e-mail: notifications-help@kyuubi.apache.org