Node not connected to database

Asked by Sushil

Hi,

I have a stado cluster setup on two physical severs with eight nodes (four in each). I am able to create table, load data and query also. But when I restart the coordinator and agent service in cluster and then try to connect from command line I am getting the following error.

"SQLException: ERROR: Node 6 has aborted execution, cause is: Not connected to database: "

The database connectivity is not a issue, I have set trusted connection in pg_hba.conf for all database servers inside the cluster.

Below is my stado.config file.

stado.config(192.168.100.60)
========================

###
### Server settings
###

xdb.port=6453
xdb.maxconnections=10

xdb.default.dbusername=*******
xdb.default.dbpassword=*******

xdb.default.dbport=5488

xdb.default.threads.pool.initsize=5
xdb.default.threads.pool.maxsize=10
xdb.jdbc.pool.maxsize=200
xdb.jdbc.pool.initsize=5
xdb.maxconnections=100
xdb.unicode=yes
xdb.client_encoding.ignore=true
xdb.loader.dataprocessors.count=3

xdb.metadata.database=XDBSYS
xdb.metadata.dbhost=192.168.100.60

### The number of nodes in cluster

xdb.nodecount=8

xdb.node.1.dbhost=192.168.100.60
xdb.node.1.dbport=5488
xdb.node.2.dbhost=192.168.100.60
xdb.node.2.dbport=5433
xdb.node.3.dbhost=192.168.100.60
xdb.node.3.dbport=5444
xdb.node.4.dbhost=192.168.100.60
xdb.node.4.dbport=5455

xdb.node.5.dbhost=192.168.100.61
xdb.node.5.dbport=5488
xdb.node.6.dbhost=192.168.100.61
xdb.node.6.dbport=5433
xdb.node.7.dbhost=192.168.100.61
xdb.node.7.dbport=5444
xdb.node.8.dbhost=192.168.100.61
xdb.node.8.dbport=5455

xdb.coordinator.node=1

xdb.node.1.port=6455
xdb.node.1.host=192.168.100.60
xdb.node.2.port=6456
xdb.node.2.host=192.168.100.60
xdb.node.3.port=6457
xdb.node.3.host=192.168.100.60
xdb.node.4.port=6458
xdb.node.4.host=192.168.100.60
xdb.node.5.port=7455
xdb.node.5.host=192.168.100.61
xdb.node.6.port=7456
xdb.node.6.host=192.168.100.61
xdb.node.7.port=7457
xdb.node.7.host=192.168.100.61
xdb.node.8.port=7458
xdb.node.8.host=192.168.100.61

xdb.coordinator.host=192.168.100.60
xdb.coordinator.port=6454

root@db1001:/usr/local/stado/bin# ./gs-server.sh -d dwh
Starting....
root@db1001:/usr/local/stado/bin#

I am not starting any agent on the master node.

stado_agent.config on (192.168.100.61)
===============================

###
### The coordinator host and port
###

xdb.coordinator.host=192.168.100.60
xdb.coordinator.port=6454

root@db1002:/usr/local/stado/bin#./gs-agent.sh -n 5 6 7 8;
Starting....
root@db1002:/usr/local/stado/bin#

Thanks,
Sushil

Question information

Language:
English Edit question
Status:
Answered
For:
Stado Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Alvin Peng (pengalvin) said :
#1

There may be bug for agent restart.
You can try below sequence for restarts:
1. kill agent
2. shut down Stado
3. start Stado
4. start agent

Can you help with this problem?

Provide an answer of your own, or ask Sushil for more information if necessary.

To post a message you must log in.