> 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?
I assume you're running Linux, right? What Version of MaxDB are you using? I think the problem is, that the second pipe never got its "data out" so the OS still has the buffers filled and the filedescriptor is still "busy" in the database. What happens of you do "dd if=/tmp/maxdb/datapipe2 of=/dev/null" after the first failed backup and then start the backup again? We're having the same scenario although we are using Legato Networker to backup. In this case the Legato-Client creates the pipe and not the database. If the backup fails, the pipes are closed _and_deleted_ by the client so the next attempt will lead to another new pipe creation. Greetz, SIEGENIA-AUBI KG Informationswesen i.A. Markus Döhr SAP-CC/BC, SAPDB-DBA Tel.: +49 6503 917-152 Fax: +49 6503 917-7152 E-Mail: [EMAIL PROTECTED] Internet: http://www.siegenia-aubi.com -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
