Uploaded image for project: 'Qt License server'
  1. Qt License server
  2. QLS-1933

On-premise: Failed to remove reservation records from local database

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • P3: Somewhat important
    • 3.5.0
    • 3.5.0
    • On-premise server
    • None
    • License server development 51

    Description

      This happens sometimes when starting the on-premises instance. Only way to get forward is to remove data.sqlite (see attach) and start the on-premises again.

      2025-04-28 12:03:16,953 INFO: 2025-04-28 12:03:16 - info: Removing current license reservations...
        2025-04-28 12:03:17,053 INFO: 2025-04-28 12:03:16 - error: Failed to remove reservation records from local database: {"name":"SequelizeDatabaseError","parent":{"errno":1,"code":"SQLITE_ERROR","sql":"SELECT `id`, `reservation_id__c`, `license_number__c`, `hardware_id__c`, `process_id__c`, `email__c`, `lease_start__c`, `lease_end__c`, `last_used__c`, `actual_usage_days__c`, `type__c`, `extension_mode__c`, `is_manually_released__c`, `user_id__c` FROM `reservations` AS `reservation` WHERE `reservation`.`is_manually_released__c` = 0;"},"original":{"errno":1,"code":"SQLITE_ERROR","sql":"SELECT `id`, `reservation_id__c`, `license_number__c`, `hardware_id__c`, `process_id__c`, `email__c`, `lease_start__c`, `lease_end__c`, `last_used__c`, `actual_usage_days__c`, `type__c`, `extension_mode__c`, `is_manually_released__c`, `user_id__c` FROM `reservations` AS `reservation` WHERE `reservation`.`is_manually_released__c` = 0;"},"sql":"SELECT `id`, `reservation_id__c`, `license_number__c`, `hardware_id__c`, `process_id__c`, `email__c`, `lease_start__c`, `lease_end__c`, `last_used__c`, `actual_usage_days__c`, `type__c`, `extension_mode__c`, `is_manually_released__c`, `user_id__c` FROM `reservations` AS `reservation` WHERE `reservation`.`is_manually_released__c` = 0;","parameters":{}}
        2025-04-28 12:03:17,154 INFO: 2025-04-28 12:03:16 - info: Removing current licenses...
        2025-04-28 12:03:17,254 INFO: 2025-04-28 12:03:16 - error: Failed to remove license records from local database: {"name":"SequelizeDatabaseError","parent":{"errno":1,"code":"SQLITE_ERROR","sql":"DELETE FROM `unified_licenses`"},"original":{"errno":1,"code":"SQLITE_ERROR","sql":"DELETE FROM `unified_licenses`"},"sql":"DELETE FROM `unified_licenses`","parameters":{}}
        2025-04-28 12:03:17,355 INFO: 2025-04-28 12:03:16 - info: Local instance loaded with newest license data.
        2025-04-28 12:03:17,456 INFO: 2025-04-28 12:03:16 - info: Loading the local ACL file: /home/qt/work/release_artifacts/server_artifacts/acl.json
        2025-04-28 12:03:17,556 INFO: 2025-04-28 12:03:16 - error: uncaughtException: SQLITE_ERROR: no such table: unified_licenses
        2025-04-28 12:03:17,657 INFO: Error
        2025-04-28 12:03:17,758 INFO: at Database.<anonymous> (/snapshot/tqtc-license-server/node_modules/sequelize/lib/dialects/sqlite/query.js:185:27)
        2025-04-28 12:03:17,858 INFO: at /snapshot/tqtc-license-server/node_modules/sequelize/lib/dialects/sqlite/query.js:183:50
        2025-04-28 12:03:17,959 INFO: at new WrappedPromise (/snapshot/tqtc-license-server/node_modules/async-listener/es6-wrapped-promise.js:13:18)
        2025-04-28 12:03:18,059 INFO: at Query.run (/snapshot/tqtc-license-server/node_modules/sequelize/lib/dialects/sqlite/query.js:183:12)
        2025-04-28 12:03:18,160 INFO: at /snapshot/tqtc-license-server/node_modules/sequelize/lib/sequelize.js:315:28
        2025-04-28 12:03:18,261 INFO: 2025-04-28 12:03:16 - error: uncaughtException: SQLITE_ERROR: no such table: unified_licenses
        2025-04-28 12:03:18,362 INFO: Error
        2025-04-28 12:03:18,462 INFO: at Database.<anonymous> (/snapshot/tqtc-license-server/node_modules/sequelize/lib/dialects/sqlite/query.js:185:27)
        2025-04-28 12:03:18,563 INFO: at /snapshot/tqtc-license-server/node_modules/sequelize/lib/dialects/sqlite/query.js:183:50
        2025-04-28 12:03:18,664 INFO: at new WrappedPromise (/snapshot/tqtc-license-server/node_modules/async-listener/es6-wrapped-promise.js:13:18)
        2025-04-28 12:03:18,765 INFO: at Query.run (/snapshot/tqtc-license-server/node_modules/sequelize/lib/dialects/sqlite/query.js:183:12)
        2025-04-28 12:03:18,865 INFO: at /snapshot/tqtc-license-server/node_modules/sequelize/lib/sequelize.js:315:28
        2025-04-28 12:03:18,966 INFO: 2025-04-28 12:03:16 - error: uncaughtException: SQLITE_ERROR: no such table: unified_licenses

       

      Also once data.sqlite was renamed to data.sqlite-journal (see attach)

      Attachments

        1. data.sqlite
          88 kB
        2. data.sqlite-journal
          9 kB
        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            lapham Lam Pham
            hehalmet Heikki Halmet
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Gerrit Reviews

                There are no open Gerrit changes