Hi:

Thanks for information. Any ideas on this?

Same table:

ALLZIP with fields:

CITY VARCHAR(50)
STATE CHAR(2)
ZIP CHAR(6)

I want to change CITY to varchar(30).

1. Create new field UCITY VARCHAR(30). Ok

2. UPDATE ALLZIP
SET UCITY = CITY Ok

Commit

3. UPDATE ALLZIP
DROP CITY Ok

4. ALTER TABLE ALLZIP
ADD CITY VARCHAR(30) Ok

5. UPDATE ALLZIP
SET CITY = UCITY Horror!!!!!!!!!!!!!!!

I have restored from backup and tried this TEN times and it fails every time. Right
now, my cursor is jerking across screen because IBServer is using 99% cpu and has been
doing so on the simple update in step 5.

What is worse is you can't stop it. I open server manager and click Stop, it changes
to Start and task manager still shows IBServer at 99% and you can't stop it in task
manager: "access denied". After two tries doing something with IBConsole, that quits
responding until you restart machine. I have also run chkdsk twice thinking maybe it
was file corruption.

So, something is really hosed up here. I will reinstall 332 and if it happens again,
I will reinstall an earlier version and test it.

I cannot believe that you can get into a screwed up situation like this doing a
simple thing like I was doing and IBConsole/IBServer provides no graceful exit.

Any insight appreciated.


Best regards