Cross platform dump and load

Discussion:

(too old to reply)

Pradeep

2009-08-03 09:41:01 UTC

Hello all,

Our production DB is running on Solaris. The DBA has sent us a dump of
that db and we are trying to load it into a test db on Linux. After
loading 23%, it gives the following error:

Backup Server session id is: 11. Use this value when executing the
'sp_volchanged' system stored procedure after fulfilling any volume
change request from the Backup Server.
Backup Server: 4.132.1.1: Attempting to open byte stream device:
'compress::4::/home/sybase/dumps/MIGRATE_STG_sybcomp_4.dmp::00'
Backup Server: 6.28.1.1: Dumpfile name 'ATE_STG092110FE46' section
number 1 mounted on byte stream 'compress::4::/home/sybase/dumps/
MIGRATE_STG_sybcomp_4.dmp::00'
Backup Server: 4.188.1.1: Database SURETYDEV: 28804 kilobytes (3%)
LOADED.
Backup Server: 4.188.1.1: Database SURETYDEV: 57350 kilobytes (7%)
LOADED.
Backup Server: 4.188.1.1: Database SURETYDEV: 86152 kilobytes (11%)
LOADED.
Backup Server: 4.188.1.1: Database SURETYDEV: 111882 kilobytes (14%)
LOADED.
Backup Server: 4.188.1.1: Database SURETYDEV: 133516 kilobytes (17%)
LOADED.
Backup Server: 4.188.1.1: Database SURETYDEV: 155150 kilobytes (20%)
LOADED.
Backup Server: 4.188.1.1: Database SURETYDEV: 176784 kilobytes (23%)
LOADED.
Backup Server: 1.1.2.26: Memory allocation failed in bs_remap_runlist
for a M_IO_LIST allocation. This DUMP or LOAD session must exit.

I tried the same on a test db on windows and I get the same error.

The dump file was compressed as can be seen from the above and I did a
FTP in binary mode from the FTP server (on windows NT) to the test
Linux server.

Can anyone help me out with this?

Thank you,
Pradeep

Rob V [Sybase]

2009-08-03 11:18:16 UTC

Permalink

Most likely you've run out of virtual memory:

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.39996_1250/html/svrtsg/svrtsg271.htm

HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

mailto:***@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., Amersfoort, The Netherlands
Chamber of Commerce 27138666
-----------------------------------------------------------------

Post by Pradeep
Hello all,
Our production DB is running on Solaris. The DBA has sent us a dump of
that db and we are trying to load it into a test db on Linux. After
Backup Server session id is: 11. Use this value when executing the
'sp_volchanged' system stored procedure after fulfilling any volume
change request from the Backup Server.
'compress::4::/home/sybase/dumps/MIGRATE_STG_sybcomp_4.dmp::00'
Backup Server: 6.28.1.1: Dumpfile name 'ATE_STG092110FE46' section
number 1 mounted on byte stream 'compress::4::/home/sybase/dumps/
MIGRATE_STG_sybcomp_4.dmp::00'
Backup Server: 4.188.1.1: Database SURETYDEV: 28804 kilobytes (3%)
LOADED.
Backup Server: 4.188.1.1: Database SURETYDEV: 57350 kilobytes (7%)
LOADED.
Backup Server: 4.188.1.1: Database SURETYDEV: 86152 kilobytes (11%)
LOADED.
Backup Server: 4.188.1.1: Database SURETYDEV: 111882 kilobytes (14%)
LOADED.
Backup Server: 4.188.1.1: Database SURETYDEV: 133516 kilobytes (17%)
LOADED.
Backup Server: 4.188.1.1: Database SURETYDEV: 155150 kilobytes (20%)
LOADED.
Backup Server: 4.188.1.1: Database SURETYDEV: 176784 kilobytes (23%)
LOADED.
Backup Server: 1.1.2.26: Memory allocation failed in bs_remap_runlist
for a M_IO_LIST allocation. This DUMP or LOAD session must exit.
I tried the same on a test db on windows and I get the same error.
The dump file was compressed as can be seen from the above and I did a
FTP in binary mode from the FTP server (on windows NT) to the test
Linux server.
Can anyone help me out with this?
Thank you,
Pradeep

Pradeep

2009-08-03 12:24:25 UTC

Permalink

On Aug 3, 4:18 pm, "Rob V [Sybase]"

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.39996_1...
HTH,
Rob V.
-----------------------------------------------------------------
Rob Verschoor
Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase
"Tips, Tricks & Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"
Sypron B.V., Amersfoort, The Netherlands
Chamber of Commerce 27138666
-----------------------------------------------------------------

Thank you for the response. I get the error at the exact same point
(176784 bytes) in both Linux and Windows. So, it might not be a
problem with the virtual memory. I tried increasing the virtual memory
from 1.5G to 2G in the windows system but the error came again at the
same point in the load.

Mark A. Parsons

2009-08-03 13:14:47 UTC

Permalink

Solved cases at sybase.com suggest ...

- corrupted dump file, eg, incomplete file (filesystem filled up, file was modified/cut short, etc)

- corrupted dump file, eg, ftp'd in ascii mode (should use binary mode)

- missing patch for OS filesystem (HP-UX in the case)

If you've verified that all dump files are complete, files were ftp'd using binary mode, and there are no issues with
patch levels on your Linux machine ... I'd suggest you open a case with Sybase TechSupport.