Backup error

[Former Member]

Hi Gurus

I am facing this problem when trying to run a backup on Maxdb 7.6.0 ,ECC6 Suse 9.1

My knldiag shows this error message:

2008-03-05 20:02:01 14857 ERR 11987 IO/READ read error: rc=8192, wanted=65536, 'NO ERROR(0)', try again

2008-03-05 20:02:01 14860 ERR 11987 IO/READ read error: rc=8192, wanted=57344, 'NO ERROR(0)', try again

2008-03-05 20:02:01 14856 ERR 11987 IO/READ read error: rc=8192, wanted=24576, 'NO ERROR(0)', try again

2008-03-05 20:02:01 14855 ERR 11987 IO/READ read error: rc=4096, wanted=16384, 'NO ERROR(0)', try again

2008-03-05 20:02:02 14850 ERR 11000 devio read error (fd = 112): Input/output error

2008-03-05 20:02:02 14850 ERR 11987 IO/READ read error: rc=4294967295, wanted=16384, 'Input/output error', try again

2008-03-05 20:02:02 14865 ERR 11000 devio read error (fd = 127): Input/output error

2008-03-05 20:02:02 14865 ERR 11987 IO/READ read error: rc=4294967295, wanted=8192, 'Input/output error', try again

2008-03-05 20:02:02 14853 ERR 11987 IO/READ read error: rc=4096, wanted=16384, 'NO ERROR(0)', try again

2008-03-05 20:02:02 14869 ERR 11987 IO/READ read error: rc=16384, wanted=65536, 'NO ERROR(0)', try again

2008-03-05 20:02:02 14864 ERR 11987 IO/READ read error: rc=12288, wanted=24576, 'NO ERROR(0)', try again

2008-03-05 20:02:02 14861 ERR 11000 devio read error (fd = 123): Input/output error

2008-03-05 20:02:02 14861 ERR 11987 IO/READ read error: rc=4294967295, wanted=32768, 'Input/output error', try again

2008-03-05 20:02:03 14859 ERR 11000 devio read error (fd = 121): Input/output error

2008-03-05 20:02:03 14859 ERR 11987 IO/READ read error: rc=4294967295, wanted=57344, 'Input/output error', try again

2008-03-05 20:02:03 14858 ERR 11987 IO/READ read error: rc=4096, wanted=32768, 'NO ERROR(0)', try again

2008-03-05 20:02:04 14869 ERR 11987 IO/READ read error: rc=4096, wanted=65536, 'NO ERROR(0)', try again

2008-03-05 20:02:04 14868 ERR 11987 IO/READ read error: rc=4096, wanted=57344, 'NO ERROR(0)', try again

2008-03-05 20:02:04 14859 ERR 11000 devio read error (fd = 121): Input/output error

2008-03-05 20:02:04 14859 ERR 11987 IO/READ read error: rc=4294967295, wanted=65536, 'Input/output error', try again

2008-03-05 20:02:04 14867 ERR 11000 devio read error (fd = 129): Input/output error

2008-03-05 20:02:04 14867 ERR 11987 IO/READ read error: rc=4294967295, wanted=65536, 'Input/output error', try again

2008-03-05 20:02:04 14858 ERR 11987 IO/READ read error: rc=12288, wanted=32768, 'NO ERROR(0)', try again

2008-03-05 20:02:05 14862 ERR 11987 IO/READ read error: rc=8192, wanted=16384, 'NO ERROR(0)', try again

2008-03-05 20:02:05 14867 ERR 11987 IO/READ read error: rc=8192, wanted=65536, 'Input/output error', try again

2008-03-05 20:02:05 14858 ERR 11000 aio_read read lgt 4096, wanted 32768

2008-03-05 20:02:06 14869 ERR 11000 aio_read Error on read, NO ERROR(0)

2008-03-05 20:02:06 14869 ERR 11987 IO/READ read error: rc=20480, wanted=65536, 'NO ERROR(0)', try again

2008-03-05 20:02:06 14862 ERR 11987 IO/READ read error: rc=12288, wanted=16384, 'NO ERROR(0)', try again

2008-03-05 20:02:07 14869 ERR 11000 devio read error (fd = 131): Input/output error

2008-03-05 20:02:07 14869 ERR 11987 IO/READ read error: rc=4294967295, wanted=65536, 'Input/output error', try again

2008-03-05 20:02:07 14862 ERR 11000 devio read error (fd = 124): Input/output error

2008-03-05 20:02:07 14862 ERR 11000 aio_read Error on read, Input/output error

2008-03-05 20:02:07 14862 ERR 11000 devio read error (fd = 124): Input/output error

2008-03-05 20:02:07 14862 ERR 11987 IO/READ read error: rc=4294967295, wanted=16384, 'Input/output error', try again

2008-03-05 20:02:34 3626 ERR 52012 SAVE error occured, basis_err 6433

2008-03-05 20:02:34 3626 ERR 51080 SYSERROR -9407 unexpected error

2008-03-05 20:02:34 3626 ERR 3 Backup Data backup failed

2008-03-05 20:02:34 3626 ERR 3 IOMan + An error occurred while accessing a volume,VOLUME_TYPE=data,VOLUME_ID=13,BLOCK_NO=334517,NUMBER=2,ERRORTEXT

=en

2008-03-05 20:02:34 3626 ERR 3 IOMan + d of file,NUMBER1=43

2008-03-05 20:02:34 3626 ERR 3 IOMan + An error occurred while accessing a volume,VOLUME_TYPE=data,VOLUME_ID=20,BLOCK_NO=341686,NUMBER=8,ERRORTEXT

=en

2008-03-05 20:02:34 3626 ERR 3 IOMan + d of file,NUMBER1=50

2008-03-05 20:02:34 3626 ERR 3 IOMan + An error occurred while accessing a volume,VOLUME_TYPE=data,VOLUME_ID=9,BLOCK_NO=339874,NUMBER=4,ERRORTEXT=

end

2008-03-05 20:02:34 3626 ERR 3 IOMan + of file,NUMBER1=39

2008-03-05 20:02:34 3626 ERR 17 SrvTasks + Servertask Info: because Error in backup task occured

2008-03-05 20:02:34 3626 ERR 10 SrvTasks + Job 8 (Backup / Restore Volume Task) [executing] WaitingT128 Result=6433

2008-03-05 20:02:34 3626 ERR 6 KernelCo + Error in backup task occured, Errorcode 6433 "system_error"

Any ideas welcome

[former_member229109]

Hello Tsungy Tadinos ,

1)

Could you please update the thread with answers on the posted above questions.

You posted that you have "Maxdb 7.6.0 ,ECC6 Suse 9.1", but the information about

database version is not complete. It's also good to know the build number.

2)

It's looking that you gave answer on the question "What was changed in the database or on the database server?"

When you wrote => "i made 2 database parameter changes which are use_open_ direct from no to yes ._maxtask_stack from 512 to 1024 "

If you are SAP customer please review the SAP notes No. 977515 & 814704 & 851333.

3)

Please also post the tail of DBAHIST.PRT < as of 03/01/2008 >.

Please aso update with following information:

• Did you check OS messages . Please post them. < <.>/log/messages >

• You posted the knldiag.err entries. Please post the knldiag file :

head - to see more details ... and database parameters values;

the part of entries with the errors - to see the information beetween the

errors;

• How did you mount the FS for the data volumes & backups? Are you using NFS?

mount | grep <FS for datavolume or backup>

• Could you please set the database parameter USE_OPEN_DIRECT to NO & restart the

database to activate the new value & let me know the results after that.

Thank you and best regards, Natalia Khlopina

[Former Member]

Hi

The exact error message in DBM GUI is:

24988 sql error [backup_save "HP_ULTRUIM"DATA RECOVERY]; -9407,system:unexpected error -

[former_member229109]

Hello Tsungy Tadinos ,

Please update with additional information:

-> Output of the following commands:

dbmcli db_enum

dbmcli inst_enum

sdbregview -l

xinstinfo <DB name>

dbmcli -d <DB name> -u <dbm-user>,<pwd> param_getvolsall

dbmcli -d <DB name> -u <dbm-user>,<pwd> medium_getall

-> Could you restart the database in the online status?

-> Was the database running before the problem occurred?

When the problem started first? < Check in the knldiag.err file>

What was changed in the database or on the database server?

-> Are you SAP customer?

-> Please check if you have the I/o problems with backup device.

Please check, if you could run full database backup to different location /different disk.

< Create a new medium >

-> Did you run the CHECK DATA before you was running the databackup?

Thank you and best regards, Natalia Khlopina

[Former Member]

Hi

i made 2 database parameter changes which are use_open_ direct from no to yes ._maxtask_stack from 512 to 1024 .iam using note 814704. i dont know whether this is the source of the problem.

[Former Member]

Hi,

do this error also occur if you save to disk and not to tape?

The Errors are Read Errors, but when was the the last Tape Cleaning?

Regards Manuel