Memory Error!

Post your Server Bug Report

Memory Error!

Unread postby taoism » 25 Feb 2015, 04:36

Exception org.springframework.dao.TransientDataAccessResourceException
Message PreparedStatementCallback; SQL [insert into media_file (id, path, folder, type, override, format, data, title, album, album_name, artist, album_artist, disc_number, track_number, year, genre, mood, 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, first_scanned, children_last_updated, present, version, rank) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; org.hsqldb.HsqlException: java.io.EOFException; nested exception is java.sql.SQLException: org.hsqldb.HsqlException: java.io.EOFException
Java version Oracle Corporation 1.8.0_31
Operating system Windows 7 6.1
Server jetty/8.y.z-SNAPSHOT
Memory Used 49 of 372 MB
Stack trace org.springframework.dao.TransientDataAccessResourceException: PreparedStatementCallback; SQL [insert into media_file (id, path, folder, type, override, format, data, title, album, album_name, artist, album_artist, disc_number, track_number, year, genre, mood, 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, first_scanned, children_last_updated, present, version, rank) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; org.hsqldb.HsqlException: java.io.EOFException; nested exception is
taoism
 
Posts: 6
Joined: 19 May 2014, 06:58
Has thanked: 4 times
Been thanked: 4 times

Re: Memory Error!

Unread postby DoCC » 01 Mar 2015, 02:40

welcome to club, hsqldb fucked up : )

stop the deamon,
rename the db directory,
restart the deamon,
wait 30 sec,
stop the deamon,
copy some needed stuff like users, customavatars and podcasts to the regarding place from the old to the new madsonic.script file
restart the deamon,
setup the music folders once again.
rescan the media files ...

no, there is no other way.
User avatar
DoCC
Contributor
Contributor
 
Posts: 210
Joined: 25 Feb 2014, 14:41
Location: UpperBavaria : ))
Has thanked: 41 times
Been thanked: 71 times


Return to Bug Reports 5.x

Who is online

Users browsing this forum: No registered users and 0 guests