Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

2021-04-28 06:36:17,500 ERROR HikariPool-605 - Exception during pool initialization. HikariPool preview-pool-13-thread-4 com.sas.rio.MVASQLExceptionUnsupported: Commit/Rollback not supported. at com.sas.rio.MVAConnection.setAutoCommit(MVAConnection.java:557) at com.zaxxer.hikari.pool.PoolBase.setupConnection(PoolBase.java:418) at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:374) at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:198) at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:467) at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:541) at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115) at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:81) at com.streamsets.pipeline.lib.jdbc.JdbcUtil.createDataSourceForRead(JdbcUtil.java:1049) at com.streamsets.pipeline.stage.origin.jdbc.AbstractTableJdbcSource.checkConnectionAndBootstrap(AbstractTableJdbcSource.java:189) at com.streamsets.pipeline.stage.origin.jdbc.table.TableJdbcSource.checkConnectionAndBootstrap(TableJdbcSource.java:72) at com.streamsets.pipeline.stage.origin.jdbc.AbstractTableJdbcSource.init(AbstractTableJdbcSource.java:171) at com.streamsets.pipeline.api.base.BaseStage.init(BaseStage.java:48) at com.streamsets.pipeline.api.base.configurablestage.DStage.init(DStage.java:36) at com.streamsets.datacollector.runner.StageRuntime.lambda$init$0(StageRuntime.java:220) at com.streamsets.datacollector.util.LambdaUtil.withClassLoaderInternal(LambdaUtil.java:148) at com.streamsets.datacollector.util.LambdaUtil.withClassLoader(LambdaUtil.java:44) at com.streamsets.datacollector.runner.StageRuntime.init(StageRuntime.java:218) at com.streamsets.datacollector.runner.StagePipe.init(StagePipe.java:109) at com.streamsets.datacollector.runner.StagePipe.init(StagePipe.java:44) at com.streamsets.datacollector.runner.Pipeline.initPipe(Pipeline.java:411) at com.streamsets.datacollector.runner.Pipeline.init(Pipeline.java:314) at com.streamsets.datacollector.runner.Pipeline.validateConfigs(Pipeline.java:221) at com.streamsets.datacollector.runner.preview.PreviewPipeline.validateConfigs(PreviewPipeline.java:60) at com.streamsets.datacollector.execution.preview.sync.SyncPreviewer.validateConfigs(SyncPreviewer.java:167) at com.streamsets.datacollector.execution.preview.async.AsyncPreviewer.lambda$validateConfigs$0(AsyncPreviewer.java:81) at com.streamsets.pipeline.lib.executor.SafeScheduledExecutorService$SafeCallable.lambda$call$0(SafeScheduledExecutorService.java:226) at com.streamsets.datacollector.security.GroupsInScope.execute(GroupsInScope.java:34) at com.streamsets.pipeline.lib.executor.SafeScheduledExecutorService$SafeCallable.call(SafeScheduledExecutorService.java:222) at com.streamsets.pipeline.lib.executor.SafeScheduledExecutorService$SafeCallable.lambda$call$0(SafeScheduledExecutorService.java:226) at com.streamsets.datacollector.security.GroupsInScope.execute(GroupsInScope.java:34) at com.streamsets.pipeline.lib.executor.SafeScheduledExecutorService$SafeCallable.call(SafeScheduledExecutorService.java:222) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) at com.streamsets.datacollector.metrics.MetricSafeScheduledExecutorService$MetricsTask.run(MetricSafeScheduledExecutorService.java:100) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) 2021-04-28 06:36:17,500 ERROR Failed to initialize connection pool: {} JdbcUtil * preview-pool-13-thread-4 com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: Commit/Rollback not supported. at com.zaxxer.hikari.pool.HikariPool.throwPoolInitializationException(HikariPool.java:576) at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:555) at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115) at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:81) at com.streamsets.pipeline.lib.jdbc.JdbcUtil.createDataSourceForRead(JdbcUtil.java:1049) at com.streamsets.pipeline.stage.origin.jdbc.AbstractTableJdbcSource.checkConnectionAndBootstrap(AbstractTableJdbcSource.java:189) at com.streamsets.pipeline.stage.origin.jdbc.table.TableJdbcSource.checkConnectionAndBootstrap(TableJdbcSource.java:72) at com.streamsets.pipeline.stage.origin.jdbc.AbstractTableJdbcSource.init(AbstractTableJdbcSource.java:171) at com.streamsets.pipeline.api.base.BaseStage.init(BaseStage.java:48) at com.streamsets.pipeline.api.base.configurablestage.DStage.init(DStage.java:36) at com.streamsets.datacollector.runner.StageRuntime.lambda$init$0(StageRuntime.java:220) at com.streamsets.datacollector.util.LambdaUtil.withClassLoaderInternal(LambdaUtil.java:148) at com.streamsets.datacollector.util.LambdaUtil.withClassLoader(LambdaUtil.java:44) at com.streamsets.datacollector.runner.StageRuntime.init(StageRuntime.java:218) at com.streamsets.datacollector.runner.StagePipe.init(StagePipe.java:109) at com.streamsets.datacollector.runner.StagePipe.init(StagePipe.java:44) at com.streamsets.datacollector.runner.Pipeline.initPipe(Pipeline.java:411) at com.streamsets.datacollector.runner.Pipeline.init(Pipeline.java:314) at com.streamsets.datacollector.runner.Pipeline.validateConfigs(Pipeline.java:221) at com.streamsets.datacollector.runner.preview.PreviewPipeline.validateConfigs(PreviewPipeline.java:60) at com.streamsets.datacollector.execution.preview.sync.SyncPreviewer.validateConfigs(SyncPreviewer.java:167) at com.streamsets.datacollector.execution.preview.async.AsyncPreviewer.lambda$validateConfigs$0(AsyncPreviewer.java:81) at com.streamsets.pipeline.lib.executor.SafeScheduledExecutorService$SafeCallable.lambda$call$0(SafeScheduledExecutorService.java:226) at com.streamsets.datacollector.security.GroupsInScope.execute(GroupsInScope.java:34) at com.streamsets.pipeline.lib.executor.SafeScheduledExecutorService$SafeCallable.call(SafeScheduledExecutorService.java:222) at com.streamsets.pipeline.lib.executor.SafeScheduledExecutorService$SafeCallable.lambda$call$0(SafeScheduledExecutorService.java:226) at com.streamsets.datacollector.security.GroupsInScope.execute(GroupsInScope.java:34) at com.streamsets.pipeline.lib.executor.SafeScheduledExecutorService$SafeCallable.call(SafeScheduledExecutorService.java:222) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) at com.streamsets.datacollector.metrics.MetricSafeScheduledExecutorService$MetricsTask.run(MetricSafeScheduledExecutorService.java:100) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: com.sas.rio.MVASQLExceptionUnsupported: Commit/Rollback not supported. at com.sas.rio.MVAConnection.setAutoCommit(MVAConnection.java:557) at com.zaxxer.hikari.pool.PoolBase.setupConnection(PoolBase.java:418) at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:374) at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:198) at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:467) at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:541) ... 33 more