Spring Boot ShedLock "relation "shedlock" does not exist"

Question

I added ShedLock to my project to prevent working of scheduled job more than one time. I configured it like below but I'm getting

"org.postgresql.util.PSQLException: ERROR: relation "shedlock" does not exist" error.

This is lockProviderBean:

@Bean
    public LockProvider lockProvider(DataSource dataSource) {
        return new JdbcTemplateLockProvider(
                JdbcTemplateLockProvider.Configuration.builder()
                        .withJdbcTemplate(new JdbcTemplate(dataSource))
                        .usingDbTime() 
                        .build()
        );
    }

This is scheduled job:

@Scheduled(cron = "${cronProperty:0 00 23 * * *}")
@SchedulerLock(name = "schedulerLockName")
public void scheduledJob() {
       ..............
}

I added these notations to my class which contains schduledJob method:

@EnableScheduling
@Component
@Configuration
@EnableSchedulerLock(defaultLockAtMostFor = "2m")

I'm using Spring Data to do database operations and using these properties:

spring.datasource.url = jdbc:postgresql://ip:port/databaseName?currentSchema=schemeName
spring.datasource.driver-class-name = org.postgresql.Driver
spring.jpa.database = postgresql
spring.datasource.platform = postgresql
spring.datasource.hikari.maximum-pool-size=5
spring.jpa.database-platform=org.hibernate.dialect.PostgreSQLDialect
spring.datasource.username = username
spring.datasource.password = password

Create shedlock table manually. Details https://github.com/lukas-krecan/ShedLock#jdbctemplate — fkrsc, Sep 29 '21 at 18:06

score 3 · Answer 1 · answered Sep 30 '21 at 18:14

3

You have to create the table as described in the documentation.

answered Sep 30 '21 at 18:14

Lukas

13,606
9
31
40

I have the exact same problem when I perform a clean with Flyway, which deletes everything from database. When I restart all my containers/volumes and also the API, it fails to works and keeps telling me the relation does not exist. How is that even possible ? There must be some state left somewhere. I'm using the dependency with gradle that adds it automatically. – Radioreve Jan 19 '22 at 16:49

score 3 · Answer 2 · answered Mar 24 '22 at 11:06

3

maybe this is what you are missing:

If you need to specify a schema, you can set it in the table name using the usual dot notation new JdbcTemplateLockProvider(datasource, "my_schema.shedlock")

answered Mar 24 '22 at 11:06

Yoav A

555
1
4
16

score 0 · Answer 3 · answered May 23 '22 at 04:14

I face this problem too even though shedlock table has been created.

Workarounds for this is by

Setting pg's user default schema using ALTER ROLE YourPgUser SET search_path TO ... , or
Specifing shedlock schema on LockProvider bean

    @Bean
    public LockProvider getLockProvider(@Autowired JdbcTemplate jdbcTemplate) {
        jdbcTemplate.execute("SET search_path TO domaindbschema");
        return new JdbcTemplateLockProvider(jdbcTemplate);
    }

or another style

    @Bean
    public LockProvider getLockProvider(@Autowired JdbcTemplate jdbcTemplate) {
        return new JdbcTemplateLockProvider(jdbcTemplate, "domaindbschema.shedlock");
    }

score 0 · Answer 4 · answered Mar 03 '23 at 19:06

0

If This is in the server, you need to modify the privileges to the table. contact to BD team

answered Mar 03 '23 at 19:06

Gabriel Cortez

3
2

As it’s currently written, your answer is unclear. Please [edit] to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Mar 15 '23 at 03:50

Spring Boot ShedLock "relation "shedlock" does not exist"

4 Answers4