Fetch result failed

[ssdyue]

Issue Type

Running

Have you searched for existing issues?

No

OS Platform and Distribution

Ubuntu 18.04

SCQL Version

SCQL 0.9.2b1

What happend and What you expected to happen.

{"status":{"code":300,"message":"FetchResult: failed in session result check: QueryResponse error: status = code:300 message:\"Error 1235: Not supported feature or function\"","details":[]},"result":null,"job_status":null}

Configuration used to run SCQL.

curl -X POST http://127.0.0.1:80/intra/project/create \
--header "host: scql-broker-intra.alice.svc" \
--header "kuscia-source: alice" \
-d '{
    "project_id":"demo",
    "name":"demo",
    "conf":{
        "spu_runtime_cfg": {
        "protocol": "SEMI2K",
        "field": "FM64"
        },
        "group_by_threshold": "1"
    },
   "description":"this is a demo project"
}'

SCQL log output.

# alice.log
2025-01-15 11:57:14.243 [warning] [engine_service_impl.cc:ReportResult:444] [job(db9dbb3f-d2eb-11ef-886e-c64f99d9b14d)] session(db9dbb3f-d2eb-11ef-886e-c64f99d9b14d) send rpc request to driver, callback_url=http://scql-broker-intra.alice.svc:22995/intra/cb/engine
2025-01-15 11:57:18.993 [info] [engine_service_impl.cc:ReportResult:457] [job(db9dbb3f-d2eb-11ef-886e-c64f99d9b14d)] session(db9dbb3f-d2eb-11ef-886e-c64f99d9b14d) report success, get response ({}), used(4749ms)
2025-01-15 11:57:19.583 [info] [session_manager.cc:RemoveSession:235] [scqlengine] session(db9dbb3f-d2eb-11ef-886e-c64f99d9b14d) removed, running_cost(3805858ms), current running session=0
*** SIGTERM received at time=1736913441 on cpu 68 ***
PC: @     0x7fa25ceed7f8  (unknown)  clock_nanosleep
    @     0x7fa25ce4a520  (unknown)  (unknown)
    @     0x55893eac5b92         32  brpc::Server::RunUntilAskedToQuit()
    @     0x55893b03cb36       4928  main
    @     0x7fa25ce31d90  (unknown)  (unknown)
rpc error: code = Unknown desc = failed to get container status of "53fa0fbaa487ed8106c392b795a037514c157e9ffae1439be8ceba6b3eb9d5d8": container 53fa0fbaa487ed8106c392b795a037514c157e9ffae1439be8ceba6b3eb9d5d8: not found


# bob.log
2025-01-15 11:57:13.996 [warning] [engine_service_impl.cc:ReportResult:444] [job(db9dbb3f-d2eb-11ef-886e-c64f99d9b14d)] session(db9dbb3f-d2eb-11ef-886e-c64f99d9b14d) send rpc request to driver, callback_url=http://scql-broker-intra.bob.svc:26298/intra/cb/engine
2025-01-15 11:57:15.634 [info] [engine_service_impl.cc:ReportResult:457] [job(db9dbb3f-d2eb-11ef-886e-c64f99d9b14d)] session(db9dbb3f-d2eb-11ef-886e-c64f99d9b14d) report success, get response ({}), used(1637ms)
2025-01-15 11:57:15.654 [info] [session_manager.cc:RemoveSession:235] [scqlengine] session(db9dbb3f-d2eb-11ef-886e-c64f99d9b14d) removed, running_cost(3802386ms), current running session=0
*** SIGTERM received at time=1736913438 on cpu 6 ***
PC: @     0x7f62ac9687f8  (unknown)  clock_nanosleep
    @     0x7f62ac8c5520  (unknown)  (unknown)
    @     0x556608669b92         32  brpc::Server::RunUntilAskedToQuit()
    @     0x556604be0b36       4928  main
    @     0x7f62ac8acd90  (unknown)  (unknown)
rpc error: code = Unknown desc = failed to get container status of "b73a15a1cf02f3836e070e55de6bb2effb93131286f9dfc2f9ae45f91f3a8d97": container b73a15a1cf02f3836e070e55de6bb2effb93131286f9dfc2f9ae45f91f3a8d97: not found

[wangzul]

是按照这个文档操作的吗？
https://www.secretflow.org.cn/zh-CN/docs/kuscia/v0.13.0b0/tutorial/run_scql_on_kuscia_cn

[jingshi-ant]

您好：可以补充下create job里的具体query信息，以及更完整的engine日志，以帮助确认Error 1235: Not supported feature or function的来源

[wangzul]

可以提供一下日志
在目录 /home/kuscia/var/stdout/pods 下可以看到对应 SCQL Broker 和 Engine 应用容器的目录。后续进入到相应目录下，即可查看应用的日志。

查看当前应用容器的目录

ls /home/kuscia/var/stdout/pods

查看应用容器的日志，示例如下:

cat /home/kuscia/var/stdout/pods/alice_xxxx_engine_xxxx/secretflow/0.log
cat /home/kuscia/var/stdout/pods/alice_xxxx_broker_xxxx/secretflow/0.log

[wangzul]

由于您长时间没有回复，这边先关闭这个问题。后续有其他问题，欢迎再沟通！