Re: update statistics crashes database server

Posted in 1996

David Williams — Sun, 1 Dec 1996 18:05:42 +0000 — source: Informix-list mailing list archive (1991-1998)

In article <329F9C17.1BE9@netcomuk.co.uk>, Neil Truby <ntruby@netcomuk.co.uk> writes >Has anyone come across this one?: > >I ran an UPDATE STATISTICS medium against my database and the following >appeared in the log: > >Assert Failed: Internal Error - Arithmetic exception >Who:Session(413, informix@ubns04, 17720, 215707656) > Thread(62, sqlexec, cd97280, 1)>Results: OnLine must abort >Action: reininitalise shared memory >See Also: /tmp/af.3e6e50, shmem.blah blah blah >rsinit,c line 9196, thread 62 proc id 17099 Arith... >PANIC: Attempting to bring system down > >This happens whenever I run UPDATE STATISTICS medium on my database. >Also happens on another instance with a recent copy of this database. >UPDATE STATISTICS on its own is fine. oncheck shows no consistency>errors. > >I'm on OnLine 7.13 on solaris 2.4 > >Thanks >Neil Truby >Chase Bank, Bournemouth, UK First try dropping any existing distributions then try running update statistics medium on one table at a time... That should help to narrow down the problem... -- David Williams