SSL It! extension fails to renew or issue ceritificate: Error: database disk image is malformed

Symptoms

• The following error show up in /var/log/plesk/panel.log when renewing the certificate has failed:

  ERR [extension/sslit] Failed to renew certificate of domain 'example.com': SQLSTATE[HY000]: General error: 11 database disk image is malformed, query was: SELECT "OrderAttribute".* FROM "OrderAttribute" WHERE ("orderId" = '12345')

• The following error show up in Plesk panel, if issuing a new certificate is attempted:

  An error happened during the installation of the certificate: SQLSTATE[HY000]: General error: 11 database disk image is malformed, query was: INSERT INTO "Orders" ("vendorid","productId", "domainGuid") VALUES (?,?,?)

• Trying to access the database record directly returns the same error

  sqlite> select OrderAttribute.* from OrderAttribute where orderId='12345';
  Error: database disk image is malformed

Cause

The SSL It! SQLite database is corrupted.

Resolution

Regenerate the SQLite database by reinstalling the extension.

1. Log in to Plesk

2. Backup the SSL It! database

   # cp /usr/local/psa/var/modules/sslit/sslit.sqlite3{,.backup}

3. Reinstall the SSL It! extension

4. Reissue the domain's certificate