starting SQL Server 2019 failure after shutdown and start Ubuntu 20.04

Question

Environment

Windows 10 Home (host) + Virtual Box 6.1.22 + Ubuntu 20.04 (guest) + SQL Server 2019 for Ubuntu

Symptom

I follow the Quickstart: Install SQL Server and create a database on Ubuntu to build SQL Server 2019 for Linux.
All are smoothly until I shutdown my VM, and start VM, the mssql-server start failure.

The check command and error message are as follows :

1. * sudo systemctl status mssql-server --no-pager -l *
   => mssql-server.service: Start request repeated too quickly.
2. * journalctl -xe | grep mssql *
   => /opt/mssql/bin/sqlservr: The file archive [/opt/mssql/lib/sqlservr.sfp] is invalid.

Research

I've found the article SQL Serve 2019 on Ubuntu fails after powering off has the similar issue, then I reinstall SQL Server 2019 ( sudo apt-get install --reinstall mssql-server ), it seems OK until I shutdown and start VM again, the mssql-server still start failure.

I don't have any idea why it occurs. Is there any solution?
Thank you

Appendix

The following are the screen capture for error messages.

Answer 1

Hi @jasper.lai ,

Welcome to Microsoft Q&A!
Having an Ubuntu 20.04 machine with at least 2GB of RAM is a prerequisite for installing SQL Server on Ubuntu.
You can track it by this command:
journalctl -u mssql-server.service -b
If this condition is not met, you can add memory.

Best regards,
Seeya

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.