search

AtlasOfLivingAustralia / image-service

Image repository and tiling services
https://images.ala.org.au
0 stars 17 forks source link

Update postgresql driver dependency to prevent org.hibernate.exception.SQLGrammarException #47

Closed vjrj closed 5 years ago

vjrj commented 5 years ago

We get this SQL grammar exception:

2019-02-25 12:51:00,516 [imagenes.gbif.es-startStop-1] ERROR util.JDBCExceptionReporter  - ERROR: column am.amcanorder does not exist
  Position: 427
2019-02-25 12:51:00,519 [imagenes.gbif.es-startStop-1] ERROR hbm2ddl.SchemaUpdate  - could not complete schema update
org.hibernate.exception.SQLGrammarException: could not get table metadata: album
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        at java.util.concurrent.FutureTask.run(FutureTask.java:266)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at java.lang.Thread.run(Thread.java:748)
Caused by: org.postgresql.util.PSQLException: ERROR: column am.amcanorder does not exist
  Position: 427
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:406)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:286)
        at org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getIndexInfo(AbstractJdbc2DatabaseMetaData.java:4234)

This is a ubuntu xenial server with postgresql-9.6.

It seems that the posgresql driver should be updated.