[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sapdb-general
Subject:    RE: -903, Host file I/O error,Wrong file type
From:       "JUNG, Christian" <christian.jung () saarstahl ! com>
Date:       2006-07-25 14:27:49
Message-ID: FA8270F9F8D35946ADDBC0F36E6667CE0175C858 () nts27 ! saarstahl ! de
[Download RAW message or body]

Hello,

was this problem solved? I seem to have the same here on a MaxDB 7.6.0.18 on
Linux (x86_64):

The medium was created with following command:

medium_put BACKfull /space/sapdb/bkp/full PIPE DATA  0 8 NO NO BACK

When I trigger a backup with "backup_start BACKfull" (after a db_connect),
it lasts some seconds and then following error is displayed:

ERR
-24988,ERR_SQL: Sql error
-903,Host file I/O error,Wrong file type                         
3,Data backup failed
17,Servertask Info: because Error in backup task occured
10,Job 1 (Backup / Restore Medium Task) [executing] WaitingT465 Result=3700
6,Error in backup task occured, Errorcode 3700 "hostfile_error"

A quick look in knldiag:

2006-07-25 16:09:20    47     11597 IO       Open '/space/sapdb/bkp/full'
successfull, fd: 44
2006-07-25 16:09:20    47 ERR 11000 d0_aopen filetype found file, required
pipe
2006-07-25 16:09:20    47     11566 stop     DEVi stopped
2006-07-25 16:09:20    21     11000 vasynope '/space/sapdb/bkp/full' T40
failed

At the location for the pipe a regular file with 65536 Bytes exists. In
earlier versions SAP DB/MaxDB created the pipe itself. The backint program
(defined in <WORKDIRECTORY>/bsi.env) isn't called too.

Did I made something wrong with the media-definition? I also made some tests
with backup-media without BACK prepended and so on. I also created the pipe
manually via mknod - but nothing helped.

bye
Christian Jung

-----Ursprüngliche Nachricht-----
Von: Heinrich, Tilo [mailto:tilo.heinrich@sap.com]
Gesendet: Freitag, 12. August 2005 18:15
An: maxdb@lists.mysql.com
Betreff: RE: -903, Host file I/O error,Wrong file type


Hello David,

do you mind sending the file dbm.prt and - if existing - also the file
dbm.ebl to this list?

Best regards,
Tilo Heinrich
SAP Labs Berlin

-----Original Message-----
From: David Lane [mailto:David.Lane@BridgeHeadSoftware.com] 
Sent: Friday, August 12, 2005 12:20 PM
To: maxdb@lists.mysql.com
Subject: -903, Host file I/O error,Wrong file type

I'm trying to get a backint backup working. This is MaxDB 7.6.00.12 on
Solaris 9.
 
I've defined a backup media group:
 
BACKdata\P01    /vol0/MaxDB/bupht/datapipe1       PIPE    DATA    0
8       NO      NO              20050812090409  20050812090409
BACK
BACKdata\P02    /vol0/MaxDB/bupht/datapipe2       PIPE    DATA    0
8       NO      NO              20050812090410  20050812090410
BACK
 
When I run the backup I get the -903 error.
>From knldiag.err:
 
2005-08-12 10:31:04    37     11597 IO       Open
'/vol0/MaxDB/bupht/datapipe1' su
ccessfull, fd: 24
2005-08-12 10:31:04    37 ERR 11000 d0_aopen filetype found file,
required pipe
2005-08-12 10:31:04    38     12821 TASKING  Thread 38 starting
2005-08-12 10:31:04    38     11597 IO       Open
'/vol0/MaxDB/bupht/datapipe2' su
ccessfull, fd: 23
2005-08-12 10:31:04    37     11566 stop     DEVi stopped
2005-08-12 10:31:04    17     11000 vasynope
'/vol0/MaxDB/bupht/datapipe1' T11 fai
led
2005-08-12 10:31:04    38 ERR 11000 d0_aopen filetype found file,
required pipe
2005-08-12 10:31:04    38     11566 stop     DEVi stopped
2005-08-12 10:31:04    17     11000 vasynope
'/vol0/MaxDB/bupht/datapipe2' T12 fai
led
 
The directory /vol0/MaxDB/bupht exists but is empty. datapipe1 and
datapipe2 do not exist.
 
What am I doing wrong?

_____________________________________________________________________
BridgeHead Software is pleased to confirm this e-mail has been scanned
for viruses by MessageLabs.

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:
http://lists.mysql.com/maxdb?unsub=christian.jung@saarstahl.de


-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=sapdb-general@progressive-comp.com


[prev in list] [next in list] [prev in thread] [next in thread]