SQL errors in 2.3 / OpenBSD 7.2-current

[Former user]

Hello, I've updated serviio from 2.2.1 to 2.3 and I'm seeing some SQL related errors in the console now. I can access the console, dlna server also works but the shared folder are empty. This is on openbsd 7.2-current, jdk-1.8.0.342.b07.1v0. Any idea how to fix it?

openbsd$ /sbin/route -T1 exec /bin/sh /usr/local/serviio/bin/serviio.sh
Exception in thread "pool-17-thread-1" org.serviio.db.dao.PersistenceException: Cannot delete Renderer with uuid = 34f66277-0f7e-4a57-a5e2-f9140c954618 at org.serviio.renderer.dao.RendererDAOImpl.delete(RendererDAOImpl.java:84) at org.serviio.renderer.service.RendererService.delete(RendererService.java:44) at org.serviio.renderer.RendererManager.removeRenderer(RendererManager.java:245) at org.serviio.renderer.RendererManager.removeRendererWithIPAddress(RendererManager.java:398) at org.serviio.renderer.RendererManager.getProfileByRendererDescriptionFromURL(RendererManager.java:303) at org.serviio.renderer.RendererManager.rendererAvailable(RendererManager.java:121) at org.serviio.upnp.discovery.RendererSearchResponseProcessor.run(RendererSearchResponseProcessor.java:65) 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:750) Caused by: java.sql.SQLException: An SQL data change is not permitted for a read-only connection, user or database. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) at org.serviio.renderer.dao.RendererDAOImpl.delete(RendererDAOImpl.java:82) ... 9 more Caused by: ERROR 25502: An SQL data change is not permitted for a read-only connection, user or database. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.sql.conn.GenericAuthorizer.authorize(Unknown Source) at org.apache.derby.impl.sql.execute.GenericResultSetFactory.getDeleteResultSet(Unknown Source) at org.apache.derby.exe.acf81e0010x0184x7c89xe56fxffffcdc429f77.createResultSet(Unknown Source) at org.apache.derby.impl.sql.execute.BaseActivation.decorateResultSet(Unknown Source) at org.apache.derby.impl.sql.execute.BaseActivation.execute(Unknown Source) at org.apache.derby.impl.sql.GenericActivationHolder.execute(Unknown Source) at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source) at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) ... 14 more Exception in thread "pool-17-thread-3" org.serviio.db.dao.PersistenceException: Cannot delete Renderer with uuid = 34f66277-0f7e-4a57-a5e2-f9140c954618 at org.serviio.renderer.dao.RendererDAOImpl.delete(RendererDAOImpl.java:84) at org.serviio.renderer.service.RendererService.delete(RendererService.java:44) at org.serviio.renderer.RendererManager.removeRenderer(RendererManager.java:245) at org.serviio.renderer.RendererManager.removeRendererWithIPAddress(RendererManager.java:398) at org.serviio.renderer.RendererManager.getProfileByRendererDescriptionFromURL(RendererManager.java:303) at org.serviio.renderer.RendererManager.rendererAvailable(RendererManager.java:121) at org.serviio.upnp.discovery.RendererSearchResponseProcessor.run(RendererSearchResponseProcessor.java:65) 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:750) Caused by: java.sql.SQLException: An SQL data change is not permitted for a read-only connection, user or database. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) at org.serviio.renderer.dao.RendererDAOImpl.delete(RendererDAOImpl.java:82) ... 9 more Caused by: ERROR 25502: An SQL data change is not permitted for a read-only connection, user or database. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.sql.conn.GenericAuthorizer.authorize(Unknown Source) at org.apache.derby.impl.sql.execute.GenericResultSetFactory.getDeleteResultSet(Unknown Source) at org.apache.derby.exe.acf81e0010x0184x7c89xe56fxffffcdc429f77.createResultSet(Unknown Source) at org.apache.derby.impl.sql.execute.BaseActivation.decorateResultSet(Unknown Source) at org.apache.derby.impl.sql.execute.BaseActivation.execute(Unknown Source) at org.apache.derby.impl.sql.GenericActivationHolder.execute(Unknown Source) at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source) at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) ... 14 more Exception in thread "pool-17-thread-5" org.serviio.db.dao.PersistenceException: Cannot delete Renderer with uuid = 34f66277-0f7e-4a57-a5e2-f9140c954618 at org.serviio.renderer.dao.RendererDAOImpl.delete(RendererDAOImpl.java:84) at org.serviio.renderer.service.RendererService.delete(RendererService.java:44) at org.serviio.renderer.RendererManager.removeRenderer(RendererManager.java:245) at org.serviio.renderer.RendererManager.removeRendererWithIPAddress(RendererManager.java:398) at org.serviio.renderer.RendererManager.getProfileByRendererDescriptionFromURL(RendererManager.java:303) at org.serviio.renderer.RendererManager.rendererAvailable(RendererManager.java:121) at org.serviio.upnp.discovery.RendererSearchResponseProcessor.run(RendererSearchResponseProcessor.java:65) 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:750) Caused by: java.sql.SQLException: An SQL data change is not permitted for a read-only connection, user or database. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) at org.serviio.renderer.dao.RendererDAOImpl.delete(RendererDAOImpl.java:82) ... 9 more Caused by: ERROR 25502: An SQL data change is not permitted for a read-only connection, user or database. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.sql.conn.GenericAuthorizer.authorize(Unknown Source) at org.apache.derby.impl.sql.execute.GenericResultSetFactory.getDeleteResultSet(Unknown Source) at org.apache.derby.exe.acf81e0010x0184x7c89xe56fxffffcdc429f77.createResultSet(Unknown Source) at org.apache.derby.impl.sql.execute.BaseActivation.decorateResultSet(Unknown Source) at org.apache.derby.impl.sql.execute.BaseActivation.execute(Unknown Source) at org.apache.derby.impl.sql.GenericActivationHolder.execute(Unknown Source) at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source) at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) ... 14 more ^C

[Petr Nejedly]

This looks like the dB folder is red only for the user running Serviio?

[Former user]

Turns out, I accidently ran it as root once after the update. This created a db.lck in <installpath>/serviio/library/db, so that the user serviio was running as, couldn’t delete it. Deleted the file, problem solved.
Sorry for the noise.