search

bitwarden / server

Bitwarden infrastructure/backend (API, database, Docker, etc).
https://bitwarden.com
Other
15.33k stars 1.28k forks source link

bitwarden-mssql not starting #676

Closed Y0ngg4n closed 4 years ago

Y0ngg4n commented 4 years ago

My Bitwarden MSSQL Docker Container ist not starting. It failes at creating triggers and procedures:

Error: 18401, Severity: 14, State: 1.

Nothing of those worked: ./bitwarden.sh update ./bitwarden.sh updateself ./bitwarden.sh updatedb

Full Log:

2020-03-22 23:10:32.47 Server      The licensing PID was successfully processed. The new edition is [Express Edition].

2020-03-22 23:10:35.81 Server      Microsoft SQL Server 2017 (RTM-CU18) (KB4527377) - 14.0.3257.3 (X64) 

    Nov 16 2019 01:14:50 

    Copyright (C) 2017 Microsoft Corporation

    Express Edition (64-bit) on Linux (Ubuntu 16.04.6 LTS)

2020-03-22 23:10:35.81 Server      UTC adjustment: 0:00

2020-03-22 23:10:35.81 Server      (c) Microsoft Corporation.

2020-03-22 23:10:35.81 Server      All rights reserved.

2020-03-22 23:10:35.81 Server      Server process ID is 32.

2020-03-22 23:10:35.81 Server      Logging SQL Server messages in file '/var/opt/mssql/log/errorlog'.

2020-03-22 23:10:35.81 Server      Registry startup parameters: 

     -d /var/opt/mssql/data/master.mdf

     -l /var/opt/mssql/data/mastlog.ldf

     -e /var/opt/mssql/log/errorlog

2020-03-22 23:10:35.83 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.

2020-03-22 23:10:35.84 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.

2020-03-22 23:10:35.84 Server      Detected 25626 MB of RAM. This is an informational message; no user action is required.

2020-03-22 23:10:35.84 Server      Using conventional memory in the memory manager.

2020-03-22 23:10:37.13 Server      Buffer pool extension is already disabled. No action is necessary. 

2020-03-22 23:10:37.48 Server      InitializeExternalUserGroupSid failed. Implied authentication will be disabled.

2020-03-22 23:10:37.48 Server      Implied authentication manager initialization failed. Implied authentication will be disabled.

2020-03-22 23:10:37.49 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'].

2020-03-22 23:10:37.57 Server      The maximum number of dedicated administrator connections for this instance is '1'

2020-03-22 23:10:37.57 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.

2020-03-22 23:10:37.58 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.

2020-03-22 23:10:37.59 Server      In-Memory OLTP initialized on standard machine.

2020-03-22 23:10:37.72 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. 

2020-03-22 23:10:37.73 Server      Query Store settings initialized with enabled = 1, 

2020-03-22 23:10:37.73 Server      Software Usage Metrics is disabled.

2020-03-22 23:10:37.73 spid6s      Starting up database 'master'.

ForceFlush feature is enabled for log durability.

2020-03-22 23:10:38.20 spid6s      10 transactions rolled forward in database 'master' (1:0). This is an informational message only. No user action is required.

2020-03-22 23:10:38.26 spid6s      0 transactions rolled back in database 'master' (1:0). This is an informational message only. No user action is required.

2020-03-22 23:10:38.26 spid6s      Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.

2020-03-22 23:10:38.70 spid6s      Service Master Key could not be decrypted using one of its encryptions. See sys.key_encryptions for details.

2020-03-22 23:10:38.70 spid6s      An error occurred during Service Master Key initialization. SQLErrorCode=33095, State=8, LastOsError=0.

2020-03-22 23:10:38.76 spid6s      SQL Server Audit is starting the audits. This is an informational message. No user action is required.

2020-03-22 23:10:38.76 spid6s      SQL Server Audit has started the audits. This is an informational message. No user action is required.

2020-03-22 23:10:39.14 spid6s      SQL Trace ID 1 was started by login "sa".

2020-03-22 23:10:39.34 spid6s      Server name is '81d7d2c79414'. This is an informational message only. No user action is required.

2020-03-22 23:10:39.35 spid24s     Always On: The availability replica manager is starting. This is an informational message only. No user action is required.

2020-03-22 23:10:39.35 spid22s     Starting up database 'msdb'.

2020-03-22 23:10:39.35 spid23s     Starting up database 'vault'.

2020-03-22 23:10:39.35 spid9s      Starting up database 'mssqlsystemresource'.

2020-03-22 23:10:39.36 spid24s     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.

2020-03-22 23:10:39.36 spid9s      The resource database build version is 14.00.3257. This is an informational message only. No user action is required.

2020-03-22 23:10:39.38 spid9s      Starting up database 'model'.

2020-03-22 23:10:39.74 spid23s     Parallel redo is started for database 'vault' with worker pool size [4].

2020-03-22 23:10:39.76 spid19s     A self-generated certificate was successfully loaded for encryption.

2020-03-22 23:10:39.76 spid19s     Server is listening on [ 'any' <ipv6> 1433].

2020-03-22 23:10:39.76 spid19s     Server is listening on [ 'any' <ipv4> 1433].

2020-03-22 23:10:39.76 spid19s     Dedicated administrator connection support was not started because it is disabled on this edition of SQL Server. If you want to use a dedicated administrator connection, restart SQL Server using the trace flag 7806. This is an informational message only. No user action is required.

2020-03-22 23:10:39.94 spid22s     17 transactions rolled forward in database 'msdb' (4:0). This is an informational message only. No user action is required.

2020-03-22 23:10:39.95 spid23s     7 transactions rolled forward in database 'vault' (5:0). This is an informational message only. No user action is required.

2020-03-22 23:10:40.39 spid23s     0 transactions rolled back in database 'vault' (5:0). This is an informational message only. No user action is required.

2020-03-22 23:10:40.40 spid23s     Parallel redo is shutdown for database 'vault' with worker pool size [4].

2020-03-22 23:10:40.40 spid22s     0 transactions rolled back in database 'msdb' (4:0). This is an informational message only. No user action is required.

2020-03-22 23:10:40.40 spid22s     Recovery is writing a checkpoint in database 'msdb' (4). This is an informational message only. No user action is required.

2020-03-22 23:10:40.47 spid9s      Polybase feature disabled.

2020-03-22 23:10:40.48 spid9s      Clearing tempdb database.

2020-03-22 23:10:40.53 Logon       Error: 18401, Severity: 14, State: 1.

2020-03-22 23:10:40.53 Logon       Login failed for user 'sa'. Reason: Server is in script upgrade mode. Only administrator can connect at this time. [CLIENT: 172.50.0.11]

2020-03-22 23:10:40.90 spid22s     Recovery completed for database msdb (database ID 4) in 2 second(s) (analysis 34 ms, redo 169 ms, undo 88 ms.) This is an informational message only. No user action is required.

2020-03-22 23:10:41.73 spid9s      Starting up database 'tempdb'.

2020-03-22 23:10:41.98 spid24s     The Service Broker endpoint is in disabled or stopped state.

2020-03-22 23:10:41.99 spid24s     The Database Mirroring endpoint is in disabled or stopped state.

2020-03-22 23:10:42.00 spid24s     Service Broker manager has started.

2020-03-22 23:10:43.15 spid6s      Database 'master' is upgrading script 'msdb110_upgrade.sql' from level 234884100 to level 234884281.

2020-03-22 23:10:43.15 spid6s      ----------------------------------

2020-03-22 23:10:43.15 spid6s      Starting execution of PRE_MSDB.SQL

2020-03-22 23:10:43.15 spid6s      ----------------------------------

2020-03-22 23:10:43.50 spid6s      Setting database option COMPATIBILITY_LEVEL to 100 for database 'msdb'.

2020-03-22 23:10:44.07 spid6s      -----------------------------------------

2020-03-22 23:10:44.07 spid6s      Starting execution of PRE_SQLAGENT100.SQL

2020-03-22 23:10:44.07 spid6s      -----------------------------------------

2020-03-22 23:10:44.87 spid6s      Setting database option COMPATIBILITY_LEVEL to 140 for database 'msdb'.

2020-03-22 23:10:45.66 spid6s      Configuration option 'allow updates' changed from 1 to 1. Run the RECONFIGURE statement to install.

2020-03-22 23:10:45.66 spid6s      Configuration option 'allow updates' changed from 1 to 1. Run the RECONFIGURE statement to install.

2020-03-22 23:10:51.43 Logon       Error: 18401, Severity: 14, State: 1.

2020-03-22 23:10:51.43 Logon       Login failed for user 'sa'. Reason: Server is in script upgrade mode. Only administrator can connect at this time. [CLIENT: 172.50.0.6]

2020-03-22 23:11:10.79 Logon       Error: 18401, Severity: 14, State: 1.

2020-03-22 23:11:10.79 Logon       Login failed for user 'sa'. Reason: Server is in script upgrade mode. Only administrator can connect at this time. [CLIENT: 172.50.0.11]

2020-03-22 23:11:11.48 Logon       Error: 18401, Severity: 14, State: 1.

2020-03-22 23:11:11.48 Logon       Login failed for user 'sa'. Reason: Server is in script upgrade mode. Only administrator can connect at this time. [CLIENT: 172.50.0.6]

2020-03-22 23:11:17.57 spid6s      Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.

2020-03-22 23:11:17.65 spid6s      Using 'xpstar.dll' version '2017.140.3257' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.

2020-03-22 23:11:17.68 spid6s      DBCC TRACEOFF 1717, server process ID (SPID) 6. This is an informational message only; no user action is required.

2020-03-22 23:11:17.68 spid6s      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

2020-03-22 23:11:17.69 spid6s       

2020-03-22 23:11:17.69 spid6s      Creating table temp_sysjobschedules

2020-03-22 23:11:18.12 spid6s       

2020-03-22 23:11:18.12 spid6s      Alter table sysdownloadlist...

2020-03-22 23:11:18.31 spid6s       

2020-03-22 23:11:18.31 spid6s      Alter table sysjobhistory...

2020-03-22 23:11:18.35 spid6s       

2020-03-22 23:11:18.35 spid6s      Alter table systargetservers...

2020-03-22 23:11:18.39 spid6s       

2020-03-22 23:11:18.39 spid6s      Alter table sysjobsteps...

2020-03-22 23:11:18.71 spid6s      Configuration option 'allow updates' changed from 1 to 0. Run the RECONFIGURE statement to install.

2020-03-22 23:11:18.71 spid6s      Configuration option 'allow updates' changed from 1 to 0. Run the RECONFIGURE statement to install.

2020-03-22 23:11:18.92 spid6s       

2020-03-22 23:11:18.92 spid6s      -----------------------------------------

2020-03-22 23:11:18.93 spid6s      Execution of PRE_SQLAGENT100.SQL complete

2020-03-22 23:11:18.93 spid6s      -----------------------------------------

2020-03-22 23:11:18.99 spid6s      DMF pre-upgrade steps...

2020-03-22 23:11:19.35 spid6s      DC pre-upgrade steps...

2020-03-22 23:11:19.36 spid6s      Check if Data collector config table exists...

2020-03-22 23:11:19.36 spid6s      Data Collector state before upgrade: 0

2020-03-22 23:11:19.37 spid6s      pre_dc100::Check if syscollector_collection_sets_internal table exists...

2020-03-22 23:11:19.37 spid6s      pre_dc100::Capturing Collection set status in temp table...

2020-03-22 23:11:19.64 spid6s      Deleting cached auto-generated T-SQL Data Collection packages from msdb...

2020-03-22 23:11:19.64 spid6s      End of DC pre-upgrade steps.

2020-03-22 23:11:19.64 spid6s      DAC pre-upgrade steps...

2020-03-22 23:11:19.65 spid6s      Starting DAC pre-upgrade steps ...

2020-03-22 23:11:19.65 spid6s      End of DAC pre-upgrade steps.

2020-03-22 23:11:19.65 spid6s      ----------------------------------

2020-03-22 23:11:19.65 spid6s      Starting execution of MSDB.SQL

2020-03-22 23:11:19.65 spid6s      ----------------------------------

2020-03-22 23:11:19.78 spid6s      Configuration option 'allow updates' changed from 0 to 1. Run the RECONFIGURE statement to install.

2020-03-22 23:11:19.78 spid6s      Configuration option 'allow updates' changed from 0 to 1. Run the RECONFIGURE statement to install.

2020-03-22 23:11:20.03 spid6s      Checking the size of MSDB...

2020-03-22 23:11:20.76 spid6s       

2020-03-22 23:11:20.76 spid6s      Setting database option TRUSTWORTHY to ON for database 'msdb'.

2020-03-22 23:11:20.76 spid6s      Setting database option RECOVERY to SIMPLE for database 'msdb'.

2020-03-22 23:11:21.35 spid6s      ----------------------------------

2020-03-22 23:11:21.36 spid6s      Finished execution of MSDB.SQL

2020-03-22 23:11:21.36 spid6s      ----------------------------------

2020-03-22 23:11:21.36 spid6s      -----------------------------------------

2020-03-22 23:11:21.36 spid6s      Starting execution of MSDB_VERSIONING.SQL

2020-03-22 23:11:21.36 spid6s      -----------------------------------------

2020-03-22 23:11:21.45 spid6s      -----------------------------------------

2020-03-22 23:11:21.45 spid6s      Finished execution of MSDB_VERSIONING.SQL

2020-03-22 23:11:21.45 spid6s      -----------------------------------------

2020-03-22 23:11:21.98 spid6s       

2020-03-22 23:11:21.98 spid6s      Creating procedure sp_agent_add_job...

2020-03-22 23:11:22.18 spid6s       

2020-03-22 23:11:22.18 spid6s      Creating procedure sp_agent_delete_job...

2020-03-22 23:11:22.30 spid6s       

2020-03-22 23:11:22.30 spid6s      Creating procedure sp_agent_add_jobstep...

2020-03-22 23:11:22.46 spid6s       

2020-03-22 23:11:22.47 spid6s      Creating procedure sp_agent_start_job...

2020-03-22 23:11:22.61 spid6s       

2020-03-22 23:11:22.61 spid6s      Creating procedure sp_agent_get_jobstep...

2020-03-22 23:11:22.71 spid6s       

2020-03-22 23:11:22.71 spid6s      Creating procedure sp_agent_log_job_history...

2020-03-22 23:11:22.79 spid6s       

2020-03-22 23:11:22.80 spid6s      Creating procedure sp_agent_write_sysjobstep_log...

2020-03-22 23:11:22.88 spid6s       

2020-03-22 23:11:22.88 spid6s      Creating table syssubsystems...

2020-03-22 23:11:23.00 spid6s       

2020-03-22 23:11:23.00 spid6s      Creating view sysproxyloginsubsystem_view...

2020-03-22 23:11:23.71 spid6s       

2020-03-22 23:11:23.71 spid6s      Creating trigger trig_sysoriginatingservers_delete...

2020-03-22 23:11:23.81 spid6s       

2020-03-22 23:11:23.81 spid6s      Creating view sysoriginatingservers_view...

2020-03-22 23:11:23.93 spid6s       

2020-03-22 23:11:23.93 spid6s      Creating trigger trig_sysjobs_insert_update...

2020-03-22 23:11:24.14 spid6s       

2020-03-22 23:11:24.14 spid6s      Creating view sysjobs_view...

2020-03-22 23:11:24.31 spid6s       

2020-03-22 23:11:24.31 spid6s      Creating trigger trig_sysschedules_insert_update...

2020-03-22 23:11:24.45 spid6s       

2020-03-22 23:11:24.45 spid6s      Creating view sysschedules_localserver_view...

2020-03-22 23:11:25.66 spid6s       

2020-03-22 23:11:25.66 spid6s      Creating view systargetservers_view...

2020-03-22 23:11:32.98 Server      Microsoft SQL Server 2017 (RTM-CU18) (KB4527377) - 14.0.3257.3 (X64) 

    Nov 16 2019 01:14:50 

    Copyright (C) 2017 Microsoft Corporation

    Express Edition (64-bit) on Linux (Ubuntu 16.04.6 LTS)

2020-03-22 23:11:32.98 Server      UTC adjustment: 0:00

2020-03-22 23:11:32.99 Server      (c) Microsoft Corporation.

2020-03-22 23:11:32.99 Server      All rights reserved.

2020-03-22 23:11:32.99 Server      Server process ID is 32.

2020-03-22 23:11:32.99 Server      Logging SQL Server messages in file '/var/opt/mssql/log/errorlog'.

2020-03-22 23:11:32.99 Server      Registry startup parameters: 

     -d /var/opt/mssql/data/master.mdf

     -l /var/opt/mssql/data/mastlog.ldf

     -e /var/opt/mssql/log/errorlog

2020-03-22 23:11:32.99 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.

2020-03-22 23:11:32.99 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.

2020-03-22 23:11:33.00 Server      Detected 25626 MB of RAM. This is an informational message; no user action is required.

2020-03-22 23:11:33.00 Server      Using conventional memory in the memory manager.

2020-03-22 23:11:33.54 Server      Buffer pool extension is already disabled. No action is necessary. 

2020-03-22 23:11:33.82 Server      InitializeExternalUserGroupSid failed. Implied authentication will be disabled.

2020-03-22 23:11:33.82 Server      Implied authentication manager initialization failed. Implied authentication will be disabled.

2020-03-22 23:11:33.83 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'].

2020-03-22 23:11:33.91 Server      The maximum number of dedicated administrator connections for this instance is '1'

2020-03-22 23:11:33.92 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.

2020-03-22 23:11:33.93 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.

2020-03-22 23:11:34.30 Server      In-Memory OLTP initialized on standard machine.

2020-03-22 23:11:34.47 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. 

2020-03-22 23:11:34.48 Server      Query Store settings initialized with enabled = 1, 

2020-03-22 23:11:34.49 Server      Software Usage Metrics is disabled.

2020-03-22 23:11:34.49 spid6s      Starting up database 'master'.

ForceFlush feature is enabled for log durability.

2020-03-22 23:11:35.02 spid6s      10 transactions rolled forward in database 'master' (1:0). This is an informational message only. No user action is required.

2020-03-22 23:11:35.08 spid6s      0 transactions rolled back in database 'master' (1:0). This is an informational message only. No user action is required.

2020-03-22 23:11:35.09 spid6s      Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.

2020-03-22 23:11:35.47 spid6s      Service Master Key could not be decrypted using one of its encryptions. See sys.key_encryptions for details.

2020-03-22 23:11:35.48 spid6s      An error occurred during Service Master Key initialization. SQLErrorCode=33095, State=8, LastOsError=0.

2020-03-22 23:11:35.54 spid6s      SQL Server Audit is starting the audits. This is an informational message. No user action is required.

2020-03-22 23:11:35.54 spid6s      SQL Server Audit has started the audits. This is an informational message. No user action is required.

2020-03-22 23:11:35.79 spid6s      SQL Trace ID 1 was started by login "sa".

2020-03-22 23:11:36.04 spid6s      Server name is '81d7d2c79414'. This is an informational message only. No user action is required.

2020-03-22 23:11:36.05 spid24s     Always On: The availability replica manager is starting. This is an informational message only. No user action is required.

2020-03-22 23:11:36.05 spid9s      Starting up database 'mssqlsystemresource'.

2020-03-22 23:11:36.05 spid23s     Starting up database 'msdb'.

2020-03-22 23:11:36.05 spid22s     Starting up database 'vault'.

2020-03-22 23:11:36.05 spid24s     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.

2020-03-22 23:11:36.05 spid9s      The resource database build version is 14.00.3257. This is an informational message only. No user action is required.

2020-03-22 23:11:36.06 spid19s     A self-generated certificate was successfully loaded for encryption.

2020-03-22 23:11:36.06 spid19s     Server is listening on [ 'any' <ipv6> 1433].

2020-03-22 23:11:36.06 spid19s     Server is listening on [ 'any' <ipv4> 1433].

2020-03-22 23:11:36.06 spid9s      Starting up database 'model'.

2020-03-22 23:11:36.07 spid19s     Dedicated administrator connection support was not started because it is disabled on this edition of SQL Server. If you want to use a dedicated administrator connection, restart SQL Server using the trace flag 7806. This is an informational message only. No user action is required.

2020-03-22 23:11:36.43 spid22s     Parallel redo is started for database 'vault' with worker pool size [4].

2020-03-22 23:11:36.52 spid22s     7 transactions rolled forward in database 'vault' (5:0). This is an informational message only. No user action is required.

2020-03-22 23:11:36.82 spid23s     57 transactions rolled forward in database 'msdb' (4:0). This is an informational message only. No user action is required.

2020-03-22 23:11:36.97 spid9s      Polybase feature disabled.

2020-03-22 23:11:36.98 spid9s      Clearing tempdb database.

2020-03-22 23:11:37.03 Logon       Error: 18401, Severity: 14, State: 1.

2020-03-22 23:11:37.03 Logon       Login failed for user 'sa'. Reason: Server is in script upgrade mode. Only administrator can connect at this time. [CLIENT: 172.50.0.6]

2020-03-22 23:11:37.12 spid22s     0 transactions rolled back in database 'vault' (5:0). This is an informational message only. No user action is required.

2020-03-22 23:11:37.12 spid23s     0 transactions rolled back in database 'msdb' (4:0). This is an informational message only. No user action is required.

2020-03-22 23:11:37.12 spid22s     Parallel redo is shutdown for database 'vault' with worker pool size [4].

2020-03-22 23:11:37.12 spid23s     Recovery is writing a checkpoint in database 'msdb' (4). This is an informational message only. No user action is required.

2020-03-22 23:11:37.78 spid23s     Recovery completed for database msdb (database ID 4) in 2 second(s) (analysis 40 ms, redo 286 ms, undo 131 ms.) This is an informational message only. No user action is required.

2020-03-22 23:11:38.42 spid9s      Starting up database 'tempdb'.

2020-03-22 23:11:38.70 spid17s     The Service Broker endpoint is in disabled or stopped state.

2020-03-22 23:11:38.70 spid17s     The Database Mirroring endpoint is in disabled or stopped state.

2020-03-22 23:11:38.71 spid17s     Service Broker manager has started.

2020-03-22 23:11:40.12 spid6s      Database 'master' is upgrading script 'msdb110_upgrade.sql' from level 234884100 to level 234884281.

2020-03-22 23:11:40.12 spid6s      ----------------------------------

2020-03-22 23:11:40.12 spid6s      Starting execution of PRE_MSDB.SQL

2020-03-22 23:11:40.12 spid6s      ----------------------------------

2020-03-22 23:11:40.50 spid6s      Setting database option COMPATIBILITY_LEVEL to 100 for database 'msdb'.

2020-03-22 23:11:40.92 spid6s      -----------------------------------------

2020-03-22 23:11:40.92 spid6s      Starting execution of PRE_SQLAGENT100.SQL

2020-03-22 23:11:40.92 spid6s      -----------------------------------------

2020-03-22 23:11:41.20 spid6s      Setting database option COMPATIBILITY_LEVEL to 140 for database 'msdb'.

2020-03-22 23:11:41.57 spid6s      Configuration option 'allow updates' changed from 1 to 1. Run the RECONFIGURE statement to install.

2020-03-22 23:11:41.57 spid6s      Configuration option 'allow updates' changed from 1 to 1. Run the RECONFIGURE statement to install.

2020-03-22 23:11:57.60 Logon       Error: 18401, Severity: 14, State: 1.

2020-03-22 23:11:57.60 Logon       Login failed for user 'sa'. Reason: Server is in script upgrade mode. Only administrator can connect at this time. [CLIENT: 172.50.0.11]

2020-03-22 23:12:10.69 Logon       Error: 18401, Severity: 14, State: 1.

2020-03-22 23:12:10.69 Logon       Login failed for user 'sa'. Reason: Server is in script upgrade mode. Only administrator can connect at this time. [CLIENT: 172.50.0.6]

2020-03-22 23:12:13.01 spid6s      Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.

2020-03-22 23:12:13.07 spid6s      Using 'xpstar.dll' version '2017.140.3257' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.

2020-03-22 23:12:13.10 spid6s      DBCC TRACEOFF 1717, server process ID (SPID) 6. This is an informational message only; no user action is required.

2020-03-22 23:12:13.10 spid6s      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

2020-03-22 23:12:13.11 spid6s       

2020-03-22 23:12:13.11 spid6s      Creating table temp_sysjobschedules

2020-03-22 23:12:13.42 spid6s       

2020-03-22 23:12:13.42 spid6s      Alter table sysdownloadlist...

2020-03-22 23:12:13.55 spid6s       

2020-03-22 23:12:13.55 spid6s      Alter table sysjobhistory...

2020-03-22 23:12:13.65 spid6s       

2020-03-22 23:12:13.65 spid6s      Alter table systargetservers...

2020-03-22 23:12:13.68 spid6s       

2020-03-22 23:12:13.68 spid6s      Alter table sysjobsteps...

2020-03-22 23:12:14.08 spid6s      Configuration option 'allow updates' changed from 1 to 0. Run the RECONFIGURE statement to install.

2020-03-22 23:12:14.08 spid6s      Configuration option 'allow updates' changed from 1 to 0. Run the RECONFIGURE statement to install.

2020-03-22 23:12:14.27 spid6s       

2020-03-22 23:12:14.27 spid6s      -----------------------------------------

2020-03-22 23:12:14.28 spid6s      Execution of PRE_SQLAGENT100.SQL complete

2020-03-22 23:12:14.28 spid6s      -----------------------------------------

2020-03-22 23:12:14.32 spid6s      DMF pre-upgrade steps...

2020-03-22 23:12:14.50 spid6s      DC pre-upgrade steps...

2020-03-22 23:12:14.50 spid6s      Check if Data collector config table exists...

2020-03-22 23:12:14.51 spid6s      Data Collector state before upgrade: 0

2020-03-22 23:12:14.51 spid6s      pre_dc100::Check if syscollector_collection_sets_internal table exists...

2020-03-22 23:12:14.51 spid6s      pre_dc100::Capturing Collection set status in temp table...

2020-03-22 23:12:14.88 spid6s      Deleting cached auto-generated T-SQL Data Collection packages from msdb...

2020-03-22 23:12:14.88 spid6s      End of DC pre-upgrade steps.

2020-03-22 23:12:14.89 spid6s      DAC pre-upgrade steps...

2020-03-22 23:12:14.89 spid6s      Starting DAC pre-upgrade steps ...

2020-03-22 23:12:14.91 spid6s      End of DAC pre-upgrade steps.

2020-03-22 23:12:14.91 spid6s      ----------------------------------

2020-03-22 23:12:14.92 spid6s      Starting execution of MSDB.SQL

2020-03-22 23:12:14.92 spid6s      ----------------------------------

2020-03-22 23:12:15.08 spid6s      Configuration option 'allow updates' changed from 0 to 1. Run the RECONFIGURE statement to install.

2020-03-22 23:12:15.08 spid6s      Configuration option 'allow updates' changed from 0 to 1. Run the RECONFIGURE statement to install.

2020-03-22 23:12:16.01 spid6s      Checking the size of MSDB...

2020-03-22 23:12:17.17 spid6s       

2020-03-22 23:12:17.17 spid6s      Setting database option TRUSTWORTHY to ON for database 'msdb'.

2020-03-22 23:12:17.18 spid6s      Setting database option RECOVERY to SIMPLE for database 'msdb'.

2020-03-22 23:12:17.61 spid6s      ----------------------------------

2020-03-22 23:12:17.62 spid6s      Finished execution of MSDB.SQL

2020-03-22 23:12:17.62 spid6s      ----------------------------------

2020-03-22 23:12:17.62 spid6s      -----------------------------------------

2020-03-22 23:12:17.62 spid6s      Starting execution of MSDB_VERSIONING.SQL

2020-03-22 23:12:17.62 spid6s      -----------------------------------------

2020-03-22 23:12:17.69 spid6s      -----------------------------------------

2020-03-22 23:12:17.69 spid6s      Finished execution of MSDB_VERSIONING.SQL

2020-03-22 23:12:17.70 spid6s      -----------------------------------------

2020-03-22 23:12:18.24 spid6s       

2020-03-22 23:12:18.24 spid6s      Creating procedure sp_agent_add_job...

2020-03-22 23:12:18.35 spid6s       

2020-03-22 23:12:18.35 spid6s      Creating procedure sp_agent_delete_job...

2020-03-22 23:12:18.43 spid6s       

2020-03-22 23:12:18.43 spid6s      Creating procedure sp_agent_add_jobstep...

2020-03-22 23:12:18.59 spid6s       

2020-03-22 23:12:18.59 spid6s      Creating procedure sp_agent_start_job...

2020-03-22 23:12:18.68 spid6s       

2020-03-22 23:12:18.68 spid6s      Creating procedure sp_agent_get_jobstep...

2020-03-22 23:12:18.76 spid6s       

2020-03-22 23:12:18.76 spid6s      Creating procedure sp_agent_log_job_history...

2020-03-22 23:12:18.84 spid6s       

2020-03-22 23:12:18.84 spid6s      Creating procedure sp_agent_write_sysjobstep_log...

2020-03-22 23:12:18.94 spid6s       

2020-03-22 23:12:18.94 spid6s      Creating table syssubsystems...

2020-03-22 23:12:19.15 spid6s       

2020-03-22 23:12:19.15 spid6s      Creating view sysproxyloginsubsystem_view...

2020-03-22 23:12:19.35 spid6s       

2020-03-22 23:12:19.35 spid6s      Creating trigger trig_sysoriginatingservers_delete...

2020-03-22 23:12:19.43 spid6s       

2020-03-22 23:12:19.44 spid6s      Creating view sysoriginatingservers_view...

2020-03-22 23:12:19.59 spid6s       

2020-03-22 23:12:19.59 spid6s      Creating trigger trig_sysjobs_insert_update...

2020-03-22 23:12:19.72 spid6s       

2020-03-22 23:12:19.72 spid6s      Creating view sysjobs_view...

2020-03-22 23:12:19.91 spid6s       

2020-03-22 23:12:19.91 spid6s      Creating trigger trig_sysschedules_insert_update...

2020-03-22 23:12:20.07 spid6s       

2020-03-22 23:12:20.07 spid6s      Creating view sysschedules_localserver_view...

2020-03-22 23:12:22.23 spid6s       

2020-03-22 23:12:22.23 spid6s      Creating view systargetservers_view...

2020-03-22 23:12:22.31 spid6s       

2020-03-22 23:12:22.31 spid6s      Creating view sysalerts_performance_counters_view...

2020-03-22 23:12:22.44 spid6s       

2020-03-22 23:12:22.44 spid6s      Creating function SQLAGENT_SUSER_SNAME ...

2020-03-22 23:12:22.66 spid6s       

2020-03-22 23:12:22.66 spid6s      Creating function SQLAGENT_SUSER_SID ...

2020-03-22 23:12:23.37 spid6s       

2020-03-22 23:12:23.37 spid6s      Creating procedure SP_SQLAGENT_IS_SRVROLEMEMBER...

2020-03-22 23:12:23.71 spid6s       

2020-03-22 23:12:23.71 spid6s      Creating procedure sp_get_traceflag_status_internal...

2020-03-22 23:12:23.82 spid6s       

2020-03-22 23:12:23.82 spid6s      Creating procedure sp_verify_category_identifiers...

2020-03-22 23:12:23.99 spid6s       

2020-03-22 23:12:23.99 spid6s      Creating function agent_datetime...

2020-03-22 23:12:24.10 spid6s       

2020-03-22 23:12:24.10 spid6s      Creating procedure sp_verify_proxy_identifiers...

2020-03-22 23:12:24.26 spid6s       

2020-03-22 23:12:24.26 spid6s      Creating procedure sp_verify_credential_identifiers...

2020-03-22 23:12:24.40 spid6s       

2020-03-22 23:12:24.40 spid6s      Creating procedure sp_verify_subsystems...

2020-03-22 23:12:24.57 spid6s       

2020-03-22 23:12:24.57 spid6s      Creating procedure sp_verify_subsystem_identifiers...

2020-03-22 23:12:24.71 spid6s       

2020-03-22 23:12:24.71 spid6s      Creating procedure sp_verify_login_identifiers...

2020-03-22 23:12:24.81 spid6s       

2020-03-22 23:12:24.81 spid6s      Creating procedure sp_verify_proxy...

2020-03-22 23:12:24.92 spid6s       

2020-03-22 23:12:24.92 spid6s      Creating procedure sp_add_proxy...

2020-03-22 23:12:25.06 spid6s       

2020-03-22 23:12:25.06 spid6s      Creating procedure sp_delete_proxy...

2020-03-22 23:12:25.21 spid6s       

2020-03-22 23:12:25.21 spid6s      Creating procedure sp_update_proxy...

2020-03-22 23:12:25.41 spid6s       

2020-03-22 23:12:25.41 spid6s      Creating procedure sp_sqlagent_is_member...

2020-03-22 23:12:25.63 spid6s       

2020-03-22 23:12:25.63 spid6s      Creating procedure sp_verify_proxy_permissions...

2020-03-22 23:12:25.83 spid6s       

2020-03-22 23:12:25.84 spid6s      Creating procedure sp_help_proxy...

2020-03-22 23:12:26.35 spid6s       

2020-03-22 23:12:26.35 spid6s      Creating procedure sp_get_proxy_properties...

2020-03-22 23:12:26.48 spid6s       

2020-03-22 23:12:26.48 spid6s      Creating procedure sp_grant_proxy_to_subsystem...

2020-03-22 23:12:26.65 spid6s       

2020-03-22 23:12:26.65 spid6s      Creating procedure sp_grant_login_to_proxy...

2020-03-22 23:12:26.84 spid6s       

2020-03-22 23:12:26.84 spid6s      Creating procedure sp_revoke_login_from_proxy...

2020-03-22 23:12:27.07 spid6s       

2020-03-22 23:12:27.07 spid6s      Creating procedure sp_revoke_proxy_from_subsystem...

2020-03-22 23:12:27.49 spid6s       

2020-03-22 23:12:27.49 spid6s      Creating procedure sp_enum_proxy_for_subsystem...

2020-03-22 23:12:27.74 spid6s       

2020-03-22 23:12:27.75 spid6s      Creating procedure sp_enum_login_for_proxy...

2020-03-22 23:12:27.86 spid6s       

2020-03-22 23:12:27.86 spid6s      Creating procedure sp_reassign_proxy...

2020-03-22 23:12:27.88 Logon       Error: 18401, Severity: 14, State: 1.

2020-03-22 23:12:27.88 Logon       Login failed for user 'sa'. Reason: Server is in script upgrade mode. Only administrator can connect at this time. [CLIENT: 172.50.0.11]

2020-03-22 23:12:28.05 spid6s       

2020-03-22 23:12:28.05 spid6s      Creating procedure sp_sqlagent_get_startup_info...

2020-03-22 23:12:28.21 spid6s       

2020-03-22 23:12:28.21 spid6s      Creating procedure sp_sqlagent_update_agent_xps...

2020-03-22 23:12:28.32 spid6s       

2020-03-22 23:12:28.32 spid6s      Creating procedure sp_sqlagent_has_server_access...

2020-03-22 23:12:28.58 spid6s       

2020-03-22 23:12:28.58 spid6s      Creating procedure sp_sqlagent_get_perf_counters...

2020-03-22 23:12:28.75 spid6s       

2020-03-22 23:12:28.75 spid6s      Creating procedure sp_sqlagent_notify...

2020-03-22 23:12:28.92 spid6s       

2020-03-22 23:12:28.92 spid6s      Creating procedure sp_is_sqlagent_starting...

2020-03-22 23:12:29.09 spid6s       

2020-03-22 23:12:29.09 spid6s      Creating procedure sp_verify_job_identifiers...

2020-03-22 23:12:29.26 spid6s       

2020-03-22 23:12:29.26 spid6s      Creating procedure sp_verify_schedule_identifiers...

2020-03-22 23:12:29.46 spid6s       

2020-03-22 23:12:29.46 spid6s      Creating procedure sp_verify_jobproc_caller...

2020-03-22 23:12:29.58 spid6s       

2020-03-22 23:12:29.58 spid6s      Creating procedure sp_downloaded_row_limiter...

2020-03-22 23:12:29.84 spid6s       

2020-03-22 23:12:29.84 spid6s      Creating procedure sp_post_msx_operation...

2020-03-22 23:12:30.05 spid6s       

2020-03-22 23:12:30.05 spid6s      Creating procedure sp_verify_performance_condition...

2020-03-22 23:12:30.25 spid6s       

2020-03-22 23:12:30.25 spid6s      Creating procedure sp_verify_job_date...

2020-03-22 23:12:30.39 spid6s       

2020-03-22 23:12:30.39 spid6s      Creating procedure sp_verify_job_time...

2020-03-22 23:12:30.61 spid6s       

2020-03-22 23:12:30.61 spid6s      Creating procedure sp_verify_alert...

2020-03-22 23:12:30.73 Logon       Error: 18401, Severity: 14, State: 1.

2020-03-22 23:12:30.73 Logon       Login failed for user 'sa'. Reason: Server is in script upgrade mode. Only administrator can connect at this time. [CLIENT: 172.50.0.6]

2020-03-22 23:12:30.85 spid6s       

2020-03-22 23:12:30.85 spid6s      Creating procedure sp_update_alert...

2020-03-22 23:12:31.01 spid6s       

2020-03-22 23:12:31.01 spid6s      Creating procedure sp_delete_job_references...

2020-03-22 23:12:31.16 spid6s       

2020-03-22 23:12:31.16 spid6s      Creating procedure sp_delete_all_msx_jobs...

2020-03-22 23:12:31.49 spid6s       

2020-03-22 23:12:31.49 spid6s      Creating procedure sp_generate_target_server_job_assignment_sql...

2020-03-22 23:12:31.73 spid6s       

2020-03-22 23:12:31.73 spid6s      Creating procedure sp_generate_server_description...

2020-03-22 23:12:31.84 spid6s       

2020-03-22 23:12:31.84 spid6s      Creating procedure sp_msx_set_account...

2020-03-22 23:12:31.97 spid6s       

2020-03-22 23:12:31.97 spid6s      Creating procedure sp_msx_get_account...

2020-03-22 23:12:32.11 spid6s       

2020-03-22 23:12:32.11 spid6s      Creating procedure sp_delete_operator...

2020-03-22 23:12:32.39 spid6s       

2020-03-22 23:12:32.39 spid6s      Creating procedure sp_msx_defect...

2020-03-22 23:12:32.57 spid6s       

2020-03-22 23:12:32.57 spid6s      Creating procedure sp_msx_enlist...

2020-03-22 23:12:32.77 spid6s       

2020-03-22 23:12:32.77 spid6s      Creating procedure sp_delete_targetserver...

2020-03-22 23:12:32.94 spid6s       

2020-03-22 23:12:32.95 spid6s      Creating procedure sp_enlist_tsx

2020-03-22 23:12:33.02 spid6s       

2020-03-22 23:12:33.02 spid6s      Creating procedure sp_get_sqlagent_properties...

2020-03-22 23:12:33.28 spid6s       

2020-03-22 23:12:33.28 spid6s      Create procedure sp_set_sqlagent_properties...

2020-03-22 23:12:33.38 spid6s       

2020-03-22 23:12:33.38 spid6s      Creating procedure sp_add_targetservergroup...

2020-03-22 23:12:33.56 spid6s       

2020-03-22 23:12:33.56 spid6s      Creating procedure sp_update_targetservergroup...

2020-03-22 23:12:33.85 spid6s       

2020-03-22 23:12:33.85 spid6s      Creating procedure sp_delete_targetservergroup...

2020-03-22 23:12:33.97 spid6s       

2020-03-22 23:12:33.98 spid6s      Creating procedure sp_help_targetservergroup...

2020-03-22 23:12:34.08 spid6s       

2020-03-22 23:12:34.08 spid6s      Creating procedure sp_add_targetsvgrp_member...

2020-03-22 23:12:34.22 spid6s       

2020-03-22 23:12:34.23 spid6s      Creating procedure sp_delete_targetsvrgrp_member...

2020-03-22 23:12:34.32 spid6s       

2020-03-22 23:12:34.33 spid6s      Creating procedure sp_verify_category...

2020-03-22 23:12:34.42 spid6s       

2020-03-22 23:12:34.43 spid6s      Creating procedure sp_add_category...

2020-03-22 23:12:34.57 spid6s       

2020-03-22 23:12:34.57 spid6s      Creating procedure sp_update_category...

2020-03-22 23:12:34.71 spid6s       

2020-03-22 23:12:34.72 spid6s      Creating procedure sp_delete_category...

2020-03-22 23:12:34.92 spid6s       

2020-03-22 23:12:34.92 spid6s      Creating procedure sp_help_category...

2020-03-22 23:12:35.02 spid6s       

2020-03-22 23:12:35.02 spid6s      Creating procedure sp_help_targetserver...

2020-03-22 23:12:35.17 spid6s       

2020-03-22 23:12:35.18 spid6s      Creating procedure sp_resync_targetserver...

2020-03-22 23:12:36.98 spid6s       

2020-03-22 23:12:36.98 spid6s      Creating procedure sp_purge_jobhistory...

2020-03-22 23:12:37.49 spid6s       

2020-03-22 23:12:37.49 spid6s      Creating procedure sp_help_jobhistory...

2020-03-22 23:12:37.62 spid6s       

2020-03-22 23:12:37.62 spid6s      Creating procedure sp_add_jobserver...

2020-03-22 23:12:37.72 spid6s       

2020-03-22 23:12:37.72 spid6s      Creating procedure sp_delete_jobserver...

2020-03-22 23:12:37.90 spid6s       

2020-03-22 23:12:37.90 spid6s      Creating procedure sp_help_jobserver...

2020-03-22 23:12:38.14 spid6s       

2020-03-22 23:12:38.14 spid6s      Creating procedure sp_help_downloadlist...

2020-03-22 23:12:38.60 spid6s       

2020-03-22 23:12:38.60 spid6s      Creating procedure sp_enum_sqlagent_subsystems_internal...

2020-03-22 23:12:38.78 spid6s       

2020-03-22 23:12:38.78 spid6s      Creating procedure sp_enum_sqlagent_subsystems...

2020-03-22 23:12:39.00 spid6s       

2020-03-22 23:12:39.00 spid6s      Creating procedure sp_verify_subsystem...

2020-03-22 23:12:39.18 spid6s       

2020-03-22 23:12:39.18 spid6s      Creating procedure sp_verify_schedule...

2020-03-22 23:12:39.39 spid6s       

2020-03-22 23:12:39.39 spid6s      Creating procedure sp_add_schedule...

2020-03-22 23:12:39.75 spid6s       

2020-03-22 23:12:39.75 spid6s      Creating procedure sp_attach_schedule ...

2020-03-22 23:12:39.93 spid6s       

2020-03-22 23:12:39.94 spid6s      Creating procedure sp_detach_schedule ...

2020-03-22 23:12:40.06 spid6s       

2020-03-22 23:12:40.06 spid6s      Creating procedure sp_update_replication_job_parameter...

2020-03-22 23:12:40.17 spid6s       

2020-03-22 23:12:40.17 spid6s      Creating procedure sp_update_schedule ...

2020-03-22 23:12:40.29 spid6s       

2020-03-22 23:12:40.29 spid6s      Creating procedure sp_delete_schedule ...

2020-03-22 23:12:40.40 spid6s       

2020-03-22 23:12:40.40 spid6s      Creating procedure sp_get_jobstep_db_username...

2020-03-22 23:12:40.53 spid6s       

2020-03-22 23:12:40.53 spid6s      Creating procedure sp_verify_jobstep...

2020-03-22 23:12:40.66 spid6s       

2020-03-22 23:12:40.66 spid6s      Creating procedure sp_add_jobstep_internal...

2020-03-22 23:12:40.79 spid6s       

2020-03-22 23:12:40.79 spid6s      Creating procedure sp_add_jobstep...

2020-03-22 23:12:40.98 spid6s       

2020-03-22 23:12:40.98 spid6s      Creating procedure sp_update_jobstep...

2020-03-22 23:12:41.09 spid6s       

2020-03-22 23:12:41.09 spid6s      Creating procedure sp_delete_jobstep...

2020-03-22 23:12:41.24 spid6s       

2020-03-22 23:12:41.24 spid6s      Creating procedure sp_help_jobstep...

2020-03-22 23:12:41.35 spid6s       

2020-03-22 23:12:41.35 spid6s      Creating procedure sp_write_sysjobstep_log...

2020-03-22 23:12:41.48 spid6s       

2020-03-22 23:12:41.48 spid6s      Creating procedure sp_help_jobsteplog...

2020-03-22 23:12:41.59 spid6s       

2020-03-22 23:12:41.59 spid6s      Creating procedure sp_delete_jobsteplog...

2020-03-22 23:12:42.17 spid6s       

2020-03-22 23:12:42.18 spid6s      Creating procedure sp_get_schedule_description...

2020-03-22 23:12:42.82 spid6s       

2020-03-22 23:12:42.82 spid6s      Creating procedure sp_add_jobschedule...

2020-03-22 23:12:42.93 spid6s       

2020-03-22 23:12:42.93 spid6s      Creating procedure sp_update_jobschedule...

2020-03-22 23:12:43.10 spid6s       

2020-03-22 23:12:43.10 spid6s      Creating procedure sp_delete_jobschedule...

2020-03-22 23:12:43.20 spid6s       

2020-03-22 23:12:43.20 spid6s      Creating procedure sp_help_schedule...

2020-03-22 23:12:43.30 spid6s       

2020-03-22 23:12:43.30 spid6s      Creating procedure sp_help_jobschedule...

2020-03-22 23:12:43.89 spid6s       

2020-03-22 23:12:43.89 spid6s      Creating procedure sp_verify_job...

2020-03-22 23:12:44.06 spid6s       

2020-03-22 23:12:44.06 spid6s      Creating procedure sp_add_job...

2020-03-22 23:12:44.15 spid6s       

2020-03-22 23:12:44.15 spid6s      Creating procedure sp_update_job...

2020-03-22 23:12:44.29 spid6s       

2020-03-22 23:12:44.29 spid6s      Creating procedure sp_delete_job...

2020-03-22 23:12:44.41 spid6s       

2020-03-22 23:12:44.41 spid6s      Creating procedure sp_get_composite_job_info...

2020-03-22 23:12:44.62 spid6s       

2020-03-22 23:12:44.62 spid6s      Creating procedure sp_help_job...

2020-03-22 23:12:45.27 spid6s       

2020-03-22 23:12:45.27 spid6s      Creating procedure sp_help_jobcount...

2020-03-22 23:12:45.36 spid6s       

2020-03-22 23:12:45.36 spid6s      Creating procedure sp_help_jobs_in_schedule...

2020-03-22 23:12:45.45 spid6s       

2020-03-22 23:12:45.45 spid6s      Creating procedure sp_manage_jobs_by_login...

2020-03-22 23:12:45.57 spid6s       

2020-03-22 23:12:45.57 spid6s      Creating procedure sp_apply_job_to_targets...

2020-03-22 23:12:45.67 spid6s       

2020-03-22 23:12:45.67 spid6s      Creating procedure sp_remove_job_from_targets...

2020-03-22 23:12:45.77 spid6s       

2020-03-22 23:12:45.77 spid6s      Creating procedure sp_get_job_alerts...

2020-03-22 23:12:45.87 spid6s       

2020-03-22 23:12:45.87 spid6s      Creating procedure sp_start_job...

2020-03-22 23:12:45.97 spid6s       

2020-03-22 23:12:45.97 spid6s      Creating procedure sp_stop_job...

2020-03-22 23:12:46.24 spid6s       

2020-03-22 23:12:46.24 spid6s      Creating procedure sp_cycle_agent_errorlog...

2020-03-22 23:12:46.45 spid6s       

2020-03-22 23:12:46.45 spid6s      Creating procedure sp_get_chunked_jobstep_params...

2020-03-22 23:12:46.57 spid6s       

2020-03-22 23:12:46.57 spid6s      Creating procedure sp_check_for_owned_jobs...

2020-03-22 23:12:46.76 spid6s       

2020-03-22 23:12:46.76 spid6s      Creating procedure sp_check_for_owned_jobsteps...

2020-03-22 23:12:46.88 spid6s       

2020-03-22 23:12:46.89 spid6s      Creating procedure sp_sqlagent_refresh_job...

2020-03-22 23:12:47.06 spid6s       

2020-03-22 23:12:47.06 spid6s      Creating procedure sp_jobhistory_row_limiter...

2020-03-22 23:12:47.58 spid6s       

2020-03-22 23:12:47.59 spid6s      Creating procedure [dbo].[sp_sqlagent_set_job_completion_state]...

2020-03-22 23:12:48.21 spid6s       

2020-03-22 23:12:48.21 spid6s      Creating procedure [dbo].[sp_sqlagent_set_jobstep_completion_state]...

2020-03-22 23:12:48.60 spid6s       

2020-03-22 23:12:48.60 spid6s      Creating procedure [dbo].[sp_sqlagent_create_jobactivity]...

2020-03-22 23:12:48.98 spid6s       

2020-03-22 23:12:48.99 spid6s      Creating procedure [dbo].[sp_sqlagent_update_jobactivity_next_scheduled_date]...

2020-03-22 23:12:49.09 spid6s       

2020-03-22 23:12:49.09 spid6s      Creating procedure [dbo].[sp_sqlagent_update_jobactivity_requested_date]...

2020-03-22 23:12:49.43 spid6s       

2020-03-22 23:12:49.43 spid6s      Creating procedure [dbo].[sp_sqlagent_update_jobactivity_queued_date]...

2020-03-22 23:12:49.74 spid6s       

2020-03-22 23:12:49.74 spid6s      Creating procedure [dbo].[sp_sqlagent_update_jobactivity_start_execution_date]...

2020-03-22 23:12:49.77 spid6s       

2020-03-22 23:12:49.77 spid6s      Creating procedure sp_sqlagent_log_jobhistory...

2020-03-22 23:12:50.05 spid6s       

2020-03-22 23:12:50.05 spid6s      Creating procedure sp_sqlagent_check_msx_version...

2020-03-22 23:12:50.75 spid6s       

2020-03-22 23:12:50.75 spid6s      Creating procedure sp_sqlagent_probe_msx...

2020-03-22 23:12:50.75 Logon       Error: 18401, Severity: 14, State: 1.

2020-03-22 23:12:50.75 Logon       Login failed for user 'sa'. Reason: Server is in script upgrade mode. Only administrator can connect at this time. [CLIENT: 172.50.0.6]

2020-03-22 23:12:51.40 spid6s       

2020-03-22 23:12:51.40 spid6s      Creating procedure sp_set_local_time...

2020-03-22 23:12:51.52 spid6s       

2020-03-22 23:12:51.52 spid6s      Creating procedure sp_multi_server_job_summary...

2020-03-22 23:12:51.61 spid6s       

2020-03-22 23:12:51.61 spid6s      Creating procedure sp_target_server_summary...

2020-03-22 23:12:52.19 spid6s       

2020-03-22 23:12:52.20 spid6s      Creating [legacy] procedure sp_uniquetaskname...

2020-03-22 23:12:52.37 spid6s       

2020-03-22 23:12:52.37 spid6s      Creating [legacy] procedure sp_addtask...

2020-03-22 23:12:52.49 spid6s       

2020-03-22 23:12:52.50 spid6s      Creating [legacy] procedure sp_droptask...

2020-03-22 23:12:52.59 spid6s       

2020-03-22 23:12:52.59 spid6s      Creating trigger trig_targetserver_insert...

2020-03-22 23:12:53.15 spid6s       

2020-03-22 23:12:53.16 spid6s      Creating procedure sp_add_alert_internal...

2020-03-22 23:12:53.27 spid6s       

2020-03-22 23:12:53.27 spid6s      Creating procedure sp_add_alert...

2020-03-22 23:12:53.49 spid6s       

2020-03-22 23:12:53.49 spid6s      Creating procedure sp_delete_alert...

2020-03-22 23:12:53.61 spid6s       

2020-03-22 23:12:53.62 spid6s      Creating procedure sp_help_alert...

2020-03-22 23:12:53.74 spid6s       

2020-03-22 23:12:53.74 spid6s      Creating procedure sp_verify_operator...

2020-03-22 23:12:53.82 spid6s       

2020-03-22 23:12:53.82 spid6s      Creating procedure sp_add_operator...

2020-03-22 23:12:53.91 spid6s       

2020-03-22 23:12:53.91 spid6s      Creating procedure sp_update_operator...

2020-03-22 23:12:54.02 spid6s       

2020-03-22 23:12:54.02 spid6s      Creating procedure sp_help_operator...

2020-03-22 23:12:54.13 spid6s       

2020-03-22 23:12:54.13 spid6s      Creating procedure sp_help_operator_jobs...

2020-03-22 23:12:54.22 spid6s       

2020-03-22 23:12:54.22 spid6s      Creating procedure sp_verify_operator_identifiers...

2020-03-22 23:12:54.35 spid6s       

2020-03-22 23:12:54.35 spid6s      Creating procedure sp_notify_operator...

2020-03-22 23:12:54.42 spid6s       

2020-03-22 23:12:54.43 spid6s      Creating procedure sp_verify_notification...

2020-03-22 23:12:54.55 spid6s       

2020-03-22 23:12:54.55 spid6s      Creating procedure sp_add_notification...

2020-03-22 23:12:54.63 spid6s       

2020-03-22 23:12:54.63 spid6s      Creating procedure sp_update_notification...

2020-03-22 23:12:54.72 spid6s       

2020-03-22 23:12:54.73 spid6s      Creating procedure sp_delete_notification...

2020-03-22 23:12:54.83 spid6s       

2020-03-22 23:12:54.83 spid6s      Creating procedure sp_help_notification...

2020-03-22 23:12:54.99 spid6s       

2020-03-22 23:12:54.99 spid6s      Creating procedure sp_help_jobactivity...

2020-03-22 23:12:55.28 spid6s       

2020-03-22 23:12:55.28 spid6s      Creating trigger trig_notification_ins_or_upd...

2020-03-22 23:12:55.43 spid6s       

2020-03-22 23:12:55.43 spid6s      Creating trigger trig_notification_delete...

2020-03-22 23:12:55.53 spid6s       

2020-03-22 23:12:55.53 spid6s      Setting object permissions...

2020-03-22 23:12:58.13 Logon       Error: 18401, Severity: 14, State: 1.

2020-03-22 23:12:58.13 Logon       Login failed for user 'sa'. Reason: Server is in script upgrade mode. Only administrator can connect at this time. [CLIENT: 172.50.0.11]

2020-03-22 23:12:58.95 spid6s      The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.

2020-03-22 23:12:58.99 spid6s      The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.

2020-03-22 23:12:59.09 spid6s      The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.

2020-03-22 23:12:59.13 spid6s      The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.

2020-03-22 23:12:59.27 spid6s      The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.

2020-03-22 23:12:59.31 spid6s      The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.

2020-03-22 23:12:59.43 spid6s      The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.

2020-03-22 23:12:59.51 spid6s      The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.

2020-03-22 23:12:59.60 spid6s      The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.

2020-03-22 23:12:59.64 spid6s      The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.

2020-03-22 23:12:59.68 spid6s      The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.

2020-03-22 23:12:59.72 spid6s      The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.

2020-03-22 23:12:59.80 spid6s      The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.

2020-03-22 23:12:59.84 spid6s      The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.

2020-03-22 23:12:59.88 spid6s      The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.

2020-03-22 23:12:59.92 spid6s      The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.

2020-03-22 23:12:59.96 spid6s      The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.

2020-03-22 23:13:00.05 spid6s      The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.

2020-03-22 23:13:00.17 spid6s      The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.

2020-03-22 23:13:00.25 spid6s      The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.

2020-03-22 23:13:00.32 spid6s      The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.

2020-03-22 23:13:00.46 spid6s      The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.

2020-03-22 23:13:00.52 spid6s      The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.

2020-03-22 23:13:00.60 spid6s      The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.

2020-03-22 23:13:00.66 spid6s      The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.

2020-03-22 23:13:00.70 spid6s      The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.

2020-03-22 23:13:00.74 spid6s      The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.

2020-03-22 23:13:00.78 spid6s      The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.

2020-03-22 23:13:00.83 spid6s      The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.

2020-03-22 23:13:00.87 spid6s      The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.

2020-03-22 23:13:00.91 spid6s      The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.

2020-03-22 23:13:00.95 spid6s      The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.

2020-03-22 23:13:02.09 spid6s       

2020-03-22 23:13:02.10 spid6s      Creating procedure sp_sem_add_message...

2020-03-22 23:13:02.28 spid6s       

2020-03-22 23:13:02.28 spid6s      Creating procedure sp_sem_drop_message...

2020-03-22 23:13:02.37 spid6s       

2020-03-22 23:13:02.37 spid6s      Creating procedure sp_get_message_description...

2020-03-22 23:13:02.77 spid6s       

2020-03-22 23:13:02.77 spid6s      Creating procedure sp_convert_jobid_to_char...

2020-03-22 23:13:04.64 spid6s       

2020-03-22 23:13:04.64 spid6s      Creating view sysmail_allitems...

2020-03-22 23:13:04.82 spid6s       

2020-03-22 23:13:04.82 spid6s      Creating view sysmail_sentitems...

2020-03-22 23:13:04.93 spid6s       

2020-03-22 23:13:04.93 spid6s      Creating view sysmail_unsentitems...

2020-03-22 23:13:05.06 spid6s       

2020-03-22 23:13:05.06 spid6s      Creating view sysmail_faileditems...

2020-03-22 23:13:05.20 spid6s      Creating sysmail_delete_mailitems_sp

2020-03-22 23:13:05.34 spid6s       

2020-03-22 23:13:05.34 spid6s      Creating view sysmail_mailattachments...

2020-03-22 23:13:05.51 spid6s       

2020-03-22 23:13:05.51 spid6s      Creating view sysmail_event_log...

2020-03-22 23:13:05.71 spid6s      Creating sysmail_delete_log_sp

2020-03-22 23:13:05.77 spid6s       

2020-03-22 23:13:05.77 spid6s      Creating trigger trig_sysmail_profile...

2020-03-22 23:13:05.86 spid6s       

2020-03-22 23:13:05.86 spid6s      Creating trigger trig_principalprofile...

2020-03-22 23:13:06.08 spid6s       

2020-03-22 23:13:06.08 spid6s      Creating trigger trig_sysmail_account...

2020-03-22 23:13:06.33 spid6s       

2020-03-22 23:13:06.33 spid6s      Creating trigger trig_sysmail_profileaccount...

2020-03-22 23:13:06.42 spid6s       

2020-03-22 23:13:06.42 spid6s      Creating trigger trig_sysmail_profile_delete...

2020-03-22 23:13:06.50 spid6s       

2020-03-22 23:13:06.50 spid6s      Creating trigger trig_sysmail_servertype...

2020-03-22 23:13:06.69 spid6s       

2020-03-22 23:13:06.69 spid6s      Creating trigger trig_sysmail_server...

2020-03-22 23:13:06.78 spid6s       

2020-03-22 23:13:06.78 spid6s      Creating trigger trig_sysmail_configuration...

2020-03-22 23:13:07.45 spid6s       

2020-03-22 23:13:07.45 spid6s      Creating procedure sysmail_verify_accountparams_sp...

2020-03-22 23:13:07.69 spid6s       

2020-03-22 23:13:07.69 spid6s      Creating procedure sysmail_verify_addressparams_sp...

2020-03-22 23:13:07.85 spid6s       

2020-03-22 23:13:07.86 spid6s      Creating procedure sysmail_verify_principal_sp...

2020-03-22 23:13:08.06 spid6s       

2020-03-22 23:13:08.06 spid6s      Creating procedure sysmail_verify_profile_sp...

2020-03-22 23:13:08.20 spid6s       

2020-03-22 23:13:08.20 spid6s      Creating procedure sysmail_verify_account_sp...

2020-03-22 23:13:08.30 spid6s       

2020-03-22 23:13:08.30 spid6s      Creating procedure sysmail_add_profile_sp...

2020-03-22 23:13:08.62 spid6s       

2020-03-22 23:13:08.62 spid6s      Creating procedure sysmail_update_profile_sp...

2020-03-22 23:13:08.99 spid6s       

2020-03-22 23:13:08.99 spid6s      Creating procedure sysmail_delete_profile_sp...

2020-03-22 23:13:09.21 spid6s       

2020-03-22 23:13:09.21 spid6s      Creating procedure sysmail_help_profile_sp...

2020-03-22 23:13:09.28 spid6s       

2020-03-22 23:13:09.28 spid6s      Creating procedure sysmail_create_user_credential_sp...

2020-03-22 23:13:09.38 spid6s       

2020-03-22 23:13:09.38 spid6s      Creating procedure sysmail_alter_user_credential_sp...

2020-03-22 23:13:09.50 spid6s       

2020-03-22 23:13:09.50 spid6s      Creating procedure sysmail_drop_user_credential_sp...

2020-03-22 23:13:09.59 spid6s       

2020-03-22 23:13:09.59 spid6s      Creating procedure sysmail_add_account_sp...

2020-03-22 23:13:09.76 spid6s       

2020-03-22 23:13:09.76 spid6s      Creating procedure sysmail_update_account_sp...

2020-03-22 23:13:09.88 spid6s       

2020-03-22 23:13:09.88 spid6s      Creating procedure sysmail_delete_account_sp...

2020-03-22 23:13:09.95 spid6s       

2020-03-22 23:13:09.95 spid6s      Creating procedure sysmail_help_account_sp...

2020-03-22 23:13:10.02 spid6s       

2020-03-22 23:13:10.02 spid6s      Creating procedure sysmail_help_admin_account_sp...

2020-03-22 23:13:10.11 spid6s       

2020-03-22 23:13:10.11 spid6s      Creating procedure sysmail_add_profileaccount_sp...

2020-03-22 23:13:10.19 spid6s       

2020-03-22 23:13:10.19 spid6s      Creating procedure sysmail_update_profileaccount_sp...

2020-03-22 23:13:10.26 spid6s       

2020-03-22 23:13:10.27 spid6s      Creating procedure sysmail_delete_profileaccount_sp...

2020-03-22 23:13:10.37 spid6s       

2020-03-22 23:13:10.37 spid6s      Creating procedure sysmail_help_profileaccount_sp...

2020-03-22 23:13:18.55 Server      Microsoft SQL Server 2017 (RTM-CU18) (KB4527377) - 14.0.3257.3 (X64) 

    Nov 16 2019 01:14:50 

    Copyright (C) 2017 Microsoft Corporation

    Express Edition (64-bit) on Linux (Ubuntu 16.04.6 LTS)

2020-03-22 23:13:18.55 Server      UTC adjustment: 0:00

2020-03-22 23:13:18.55 Server      (c) Microsoft Corporation.

2020-03-22 23:13:18.55 Server      All rights reserved.

2020-03-22 23:13:18.55 Server      Server process ID is 32.

2020-03-22 23:13:18.55 Server      Logging SQL Server messages in file '/var/opt/mssql/log/errorlog'.

2020-03-22 23:13:18.56 Server      Registry startup parameters: 

     -d /var/opt/mssql/data/master.mdf

     -l /var/opt/mssql/data/mastlog.ldf

     -e /var/opt/mssql/log/errorlog

2020-03-22 23:13:18.56 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.

2020-03-22 23:13:18.56 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.

2020-03-22 23:13:18.57 Server      Detected 25626 MB of RAM. This is an informational message; no user action is required.

2020-03-22 23:13:18.57 Server      Using conventional memory in the memory manager.

2020-03-22 23:13:19.08 Server      Buffer pool extension is already disabled. No action is necessary. 

2020-03-22 23:13:19.32 Server      InitializeExternalUserGroupSid failed. Implied authentication will be disabled.

2020-03-22 23:13:19.32 Server      Implied authentication manager initialization failed. Implied authentication will be disabled.

2020-03-22 23:13:19.33 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'].

2020-03-22 23:13:19.39 Server      The maximum number of dedicated administrator connections for this instance is '1'

2020-03-22 23:13:19.39 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.

2020-03-22 23:13:19.40 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.

2020-03-22 23:13:19.41 Server      In-Memory OLTP initialized on standard machine.

2020-03-22 23:13:19.61 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. 

2020-03-22 23:13:19.62 Server      Query Store settings initialized with enabled = 1, 

2020-03-22 23:13:19.62 Server      Software Usage Metrics is disabled.

2020-03-22 23:13:19.62 spid6s      Starting up database 'master'.

ForceFlush feature is enabled for log durability.

2020-03-22 23:13:20.36 spid6s      10 transactions rolled forward in database 'master' (1:0). This is an informational message only. No user action is required.

2020-03-22 23:13:20.50 spid6s      0 transactions rolled back in database 'master' (1:0). This is an informational message only. No user action is required.

2020-03-22 23:13:20.51 spid6s      Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.

2020-03-22 23:13:20.87 spid6s      Service Master Key could not be decrypted using one of its encryptions. See sys.key_encryptions for details.

2020-03-22 23:13:20.87 spid6s      An error occurred during Service Master Key initialization. SQLErrorCode=33095, State=8, LastOsError=0.

2020-03-22 23:13:20.94 spid6s      SQL Server Audit is starting the audits. This is an informational message. No user action is required.

2020-03-22 23:13:20.94 spid6s      SQL Server Audit has started the audits. This is an informational message. No user action is required.

2020-03-22 23:13:21.22 spid6s      SQL Trace ID 1 was started by login "sa".

2020-03-22 23:13:21.41 spid6s      Server name is '81d7d2c79414'. This is an informational message only. No user action is required.

2020-03-22 23:13:21.42 spid20s     Always On: The availability replica manager is starting. This is an informational message only. No user action is required.

2020-03-22 23:13:21.42 spid20s     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.

2020-03-22 23:13:21.42 spid9s      Starting up database 'mssqlsystemresource'.

2020-03-22 23:13:21.42 spid24s     Starting up database 'vault'.

2020-03-22 23:13:21.42 spid23s     Starting up database 'msdb'.

2020-03-22 23:13:21.43 spid9s      The resource database build version is 14.00.3257. This is an informational message only. No user action is required.

2020-03-22 23:13:21.43 spid19s     A self-generated certificate was successfully loaded for encryption.

2020-03-22 23:13:21.44 spid19s     Server is listening on [ 'any' <ipv6> 1433].

2020-03-22 23:13:21.44 spid9s      Starting up database 'model'.

2020-03-22 23:13:21.44 spid19s     Server is listening on [ 'any' <ipv4> 1433].

2020-03-22 23:13:21.44 spid19s     Dedicated administrator connection support was not started because it is disabled on this edition of SQL Server. If you want to use a dedicated administrator connection, restart SQL Server using the trace flag 7806. This is an informational message only. No user action is required.

2020-03-22 23:13:21.95 spid24s     Parallel redo is started for database 'vault' with worker pool size [4].

2020-03-22 23:13:22.09 spid24s     7 transactions rolled forward in database 'vault' (5:0). This is an informational message only. No user action is required.

2020-03-22 23:13:22.18 spid9s      Polybase feature disabled.

2020-03-22 23:13:22.18 spid9s      Clearing tempdb database.

2020-03-22 23:13:22.36 spid24s     0 transactions rolled back in database 'vault' (5:0). This is an informational message only. No user action is required.

2020-03-22 23:13:22.36 spid24s     Parallel redo is shutdown for database 'vault' with worker pool size [4].

2020-03-22 23:13:22.36 Logon       Error: 18401, Severity: 14, State: 1.

2020-03-22 23:13:22.36 Logon       Login failed for user 'sa'. Reason: Server is in script upgrade mode. Only administrator can connect at this time. [CLIENT: 172.50.0.6]

2020-03-22 23:13:22.65 spid23s     28 transactions rolled forward in database 'msdb' (4:0). This is an informational message only. No user action is required.

2020-03-22 23:13:23.33 spid23s     0 transactions rolled back in database 'msdb' (4:0). This is an informational message only. No user action is required.

2020-03-22 23:13:23.33 spid23s     Recovery is writing a checkpoint in database 'msdb' (4). This is an informational message only. No user action is required.

2020-03-22 23:13:23.73 spid23s     Recovery completed for database msdb (database ID 4) in 2 second(s) (analysis 45 ms, redo 267 ms, undo 14 ms.) This is an informational message only. No user action is required.

2020-03-22 23:13:24.31 spid9s      Starting up database 'tempdb'.

2020-03-22 23:13:24.56 spid17s     The Service Broker endpoint is in disabled or stopped state.

2020-03-22 23:13:24.56 spid17s     The Database Mirroring endpoint is in disabled or stopped state.

2020-03-22 23:13:24.57 spid17s     Service Broker manager has started.

2020-03-22 23:13:26.02 spid6s      Database 'master' is upgrading script 'msdb110_upgrade.sql' from level 234884100 to level 234884281.

2020-03-22 23:13:26.02 spid6s      ----------------------------------

2020-03-22 23:13:26.02 spid6s      Starting execution of PRE_MSDB.SQL

2020-03-22 23:13:26.02 spid6s      ----------------------------------

2020-03-22 23:13:26.90 spid6s      Setting database option COMPATIBILITY_LEVEL to 100 for database 'msdb'.

2020-03-22 23:13:27.28 spid6s      -----------------------------------------

2020-03-22 23:13:27.28 spid6s      Starting execution of PRE_SQLAGENT100.SQL

2020-03-22 23:13:27.28 spid6s      -----------------------------------------

2020-03-22 23:13:27.55 spid6s      Setting database option COMPATIBILITY_LEVEL to 140 for database 'msdb'.

2020-03-22 23:13:27.90 spid6s      Configuration option 'allow updates' changed from 1 to 1. Run the RECONFIGURE statement to install.

2020-03-22 23:13:27.90 spid6s      Configuration option 'allow updates' changed from 1 to 1. Run the RECONFIGURE statement to install.

2020-03-22 23:13:43.25 Logon       Error: 18401, Severity: 14, State: 1.

2020-03-22 23:13:43.25 Logon       Login failed for user 'sa'. Reason: Server is in script upgrade mode. Only administrator can connect at this time. [CLIENT: 172.50.0.11]

2020-03-22 23:14:00.22 Logon       Error: 18401, Severity: 14, State: 1.

2020-03-22 23:14:00.22 Logon       Login failed for user 'sa'. Reason: Server is in script upgrade mode. Only administrator can connect at this time. [CLIENT: 172.50.0.6]

2020-03-22 23:14:05.92 spid6s      Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.

2020-03-22 23:14:06.05 spid6s      Using 'xpstar.dll' version '2017.140.3257' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.

2020-03-22 23:14:06.08 spid6s      DBCC TRACEOFF 1717, server process ID (SPID) 6. This is an informational message only; no user action is required.

2020-03-22 23:14:06.08 spid6s      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

2020-03-22 23:14:06.09 spid6s       

2020-03-22 23:14:06.09 spid6s      Creating table temp_sysjobschedules

2020-03-22 23:14:06.35 spid6s       

2020-03-22 23:14:06.35 spid6s      Alter table sysdownloadlist...

2020-03-22 23:14:06.42 spid6s       

2020-03-22 23:14:06.42 spid6s      Alter table sysjobhistory...

2020-03-22 23:14:06.46 spid6s       

2020-03-22 23:14:06.46 spid6s      Alter table systargetservers...

2020-03-22 23:14:06.52 spid6s       

2020-03-22 23:14:06.52 spid6s      Alter table sysjobsteps...

2020-03-22 23:14:06.97 spid6s      Configuration option 'allow updates' changed from 1 to 0. Run the RECONFIGURE statement to install.

2020-03-22 23:14:06.98 spid6s      Configuration option 'allow updates' changed from 1 to 0. Run the RECONFIGURE statement to install.

2020-03-22 23:14:07.24 spid6s       

2020-03-22 23:14:07.24 spid6s      -----------------------------------------

2020-03-22 23:14:07.24 spid6s      Execution of PRE_SQLAGENT100.SQL complete

2020-03-22 23:14:07.24 spid6s      -----------------------------------------

2020-03-22 23:14:07.27 spid6s      DMF pre-upgrade steps...

2020-03-22 23:14:07.50 spid6s      DC pre-upgrade steps...

2020-03-22 23:14:07.50 spid6s      Check if Data collector config table exists...

2020-03-22 23:14:07.50 spid6s      Data Collector state before upgrade: 0

2020-03-22 23:14:07.50 spid6s      pre_dc100::Check if syscollector_collection_sets_internal table exists...

2020-03-22 23:14:07.50 spid6s      pre_dc100::Capturing Collection set status in temp table...

2020-03-22 23:14:07.71 spid6s      Deleting cached auto-generated T-SQL Data Collection packages from msdb...

2020-03-22 23:14:07.71 spid6s      End of DC pre-upgrade steps.

2020-03-22 23:14:07.72 spid6s      DAC pre-upgrade steps...

2020-03-22 23:14:07.73 spid6s      Starting DAC pre-upgrade steps ...

2020-03-22 23:14:07.73 spid6s      End of DAC pre-upgrade steps.

2020-03-22 23:14:07.73 spid6s      ----------------------------------

2020-03-22 23:14:07.73 spid6s      Starting execution of MSDB.SQL

2020-03-22 23:14:07.73 spid6s      ----------------------------------

2020-03-22 23:14:07.84 spid6s      Configuration option 'allow updates' changed from 0 to 1. Run the RECONFIGURE statement to install.

2020-03-22 23:14:07.84 spid6s      Configuration option 'allow updates' changed from 0 to 1. Run the RECONFIGURE statement to install.

2020-03-22 23:14:08.10 spid6s      Checking the size of MSDB...

2020-03-22 23:14:09.23 spid6s       

2020-03-22 23:14:09.23 spid6s      Setting database option TRUSTWORTHY to ON for database 'msdb'.

2020-03-22 23:14:09.23 spid6s      Setting database option RECOVERY to SIMPLE for database 'msdb'.

2020-03-22 23:14:09.86 spid6s      ----------------------------------

2020-03-22 23:14:09.86 spid6s      Finished execution of MSDB.SQL

2020-03-22 23:14:09.86 spid6s      ----------------------------------

2020-03-22 23:14:09.86 spid6s      -----------------------------------------

2020-03-22 23:14:09.86 spid6s      Starting execution of MSDB_VERSIONING.SQL

2020-03-22 23:14:09.86 spid6s      -----------------------------------------

2020-03-22 23:14:09.93 spid6s      -----------------------------------------

2020-03-22 23:14:09.93 spid6s      Finished execution of MSDB_VERSIONING.SQL

2020-03-22 23:14:09.93 spid6s      -----------------------------------------

2020-03-22 23:14:10.49 spid6s       

2020-03-22 23:14:10.49 spid6s      Creating procedure sp_agent_add_job...

2020-03-22 23:14:10.71 spid6s       

2020-03-22 23:14:10.71 spid6s      Creating procedure sp_agent_delete_job...

2020-03-22 23:14:10.80 spid6s       

2020-03-22 23:14:10.81 spid6s      Creating procedure sp_agent_add_jobstep...

2020-03-22 23:14:10.90 spid6s       

2020-03-22 23:14:10.90 spid6s      Creating procedure sp_agent_start_job...

2020-03-22 23:14:10.97 spid6s       

2020-03-22 23:14:10.97 spid6s      Creating procedure sp_agent_get_jobstep...

2020-03-22 23:14:11.15 spid6s       

2020-03-22 23:14:11.15 spid6s      Creating procedure sp_agent_log_job_history...

2020-03-22 23:14:11.24 spid6s       

2020-03-22 23:14:11.24 spid6s      Creating procedure sp_agent_write_sysjobstep_log...

2020-03-22 23:14:11.36 spid6s       

2020-03-22 23:14:11.36 spid6s      Creating table syssubsystems...

2020-03-22 23:14:11.52 spid6s       

2020-03-22 23:14:11.52 spid6s      Creating view sysproxyloginsubsystem_view...

2020-03-22 23:14:11.73 spid6s       

2020-03-22 23:14:11.73 spid6s      Creating trigger trig_sysoriginatingservers_delete...

2020-03-22 23:14:11.82 spid6s       

2020-03-22 23:14:11.82 spid6s      Creating view sysoriginatingservers_view...

2020-03-22 23:14:11.94 spid6s       

2020-03-22 23:14:11.94 spid6s      Creating trigger trig_sysjobs_insert_update...

2020-03-22 23:14:12.16 spid6s       

2020-03-22 23:14:12.16 spid6s      Creating view sysjobs_view...

2020-03-22 23:14:12.36 spid6s       

2020-03-22 23:14:12.37 spid6s      Creating trigger trig_sysschedules_insert_update...

2020-03-22 23:14:12.61 spid6s       

2020-03-22 23:14:12.61 spid6s      Creating view sysschedules_localserver_view...

2020-03-22 23:14:13.76 Logon       Error: 18401, Severity: 14, State: 1.

2020-03-22 23:14:13.76 Logon       Login failed for user 'sa'. Reason: Server is in script upgrade mode. Only administrator can connect at this time. [CLIENT: 172.50.0.11]

2020-03-22 23:14:14.74 spid6s       

2020-03-22 23:14:14.74 spid6s      Creating view systargetservers_view...

2020-03-22 23:14:14.85 spid6s       

2020-03-22 23:14:14.85 spid6s      Creating view sysalerts_performance_counters_view...

2020-03-22 23:14:14.97 spid6s       

2020-03-22 23:14:14.97 spid6s      Creating function SQLAGENT_SUSER_SNAME ...

2020-03-22 23:14:15.16 spid6s       

2020-03-22 23:14:15.16 spid6s      Creating function SQLAGENT_SUSER_SID ...

2020-03-22 23:14:15.45 spid6s       

2020-03-22 23:14:15.45 spid6s      Creating procedure SP_SQLAGENT_IS_SRVROLEMEMBER...

2020-03-22 23:14:15.56 spid6s       

2020-03-22 23:14:15.57 spid6s      Creating procedure sp_get_traceflag_status_internal...

2020-03-22 23:14:15.68 spid6s       

2020-03-22 23:14:15.68 spid6s      Creating procedure sp_verify_category_identifiers...

2020-03-22 23:14:15.80 spid6s       

2020-03-22 23:14:15.80 spid6s      Creating function agent_datetime...

2020-03-22 23:14:15.90 spid6s       

2020-03-22 23:14:15.90 spid6s      Creating procedure sp_verify_proxy_identifiers...

2020-03-22 23:14:16.01 spid6s       

2020-03-22 23:14:16.01 spid6s      Creating procedure sp_verify_credential_identifiers...

2020-03-22 23:14:16.22 spid6s       

2020-03-22 23:14:16.22 spid6s      Creating procedure sp_verify_subsystems...

2020-03-22 23:14:16.35 spid6s       

2020-03-22 23:14:16.35 spid6s      Creating procedure sp_verify_subsystem_identifiers...

2020-03-22 23:14:16.48 spid6s       

2020-03-22 23:14:16.48 spid6s      Creating procedure sp_verify_login_identifiers...

2020-03-22 23:14:16.65 spid6s       

2020-03-22 23:14:16.65 spid6s      Creating procedure sp_verify_proxy...

2020-03-22 23:14:16.75 spid6s       

2020-03-22 23:14:16.75 spid6s      Creating procedure sp_add_proxy...

2020-03-22 23:14:16.93 spid6s       

2020-03-22 23:14:16.93 spid6s      Creating procedure sp_delete_proxy...

2020-03-22 23:14:17.11 spid6s       

2020-03-22 23:14:17.11 spid6s      Creating procedure sp_update_proxy...

2020-03-22 23:14:17.31 spid6s       

2020-03-22 23:14:17.31 spid6s      Creating procedure sp_sqlagent_is_member...

2020-03-22 23:14:17.57 spid6s       

2020-03-22 23:14:17.57 spid6s      Creating procedure sp_verify_proxy_permissions...

2020-03-22 23:14:17.78 spid6s       

2020-03-22 23:14:17.78 spid6s      Creating procedure sp_help_proxy...

2020-03-22 23:14:17.89 spid6s       

2020-03-22 23:14:17.89 spid6s      Creating procedure sp_get_proxy_properties...

2020-03-22 23:14:18.06 spid6s       

2020-03-22 23:14:18.06 spid6s      Creating procedure sp_grant_proxy_to_subsystem...

2020-03-22 23:14:18.45 spid6s       

2020-03-22 23:14:18.45 spid6s      Creating procedure sp_grant_login_to_proxy...

2020-03-22 23:14:18.61 spid6s       

2020-03-22 23:14:18.61 spid6s      Creating procedure sp_revoke_login_from_proxy...

2020-03-22 23:14:18.84 spid6s       

2020-03-22 23:14:18.84 spid6s      Creating procedure sp_revoke_proxy_from_subsystem...

2020-03-22 23:14:18.97 spid6s       

2020-03-22 23:14:18.97 spid6s      Creating procedure sp_enum_proxy_for_subsystem...

2020-03-22 23:14:19.58 spid6s       

2020-03-22 23:14:19.58 spid6s      Creating procedure sp_enum_login_for_proxy...

2020-03-22 23:14:19.72 spid6s       

2020-03-22 23:14:19.72 spid6s      Creating procedure sp_reassign_proxy...

2020-03-22 23:14:19.84 spid6s       

2020-03-22 23:14:19.84 spid6s      Creating procedure sp_sqlagent_get_startup_info...

2020-03-22 23:14:19.93 spid6s       

2020-03-22 23:14:19.94 spid6s      Creating procedure sp_sqlagent_update_agent_xps...

2020-03-22 23:14:20.08 spid6s       

2020-03-22 23:14:20.08 spid6s      Creating procedure sp_sqlagent_has_server_access...

2020-03-22 23:14:20.26 Logon       Error: 18401, Severity: 14, State: 1.

2020-03-22 23:14:20.26 Logon       Login failed for user 'sa'. Reason: Server is in script upgrade mode. Only administrator can connect at this time. [CLIENT: 172.50.0.6]

2020-03-22 23:14:20.31 spid6s       

2020-03-22 23:14:20.32 spid6s      Creating procedure sp_sqlagent_get_perf_counters...

2020-03-22 23:14:20.53 spid6s       

2020-03-22 23:14:20.53 spid6s      Creating procedure sp_sqlagent_notify...

2020-03-22 23:14:20.71 spid6s       

2020-03-22 23:14:20.71 spid6s      Creating procedure sp_is_sqlagent_starting...

2020-03-22 23:14:20.90 spid6s       

2020-03-22 23:14:20.90 spid6s      Creating procedure sp_verify_job_identifiers...

2020-03-22 23:14:21.10 spid6s       

2020-03-22 23:14:21.10 spid6s      Creating procedure sp_verify_schedule_identifiers...

2020-03-22 23:14:21.23 spid6s       

2020-03-22 23:14:21.23 spid6s      Creating procedure sp_verify_jobproc_caller...

2020-03-22 23:14:21.38 spid6s       

2020-03-22 23:14:21.39 spid6s      Creating procedure sp_downloaded_row_limiter...

2020-03-22 23:14:21.58 spid6s       

2020-03-22 23:14:21.59 spid6s      Creating procedure sp_post_msx_operation...

2020-03-22 23:14:21.75 spid6s       

2020-03-22 23:14:21.75 spid6s      Creating procedure sp_verify_performance_condition...

2020-03-22 23:14:21.89 spid6s       

2020-03-22 23:14:21.89 spid6s      Creating procedure sp_verify_job_date...

2020-03-22 23:14:22.08 spid6s       

2020-03-22 23:14:22.08 spid6s      Creating procedure sp_verify_job_time...

2020-03-22 23:14:22.45 spid6s       

2020-03-22 23:14:22.45 spid6s      Creating procedure sp_verify_alert...

2020-03-22 23:14:22.76 spid6s       

2020-03-22 23:14:22.77 spid6s      Creating procedure sp_update_alert...

2020-03-22 23:14:23.00 spid6s       

2020-03-22 23:14:23.00 spid6s      Creating procedure sp_delete_job_references...

2020-03-22 23:14:23.11 spid6s       

2020-03-22 23:14:23.12 spid6s      Creating procedure sp_delete_all_msx_jobs...

2020-03-22 23:14:23.25 spid6s       

2020-03-22 23:14:23.25 spid6s      Creating procedure sp_generate_target_server_job_assignment_sql...

2020-03-22 23:14:23.45 spid6s       

2020-03-22 23:14:23.45 spid6s      Creating procedure sp_generate_server_description...

2020-03-22 23:14:23.58 spid6s       

2020-03-22 23:14:23.58 spid6s      Creating procedure sp_msx_set_account...

2020-03-22 23:14:23.68 spid6s       

2020-03-22 23:14:23.68 spid6s      Creating procedure sp_msx_get_account...

2020-03-22 23:14:23.83 spid6s       

2020-03-22 23:14:23.83 spid6s      Creating procedure sp_delete_operator...

2020-03-22 23:14:23.96 spid6s       

2020-03-22 23:14:23.96 spid6s      Creating procedure sp_msx_defect...

2020-03-22 23:14:24.48 spid6s       

2020-03-22 23:14:24.48 spid6s      Creating procedure sp_msx_enlist...

2020-03-22 23:14:24.62 spid6s       

2020-03-22 23:14:24.63 spid6s      Creating procedure sp_delete_targetserver...

2020-03-22 23:14:24.77 spid6s       

2020-03-22 23:14:24.77 spid6s      Creating procedure sp_enlist_tsx

2020-03-22 23:14:24.93 spid6s       

2020-03-22 23:14:24.93 spid6s      Creating procedure sp_get_sqlagent_properties...

2020-03-22 23:14:25.18 spid6s       

2020-03-22 23:14:25.18 spid6s      Create procedure sp_set_sqlagent_properties...

2020-03-22 23:14:25.25 spid6s       

2020-03-22 23:14:25.25 spid6s      Creating procedure sp_add_targetservergroup...

2020-03-22 23:14:25.45 spid6s       

2020-03-22 23:14:25.45 spid6s      Creating procedure sp_update_targetservergroup...

2020-03-22 23:14:25.58 spid6s       

2020-03-22 23:14:25.58 spid6s      Creating procedure sp_delete_targetservergroup...

2020-03-22 23:14:25.70 spid6s       

2020-03-22 23:14:25.70 spid6s      Creating procedure sp_help_targetservergroup...

2020-03-22 23:14:25.82 spid6s       

2020-03-22 23:14:25.82 spid6s      Creating procedure sp_add_targetsvgrp_member...

2020-03-22 23:14:25.97 spid6s       

2020-03-22 23:14:25.97 spid6s      Creating procedure sp_delete_targetsvrgrp_member...

2020-03-22 23:14:26.06 spid6s       

2020-03-22 23:14:26.06 spid6s      Creating procedure sp_verify_category...

2020-03-22 23:14:26.23 spid6s       

2020-03-22 23:14:26.23 spid6s      Creating procedure sp_add_category...

2020-03-22 23:14:26.49 spid6s       

2020-03-22 23:14:26.49 spid6s      Creating procedure sp_update_category...

2020-03-22 23:14:26.75 spid6s       

2020-03-22 23:14:26.75 spid6s      Creating procedure sp_delete_category...

2020-03-22 23:14:26.89 spid6s       

2020-03-22 23:14:26.89 spid6s      Creating procedure sp_help_category...

2020-03-22 23:14:27.01 spid6s       

2020-03-22 23:14:27.01 spid6s      Creating procedure sp_help_targetserver...

2020-03-22 23:14:27.12 spid6s       

2020-03-22 23:14:27.12 spid6s      Creating procedure sp_resync_targetserver...

2020-03-22 23:14:27.82 spid6s       

2020-03-22 23:14:27.82 spid6s      Creating procedure sp_purge_jobhistory...

2020-03-22 23:14:28.19 spid6s       

2020-03-22 23:14:28.19 spid6s      Creating procedure sp_help_jobhistory...

2020-03-22 23:14:28.31 spid6s       

2020-03-22 23:14:28.31 spid6s      Creating procedure sp_add_jobserver...

2020-03-22 23:14:28.43 spid6s       

2020-03-22 23:14:28.43 spid6s      Creating procedure sp_delete_jobserver...

2020-03-22 23:14:28.53 spid6s       

2020-03-22 23:14:28.53 spid6s      Creating procedure sp_help_jobserver...

2020-03-22 23:14:28.68 spid6s       

2020-03-22 23:14:28.69 spid6s      Creating procedure sp_help_downloadlist...

2020-03-22 23:14:28.92 spid6s       

2020-03-22 23:14:28.92 spid6s      Creating procedure sp_enum_sqlagent_subsystems_internal...

2020-03-22 23:14:29.07 spid6s       

2020-03-22 23:14:29.07 spid6s      Creating procedure sp_enum_sqlagent_subsystems...

2020-03-22 23:14:29.17 spid6s       

2020-03-22 23:14:29.17 spid6s      Creating procedure sp_verify_subsystem...

2020-03-22 23:14:29.27 spid6s       

2020-03-22 23:14:29.27 spid6s      Creating procedure sp_verify_schedule...

2020-03-22 23:14:29.40 spid6s       

2020-03-22 23:14:29.40 spid6s      Creating procedure sp_add_schedule...

2020-03-22 23:14:29.88 spid6s       

2020-03-22 23:14:29.88 spid6s      Creating procedure sp_attach_schedule ...

2020-03-22 23:14:30.03 spid6s       

2020-03-22 23:14:30.03 spid6s      Creating procedure sp_detach_schedule ...

2020-03-22 23:14:30.24 spid6s       

2020-03-22 23:14:30.24 spid6s      Creating procedure sp_update_replication_job_parameter...

2020-03-22 23:14:30.41 spid6s       

2020-03-22 23:14:30.41 spid6s      Creating procedure sp_update_schedule ...

2020-03-22 23:14:30.78 spid6s       

2020-03-22 23:14:30.78 spid6s      Creating procedure sp_delete_schedule ...

2020-03-22 23:14:31.06 spid6s       

2020-03-22 23:14:31.07 spid6s      Creating procedure sp_get_jobstep_db_username...

2020-03-22 23:14:31.21 spid6s       

2020-03-22 23:14:31.21 spid6s      Creating procedure sp_verify_jobstep...

2020-03-22 23:14:31.41 spid6s       

2020-03-22 23:14:31.41 spid6s      Creating procedure sp_add_jobstep_internal...

2020-03-22 23:14:31.52 spid6s       

2020-03-22 23:14:31.52 spid6s      Creating procedure sp_add_jobstep...

2020-03-22 23:14:31.63 spid6s       

2020-03-22 23:14:31.63 spid6s      Creating procedure sp_update_jobstep...

2020-03-22 23:14:31.82 spid6s       

2020-03-22 23:14:31.82 spid6s      Creating procedure sp_delete_jobstep...

2020-03-22 23:14:31.96 spid6s       

2020-03-22 23:14:31.96 spid6s      Creating procedure sp_help_jobstep...

2020-03-22 23:14:32.07 spid6s       

2020-03-22 23:14:32.07 spid6s      Creating procedure sp_write_sysjobstep_log...

2020-03-22 23:14:32.14 spid6s       

2020-03-22 23:14:32.14 spid6s      Creating procedure sp_help_jobsteplog...

2020-03-22 23:14:32.23 spid6s       

2020-03-22 23:14:32.23 spid6s      Creating procedure sp_delete_jobsteplog...

2020-03-22 23:14:32.40 spid6s       

2020-03-22 23:14:32.40 spid6s      Creating procedure sp_get_schedule_description...

2020-03-22 23:14:33.07 spid6s       

2020-03-22 23:14:33.07 spid6s      Creating procedure sp_add_jobschedule...

2020-03-22 23:14:33.19 spid6s       

2020-03-22 23:14:33.20 spid6s      Creating procedure sp_update_jobschedule...

2020-03-22 23:14:33.39 spid6s       

2020-03-22 23:14:33.39 spid6s      Creating procedure sp_delete_jobschedule...

2020-03-22 23:14:33.49 spid6s       

2020-03-22 23:14:33.49 spid6s      Creating procedure sp_help_schedule...

2020-03-22 23:14:33.65 spid6s       

2020-03-22 23:14:33.65 spid6s      Creating procedure sp_help_jobschedule...

2020-03-22 23:14:34.35 spid6s       

2020-03-22 23:14:34.36 spid6s      Creating procedure sp_verify_job...

2020-03-22 23:14:34.47 spid6s       

2020-03-22 23:14:34.47 spid6s      Creating procedure sp_add_job...

2020-03-22 23:14:34.57 spid6s       

2020-03-22 23:14:34.57 spid6s      Creating procedure sp_update_job...

2020-03-22 23:14:34.67 spid6s       

2020-03-22 23:14:34.67 spid6s      Creating procedure sp_delete_job...

2020-03-22 23:14:35.31 spid6s       

2020-03-22 23:14:35.31 spid6s      Creating procedure sp_get_composite_job_info...

2020-03-22 23:14:35.53 spid6s       

2020-03-22 23:14:35.54 spid6s      Creating procedure sp_help_job...

2020-03-22 23:14:36.27 spid6s       

2020-03-22 23:14:36.27 spid6s      Creating procedure sp_help_jobcount...

2020-03-22 23:14:36.36 spid6s       

2020-03-22 23:14:36.37 spid6s      Creating procedure sp_help_jobs_in_schedule...

2020-03-22 23:14:36.46 spid6s       

2020-03-22 23:14:36.47 spid6s      Creating procedure sp_manage_jobs_by_login...

2020-03-22 23:14:36.56 spid6s       

2020-03-22 23:14:36.57 spid6s      Creating procedure sp_apply_job_to_targets...

2020-03-22 23:14:36.66 spid6s       

2020-03-22 23:14:36.66 spid6s      Creating procedure sp_remove_job_from_targets...

2020-03-22 23:14:36.73 spid6s       

2020-03-22 23:14:36.73 spid6s      Creating procedure sp_get_job_alerts...

2020-03-22 23:14:36.87 spid6s       

2020-03-22 23:14:36.87 spid6s      Creating procedure sp_start_job...

2020-03-22 23:14:37.05 spid6s       

2020-03-22 23:14:37.05 spid6s      Creating procedure sp_stop_job...

2020-03-22 23:14:37.19 spid6s       

2020-03-22 23:14:37.19 spid6s      Creating procedure sp_cycle_agent_errorlog...

2020-03-22 23:14:37.27 spid6s       

2020-03-22 23:14:37.27 spid6s      Creating procedure sp_get_chunked_jobstep_params...

2020-03-22 23:14:37.35 spid6s       

2020-03-22 23:14:37.35 spid6s      Creating procedure sp_check_for_owned_jobs...

2020-03-22 23:14:37.46 spid6s       

2020-03-22 23:14:37.46 spid6s      Creating procedure sp_check_for_owned_jobsteps...

2020-03-22 23:14:37.55 spid6s       

2020-03-22 23:14:37.55 spid6s      Creating procedure sp_sqlagent_refresh_job...

2020-03-22 23:14:37.64 spid6s       

2020-03-22 23:14:37.64 spid6s      Creating procedure sp_jobhistory_row_limiter...

2020-03-22 23:14:37.82 spid6s       

2020-03-22 23:14:37.82 spid6s      Creating procedure [dbo].[sp_sqlagent_set_job_completion_state]...

2020-03-22 23:14:37.91 spid6s       

2020-03-22 23:14:37.91 spid6s      Creating procedure [dbo].[sp_sqlagent_set_jobstep_completion_state]...

2020-03-22 23:14:38.03 spid6s       

2020-03-22 23:14:38.04 spid6s      Creating procedure [dbo].[sp_sqlagent_create_jobactivity]...

2020-03-22 23:14:38.18 spid6s       

2020-03-22 23:14:38.18 spid6s      Creating procedure [dbo].[sp_sqlagent_update_jobactivity_next_scheduled_date]...

2020-03-22 23:14:38.28 spid6s       

2020-03-22 23:14:38.28 spid6s      Creating procedure [dbo].[sp_sqlagent_update_jobactivity_requested_date]...

2020-03-22 23:14:38.45 spid6s       

2020-03-22 23:14:38.45 spid6s      Creating procedure [dbo].[sp_sqlagent_update_jobactivity_queued_date]...

2020-03-22 23:14:38.57 spid6s       

2020-03-22 23:14:38.57 spid6s      Creating procedure [dbo].[sp_sqlagent_update_jobactivity_start_execution_date]...

2020-03-22 23:14:38.62 spid6s       

2020-03-22 23:14:38.62 spid6s      Creating procedure sp_sqlagent_log_jobhistory...

2020-03-22 23:14:38.71 spid6s       

2020-03-22 23:14:38.71 spid6s      Creating procedure sp_sqlagent_check_msx_version...

2020-03-22 23:14:38.86 spid6s       

2020-03-22 23:14:38.86 spid6s      Creating procedure sp_sqlagent_probe_msx...

2020-03-22 23:14:38.96 spid6s       

2020-03-22 23:14:38.96 spid6s      Creating procedure sp_set_local_time...

2020-03-22 23:14:39.20 spid6s       

2020-03-22 23:14:39.20 spid6s      Creating procedure sp_multi_server_job_summary...

2020-03-22 23:14:39.31 spid6s       

2020-03-22 23:14:39.31 spid6s      Creating procedure sp_target_server_summary...

2020-03-22 23:14:40.11 spid6s       

2020-03-22 23:14:40.11 spid6s      Creating [legacy] procedure sp_uniquetaskname...

2020-03-22 23:14:40.28 Logon       Error: 18401, Severity: 14, State: 1.

2020-03-22 23:14:40.28 Logon       Login failed for user 'sa'. Reason: Server is in script upgrade mode. Only administrator can connect at this time. [CLIENT: 172.50.0.6]

2020-03-22 23:14:40.33 spid6s       

2020-03-22 23:14:40.33 spid6s      Creating [legacy] procedure sp_addtask...

2020-03-22 23:14:40.43 spid6s       

2020-03-22 23:14:40.43 spid6s      Creating [legacy] procedure sp_droptask...

2020-03-22 23:14:41.09 spid6s       

2020-03-22 23:14:41.09 spid6s      Creating trigger trig_targetserver_insert...

2020-03-22 23:14:41.64 spid6s       

2020-03-22 23:14:41.64 spid6s      Creating procedure sp_add_alert_internal...

2020-03-22 23:14:41.75 spid6s       

2020-03-22 23:14:41.75 spid6s      Creating procedure sp_add_alert...

2020-03-22 23:14:41.84 spid6s       

2020-03-22 23:14:41.84 spid6s      Creating procedure sp_delete_alert...

2020-03-22 23:14:41.99 spid6s       

2020-03-22 23:14:41.99 spid6s      Creating procedure sp_help_alert...

2020-03-22 23:14:42.09 spid6s       

2020-03-22 23:14:42.09 spid6s      Creating procedure sp_verify_operator...

2020-03-22 23:14:42.18 spid6s       

2020-03-22 23:14:42.19 spid6s      Creating procedure sp_add_operator...

2020-03-22 23:14:42.27 spid6s       

2020-03-22 23:14:42.27 spid6s      Creating procedure sp_update_operator...

2020-03-22 23:14:42.43 spid6s       

2020-03-22 23:14:42.44 spid6s      Creating procedure sp_help_operator...

2020-03-22 23:14:42.51 spid6s       

2020-03-22 23:14:42.51 spid6s      Creating procedure sp_help_operator_jobs...

2020-03-22 23:14:42.59 spid6s       

2020-03-22 23:14:42.60 spid6s      Creating procedure sp_verify_operator_identifiers...

2020-03-22 23:14:42.67 spid6s       

2020-03-22 23:14:42.67 spid6s      Creating procedure sp_notify_operator...

2020-03-22 23:14:42.76 spid6s       

2020-03-22 23:14:42.76 spid6s      Creating procedure sp_verify_notification...

2020-03-22 23:14:42.84 spid6s       

2020-03-22 23:14:42.84 spid6s      Creating procedure sp_add_notification...

2020-03-22 23:14:42.93 spid6s       

2020-03-22 23:14:42.93 spid6s      Creating procedure sp_update_notification...

2020-03-22 23:14:43.05 spid6s       

2020-03-22 23:14:43.05 spid6s      Creating procedure sp_delete_notification...

2020-03-22 23:14:43.15 spid6s       

2020-03-22 23:14:43.15 spid6s      Creating procedure sp_help_notification...

2020-03-22 23:14:43.25 spid6s       

2020-03-22 23:14:43.25 spid6s      Creating procedure sp_help_jobactivity...

2020-03-22 23:14:43.40 spid6s       

2020-03-22 23:14:43.40 spid6s      Creating trigger trig_notification_ins_or_upd...

2020-03-22 23:14:43.47 spid6s       

2020-03-22 23:14:43.47 spid6s      Creating trigger trig_notification_delete...

2020-03-22 23:14:43.56 spid6s       

2020-03-22 23:14:43.56 spid6s      Setting object permissions...

2020-03-22 23:14:44.26 Logon       Error: 18401, Severity: 14, State: 1.

2020-03-22 23:14:44.26 Logon       Login failed for user 'sa'. Reason: Server is in script upgrade mode. Only administrator can connect at this time. [CLIENT: 172.50.0.11]
kspearrin commented 4 years ago

Looks like it is upgrading from a previous version of mssql. Wait a bit for it to finish and try again.

Y0ngg4n commented 4 years ago

@kspearrin In the Log, you can see, the Process is repeating. It will never Finish because it gets an error: Error: 18401, Severity: 14, State: 1. I left it running the whole night but it still loops.

kspearrin commented 4 years ago

What happens if you try again now?

Y0ngg4n commented 4 years ago

@kspearrin Same behavior :/

Y0ngg4n commented 4 years ago

@kspearrin My fault. I used willfarrell/docker-autoheal to restart containers with healthcheck where healthcheck failed. The AutoHeal container restarted the bitwarden-mssql container everytime while in update process. I disabled it, to let the bitwarden-mssql updating. No everything is working fine. Thanks for the support!