Re: sql causes server crash

Posted in 2006

Topics: Installation, Setup & Upgrades, Stored Procedures & SPL

Habichtsberg, Reinhard — Tue, 16 May 2006 11:55:33 +0200 — source: Usenet: comp.databases.informix

Ben: If the query is run against _one_ server no error occures. Actually I have a cron job for this. My intention is to collect statistical data from two or more instances in one database on one instance. The problem raises if I mix two server instances: Query sysmaster of the first and write the result to the second server. Reinhard > [mailto:informix-list-bounces@iiug.org]Im Auftrag von Ben Thompson > Gesendet am: Dienstag, 16. Mai 2006 11:29 > Habichtsberg, Reinhard wrote: > > > select "$INFORMIXSERVER", current zeitpunkt, round > > (sum(cumtime/1000000),0) , reason > > > Running the query causes a reproducible crash of the server > > (dbtest2). > > I believe you have encountered a bug I have seen this bug on > our systems > and it's not very nice. It has nothing to do with running a query > against the sysmaster database. It seems to occur when you > have a number > of mathematical functions grouped together in one statement > like above. > You may be able to work around it by splitting your mathematical > statements up into smaller pieces in multiple statements. I am pretty > sure it's fixed in 9.40.UC7 and above (9.40.UC8 latest), it's > definitely > still a bug in 9.40.UC5. I've never experienced it in any v10 > release. I > recommend you upgrade. > > Ben. > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >

↪ replying to Habichtsberg, Reinhard

Ben Thompson — Tue, 16 May 2006 11:17:43 +0100 — source: Usenet: comp.databases.informix

Habichtsberg, Reinhard wrote: > Ben: > > If the query is run against _one_ server no error occures. Actually I have a > cron job for this. My intention is to collect statistical data from two or > more instances in one database on one instance. > > The problem raises if I mix two server instances: Query sysmaster of the > first and write the result to the second server. In which case it sounds like you may not suffering from the same bug. Even so, have you tried running a similar query without "round (sum(cumtime/1000000),0)", perhaps just: select "$INFORMIXSERVER", current zeitpunkt, 1, reason .... Does this crash the server when you insert the results into the second instance? If this makes no difference then it's a different problem I haven't come across before. Ben.