Uploaded image for project: 'aaa'
  1. aaa
  2. AAA-38

Incorrect database initialization

    XMLWordPrintable

Details

    • Bug
    • Status: Resolved
    • Resolution: Done
    • None
    • None
    • General
    • None
    • Operating System: All
      Platform: All

    • 3820

    Description

      H2 database initialization parameters were left "as is" verbatim from sqlite3 which is

      1. Incorrect
      2. Reduces functionality

      Background: It was possible to recover, reset or otherwise "fix" the database in Helium using a range of tools - command line sqlite3 utility, python, perl, etc.

      That functionality should be possible with the H2 database as well due to H2 providing reasonable level of support for the Postgresql connection protocol.

      Unfortunately, it is not possible to use it because the specific H2 postgresql protocol implementation insists on valid username and password.

      As a result it is no longer possible to recover, reset, backup cleanly in non-binary form for upgrade and migration purposes the database.

      Solution - add username and password to database instantiation (unfortunately not backwards compatible as the current Li database is not created correctly).

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            Unassigned Unassigned
            aivanov@brocade.com Anton Ivanov
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: