With the new code base (Version 505417), I'm getting a new exception as "Timeout when waiting for response to MEX null"
This happened after 2 minutes of waiting. Here is the debug trace from Geronimo.log. ---------------------------------------- 14:02:16,847 DEBUG [SessionOutHandler] Sending stateful TO epr in message header using session null 14:02:16,847 DEBUG [SessionOutHandler] Sending a message containing wsa endpoints in headers for session passing. 14:02:16,847 DEBUG [SessionOutHandler] <?xml version='1.0' encoding='utf-8'?><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/";><soapenv:Header> <addr:To xmlns:addr="http://www.w3.org/2005/08/addressing";>http://10.23.1.199:8080/ SimpleWebService/services/SimpleServices</addr:To><addr:Action xmlns:addr="http://www.w3.org/2005/08/addressing";></addr:Action></soapenv: Header><soapenv:Body><axis2ns2:addNumbers xmlns:tns="http://ws.sdc.maximus.com"; xmlns:axis2ns2="http://ws.sdc.maximus.com"; xmlns="http://ws.sdc.maximus.com";> <Number1>11</Number1> <Number2>22</Number2> </axis2ns2:addNumbers></soapenv:Body></soapenv:Envelope> 14:02:16,847 DEBUG [Phase] Checking post-conditions for phase "ProcessHeader" 14:02:16,847 DEBUG [Phase] Checking pre-condition for Phase "soapmonitorPhase" 14:02:16,847 DEBUG [Phase] Invoking phase "soapmonitorPhase" 14:02:16,847 DEBUG [Phase] Checking post-conditions for phase "soapmonitorPhase" 14:02:16,847 DEBUG [Phase] Checking pre-condition for Phase "OperationOutPhase" 14:02:16,847 DEBUG [Phase] Invoking phase "OperationOutPhase" 14:02:16,847 DEBUG [Phase] Checking post-conditions for phase "OperationOutPhase" 14:02:16,847 DEBUG [Phase] Checking pre-condition for Phase "PolicyDetermination" 14:02:16,847 DEBUG [Phase] Invoking phase "PolicyDetermination" 14:02:16,847 DEBUG [Phase] Checking post-conditions for phase "PolicyDetermination" 14:02:16,847 DEBUG [Phase] Checking pre-condition for Phase "MessageOut" 14:02:16,847 DEBUG [Phase] Invoking phase "MessageOut" 14:02:16,847 DEBUG [Phase] Checking post-conditions for phase "MessageOut" 14:02:16,847 DEBUG [Phase] Checking pre-condition for Phase "Security" 14:02:16,847 DEBUG [Phase] Invoking phase "Security" 14:02:16,847 DEBUG [Phase] Checking post-conditions for phase "Security" 14:02:17,160 DEBUG [Phase] Checking pre-condition for Phase "Transport" 14:02:17,160 DEBUG [Phase] Invoking phase "Transport" 14:02:17,160 DEBUG [Phase] Invoking Handler 'RequestURIBasedDispatcher' in Phase 'Transport' 14:02:17,160 DEBUG [Phase] Invoking Handler 'SOAPActionBasedDispatcher' in Phase 'Transport' 14:02:17,160 DEBUG [Phase] Checking post-conditions for phase "Transport" 14:02:17,160 DEBUG [Phase] Checking pre-condition for Phase "Security" 14:02:17,160 DEBUG [Phase] Invoking phase "Security" 14:02:17,160 DEBUG [Phase] Checking post-conditions for phase "Security" 14:02:17,160 DEBUG [Phase] Checking pre-condition for Phase "PreDispatch" 14:02:17,160 DEBUG [Phase] Invoking phase "PreDispatch" 14:02:17,160 DEBUG [Phase] Checking post-conditions for phase "PreDispatch" 14:02:17,160 DEBUG [Phase] Checking pre-condition for Phase "Dispatch" 14:02:17,160 DEBUG [Phase] Invoking phase "Dispatch" 14:02:17,160 DEBUG [Phase] Invoking Handler 'ODEAxisDispatcher' in Phase 'Dispatch' 14:02:17,160 DEBUG [Phase] Invoking Handler 'InstanceDispatcher' in Phase 'Dispatch' 14:02:17,160 DEBUG [Phase] Checking post-conditions for phase "Dispatch" 14:02:17,160 DEBUG [Phase] Checking pre-condition for Phase "OperationInPhase" 14:02:17,160 DEBUG [Phase] Invoking phase "OperationInPhase" 14:02:17,160 DEBUG [Phase] Checking post-conditions for phase "OperationInPhase" 14:02:17,160 DEBUG [Phase] Checking pre-condition for Phase "soapmonitorPhase" 14:02:17,160 DEBUG [Phase] Invoking phase "soapmonitorPhase" 14:02:17,160 DEBUG [Phase] Checking post-conditions for phase "soapmonitorPhase" 14:02:17,176 DEBUG [QuartzSchedulerImpl] Starting transaction. 14:02:17,176 DEBUG [sql] getConnection (tx=2) 14:02:17,176 DEBUG [sql] prepareStmt: select hibernate_sequence.nextval from dual 14:02:17,176 DEBUG [sql] close 14:02:17,176 DEBUG [ExternalService] Received response for MEX {PartnerRoleMex#1572 [PID {http://sdc.maximus.com/Process1/SimpleProcess}SimpleProcess-4] calling [EMAIL PROTECTED](...)} 14:02:17,176 DEBUG [sql] getConnection (tx=2) 14:02:17,176 DEBUG [sql] prepareStmt: select hibernate_sequence.nextval from dual 14:02:17,176 DEBUG [sql] close 14:02:17,176 DEBUG [ExternalService] RESPONSE (NORMAL): <?xml version="1.0" encoding="UTF-8"?> <message><parameters><addNumbersResponse xmlns="http://ws.sdc.maximus.com"; xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"; xmlns:xsd="http://www.w3.org/2001/XMLSchema"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";><out xmlns="http://ws.sdc.maximus.com";>33</out></addNumbersResponse></parameter s></message> 14:02:17,191 DEBUG [sql] getConnection (tx=2) 14:02:17,191 DEBUG [JobStoreJTA] prepareStmt: SELECT JOB_NAME FROM QRTZ_JOB_DETAILS WHERE JOB_NAME = ? AND JOB_GROUP = ? 14:02:17,191 DEBUG [sql] prepareStmt: SELECT JOB_NAME FROM QRTZ_JOB_DETAILS WHERE JOB_NAME = ? AND JOB_GROUP = ? 14:02:17,191 DEBUG [JobStoreJTA] bound (2,DEFAULT) (1,1e0nnrw0413chbme92nrva) 14:02:17,191 DEBUG [sql] bound (2,DEFAULT) (1,1e0nnrw0413chbme92nrva) 14:02:17,191 DEBUG [JobStoreJTA] prepareStmt: INSERT INTO QRTZ_JOB_DETAILS (JOB_NAME, JOB_GROUP, DESCRIPTION, JOB_CLASS_NAME, IS_DURABLE, IS_VOLATILE, IS_STATEFUL, REQUESTS_RECOVERY, JOB_DATA) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?) 14:02:17,191 DEBUG [sql] prepareStmt: INSERT INTO QRTZ_JOB_DETAILS (JOB_NAME, JOB_GROUP, DESCRIPTION, JOB_CLASS_NAME, IS_DURABLE, IS_VOLATILE, IS_STATEFUL, REQUESTS_RECOVERY, JOB_DATA) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?) 14:02:17,191 DEBUG [JobStoreJTA] bound (2,DEFAULT) (4,org.apache.ode.bpel.scheduler.quartz.JobImpl) (9,[EMAIL PROTECTED]) (8,true) (6,false) (1,1e0nnrw0413chbme92nrva) (3,(7,false) (5,false) 14:02:17,191 DEBUG [sql] bound (2,DEFAULT) (4,org.apache.ode.bpel.scheduler.quartz.JobImpl) (9,[EMAIL PROTECTED]) (8,true) (6,false) (1,1e0nnrw0413chbme92nrva) (3,(7,false) (5,false) 14:02:17,191 DEBUG [JobStoreJTA] prepareStmt: SELECT TRIGGER_NAME FROM QRTZ_TRIGGERS WHERE TRIGGER_NAME = ? AND TRIGGER_GROUP = ? 14:02:17,191 DEBUG [sql] prepareStmt: SELECT TRIGGER_NAME FROM QRTZ_TRIGGERS WHERE TRIGGER_NAME = ? AND TRIGGER_GROUP = ? 14:02:17,191 DEBUG [JobStoreJTA] bound (2,DEFAULT) (1,1e0nnrw0413chbme92nrva.trigger) 14:02:17,191 DEBUG [sql] bound (2,DEFAULT) (1,1e0nnrw0413chbme92nrva.trigger) 14:02:17,191 DEBUG [JobStoreJTA] prepareStmt: SELECT TRIGGER_GROUP FROM QRTZ_PAUSED_TRIGGER_GRPS WHERE TRIGGER_GROUP = ? 14:02:17,191 DEBUG [sql] prepareStmt: SELECT TRIGGER_GROUP FROM QRTZ_PAUSED_TRIGGER_GRPS WHERE TRIGGER_GROUP = ? 14:02:17,191 DEBUG [JobStoreJTA] bound (1,DEFAULT) 14:02:17,191 DEBUG [sql] bound (1,DEFAULT) 14:02:17,191 DEBUG [JobStoreJTA] prepareStmt: SELECT TRIGGER_GROUP FROM QRTZ_PAUSED_TRIGGER_GRPS WHERE TRIGGER_GROUP = ? 14:02:17,191 DEBUG [sql] prepareStmt: SELECT TRIGGER_GROUP FROM QRTZ_PAUSED_TRIGGER_GRPS WHERE TRIGGER_GROUP = ? 14:02:17,191 DEBUG [JobStoreJTA] bound (1,_$_ALL_GROUPS_PAUSED_$_) 14:02:17,191 DEBUG [sql] bound (1,_$_ALL_GROUPS_PAUSED_$_) 14:02:17,191 DEBUG [JobStoreJTA] prepareStmt: INSERT INTO QRTZ_TRIGGERS (TRIGGER_NAME, TRIGGER_GROUP, JOB_NAME, JOB_GROUP, IS_VOLATILE, DESCRIPTION, NEXT_FIRE_TIME, PREV_FIRE_TIME, TRIGGER_STATE, TRIGGER_TYPE, START_TIME, END_TIME, CALENDAR_NAME, MISFIRE_INSTR, JOB_DATA) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 14:02:17,191 DEBUG [sql] prepareStmt: INSERT INTO QRTZ_TRIGGERS (TRIGGER_NAME, TRIGGER_GROUP, JOB_NAME, JOB_GROUP, IS_VOLATILE, DESCRIPTION, NEXT_FIRE_TIME, PREV_FIRE_TIME, TRIGGER_STATE, TRIGGER_TYPE, START_TIME, END_TIME, CALENDAR_NAME, MISFIRE_INSTR, JOB_DATA) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 14:02:17,191 DEBUG [JobStoreJTA] bound (15,(4,DEFAULT) (8,-1) (11,1171047737191) (3,1e0nnrw0413chbme92nrva) (7,1171047737191) (12,0) (2,DEFAULT) (13,(9,WAITING) (6,(1,1e0nnrw0413chbme92nrva.trigger) (14,0) (10,SIMPLE) (5,false) 14:02:17,191 DEBUG [sql] bound (15,(4,DEFAULT) (8,-1) (11,1171047737191) (3,1e0nnrw0413chbme92nrva) (7,1171047737191) (12,0) (2,DEFAULT) (13,(9,WAITING) (6,(1,1e0nnrw0413chbme92nrva.trigger) (14,0) (10,SIMPLE) (5,false) 14:02:17,191 DEBUG [JobStoreJTA] prepareStmt: INSERT INTO QRTZ_SIMPLE_TRIGGERS (TRIGGER_NAME, TRIGGER_GROUP, REPEAT_COUNT, REPEAT_INTERVAL, TIMES_TRIGGERED) VALUES(?, ?, ?, ?, ?) 14:02:17,191 DEBUG [sql] prepareStmt: INSERT INTO QRTZ_SIMPLE_TRIGGERS (TRIGGER_NAME, TRIGGER_GROUP, REPEAT_COUNT, REPEAT_INTERVAL, TIMES_TRIGGERED) VALUES(?, ?, ?, ?, ?) 14:02:17,191 DEBUG [JobStoreJTA] bound (2,DEFAULT) (4,0) (1,1e0nnrw0413chbme92nrva.trigger) (3,0) (5,0) 14:02:17,191 DEBUG [sql] bound (2,DEFAULT) (4,0) (1,1e0nnrw0413chbme92nrva.trigger) (3,0) (5,0) 14:02:17,191 DEBUG [JobStoreJTA] close 14:02:17,191 DEBUG [sql] close 14:02:17,191 DEBUG [QuartzSchedulerImpl] Commiting transaction. 14:02:17,191 DEBUG [sql] getConnection (tx=2) 14:02:17,207 DEBUG [sql] prepareStmt: insert into BPEL_MESSAGE (MEX, TYPE, DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?, ?, ?) 14:02:17,207 DEBUG [sql] bound (2,{http://ws.sdc.maximus.com}addNumbersResponse) (4,2007-02-09 14:02:17.176) (6,1577) (1,1572) (3,null) (5,0) 14:02:17,207 DEBUG [sql] close 14:02:17,207 DEBUG [sql] getConnection (tx=2) 14:02:17,207 DEBUG [sql] prepareStmt: insert into LARGE_DATA (BIN_DATA, INSERT_TIME, MLOCK, ID) values (?, ?, ?, ?) 14:02:17,207 DEBUG [sql] bound (2,null) (4,1578) (1,[EMAIL PROTECTED]) (3,0) 14:02:17,207 DEBUG [sql] close 14:02:17,207 DEBUG [sql] getConnection (tx=2) 14:02:17,207 DEBUG [sql] prepareStmt: update BPEL_MESSAGE set MEX=?, TYPE=?, DATA=?, INSERT_TIME=?, MLOCK=? where ID=? 14:02:17,207 DEBUG [sql] bound (2,{http://ws.sdc.maximus.com}addNumbersResponse) (4,2007-02-09 14:02:17.176) (6,1577) (1,1572) (3,1578) (5,0) 14:02:17,207 DEBUG [sql] close 14:02:17,207 DEBUG [sql] getConnection (tx=2) 14:02:17,207 DEBUG [sql] prepareStmt: update BPEL_MESSAGE_EXCHANGE set PORT_TYPE=?, CHANNEL_NAME=?, CLIENTKEY=?, LDATA_EPR_ID=?, LDATA_CEPR_ID=?, REQUEST=?, RESPONSE=?, INSERT_DT=?, OPERATION=?, STATE=?, PROCESS=?, PIID=?, DIR=?, PLINK_MODELID=?, PATTERN=?, CORR_STATUS=?, FAULT_TYPE=?, FAULT_EXPL=?, CALLEE=?, PARTNERLINK=?, INSERT_TIME=?, MLOCK=? where ID=? 14:02:17,207 DEBUG [sql] bound (15,REQUEST_RESPONSE) (4,1575) (19,null) (8,null) (23,1572) (11,1512) (16,null) (18,null) (3,null) (7,1577) (12,1516) (22,0) (17,null) (2,20) (13,P) (9,addNumbers) (21,null) (6,1573) (1,{http://ws.sdc.maximus.com}SimpleServicesPortType) (20,1521) (14,20) (10,RESPONSE) (5,null) 14:02:17,207 DEBUG [sql] close 14:04:17,176 DEBUG [ODEService] Handling response for MEX null 14:04:17,176 ERROR [ODEService] Timeout when waiting for response to MEX null 14:04:17,176 DEBUG [AxisServlet] org.apache.axis2.AxisFault: Message was either unroutable or timed out! 14:04:17,176 DEBUG [AddressingHelper] isReplyRedirected: FaultTo is null. Returning isReplyRedirected 14:04:17,176 DEBUG [AddressingHelper] isReplyRedirected: ReplyTo is null. Returning false 14:04:17,207 DEBUG [Phase] Checking pre-condition for Phase "soapmonitorPhase" 14:04:17,207 DEBUG [Phase] Invoking phase "soapmonitorPhase" 14:04:17,207 DEBUG [Phase] Checking post-conditions for phase "soapmonitorPhase" 14:04:17,207 DEBUG [Phase] Checking pre-condition for Phase "OperationOutFaultPhase" 14:04:17,207 DEBUG [Phase] Invoking phase "OperationOutFaultPhase" 14:04:17,207 DEBUG [Phase] Checking post-conditions for phase "OperationOutFaultPhase" 14:04:17,207 DEBUG [Phase] Checking pre-condition for Phase "PolicyDetermination" 14:04:17,207 DEBUG [Phase] Invoking phase "PolicyDetermination" 14:04:17,207 DEBUG [Phase] Checking post-conditions for phase "PolicyDetermination" 14:04:17,207 DEBUG [Phase] Checking pre-condition for Phase "MessageOut" 14:04:17,222 DEBUG [Phase] Invoking phase "MessageOut" 14:04:17,222 DEBUG [Phase] Checking post-conditions for phase "MessageOut" ---------------------------------------- If anybody has an idea of why this happens, please let me know. I will try your suggestion. Thank you Raja -----Original Message----- From: Matthieu Riou [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 07, 2007 6:45 PM To: [email protected] Subject: Re: Using ODE with ORACLE and Geronimo Hi Raja, This seems to indicate as deadlock as well. I don't have much time for now to look at your scenario but I've been able to run highly concurrent scenarios on Oracle without deadlocks. Usually Oracle is pretty good with its locks. You can try to see which queries are conflicting and what executes them. If you can spot where this comes from the correction would be easier. Cheers, Matthieu On 2/7/07, Raja Balasubramanian/MAXIMUS <[EMAIL PROTECTED]> wrote: > > Hi Matthieu, > > Today I did additional round of debugging and following are the result. > 1. Ode engine calls ExternalService.reply(odeMex, reply) method. (Line > 225) > 2. reply() calls odeMex.reply(response) > 3. Finally it calls (after going through PartnerRoleMessageExchangeImpl, > MessageExchangeImpl) QuartzSchedulerImpl. execTransaction(transaction) > (Line 221) > 4. In execTransaction() it makes a call to commit(); (Line 241) > 5. commit() makes a call to TransactionManager.commit() (Line 278) > 6. Then it goes to GeronimoTransactionManager.commit() > (In Jencks 1.3 Line 74[using jencks-1.3.jar]) > 7. At Line #81 in GeronimoTransactionManager.commit() while executing > !beanContext.commit(), the whole thread stack dies! > No records got committed into database. > > Does this ring any bell to you? > > Thank you > Raja > > -----Original Message----- > From: Matthieu Riou [mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 06, 2007 5:10 PM > To: [email protected] > Subject: Re: Using ODE with ORACLE and Geronimo > > Hi Raja, > > I had a look at your log and while having the Hibernate queries is useful, > it's not quite enough to diagnose. I've committed the usage a wrapper > around > the datasource we use in the JBI impl. Just update your code and enable > all > the following categories: > > org.apache.ode.sql > org.apache.ode.bpel.engine > org.apache.ode.bpel.scheduler.quartz > org.apache.ode.axis2 > > This should give us more information about the data being locked and where > the contention is. > > Thanks, > Matthieu > > On 2/5/07, Raja Balasubramanian/MAXIMUS <[EMAIL PROTECTED]> > wrote: > > > > Hi Matthieu, > > > > As you described, I have configured my Oracle database. > > Removed all the foreign key constraints and added the indexes. > > But it resulted in the same dead lock situation. I have created a new > Jira > > issue for that (ODE-96). > > Ode recreates some of the constraints based on Hibernate configuration > > while startup. > > > > If you have any suggestions, please let me know. I will try. > > > > Thank you > > Raja > > > > -----Original Message----- > > From: Matthieu Riou [mailto:[EMAIL PROTECTED] > > Sent: Friday, February 02, 2007 1:13 PM > > To: [email protected] > > Subject: Re: Using ODE with ORACLE and Geronimo > > > > Yep, tracking this with an issue would be better. > > > > You can also try to remove ALL foreign key constraints and add the > indexes > > pasted below. That should solve most database related deadlocks. > > > > create index IDX_XMLDATA_IID on BPEL_XML_DATA (PIID); > > create index IDX_XMLDATA_SID on BPEL_XML_DATA (SCOPE_ID); > > create index IDX_XMLDATA_NAME on BPEL_XML_DATA (NAME); > > create index IDX_XMLDATA_NAME_SID on BPEL_XML_DATA (NAME, SCOPE_ID); > > > > create index IDX_EVENT_IID on BPEL_EVENT (IID); > > create index IDX_EVENT_PID on BPEL_EVENT (PID); > > > > create index IDX_QRTZ_SIMTRIG_NAME on QRTZ_SIMPLE_TRIGGERS > (TRIGGER_NAME); > > create index IDX_QRTZ_SIMTRIG_GRP on QRTZ_SIMPLE_TRIGGERS > (TRIGGER_GROUP); > > create index IDX_QRTZ_FIRTRIG_NAME on QRTZ_FIRED_TRIGGERS > (TRIGGER_NAME); > > create index IDX_QRTZ_FIRTRIG_GRP on QRTZ_FIRED_TRIGGERS > (TRIGGER_GROUP); > > create index IDX_QRTZ_FIRTRIG_INST on QRTZ_FIRED_TRIGGERS > (INSTANCE_NAME); > > create index IDX_QRTZ_FIRTRIG_ENTRY on QRTZ_FIRED_TRIGGERS (ENTRY_ID); > > create index IDX_QRTZ_TRIG_NAME on QRTZ_TRIGGERS (TRIGGER_NAME); > > create index IDX_QRTZ_TRIG_GRP on QRTZ_TRIGGERS (TRIGGER_GROUP); > > create index IDX_QRTZ_TRIG_NAME_GRP on QRTZ_TRIGGERS (TRIGGER_NAME, > > TRIGGER_GROUP); > > create index IDX_QRTZ_SIMTRIG_NAME_GRP on QRTZ_SIMPLE_TRIGGERS > > (TRIGGER_NAME, TRIGGER_GROUP); > > create index IDX_QRTZ_FIRTRIG_NAME_GRP on QRTZ_FIRED_TRIGGERS > > (TRIGGER_NAME, > > TRIGGER_GROUP); > > > > create index idx_qrtz_t_next_fire_time on QRTZ_TRIGGERS(NEXT_FIRE_TIME); > > create index idx_qrtz_t_state on QRTZ_TRIGGERS(TRIGGER_STATE); > > create index idx_qrtz_t_nf_st on > > QRTZ_TRIGGERS(TRIGGER_STATE,NEXT_FIRE_TIME); > > create index idx_qrtz_ft_job_name on QRTZ_FIRED_TRIGGERS(JOB_NAME); > > create index idx_qrtz_ft_job_group on QRTZ_FIRED_TRIGGERS(JOB_GROUP); > > > > create index IDX_CORR_SET_NAME on BPEL_CORRELATION_SET (CORR_SET_NAME); > > create index IDX_CORR_SET_SCOPE_ID on BPEL_CORRELATION_SET (SCOPE_ID); > > create index IDX_BPEL_INSTANCE_PROCESS_ID on BPEL_INSTANCE (PROCESS_ID); > > create index IDX_BPEL_INSTANCE_STATE on BPEL_INSTANCE (STATE); > > create index IDX_BPEL_PROCESS_PROCID on BPEL_PROCESS (PROCID); > > create index IDX_BPEL_PROCESS_TYPE_NAME on BPEL_PROCESS (type_name); > > create index IDX_BPEL_PROCESS_TYPE_NS on BPEL_PROCESS (type_ns); > > create index IDX_BPEL_CORRELATOR_PROCESS_ID on BPEL_CORRELATOR > > (PROCESS_ID); > > create index IDX_BPEL_CORRELATOR_CID on BPEL_CORRELATOR (CID); > > create index IDX_BPEL_CORRELATOR_MESSAGE_CKEY on > > BPEL_CORRELATOR_MESSAGE_CKEY (CKEY); > > create index IDX_SELECTOR_CORRELATOR on BPEL_SELECTORS > > (CORRELATOR,CORRELATION_KEY); > > create index IDX_SELECTOR_CKEY on BPEL_SELECTORS (CORRELATION_KEY); > > create index IDX_SELECTOR_SELGRPID on BPEL_SELECTORS (SELGRPID); > > create index IDX_UNMATCHED_CKEY on BPEL_UNMATCHED (CORRELATION_KEY); > > create index IDX_UNMATCHED_CORRELATOR_CKEY on BPEL_UNMATCHED > > (CORRELATOR,CORRELATION_KEY); > > create index IDX_RECOVERY_LDATAID on BPEL_ACTIVITY_RECOVERY (LDATA_ID); > > create index IDX_EVENT_LDATAID on BPEL_EVENT (LDATA_ID); > > create index IDX_FAULT_LDATAID on BPEL_FAULT (LDATA_ID); > > create index IDX_MESSAGE_LDATAID on BPEL_MESSAGE (DATA); > > create index IDX_INSTANCE_LDATAID on BPEL_INSTANCE (JACOB_STATE); > > create index IDX_MEXCEPR_LDATAID on BPEL_MESSAGE_EXCHANGE > (LDATA_CEPR_ID); > > create index IDX_MEXEPR_LDATAID on BPEL_MESSAGE_EXCHANGE (LDATA_EPR_ID); > > create index IDX_PLINK_VAL_PROCESS_IDX on BPEL_PLINK_VAL (PROCESS); > > create index IDX_PLINK_VAL_SCOPE on BPEL_PLINK_VAL (SCOPE); > > create index IDX_PLINKMYR_LDATAID on BPEL_PLINK_VAL (MYROLE_EPR); > > create index IDX_PLINKPR_LDATAID on BPEL_PLINK_VAL (PARTNERROLE_EPR); > > create index IDX_XMLDATA_LDATAID on BPEL_PLINK_VAL (PARTNERROLE_EPR); > > create index IDX_PLINK_VAL_MODELID on BPEL_PLINK_VAL (MODELID); > > create index IDX_UNMATCHED_CORRELATOR on BPEL_UNMATCHED (CORRELATOR); > > create index IDX_XML_DATA_SCOPE on BPEL_XML_DATA (SCOPE_ID); > > create index IDX_SELECTOR_INSTANCE on BPEL_SELECTORS (PIID); > > create index IDX_VARPROP_XMLDATA on VAR_PROPERTY (XML_DATA_ID); > > create index IDX_VARPROP_NAME on VAR_PROPERTY (PROP_NAME); > > create index IDX_VARPROP_VALUE on VAR_PROPERTY (PROP_VALUE); > > > > Cheers, > > > > Matthieu > > > > On 2/2/07, Maciej Szefler <[EMAIL PROTECTED]> wrote: > > > > > > Raja, > > > > > > This looks like a deadlock issue. Also if you could, (a) set oracle's > > > deadlock timeout to some short period (5 sec) and run to see what > > happens, > > > or (b) query oracle's lock table once the system hangs and include the > > > output. Also if you run with logging at the debug level (esp wrt to > > > hibernate SQL calls), the output could be very helpful. Also, it'd be > > best > > > if you file an issue for this. > > > > > > Thanks, > > > -mbs > > > > > > On 2/2/07, Raja Balasubramanian/MAXIMUS > > <[EMAIL PROTECTED]> > > > wrote: > > > > > > > > Hi All, > > > > > > > > I'm trying to use ODE in Geronimo with ORACLE 10g as back end. > > > > ODE in Geronimo with MySQL works like a charm. > > > > > > > > I have created ORACLE schema and created a connection pool for that > > and > > > > mapped in web.xml and geronimo-web.xml. > > > > > > > > ODE deployment went fine and BPEL deployments went fine. > > > > But when I invoke a process (which calls another web service), it > just > > > > hangs. No exceptions, but waiting for something indefinitely. > > > > > > > > Anybody faced this problem? > > > > Could somebody show me how to overcome this? > > > > > > > > Thank you > > > > > > > > Raja > > > > > > > > > >
