positions api keeps failing

Bigmachini Enterprises5 years ago

Greetings, I have been having an issue with the positions api of late, it works fine for a while then it stops responding. All the other api are working, the systems is still running, but on trying to access the position api I don't get a response. any ideas what this can be about?

this is what the position api logs: Failed to load resource: the server responded with a status of 400 (Bad Request)

Regards

Bigmachini Enterprises5 years ago

When I try to restart the server i get this from logs:

2020-05-08 09:05:43  INFO: HikariPool-1 - Start completed.
2020-05-08 09:05:44  INFO: Clearing database change log checksums
2020-05-08 09:05:44 ERROR: Main method error - ERROR: prepared statement "S_1" already exists - PSQLException (... < DataManager:310 < *:90 < Context:292 < Main:110 < ...)
2020-05-08 09:05:50  INFO: HikariPool-1 - Starting...
2020-05-08 09:05:50  INFO: HikariPool-1 - Start completed.
2020-05-08 09:05:51  INFO: Clearing database change log checksums
2020-05-08 09:05:51  INFO: SELECT COUNT(*) FROM public.databasechangeloglock
2020-05-08 09:05:51  INFO: SELECT COUNT(*) FROM public.databasechangeloglock
2020-05-08 09:05:51  INFO: SELECT LOCKED FROM public.databasechangeloglock WHERE ID=1
2020-05-08 09:05:51 ERROR: Main method error - ERROR: prepared statement "S_2" already exists - PSQLException (... < DataManager:310 < *:90 < Context:292 < Main:110 < ...)
2020-05-08 09:05:54  INFO: HikariPool-1 - Starting...
2020-05-08 09:05:54  INFO: HikariPool-1 - Start completed.
2020-05-08 09:05:55  INFO: Clearing database change log checksums
2020-05-08 09:05:55 ERROR: Main method error - ERROR: prepared statement "S_1" already exists - PSQLException (... < DataManager:310 < *:90 < Context:292 < Main:110 < ...)
2020-05-08 09:05:57  INFO: HikariPool-1 - Starting...
2020-05-08 09:05:57  INFO: HikariPool-1 - Start completed.
2020-05-08 09:05:58  INFO: Clearing database change log checksums
2020-05-08 09:05:58  INFO: SELECT COUNT(*) FROM public.databasechangeloglock
2020-05-08 09:05:58  INFO: SELECT COUNT(*) FROM public.databasechangeloglock
2020-05-08 09:05:58  INFO: SELECT LOCKED FROM public.databasechangeloglock WHERE ID=1
2020-05-08 09:05:58 ERROR: Main method error - ERROR: prepared statement "S_2" already exists - PSQLException (... < DataManager:310 < *:90 < Context:292 < Main:110 < ...)
2020-05-08 09:06:01  INFO: HikariPool-1 - Starting...
2020-05-08 09:06:01  INFO: HikariPool-1 - Start completed.
2020-05-08 09:06:02  INFO: Clearing database change log checksums
2020-05-08 09:06:02 ERROR: Main method error - ERROR: prepared statement "S_1" already exists - PSQLException (... < DataManager:310 < *:90 < Context:292 < Main:110 < ...)

I have to restart the database server a couple of times before this picks up and it starts

Anton Tananaev5 years ago

Looks like you have some customization. What is S_1 and S_2?