Re: SQL Query hang
Anu_R wanted a SELECT-only session to hang and wondered about corrupting the database. Gorazd Hribar Rajteric said an earlier hang had turned out to be a corrupt index, but he did not know how to cause one deliberately. Obnoxio The Clown and Malc P joked about pulling the server's power. No real solution.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi, Thanks. I dont want to use any statement except for the SELECT in session2. I am aware that issuing a SET LOCK MODE in 2nd session will cause the SELECT to hang. But, I need to only use a SELECT statement. So, I was thinking if I can corrupt the database in some way, probably SELECT might hang. How about your ideas? Anu_R -- Posted via http://dbforums.com
More than a year ago we experienced such kind of trouble. Later we found out that index was corrupt, but I have no idea on how to do it on purpose. Gorazd "Anu_R" <member30973@dbforums.com> wrote in message news:3388891.1063940718@dbforums.com... > > Hi, > > > > Thanks. I dont want to use any statement except for the SELECT in > session2. I am aware that issuing a SET LOCK MODE in 2nd session will > cause the SELECT to hang. > > > > But, I need to only use a SELECT statement. > > > > So, I was thinking if I can corrupt the database in some way, probably > SELECT might hang. > > > > How about your ideas? > > > > Anu_R > > > -- > Posted via http://dbforums.com
Gorazd Hribar Rajteri' wrote: > More than a year ago we experienced such kind of trouble. Later we found > out that index was corrupt, but I have no idea on how to do it on purpose. Try running your disks on a separate power supply from the server, then pull the plug from the server. That ought to do it. :o) -- "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche
Obnoxio The Clown <obnoxio@hotmail.com> wrote in message news:<bked9f$o5bl$1@ID-64669.news.uni-berlin.de>... > Gorazd Hribar Rajteri' wrote: > > > More than a year ago we experienced such kind of trouble. Later we found > > out that index was corrupt, but I have no idea on how to do it on purpose. > > Try running your disks on a separate power supply from the server, then pull > the plug from the server. That ought to do it. :o) The voice of bitter experience, I surmise?
Malc P wrote: > Obnoxio The Clown <obnoxio@hotmail.com> wrote in message > news:<bked9f$o5bl$1@ID-64669.news.uni-berlin.de>... >> Gorazd Hribar Rajteri' wrote: >> >> > More than a year ago we experienced such kind of trouble. Later we >> > found out that index was corrupt, but I have no idea on how to do it on >> > purpose. >> >> Try running your disks on a separate power supply from the server, then >> pull the plug from the server. That ought to do it. :o) > > The voice of bitter experience, I surmise? Not my own, but it's probably quite a good way of rogering a system. -- "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche