search

microsoft / mssql-docker

Official Microsoft repository for SQL Server in Docker resources
MIT License
1.72k stars 759 forks source link

2019-CU13-ubuntu-20.04 image sometimes causes collation conflict or deadlocked error #724

Closed ebyhr closed 2 years ago

ebyhr commented 2 years ago

2019 CU images sometimes cause below error when executing DatabaseMetaData.getTables() (≒ sp_tables procedure) from JDBC driver. This issue didn't happen in 2017 images. I tried 2019-CU12-ubuntu-20.04 and some other images, but I couldn't find the exact version which this issue started. 

Exception in thread "main" com.microsoft.sqlserver.jdbc.SQLServerException: Cannot resolve collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CS_AS" in UNION ALL operator occurring in SELECT statement column 2.
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1632)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:602)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:524)
    at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7418)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3272)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:247)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:222)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQueryInternal(SQLServerPreparedStatement.java:460)
    at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetFromStoredProc(SQLServerDatabaseMetaData.java:354)
    at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetWithProvidedColumnNames(SQLServerDatabaseMetaData.java:366)
    at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getTables(SQLServerDatabaseMetaData.java:549)
    at SqlServer.main(SqlServer.java:14)
ebyhr commented 2 years ago

Docker logs

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.
2021-10-22 05:01:47.51 Server      Setup step is copying system data file 'C:\templatedata\master.mdf' to '/var/opt/mssql/data/master.mdf'.
2021-10-22 05:01:47.57 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.
2021-10-22 05:01:47.57 Server      Setup step is copying system data file 'C:\templatedata\mastlog.ldf' to '/var/opt/mssql/data/mastlog.ldf'.
2021-10-22 05:01:47.58 Server      Setup step is copying system data file 'C:\templatedata\model.mdf' to '/var/opt/mssql/data/model.mdf'.
2021-10-22 05:01:47.59 Server      Setup step is copying system data file 'C:\templatedata\modellog.ldf' to '/var/opt/mssql/data/modellog.ldf'.
2021-10-22 05:01:47.60 Server      Setup step is copying system data file 'C:\templatedata\msdbdata.mdf' to '/var/opt/mssql/data/msdbdata.mdf'.
2021-10-22 05:01:47.62 Server      Setup step is copying system data file 'C:\templatedata\msdblog.ldf' to '/var/opt/mssql/data/msdblog.ldf'.
2021-10-22 05:01:47.63 Server      Setup step is FORCE copying system data file 'C:\templatedata\model_replicatedmaster.mdf' to '/var/opt/mssql/data/model_replicatedmaster.mdf'.
2021-10-22 05:01:47.64 Server      Setup step is FORCE copying system data file 'C:\templatedata\model_replicatedmaster.ldf' to '/var/opt/mssql/data/model_replicatedmaster.ldf'.
2021-10-22 05:01:47.65 Server      Setup step is FORCE copying system data file 'C:\templatedata\model_msdbdata.mdf' to '/var/opt/mssql/data/model_msdbdata.mdf'.
2021-10-22 05:01:47.68 Server      Setup step is FORCE copying system data file 'C:\templatedata\model_msdblog.ldf' to '/var/opt/mssql/data/model_msdblog.ldf'.
2021-10-22 05:01:47.74 Server      Microsoft SQL Server 2019 (RTM-CU13) (KB5005679) - 15.0.4178.1 (X64)
    Sep 23 2021 16:47:49
    Copyright (C) 2019 Microsoft Corporation
    Developer Edition (64-bit) on Linux (Ubuntu 20.04.3 LTS) <X64>
2021-10-22 05:01:47.75 Server      UTC adjustment: 0:00
2021-10-22 05:01:47.75 Server      (c) Microsoft Corporation.
2021-10-22 05:01:47.76 Server      All rights reserved.
2021-10-22 05:01:47.76 Server      Server process ID is 380.
2021-10-22 05:01:47.76 Server      Logging SQL Server messages in file '/var/opt/mssql/log/errorlog'.
2021-10-22 05:01:47.76 Server      Registry startup parameters:
     -d /var/opt/mssql/data/master.mdf
     -l /var/opt/mssql/data/mastlog.ldf
     -e /var/opt/mssql/log/errorlog
2021-10-22 05:01:47.77 Server      SQL Server detected 8 sockets with 1 cores per socket and 1 logical processors per socket, 8 total logical processors; using 8 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
2021-10-22 05:01:47.78 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2021-10-22 05:01:47.79 Server      Detected 6368 MB of RAM. This is an informational message; no user action is required.
2021-10-22 05:01:47.79 Server      Using conventional memory in the memory manager.
2021-10-22 05:01:47.79 Server      Page exclusion bitmap is enabled.
2021-10-22 05:01:47.85 Server      Buffer pool extension is not supported on Linux platform.
2021-10-22 05:01:47.85 Server      Buffer Pool: Allocating 1048576 bytes for 938128 hashPages.
2021-10-22 05:01:48.06 Server      Buffer pool extension is already disabled. No action is necessary.
2021-10-22 05:01:48.38 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'].
2021-10-22 05:01:48.41 Server      Query Store settings initialized with enabled = 1,
2021-10-22 05:01:48.43 Server      The maximum number of dedicated administrator connections for this instance is '1'
2021-10-22 05:01:48.44 Server      Node configuration: node 0: CPU mask: 0x00000000000000ff:0 Active CPU mask: 0x00000000000000ff:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2021-10-22 05:01:48.45 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.
2021-10-22 05:01:48.47 Server      In-Memory OLTP initialized on lowend machine.
2021-10-22 05:01:48.49 Server      [INFO] Created Extended Events session 'hkenginexesession'
2021-10-22 05:01:48.49 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.
2021-10-22 05:01:48.51 Server      Total Log Writer threads: 2. This is an informational message; no user action is required.
2021-10-22 05:01:48.52 Server      clflush is selected for pmem flush operation.
2021-10-22 05:01:48.53 Server      Software Usage Metrics is disabled.
2021-10-22 05:01:48.59 spid9s      [1]. Feature Status: PVS: 0. CTR: 0. ConcurrentPFSUpdate: 1.
2021-10-22 05:01:48.60 spid9s      Starting up database 'master'.
ForceFlush feature is enabled for log durability.
2021-10-22 05:01:48.64 Server      CLR version v4.0.30319 loaded.
2021-10-22 05:01:48.79 spid9s      Converting database 'master' from version 897 to the current version 904.
2021-10-22 05:01:48.79 spid9s      Database 'master' running the upgrade step from version 897 to version 898.
2021-10-22 05:01:48.81 spid9s      Database 'master' running the upgrade step from version 898 to version 899.
2021-10-22 05:01:48.84 spid9s      Database 'master' running the upgrade step from version 899 to version 900.
2021-10-22 05:01:48.86 spid9s      Database 'master' running the upgrade step from version 900 to version 901.
2021-10-22 05:01:48.87 spid9s      Database 'master' running the upgrade step from version 901 to version 902.
2021-10-22 05:01:48.89 spid9s      Database 'master' running the upgrade step from version 902 to version 903.
2021-10-22 05:01:48.89 spid9s      Database 'master' running the upgrade step from version 903 to version 904.
2021-10-22 05:01:49.18 Server      Common language runtime (CLR) functionality initialized.
2021-10-22 05:01:49.26 spid9s      Resource governor reconfiguration succeeded.
2021-10-22 05:01:49.26 spid9s      SQL Server Audit is starting the audits. This is an informational message. No user action is required.
2021-10-22 05:01:49.26 spid9s      SQL Server Audit has started the audits. This is an informational message. No user action is required.
2021-10-22 05:01:49.31 spid9s      SQL Trace ID 1 was started by login "sa".
2021-10-22 05:01:49.32 spid9s      Server name is '2db04a290cdd'. This is an informational message only. No user action is required.
2021-10-22 05:01:49.32 spid24s     Password policy update was successful.
2021-10-22 05:01:49.40 spid27s     Always On: The availability replica manager is starting. This is an informational message only. No user action is required.
2021-10-22 05:01:49.41 spid27s     Always On: The availability replica manager is waiting for the instance of SQL Server to allow client connections. This is an informational message only. No user action is required.
2021-10-22 05:01:49.42 spid15s     [32767]. Feature Status: PVS: 0. CTR: 0. ConcurrentPFSUpdate: 1.
2021-10-22 05:01:49.43 spid9s      [4]. Feature Status: PVS: 0. CTR: 0. ConcurrentPFSUpdate: 1.
2021-10-22 05:01:49.44 spid9s      Starting up database 'msdb'.
2021-10-22 05:01:49.44 spid15s     Starting up database 'mssqlsystemresource'.
2021-10-22 05:01:49.45 spid15s     The resource database build version is 15.00.4178. This is an informational message only. No user action is required.
2021-10-22 05:01:49.54 spid9s      The tail of the log for database msdb is being rewritten to match the new sector size of 4096 bytes.  3072 bytes at offset 50176 in file /var/opt/mssql/data/MSDBLog.ldf will be written.
2021-10-22 05:01:49.57 spid15s     [3]. Feature Status: PVS: 0. CTR: 0. ConcurrentPFSUpdate: 1.
2021-10-22 05:01:49.57 spid15s     Starting up database 'model'.
2021-10-22 05:01:49.60 spid9s      Converting database 'msdb' from version 897 to the current version 904.
2021-10-22 05:01:49.60 spid24s     A self-generated certificate was successfully loaded for encryption.
2021-10-22 05:01:49.60 spid9s      Database 'msdb' running the upgrade step from version 897 to version 898.
2021-10-22 05:01:49.61 spid24s     Server is listening on [ 'any' <ipv6> 1433].
2021-10-22 05:01:49.62 spid24s     Server is listening on [ 'any' <ipv4> 1433].
2021-10-22 05:01:49.62 Server      Server is listening on [ ::1 <ipv6> 1434].
2021-10-22 05:01:49.62 Server      Server is listening on [ 127.0.0.1 <ipv4> 1434].
2021-10-22 05:01:49.62 Server      Dedicated admin connection support was established for listening locally on port 1434.
2021-10-22 05:01:49.63 spid9s      Database 'msdb' running the upgrade step from version 898 to version 899.
2021-10-22 05:01:49.64 spid24s     Server is listening on [ ::1 <ipv6> 1431].
2021-10-22 05:01:49.64 spid24s     Server is listening on [ 127.0.0.1 <ipv4> 1431].
2021-10-22 05:01:49.65 spid24s     SQL Server is now ready for client connections. This is an informational message; no user action is required.
2021-10-22 05:01:49.66 spid15s     The tail of the log for database model is being rewritten to match the new sector size of 4096 bytes.  512 bytes at offset 73216 in file /var/opt/mssql/data/modellog.ldf will be written.
2021-10-22 05:01:49.68 spid9s      Database 'msdb' running the upgrade step from version 899 to version 900.
2021-10-22 05:01:49.70 spid15s     Converting database 'model' from version 897 to the current version 904.
2021-10-22 05:01:49.70 spid15s     Database 'model' running the upgrade step from version 897 to version 898.
2021-10-22 05:01:49.70 spid9s      Database 'msdb' running the upgrade step from version 900 to version 901.
2021-10-22 05:01:49.72 spid15s     Database 'model' running the upgrade step from version 898 to version 899.
2021-10-22 05:01:49.72 spid9s      Database 'msdb' running the upgrade step from version 901 to version 902.
2021-10-22 05:01:49.73 spid15s     Database 'model' running the upgrade step from version 899 to version 900.
2021-10-22 05:01:49.74 spid15s     Database 'model' running the upgrade step from version 900 to version 901.
2021-10-22 05:01:49.75 spid15s     Database 'model' running the upgrade step from version 901 to version 902.
2021-10-22 05:01:49.76 spid15s     Database 'model' running the upgrade step from version 902 to version 903.
2021-10-22 05:01:49.77 spid15s     Database 'model' running the upgrade step from version 903 to version 904.
2021-10-22 05:01:49.88 spid15s     Clearing tempdb database.
2021-10-22 05:01:49.99 spid15s     [2]. Feature Status: PVS: 0. CTR: 0. ConcurrentPFSUpdate: 1.
2021-10-22 05:01:49.99 spid15s     Starting up database 'tempdb'.
2021-10-22 05:01:50.09 spid15s     The tempdb database has 1 data file(s).
2021-10-22 05:01:50.10 spid29s     The Service Broker endpoint is in disabled or stopped state.
2021-10-22 05:01:50.11 spid29s     The Database Mirroring endpoint is in disabled or stopped state.
2021-10-22 05:01:50.12 spid29s     Service Broker manager has started.
2021-10-22 05:01:50.13 spid9s      Database 'msdb' running the upgrade step from version 902 to version 903.
2021-10-22 05:01:50.14 spid9s      Database 'msdb' running the upgrade step from version 903 to version 904.
2021-10-22 05:01:50.23 spid9s      Recovery is complete. This is an informational message only. No user action is required.
2021-10-22 05:01:50.25 spid27s     The default language (LCID 0) has been set for engine and full-text services.
2021-10-22 05:01:50.35 spid27s     Warning ******************
2021-10-22 05:01:50.35 spid27s     Attempting to change default collation to Latin1_General_CS_AS.
2021-10-22 05:01:50.37 spid17s     Using 'dbghelp.dll' version '4.0.5'
2021-10-22 05:01:50.38 spid17s     ***Stack Dump being sent to /var/opt/mssql/log/SQLDump0001.txt
2021-10-22 05:01:50.39 spid17s     SqlDumpExceptionHandler: Process 17 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
2021-10-22 05:01:50.39 spid17s     * *******************************************************************************
2021-10-22 05:01:50.39 spid17s     *
2021-10-22 05:01:50.39 spid17s     * BEGIN STACK DUMP:
2021-10-22 05:01:50.39 spid17s     *   10/22/21 05:01:50 spid 17
2021-10-22 05:01:50.39 spid17s     *
2021-10-22 05:01:50.39 spid17s     *
2021-10-22 05:01:50.40 spid17s     *   Exception Address = 000000098225C28D Module(sqlmin+000000000018C28D)
2021-10-22 05:01:50.40 spid17s     *   Exception Code    = c0000005 EXCEPTION_ACCESS_VIOLATION
2021-10-22 05:01:50.40 spid17s     *   Access Violation occurred reading address 0000000000000010
2021-10-22 05:01:50.40 spid17s     *
2021-10-22 05:01:50.40 spid17s     *
2021-10-22 05:01:50.40 spid17s     *  MODULE                          BASE      END       SIZE
2021-10-22 05:01:50.40 spid17s     * sqlservr                       0000000980230000  00000009802CEFFF  0009f000
2021-10-22 05:01:50.41 spid17s     * ntdll                          0000000980040000  0000000980227FFF  001e8000
2021-10-22 05:01:50.41 spid17s     * KERNEL32                       00000009815A0000  0000000981657FFF  000b8000
2021-10-22 05:01:50.41 spid17s     * KERNELBASE                     0000000981A30000  0000000981CA9FFF  0027a000
2021-10-22 05:01:50.41 spid17s     * NETAPI32                       00000009816A0000  00000009816B6FFF  00017000
2021-10-22 05:01:50.41 spid17s     * pdh                            00000009816C0000  000000098170BFFF  0004c000
2021-10-22 05:01:50.41 spid17s     * CRYPT32                        0000000981D80000  0000000981F61FFF  001e2000
2021-10-22 05:01:50.42 spid17s     * ADVAPI32                       0000000981710000  0000000981725FFF  00016000
2021-10-22 05:01:50.42 spid17s     * ole32                          0000000981F70000  00000009820C1FFF  00152000
2021-10-22 05:01:50.42 spid17s     * SQLOS                          0000000980020000  0000000980027FFF  00008000
2021-10-22 05:01:50.42 spid17s     * sqlmin                         00000009820D0000  0000000985127FFF  03058000
2021-10-22 05:01:50.42 spid17s     * sqllang                        0000000985130000  0000000987768FFF  02639000
2021-10-22 05:01:50.42 spid17s     * sqlTsEs                        0000000987770000  000000098803BFFF  008cc000
2021-10-22 05:01:50.42 spid17s     * sqldk                          0000000988040000  000000098856CFFF  0052d000
2021-10-22 05:01:50.43 spid17s     * opends60                       0000000988570000  0000000988578FFF  00009000
2021-10-22 05:01:50.43 spid17s     * qds                            0000000988580000  00000009886ABFFF  0012c000
2021-10-22 05:01:50.43 spid27s      index restored for master.syspriorities.
2021-10-22 05:01:50.43 spid17s     * svl                            00000009886B0000  00000009886DCFFF  0002d000
2021-10-22 05:01:50.43 spid17s     * MSVCP140                       00000009886E0000  000000098877AFFF  0009b000
2021-10-22 05:01:50.44 spid17s     * MPR                            0000000988780000  0000000988789FFF  0000a000
2021-10-22 05:01:50.44 spid17s     * VCRUNTIME140                   0000000988790000  00000009887A4FFF  00015000
2021-10-22 05:01:50.44 spid27s      index restored for master.sysbrickfiles.
2021-10-22 05:01:50.44 spid17s     * ucrtbase                       00000009887B0000  00000009888A7FFF  000f8000
2021-10-22 05:01:50.44 spid17s     * msvcrt                         00000009888B0000  000000098894DFFF  0009e000
2021-10-22 05:01:50.44 spid27s      index restored for master.sysowners.
2021-10-22 05:01:50.44 spid17s     * RPCRT4                         0000000988950000  0000000988961FFF  00012000
2021-10-22 05:01:50.44 spid27s      index restored for master.sysdbreg.
2021-10-22 05:01:50.44 spid17s     * sechost                        0000000988970000  00000009889CDFFF  0005e000
2021-10-22 05:01:50.45 spid17s     * MSASN1                         00000009889D0000  00000009889E1FFF  00012000
2021-10-22 05:01:50.45 spid17s     * combase                        00000009889F0000  0000000988D19FFF  0032a000
2021-10-22 05:01:50.45 spid17s     * GDI32                          0000000988D20000  0000000988D47FFF  00028000
2021-10-22 05:01:50.45 spid17s     * USER32                         0000000988D50000  0000000988EE4FFF  00195000
2021-10-22 05:01:50.45 spid27s      index restored for master.sysschobjs.
2021-10-22 05:01:50.45 spid17s     * Secur32                        0000000988EF0000  0000000988EF9FFF  0000a000
2021-10-22 05:01:50.45 spid27s      index restored for master.sysextsources.
2021-10-22 05:01:50.45 spid17s     * WS2_32                         0000000988F00000  0000000988F6BFFF  0006c000
2021-10-22 05:01:50.45 spid27s      index restored for master.sysextfileformats.
2021-10-22 05:01:50.46 spid17s     * WINHTTP                        0000000988F70000  000000098904FFFF  000e0000
2021-10-22 05:01:50.46 spid17s     * OLEAUT32                       0000000989050000  0000000989111FFF  000c2000
2021-10-22 05:01:50.46 spid17s     * ODBC32                         0000000989120000  00000009891D3FFF  000b4000
2021-10-22 05:01:50.46 spid17s     * secforwarder                   00000009891E0000  00000009891EDFFF  0000e000
2021-10-22 05:01:50.46 spid17s     * USERENV                        00000009891F0000  0000000989217FFF  00028000
2021-10-22 05:01:50.46 spid17s     * AUTHZ                          0000000989220000  000000098926AFFF  0004b000
2021-10-22 05:01:50.46 spid17s     * WINTRUST                       0000000989270000  00000009892C6FFF  00057000
2021-10-22 05:01:50.47 spid17s     * XmlLite                        00000009892D0000  0000000989308FFF  00039000
2021-10-22 05:01:50.47 spid27s      index restored for master.syscolpars.
2021-10-22 05:01:50.47 spid17s     * dhcpcsvc                       0000000989310000  0000000989329FFF  0001a000
2021-10-22 05:01:50.47 spid27s      index restored for master.sysxlgns.
2021-10-22 05:01:50.47 spid17s     * WININET                        0000000989330000  00000009897EBFFF  004bc000
2021-10-22 05:01:50.47 spid27s      index restored for master.sysxsrvs.
2021-10-22 05:01:50.47 spid17s     * WINMM                          00000009897F0000  0000000989813FFF  00024000
2021-10-22 05:01:50.47 spid27s      index restored for master.sysnsobjs.
2021-10-22 05:01:50.47 spid17s     * DkDll                          0000000989820000  0000000989828FFF  00009000
2021-10-22 05:01:50.47 spid27s      index restored for master.syscerts.
2021-10-22 05:01:50.47 spid17s     * bcryptPrimitives               0000000989830000  00000009898AAFFF  0007b000
2021-10-22 05:01:50.48 spid27s      index restored for master.sysrmtlgns.
2021-10-22 05:01:50.48 spid17s     * gdi32full                      00000009898B0000  0000000989A43FFF  00194000
2021-10-22 05:01:50.48 spid27s      index restored for master.sysxprops.
2021-10-22 05:01:50.48 spid17s     * win32u                         0000000989A50000  0000000989A6FFFF  00020000
2021-10-22 05:01:50.48 spid17s     * msvcp_win                      0000000989A70000  0000000989B0EFFF  0009f000
2021-10-22 05:01:50.48 spid27s      index restored for master.sysscalartypes.
2021-10-22 05:01:50.48 spid17s     * profapi                        0000000989B10000  0000000989B2EFFF  0001f000
2021-10-22 05:01:50.48 spid27s      index restored for master.sysidxstats.
2021-10-22 05:01:50.48 spid17s     * NSI                            0000000989B30000  0000000989B38FFF  00009000
2021-10-22 05:01:50.49 spid27s      index restored for master.sysendpts.
2021-10-22 05:01:50.49 spid17s     * WINMMBASE                      0000000989B40000  0000000989B69FFF  0002a000
2021-10-22 05:01:50.49 spid27s      index restored for master.sysclsobjs.
2021-10-22 05:01:50.49 spid17s     * sqlpal                         00003FFF9E000000  00003FFF9EFFFFFF  01000000
2021-10-22 05:01:50.49 spid27s      index restored for master.sysremsvcbinds.
2021-10-22 05:01:50.49 spid17s     * NETUTILS                       0000000989B70000  0000000989B7DFFF  0000e000
2021-10-22 05:01:50.49 spid27s      index restored for master.sysrts.
2021-10-22 05:01:50.49 spid17s     * rpcrt4_NT                      0000000989B80000  0000000989CA5FFF  00126000
2021-10-22 05:01:50.49 spid27s      index restored for master.sysasymkeys.
2021-10-22 05:01:50.49 spid17s     * DPAPI                          0000000989CB0000  0000000989CB9FFF  0000a000
2021-10-22 05:01:50.49 spid27s      index restored for master.syssqlguides.
2021-10-22 05:01:50.49 spid17s     * cfgmgr32                       0000000989CC0000  0000000989D08FFF  00049000
2021-10-22 05:01:50.50 spid27s      index restored for master.syssoftobjrefs.
2021-10-22 05:01:50.50 spid17s     * advapi32_NT                    0000000989D10000  0000000989DB0FFF  000a1000
2021-10-22 05:01:50.50 spid17s     * SAMCLI                         0000000989DC0000  0000000989DD7FFF  00018000
2021-10-22 05:01:50.50 spid17s     * securityapi                    0000000989DE0000  0000000989E40FFF  00061000
2021-10-22 05:01:50.50 spid27s      index restored for master.MSreplication_options.
2021-10-22 05:01:50.50 spid17s     * secur32_NT                     0000000989E50000  0000000989E5BFFF  0000c000
2021-10-22 05:01:50.50 spid17s     * bcrypt                         0000000989E60000  0000000989E84FFF  00025000
2021-10-22 05:01:50.50 spid17s     * SSPICLI                        0000000989E90000  0000000989EBFFFF  00030000
2021-10-22 05:01:50.51 spid17s     * LOGONCLI                       0000000989EC0000  0000000989EFDFFF  0003e000
2021-10-22 05:01:50.51 spid17s     * psapi                          0000000989F60000  0000000989F67FFF  00008000
2021-10-22 05:01:50.51 spid17s     * ncrypt                         0000000989FA0000  0000000989FC5FFF  00026000
2021-10-22 05:01:50.51 spid17s     * NTASN1                         0000000989FD0000  000000098A005FFF  00036000
2021-10-22 05:01:50.51 spid17s     * kernel.appcore                 000000098A870000  000000098A880FFF  00011000
2021-10-22 05:01:50.52 spid17s     * instapi150                     000000098A8A0000  000000098A8B3FFF  00014000
2021-10-22 05:01:50.52 spid17s     * CRYPTSP                        000000098A8C0000  000000098A8D6FFF  00017000
2021-10-22 05:01:50.52 spid17s     * rsaenh                         000000098A8E0000  000000098A913FFF  00034000
2021-10-22 05:01:50.52 spid17s     * CRYPTBASE                      000000098A920000  000000098A92AFFF  0000b000
2021-10-22 05:01:50.52 spid17s     * imagehlp                       000000098AD50000  000000098AD6CFFF  0001d000
2021-10-22 05:01:50.52 spid17s     * gpapi                          000000098AE80000  000000098AEA1FFF  00022000
2021-10-22 05:01:50.53 spid17s     * cryptnet                       000000098B0B0000  000000098B0DDFFF  0002e000
2021-10-22 05:01:50.53 spid17s     * wkscli                         000000098B120000  000000098B136FFF  00017000
2021-10-22 05:01:50.53 spid17s     * cscapi                         000000098B140000  000000098B151FFF  00012000
2021-10-22 05:01:50.54 spid17s     * sqlevn70                       000000098B160000  000000098B49EFFF  0033f000
2021-10-22 05:01:50.54 spid17s     * SQLVDI                         00000009D9E30000  00000009D9E6AFFF  0003b000
2021-10-22 05:01:50.54 spid17s     * VERSION                        00000009D9E70000  00000009D9E79FFF  0000a000
2021-10-22 05:01:50.55 spid17s     * hkruntime                      00000009DA2C0000  00000009DA592FFF  002d3000
2021-10-22 05:01:50.55 spid17s     * hkcompile                      00000009DA5A0000  00000009DA6DFFFF  00140000
2021-10-22 05:01:50.55 spid17s     * hkengine                       00000009DA6E0000  00000009DADD5FFF  006f6000
2021-10-22 05:01:50.55 spid17s     * dbghelp                        00000009DADE0000  00000009DAFA8FFF  001c9000
2021-10-22 05:01:50.55 spid17s     * SHLWAPI                        00000009DAFB0000  00000009DB000FFF  00051000
2021-10-22 05:01:50.56 spid17s     * msv1_0                         00000009DB010000  00000009DB081FFF  00072000
2021-10-22 05:01:50.56 spid17s     * NtlmShared                     00000009DB090000  00000009DB09CFFF  0000d000
2021-10-22 05:01:50.56 spid17s     * cryptdll                       00000009DB0A0000  00000009DB0B3FFF  00014000
2021-10-22 05:01:50.56 spid27s      index restored for tempdb.syspriorities.
2021-10-22 05:01:50.56 spid17s     * kerberos                       00000009DB0F0000  00000009DB1DDFFF  000ee000
2021-10-22 05:01:50.57 spid27s      index restored for tempdb.sysowners.
2021-10-22 05:01:50.57 spid17s     * schannel                       00000009DB1E0000  00000009DB257FFF  00078000
2021-10-22 05:01:50.57 spid27s      index restored for tempdb.sysdbreg.
2021-10-22 05:01:50.57 spid17s     * SECURITY                       00000009DB0C0000  00000009DB0C2FFF  00003000
2021-10-22 05:01:50.57 spid17s     * MSCOREE                        00000009DB260000  00000009DB2C3FFF  00064000
2021-10-22 05:01:50.58 spid17s     * mscoreei                       00000009DB310000  00000009DB3ABFFF  0009c000
2021-10-22 05:01:50.58 spid17s     * SqlServerSpatial150            00000009DB800000  00000009DB8A1FFF  000a2000
2021-10-22 05:01:50.58 spid27s      index restored for tempdb.sysschobjs.
2021-10-22 05:01:50.58 spid17s     * CLUSAPI                        00000009DB8B0000  00000009DB9AAFFF  000fb000
2021-10-22 05:01:50.58 spid27s      index restored for tempdb.sysextsources.
2021-10-22 05:01:50.58 spid17s     * DNSAPI                         00000009DB9B0000  00000009DB9BAFFF  0000b000
2021-10-22 05:01:50.58 spid27s      index restored for tempdb.sysextfileformats.
2021-10-22 05:01:50.58 spid17s     * RESUTILS                       00000009DB9C0000  00000009DBA5AFFF  0009b000
2021-10-22 05:01:50.59 spid17s     * clbcatq                        00000009DD980000  00000009DDA21FFF  000a2000
2021-10-22 05:01:50.59 spid27s      index restored for tempdb.syscolpars.
2021-10-22 05:01:50.59 spid17s     * msxml3                         00000009DDA30000  00000009DDC63FFF  00234000
2021-10-22 05:01:50.59 spid27s      index restored for tempdb.sysxlgns.
2021-10-22 05:01:50.59 spid17s     * SAMLIB                         00000009DDD70000  00000009DDD92FFF  00023000
2021-10-22 05:01:50.59 spid27s      index restored for tempdb.sysxsrvs.
2021-10-22 05:01:50.59 spid17s     * msoledbsql                     00000009E0720000  00000009E0994FFF  00275000
2021-10-22 05:01:50.60 spid17s     * COMDLG32                       00000009E0BB0000  00000009E0C9FFFF  000f0000
2021-10-22 05:01:50.60 spid27s      index restored for tempdb.sysnsobjs.
2021-10-22 05:01:50.60 spid17s     * SHELL32                        00000009E10A0000  00000009E251AFFF  0147b000
2021-10-22 05:01:50.60 spid27s      index restored for tempdb.syscerts.
2021-10-22 05:01:50.60 spid17s     * IPHLPAPI                       00000009DDDB0000  00000009DDDBEFFF  0000f000
2021-10-22 05:01:50.60 spid27s      index restored for tempdb.sysrmtlgns.
2021-10-22 05:01:50.60 spid17s     * shcore                         00000009DDE70000  00000009DDF18FFF  000a9000
2021-10-22 05:01:50.60 spid27s      index restored for tempdb.sysxprops.
2021-10-22 05:01:50.60 spid17s     * COMCTL32                       00000009E2520000  00000009E25C6FFF  000a7000
2021-10-22 05:01:50.61 spid17s     * windows.storage                00000009E25D0000  00000009E2D04FFF  00735000
2021-10-22 05:01:50.61 spid27s      index restored for tempdb.sysscalartypes.
2021-10-22 05:01:50.61 spid17s     * powrprof                       00000009DDDC0000  00000009DDE0BFFF  0004c000
2021-10-22 05:01:50.61 spid17s     * FLTLIB                         00000009DDE10000  00000009DDE19FFF  0000a000
2021-10-22 05:01:50.61 spid27s      index restored for tempdb.sysidxstats.
2021-10-22 05:01:50.61 spid17s     * sqlncli11                      00000009E3090000  00000009E33E2FFF  00353000
2021-10-22 05:01:50.61 spid27s      index restored for tempdb.sysendpts.
2021-10-22 05:01:50.61 spid17s     * MSVCR100                       00000009E2D10000  00000009E2DE1FFF  000d2000
2021-10-22 05:01:50.61 spid27s      index restored for tempdb.sysclsobjs.
2021-10-22 05:01:50.62 spid17s     * netbios                        00000009DDF50000  00000009DDF5BFFF  0000c000
2021-10-22 05:01:50.62 spid27s      index restored for tempdb.sysremsvcbinds.
2021-10-22 05:01:50.62 spid17s     * clr                            00000009E3F90000  00000009E497BFFF  009ec000
2021-10-22 05:01:50.62 spid27s      index restored for tempdb.sysrts.
2021-10-22 05:01:50.62 spid17s     * MSVCR120_CLR0400               00000009E33F0000  00000009E34E6FFF  000f7000
2021-10-22 05:01:50.62 spid27s      index restored for tempdb.sysasymkeys.
2021-10-22 05:01:50.62 spid17s     * BatchParser                    00000009E3530000  00000009E3559FFF  0002a000
2021-10-22 05:01:50.62 spid27s      index restored for tempdb.syssqlguides.
2021-10-22 05:01:50.62 spid17s     * clrjit                         00000009E6020000  00000009E614AFFF  0012b000
2021-10-22 05:01:50.63 spid27s      index restored for tempdb.syssoftobjrefs.
2021-10-22 05:01:50.63 spid17s     * SqlAccess                      00000009E62F0000  00000009E6365FFF  00076000
2021-10-22 05:01:50.63 spid17s     * SRVCLI                         00000009E3F20000  00000009E3F45FFF  00026000
2021-10-22 05:01:50.63 spid17s     * mswsock                        00000009E7710000  00000009E7775FFF  00066000
2021-10-22 05:01:50.63 spid17s     *
2021-10-22 05:01:50.64 spid17s     *     P1Home: 0000000EDE700400:  0000000000000000  0000000000000000  0000000000000000  0000000000000000  0000000000000000  0000000983D6FB50
2021-10-22 05:01:50.64 spid17s     *     P2Home: 0001000000180001:
2021-10-22 05:01:50.64 spid17s     *     P3Home: 00000009CDC7D380:  0000000000000000  0000000000000010  0000000000000000  0000000000000000  0000000000000000  0000000000000000
2021-10-22 05:01:50.64 spid52      [5]. Feature Status: PVS: 0. CTR: 0. ConcurrentPFSUpdate: 1.
2021-10-22 05:01:50.64 spid17s     *     P4Home: 0000000000000000:
2021-10-22 05:01:50.65 spid52      Starting up database 'database_5d6b037a4f6d41d59b153b61b25ba0b2'.
2021-10-22 05:01:50.65 spid17s     *     P5Home: 0000000EE847A240:  0000000E00000003  0000000EE847A398  0000000000000040  0000000EE93D0040  0000000EE847ABB0  0000000000000200
2021-10-22 05:01:50.65 spid17s     *     P6Home: 0000000000180000:
2021-10-22 05:01:50.65 spid17s     * ContextFlags: 000000000010000F:
2021-10-22 05:01:50.65 spid17s     *      MxCsr: 0000000000001FA0:
2021-10-22 05:01:50.65 spid17s     *      SegCs: 0000000000000033:
2021-10-22 05:01:50.66 spid17s     *      SegDs: 0000000000000000:
2021-10-22 05:01:50.66 spid17s     *      SegEs: 0000000000000000:
2021-10-22 05:01:50.66 spid17s     *      SegFs: 0000000000000000:
2021-10-22 05:01:50.66 spid17s     *      SegGs: 0000000000000000:
2021-10-22 05:01:50.66 spid17s     *      SegSs: 000000000000002B:
2021-10-22 05:01:50.66 spid17s     *     EFlags: 0000000000010246:
2021-10-22 05:01:50.67 spid17s     *        Rax: 0000000000000000:
2021-10-22 05:01:50.67 spid17s     *        Rcx: 0000000EE847BE80:  0000000000000000  0000000000000000  0000000983D656E8  0000000100000001  0000000EE847BEA0  0000000EE847BEA0
2021-10-22 05:01:50.67 spid17s     *        Rdx: 0000000000000002:
2021-10-22 05:01:50.67 spid17s     *        Rbx: 0000000000000002:
2021-10-22 05:01:50.67 spid17s     *        Rsp: 00000009CDC7D430:  0000000EDE862000  00000009880468B9  0000000EEE681FA0  0000000988046A72  0000000EDE862000  0000000EDE8626D0
2021-10-22 05:01:50.67 spid17s     *        Rbp: 00000009CDC7D4A9:  0000000000000000  0000000000000000  6000000000000001  B300000000000000  02000000098225BC  0000000000000000
2021-10-22 05:01:50.68 spid17s     *        Rsi: 0000000EDE8626E0:  0000000EDE863FE0  0002000EFFFFFFFF  0000000000000000  0000000000000000  0000000000000000  0000000000000000
2021-10-22 05:01:50.68 spid17s     *        Rdi: 00000009CDC7D750:  0000000000000007  0000000000000008  0000000000000000  0000000000000010  0000000000000000  0000000000000000
2021-10-22 05:01:50.68 spid17s     *         R8: 00000009CDC7D750:  0000000000000007  0000000000000008  0000000000000000  0000000000000010  0000000000000000  0000000000000000
2021-10-22 05:01:50.69 spid17s     *         R9: 00000009CDC7D630:  0000001800000001  0000000900000001  0000000EE93D0040  0000000000000E82  0000000EE6CCD630  0000000000000001
2021-10-22 05:01:50.69 spid17s     *        R10: 0000000000000000:
2021-10-22 05:01:50.69 spid17s     *        R11: 0000000000000002:
2021-10-22 05:01:50.69 spid27s      index restored for model.syspriorities.
2021-10-22 05:01:50.70 spid17s     *        R12: 0000000000000001:
2021-10-22 05:01:50.70 spid17s     *        R13: 0000000EDE8626E0:  0000000EDE863FE0  0002000EFFFFFFFF  0000000000000000  0000000000000000  0000000000000000  0000000000000000
2021-10-22 05:01:50.70 spid17s     *        R14: 00000009CDC7D750:  0000000000000007  0000000000000008  0000000000000000  0000000000000010  0000000000000000  0000000000000000
2021-10-22 05:01:50.71 spid27s      index restored for model.sysowners.
2021-10-22 05:01:50.71 spid17s     *        R15: 0000000000000002:
2021-10-22 05:01:50.71 spid27s      index restored for model.sysdbreg.
2021-10-22 05:01:50.72 spid17s     *        Rip: 000000098225C28D:  867F860F10503944  89447F458B480171  45B74589C28B4110  000004938E0FDB85  000000D0249C8948  0FFFE73D44158D48
2021-10-22 05:01:50.72 spid17s     * *******************************************************************************
2021-10-22 05:01:50.72 spid17s     * -------------------------------------------------------------------------------
2021-10-22 05:01:50.73 spid17s     * Short Stack Dump
2021-10-22 05:01:50.74 spid27s      index restored for model.sysschobjs.
2021-10-22 05:01:50.74 spid27s      index restored for model.sysextsources.
2021-10-22 05:01:50.75 spid27s      index restored for model.sysextfileformats.
2021-10-22 05:01:50.76 spid27s      index restored for model.syscolpars.
2021-10-22 05:01:50.76 spid27s      index restored for model.sysxlgns.
2021-10-22 05:01:50.76 spid27s      index restored for model.sysxsrvs.
2021-10-22 05:01:50.76 spid17s     000000098225C28D Module(sqlmin+000000000018C28D)
2021-10-22 05:01:50.77 spid27s      index restored for model.sysnsobjs.
2021-10-22 05:01:50.77 spid17s     000000098225C12E Module(sqlmin+000000000018C12E)
2021-10-22 05:01:50.77 spid27s      index restored for model.syscerts.
2021-10-22 05:01:50.77 spid17s     000000098211334A Module(sqlmin+000000000004334A)
2021-10-22 05:01:50.77 spid27s      index restored for model.sysrmtlgns.
2021-10-22 05:01:50.78 spid17s     0000000982168C94 Module(sqlmin+0000000000098C94)
2021-10-22 05:01:50.78 spid27s      index restored for model.sysxprops.
2021-10-22 05:01:50.78 spid17s     0000000982168B1B Module(sqlmin+0000000000098B1B)
2021-10-22 05:01:50.78 spid17s     0000000982168902 Module(sqlmin+0000000000098902)
2021-10-22 05:01:50.78 spid27s      index restored for model.sysscalartypes.
2021-10-22 05:01:50.78 spid17s     0000000982187B4D Module(sqlmin+00000000000B7B4D)
2021-10-22 05:01:50.79 spid17s     0000000982187A77 Module(sqlmin+00000000000B7A77)
2021-10-22 05:01:50.79 spid27s      index restored for model.sysidxstats.
2021-10-22 05:01:50.79 spid17s     000000098218453D Module(sqlmin+00000000000B453D)
2021-10-22 05:01:50.79 spid27s      index restored for model.sysendpts.
2021-10-22 05:01:50.79 spid27s      index restored for model.sysclsobjs.
2021-10-22 05:01:50.80 spid27s      index restored for model.sysremsvcbinds.
2021-10-22 05:01:50.80 spid27s      index restored for model.sysrts.
2021-10-22 05:01:50.80 spid27s      index restored for model.sysasymkeys.
2021-10-22 05:01:50.80 spid27s      index restored for model.syssqlguides.
2021-10-22 05:01:50.81 spid27s      index restored for model.syssoftobjrefs.
2021-10-22 05:01:50.81 spid17s     00000009820F0A03 Module(sqlmin+0000000000020A03)
2021-10-22 05:01:50.81 spid17s     00000009851350FC Module(sqllang+00000000000050FC)
2021-10-22 05:01:50.82 spid17s     00000009820F06B5 Module(sqlmin+00000000000206B5)
2021-10-22 05:01:50.83 spid17s     000000098804A573 Module(sqldk+000000000000A573)
2021-10-22 05:01:50.83 spid17s     000000098804A1FD Module(sqldk+000000000000A1FD)
2021-10-22 05:01:50.83 spid17s     0000000988049DEE Module(sqldk+0000000000009DEE)
2021-10-22 05:01:50.83 spid17s     0000000988063192 Module(sqldk+0000000000023192)
2021-10-22 05:01:50.84 spid17s     0000000988062D5C Module(sqldk+0000000000022D5C)
2021-10-22 05:01:50.84 spid17s     00000009880634D3 Module(sqldk+00000000000234D3)
2021-10-22 05:01:50.85 spid17s     00000009815B4414 Module(KERNEL32+0000000000014414)
2021-10-22 05:01:50.85 spid17s     00000009800B5541 Module(ntdll+0000000000075541)
2021-10-22 05:01:50.88 spid17s     Stack Signature for the dump is 0x00000000C43B1821
2021-10-22 05:01:51.00 spid27s      index restored for msdb.syspriorities.
2021-10-22 05:01:51.00 spid27s      index restored for msdb.sysowners.
2021-10-22 05:01:51.00 spid27s      index restored for msdb.sysdbreg.
2021-10-22 05:01:51.01 spid27s      index restored for msdb.sysschobjs.
2021-10-22 05:01:51.01 spid27s      index restored for msdb.sysextsources.
2021-10-22 05:01:51.02 spid27s      index restored for msdb.sysextfileformats.
2021-10-22 05:01:51.03 spid27s      index restored for msdb.syscolpars.
2021-10-22 05:01:51.03 spid27s      index restored for msdb.sysxlgns.
2021-10-22 05:01:51.03 spid27s      index restored for msdb.sysxsrvs.
2021-10-22 05:01:51.04 spid27s      index restored for msdb.sysnsobjs.
2021-10-22 05:01:51.04 spid27s      index restored for msdb.syscerts.
2021-10-22 05:01:51.04 spid27s      index restored for msdb.sysrmtlgns.
2021-10-22 05:01:51.04 spid27s      index restored for msdb.sysxprops.
2021-10-22 05:01:51.04 spid27s      index restored for msdb.sysscalartypes.
2021-10-22 05:01:51.05 spid27s      index restored for msdb.sysidxstats.
2021-10-22 05:01:51.05 spid27s      index restored for msdb.sysendpts.
2021-10-22 05:01:51.05 spid27s      index restored for msdb.sysclsobjs.
2021-10-22 05:01:51.05 spid27s      index restored for msdb.sysremsvcbinds.
2021-10-22 05:01:51.05 spid27s      index restored for msdb.sysrts.
2021-10-22 05:01:51.06 spid27s      index restored for msdb.sysasymkeys.
2021-10-22 05:01:51.06 spid27s      index restored for msdb.syssqlguides.
2021-10-22 05:01:51.06 spid27s      index restored for msdb.syssoftobjrefs.
2021-10-22 05:01:51.07 spid27s      index restored for msdb.syscachedcredentials.
2021-10-22 05:01:51.07 spid27s      index restored for msdb.syscollector_blobs_internal.
2021-10-22 05:01:51.08 spid27s      index restored for msdb.syspolicy_system_health_state_internal.
2021-10-22 05:01:51.09 spid27s      index restored for msdb.sysmanagement_shared_server_groups_internal.
2021-10-22 05:01:51.10 spid27s      index restored for msdb.sysssispackages.
2021-10-22 05:01:51.10 spid27s      index restored for msdb.sysmanagement_shared_registered_servers_internal.
2021-10-22 05:01:51.11 spid27s      index restored for msdb.sysssispackagefolders.
2021-10-22 05:01:51.12 spid27s      index restored for msdb.sysutility_mi_smo_properties_to_collect_internal.
2021-10-22 05:01:51.13 spid27s      index restored for msdb.syspolicy_configuration_internal.
2021-10-22 05:01:51.13 spid27s      index restored for msdb.log_shipping_primary_databases.
2021-10-22 05:01:51.14 spid27s      index restored for msdb.syspolicy_management_facets.
2021-10-22 05:01:51.15 spid27s      index restored for msdb.syspolicy_facet_events.
2021-10-22 05:01:51.16 spid27s      index restored for msdb.syscollector_config_store_internal.
2021-10-22 05:01:51.16 spid27s      index restored for msdb.sysutility_ucp_dac_health_internal.
2021-10-22 05:01:51.16 spid27s      index restored for msdb.sysmail_profile.
2021-10-22 05:01:51.16 spid27s      index restored for msdb.MSdbms.
2021-10-22 05:01:51.17 spid27s      index restored for msdb.log_shipping_primary_secondaries.
2021-10-22 05:01:51.18 spid27s      index restored for msdb.syspolicy_conditions_internal.
2021-10-22 05:01:51.19 spid27s      index restored for msdb.MSdbms_datatype.
2021-10-22 05:01:51.19 spid27s      index restored for msdb.log_shipping_monitor_primary.
2021-10-22 05:01:51.19 spid27s      index restored for msdb.log_shipping_monitor_history_detail.
2021-10-22 05:01:51.19 spid27s      index restored for msdb.log_shipping_monitor_error_detail.
2021-10-22 05:01:51.20 spid27s      index restored for msdb.log_shipping_secondary.
2021-10-22 05:01:51.20 spid27s      index restored for msdb.log_shipping_secondary_databases.
2021-10-22 05:01:51.20 spid27s      index restored for msdb.sysutility_ucp_managed_instances_internal.
2021-10-22 05:01:51.21 spid27s      index restored for msdb.log_shipping_monitor_secondary.
2021-10-22 05:01:51.21 spid27s      index restored for msdb.sysmail_account.
2021-10-22 05:01:51.21 spid27s      index restored for msdb.sysutility_ucp_mi_health_internal.
2021-10-22 05:01:51.22 spid27s      index restored for msdb.sysdac_instances_internal.
2021-10-22 05:01:51.23 spid27s      index restored for msdb.syscollector_collection_sets_internal.
2021-10-22 05:01:51.23 spid27s      index restored for msdb.syspolicy_policy_categories_internal.
2021-10-22 05:01:51.24 spid27s      index restored for msdb.sysdac_history_internal.
2021-10-22 05:01:51.24 spid27s      index restored for msdb.sysmail_servertype.
2021-10-22 05:01:51.25 spid27s      index restored for msdb.syspolicy_object_sets_internal.
2021-10-22 05:01:51.25 spid27s      index restored for msdb.sysutility_ucp_health_policies_internal.
2021-10-22 05:01:51.26 spid27s      index restored for msdb.sysmail_server.
2021-10-22 05:01:51.26 spid27s      index restored for msdb.sysutility_ucp_filegroups_with_policy_violations_internal.
2021-10-22 05:01:51.27 spid27s      index restored for msdb.sysutility_ucp_policy_check_conditions_internal.
2021-10-22 05:01:51.27 spid27s      index restored for msdb.syscollector_collector_types_internal.
2021-10-22 05:01:51.28 spid27s      index restored for msdb.syspolicy_policies_internal.
2021-10-22 05:01:51.29 spid27s      index restored for msdb.sysutility_ucp_policy_target_conditions_internal.
2021-10-22 05:01:51.29 spid27s      index restored for msdb.sysmail_configuration.
2021-10-22 05:01:51.30 spid27s      index restored for msdb.external_libraries_installed.
2021-10-22 05:01:51.30 spid27s      index restored for msdb.sysdbmaintplan_databases.
2021-10-22 05:01:51.30 spid27s      index restored for msdb.sysutility_ucp_configuration_internal.
2021-10-22 05:01:51.31 spid27s      index restored for msdb.sysproxies.
2021-10-22 05:01:51.31 spid27s      index restored for msdb.syssubsystems.
2021-10-22 05:01:51.31 spid27s      index restored for msdb.syscollector_collection_items_internal.
2021-10-22 05:01:51.32 spid27s      index restored for msdb.sysdownloadlist.
2021-10-22 05:01:51.32 spid27s      index restored for msdb.sysoriginatingservers.
2021-10-22 05:01:51.33 spid27s      index restored for msdb.autoadmin_managed_databases.
2021-10-22 05:01:51.33 spid27s      index restored for msdb.sysjobs.
2021-10-22 05:01:51.34 spid27s      index restored for msdb.smart_backup_files.
2021-10-22 05:01:51.34 spid27s      index restored for msdb.backupset.
2021-10-22 05:01:51.35 spid27s      index restored for msdb.sysjobsteps.
2021-10-22 05:01:51.35 spid27s      index restored for msdb.syscollector_execution_stats_internal.
2021-10-22 05:01:51.36 spid27s      index restored for msdb.sysutility_ucp_mi_file_space_health_internal.
2021-10-22 05:01:51.37 spid27s      index restored for msdb.syspolicy_target_sets_internal.
2021-10-22 05:01:51.37 spid27s      index restored for msdb.sysschedules.
2021-10-22 05:01:51.38 spid27s      index restored for msdb.sysutility_ucp_mi_database_health_internal.
2021-10-22 05:01:51.38 spid27s      index restored for msdb.logmarkhistory.
2021-10-22 05:01:51.38 spid27s      index restored for msdb.sysutility_ucp_dac_file_space_health_internal.
2021-10-22 05:01:51.39 spid27s      index restored for msdb.syscategories.
2021-10-22 05:01:51.39 spid27s      index restored for msdb.systargetservers.
2021-10-22 05:01:51.39 spid27s      index restored for msdb.sysutility_ucp_mi_volume_space_health_internal.
2021-10-22 05:01:51.40 spid27s      index restored for msdb.sysutility_mi_dac_execution_statistics_internal.
2021-10-22 05:01:51.40 spid27s      index restored for msdb.systargetservergroups.
2021-10-22 05:01:51.40 spid27s      index restored for msdb.syspolicy_policy_category_subscriptions_internal.
2021-10-22 05:01:51.41 spid27s      index restored for msdb.sysalerts.
2021-10-22 05:01:51.41 spid27s      index restored for msdb.sysutility_ucp_computer_cpu_health_internal.
2021-10-22 05:01:51.41 spid27s      index restored for msdb.sysutility_mi_session_statistics_internal.
2021-10-22 05:01:51.41 spid27s      index restored for msdb.sysoperators.
2021-10-22 05:01:51.43 spid27s     The default collation was successfully changed.
2021-10-22 05:01:52.60 spid17s     External dump process return code 0x20000001.
External dump process returned no errors.
2021-10-22 05:01:52.60 spid52      Parallel redo is started for database 'database_5d6b037a4f6d41d59b153b61b25ba0b2' with worker pool size [4].
2021-10-22 05:01:52.61 spid52      Recovery completed for database database_5d6b037a4f6d41d59b153b61b25ba0b2 (database ID 5) in 2 second(s) (analysis 1 ms, redo 0 ms, undo 2 ms [system undo 0 ms, regular undo 0 ms].) This is an informational message only. No user action is required.
2021-10-22 05:01:52.62 spid52      Parallel redo is shutdown for database 'database_5d6b037a4f6d41d59b153b61b25ba0b2' with worker pool size [4].
2021-10-22 05:01:52.77 spid52      Setting database option ALLOW_SNAPSHOT_ISOLATION to ON for database 'database_5d6b037a4f6d41d59b153b61b25ba0b2'.
2021-10-22 05:01:52.81 spid52      Setting database option READ_COMMITTED_SNAPSHOT to ON for database 'database_5d6b037a4f6d41d59b153b61b25ba0b2'.
2021-10-22 05:01:52.86 spid52      [5]. Feature Status: PVS: 0. CTR: 0. ConcurrentPFSUpdate: 1.
2021-10-22 05:01:52.86 spid52      Starting up database 'database_5d6b037a4f6d41d59b153b61b25ba0b2'.
2021-10-22 05:01:52.92 spid52      Parallel redo is started for database 'database_5d6b037a4f6d41d59b153b61b25ba0b2' with worker pool size [4].
2021-10-22 05:01:52.96 spid40s     Parallel redo is shutdown for database 'database_5d6b037a4f6d41d59b153b61b25ba0b2' with worker pool size [4].
2021-10-22 05:01:53.07 spid27s     The tempdb database has 8 data file(s).
ebyhr commented 2 years ago

There is no stack dump message when I can call DatabaseMetaData.getTables() successfully.

ebyhr commented 2 years ago

Also, faced deadlocked issue in DatabaseMetaData .getColumns() method:

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 60) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1632)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:602)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:524)
    at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7418)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3272)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:247)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:222)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:446)
    at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getColumns(SQLServerDatabaseMetaData.java:653)
    at io.trino.plugin.jdbc.BaseJdbcClient.getColumns(BaseJdbcClient.java:336)
    at io.trino.plugin.jdbc.BaseJdbcClient.getColumns(BaseJdbcClient.java:268)
    ... 46 more