bekk/db-scheduler-ui

Fetching history is not working

ipodobin opened this issue · 5 comments

ipodobin commented

Project setup :
Spring Boot 2.6.3
Java corretto-17 (17.0.9)
PostgreSQL 15.2

Issue:
When I am trying to get history of executions I am getting this error:
detailed message:
PreparedStatementCallback; bad SQL grammar [select * from scheduled_execution_logs where time_started >= ? and time_finished <= ? order by time_finished desc limit 500]
cause:
org.postgresql.util.PSQLException: Can't infer the SQL type to use for an instance of java.time.Instant. Use setObject() with an explicit Types value to specify the type to use.
I am getting these time range parameters as default:
image
but I get the same behaviour with these values:
image

When I try to query database myself I am getting proper results:
image
image

ipodobin commented

I will try with required Spring Boot 2.7... ;)

ipodobin commented

With Spring boot 2.7.16 issue is still there.

geirsagberg commented

Which version of db-scheduler-ui are you using?

ipodobin commented

db-scheduler-ui-starter:1.0.1

ipodobin commented

Updated to 3.10 and it seems that it works. There is still issue with serialising task data with LocalDate (but only for TaskModel not for LogModel, but I've seen that there is a fix for that).