Re: sysviews corrupted

Art S. Kagel wrote: > > BALLENTINE.MIKE@heb.com wrote: > > copy /dev/zero over the offending chunk and then reinitialized, > > did the problem go away. However, if you replaced the disk(s) > > that the database uses, this is probably not the problem. > > > > Barring that, I would agree that it sounds like a hardware > > problem. > > Art S. Kagel wrote: > > > > > > Guy Germonpre wrote: > > > > > > > without executing normal shutdown? These are all possible causes of > > > corruption. Others include a controller or power supply that is going > > > bad and has become flaky. > > No we (my customer) does not use cooked files, the engine nor the > > machine itself was not shut down prior to the error, no crash, just > > suddenly a corrupted engine 3 or 4 times in a row. > > The customer told me he had the error while creating temporary tables > > via sequelink. There is anough disk space and database space so it is > > not caused by shortage of disk. > > > > Do you really think it can be caused by HARDWARE ? > > Sounds like it. Especially power supply. Have you recently added some > additional hardware? The power supply when it is going or is over > stressed will introduce spikes in the power and can corrupt data being > read or written by the controllers. I had this. There may not even be > any physical damage just flaky reads. If you have added hardware, > additional disks, a new CDROM, internal modem, etc. about the time that > the problem showed up I'd say that you need a more powerful power supply > otherwise try replacing that first anyway as the cheapest possible > culprit. If you've got a hardware tech available you can have > everything checked out. > > Art S. Kagel No there is nothing added. The machine is a black box doing everything it should but nothing more. Guy