RE: In the brown sticky stuff:-))

Nope a completely new installation, been live since March with the only hiccup being recursion loop in a piece of SPL took the engine down - our fault:-)) But the evidence script went into a continuous loop and took the server out !!! Now we just put a depth trap on all recursive SPL even if we are 100% sure we don't self loop :-)) Paul Watson # WF Software Ltd # If in doubt Tel: +44 1436 674729 # make it up Fax: +44 1436 678693 # www.wfsoftware.com # > -----Original Message----- > From: Art S. Kagel [mailto:kagel@bloomberg.net] > Sent: Thursday, October 12, 2000 7:42 PM > To: informix-list@iiug.org > Subject: Re: In the brown sticky stuff:-)) > > > Was the server upgraded from 7.3x? 'Cause it looks to me > like there were > in-place-alter rows which had not been updated to the newest > version before > the upgrade. IB this is specifically recommended against. > Informix always > says to force all tables which have been altered to complete with: > UPDATE tablename SET acol = acol;> before attempting to upgrade to a newer release. > > Art S. Kagel > > Paul Watson wrote: > > > > I've got table I can't read right through, the oncheck -cDI reports > > > > > > WARNING: index check requires a s-lock on tables whose lock level is > > page. > > > > Validating indexes for > > drug:viagra.order... > > > > WARNING: index check requires a s-lock on tables whose lock level is > > page. > > > > TBLspace data check for > > drug:viagra.order > > > > ERROR:Version 1 on page 72 (0x700947) is out of > > range > > ERROR:Version 1 on page 73 (0x700948) is out of > > range > > ERROR:Version 1 on page 74 (0x700949) is out of > > range > > ERROR:Version 1 on page 75 (0x70094a) is out of > > range > > ERROR:Version 1 on page 76 (0x70094b) is out of > > range > > ERROR:Version 1 on page 77 (0x70094c) is out of > > range > > ERROR:Version 1 on page 78 (0x70094d) is out of > > range > > ERROR:Version 1 on page 79 (0x70094e) is out of > > range > > ERROR:Version 1 on page 80 (0x70094f) is out of > > range > > > > and the log give me > > > > 21:31:27 Informix Dynamic Server 2000 Version > > 9.20.UC2 > > 21:31:27 Who: Session(98, informix@hobbit, 18721, > > 296254552) > > Thread(1271, xchg_3.0, 11a5dd58, > > 1) > > File: rssupp.c Line:> > 2658 > > 21:31:27 Results: altering older version row to latest version> > failed > > 21:31:27 stack trace for pid 281 written to > > /var/tmp/af.8dfce1f > > 21:31:27 See Also: > > /var/tmp/af.8dfce1f > > 21:31:43 Assert Failed: read_record: decompress_row, > source = 12797018,> > target > > = > > 12725018 > > 21:31:43 Informix Dynamic Server 2000 Version > > 9.20.UC2 > > 21:31:43 Who: Session(98, informix@hobbit, 18721, > > 296254552) > > Thread(1271, xchg_3.0, 11a5dd58, > > 1) > > File: rsread.c Line:> > 2507 > > 21:31:43 Results: Record not> > read > > 21:31:43 Action: Please notify Informix Technical > > Support. > > 21:31:43 stack trace for pid 281 written to > > /var/tmp/af.8dfce1f > > 21:31:43 See Also: > > /var/tmp/af.8dfce1f > > 21:32:06 read_record: invalid rowid = 4801, partnum => > 700068 > > > > ITS is shut, so the question is there anything I can do or > do I have to > > wait, > > I can't unload the table 'cos of the above > ********************************************************************** The contents of this e-mail are confidential to the ordinary user(S) of the mail address(es) to which it was sent and may be legally privileged. If you are not the intended recipient, any disclosure, copying, distribution or use of it, or any part of it, in any form whatsoever, and any actions taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. **********************************************************************