java - 为什么通过注释设置超时的 ChainedTransactionManager 不起作用?弹簧靴
问题描述
应用:
- Spring Boot 2.2.13.RELEASE 版本
- postgresql 版本 42.2.10
- 石英版本 2.3.2
- 石英作业版本 2.3.2
我已经实现了一个调用 @Service bean 中实现的方法的工作石英。进入这个方法有与两个数据库(Oracle 和 PostgreSql)的交互。每个 Db 都使用 Hikari 连接池进行初始化
配置 bean 中的 Postgresql DB:
@Bean(value="sreDataSource")
public DataSource dataSource() {
HikariConfig hikariConfig = new HikariConfig();
hikariConfig.setDriverClassName(driverClassName);
hikariConfig.setJdbcUrl(datasourceUrl);
hikariConfig.setUsername(datasourceUsername);
hikariConfig.setPassword(datasourcePassword);
hikariConfig.setConnectionInitSql("set time zone 'UTC'");
hikariConfig.setMaximumPoolSize(maxPoolSize);
hikariConfig.setConnectionTestQuery("SELECT 1");
hikariConfig.setPoolName("springHikariCP");
return new HikariDataSource(hikariConfig);
}
/**
* @return {@link JdbcTemplate}
*/
@Bean(value="sreJdbcTemplate")
public JdbcTemplate jdbcTemplate() {
JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource());
jdbcTemplate.setFetchSize(Integer.parseInt(fetchSize));
jdbcTemplate.setQueryTimeout(60);
return jdbcTemplate;
}
/**
* Create the namedJdbcTemplate bean for the SRE database
* @return {@link NamedParameterJdbcTemplate}
*/
@Bean(value="sreNamedParameterJdbcTemplate")
public NamedParameterJdbcTemplate namedParameterJdbcTemplate() {
return new NamedParameterJdbcTemplate(jdbcTemplate());
}
/**
* @param dataSource
* @return {@link PlatformTransactionManager}
*/
@Bean(value="sreTransactionManager")
public PlatformTransactionManager transactionManager(@Qualifier("sreDataSource") DataSource dataSource) {
return new DataSourceTransactionManager(dataSource);
}
/**
* @param sreTransactionManager
* @param assetTransactionManager
* @return {@link ChainedTransactionManager}
*/
@Bean(value="chainedTransactionManager")
public ChainedTransactionManager transactionManager(@Qualifier("sreTransactionManager") PlatformTransactionManager sreTransactionManager,
@Qualifier("assetTransactionManager") PlatformTransactionManager assetTransactionManager) {
return new ChainedTransactionManager(sreTransactionManager, assetTransactionManager);
}
配置 bean 中的 Oracle DB:
/**
* Datasource
* @return Datasource
*/
@Bean(value="assetDataSource")
public DataSource dataSource() {
HikariConfig hikariConfig = new HikariConfig();
hikariConfig.setDriverClassName(driverClassName);
hikariConfig.setJdbcUrl(datasourceUrl);
hikariConfig.setUsername(datasourceUsername);
hikariConfig.setPassword(datasourcePassword);
hikariConfig.addDataSourceProperty("oracle.jdbc.timezoneAsRegion", "false");
hikariConfig.setMaximumPoolSize(maxPoolSize);
hikariConfig.setConnectionTestQuery("SELECT 1 from dual");
hikariConfig.setPoolName("springHikariAssetCp");
return new HikariDataSource(hikariConfig);
}
/**
* JDBCTemplate
* @return JDBCTemplate
*/
@Bean(value="assetJdbcTemplate")
public JdbcTemplate jdbcTemplate() {
JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource());
jdbcTemplate.setFetchSize(Integer.parseInt(fetchSize));
jdbcTemplate.setQueryTimeout(60);
return jdbcTemplate;
}
/**
* Create the namedJdbcTemplate bean for the RMD database
* @return NamedParameterJdbcTemplate
*/
@Bean(value="assetNamedParameterJdbcTemplate")
public NamedParameterJdbcTemplate namedParameterJdbcTemplate() {
return new NamedParameterJdbcTemplate(jdbcTemplate());
}
/**
* Create transaction manager
* @param dataSource Datasource
* @return transaction manager
*/
@Bean(value="assetTransactionManager")
public PlatformTransactionManager transactionManager(@Qualifier("assetDataSource") DataSource dataSource) {
return new DataSourceTransactionManager(dataSource);
}
服务 bean 从集群中的作业石英中调用。服务 bean 定义如下:
/**
* @author sgalgani
*
*/
@Service("processSreService")
@Transactional("chainedTransactionManager")
public class ProcessSreServiceImpl implements ProcessSreService {
private static final Logger LOGGER = LogManager.getLogger(ProcessSreServiceImpl.class);
@Autowired
@Qualifier("historianService")
private HistorianService historianService;
@Autowired
@Qualifier("sreEvolutionService")
private SreEvolutionService sreEvolutionService;
@Autowired
@Qualifier("assetService")
private AssetService assetService;
@Autowired
@Qualifier("configService")
private ConfigService configService;
@Autowired
@Qualifier("engineSupportService")
private EngineSupportService engineSupportService;
@Autowired
@Qualifier("tagAvailabilityService")
private TagAvailabilityService tagAvailabilityService;
@Autowired
@Qualifier("engineTransformService")
private EngineTransformService engineTransformService;
@Autowired
@Qualifier("quarantineService")
private QuarantineService quarantineService;
@Autowired
@Qualifier("simpleRuleEventService")
private SimpleRuleEventService simpleRuleEventService;
@Value("${save.oracle.temporary.results}")
private boolean saveOracleTemporaryResults;
@Value("${enable.save.local.db.alerts}")
private boolean enableSaveLocalDbAlerts;
@Value("${simple.rule.event.service.enable}")
private boolean simpleRuleEventServiceEnable;
@SuppressWarnings("javadoc")
@Override
@Transactional(value = "chainedTransactionManager", rollbackFor = Exception.class, timeout = 120)
public void processSre(Sre sre, List<TagLastTimestamp> tagsLastTimestamp, Metric metrics) throws Exception {
LOGGER.info("[processSre] for JobId : {} and lineup: {} ",sre.getId(), sre.getLineupId() );
在 Amazon RDS postgresql 上的故障转移数据库操作(丢失与数据库的连接)后,我会在 120 秒后出现事务超时异常,但超时不起作用,为什么?
解决方案
我通过设置属性解决了我的问题,如以下文章中所述:
我的代码是添加配置HikariCP:
hikariConfig.addDataSourceProperty("socketTimeout", "120");
socketTimeout 为 120 秒,因此无论如何该属性都会在超时后引发以下异常:
Caused by: java.net.SocketTimeoutException: Read timed out at java.net.SocketInputStream.socketRead0(Native Method) ~[?:?]
at java.net.SocketInputStream.socketRead(SocketInputStream.java:115) ~[?:?]
at java.net.SocketInputStream.read(SocketInputStream.java:168) ~[?:?]
at java.net.SocketInputStream.read(SocketInputStream.java:140) ~[?:?]
at sun.security.ssl.SSLSocketInputRecord.read(SSLSocketInputRecord.java:448) ~[?:?]
at sun.security.ssl.SSLSocketInputRecord.bytesInCompletePacket(SSLSocketInputRecord.java:68) ~[?:?]
at sun.security.ssl.SSLSocketImpl.readApplicationRecord(SSLSocketImpl.java:1103) ~[?:?]
at sun.security.ssl.SSLSocketImpl$AppInputStream.read(SSLSocketImpl.java:823) ~[?:?]
at org.postgresql.core.VisibleBufferedInputStream.readMore(VisibleBufferedInputStream.java:161) ~[postgresql-42.2.10.jar!/:42.2.10]
at org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:128) ~[postgresql-42.2.10.jar!/:42.2.10]
at org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:113) ~[postgresql-42.2.10.jar!/:42.2.10]
at org.postgresql.core.VisibleBufferedInputStream.read(VisibleBufferedInputStream.java:73) ~[postgresql-42.2.10.jar!/:42.2.10]
at org.postgresql.core.PGStream.receiveChar(PGStream.java:370) ~[postgresql-42.2.10.jar!/:42.2.10]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2015) ~[postgresql-42.2.10.jar!/:42.2.10]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:311) ~[postgresql-42.2.10.jar!/:42.2.10]... 17 more
推荐阅读
- php - 使用for循环循环时如何避免重复?
- c# - 需要帮助对 linux Docker 中的 .NET Core 2.1 API 进行故障排除
- android - android.content.res.Resources$NotFoundException 仅在棉花糖中出错,但在牛轧糖中正常工作
- python - 如果Windows上有两个相同版本的python,如何使用pip安装一个包
- angular - 如何在 Angular 中测试 form.valueChanges?
- javascript - React 组件记录对象,然后在同一对象上记录未定义
- javascript - 在从 Sybase 到 MongoDB 运行 ETL 时使用三元表达式
- insertion-sort - 我们可以写marks[j]=marks[i]; 在 while 循环内而不是标记[i+1]=marks[i];
- angular - 如何配置 Google App Engine yaml 文件以处理 404 错误
- javascript - 使用 JS 更改默认文件名下载?