Database Load error

[unknown]

Hi all,

Im frequently getting the following error when trying to
load from tape.

D00: SYBMULTBUF ERROR: Wait for i/o completion failed:
State=105, Msg=Attempted to transfer 262144 bytes, but 0
bytes were transferred by operating system call write.
Jun 25 00:13:19 2006: Backup Server: 4.145.2.22: [105] Error
for device '/dev/nst0'. Attempted to transfer 262144 bytes,
but 0 bytes were transferred by operating system call write.
Jun 25 00:13:19 2006: D00: SYBMULTBUF ERROR: Internal error:
In db_proc, the C_MBUF command is invalid when the context
is DEST_RUN.
Jun 25 00:13:19 2006: Backup Server: 4.145.2.73: [0] Error
for device '/dev/nst0'. Pipe I/O returned 0 bytes
Jun 25 00:13:19 2006: Backup Server Internal Error:
4.62.3.4: Multibuffering subprocesses died, archive
/dev/nst0.
Jun 25 00:13:19 2006: Backup Server Internal Error:
4.62.3.4: Multibuffering subprocesses died, archive
/dev/nst0.
Jun 25 00:13:19 2006: Backup Server: 6.32.2.3: /dev/nst0:
volume not valid or not requested (server: , session id:
63.)
Jun 25 00:13:19 2006: Backup Server: 1.14.2.4: Unrecoverable
I/O or volume error. This DUMP or LOAD session must exit.
Jun 25 00:13:19 2006: Backup Server: 4.141.2.66: [0] The
'write' call failed for device '/dev/nst0' with error number
32 (Broken pipe). Refer to your operating system
documentation for further details.
Jun 25 00:13:19 2006: Backup Server Internal Error:
4.62.3.8: Multibuffering subprocesses died, archive
/dev/nst0.
Jun 25 00:14:44 2006: Backup Server: 4.141.2.50: [11] The
'ioctl' call failed for device '/dev/nst0' with error number
5 (Input/output error). Refer to your operating system
documentation for further details.
Jun 25 00:14:44 2006: Backup Server: 1.14.2.2: Unrecoverable
I/O or volume error. This DUMP or LOAD session must exit.

Anybody with an Idea of how to resolve it


Martin

[A.M.]

Post by unknown
Im frequently getting the following error when trying to
load from tape.
State=105, Msg=Attempted to transfer 262144 bytes, but 0
bytes were transferred by operating system call write.

...

Post by unknown
Jun 25 00:14:44 2006: Backup Server: 4.141.2.50: [11] The
'ioctl' call failed for device '/dev/nst0' with error number
5 (Input/output error). Refer to your operating system
documentation for further details.
Jun 25 00:14:44 2006: Backup Server: 1.14.2.2: Unrecoverable
I/O or volume error. This DUMP or LOAD session must exit.
Anybody with an Idea of how to resolve it

I don't understand why it says its doing a write
if you're doing a load. Something very odd is going
on here.

Can you post the exact command you were using and some
details about your hardware and ASE version?

-am © MMVI

[unknown]

Thax AM, i got some solution i do not know how stable it is:

The thing is to export a variable for assuming kernel
version. I have no details about it.

export LD_ASSUME_KERNEL=2.4.1

since i applied it....i havent got this error


martin

Post by A.M.

Post by unknown
Im frequently getting the following error when trying to
load from tape.
State=105, Msg=Attempted to transfer 262144 bytes,

but 0

Post by A.M.

Post by unknown
bytes were transferred by operating system call write.

...

Post by unknown
Jun 25 00:14:44 2006: Backup Server: 4.141.2.50: [11]
The 'ioctl' call failed for device '/dev/nst0' with
error number 5 (Input/output error). Refer to your
operating system documentation for further details.
Unrecoverable I/O or volume error. This DUMP or LOAD
session must exit.
Anybody with an Idea of how to resolve it

I don't understand why it says its doing a write
if you're doing a load. Something very odd is going
on here.
Can you post the exact command you were using and some
details about your hardware and ASE version?
-am © MMVI

[Jason L. Froebe (Team Sybase)]

Post by unknown
The thing is to export a variable for assuming kernel
version. I have no details about it.
export LD_ASSUME_KERNEL=2.4.1
since i applied it....i havent got this error
martin

Hi Martin,

You didn't mention the Linux kernel version or the version of Sybase ASE
you are using. The issue appears to involve the Native Posix Thread
Library. Did you check the ASE on Linux FAQ
(http://www.peppler.org/FAQ/linux.html) to verify you have the correct
trace flags enabled (if needed for your version of ASE)?