Sqlserver 2022 lxc

pedro.toledo

Member
Oct 10, 2019
6
0
6
42
Hello,

I have a problem for using sqlserver 2022 with lxc in proxmox 7.3-3

I tryed add in kernel "systemd.unified_cgroup_hierarchy=0"
I tryed update of package pve-lxc

but nothing fix this problem.

I have other cluster with proxmox 6 and worked normally.

has anyone experienced this problem?

erros bellow:

This program has encountered a fatal error and cannot continue running at Thu Jan 12 02:09:26 2023
The following diagnostic information is available:

Reason: 0x00000001
Signal: SIGABRT - Aborted (6)
Stack:
IP Function
---------------- --------------------------------------
000055cc2e3e25b2 <unknown>
000055cc2e3e1fd0 <unknown>
000055cc2e3e166f <unknown>
00007fdd49186090 killpg+0x40
00007fdd4918600b gsignal+0xcb
00007fdd49165859 abort+0x12b
000055cc2e387f76 <unknown>
000055cc2e412eba <unknown>
Process: 20086 - sqlservr
Thread: 20091 (application thread 0x8)
Instance Id: 6c988dee-3942-4fa0-a572-f677df0cb0cb
Crash Id: e67f5f25-dcff-42d7-a323-4c235b9f854f
Build stamp: d81e9b6de06534e649bd57dd609aa3050f5e380f361b7f8a80a80eeb71e7422c
Distribution: Ubuntu 20.04.5 LTS
Processors: 16
Total Memory: 404153380864 bytes
Timestamp: Thu Jan 12 02:09:26 2023
Last errno: 2
Last errno text: No such file or directory
Capturing a dump of 20086
FAILED to capture a dump. Details in paldumper log.
Executing: /opt/mssql/bin/handle-crash.sh with parameters
handle-crash.sh
/opt/mssql/bin/sqlservr
20086
/opt/mssql/bin
/var/opt/mssql/log/

6c988dee-3942-4fa0-a572-f677df0cb0cb
e67f5f25-dcff-42d7-a323-4c235b9f854f



Ubuntu 20.04.5 LTS
Capturing core dump and information to /var/opt/mssql/log...
dmesg: read kernel buffer failed: Operation not permitted
Thu Jan 12 02:09:27 UTC 2023 Capturing program information
Thu Jan 12 02:09:27 UTC 2023 Attempting to capture a dump with paldumper for pid 20086
WARNING: Capture attempt failure detected
Attempting to capture a filtered dump with paldumper for pid 20086
Captured a filtered dump with paldumper
Thu Jan 12 02:09:27 UTC 2023 Capturing program binaries
Thu Jan 12 02:09:27 UTC 2023 Compressing the dump files
Core dump and information are being compressed in the background. When
complete, they can be found in the following location:
/var/opt/mssql/log/core.sqlservr.01_12_2023_02_09_26.20086.tbz2


Thanks for help.
 
Same problem here. After losing full day I had to reinstall VM from beginning.
I created new VM, installed fresh SQL server, moved volumes and everything was ok.

Now after 3 months it happens again.
 

About

The Proxmox community has been around for many years and offers help and support for Proxmox VE, Proxmox Backup Server, and Proxmox Mail Gateway.
We think our community is one of the best thanks to people like you!

Get your subscription!

The Proxmox team works very hard to make sure you are running the best software and getting stable updates and security enhancements, as well as quick enterprise support. Tens of thousands of happy customers have a Proxmox subscription. Get yours easily in our online shop.

Buy now!