Details
-
Bug
-
Resolution: Unresolved
-
P3: Somewhat important
-
3.5.0
-
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)