Ubuntu 16.04.7 and Broken SQL Server after Update

Question

Was testing SQL Server on Ubuntu 16.04.7 LTS (GNU/Linux 4.4.0-189-generic x86_64).

Running Fine - I think it was related to an apt-get update/upgrade, but not sure. Looks like MSSQL updated, but not it doesn't run - depends on a different version of GLIBC...did this change?

Can anybody assist? Some notes below

"apt-get install mssql-tools unixodbc-dev" Reports the following... mssql-tools is already the newest version (17.6.1.1-1). unixodbc-dev is already the newest version (2.3.7).

"apt-get install mssql-server" Reports the following... mssql-server is already the newest version (15.0.4063.15-10).

Running "/opt/mssql/bin/sqlservr -f" /opt/mssql/bin/sqlservr: /lib/x86_64-linux-gnu/libc.so.6: version `GLIBC_2.27' not found (required by /opt/mssql/bin/sqlservr)

Answer 1

That link you provided pointed me (thank you) in the right direction for a DOWNGRADE - so others beware.

Here's what I did to fix it as it looks like Microsoft it building against Ubuntu 18.04 now (which is probably a different version of GLIBC)

Microsoft says to do an "apt-get install mssql-server=15.0.4063.15-10" in order to downgrade to August 2020 version CU6 - but this didn't do anything for me.

Instead I downloaded the DEB package built against 16.04 LTS and installed it like the following...(thankfully they are building against 16.04!!!!)

wget https://packages.microsoft.com/ubuntu/16.04/mssql-server-2019/pool/main/m/mssql-server/mssql-server_15.0.4063.15-10_amd64.deb

apt install ./mssql-server_15.0.4063.15-10_amd64.deb

.
.
.
Note, selecting 'mssql-server' instead of './mssql-server_15.0.4063.15-10_amd64.deb'
The following packages will be DOWNGRADED:
mssql-server
0 upgraded, 0 newly installed, 1 downgraded, 0 to remove and 0 not upgraded.
Need to get 0 B/222 MB of archives.
After this operation, 0 B of additional disk space will be used.
Do you want to continue? [Y/n] Y
.
.
.
.

systemctl start mssql-server

Answer 2

Hi @Zachary Burns ,

Can you describe the current problem in detail? SQL Server cannot start after updating?

Update or Upgrade SQL Server
https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-setup?view=sql-server-ver15#upgrade

Answer 3

The Issue is the latest version of SQL Server is looking for Glibc Version 2.27, Debian 9, and Ubuntu 16.04 have version 2.15 or earlier installed so the SQL setup fails. The answer was to go back a few builds on the same release of SQL Server 2019 which matched both Linux versions.

Answer 4

The Bleeding edge GLIBC with newer Linux releases is 2.32.....

https://www.gnu.org/software/libc/sources.html

but if you have an old version of Linux you either have to downgrade builds of SQL server or upgrade GLIBC on Linux. I tried both ways and both work.

Cheers,
John