Arch Linux

YuvarajVelmurugan

Member

Registered: 2020-11-23

Posts: 15

Failed to start Microsoft SQL Server Database Engine

I was using mssql-server 2019 package for sometime and it was working good. But after recent software updates MSSQL SERVER is not starting.

I ran below command to check the journal logs for errors

journalctl -u mssql-server.service -b

I got below information from logs.

-- Journal begins at Mon 2021-10-04 13:16:24 IST, ends at Wed 2021-12-01 15:51:31 IST. --
systemd[1]: Started Microsoft SQL Server Database Engine.
sqlservr[378]: /opt/mssql/bin/sqlservr: error while loading shared libraries: liblber-2.4.so.2: cannot open shared object file: No such file or directory
systemd[1]: mssql-server.service: Main process exited, code=exited, status=127/n/a
systemd[1]: mssql-server.service: Failed with result 'exit-code'.
systemd[1]: mssql-server.service: Scheduled restart job, restart counter is at 1.
systemd[1]: Stopped Microsoft SQL Server Database Engine.
systemd[1]: Started Microsoft SQL Server Database Engine.
sqlservr[384]: /opt/mssql/bin/sqlservr: error while loading shared libraries: liblber-2.4.so.2: cannot open shared object file: No such file or directory
systemd[1]: mssql-server.service: Main process exited, code=exited, status=127/n/a
systemd[1]: mssql-server.service: Failed with result 'exit-code'.
systemd[1]: mssql-server.service: Scheduled restart job, restart counter is at 2.
systemd[1]: Stopped Microsoft SQL Server Database Engine.
systemd[1]: Started Microsoft SQL Server Database Engine.
sqlservr[387]: /opt/mssql/bin/sqlservr: error while loading shared libraries: liblber-2.4.so.2: cannot open shared object file: No such file or directory
systemd[1]: mssql-server.service: Main process exited, code=exited, status=127/n/a
systemd[1]: mssql-server.service: Failed with result 'exit-code'.
systemd[1]: mssql-server.service: Scheduled restart job, restart counter is at 3.
systemd[1]: Stopped Microsoft SQL Server Database Engine.
systemd[1]: mssql-server.service: Start request repeated too quickly.
systemd[1]: mssql-server.service: Failed with result 'exit-code'.
systemd[1]: Failed to start Microsoft SQL Server Database Engine.
systemd[1]: Started Microsoft SQL Server Database Engine.
sqlservr[11971]: /opt/mssql/bin/sqlservr: error while loading shared libraries: liblber-2.4.so.2: cannot open shared object file: No such file or directory
systemd[1]: mssql-server.service: Main process exited, code=exited, status=127/n/a
systemd[1]: mssql-server.service: Failed with result 'exit-code'.
systemd[1]: mssql-server.service: Scheduled restart job, restart counter is at 1.
systemd[1]: Stopped Microsoft SQL Server Database Engine.
systemd[1]: Started Microsoft SQL Server Database Engine.
sqlservr[11991]: /opt/mssql/bin/sqlservr: error while loading shared libraries: liblber-2.4.so.2: cannot open shared object file: No such file or directory
systemd[1]: mssql-server.service: Main process exited, code=exited, status=127/n/a
systemd[1]: mssql-server.service: Failed with result 'exit-code'.
systemd[1]: mssql-server.service: Scheduled restart job, restart counter is at 2.
systemd[1]: Stopped Microsoft SQL Server Database Engine.
systemd[1]: Started Microsoft SQL Server Database Engine.
sqlservr[11992]: /opt/mssql/bin/sqlservr: error while loading shared libraries: liblber-2.4.so.2: cannot open shared object file: No such file or directory
systemd[1]: mssql-server.service: Main process exited, code=exited, status=127/n/a
systemd[1]: mssql-server.service: Failed with result 'exit-code'.
systemd[1]: mssql-server.service: Scheduled restart job, restart counter is at 3.
systemd[1]: Stopped Microsoft SQL Server Database Engine.
systemd[1]: Started Microsoft SQL Server Database Engine.
sqlservr[11994]: /opt/mssql/bin/sqlservr: error while loading shared libraries: liblber-2.4.so.2: cannot open shared object file: No such file or directory
systemd[1]: mssql-server.service: Main process exited, code=exited, status=127/n/a
systemd[1]: mssql-server.service: Failed with result 'exit-code'.
systemd[1]: mssql-server.service: Scheduled restart job, restart counter is at 4.
systemd[1]: Stopped Microsoft SQL Server Database Engine.
systemd[1]: mssql-server.service: Start request repeated too quickly.
systemd[1]: mssql-server.service: Failed with result 'exit-code'.
systemd[1]: Failed to start Microsoft SQL Server Database Engine.
systemd[1]: Started Microsoft SQL Server Database Engine.
sqlservr[12022]: /opt/mssql/bin/sqlservr: error while loading shared libraries: liblber-2.4.so.2: cannot open shared object file: No such file or directory
systemd[1]: mssql-server.service: Main process exited, code=exited, status=127/n/a
systemd[1]: mssql-server.service: Failed with result 'exit-code'.

From root user i checked the LDAP version running on my machine

/usr/sbin/slapd -VV

The output was

@(#) $OpenLDAP: slapd 2.6.0 (Nov 13 2021 17:37:14) $
        openldap

It seems mssql-server 2019 package has dependency with older version of libldap<=2.4.59

Kindly help me resolve this issue.

---

Thanks,
Yuvaraj Velmurugan

Lone_Wolf

Administrator

From: Netherlands, Europe

Registered: 2005-10-04

Posts: 15,312

Re: Failed to start Microsoft SQL Server Database Engine

There is no mssql 2019 pacakge in repos or aur, but there is a mssql-server package.

Even if that's not what your using, check the comments on its aur page for hints how to solve this.

---

Disliking systemd intensely, but not satisfied with alternatives so focusing on taming systemd.

clean chroot building not flexible enough ?
Try clean chroot manager by graysky