Back up failure

[Former Member]

Hello,

We backup our production system with a ksh script and dbmcli commands. Blocks are written on a named pipe in order to split destiantion file into 1Go pieces. The backup has failed last night. In the KnlMsg, I have :

Thread  0x7AE Task	251  2015-08-14 01:31:15	RTEIO	112:  Open of medium  /sapdb/ZZZ/sapdata/DISKD0032 as number 34 for READ successfull
Thread  0x7AD Task	152  2015-08-14 01:31:15	RTEIO	112:  Open of medium  /tmp/savnod as number 35 for WRITE successfull
Thread  0x7AD Task	152  2015-08-14 01:31:15	SAVE	52101:  Filetype: pipe
Thread  0x7AD Task	152  2015-08-14 01:31:15	SAVE	52024:  200 pages -> "/tmp/savnod"
Thread  0x7AD Task	152  2015-08-14 01:31:20	SAVE	52024:  85600 pages -> "/tmp/savnod"
Thread  0x7AD Task	152  2015-08-14 01:32:22 ERR RTEIO	136:  transfer of block 4294967295 to medium /tmp/savnod failed,_FILE=RTEIO_StreamMedium+noPIC.cpp,_LINE=2441
	2015-08-14 01:32:22 ERR RTEIO	124:  write on medium /tmp/savnod failed:32,BYTES_NEEDED=65536,BYTES_USED=0,ERRORTEXT=Broken pipe,_FILE=RTEIO_StreamMedium+noPIC.cpp,

_LINE=3175

Thread  0x7AE Task	251  2015-08-14 01:32:22	RTEIO	114:  medium /tmp/savnod with number 35 was closed
Thread  0x7AE Task	251  2015-08-14 01:32:22	RTEIO	114:  medium /sapdb/ZZZ/sapdata/DISKD0001 with number 2 was closed

....

Thread  0x7AE Task	251  2015-08-14 01:32:22	RTEIO	114:  medium /sapdb/ZZZ/sapdata/DISKD0032 with number 34 was closed
Thread  0x7AE Task	251  2015-08-14 01:32:23 ERR SAVE	52012:  error occured, basis_err 3700
Thread  0x7AE Task	251  2015-08-14 01:32:23 ERR Backup	3:  Data backup failed,_FILE=Kernel_Administration+noPIC.cpp,_LINE=1465
	2015-08-14 01:32:22	SrvTasks	17:  Servertask Info: because Error in backup task occured
	2015-08-14 01:32:22	SrvTasks	10:  Job 1 (Backup / Restore Medium Task) [executing] WaitingT251 Result=3700
	2015-08-14 01:32:22	KernelComm	6:  Error in backup task occured, Error code 3700 "hostfile_error"
	2015-08-14 01:32:22	Backup	1:  Backupmedium #1 (/tmp/savnod) I/O Error
	2015-08-14 01:32:22	KernelComm	6:  Backup error occured, Error code 3700 "hostfile_error"
Thread  0x7AE Task	251  2015-08-14 01:32:23 ERR Backup	3:  Data backup failed,_FILE=Kernel_Administration+noPIC.cpp,_LINE=1465
	2015-08-14 01:32:22	SrvTasks	17:  Servertask Info: because Error in backup task occured
	2015-08-14 01:32:22	SrvTasks	10:  Job 1 (Backup / Restore Medium Task) [executing] WaitingT251 Result=3700
	2015-08-14 01:32:22	KernelComm	6:  Error in backup task occured, Error code 3700 "hostfile_error"
	2015-08-14 01:32:22	Backup	1:  Backupmedium #1 (/tmp/savnod) I/O Error
	2015-08-14 01:32:22	KernelComm	6:  Backup error occured, Error code 3700 "hostfile_error"

I can copy a file manually trought a named pipe, I guess that the problem is not at OS level.

I have scheduled a check data this week-end. What can I check ?

Thank you,

--

Fabien

[JamesZ]

Hi Fabien,

Can you attach diagpack.tgz file after execute below os command?

dbmcli -d <dbsid> -u control,<password> diag_pack

You can find diagpack.tgz from maxdb run directory afterwards.

Best regards,

James

[Former Member]

Hi James,

Sorry for this late reply. MaxDB is safe. The problem was located on the ftp server that receive segmented files of the backup.

Thank you for your help.

Best regards,

--

Fabien