Connection Error from iquery


#1

We were finally able to get Postgres 8.4 installed and build SciDB from source on Rocks. We configured using the example config.ini and documentation and were able to create a database using initall and start it using startall. However, when we try to use iquery, it gives the following error:

2 [0x7ff0ac375760] FATAL scidb.services.network null - Error #system:111 when connecting to localhost:1239
2 [0x7ff0ac375760] FATAL scidb.services.network null - Error #system:111 when connecting to localhost:1239
iquery SystemException in file: src/network/BaseConnection.cpp function: connect line: 267
Error id: scidb::SCIDB_SE_NETWORK::SCIDB_LE_CONNECTION_ERROR
Error description: Network error. Error #system:111 when connecting to localhost:1239.

At first, I thought it might be a firewall issue, so I checked the firewall settings and they seem OK. Also, I wrote my own socket based daemon and set it to listen on port 1239 and was able to accept connections both locally and from remote machines so I know that is not the issue. I guess I can dig into the iquery source and see what is causing the error, but I thought I would post here in case anyone has seen this before and there is a simple fix. Any help would be much appreciated.

By the way, we also built from source successfully and ran on Fedora 17 which is also CentOS based like Rocks and did not see this issue.

Thanks,
John Rushing
University of Alabama in Huntsville


#2

John,

During our tests, this is usually a telltale sign that scidb is not running. Perhaps it started and stopped right away. Check “ps” output for scidb process? Check scidb.log for any clues?

-Alex P


#3

Alex,

Thanks for the quick reply! I checked ps and got this:

[scidb@hawkeye etc]$ ps -ef | grep scidb
root 18754 31632 0 09:57 pts/0 00:00:00 su scidb
scidb 18756 18754 0 09:57 pts/0 00:00:00 bash
root 21434 21288 0 11:56 pts/1 00:00:00 su scidb
scidb 21435 21434 0 11:56 pts/1 00:00:00 bash
root 25223 1 0 12:58 pts/1 00:00:00 /home/scidb/test1/000/0/SciDB-000-0-1239 -i localhost -p 1239 --merge-sort-buffer 512 --cache 256 -k -l /opt/scidb/12.3/share/scidb/log4cxx.properties --plugins /opt/scidb/12.3/lib/scidb/plugins -s /home/scidb/test1/000/0/storage.cfg -c host=localhost port=5432 dbname=test1 user=test1user password=test1passwd
scidb 27384 18756 0 15:32 pts/0 00:00:00 ps -ef
scidb 27385 18756 0 15:32 pts/0 00:00:00 grep scidb

So it looks like it is still running.

However, the log has the following:


array-emptyable-by-default : 1
small-memalloc-size : -1
large-memalloc-limit : -1

2012-09-19 15:35:09,870 [0x7f31c2e70840] [ERROR]: System catalog connection failed: SystemException in file: src/system/catalog/SystemCatalog.cpp function: con
nect line: 1871
Error id: scidb::SCIDB_SE_SYSCAT::SCIDB_LE_CANT_CONNECT_PG
Error description: System catalog error. Cannot connect to PostgreSQL catalog: ‘FATAL: Ident authentication failed for user “test1user”
’.

Postgres also seems to be running. Do I need to change some configuration in postgres?

Thanks,
John


#4

This means that the initialization didn’t succeed. You could use the commands described in Section 2.1.1.2 of the User Guide in version 12.3.
root$ sudo -u postgres /opt/scidb/12.3/bin/scidb-prepare-db.sh
p4-releases-12-03.s3.amazonaws.c … e-12.3.pdf

Then, repeat the stopall, initall, startall steps.