|
Membre du Club
Inscription : octobre 2005 Messages : 79 Détails du profil  Informations personnelles : Âge : 32
Informations forums :
Inscription : octobre 2005 Messages : 79 Points : 46 Points : 46
|
[SYBASE ASE 12.5.1] - DBCC Msg 100025
Bonjour,
Version : Adaptive Server Enterprise/12.5.1/EBF 11422/P/RS6000/AIX 4.3.3/ase1251/1823/32-bit/FBO/Wed Sep 17 03:34:51 2003
Suite au passage des commandes ci-dessous, j'obtiens via sp_dbcc_faultreport l'erreur 100025 pour des tables d'une base.
Commandes :
Code :
1
2
3
4
|
dbcc checkstorage(fkqdb_rct)
dbcc checkverify(fkqdb_rct)
dbcc checkcatalog(fkqdb_rct) |
Output :
Code :
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
|
Checking fkqdb_rct: Logical pagesize IS 2048 bytes
Server Message: Number 9954, Severity 10
Server 'FS_SV_SHIRE', Line 1:
Storage checks FOR 'fkqdb_rct' are complete. DBCC IS now recording the results IN the dbccdb DATABASE.
Server Message: Number 9974, Severity 10
Server 'FS_SV_SHIRE', Line 1:
DBCC CHECKSTORAGE FOR DATABASE 'fkqdb_rct' sequence 181 completed at May 9 2008 11:56AM. 0 faults AND 14 suspect conditions were located. 0 checks were aborted. You should investigate the recorded faults, AND plan a course of action that will correct them.
Server Message: Number 9986, Severity 10
Server 'FS_SV_SHIRE', Line 1:
Suspect conditions are TO be treated AS faults IF the same suspect condition persists IN subsequent CHECKSTORAGE operations, OR IF they are also detected BY other DBCC functions.
Server Message: Number 12919, Severity 10
Server 'FS_SV_SHIRE', Line 2:
Verifying faults FOR 'fkqdb_rct'.
Server Message: Number 12925, Severity 10
Server 'FS_SV_SHIRE', Line 2:
DBCC CHECKVERIFY FOR DATABASE 'fkqdb_rct' sequence 181 completed at May 9 2008 11:56AM. 13 suspect conditions considered, 0 resolved AS faults, 13 resolved AS harmless, AND 0 could NOT be checked. 0 objects could NOT be checked.
Checking fkqdb_rct: Logical pagesize IS 2048 bytes
The following segments have been defined FOR DATABASE 7 (DATABASE name fkqdb_rct).
virtual start addr size (logical pages) segments
-------------------- ---------------------- --------------------------
50515970 5120
0
1
83929090 2560
2
DBCC execution completed. IF DBCC printed error messages, contact a user WITH System Administrator (SA) role. |
Je regarde les rapports :
Code :
1
2
3
4
|
exec sp_dbcc_summaryreport fkqdb_rct
exec sp_dbcc_faultreport NULL, fkqdb_rct |
Output :
Code :
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
|
DATABASE Name Start time End Time Operation ID Hard Faults Soft Faults Text COLUMNS Abort Count User Name
------------- ---------- -------- ------------ ----------- ----------- ------------ ----------- ---------
fkqdb_rct 05/09/2008 11:56:44 11:56:48:223 181 0 14 0 0 sa
DATABASE Name Start time End Time Operation ID Run Srl TABLE Name TABLE Id Hard Faults Soft Faults User Name
------------- ---------- -------- ------------ ----------- ---------- ----------- ----------- ----------- ---------
fkqdb_rct 05/09/2008 11:56:48 11:56:48:333 181 1 NULL NULL 0 13 sa
TABLE Name INDEX Type Code Description Page Number
---------- ----------- ----------- ----------- -----------
ta_traceur_rct 0 100025 row count error NULL
ta_donnees_bct 0 100025 row count error NULL
ta_stat_cpttitre 0 100025 row count error NULL
ta_feuille_rct 0 100025 row count error NULL
ta_intervient_int 0 100025 row count error NULL
ta_est_liecptnum 0 100025 row count error NULL
ta_a_pourcodif 0 100025 row count error NULL
ta_a_pourvalid 0 100025 row count error NULL
ta_intervient_tie 0 100025 row count error NULL
ta_a_pouragent 0 100025 row count error NULL
ta_cpt_titre 0 100025 row count error NULL
ta_compteurs 0 100025 row count error NULL
ta_rejet 0 100025 row count error NULL |
Comme indiqué dans le "Troubleshooting and Error Messages Guide"
http://manuals.sybase.com/onlinebook...ebQuery=100025
100025 : Row count or rows per page error in Object Allocation Map (OAM). checktable corrects this error.
Je lance un checktable :
Code :
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
|
USE fkqdb_rct
go
dbcc checktable (ta_traceur_rct)
go
dbcc checktable (ta_donnees_bct)
go
dbcc checktable (ta_stat_cpttitre)
go
dbcc checktable (ta_feuille_rct)
go
dbcc checktable (ta_intervient_int)
go
dbcc checktable (ta_est_liecptnum)
go
dbcc checktable (ta_a_pourcodif)
go
dbcc checktable (ta_a_pourvalid)
go
dbcc checktable (ta_intervient_tie)
go
dbcc checktable (ta_a_pouragent)
go
dbcc checktable (ta_cpt_titre)
go
dbcc checktable (ta_compteurs)
go
dbcc checktable (ta_rejet)
go |
Output :
Code :
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
|
Checking ta_traceur_rct: Logical pagesize IS 2048 bytes
The total number of DATA pages IN this TABLE IS 1.
TABLE has 593 DATA rows.
DBCC execution completed. IF DBCC printed error messages, contact a user WITH System Administrator (SA) role.
Checking ta_donnees_bct: Logical pagesize IS 2048 bytes
The total number of DATA pages IN this TABLE IS 1.
TABLE has 5001 DATA rows.
DBCC execution completed. IF DBCC printed error messages, contact a user WITH System Administrator (SA) role.
Checking ta_stat_cpttitre: Logical pagesize IS 2048 bytes
The total number of DATA pages IN this TABLE IS 1.
TABLE has 5003 DATA rows.
DBCC execution completed. IF DBCC printed error messages, contact a user WITH System Administrator (SA) role.
Checking ta_feuille_rct: Logical pagesize IS 2048 bytes
The total number of DATA pages IN this TABLE IS 1.
TABLE has 5038 DATA rows.
DBCC execution completed. IF DBCC printed error messages, contact a user WITH System Administrator (SA) role.
Checking ta_intervient_int: Logical pagesize IS 2048 bytes
The total number of DATA pages IN this TABLE IS 1.
TABLE has 11821 DATA rows.
DBCC execution completed. IF DBCC printed error messages, contact a user WITH System Administrator (SA) role.
Checking ta_est_liecptnum: Logical pagesize IS 2048 bytes
The total number of DATA pages IN this TABLE IS 1.
TABLE has 4074 DATA rows.
DBCC execution completed. IF DBCC printed error messages, contact a user WITH System Administrator (SA) role.
Checking ta_a_pourcodif: Logical pagesize IS 2048 bytes
The total number of DATA pages IN this TABLE IS 1.
TABLE has 15113 DATA rows.
DBCC execution completed. IF DBCC printed error messages, contact a user WITH System Administrator (SA) role.
Checking ta_a_pourvalid: Logical pagesize IS 2048 bytes
The total number of DATA pages IN this TABLE IS 1.
TABLE has 6539 DATA rows.
DBCC execution completed. IF DBCC printed error messages, contact a user WITH System Administrator (SA) role.
Checking ta_intervient_tie: Logical pagesize IS 2048 bytes
The total number of DATA pages IN this TABLE IS 1.
TABLE has 30857 DATA rows.
DBCC execution completed. IF DBCC printed error messages, contact a user WITH System Administrator (SA) role.
Checking ta_a_pouragent: Logical pagesize IS 2048 bytes
The total number of DATA pages IN this TABLE IS 1.
TABLE has 5965 DATA rows.
DBCC execution completed. IF DBCC printed error messages, contact a user WITH System Administrator (SA) role.
Checking ta_cpt_titre: Logical pagesize IS 2048 bytes
The total number of DATA pages IN this TABLE IS 1.
TABLE has 5042 DATA rows.
DBCC execution completed. IF DBCC printed error messages, contact a user WITH System Administrator (SA) role.
Checking ta_compteurs: Logical pagesize IS 2048 bytes
The total number of DATA pages IN this TABLE IS 1.
TABLE has 2708 DATA rows.
DBCC execution completed. IF DBCC printed error messages, contact a user WITH System Administrator (SA) role.
Checking ta_rejet: Logical pagesize IS 2048 bytes
The total number of DATA pages IN this TABLE IS 1.
TABLE has 990 DATA rows.
DBCC execution completed. IF DBCC printed error messages, contact a user WITH System Administrator (SA) role. |
Je relance pour vérifier :
Code :
1
2
3
4
5
6
7
8
9
10
|
USE dbccdb
go
dbcc checkstorage(fkqdb_rct)
dbcc checkverify(fkqdb_rct)
dbcc checkcatalog(fkqdb_rct)
exec sp_dbcc_summaryreport fkqdb_rct
exec sp_dbcc_faultreport NULL, fkqdb_rct |
Output :
Code :
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
|
Checking fkqdb_rct: Logical pagesize IS 2048 bytes
Server Message: Number 9954, Severity 10
Server 'FS_SV_SHIRE', Line 1:
Storage checks FOR 'fkqdb_rct' are complete. DBCC IS now recording the results IN the dbccdb DATABASE.
Server Message: Number 9974, Severity 10
Server 'FS_SV_SHIRE', Line 1:
DBCC CHECKSTORAGE FOR DATABASE 'fkqdb_rct' sequence 182 completed at May 9 2008 12:01PM. 0 faults AND 14 suspect conditions were located. 0 checks were aborted. You should investigate the recorded faults, AND plan a course of action that will correct them.
Server Message: Number 9986, Severity 10
Server 'FS_SV_SHIRE', Line 1:
Suspect conditions are TO be treated AS faults IF the same suspect condition persists IN subsequent CHECKSTORAGE operations, OR IF they are also detected BY other DBCC functions.
Server Message: Number 12919, Severity 10
Server 'FS_SV_SHIRE', Line 2:
Verifying faults FOR 'fkqdb_rct'.
Server Message: Number 12925, Severity 10
Server 'FS_SV_SHIRE', Line 2:
DBCC CHECKVERIFY FOR DATABASE 'fkqdb_rct' sequence 182 completed at May 9 2008 12:01PM. 13 suspect conditions considered, 0 resolved AS faults, 13 resolved AS harmless, AND 0 could NOT be checked. 0 objects could NOT be checked.
Checking fkqdb_rct: Logical pagesize IS 2048 bytes
The following segments have been defined FOR DATABASE 7 (DATABASE name fkqdb_rct).
virtual start addr size (logical pages) segments
-------------------- ---------------------- --------------------------
50515970 5120
0
1
83929090 2560
2
DBCC execution completed. IF DBCC printed error messages, contact a user WITH System Administrator (SA) role.
DBCC Operation : checkstorage
================================================================================
================================================================================
DBCC Operation : checkverify
================================================================================
================================================================================
(1 row affected)
DATABASE Name : fkqdb_rct
(1 row affected)
(6 rows affected)
(6 rows affected)
(RETURN STATUS = 0)
(13 rows affected)
(RETURN STATUS = 0)
DATABASE Name Start time End Time Operation ID Hard Faults Soft Faults Text COLUMNS Abort Count User Name
------------- ---------- -------- ------------ ----------- ----------- ------------ ----------- ---------
fkqdb_rct 05/06/2008 17:20:51 17:20:57:216 177 0 14 0 0 sa
fkqdb_rct 05/06/2008 17:45:28 17:45:30:956 178 0 14 0 0 sa
fkqdb_rct 05/09/2008 11:43:00 11:43:3:613 179 0 14 0 0 sa
fkqdb_rct 05/09/2008 11:55:39 11:55:42:416 180 0 14 0 0 sa
fkqdb_rct 05/09/2008 11:56:44 11:56:48:223 181 0 14 0 0 sa
fkqdb_rct 05/09/2008 12:01:31 12:1:34:863 182 0 14 0 0 sa
DATABASE Name Start time End Time Operation ID Run Srl TABLE Name TABLE Id Hard Faults Soft Faults User Name
------------- ---------- -------- ------------ ----------- ---------- ----------- ----------- ----------- ---------
fkqdb_rct 05/06/2008 17:20:57 17:20:57:710 177 1 NULL NULL 0 13 sa
fkqdb_rct 05/06/2008 17:45:30 17:45:31:36 178 1 NULL NULL 0 13 sa
fkqdb_rct 05/09/2008 11:43:03 11:43:3:730 179 1 NULL NULL 0 13 sa
fkqdb_rct 05/09/2008 11:55:42 11:55:42:506 180 1 NULL NULL 0 13 sa
fkqdb_rct 05/09/2008 11:56:48 11:56:48:333 181 1 NULL NULL 0 13 sa
fkqdb_rct 05/09/2008 12:01:34 12:1:34:960 182 1 NULL NULL 0 13 sa
TABLE Name INDEX Type Code Description Page Number
---------- ----------- ----------- ----------- -----------
ta_traceur_rct 0 100025 row count error NULL
ta_donnees_bct 0 100025 row count error NULL
ta_stat_cpttitre 0 100025 row count error NULL
ta_feuille_rct 0 100025 row count error NULL
ta_intervient_int 0 100025 row count error NULL
ta_est_liecptnum 0 100025 row count error NULL
ta_a_pourcodif 0 100025 row count error NULL
ta_a_pourvalid 0 100025 row count error NULL
ta_intervient_tie 0 100025 row count error NULL
ta_a_pouragent 0 100025 row count error NULL
ta_cpt_titre 0 100025 row count error NULL
ta_compteurs 0 100025 row count error NULL
ta_rejet 0 100025 row count error NULL |
J'obtiens toujours l'erreur 100025 sur les même objets.
Que me conseillez vous, merci.
PS : Je suis seul sur le serveur ASE
Cordialement.
|
14/05/2008, 16h16
00
