Hi, we're encountering the following trouble. Seems that mts crash
Webservers cannot connect the db
Dedicated connection is workin when it happens.
I had a look in newsgroups archives and saw response to my answer as
"contact Oracle..."
But these answers were wrotten in y2k
May be anyone know how to fix it ?
We have this pb once every 15 days and the only solution we have is to
restart the system....
MTS use to works perfectly with this configuration before.
log...
/opt/oracle/admin/inst1/bdump/inst1_s001_28226.trc
Oracle8i Release 8.1.6.0.0 - Production
JServer Release 8.1.6.0.0 - Production
ORACLE_HOME = /opt/oracle/product/816
System name: SunOS
Node name: eus0000015
Release: 5.6
Version: Generic_105181-16
Machine: sun4u
Instance name: INST1
Redo thread mounted by this instance: 1
Oracle process number: 20
Unix process pid: 28226, image: oracle_at_eus0000015 (S001)
- 2002-04-04 09:24:18.873
- SESSION ID:(152.2894) 2002-04-04 09:24:18.673
Dumping MTS state at level 10
Global: Svc Name=INST1.immostreet, Max Svrs=30, Max Disp=6, Max Ses=550
Svrs: #act=18, #sta=6715, #trm=6853, #unt=145, #max=30
Starting: flg=20, current=1, index=19
Queue state
COMMON : Current: 0, TotalQ: 124845844, TotalTime: 24914759
ServiceQ:
DISP-D000: Current: 0, TotalQ: 63856051, TotalTime: 2718035
ServiceQ:
DISP-D001: Current: 0, TotalQ: 65497585, TotalTime: 3149459
ServiceQ:
DISP- : Current: 0, TotalQ: 0, TotalTime: 0
ServiceQ:
DISP- : Current: 0, TotalQ: 0, TotalTime: 0
ServiceQ:
DISP- : Current: 0, TotalQ: 0, TotalTime: 0
ServiceQ:
DISP- : Current: 0, TotalQ: 0, TotalTime: 0
ServiceQ:
Dispatcher State
D000: 8898ba68(1). Proc: 881ef4ac(1) flgs: 5, 1
Own: 90, Total: 114607, InTrans: 0
Net:(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP)), Opt:2, #Act: 2, Trm: 0,
LastS: 0, Bk: 0
D001: 8898bad8(1). Proc: 881ef7ac(1) flgs: 5, 3
Own: 90, Total: 116322, InTrans: 0
Net:(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP)), Opt:2, #Act: 2, Trm: 0,
LastS: 0, Bk: 0
D002: 8898bb48(0). Proc: 0(0) flgs: 0, 0
Own: 0, Total: 0, InTrans: 0
Net:(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP)), Opt:2, #Act: 2, Trm: 0,
LastS: 0, Bk: 0
D003: 8898bbb8(0). Proc: 0(0) flgs: 0, 0
Own: 0, Total: 0, InTrans: 0
Net:(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP)), Opt:2, #Act: 2, Trm: 0,
LastS: 0, Bk: 0
D004: 8898bc28(0). Proc: 0(0) flgs: 0, 0
Own: 0, Total: 0, InTrans: 0
Net:(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP)), Opt:2, #Act: 2, Trm: 0,
LastS: 0, Bk: 0
D005: 8898bc98(0). Proc: 0(0) flgs: 0, 0
Own: 0, Total: 0, InTrans: 0
Net:(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP)), Opt:2, #Act: 2, Trm: 0,
LastS: 0, Bk: 0
Server Info
S000: 8898acbc(23). Proc: 881ed9ac(97) Disp: 881ef4ac VC: 889a42d8 flgs: 1
InTrans:0 Byt:112 Brk:41007 Tvc: 84617 Nmg: 97
S001: 8898ad00(17). Proc: 881efaac(16) Disp: 881ef7ac VC: 889a0ed8 flgs: 1
InTrans:0 Byt:6143 Brk:3934742 Tvc: 8008416 Nmg: 16
S002: 8898ad44(31). Proc: 881edfac(197) Disp: 881ef7ac VC: 889924d8 flgs:
1
InTrans:0 Byt:76 Brk:32658 Tvc: 67099 Nmg: 197
S003: 8898ad88(28). Proc: 881ed6ac(174) Disp: 881ef4ac VC: 8899d3d8 flgs:
1
InTrans:0 Byt:88 Brk:31549 Tvc: 64500 Nmg: 174
S004: 8898adcc(31). Proc: 881ee5ac(80) Disp: 881ef4ac VC: 88994ad8 flgs: 1
InTrans:0 Byt:17 Brk:8051 Tvc: 16479 Nmg: 80
S005: 8898ae10(39). Proc: 881edcac(147) Disp: 881ef7ac VC: 889a0bd8 flgs:
1
...
Circuits:
8898dfd8 f:100 q:8 w:0 ob:0 bst:0/0 bsz:0/0 bo:0 m:22
8898e2d8 f:100 q:8 w:0 ob:0 bst:0/0 bsz:0/0 bo:0 m:556
8898e3d8 f:130 q:8 w:0 ob:0 bst:0/0 bsz:0/0 bo:0 m:6725
8898e4d8 f:130 q:8 w:0 ob:1 bst:0/0 bsz:0/0 bo:0 m:18742
8898e8d8 f:100 q:8 w:0 ob:1 bst:0/0 bsz:0/0 bo:0 m:123
8898e9d8 f:130 q:8 w:0 ob:1 bst:0/0 bsz:0/0 bo:0 m:23023
8898ead8 f:130 q:8 w:0 ob:0 bst:0/0 bsz:0/0 bo:0 m:16929
8898edd8 f:130 q:8 w:0 ob:0 bst:0/0 bsz:0/0 bo:0 m:5594
8898efd8 f:100 q:8 w:0 ob:0 bst:0/0 bsz:0/0 bo:0 m:150
8898f4d8 f:130 q:8 w:0 ob:1 bst:0/0 bsz:0/0 bo:0 m:24669
8898f6d8 f:130 q:8 w:0 ob:0 bst:0/0 bsz:0/0 bo:0 m:18082
8898f8d8 f:130 q:8 w:0 ob:1 bst:0/0 bsz:0/0 bo:0 m:8906
8898f9d8 f:130 q:8 w:0 ob:1 bst:0/0 bsz:0/0 bo:0 m:714
8898fad8 f:c8 q:8 w:0 ob:1 bst:0/1 bsz:0/1 bo:0 m:57
8898fcd8 f:100 q:8 w:0 ob:0 bst:0/0 bsz:0/0 bo:0 m:218
8898fdd8 f:130 q:8 w:0 ob:0 bst:0/0 bsz:0/0 bo:0 m:17156
8898fed8 f:c8 q:8 w:0 ob:0 bst:4/a bsz:13/67 bo:0 m:48
Half-duplex protocol violation; dumping buffers:
Buffer 0:
Dump of memory from 0x81B93120 to 0x81B9312D
81B93120 116B2201 1E02ED53 01010309 230702C1 [.k"....S....#...]
Buffer 1:
...
- 2002-04-04 09:24:18.889
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [16365], [2291797720], [0], [4],
[], [], [], []
Current SQL statement for this session:
update ANNONCE set
N_AGENCE=4196,TYPE_ANNONCE_ID=2,REF_INTERNE='VE167',TYPE_BIEN_ID=1,PRIX=5031
0,CHARGES=NULL,SURFACE=20,NBR_SDB=1,S_TERRAIN=NULL,NBR_WC=1,NBR_WC_SEPARE=NU
LL,NBR_PIECE=1,NBR_CHAMBRE=NULL,ETAGE=3,NBR_NIVEAU=NULL,S_JARDIN=NULL,S_BALC
ON=NULL,S_TERRASSE=NULL,CHAUFF_ELECTRIQUE=1,VUE_DEGAGEE=1,VUE_SUR_DETAIL='co
ur',CALME=1,CP_ID='92600',VILLE='ASNIERES',ADRESSE='',QUARTIER='Bourguignons
',LIEUDIT='',VILLE_PROXIMITE='',ACCES1_STATION='',ACCES1_NUM_LETTR='',ACCES2
_STATION='',ACCES2_NUM_LETTR='',COMMERCE=1,ECOLE_PRIMAIRE=1,NOM_ECOLE_PRIMAI
RE='',COLLEGE=1,NOM_COLLEGE='',NOM_LYCEE='',NOM_UNIVERSITE='',COMMENTAIRE='A
snières/ Bourguignons : proche tous commerces et transports, dans rue calme,
studio donnant sur jardin, ensoleillé, cuisine équipée, bonne copropriété.
Prix : 50 310 euros.
',NOM_PROGRAMME='',BUR_ADRESSE='',BUR_VENTE_CP='',BUR_VENTE_VILLE='',HRES_OU
VERT_DEBUT='',HRES_OUVERT_FIN='',VALID_TYPE_ID=1,CHIFFRE_AFFAIRE=NULL,ANNEE_
CONSTRUCTION=NULL,CAPACITE_ACCUEIL=NULL,CHARGES_2=NULL,DISTANCE_AEROPORT=NUL
L,DISTANCE_GARE=NULL,DISTANCE_MER=NULL,DISTANCE_VILLE_PROXIMITE=NULL,HAUTEUR
_PLAFOND=NULL,LONGUEUR_VITRINE=NULL,LOYER_MURS=NULL,NBR_COUVERT=NULL,NBR_LIT
=NULL,NBR_LITDOUBLE=NULL,NBR_LITENFANT=NULL,NBR_LITSIMPLE=NULL,NBR_PLACEPARK
ING=NULL,S_BOUTIQUE=NULL,S_LOGEMENT_1=NULL,S_LOGEMENT_2=NULL,S_RESERVE=NULL,
PAYS_ID=1,D_BAIL='',D_DISPO='',ACCES_INTERNET=0,AEROPORT=0,AGGLO_URBAINE=0,A
LARME=0,ALLEMAND=0,AMENAGEMENT_PA=0,AMENAGEMENT_PMR=0,AMENAGEMENT_SE=0,ANGLA
IS=0,ANIMAUX_ACCEPTES=0,ASCENSEUR=0,AUTOROUTE=0,BALCON=0,BATEAU=0,BUS=0,CABL
E_TV=0,CAFE_BAR=0,CANOE_KAYAK=0,CAVE=0,CENTRE_COMMERCIAL=0,CENTRE_VILLE=0,CH
AUFF_CENTRAL=0,CHAUFF_GAZ=0,CHEMINEE=0,CIRCUIT_RANDONNEE=0,CLIMATISATION=0,C
ONGELATEUR=0,COUVERTS=0,CUISINE_EQUIP=0,CUISINE_EQUIP_COM=0,CUISINE_EQUIP_IN
D=0,DEMI_PENSION=0,DIGICODE=0,DISCOTHEQUE=0,DOUBLE_EXPO=0,DRAPS_FOURNIS=0,DU
PLEX=0,EN_FRONT_DE_MER=0,EQUITATION=0,ESPAGNOL=0,ESCALADE=0,FOUR=0,F_VEN_LOU
_WEB=0,GARAGE=0,GARDERIE_JOUR=0,GARDERIE_SOIR=0,GARDIEN=0,GARE=0,GA_VUE_SUR_
COUR=0,GA_VUE_SUR_MONTAGNE=0,GD_HAUTEUR=0,GOLF=0,GRENIER=0,INTERPHONE=0,INVE
STISSEMENT_LOCATIF=0,ITALIEN=0,JARDIN=0,JARDIN_CLOS=0,LAC=0,LAVERIE=0,LAVE_V
AISSELLE=0,LICENCE_IV=0,LOGGIA=0,LYCEE=0,MACHINE_LAVER=0,MARCHE_COMMERCANT=0
,MENAGE=0,MER=0,MEUBLE=0,F_PRESTIGE=0,MEZZANINE=0,MICROONDES=0,MONTAGNE=0,MO
NUMENTS_HISTORIQUES=0,ORIENTATION_SUD=0,PARABOLE_SATELLITE=0,PARKING=0,PARKI
NG_PRIVE=0,PARKING_PUBLIC=0,PECHE=0,PENSION_COMPLETE=0,PETIT_DEJ=0,PISCINE=0
,PISTES_SKI=0,PLAQUES=0,PLONGEE=0,RAFTING=0,RANGEMENTS=0,REFAIT_NEUF=0,REFRI
GERATEUR=0,RESTAURANT=0,RIVIERE=0,SALLE_GYM=0,SOUS_SOL=0,TELEPHONE=0,TENNIS=
0,TERRASSE=0,UNIVERSITE=0,VAISSELLE=0,VUE_SUR_MER=0,ZA_ZI=0,ZI=0,ZONE_COMMER
CIALE=0,ZONE_PERIPHERIQUE=0,ACCES1_TYP='',ACCES2_TYP='',DENOMINATION='',LIEU
_CP='',LOGEMENT_1='',LOGEMENT_2='',NOM_GARE='',TYPE_BAIL='',TYPE_REGIME_BAIL
='',TYPE_RESIDENCE='' where N_AGENCE=4196 AND ANNONCE_ID=652051
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- -------------------------
---
Anyone can help ?
Thanks
Received on Thu Apr 04 2002 - 07:08:35 CST
