Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SCQL engine连接pgsql报错 #174

Open
Rufus369 opened this issue Nov 16, 2023 · 2 comments
Open

SCQL engine连接pgsql报错 #174

Rufus369 opened this issue Nov 16, 2023 · 2 comments
Assignees

Comments

@Rufus369
Copy link

把scql engine的数据源换成pgsql,在client执行查询语句,报如下错误,请问应该怎么修改配置?

`[demo]alice> SELECT ta.credit_rank, COUNT(*) as cnt, AVG(ta.income) as avg_income, AVG(tb.order_amount) as avg_amount FROM ta INNER JOIN tb ON ta.ID = tb.ID WHERE ta.age >= 20 AND ta.age <= 30 AND tb.is_active=1 GROUP BY ta.credit_rank;
[fetch]err: Code: 320, message:RunExecutionPlan run jobs(3399514f-75b5-11ee-bb1d-0242c0a87006) failed, catch std::exception=[engine/datasource/odbc_ad aptor.cc:58] catch unexpected Poco::Data::DataException: Connection attempt failed: Connection Error: connection to server on socket "/tmp/.s.PGSQL.54 32" failed: No such file or directory
Is the server running locally and accepting connections on that socket?

Stacktrace:
#0 scql::engine::op::RunSQL::Execute()+0x556e3e6f20f6
#1 scql::engine::Executor::RunExecNode()+0x556e3e4deb33
#2 scql::engine::EngineServiceImpl::RunPlan()+0x556e3e4d163d
#3 scql::engine::EngineServiceImpl::RunExecutionPlan()+0x556e3e4d4625
#4 brpc::policy::ProcessHttpRequest()+0x556e40ccd321
#5 brpc::ProcessInputMessage()+0x556e40c77b97
#6 brpc::InputMessenger::InputMessageClosure::~InputMessageClosure()+0x556e40c785f1
#7 brpc::InputMessenger::OnNewMessages()+0x556e40c790a1
#8 brpc::Socket::ProcessEvent()+0x556e40d739fe
#9 bthread::TaskGroup::task_runner()+0x556e40dcd497
#10 bthread_make_fcontext+0x556e40db8b01
`

@tongke6
Copy link
Collaborator

tongke6 commented Nov 20, 2023

请进入到 engine 的容器中,用配置的 pgsql 连接串连接一下 pgsql 试下,看是否可以联通

@tyrone-yu
Copy link
Contributor

请问使用的 pg 的版本是哪个?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants