sbu 6.0.1 / onbar (Backup sometimes fails)

sbu 6.0.1 / onbar (Backup sometimes fails)

Post by Stefan Moen » Fri, 22 Jun 2001 21:30:27



Hello,

# Solstice Backup 6.0.1
# Legato Networker Module for Informix release 2.0
# Informix Dynamic Server 2000 Version 9.21.UC4
# Sun Solaris 7

We have two tape devices one for data and one for logical logs.
The logical logs are backed up with the log_full.sh script.
(continuously)
In the nsrdmi script I have put DO_LOGFILE_BACKUPS to NO.

When we try to take a full backup of our database server it sometimes
succeeds
other times it fails with the message :

* toots_ge:INFORMIX:/ol_besrvdb01:dba02 1 retry attempted
* toots_ge:INFORMIX:/ol_besrvdb01:dba02 ! no output

Further investigation in the bar_act.log learned that the backup fails
because after
the backup of the dbspaces a backup of a logical log is initiated.
But there is already a backup of a logical log going on.
The backup fails completely and retries.

bar_act.log :

 2001-06-21 09:23:13 27465  27464 /software/ius/bin/onbar_d -b -L 0
dba02
 2001-06-21 09:23:26 27465  27464 Begin level 0 backup dba02.
 2001-06-21 09:23:26 27465  27464 Successfully connected to Storage
Manager.
 2001-06-21 09:44:36 27465  27464 Completed level 0 backup dba02
(Storage Manager copy ID: 993108207 993108208).
 2001-06-21 09:44:43 27465  27464 A log backup is already running. Can't
start another.
 2001-06-21 09:44:47 25196  25194 Begin backup logical log 53788.
 2001-06-21 09:44:49 27465  27464 /software/ius/bin/onbar_d complete,
returning 152 (0x98)
 2001-06-21 09:44:51 28225  28224 /software/ius/bin/onbar_d -b -L 0
dba02
 2001-06-21 09:44:55 25196  25194 Completed backup logical log 53788
(Storage Manager copy ID: 993109487 993110183).
...
 2001-06-21 09:44:59 28225  28224 Begin level 0 backup dba02.
 2001-06-21 09:45:00 28225  28224 Successfully connected to Storage
Manager.
 2001-06-21 09:55:10 28225  28224 Completed level 0 backup dba02
(Storage Manager copy ID: 993109500 993109501).
 2001-06-21 09:55:14 25196  25194 Begin backup logical log 53867.
 2001-06-21 09:55:16 28225  28224 A log backup is already running. Can't
start another.
 2001-06-21 09:55:22 28225  28224 /software/ius/bin/onbar_d complete,
returning 152 (0x98)

We are doing bulk operations and use a log of logical log. The change a
logical log is backing up when
the full backup tries also to backup a logical log is very  high.
If we are lucky the backup succeeds otherwise it fails (in most of the
cases)

Is there a workaround for this problem ?

Tanks,
Stefan

 
 
 

1. ADO recordset : Resync sometimes works and sometimes failed

Hi all,

I hope someone from the experts of this forum
will be able to see where is my problem .

I have a Data Grid on my form which shows a join of "Master" and
"Slave"
tables for display and data entry.

See below 2 scenarios: first one works fine and the second one failed.

1. Working scenario:

1.1 Connect to the SQL Server 2000 using ADO :

     oRecordSet.CursorLocation = adUseClient
     oRecordSet.CursorType = adOpenStatic
     oRecordSet.LockType = adLockBatchOptimistic
     oRecordSet.Source = "Select Master.*,Slave.SlaveName from Master
     JOIN Slave ON Master.SlaveId = Slave.SlaveId"
     oRecordSet.Open

1.2 Display fields from a Master table + joined Slave.SlaveName
      Set DataGrid.DataSource = oRecordSet

1.3   Change Master.SlaveID , for example from 1 to 3 :
      oRecordSet!SlaveId = 3

1.4   Update Master table :
      oRecordSet..Properties("Unique Table") = "Master"
      oRecordSet.UpdateBatch  adAffectCurrent

1.5   Refresh the Slave.SlaveName in the grid  
      oRecordSet.Resync adAffectCurrent

Everything works fine and all fields are displayed correctly in the
grid .

2. NOT working scenario:

Connect to the SQL Server 2000 with small addition of WHERE part in
SQL statement :
     oRecordSet.Source = "Select Master.*,Slave.SlaveName from Master
     JOIN Slave ON Master.SlaveId = Slave.SlaveId
     WHERE Master.SlaveId = 1 "

all other steps are the same like in scenario 1 .
It fails on oRecordSet.Resync  with the following run-time error :
"-2147217885 Key value for this row was changed or deleted at the data
store .The local row is now deleted ."

If I replace oRecordSet.Resync with oRecordSet.Requery , it works
correctly  .
BUT: I really don't like to retrieve the whole recordset if only 1 row
has been altered... Another point is that the changed record changes
its location in the recordset, so that the user gets the impression
that it "disappears".

Has someone an idea for a solution?

Thanks in advance,
Orit .

2. Validating login on sql server

3. phantom procedure - mi_prepare() fails sometimes, but sometimes do not

4. Dateformat in 6.4

5. onbar restore to alternate client from a parallel backup failed

6. FORM Errors

7. onbar with 7.24 -- Log file backup after backup.

8. The NAIUA wants your suggestions

9. Login failed for user - sometimes...

10. Pasting Cube with same shared Dimensions sometimes Ok sometimes Error

11. Login Failed For User - sometimes

12. SQL Server 7.0 Update statement sometimes partially fails with no Error Messages

13. Connection string failed to login sqlserver...sometimes...Visual Basic 6.0