Ubuntu 16.04.7 and Broken SQL Server after Update

Zachary Burns 106 Reputation points
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 ( 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)
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,560 questions
{count} votes

Accepted answer
  1. Zachary Burns 106 Reputation points

    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:
    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

    No comments

3 additional answers

Sort by: Most helpful
  1. Cris Zhan-MSFT 6,561 Reputation points

    Hi @Zachary Burns ,

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

    Update or Upgrade SQL Server

    No comments

  2. John Stritzinger 1 Reputation point

    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.

    No comments

  3. John Stritzinger 1 Reputation point

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


    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.


    No comments