Re: Bizarre query failure

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Fri, 13 Aug 1999 16:29:05 +0800
Message-ID: <37B3D751.3675@yahoo.com>

Tom Williamson wrote:
>
> Simple problem with no good explanation: I am trying to update the data in
> a table. The following SQL statements work:
>
> select * from cards;
> select * from cards where pc_batch > 1165;
> update cards set pc_batch = 1000 where pc_batch = 0;
> update cards set pc_batch = 0 where pc_batch = 1000;
> update cards set pc_batch = -1 where pc_batch = 0;
> update cards set pc_batch = 0 where pc_batch = -1;
>
> The following SQL statements hang and never return:
>
> update cards set pc_batch = -1 where pc_batch = 1180;
> update cards set pc_batch = 0 where pc_batch = 1180;
> update cards set pc_batch = 0 where pc_batch > 1165;
>
> If I run these in SQL Worksheet (on Windows NT), the client hangs completely
> and must be killed manually. If I run them in a telnet window, I can
> recover the session using Ctrl-C. The message I get is:
>
> ERROR at line 1:
> ORA-01013: user requested cancel of current operation
>
> I am running Oracle 8.0.5 on Solaris/Intel. I have already rebooted the
> machine and restarted the database. Our server installation was set up by
> an Oracle consultant, so I'm fairly sure it's correct.
>
> More importantly, how can I fix this?
>
> Thanks - Tom

Some possibilities:

1. Big cards table ? So it takes a long to update.
2. Someone else has locked the cards table so you're updates just sit and wait. In particular, if you aborted a SQL Worksheet, you may just have locked yourself.
3. Tiny logfiles - the update is going superslow because logfiles are too small - check alert log for "checkpoint not complete" messages...

Just some thoughts - HTH

--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Fri Aug 13 1999 - 03:29:05 CDT