csosnu@uta.fi (Ossi Numminen) (02/01/90)
We have a problem with Ingres (vers. 6.2) database procedures
in an ABF application in VAX/VMS environment (v. 5.2).
We have a database procedure that should make some updates
to a table. The designer noticed that she had forgotten
one attribute from the procedure and the respective assignment
statement (the attribute value to be updated) from the code.
She added the assignment statement but forgot to modify the
database procedure.
The program was compiled and executed and it went to a halt.
The killing of your own working process didn't help. The
II_DBMS server process took almost 100 % of the cpu time but
nothing happened, no I/O, nothing at all.
The only help was to boot the machine. The procedure was
corrected but it didn't help. The same has happened ever
since: program halts and nothing happens.
Does this description ring any bells to you? What might
be wrong?
Any suggestions are warmly welcome.
Ossi Numminen
(e-mail: csosnu@kielo.uta.fi)