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 for Me (Login required).

Search for additional results

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