search

AtlasOfLivingAustralia / image-service

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

ERROR: relation "image_metadata_seq" does not exist #75

Closed sadeghim closed 5 years ago

sadeghim commented 5 years ago

see lots of this error in the image-service while loading inat, while nothing indicative on biocache-store logs:


2019-09-09 14:10:42.179  WARN --- [eduler_Worker-7] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: 42P01
2019-09-09 14:10:42.180 ERROR --- [eduler_Worker-7] o.h.engine.jdbc.spi.SqlExceptionHelper   : ERROR: relation "image_metadata_seq" does not exist
  Position: 95
2019-09-09 14:10:42.477  WARN --- [eduler_Worker-7] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: 42P01
2019-09-09 14:10:42.477 ERROR --- [eduler_Worker-7] o.h.engine.jdbc.spi.SqlExceptionHelper   : ERROR: relation "image_metadata_seq" does not exist
  Position: 95
2019-09-09 14:10:42.746  WARN --- [eduler_Worker-7] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: 42P01
2019-09-09 14:10:42.746 ERROR --- [eduler_Worker-7] o.h.engine.jdbc.spi.SqlExceptionHelper   : ERROR: relation "image_metadata_seq" does not exist
  Position: 95
2019-09-09 14:10:42.922  WARN --- [eduler_Worker-7] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: 42P01
2019-09-09 14:10:42.922 ERROR --- [eduler_Worker-7] o.h.engine.jdbc.spi.SqlExceptionHelper   : ERROR: relation "image_metadata_seq" does not exist
  Position: 95
2019-09-09 14:10:42.993  WARN --- [eduler_Worker-5] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: 42P01
2019-09-09 14:10:42.993 ERROR --- [eduler_Worker-5] o.h.engine.jdbc.spi.SqlExceptionHelper   : ERROR: relation "image_metadata_seq" does not exist
  Position: 95
2019-09-09 14:10:43.258  WARN --- [eduler_Worker-7] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: 42P01
2019-09-09 14:10:43.258 ERROR --- [eduler_Worker-7] o.h.engine.jdbc.spi.SqlExceptionHelper   : ERROR: relation "image_metadata_seq" does not exist
  Position: 95
djtfmartin commented 5 years ago

Ive added the sequence. Something that was missed in the migration. Its automatically created by grails for new installations and blank DBs with

dataSource.dbCreate = update