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
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.