<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" id="owaParaStyle"></style>
</head>
<body fpstyle="1" ocsi="0">
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;">
<div>Sorry, Im not sure whats happening here.</div>
<div><br>
</div>
<div>If you are using the same biocache commandline tool to load the data and do the processing then there shouldnt be an issue as it uses the same configuration.</div>
<div>If you are running the&nbsp;<span style="font-size: 10pt;">biocache commandline tool</span><span style="font-size: 10pt;">&nbsp;on one machine to do the loading, and the running the&nbsp;</span><span style="font-size: 10pt;">biocache commandline tool</span><span style="font-size: 10pt;">&nbsp;on
 a different machine to do the processing then they will be using different configuration files with potentially different content.</span></div>
<div><span style="font-size: 10pt;"><br>
</span></div>
<div><span style="font-size: 10pt;">Dave</span></div>
<div><br>
</div>
<br>
<div style="font-family: Times New Roman; color: #000000; font-size: 16px">
<hr tabindex="-1">
<div id="divRpF462172" style="direction: ltr;"><font face="Tahoma" size="2" color="#000000"><b>From:</b> Daniel Lins [daniel.lins@gmail.com]<br>
<b>Sent:</b> 25 June 2014 16:40<br>
<b>To:</b> Martin, Dave (CES, Black Mountain)<br>
<b>Cc:</b> ala-portal@lists.gbif.org; Pedro Corrêa<br>
<b>Subject:</b> Re: [ExternalEmail] Re: [Ala-portal] Using Biocache-Store and Apache Cassandra on different servers<br>
</font><br>
</div>
<div></div>
<div>
<div dir="ltr">
<div>Hi Dave,</div>
<div><br>
</div>
<div>This seems to be the problem! But which settings could be?&nbsp;Something in the external configuration file?</div>
<div><br>
</div>
<div>Because when I set the biocache property (<b style="font-size:13px; font-family:arial,sans-serif">cassandra.hosts=localhost)</b>&nbsp;to access the local instance of Cassandra it works perfectly.</div>
<div><br>
</div>
<div>When I ran the processing process, biocache returns these messages:</div>
<div><br>
</div>
<div>&nbsp;biocache&gt; process dr0</div>
<div>Processing dr0 incremental=false</div>
<div>2014-06-25 03:26:29,145 INFO : [Consumer] - Initialising thread: 0</div>
<div>2014-06-25 03:26:29,189 INFO : [Consumer] - Initialising thread: 1</div>
<div>2014-06-25 03:26:29,190 INFO : [Consumer] - Initialising thread: 2</div>
<div>2014-06-25 03:26:29,191 INFO : [Consumer] - Initialising thread: 3</div>
<div>2014-06-25 03:26:29,191 INFO : [ProcessWithActors] - Starting with dr0| endingwith dr0|~</div>
<div>2014-06-25 03:26:29,193 INFO : [ProcessWithActors] - Initialised actors...</div>
<div>2014-06-25 03:26:29,200 INFO : [Consumer] - In thread: 1</div>
<div>2014-06-25 03:26:29,200 INFO : [Consumer] - In thread: 0</div>
<div>2014-06-25 03:26:29,200 INFO : [Consumer] - In thread: 2</div>
<div>2014-06-25 03:26:29,209 INFO : [Consumer] - In thread: 3</div>
<div>2014-06-25 03:26:29,271 INFO : [ProcessWithActors] - Last row key processed:&nbsp;</div>
<div>2014-06-25 03:26:29,271 INFO : [ProcessWithActors] - Finished.</div>
<div>2014-06-25 03:26:29,278 INFO : [Consumer] - Killing (Actor.act) thread: 0</div>
<div>2014-06-25 03:26:29,278 INFO : [Consumer] - Killing (Actor.act) thread: 3</div>
<div>2014-06-25 03:26:29,278 INFO : [Consumer] - Killing (Actor.act) thread: 2</div>
<div>2014-06-25 03:26:29,278 INFO : [Consumer] - Killing (Actor.act) thread: 1</div>
<div><br>
</div>
<div>and the Cassandra data, I believe that remains the same:</div>
<div><br>
</div>
<div>
<div>[default@occ] list occ limit 1;</div>
<div>Using default cell limit of 100</div>
<div>-------------------</div>
<div>RowKey: dr0|urn:lsid:icmbio.gov.br:icmbio.parnaso.occurrence:MA120999</div>
<div>=&gt; (name=acceptedNameUsageID, value=MA20, timestamp=1403674832408000)</div>
<div>=&gt; (name=associatedMedia, value=/data/biocache-media/dr0/11302/4356e553-1080-4815-ba86-20f85f13394c/Chrysocyon.brachyurus.jpg, timestamp=1403674832408000)</div>
<div>=&gt; (name=basisOfRecord, value=HumanObservation, timestamp=1403674832408000)</div>
<div>=&gt; (name=catalogNumber, value=MA120999, timestamp=1403674832408000)</div>
<div>=&gt; (name=classs, value=Mammalia, timestamp=1403666202349000)</div>
<div>=&gt; (name=collectionCode, value=PARNASO, timestamp=1403674832408000)</div>
<div>=&gt; (name=continent, value=América, timestamp=1403674832408000)</div>
<div>=&gt; (name=coordinatePrecision, value=30, timestamp=1403674832408000)</div>
<div>=&gt; (name=country, value=Brasil, timestamp=1403674832408000)</div>
<div>=&gt; (name=countryCode, value=BR, timestamp=1403674832408000)</div>
<div>=&gt; (name=county, value=Anastacio, timestamp=1403674832408000)</div>
<div>=&gt; (name=dataResourceUid, value=dr0, timestamp=1403674832408000)</div>
<div>=&gt; (name=datasetName, value=Monitoramento, timestamp=1403674832408000)</div>
<div>=&gt; (name=dateIdentified, value=2014-03-16 00:00:00.0, timestamp=1403674832408000)</div>
<div>=&gt; (name=day, value=16, timestamp=1403674832408000)</div>
<div>=&gt; (name=decimalLatitude, value=-18.355717, timestamp=1403674832408000)</div>
<div>=&gt; (name=decimalLongitude, value=-55.55105, timestamp=1403674832408000)</div>
<div>=&gt; (name=defaultValuesUsed, value=false, timestamp=1403674832408000)</div>
<div>=&gt; (name=eventDate, value=2014-03-16 00:00:00.0, timestamp=1403674832408000)</div>
<div>=&gt; (name=eventID, value=100, timestamp=1403674832408000)</div>
<div>=&gt; (name=eventRemarks, value=Chuvoso, timestamp=1403674832408000)</div>
<div>=&gt; (name=family, value=Canidae, timestamp=1403674832408000)</div>
<div>=&gt; (name=firstLoaded, value=2014-06-25T00:15:40Z, timestamp=1403666202349000)</div>
<div>=&gt; (name=genus, value=Chrysocyon, timestamp=1403674832408000)</div>
<div>=&gt; (name=geodeticDatum, value=EPSG:4326, timestamp=1403674832408000)</div>
<div>=&gt; (name=georeferenceProtocol, value=&quot;Guide to Best Practices for Georeferencing&quot; (Chapman and Wieczorek, eds. 2006), timestamp=1403674832408000)</div>
<div>=&gt; (name=georeferencedBy, value=D. Silva, timestamp=1403674832408000)</div>
<div>=&gt; (name=identifiedBy, value=James L. Patton, timestamp=1403674832408000)</div>
<div>=&gt; (name=institutionCode, value=ICMBIO, timestamp=1403674832408000)</div>
<div>=&gt; (name=kingdom, value=Animalia, timestamp=1403674832408000)</div>
<div>=&gt; (name=language, value=pt-BR, timestamp=1403674832408000)</div>
<div>=&gt; (name=lastModifiedTime, value=2014-06-25T02:40:29Z, timestamp=1403674832408000)</div>
<div>=&gt; (name=locality, value=Fazenda Alegre Paraguai River, timestamp=1403674832408000)</div>
<div>=&gt; (name=locationDetermined, value=false, timestamp=1403674832408000)</div>
<div>=&gt; (name=locationRemarks, value=Cerrado, timestamp=1403674832408000)</div>
<div>=&gt; (name=maximumElevationInMeters, value=0, timestamp=1403674832408000)</div>
<div>=&gt; (name=minimumElevationInMeters, value=0, timestamp=1403674832408000)</div>
<div>=&gt; (name=miscProperties, value={&quot;class&quot;:&quot;Mammalia&quot;,&quot;type&quot;:&quot;Event&quot;}, timestamp=1403674832408000)</div>
<div>=&gt; (name=modified, value=2013-03-16 18:19:39.0, timestamp=1403674832408000)</div>
<div>=&gt; (name=month, value=3, timestamp=1403674832408000)</div>
<div>=&gt; (name=municipality, value=Anastacio, timestamp=1403674832408000)</div>
<div>=&gt; (name=occurrenceID, value=urn:lsid:icmbio.gov.br:icmbio.parnaso.occurrence:MA120999, timestamp=1403674832408000)</div>
<div>=&gt; (name=order, value=Carnivora, timestamp=1403674832408000)</div>
<div>=&gt; (name=phylum, value=Chordata, timestamp=1403674832408000)</div>
<div>=&gt; (name=recordNumber, value=444, timestamp=1403674832408000)</div>
<div>=&gt; (name=recordedBy, value=S. Siemel, timestamp=1403674832408000)</div>
<div>=&gt; (name=rights, value=Os termos e condições para uso estão disponíveis no documento localizado em
<a href="http://www.icmbio.gov.br/direitos/normas.pdf" target="_blank">http://www.icmbio.gov.br/direitos/normas.pdf</a>., timestamp=1403674832408000)</div>
<div>=&gt; (name=rowKey, value=dr0|urn:lsid:icmbio.gov.br:icmbio.parnaso.occurrence:MA120999, timestamp=1403674832408000)</div>
<div>=&gt; (name=samplingEffort, value=105 homem-hora, timestamp=1403674832408000)</div>
<div>=&gt; (name=samplingProtocol, value=Protocolo de Monitoramento, timestamp=1403674832408000)</div>
<div>=&gt; (name=scientificName, value=Chrysocyon brachyurus, timestamp=1403674832408000)</div>
<div>=&gt; (name=scientificNameAuthorship, value=(Illiger 1815), timestamp=1403674832408000)</div>
<div>=&gt; (name=stateProvince, value=Mato Grosso do Sul, timestamp=1403674832408000)</div>
<div>=&gt; (name=taxonRank, value=species, timestamp=1403674832408000)</div>
<div>=&gt; (name=uuid, value=4356e553-1080-4815-ba86-20f85f13394c, timestamp=1403674832408000)</div>
<div>=&gt; (name=verbatimLatitude, value=-18.355717, timestamp=1403674832408000)</div>
<div>=&gt; (name=verbatimLongitude, value=-55.55105, timestamp=1403674832408000)</div>
<div>=&gt; (name=year, value=2014, timestamp=1403674832408000)</div>
</div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">2014-06-25 3:18 GMT-03:00 <span dir="ltr">&lt;<a href="mailto:David.Martin@csiro.au" target="_blank">David.Martin@csiro.au</a>&gt;</span>:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex; border-left:1px #ccc solid; padding-left:1ex">
<div>
<div style="direction:ltr; font-family:Tahoma; color:#000000; font-size:10pt">Thanks Daniel. Is it possible that you are running a different version of the commandline tool when you run a load compared to when you run process&#43;index ?
<div><span style="font-size:10pt">I can see from the output from cassandra-cli that the records havent been processed at all.&nbsp;</span></div>
<div><span style="font-size:10pt">I can only think that when you are running the processing and indexing its using configuration that is pointing at a different server.</span></div>
<div><span style="font-size:10pt"><br>
</span></div>
<div><span style="font-size:10pt">Dave</span></div>
<div><br>
<div style="font-family:Times New Roman; color:#000000; font-size:16px">
<hr>
<div style="direction:ltr"><font face="Tahoma" color="#000000"><b>From:</b> Daniel Lins [<a href="mailto:daniel.lins@gmail.com" target="_blank">daniel.lins@gmail.com</a>]<br>
<b>Sent:</b> 25 June 2014 16:00
<div class=""><br>
<b>To:</b> Martin, Dave (CES, Black Mountain)<br>
</div>
<b>Cc:</b> <a href="mailto:ala-portal@lists.gbif.org" target="_blank">ala-portal@lists.gbif.org</a>; Pedro Corrêa<br>
<b>Subject:</b> Re: [ExternalEmail] Re: [Ala-portal] Using Biocache-Store and Apache Cassandra on different servers<br>
</font><br>
</div>
<div>
<div class="h5">
<div></div>
<div>
<div dir="ltr">Hi Dave,
<div><br>
</div>
<div>I used the biocache tool (load dr0) to load these data. To view these data in Cassandra normally I use the cassandra-cli&nbsp;or the&nbsp;cql&nbsp;tool (cqlsh).&nbsp;</div>
<div><br>
</div>
<div>After loading the data on the remote server, I can see them using these tools (see below). But after, while performing the processing and indexing steps, these issues occur.<br>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div>
<div>poliusp@poliusp-VirtualBox:~/dev/apache-cassandra-1.2.13/bin$ sudo ./cassandra-cli -h 192.168.15.199 -k occ</div>
<div>Connected to: &quot;Biocache Cluster&quot; on <a href="http://192.168.15.199/9160" target="_blank">
192.168.15.199/9160</a></div>
<div>Welcome to Cassandra CLI version 1.2.13</div>
<div><br>
</div>
<div>Type 'help;' or '?' for help.</div>
<div>Type 'quit;' or 'exit;' to quit.</div>
<div><br>
</div>
<div>[default@occ] list occ limit 1;</div>
<div>Using default cell limit of 100</div>
<div>-------------------</div>
<div>RowKey: dr0|urn:lsid:icmbio.gov.br:icmbio.parnaso.occurrence:MA120999</div>
<div>=&gt; (name=acceptedNameUsageID, value=MA20, timestamp=1403674832408000)</div>
<div>=&gt; (name=associatedMedia, value=/data/biocache-media/dr0/11302/4356e553-1080-4815-ba86-20f85f13394c/Chrysocyon.brachyurus.jpg, timestamp=1403674832408000)</div>
<div>=&gt; (name=basisOfRecord, value=HumanObservation, timestamp=1403674832408000)</div>
<div>=&gt; (name=catalogNumber, value=MA120999, timestamp=1403674832408000)</div>
<div>=&gt; (name=classs, value=Mammalia, timestamp=1403666202349000)</div>
<div>=&gt; (name=collectionCode, value=PARNASO, timestamp=1403674832408000)</div>
<div>=&gt; (name=continent, value=América, timestamp=1403674832408000)</div>
<div>=&gt; (name=coordinatePrecision, value=30, timestamp=1403674832408000)</div>
<div>=&gt; (name=country, value=Brasil, timestamp=1403674832408000)</div>
<div>=&gt; (name=countryCode, value=BR, timestamp=1403674832408000)</div>
<div>=&gt; (name=county, value=Anastacio, timestamp=1403674832408000)</div>
<div>=&gt; (name=dataResourceUid, value=dr0, timestamp=1403674832408000)</div>
<div>=&gt; (name=datasetName, value=Monitoramento, timestamp=1403674832408000)</div>
<div>=&gt; (name=dateIdentified, value=2014-03-16 00:00:00.0, timestamp=1403674832408000)</div>
<div>=&gt; (name=day, value=16, timestamp=1403674832408000)</div>
<div>=&gt; (name=decimalLatitude, value=-18.355717, timestamp=1403674832408000)</div>
<div>=&gt; (name=decimalLongitude, value=-55.55105, timestamp=1403674832408000)</div>
<div>=&gt; (name=defaultValuesUsed, value=false, timestamp=1403674832408000)</div>
<div>=&gt; (name=eventDate, value=2014-03-16 00:00:00.0, timestamp=1403674832408000)</div>
<div>=&gt; (name=eventID, value=100, timestamp=1403674832408000)</div>
<div>=&gt; (name=eventRemarks, value=Chuvoso, timestamp=1403674832408000)</div>
<div>=&gt; (name=family, value=Canidae, timestamp=1403674832408000)</div>
<div>=&gt; (name=firstLoaded, value=2014-06-25T00:15:40Z, timestamp=1403666202349000)</div>
<div>=&gt; (name=genus, value=Chrysocyon, timestamp=1403674832408000)</div>
<div>=&gt; (name=geodeticDatum, value=EPSG:4326, timestamp=1403674832408000)</div>
<div>=&gt; (name=georeferenceProtocol, value=&quot;Guide to Best Practices for Georeferencing&quot; (Chapman and Wieczorek, eds. 2006), timestamp=1403674832408000)</div>
<div>=&gt; (name=georeferencedBy, value=D. Silva, timestamp=1403674832408000)</div>
<div>=&gt; (name=identifiedBy, value=James L. Patton, timestamp=1403674832408000)</div>
<div>=&gt; (name=institutionCode, value=ICMBIO, timestamp=1403674832408000)</div>
<div>=&gt; (name=kingdom, value=Animalia, timestamp=1403674832408000)</div>
<div>=&gt; (name=language, value=pt-BR, timestamp=1403674832408000)</div>
<div>=&gt; (name=lastModifiedTime, value=2014-06-25T02:40:29Z, timestamp=1403674832408000)</div>
<div>=&gt; (name=locality, value=Fazenda Alegre Paraguai River, timestamp=1403674832408000)</div>
<div>=&gt; (name=locationDetermined, value=false, timestamp=1403674832408000)</div>
<div>=&gt; (name=locationRemarks, value=Cerrado, timestamp=1403674832408000)</div>
<div>=&gt; (name=maximumElevationInMeters, value=0, timestamp=1403674832408000)</div>
<div>=&gt; (name=minimumElevationInMeters, value=0, timestamp=1403674832408000)</div>
<div>=&gt; (name=miscProperties, value={&quot;class&quot;:&quot;Mammalia&quot;,&quot;type&quot;:&quot;Event&quot;}, timestamp=1403674832408000)</div>
<div>=&gt; (name=modified, value=2013-03-16 18:19:39.0, timestamp=1403674832408000)</div>
<div>=&gt; (name=month, value=3, timestamp=1403674832408000)</div>
<div>=&gt; (name=municipality, value=Anastacio, timestamp=1403674832408000)</div>
<div>=&gt; (name=occurrenceID, value=urn:lsid:icmbio.gov.br:icmbio.parnaso.occurrence:MA120999, timestamp=1403674832408000)</div>
<div>=&gt; (name=order, value=Carnivora, timestamp=1403674832408000)</div>
<div>=&gt; (name=phylum, value=Chordata, timestamp=1403674832408000)</div>
<div>=&gt; (name=recordNumber, value=444, timestamp=1403674832408000)</div>
<div>=&gt; (name=recordedBy, value=S. Siemel, timestamp=1403674832408000)</div>
<div>=&gt; (name=rights, value=Os termos e condições para uso estão disponíveis no documento localizado em
<a href="http://www.icmbio.gov.br/direitos/normas.pdf" target="_blank">http://www.icmbio.gov.br/direitos/normas.pdf</a>., timestamp=1403674832408000)</div>
<div>=&gt; (name=rowKey, value=dr0|urn:lsid:icmbio.gov.br:icmbio.parnaso.occurrence:MA120999, timestamp=1403674832408000)</div>
<div>=&gt; (name=samplingEffort, value=105 homem-hora, timestamp=1403674832408000)</div>
<div>=&gt; (name=samplingProtocol, value=Protocolo de Monitoramento, timestamp=1403674832408000)</div>
<div>=&gt; (name=scientificName, value=Chrysocyon brachyurus, timestamp=1403674832408000)</div>
<div>=&gt; (name=scientificNameAuthorship, value=(Illiger 1815), timestamp=1403674832408000)</div>
<div>=&gt; (name=stateProvince, value=Mato Grosso do Sul, timestamp=1403674832408000)</div>
<div>=&gt; (name=taxonRank, value=species, timestamp=1403674832408000)</div>
<div>=&gt; (name=uuid, value=4356e553-1080-4815-ba86-20f85f13394c, timestamp=1403674832408000)</div>
<div>=&gt; (name=verbatimLatitude, value=-18.355717, timestamp=1403674832408000)</div>
<div>=&gt; (name=verbatimLongitude, value=-55.55105, timestamp=1403674832408000)</div>
<div>=&gt; (name=year, value=2014, timestamp=1403674832408000)</div>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div>
<div>poliusp@poliusp-VirtualBox:~/dev/biocache$ cqlsh 192.168.15.199</div>
<div>Connected to Biocache Cluster at <a href="http://192.168.15.199:9160" target="_blank">
192.168.15.199:9160</a>.</div>
<div>[cqlsh 3.1.8 | Cassandra 2.0.8 | CQL spec 3.0.0 | Thrift protocol 19.39.0]</div>
<div>Use HELP for help.</div>
<div>cqlsh&gt; use occ;</div>
<div>cqlsh:occ&gt; select * from occ;</div>
<div><br>
</div>
<div>&nbsp;key &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; | portalId | uuid</div>
<div>---------------------------------------------------------------&#43;----------&#43;--------------------------------------</div>
<div>&nbsp;dr0|urn:lsid:icmbio.gov.br:icmbio.parnaso.occurrence:MA120999 | &nbsp; &nbsp; null | 4356e553-1080-4815-ba86-20f85f13394c</div>
<div>&nbsp; dr0|urn:lsid:icmbio.gov.br:icmbio.parnaso.occurrence:MA34261 | &nbsp; &nbsp; null | ab61409f-5e42-41a6-ac81-8bf9c0b93aac</div>
<div>&nbsp; dr0|urn:lsid:icmbio.gov.br:icmbio.parnaso.occurrence:MA63770 | &nbsp; &nbsp; null | cffb70cb-f583-4e10-8ea9-600fdce36706</div>
<div>&nbsp;dr0|urn:lsid:icmbio.gov.br:icmbio.parnaso.occurrence:MA133941 | &nbsp; &nbsp; null | 9be57c4f-e2d0-4d67-a418-cb140c113029</div>
<div>&nbsp; dr0|urn:lsid:icmbio.gov.br:icmbio.parnaso.occurrence:MA63773 | &nbsp; &nbsp; null | 9c3c0c56-9279-4e3d-8b01-a4bc9068093f</div>
<div>&nbsp; dr0|urn:lsid:icmbio.gov.br:icmbio.parnaso.occurrence:MA27101 | &nbsp; &nbsp; null | 4e1b082d-3610-45b2-b49f-f9c72c050866</div>
<div>&nbsp; dr0|urn:lsid:icmbio.gov.br:icmbio.parnaso.occurrence:MA36962 | &nbsp; &nbsp; null | 515b1fd5-7611-4724-a371-c2843f4b0900</div>
<div>&nbsp; dr0|urn:lsid:icmbio.gov.br:icmbio.parnaso.occurrence:MA63846 | &nbsp; &nbsp; null | a48edaee-f7ba-41bf-bef1-bef867a67faa</div>
<div>&nbsp; dr0|urn:lsid:icmbio.gov.br:icmbio.parnaso.occurrence:MA63771 | &nbsp; &nbsp; null | 352fe23c-7f29-43eb-bb82-8b5f195150a1</div>
<div>&nbsp; dr0|urn:lsid:icmbio.gov.br:icmbio.parnaso.occurrence:MA28313 | &nbsp; &nbsp; null | 6a1d090d-dadb-4f24-8bfe-a6c24846d8c3</div>
<div>&nbsp;dr0|urn:lsid:icmbio.gov.br:icmbio.parnaso.occurrence:MA146295 | &nbsp; &nbsp; null | 5c2500cc-6935-4caf-ad05-0fea60fc2f3c</div>
<div>&nbsp; dr0|urn:lsid:icmbio.gov.br:icmbio.parnaso.occurrence:MA42147 | &nbsp; &nbsp; null | a9f14456-01cb-44b8-91bc-605aecd26d50</div>
<div>&nbsp; &nbsp;dr0|urn:lsid:icmbio.gov.br:icmbio.parnaso.occurrence:MA2523 | &nbsp; &nbsp; null | c5a064fc-31b5-4952-a513-9062ad347db0</div>
<div>&nbsp;dr0|urn:lsid:icmbio.gov.br:icmbio.parnaso.occurrence:MA123393 | &nbsp; &nbsp; null | 75a50714-1c30-4e56-a2bb-006593b6277a</div>
<div>&nbsp; dr0|urn:lsid:icmbio.gov.br:icmbio.parnaso.occurrence:MA36937 | &nbsp; &nbsp; null | 69db738e-a98e-4f25-95e1-ba9dd52aa006</div>
<div>&nbsp; dr0|urn:lsid:icmbio.gov.br:icmbio.parnaso.occurrence:MA63769 | &nbsp; &nbsp; null | 4a8e57f0-d288-48f5-9b07-d56fe190e4e1</div>
<div>&nbsp; dr0|urn:lsid:icmbio.gov.br:icmbio.parnaso.occurrence:MA44534 | &nbsp; &nbsp; null | 173dbf31-09e6-4672-a210-dc63dbe33f47</div>
<div>&nbsp; dr0|urn:lsid:icmbio.gov.br:icmbio.parnaso.occurrence:MA21669 | &nbsp; &nbsp; null | b75bc5d8-0899-4baf-883a-bb0b97416a74</div>
<div>&nbsp; dr0|urn:lsid:icmbio.gov.br:icmbio.parnaso.occurrence:MA71180 | &nbsp; &nbsp; null | 676e7b64-2303-4707-b726-63112fde031a</div>
<div>&nbsp; dr0|urn:lsid:icmbio.gov.br:icmbio.parnaso.occurrence:MA28312 | &nbsp; &nbsp; null | 93106978-65fd-4eb6-aa5d-ca1d2e5c98f4</div>
<div>&nbsp; dr0|urn:lsid:icmbio.gov.br:icmbio.parnaso.occurrence:MA28311 | &nbsp; &nbsp; null | 92c03fe9-20cf-4ff0-9749-85e5730e8893</div>
<div>&nbsp; dr0|urn:lsid:icmbio.gov.br:icmbio.parnaso.occurrence:MA23771 | &nbsp; &nbsp; null | a7c18f6a-5575-48e5-b5fc-8cf3b28a8848</div>
<div>&nbsp; dr0|urn:lsid:icmbio.gov.br:icmbio.parnaso.occurrence:MA71179 | &nbsp; &nbsp; null | 4ea9ad71-16a3-4f17-800c-ba40492c978b</div>
<div>&nbsp; dr0|urn:lsid:icmbio.gov.br:icmbio.parnaso.occurrence:MA63847 | &nbsp; &nbsp; null | 2c94f101-2fec-4aba-93a0-05d50f529300</div>
<div>&nbsp;dr0|urn:lsid:icmbio.gov.br:icmbio.parnaso.occurrence:MA464300 | &nbsp; &nbsp; null | 0ac772ed-8e02-444d-8433-a80aa9771f25</div>
<div>&nbsp; dr0|urn:lsid:icmbio.gov.br:icmbio.parnaso.occurrence:MA63772 | &nbsp; &nbsp; null | 2ce8275c-7d36-4e9d-a15f-4e3daf6bfde9</div>
<div>&nbsp; dr0|urn:lsid:icmbio.gov.br:icmbio.parnaso.occurrence:MA16756 | &nbsp; &nbsp; null | 253b2511-6a09-493a-9d05-2f2573f9fbd1</div>
<div>&nbsp;dr0|urn:lsid:icmbio.gov.br:icmbio.parnaso.occurrence:MA133940 | &nbsp; &nbsp; null | 368a1412-7350-46b5-b389-07125dd28a33</div>
<div>&nbsp; dr0|urn:lsid:icmbio.gov.br:icmbio.parnaso.occurrence:MA41315 | &nbsp; &nbsp; null | ead8efa0-2216-427b-bfaa-595a49603a09</div>
<div>&nbsp;dr0|urn:lsid:icmbio.gov.br:icmbio.parnaso.occurrence:MA198039 | &nbsp; &nbsp; null | e7f101cd-243d-479a-98b1-043adae19cb7</div>
<div>&nbsp;dr0|urn:lsid:icmbio.gov.br:icmbio.parnaso.occurrence:MA133942 | &nbsp; &nbsp; null | 704cf8c0-9c10-4e1b-93d1-8a5a52e62126</div>
<div>&nbsp; &nbsp;dr0|urn:lsid:icmbio.gov.br:icmbio.parnaso.occurrence:MA2524 | &nbsp; &nbsp; null | 1c287699-75dd-4ac6-80cc-314151277366</div>
</div>
<div><br>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">2014-06-25 2:32 GMT-03:00 <span dir="ltr">&lt;<a href="mailto:David.Martin@csiro.au" target="_blank">David.Martin@csiro.au</a>&gt;</span>:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex; border-left-width:1px; border-left-color:rgb(204,204,204); border-left-style:solid; padding-left:1ex">
<div>
<div style="direction:ltr; font-family:Tahoma; color:rgb(0,0,0); font-size:10pt">
I thought I'd just post the following shell transcript to the list in case its of use to others.&nbsp;
<div>The cassandra-cli tool is part of the cassandra distribution.</div>
<div>To view the data in cassandra using the cassandra-cli tool:
<div><br>
</div>
<div><span style="font-size:10pt">mar759@ala-ono:~$ cassandra-cli -h localhost -p 9160 -k occ</span></div>
<div>
<p>Column Family assumptions read from /home/mar759/.cassandra/assumptions.json</p>
<p>Connected to: &quot;Biocache&quot; on localhost/9160</p>
<p>Welcome to Cassandra CLI version 1.2.10</p>
<p><br>
</p>
<p>Type 'help;' or '?' for help.</p>
<p>Type 'quit;' or 'exit;' to quit.</p>
<p><br>
</p>
<p>[default@occ] list occ limit 1;</p>
<p>Using default cell limit of 100</p>
<p>-------------------</p>
<p>RowKey: dr107|43704421</p>
<p>=&gt; (name=<a href="http://attr.qa" target="_blank">attr.qa</a>, value=[], timestamp=1397043413407000)</p>
<p>=&gt; (name=basisOfRecord, value=UNKNOWN, timestamp=1397043412777000)</p>
<p>=&gt; (name=<a href="http://bor.qa" target="_blank">bor.qa</a>, value=[20002], timestamp=1397043413407000)</p>
<p>=&gt; (name=catalogNumber, value=1, timestamp=1397043412777000)</p>
<p>=&gt; (name=<a href="http://class.qa" target="_blank">class.qa</a>, value=[10008,10005], timestamp=1397043413407</p>
<p>.....</p>
</div>
<div><br>
</div>
<div><br>
<div style="font-family:'Times New Roman'; color:rgb(0,0,0); font-size:16px">
<hr>
<div style="direction:ltr"><font face="Tahoma" color="#000000"><b>From:</b> <a href="mailto:ala-portal-bounces@lists.gbif.org" target="_blank">
ala-portal-bounces@lists.gbif.org</a> [<a href="mailto:ala-portal-bounces@lists.gbif.org" target="_blank">ala-portal-bounces@lists.gbif.org</a>] on behalf of David.Martin@csiro.au [David.Martin@csiro.au]<br>
<b>Sent:</b> 25 June 2014 15:24<br>
<b>To:</b> <a href="mailto:daniel.lins@gmail.com" target="_blank">daniel.lins@gmail.com</a>;
<a href="mailto:ala-portal@lists.gbif.org" target="_blank">ala-portal@lists.gbif.org</a>;
<a href="mailto:pedro.correa@usp.br" target="_blank">pedro.correa@usp.br</a><br>
<b>Subject:</b> [ExternalEmail] Re: [Ala-portal] Using Biocache-Store and Apache Cassandra on different servers<br>
</font><br>
</div>
<div>
<div>
<div></div>
<div>
<div style="direction:ltr; font-family:Tahoma; color:rgb(0,0,0); font-size:10pt">
<div>Thanks Daniel.</div>
<div><br>
</div>
How did you load the data ?
<div><span style="font-size:10pt">Also can you see the records using the cassandra-cli tool ?</span></div>
<div><br>
</div>
<div>Dave</div>
<div><br>
</div>
<div><br>
<div style="font-family:'Times New Roman'; color:rgb(0,0,0); font-size:16px">
<hr>
<div style="direction:ltr"><font face="Tahoma" color="#000000"><b>From:</b> Daniel Lins [<a href="mailto:daniel.lins@gmail.com" target="_blank">daniel.lins@gmail.com</a>]<br>
<b>Sent:</b> 25 June 2014 15:21<br>
<b>To:</b> Martin, Dave (CES, Black Mountain); <a href="mailto:ala-portal@lists.gbif.org" target="_blank">
ala-portal@lists.gbif.org</a>; Pedro Corrêa<br>
<b>Subject:</b> Using Biocache-Store and Apache Cassandra on different servers<br>
</font><br>
</div>
<div></div>
<div>
<div dir="ltr">Hi,
<div><br>
</div>
<div>
<div>We configured the ALA applications on different Servers <span>of</span> the database Server. However, we are having problems running the biocache-store.</div>
<div><br>
</div>
<div>I changed the biocache configuration file (/data/biocache/config/biocache-config.properties) and the Cassandra configuration (<span>cassandra</span><span>.</span><span>yaml</span>) for enabling remote access.</div>
<div><br>
</div>
<div>(biocache-config.properties)</div>
<div>
<div># Cassandra Config</div>
<div>db=cassandra</div>
<div><b><span>cassandra</span><span>.</span>hosts=192<span>.</span>168.15.199</b><br>
</div>
<div><span>cassandra</span><span>.</span>port=9160</div>
<div><span>cassandra</span><span>.</span>pool=biocache-store-pool</div>
<div><span>cassandra</span><span>.</span>keyspace=occ</div>
<div><span>cassandra</span><span>.</span>max<span>.</span>connections=-1</div>
<div><span>cassandra</span><span>.</span>max<span>.</span>retries=6</div>
<div><span><span>thrift</span></span><span><span>.</span></span>operation<span><span>.</span></span>timeout=8000</div>
</div>
<div><br>
</div>
<div>(<span>cassandra</span><span>.</span><span>yaml</span>)</div>
<div><b>listen_address: 192.168.15.199<br>
</b></div>
<div><b>rpc_address: 192.168.15.199<br>
</b></div>
<div>
<div><b>rpc_port: 9160</b></div>
</div>
<div>...</div>
<div><br>
</div>
<div><b>Running the Biocache-store in the server 192.168.15.132</b><br>
</div>
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>
<div style="font-family:arial,sans-serif; font-size:13px">
<div>biocache&gt; process dr0</div>
<div>Processing dr0 incremental=false</div>
<div>2014-06-25 00:17:20,228 INFO<span> :</span> [Consumer] - <span>Initialising</span> thread: 0</div>
<div>2014-06-25 00:17:20,270 INFO<span> :</span> [Consumer] - <span>Initialising</span> thread: 1</div>
<div>2014-06-25 00:17:20,271 INFO<span> :</span> [Consumer] - <span>Initialising</span> thread: 2</div>
<div>2014-06-25 00:17:20,274 INFO<span> :</span> [Consumer] - <span>Initialising</span> thread: 3</div>
<div>2014-06-25 00:17:20,275 INFO<span> :</span> [ProcessWithActors] - Starting with dr0|
<span>endingwith</span> dr0|~</div>
<div>2014-06-25 00:17:20,275 INFO<span> :</span> [ProcessWithActors] - <span>Initialised</span> actors...</div>
<div>2014-06-25 00:17:20,274 INFO<span> :</span> [Consumer] - In thread: 0</div>
<div>2014-06-25 00:17:20,274 INFO<span> :</span> [Consumer] - In thread: 1</div>
<div>2014-06-25 00:17:20,281 INFO<span> :</span> [Consumer] - In thread: 2</div>
<div>2014-06-25 00:17:20,293 INFO<span> :</span> [Consumer] - In thread: 3</div>
<div>2014-06-25 00:17:20,326 INFO<span> :</span> [ProcessWithActors] - Last row key processed:&nbsp;</div>
<div>2014-06-25 00:17:20,327 INFO<span> :</span> [ProcessWithActors] - Finished.</div>
<div>2014-06-25 00:17:20,333 INFO<span> :</span> [Consumer] - Killing (Actor<span>.</span>act) thread: 0</div>
<div>2014-06-25 00:17:20,333 INFO<span> :</span> [Consumer] - Killing (Actor<span>.</span>act) thread: 3</div>
<div>2014-06-25 00:17:20,333 INFO<span> :</span> [Consumer] - Killing (Actor<span>.</span>act) thread: 2</div>
<div>2014-06-25 00:17:20,333 INFO<span> :</span> [Consumer] - Killing (Actor<span>.</span>act) thread: 1</div>
<div><br>
</div>
</div>
</div>
<div style="font-family:arial,sans-serif; font-size:13px">biocache&gt; index dr0<br>
</div>
<div style="font-family:arial,sans-serif; font-size:13px">
<div>2014-06-25 00:17:36,848 INFO<span> :</span> [<span>IndexRecords</span>] - Starting to index dr0| until dr0|~</div>
<div>2014-06-25 00:17:36,858 INFO<span> :</span> [<span>IndexRecords</span>] - Total indexing time 0.005 seconds</div>
<div>2014-06-25 00:17:36,858 INFO<span> :</span> [SolrIndexDAO] - Initialising the
<span>solr</span> server <a href="http://192.168.15.132:8080/solr" target="_blank">
http://192.168.15.132:8080/solr</a> null null</div>
<div>2014-06-25 00:17:36,859 INFO<span> :</span> [SolrIndexDAO] - <span>Initialising</span> connection to SOLR server.....</div>
<div>2014-06-25 00:17:37,764 INFO<span> :</span> [SolrIndexDAO] - <span>Initialising</span> connection to SOLR server - done.</div>
<div>2014-06-25 00:17:38,040 INFO<span> :</span> [SolrIndexDAO] - &gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt; Document count of index: 0</div>
<div>2014-06-25 00:17:38,041 INFO<span> :</span> [SolrIndexDAO] - <span>Finalise</span> finished.</div>
<div><br>
</div>
</div>
<div>** The delete_resource method also didn't work and I need to delete the occurrence table using the truncate command.<br>
</div>
<div><br>
</div>
<div>Does anyone know how to solve this issue?<br>
</div>
<div><br>
</div>
<div>Thanks!!</div>
<div><br>
</div>
<div>Regards,</div>
<div><br>
</div>
<div><span style="color:rgb(136,136,136); font-family:arial,sans-serif; font-size:13px">--&nbsp;</span><br style="color:rgb(136,136,136); font-family:arial,sans-serif; font-size:13px">
<div style="color:rgb(136,136,136); font-family:arial,sans-serif; font-size:13px">
<div class="gmail_extra">Daniel Lins da Silva</div>
<div class="gmail_extra">(Mobile)&nbsp;<a href="tel:55%2011%2096144-4050" value="&#43;5511961444050" target="_blank">55 11 96144-4050</a></div>
<div>
<div class="gmail_extra"><font color="#000000">Research Center&nbsp;<span>on</span>&nbsp;Biodiversity and Computing (Biocomp)</font></div>
<div class="gmail_extra"><font color="#000000">University of Sao Paulo, Brazil</font></div>
</div>
<div class="gmail_extra"><a href="mailto:daniellins@usp.br" target="_blank">daniellins@usp.br</a></div>
<div class="gmail_extra"><a href="mailto:daniel.lins@gmail.com" target="_blank">daniel.lins@gmail.com</a></div>
<div><br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
<div>Daniel Lins da Silva<br>
(Cel) 11 6144-4050</div>
<div><a href="mailto:daniel.lins@gmail.com" target="_blank">daniel.lins@gmail.com</a><br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
<div>Daniel Lins da Silva<br>
(Cel) 11 6144-4050</div>
<div><a href="mailto:daniel.lins@gmail.com" target="_blank">daniel.lins@gmail.com</a><br>
</div>
</div>
</div>
</div>
</div>
</body>
</html>