Can't start BeaTunes, getting a fatal error, and it wants to rebuild the database

Ker Bob's Avatar

Ker Bob

22 Apr, 2018 07:40 AM

Everything had been working ok, but i just upgraded to the latest version, and now these:

Fatal Error:
org.hibernate.exception.GenericJDBCException: Unable to acquire JDBC Connection.

Then when I restarted, it tried to repair my database, and now I get this:
Fatal Error:
Database repair failed:
org.h2.jdbc.JdbcSQLException:
Unique index or primary key violationL
"Primary_KEY_4 ON PUBLIC.SONGS(ID) VALUES (/* 4835 */ -9089281159947931888 )"; SQL statement:
CREATE PRIMARY KEY PUBLIC.PRIMARY _KEY_4 ON PUBLIC.SONGS(ID) [23505-195]

Would you like to re-build beaTunes' internal database from your auddio files?

I havent done anything at this point, as I really dont want to rebuild the database if possible. Any ideas?

  1. Support Staff 1 Posted by hendrik on 22 Apr, 2018 08:05 AM

    hendrik's Avatar

    I havent done anything at this point, as I really dont want to rebuild the database if possible. Any ideas?

    Unfortunately, rebuilding is the only sane option when the primary index is broken.

    Sorry.

  2. 2 Posted by Ker Bob on 24 Apr, 2018 01:33 AM

    Ker Bob's Avatar

    So it looks like I lost all my data? Everything I had corrected, all the mood, instrumentation, color, key, genre, etc?
    I thought it actually wrote the info to the songs?

  3. Support Staff 3 Posted by hendrik on 24 Apr, 2018 06:14 AM

    hendrik's Avatar

    beaTunes writes all that info into the audio files, if you check the box "embed non-iTunes fields" in the general preferences before analysis. If that box is not checked, beaTunes tells iTunes about all changes that iTunes can handle (e.g. genre, name, album, ...), and stores all other info (like key, mood, etc.) only in its internal database.

    See also https://blog.beatunes.com/2013/10/so-where-exactly-does-beatunes-st...

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac