HSQLDB issue - Data file size limit is reached

[isuftin]

Hey folks. I think my HSQLDB has reached its max file size. I am currently at 2147483312 bytes. Based on some HSQLDB info I've found, I need to update the hsqldb.cache_file_scale value in /var/subsonic/db/subsonic.properties : https://support.adeptia.com/entries/214 ... aintenance

The problem is that when I do update the key/value pair and restart Subsonic, Subsonic actually overwrites this properties file and sets the value back to 1. Does anyone know how I can change this value to 8? Does anyone know which template this reads from? I looked in the jetty/ directory to see if I could find anything useful but I couldn't.

I've also tried cleaning the database from the UI with no luck. I can, of course, delete the database and re-scan but my music collection is pretty huge and if I don't immediately reach that limitation again, I quickly will.

The error follows:

Caused by: java.sql.SQLException: java.io.IOException: S1000 Data file size limit is reached in statement [insert into media_file (id, path, folder, type, format, title, album, artist, album_artist, disc_num
mber, 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_update
ersion) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:798)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:591)
... 68 more