Re: deadlock detection/resolving

What is WURST?

According to www.acronymfinder.com it is

WURST
Wideband, Uniform Rate, and Smooth Truncation (NMR spectroscopy)

Martin

RSH wrote:
>
> Might I add,
>
> it isn't really nice to yell at people who are only trying to explain things
> and help you, wherever you make your WURST? I don't know the equivalent
> expression in German, but in English, we call that "Biting the hand that
> feeds you.".
>
> RSH
>
> "Rüdiger J. Schulz" <johannes.schulz_at_web.de> wrote in message
> news:3cc03614$1_at_netnews.web.de...
> > - there are only two connections
> > (started with benthic-software "golden")
> > t1:
> > update artikel set bezeichnung = 'WURST'
> > where artnr = 127493;
> > t2:
> > update artikel set bezeichnung = 'WURST'
> > where artnr = 127494;
> > t1:
> > update artikel set bezeichnung = 'KÄSE'
> > where artnr = 127494;
> > t2:
> > update artikel set bezeichnung = 'KÄSE'
> > where artnr = 127493;
> >
> >
> > --> look at the artnr !!
> >
> >
> > now there's a deadlock! all that I want is that oracle
> > resolves it automatic...
> >
> >
> > "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
> > >
> > >It did resolve it automatically. It found the deadlock within
> > >three seconds, rolled back one of the transaction AT THE
> > >STATEMENT LEVEL (which is the only safe rollback it
> > >could do) and sent the transaction an error message that #
> > >it had caused a deadlock so that the calling program would
> > >know it had to take appropriate action.
> > >
> > >Since the appropriate action is ENTIRELY dependent on
> > >the prior activity of the calling program, it would be dangerous
> > >for any further action on the part of the database.
> > >
> > >Put the question another way - what more would you
> > >want it to do ? (And would this make sense in the
> > >general case, rather than your particular situation ?)
> > >
> > >
> > >--
> > >Jonathan Lewis
> > >http://www.jlcomp.demon.co.uk
> > >
> > >Author of:
> > >Practical Oracle 8i: Building Efficient Databases
> > >
> > >Next Seminar - Australia - July/August
> > >http://www.jlcomp.demon.co.uk/seminar.html
> > >
> > >Host to The Co-Operative Oracle Users' FAQ
> > >http://www.jlcomp.demon.co.uk/faq/ind_faq.html
> > >
> > >
> > >
> > >Rüdiger J. Schulz wrote in message <3cc02889_at_netnews.web.de>...
> > >>hi all,
> > >>
> > >>
> > >>my oracle-server (8.1.7 on openunix 8/lkp) detects a dealock
> > >>(ora-000060 in the alert.log / and the trace-file).
> > >>the situation: two statements are trying an UPDATE on two rows.
> > >>
> > >>
> > >>but the oracle-server don't resolve it automatic!
> > >>
> > >>
> > >>why?
> > >>
> > >
> > >
> > >
> >
> > --
> > __________________________________________________________
> > News suchen, lesen, schreiben mit http://newsgroups.web.de
Received on Tue Apr 30 2002 - 07:23:44 CDT