Skip to content

Problem: BoltDB migration to sqlite failes (TemplateVault) #3743

@derDaywalker

Description

@derDaywalker

Issue

I'm using docker and upgraded from v2.15.5 to v2.17.33-629fc09-1775060479 (docker tag latest).
When I execute the migration tool to migrate from BoltDB to sqlite the migration fails because of TemplateVault:

semaphore migrate --from-boltdb /var/lib/semaphore/database.boltdb
SQLite @0.0.0.0 semaphore
Starting migration...
Exporting User                                 100%
Exporting Project                              100%
Exporting Task                                 100%
Exporting TaskOutput                           100%
Exporting AccessKey                            100%
Exporting SecretStorage                        100%
Exporting Inventory                            100%
Exporting Repository                           100%
Exporting View                                 100%
Exporting Schedule                             100%
Exporting ProjectUser                          100%
Exporting Integration                          100%
Exporting IntegrationExtractValue              100%
Exporting Option                               100%
Exporting Template                             100%
Exporting TemplateVault                        0%
Migration failed: failed to export TemplateVault: no rows in result set

Do you need more information?
Thx for helping in advance.

Impact

Database

Installation method

Docker

Database

BoltDB

Browser

No response

Semaphore Version

semaphore version
v2.17.33-629fc09-1775060479

Ansible Version

Logs & errors

No response

Manual installation - system information

No response

Configuration

{
        "sqlite": {
                "host": "/var/lib/semaphore/database.sqlite"
        },
        "dialect": "sqlite",
        "tmp_path": "/tmp/semaphore",
        "cookie_hash": "xxx",
        "cookie_encryption": "xxx",
        "access_key_encryption": "xxx"
 }

Additional information

No response

Metadata

Metadata

Assignees

Labels

Type

No fields configured for Bug.

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions