Haven't encountered this in the nine years using it

Need help? Post your questions here.

Moderator: moderators

Haven't encountered this in the nine years using it

Postby MoreTrife » Thu Oct 29, 2020 8:59 pm

Problem Description: ALL WINDOWS FILLED WITH ERROR MESSAGES: Exception org.springframework.dao.TransientDataAccessResourceException
Message PreparedStatementCallback; SQL
Troubleshooting Steps: rebooted computer...
Playback Application and version: desktop and Dsub
Subsonic Version: not completely sure, 6.1 something. Can't even check it as all windows filled with error message.
Server Version: jetty 6.1.x? unable to check as windows filled with error messages...though connection seems in tact as I can reach server from Dsub and browser outside local network.
Hardware Platform: Windows 10, music on Seagate NAS
Java Memory Limit: 150
Last ten log file lines:
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)
at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:712)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:139)
at org.mortbay.jetty.Server.handle(Server.java:313)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:506)
at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:830)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:514)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:381)
at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:396)
at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:442)
Caused by: java.sql.SQLException: S1000 General error java.lang.NullPointerException in statement [select id, path, folder, type, format, title, album, artist, album_artist, disc_number, track_number, year, genre, bit_rate, variable_bit_rate, duration_seconds, file_size, width, height, cover_art_path, parent_path, play_count, last_played, comment, created, changed, last_scanned, children_last_updated, present, version from media_file where type = ? and folder in (?) and present order by created desc limit ? offset ?]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.executeQuery(Unknown Source)
at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:648)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:591)
... 65 more


Thanks for any help
MoreTrife
 
Posts: 29
Joined: Thu Feb 17, 2011 8:29 am

Re: Haven't encountered this in the nine years using it

Postby MoreTrife » Thu Oct 29, 2020 10:10 pm

https://photos.app.goo.gl/xsKWaqR5tmpvNnLV6

Link to screenshot of error screen, maybe that will help.
MoreTrife
 
Posts: 29
Joined: Thu Feb 17, 2011 8:29 am

Re: Haven't encountered this in the nine years using it

Postby MoreTrife » Thu Oct 29, 2020 10:17 pm

Now it's partially back having done nothing on my end...Still missing lots of settings and music isn't back. Interface is partially back.
MoreTrife
 
Posts: 29
Joined: Thu Feb 17, 2011 8:29 am

Re: Haven't encountered this in the nine years using it

Postby MoreTrife » Fri Oct 30, 2020 3:47 am

Ugh. Just deleted everything and reinstalled. Guess it was a corrupt database.
MoreTrife
 
Posts: 29
Joined: Thu Feb 17, 2011 8:29 am


Return to Help

Who is online

Users browsing this forum: No registered users and 20 guests