Error in TLR with Archecker
Vikas tried an archecker table-level restore on IDS 11.10.FC3 (Solaris) and hit "CONNECT failed / -27000". Art Kagel and Andreas Breitfeld identified the cause: INFORMIXSERVER pointed to a shared-memory connection, which can't support the multiple connections archecker needs; switching to a TCP (or stream-pipe) server name got past it. The restore then failed with "Invalid chunk number" errors and a Bus Error from an ontape level-0 backup made to a directory with BACKUP_FILTER gzip. Suggestions were to check AC_TAPEDEV vs AC_IXBAR, use -t for ontape archives, match the restore filter, try another archive, and open a PMR (a known 11.10 problem with compressed/piped archives was mentioned). No resolution to that second problem is recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi,
IDS 11.10.FC3 on solaris 10
I'm testing a table level restore using archecker and getting the following
error.
STATUS: IBM Informix Dynamic Server Version 11.10.FC3
Program Name: archecker
Version: 8.0
Released: 2008-12-09 01:42:51
CSDK: IBM Informix CSDK Version 3.00
ESQL: IBM Informix-ESQL Version 3.00.FC3
Compiled: 12/09/08 01:43 on SunOS 5.9 Generic_122300-31
STATUS: Arguments [-t -s -f /export/home/informix/vikas/ac_schema.sql -lphys]
STATUS: AC_STORAGE /tmp
STATUS: AC_MSGPATH /tmp/ac_msg.log
STATUS: AC_VERBOSE on
STATUS: AC_TAPEDEV /dev/testdb_2_L0
STATUS: AC_TAPEBLOCK 32 KB
STATUS: AC_LTAPEDEV /dev/null
STATUS: AC_LTAPEBLOCK 32 KB
STATUS: AC_RESTORE_FILTER /bin/gunzip
STATUS: AC_SCHEMA /export/home/informix/vikas/ac_schema.sql
STATUS: CLIENT_LOCALE not set, assuming [en_us.819]
ERROR: "CONNECT" failed
ERROR: -27000: (rgetlmsg() returned -1227)
ERROR: Unable to make a connection for test.vikas
CRITICAL ERROR: Connection to the database 'test@lt2_shm' has failed (SQLCODE:
-27000).
STATUS: Restore disabled for test:emp into test:vikas
CRITICAL ERROR: Unable to continue -- no tables to restore.
STATUS: archecker completed Physical Restore pid = 18354 exit code: 3
testdb_2_L0 is yesterdays level 0 file created by ontape, which has the emp
tble.
I have droped the emp table just now before starting the archecker test.
I'm able to connect to test database using dbaccess and also from other
servers.
The ac_schema.sql looks like:
database test;
create table emp
(
c1 integer,
c2 char(10)
);
create table vikas
(
c1 integer,
c2 char(10)
);
insert into vikas
select * from emp;
trying to get some clue from finderr for 27000 but
I'm missing some thing simple, Pls if any one could guide.
Regards
Vikas.
Did you use tcp connection to the server?
Andreas
On Thursday 15 January 2009 11:40:47 VIKAS HIVARKAR wrote:
> Hi,
>
> IDS 11.10.FC3 on solaris 10
>
> I'm testing a table level restore using archecker and getting the following
> error.
>
> STATUS: IBM Informix Dynamic Server Version 11.10.FC3
> Program Name: archecker
> Version: 8.0
> Released: 2008-12-09 01:42:51
> CSDK: IBM Informix CSDK Version 3.00
> ESQL: IBM Informix-ESQL Version 3.00.FC3
> Compiled: 12/09/08 01:43 on SunOS 5.9 Generic_122300-31
>
> STATUS: Arguments [-t -s -f /export/home/informix/vikas/ac_schema.sql
> -lphys] STATUS: AC_STORAGE /tmp
> STATUS: AC_MSGPATH /tmp/ac_msg.log
> STATUS: AC_VERBOSE on
> STATUS: AC_TAPEDEV /dev/testdb_2_L0
> STATUS: AC_TAPEBLOCK 32 KB
> STATUS: AC_LTAPEDEV /dev/null
> STATUS: AC_LTAPEBLOCK 32 KB
> STATUS: AC_RESTORE_FILTER /bin/gunzip
> STATUS: AC_SCHEMA /export/home/informix/vikas/ac_schema.sql
> STATUS: CLIENT_LOCALE not set, assuming [en_us.819]
> ERROR: "CONNECT" failed
> ERROR: -27000: (rgetlmsg() returned -1227)
> ERROR: Unable to make a connection for test.vikas
> CRITICAL ERROR: Connection to the database 'test@lt2_shm' has failed
> (SQLCODE: -27000).
> STATUS: Restore disabled for test:emp into test:vikas
> CRITICAL ERROR: Unable to continue -- no tables to restore.
> STATUS: archecker completed Physical Restore pid = 18354 exit code: 3
>
> testdb_2_L0 is yesterdays level 0 file created by ontape, which has the emp
> tble.
> I have droped the emp table just now before starting the archecker test.
>
> I'm able to connect to test database using dbaccess and also from other
> servers.
>
> The ac_schema.sql looks like:
> database test;>
> create table emp
> (
> c1 integer,
> c2 char(10)
> );>
> create table vikas
> (
> c1 integer,
> c2 char(10)
> );>
> insert into vikas
> select * from emp;>
> trying to get some clue from finderr for 27000 but
> I'm missing some thing simple, Pls if any one could guide.
>
> Regards
> Vikas.
>
>
> ***************************************************************************
>**** Forum Note: Use "Reply" to post a response in the discussion forum.
--
Andreas Breitfeld; Informix Development Munich
IBM Deutschland Research & Development GmbH; Vorsitzender des Aufsichtsrats:
Martin Jetter; Geschaeftsfuehrung: Erich Baier; Sitz der Gesellschaft:
Boeblingen; Registergericht: Amtsgericht Stuttgart, HRB 243294
Thanks for the help Andreas,
I've changed the INFORMIXSERVER to lt2 in order to use the tcp connection and
the restore started BUT failed with errors
STATUS: CLIENT_LOCALE not set, assuming [en_us.819]
STATUS: Temporary workspace has been set
STATUS: Extracting table test:emp into test:vikas
WARNING: Source table [emp] has no storage option
WARNING: No storage space to scan
STATUS: Tape type: Archive Backup Tape
STATUS: OnLine version: IBM Informix Dynamic Server Version 11.10.FC3
STATUS: Archive date: Sun Jan 11 22:00:01 2009
STATUS: Archive level: 0
STATUS: Tape blocksize: 32768
STATUS: Tape size: 2147483647
STATUS: Tape number in series: 1
TIME: [2009-01-15 12:35:54] Phys Tape 1 started
ERROR: Invalid chunk number 4795
ERROR: Invalid chunk number 14656
ERROR: Invalid chunk number 7912
....
I've even tried adding "set workspace to datadbs2" at the end of ac_schema.sql
file.
I'm sure that the emp table was created in datadbs2 as the test database is on
datadbs2 dbspace and i created the emp table with "create table emp --- sql
statement with out any in dbspace option.
what am i missing here?
Vikas.
--------------------------
Did you use tcp connection to the server?
Andreas
On Thursday 15 January 2009 11:40:47 VIKAS HIVARKAR wrote:
> Hi,
>
> IDS 11.10.FC3 on solaris 10
>
> I'm testing a table level restore using archecker and getting the following
> error.
>
> STATUS: IBM Informix Dynamic Server Version 11.10.FC3
> Program Name: archecker
> Version: 8.0
> Released: 2008-12-09 01:42:51
> CSDK: IBM Informix CSDK Version 3.00
> ESQL: IBM Informix-ESQL Version 3.00.FC3
> Compiled: 12/09/08 01:43 on SunOS 5.9 Generic_122300-31
>
> STATUS: Arguments [-t -s -f /export/home/informix/vikas/ac_schema.sql
> -lphys] STATUS: AC_STORAGE /tmp
> STATUS: AC_MSGPATH /tmp/ac_msg.log
> STATUS: AC_VERBOSE on
> STATUS: AC_TAPEDEV /dev/testdb_2_L0
> STATUS: AC_TAPEBLOCK 32 KB
> STATUS: AC_LTAPEDEV /dev/null
> STATUS: AC_LTAPEBLOCK 32 KB
> STATUS: AC_RESTORE_FILTER /bin/gunzip
> STATUS: AC_SCHEMA /export/home/informix/vikas/ac_schema.sql
> STATUS: CLIENT_LOCALE not set, assuming [en_us.819]
> ERROR: "CONNECT" failed
> ERROR: -27000: (rgetlmsg() returned -1227)
> ERROR: Unable to make a connection for test.vikas
> CRITICAL ERROR: Connection to the database 'test@lt2_shm' has failed
> (SQLCODE: -27000).
> STATUS: Restore disabled for test:emp into test:vikas
> CRITICAL ERROR: Unable to continue -- no tables to restore.
> STATUS: archecker completed Physical Restore pid = 18354 exit code: 3
>
> testdb_2_L0 is yesterdays level 0 file created by ontape, which has the emp
> tble.
> I have droped the emp table just now before starting the archecker test.
>
> I'm able to connect to test database using dbaccess and also from other
> servers.
>
> The ac_schema.sql looks like:
> database test;>
> create table emp
> (
> c1 integer,
> c2 char(10)
> );>
> create table vikas
> (
> c1 integer,
> c2 char(10)
> );>
> insert into vikas
> select * from emp;>
> trying to get some clue from finderr for 27000 but
> I'm missing some thing simple, Pls if any one could guide.
>
> Regards
> Vikas.
Vikas,
The problem is that you have INFORMIXSERVER set to a shared memory
connection type and archecker wants to open more than one connection to the
server which you cannot do using shared memory connection types. Change
INFORMIXSERVER to name one of your stream-pipe or TCP/IP connections and try
again. Finderr says as much:
> finderr -27000
-27000 Cannot support multiple connections over shared memory.
An application cannot use the CONNECT statement to make more than one
connection that uses shared-memory communication (IPC).
Ensure that the application makes only one shared-memory connection at
a time. If the application must use concurrent connections, the
database server administrator might need to change the connection type
(as specified in the nettype field of the sqlhosts file) from a shared
-memory connection to a network connection.
Art
On Thu, Jan 15, 2009 at 5:40 AM, VIKAS HIVARKAR
<vikas.hivarkar@gmail.com>wrote:
> Hi,
>
> IDS 11.10.FC3 on solaris 10
>
> I'm testing a table level restore using archecker and getting the following
> error.
>
> STATUS: IBM Informix Dynamic Server Version 11.10.FC3
> Program Name: archecker
> Version: 8.0
> Released: 2008-12-09 01:42:51
> CSDK: IBM Informix CSDK Version 3.00
> ESQL: IBM Informix-ESQL Version 3.00.FC3
> Compiled: 12/09/08 01:43 on SunOS 5.9 Generic_122300-31
>
> STATUS: Arguments [-t -s -f /export/home/informix/vikas/ac_schema.sql
> -lphys]
> STATUS: AC_STORAGE /tmp
> STATUS: AC_MSGPATH /tmp/ac_msg.log
> STATUS: AC_VERBOSE on
> STATUS: AC_TAPEDEV /dev/testdb_2_L0
> STATUS: AC_TAPEBLOCK 32 KB
> STATUS: AC_LTAPEDEV /dev/null
> STATUS: AC_LTAPEBLOCK 32 KB
> STATUS: AC_RESTORE_FILTER /bin/gunzip
> STATUS: AC_SCHEMA /export/home/informix/vikas/ac_schema.sql
> STATUS: CLIENT_LOCALE not set, assuming [en_us.819]
> ERROR: "CONNECT" failed
> ERROR: -27000: (rgetlmsg() returned -1227)
> ERROR: Unable to make a connection for test.vikas
> CRITICAL ERROR: Connection to the database 'test@lt2_shm' has failed
> (SQLCODE:
> -27000).
> STATUS: Restore disabled for test:emp into test:vikas
> CRITICAL ERROR: Unable to continue -- no tables to restore.
> STATUS: archecker completed Physical Restore pid = 18354 exit code: 3
>
> testdb_2_L0 is yesterdays level 0 file created by ontape, which has the emp
> tble.
> I have droped the emp table just now before starting the archecker test.
>
> I'm able to connect to test database using dbaccess and also from other
> servers.
>
> The ac_schema.sql looks like:
> database test;>
> create table emp
> (
> c1 integer,
> c2 char(10)
> );>
> create table vikas
> (
> c1 integer,
> c2 char(10)
> );>
> insert into vikas
> select * from emp;>
> trying to get some clue from finderr for 27000 but
> I'm missing some thing simple, Pls if any one could guide.
>
> Regards
> Vikas.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.
Does the block size match the one that was used to create the archive?
Art
On Thu, Jan 15, 2009 at 6:56 AM, VIKAS HIVARKAR
<vikas.hivarkar@gmail.com>wrote:
> Thanks for the help Andreas,
>
> I've changed the INFORMIXSERVER to lt2 in order to use the tcp connection
> and
> the restore started BUT failed with errors
>
> STATUS: CLIENT_LOCALE not set, assuming [en_us.819]
> STATUS: Temporary workspace has been set
> STATUS: Extracting table test:emp into test:vikas
> WARNING: Source table [emp] has no storage option
> WARNING: No storage space to scan
> STATUS: Tape type: Archive Backup Tape
> STATUS: OnLine version: IBM Informix Dynamic Server Version 11.10.FC3
> STATUS: Archive date: Sun Jan 11 22:00:01 2009
> STATUS: Archive level: 0
> STATUS: Tape blocksize: 32768
> STATUS: Tape size: 2147483647
> STATUS: Tape number in series: 1
> TIME: [2009-01-15 12:35:54] Phys Tape 1 started
> ERROR: Invalid chunk number 4795
> ERROR: Invalid chunk number 14656
> ERROR: Invalid chunk number 7912
> .....
>
> I've even tried adding "set workspace to datadbs2" at the end of
> ac_schema.sql
> file.
>
> I'm sure that the emp table was created in datadbs2 as the test database is
> on
> datadbs2 dbspace and i created the emp table with "create table emp --- sql
> statement with out any in dbspace option.
>
> what am i missing here?
>
> Vikas.
>
> --------------------------
> Did you use tcp connection to the server?
>
> Andreas
>
> On Thursday 15 January 2009 11:40:47 VIKAS HIVARKAR wrote:
> > Hi,
> >
> > IDS 11.10.FC3 on solaris 10
> >
> > I'm testing a table level restore using archecker and getting the
> following
> > error.
> >
> > STATUS: IBM Informix Dynamic Server Version 11.10.FC3
> > Program Name: archecker
> > Version: 8.0
> > Released: 2008-12-09 01:42:51
> > CSDK: IBM Informix CSDK Version 3.00
> > ESQL: IBM Informix-ESQL Version 3.00.FC3
> > Compiled: 12/09/08 01:43 on SunOS 5.9 Generic_122300-31
> >
> > STATUS: Arguments [-t -s -f /export/home/informix/vikas/ac_schema.sql
> > -lphys] STATUS: AC_STORAGE /tmp
> > STATUS: AC_MSGPATH /tmp/ac_msg.log
> > STATUS: AC_VERBOSE on
> > STATUS: AC_TAPEDEV /dev/testdb_2_L0
> > STATUS: AC_TAPEBLOCK 32 KB
> > STATUS: AC_LTAPEDEV /dev/null
> > STATUS: AC_LTAPEBLOCK 32 KB
> > STATUS: AC_RESTORE_FILTER /bin/gunzip
> > STATUS: AC_SCHEMA /export/home/informix/vikas/ac_schema.sql
> > STATUS: CLIENT_LOCALE not set, assuming [en_us.819]
> > ERROR: "CONNECT" failed
> > ERROR: -27000: (rgetlmsg() returned -1227)
> > ERROR: Unable to make a connection for test.vikas
> > CRITICAL ERROR: Connection to the database 'test@lt2_shm' has failed
> > (SQLCODE: -27000).
> > STATUS: Restore disabled for test:emp into test:vikas
> > CRITICAL ERROR: Unable to continue -- no tables to restore.
> > STATUS: archecker completed Physical Restore pid = 18354 exit code: 3
> >
> > testdb_2_L0 is yesterdays level 0 file created by ontape, which has the
> emp
> > tble.
> > I have droped the emp table just now before starting the archecker test.
> >
> > I'm able to connect to test database using dbaccess and also from other
> > servers.
> >
> > The ac_schema.sql looks like:
> > database test;> >
> > create table emp
> > (
> > c1 integer,
> > c2 char(10)
> > );> >
> > create table vikas
> > (
> > c1 integer,
> > c2 char(10)
> > );> >
> > insert into vikas
> > select * from emp;> >
> > trying to get some clue from finderr for 27000 but
> > I'm missing some thing simple, Pls if any one could guide.
> >
> > Regards
> > Vikas.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.
Hello Art,
onstat -c |grep BLK on my test serverTAPEBLK 32 # Tape block size (Kbytes)
LTAPEBLK 32 # Log tape block size (Kbytes)
Always been the same value.
I've not set the values for AC_TAPEBLOCK & AC_LTAPEDEV so that it takes the
the default values for their corresponding ONCONFIG configuration parameters.
I've also tried setting them 32.
The ac_config.lt2 file has following
AC_MSGPATH /tmp/ac_msg.log # archecker message log
AC_STORAGE /tmp # Directory used for temp storage
AC_VERBOSE 1 # 1 verbose messages 0 terse messages
AC_RESTORE_FILTER /bin/gunzip
AC_IXBAR /dev/testdb_2_L0
I'm really confused between the parameter AC_IXBAR and AC_TAPEDEV.
Against which of these do i set the path for level 0 archive file which is to
be used for restoration.
One of ppts at http://presentations.oninit.com/public/2006IDUGEMEA/H14.ppt
says that AC_IXBAR is location for ixbar file, defines what backup to use.
so i tried with this option as well.
Not sure what am i doing wrong but still getting the errors in the ac_msg.log
file
TIME: [2009-01-15 16:42:21] All old validation files removed.
STATUS: Dropping old log control tables
STATUS: CLIENT_LOCALE not set, assuming [en_us.819]
STATUS: Temporary workspace has been set
STATUS: Target table [vikas] already created
STATUS: SQL [SET INDEXES, TRIGGERS, CONSTRAINTS FOR vikas DISABLED]
STATUS: Extracting table test:emp into test:vikas
STATUS: Archive file /dev/testdb_2_L0
STATUS: Tape type: Archive Backup Tape
STATUS: OnLine version: IBM Informix Dynamic Server Version 11.10.FC3
STATUS: Archive date: Sun Jan 11 22:00:01 2009
STATUS: Archive level: 0
STATUS: Tape blocksize: 32768
STATUS: Tape size: 2147483647
STATUS: Tape number in series: 1
TIME: [2009-01-15 16:42:21] Phys Tape 1 started
ERROR: Invalid chunk number 4795
ERROR: Invalid chunk number 14656
ERROR: Invalid chunk number 7912
ERROR: Invalid chunk number 619
ERROR: Invalid chunk number 7599
on the console where i ran the archecker command the last line shows
............Bus Error
Thanks,
Vikas
-----------------------------------------------------------------------
Does the block size match the one that was used to create the archive?
Art
On Thu, Jan 15, 2009 at 6:56 AM, VIKAS HIVARKAR
<vikas.hivarkar@gmail.com>wrote:
> Thanks for the help Andreas,
>
> I've changed the INFORMIXSERVER to lt2 in order to use the tcp connection
> and
> the restore started BUT failed with errors
>
> STATUS: CLIENT_LOCALE not set, assuming [en_us.819]
> STATUS: Temporary workspace has been set
> STATUS: Extracting table test:emp into test:vikas
> WARNING: Source table [emp] has no storage option
> WARNING: No storage space to scan
> STATUS: Tape type: Archive Backup Tape
> STATUS: OnLine version: IBM Informix Dynamic Server Version 11.10.FC3
> STATUS: Archive date: Sun Jan 11 22:00:01 2009
> STATUS: Archive level: 0
> STATUS: Tape blocksize: 32768
> STATUS: Tape size: 2147483647
> STATUS: Tape number in series: 1
> TIME: [2009-01-15 12:35:54] Phys Tape 1 started
> ERROR: Invalid chunk number 4795
> ERROR: Invalid chunk number 14656
> ERROR: Invalid chunk number 7912
> .....
>
> I've even tried adding "set workspace to datadbs2" at the end of
> ac_schema.sql
> file.
>
> I'm sure that the emp table was created in datadbs2 as the test database is
> on
> datadbs2 dbspace and i created the emp table with "create table emp --- sql
> statement with out any in dbspace option.
>
> what am i missing here?
>
> Vikas.
>
> --------------------------
> Did you use tcp connection to the server?
>
> Andreas
>
> On Thursday 15 January 2009 11:40:47 VIKAS HIVARKAR wrote:
> > Hi,
> >
> > IDS 11.10.FC3 on solaris 10
> >
> > I'm testing a table level restore using archecker and getting the
> following
> > error.
> >
> > STATUS: IBM Informix Dynamic Server Version 11.10.FC3
> > Program Name: archecker
> > Version: 8.0
> > Released: 2008-12-09 01:42:51
> > CSDK: IBM Informix CSDK Version 3.00
> > ESQL: IBM Informix-ESQL Version 3.00.FC3
> > Compiled: 12/09/08 01:43 on SunOS 5.9 Generic_122300-31
> >
> > STATUS: Arguments [-t -s -f /export/home/informix/vikas/ac_schema.sql
> > -lphys] STATUS: AC_STORAGE /tmp
> > STATUS: AC_MSGPATH /tmp/ac_msg.log
> > STATUS: AC_VERBOSE on
> > STATUS: AC_TAPEDEV /dev/testdb_2_L0
> > STATUS: AC_TAPEBLOCK 32 KB
> > STATUS: AC_LTAPEDEV /dev/null
> > STATUS: AC_LTAPEBLOCK 32 KB
> > STATUS: AC_RESTORE_FILTER /bin/gunzip
> > STATUS: AC_SCHEMA /export/home/informix/vikas/ac_schema.sql
> > STATUS: CLIENT_LOCALE not set, assuming [en_us.819]
> > ERROR: "CONNECT" failed
> > ERROR: -27000: (rgetlmsg() returned -1227)
> > ERROR: Unable to make a connection for test.vikas
> > CRITICAL ERROR: Connection to the database 'test@lt2_shm' has failed
> > (SQLCODE: -27000).
> > STATUS: Restore disabled for test:emp into test:vikas
> > CRITICAL ERROR: Unable to continue -- no tables to restore.
> > STATUS: archecker completed Physical Restore pid = 18354 exit code: 3
> >
> > testdb_2_L0 is yesterdays level 0 file created by ontape, which has the
> emp
> > tble.
> > I have droped the emp table just now before starting the archecker test.
> >
> > I'm able to connect to test database using dbaccess and also from other
> > servers.
> >
> > The ac_schema.sql looks like:
> > database test;> >
> > create table emp
> > (
> > c1 integer,
> > c2 char(10)
> > );> >
> > create table vikas
> > (
> > c1 integer,
> > c2 char(10)
> > );> >
> > insert into vikas
> > select * from emp;> >
> > trying to get some clue from finderr for 27000 but
> > I'm missing some thing simple, Pls if any one could guide.
> >
> > Regards
> > Vikas.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
It LOOKS like the archive is damaged. Archecker is reading what it thinks
are chunk numbers and is seeing garbage in the tape/file. Assuming the file
is OK, I though maybe if the block size is off then every page after the
first input block would be offset somewhat. But you are correct, archecker
is reading with a block size of 32K, that was clear in the original output
you posted, so that's not it.
AC_IXBAR is the archive pointer if you used onbar to make the archive. If
you used ontape then ones uses AC_TAPEDEV instead as you have. Something's
not right. Try an earlier or even more recent archive, just for fun, with
the same config file. If that works then the problem is archive
corruption. If not, then open a case with IBM.
Oo, one question, did you make the archive to STDIO or to a pipe and
compress the archive? If so, 11.10 had a problem with it's archecker not
being able to restore from such an archive!!!!! Again open a case with IBM.
Art
On Thu, Jan 15, 2009 at 11:03 AM, VIKAS HIVARKAR
<vikas.hivarkar@gmail.com>wrote:
> Hello Art,
>
> onstat -c |grep BLK on my test server> TAPEBLK 32 # Tape block size (Kbytes)
> LTAPEBLK 32 # Log tape block size (Kbytes)>
> Always been the same value.
>
> I've not set the values for AC_TAPEBLOCK & AC_LTAPEDEV so that it takes the
> the default values for their corresponding ONCONFIG configuration
> parameters.
> I've also tried setting them 32.
>
> The ac_config.lt2 file has following
>
> AC_MSGPATH /tmp/ac_msg.log # archecker message log
> AC_STORAGE /tmp # Directory used for temp storage
> AC_VERBOSE 1 # 1 verbose messages 0 terse messages
> AC_RESTORE_FILTER /bin/gunzip
> AC_IXBAR /dev/testdb_2_L0
>
> I'm really confused between the parameter AC_IXBAR and AC_TAPEDEV.
> Against which of these do i set the path for level 0 archive file which is
> to
> be used for restoration.
>
> One of ppts at http://presentations.oninit.com/public/2006IDUGEMEA/H14.ppt
> says that AC_IXBAR is location for ixbar file, defines what backup to use.
> so i tried with this option as well.
>
> Not sure what am i doing wrong but still getting the errors in the
> ac_msg.log
> file
>
> TIME: [2009-01-15 16:42:21] All old validation files removed.
> STATUS: Dropping old log control tables
> STATUS: CLIENT_LOCALE not set, assuming [en_us.819]
> STATUS: Temporary workspace has been set
> STATUS: Target table [vikas] already created
> STATUS: SQL [SET INDEXES, TRIGGERS, CONSTRAINTS FOR vikas DISABLED]
> STATUS: Extracting table test:emp into test:vikas
> STATUS: Archive file /dev/testdb_2_L0
> STATUS: Tape type: Archive Backup Tape
> STATUS: OnLine version: IBM Informix Dynamic Server Version 11.10.FC3
> STATUS: Archive date: Sun Jan 11 22:00:01 2009
> STATUS: Archive level: 0
> STATUS: Tape blocksize: 32768
> STATUS: Tape size: 2147483647
> STATUS: Tape number in series: 1
> TIME: [2009-01-15 16:42:21] Phys Tape 1 started
> ERROR: Invalid chunk number 4795
> ERROR: Invalid chunk number 14656
> ERROR: Invalid chunk number 7912
> ERROR: Invalid chunk number 619
> ERROR: Invalid chunk number 7599
>
> on the console where i ran the archecker command the last line shows
> .............Bus Error
>
> Thanks,
> Vikas
> -----------------------------------------------------------------------
> Does the block size match the one that was used to create the archive?
>
> Art
>
> On Thu, Jan 15, 2009 at 6:56 AM, VIKAS HIVARKAR
> <vikas.hivarkar@gmail.com>wrote:
>
> > Thanks for the help Andreas,
> >
> > I've changed the INFORMIXSERVER to lt2 in order to use the tcp connection
> > and
> > the restore started BUT failed with errors
> >
> > STATUS: CLIENT_LOCALE not set, assuming [en_us.819]
> > STATUS: Temporary workspace has been set
> > STATUS: Extracting table test:emp into test:vikas
> > WARNING: Source table [emp] has no storage option
> > WARNING: No storage space to scan
> > STATUS: Tape type: Archive Backup Tape
> > STATUS: OnLine version: IBM Informix Dynamic Server Version 11.10.FC3
> > STATUS: Archive date: Sun Jan 11 22:00:01 2009
> > STATUS: Archive level: 0
> > STATUS: Tape blocksize: 32768
> > STATUS: Tape size: 2147483647
> > STATUS: Tape number in series: 1
> > TIME: [2009-01-15 12:35:54] Phys Tape 1 started
> > ERROR: Invalid chunk number 4795
> > ERROR: Invalid chunk number 14656
> > ERROR: Invalid chunk number 7912
> > .....
> >
> > I've even tried adding "set workspace to datadbs2" at the end of
> > ac_schema.sql
> > file.
> >
> > I'm sure that the emp table was created in datadbs2 as the test database
> is
> > on
> > datadbs2 dbspace and i created the emp table with "create table emp ---
> sql
> > statement with out any in dbspace option.
> >
> > what am i missing here?
> >
> > Vikas.
> >
> > --------------------------
> > Did you use tcp connection to the server?
> >
> > Andreas
> >
> > On Thursday 15 January 2009 11:40:47 VIKAS HIVARKAR wrote:
> > > Hi,
> > >
> > > IDS 11.10.FC3 on solaris 10
> > >
> > > I'm testing a table level restore using archecker and getting the
> > following
> > > error.
> > >
> > > STATUS: IBM Informix Dynamic Server Version 11.10.FC3
> > > Program Name: archecker
> > > Version: 8.0
> > > Released: 2008-12-09 01:42:51
> > > CSDK: IBM Informix CSDK Version 3.00
> > > ESQL: IBM Informix-ESQL Version 3.00.FC3
> > > Compiled: 12/09/08 01:43 on SunOS 5.9 Generic_122300-31
> > >
> > > STATUS: Arguments [-t -s -f /export/home/informix/vikas/ac_schema.sql
> > > -lphys] STATUS: AC_STORAGE /tmp
> > > STATUS: AC_MSGPATH /tmp/ac_msg.log
> > > STATUS: AC_VERBOSE on
> > > STATUS: AC_TAPEDEV /dev/testdb_2_L0
> > > STATUS: AC_TAPEBLOCK 32 KB
> > > STATUS: AC_LTAPEDEV /dev/null
> > > STATUS: AC_LTAPEBLOCK 32 KB
> > > STATUS: AC_RESTORE_FILTER /bin/gunzip
> > > STATUS: AC_SCHEMA /export/home/informix/vikas/ac_schema.sql
> > > STATUS: CLIENT_LOCALE not set, assuming [en_us.819]
> > > ERROR: "CONNECT" failed
> > > ERROR: -27000: (rgetlmsg() returned -1227)
> > > ERROR: Unable to make a connection for test.vikas
> > > CRITICAL ERROR: Connection to the database 'test@lt2_shm' has failed
> > > (SQLCODE: -27000).
> > > STATUS: Restore disabled for test:emp into test:vikas
> > > CRITICAL ERROR: Unable to continue -- no tables to restore.
> > > STATUS: archecker completed Physical Restore pid = 18354 exit code: 3
> > >
> > > testdb_2_L0 is yesterdays level 0 file created by ontape, which has the
> > emp
> > > tble.
> > > I have droped the emp table just now before starting the archecker
> test.
> > >
> > > I'm able to connect to test database using dbaccess and also from other
> > > servers.
> > >
> > > The ac_schema.sql looks like:
> > > database test;> > >
> > > create table emp
> > > (
> > > c1 integer,
> > > c2 char(10)
> > > );> > >
> > > create table vikas
> > > (
> > > c1 integer,
> > > c2 char(10)
> > > );> > >
> > > insert into vikas
> > > select * from emp;> > >
> > > trying to get some clue from finderr for 2
I've used the AC_TAPEDEV parameter and tried with another older archive file
and getting the similar errors :-(
I used ontape to backup directory feature and have set the onconfig parameter
TAPEDEV to a directory.
So when ever i run ontape -s -L 0 a level 0 backup file (file system file)is
created in that directory.
And yes i use BACKUP_FILTER /bin/gzip to get a compressed level 0 backup file.
Is there any known issue with this, We have just upgraded to FC3 on test.
And Pls let me know what more things should i try?
Thanku,
Vikas
------------------------------------------------------------------------
It LOOKS like the archive is damaged. Archecker is reading what it thinks
are chunk numbers and is seeing garbage in the tape/file. Assuming the file
is OK, I though maybe if the block size is off then every page after the
first input block would be offset somewhat. But you are correct, archecker
is reading with a block size of 32K, that was clear in the original output
you posted, so that's not it.
AC_IXBAR is the archive pointer if you used onbar to make the archive. If
you used ontape then ones uses AC_TAPEDEV instead as you have. Something's
not right. Try an earlier or even more recent archive, just for fun, with
the same config file. If that works then the problem is archive
corruption. If not, then open a case with IBM.
Oo, one question, did you make the archive to STDIO or to a pipe and
compress the archive? If so, 11.10 had a problem with it's archecker not
being able to restore from such an archive!!!!! Again open a case with IBM.
Art
On Thu, Jan 15, 2009 at 11:03 AM, VIKAS HIVARKAR
<vikas.hivarkar@gmail.com>wrote:
What did you use to make the archive. onbar or ontape?
If you used onbar the command line must have a "-b" if you
used ontape the command line must have a "-t".
Did you use an archive filter when making the backup? If
so please check to make sure you have the same filter in place.
John F. Miller III
ids-bounces@iiug.org wrote on 01/15/2009 08:17:59 AM:
> It LOOKS like the archive is damaged. Archecker is reading what it thinks
> are chunk numbers and is seeing garbage in the tape/file. Assuming the
file
> is OK, I though maybe if the block size is off then every page after the
> first input block would be offset somewhat. But you are correct,
archecker
> is reading with a block size of 32K, that was clear in the original
output
> you posted, so that's not it.
>
> AC_IXBAR is the archive pointer if you used onbar to make the archive. If
> you used ontape then ones uses AC_TAPEDEV instead as you have.
Something's
> not right. Try an earlier or even more recent archive, just for fun, with
> the same config file. If that works then the problem is archive
> corruption. If not, then open a case with IBM.
>
> Oo, one question, did you make the archive to STDIO or to a pipe and
> compress the archive? If so, 11.10 had a problem with it's archecker not
> being able to restore from such an archive!!!!! Again open a case with
IBM.
>
> Art
>
> On Thu, Jan 15, 2009 at 11:03 AM, VIKAS HIVARKAR
> <vikas.hivarkar@gmail.com>wrote:
>
> > Hello Art,
> >
> > onstat -c |grep BLK on my test server> > TAPEBLK 32 # Tape block size (Kbytes)
> > LTAPEBLK 32 # Log tape block size (Kbytes)> >
> > Always been the same value.
> >
> > I've not set the values for AC_TAPEBLOCK & AC_LTAPEDEV so that it takes
the
> > the default values for their corresponding ONCONFIG configuration
> > parameters.
> > I've also tried setting them 32.
> >
> > The ac_config.lt2 file has following
> >
> > AC_MSGPATH /tmp/ac_msg.log # archecker message log
> > AC_STORAGE /tmp # Directory used for temp storage
> > AC_VERBOSE 1 # 1 verbose messages 0 terse messages
> > AC_RESTORE_FILTER /bin/gunzip
> > AC_IXBAR /dev/testdb_2_L0
> >
> > I'm really confused between the parameter AC_IXBAR and AC_TAPEDEV.
> > Against which of these do i set the path for level 0 archive file which
is
> > to
> > be used for restoration.
> >
> > One of ppts at
http://presentations.oninit.com/public/2006IDUGEMEA/H14.ppt
> > says that AC_IXBAR is location for ixbar file, defines what backup to
use.
> > so i tried with this option as well.
> >
> > Not sure what am i doing wrong but still getting the errors in the
> > ac_msg.log
> > file
> >
> > TIME: [2009-01-15 16:42:21] All old validation files removed.
> > STATUS: Dropping old log control tables
> > STATUS: CLIENT_LOCALE not set, assuming [en_us.819]
> > STATUS: Temporary workspace has been set
> > STATUS: Target table [vikas] already created
> > STATUS: SQL [SET INDEXES, TRIGGERS, CONSTRAINTS FOR vikas DISABLED]
> > STATUS: Extracting table test:emp into test:vikas
> > STATUS: Archive file /dev/testdb_2_L0
> > STATUS: Tape type: Archive Backup Tape
> > STATUS: OnLine version: IBM Informix Dynamic Server Version 11.10.FC3
> > STATUS: Archive date: Sun Jan 11 22:00:01 2009
> > STATUS: Archive level: 0
> > STATUS: Tape blocksize: 32768
> > STATUS: Tape size: 2147483647
> > STATUS: Tape number in series: 1
> > TIME: [2009-01-15 16:42:21] Phys Tape 1 started
> > ERROR: Invalid chunk number 4795
> > ERROR: Invalid chunk number 14656
> > ERROR: Invalid chunk number 7912
> > ERROR: Invalid chunk number 619
> > ERROR: Invalid chunk number 7599
> >
> > on the console where i ran the archecker command the last line shows
> > .............Bus Error
> >
> > Thanks,
> > Vikas
> > -----------------------------------------------------------------------
> > Does the block size match the one that was used to create the archive?
> >
> > Art
> >
> > On Thu, Jan 15, 2009 at 6:56 AM, VIKAS HIVARKAR
> > <vikas.hivarkar@gmail.com>wrote:
> >
> > > Thanks for the help Andreas,
> > >
> > > I've changed the INFORMIXSERVER to lt2 in order to use the tcp
connection
> > > and
> > > the restore started BUT failed with errors
> > >
> > > STATUS: CLIENT_LOCALE not set, assuming [en_us.819]
> > > STATUS: Temporary workspace has been set
> > > STATUS: Extracting table test:emp into test:vikas
> > > WARNING: Source table [emp] has no storage option
> > > WARNING: No storage space to scan
> > > STATUS: Tape type: Archive Backup Tape
> > > STATUS: OnLine version: IBM Informix Dynamic Server Version 11.10.FC3
> > > STATUS: Archive date: Sun Jan 11 22:00:01 2009
> > > STATUS: Archive level: 0
> > > STATUS: Tape blocksize: 32768
> > > STATUS: Tape size: 2147483647
> > > STATUS: Tape number in series: 1
> > > TIME: [2009-01-15 12:35:54] Phys Tape 1 started
> > > ERROR: Invalid chunk number 4795
> > > ERROR: Invalid chunk number 14656
> > > ERROR: Invalid chunk number 7912
> > > .....
> > >
> > > I've even tried adding "set workspace to datadbs2" at the end of
> > > ac_schema.sql
> > > file.
> > >
> > > I'm sure that the emp table was created in datadbs2 as the test
database
> > is
> > > on
> > > datadbs2 dbspace and i created the emp table with "create table emp
---
> > sql
> > > statement with out any in dbspace option.
> > >
> > > what am i missing here?
> > >
> > > Vikas.
> > >
> > > --------------------------
> > > Did you use tcp connection to the server?
> > >
> > > Andreas
> > >
> > > On Thursday 15 January 2009 11:40:47 VIKAS HIVARKAR wrote:
> > > > Hi,
> > > >
> > > > IDS 11.10.FC3 on solaris 10
> > > >
> > > > I'm testing a table level restore using archecker and getting the
> > > following
> > > > error.
> > > >
> > > > STATUS: IBM Informix Dynamic Server Version 11.10.FC3
> > > > Program Name: archecker
> > > > Version: 8.0
> > > > Released: 2008-12-09 01:42:51
> > > > CSDK: IBM Informix CSDK Version 3.00
> > > > ESQL: IBM Informix-ESQL Version 3.00.FC3
> > > > Compiled: 12/09/08 01:43 on SunOS 5.9 Generic_122300-31
> > > >
> > > > STATUS: Arguments [-t -s
-f /export/home/informix/vikas/ac_schema.sql
> > > > -lphys] STATUS: AC_STORAGE /tmp
> > > > STATUS: AC_MSGPATH /tmp/ac_msg.log
> > > > STATUS: AC_VERBOSE on
> > > > STATUS: AC_TAPEDEV /dev/testdb_2_L0
> > > > STATUS: AC_TAPEBLOCK 32 KB
> > > > STATUS: AC_LTAPEDEV /dev/null
> > > > STATUS: AC_LTAPEBLOCK 32 KB
> > > > STATUS: AC_RESTORE_FILTER /bin/gunzip
> > > > STATUS: AC_SCHEMA /export/home/informix/vikas/ac_schema.sql
> > > > STATUS: CLIENT_LOCALE not set, assuming [en_us.819]
> > > > ERROR: "CONNECT" failed
> > > > ERROR: -27000: (rgetlmsg() returned -1227)
> > > > ERROR: Unable to make a connection for test.vikas
> > > > CRITICAL ERROR: Connection to the database 'test@lt2_shm' has
failed
> > > > (SQLCODE: -27000).
> > > > STATUS: Restore disabled for test:emp into test:vikas
> > > > CRITICAL ERROR: Unable to continue -- n
Hi John,
I only use Ontape for my backups and restorations !
The command that i'm executing:
archecker -t -X -f /export/home/informix/vikas/ac_schema.sql -s
onconfig file has:
BACKUP_FILTER /bin/gzip
RESTORE_FILTER /bin/gunzip
ac_config.lt2 has:
AC_RESTORE_FILTER /bin/gunzip
Thanks,
Vikas
------------------------------------------------------------
What did you use to make the archive. onbar or ontape?
If you used onbar the command line must have a "-b" if you
used ontape the command line must have a "-t".
Did you use an archive filter when making the backup? If
so please check to make sure you have the same filter in place.
John F. Miller III
ids-bounces@iiug.org wrote on 01/15/2009 08:17:59 AM:
> It LOOKS like the archive is damaged. Archecker is reading what it thinks
> are chunk numbers and is seeing garbage in the tape/file. Assuming the
file
> is OK, I though maybe if the block size is off then every page after the
> first input block would be offset somewhat. But you are correct,
archecker
> is reading with a block size of 32K, that was clear in the original
output
> you posted, so that's not it.
>
> AC_IXBAR is the archive pointer if you used onbar to make the archive. If
> you used ontape then ones uses AC_TAPEDEV instead as you have.
Something's
> not right. Try an earlier or even more recent archive, just for fun, with
> the same config file. If that works then the problem is archive
> corruption. If not, then open a case with IBM.
>
> Oo, one question, did you make the archive to STDIO or to a pipe and
> compress the archive? If so, 11.10 had a problem with it's archecker not
> being able to restore from such an archive!!!!! Again open a case with
IBM.
>
> Art