Discussion :

[lsone]

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 :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
 
dbcc checkstorage(fkqdb_rct)
dbcc checkverify(fkqdb_rct)
dbcc checkcatalog(fkqdb_rct)

Output :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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 :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
 
 
exec sp_dbcc_summaryreport fkqdb_rct
exec sp_dbcc_faultreport null, fkqdb_rct

Output :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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 :

Sélectionner tout - Visualiser dans une fenêtre à part

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 :

Sélectionner tout - Visualiser dans une fenêtre à part

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 :

Sélectionner tout - Visualiser dans une fenêtre à part

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 :

Sélectionner tout - Visualiser dans une fenêtre à part

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.

[Roller]

J'ai déjà eu le support sybase à ce sujet, ils m'avaient dit que c'est une erreur bénigne, qui disparait si tu fais un reorg rebuild de la table si c'est une table DOL.