Resource Hosting Subsystem was terminated which caused Availability group to fail

The following error was occurred in cluster events and the availability group was failed which resulted the databases in non-synchronizing state.

A component on the server did not respond in a timely fashion. This caused the cluster resource ‘AG’ (resource type ‘SQL Server Availability Group’, DLL ‘hadrres.dll’) to exceed its time-out threshold. As part of cluster health detection, recovery actions will be taken. The cluster will try to automatically recover by terminating and restarting the Resource Hosting Subsystem (RHS) process that is running this resource.

Please help me to find the root cause (A component on the server did not respond in a timely fashion).

Thanks

Does an out-of-sight creature affected by the Fear spell have to keep running if they fail the saving throw?

Imagine a (D&D 5e) spellcaster casts Fear on an enemy, and the enemy fails their Wisdom saving throw. On its turn, the enemy drops what it’s holding and takes the Dash action, running away from the spellcaster and around a corner, putting it out of sight of the spellcaster. The enemy ends its turn out-of-sight of the spellcaster, so it can make the Wisdom saving throw again; again, it fails. On its next turn does the enemy have to continue running away? Even though it’s out of sight of the spellcaster? My reading of the spell is yes: they have to continue to run away until they succeed on the save (or the spellcaster drops the spell for some other reason). Is this right, or can the enemy remain in place out-of-sight? (They obviously can’t approach closer to the spellcaster because they’re affected by the frightened condition.)

Do you know when you fail a saving throw?

The pathfinder rules say:

A creature that successfully saves against a spell that has no obvious physical effects feels a hostile force or a tingle, but cannot deduce the exact nature of the attack. Likewise, if a creature’s saving throw succeeds against a targeted spell, you sense that the spell has failed. You do not sense when creatures succeed on saves against effect and area spells.

If a creature’s saving throw fails against a spell, does the creature still feel that "hostile force or a tingle" or otherwise know that they’ve failed a save?

(I’m asking this question because it’s relevant to How powerful can a 20th-level Wizard make a 1st-level Fighter without allowing him to realize it is the Wizard's doing?)

What happens to an abjurer’s Arcane Ward when they fail the saving throw against a Banshee’s Wail?

An abjuration wizard has the Arcane Ward class feature (PHB, p. 115):

Starting at 2nd level, you can weave magic around yourself for protection. When you cast an abjuration spell of 1st level or higher, you can simultaneously use a strand of the spell’s magic to create a magical ward on yourself that lasts until you finish a long rest. The ward has hit points equal to twice your wizard level + your Intelligence modifier. Whenever you take damage, the ward takes the damage instead. If this damage reduces the ward to 0 hit points, you take any remaining damage.

A Banshee (MM, p. 23) has the Wail action:

Wail (1/Day). The banshee releases a mournful wail, provided that she isn’t in sunlight. This wail has no effect on constructs and undead. All other creatures within 30 feet of her that can hear her must make a DC 13 Constitution saving throw. On a failure, a creature drops to 0 hit points. On a success, a creature takes 10 (3d6) psychic damage.

If an abjuration wizard who has an Arcane Ward active fails their saving throw against a Banshee’s Wail, they would drop to 0 hit points. What happens to their ward?

  • Does it drop to 0 hit points instead of the wizard (meaning the wizard does not drop to 0 hit points)? The Wail ability is not damage (if you fail the save), whereas the Arcane Ward specifically mentions damage, so I assume this isn’t how it works…
  • Does it disappear when the wizard drops to 0 hit points? I don’t think anything about the Banshee’s Wail or dropping to 0 hit points generally would make it disappear…
  • Does it remain active? I’m assuming this is the most likely answer, given my above reasoning…

Why would a scheduled job fail in SQL Developer?

I am trying to create a scheduled job in Oracle SQL Developer that would run once a month and I am testing the Scheduler/Jobs feature where I have created a simple SQL query to test the ability to do this. I have a simple table called "TEST123" and I can see that it works when I do "SELECT * FROM TEST123;".

In SQL Developer I have a Job called "TEST1" which has a PL/SQL Block = "DROP TABLE TEST123;" to run immediately (though I have also tested this with running at a specific time).

After I see that I can still select from this test table and that the STATE of the job name is "FAILED". I left all other settings as default. What am I missing here? Why is it failing and is there a way to fix it?

SQL server backup fail “A system assertion check has failed”

I just installed SQL Server 2017 EVAL in a Windows Server 2012 R2 VM. Most default options.

Default installation folder. SYSTEM databases in default folder. User databases in the D:\ drive. Created some databases, some users, installed Brent Ozar and Ola Hallengren scripts. Next thing I was configuring the backups on the E:\ and getting an error. So i tried to run manually:

BACKUP DATABASE [DABOL12] TO  DISK = N'E:\BACKUP\teste.bak' WITH NOFORMAT, NOINIT,  NAME = N'DABOL12-Completo Banco de Dados Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10 GO 

and getting this error:

Location:    mediaWrite.cpp:603 Expression:  (m_pWriteBuffer->GetCurrentSize ()% GetBlockSize ()) == 0 SPID:        56 Process ID:  1104 Mensagem 3013, Nível 16, Estado 1, Linha 1 BACKUP DATABASE está sendo encerrado de forma anormal. Mensagem 3624, Nível 20, Estado 1, Linha 1 Falha em uma verificação de asserção do sistema. Verifique o log de erros do SQL Server para obter detalhes. Em geral, uma falha de asserção é causada por bug do software ou danos nos dados. Para procurar danos no banco de dados, considere a execução de DBCC CHECKDB. Se você concordou em enviar despejos à Microsoft durante a instalação, um minidespejo será enviado. Uma atualização poderá ser disponibilizada pela Microsoft no último Service Pack ou em um Hotfix do Suporte Técnico.  Horário de conclusão: 2020-08-13T21:57:22.6904999-03:00 

Is in Portuguese, and telling me to check the SQL Server logs, which point me to this dump file [1] where it have the same message but in english:

 2020-08-13 19:07:27.81 spid54      Erro: 17066, Gravidade: 16, Estado: 1. 2020-08-13 19:07:27.81 spid54      SQL Server Assertion: File: <mediaWrite.cpp>, line=603 Failed Assertion = '(m_pWriteBuffer->GetCurrentSize ()% GetBlockSize ()) == 0'. This error may be timing-related. If the error persists after rerunning the statement, use DBCC CHECKDB to check the database for structural integrity, or restart the server to ensure in-memory data structures are not corrupted. 2020-08-13 19:07:27.81 spid54      Erro: 3624, Gravidade: 20, Estado: 1. 2020-08-13 19:07:27.81 spid54      A system assertion check has failed. Check the SQL Server error log for details. Typically, an assertion failure is caused by a software bug or data corruption. To check for database corruption, consider running DBCC CHECKDB. If you agreed to send dumps to Microsoft during setup, a mini dump will be sent to Microsoft. An update might be available from Microsoft in the latest Service Pack or in a Hotfix from Technical Support. 2020-08-13 19:07:27.81 Backup      Erro: 3041, Gravidade: 16, Estado: 1. 2020-08-13 19:07:27.81 Backup      BACKUP failed to complete the command BACKUP DATABASE DABOL12. Check the backup application log for detailed messages. 2020-08-13 19:13:11.98 spid54      **Dump thread - spid = 54, EC = 0x000000D63F84C160 2020-08-13 19:13:11.98 spid54      ***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\LOG\SQLDump0035.txt 

If I try to run this same command on the D:\ drive, it runs without any problems.

Details:

  1. After getting the errors a few times, I installed CU21, but the error persist.
  2. Both SQL Server and SQL Agent account have full control over E:\ drive. I went nuts and granted full control to everyone for the sake of testing.
  3. I was pretty sure that the databases weren’t corrupt, since I don’t get the same error when backuping to another drive and had just created them), but I run the DBCC CHECK anyway, and it’s everything ok.

Any thoughts?

[1] https://pastebin.com/0BhhMN6p

UPDATE 1

This VM is hosted on a XenServer, which I’m not a admin nor thus have any access. After finding out that I can successfully perform the backup to drives C: and D:, but could not perform to E:, I decided to check the devices.

Drive C: XENSRC PVDISK SCSI Disk Device
Drive D: XENSRC PVDISK SCSI Disk Device
Drive E: FreeNAS iSCSI Disk SCSI Disk Device

Searching a bit more a found this reddit post [2] with the same problem as I, shedding some light on the problem.

This is a SQL Server Bug, a Windows bug, a Xensrv bug or a FreeNAS bug?

[2] https://www.reddit.com/r/sysadmin/comments/2ofo4k/help_with_an_iscsi_issue/

Does a character automatically fail one death save when they drop below 0 hit points?

Hey guys so I have a question regarding death saves and if anyone knows an official source that can determine this.

So according to my dms interpretation of the RAW, if an attack brings you below zero hit points, it not only knocks you unconscious but also inflicts an automatic failed death save from that same attack.

And I to this point was under the idea that the attack that brings you below 0hp as long as it doesn’t also do your max health in damage after the fact then you are simply unconscious. And then all damage received after that inflicts auto fail saves (crits inflicting 2)

Is my interpretation or my dms interpretation correct and is there an official source or creator that has spoken on the matter?

Does the spell Rope Trick fail if the rope is longer than the height of the room?

The spell description for rope trick (PHB, pg. 272) states:

You touch a length of rope that is up to 60 feet long. One end of the rope then rises into the air until the whole rope hangs perpendicular to the ground.

What happens if I cast rope trick on a 60 foot rope in a 12 foot high room? The ceiling is not high enough for the whole rope to hang perpendicular to the ground; conceivably, it either stops rising when it hits the ceiling or it begins to pile up on the ceiling until 12 feet of it dangle to the floor. Either way, the rope does not satisfy the bolded condition in the spell description.

Does the spell fail? Do I need to cut down my rope to be less than the height of the room before casting the spell?

Purposefully fail select with no where

We have an evil query that reads every row from a table, but should not. To help the devs find the source of that query, I want to make SQL Server error out when any select against that table has no where clause.


An app is doing an evil select with no where. The select reads every row of a table having about 6,500 rows. The select is fast in SSMS (< 1 second), but when run by the app it’s slow (about 1/2 hour). We think that’s because the app is slowly iterating over the result set. It’s an active table for updates and inserts, so other queries may be blocked while this read takes place.

The developers can think of no reason that any app should read every row of that table. They suspect an oversight by a past developer.

The evil query-with-no-where is my top-runner, by far, for having the longest total duration in Query Store.

I know which app is issuing the evil query by using SQL Profiler to identify the app name, host name, and DB user name. The app’s developers have been unable to locate the source of the evil query. I want to help.

I want to cause any select against that table that has no WHERE clause (i.e. selects every row) to fail immediately. Our hope is that the app will log the errors, or possibly an end user that triggered the activity will report a 500 error to us, and this will give us another clue to find what code is issuing the evil query-with-no-where.

Our other selects against that table have specific where clauses and only return a subset of the table’s rows. Those selects must be allowed to continue.

After upgrade to SQL Server 2019 some stored procedures fail

We just upgraded from SQL Server 2008 R2 to SQL Server 2019(Compability lvl 150).

We have two different stored procedures that started failing after the upgrade, with error messages like this:

Msg 8632, Level 17, State 2, Procedure BuildSelfSaleStats, Line 14 [Batch Start Line 4] Internal error: An expression services limit has been reached. Please look for potentially complex expressions in your query, and try to simplify them. 

Whats really strange is that this particular stored procedure doesnt take any arguments, and when we simply execute the body of the SQL code in SSMS, it works fine(!?).

What might cause some SQL code that works fine when executed in SSMS, to suddenly start failing when its wrapped in a stored procedure?