Re: Informix upgrade 7.23 to 7.24 (second attempt, assert failures)

You are on the extreme edge of supportability. IDS 7.23 has not been supported for a number of years because it is not Y2K compliant. AFAIK, you can usually only get support for 7.24 if you're already a customer using it - new customers certainly cannot buy the software. Note that your recovery of 7.23 was fortunate - it was not guaranteed. You should be investigating upgrading your servers to 7.31or (better) 9.40 - but you do have to get up to 7.24 first. Your Base-64 or uuencoded attachments are not legible - I deleted them from this reply. That means it is hard to form an opinion on their contents. If you are using the identical ONCONFIG files on the 1GB and 2 GB servers and the configuration is big enough to push you over the limit for the 1 GB system, then you might have problems. What do I mean by 'the limit'? Fair question - fuzzy answer only. If you are using too many buffers, mainly, such that the total resource allocated to IDS overstresses everything else, then the more limited system might fail in ways that the less limited system does not. It shouldn't be happening. Did you run an extensive set of oncheck operations on the recovered 7.23 database before redoing the conversion? This would ensure that there were no hidden problems in the original system. How much more painful would it be to use dbexport/dbimport on this server? Are you sure there isn't a hidden hardware problem? I don't rate this as likely, but a failing CPU board or something similar might produce flakey results too. -- Jonathan Leffler (jleffler@us.ibm.com) STSM, Informix Database Engineering, IBM Data Management 4100 Bohannon Drive, Menlo Park, CA 94025 Tel: +1 650-926-6921 Tie-Line: 630-6921 "I don't suffer from insanity; I enjoy every minute of it!" |---------+----------------------------> | | "Olson, Kenn...."| | | <Kenneth.Olson@ge| | | .com> | | | Sent by: | | | forum.subscriber@| | | iiug.org | | | | | | | | | 12/05/2003 01:59 | | | PM | |---------+----------------------------> >------------------------------------------------------------------------------- --------------------------------------------------------------| | | | To: ids@iiug.org | | cc: | | Subject: Informix upgrade 7.23 to 7.24 (second attempt, assert failures) Need some help please [2304] | >------------------------------------------------------------------------------- --------------------------------------------------------------| Sun 2.6 Informix 7.23 A week or two ago I tried this upgrade a server without success. = Basically the same outcome this week, finishing with a restore back to = 7.23. Last night around 10pm I upgraded the server and everything seems to = upgrade fine. I have a user test as much as possible to ensure that = things are working. User's come in and start connecting to the database = the next morning. After awhile I get assert failures one after another. I have successfully upgraded around 8 other servers in test and = production prior to this one and the last one that I did is identical in = server, os version, database version, application. The only difference = in the last one I did and this one is the last one has 2gig of memory = where this one has 1gig. Memory does not seem to be an issue.=20 Server is showing no load when the asserts accurse. We are going to be upgrading our servers and os 2.6 to 8. I need to get = to at least 7.24 so that I can get to the latest Informix release and = os. I sure could use some help from you Informix gurus and sure would = appreciate it. We are on the cusp of signing a new Informix contract that is worth more = than the gross national product. If I can not resolve this issue a new = contract is going to do us no good. =20 Thanks!!!!! <<online.loga>> <<online.logb>> <<onconfig>> = <<online.log.120503-12>> <<af.cfa416>> <<af.d1a43b>> <<af.5f98591>> = <<af.9b18>> <<af.5cb8781>> <<af.1a4be43>> <<af.19c9b17>> = <<af.191bcea>> <<af.194bd25>> <<af.14eb9a3>> <<sqlhosts>>=20 [...base-64 encoded material deleted...]