Olá amigos, estou com um problema na minha aplicação relacionado a deadlock. de
uns dias para cá tem dado uns 5 por dia e trava uma parte do sistema; Já
verifiquei em alguns documentos do metalink onde falam sobre a alteração do
parametro initrans dos objetos envolvidos; valor que estava era 1 e agora eu
alterei para 20. Alguem já esteve nessa situação?? Segue um pedação do meu
arquivo de log;
information may aid in determining the deadlock:
Deadlock graph:
---------Blocker(s)-------- ---------Waiter(s)---------
Resource Name process session holds waits process session holds waits
TM-0000203a-00000000 231 86 S 81 95 SX
TM-0000203a-00000000 81 95 SX 164 59 S
TM-00002045-00000000 164 59 SX 324 265 S
TM-0000203a-00000000 324 265 SX 231 86 S
session 86: DID 0001-00E7-00000021 session 95: DID 0001-0051-0000001A
session 95: DID 0001-0051-0000001A session 59: DID 0001-00A4-00000020
session 59: DID 0001-00A4-00000020 session 265: DID 0001-0144-00000008
session 265: DID 0001-0144-00000008 session 86: DID 0001-00E7-00000021
Rows waited on:
Session 95: obj - rowid = 0000203E - AAACA+AAtAAAAAAAAA
(dictionary objn - 8254, file - 45, block - 0, slot - 0)
Session 59: obj - rowid = 00002040 - AABM8qAAUAAAAAAAAA
(dictionary objn - 8256, file - 20, block - 0, slot - 0)
Session 265: obj - rowid = 00035DA4 - AAA12kAAWAAAAAAAAA
(dictionary objn - 220580, file - 22, block - 0, slot - 0)
Session 86: obj - rowid = 00001EB8 - AAAB64ABRAAAAAAAAA
(dictionary objn - 7864, file - 81, block - 0, slot - 0)
Information on the OTHER waiting sessions:
Session 95:
pid=81 serial=1181 audsid=19919595 user: 2446/DDV
O/S info: user: kmagalhaes_coop, term: SPO-1243, ospid: 1768:2060, machine:
TRANSIT\SPO-1243
ksh:
=:10,TB_AUX_DT_ATRIB_FINAL=:11,TB_AUX_ATRIBUICAO=:12,TB_AUX_STATUS=:13,INSCR_EST=:14,DIA_VENCIMENTO=:15,ID_EMPRESA=:16,ID_PRODUTO=:17:
not found.
program:
Current SQL Statement:
[EMAIL PROTECTED] /u01/app/oracle/admin/ITCPRD01/udump]$ The following deadlock
is not an ORACLE error. It is a
deadlock due to user error in the design of an application
or from issuing incorrect ad-hoc SQL. The following
information may aid in determining the deadlock:
Deadlock graph:
---------Blocker(s)-------- ---------Waiter(s)---------
Resource Name process session holds waits process session holds waits
TM-0000203a-00000000 231 86 S 81 95 SX
TM-0000203a-00000000 81 95 SX 164 59 S
TM-00002045-00000000 164 59 SX 324 265 S
TM-0000203a-00000000 324 265 SX 231 86 S
session 86: DID 0001-00E7-00000021 session 95: DID 0001-0051-0000001A
session 95: DID 0001-0051-0000001A session 59: DID 0001-00A4-00000020
session 59: DID 0001-00A4-00000020 session 265: DID 0001-0144-00000008
session 265: DID 0001-0144-00000008 session 86: DID 0001-00E7-00000021
Rows waited on:
Session 95: obj - rowid = 0000203E - AAACA+AAtAAAAAAAAA
(dictionary objn - 8254, file - 45, block - 0, slot - 0)
Session 59: obj - rowid = 00002040 - AABM8qAAUAAAAAAAAA
(dictionary objn - 8256, file - 20, block - 0, slot - 0)
Session 265: obj - rowid = 00035DA4 - AAA12kAAWAAAAAAAAA
(dictionary objn - 220580, file - 22, block - 0, slot - 0)
Session 86: obj - rowid = 00001EB8 - AAAB64ABRAAAAAAAAA
(dictionary objn - 7864, file - 81, block - 0, slot - 0)
Information on the OTHER waiting sessions:
Session 95:
pid=81 serial=1181 audsid=19919595 user: 2446/DDV
O/S info: user: kmagalhaes_coop, term: SPO-1243, ospid: 1768:2060, machine:
TRANSIT\SPO-1243
program:
Current SQL Statement:
INSERT INTO
SUB_AGENDAMENTO(DT_INST,MARCA_PABX,STATUS_INST,DATA_ATRI,DATA_VISITA,TB_AUX_DT_RETORNO,TB_AUX_FILA_ATRIB,NOME_TMKT,TB_AUX_DESC_PROC,TB_AUX_ENDEREC
O,TB_AUX_CNPJ,TB_AUX_SQ,TB_AUX_CD_VEND,COD_FILIAL,ID_EMPRESA) VALUES
(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15)
Session 59:
pid=164 serial=3757 audsid=19920478 user: 2327/SHE
ksh: The: not found.
[EMAIL PROTECTED] /u01/app/oracle/admin/ITCPRD01/udump]$ deadlock due to user
error in the design of an application
ksh: deadlock: not found.
[EMAIL PROTECTED] /u01/app/oracle/admin/ITCPRD01/udump]$ or from issuing
incorrect ad-hoc SQL. The following
ksh: or: not found.
[EMAIL PROTECTED] /u01/app/oracle/admin/ITCPRD01/udump]$ information may aid in
determining the deadlock:
ksh: information: not found.
Deadlock graph:
---------Blocker(s)-------- ---------Waiter(s)---------
Resource Name process session holds waits process session holds waits
TM-0000203a-00000000 231 86 S 81 95 SX
TM-0000203a-00000000 81 95 SX 164 59 S
TM-00002045-00000000 164 59 SX 324 265 S
TM-0000203a-00000000 324 265 SX 231 86 S
session 86: DID 0001-00E7-00000021 session 95: DID 0001-0051-0000001A
session 95: DID 0001-0051-0000001A session 59: DID 0001-00A4-00000020
session 59: DID 0001-00A4-00000020 session 265: DID 0001-0144-00000008
session 265: DID 0001-0144-00000008 session 86: DID 0001-00E7-00000021
Rows waited on:
Session 95: obj - rowid = 0000203E - AAACA+AAtAAAAAAAAA
(dictionary objn - 8254, file - 45, block - 0, slot - 0)
Session 59: obj - rowid = 00002040 - AABM8qAAUAAAAAAAAA
(dictionary objn - 8256, file - 20, block - 0, slot - 0)
Session 265: obj - rowid = 00035DA4 - AAA12kAAWAAAAAAAAA
(dictionary objn - 220580, file - 22, block - 0, slot - 0)
Session 86: obj - rowid = 00001EB8 - AAAB64ABRAAAAAAAAA
(dictionary objn - 7864, file - 81, block - 0, slot - 0)
Information on the OTHER waiting sessions:
Session 95:
pid=81 serial=1181 audsid=19919595 user: 2446/DDV
O/S info: user: kmagalhaes_coop, term: SPO-1243, ospid: 1768:2060, machine:
TRANSIT\SPO-1243
program:
Current SQL Statement:
INSERT INTO
SUB_AGENDAMENTO(DT_INST,MARCA_PABX,STATUS_INST,DATA_ATRI,DATA_VISITA,TB_AUX_DT_RETORNO,TB_AUX_FILA_ATRIB,NOME_TMKT,TB_AUX_DESC_PROC,TB_AUX_ENDEREC
O,TB_AUX_CNPJ,TB_AUX_SQ,TB_AUX_CD_VEND,COD_FILIAL,ID_EMPRESA) VALUES
(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15)
Session 59:
pid=164 serial=3757 audsid=19920478 user: 2327/SHE
O/S info: user: SYSTEM, term: WEBTRANS2, ospid: 9208:6116, machine:
TRANSIT\WEBTRANS2
program: frmweb.exe
application name: frmweb.exe, hash value=0
[EMAIL PROTECTED] /u01/app/oracle/admin/ITCPRD01/udump]$ Deadlock graph:
ksh: Deadlock: not found.
[EMAIL PROTECTED] /u01/app/oracle/admin/ITCPRD01/udump]$
---------Blocker(s)-------- ---------Waiter(s)---------
ksh: 0403-057 Syntax error: `(' is not expected.
[EMAIL PROTECTED] /u01/app/oracle/admin/ITCPRD01/udump]$ Resource Name
process session holds waits process session holds waits
ksh: Resource: not found.
[EMAIL PROTECTED] /u01/app/oracle/admin/ITCPRD01/udump]$
TM-0000203a-00000000 231 86 S 81 95 SX
ksh: TM-0000203a-00000000: not found.
[EMAIL PROTECTED] /u01/app/oracle/admin/ITCPRD01/udump]$
TM-0000203a-00000000 81 95 SX 164 59 S
ksh: TM-0000203a-00000000: not found.
[EMAIL PROTECTED] /u01/app/oracle/admin/ITCPRD01/udump]$
TM-00002045-00000000 164 59 SX 324 265 S
ksh: TM-00002045-00000000: not found.
[EMAIL PROTECTED] /u01/app/oracle/admin/ITCPRD01/udump]$
TM-0000203a-00000000 324 265 SX 231 86 S
ksh: TM-0000203a-00000000: not found.
[EMAIL PROTECTED] /u01/app/oracle/admin/ITCPRD01/udump]$ session 86: DID
0001-00E7-00000021 session 95: DID 0001-0051-0000001A
ksh: session: not found.
[EMAIL PROTECTED] /u01/app/oracle/admin/ITCPRD01/udump]$ session 95: DID
0001-0051-0000001A session 59: DID 0001-00A4-00000020
ksh: session: not found.
[EMAIL PROTECTED] /u01/app/oracle/admin/ITCPRD01/udump]$ session 59: DID
0001-00A4-00000020 session 265: DID 0001-0144-00000008
ksh: session: not found.
[EMAIL PROTECTED] /u01/app/oracle/admin/ITCPRD01/udump]$ session 265: DID
0001-0144-00000008 session 86: DID 0001-00E7-00000021
ksh: session: not found.
[EMAIL PROTECTED] /u01/app/oracle/admin/ITCPRD01/udump]$ Rows waited on:
ksh: Rows: not found.
[EMAIL PROTECTED] /u01/app/oracle/admin/ITCPRD01/udump]$ Session 95: obj -
rowid = 0000203E - AAACA+AAtAAAAAAAAA
ksh: Session: not found.
[EMAIL PROTECTED] /u01/app/oracle/admin/ITCPRD01/udump]$ (dictionary objn -
8254, file - 45, block - 0, slot - 0)
ksh: dictionary: not found.
[EMAIL PROTECTED] /u01/app/oracle/admin/ITCPRD01/udump]$ Session 59: obj -
rowid = 00002040 - AABM8qAAUAAAAAAAAA
ksh: Session: not found.
[EMAIL PROTECTED] /u01/app/oracle/admin/ITCPRD01/udump]$ (dictionary objn -
8256, file - 20, block - 0, slot - 0)
ksh: dictionary: not found.
[EMAIL PROTECTED] /u01/app/oracle/admin/ITCPRD01/udump]$ Session 265: obj -
rowid = 00035DA4 - AAA12kAAWAAAAAAAAA
ksh: Session: not found.
[EMAIL PROTECTED] /u01/app/oracle/admin/ITCPRD01/udump]$ (dictionary objn -
220580, file - 22, block - 0, slot - 0)
ksh: dictionary: not found.
[EMAIL PROTECTED] /u01/app/oracle/admin/ITCPRD01/udump]$ Session 86: obj -
rowid = 00001EB8 - AAAB64ABRAAAAAAAAA
ksh: Session: not found.
[EMAIL PROTECTED] /u01/app/oracle/admin/ITCPRD01/udump]$ (dictionary objn -
7864, file - 81, block - 0, slot - 0)
ksh: dictionary: not found.
[EMAIL PROTECTED] /u01/app/oracle/admin/ITCPRD01/udump]$ Information on the
OTHER waiting sessions:
ksh: Information: not found.
[EMAIL PROTECTED] /u01/app/oracle/admin/ITCPRD01/udump]$ Session 95:
ksh: Session: not found.
[EMAIL PROTECTED] /u01/app/oracle/admin/ITCPRD01/udump]$ pid=81 serial=1181
audsid=19919595 user: 2446/DDV
ksh: user:: not found.
[EMAIL PROTECTED] /u01/app/oracle/admin/ITCPRD01/udump]$ O/S info: user:
kmagalhaes_coop, term: SPO-1243, ospid: 1768:2060, machine: TRANSIT\SPO-1243
ksh: O/S: not found.
[EMAIL PROTECTED] /u01/app/oracle/admin/ITCPRD01/udump]$ program:
ksh: program:: not found.
[EMAIL PROTECTED] /u01/app/oracle/admin/ITCPRD01/udump]$ Current SQL
Statement:
ksh: Current: not found.
[EMAIL PROTECTED] /u01/app/oracle/admin/ITCPRD01/udump]$
[EMAIL PROTECTED] /u01/app/oracle/admin/ITCPRD01/udump]$
AUX_FILA_ATRIB,NOME_TMKT,TB_AUX_DESC_PROC,TB_AUX_ENDEREC
<
ksh: 0403-057 Syntax error: `(' is not expected.
[EMAIL PROTECTED] /u01/app/oracle/admin/ITCPRD01/udump]$ D_EMPRESA) VALUES
(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15)
<
ksh: 0403-057 Syntax error: `)' is not expected.
[EMAIL PROTECTED] /u01/app/oracle/admin/ITCPRD01/udump]$ Session 59:
ksh: Session: not found.
[EMAIL PROTECTED] /u01/app/oracle/admin/ITCPRD01/udump]$ pid=164 serial=3757
audsid=19920478 user: 2327/SHE
ksh: user:: not found.
[EMAIL PROTECTED] /u01/app/oracle/admin/ITCPRD01/udump]$ O/S info: user:
SYSTEM, term: WEBTRANS2, ospid: 9208:6116, machine: TRANSIT\WEBTRANS2
ksh: O/S: not found.
[EMAIL PROTECTED] /u01/app/oracle/admin/ITCPRD01/udump]$ program:
frmweb.exe
ksh: program:: not found.
[EMAIL PROTECTED] /u01/app/oracle/admin/ITCPRD01/udump]$ application name:
frmweb.exe, hash value=0
ksh: application: not found.
[EMAIL PROTECTED] /u01/app/oracle/admin/ITCPRD01/udump]$
[EMAIL PROTECTED] /u01/app/oracle/admin/ITCPRD01/udump]$
[EMAIL PROTECTED] /u01/app/oracle/admin/ITCPRD01/udump]$
[EMAIL PROTECTED] /u01/app/oracle/admin/ITCPRD01/udump]$
[EMAIL PROTECTED] /u01/app/oracle/admin/ITCPRD01/udump]$
[EMAIL PROTECTED] /u01/app/oracle/admin/ITCPRD01/udump]$ ls -ltr
total 434616
-rw-r----- 1 oracle dba 5028983 Sep 10 15:16
itcprd01_ora_7577964.trc
-rw-r----- 1 oracle dba 1399675 Sep 10 15:18
itcprd01_ora_7348572.trc
-rw-r----- 1 oracle dba 62543392 Sep 10 15:18
itcprd01_ora_7839756.trc
-rw-r----- 1 oracle dba 17903193 Sep 10 15:18
itcprd01_ora_7307762.trc
-rw-r----- 1 oracle dba 72790858 Sep 10 15:18
itcprd01_ora_7942272.trc
-rw-r----- 1 oracle dba 303587 Sep 10 15:31
itcprd01_ora_7553032.trc
-rw-r----- 1 oracle dba 193003 Sep 10 16:37
itcprd01_ora_7221544.trc
-rw-r----- 1 oracle dba 854847 Sep 10 16:37
itcprd01_ora_6959604.trc
-rw-r----- 1 oracle dba 61468948 Sep 10 16:37
itcprd01_ora_3907768.trc
[EMAIL PROTECTED] /u01/app/oracle/admin/ITCPRD01/udump]$ more
itcprd01_ora_7221544.trc
/u01/app/oracle/admin/ITCPRD01/udump/itcprd01_ora_7221544.trc
Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
ORACLE_HOME = /u01/app/oracle/product/9.2.0
System name: AIX
Node name: draco
Release: 3
Version: 5
Machine: 00C44EAF4C00
Instance name: ITCPRD01
Redo thread mounted by this instance: 1
Oracle process number: 81
Unix process pid: 7221544, image: [EMAIL PROTECTED] (TNS V1-V3)
*** 2008-09-10 16:37:24.298
*** SESSION ID:(95.1181) 2008-09-10 16:37:24.291
DEADLOCK DETECTED
Current SQL statement for this session:
INSERT INTO
SUB_AGENDAMENTO(DT_INST,MARCA_PABX,STATUS_INST,DATA_ATRI,DATA_VISITA,TB_AUX_DT_RETORNO,TB_AUX_FILA_ATRIB,NOME_TMKT,TB_AUX_DESC_PROC,TB_AUX_ENDEREC
O,TB_AUX_CNPJ,TB_AUX_SQ,TB_AUX_CD_VEND,COD_FILIAL,ID_EMPRESA) VALUES
(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15)
The following deadlock is not an ORACLE error. It is a
deadlock due to user error in the design of an application
or from issuing incorrect ad-hoc SQL. The following
information may aid in determining the deadlock:
Deadlock graph:
---------Blocker(s)-------- ---------Waiter(s)---------
Resource Name process session holds waits process session holds waits
TM-0000204e-00000000 81 95 SX 206 214 S
TM-0000203a-00000000 206 214 SX 231 86 S
TM-0000203a-00000000 231 86 S 81 95 SX
session 95: DID 0001-0051-0000001A session 214: DID 0001-00CE-00000021
session 214: DID 0001-00CE-00000021 session 86: DID 0001-00E7-00000021
session 86: DID 0001-00E7-00000021 session 95: DID 0001-0051-0000001A
Rows waited on:
Session 214: obj - rowid = 00035FC6 - AAA1/GAAPAAAAAAAAA
(dictionary objn - 221126, file - 15, block - 0, slot - 0)
Session 86: obj - rowid = 0000204A - AAACBKAAaAAAAAAAAA
(dictionary objn - 8266, file - 26, block - 0, slot - 0)
Session 95: obj - rowid = 00036A91 - AABM2LADcAAAAAAAAA
(dictionary objn - 223889, file - 220, block - 0, slot - 0)
Information on the OTHER waiting sessions:
Session 214:
pid=206 serial=2229 audsid=19924318 user: 2329/LUZ
O/S info: user: SYSTEM, term: WEBTRANS2, ospid: 4676:4144, machine:
TRANSIT\WEBTRANS2
program: frmweb.exe
application name: frmweb.exe, hash value=0
Current SQL Statement:
UPDATE DB_FILIAIS SET
TB_AUX_CNPJ=:1,COD_FILIAL=:2,DIGITO=:3,TP_ATIVACAO=:4,cd_vend=:5,protocolo=:6,USUARIO=:7,DT_PROTOCOLO=:8,CNPJ_CMP=:9,TB_AUX_DT_ATRIB_INI
=:10,TB_AUX_DT_ATRIB_FINAL=:11,TB_AUX_ATRIBUICAO=:12,TB_AUX_STATUS=:13,INSCR_EST=:14,DIA_VENCIMENTO=:15,ID_EMPRESA=:16,ID_PRODUTO=:17
WHERE ROWID=:18
Session 86:
pid=231 serial=1825 audsid=19922296 user: 2273/TRS
O/S info: user: SYSTEM, term: WEBTRANS2, ospid: 9016:7672, machine:
TRANSIT\WEBTRANS2
program: frmweb.exe
application name: frmweb.exe, hash value=0
Qualquer ajuda é bem vinda.
Obrigado, André
Novos endereços, o Yahoo! que você conhece. Crie um email novo com a sua
cara @ymail.com ou @rocketmail.com.
http://br.new.mail.yahoo.com/addresses
[As partes desta mensagem que não continham texto foram removidas]
