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. asked 17 Dec '09, 15:56 Reimer Pods Zote |
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. answered 21 Dec '09, 17:16 Bruce Hay |
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 17 Dec '09, 16:00 Reimer Pods Graeme Perrow 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 :). I'm intested how you are going to keep the answer valid (i.e. for newer builds) if this particular bug will get fixed:) +1 Crashed here too. @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 ...) |
OS: Ubuntu10.4 AMD64 / Debian5 AMD64; SQL Anywhere: SA11.0.1.2645 64bit for shut down server, run query in java isql: select * from test_table where id=1; select * from test_table where id=2; select * from test_table where id=1 select * from test_table where id=2 ps: case id 11695638 answered 05 Nov '11, 13:50 Marsel Is the semicolon deliberately omitted in the 3rd row? That might turn this into a Transact-SQL statement batch (i.e. it will return 2 result sets) - though a crash then would surely look like a bug...
(05 Nov '11, 19:02)
Volker Barth
|
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.
...network cable...
... I was thinking about a wood-chopper's axe, but that wasn't in the budget (neither a new server)
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!