IPLOAD KABOUM
Posted in 1996
Topics: Error Codes & Troubleshooting
Hi, here is a nice bug I have discovered this afternoon :
We use Online DSA 7.20.UC2 on an 3CPU HP9000 K200...
TEST CASE:
create table junk( field integer )
fragment by expression
(mod(field,2)=0) in dbs1,
(mod(field,2)=0) in dbs2;
Obviously, the creation script is incomplete/stupid/insane, BUT...Online doest
not refuse to create this table with such a fragmentation scheme ;-)
Now, just create a file named junk.unl :
1|
2|
3|
4|
et caetera...
And now, create an ipload project to fill the table junk with the data
from junk.unl.
At least, LOAD this table (execute the load job).
KA-BOUM !
online.log:
ploadbe.c, line 2209, thread 64, proc id 679, Pload client premature exit,
unable to cleanup.
PANIC: Attempting to bring system down
I didn't call Informix Tech Support, because I didn't want to be ridiculous
(the fragmentation...).
IMHO, ipload should complain about it and abort the job (with dbload, you
have no problem, but it's sloooow).
Valery Fouques GOSPORT/FRANCE
valou@hotmail.com
_ __/|
\\`O.o' "For every problem there is a solution which
=(_ _)= is simple, clean and wrong"
U