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 :
Output :
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)
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 :
Output :
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
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 :
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 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
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
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.
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 :
J'obtiens toujours l'erreur 100025 sur les même objets.
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
Que me conseillez vous, merci.
PS : Je suis seul sur le serveur ASE
Cordialement.
Partager