Welcome to SQLA Beta

Question

1

While testing High Availability I want to simulate a failing primary server. Killing the process via task manager would work, but I just wanted a more elegant solution using plain SQL.

edited Dec 17 at 16:12

Zote
821●1●11

asked Dec 17 at 15:56

Reimer Pods
1,066●7

	IMO the BEST tests are (a) pulling the power cord and (b) pulling the network caple. The most FUN tests involve water hoses, firearms and so forth... but I never get to have any fun. – Breck Carter♦ Dec 18 at 19:37
	...network cable... – Breck Carter♦ Dec 18 at 19:38
	... I was thinking about a wood-chopper's axe, but that wasn't in the budget (neither a new server) – Reimer Pods Dec 22 at 9:59
	some of us were around back when Novell dramatically demonstrated their high availability server at a trade show... with 20 workstations scrolling data from the server, the salesman used an axe to chop the rope suspending a HUGE blacksmith's anvil over one server. There was crash, bang, smoke and fire. And the workstations breifly paused while failing over, then resumed full speed scrolling. Pretty hard to top that demo! – Bill Feb 3 at 16:26

Bruce Hay · Answer 1 · 2009-12-21 17:16:43Z UTC

To terminate a server using a SQL statement, you might use xp_cmdshell() together with a command that kills a process (e.g. taskkill on Windows).

The issue that caused the crash with the above CREATE VIEW statement will be fixed in build 11.0.1.2367.

Reimer Pods · Answer 2 · 2009-12-17 16:00:03Z UTC

2

Just submit

create view ConnectionInfo as select Number as ConnNr, Name, Userid, DBNumber, LastReqTime, ReqType, CommLink, NodeAddr,LastIdle, BlockedOn, LockName, UncmtOps, (select value from sa_conn_properties(ConnNr) where PropName= 'PrepStmt' ) PrepStmt, (select convert(integer,isnull(value,0)) from sa_conn_properties(ConnNr) where PropName= 'CursorOpen' ) CursorOpen from sa_conn_info()

This will crash the server instantly (until the bug will be fixed). I'm using 11.0.1.2352.

answered Dec 17 at 16:00

Reimer Pods
1,066●7

	If you might come to the conclusion that I didn't ask a "real" question, but wanted to report a bug in a more subtle way, you're probably right :). – Reimer Pods Dec 17 at 16:30
	I'm intested how you are going to keep the answer valid (i.e. for newer builds) if this particular bug will get fixed:) – Volker Barth Dec 17 at 17:55
	+1 Crashed here too. – Zote Dec 17 at 19:44
	@Volker: this is the third time I encountered a statement that could regularily crash the engine. If this one is fixed, I'm hoping to come up with a new one (well, in fact rather fearing than hoping ...) – Reimer Pods Dec 18 at 11:16

How to crash a SA11 engine with a simple SQL statement

2 Answers