I did regular upgrade of packages as always and something broke, cant even purge the packages due broken dependencies. The server is Ubuntu 16.04 on Azure. We are using MySQL on this server, so this package could be just Azure thing?
You might want to run 'apt-get -f install' to correct these.
The following packages have unmet dependencies:
mssql-tools : Depends: msodbcsql17 (>= 22.214.171.124) but it is not installed
Depends: msodbcsql17 (< 126.96.36.199) but it is not installed
E: Unmet dependencies. Try using -f.
And when I do apt-get -f install as it was in most cases advised the output is:
apt-get -f install
Reading package lists... Done
Building dependency tree
Reading state information... Done
Correcting dependencies... Done
The following additional packages will be installed:
The following NEW packages will be installed:
0 upgraded, 1 newly installed, 0 to remove and 4 not upgraded.
6 not fully installed or removed.
Need to get 3,760 kB of archives.
After this operation, 0 B of additional disk space will be used.
Do you want to continue? [Y/n] y
Get:1 https://packages.microsoft.com/ubuntu/16.04/prod xenial/main amd64 msodbcsql17 amd64 188.8.131.52-1 [3,760 kB]
Fetched 3,760 kB in 0s (15.1 MB/s)
Preconfiguring packages ...
(Reading database ... 153677 files and directories currently installed.)
Preparing to unpack .../msodbcsql17_184.108.40.206-1_amd64.deb ...
Unpacking msodbcsql17 (220.127.116.11-1) ...
dpkg: error processing archive /var/cache/apt/archives/msodbcsql17_18.104.22.168-1_amd64.deb (--unpack):
trying to overwrite '/usr/lib/libmsodbcsql-17.so', which is also in package msodbcsql 22.214.171.124-1
Errors were encountered while processing:
E: Sub-process /usr/bin/dpkg returned an error code (1)
I have tried following the documentation and deleting the driver itself as stated: https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server
So I want either to fix it or completely remove it and return 126.96.36.199-1 version for mssql-tools. Due that apt-get is now bugged and cant install anything on that server.
Thanks in advance