I'm developing an
implementation of the MaxDB backint interface, which saves the database via two
pipes.
If the backint
process that is reading the pipes fails for any reason, so that the
database kernel reports 'broken pipe', then I am unable to do any more backups
until I restart the database. What happens is that one pipe works ok, but the
database kernel never writes the second pipe.
I've attached two
extracts of the database messages file. failure1.txt is from the first failure,
where the kernel reports 'broken pipe'. failure2.txt is from the second failure,
where the kernel never writes the second pipe.
The crucial question
is whether I can do anything about this. Failures of the failure1 type are
inevitable, if for example our backup system can't load a tape, or can't load a
follow-on tape - there will always be cases where we fail to completely read the
two pipes on a backup. Is there anything I can do to recover from there, so that
I don't have to restart the database?
Thanks in advance -
please let me know if you need any more info
David
Lane
_____________________________________________________________________
BridgeHead Software is pleased to confirm this e-mail has been scanned for viruses by MessageLabs.
2005-11-02 16:07:15 0x14 1 Savepoin Savepoint (SaveData) started by T97 2005-11-02 16:07:15 0x11 53000 OBJECT Stop active garbage coll: 1 2005-11-02 16:07:15 0x11 53000 OBJECT Garbage coll stopped: 0 2005-11-02 16:07:15 0x11 5 Pager SVP(1) Start Write Data 2005-11-02 16:07:15 0x11 6 Pager SVP(1) Stop Data IO, Pages: 0 IO: 0 2005-11-02 16:07:15 0x11 7 Pager SVP(2) Wait for last task: 79 2005-11-02 16:07:15 0x11 8 Pager SVP(2) Stop Wait for last task, Pages: 0 IO: 0 2005-11-02 16:07:15 0x11 53070 SAVPOINT B20PREPARE_SVP: 91 2005-11-02 16:07:15 0x11 53000 OBJECT Restarted Garbage coll: 1 2005-11-02 16:07:15 0x11 9 Pager SVP(3) Start Write Data 2005-11-02 16:07:15 0x11 10 Pager SVP(3) Stop Data IO, Pages: 2 IO: 2 2005-11-02 16:07:15 0x11 11 Pager SVP(3) Start Write Converter 2005-11-02 16:07:15 0x11 12 Pager SVP(3) Stop Converter IO, Pages: 6 IO: 6 2005-11-02 16:07:15 0x11 53071 SAVPOINT B20SVP_COMPLETED: 91 2005-11-02 16:07:15 0x22 12821 TASKING Thread 34 starting 2005-11-02 16:07:15 0x22 11597 IO Open '/var/opt/sdb/data/MAXDB1/data/DISKD0001' successfull, fd: 22 2005-11-02 16:07:15 0x22 11565 startup DEVi started 2005-11-02 16:07:15 0x14 11000 vasynope '/var/opt/sdb/data/MAXDB1/data/DISKD0001' devno 68 T97 succeeded 2005-11-02 16:07:15 0x9 ERR 11000 find_dev insufficient devices for ASYNOPEN (tape) 2005-11-02 16:07:15 0x9 ERR 11000 d0_vatta Cannot open volume, database shutdown 2005-11-02 16:07:15 0x9 ERR 11000 d0_vatta Volume name '/tmp/maxdb/datapipe2' 2005-11-02 16:07:15 0x11 11000 vasynope '/tmp/maxdb/datapipe2' T12 failed 2005-11-02 16:07:15 0x23 12821 TASKING Thread 35 starting 2005-11-02 16:07:15 0x14 17 SrvTasks Servertask Info: because Error in backup task occured 2005-11-02 16:07:15 0x14 10 SrvTasks Job 2 (Backup / Restore Medium Task) [executing] WaitingT97 Result=3700 2005-11-02 16:07:15 0x14 6 KernelCo Error in backup task occured, Errorcode 3700 "hostfile_error" 2005-11-02 16:07:16 0x8 11561 COMMUNIC Connecting T101 local 29483 2005-11-02 16:07:16 0x14 11561 COMMUNIC Connected T101 local 29483 2005-11-02 16:07:16 0x14 11560 COMMUNIC Releasing T101 2005-11-02 16:07:16 0x14 12929 TASKING Task T101 started 2005-11-02 16:07:16 0x14 11007 COMMUNIC wait for connection T101 2005-11-02 16:07:19 0x23 11597 IO Open '/tmp/maxdb/datapipe1' successfull, fd: 23 2005-11-02 16:07:21 0x23 11565 startup DEVi started 2005-11-02 16:07:21 0x11 11000 vasynope '/tmp/maxdb/datapipe1' devno 138 T65 succeeded 2005-11-02 16:07:21 0x11 52101 SAVE Filetype: pipe 2005-11-02 16:07:22 0x11 52024 SAVE 200 pages -> "/tmp/maxdb/datapipe1" 2005-11-02 16:07:23 0x11 52024 SAVE 336 pages -> "/tmp/maxdb/datapipe1" 2005-11-02 16:07:23 0x14 11000 vasynclo '/tmp/maxdb/datapipe1' devno 138 T97 2005-11-02 16:07:23 0x9 12822 TASKING Thread 35 joining 2005-11-02 16:07:23 0x23 11566 stop DEVi stopped 2005-11-02 16:07:23 0x14 11000 vasynclo '/var/opt/sdb/data/MAXDB1/data/DISKD0001' devno 68 T97 2005-11-02 16:07:23 0x9 12822 TASKING Thread 34 joining 2005-11-02 16:07:23 0x22 11566 stop DEVi stopped 2005-11-02 16:07:23 0x14 ERR 52012 SAVE error occured, basis_err 3700
2005-11-02 16:05:30 0x14 1 Savepoin Savepoint (SaveData) started by T103 2005-11-02 16:05:30 0x11 53000 OBJECT Stop active garbage coll: 1 2005-11-02 16:05:30 0x11 53000 OBJECT Garbage coll stopped: 0 2005-11-02 16:05:30 0x11 5 Pager SVP(1) Start Write Data 2005-11-02 16:05:30 0x11 6 Pager SVP(1) Stop Data IO, Pages: 0 IO: 0 2005-11-02 16:05:30 0x11 7 Pager SVP(2) Wait for last task: 79 2005-11-02 16:05:30 0x11 8 Pager SVP(2) Stop Wait for last task, Pages: 0 IO: 0 2005-11-02 16:05:30 0x11 53070 SAVPOINT B20PREPARE_SVP: 90 2005-11-02 16:05:30 0x11 53000 OBJECT Restarted Garbage coll: 1 2005-11-02 16:05:30 0x11 9 Pager SVP(3) Start Write Data 2005-11-02 16:05:30 0x11 10 Pager SVP(3) Stop Data IO, Pages: 2 IO: 2 2005-11-02 16:05:30 0x11 11 Pager SVP(3) Start Write Converter 2005-11-02 16:05:30 0x11 12 Pager SVP(3) Stop Converter IO, Pages: 5 IO: 5 2005-11-02 16:05:30 0x11 53071 SAVPOINT B20SVP_COMPLETED: 90 2005-11-02 16:05:30 0x1F 12821 TASKING Thread 31 starting 2005-11-02 16:05:30 0x1F 11597 IO Open '/var/opt/sdb/data/MAXDB1/data/DISKD0001' successfull, fd: 22 2005-11-02 16:05:30 0x1F 11565 startup DEVi started 2005-11-02 16:05:30 0x14 11000 vasynope '/var/opt/sdb/data/MAXDB1/data/DISKD0001' devno 68 T103 succeeded 2005-11-02 16:05:30 0x20 12821 TASKING Thread 32 starting 2005-11-02 16:05:30 0x21 12821 TASKING Thread 33 starting 2005-11-02 16:05:31 0x8 11561 COMMUNIC Connecting T104 local 29274 2005-11-02 16:05:31 0x14 11561 COMMUNIC Connected T104 local 29274 2005-11-02 16:05:31 0x14 11560 COMMUNIC Releasing T104 2005-11-02 16:05:31 0x14 12929 TASKING Task T104 started 2005-11-02 16:05:31 0x14 11007 COMMUNIC wait for connection T104 2005-11-02 16:05:35 0x20 11597 IO Open '/tmp/maxdb/datapipe1' successfull, fd: 23 2005-11-02 16:05:35 0x20 ERR 11000 devio write error (fd = 23): Broken pipe 2005-11-02 16:05:35 0x21 11597 IO Open '/tmp/maxdb/datapipe2' successfull, fd: 24 2005-11-02 16:05:35 0x21 ERR 11000 devio write error (fd = 24): Broken pipe 2005-11-02 16:05:35 0x11 11000 vasynope '/tmp/maxdb/datapipe1' T65 failed 2005-11-02 16:05:35 0x20 11566 stop DEVi stopped 2005-11-02 16:05:35 0x11 11000 vasynope '/tmp/maxdb/datapipe2' T12 failed 2005-11-02 16:05:35 0x14 11000 vasynclo '/var/opt/sdb/data/MAXDB1/data/DISKD0001' devno 68 T103 2005-11-02 16:05:35 0x9 12822 TASKING Thread 31 joining 2005-11-02 16:05:35 0x21 11566 stop DEVi stopped 2005-11-02 16:05:35 0x1F 11566 stop DEVi stopped 2005-11-02 16:05:35 0x14 ERR 52012 SAVE error occured, basis_err 3700 2005-11-02 16:05:35 0x14 17 SrvTasks Servertask Info: because Error in backup task occured 2005-11-02 16:05:35 0x14 10 SrvTasks Job 2 (Backup / Restore Medium Task) [executing] WaitingT103 Result=3700 2005-11-02 16:05:35 0x14 6 KernelCo Error in backup task occured, Errorcode 3700 "hostfile_error" 2005-11-02 16:05:35 0x14 17 SrvTasks Servertask Info: because Error in backup task occured 2005-11-02 16:05:35 0x14 10 SrvTasks Job 1 (Backup / Restore Medium Task) [executing] WaitingT103 Result=3700 2005-11-02 16:05:35 0x14 6 KernelCo Error in backup task occured, Errorcode 3700 "hostfile_error"
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
