Backup fails: Warning: Extension “SSL It!” Configuration data exceeds 8388608 bytes in length and cannot be backed up

Symptoms

• A backup cannot be created with the following error:

  Warning: Extension "SSL It!"
  Configuration data exceeds 8388608 bytes in length and cannot be backed up. 

• There are a lot of orders in the SSL It! SQLite database:

  # sqlite3 /usr/local/psa/var/modules/sslit/sslit.sqlite3 'select * from Orders;' | wc -l
  209229

Cause

This is a known bug with ID #EXTSSLIT-1936, which will be fixed in future updates of the SSL It! extension.

You may track the progress in the Change Log for Plesk Obsidian.

Resolution

Until the bug is resolved permanently, you may apply the following workaround:

1. Log into the server via SSH

2. Create a backup of the SSL It! extension database

# cp /usr/local/psa/var/modules/sslit/sslit.sqlite3 /usr/local/psa/var/modules/sslit/sslit.sqlite3.bak

3. Open the SSL It! extension database

# sqlite3 /usr/local/psa/var/modules/sslit/sslit.sqlite3:

4. Remove rows from the orders table via sqlite3:

# sqlite> delete from orders where vendorId = 'letsencrypt.letsencrypt' and productId = 'base' and status = 1 and certificateId = 0; 

Note: Since the SSL It! database may contain paid orders (e.g. Sectigo / Digicert certificates), the specific command above should be used in order to avoid removing them.