Discussion:
access error in un-nitialized page
(too old to reply)
aries
2010-08-23 02:42:33 UTC
Permalink
Hi there,
can anyone explained about the error I countered during:
A.
1> dbcc tablealloc ('ep_contribution')
2> go
The default report option of OPTIMIZED is used for this run.
The default fix option of FIX is used for this run.
***************************************************************
TABLE: ep_contribution OBJID = 418149554
PARTITION ID=418149554 FIRST=6393 ROOT=3194064 SORT=1
Msg 2529, Level 16, State 7:
Server 'PSMBFI', Line 1:
Table Corrupt: Attempted to get page 21095462, partition ID 418149554;
got page
0, partition ID 0.
PARTITION ID=418149554 FIRST=3371257 ROOT=3371256 SORT=0
Indid : 2, partition : 418149554. 312986 Index pages allocated and
39397 Extents allocated.
PARTITION ID=418149554 FIRST=3458625 ROOT=3458624 SORT=0
Indid : 3, partition : 418149554. 153066 Index pages allocated and
19504 Extents
allocated.
TOTAL # of extents = 58901
The OAM page hint for some extents were out of date, and have now been
updated.
1>

B. bcp out
   9518000 rows successfully bulk-copied to host-file.   Server
Message: PSMBFI - Msg 692, Level 20, State 1:  Uninitialized logical
page '21095462' was read while accessing database 'psmbfi'  (4),
object 'ep_contribution' (418149554), index 'ep_contribution' (0),
partiti  on 'ep_contribution_418149554' (418149554). Please contact
Sybase Technical Support.9519403 rows copied.Msg 692, Level 16, State
1:Server 'PSMBFI', Line 1:Uninitialized logical page '21095462' was
read while accessing database 'psmbfi'(4), object
'ep_contribution' (418149554), index 'ep_contribution' (0),partition
'ep_contribution_418149554' (418149554). Please contact
SybaseTechnical Support.
C. dbcc checktable
The total number of pages with more than 50 percent insert free space
is 1330.
Table has 15096943 data rows.
Msg 692, Level 16, State 1:
Server 'PSMBFI', Line 1:
Uninitialized logical page '21095462' was read while accessing
database 'psmbfi'
(4), object 'ep_contribution' (418149554), index
'ep_contribution' (0),
partition 'ep_contribution_418149554' (418149554). Please contact
Sybase
Technical Support.
D. I have also used this select into command but the problem is still
there,
Can anybody tells me regarding this problem
Sathesh
2010-08-24 16:09:32 UTC
Permalink
Hi,

You can try these follwing options:
1. dbcc checkstorage (if not run already)
dbcc checkverify (to classify soft and hard faults)
run sp_dbcc_summaryreport for that database
sp_dbcc_faultreport
sp_dbcc_help_fault
This will help you to fix the problem

2. If the above option dosen't fix the issue, you can re-create the
database ( make sure you follow the segmap of existing devices).

3. If these dosen't help you, then Sybase support is the best option .

Thanks,
Sathesh.S

Loading...