sql server 2017 express ubuntu 18.04, sql server timeout error, under a VPS server 2G ram 4 virtual cpu core.
compiled and published with vs2019 for net core self contained and release ubuntu x64 platform.
sqlcmd -S localhost-U SA -P
sqlcmd still works and return command line.
The "Send emails" scheduled task failed with the "One or more errors occurred
The "Send emails" scheduled task failed with the "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding." error (Task type: "Nop.Services.Messages.QueuedMessagesSendTask, Nop.Services". Store name: "Your store name". Task run address: "http://www.abcdef.com/scheduletask/runtask").
System.Data.SqlClient.SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
---> System.ComponentModel.Win32Exception (258): Unknown error 258
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
The "Keep alive" scheduled task failed with the "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding." error (Task type: "Nop.Services.Common.KeepAliveTask, Nop.Services". Store name: "Your store name". Task run address: "http://www.abcdef.com/scheduletask/runtask").
System.Data.SqlClient.SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
---> System.ComponentModel.Win32Exception (258): Unknown error 258
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
Connection Timeout Expired. The timeout period elapsed during the post-login phase. The connection could have timed out while waiting for server to complete the login process and respond; Or it could have timed out while attempting to create multiple active connections. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=0; handshake=73; [Login] initialization=0; authentication=0; [Post-Login] complete=14101;
System.Data.SqlClient.SqlException (0x80131904): Connection Timeout Expired. The timeout period elapsed during the post-login phase. The connection could have timed out while waiting for server to complete the login process and respond; Or it could have timed out while attempting to create multiple active connections. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=0; handshake=73; [Login] initialization=0; authentication=0; [Post-Login] complete=14101;
---> System.ComponentModel.Win32Exception (258): Unknown error 258
