Node not connected to database
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(
=======
###
### Server settings
###
xdb.port=6453
xdb.maxconnecti
xdb.default.
xdb.default.
xdb.default.
xdb.default.
xdb.default.
xdb.jdbc.
xdb.jdbc.
xdb.maxconnecti
xdb.unicode=yes
xdb.client_
xdb.loader.
xdb.metadata.
xdb.metadata.
### The number of nodes in cluster
xdb.nodecount=8
xdb.node.
xdb.node.
xdb.node.
xdb.node.
xdb.node.
xdb.node.
xdb.node.
xdb.node.
xdb.node.
xdb.node.
xdb.node.
xdb.node.
xdb.node.
xdb.node.
xdb.node.
xdb.node.
xdb.coordinator
xdb.node.
xdb.node.
xdb.node.
xdb.node.
xdb.node.
xdb.node.
xdb.node.
xdb.node.
xdb.node.
xdb.node.
xdb.node.
xdb.node.
xdb.node.
xdb.node.
xdb.node.
xdb.node.
xdb.coordinator
xdb.coordinator
root@db1001:
Starting....
root@db1001:
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
xdb.coordinator
root@db1002:
Starting....
root@db1002:
Thanks,
Sushil
Question information
- Language:
- English Edit question
- Status:
- Answered
- For:
- Stado Edit question
- Assignee:
- No assignee Edit question
- Last query:
- Last reply:
Can you help with this problem?
Provide an answer of your own, or ask Sushil for more information if necessary.