search

heavyai / heavydb

HeavyDB (formerly OmniSciDB)
https://heavy.ai
Apache License 2.0
2.96k stars 448 forks source link

Connection refused #724

Open meizizi-jy opened 2 years ago

meizizi-jy commented 2 years ago

Thrift: Fri Mar 11 09:56:51 2022 TSocket::open() connect() <Host: localhost Port: 6274>: Connection refused

image

cdessanti commented 2 years ago

Hi,

how have you started the server? if it's thru services, maybe the server is crashing and the systemd is restarting could you shot the output of command

sudo service omnisci_server status

Thanks, in advance

meizizi-jy commented 2 years ago

Hi,

how have you started the server? if it's thru services, maybe the server is crashing and the systemd is restarting could you shot the output of command

sudo service omnisci_server status

Thanks, in advance

image

cdessanti commented 2 years ago

seems that everything is correct to me.

so each time you connect to the server you get a connection refused.

I cannot reproduce the issue, could you run a netstat -an | grep LISTEN to know in which interface the server is listening?

meizizi-jy commented 2 years ago

seems that everything is correct to me.

so each time you connect to the server you get a connection refused.

I cannot reproduce the issue, could you run a netstat -an | grep LISTEN to know in which interface the server is listening?

Step by step according to the official website is now this port denied access, has been stuck here

image image

cdessanti commented 2 years ago

Which installation process are you following?

meizizi-jy commented 2 years ago

Which installation process are you following?

This installation process is followed image

cdessanti commented 2 years ago

Hi @meizizi-jy,

I'm sorry if toooks so much but I found a quite simple solution that can resolve your issue. It looks that in RH/COS the localhost is mapped by the default with both IPV4 and IPV6 adressses, so the thrift library tries to connect on IPV6 first, then in IPV4, causing the error. To change this behaviour you can change the precedence of name resolution from IPV6 to IPV4 uncommenting this line in the/etc/gai.conf file precedence ::ffff:0:0/96 100

If it's not needed you can also disable IPv6 at all, or change the /etc/hosts file, or use the -s switch with omnisql specyfing the IP address of localhost or the IPV4 interface of you machine.

Candido