Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2003
    Posts
    23

    Unanswered: Backup failure: error number 32 (Broken pipe)

    Hi all, I'm new to this so forgive me, but I need a little help. We dump our databases to filesystems, where they are archived later. I am getting the following error on every database I try and dump:

    WARNING: In order to LOAD the master database, the SQL Server must run in single-user mode. If the master database dump uses multip
    le volumes, you must execute sp_volchanged on another SQL Server at LOAD time in order to signal volume changes.
    Backup Server session id is: 141. Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any v
    olume change request from the Backup Server.
    Backup Server: 4.41.1.1: Creating new disk file //daily/master-200401281034.1_dmp.
    Backup Server: 4.145.2.73: [0] Error for device '/daily/master-200401281034.1_dmp'. Pipe I/O returned 0 bytes
    Backup Server Internal Error: 4.62.3.4: Multibuffering subprocesses died, archive /daily/master-200401281034.1_dmp.
    Backup Server Internal Error: 4.62.3.4: Multibuffering subprocesses died, archive /daily/master-200401281034.1_dmp.
    Backup Server: 4.128.2.1: Failed to start multibuffering subprocesses for archive device '/daily/master-200401281034.1
    _dmp'. Look at the Backup Server error log or standard error for more information.
    Backup Server: 4.141.2.66: [0] The 'write' call failed for device '/daily/master-200401281034.1_dmp' with error number
    32 (Broken pipe). Refer to your operating system documentation for further details.
    Backup Server Internal Error: 4.62.3.8: Multibuffering subprocesses died, archive /daily/master-200401281034.1_dmp.
    Msg 8009, Level 16, State 1:
    Server 'SYB_SRV1', Line 1:
    Error encountered by Backup Server. Please refer to Backup Server messages for details.




    This is a new server that I inherited, thus didn't set up. Any, thoughts?

    Also: Adaptive Server Enterprise/12.0/P/Sun_svr4/OS 5.7/1576/64bit/FBO/Thu Nov 4 05:51:37 1999

    Thanks for any help.

  2. #2
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524
    1) do you write access in the dump device ?
    2) do you enough free space in the dump device ?

  3. #3
    Join Date
    Nov 2003
    Posts
    23
    yes and yes to both questions. odd, we restarted the servers and now everything is golden. can anyone help me understand why a restarting the dataservers (and backup servers) would solve this issue.

  4. #4
    Join Date
    Sep 2003
    Location
    Switzerland
    Posts
    443
    The backup server creates 2 processes / forks for every dump / load operation. You might have run out of processes or memory limit in the OS level. Thats possibly why this got fine when you rebooted the server.

  5. #5
    Join Date
    Sep 2003
    Location
    GENEVA
    Posts
    4

    Lightbulb

    For next time try to run the folowing :
    ps -ef |grep sybmul

    if it returns processes kill them.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •