Uploaded image for project: 'appNG'
  1. appNG
  2. APPNG-2238

CLI closes HSQL server instance

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 1.19.0
    • Component/s: appng-cli
    • Labels:

      Description

      appng-cli closes HSQL server instance after a cli command run.

      appNG-cli.log:

      01:24:10 INFO  MigrationService    : connected to jdbc:hsqldb:hsql://localhost:9010/appng (HSQL Database Engine 2.4.0)
      01:24:10 WARN  Flyway              : Direct configuration of the Flyway object has been deprecated and will be removed in Flyway 6.0. Use Flyway.configure() instead.
      01:24:10 WARN  Flyway              : Direct configuration of the Flyway object has been deprecated and will be removed in Flyway 6.0. Use Flyway.configure() instead.
      01:24:10 INFO  DatabaseFactory     : Database: jdbc:hsqldb:hsql://localhost:9010/appng (HSQL Database Engine 2.4)
      01:24:11 WARN  JdbcTableSchemaHistory: Could not find schema history table "PUBLIC"."flyway_schema_history", but found "PUBLIC"."schema_version" instead. You are seeing this message because Flyway changed its default for flyway.table in version 5.0.0 to flyway_schema_history and you are still relying on the old default (schema_version). Set flyway.table=schema_version in your configuration to fix this. This fallback mechanism will be removed in Flyway 6.0.0.
      01:24:11 INFO  CliCore             : Database is at version 4.0.0, state: SUCCESS, installed on 2019-02-06 12:39:54.319
      01:24:11 INFO  PlatformEventListener: Created entry 2019-02-06 13:24:11.286 UPDATE bjoern Property platform.devMode
      ...
      01:24:11 INFO  CliBootstrap        : duration: 8393ms
      01:24:11 INFO  HsqlStarter         : shutting down HSQL Server 2.4.0 at null on port 9010
      

      This conflicts with the running appng-standalone instance which will be no longer functional:

      appNG.log:

      2019-02-06 13:24:44,396 INFO  [HSQLDB Connection @222a2432] HSQLDB68C29B4A70.ENGINE       : Database closed
      2019-02-06 13:24:57,009 WARN  [Scheduler_manager] pool.PoolBase                 : appNG HSQL - Failed to validate connection org.hsqldb.jdbc.JDBCConnection@15fc9df7 (connection exception: connection failure: java.net.SocketException: Broken pipe (Write failed)). Possibly consider using a shorter maxLifetime value.
      ...
      

        Attachments

          Activity

            People

            • Assignee:
              mueller.matthias Matthias Müller
              Reporter:
              pritzel.bjoern Bjoern Pritzel
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: