Page 1 of 1

New install on Macbook Sonoma. Start gets SQLException

PostPosted: Thu May 22, 2025 4:10 pm
by Scouser
Just installed latest Serviio 2.4.2 on my Macbook Pro M1 running Sonoma 14.7.5. Install worked flawlessly after invoking Serviio-2.4.2.pkg.
I double-clicked the Serviio-Console.app and get a window that states from Serviio-Console-Wrapper "Cannot connect to the server, it doesn't seem to be running...:

After trawling the forum, I learned how to set debug mode on in log4j2.xml then tried to restart. This is the error message.....

2024-04-13T23:13:43,902 INFO [MediaServer] ------------------------------------------------------------------------
2024-04-13T23:13:43,904 INFO [MediaServer] Serviio DLNA media streaming server v 2.3 (rev. 0a644e100b723d73bf6cbc59c5106edb378f336b)
2024-04-13T23:13:43,904 INFO [MediaServer] Petr Nejedly 2009-2018
2024-04-13T23:13:43,904 INFO [MediaServer] http://www.serviio.org
2024-04-13T23:13:43,904 INFO [MediaServer]
2024-04-13T23:13:43,904 INFO [MediaServer] Java 1.8.0_352-BellSoft x86_64
2024-04-13T23:13:43,904 INFO [MediaServer] OS Mac OS X 10.16
2024-04-13T23:13:43,905 INFO [MediaServer] File encoding: UTF-8
2024-04-13T23:13:43,906 INFO [MediaServer] Headless mode enabled: true
2024-04-13T23:13:43,906 INFO [MediaServer] User: root
2024-04-13T23:13:43,906 INFO [MediaServer] User home dir: /var/root
2024-04-13T23:13:43,906 INFO [MediaServer] Temp dir: /var/folders/zz/zyxvpxvq6csfxvn_n0000000000000/T/
2024-04-13T23:13:43,906 INFO [MediaServer] ------------------------------------------------------------------------
2024-04-13T23:13:43,912 INFO [DBSchemaUpdateExecutor] Checking if DB schema needs to be updated
2024-04-13T23:13:43,926 INFO [DatabaseManager] Using DERBY database language
2024-04-13T23:13:44,154 WARN [DBConnectionPool] Can't create a new connection for jdbc:derby:db;create=true
java.sql.SQLException: Failed to start database 'db' with class loader sun.misc.Launcher$AppClassLoader@63961c42, see the next exception for details.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source) ~[derby.jar:?]
at org.apache.derby.jdbc.InternalDriver$1.run(Unknown Source) ~[derby.jar:?]
at org.apache.derby.jdbc.InternalDriver$1.run(Unknown Source) ~[derby.jar:?]
at java.security.AccessController.doPrivileged(Native Method) ~[?:1.8.0_352]
at org.apache.derby.jdbc.InternalDriver.getNewEmbedConnection(Unknown Source) ~[derby.jar:?]
at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source) ~[derby.jar:?]
at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source) ~[derby.jar:?]
at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source) ~[derby.jar:?]
at java.sql.DriverManager.getConnection(DriverManager.java:664) ~[?:1.8.0_352]
at java.sql.DriverManager.getConnection(DriverManager.java:270) ~[?:1.8.0_352]
at org.serviio.db.DBConnectionPool.newConnection(DBConnetionPool.java:186) ~[serviio.jar:?]
at org.serviio.db.DBConnectionPool.getConnection(DBConnetionPool.java:123) ~[serviio.jar:?]
at org.serviio.db.DBConnectionPool.getConnection(DBConnetionPool.java:149) ~[serviio.jar:?]
at org.serviio.db.DatabaseManager.getConnection(DatabaseManager.java:71) ~[serviio.jar:?]
at org.serviio.db.DatabaseManager.getConnection(DatabaseManager.java:64) ~[serviio.jar:?]
at org.serviio.update.dao.DBLogDAOImpl.isScriptPresent(DBLogDAOImpl.java:49) ~[serviio.jar:?]
at org.serviio.update.DBSchemaUpdateExecutor.updateDBSchema(DBSchemaUpdateExecutor.java:86) ~[serviio.jar:?]
at org.serviio.MediaServer.main(MediaServer.java:128) ~[serviio.jar:?]
Caused by: org.apache.derby.iapi.error.StandardException: Failed to start database 'db' with class loader sun.misc.Launcher$AppClassLoader@63961c42, see the next exception for details.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(Unknown Source) ~[derby.jar:?]
... 22 more
Caused by: org.apache.derby.iapi.error.StandardException: Page Page(29,Container(0, 560)) is at version 223, the log file contains change version 263, either there are log records of this page missing, or this page did not get written out to disk properly.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby.jar:?]
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.store.raw.data.PageBasicOperation.needsRedo(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.store.raw.log.FileLogger.redo(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.store.raw.log.LogToFile.recover(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.store.raw.RawStore.boot(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.services.monitor.FileMonitor.startModule(Unknown Source) ~[derby.jar:?]
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.store.access.RAMAccessManager$5.run(Unknown Source) ~[derby.jar:?]
at java.security.AccessController.doPrivileged(Native Method) ~[?:1.8.0_352]
at org.apache.derby.impl.store.access.RAMAccessManager.bootServiceModule(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.store.access.RAMAccessManager.boot(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.services.monitor.FileMonitor.startModule(Unknown Source) ~[derby.jar:?]
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.db.BasicDatabase$5.run(Unknown Source) ~[derby.jar:?]
at java.security.AccessController.doPrivileged(Native Method) ~[?:1.8.0_352]
at org.apache.derby.impl.db.BasicDatabase.bootServiceModule(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.db.BasicDatabase.bootStore(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown Source) ~[derby.jar:?]
at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.jdbc.EmbedConnection$4.run(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.jdbc.EmbedConnection$4.run(Unknown Source) ~[derby.jar:?]
at java.security.AccessController.doPrivileged(Native Method) ~[?:1.8.0_352]
at org.apache.derby.impl.jdbc.EmbedConnection.startPersistentService(Unknown Source) ~[derby.jar:?]
... 19 more
2024-04-13T23:13:46,262 ERROR [MediaServer] An unexpected error occurred. Ending the application. Message: null
java.lang.NullPointerException: null
at org.serviio.update.dao.DBLogDAOImpl.isScriptPresent(DBLogDAOImpl.java:50) ~[serviio.jar:?]
at org.serviio.update.DBSchemaUpdateExecutor.updateDBSchema(DBSchemaUpdateExecutor.java:86) ~[serviio.jar:?]
at org.serviio.MediaServer.main(MediaServer.java:128) ~[serviio.jar:?]

Re: New install on Macbook Sonoma. Start gets SQLException

PostPosted: Thu May 22, 2025 4:28 pm
by Scouser
I thought the log looked weired as it reported wrong version. So I rebooted. Version is correct now but still get same results.

2025-05-22T17:21:02,541 DEBUG [ApplicationInstanceManager] Listening for application instances on socket 44331
2025-05-22T17:21:02,545 INFO [MediaServer] ------------------------------------------------------------------------
2025-05-22T17:21:02,546 INFO [MediaServer] Serviio DLNA media streaming server v 2.4 (rev. f520ddf3d2ce4ae4f1f352761852647a7fab7d43)
2025-05-22T17:21:02,546 INFO [MediaServer] Petr Nejedly 2009-2018
2025-05-22T17:21:02,546 INFO [MediaServer] http://www.serviio.org
2025-05-22T17:21:02,546 INFO [MediaServer]
2025-05-22T17:21:02,546 INFO [MediaServer] Java 1.8.0_352-BellSoft x86_64
2025-05-22T17:21:02,546 INFO [MediaServer] OS Mac OS X 10.16
2025-05-22T17:21:02,546 INFO [MediaServer] File encoding: UTF-8
2025-05-22T17:21:02,548 INFO [MediaServer] Headless mode enabled: true
2025-05-22T17:21:02,548 INFO [MediaServer] User: root
2025-05-22T17:21:02,548 INFO [MediaServer] User home dir: /var/root
2025-05-22T17:21:02,548 INFO [MediaServer] Temp dir: /var/folders/zz/zyxvpxvq6csfxvn_n0000000000000/T/
2025-05-22T17:21:02,548 INFO [MediaServer] ------------------------------------------------------------------------
2025-05-22T17:21:02,550 DEBUG [MediaServer] Runtime params: -Xmx512M, -Xms20M, -XX:+UseG1GC, -XX:GCTimeRatio=1, -XX:MinHeapFreeRatio=10, -XX:MaxHeapFreeRatio=20, -Djava.net.preferIPv4Stack=true, -Djava.awt.headless=true, -Dorg.restlet.engine.loggerFacadeClass=org.restlet.ext.slf4j.Slf4jLoggerFacade, -Dderby.system.home=/Library/Application Support/Serviio/library, -Dserviio.home=/Library/Application Support/Serviio, -Dffmpeg.location=/Library/Application Support/Serviio/lib/ffmpeg, -Ddcraw.location=/Library/Application Support/Serviio/lib/dcraw, -Dserviio.libraryPollerFrequency=5
2025-05-22T17:21:02,558 INFO [DBSchemaUpdateExecutor] Checking if DB schema needs to be updated
2025-05-22T17:21:02,579 DEBUG [DBLogDAOImpl] Checking if script 'script-0.1.sql' has been run
2025-05-22T17:21:02,580 INFO [DatabaseManager] Using DERBY database language
2025-05-22T17:21:02,938 WARN [DBConnectionPool] Can't create a new connection for jdbc:derby:db;create=true
java.sql.SQLException: Failed to start database 'db' with class loader sun.misc.Launcher$AppClassLoader@63961c42, see the next exception for details.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source) ~[derby.jar:?]
at org.apache.derby.jdbc.InternalDriver$1.run(Unknown Source) ~[derby.jar:?]
at org.apache.derby.jdbc.InternalDriver$1.run(Unknown Source) ~[derby.jar:?]
at java.security.AccessController.doPrivileged(Native Method) ~[?:1.8.0_352]
at org.apache.derby.jdbc.InternalDriver.getNewEmbedConnection(Unknown Source) ~[derby.jar:?]
at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source) ~[derby.jar:?]
at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source) ~[derby.jar:?]
at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source) ~[derby.jar:?]
at java.sql.DriverManager.getConnection(DriverManager.java:664) ~[?:1.8.0_352]
at java.sql.DriverManager.getConnection(DriverManager.java:270) ~[?:1.8.0_352]
at org.serviio.db.DBConnectionPool.newConnection(DBConnetionPool.java:186) ~[serviio.jar:?]
at org.serviio.db.DBConnectionPool.getConnection(DBConnetionPool.java:123) ~[serviio.jar:?]
at org.serviio.db.DBConnectionPool.getConnection(DBConnetionPool.java:149) ~[serviio.jar:?]
at org.serviio.db.DatabaseManager.getConnection(DatabaseManager.java:71) ~[serviio.jar:?]
at org.serviio.db.DatabaseManager.getConnection(DatabaseManager.java:64) ~[serviio.jar:?]
at org.serviio.update.dao.DBLogDAOImpl.isScriptPresent(DBLogDAOImpl.java:49) ~[serviio.jar:?]
at org.serviio.update.DBSchemaUpdateExecutor.updateDBSchema(DBSchemaUpdateExecutor.java:86) ~[serviio.jar:?]
at org.serviio.MediaServer.main(MediaServer.java:128) ~[serviio.jar:?]
Caused by: org.apache.derby.iapi.error.StandardException: Failed to start database 'db' with class loader sun.misc.Launcher$AppClassLoader@63961c42, see the next exception for details.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(Unknown Source) ~[derby.jar:?]
... 22 more
Caused by: org.apache.derby.iapi.error.StandardException: Page Page(29,Container(0, 560)) is at version 223, the log file contains change version 263, either there are log records of this page missing, or this page did not get written out to disk properly.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby.jar:?]
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.store.raw.data.PageBasicOperation.needsRedo(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.store.raw.log.FileLogger.redo(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.store.raw.log.LogToFile.recover(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.store.raw.RawStore.boot(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.services.monitor.FileMonitor.startModule(Unknown Source) ~[derby.jar:?]
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.store.access.RAMAccessManager$5.run(Unknown Source) ~[derby.jar:?]
at java.security.AccessController.doPrivileged(Native Method) ~[?:1.8.0_352]
at org.apache.derby.impl.store.access.RAMAccessManager.bootServiceModule(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.store.access.RAMAccessManager.boot(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.services.monitor.FileMonitor.startModule(Unknown Source) ~[derby.jar:?]
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.db.BasicDatabase$5.run(Unknown Source) ~[derby.jar:?]
at java.security.AccessController.doPrivileged(Native Method) ~[?:1.8.0_352]
at org.apache.derby.impl.db.BasicDatabase.bootServiceModule(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.db.BasicDatabase.bootStore(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown Source) ~[derby.jar:?]
at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.jdbc.EmbedConnection$4.run(Unknown Source) ~[derby.jar:?]
at org.apache.derby.impl.jdbc.EmbedConnection$4.run(Unknown Source) ~[derby.jar:?]
at java.security.AccessController.doPrivileged(Native Method) ~[?:1.8.0_352]
at org.apache.derby.impl.jdbc.EmbedConnection.startPersistentService(Unknown Source) ~[derby.jar:?]
... 19 more
2025-05-22T17:21:05,115 ERROR [MediaServer] An unexpected error occurred. Ending the application. Message: null
java.lang.NullPointerException: null
at org.serviio.update.dao.DBLogDAOImpl.isScriptPresent(DBLogDAOImpl.java:50) ~[serviio.jar:?]
at org.serviio.update.DBSchemaUpdateExecutor.updateDBSchema(DBSchemaUpdateExecutor.java:86) ~[serviio.jar:?]
at org.serviio.MediaServer.main(MediaServer.java:128) ~[serviio.jar:?]

I wonder if there are remnants of the old serviio install somewhere. If so where will they be and how do I delete them?

Re: New install on Macbook Sonoma. Start gets SQLException

PostPosted: Thu May 22, 2025 4:39 pm
by Scouser
so I sorted it. There were old remnants of a previous serviio install.
sudo rm -rf /Library/Application\ Support/Serviio
sudo rm -rf /Users/b***y/Library/Application\ Support/Serviio*
deleted the app from Applications folder.
Reboot.
Re install the pkg.
All good.

Re: New install on Macbook Sonoma. Start gets SQLException

PostPosted: Fri May 23, 2025 1:04 am
by atc98092
Ah yes. I've had issues in the past with leftover bits of programs when using an -nix based OS. And that's the core of the MacOS now, a form of Unix. Glad you found the issue. :D