Issue Error: Unable to restore the backup: the file contains wrong formatting.

[seed4]

Server operating system version

Debian GNU/Linux 10 (buster)

Plesk version and microupdate number

18.0.47.2

backup_info_2210041218.xml: Failed to load XML document.
Line 38103 Position 10002112 error: xmlSAX2Characters: huge text node
Line 38103 Position 10002112 fatal error: Extra content at the end of the document

 

[IgorG]

This is Plesk bug number EXTSSLIT-1936

The backup can't be restored because the SSL It! extension config encoded in the <config> element of a backup_info_*.xml file is more significant than 10'000'000 bytes (the default maximum node size specified by the XML_MAX_TEXT_LENGTH constant of libxml2)

 

[Nik G]

hello @seed4 ,
it looks similar to PPPM-13707.
the root cause is that some extension may have very huge config (>10mb) and restore filed when trying to read XML > 10Mb

extensions that may be related are SSL It! & Sectigo SSL.
you can check size of /usr/local/psa/var/modules/sslit/sslit.sqlite3 for example, and if it is more 10Mb try to export it to the file (and put to some place that will be backed up)
purge db and try again (create backup and restore it)

 

[seed4]

du -ch /usr/local/psa/var/modules/sslit/sslit.sqlite3
850M /usr/local/psa/var/modules/sslit/sslit.sqlite3

purge db and try again
which db ?

 

[IgorG]

Run the following command to create a backup of the SSL It! database:

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

Access the SSL It! database:

# sqlite3 -column -header /usr/local/psa/var/modules/sslit/sslit.sqlite3

Delete the orders from non-paid SSL. Be careful to run the exact command below, including all the filters:

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