关于SYBASE数据库load的一个奇怪问题

y3733

   最近遇到一个很有趣的问题，是这样的。生产系统里有主备两个数据库，主库里的数据每天在下午进行备份，然后ftp到备库，备库load，然后主备库进行数据比对都一致，但是最近从备库上下载数据到测试系统里load的时候经常load到一半的时候报错，load了多次，主要有下面三种报错。
   从网上找了一些答案，大都是说是dump文件有问题，但是我奇怪的是，既然备库能load，那么说明备库上这份文件肯定没有问题，而且我也从主库下载过，结果一样，每次下载完我都会比对数据大小，也没有错，还有个奇怪的现象就是好比日期越往后，能load的数据越少，比如在6月1号的数据还能load到三十多G，但是到7月1号就是十几二十G，而且似乎6月前的数据没有这个问题。
(1)
Jul  5 16:25:45 2016: Backup Server: 3.29.2.1: No virtual mapping for logical page 914030842.
Jul  5 16:25:45 2016: Backup Server: 3.29.2.1: No virtual mapping for logical page -1856962061.
Jul  5 16:25:45 2016: Backup Server: 3.14.2.4: Logical page 1281557 is not in the given database map.
Jul  5 16:25:45 2016: Backup Server: 6.32.2.3: compress::6::/backup/20160701/ksqhdb_20160701_part4.c6dmp::03: volume not valid or not requested (server: , session id: 28.)
Jul  5 16:25:45 2016: Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.  This DUMP or LOAD session must exit.
(2)
Jul  6 11:18:33 2016: Backup Server: 3.29.2.1: No virtual mapping for logical page 2097953072.
Jul  6 11:18:33 2016: Backup Server: 3.29.2.1: No virtual mapping for logical page -310530138.
Jul  6 11:18:33 2016: Backup Server: 3.29.2.1: No virtual mapping for logical page -1.

(3)
Jul  6 08:17:44 2016: Backup Server: 4.58.1.1: Database ksqhdb: 19476092 kilobytes LOADed.
Jul  6 08:18:07 2016: Backup Server: 4.58.1.1: Database ksqhdb: 19975656 kilobytes LOADed.
Jul  6 08:18:37 2016: Backup Server: 4.58.1.1: Database ksqhdb: 20501150 kilobytes LOADed.
Jul  6 08:18:52 2016: Backup Server: 4.124.2.1: Archive API error for device='compress::6::/backup/20160701/ksqhdb_20160701_part4.c6dmp::03': Vendor application name=Compress API
, Library version=1, API routine=syb_read(), Message=
Jul  6 08:18:53 2016: Backup Server: 6.32.2.3: compress::6::/backup/20160701/ksqhdb_20160701_part3.c6dmp::02: volume not valid or not requested (server: , session id: 40.)
Jul  6 08:18:53 2016: Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.  This DUMP or LOAD session must exit.
Jul  6 08:18:53 2016: Backup Server: 6.32.2.3: compress::6::/backup/20160701/ksqhdb_20160701_part1.c6dmp::00: volume not valid or not requested (server: , session id: 40.)
Jul  6 08:18:53 2016: Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.  This DUMP or LOAD session must exit.
Jul  6 08:18:54 2016: Backup Server: 6.32.2.3: compress::6::/backup/20160701/ksqhdb_20160701_part2.c6dmp::01: volume not valid or not requested (server: , session id: 40.)
Jul  6 08:18:54 2016: Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.  This DUMP or LOAD session must exit.
Jul  6 08:18:54 2016: Backup Server: 6.32.2.3: compress::6::/backup/20160701/ksqhdb_20160701_part4.c6dmp::03: volume not valid or not requested (server: , session id: 40.)
Jul  6 08:18:54 2016: Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.  This DUMP or LOAD session must exit.
Jul  6 09:07:51 2016: Backup Server: 4.132.1.1: Attempting to open byte stream device: 'compress::6::/backup/20160602/ksqhdb_20160602_part1.c6dmp::00'
Jul  6 09:07:51 2016: Backup Server: 4.132.1.1: Attempting to open byte stream device: 'compress::6::/backup/20160602/ksqhdb_20160602_part2.c6dmp::01'
Jul  6 09:07:51 2016: Backup Server: 4.132.1.1: Attempting to open byte stream device: 'compress::6::/backup/20160602/ksqhdb_20160602_part3.c6dmp::02'
Jul  6 09:07:51 2016: Backup Server: 4.132.1.1: Attempting to open byte stream device: 'compress::6::/backup/20160602/ksqhdb_20160602_part4.c6dmp::03'
Jul  6 09:07:51 2016: Backup Server: 6.28.1.1: Dumpfile name 'ksqhdb161540F362 ' section number 1 mounted on byte stream 'compress::6::/backup/20160602/ksqhdb_20160602_part3.c6dm
p::02'
Jul  6 09:07:51 2016: Backup Server: 6.28.1.1: Dumpfile name 'ksqhdb161540F362 ' section number 1 mounted on byte stream 'compress::6::/backup/20160602/ksqhdb_20160602_part2.c6dm
p::01'
Jul  6 09:07:51 2016: Backup Server: 6.28.1.1: Dumpfile name 'ksqhdb161540F362 ' section number 1 mounted on byte stream 'compress::6::/backup/20160602/ksqhdb_20160602_part1.c6dm
p::00'
Jul  6 09:07:51 2016: Backup Server: 6.28.1.1: Dumpfile name 'ksqhdb161540F362 ' section number 1 mounted on byte stream 'compress::6::/backup/20160602/ksqhdb_20160602_part4.c6dm
p::03'

andkylee

两个方面：
1、文件内容方面，计算一下文件的md5值，看看测试系统上各个备份文件分片的MD5值是否与生产主库上的一致。
2、确认一下测试系统、主库及备库的数据库版本是否一致。

y3733

多谢   问题已经解决
比较了MD5不一样
发现是dump文件从生产往测试拷贝的途中
在从媒介往测试库上上传时dump文件损坏
最后查出是上传使用的那台电脑内存有问题  凡是大一点的文件都会出现字节数一致 但是实际文件被损 MD5不一致的情况





回复 2# andkylee