Just an idea Martin but what if you add Commit; in between the statements in
the script?

Does the table have before or afterupdate triggers?



Franky



From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Martin Dew
Sent: dinsdag 4 juli 2006 18:14
To: firebird-support@yahoogroups.com
Subject: [firebird-support] [firebird-support Problematic Upgrade Script -
any solution



Hi,

I needed to add more space into an already present varchar field.

alter table patient_triage_cons

add tmpACTIONTYPE VARCHAR(10),

add tmpACTIONNOTES VARCHAR(8192)

---

update patient_triage_cons set tmpACTIONTYPE = ACTION_TYPE,
tmpACTIONNOTES = ACTION_NOTES

---

alter table patient_triage_cons

drop ACTION_TYPE,

drop ACTION_NOTES

---

alter table patient_triage_cons

add ACTION_TYPE VARCHAR(10),

add ACTION_NOTES VARCHAR(8192)

---

update patient_triage_cons set ACTION_TYPE = tmpACTIONTYPE, ACTION_NOTES
= tmpACTIONNOTES

The above red line (or last line of script if this message does not show
in colour ) is where it fails. The memory usage just keeps going up by
small chunks continuously, but the cpu is hardly being touched. We have
cycled the machine, done a backup and restore but the problem still
occurs. The same script has been run at numerous other sites without a
problem. What I do not understand is that it really is just a
replication of the second statement in the script, and that always works
at this site.

Is there a way in Firebird 1.5.2 to alter the field size without doing
all the copying of data into temporary fields ?

T.I.A

Martin

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]