Discussion about the framework

[sses7757]

Any questions about the framework including gradle, spring, etc. can be discussed here.

[mmhct]

output

Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30006ms.
2023-12-26 09:35:16.949 ERROR 10232 --- [onPool-worker-1] io.sustc.benchmark.BenchmarkService      : Exception thrown for BV1v54y1u7m1=[BV1PK4y1b7dt, BV1Q7411J751, BV1mG4y1z761, BV1bt4y1x7Wk, BV19t4y1E7hh]
java.lang.RuntimeException: 执行 SQL 语句时发生异常

at io.sustc.service.impl.RecommenderServiceImpl.videoExists(RecommenderServiceImpl.java:73) ~[sustc-api-0.1.0-plain.jar:na]

at io.sustc.service.impl.RecommenderServiceImpl.recommendNextVideo(RecommenderServiceImpl.java:34) ~[sustc-api-0.1.0-plain.jar:na]

at io.sustc.benchmark.BenchmarkService.lambda$recVideo$3(BenchmarkService.java:154) ~[main/:na]

at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183) ~[na:na]

at java.base/java.util.HashMap$EntrySpliterator.forEachRemaining(HashMap.java:1850) ~[na:na]

at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509) ~[na:na]

at java.base/java.util.stream.ForEachOps$ForEachTask.compute(ForEachOps.java:290) ~[na:na]

at java.base/java.util.concurrent.CountedCompleter.exec(CountedCompleter.java:754) ~[na:na]

at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:373) ~[na:na]

at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1182) ~[na:na]

at java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1655) ~[na:na]

at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1622) ~[na:na]

at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:165) ~[na:na]

Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30012ms.

at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:696) ~[HikariCP-4.0.3.jar:na]

at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:197) ~[HikariCP-4.0.3.jar:na]

at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162) ~[HikariCP-4.0.3.jar:na]

Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30012ms.
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128) ~[HikariCP-4.0.3.jar:na]
at io.sustc.service.impl.RecommenderServiceImpl.videoExists(RecommenderServiceImpl.java:62) ~[sustc-api-0.1.0-plain.jar:na]
... 12 common frames omitted

2023-12-26 09:35:17.240 ERROR 10232 --- [onPool-worker-6] io.sustc.benchmark.BenchmarkService      : Exception thrown for BV14r4y1i7vZ=[BV1PK4y1b7dt, BV1Q7411J751, BV1mG4y1z761, BV1bt4y1x7Wk, BV19t4y1E7hh]
java.lang.RuntimeException: 执行 SQL 语句时发生异常

at io.sustc.service.impl.RecommenderServiceImpl.videoExists(RecommenderServiceImpl.java:73) ~[sustc-api-0.1.0-plain.jar:na]

at io.sustc.service.impl.RecommenderServiceImpl.recommendNextVideo(RecommenderServiceImpl.java:34) ~[sustc-api-0.1.0-plain.jar:na]

at io.sustc.benchmark.BenchmarkService.lambda$recVideo$3(BenchmarkService.java:154) ~[main/:na]

at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183) ~[na:na]

at java.base/java.util.HashMap$EntrySpliterator.forEachRemaining(HashMap.java:1850) ~[na:na]

at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509) ~[na:na]

at java.base/java.util.stream.ForEachOps$ForEachTask.compute(ForEachOps.java:290) ~[na:na]

at java.base/java.util.concurrent.CountedCompleter.exec(CountedCompleter.java:754) ~[na:na]

at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:373) ~[na:na]

at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1182) ~[na:na]

at java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1655) ~[na:na]

at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1622) ~[na:na]

at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:165) ~[na:na]

Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30002ms.

at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:696) ~[HikariCP-4.0.3.jar:na]

at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:197) ~[HikariCP-4.0.3.jar:na]

Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30002ms.
at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162) ~[HikariCP-4.0.3.jar:na]
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128) ~[HikariCP-4.0.3.jar:na]
at io.sustc.service.impl.RecommenderServiceImpl.videoExists(RecommenderServiceImpl.java:62) ~[sustc-api-0.1.0-plain.jar:na]
... 12 common frames omitted

2023-12-26 09:35:17.500 ERROR 10232 --- [nPool-worker-11] io.sustc.benchmark.BenchmarkService      : Exception thrown for BV1sz411z7Qb=[BV1PK4y1b7dt, BV1Q7411J751, BV1mG4y1z761, BV1bt4y1x7Wk, BV1FJ411M7rM]
java.lang.RuntimeException: 执行 SQL 语句时发生异常

at io.sustc.service.impl.RecommenderServiceImpl.videoExists(RecommenderServiceImpl.java:73) ~[sustc-api-0.1.0-plain.jar:na]

at io.sustc.service.impl.RecommenderServiceImpl.recommendNextVideo(RecommenderServiceImpl.java:34) ~[sustc-api-0.1.0-plain.jar:na]

at io.sustc.benchmark.BenchmarkService.lambda$recVideo$3(BenchmarkService.java:154) ~[main/:na]

at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183) ~[na:na]

at java.base/java.util.HashMap$EntrySpliterator.forEachRemaining(HashMap.java:1850) ~[na:na]

at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509) ~[na:na]

at java.base/java.util.stream.ForEachOps$ForEachTask.compute(ForEachOps.java:290) ~[na:na]

at java.base/java.util.concurrent.CountedCompleter.exec(CountedCompleter.java:754) ~[na:na]

at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:373) ~[na:na]

at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1182) ~[na:na]

at java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1655) ~[na:na]

at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1622) ~[na:na]

at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:165) ~[na:na]

Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30005ms.

at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:696) ~[HikariCP-4.0.3.jar:na]

at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:197) ~[HikariCP-4.0.3.jar:na]

at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162) ~[HikariCP-4.0.3.jar:na]

at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128) ~[HikariCP-4.0.3.jar:na]

at io.sustc.service.impl.RecommenderServiceImpl.videoExists(RecommenderServiceImpl.java:62) ~[sustc-api-0.1.0-plain.jar:na]

Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30005ms.
... 12 common frames omitted

2023-12-26 09:35:17.530 ERROR 10232 --- [nPool-worker-16] io.sustc.benchmark.BenchmarkService      : Exception thrown for BV1j5411H7zk=[BV1PK4y1b7dt, BV1Q7411J751, BV1mG4y1z761, BV1bt4y1x7Wk, BV19t4y1E7hh]
java.lang.RuntimeException: 执行 SQL 语句时发生异常

at io.sustc.service.impl.RecommenderServiceImpl.videoExists(RecommenderServiceImpl.java:73) ~[sustc-api-0.1.0-plain.jar:na]

at io.sustc.service.impl.RecommenderServiceImpl.recommendNextVideo(RecommenderServiceImpl.java:34) ~[sustc-api-0.1.0-plain.jar:na]

at io.sustc.benchmark.BenchmarkService.lambda$recVideo$3(BenchmarkService.java:154) ~[main/:na]

at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183) ~[na:na]

at java.base/java.util.HashMap$EntrySpliterator.forEachRemaining(HashMap.java:1850) ~[na:na]

at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509) ~[na:na]

at java.base/java.util.stream.ForEachOps$ForEachTask.compute(ForEachOps.java:290) ~[na:na]

at java.base/java.util.concurrent.CountedCompleter.exec(CountedCompleter.java:754) ~[na:na]

at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:373) ~[na:na]

at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1182) ~[na:na]

at java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1655) ~[na:na]

at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1622) ~[na:na]

at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:165) ~[na:na]

Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30009ms.

at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:696) ~[HikariCP-4.0.3.jar:na]

at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:197) ~[HikariCP-4.0.3.jar:na]

at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162) ~[HikariCP-4.0.3.jar:na]

at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128) ~[HikariCP-4.0.3.jar:na]

at io.sustc.service.impl.RecommenderServiceImpl.videoExists(RecommenderServiceImpl.java:62) ~[sustc-api-0.1.0-plain.jar:na]

... 12 common frames omitted

Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30009ms.
2023-12-26 09:35:19.277  INFO 10232 --- [           main] io.sustc.benchmark.BenchmarkRunner       : BenchmarkResult(id=5, passCnt=38, elapsedTime=33615)

2023-12-26 09:35:19.278  INFO 10232 --- [           main] io.sustc.benchmark.BenchmarkRunner       : Step 6: Test RecommenderService#generalRecommendations(int, int)

2023-12-26 09:35:21.758  INFO 10232 --- [           main] io.sustc.benchmark.BenchmarkRunner       : BenchmarkResult(id=6, passCnt=11, elapsedTime=2473)

2023-12-26 09:35:21.760  INFO 10232 --- [           main] io.sustc.benchmark.BenchmarkRunner       : Step 7: Test RecommenderService#recommendVideosForUser(AuthInfo, int, int)

2023-12-26 09:35:51.768 ERROR 10232 --- [nPool-worker-11] io.sustc.benchmark.BenchmarkService      : Exception thrown for [Ljava.lang.Object;@254f24b4=[]
java.lang.RuntimeException: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30003ms.

at io.sustc.service.impl.RecommenderServiceImpl.checkAuth(RecommenderServiceImpl.java:448) ~[sustc-api-0.1.0-plain.jar:na]

at io.sustc.service.impl.RecommenderServiceImpl.recommendVideosForUser(RecommenderServiceImpl.java:187) ~[sustc-api-0.1.0-plain.jar:na]

at io.sustc.benchmark.BenchmarkService.lambda$recUser$5(BenchmarkService.java:202) ~[main/:na]

at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183) ~[na:na]

at java.base/java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:992) ~[na:na]

at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509) ~[na:na]

at java.base/java.util.stream.ForEachOps$ForEachTask.compute(ForEachOps.java:290) ~[na:na]

at java.base/java.util.concurrent.CountedCompleter.exec(CountedCompleter.java:754) ~[na:na]

at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:373) ~[na:na]

at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1182) ~[na:na]

at java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1655) ~[na:na]

at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1622) ~[na:na]

at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:165) ~[na:na]

Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30003ms.

at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:696) ~[HikariCP-4.0.3.jar:na]

at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:197) ~[HikariCP-4.0.3.jar:na]

at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162) ~[HikariCP-4.0.3.jar:na]

at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128) ~[HikariCP-4.0.3.jar:na]

at io.sustc.service.impl.RecommenderServiceImpl.checkAuth(RecommenderServiceImpl.java:350) ~[sustc-api-0.1.0-plain.jar:na]

... 12 common frames omitted
2023-12-26 09:35:51.768 ERROR 10232 --- [nPool-worker-12] io.sustc.benchmark.BenchmarkService      : Exception thrown for [Ljava.lang.Object;@7791f89b=[]
java.lang.RuntimeException: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30003ms.

at io.sustc.service.impl.RecommenderServiceImpl.checkAuth(RecommenderServiceImpl.java:448) ~[sustc-api-0.1.0-plain.jar:na]

Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30003ms.
at io.sustc.service.impl.RecommenderServiceImpl.recommendVideosForUser(RecommenderServiceImpl.java:187) ~[sustc-api-0.1.0-plain.jar:na]
at io.sustc.benchmark.BenchmarkService.lambda$recUser$5(BenchmarkService.java:202) ~[main/:na]
at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183) ~[na:na]
at java.base/java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:992) ~[na:na]
at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509) ~[na:na]
at java.base/java.util.stream.ForEachOps$ForEachTask.compute(ForEachOps.java:290) ~[na:na]
at java.base/java.util.concurrent.CountedCompleter.exec(CountedCompleter.java:754) ~[na:na]
at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:373) ~[na:na]
at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1182) ~[na:na]
at java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1655) ~[na:na]
at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1622) ~[na:na]
at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:165) ~[na:na]

Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30003ms.

at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:696) ~[HikariCP-4.0.3.jar:na]

at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:197) ~[HikariCP-4.0.3.jar:na]

at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162) ~[HikariCP-4.0.3.jar:na]

at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128) ~[HikariCP-4.0.3.jar:na]

at io.sustc.service.impl.RecommenderServiceImpl.checkAuth(RecommenderServiceImpl.java:350) ~[sustc-api-0.1.0-plain.jar:na]

... 12 common frames omitted
2023-12-26 09:35:51.768 ERROR 10232 --- [nPool-worker-13] io.sustc.benchmark.BenchmarkService      : Exception thrown for [Ljava.lang.Object;@229487d0=[BV1rq4y1k7SH, BV1Rg411w7uU, BV1yX4y1T7nY]
java.lang.RuntimeException: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30000ms.

at io.sustc.service.impl.RecommenderServiceImpl.useAuthGetMid(RecommenderServiceImpl.java:551) ~[sustc-api-0.1.0-plain.jar:na]

at io.sustc.service.impl.RecommenderServiceImpl.getUserInterests(RecommenderServiceImpl.java:227) ~[sustc-api-0.1.0-plain.jar:na]

at io.sustc.service.impl.RecommenderServiceImpl.recommendVideosForUser(RecommenderServiceImpl.java:195) ~[sustc-api-0.1.0-plain.jar:na]

at io.sustc.benchmark.BenchmarkService.lambda$recUser$5(BenchmarkService.java:202) ~[main/:na]

at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183) ~[na:na]

at java.base/java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:992) ~[na:na]

at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509) ~[na:na]

at java.base/java.util.stream.ForEachOps$ForEachTask.compute(ForEachOps.java:290) ~[na:na]

at java.base/java.util.concurrent.CountedCompleter.exec(CountedCompleter.java:754) ~[na:na]

at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:373) ~[na:na]

at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1182) ~[na:na]

at java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1655) ~[na:na]

at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1622) ~[na:na]

at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:165) ~[na:na]

Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30000ms.

at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:696) ~[HikariCP-4.0.3.jar:na]

at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:197) ~[HikariCP-4.0.3.jar:na]

at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162) ~[HikariCP-4.0.3.jar:na]

at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128) ~[HikariCP-4.0.3.jar:na]

at io.sustc.service.impl.RecommenderServiceImpl.useAuthGetMid(RecommenderServiceImpl.java:503) ~[sustc-api-0.1.0-plain.jar:na]

... 13 common frames omitted
2023-12-26 09:35:51.784 ERROR 10232 --- [onPool-worker-6] io.sustc.benchmark.BenchmarkService      : Exception thrown for [Ljava.lang.Object;@3d9a6b7e=[BV1Yb4y1q7FH, BV1JZ4y1h7nD, BV1ef4y1R71D, BV1U94y1d71R, BV1P7411g7Jk, BV1cJ411H77j]
java.lang.RuntimeException: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30014ms.

at io.sustc.service.impl.RecommenderServiceImpl.useAuthGetMid(RecommenderServiceImpl.java:551) ~[sustc-api-0.1.0-plain.jar:na]

at io.sustc.service.impl.RecommenderServiceImpl.getUserInterests(RecommenderServiceImpl.java:227) ~[sustc-api-0.1.0-plain.jar:na]

at io.sustc.service.impl.RecommenderServiceImpl.recommendVideosForUser(RecommenderServiceImpl.java:195) ~[sustc-api-0.1.0-plain.jar:na]

at io.sustc.benchmark.BenchmarkService.lambda$recUser$5(BenchmarkService.java:202) ~[main/:na]

at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183) ~[na:na]

at java.base/java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:992) ~[na:na]

at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509) ~[na:na]

at java.base/java.util.stream.ForEachOps$ForEachTask.compute(ForEachOps.java:290) ~[na:na]

at java.base/java.util.concurrent.CountedCompleter.exec(CountedCompleter.java:754) ~[na:na]

at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:373) ~[na:na]

at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1182) ~[na:na]

at java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1655) ~[na:na]

at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1622) ~[na:na]

at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:165) ~[na:na]

Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30014ms.

at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:696) ~[HikariCP-4.0.3.jar:na]

at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:197) ~[HikariCP-4.0.3.jar:na]

at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162) ~[HikariCP-4.0.3.jar:na]

at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128) ~[HikariCP-4.0.3.jar:na]

at io.sustc.service.impl.RecommenderServiceImpl.useAuthGetMid(RecommenderServiceImpl.java:503) ~[sustc-api-0.1.0-plain.jar:na]

... 13 common frames omitted
2023-12-26 09:35:51.784 ERROR 10232 --- [onPool-worker-5] io.sustc.benchmark.BenchmarkService      : Exception thrown for [Ljava.lang.Object;@3b3c861a=[BV1CP4y1H7SB, BV1Rg411w7uU]
java.lang.RuntimeException: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30014ms.

at io.sustc.service.impl.RecommenderServiceImpl.useAuthGetMid(RecommenderServiceImpl.java:551) ~[sustc-api-0.1.0-plain.jar:na]

at io.sustc.service.impl.RecommenderServiceImpl.getUserInterests(RecommenderServiceImpl.java:227) ~[sustc-api-0.1.0-plain.jar:na]

at io.sustc.service.impl.RecommenderServiceImpl.recommendVideosForUser(RecommenderServiceImpl.java:195) ~[sustc-api-0.1.0-plain.jar:na]

at io.sustc.benchmark.BenchmarkService.lambda$recUser$5(BenchmarkService.java:202) ~[main/:na]

at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183) ~[na:na]

at java.base/java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:992) ~[na:na]

at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509) ~[na:na]

at java.base/java.util.stream.ForEachOps$ForEachTask.compute(ForEachOps.java:290) ~[na:na]

at java.base/java.util.concurrent.CountedCompleter.exec(CountedCompleter.java:754) ~[na:na]

at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:373) ~[na:na]

at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1182) ~[na:na]

at java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1655) ~[na:na]

at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1622) ~[na:na]

at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:165) ~[na:na]

Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30014ms.

at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:696) ~[HikariCP-4.0.3.jar:na]

at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:197) ~[HikariCP-4.0.3.jar:na]

at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162) ~[HikariCP-4.0.3.jar:na]

at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128) ~[HikariCP-4.0.3.jar:na]

at io.sustc.service.impl.RecommenderServiceImpl.useAuthGetMid(RecommenderServiceImpl.java:503) ~[sustc-api-0.1.0-plain.jar:na]

... 13 common frames omitted
2023-12-26 09:35:51.784 ERROR 10232 --- [nPool-worker-16] io.sustc.benchmark.BenchmarkService      : Exception thrown for [Ljava.lang.Object;@784d0b96=[]
java.lang.RuntimeException: 执行 SQL 语句时发生异常

at io.sustc.service.impl.RecommenderServiceImpl.getUserInterests(RecommenderServiceImpl.java:259) ~[sustc-api-0.1.0-plain.jar:na]

at io.sustc.service.impl.RecommenderServiceImpl.recommendVideosForUser(RecommenderServiceImpl.java:195) ~[sustc-api-0.1.0-plain.jar:na]

at io.sustc.benchmark.BenchmarkService.lambda$recUser$5(BenchmarkService.java:202) ~[main/:na]

at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183) ~[na:na]

Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30000ms.
at java.base/java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:992) ~[na:na]
at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509) ~[na:na]
at java.base/java.util.stream.ForEachOps$ForEachTask.compute(ForEachOps.java:290) ~[na:na]
at java.base/java.util.concurrent.CountedCompleter.exec(CountedCompleter.java:754) ~[na:na]
at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:373) ~[na:na]
at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1182) ~[na:na]
at java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1655) ~[na:na]
at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1622) ~[na:na]
at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:165) ~[na:na]

Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30005ms.

at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:696) ~[HikariCP-4.0.3.jar:na]

at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:197) ~[HikariCP-4.0.3.jar:na]

at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162) ~[HikariCP-4.0.3.jar:na]

at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128) ~[HikariCP-4.0.3.jar:na]

at io.sustc.service.impl.RecommenderServiceImpl.getUserInterests(RecommenderServiceImpl.java:225) ~[sustc-api-0.1.0-plain.jar:na]

... 12 common frames omitted
2023-12-26 09:35:51.784 ERROR 10232 --- [nPool-worker-14] io.sustc.benchmark.BenchmarkService      : Exception thrown for [Ljava.lang.Object;@ed5789e=[BV187411H782, BV1CP4y1H7SB, BV1p44y1i7cb, BV1Ah411m7GM, BV1XP4y1T7zz]
java.lang.RuntimeException: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30012ms.

at io.sustc.service.impl.RecommenderServiceImpl.checkAuth(RecommenderServiceImpl.java:448) ~[sustc-api-0.1.0-plain.jar:na]

at io.sustc.service.impl.RecommenderServiceImpl.recommendVideosForUser(RecommenderServiceImpl.java:187) ~[sustc-api-0.1.0-plain.jar:na]

at io.sustc.benchmark.BenchmarkService.lambda$recUser$5(BenchmarkService.java:202) ~[main/:na]

at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183) ~[na:na]

at java.base/java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:992) ~[na:na]

Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30014ms.
at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509) ~[na:na]
at java.base/java.util.stream.ForEachOps$ForEachTask.compute(ForEachOps.java:290) ~[na:na]
at java.base/java.util.concurrent.CountedCompleter.exec(CountedCompleter.java:754) ~[na:na]
at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:373) ~[na:na]
at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1182) ~[na:na]
at java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1655) ~[na:na]
at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1622) ~[na:na]
at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:165) ~[na:na]

Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30012ms.

at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:696) ~[HikariCP-4.0.3.jar:na]

at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:197) ~[HikariCP-4.0.3.jar:na]

at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162) ~[HikariCP-4.0.3.jar:na]

at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128) ~[HikariCP-4.0.3.jar:na]

at io.sustc.service.impl.RecommenderServiceImpl.checkAuth(RecommenderServiceImpl.java:350) ~[sustc-api-0.1.0-plain.jar:na]

... 12 common frames omitted
2023-12-26 09:35:51.784 ERROR 10232 --- [nPool-worker-17] io.sustc.benchmark.BenchmarkService      : Exception thrown for [Ljava.lang.Object;@21ea0b31=[BV14r4y1i7vZ, BV1Q3411M79u, BV1fW4y1f7Eu, BV1wd4y1G7Rd, BV1pM4y1e7Ke, BV1Mv4y1N7WJ, BV1bt4y1x7Wk]
java.lang.RuntimeException: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30002ms.

at io.sustc.service.impl.RecommenderServiceImpl.useAuthGetMid(RecommenderServiceImpl.java:551) ~[sustc-api-0.1.0-plain.jar:na]

at io.sustc.service.impl.RecommenderServiceImpl.getUserInterests(RecommenderServiceImpl.java:227) ~[sustc-api-0.1.0-plain.jar:na]

at io.sustc.service.impl.RecommenderServiceImpl.recommendVideosForUser(RecommenderServiceImpl.java:195) ~[sustc-api-0.1.0-plain.jar:na]

at io.sustc.benchmark.BenchmarkService.lambda$recUser$5(BenchmarkService.java:202) ~[main/:na]

at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183) ~[na:na]

at java.base/java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:992) ~[na:na]

at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509) ~[na:na]

at java.base/java.util.stream.ForEachOps$ForEachTask.compute(ForEachOps.java:290) ~[na:na]

at java.base/java.util.concurrent.CountedCompleter.exec(CountedCompleter.java:754) ~[na:na]

at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:373) ~[na:na]

at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1182) ~[na:na]

at java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1655) ~[na:na]

at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1622) ~[na:na]

at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:165) ~[na:na]

Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30002ms.

at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:696) ~[HikariCP-4.0.3.jar:na]

at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:197) ~[HikariCP-4.0.3.jar:na]

at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162) ~[HikariCP-4.0.3.jar:na]

at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128) ~[HikariCP-4.0.3.jar:na]

at io.sustc.service.impl.RecommenderServiceImpl.useAuthGetMid(RecommenderServiceImpl.java:503) ~[sustc-api-0.1.0-plain.jar:na]

... 13 common frames omitted
Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30005ms.
Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30012ms.
Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30002ms.

昨天让助教改了component也没用，SA said it is frame problem

[sses7757]

@mmhct
These problems may also be caused by thread-unsafe codes. Since the benchmark code is provided, you can see that query tests like Step 7 Recommend are executed in parallel (see BenchmarkServide.java#L199). If your SQL is not fast (cannot finish one query in 30000 ms) and do not consider thread-safe connection resource allocation, you may run out of the connection pool of 10 connections.

[mmhct]

That means we need to optimize our sql statements? Or there is any other solution like avoid using thread-unsafe codes, can you tell me how to do it?

[sses7757]

You may try to add the connection pool timeout and the benchmark step timeout to a larger value at your own computer. If I remember it correctly, you may add spring.datasource.hikari.connectionTimeout=300000 in gradle.properties and increase the timeout of benchmark steps like @BenchmarkStep(order = 5, timeout = 8, description = "Test RecommenderService#recommendNextVideo(String)") → @BenchmarkStep(order = 5, timeout = 80, description = "Test RecommenderService#recommendNextVideo(String)").
You can try this temporary solution in your computer and see if this error can be resolved. I will contact other SA to change the timeouts to proper values later.

[dequeueing]

Hi. I encounter the same problem and do as you said.

But the problem still occurs.

[sses7757]

The time constraints have been increased. You may synchronize with the main branch and try again.

[fz-zsl]

Hello reviewer, I've downloaded the newest data from http://172.18.34.154/ (ETAG 69d03da0c45e786250b1c3dd586e1ee9) and passed task 7&8 on my computer. However, OJ kept saying that I can't pass them, with the passing rate exactly the same as the submissions before I debug these tasks. Is there a problem with my submission method? (delete .jar file -> generate .jar with submitJar -> zip the files into submit.jar and submit on OJ).

[fz-zsl]

And I've just debugged task 9, the result of task 9 turned from WA to AC, but tasks 7&8 are still wrong...