[Ala-portal] Using Biocache-Store and Apache Cassandra on different servers

[Daniel Lins]

Hi,

We configured the ALA applications on different Servers of the database
Server. However, we are having problems running the biocache-store.

I changed the biocache configuration file
(/data/biocache/config/biocache-config.properties) and the Cassandra
configuration (cassandra.yaml) for enabling remote access.

(biocache-config.properties)
# Cassandra Config
db=cassandra
*cassandra.hosts=192.168.15.199*
cassandra.port=9160
cassandra.pool=biocache-store-pool
cassandra.keyspace=occ
cassandra.max.connections=-1
cassandra.max.retries=6
thrift.operation.timeout=8000

(cassandra.yaml)

*listen_address: 192.168.15.199*

*rpc_address: 192.168.15.199*
*rpc_port: 9160*
...

*Running the Biocache-store in the server 192.168.15.132*

When I ran the Loading method, the data were saved correctly in the
Cassandra Database. However, in the Processing method, the data was not
recovered (see message below) and the Indexing method did not index.

biocache> process dr0
Processing dr0 incremental=false
2014-06-25 00:17:20,228 INFO : [Consumer] - Initialising thread: 0
2014-06-25 00:17:20,270 INFO : [Consumer] - Initialising thread: 1
2014-06-25 00:17:20,271 INFO : [Consumer] - Initialising thread: 2
2014-06-25 00:17:20,274 INFO : [Consumer] - Initialising thread: 3
2014-06-25 00:17:20,275 INFO : [ProcessWithActors] - Starting with dr0|
endingwith dr0|~
2014-06-25 00:17:20,275 INFO : [ProcessWithActors] - Initialised actors...
2014-06-25 00:17:20,274 INFO : [Consumer] - In thread: 0
2014-06-25 00:17:20,274 INFO : [Consumer] - In thread: 1
2014-06-25 00:17:20,281 INFO : [Consumer] - In thread: 2
2014-06-25 00:17:20,293 INFO : [Consumer] - In thread: 3
2014-06-25 00:17:20,326 INFO : [ProcessWithActors] - Last row key
processed:
2014-06-25 00:17:20,327 INFO : [ProcessWithActors] - Finished.
2014-06-25 00:17:20,333 INFO : [Consumer] - Killing (Actor.act) thread: 0
2014-06-25 00:17:20,333 INFO : [Consumer] - Killing (Actor.act) thread: 3
2014-06-25 00:17:20,333 INFO : [Consumer] - Killing (Actor.act) thread: 2
2014-06-25 00:17:20,333 INFO : [Consumer] - Killing (Actor.act) thread: 1

biocache> index dr0
2014-06-25 00:17:36,848 INFO : [IndexRecords] - Starting to index dr0|
until dr0|~
2014-06-25 00:17:36,858 INFO : [IndexRecords] - Total indexing time 0.005
seconds
2014-06-25 00:17:36,858 INFO : [SolrIndexDAO] - Initialising the solr
server http://192.168.15.132:8080/solr null null
2014-06-25 00:17:36,859 INFO : [SolrIndexDAO] - Initialising connection to
SOLR server.....
2014-06-25 00:17:37,764 INFO : [SolrIndexDAO] - Initialising connection to
SOLR server - done.
2014-06-25 00:17:38,040 INFO : [SolrIndexDAO] - >>>>>>>>>>>>> Document
count of index: 0
2014-06-25 00:17:38,041 INFO : [SolrIndexDAO] - Finalise finished.

** The delete_resource method also didn't work and I need to delete the
occurrence table using the truncate command.

Does anyone know how to solve this issue?

Thanks!!

Regards,

-- 
Daniel Lins da Silva
(Mobile) 55 11 96144-4050
Research Center on Biodiversity and Computing (Biocomp)
University of Sao Paulo, Brazil
daniellins at usp.br
daniel.lins at gmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.gbif.org/pipermail/ala-portal/attachments/20140625/b39fd250/attachment.html