SQL errors in 2.3 / OpenBSD 7.2-current
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
Comments (3)
-
repo owner -
Account Deleted 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. -
repo owner - changed status to invalid
- Log in to comment
This looks like the dB folder is red only for the user running Serviio?