Re: Error 458 - Long transaction aborted
Nope, running out of locks has nothing to do with the problem. Read on ...
"Alvan Rowland Jr." wrote:
> Try using the dbload utility. The database seems to be transaction logging and
> therefore you are running out of locks. dbload will allow you the flexibility to
> commit your records after a pre-determined amount.
>
> Michael Firschke wrote:
>
> > Hello Informix-experts,
> > we encountered a problem with long transactions in Informix.
> > So we tried to enlarge the filespace for Informix, but
> > with no effect. Is there any way out?
> > TIA, Michael
> >
> > BEGIN WORK;
> > LOCK TABLE n_ursprber IN EXCLUSIVE MODE;
> > LOCK TABLE n_ursprung IN EXCLUSIVE MODE;
> > LOCK TABLE r_n_urspr_std IN EXCLUSIVE MODE;
> > LOCK TABLE r_std_komb_ub IN EXCLUSIVE MODE;
> > UNLOAD TO "n_ursprber.V5403.unl" DELIMITER "|"
> > SELECT * FROM n_ursprber;
> > UNLOAD TO "n_ursprung.V5403.unl" DELIMITER "|"
> > SELECT * FROM n_ursprung;
> > UNLOAD TO "rn_ursprs.V5403.unl" DELIMITER "|"
> > SELECT * FROM r_n_urspr_std;
> > UNLOAD TO "rstd_kub.V5403.unl" DELIMITER "|"
> > SELECT * FROM r_std_komb_ub;
> > DELETE FROM r_n_urspr_std;
> > DELETE FROM r_std_komb_ub;
> > DELETE FROM n_ursprber;
> > DELETE FROM n_ursprung;
> > LOAD FROM "n_ursprber.sql" INSERT INTO n_ursprber;
> > LOAD FROM "n_ursprung.sql" INSERT INTO n_ursprung;> > ^
> > F>> 458: Long transaction aborted.
> >
> > onstat -d> >
> > INFORMIX-OnLine Version 7.24.UC5 -- On-Line -- Up 7 days 06:32:40 -- 74736
> > Kby
> > tes
> >
> > Dbspaces
> > address number flags fchunk nchunks flags owner name
> > 2193a100 1 2 1 1 M informix rootdbs
> > 2193afd0 2 2 2 1 M informix stammdbs
> > 2193b040 3 2 3 1 M informix statdbs
> > 2193b0b0 4 2 4 1 M informix pnpdbs
> > 2193b120 5 2001 5 3 N T informix tempdbs
> > 2193b190 6 12 6 1 M B informix blobdbs1
> > 2193b200 7 2 7 1 M informix scedbs
> > 2193b270 8 12 8 1 M B informix blobdbs2
> > 8 active, 2047 maximum
> >
> > Chunks
> > address chk/dbs offset size free bpages flags pathname
> > 2193a170 1 1 0 50000 36751 PO- /dev/rootdbs
> > 2193a248 1 1 0 50000 0 MO- /dev/mrootdbs
> > 2193a400 2 2 0 250000 239161 PO- /dev/stammdbs
> > 2193aac0 2 2 0 250000 0 MO- /dev/mstammdbs
> > 2193a4d8 3 3 0 250000 247371 PO- /dev/statdbs
> > 2193ab98 3 3 0 250000 0 MO- /dev/mstatdbs
> > 2193a5b0 4 4 0 25000 24662 PO- /dev/pnpdbs
> > 2193ac70 4 4 0 25000 0 MO- /dev/mpnpdbs
> > 2193a688 5 5 0 200000 199947 PO- /dev/tempdbs
> > 2193a760 6 6 0 100000 ~99603 100000 POB /dev/blobdbs1
> > 2193ad48 6 6 0 100000 0 MOB /dev/mblobdbs1
> > 2193a838 7 7 0 1000000 474669 PO- /dev/scedbs
> > 2193ae20 7 7 0 1000000 0 MO- /dev/mscedbs
> > 2193a910 8 8 0 1000000 ~994822 1000000 POB /dev/blobdbs2
> > 2193aef8 8 8 0 1000000 0 MOB /dev/mblobdbs2
> > 2193a9e8 9 5 0 250000 249997 PO- /dev/tempdbs1
> > 21e94830 10 5 0 250000 249997 PO- /dev/tempdbs2
> > 10 active, 2047 maximum
--
Richard C. Auslander
Database Manager
AirFlash, Inc.
1733 Woodside Rd., Suite #110
Redwood City, CA 94061
(650) 556-7928
www.airflash.com