While a dumping a particular database, it gives internal error.

Manish Negandhi

2009-07-07 08:49:58 UTC

Post by unknown
Hi All,
I have a database on Sybase ASE 12.5 on Windows 2003 Std
Edition. Dump of one database gives the following error in
the errorlog file of the Server and BACKUP Server
respectively. But dump on other databases does not give any
problem.
Error: 8006, Severity: 20, State: 1
00:00000:00025:2009/07/03 13:50:23.18 server SQL Server
error detected by Backup Server. Refer to the preceding
Backup Server message.
00:00000:00025:2009/07/03 13:50:23.23 kernel
************************************
00:00000:00025:2009/07/03 13:50:23.25 kernel SQL causing
dump database distlpg to
"compress::6::d:\cmsro_DUMP\distlpg.dmp"
00:00000:00025:2009/07/03 13:50:23.25 kernel
************************************
dump database distlpg to
"compress::6::d:\cmsro_DUMP\distlpg.dmp"
00:00000:00025:2009/07/03 13:50:23.25 kernel curdb = 1
pstat = 0x10000 lasterror = 8006
00:00000:00025:2009/07/03 13:50:23.25 kernel preverror = 0
transtate = 0
00:00000:00025:2009/07/03 13:50:23.25 kernel curcmd = 228
program = isql
00:00000:00025:2009/07/03 13:50:23.32 kernel pc: 0x00A7D8BD
(Symbol not found)(0x0215DF3C, 0x77E61A60, 0x77E64598,
0xFFFFFFFF)
00:00000:00025:2009/07/03 13:50:23.32 kernel pc: 0x00A7D8BD
(Symbol not found)(0x0215DF3C, 0x0215DCF4, 0x0000270F,
0x00000002)
00:00000:00025:2009/07/03 13:50:23.32 kernel pc: 0x00A589EA
(Symbol not found)(0x19D7002F, 0x00000002, 0x0000270F,
0x00000000)
00:00000:00025:2009/07/03 13:50:23.32 kernel pc: 0x00A58674
(Symbol not found)(0x19D7002F, 0x00000001, 0x0215E4E0,
0x00D04EAC)
00:00000:00025:2009/07/03 13:50:23.32 kernel pc: 0x00A1431B
(Symbol not found)(0x00000000, 0xFFFFFFFF, 0x0215E28C,
0x004657A7)
00:00000:00025:2009/07/03 13:50:23.32 kernel pc: 0x00406D71
(Symbol not found)(0x0215E374, 0x0072F1F8, 0x00000050,
0x00000006)
00:00000:00025:2009/07/03 13:50:23.32 kernel pc: 0x004657C4
(Symbol not found)(0x00000050, 0x00000006, 0x00000014,
0x00000001)
00:00000:00025:2009/07/03 13:50:23.32 kernel pc: 0x004657A7
(Symbol not found)(0x00000050, 0x00000006, 0x00000014,
0x00000001)
00:00000:00025:2009/07/03 13:50:23.32 kernel pc: 0x0072F1F8
(Symbol not found)(0x00000050, 0x00000006, 0x00000014,
0x00000001)
00:00000:00025:2009/07/03 13:50:23.32 kernel pc: 0x004653AB
(Symbol not found)(0x2214ACFC, 0x00000000, 0x00003322,
0x00000005)
00:00000:00025:2009/07/03 13:50:23.32 kernel pc: 0x007449A0
(Symbol not found)(0x202974DC, 0x00D04F80, 0x00000009,
0x00000000)
00:00000:00025:2009/07/03 13:50:23.32 kernel pc: 0x0074488B
(Symbol not found)(0x202974DC, 0x00000000, 0x00200000,
0x14000000)
00:00000:00025:2009/07/03 13:50:23.32 kernel pc: 0x00744C76
(Symbol not found)(0x2217C800, 0x202974DC, 0x0215EF00,
0x00200000)
00:00000:00025:2009/07/03 13:50:23.32 kernel pc: 0x008BE04F
(Symbol not found)(0x2217C800, 0x214D8694, 0x0215E7B0,
0x00000001)
00:00000:00025:2009/07/03 13:50:23.32 kernel pc: 0x008BDE52
(Symbol not found)(0x220105B0, 0x00000000, 0x00000000,
0x0215F840)
0x008BB417 (Symbol not found) installed by the following
function:-]
00:00000:00025:2009/07/03 13:50:23.32 kernel pc: 0x008B93DF
(Symbol not found)(0x00000000, 0x00000000, 0x00000000,
0x00000000)
00:00000:00025:2009/07/03 13:50:23.32 kernel pc: 0x006FC527
(Symbol not found)(0x2217C800, 0x00448195, 0x00000000,
0x00000000)
0x0072DF86 (Symbol not found) installed by the following
function:-]
00:00000:00025:2009/07/03 13:50:23.32 kernel pc: 0x0072AFF2
(Symbol not found)(0x214D7900, 0x00000000, 0x00000000,
0x00000000)
00:00000:00025:2009/07/03 13:50:23.32 kernel pc: 0x0044356A
(Symbol not found)(0x0000001E, 0x00000000, 0x00000000,
0x21B5B6B8)
0x00465417 (Symbol not found) installed by the following
function:-]
0x00688040 (Symbol not found) installed by the following
function:-]
0x00688040 (Symbol not found) installed by the following
function:-]
00:00000:00025:2009/07/03 13:50:23.35 kernel pc: 0x00411C47
(Symbol not found)(0x21B5B6B8, 0x00000000, 0x00000000,
0x21B5B6B8)
00:00000:00025:2009/07/03 13:50:23.35 kernel pc: 0x00A09ED7
(Symbol not found)(0x00000000, 0x00000000, 0x00000000,
0x00000000)
00:00000:00025:2009/07/03 13:50:23.35 kernel pc: 0x77E64829
kernel32.dll (0x00000000, 0x00000000, 0x00000000,
0x00000000)
00:00000:00025:2009/07/03 13:50:23.35 kernel end of stack
trace, spid 25, kpid 433520687, suid 7
4.76.3.3: Device C:\distlpg\lpgdist.dat: 0 is not a legal
virtual block number.
Can anybody pl give solution for the above? Thanks in
advance.
Nirmal Jana

You might be hitting CR263281 listed in sybase cases

CR263281: Databases created with fragments of space 4 GB or larger
cannot be dumped or loaded. The dump will fail with backupserver
error: Backup Server Internal Error: 4.76.3.3: Device /work5/test.dat:
0 is not a legal virtual block number. This will be followed by ASE
error 8006
CR263281 is fixed in ebf 9981, 12.5.0.1 IR Adaptive Server Enterprise
32-bit, and in ebf 9982, 12.5.0.1 IR Adaptive Server Enterprise 64-bit

Workaround: Keep all contiguous allocations of space in a database to
less than 4 GB

-HTH
Manish Negandhi
[TeamSybase]