linux - Sahi on Jenkins DB 错误 - 无法从底层数据库获取连接

Question

错误 - java.sql.SQLException:无法从基础数据库获取连接!(..)信息:Sql 查询错误。如果不存在则创建表 SUITEREPORTS(ID BIGINT 身份、SUITEREPORTID VARCHAR(255)、SUITENAME VARCHAR(2000)、SUITEPATH VARCHAR(2000)、开始时间戳、结束时间戳、状态 VARCHAR(255)、TOTALCOUNT INT、PASSEDCOUNT INT、FAILEDCOUNT INT、 TIMETAKEN INT，浏览器类型 VARCHAR(255))

在某一时刻(可能是因为缺少可用空间)基于 jenkins 的 sahi 停止工作。当我打开日志数据库时，我收到文本 - 无法从底层数据库获取连接!

在控制台日志中:

[java] Nov 21, 2017 1:37:22 PM in.co.sahi.datastore.SahiDB createTables
 [java] INFO: version=2017-05-09 20:45:45
 [java] Nov 21, 2017 1:37:22 PM in.co.sahi.datastore.SahiDB createTables
 [java] INFO: Updating tables structures.
 [java] java.sql.SQLException: Connections could not be acquired from the underlying database!
 [java]     at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)
 [java]     at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:690)
 [java]     at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140)
 [java]     at net.sf.sahi.plugin.PooledDBClient.getConnection(PooledDBClient.java:31)
 [java]     at net.sf.sahi.plugin.DBClient.execute(DBClient.java:66)
 [java]     at in.co.sahi.datastore.SahiDB.executeSQL(SahiDB.java:162)
 [java]     at in.co.sahi.datastore.SahiDB.createTables(SahiDB.java:98)
 [java]     at in.co.sahi.datastore.SahiDB.<clinit>(SahiDB.java:32)
 [java]     at net.sf.sahi.f.run(Unknown Source)
 [java]     at java.lang.Thread.run(Thread.java:748)
 [java] Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
 [java]     at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1418)
 [java]     at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:606)
 [java]     at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:526)
 [java]     at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:756)
 [java]     at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:683)
 [java]     ... 8 more
 [java] Nov 21, 2017 1:37:54 PM in.co.sahi.datastore.SahiDB createTables
 [java] INFO: -----------------------------------------------
 [java] Nov 21, 2017 1:37:54 PM in.co.sahi.datastore.SahiDB createTables
 [java] INFO: Error in Sql Query.
 [java] CREATE TABLE IF NOT EXISTS SUITEREPORTS (ID BIGINT IDENTITY, SUITEREPORTID VARCHAR(255), SUITENAME VARCHAR(2000), SUITEPATH VARCHAR(2000), STARTTIME TIMESTAMP, ENDTIME TIMESTAMP, STATUS VARCHAR(255), TOTALCOUNT INT, PASSEDCOUNT INT, FAILEDCOUNT INT, TIMETAKEN INT, BROWSERTYPE VARCHAR(255))
 [java] exception: java.sql.SQLException: Connections could not be acquired from the underlying database!
 [java]     at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)
 [java]     at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:690)
 [java]     at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140)
 [java]     at net.sf.sahi.plugin.PooledDBClient.getConnection(PooledDBClient.java:31)
 [java]     at net.sf.sahi.plugin.DBClient.execute(DBClient.java:66)
 [java]     at in.co.sahi.datastore.SahiDB.executeSQL(SahiDB.java:162)
 [java]     at in.co.sahi.datastore.SahiDB.createTables(SahiDB.java:98)
 [java]     at in.co.sahi.datastore.SahiDB.<clinit>(SahiDB.java:32)
 [java]     at net.sf.sahi.f.run(Unknown Source)
 [java]     at java.lang.Thread.run(Thread.java:748)
 [java] Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
 [java]     at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1418)
 [java]     at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:606)
 [java]     at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:526)
 [java]     at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:756)
 [java]     at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:683)
 [java]     ... 8 more
 [java] 
 [java] Nov 21, 2017 1:37:54 PM in.co.sahi.datastore.SahiDB createTables
 [java] INFO: -----------------------------------------------
 [java] java.sql.SQLException: Connections could not be acquired from the underlying database!
 [java]     at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)
 [java]     at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:690)
 [java]     at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140)
 [java]     at net.sf.sahi.plugin.PooledDBClient.getConnection(PooledDBClient.java:31)
 [java]     at net.sf.sahi.plugin.DBClient.execute(DBClient.java:66)
 [java]     at in.co.sahi.datastore.SahiDB.executeSQL(SahiDB.java:162)
 [java]     at net.sf.sahi.test.SuiteSummary.init(SuiteSummary.java:104)
 [java]     at in.co.sahi.distributed.DSuiteRunner.execute(DSuiteRunner.java:72)
 [java]     at in.co.sahi.command.Master$1.run(Master.java:117)
 [java]     at java.lang.Thread.run(Thread.java:748)
 [java] Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
 [java]     at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1418)
 [java]     at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:606)
 [java]     at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:526)
 [java]     at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:756)
 [java]     at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:683)
 [java]     ... 8 more

哪里会出问题？我能做些什么来修复？

Answer 1

你能告诉我你在 Sahi 中使用的是哪个数据库吗？

确保您在 Sahi 属性中为您的数据库添加了正确的 JDBC URL。