Ubuntu 16.04.7 and Broken SQL Server after Update

Zachary Burns 106 Reputation points
2020-09-11T12:04:52.163+00:00
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)
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
    2020-09-14T12:16:40.767+00:00

    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

    No comments

3 additional answers

Sort by: Most helpful
  1. Cris Zhan-MSFT 6,561 Reputation points
    2020-09-14T09:50:51.933+00:00

    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

    No comments

  2. John Stritzinger 1 Reputation point
    2020-10-31T13:09:09.877+00:00

    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
    2020-10-31T13:11:18.79+00:00

    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

    No comments