How to Upgrade QueryPie ACP Community Edition

Overview

The upgrade uses the --upgrade option of the installation script (setup.v2.sh). It transitions to a new version while preserving existing data and configuration, and automatically performs DB migration.

Upgrade Requirements

The <installation path>/current symbolic link must exist.
Example when installed under the home directory: ~/querypie/current
The querypie container must be running during the upgrade.
The upgrade cannot proceed if containers are stopped.

Upgrade Procedure

Step 1: Check the Current Version and Verify Upgrade Prerequisites


# Check which version the `current` symbolic link points to
ls -al ~/querypie/current ## This is an example when installed under the home directory.

# Check whether all required containers are running (app, mysql, redis)
docker ps --format "table {{.Names}}\t{{.Image}}" | grep querypie

Step 2: Check Available Versions

Check the available versions in the Product Versions document.

Step 3: Run the Upgrade


bash <(curl -s https://dl.querypie.com/setup.v2.sh) --upgrade <version>

Example:


bash <(curl -s https://dl.querypie.com/setup.v2.sh) --upgrade 11.6.0

Upgrading to the same version or a lower version is not supported.

Step 4: Verify Upgrade Completion


# Check whether the `current` symbolic link points to the new version
ls -al ~/querypie/current ## This is an example when installed under the home directory.

# Check whether the new version containers are running
docker ps --format "table {{.Names}}\t{{.Image}}" | grep querypie

Internal Upgrade Process

Tasks performed automatically by the script:

Check container engine and current QueryPie status
Verify that the running version matches the configured version (stops if mismatched)
Confirm that the target version is higher than the current version (skipped if same or lower)
Download and configure the new version configuration files
Pull the new version Docker images
Stop the existing version containers
Run DB migration (migrate.sh runall twice)
Start the new version containers and verify readiness
Update the ~/querypie/current symbolic link to the new version

Notes

Direct Login Required: As with installation, TTY is required, so connect directly to the server via SSH before running.
Version Order: Upgrading to the same version or a lower version is not supported.
Previous Version Directory Preserved: After the upgrade, the previous version directory (~/querypie/<previous version>/) is not automatically deleted. Verify and manually delete if no longer needed. (If there are files from the previous version that need to be copied, such as certificates, copy them before deleting.)
```
rm -rf ~/querypie/<previous version>
```
Downtime: A brief service interruption occurs during the container replacement process.
License: The Community Edition license is valid for one year from the date of issuance. Verify the license expiration status after the upgrade.