Error Druing ontape -r Restore

Posted in 2004

Topics: Backup & Restore, Error Codes & Troubleshooting, Transactions, Locking & Isolation

JAMES NNAJI — Wed, 19 May 2004 17:21:55 — source: IIUG Forums & Mailing Lists

Dear All, During a Restore using ontape -r on AIX, I am having the following error physical restore failed - function read archive backup failed code -1 errno 78 I then did finderr 78 and this is what I got Program over. Nigbill3 /u1/informix: $finderr 78 -78 Deadlock situation detected/avoided. An operating-system error code with the meaning shown was unexpectedly returned to the database server. If the error recurs, please note all circumstances and contact Informix Technical Support. Under AIX, this code means connection timed out. Pls, I need Ur help. Can anybody help me Regards, James

↪ replying to JAMES NNAJI

Davis Kwong — Wed, 19 May 2004 19:09:23 — source: IIUG Forums & Mailing Lists

--0__=08BBE40ADFFBD3A88f9e8a93df938690918c08BBE40ADFFBD3A8 Content-type: multipart/alternative; Boundary="1__=08BBE40ADFFBD3A88f9e8a93df938690918c08BBE40ADFFBD3A8" --1__=08BBE40ADFFBD3A88f9e8a93df938690918c08BBE40ADFFBD3A8 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: quoted-printable HI The errno refers to the system call from open/read/write/close, not the= IDS error. On my solaris, errno 78 corresponds to grep 78 /usr/include/sys/errno.h #define ENAMETOOLONG 78 /* path name is too long */ which is most likely from the open() system call. Check the ONCONFIG TAPEDEV or LTAPEDEV and see if the value looks reasonable. thanks. davis. = "JAMES NNAJI" = <jnnaji@vodacom-n = igeria.com> = To Sent by: ids@iiug.org = forum.subscriber@ = cc iiug.org = Subj= ect Error Druing ontape -r Restore = 05/19/2004 10:21 [2986] = AM = = = = = = Dear All, During a Restore using ontape -r on AIX, I am having the follo= wing error physical restore failed - function read archive backup failed code -1 e= rrno 78 I then did finderr 78 and this is what I got Program over. Nigbill3 /u1/informix: $finderr 78 -78 Deadlock situation detected/avoided. An operating-system error code with the meaning shown was unexpectedly returned to the database server. If the error recurs, please note all circumstances and contact Informix Technical Support. Under AIX, this code means connection timed out. Pls, I need Ur help. Can anybody help me Regards, James = --1__=08BBE40ADFFBD3A88f9e8a93df938690918c08BBE40ADFFBD3A8 Content-type: text/html; charset=US-ASCII Content-Disposition: inline Content-transfer-encoding: quoted-printable <html><body> HI The errno refers to the system call from open/read/write/close, not the= IDS error. On my solaris, errno 78 corresponds to grep 78 /usr/include/sys/errno.h #define ENAMETOOLONG 78 /* path name is too long */ which is most likely from the open() system call. Check the ONCONFIG TAPEDEV or LTAPEDEV and see if the value looks reaso= nable. thanks. davis. <img src=3D"cid:10__=3D08BBE40ADFFBD3A88f9e8a93df938@us.ibm.com" width=3D= "16" height=3D"16" alt=3D"Inactive hide details for "JAMES NNAJI&q= uot; <jnnaji@vodacom-nigeria.com>">"JAMES NNAJI" <jn= naji@vodacom-nigeria.com> <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= <tr valign=3D"top"><td style=3D"background-image:url(cid:20__=3D08BBE40= ADFFBD3A88f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid= th=3D"40%"> <ul> <ul> <ul> <ul>"JAMES NNAJI" <jnnaji@vodacom-nige= ria.com> Sent by: forum.subscriber@iiug.org 05/19/2004 10:21 AM</ul> </ul> </ul> </ul> </td><td width=3D"60%"> <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D08BBE40ADFFBD3A88f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""> <div align=3D"right">To</div></td><td width=3D"= 100%"><img src=3D"cid:30__=3D08BBE40ADFFBD3A88f9e8a93df938@us.ibm.com" = border=3D"0" height=3D"1" width=3D"1" alt=3D""> ids@iiug.org</td></tr> <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D08BBE40ADFFBD3A88f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""> <div align=3D"right">cc</div></td><td width=3D"= 100%"><img src=3D"cid:30__=3D08BBE40ADFFBD3A88f9e8a93df938@us.ibm.com" = border=3D"0" height=3D"1" width=3D"1" alt=3D""> </td></tr> <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D08BBE40ADFFBD3A88f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""> <div align=3D"right">Subject</div></td><td widt= h=3D"100%"><img src=3D"cid:30__=3D08BBE40ADFFBD3A88f9e8a93df938@us.ibm.= com" border=3D"0" height=3D"1" width=3D"1" alt=3D""> Error Druing ontape -r Restore [2986]</td></tr= > </table> <table border=3D"0" cellspacing=3D"0" cellpadding=3D"0"> <tr valign=3D"top"><td width=3D"58"><img src=3D"cid:30__=3D08BBE40ADFFB= D3A88f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt= =3D""></td><td width=3D"336"><img src=3D"cid:30__=3D08BBE40ADFFBD3A88f9= e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><= /td></tr> </table> </td></tr> </table> <tt>Dear All,         During a Restore using ontape -r on AIX, I= am having the following error physical restore failed - function read archive backup failed code -1 e= rrno 78 I then did finderr 78 and this is what I got Program over. Nigbill3 /u1/informix: $finderr 78 -78     Deadlock situation detected/avoided. An operating-system error code with the meaning shown was unexpectedly<= br> returned to the database server. If the error recurs, please note all<b= r> circumstances and contact Informix Technical Support. Under AIX, this code means connection timed out. Pls, I need Ur help. Can anybody help me Regards, James </tt> </body></html>= --1__=08BBE40ADFFBD3A88f9e8a93df938690918c08BBE40ADFFBD3A8-- --0__=08BBE40ADFFBD3A88f9e8a93df938690918c08BBE40ADFFBD3A8 Content-type: image/gif; name="graycol.gif" Content-Disposition: inline; filename="graycol.gif" Content-ID: <10__=08BBE40ADFFBD3A88f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 R0lGODlhEAAQAKECAMzMzAAAAP///wAAACH5BAEAAAIALAAAAAAQABAAAAIXlI+py+0PopwxUbpu ZRfKZ2zgSJbmSRYAIf4fT3B0aW1pemVkIGJ5IFVsZWFkIFNtYXJ0U2F2ZXIhAAA7 --0__=08BBE40ADFFBD3A88f9e8a93df938690918c08BBE40ADFFBD3A8 Content-type: image

Glossary

ontape