Oninit cdi / Archive
Talk to an expert →

Re: Sanity test on parition page failed...

Posted in 2007

Topics: Backup & Restore, Storage & Space Management, Platform-Specific Issues

david@smooth1.co.uk — — source: Usenet: comp.databases.informix

On 9 Feb, 08:56, Sergey Babitch <vinny+fi...@babitch.com> wrote: > I do: > > onbar -b -w > onbar -b -w -L 1 > onbar -b -w -L 2 > onbar -v -w> > In file /tmp/ac_msg.log I have: > > 02/08/2007 14:40:07 > ----------------------------------------- > STATUS: IBM Informix Dynamic Server Version 9.40.UC4 > Program Name: archecker > Version: 4.7 > Released: 03/24/04 01:02 > Compiled: 03/24/04 01:03 on Linux 2.4.7-10 #1 Thu Sep 6 17:27:27 EDT 2001 > > STATUS: AC_STORAGE /tmp > STATUS: AC_MSGPATH /tmp/ac_msg.log > STATUS: AC_TIMEOUT 300 > STATUS: AC_VERBOSE on > TIME: [02/08/2007 14:40:07] Data transfer opened. > STATUS: starting to scan dbspace 1 created on 02/08/2007 14:14:24. > STATUS: Archive timestamp 0X5C85A27E. > STATUS: starting to scan dbspace 10 created on 02/08/2007 14:14:24. > STATUS: Archive timestamp 0X5C85A27E. > STATUS: starting to scan dbspace 9 created on 02/08/2007 14:14:24. > STATUS: Archive timestamp 0X5C85A27E. > STATUS: starting to scan dbspace 5 created on 02/08/2007 14:14:24. > STATUS: Archive timestamp 0X5C85A27E. > ERROR: Parition 0X00000012 has incorrect number of pages ->used 330 < total 0. > ERROR: Sanity test on parition page failed 5:18. > ERROR: Parition 0X00000014 has incorrect number of pages ->used 334 < total 330. > ERROR: Sanity test on parition page failed 5:20. > ERROR: Parition 0X0001B543 has incorrect number of pages ->used 4 < total 0. > ERROR: Sanity test on parition page failed 5:111939. > ERROR: Parition 0X0001B544 has incorrect number of pages ->used 73 < total 69. > ERROR: Sanity test on parition page failed 5:111940. > > How can I fix this errors? > > -- > Good Luck! Sergey Babitch (SB551-RIPE) ICQ: 105517491 FreeLance Artist Run "select tabname, hex(partnum) from systables" for all databases on the server. Once you find the table that has that Partition Number then run "oncheck -cID database:table".

↪ replying to david@smooth1.co.uk
Sergey Babitch — — source: Usenet: comp.databases.informix

Hi, david! On Sat, Feb 10, 2007 at 09:11:40PM -0800, david@smooth1.co.uk wrote: > On 9 Feb, 08:56, Sergey Babitch <vinny+fi...@babitch.com> wrote: > > I do: > > > > onbar -b -w > > onbar -b -w -L 1 > > onbar -b -w -L 2 > > onbar -v -w> > > > In file /tmp/ac_msg.log I have: > > > > 02/08/2007 14:40:07 > > ----------------------------------------- > > STATUS: IBM Informix Dynamic Server Version 9.40.UC4 > > Program Name: archecker > > Version: 4.7 > > Released: 03/24/04 01:02 > > Compiled: 03/24/04 01:03 on Linux 2.4.7-10 #1 Thu Sep 6 17:27:27 EDT 2001 > > > > STATUS: AC_STORAGE /tmp > > STATUS: AC_MSGPATH /tmp/ac_msg.log > > STATUS: AC_TIMEOUT 300 > > STATUS: AC_VERBOSE on > > TIME: [02/08/2007 14:40:07] Data transfer opened. > > STATUS: starting to scan dbspace 1 created on 02/08/2007 14:14:24. > > STATUS: Archive timestamp 0X5C85A27E. > > STATUS: starting to scan dbspace 10 created on 02/08/2007 14:14:24. > > STATUS: Archive timestamp 0X5C85A27E. > > STATUS: starting to scan dbspace 9 created on 02/08/2007 14:14:24. > > STATUS: Archive timestamp 0X5C85A27E. > > STATUS: starting to scan dbspace 5 created on 02/08/2007 14:14:24. > > STATUS: Archive timestamp 0X5C85A27E. > > ERROR: Parition 0X00000012 has incorrect number of pages ->used 330 < total 0. > > ERROR: Sanity test on parition page failed 5:18. > > ERROR: Parition 0X00000014 has incorrect number of pages ->used 334 < total 330. > > ERROR: Sanity test on parition page failed 5:20. > > ERROR: Parition 0X0001B543 has incorrect number of pages ->used 4 < total 0. > > ERROR: Sanity test on parition page failed 5:111939. > > ERROR: Parition 0X0001B544 has incorrect number of pages ->used 73 < total 69. > > ERROR: Sanity test on parition page failed 5:111940. > > > > How can I fix this errors? > > > > -- > > Good Luck! Sergey Babitch (SB551-RIPE) ICQ: 105517491 FreeLance Artist > > Run "select tabname, hex(partnum) from systables" for all databases > on the server. > Once you find the table that has that Partition Number then run > "oncheck -cID database:table". informix@sunny:~> echo 'SELECT tabname, HEX (partnum) FROM systables WHERE HEX (partnum) = "0x00000014"' | dbaccess sysmaster Database selected. tabname sysptntab (expression) 0x00000014 1 row(s) retrieved. Database closed. informix@sunny:~> oncheck -cID sysmaster:sysptntab This operation is not permitted on an SMI pseudo table informix@sunny:~> -- Good Luck! Sergey Babitch (SB551-RIPE) ICQ: 105517491 FreeLance Artist

↪ replying to Sergey Babitch
TBP — — source: Usenet: comp.databases.informix

Sergey Babitch wrote: > Hi, david! > > On Sat, Feb 10, 2007 at 09:11:40PM -0800, david@smooth1.co.uk wrote: > >> On 9 Feb, 08:56, Sergey Babitch <vinny+fi...@babitch.com> wrote: >>> I do: >>> >>> onbar -b -w >>> onbar -b -w -L 1 >>> onbar -b -w -L 2 >>> onbar -v -w>>> >>> In file /tmp/ac_msg.log I have: >>> >>> 02/08/2007 14:40:07 >>> ----------------------------------------- >>> STATUS: IBM Informix Dynamic Server Version 9.40.UC4 >>> Program Name: archecker >>> Version: 4.7 >>> Released: 03/24/04 01:02 >>> Compiled: 03/24/04 01:03 on Linux 2.4.7-10 #1 Thu Sep 6 17:27:27 EDT 2001 >>> >>> STATUS: AC_STORAGE /tmp >>> STATUS: AC_MSGPATH /tmp/ac_msg.log >>> STATUS: AC_TIMEOUT 300 >>> STATUS: AC_VERBOSE on >>> TIME: [02/08/2007 14:40:07] Data transfer opened. >>> STATUS: starting to scan dbspace 1 created on 02/08/2007 14:14:24. >>> STATUS: Archive timestamp 0X5C85A27E. >>> STATUS: starting to scan dbspace 10 created on 02/08/2007 14:14:24. >>> STATUS: Archive timestamp 0X5C85A27E. >>> STATUS: starting to scan dbspace 9 created on 02/08/2007 14:14:24. >>> STATUS: Archive timestamp 0X5C85A27E. >>> STATUS: starting to scan dbspace 5 created on 02/08/2007 14:14:24. >>> STATUS: Archive timestamp 0X5C85A27E. >>> ERROR: Parition 0X00000012 has incorrect number of pages ->used 330 < total 0. >>> ERROR: Sanity test on parition page failed 5:18. >>> ERROR: Parition 0X00000014 has incorrect number of pages ->used 334 < total 330. >>> ERROR: Sanity test on parition page failed 5:20. >>> ERROR: Parition 0X0001B543 has incorrect number of pages ->used 4 < total 0. >>> ERROR: Sanity test on parition page failed 5:111939. >>> ERROR: Parition 0X0001B544 has incorrect number of pages ->used 73 < total 69. >>> ERROR: Sanity test on parition page failed 5:111940. >>> >>> How can I fix this errors? >>> >>> -- >>> Good Luck! Sergey Babitch (SB551-RIPE) ICQ: 105517491 FreeLance Artist >> Run "select tabname, hex(partnum) from systables" for all databases >> on the server. >> Once you find the table that has that Partition Number then run >> "oncheck -cID database:table". > > informix@sunny:~> echo 'SELECT tabname, HEX (partnum) FROM systables WHERE HEX (partnum) = "0x00000014"' | dbaccess sysmaster > > Database selected. > > > > > tabname sysptntab > (expression) 0x00000014 > > 1 row(s) retrieved. > > > > Database closed. > > informix@sunny:~> oncheck -cID sysmaster:sysptntab > This operation is not permitted on an SMI pseudo table > informix@sunny:~> > Does it really say ERROR: *Parition* 0X00000014 has incorrect number of pages ->used 334 < total 330. "Parition"!!??!!

↪ replying to TBP
Sergey Babitch — — source: Usenet: comp.databases.informix

Hi, TBP! On Sun, Feb 11, 2007 at 11:32:21AM +0000, TBP wrote: [Skipped by Sergey Babitch] > Does it really say > > ERROR: *Parition* 0X00000014 has incorrect number of pages ->used 334 < > total 330. > > "Parition"!!??!! Yes! "Parition"!!!! Without 't' between 'r' and 'i'. And: ERROR: Sanity test on parition page failed 3:554620. ERROR: dbspace 0 is not open for parition 0X00087688. Also without 't' between 'r' and 'i'. I know - it is error. But it is say in my /tmp/ac_msg.log :( Also, if I say: echo 'CREATE DATABASE mydatabase IN mydbspace;' | dbaccess - echo 'CREATE SEQUENCE mysequence;' | dbaccess mydatabase echo 'DROP DATABASE mydatabase;' | dbaccess - It result: Object mydatabase:mysequence stay in mydbspace, although mydatabase not exists. It is lost object. And if I want drop mydbspace, onspace say "mydbspace not empty". And I don't know how drop this dbspace :( -- Good Luck! Sergey Babitch (SB551-RIPE) ICQ: 105517491 FreeLance Artist

Related threads

Glossary