SAP Knowledge Base Article - Preview

2197553 - DUMP or LOAD fails with "A00: SYBMULTBUF ERROR: Fatal Error: Database emulator failed while executing command 161" - SAP ASE

Symptom

  • The database device resides on a ZFS device. 
  • Backup Server traceflag  -D512 is enabled.    
  • A database dump or load opearation fails with the error.
  • Dump database error:

dump database zfsdb to "/dumps/zfsdb.dump"

Backup Server: 4.171.1.1: The current value of 'reserved pages threshold' is 85%.
Backup Server: 4.171.1.2: The current value of 'allocated pages threshold' is 40%.
Backup Server: 4.171.1.5: The current value of 'parallel scan' is 2.
Backup Server session id is: 5. Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling anyvolume change request from the Backup Server.
Backup Server: 6.28.1.1: Dumpfile name 'zfsdb152070CEDE  ' section number 1 mounted on disk file '/dumps/zfsdb.dump'
Backup Server: 4.143.2.82: [0] A failure occurred for database/archive device while working on stripe device'/dumps/zfsdb.dump'. Look for 'Jul 26 14:42:38 2015: A00: SYBMULTBUF ERROR: ' in the backup server errorlog for additional information from SYBMULTBUF.
Msg 8009, Level 16, State 1:
Server 'ase157', Line 1:
Error encountered by Backup Server.  Please refer to Backup Server messages for details.

>>> Backup Server log entry

Backup Server: 1.78.1.1: The interfaces file used by the backup server is '/ase157/interfaces'.
Backup Server: 1.88.1.1: The hosts authentication file used by the backup server is '/ase157/ASE15_0/install/ase157_bs.hosts.allow'.
Backup Server: 1.79.1.1: The backup server name is 'ase157_bs'.
Backup Server: 1.70.1.1: Configuring the maximum shared memory usage to 48 MB.
Backup Server: 1.69.1.2: Configuring the number of service threads to 48.
Backup Server: 1.70.1.3: Configuring the maximum shared memory per stripe to 1048576 bytes.
Backup Server: 2.23.1.1: Connection from Server ase157 on Host test with HostProcid 24954.
Backup Server: 2.23.1.1: Connection from Server ase157 on Host test with HostProcid 24954.
Backup Server: 4.171.1.1: The current value of 'reserved pages threshold' is 85%.
Backup Server: 4.171.1.2: The current value of 'allocated pages threshold' is 40%.
Backup Server: 4.171.1.5: The current value of 'parallel scan' is 2.
Backup Server: 1.70.1.2: Configuring the shared memory per stripe to 786432 bytes.
Backup Server: 6.28.1.1: Dumpfile name 'zfsdb152070CEDE  ' section number 1 mounted on disk file '/dumps/zfsdb.dump'
D00: Attempting direct I/O for device '/export/data157/zfs1.dat'
D00: SYBMULTBUF ERROR: Failed to turn direct i/o on for database device /export/data157/zfs1.dat.
A00: SYBMULTBUF ERROR: Fatal Error: Database emulator failed while executing command 161.
Backup Server: 4.143.2.82: [0] A failure occurred for database/archive device while working on stripe device '/dumps/zfsdb.dump'. Look for 'Jul 26 14:42:38 2015: A00: SYBMULTBUF ERROR: ' in the backup server errorlog for additional information from SYBMULTBUF.
A00: SYBMULTBUF ERROR: Emulator interprocess communication failed with error state = 18, error code=32, system message=Broken pipe.

  • Load database error:

load database zfsdb from "/dumps/zfsdb.dump"
 
Backup Server session id is: 12. Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server.
Backup Server: 6.28.1.1: Dumpfile name 'zfsdb152070CEDE  ' section number 1 mounted on disk file '/dumps/zfsdb.dump'
Backup Server: 4.143.2.82: [0] A failure occurred for database/archive device while working on stripe device '/dumps/zfsdb.dump'. Look for 'Jul 26 17:45:27 2015: A00: SYBMULTBUF ERROR: ' in the backup server errorlog for additional information from SYBMULTBUF.
Backup Server: 6.32.2.3: /dumps/zfsdb.dump: volume not valid or not requested (server: , session id: 12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.  This DUMP or LOAD session must exit.
Msg 8009, Level 16, State 1:
Server 'ase157', Line 1:
Error encountered by Backup Server.  Please refer to Backup Server messages for details.

>>> Backup server log entry

Backup Server: 2.23.1.1: Connection from Server ase157j on Host test with HostProcid 5238.
Backup Server: 6.28.1.1: Dumpfile name 'zfsdb152070CEDE  ' section number 1 mounted on disk file '/dumps/zfsdb.dump'
D00: Attempting direct I/O for device '/export/data157/zfs1.dat'
D00: Attempting dsync I/O for device '/export/data157/zfs1.dat'
D00: SYBMULTBUF ERROR: Failed to turn direct i/o on for database device /export/data157/zfs1.dat.
A00: SYBMULTBUF ERROR: Fatal Error: Database emulator failed while executing command 161.
Backup Server: 4.143.2.82: [0] A failure occurred for database/archive device while working on stripe device '/dumps/zfsdb.dump'.Look for 'Jul 26 17:45:27 2015: A00: SYBMULTBUF ERROR: ' in the backup server errorlog for additional information from SYBMULTBUF.
Backup Server: 6.32.2.3: /dumps/zfsdb.dump: volume not valid or not requested (server: , session id: 12.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.  This DUMP or LOAD session must exit.
A00: SYBMULTBUF ERROR: Emulator interprocess communication failed with error state = 18, error code=32, system message=Broken pipe.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7 and 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

CR786808, CR#786808, 786808, ZFS device, trace flag -D512, direc io, BS, dump command fails , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.