2

Last night I upgraded from 21.04 to 21.10 and it removed MsSql-server from my system and there isn't a release for this new version. How can I remove this update so I can get my Sql Server back????

Is there any other way to install mysql without rolling back the update?

Archisman Panigrahi
  • 38,814
DoImagine
  • 53

2 Answers2

1

Thank you for all the feed back and suggestions. After hours of investigating the situation, I have discovered proof that the upgrade did in fact remove SQL Server due to dependency conflicts.

I'm not sure whom to forward the logs to but I do have them ready to send. I was able to get MSSQL server running finally, after removing libldap2.4-2 and ldap-common excluding dependencies, installing SQL server package with force-depends. downloading libldap2.4 pkg and extracting libs to /usr/lib.

I then ran apt update and upgrade and SQL Server is running again. with no errors. Excerpt from logs generated during upgrade: 

Investigating (1) libc++1:amd64 < 1:12.0-52~exp1 -> 1:13.0-53~exp1 @ii umU Ib >
Broken libc++1:amd64 Depends on libc++1-13:amd64 < none | 1:13.0.0-2 @un uH > (>= 13~)
Considering libc++1-13:amd64 -1 as a solution to libc++1:amd64 0
MarkKeep libc++1:amd64 < 1:12.0-52~exp1 -> 1:13.0-53~exp1 @ii umU Ib > FU=0
Removing libc++1:amd64 rather than change libc++1-13:amd64
MarkDelete libc++1:amd64 < 1:12.0-52~exp1 | 1:13.0-53~exp1 @ii umH Ib > FU=0
Investigating (1) mssql-server:amd64 < 15.0.4153.1-6 @ii mK Ib >
Broken mssql-server:amd64 Depends on libc++1:amd64 < 1:12.0-52~exp1 | 1:13.0-53~exp1 @ii umR >
Considering libc++1:amd64 0 as a solution to mssql-server:amd64 -2
 Removing mssql-server:amd64 rather than change libc++1:amd64
MarkDelete mssql-server:amd64 < 15.0.4153.1-6 @ii mK Ib > FU=0
Done
DoImagine
  • 53
0

As a workaround, you can manually download the required .deb packages from here and here, and install them with gdebi.

First install gdebi with

sudo apt install gdebi

Then double click the .deb packages to install. Some of them may be dependencies of mysql (gdebi will tell you if there is any missing dependency), and you would have to install those dependencies first.

Archisman Panigrahi
  • 38,814