Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add getR2dbcUrl Method on MariaDB, MySQL, PostgreSQL, MsSQL #9569

Open
wants to merge 1 commit into
base: main
Choose a base branch
from

Conversation

DHKIM-0511
Copy link

I have added functionality to support the getR2dbcUrl method for MySQL, MariaDB, PostgreSQL, and MsSQL, as it was requested in this issue #8797

@eddumelendez
Copy link
Member

Can you add tests, please?

@DHKIM-0511
Copy link
Author

DHKIM-0511 commented Nov 27, 2024

Of course! I'm currently writing and testing the cases. However, I encountered an error in MsSQL Test.

Project error log:

11월 27, 2024 9:32:30 오후 com.microsoft.sqlserver.jdbc.SQLServerConnection prelogin
WARNING: ConnectionID:49 ClientConnectionId: 307fe177-58b3-484d-9704-af971c580c28 Prelogin error: host localhost port 56807 Unexpected end of prelogin response after 0 bytes read

MsSQL Docker container error log:

2024-11-27 09:00:00 11:22:22.82 Logon       Error: 18456, Severity: 14, State: 7.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.82 Logon       Login failed for user 'sa'. Reason: An error occurred while evaluating the password. [CLIENT: 172.17.0.1]

I've found that these error logs keep repeating(but it seems like it's working fine). After researching, it seems that this issue is not only present in "Testcontainers" (#3079) but also appears in "mssql-docker" issues. However, I am unsure how to resolve this. Could you provide guidance on how to address this problem?

whole error log (MsSQL Docker container)
2024-11-27 20:22:14 SQL Server 2022 will run as non-root by default.
2024-11-27 20:22:14 This container is running as user mssql.
2024-11-27 20:22:14 To learn more visit https://go.microsoft.com/fwlink/?linkid=2099216.
2024-11-27 20:22:18 2024-11-27 11:22:18.51 Server      Setup step is copying system data file 'C:\templatedata\master.mdf' to '/var/opt/mssql/data/master.mdf'.
2024-11-27 20:22:18 
2024-11-27 09:00:00 11:22:18.53 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.
2024-11-27 20:22:18 
2024-11-27 09:00:00 11:22:18.54 Server      Setup step is copying system data file 'C:\templatedata\mastlog.ldf' to '/var/opt/mssql/data/mastlog.ldf'.
2024-11-27 20:22:18 
2024-11-27 09:00:00 11:22:18.55 Server      Setup step is copying system data file 'C:\templatedata\model.mdf' to '/var/opt/mssql/data/model.mdf'.
2024-11-27 20:22:18 
2024-11-27 09:00:00 11:22:18.56 Server      Setup step is copying system data file 'C:\templatedata\modellog.ldf' to '/var/opt/mssql/data/modellog.ldf'.
2024-11-27 20:22:18 
2024-11-27 09:00:00 11:22:18.57 Server      Setup step is copying system data file 'C:\templatedata\msdbdata.mdf' to '/var/opt/mssql/data/msdbdata.mdf'.
2024-11-27 20:22:18 
2024-11-27 09:00:00 11:22:18.58 Server      Setup step is copying system data file 'C:\templatedata\msdblog.ldf' to '/var/opt/mssql/data/msdblog.ldf'.
2024-11-27 20:22:18 
2024-11-27 09:00:00 11:22:18.59 Server      Setup step is FORCE copying system data file 'C:\templatedata\model_replicatedmaster.mdf' to '/var/opt/mssql/data/model_replicatedmaster.mdf'.
2024-11-27 20:22:18 
2024-11-27 09:00:00 11:22:18.60 Server      Setup step is FORCE copying system data file 'C:\templatedata\model_replicatedmaster.ldf' to '/var/opt/mssql/data/model_replicatedmaster.ldf'.
2024-11-27 20:22:18 
2024-11-27 09:00:00 11:22:18.61 Server      Setup step is FORCE copying system data file 'C:\templatedata\model_msdbdata.mdf' to '/var/opt/mssql/data/model_msdbdata.mdf'.
2024-11-27 20:22:18 
2024-11-27 09:00:00 11:22:18.62 Server      Setup step is FORCE copying system data file 'C:\templatedata\model_msdblog.ldf' to '/var/opt/mssql/data/model_msdblog.ldf'.
2024-11-27 20:22:18 
2024-11-27 09:00:00 11:22:18.65 Server      Microsoft SQL Server 2022 (RTM-CU14) (KB5038325) - 16.0.4135.4 (X64) 
2024-11-27 20:22:18 
        Jul 10 2024 14:09:09 
2024-11-27 20:22:18 
        Copyright (C) 2022 Microsoft Corporation
2024-11-27 20:22:18 
        Developer Edition (64-bit) on Linux (Ubuntu 22.04.4 LTS) <X64>
2024-11-27 20:22:18 
2024-11-27 09:00:00 11:22:18.65 Server      UTC adjustment: 0:00
2024-11-27 20:22:18 
2024-11-27 09:00:00 11:22:18.65 Server      (c) Microsoft Corporation.
2024-11-27 20:22:18 
2024-11-27 09:00:00 11:22:18.66 Server      All rights reserved.
2024-11-27 20:22:18 
2024-11-27 09:00:00 11:22:18.66 Server      Server process ID is 472.
2024-11-27 20:22:18 
2024-11-27 09:00:00 11:22:18.66 Server      Logging SQL Server messages in file '/var/opt/mssql/log/errorlog'.
2024-11-27 20:22:18 
2024-11-27 09:00:00 11:22:18.66 Server      Registry startup parameters: 
2024-11-27 20:22:18 
         -d /var/opt/mssql/data/master.mdf
2024-11-27 20:22:18 
         -l /var/opt/mssql/data/mastlog.ldf
2024-11-27 20:22:18 
         -e /var/opt/mssql/log/errorlog
2024-11-27 20:22:18 
2024-11-27 09:00:00 11:22:18.66 Server      SQL Server detected 1 sockets with 4 cores per socket and 8 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.
2024-11-27 20:22:18 
2024-11-27 09:00:00 11:22:18.67 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2024-11-27 20:22:18 
2024-11-27 09:00:00 11:22:18.67 Server      Detected 12688 MB of RAM. This is an informational message; no user action is required.
2024-11-27 20:22:18 
2024-11-27 09:00:00 11:22:18.67 Server      Using conventional memory in the memory manager.
2024-11-27 20:22:18 
2024-11-27 09:00:00 11:22:18.68 Server      Detected pause instruction latency: 110 cycles.
2024-11-27 20:22:18 
2024-11-27 09:00:00 11:22:18.68 Server      SQL Server detected the following NUMA node configuration (NUMA Node number 0, Processor Group number 0, CPU Mask 0x00000000000000ff).
2024-11-27 20:22:18 
2024-11-27 09:00:00 11:22:18.69 Server      Page exclusion bitmap is enabled.
2024-11-27 20:22:18 
2024-11-27 09:00:00 11:22:18.73 Server      Buffer pool extension is not supported on Linux platform.
2024-11-27 20:22:18 
2024-11-27 09:00:00 11:22:18.73 Server      Buffer Pool: Allocating 2097152 bytes for 1951326 hashPages.
2024-11-27 20:22:18 
2024-11-27 09:00:00 11:22:18.86 Server      Buffer pool extension is already disabled. No action is necessary.
2024-11-27 20:22:19 
2024-11-27 09:00:00 11:22:19.31 Server      Installing Client TLS certificates to the store.
2024-11-27 20:22:19 
2024-11-27 09:00:00 11:22:19.33 Server      CPU vectorization level(s) detected:  SSE SSE2 SSE3 SSSE3 SSE41 SSE42 AVX AVX2 POPCNT BMI1 BMI2 AVX512 (F CD BW DQ VL IFMA VBMI VBMI2 VNNI BITALG VPOQCNTDQ VP2INTERSECT)
2024-11-27 20:22:19 
2024-11-27 09:00:00 11:22:19.42 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'].
2024-11-27 20:22:19 
2024-11-27 09:00:00 11:22:19.46 Server      Query Store settings initialized with enabled = 1, 
2024-11-27 20:22:19 
2024-11-27 09:00:00 11:22:19.47 Server      The maximum number of dedicated administrator connections for this instance is '1'
2024-11-27 20:22:19 
2024-11-27 09:00:00 11:22:19.47 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.
2024-11-27 20:22:19 
2024-11-27 09:00:00 11:22:19.49 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.
2024-11-27 20:22:19 
2024-11-27 09:00:00 11:22:19.52 Server      In-Memory OLTP initialized on standard machine.
2024-11-27 20:22:19 
2024-11-27 09:00:00 11:22:19.55 Server      [INFO] Created Extended Events session 'hkenginexesession'
2024-11-27 20:22:19 
2024-11-27 09:00:00 11:22:19.55 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.
2024-11-27 20:22:19 
ForceFlush is enabled for this instance. 
2024-11-27 20:22:19 
2024-11-27 09:00:00 11:22:19.58 Server      Total Log Writer threads: 2. This is an informational message; no user action is required.
2024-11-27 20:22:19 
2024-11-27 09:00:00 11:22:19.59 Server      clwb is selected for pmem flush operation.
2024-11-27 20:22:19 
2024-11-27 09:00:00 11:22:19.59 Server      CLR version v4.0.30319 loaded.
2024-11-27 20:22:19 
2024-11-27 09:00:00 11:22:19.59 Server      Software Usage Metrics is disabled.
2024-11-27 20:22:19 
2024-11-27 09:00:00 11:22:19.61 spid27s     [1]. Feature Status: PVS: 0. CTR: 0. ConcurrentPFSUpdate: 1. ConcurrentGAMUpdate: 1. ConcurrentSGAMUpdate: 1, CleanupUnderUserTransaction: 0. TranLevelPVS: 0
2024-11-27 20:22:19 
2024-11-27 09:00:00 11:22:19.61 spid27s     Starting up database 'master'.
2024-11-27 20:22:19 
ForceFlush feature is enabled for log durability.
2024-11-27 20:22:19 
2024-11-27 09:00:00 11:22:19.73 spid27s     The tail of the log for database master is being rewritten to match the new sector size of 4096 bytes.  1024 bytes at offset 396288 in file /var/opt/mssql/data/mastlog.ldf will be written.
2024-11-27 20:22:19 
2024-11-27 09:00:00 11:22:19.78 spid27s     Converting database 'master' from version 927 to the current version 957.
2024-11-27 20:22:19 
2024-11-27 09:00:00 11:22:19.78 spid27s     Database 'master' running the upgrade step from version 927 to version 928.
2024-11-27 20:22:19 
2024-11-27 09:00:00 11:22:19.82 spid27s     Database 'master' running the upgrade step from version 928 to version 929.
2024-11-27 20:22:19 
2024-11-27 09:00:00 11:22:19.88 spid27s     Database 'master' running the upgrade step from version 929 to version 930.
2024-11-27 20:22:19 
2024-11-27 09:00:00 11:22:19.90 spid27s     Database 'master' running the upgrade step from version 930 to version 931.
2024-11-27 20:22:19 
2024-11-27 09:00:00 11:22:19.92 spid27s     Database 'master' running the upgrade step from version 931 to version 932.
2024-11-27 20:22:19 
2024-11-27 09:00:00 11:22:19.96 spid27s     Database 'master' running the upgrade step from version 932 to version 933.
2024-11-27 20:22:19 
2024-11-27 09:00:00 11:22:19.97 Server      Common language runtime (CLR) functionality initialized.
2024-11-27 20:22:19 
2024-11-27 09:00:00 11:22:19.98 spid27s     Database 'master' running the upgrade step from version 933 to version 934.
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.00 spid27s     Database 'master' running the upgrade step from version 934 to version 935.
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.03 Server      External governance manager initialized
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.03 spid27s     Database 'master' running the upgrade step from version 935 to version 936.
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.06 spid27s     Database 'master' running the upgrade step from version 936 to version 937.
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.07 spid27s     Database 'master' running the upgrade step from version 937 to version 938.
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.10 spid27s     Database 'master' running the upgrade step from version 938 to version 939.
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.12 spid27s     Database 'master' running the upgrade step from version 939 to version 940.
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.13 spid27s     Database 'master' running the upgrade step from version 940 to version 941.
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.15 spid27s     Database 'master' running the upgrade step from version 941 to version 942.
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.17 spid27s     Database 'master' running the upgrade step from version 942 to version 943.
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.22 spid27s     Database 'master' running the upgrade step from version 943 to version 944.
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.24 spid27s     Database 'master' running the upgrade step from version 944 to version 945.
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.27 spid27s     Database 'master' running the upgrade step from version 945 to version 946.
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.29 spid27s     Database 'master' running the upgrade step from version 946 to version 947.
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.32 spid27s     Database 'master' running the upgrade step from version 947 to version 948.
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.34 spid27s     Database 'master' running the upgrade step from version 948 to version 949.
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.35 spid27s     Database 'master' running the upgrade step from version 949 to version 950.
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.37 spid27s     Database 'master' running the upgrade step from version 950 to version 951.
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.40 spid27s     Database 'master' running the upgrade step from version 951 to version 952.
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.42 spid27s     Database 'master' running the upgrade step from version 952 to version 953.
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.44 spid27s     Database 'master' running the upgrade step from version 953 to version 954.
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.46 spid27s     Database 'master' running the upgrade step from version 954 to version 955.
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.48 spid27s     Database 'master' running the upgrade step from version 955 to version 956.
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.52 spid27s     Database 'master' running the upgrade step from version 956 to version 957.
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.63 spid29s     [32767]. Feature Status: PVS: 0. CTR: 0. ConcurrentPFSUpdate: 1. ConcurrentGAMUpdate: 1. ConcurrentSGAMUpdate: 1, CleanupUnderUserTransaction: 0. TranLevelPVS: 0
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.64 spid29s     Starting up database 'mssqlsystemresource'.
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.64 spid29s     The resource database build version is 16.00.4135. This is an informational message only. No user action is required.
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.66 spid37s     Password policy update was successful.
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.69 spid29s     [3]. Feature Status: PVS: 0. CTR: 0. ConcurrentPFSUpdate: 1. ConcurrentGAMUpdate: 1. ConcurrentSGAMUpdate: 1, CleanupUnderUserTransaction: 0. TranLevelPVS: 0
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.69 spid29s     Starting up database 'model'.
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.70 spid27s     [32762]. Feature Status: PVS: 0. CTR: 0. ConcurrentPFSUpdate: 1. ConcurrentGAMUpdate: 1. ConcurrentSGAMUpdate: 1, CleanupUnderUserTransaction: 0. TranLevelPVS: 0
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.71 spid27s     Starting up database 'model_replicatedmaster'.
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.73 spid29s     The tail of the log for database model is being rewritten to match the new sector size of 4096 bytes.  2048 bytes at offset 75776 in file /var/opt/mssql/data/modellog.ldf will be written.
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.75 spid27s     The tail of the log for database model_replicatedmaster is being rewritten to match the new sector size of 4096 bytes.  2560 bytes at offset 99840 in file /var/opt/mssql/data/model_replicatedmaster.ldf will be written.
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.78 spid29s     Converting database 'model' from version 927 to the current version 957.
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.78 spid29s     Database 'model' running the upgrade step from version 927 to version 928.
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.83 spid29s     Database 'model' running the upgrade step from version 928 to version 929.
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.84 spid27s     Converting database 'model_replicatedmaster' from version 927 to the current version 957.
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.84 spid27s     Database 'model_replicatedmaster' running the upgrade step from version 927 to version 928.
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.88 spid27s     Database 'model_replicatedmaster' running the upgrade step from version 928 to version 929.
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.89 spid29s     Database 'model' running the upgrade step from version 929 to version 930.
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.91 spid29s     Database 'model' running the upgrade step from version 930 to version 931.
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.93 spid27s     Database 'model_replicatedmaster' running the upgrade step from version 929 to version 930.
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.94 spid29s     Database 'model' running the upgrade step from version 931 to version 932.
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.96 spid29s     Database 'model' running the upgrade step from version 932 to version 933.
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.99 spid29s     Database 'model' running the upgrade step from version 933 to version 934.
2024-11-27 20:22:20 
2024-11-27 09:00:00 11:22:20.99 spid27s     Database 'model_replicatedmaster' running the upgrade step from version 930 to version 931.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.01 spid29s     Database 'model' running the upgrade step from version 934 to version 935.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.01 spid27s     Database 'model_replicatedmaster' running the upgrade step from version 931 to version 932.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.03 spid29s     Database 'model' running the upgrade step from version 935 to version 936.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.03 spid27s     Database 'model_replicatedmaster' running the upgrade step from version 932 to version 933.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.06 spid27s     Database 'model_replicatedmaster' running the upgrade step from version 933 to version 934.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.06 spid29s     Database 'model' running the upgrade step from version 936 to version 937.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.08 spid29s     Database 'model' running the upgrade step from version 937 to version 938.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.08 spid27s     Database 'model_replicatedmaster' running the upgrade step from version 934 to version 935.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.10 spid29s     Database 'model' running the upgrade step from version 938 to version 939.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.11 spid27s     Database 'model_replicatedmaster' running the upgrade step from version 935 to version 936.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.12 spid29s     Database 'model' running the upgrade step from version 939 to version 940.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.13 spid27s     Database 'model_replicatedmaster' running the upgrade step from version 936 to version 937.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.14 spid29s     Database 'model' running the upgrade step from version 940 to version 941.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.16 spid27s     Database 'model_replicatedmaster' running the upgrade step from version 937 to version 938.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.17 spid29s     Database 'model' running the upgrade step from version 941 to version 942.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.19 spid27s     Database 'model_replicatedmaster' running the upgrade step from version 938 to version 939.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.20 spid29s     Database 'model' running the upgrade step from version 942 to version 943.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.22 spid27s     Database 'model_replicatedmaster' running the upgrade step from version 939 to version 940.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.23 spid29s     Database 'model' running the upgrade step from version 943 to version 944.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.24 spid27s     Database 'model_replicatedmaster' running the upgrade step from version 940 to version 941.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.26 spid29s     Database 'model' running the upgrade step from version 944 to version 945.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.28 spid27s     Database 'model_replicatedmaster' running the upgrade step from version 941 to version 942.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.28 spid37s     A self-generated certificate was successfully loaded for encryption.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.28 spid37s     Server is listening on [ 'any' <ipv6> 1433] accept sockets 1.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.29 spid37s     Server is listening on [ 'any' <ipv4> 1433] accept sockets 1.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.29 Server      Server is listening on [ ::1 <ipv6> 1434] accept sockets 1.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.29 Server      Server is listening on [ 127.0.0.1 <ipv4> 1434] accept sockets 1.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.29 Server      Dedicated admin connection support was established for listening locally on port 1434.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.32 spid29s     Database 'model' running the upgrade step from version 945 to version 946.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.32 spid27s     Database 'model_replicatedmaster' running the upgrade step from version 942 to version 943.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.34 spid37s     Server is listening on [ ::1 <ipv6> 1431] accept sockets 1.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.34 spid37s     Server is listening on [ 127.0.0.1 <ipv4> 1431] accept sockets 1.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.34 spid37s     SQL Server is now ready for client connections. This is an informational message; no user action is required.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.35 spid29s     Database 'model' running the upgrade step from version 946 to version 947.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.38 spid29s     Database 'model' running the upgrade step from version 947 to version 948.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.40 spid29s     Database 'model' running the upgrade step from version 948 to version 949.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.40 spid27s     Database 'model_replicatedmaster' running the upgrade step from version 943 to version 944.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.43 spid29s     Database 'model' running the upgrade step from version 949 to version 950.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.43 spid27s     Database 'model_replicatedmaster' running the upgrade step from version 944 to version 945.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.46 spid29s     Database 'model' running the upgrade step from version 950 to version 951.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.47 spid27s     Database 'model_replicatedmaster' running the upgrade step from version 945 to version 946.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.49 spid29s     Database 'model' running the upgrade step from version 951 to version 952.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.50 spid27s     Database 'model_replicatedmaster' running the upgrade step from version 946 to version 947.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.52 spid29s     Database 'model' running the upgrade step from version 952 to version 953.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.54 spid27s     Database 'model_replicatedmaster' running the upgrade step from version 947 to version 948.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.56 Logon       Error: 18456, Severity: 14, State: 7.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.56 Logon       Login failed for user 'sa'. Reason: An error occurred while evaluating the password. [CLIENT: 172.17.0.1]
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.57 spid29s     Database 'model' running the upgrade step from version 953 to version 954.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.58 spid27s     Database 'model_replicatedmaster' running the upgrade step from version 948 to version 949.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.60 spid29s     Database 'model' running the upgrade step from version 954 to version 955.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.61 spid27s     Database 'model_replicatedmaster' running the upgrade step from version 949 to version 950.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.63 spid29s     Database 'model' running the upgrade step from version 955 to version 956.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.64 spid27s     Database 'model_replicatedmaster' running the upgrade step from version 950 to version 951.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.67 spid29s     Database 'model' running the upgrade step from version 956 to version 957.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.68 spid27s     Database 'model_replicatedmaster' running the upgrade step from version 951 to version 952.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.70 spid27s     Database 'model_replicatedmaster' running the upgrade step from version 952 to version 953.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.73 spid27s     Database 'model_replicatedmaster' running the upgrade step from version 953 to version 954.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.74 Logon       Error: 18456, Severity: 14, State: 7.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.74 Logon       Login failed for user 'sa'. Reason: An error occurred while evaluating the password. [CLIENT: 172.17.0.1]
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.77 spid27s     Database 'model_replicatedmaster' running the upgrade step from version 954 to version 955.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.82 spid27s     Database 'model_replicatedmaster' running the upgrade step from version 955 to version 956.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.84 spid27s     Database 'model_replicatedmaster' running the upgrade step from version 956 to version 957.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.87 Logon       Error: 18456, Severity: 14, State: 7.
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.87 Logon       Login failed for user 'sa'. Reason: An error occurred while evaluating the password. [CLIENT: 172.17.0.1]
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.97 spid27s     [32761]. Feature Status: PVS: 0. CTR: 0. ConcurrentPFSUpdate: 1. ConcurrentGAMUpdate: 1. ConcurrentSGAMUpdate: 1, CleanupUnderUserTransaction: 0. TranLevelPVS: 0
2024-11-27 20:22:21 
2024-11-27 09:00:00 11:22:21.98 spid27s     Starting up database 'model_msdb'.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.01 Logon       Error: 18456, Severity: 14, State: 7.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.01 Logon       Login failed for user 'sa'. Reason: An error occurred while evaluating the password. [CLIENT: 172.17.0.1]
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.06 spid27s     Converting database 'model_msdb' from version 927 to the current version 957.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.06 spid27s     Database 'model_msdb' running the upgrade step from version 927 to version 928.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.08 spid27s     Database 'model_msdb' running the upgrade step from version 928 to version 929.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.11 spid27s     Database 'model_msdb' running the upgrade step from version 929 to version 930.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.14 spid27s     Database 'model_msdb' running the upgrade step from version 930 to version 931.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.15 Logon       Error: 18456, Severity: 14, State: 7.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.15 Logon       Login failed for user 'sa'. Reason: An error occurred while evaluating the password. [CLIENT: 172.17.0.1]
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.17 spid27s     Database 'model_msdb' running the upgrade step from version 931 to version 932.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.18 spid27s     Database 'model_msdb' running the upgrade step from version 932 to version 933.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.21 spid27s     Database 'model_msdb' running the upgrade step from version 933 to version 934.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.23 spid27s     Database 'model_msdb' running the upgrade step from version 934 to version 935.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.25 spid27s     Database 'model_msdb' running the upgrade step from version 935 to version 936.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.27 spid27s     Database 'model_msdb' running the upgrade step from version 936 to version 937.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.28 Logon       Error: 18456, Severity: 14, State: 7.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.28 Logon       Login failed for user 'sa'. Reason: An error occurred while evaluating the password. [CLIENT: 172.17.0.1]
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.29 spid27s     Database 'model_msdb' running the upgrade step from version 937 to version 938.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.31 spid27s     Database 'model_msdb' running the upgrade step from version 938 to version 939.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.33 spid27s     Database 'model_msdb' running the upgrade step from version 939 to version 940.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.35 spid27s     Database 'model_msdb' running the upgrade step from version 940 to version 941.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.37 spid27s     Database 'model_msdb' running the upgrade step from version 941 to version 942.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.39 spid27s     Database 'model_msdb' running the upgrade step from version 942 to version 943.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.43 Logon       Error: 18456, Severity: 14, State: 7.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.43 Logon       Login failed for user 'sa'. Reason: An error occurred while evaluating the password. [CLIENT: 172.17.0.1]
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.46 spid27s     Database 'model_msdb' running the upgrade step from version 943 to version 944.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.48 spid27s     Database 'model_msdb' running the upgrade step from version 944 to version 945.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.51 spid27s     Database 'model_msdb' running the upgrade step from version 945 to version 946.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.52 spid27s     Database 'model_msdb' running the upgrade step from version 946 to version 947.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.54 spid27s     Database 'model_msdb' running the upgrade step from version 947 to version 948.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.56 spid27s     Database 'model_msdb' running the upgrade step from version 948 to version 949.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.56 Logon       Error: 18456, Severity: 14, State: 7.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.56 Logon       Login failed for user 'sa'. Reason: An error occurred while evaluating the password. [CLIENT: 172.17.0.1]
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.58 spid27s     Database 'model_msdb' running the upgrade step from version 949 to version 950.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.59 spid27s     Database 'model_msdb' running the upgrade step from version 950 to version 951.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.61 spid27s     Database 'model_msdb' running the upgrade step from version 951 to version 952.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.63 spid27s     Database 'model_msdb' running the upgrade step from version 952 to version 953.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.65 spid27s     Database 'model_msdb' running the upgrade step from version 953 to version 954.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.67 spid27s     Database 'model_msdb' running the upgrade step from version 954 to version 955.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.69 spid27s     Database 'model_msdb' running the upgrade step from version 955 to version 956.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.69 Logon       Error: 18456, Severity: 14, State: 7.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.69 Logon       Login failed for user 'sa'. Reason: An error occurred while evaluating the password. [CLIENT: 172.17.0.1]
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.71 spid27s     Database 'model_msdb' running the upgrade step from version 956 to version 957.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.81 spid34s     Attribute synchronization initialized
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.81 spid27s     Resource governor reconfiguration succeeded.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.81 spid34s     Attribute synchronization manager initialized
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.81 spid27s     SQL Server Audit is starting the audits. This is an informational message. No user action is required.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.81 spid27s     SQL Server Audit has started the audits. This is an informational message. No user action is required.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.82 spid27s     XE session 'system_health' started.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.82 Logon       Error: 18456, Severity: 14, State: 7.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.82 Logon       Login failed for user 'sa'. Reason: An error occurred while evaluating the password. [CLIENT: 172.17.0.1]
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.85 spid27s     SQL Trace ID 1 was started by login "sa".
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.86 spid27s     Server name is '8771db1dd11d'. This is an informational message only. No user action is required.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.88 spid29s     Clearing tempdb database.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.88 spid46s     Always On: The availability replica manager is starting. This is an informational message only. No user action is required.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.88 spid48s     [4]. Feature Status: PVS: 0. CTR: 0. ConcurrentPFSUpdate: 1. ConcurrentGAMUpdate: 1. ConcurrentSGAMUpdate: 1, CleanupUnderUserTransaction: 0. TranLevelPVS: 0
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.89 spid46s     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.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.89 spid48s     Starting up database 'msdb'.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.96 spid48s     Converting database 'msdb' from version 927 to the current version 957.
2024-11-27 20:22:22 
2024-11-27 09:00:00 11:22:22.96 spid48s     Database 'msdb' running the upgrade step from version 927 to version 928.
2024-11-27 20:22:23 
2024-11-27 09:00:00 11:22:23.01 spid48s     Database 'msdb' running the upgrade step from version 928 to version 929.
2024-11-27 20:22:23 
2024-11-27 09:00:00 11:22:23.02 spid29s     [2]. Feature Status: PVS: 0. CTR: 0. ConcurrentPFSUpdate: 1. ConcurrentGAMUpdate: 1. ConcurrentSGAMUpdate: 1, CleanupUnderUserTransaction: 0. TranLevelPVS: 0
2024-11-27 20:22:23 
2024-11-27 09:00:00 11:22:23.03 spid29s     Starting up database 'tempdb'.
2024-11-27 20:22:23 
2024-11-27 09:00:00 11:22:23.07 spid48s     Database 'msdb' running the upgrade step from version 929 to version 930.
2024-11-27 20:22:23 
2024-11-27 09:00:00 11:22:23.08 spid29s     The tempdb database has 1 data file(s).
2024-11-27 20:22:23 
2024-11-27 09:00:00 11:22:23.09 spid46s     The Service Broker endpoint is in disabled or stopped state.
2024-11-27 20:22:23 
2024-11-27 09:00:00 11:22:23.09 spid46s     The Database Mirroring endpoint is in disabled or stopped state.
2024-11-27 20:22:23 
2024-11-27 09:00:00 11:22:23.10 spid46s     Service Broker manager has started.
2024-11-27 20:22:23 
2024-11-27 09:00:00 11:22:23.10 spid48s     Database 'msdb' running the upgrade step from version 930 to version 931.
2024-11-27 20:22:23 
2024-11-27 09:00:00 11:22:23.12 spid48s     Database 'msdb' running the upgrade step from version 931 to version 932.
2024-11-27 20:22:23 
2024-11-27 09:00:00 11:22:23.14 spid48s     Database 'msdb' running the upgrade step from version 932 to version 933.
2024-11-27 20:22:23 
2024-11-27 09:00:00 11:22:23.17 spid48s     Database 'msdb' running the upgrade step from version 933 to version 934.
2024-11-27 20:22:23 
2024-11-27 09:00:00 11:22:23.19 spid48s     Database 'msdb' running the upgrade step from version 934 to version 935.
2024-11-27 20:22:23 
2024-11-27 09:00:00 11:22:23.20 spid48s     Database 'msdb' running the upgrade step from version 935 to version 936.
2024-11-27 20:22:23 
2024-11-27 09:00:00 11:22:23.22 spid48s     Database 'msdb' running the upgrade step from version 936 to version 937.
2024-11-27 20:22:23 
2024-11-27 09:00:00 11:22:23.23 spid48s     Database 'msdb' running the upgrade step from version 937 to version 938.
2024-11-27 20:22:23 
2024-11-27 09:00:00 11:22:23.25 spid48s     Database 'msdb' running the upgrade step from version 938 to version 939.
2024-11-27 20:22:23 
2024-11-27 09:00:00 11:22:23.27 spid48s     Database 'msdb' running the upgrade step from version 939 to version 940.
2024-11-27 20:22:23 
2024-11-27 09:00:00 11:22:23.29 spid48s     Database 'msdb' running the upgrade step from version 940 to version 941.
2024-11-27 20:22:23 
2024-11-27 09:00:00 11:22:23.31 spid48s     Database 'msdb' running the upgrade step from version 941 to version 942.
2024-11-27 20:22:23 
2024-11-27 09:00:00 11:22:23.33 spid48s     Database 'msdb' running the upgrade step from version 942 to version 943.
2024-11-27 20:22:23 
2024-11-27 09:00:00 11:22:23.37 spid48s     Database 'msdb' running the upgrade step from version 943 to version 944.
2024-11-27 20:22:23 
2024-11-27 09:00:00 11:22:23.39 spid48s     Database 'msdb' running the upgrade step from version 944 to version 945.
2024-11-27 20:22:23 
2024-11-27 09:00:00 11:22:23.42 spid48s     Database 'msdb' running the upgrade step from version 945 to version 946.
2024-11-27 20:22:23 
2024-11-27 09:00:00 11:22:23.44 spid48s     Database 'msdb' running the upgrade step from version 946 to version 947.
2024-11-27 20:22:23 
2024-11-27 09:00:00 11:22:23.46 spid48s     Database 'msdb' running the upgrade step from version 947 to version 948.
2024-11-27 20:22:23 
2024-11-27 09:00:00 11:22:23.48 spid48s     Database 'msdb' running the upgrade step from version 948 to version 949.
2024-11-27 20:22:23 
2024-11-27 09:00:00 11:22:23.50 spid48s     Database 'msdb' running the upgrade step from version 949 to version 950.
2024-11-27 20:22:23 
2024-11-27 09:00:00 11:22:23.51 spid48s     Database 'msdb' running the upgrade step from version 950 to version 951.
2024-11-27 20:22:23 
2024-11-27 09:00:00 11:22:23.53 spid48s     Database 'msdb' running the upgrade step from version 951 to version 952.
2024-11-27 20:22:23 
2024-11-27 09:00:00 11:22:23.55 spid48s     Database 'msdb' running the upgrade step from version 952 to version 953.
2024-11-27 20:22:23 
2024-11-27 09:00:00 11:22:23.56 spid48s     Database 'msdb' running the upgrade step from version 953 to version 954.
2024-11-27 20:22:23 
2024-11-27 09:00:00 11:22:23.58 spid48s     Database 'msdb' running the upgrade step from version 954 to version 955.
2024-11-27 20:22:23 
2024-11-27 09:00:00 11:22:23.60 spid48s     Database 'msdb' running the upgrade step from version 955 to version 956.
2024-11-27 20:22:23 
2024-11-27 09:00:00 11:22:23.64 spid48s     Database 'msdb' running the upgrade step from version 956 to version 957.
2024-11-27 20:22:23 
2024-11-27 09:00:00 11:22:23.72 spid27s     Recovery is complete. This is an informational message only. No user action is required.
2024-11-27 20:22:23 
2024-11-27 09:00:00 11:22:23.84 spid35s     The default language (LCID 0) has been set for engine and full-text services.
2024-11-27 20:22:24 
2024-11-27 09:00:00 11:22:24.09 spid35s     The tempdb database has 8 data file(s).

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging this pull request may close these issues.

2 participants