Re: sysviews corrupted

June Tong wrote: > > Guy Germonpre (germonpre_guy/dis@bekaert.com) wrote: > : Art S. Kagel wrote: > : > > : > Guy Germonpre wrote: > : > > > : > > I have an Informix Online 4.10.UD2 on SCO 3.2v2.1. this thing worked for > : > > a LONG time, but now i get errors "ptalloc bad page ..", and my sysviews > : > > table is gone. > : > > I unloaded all data, did a tbinit -i, and reloaded everything. > : > > 2 days later the same problem. > : > > I switched the disk. > : > > 5 days later the same problem. > > : 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. > > Can he be more specific about what he was doing? Was he always doing the same > thing when he got the error? Can you get the error messages? > Yes. In sequelink he is executing a macro. The macro does a connect, a drop table "extraction", then a create temp table "extraction", and then a lot of selects. the macro is often executed, without problems, but it could be that the problems arise when the macro is executed many times without actualy leaving it. the error in the turbo.log is : bfcheck: bad page: pg_flags 0 != type 2, userp = 80402134, pid = 4482, uid = 0 09:59:42 buffer header: 09:59:42 804a1e08: 00000000 00000000 c4994980 c4994980 ........ ..I...I. 09:59:42 804a1e18: d4ab4a80 480a4b80 03000000 04070000 ..J.H.K. ........ 09:59:42 804a1e28: 8a001000 00804d80 00000000 00000000 ......M. ........ 09:59:42 804a1e38: 01000000 138a4b80 00010000 ......K. .... 09:59:42 page header: 09:59:42 804d8000: 8a001000 6dae2d00 00000000 1800e407 ....m.-. ........ 09:59:42 804d8010: 00000000 00000000 ........ 09:59:42 slot table and stamp: 09:59:42 804d87fc: 6dae2d00 m.-. 09:59:42 partition header error: 09:59:42 8045e754: 00000000 00000000 00000000 01000000 ........ ........ 09:59:42 8045e764: 7d000001 8a001000 00000000 00000000 }....... ........ 09:59:42 8045e774: 00000000 00000000 00000000 00000000 ........ ........ 09:59:42 8045e784: 00000000 00000000 00000000 00000000 ........ ........ 09:59:42 8045e794: 00000000 00000000 00000000 00000000 ........ ........ 09:59:42 8045e7a4: 00000000 00000000 00000000 00000000 ........ ........ 09:59:42 8045e7b4: 00000000 77000001 21000a00 2b000000 ....w... !...+... 09:59:42 8045e7c4: 01000100 1c772b34 01000000 08000000 .....w+4 ........ 09:59:42 8045e7d4: 08000000 08000000 03000000 01000000 ........ ........ 09:59:42 8045e7e4: 00000000 2b000000 01000000 00000000 ....+... ........ 09:59:42 8045e7f4: c97d1100 08000000 00000000 00000000 .}...... ........ 09:59:42 8045e804: 00000000 00000000 00000000 00000000 ........ ........ 09:59:42 8045e814: 00000000 00000000 00000000 00000000 ........ ........ 09:59:42 8045e824: 00000000 00000000 00000000 08000000 ........ ........ 09:59:42 8045e834: 00000000 00000000 00000000 00000000 ........ ........ 09:59:42 -- Fail Consistency Check -- pthdrpage:ptalloc:bad partn page -- pid=4482 user=0 us=80402134 Guy