java - HikariPool-1 - 连接不可用，请求在 30000 毫秒后超时

Question

我在下面的配置 xml 映射中收到连接不可用错误消息。请告诉我我在 beolw 代码中做错了什么，或者这是另一个问题。根据我的调查，这是 HikariCP、Hibernate 和 Spring Batch 的集成问题。

2.0.3
5.1.6
4.0.0. 发布
3.0.0. 发布
3.0.0. 发布
0.5
2.3.2
4.3.5. final

Below Configuration
    @Bean
    public DataSource dataSource() {
        final HikariConfig config = new HikariConfig();
        config.setMaximumPoolSize(1);
        System.out.println("Pool size is "+config.getMaximumPoolSize());
        config.setDriverClassName(environment.getRequiredProperty(PROPERTY_NAME_DATABASE_DRIVER));
        config.setJdbcUrl(environment.getRequiredProperty(PROPERTY_NAME_DATABASE_URL));
        config.setUsername(environment.getRequiredProperty(PROPERTY_NAME_DATABASE_USERNAME));
        config.setPassword(environment.getRequiredProperty(PROPERTY_NAME_DATABASE_PASSWORD));

        final HikariDataSource dataSource = new HikariDataSource(config);
        return dataSource;
    }

错误: -

DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Timeout failure stats (total=1, active=1, idle=0, waiting=0)
2017-01-03T11:10:30.33+0000 [App/0]      OUT PDC::fre-staging/0: 2017-01-03 11:10:30.335 [task-scheduler-6] WARN  o.h.e.jdbc.spi.SqlExceptionHelper - SQL Error: 0, SQLState: null
2017-01-03T11:10:30.33+0000 [App/0]      OUT PDC::fre-staging/0: 2017-01-03 11:10:30.335 [task-scheduler-6] ERROR o.h.e.jdbc.spi.SqlExceptionHelper - HikariPool-1 - Connection is not available, request timed out after 30000ms.
2017-01-03T11:10:30.34+0000 [App/0]      OUT In finally If
2017-01-03T11:10:43.89+0000 [App/0]      OUT PDC::fre-staging/0: 2017-01-03 11:10:43.896 [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Pool stats (total=1, active=1, idle=0, waiting=1)
2017-01-03T11:11:00.34+0000 [App/0]      OUT PDC::fre-staging/0: 2017-01-03 11:11:00.340 [task-scheduler-6] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Timeout failure stats (total=1, active=1, idle=0, waiting=0)
2017-01-03T11:11:00.34+0000 [App/0]      OUT PDC::fre-staging/0: 2017-01-03 11:11:00.341 [task-scheduler-6] WARN  o.h.e.jdbc.spi.SqlExceptionHelper - SQL Error: 0, SQLState: null
2017-01-03T11:11:00.34+0000 [App/0]      OUT PDC::fre-staging/0: 2017-01-03 11:11:00.341 [task-scheduler-6] ERROR o.h.e.jdbc.spi.SqlExceptionHelper - HikariPool-1 - Connection is not available, request timed out after 30000ms.
2017-01-03T11:11:00.35+0000 [App/0]      OUT PDC::fre-staging/0: 2017-01-03 11:11:00.354 [task-scheduler-6] ERROR o.s.batch.core.step.AbstractStep - Encountered an error executing step emisTopupStep in job emisTopupJob
2017-01-03T11:11:00.35+0000 [App/0]      OUT javax.persistence.PersistenceException: org.hibernate.exception.JDBCConnectionException: Could not open connection.

请帮帮我。

Answer 1

您正在使用以下行将池最大大小设置为 1
config.setMaximumPoolSize(1);
我的猜测是那是你的问题。尝试增加它，只是不要过度。默认值为 10，这适用于大多数情况。