Test Database refresh

[sharikaganju]

Hi All,

We are trying to refresh data in our Test database in QAD. And we had written the following script -

#!/bin/sh
DLC=/progress/oe101b;export DLC
PATH=$PATH:$DLC;export PATH
PROMSGS=$DLC/promsgs;export PROMSGS
PROTERMCAP=$DLC/protermcap;export PROTERMCAP
/qad/scripts/stop.test
$DLC/bin/prorest /qad/qaddb/mfgprod.bkp /qad/qaddb/test/mfgtest
$DLC/bin/prorest /qad/qaddb/admprod.bkp /qad/qaddb/test/admtest
$DLC/bin/prorest /qad/qaddb/hlpprod.bkp /qad/qaddb/test/hlptest
/qad/scripts/start.test

When we run this script, we get the following errors -
[root@qad scripts]# ./refresh.test
OpenEdge Release 10.1B03 as of Fri Nov 2 22:11:46 EDT 2007


Connecting to Progress AdminServer using rmi://localhost:20931/Chimera (8280)
Searching for uitest_WS (8288)
Connecting to uitest_WS (8276)
uitest_WS not running (8313)
OpenEdge Release 10.1B03 as of Fri Nov 2 22:11:46 EDT 2007


Connecting to Progress AdminServer using rmi://localhost:20931/Chimera (8280)
Searching for uitest_AS (8288)
Connecting to uitest_AS (8276)
uitest_AS not running (8313)
SYSTEM ERROR: Can't attach shared memory with segment_id: 1343505 for /qad/qaddb/test/mfgtest
There is no server for database /qad/qaddb/test/mfgtest. (1423)
SYSTEM ERROR: Can't attach shared memory with segment_id: 1376276 for /qad/qaddb/test/hlptest
There is no server for database /qad/qaddb/test/hlptest. (1423)
SYSTEM ERROR: Can't attach shared memory with segment_id: 1409045 for /qad/qaddb/test/admtest
There is no server for database /qad/qaddb/test/admtest. (1423)
** Cannot find or open file /qad/qaddb/test/mfgtest, errno = 2. (43)
!!! ERROR - Database restore utility FAILED !!! (8564)
** Cannot find or open file /qad/qaddb/test/admtest, errno = 2. (43)
!!! ERROR - Database restore utility FAILED !!! (8564)
** Cannot find or open file /qad/qaddb/test/hlptest, errno = 2. (43)
!!! ERROR - Database restore utility FAILED !!! (8564)
11:51:15 BROKER 0: Multi-user session begin. (333)
11:51:16 BROKER 0: Begin Physical Redo Phase at 110000 . (5326)
11:51:17 BROKER 0: Physical Redo Phase Completed at blk 111741 off 6416 upd 0. (7161)
11:51:17 BROKER 0: At end of Physical redo, transaction table size is 256. (13547)
11:51:17 BROKER 0: Started for mfgtest-srv using tcp, pid 22651. (5644)
11:51:18 BROKER 0: Multi-user session begin. (333)
11:51:18 BROKER 0: Begin Physical Redo Phase at 0 . (5326)
11:51:18 BROKER 0: Physical Redo Phase Completed at blk 0 off 3407 upd 0. (7161)
11:51:18 BROKER 0: At end of Physical redo, transaction table size is 256. (13547)
11:51:18 BROKER 0: Started for hlptest-srv using tcp, pid 22654. (5644)
11:51:18 BROKER 0: Multi-user session begin. (333)
11:51:18 BROKER 0: Begin Physical Redo Phase at 3584 . (5326)
11:51:18 BROKER 0: Physical Redo Phase Completed at blk 1622 off 5565 upd 0. (7161)
11:51:18 BROKER 0: At end of Physical redo, transaction table size is 256. (13547)
11:51:18 BROKER 0: Started for admtest-srv using tcp, pid 22656. (5644)
OpenEdge Release 10.1B03 as of Fri Nov 2 22:11:46 EDT 2007


Connecting to Progress AdminServer using rmi://localhost:20931/Chimera (8280)
Searching for uitest_WS (8288)
Connecting to uitest_WS (8276)
Starting uitest_WS. Check status. (8296)
OpenEdge Release 10.1B03 as of Fri Nov 2 22:11:46 EDT 2007


Connecting to Progress AdminServer using rmi://localhost:20931/Chimera (8280)
Searching for uitest_AS (8288)
Connecting to uitest_AS (8276)
Starting uitest_AS. Check status. (8296)
[root@qad scripts]#


What could be the reason for the same ?

Thanks in advance.

 

[sharikaganju]

Okay I changed the prorest command in the script(refresh.test) as follows -

DLC=/progress/oe101b;export DLC
PATH=$PATH:$DLC;export PATH
PROMSGS=$DLC/promsgs;export PROMSGS
PROTERMCAP=$DLC/protermcap;export PROTERMCAP
/qad/scripts/stop.test
$DLC/bin/prorest /qad/qaddb/test/mfgtest /qad/qaddb/mfgprod.bkp
$DLC/bin/prorest /qad/qaddb/test/admtest /qad/qaddb/admprod.bkp
$DLC/bin/prorest /qad/qaddb/test/hlptest /qad/qaddb/hlpprod.bkp
/qad/scripts/start.test

I just corrected the syntax. But I now get another set of errors

[root@qad scripts]# ./refresh.test
OpenEdge Release 10.1B03 as of Fri Nov 2 22:11:46 EDT 2007

Connecting to Progress AdminServer using rmi://localhost:20931/Chimera (8280)
Searching for uitest_WS (8288)
Connecting to uitest_WS (8276)
Shut down uitest_WS (8277)
OpenEdge Release 10.1B03 as of Fri Nov 2 22:11:46 EDT 2007

Connecting to Progress AdminServer using rmi://localhost:20931/Chimera (8280)
Searching for uitest_AS (8288)
Connecting to uitest_AS (8276)
Shut down uitest_AS (8277)
Shutdown is executing. (1613)
Shutdown complete. (1614)
Shutdown is executing. (1613)
Shutdown complete. (1614)
Shutdown is executing. (1613)
Shutdown complete. (1614)
/qad/qaddb/test/mfgtest already exists.
Do you want to over write it? [y/n]: y
Start of extending target DB to needed size... (9432)
This is a full backup of /qad/qaddb/mfgprod.db. (6759)
This backup was taken Fri Dec 18 13:22:01 2009. (6760)
The blocksize is 4096. (6994)
It will require a minimum of 3824273 blocks to restore. (6763)
Start of restoring the target DB... (9433)
Read 3081853 db blocks in 00:07:53
/qad/qaddb/test/admtest already exists.
Do you want to over write it? [y/n]:
Restore failed. (1618)
!!! ERROR - Database restore utility FAILED !!! (8564)
Source database blocksize is 4096 which is unequal to target database 8192. (6769)
Restore failed. (1618)
!!! ERROR - Database restore utility FAILED !!! (8564)
14:25:31 BROKER 0: Multi-user session begin. (333)
14:25:33 BROKER 0: Begin Physical Redo Phase at 0 . (5326)
14:25:50 BROKER 0: Physical Redo Phase Completed at blk 1209 off 10977 upd 13224. (7161)
14:25:50 BROKER 0: At end of Physical redo, transaction table size is 256. (13547)
14:25:50 BROKER 0: Begin Physical Undo 1 transactions at block 1209 offset 11013 (7163)
14:25:50 BROKER 0: Physical Undo Phase Completed at 1209 . (5331)
14:25:50 BROKER 0: Begin Logical Undo Phase, 1 incomplete transactions are being backed out. (7162)
14:25:50 BROKER 0: Logical Undo Phase begin at Block 1209 Offset 10977. (11231)
14:25:50 BROKER 0: Logical Undo Phase completed at block 1034, offset 13569. (12095)
14:25:51 BROKER 0: Started for mfgtest-srv using tcp, pid 31643. (5644)
14:25:51 BROKER 0: Multi-user session begin. (333)
14:25:51 BROKER 0: Begin Physical Redo Phase at 0 . (5326)
14:25:51 BROKER 0: Physical Redo Phase Completed at blk 0 off 3459 upd 0. (7161)
14:25:51 BROKER 0: At end of Physical redo, transaction table size is 256. (13547)
14:25:51 BROKER 0: Started for hlptest-srv using tcp, pid 31645. (5644)
14:25:51 BROKER 0: Multi-user session begin. (333)
14:25:51 BROKER 0: Begin Physical Redo Phase at 5120 . (5326)
14:25:52 BROKER 0: Physical Redo Phase Completed at blk 320 off 6140 upd 44939. (7161)
14:25:52 BROKER 0: At end of Physical redo, transaction table size is 256. (13547)
14:25:52 BROKER 0: Started for admtest-srv using tcp, pid 31647. (5644)
OpenEdge Release 10.1B03 as of Fri Nov 2 22:11:46 EDT 2007

Connecting to Progress AdminServer using rmi://localhost:20931/Chimera (8280)
Searching for uitest_WS (8288)
Connecting to uitest_WS (8276)
Starting uitest_WS. Check status. (8296)
OpenEdge Release 10.1B03 as of Fri Nov 2 22:11:46 EDT 2007

Connecting to Progress AdminServer using rmi://localhost:20931/Chimera (8280)
Searching for uitest_AS (8288)
Connecting to uitest_AS (8276)
Starting uitest_AS. Check status. (8296)

What should I do to correct this ??

Thanks in advance.

 

[Cecil Snodgrass]

Start using prokb (Progress Knowledgebase) and lookup the error codes, it will tell you what to do. The error message you highlighted in red tells you that the test database set was created wrong with a 8k blocksize. The target database must be the same blocksize as the source. Delete the test databases and recreate with 4k blocksize. See the prostrct command.

 

[sharikaganju]

Thanks. This was quite a help.