BookLore icon indicating copy to clipboard operation
BookLore copied to clipboard

Seeing some sort of timeout error

Open ovizii opened this issue 8 months ago • 1 comments

I just fired up booklore and imported a library with about 1000 books. While it was working, I did have a few looks at the logs and saw some stuff scrolling past but didn't manage to save it all.

I think the provided ressources are fine:

Image

Here is the first log snippet:

 2025-04-22T23:12:02.989+03:00  INFO 1 --- [booklore-api] [     virtual-98] c.a.b.service.LibraryProcessingService   : Processing file: book-title1 - author-name1.epub                                   │
│   2025-04-22T23:12:03.305+03:00  INFO 1 --- [booklore-api] [     virtual-98] c.a.b.service.LibraryProcessingService   : Processed file: book-title1 - author-name1.epub                                    │
│   2025-04-22T23:12:03.305+03:00  INFO 1 --- [booklore-api] [     virtual-98] c.a.b.service.LibraryProcessingService   : Processing file: book-title1 - author-name1.pdf                                      │
│   2025-04-22T23:12:04.644+03:00  WARN 1 --- [booklore-api] [nio-8080-exec-8] com.zaxxer.hikari.pool.PoolBase          : HikariPool-1 - Failed to validate connection org.mariadb.jdbc.Connection@71865b36 ((co   │
│   nn=14) Connection.setNetworkTimeout cannot be called on a closed connection). Possibly consider using a shorter maxLifetime value.                                                                             │
│   2025-04-22T23:12:04.644+03:00  WARN 1 --- [booklore-api] [nio-8080-exec-1] com.zaxxer.hikari.pool.PoolBase          : HikariPool-1 - Failed to validate connection org.mariadb.jdbc.Connection@e5c57e4 ((con   │
│   n=13) Connection.setNetworkTimeout cannot be called on a closed connection). Possibly consider using a shorter maxLifetime value.                                                                              │
│   2025-04-22T23:12:04.647+03:00  WARN 1 --- [booklore-api] [nio-8080-exec-2] com.zaxxer.hikari.pool.PoolBase          : HikariPool-1 - Failed to validate connection org.mariadb.jdbc.Connection@572ba58 ((con   │
│   n=15) Connection.setNetworkTimeout cannot be called on a closed connection). Possibly consider using a shorter maxLifetime value.                                                                              │
│   2025-04-22T23:12:04.647+03:00  WARN 1 --- [booklore-api] [nio-8080-exec-8] com.zaxxer.hikari.pool.PoolBase          : HikariPool-1 - Failed to validate connection org.mariadb.jdbc.Connection@62926d50 ((co   │
│   nn=16) Connection.setNetworkTimeout cannot be called on a closed connection). Possibly consider using a shorter maxLifetime value.                                                                             │
│   2025-04-22T23:12:04.647+03:00  WARN 1 --- [booklore-api] [nio-8080-exec-2] com.zaxxer.hikari.pool.PoolBase          : HikariPool-1 - Failed to validate connection org.mariadb.jdbc.Connection@43e79438 ((co   │
│   nn=18) Connection.setNetworkTimeout cannot be called on a closed connection). Possibly consider using a shorter maxLifetime value.                                                                             │
│   2025-04-22T23:12:04.651+03:00  WARN 1 --- [booklore-api] [nio-8080-exec-1] com.zaxxer.hikari.pool.PoolBase          : HikariPool-1 - Failed to validate connection org.mariadb.jdbc.Connection@386995d6 ((co   │
│   nn=17) Connection.setNetworkTimeout cannot be called on a closed connection). Possibly consider using a shorter maxLifetime value.

and the second one:

 at com.zaxxer.hikari.pool.ProxyConnection.rollback(ProxyConnection.java:386)                                                                                                                                   │
│   at com.zaxxer.hikari.pool.HikariProxyConnection.rollback(HikariProxyConnection.java)                                                                                                                           │
│   at org.hibernate.resource.jdbc.internal.AbstractLogicalConnectionImplementor.rollback(AbstractLogicalConnectionImplementor.java:127)                                                                           │
│   at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.rollback(JdbcResourceLocalTransactionCoordinatorImpl.java:289)            │
│   at org.hibernate.engine.transaction.internal.TransactionImpl.rollback(TransactionImpl.java:142)                                                                                                                │
│   at org.springframework.orm.jpa.JpaTransactionManager.doRollback(JpaTransactionManager.java:589)                                                                                                                │
│   ... 10 more                                                                                                                                                                                                    │
│   Caused by: java.net.SocketException: Connection reset by peer                                                                                                                                                  │
│   at java.base/sun.nio.ch.SocketDispatcher.write0(Native Method)                                                                                                                                                 │
│   at java.base/sun.nio.ch.SocketDispatcher.write(Unknown Source)                                                                                                                                                 │
│   at java.base/sun.nio.ch.NioSocketImpl.tryWrite(Unknown Source)                                                                                                                                                 │
│   at java.base/sun.nio.ch.NioSocketImpl.implWrite(Unknown Source)                                                                                                                                                │
│   at java.base/sun.nio.ch.NioSocketImpl.write(Unknown Source)                                                                                                                                                    │
│   at java.base/sun.nio.ch.NioSocketImpl$2.write(Unknown Source)                                                                                                                                                  │
│   at java.base/java.net.Socket$SocketOutputStream.write(Unknown Source)                                                                                                                                          │
│   at org.mariadb.jdbc.client.socket.impl.PacketWriter.writeSocket(PacketWriter.java:852)                                                                                                                         │
│   at org.mariadb.jdbc.client.socket.impl.PacketWriter.flush(PacketWriter.java:711)                                                                                                                               │
│   at org.mariadb.jdbc.message.client.QueryPacket.encode(QueryPacket.java:48)                                                                                                                                     │
│   at org.mariadb.jdbc.client.impl.StandardClient.sendQuery(StandardClient.java:978)                                                                                                                              │
│   ... 19 more   

ovizii avatar Apr 22 '25 20:04 ovizii

Thanks for reporting this! It looks like a database connection issue, I’ll try to reproduce the error with a large import and see what’s going on.

acx10 avatar Apr 22 '25 21:04 acx10