Skip to content

Instantly share code, notes, and snippets.

@doggy8088

doggy8088/sql-server-container.log Secret

Created August 19, 2022 15:33
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save doggy8088/2460cac9032e27f4f84f7fe5acfaa7f5 to your computer and use it in GitHub Desktop.
Save doggy8088/2460cac9032e27f4f84f7fe5acfaa7f5 to your computer and use it in GitHub Desktop.
Download ZIP
docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=Pa@@w0rd1234" -p 1433:1433 --name sql1 --hostname sql1 -d -m 1073741824 mcr.microsoft.com/mssql/server:2019-latest
Raw
sql-server-container.log
SQL Server 2019 will run as non-root by default.
This container is running as user mssql.
To learn more visit https://go.microsoft.com/fwlink/?linkid=2099216.
2022-08-19 15:31:28.60 Server Setup step is copying system data file 'C:\templatedata\master.mdf' to '/var/opt/mssql/data/master.mdf'.
2022-08-19 15:31:28.64 Server Did not find an existing master data file /var/opt/mssql/data/master.mdf, copying the missing default master and other system database files. If you have moved the database location, but not moved the database files, startup may fail. To repair: shutdown SQL Server, move the master database to configured location, and restart.
2022-08-19 15:31:28.64 Server Setup step is copying system data file 'C:\templatedata\mastlog.ldf' to '/var/opt/mssql/data/mastlog.ldf'.
2022-08-19 15:31:28.64 Server Setup step is copying system data file 'C:\templatedata\model.mdf' to '/var/opt/mssql/data/model.mdf'.
2022-08-19 15:31:28.66 Server Setup step is copying system data file 'C:\templatedata\modellog.ldf' to '/var/opt/mssql/data/modellog.ldf'.
2022-08-19 15:31:28.67 Server Setup step is copying system data file 'C:\templatedata\msdbdata.mdf' to '/var/opt/mssql/data/msdbdata.mdf'.
2022-08-19 15:31:28.69 Server Setup step is copying system data file 'C:\templatedata\msdblog.ldf' to '/var/opt/mssql/data/msdblog.ldf'.
2022-08-19 15:31:28.69 Server Setup step is FORCE copying system data file 'C:\templatedata\model_replicatedmaster.mdf' to '/var/opt/mssql/data/model_replicatedmaster.mdf'.
2022-08-19 15:31:28.70 Server Setup step is FORCE copying system data file 'C:\templatedata\model_replicatedmaster.ldf' to '/var/opt/mssql/data/model_replicatedmaster.ldf'.
2022-08-19 15:31:28.70 Server Setup step is FORCE copying system data file 'C:\templatedata\model_msdbdata.mdf' to '/var/opt/mssql/data/model_msdbdata.mdf'.
2022-08-19 15:31:28.72 Server Setup step is FORCE copying system data file 'C:\templatedata\model_msdblog.ldf' to '/var/opt/mssql/data/model_msdblog.ldf'.
2022-08-19 15:31:28.77 Server Microsoft SQL Server 2019 (RTM-CU17) (KB5016394) - 15.0.4249.2 (X64)
Jul 22 2022 12:11:33
Copyright (C) 2019 Microsoft Corporation
Developer Edition (64-bit) on Linux (Ubuntu 20.04.4 LTS) <X64>
2022-08-19 15:31:28.77 Server UTC adjustment: 0:00
2022-08-19 15:31:28.77 Server (c) Microsoft Corporation.
2022-08-19 15:31:28.77 Server All rights reserved.
2022-08-19 15:31:28.77 Server Server process ID is 344.
2022-08-19 15:31:28.77 Server Logging SQL Server messages in file '/var/opt/mssql/log/errorlog'.
2022-08-19 15:31:28.78 Server Registry startup parameters:
-d /var/opt/mssql/data/master.mdf
-l /var/opt/mssql/data/mastlog.ldf
-e /var/opt/mssql/log/errorlog
2022-08-19 15:31:28.78 Server SQL Server detected 1 sockets with 8 cores per socket and 16 logical processors per socket, 16 total logical processors; using 16 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
2022-08-19 15:31:28.78 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2022-08-19 15:31:28.78 Server Detected 820 MB of RAM. This is an informational message; no user action is required.
2022-08-19 15:31:28.78 Server Using conventional memory in the memory manager.
2022-08-19 15:31:28.79 Server Page exclusion bitmap is enabled.
2022-08-19 15:31:28.84 Server Buffer pool extension is not supported on Linux platform.
2022-08-19 15:31:28.84 Server Buffer Pool: Allocating 65536 bytes for 56190 hashPages.
2022-08-19 15:31:28.93 Server Buffer pool extension is already disabled. No action is necessary.
2022-08-19 15:31:29.15 Server Successfully initialized the TLS configuration. Allowed TLS protocol versions are ['1.0 1.1 1.2']. Allowed TLS ciphers are ['ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES128-SHA256:ECDHE-ECDSA-AES256-SHA384:ECDHE-ECDSA-AES256-SHA:ECDHE-ECDSA-AES128-SHA:AES256-GCM-SHA384:AES128-GCM-SHA256:AES256-SHA256:AES128-SHA256:AES256-SHA:AES128-SHA:!DHE-RSA-AES256-GCM-SHA384:!DHE-RSA-AES128-GCM-SHA256:!DHE-RSA-AES256-SHA:!DHE-RSA-AES128-SHA'].
2022-08-19 15:31:29.17 Server Query Store settings initialized with enabled = 1,
2022-08-19 15:31:29.18 Server The maximum number of dedicated administrator connections for this instance is '1'
2022-08-19 15:31:29.19 Server Node configuration: node 0: CPU mask: 0x000000000000ffff:0 Active CPU mask: 0x000000000000ffff:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2022-08-19 15:31:29.20 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2022-08-19 15:31:29.20 Server Lock partitioning is enabled. This is an informational message only. No user action is required.
2022-08-19 15:31:29.21 Server In-Memory OLTP initialized on lowend machine.
2022-08-19 15:31:29.24 Server [INFO] Created Extended Events session 'hkenginexesession'
2022-08-19 15:31:29.24 Server Database Instant File Initialization: enabled. For security and performance considerations see the topic 'Database Instant File Initialization' in SQL Server Books Online. This is an informational message only. No user action is required.
ForceFlush is enabled for this instance.
2022-08-19 15:31:29.24 Server Total Log Writer threads: 2. This is an informational message; no user action is required.
2022-08-19 15:31:29.25 Server clflushopt is selected for pmem flush operation.
2022-08-19 15:31:29.25 Server Software Usage Metrics is disabled.
2022-08-19 15:31:29.26 spid10s [1]. Feature Status: PVS: 0. CTR: 0. ConcurrentPFSUpdate: 1.
2022-08-19 15:31:29.26 spid10s Starting up database 'master'.
ForceFlush feature is enabled for log durability.
2022-08-19 15:31:29.39 spid10s The tail of the log for database master is being rewritten to match the new sector size of 4096 bytes. 1536 bytes at offset 412160 in file /var/opt/mssql/data/mastlog.ldf will be written.
2022-08-19 15:31:29.41 Server CLR version v4.0.30319 loaded.
2022-08-19 15:31:29.46 spid10s Converting database 'master' from version 897 to the current version 904.
2022-08-19 15:31:29.46 spid10s Database 'master' running the upgrade step from version 897 to version 898.
2022-08-19 15:31:29.47 spid10s Database 'master' running the upgrade step from version 898 to version 899.
2022-08-19 15:31:29.49 spid10s Database 'master' running the upgrade step from version 899 to version 900.
2022-08-19 15:31:29.52 spid10s Database 'master' running the upgrade step from version 900 to version 901.
2022-08-19 15:31:29.53 spid10s Database 'master' running the upgrade step from version 901 to version 902.
2022-08-19 15:31:29.54 spid10s Database 'master' running the upgrade step from version 902 to version 903.
2022-08-19 15:31:29.55 spid10s Database 'master' running the upgrade step from version 903 to version 904.
2022-08-19 15:31:29.66 Server Common language runtime (CLR) functionality initialized.
2022-08-19 15:31:29.81 spid10s Resource governor reconfiguration succeeded.
2022-08-19 15:31:29.81 spid10s SQL Server Audit is starting the audits. This is an informational message. No user action is required.
2022-08-19 15:31:29.81 spid10s SQL Server Audit has started the audits. This is an informational message. No user action is required.
2022-08-19 15:31:29.84 spid10s SQL Trace ID 1 was started by login "sa".
2022-08-19 15:31:29.85 spid25s Password policy update was successful.
2022-08-19 15:31:29.86 spid10s Server name is 'sql1'. This is an informational message only. No user action is required.
2022-08-19 15:31:34.91 spid17s Failed allocate pages: FAIL_PAGE_ALLOCATION 1
Failed to execute SystemTaskEntryPoint: unable to allocate MsqlXactManager2022-08-19 15:31:34.91 spid25s Error: 26018, Severity: 10, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
2022-08-19 15:31:34.91 Server Error: 17138, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Failed to execute SystemTaskEntryPoint: unable to allocate MsqlXactManager2022-08-19 15:31:34.91 spid17s
Process/System Counts Value
---------------------------------------- ----------
Available Physical Memory 65839104
Available Virtual Memory 70364449144833
Available Paging File 65839104
Working Set 4294967296
Percent of Committed Memory in WS 100
Page Faults 0
System physical memory high 0
System physical memory low 0
Process physical memory low 1
Process virtual memory low 0
Failed to execute SystemTaskEntryPoint: unable to allocate MsqlXactManager2022-08-19 15:31:34.92 Server Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Failed to execute SystemTaskEntryPoint: unable to allocate MsqlXactManager2022-08-19 15:31:34.92 Server Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
2022-08-19 15:31:34.92 Server Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
2022-08-19 15:31:34.92 Server Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
2022-08-19 15:31:34.92 Server Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
2022-08-19 15:31:34.92 Server Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
2022-08-19 15:31:34.92 Server Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
2022-08-19 15:31:34.92 Server Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
2022-08-19 15:31:34.92 Server Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
2022-08-19 15:31:34.92 spid25s Error: 26022, Severity: 10, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
2022-08-19 15:31:34.92 Server Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
2022-08-19 15:31:34.92 spid17s
Memory Manager KB
---------------------------------------- ----------
VM Reserved 1868572
VM Committed 106316
Locked Pages Allocated 0
Large Pages Allocated 0
Emergency Memory 1024
Emergency Memory In Use 8
Target Committed 106320
Current Committed 106320
Pages Allocated 81000
Pages Reserved 0
Pages Free 496
Pages In Use 104280
Page Alloc Potential -3272
NUMA Growth Phase 2
Last OOM Factor 1
Last OS Error 0
Failed to execute SystemTaskEntryPoint: unable to allocate MsqlXactManager2022-08-19 15:31:34.93 Server Error: 17312, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Failed to start system task System Task
Failed to start system task System Task
Failed to start system task System Task
Failed to start system task System Task
Failed to start system task System Task
Failed to start system task System Task
Failed to start system task System Task
Failed to start system task System Task
2022-08-19 15:31:34.94 spid25s Error: 26022, Severity: 10, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
Failed to start system task System Task
2022-08-19 15:31:34.95 spid17s
Memory node Id = 0 KB
---------------------------------------- ----------
VM Reserved 1868444
VM Committed 106280
Locked Pages Allocated 0
Pages Allocated 80920
Pages Free 576
Target Committed 106280
Current Committed 106280
Foreign Committed 0
Away Committed 0
Taken Away Committed 0
2022-08-19 15:31:34.96 spid23s Error: 19032, Severity: 10, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
2022-08-19 15:31:34.96 Server Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
2022-08-19 15:31:34.96 Server Server is listening on [ ::1 <ipv6> 1434].
2022-08-19 15:31:34.97 spid17s
Memory node Id = 64 KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 36
Locked Pages Allocated 0
Failed to start system task System Task
2022-08-19 15:31:34.97 Server Server is listening on [ 127.0.0.1 <ipv4> 1434].
2022-08-19 15:31:34.98 spid17s
MEMORYCLERK_XE_BUFFER (node 0) KB
---------------------------------------- ----------
VM Reserved 8448
VM Committed 8448
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 0
2022-08-19 15:31:34.98 Server Dedicated admin connection support was established for listening locally on port 1434.
2022-08-19 15:31:34.98 spid17s
MEMORYCLERK_HOST (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 32
2022-08-19 15:31:34.99 spid17s
MEMORYCLERK_SOSNODE (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 38176
2022-08-19 15:31:34.99 spid17s
MEMORYCLERK_SOSNODE (node 64) KB
---------------------------------------- ----------
VM Reserved 0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment