Discussion:
While a dumping a particular database, it gives internal error.
(too old to reply)
Nirmal Jana
2009-07-07 05:39:39 UTC
Permalink
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 log file of the Database Server:

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
error :
dump database distlpg to
"compress::6::d:\cmsro_DUMP\distlpg.dmp"

00:00000:00025:2009/07/03 13:50:23.25 kernel
************************************
00:00000:00025:2009/07/03 13:50:23.25 server SQL Text:
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)
00:00000:00025:2009/07/03 13:50:23.32 kernel [Handler pc:
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)
00:00000:00025:2009/07/03 13:50:23.32 kernel [Handler pc:
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)
00:00000:00025:2009/07/03 13:50:23.34 kernel [Handler pc:
0x00465417 (Symbol not found) installed by the following
function:-]
00:00000:00025:2009/07/03 13:50:23.34 kernel [Handler pc:
0x00688040 (Symbol not found) installed by the following
function:-]
00:00000:00025:2009/07/03 13:50:23.34 kernel [Handler pc:
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


Error log file of the Backup Server:
Jul 03 13:50:23 2009: Backup Server Internal Error:
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
Manish Negandhi
2009-07-07 08:49:58 UTC
Permalink
Post by Nirmal Jana
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]

Loading...