search

AtlasOfLivingAustralia / ala-install

Ansible playbooks for installing the ALA components
https://www.ala.org.au
Apache License 2.0
26 stars 52 forks source link

ala-demo: specieslist not deployed #184

Open javier-molina opened 6 years ago

javier-molina commented 6 years ago

Running the usual suspect below and specieslist.war is copied to tomcat dir but still it is not expanded

ansible-playbook -i inventories/ala-demo ala-demo-cassandra3-solr6.yml  --become    --ask-become-pass
root@nectar-demo:/var/lib/tomcat7/webapps-living-atlas.org# ls -l
total 644128
drwxr-xr-x  5 tomcat7 tomcat7      4096 Aug 13 11:25 ala-bie
-rw-r--r--  1 root    root     57960220 Aug 13 09:11 ala-bie.war
drwxr-xr-x  5 tomcat7 tomcat7      4096 Aug 13 11:15 ala-hub
-rw-r--r--  1 root    root     74277658 Aug 13 08:58 ala-hub.war
drwxr-xr-x  5 tomcat7 tomcat7      4096 Aug 13 11:25 bie-index
-rw-r--r--  1 root    root     89639454 Aug 13 09:10 bie-index.war
drwxr-xr-x  7 tomcat7 tomcat7      4096 Aug 13 11:13 biocache-service
-rw-r--r--  1 root    root    148147141 Aug 13 08:56 biocache-service.war
drwxr-xr-x 10 tomcat7 tomcat7      4096 Aug 13 11:16 collectory
-rw-r--r--  1 root    root     65029604 Aug 13 08:59 collectory.war
drwxr-xr-x  8 tomcat7 tomcat7      4096 Aug 13 11:41 images
-rw-r--r--  1 root    root     89094569 Aug 13 09:12 images.war
drwxr-xr-x  8 tomcat7 tomcat7      4096 Aug 13 11:20 logger-service
-rw-r--r--  1 root    root     42396952 Aug 13 09:08 logger-service.war
-rw-r--r--  1 root    root     92991986 Aug 13 09:09 specieslists.war
djtfmartin commented 6 years ago

Cant reproduce the not deploying problem. However I do see

Unable to retrieve species list items. Please let us know if this error persists. <br>Error:<br>Hibernate operation: could not extract ResultSet; uncategorized SQLException for SQL [n/a]; SQL state [HY000]; error code [3065]; Expression #1 of ORDER BY clause is not in SELECT list, references column 'specieslists.specieslis0_.item_order' which is not in SELECT list; this is incompatible with DISTINCT; nested exception is java.sql.SQLException: Expression #1 of ORDER BY clause is not in SELECT list, references column 'specieslists.specieslis0_.item_order' which is not in SELECT list; this is incompatible with DISTINCT

when uploading a list.