AW: sql causes server crash

Do you mix several instances like I tried to do. There is no problem if I access only one instance. > Saltan wrote > Habichtsberg, Reinhard wrote: > > > > The sql crashes the server even if I replace "round > > (sum(cumtime/1000000),0)" with "1". I'm nearly sure the > crash is associated > > with the access from the server instance where the data > should be inserted > > to the sysmaster (in other words: shared memory) on the > other instance. > > > > Reinhard. > > I do select from sysmaster and insert into my database for 3 years > every night. > I never used 9.40xC4, but it works fine for C1, C5, C6 and C7. > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >

Now I do select from 9.40.FC7 and 9.40.UC7 and insert into 10.00.UC4. Because of 3 years of use I did insert into 9.40, 9.30 and select from 9.40, 9.30. Versions of servers are changed asynchronously. Never think about version difference, never have problem with it. Habichtsberg, Reinhard wrote: > Do you mix several instances like I tried to do. There is no problem if I > access only one instance. > > > Saltan wrote > > Habichtsberg, Reinhard wrote: > > > > > > The sql crashes the server even if I replace "round > > > (sum(cumtime/1000000),0)" with "1". I'm nearly sure the > > crash is associated > > > with the access from the server instance where the data > > should be inserted > > > to the sysmaster (in other words: shared memory) on the > > other instance. > > > > > > Reinhard. > > > > I do select from sysmaster and insert into my database for 3 years > > every night. > > I never used 9.40xC4, but it works fine for C1, C5, C6 and C7. > > > > _______________________________________________ > > Informix-list mailing list > > Informix-list@iiug.org > > http://www.iiug.org/mailman/listinfo/informix-list > >