mssqlserver无法启动:文章来源:https://www.toymoban.com/news/detail-516630.html
9月 25 09:00:59 bjca-db sqlservr[21339]: chmod: 更改"/var/opt/mssql/log/core.sqlservr.07_10_2022_01_00_09.26320.txt" 的权限: 不允许的操作
9月 25 09:00:59 bjca-db systemd[1]: mssql-server.service: main process exited, code=exited, status=1/FAILURE
9月 25 09:00:59 bjca-db systemd[1]: Unit mssql-server.service entered failed state.
9月 25 09:00:59 bjca-db systemd[1]: mssql-server.service failed.
9月 25 09:00:59 bjca-db systemd[1]: mssql-server.service holdoff time over, scheduling restart.
9月 25 09:00:59 bjca-db systemd[1]: Stopped Microsoft SQL Server Database Engine.
9月 25 09:00:59 bjca-db systemd[1]: Started Microsoft SQL Server Database Engine.
9月 25 09:01:00 bjca-db sqlservr[22243]: This program has encountered a fatal error and cannot continue running at Sun Sep 25 09:01:00 2022
9月 25 09:01:00 bjca-db sqlservr[22243]: The following diagnostic information is available:
9月 25 09:01:00 bjca-db sqlservr[22243]: Reason: 0x00000007
9月 25 09:01:00 bjca-db sqlservr[22243]: Status: 0xc0000022
9月 25 09:01:00 bjca-db sqlservr[22243]: Message: Access was denied setting up the persistent registry: \SystemRoot\licensing.hiv.
9月 25 09:01:00 bjca-db sqlservr[22243]: Stack Trace:
9月 25 09:01:00 bjca-db sqlservr[22243]: CentOS Linux 7 (Core)
9月 25 09:01:00 bjca-db sqlservr[22243]: Capturing core dump and information to /var/opt/mssql/log...
9月 25 09:01:01 bjca-db sqlservr[22243]: dmesg: --reltime 不能与 --ctime 选项同时使用
9月 25 09:01:01 bjca-db sqlservr[22243]: Hint: You are currently not seeing messages from other users and the system.
9月 25 09:01:01 bjca-db sqlservr[22243]: Users in the 'systemd-journal' group can see all messages. Pass -q to
9月 25 09:01:01 bjca-db sqlservr[22243]: turn off this notice.
9月 25 09:01:01 bjca-db sqlservr[22243]: No journal files were opened due to insufficient permissions.
9月 25 09:01:01 bjca-db sqlservr[22243]: Hint: You are currently not seeing messages from other users and the system.
9月 25 09:01:01 bjca-db sqlservr[22243]: Users in the 'systemd-journal' group can see all messages. Pass -q to
9月 25 09:01:01 bjca-db sqlservr[22243]: turn off this notice.
9月 25 09:01:01 bjca-db sqlservr[22243]: No journal files were opened due to insufficient permissions.
9月 25 09:01:01 bjca-db sqlservr[22243]: /usr/bin/tail: 无法打开"/var/log/messages" 读取数据: 权限不够
9月 25 09:01:01 bjca-db sqlservr[22243]: 2022年 09月 25日 星期日 09:01:01 CST Capturing program information
9月 25 09:01:02 bjca-db sqlservr[22243]: 2022年 09月 25日 星期日 09:01:02 CST Attempting to capture a dump with paldumper for pid 22246
9月 25 09:01:03 bjca-db sqlservr[22243]: Captured a dump with paldumper
9月 25 09:01:03 bjca-db sqlservr[22243]: 2022年 09月 25日 星期日 09:01:03 CST Capturing program binaries
9月 25 09:01:04 bjca-db sqlservr[22243]: /usr/bin/find: ‘/usr/share/polkit-1/rules.d’: 权限不够
9月 25 09:01:04 bjca-db sqlservr[22243]: /usr/bin/find: ‘/usr/libexec/initscripts/legacy-actions/auditd’: 权限不够
9月 25 09:01:04 bjca-db sqlservr[22243]: 2022年 09月 25日 星期日 09:01:04 CST Compressing the dump files
9月 25 09:01:04 bjca-db sqlservr[22243]: Core dump and information are being compressed in the background. When
9月 25 09:01:04 bjca-db sqlservr[22243]: complete, they can be found in the following location:
9月 25 09:01:04 bjca-db sqlservr[22243]: /var/opt/mssql/log/core.sqlservr.09_25_2022_09_01_00.22246.tbz2
9月 25 09:01:04 bjca-db systemd[1]: mssql-server.service: main process exited, code=exited, status=1/FAILURE
9月 25 09:01:04 bjca-db systemd[1]: Unit mssql-server.service entered failed state.
9月 25 09:01:04 bjca-db systemd[1]: mssql-server.service failed.
9月 25 09:01:04 bjca-db systemd[1]: mssql-server.service holdoff time over, scheduling restart.
9月 25 09:01:04 bjca-db systemd[1]: Stopped Microsoft SQL Server Database Engine.
9月 25 09:01:04 bjca-db systemd[1]: Started Microsoft SQL Server Database Engine.
9月 25 09:01:05 bjca-db sqlservr[23220]: This program has encountered a fatal error and cannot continue running at Sun Sep 25 09:01:05 2022
9月 25 09:01:05 bjca-db sqlservr[23220]: The following diagnostic information is available:
9月 25 09:01:05 bjca-db sqlservr[23220]: Reason: 0x00000007
9月 25 09:01:05 bjca-db sqlservr[23220]: Status: 0xc0000022
9月 25 09:01:05 bjca-db sqlservr[23220]: Message: Access was denied setting up the persistent registry: \SystemRoot\licensing.hiv.
9月 25 09:01:05 bjca-db sqlservr[23220]: Stack Trace:
9月 25 09:01:05 bjca-db sqlservr[23220]: file://package4/windows/system32/sqlpal.dll+0x000000000029697A
9月 25 09:01:05 bjca-db sqlservr[23220]: file://package4/windows/system32/sqlpal.dll+0x0000000000295BC0
9月 25 09:01:05 bjca-db sqlservr[23220]: file://package4/windows/system32/sqlpal.dll+0x0000000000293868
9月 25 09:01:05 bjca-db sqlservr[23220]: file://package4/windows/system32/sqlpal.dll+0x0000000000293A48
9月 25 09:01:05 bjca-db sqlservr[23220]: file://package4/windows/system32/sqlpal.dll+0x0000000000292A01
9月 25 09:01:05 bjca-db sqlservr[23220]: file://package4/windows/system32/sqlpal.dll+0x000000000029186C
9月 25 09:01:05 bjca-db sqlservr[23220]: file://package4/windows/system32/sqlpal.dll+0x0000000000388631
9月 25 09:01:05 bjca-db sqlservr[23220]: Process: 23245 - sqlservr
9月 25 09:01:05 bjca-db sqlservr[23220]: Thread: 23250 (application thread 0x8)
9月 25 09:01:05 bjca-db sqlservr[23220]: Instance Id: 185564a1-bfb7-4ebd-9bad-3d2d2b26fd04
9月 25 09:01:05 bjca-db sqlservr[23220]: Crash Id: 3fcf8def-e258-4a42-bb29-461b8f155fe8
9月 25 09:01:05 bjca-db sqlservr[23220]: Build stamp: c4ae858e5b9b6177096354e03007b2cc66ed6ea92fccf78fc71d2c87203bfcf4
9月 25 09:01:05 bjca-db sqlservr[23220]: Distribution: CentOS Linux 7 (Core)
9月 25 09:01:05 bjca-db sqlservr[23220]: Processors: 4
9月 25 09:01:05 bjca-db sqlservr[23220]: Total Memory: 8200859648 bytes
9月 25 09:01:05 bjca-db sqlservr[23220]: Timestamp: Sun Sep 25 09:01:05 2022
9月 25 09:01:05 bjca-db sqlservr[23220]: Last errno: 13
9月 25 09:01:05 bjca-db sqlservr[23220]: Last errno text: 权限不够
9月 25 09:01:05 bjca-db sqlservr[23220]: Executing: /opt/mssql/bin/handle-crash.sh with parameters
9月 25 09:01:05 bjca-db sqlservr[23220]: handle-crash.sh
9月 25 09:01:05 bjca-db sqlservr[23220]: /opt/mssql/bin/sqlservr
9月 25 09:01:05 bjca-db sqlservr[23220]: 23245
9月 25 09:01:05 bjca-db sqlservr[23220]: /opt/mssql/bin
9月 25 09:01:05 bjca-db sqlservr[23220]: /var/opt/mssql/log/
9月 25 09:01:05 bjca-db sqlservr[23220]: 185564a1-bfb7-4ebd-9bad-3d2d2b26fd04
9月 25 09:01:05 bjca-db sqlservr[23220]: 3fcf8def-e258-4a42-bb29-461b8f155fe8
9月 25 09:01:05 bjca-db sqlservr[23220]: CentOS Linux 7 (Core)
9月 25 09:01:05 bjca-db sqlservr[23220]: Capturing core dump and information to /var/opt/mssql/log...
9月 25 09:01:06 bjca-db sqlservr[23220]: dmesg: --reltime 不能与 --ctime 选项同时使用
9月 25 09:01:06 bjca-db sqlservr[23220]: Hint: You are currently not seeing messages from other users and the system.
9月 25 09:01:06 bjca-db sqlservr[23220]: Users in the 'systemd-journal' group can see all messages. Pass -q to
9月 25 09:01:06 bjca-db sqlservr[23220]: turn off this notice.
9月 25 09:01:06 bjca-db sqlservr[23220]: No journal files were opened due to insufficient permissions.
9月 25 09:01:06 bjca-db sqlservr[23220]: Hint: You are currently not seeing messages from other users and the system.
9月 25 09:01:06 bjca-db sqlservr[23220]: Users in the 'systemd-journal' group can see all messages. Pass -q to
9月 25 09:01:06 bjca-db sqlservr[23220]: turn off this notice.
9月 25 09:01:06 bjca-db sqlservr[23220]: No journal files were opened due to insufficient permissions.
9月 25 09:01:06 bjca-db sqlservr[23220]: /usr/bin/tail: 无法打开"/var/log/messages" 读取数据: 权限不够
9月 25 09:01:06 bjca-db sqlservr[23220]: 2022年 09月 25日 星期日 09:01:06 CST Capturing program information
9月 25 09:01:06 bjca-db sqlservr[23220]: 2022年 09月 25日 星期日 09:01:06 CST Attempting to capture a dump with paldumper for pid 23245
9月 25 09:01:08 bjca-db sqlservr[23220]: Captured a dump with paldumper
9月 25 09:01:08 bjca-db sqlservr[23220]: 2022年 09月 25日 星期日 09:01:08 CST Capturing program binaries
9月 25 09:01:08 bjca-db sqlservr[23220]: /usr/bin/find: ‘/usr/share/polkit-1/rules.d’: 权限不够
9月 25 09:01:08 bjca-db sqlservr[23220]: /usr/bin/find: ‘/usr/libexec/initscripts/legacy-actions/auditd’: 权限不够
9月 25 09:01:08 bjca-db sqlservr[23220]: 2022年 09月 25日 星期日 09:01:08 CST Compressing the dump files
9月 25 09:01:08 bjca-db sqlservr[23220]: Core dump and information are being compressed in the background. When
9月 25 09:01:08 bjca-db sqlservr[23220]: complete, they can be found in the following location:
9月 25 09:01:08 bjca-db sqlservr[23220]: /var/opt/mssql/log/core.sqlservr.09_25_2022_09_01_05.23245.tbz2
9月 25 09:01:08 bjca-db sqlservr[23220]: chmod: 更改"/var/opt/mssql/log/core.sqlservr.07_10_2022_01_00_09.26320.json" 的权限: 不允许的操作
9月 25 09:01:08 bjca-db systemd[1]: mssql-server.service: main process exited, code=exited, status=1/FAILURE
9月 25 09:01:08 bjca-db systemd[1]: Unit mssql-server.service entered failed state.
9月 25 09:01:08 bjca-db systemd[1]: mssql-server.service failed.
9月 25 09:01:08 bjca-db systemd[1]: mssql-server.service holdoff time over, scheduling restart.
9月 25 09:01:08 bjca-db systemd[1]: Stopped Microsoft SQL Server Database Engine.
9月 25 09:01:08 bjca-db systemd[1]: start request repeated too quickly for mssql-server.service
9月 25 09:01:08 bjca-db systemd[1]: Failed to start Microsoft SQL Server Database Engine.
9月 25 09:01:08 bjca-db systemd[1]: Unit mssql-server.service entered failed state.
9月 25 09:01:08 bjca-db systemd[1]: mssql-server.service failed.
9月 25 09:02:20 bjca-db systemd[1]: start request repeated too quickly for mssql-server.service
9月 25 09:02:20 bjca-db systemd[1]: Failed to start Microsoft SQL Server Database Engine.
9月 25 09:02:20 bjca-db systemd[1]: mssql-server.service failed.
9月 25 09:02:31 bjca-db systemd[1]: start request repeated too quickly for mssql-server.service
9月 25 09:02:31 bjca-db systemd[1]: Failed to start Microsoft SQL Server Database Engine.
9月 25 09:02:31 bjca-db systemd[1]: mssql-server.service failed.
9月 25 09:02:55 bjca-db systemd[1]: start request repeated too quickly for mssql-server.service
9月 25 09:02:55 bjca-db systemd[1]: Failed to start Microsoft SQL Server Database Engine.
9月 25 09:02:55 bjca-db systemd[1]: mssql-server.service failed.
9月 25 12:04:36 bjca-db systemd[1]: Started Microsoft SQL Server Database Engine.
9月 25 12:04:36 bjca-db sqlservr[14912]: This program has encountered a fatal error and cannot continue running at Sun Sep 25 12:04:36 2022
9月 25 12:04:36 bjca-db sqlservr[14912]: The following diagnostic information is available:
9月 25 12:04:36 bjca-db sqlservr[14912]: Reason: 0x00000007
9月 25 12:04:36 bjca-db sqlservr[14912]: Status: 0xc0000022
9月 25 12:04:36 bjca-db sqlservr[14912]: Message: Access was denied setting up the persistent registry: \SystemRoot\licensing.hiv.
9月 25 12:04:36 bjca-db sqlservr[14912]: Stack Trace:
9月 25 12:04:36 bjca-db sqlservr[14912]: file://package4/windows/system32/sqlpal.dll+0x000000000029697A
9月 25 12:04:36 bjca-db sqlservr[14912]: file://package4/windows/system32/sqlpal.dll+0x0000000000295BC0
9月 25 12:04:36 bjca-db sqlservr[14912]: file://package4/windows/system32/sqlpal.dll+0x0000000000293868
9月 25 12:04:36 bjca-db sqlservr[14912]: file://package4/windows/system32/sqlpal.dll+0x0000000000293A48
9月 25 12:04:36 bjca-db sqlservr[14912]: file://package4/windows/system32/sqlpal.dll+0x0000000000292A01
9月 25 12:04:36 bjca-db sqlservr[14912]: file://package4/windows/system32/sqlpal.dll+0x000000000029186C
9月 25 12:04:36 bjca-db sqlservr[14912]: file://package4/windows/system32/sqlpal.dll+0x0000000000388631
9月 25 12:04:36 bjca-db sqlservr[14912]: Process: 15183 - sqlservr
9月 25 12:04:36 bjca-db sqlservr[14912]: Thread: 15209 (application thread 0x8)
9月 25 12:04:36 bjca-db sqlservr[14912]: Instance Id: 185564a1-bfb7-4ebd-9bad-3d2d2b26fd04
9月 25 12:04:36 bjca-db sqlservr[14912]: Crash Id: 0c7cd059-efd6-4b02-948f-4af49701253b
9月 25 12:04:36 bjca-db sqlservr[14912]: Build stamp: c4ae858e5b9b6177096354e03007b2cc66ed6ea92fccf78fc71d2c87203bfcf4
9月 25 12:04:36 bjca-db sqlservr[14912]: Distribution: CentOS Linux 7 (Core)
9月 25 12:04:36 bjca-db sqlservr[14912]: Processors: 4
9月 25 12:04:36 bjca-db sqlservr[14912]: Total Memory: 8200859648 bytes
9月 25 12:04:36 bjca-db sqlservr[14912]: Timestamp: Sun Sep 25 12:04:36 2022
9月 25 12:04:36 bjca-db sqlservr[14912]: Last errno: 13
9月 25 12:04:36 bjca-db sqlservr[14912]: Last errno text: 权限不够
9月 25 12:04:36 bjca-db sqlservr[14912]: Executing: /opt/mssql/bin/handle-crash.sh with parameters
9月 25 12:04:36 bjca-db sqlservr[14912]: handle-crash.sh
9月 25 12:04:36 bjca-db sqlservr[14912]: /opt/mssql/bin/sqlservr
9月 25 12:04:36 bjca-db sqlservr[14912]: 15183
9月 25 12:04:36 bjca-db sqlservr[14912]: /opt/mssql/bin
9月 25 12:04:36 bjca-db sqlservr[14912]: /var/opt/mssql/log/
9月 25 12:04:36 bjca-db sqlservr[14912]: 185564a1-bfb7-4ebd-9bad-3d2d2b26fd04
9月 25 12:04:36 bjca-db sqlservr[14912]: 0c7cd059-efd6-4b02-948f-4af49701253b
9月 25 12:04:36 bjca-db sqlservr[14912]: CentOS Linux 7 (Core)
9月 25 12:04:36 bjca-db sqlservr[14912]: Capturing core dump and information to /var/opt/mssql/log...
9月 25 12:04:38 bjca-db sqlservr[14912]: dmesg: --reltime 不能与 --ctime 选项同时使用
9月 25 12:04:38 bjca-db sqlservr[14912]: Hint: You are currently not seeing messages from other users and the system.
9月 25 12:04:38 bjca-db sqlservr[14912]: Users in the 'systemd-journal' group can see all messages. Pass -q to
9月 25 12:04:38 bjca-db sqlservr[14912]: turn off this notice.
9月 25 12:04:38 bjca-db sqlservr[14912]: No journal files were opened due to insufficient permissions.
9月 25 12:04:38 bjca-db sqlservr[14912]: Hint: You are currently not seeing messages from other users and the system.
9月 25 12:04:38 bjca-db sqlservr[14912]: Users in the 'systemd-journal' group can see all messages. Pass -q to
9月 25 12:04:38 bjca-db sqlservr[14912]: turn off this notice.
9月 25 12:04:38 bjca-db sqlservr[14912]: No journal files were opened due to insufficient permissions.
9月 25 12:04:38 bjca-db sqlservr[14912]: /usr/bin/tail: 无法打开"/var/log/messages" 读取数据: 权限不够
9月 25 12:04:38 bjca-db sqlservr[14912]: 2022年 09月 25日 星期日 12:04:38 CST Capturing program information
9月 25 12:04:38 bjca-db sqlservr[14912]: 2022年 09月 25日 星期日 12:04:38 CST Attempting to capture a dump with paldumper for pid 15183
9月 25 12:04:39 bjca-db sqlservr[14912]: Captured a dump with paldumper
9月 25 12:04:39 bjca-db sqlservr[14912]: 2022年 09月 25日 星期日 12:04:39 CST Capturing program binaries
9月 25 12:04:39 bjca-db sqlservr[14912]: /usr/bin/find: ‘/usr/share/polkit-1/rules.d’: 权限不够
9月 25 12:04:39 bjca-db sqlservr[14912]: /usr/bin/find: ‘/usr/libexec/initscripts/legacy-actions/auditd’: 权限不够
9月 25 12:04:39 bjca-db sqlservr[14912]: 2022年 09月 25日 星期日 12:04:39 CST Compressing the dump files
9月 25 12:04:39 bjca-db sqlservr[14912]: Core dump and information are being compressed in the background. When
9月 25 12:04:39 bjca-db sqlservr[14912]: complete, they can be found in the following location:
9月 25 12:04:39 bjca-db sqlservr[14912]: /var/opt/mssql/log/core.sqlservr.09_25_2022_12_04_36.15183.tbz2
9月 25 12:04:39 bjca-db sqlservr[14912]: chmod: 更改"/var/opt/mssql/log/core.sqlservr.07_10_2022_01_00_09.26320.json" 的权限: 不允许的操作
9月 25 12:04:39 bjca-db sqlservr[14912]: chmod: 更改"/var/opt/mssql/log/core.sqlservr.07_10_2022_01_00_09.26320.tbz2" 的权限: 不允许的操作
9月 25 12:04:39 bjca-db systemd[1]: mssql-server.service: main process exited, code=exited, status=1/FAILURE
9月 25 12:04:39 bjca-db systemd[1]: Unit mssql-server.service entered failed state.
9月 25 12:04:39 bjca-db systemd[1]: mssql-server.service failed.
9月 25 12:04:39 bjca-db systemd[1]: mssql-server.service holdoff time over, scheduling restart.
9月 25 12:04:39 bjca-db systemd[1]: Stopped Microsoft SQL Server Database Engine.
9月 25 12:04:39 bjca-db systemd[1]: Started Microsoft SQL Server Database Engine.
9月 25 12:04:40 bjca-db sqlservr[15953]: This program has encountered a fatal error and cannot continue running at Sun Sep 25 12:04:40 2022
9月 25 12:04:40 bjca-db sqlservr[15953]: The following diagnostic information is available:
9月 25 12:04:40 bjca-db sqlservr[15953]: Reason: 0x00000007
9月 25 12:04:40 bjca-db sqlservr[15953]: Status: 0xc0000022
9月 25 12:04:40 bjca-db sqlservr[15953]: Message: Access was denied setting up the persistent registry: \SystemRoot\licensing.hiv.
9月 25 12:04:40 bjca-db sqlservr[15953]: Stack Trace:
9月 25 12:04:40 bjca-db sqlservr[15953]: file://package4/windows/system32/sqlpal.dll+0x000000000029697A
9月 25 12:04:40 bjca-db sqlservr[15953]: file://package4/windows/system32/sqlpal.dll+0x0000000000295BC0
9月 25 12:04:40 bjca-db sqlservr[15953]: file://package4/windows/system32/sqlpal.dll+0x0000000000293868
9月 25 12:04:40 bjca-db sqlservr[15953]: file://package4/windows/system32/sqlpal.dll+0x0000000000293A48
9月 25 12:04:40 bjca-db sqlservr[15953]: file://package4/windows/system32/sqlpal.dll+0x0000000000292A01
9月 25 12:04:40 bjca-db sqlservr[15953]: file://package4/windows/system32/sqlpal.dll+0x000000000029186C
9月 25 12:04:40 bjca-db sqlservr[15953]: file://package4/windows/system32/sqlpal.dll+0x0000000000388631
9月 25 12:04:40 bjca-db sqlservr[15953]: Process: 15958 - sqlservr
9月 25 12:04:40 bjca-db sqlservr[15953]: Thread: 15963 (application thread 0x8)
9月 25 12:04:40 bjca-db sqlservr[15953]: Instance Id: 185564a1-bfb7-4ebd-9bad-3d2d2b26fd04
9月 25 12:04:40 bjca-db sqlservr[15953]: Crash Id: 0497216e-67c6-4f71-a7c9-e76f703e4775
9月 25 12:04:40 bjca-db sqlservr[15953]: Build stamp: c4ae858e5b9b6177096354e03007b2cc66ed6ea92fccf78fc71d2c87203bfcf4
9月 25 12:04:40 bjca-db sqlservr[15953]: Distribution: CentOS Linux 7 (Core)
9月 25 12:04:40 bjca-db sqlservr[15953]: Processors: 4
9月 25 12:04:40 bjca-db sqlservr[15953]: Total Memory: 8200859648 bytes
9月 25 12:04:40 bjca-db sqlservr[15953]: Timestamp: Sun Sep 25 12:04:40 2022
9月 25 12:04:40 bjca-db sqlservr[15953]: Last errno: 13
9月 25 12:04:40 bjca-db sqlservr[15953]: Last errno text: 权限不够
9月 25 12:04:40 bjca-db sqlservr[15953]: Executing: /opt/mssql/bin/handle-crash.sh with parameters
9月 25 12:04:40 bjca-db sqlservr[15953]: handle-crash.sh
9月 25 12:04:40 bjca-db sqlservr[15953]: /opt/mssql/bin/sqlservr
9月 25 12:04:40 bjca-db sqlservr[15953]: 15958
9月 25 12:04:40 bjca-db sqlservr[15953]: /opt/mssql/bin
9月 25 12:04:40 bjca-db sqlservr[15953]: /var/opt/mssql/log/
9月 25 12:04:40 bjca-db sqlservr[15953]: 185564a1-bfb7-4ebd-9bad-3d2d2b26fd04
9月 25 12:04:40 bjca-db sqlservr[15953]: 0497216e-67c6-4f71-a7c9-e76f703e4775
9月 25 12:04:40 bjca-db sqlservr[15953]: CentOS Linux 7 (Core)
9月 25 12:04:40 bjca-db sqlservr[15953]: Capturing core dump and information to /var/opt/mssql/log...
9月 25 12:04:42 bjca-db sqlservr[15953]: dmesg: --reltime 不能与 --ctime 选项同时使用
9月 25 12:04:42 bjca-db sqlservr[15953]: Hint: You are currently not seeing messages from other users and the system.
9月 25 12:04:42 bjca-db sqlservr[15953]: Users in the 'systemd-journal' group can see all messages. Pass -q to
9月 25 12:04:42 bjca-db sqlservr[15953]: turn off this notice.
9月 25 12:04:42 bjca-db sqlservr[15953]: No journal files were opened due to insufficient permissions.
9月 25 12:04:42 bjca-db sqlservr[15953]: Hint: You are currently not seeing messages from other users and the system.
9月 25 12:04:42 bjca-db sqlservr[15953]: Users in the 'systemd-journal' group can see all messages. Pass -q to
9月 25 12:04:42 bjca-db sqlservr[15953]: turn off this notice.
9月 25 12:04:42 bjca-db sqlservr[15953]: No journal files were opened due to insufficient permissions.
9月 25 12:04:42 bjca-db sqlservr[15953]: /usr/bin/tail: 无法打开"/var/log/messages" 读取数据: 权限不够
9月 25 12:04:42 bjca-db sqlservr[15953]: 2022年 09月 25日 星期日 12:04:42 CST Capturing program information
9月 25 12:04:42 bjca-db sqlservr[15953]: 2022年 09月 25日 星期日 12:04:42 CST Attempting to capture a dump with paldumper for pid 15958
9月 25 12:04:43 bjca-db sqlservr[15953]: Captured a dump with paldumper
9月 25 12:04:43 bjca-db sqlservr[15953]: 2022年 09月 25日 星期日 12:04:43 CST Capturing program binaries
9月 25 12:04:43 bjca-db sqlservr[15953]: /usr/bin/find: ‘/usr/share/polkit-1/rules.d’: 权限不够
9月 25 12:04:43 bjca-db sqlservr[15953]: /usr/bin/find: ‘/usr/libexec/initscripts/legacy-actions/auditd’: 权限不够
9月 25 12:04:43 bjca-db sqlservr[15953]: 2022年 09月 25日 星期日 12:04:43 CST Compressing the dump files
9月 25 12:04:43 bjca-db sqlservr[15953]: Core dump and information are being compressed in the background. When
9月 25 12:04:43 bjca-db sqlservr[15953]: complete, they can be found in the following location:
9月 25 12:04:43 bjca-db sqlservr[15953]: /var/opt/mssql/log/core.sqlservr.09_25_2022_12_04_40.15958.tbz2
9月 25 12:04:43 bjca-db sqlservr[15953]: chmod: 更改"/var/opt/mssql/log/core.sqlservr.07_10_2022_01_00_09.26320.json" 的权限: 不允许的操作
9月 25 12:04:43 bjca-db sqlservr[15953]: chmod: 更改"/var/opt/mssql/log/core.sqlservr.07_10_2022_01_00_09.26320.tbz2" 的权限: 不允许的操作
9月 25 12:04:43 bjca-db sqlservr[15953]: chmod: 更改"/var/opt/mssql/log/core.sqlservr.07_10_2022_01_00_09.26320.txt" 的权限: 不允许的操作
9月 25 12:04:43 bjca-db systemd[1]: mssql-server.service: main process exited, code=exited, status=1/FAILURE
9月 25 12:04:43 bjca-db systemd[1]: Unit mssql-server.service entered failed state.
9月 25 12:04:43 bjca-db systemd[1]: mssql-server.service failed.
9月 25 12:04:43 bjca-db systemd[1]: mssql-server.service holdoff time over, scheduling restart.
9月 25 12:04:43 bjca-db systemd[1]: Stopped Microsoft SQL Server Database Engine.
9月 25 12:04:43 bjca-db systemd[1]: Started Microsoft SQL Server Database Engine.
9月 25 12:04:44 bjca-db sqlservr[16860]: This program has encountered a fatal error and cannot continue running at Sun Sep 25 12:04:44 2022
9月 25 12:04:44 bjca-db sqlservr[16860]: The following diagnostic information is available:
9月 25 12:04:44 bjca-db sqlservr[16860]: Reason: 0x00000007
9月 25 12:04:44 bjca-db sqlservr[16860]: Status: 0xc0000022
9月 25 12:04:44 bjca-db sqlservr[16860]: Message: Access was denied setting up the persistent registry: \SystemRoot\licensing.hiv.
9月 25 12:04:44 bjca-db sqlservr[16860]: Stack Trace:
9月 25 12:04:44 bjca-db sqlservr[16860]: file://package4/windows/system32/sqlpal.dll+0x000000000029697A
9月 25 12:04:44 bjca-db sqlservr[16860]: file://package4/windows/system32/sqlpal.dll+0x0000000000295BC0
9月 25 12:04:44 bjca-db sqlservr[16860]: file://package4/windows/system32/sqlpal.dll+0x0000000000293868
9月 25 12:04:44 bjca-db sqlservr[16860]: file://package4/windows/system32/sqlpal.dll+0x0000000000293A48
9月 25 12:04:44 bjca-db sqlservr[16860]: file://package4/windows/system32/sqlpal.dll+0x0000000000292A01
9月 25 12:04:44 bjca-db sqlservr[16860]: file://package4/windows/system32/sqlpal.dll+0x000000000029186C
9月 25 12:04:44 bjca-db sqlservr[16860]: file://package4/windows/system32/sqlpal.dll+0x0000000000388631
9月 25 12:04:44 bjca-db sqlservr[16860]: Process: 16864 - sqlservr
9月 25 12:04:44 bjca-db sqlservr[16860]: Thread: 16869 (application thread 0x8)
9月 25 12:04:44 bjca-db sqlservr[16860]: Instance Id: 185564a1-bfb7-4ebd-9bad-3d2d2b26fd04
9月 25 12:04:44 bjca-db sqlservr[16860]: Crash Id: e69b2a64-21cd-4548-bbd8-6c6b8a6f4cd0
9月 25 12:04:44 bjca-db sqlservr[16860]: Build stamp: c4ae858e5b9b6177096354e03007b2cc66ed6ea92fccf78fc71d2c87203bfcf4
9月 25 12:04:44 bjca-db sqlservr[16860]: Distribution: CentOS Linux 7 (Core)
9月 25 12:04:44 bjca-db sqlservr[16860]: Processors: 4
9月 25 12:04:44 bjca-db sqlservr[16860]: Total Memory: 8200859648 bytes
9月 25 12:04:44 bjca-db sqlservr[16860]: Timestamp: Sun Sep 25 12:04:44 2022
9月 25 12:04:44 bjca-db sqlservr[16860]: Last errno: 13
9月 25 12:04:44 bjca-db sqlservr[16860]: Last errno text: 权限不够
9月 25 12:04:44 bjca-db sqlservr[16860]: Executing: /opt/mssql/bin/handle-crash.sh with parameters
9月 25 12:04:44 bjca-db sqlservr[16860]: handle-crash.sh
9月 25 12:04:44 bjca-db sqlservr[16860]: /opt/mssql/bin/sqlservr
9月 25 12:04:44 bjca-db sqlservr[16860]: 16864
9月 25 12:04:44 bjca-db sqlservr[16860]: /opt/mssql/bin
9月 25 12:04:44 bjca-db sqlservr[16860]: /var/opt/mssql/log/
9月 25 12:04:44 bjca-db sqlservr[16860]: 185564a1-bfb7-4ebd-9bad-3d2d2b26fd04
9月 25 12:04:44 bjca-db sqlservr[16860]: e69b2a64-21cd-4548-bbd8-6c6b8a6f4cd0
9月 25 12:04:44 bjca-db sqlservr[16860]: CentOS Linux 7 (Core)
9月 25 12:04:44 bjca-db sqlservr[16860]: Capturing core dump and information to /var/opt/mssql/log...
9月 25 12:04:46 bjca-db sqlservr[16860]: dmesg: --reltime 不能与 --ctime 选项同时使用
9月 25 12:04:46 bjca-db sqlservr[16860]: Hint: You are currently not seeing messages from other users and the system.
9月 25 12:04:46 bjca-db sqlservr[16860]: Users in the 'systemd-journal' group can see all messages. Pass -q to
9月 25 12:04:46 bjca-db sqlservr[16860]: turn off this notice.
9月 25 12:04:46 bjca-db sqlservr[16860]: No journal files were opened due to insufficient permissions.
9月 25 12:04:46 bjca-db sqlservr[16860]: Hint: You are currently not seeing messages from other users and the system.
9月 25 12:04:46 bjca-db sqlservr[16860]: Users in the 'systemd-journal' group can see all messages. Pass -q to
9月 25 12:04:46 bjca-db sqlservr[16860]: turn off this notice.
9月 25 12:04:46 bjca-db sqlservr[16860]: No journal files were opened due to insufficient permissions.
9月 25 12:04:46 bjca-db sqlservr[16860]: /usr/bin/tail: 无法打开"/var/log/messages" 读取数据: 权限不够
9月 25 12:04:46 bjca-db sqlservr[16860]: 2022年 09月 25日 星期日 12:04:46 CST Capturing program information
9月 25 12:04:46 bjca-db sqlservr[16860]: 2022年 09月 25日 星期日 12:04:46 CST Attempting to capture a dump with paldumper for pid 16864
9月 25 12:04:47 bjca-db sqlservr[16860]: Captured a dump with paldumper
9月 25 12:04:47 bjca-db sqlservr[16860]: 2022年 09月 25日 星期日 12:04:47 CST Capturing program binaries
9月 25 12:04:48 bjca-db sqlservr[16860]: /usr/bin/find: ‘/usr/share/polkit-1/rules.d’: 权限不够
9月 25 12:04:48 bjca-db sqlservr[16860]: /usr/bin/find: ‘/usr/libexec/initscripts/legacy-actions/auditd’: 权限不够
9月 25 12:04:48 bjca-db sqlservr[16860]: 2022年 09月 25日 星期日 12:04:48 CST Compressing the dump files
9月 25 12:04:48 bjca-db sqlservr[16860]: Core dump and information are being compressed in the background. When
9月 25 12:04:48 bjca-db sqlservr[16860]: complete, they can be found in the following location:
9月 25 12:04:48 bjca-db sqlservr[16860]: /var/opt/mssql/log/core.sqlservr.09_25_2022_12_04_44.16864.tbz2
9月 25 12:04:48 bjca-db sqlservr[16860]: chmod: 更改"/var/opt/mssql/log/core.sqlservr.07_10_2022_01_00_09.26320.json" 的权限: 不允许的操作
9月 25 12:04:48 bjca-db sqlservr[16860]: chmod: 更改"/var/opt/mssql/log/core.sqlservr.07_10_2022_01_00_09.26320.tbz2" 的权限: 不允许的操作
9月 25 12:04:48 bjca-db sqlservr[16860]: chmod: 更改"/var/opt/mssql/log/core.sqlservr.07_10_2022_01_00_09.26320.txt" 的权限: 不允许的操作
9月 25 12:04:48 bjca-db systemd[1]: mssql-server.service: main process exited, code=exited, status=1/FAILURE
9月 25 12:04:48 bjca-db systemd[1]: Unit mssql-server.service entered failed state.
9月 25 12:04:48 bjca-db systemd[1]: mssql-server.service failed.
9月 25 12:04:48 bjca-db systemd[1]: mssql-server.service holdoff time over, scheduling restart.
9月 25 12:04:48 bjca-db systemd[1]: Stopped Microsoft SQL Server Database Engine.
9月 25 12:04:48 bjca-db systemd[1]: start request repeated too quickly for mssql-server.service
9月 25 12:04:48 bjca-db systemd[1]: Failed to start Microsoft SQL Server Database Engine.
9月 25 12:04:48 bjca-db systemd[1]: Unit mssql-server.service entered failed state.
9月 25 12:04:48 bjca-db systemd[1]: mssql-server.service failed.
9月 25 12:05:23 bjca-db systemd[1]: start request repeated too quickly for mssql-server.service
9月 25 12:05:23 bjca-db systemd[1]: Failed to start Microsoft SQL Server Database Engine.
9月 25 12:05:23 bjca-db systemd[1]: mssql-server.service failed.
9月 25 12:10:00 bjca-db systemd[1]: Started Microsoft SQL Server Database Engine.
9月 25 12:10:01 bjca-db sqlservr[13303]: This program has encountered a fatal error and cannot continue running at Sun Sep 25 12:10:01 2022
9月 25 12:10:01 bjca-db sqlservr[13303]: The following diagnostic information is available:
9月 25 12:10:01 bjca-db sqlservr[13303]: Reason: 0x00000007
9月 25 12:10:01 bjca-db sqlservr[13303]: Status: 0xc0000022
9月 25 12:10:01 bjca-db sqlservr[13303]: Message: Access was denied setting up the persistent registry: \SystemRoot\licensing.hiv.
9月 25 12:10:01 bjca-db sqlservr[13303]: Stack Trace:
9月 25 12:10:01 bjca-db sqlservr[13303]: file://package4/windows/system32/sqlpal.dll+0x000000000029697A
9月 25 12:10:01 bjca-db sqlservr[13303]: file://package4/windows/system32/sqlpal.dll+0x0000000000295BC0
9月 25 12:10:01 bjca-db sqlservr[13303]: file://package4/windows/system32/sqlpal.dll+0x0000000000293868
9月 25 12:10:01 bjca-db sqlservr[13303]: file://package4/windows/system32/sqlpal.dll+0x0000000000293A48
9月 25 12:10:01 bjca-db sqlservr[13303]: file://package4/windows/system32/sqlpal.dll+0x0000000000292A01
9月 25 12:10:01 bjca-db sqlservr[13303]: file://package4/windows/system32/sqlpal.dll+0x000000000029186C
9月 25 12:10:01 bjca-db sqlservr[13303]: file://package4/windows/system32/sqlpal.dll+0x0000000000388631
9月 25 12:10:01 bjca-db sqlservr[13303]: Process: 13326 - sqlservr
9月 25 12:10:01 bjca-db sqlservr[13303]: Thread: 13331 (application thread 0x8)
9月 25 12:10:01 bjca-db sqlservr[13303]: Instance Id: 185564a1-bfb7-4ebd-9bad-3d2d2b26fd04
9月 25 12:10:01 bjca-db sqlservr[13303]: Crash Id: 6268bde7-3579-4553-b690-b1ac75e23768
9月 25 12:10:01 bjca-db sqlservr[13303]: Build stamp: c4ae858e5b9b6177096354e03007b2cc66ed6ea92fccf78fc71d2c87203bfcf4
9月 25 12:10:01 bjca-db sqlservr[13303]: Distribution: CentOS Linux 7 (Core)
9月 25 12:10:01 bjca-db sqlservr[13303]: Processors: 4
9月 25 12:10:01 bjca-db sqlservr[13303]: Total Memory: 8200859648 bytes
9月 25 12:10:01 bjca-db sqlservr[13303]: Timestamp: Sun Sep 25 12:10:01 2022
9月 25 12:10:01 bjca-db sqlservr[13303]: Last errno: 13
9月 25 12:10:01 bjca-db sqlservr[13303]: Last errno text: 权限不够
9月 25 12:10:01 bjca-db sqlservr[13303]: Executing: /opt/mssql/bin/handle-crash.sh with parameters
9月 25 12:10:01 bjca-db sqlservr[13303]: handle-crash.sh
9月 25 12:10:01 bjca-db sqlservr[13303]: /opt/mssql/bin/sqlservr
9月 25 12:10:01 bjca-db sqlservr[13303]: 13326
9月 25 12:10:01 bjca-db sqlservr[13303]: /opt/mssql/bin
9月 25 12:10:01 bjca-db sqlservr[13303]: /var/opt/mssql/log/
9月 25 12:10:01 bjca-db sqlservr[13303]: 185564a1-bfb7-4ebd-9bad-3d2d2b26fd04
9月 25 12:10:01 bjca-db sqlservr[13303]: 6268bde7-3579-4553-b690-b1ac75e23768
9月 25 12:10:01 bjca-db sqlservr[13303]: CentOS Linux 7 (Core)
9月 25 12:10:01 bjca-db sqlservr[13303]: Capturing core dump and information to /var/opt/mssql/log...
9月 25 12:10:03 bjca-db sqlservr[13303]: dmesg: --reltime 不能与 --ctime 选项同时使用
9月 25 12:10:03 bjca-db sqlservr[13303]: Hint: You are currently not seeing messages from other users and the system.
9月 25 12:10:03 bjca-db sqlservr[13303]: Users in the 'systemd-journal' group can see all messages. Pass -q to
9月 25 12:10:03 bjca-db sqlservr[13303]: turn off this notice.
9月 25 12:10:03 bjca-db sqlservr[13303]: No journal files were opened due to insufficient permissions.
9月 25 12:10:03 bjca-db sqlservr[13303]: Hint: You are currently not seeing messages from other users and the system.
9月 25 12:10:03 bjca-db sqlservr[13303]: Users in the 'systemd-journal' group can see all messages. Pass -q to
9月 25 12:10:03 bjca-db sqlservr[13303]: turn off this notice.
9月 25 12:10:03 bjca-db sqlservr[13303]: No journal files were opened due to insufficient permissions.
9月 25 12:10:03 bjca-db sqlservr[13303]: 2022年 09月 25日 星期日 12:10:03 CST Capturing program information
9月 25 12:10:03 bjca-db sqlservr[13303]: 2022年 09月 25日 星期日 12:10:03 CST Attempting to capture a dump with paldumper for pid 13326
9月 25 12:10:04 bjca-db sqlservr[13303]: Captured a dump with paldumper
9月 25 12:10:04 bjca-db sqlservr[13303]: 2022年 09月 25日 星期日 12:10:04 CST Capturing program binaries
9月 25 12:10:04 bjca-db sqlservr[13303]: /usr/bin/find: ‘/usr/share/polkit-1/rules.d’: 权限不够
9月 25 12:10:04 bjca-db sqlservr[13303]: /usr/bin/find: ‘/usr/libexec/initscripts/legacy-actions/auditd’: 权限不够
9月 25 12:10:04 bjca-db sqlservr[13303]: 2022年 09月 25日 星期日 12:10:04 CST Compressing the dump files
9月 25 12:10:04 bjca-db sqlservr[13303]: Core dump and information are being compressed in the background. When
9月 25 12:10:04 bjca-db sqlservr[13303]: complete, they can be found in the following location:
9月 25 12:10:04 bjca-db sqlservr[13303]: /var/opt/mssql/log/core.sqlservr.09_25_2022_12_10_01.13326.tbz2
9月 25 12:10:04 bjca-db systemd[1]: mssql-server.service: main process exited, code=exited, status=1/FAILURE
9月 25 12:10:04 bjca-db systemd[1]: Unit mssql-server.service entered failed state.
9月 25 12:10:04 bjca-db systemd[1]: mssql-server.service failed.
9月 25 12:10:04 bjca-db systemd[1]: mssql-server.service holdoff time over, scheduling restart.
9月 25 12:10:04 bjca-db systemd[1]: Stopped Microsoft SQL Server Database Engine.
9月 25 12:10:04 bjca-db systemd[1]: Started Microsoft SQL Server Database Engine.
9月 25 12:10:05 bjca-db sqlservr[14233]: This program has encountered a fatal error and cannot continue running at Sun Sep 25 12:10:05 2022
9月 25 12:10:05 bjca-db sqlservr[14233]: The following diagnostic information is available:
9月 25 12:10:05 bjca-db sqlservr[14233]: Reason: 0x00000007
9月 25 12:10:05 bjca-db sqlservr[14233]: Status: 0xc0000022
9月 25 12:10:05 bjca-db sqlservr[14233]: Message: Access was denied setting up the persistent registry: \SystemRoot\licensing.hiv.
9月 25 12:10:05 bjca-db sqlservr[14233]: Stack Trace:
9月 25 12:10:05 bjca-db sqlservr[14233]: file://package4/windows/system32/sqlpal.dll+0x000000000029697A
9月 25 12:10:05 bjca-db sqlservr[14233]: file://package4/windows/system32/sqlpal.dll+0x0000000000295BC0
9月 25 12:10:05 bjca-db sqlservr[14233]: file://package4/windows/system32/sqlpal.dll+0x0000000000293868
9月 25 12:10:05 bjca-db sqlservr[14233]: file://package4/windows/system32/sqlpal.dll+0x0000000000293A48
9月 25 12:10:05 bjca-db sqlservr[14233]: file://package4/windows/system32/sqlpal.dll+0x0000000000292A01
9月 25 12:10:05 bjca-db sqlservr[14233]: file://package4/windows/system32/sqlpal.dll+0x000000000029186C
9月 25 12:10:05 bjca-db sqlservr[14233]: file://package4/windows/system32/sqlpal.dll+0x0000000000388631
9月 25 12:10:05 bjca-db sqlservr[14233]: Process: 14258 - sqlservr
9月 25 12:10:05 bjca-db sqlservr[14233]: Thread: 14263 (application thread 0x8)
9月 25 12:10:05 bjca-db sqlservr[14233]: Instance Id: 185564a1-bfb7-4ebd-9bad-3d2d2b26fd04
9月 25 12:10:05 bjca-db sqlservr[14233]: Crash Id: 4167b752-2994-42f2-9b9e-f6df9c87b348
9月 25 12:10:05 bjca-db sqlservr[14233]: Build stamp: c4ae858e5b9b6177096354e03007b2cc66ed6ea92fccf78fc71d2c87203bfcf4
9月 25 12:10:05 bjca-db sqlservr[14233]: Distribution: CentOS Linux 7 (Core)
9月 25 12:10:05 bjca-db sqlservr[14233]: Processors: 4
9月 25 12:10:05 bjca-db sqlservr[14233]: Total Memory: 8200859648 bytes
9月 25 12:10:05 bjca-db sqlservr[14233]: Timestamp: Sun Sep 25 12:10:05 2022
9月 25 12:10:05 bjca-db sqlservr[14233]: Last errno: 13
9月 25 12:10:05 bjca-db sqlservr[14233]: Last errno text: 权限不够
9月 25 12:10:05 bjca-db sqlservr[14233]: Executing: /opt/mssql/bin/handle-crash.sh with parameters
9月 25 12:10:05 bjca-db sqlservr[14233]: handle-crash.sh
9月 25 12:10:05 bjca-db sqlservr[14233]: /opt/mssql/bin/sqlservr
9月 25 12:10:05 bjca-db sqlservr[14233]: 14258
9月 25 12:10:05 bjca-db sqlservr[14233]: /opt/mssql/bin
9月 25 12:10:05 bjca-db sqlservr[14233]: /var/opt/mssql/log/
9月 25 12:10:05 bjca-db sqlservr[14233]: 185564a1-bfb7-4ebd-9bad-3d2d2b26fd04
9月 25 12:10:05 bjca-db sqlservr[14233]: 4167b752-2994-42f2-9b9e-f6df9c87b348
9月 25 12:10:05 bjca-db sqlservr[14233]: CentOS Linux 7 (Core)
9月 25 12:10:05 bjca-db sqlservr[14233]: Capturing core dump and information to /var/opt/mssql/log...
9月 25 12:10:07 bjca-db sqlservr[14233]: dmesg: --reltime 不能与 --ctime 选项同时使用
9月 25 12:10:07 bjca-db sqlservr[14233]: Hint: You are currently not seeing messages from other users and the system.
9月 25 12:10:07 bjca-db sqlservr[14233]: Users in the 'systemd-journal' group can see all messages. Pass -q to
9月 25 12:10:07 bjca-db sqlservr[14233]: turn off this notice.
9月 25 12:10:07 bjca-db sqlservr[14233]: No journal files were opened due to insufficient permissions.
9月 25 12:10:07 bjca-db sqlservr[14233]: Hint: You are currently not seeing messages from other users and the system.
9月 25 12:10:07 bjca-db sqlservr[14233]: Users in the 'systemd-journal' group can see all messages. Pass -q to
9月 25 12:10:07 bjca-db sqlservr[14233]: turn off this notice.
9月 25 12:10:07 bjca-db sqlservr[14233]: No journal files were opened due to insufficient permissions.
9月 25 12:10:07 bjca-db sqlservr[14233]: 2022年 09月 25日 星期日 12:10:07 CST Capturing program information
9月 25 12:10:07 bjca-db sqlservr[14233]: 2022年 09月 25日 星期日 12:10:07 CST Attempting to capture a dump with paldumper for pid 14258
9月 25 12:10:07 bjca-db sqlservr[14233]: Captured a dump with paldumper
9月 25 12:10:07 bjca-db sqlservr[14233]: 2022年 09月 25日 星期日 12:10:07 CST Capturing program binaries
9月 25 12:10:08 bjca-db sqlservr[14233]: /usr/bin/find: ‘/usr/share/polkit-1/rules.d’: 权限不够
9月 25 12:10:08 bjca-db sqlservr[14233]: /usr/bin/find: ‘/usr/libexec/initscripts/legacy-actions/auditd’: 权限不够
9月 25 12:10:08 bjca-db sqlservr[14233]: 2022年 09月 25日 星期日 12:10:08 CST Compressing the dump files
9月 25 12:10:08 bjca-db sqlservr[14233]: Core dump and information are being compressed in the background. When
9月 25 12:10:08 bjca-db sqlservr[14233]: complete, they can be found in the following location:
9月 25 12:10:08 bjca-db sqlservr[14233]: /var/opt/mssql/log/core.sqlservr.09_25_2022_12_10_05.14258.tbz2
9月 25 12:10:08 bjca-db systemd[1]: mssql-server.service: main process exited, code=exited, status=1/FAILURE
9月 25 12:10:08 bjca-db systemd[1]: Unit mssql-server.service entered failed state.
9月 25 12:10:08 bjca-db systemd[1]: mssql-server.service failed.
9月 25 12:10:08 bjca-db systemd[1]: mssql-server.service holdoff time over, scheduling restart.
9月 25 12:10:08 bjca-db systemd[1]: Stopped Microsoft SQL Server Database Engine.
9月 25 12:10:08 bjca-db systemd[1]: Started Microsoft SQL Server Database Engine.
9月 25 12:10:09 bjca-db sqlservr[15133]: This program has encountered a fatal error and cannot continue running at Sun Sep 25 12:10:09 2022
9月 25 12:10:09 bjca-db sqlservr[15133]: The following diagnostic information is available:
9月 25 12:10:09 bjca-db sqlservr[15133]: Reason: 0x00000007
9月 25 12:10:09 bjca-db sqlservr[15133]: Status: 0xc0000022
9月 25 12:10:09 bjca-db sqlservr[15133]: Message: Access was denied setting up the persistent registry: \SystemRoot\licensing.hiv.
9月 25 12:10:09 bjca-db sqlservr[15133]: file://package4/windows/system32/sqlpal.dll+0x0000000000388631
9月 25 12:10:09 bjca-db sqlservr[15133]: Process: 15141 - sqlservr
9月 25 12:10:09 bjca-db sqlservr[15133]: Thread: 15151 (application thread 0x8)
9月 25 12:10:09 bjca-db sqlservr[15133]: Instance Id: 185564a1-bfb7-4ebd-9bad-3d2d2b26fd04
9月 25 12:10:09 bjca-db sqlservr[15133]: Crash Id: 42cebd31-3b56-4434-af2c-d92d79e7ace4
9月 25 12:10:09 bjca-db sqlservr[15133]: Build stamp: c4ae858e5b9b6177096354e03007b2cc66ed6ea92fccf78fc71d2c87203bfcf4
9月 25 12:10:09 bjca-db sqlservr[15133]: Distribution: CentOS Linux 7 (Core)
9月 25 12:10:09 bjca-db sqlservr[15133]: Processors: 4
9月 25 12:10:09 bjca-db sqlservr[15133]: Total Memory: 8200859648 bytes
9月 25 12:10:09 bjca-db sqlservr[15133]: Timestamp: Sun Sep 25 12:10:09 2022
9月 25 12:10:09 bjca-db sqlservr[15133]: Last errno: 13
9月 25 12:10:09 bjca-db sqlservr[15133]: Last errno text: 权限不够
9月 25 12:10:09 bjca-db sqlservr[15133]: Executing: /opt/mssql/bin/handle-crash.sh with parameters
9月 25 12:10:09 bjca-db sqlservr[15133]: handle-crash.sh
9月 25 12:10:09 bjca-db sqlservr[15133]: /opt/mssql/bin/sqlservr
9月 25 12:10:09 bjca-db sqlservr[15133]: 15141
9月 25 12:10:09 bjca-db sqlservr[15133]: /opt/mssql/bin
9月 25 12:10:09 bjca-db sqlservr[15133]: /var/opt/mssql/log/
9月 25 12:10:09 bjca-db sqlservr[15133]: 185564a1-bfb7-4ebd-9bad-3d2d2b26fd04
9月 25 12:10:09 bjca-db sqlservr[15133]: 42cebd31-3b56-4434-af2c-d92d79e7ace4
9月 25 12:10:09 bjca-db sqlservr[15133]: CentOS Linux 7 (Core)
9月 25 12:10:09 bjca-db sqlservr[15133]: Capturing core dump and information to /var/opt/mssql/log...
9月 25 12:10:10 bjca-db sqlservr[15133]: dmesg: --reltime 不能与 --ctime 选项同时使用
9月 25 12:10:10 bjca-db sqlservr[15133]: Hint: You are currently not seeing messages from other users and the system.
9月 25 12:10:10 bjca-db sqlservr[15133]: Users in the 'systemd-journal' group can see all messages. Pass -q to
9月 25 12:10:10 bjca-db sqlservr[15133]: turn off this notice.
9月 25 12:10:10 bjca-db sqlservr[15133]: No journal files were opened due to insufficient permissions.
9月 25 12:10:10 bjca-db sqlservr[15133]: Hint: You are currently not seeing messages from other users and the system.
9月 25 12:10:10 bjca-db sqlservr[15133]: Users in the 'systemd-journal' group can see all messages. Pass -q to
9月 25 12:10:10 bjca-db sqlservr[15133]: turn off this notice.
9月 25 12:10:10 bjca-db sqlservr[15133]: No journal files were opened due to insufficient permissions.
9月 25 12:10:10 bjca-db sqlservr[15133]: 2022年 09月 25日 星期日 12:10:10 CST Capturing program information
9月 25 12:10:11 bjca-db sqlservr[15133]: 2022年 09月 25日 星期日 12:10:11 CST Attempting to capture a dump with paldumper for pid 15141
9月 25 12:10:12 bjca-db sqlservr[15133]: Captured a dump with paldumper
9月 25 12:10:12 bjca-db sqlservr[15133]: 2022年 09月 25日 星期日 12:10:12 CST Capturing program binaries
9月 25 12:10:12 bjca-db sqlservr[15133]: /usr/bin/find: ‘/usr/share/polkit-1/rules.d’: 权限不够
9月 25 12:10:12 bjca-db sqlservr[15133]: /usr/bin/find: ‘/usr/libexec/initscripts/legacy-actions/auditd’: 权限不够
9月 25 12:10:12 bjca-db sqlservr[15133]: 2022年 09月 25日 星期日 12:10:12 CST Compressing the dump files
9月 25 12:10:12 bjca-db sqlservr[15133]: Core dump and information are being compressed in the background. When
9月 25 12:10:12 bjca-db sqlservr[15133]: complete, they can be found in the following location:
9月 25 12:10:12 bjca-db sqlservr[15133]: /var/opt/mssql/log/core.sqlservr.09_25_2022_12_10_09.15141.tbz2
9月 25 12:10:12 bjca-db systemd[1]: mssql-server.service: main process exited, code=exited, status=1/FAILURE
9月 25 12:10:12 bjca-db systemd[1]: Unit mssql-server.service entered failed state.
9月 25 12:10:12 bjca-db systemd[1]: mssql-server.service failed.
9月 25 12:10:13 bjca-db systemd[1]: mssql-server.service holdoff time over, scheduling restart.
9月 25 12:10:13 bjca-db systemd[1]: Stopped Microsoft SQL Server Database Engine.
9月 25 12:10:13 bjca-db systemd[1]: start request repeated too quickly for mssql-server.service
9月 25 12:10:13 bjca-db systemd[1]: Failed to start Microsoft SQL Server Database Engine.
9月 25 12:10:13 bjca-db systemd[1]: Unit mssql-server.service entered failed state.
9月 25 12:10:13 bjca-db systemd[1]: mssql-server.service failed.
9月 25 12:13:46 bjca-db systemd[1]: Started Microsoft SQL Server Database Engine.
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.02 Server Microsoft SQL Server 2017 (RTM-CU24) (KB5001228) - 14.0.3391.2 (X64)
9月 25 12:13:49 bjca-db sqlservr[2449]: Apr 28 2021 10:32:18
9月 25 12:13:49 bjca-db sqlservr[2449]: Copyright (C) 2017 Microsoft Corporation
9月 25 12:13:49 bjca-db sqlservr[2449]: Developer Edition (64-bit) on Linux (CentOS Linux 7 (Core))
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.05 Server Microsoft SQL Server 2017 (RTM-CU24) (KB5001228) - 14.0.3391.2 (X64)
9月 25 12:13:49 bjca-db sqlservr[2449]: Apr 28 2021 10:32:18
9月 25 12:13:49 bjca-db sqlservr[2449]: Copyright (C) 2017 Microsoft Corporation
9月 25 12:13:49 bjca-db sqlservr[2449]: Developer Edition (64-bit) on Linux (CentOS Linux 7 (Core))
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.06 Server UTC 2022-09-25 12:13:49.06 Server UTC adjustment: 8:00
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.06 Server (c) Microsoft Corporation2022-09-25 12:13:49.06 Server (c) Microsoft Corporation.
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.06 Server 2022-09-25 12:13:49.06 Server All rights reserved.
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.07 Server 2022-09-25 12:13:49.07 Server Server process ID is 392.
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.07 Server 2022-09-25 12:13:49.07 Server Logging SQL Server messages in file '/var/opt/mssql/log/errorlog.loc'.
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.07 Server 2022-09-25 12:13:49.07 Server Registry startup parameters:
9月 25 12:13:49 bjca-db sqlservr[2449]: -d /var/opt/mssql/data/master.mdf
9月 25 12:13:49 bjca-db sqlservr[2449]: -l /var/opt/mssql/data/mastlog.ldf
9月 25 12:13:49 bjca-db sqlservr[2449]: -e /var/opt/mssql/log/errorlog
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.08 Server SQL Server 2022-09-25 12:13:49.08 Server SQL Server detected 1 sockets with 4 cores per socket and 4 l
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.09 Server SQL Server 2022-09-25 12:13:49.09 Server SQL Server is starting at normal priority base (=7). This is
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.09 Server 2022-09-25 12:13:49.09 Server Detected 6256 MB of RAM. This is an informational message; no user actio
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.10 Server 2022-09-25 12:13:49.10 Server Using conventional memory in the memory manager.
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.10 Server Page exclusion bitmap is enabled.
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.10 Server Page exclusion bitmap is enabled.
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.16 Server 2022-09-25 12:13:49.16 Server Default collation: Chinese_PRC_CI_AS (2022-09-25 12:13:49.23 Server
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.43 Server InitializeExternalUserGroupSid failed. Implied authentication will be disabled.
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.43 Server InitializeExternalUserGroupSid failed. Implied authentication will be disabled.
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.43 Server Implied authentication manager initialization failed. Implied authentication will be disabled.
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.44 Server Implied authentication manager initialization failed. Implied authentication will be disabled.
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.45 Server 2022-09-25 12:13:49.45 Server Successfully initialized the TLS configuration. Allowed TLS protocol ver
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.48 Server Query Store settings initialized with enabled = 1,
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.48 Server Query Store settings initialized with enabled = 1,
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.50 Server 2022-09-25 12:13:49.50 Server 2022-09-25 12:13:49.50 Server Node configuration: node 0: CPU mask:
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.50 Server The maximum number of dedicated administrator connections for this instance is '1'
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.51 Server 2022-09-25 12:13:49.51 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks a
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.53 Server In-Memory OLTP initialized on lowend machine.
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.53 Server In-Memory OLTP initialized on lowend machine.
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.57 Server 2022-09-25 12:13:49.57 Server Database Instant File Initialization: ForceFlush is enabled for this ins
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.58 Server 2022-09-25 12:13:49.58 Server Software Usage Metrics is disabled.
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.58 spid5s 2022-09-25 12:13:49.58 spid5s Starting up database 'master'.
9月 25 12:13:49 bjca-db sqlservr[2449]: ForceFlush feature is enabled for log durability.
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.81 spid5s Resource Governor 2022-09-25 12:13:49.82 spid5s Resource governor reconfiguration succeeded.
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.82 spid5s SQL Server Audit 2022-09-25 12:13:49.82 spid5s SQL Server Audit is starting the audits. This is an inf
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.82 spid5s SQL Server Audit 2022-09-25 12:13:49.83 spid5s SQL Server Audit has started the audits. This is an inf
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.89 spid5s SQL 2022-09-25 12:13:49.89 spid5s SQL Trace ID 1 was started by login "sa".
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.90 spid5s 2022-09-25 12:13:49.90 spid5s Server name is 'bjca-db'. This is an informational message only. No user
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.92 spid21s AlwaysOn:2022-09-25 12:13:49.92 spid21s Always On: The availability replica manager is starting. This i
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.92 spid9s 2022-09-25 12:13:49.92 spid23s 2022-09-25 12:13:49.92 spid9s Starting up database 'mssqlsystemreso
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.93 spid23s Starting up database 'msdb'.
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.93 spid9s 2022-09-25 12:13:49.93 spid9s The resource database build version is 14.00.3391. This is an informatio
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.94 spid21s AlwaysOn:2022-09-25 12:13:49.94 spid21s Always On: The availability replica manager is waiting for the
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.95 spid24s 2022-09-25 12:13:49.95 spid24s Starting up database 'signature'.
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.97 spid9s 2022-09-25 12:13:49.97 spid9s Starting up database 'model'.
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.08 spid24s 2022-09-25 12:13:50.08 spid24s Parallel redo is started for database 'signature' with worker pool size
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.11 spid9s 2022-09-25 12:13:50.11 spid9s Polybase feature disabled.
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.12 spid9s 2022-09-25 12:13:50.12 spid9s Clearing tempdb database.
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.12 spid19s 2022-09-25 12:13:50.12 spid19s A self-generated certificate was successfully loaded for encryption.
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.14 spid19s 2022-09-25 12:13:50.14 spid19s Server is listening on [ 'any' <ipv6> 1433].
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.15 spid19s 2022-09-25 12:13:50.15 spid19s Server is listening on [ 'any' <ipv4> 1433].
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.16 Server 2022-09-25 12:13:50.16 Server Server is listening on [ ::1 <ipv6> 1434].
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.16 Server 2022-09-25 12:13:50.16 Server Server is listening on [ 127.0.0.1 <ipv4> 1434].
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.17 Server 2022-09-25 12:13:50.17 Server Dedicated admin connection support was established for listening locally
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.17 spid19s SQL Server 2022-09-25 12:13:50.17 spid19s SQL Server is now ready for client connections. This is an in
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.23 spid5s 2022-09-25 12:13:50.23 spid5s Parallel redo is shutdown for database 'signature' with worker pool size
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.38 spid9s 2022-09-25 12:13:50.38 spid9s Starting up database 'tempdb'.
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.57 spid9s tempdb 2022-09-25 12:13:50.57 spid9s The tempdb database has 1 data file(s).
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.58 spid21s Service Broker 2022-09-25 12:13:50.58 spid21s The Service Broker endpoint is in disabled or stopped sta
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.58 spid21s Database Mirroring 2022-09-25 12:13:50.58 spid21s The Database Mirroring endpoint is in disabled or sto
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.60 spid21s 2022-09-25 12:13:50.61 spid21s Service Broker manager has started.
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.62 spid5s 2022-09-25 12:13:50.62 spid5s Recovery is complete. This is an informational message only. No user act
[root@bjca-db mssql]#
处理办法:权限问题,参考Ops! I broke mssql-server by running it with sudo文章来源地址https://www.toymoban.com/news/detail-516630.html
[root@bjca-db ~]# systemctl status mssql-server
● mssql-server.service - Microsoft SQL Server Database Engine
Loaded: loaded (/usr/lib/systemd/system/mssql-server.service; enabled; vendor preset: disabled)
Active: failed (Result: start-limit) since 日 2022-09-25 12:10:13 CST; 43s ago
Docs: https://docs.microsoft.com/en-us/sql/linux
Process: 15133 ExecStart=/opt/mssql/bin/sqlservr (code=exited, status=1/FAILURE)
Main PID: 15133 (code=exited, status=1/FAILURE)
Tasks: 0
CGroup: /system.slice/mssql-server.service
9月 25 12:10:12 bjca-db systemd[1]: mssql-server.service: main process exited, code=exited, status=1/FAILURE
9月 25 12:10:12 bjca-db systemd[1]: Unit mssql-server.service entered failed state.
9月 25 12:10:12 bjca-db systemd[1]: mssql-server.service failed.
9月 25 12:10:13 bjca-db systemd[1]: mssql-server.service holdoff time over, scheduling restart.
9月 25 12:10:13 bjca-db systemd[1]: Stopped Microsoft SQL Server Database Engine.
9月 25 12:10:13 bjca-db systemd[1]: start request repeated too quickly for mssql-server.service
9月 25 12:10:13 bjca-db systemd[1]: Failed to start Microsoft SQL Server Database Engine.
9月 25 12:10:13 bjca-db systemd[1]: Unit mssql-server.service entered failed state.
9月 25 12:10:13 bjca-db systemd[1]: mssql-server.service failed.
[root@bjca-db ~]# ll /var/opt/mssql/.system/
总用量 4
-rw-r--r-- 1 mssql mssql 60 9月 25 12:10 instance_id
drwxr-xr-x 3 mssql mssql 20 6月 22 2021 profiles
drwxr-xr-x 3 mssql mssql 23 6月 22 2021 programdata
drwxr-xr-x 5 mssql mssql 224 9月 24 00:57 system
[root@bjca-db ~]# chown -R mssql:mssql /var/opt/mssql/* /var/opt/mssql/.system/
[root@bjca-db ~]# systemctl status mssql-server
● mssql-server.service - Microsoft SQL Server Database Engine
Loaded: loaded (/usr/lib/systemd/system/mssql-server.service; enabled; vendor preset: disabled)
Active: failed (Result: start-limit) since 日 2022-09-25 12:10:13 CST; 3min 26s ago
Docs: https://docs.microsoft.com/en-us/sql/linux
Process: 15133 ExecStart=/opt/mssql/bin/sqlservr (code=exited, status=1/FAILURE)
Main PID: 15133 (code=exited, status=1/FAILURE)
Tasks: 0
CGroup: /system.slice/mssql-server.service
9月 25 12:10:12 bjca-db systemd[1]: mssql-server.service: main process exited, code=exited, status=1/FAILURE
9月 25 12:10:12 bjca-db systemd[1]: Unit mssql-server.service entered failed state.
9月 25 12:10:12 bjca-db systemd[1]: mssql-server.service failed.
9月 25 12:10:13 bjca-db systemd[1]: mssql-server.service holdoff time over, scheduling restart.
9月 25 12:10:13 bjca-db systemd[1]: Stopped Microsoft SQL Server Database Engine.
9月 25 12:10:13 bjca-db systemd[1]: start request repeated too quickly for mssql-server.service
9月 25 12:10:13 bjca-db systemd[1]: Failed to start Microsoft SQL Server Database Engine.
9月 25 12:10:13 bjca-db systemd[1]: Unit mssql-server.service entered failed state.
9月 25 12:10:13 bjca-db systemd[1]: mssql-server.service failed.
[root@bjca-db ~]# systemctl start mssql-server
[root@bjca-db ~]# systemctl status mssql-server
● mssql-server.service - Microsoft SQL Server Database Engine
Loaded: loaded (/usr/lib/systemd/system/mssql-server.service; enabled; vendor preset: disabled)
Active: active (running) since 日 2022-09-25 12:13:46 CST; 1s ago
Docs: https://docs.microsoft.com/en-us/sql/linux
Main PID: 2449 (sqlservr)
Tasks: 66
CGroup: /system.slice/mssql-server.service
├─2449 /opt/mssql/bin/sqlservr
└─2467 /opt/mssql/bin/sqlservr
9月 25 12:13:46 bjca-db systemd[1]: Started Microsoft SQL Server Database Engine.
[root@bjca-db ~]# systemctl status mssql-server
● mssql-server.service - Microsoft SQL Server Database Engine
Loaded: loaded (/usr/lib/systemd/system/mssql-server.service; enabled; vendor preset: disabled)
Active: active (running) since 日 2022-09-25 12:13:46 CST; 3s ago
Docs: https://docs.microsoft.com/en-us/sql/linux
Main PID: 2449 (sqlservr)
Tasks: 108
CGroup: /system.slice/mssql-server.service
├─2449 /opt/mssql/bin/sqlservr
└─2467 /opt/mssql/bin/sqlservr
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.10 Server Page exclusion bitmap is enabled.
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.10 Server Page exclusion bitmap is enabled.
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.16 Server 2022-09-25 12:13:49.16 Server Default collation: Chinese_PRC_CI_AS (2022-09-25 12:13:4...s necessary.
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.43 Server InitializeExternalUserGroupSid failed. Implied authentication will be disabled.
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.43 Server InitializeExternalUserGroupSid failed. Implied authentication will be disabled.
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.43 Server Implied authentication manager initialization failed. Implied authentication will be disabled.
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.44 Server Implied authentication manager initialization failed. Implied authentication will be disabled.
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.45 Server 2022-09-25 12:13:49.45 Server Successfully initialized the TLS configuration. Allowed ...6:ECDHE-RSA-
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.48 Server Query Store settings initialized with enabled = 1,
9月 25 12:13:49 bjca-db sqlservr[2449]: 2022-09-25 12:13:49.48 Server Query Store settings initialized with enabled = 1,
Hint: Some lines were ellipsized, use -l to show in full.
[root@bjca-db ~]# systemctl status mssql-server
● mssql-server.service - Microsoft SQL Server Database Engine
Loaded: loaded (/usr/lib/systemd/system/mssql-server.service; enabled; vendor preset: disabled)
Active: active (running) since 日 2022-09-25 12:13:46 CST; 5s ago
Docs: https://docs.microsoft.com/en-us/sql/linux
Main PID: 2449 (sqlservr)
Tasks: 137
CGroup: /system.slice/mssql-server.service
├─2449 /opt/mssql/bin/sqlservr
└─2467 /opt/mssql/bin/sqlservr
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.16 Server 2022-09-25 12:13:50.16 Server Server is listening on [ 127.0.0.1 <ipv4> 1434].
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.17 Server 2022-09-25 12:13:50.17 Server Dedicated admin connection support was established for l...n port 1434.
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.17 spid19s SQL Server 2022-09-25 12:13:50.17 spid19s SQL Server is now ready for client connection...is required.
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.23 spid5s 2022-09-25 12:13:50.23 spid5s Parallel redo is shutdown for database 'signature' with ...ol size [2].
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.38 spid9s 2022-09-25 12:13:50.38 spid9s Starting up database 'tempdb'.
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.57 spid9s tempdb 2022-09-25 12:13:50.57 spid9s The tempdb database has 1 data file(s).
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.58 spid21s Service Broker 2022-09-25 12:13:50.58 spid21s The Service Broker endpoint is in disable...opped state.
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.58 spid21s Database Mirroring 2022-09-25 12:13:50.58 spid21s The Database Mirroring endpoint is in...opped state.
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.60 spid21s 2022-09-25 12:13:50.61 spid21s Service Broker manager has started.
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.62 spid5s 2022-09-25 12:13:50.62 spid5s Recovery is complete. This is an informational message o...is required.
Hint: Some lines were ellipsized, use -l to show in full.
[root@bjca-db ~]# systemctl status mssql-server
● mssql-server.service - Microsoft SQL Server Database Engine
Loaded: loaded (/usr/lib/systemd/system/mssql-server.service; enabled; vendor preset: disabled)
Active: active (running) since 日 2022-09-25 12:13:46 CST; 7s ago
Docs: https://docs.microsoft.com/en-us/sql/linux
Main PID: 2449 (sqlservr)
Tasks: 137
CGroup: /system.slice/mssql-server.service
├─2449 /opt/mssql/bin/sqlservr
└─2467 /opt/mssql/bin/sqlservr
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.16 Server 2022-09-25 12:13:50.16 Server Server is listening on [ 127.0.0.1 <ipv4> 1434].
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.17 Server 2022-09-25 12:13:50.17 Server Dedicated admin connection support was established for l...n port 1434.
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.17 spid19s SQL Server 2022-09-25 12:13:50.17 spid19s SQL Server is now ready for client connection...is required.
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.23 spid5s 2022-09-25 12:13:50.23 spid5s Parallel redo is shutdown for database 'signature' with ...ol size [2].
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.38 spid9s 2022-09-25 12:13:50.38 spid9s Starting up database 'tempdb'.
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.57 spid9s tempdb 2022-09-25 12:13:50.57 spid9s The tempdb database has 1 data file(s).
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.58 spid21s Service Broker 2022-09-25 12:13:50.58 spid21s The Service Broker endpoint is in disable...opped state.
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.58 spid21s Database Mirroring 2022-09-25 12:13:50.58 spid21s The Database Mirroring endpoint is in...opped state.
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.60 spid21s 2022-09-25 12:13:50.61 spid21s Service Broker manager has started.
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.62 spid5s 2022-09-25 12:13:50.62 spid5s Recovery is complete. This is an informational message o...is required.
Hint: Some lines were ellipsized, use -l to show in full.
[root@bjca-db ~]# systemctl status mssql-server
● mssql-server.service - Microsoft SQL Server Database Engine
Loaded: loaded (/usr/lib/systemd/system/mssql-server.service; enabled; vendor preset: disabled)
Active: active (running) since 日 2022-09-25 12:13:46 CST; 8s ago
Docs: https://docs.microsoft.com/en-us/sql/linux
Main PID: 2449 (sqlservr)
Tasks: 137
CGroup: /system.slice/mssql-server.service
├─2449 /opt/mssql/bin/sqlservr
└─2467 /opt/mssql/bin/sqlservr
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.16 Server 2022-09-25 12:13:50.16 Server Server is listening on [ 127.0.0.1 <ipv4> 1434].
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.17 Server 2022-09-25 12:13:50.17 Server Dedicated admin connection support was established for l...n port 1434.
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.17 spid19s SQL Server 2022-09-25 12:13:50.17 spid19s SQL Server is now ready for client connection...is required.
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.23 spid5s 2022-09-25 12:13:50.23 spid5s Parallel redo is shutdown for database 'signature' with ...ol size [2].
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.38 spid9s 2022-09-25 12:13:50.38 spid9s Starting up database 'tempdb'.
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.57 spid9s tempdb 2022-09-25 12:13:50.57 spid9s The tempdb database has 1 data file(s).
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.58 spid21s Service Broker 2022-09-25 12:13:50.58 spid21s The Service Broker endpoint is in disable...opped state.
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.58 spid21s Database Mirroring 2022-09-25 12:13:50.58 spid21s The Database Mirroring endpoint is in...opped state.
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.60 spid21s 2022-09-25 12:13:50.61 spid21s Service Broker manager has started.
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.62 spid5s 2022-09-25 12:13:50.62 spid5s Recovery is complete. This is an informational message o...is required.
Hint: Some lines were ellipsized, use -l to show in full.
[root@bjca-db ~]# systemctl status mssql-server
● mssql-server.service - Microsoft SQL Server Database Engine
Loaded: loaded (/usr/lib/systemd/system/mssql-server.service; enabled; vendor preset: disabled)
Active: active (running) since 日 2022-09-25 12:13:46 CST; 10s ago
Docs: https://docs.microsoft.com/en-us/sql/linux
Main PID: 2449 (sqlservr)
Tasks: 138
CGroup: /system.slice/mssql-server.service
├─2449 /opt/mssql/bin/sqlservr
└─2467 /opt/mssql/bin/sqlservr
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.16 Server 2022-09-25 12:13:50.16 Server Server is listening on [ 127.0.0.1 <ipv4> 1434].
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.17 Server 2022-09-25 12:13:50.17 Server Dedicated admin connection support was established for l...n port 1434.
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.17 spid19s SQL Server 2022-09-25 12:13:50.17 spid19s SQL Server is now ready for client connection...is required.
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.23 spid5s 2022-09-25 12:13:50.23 spid5s Parallel redo is shutdown for database 'signature' with ...ol size [2].
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.38 spid9s 2022-09-25 12:13:50.38 spid9s Starting up database 'tempdb'.
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.57 spid9s tempdb 2022-09-25 12:13:50.57 spid9s The tempdb database has 1 data file(s).
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.58 spid21s Service Broker 2022-09-25 12:13:50.58 spid21s The Service Broker endpoint is in disable...opped state.
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.58 spid21s Database Mirroring 2022-09-25 12:13:50.58 spid21s The Database Mirroring endpoint is in...opped state.
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.60 spid21s 2022-09-25 12:13:50.61 spid21s Service Broker manager has started.
9月 25 12:13:50 bjca-db sqlservr[2449]: 2022-09-25 12:13:50.62 spid5s 2022-09-25 12:13:50.62 spid5s Recovery is complete. This is an informational message o...is required.
Hint: Some lines were ellipsized, use -l to show in full.
到了这里,关于Access was denied setting up the persistent registry: \SystemRoot\licensing.hiv.的文章就介绍完了。如果您还想了解更多内容,请在右上角搜索TOY模板网以前的文章或继续浏览下面的相关文章,希望大家以后多多支持TOY模板网!