[jboss-jira] [JBoss JIRA] Updated: (JBMESSAGING-1162) JBM takes eons to startup with topic persisted messages within db

[Tim Fox (JIRA)]

     [ http://jira.jboss.com/jira/browse/JBMESSAGING-1162?page=all ]

Tim Fox updated JBMESSAGING-1162:
---------------------------------

    Fix Version/s:  1.4.0.SP3.CP04
                       (was: Unscheduled)

> JBM takes eons to startup with topic persisted messages within db
> -----------------------------------------------------------------
>
>                 Key: JBMESSAGING-1162
>                 URL: http://jira.jboss.com/jira/browse/JBMESSAGING-1162
>             Project: JBoss Messaging
>          Issue Type: Bug
>          Components: Messaging Core Persistence
>    Affects Versions: 1.4.0.SP1
>         Environment: Java 1.5.0_14
> JBoss 4.2.2
> Solaris 10, AMD Opteron biprocessor machine
>            Reporter: Gabriele Garuglieri
>         Assigned To: Tim Fox
>            Priority: Critical
>             Fix For:  1.4.0.SP3.CP04
>
>
> The problem is reproduced as follows:
> 1-Start server
> 2-start a producer that inserts persisted messages (we tried 90.000 messages) in TestTopic topic with default configuration where there are some consumers subscribed but not active
> 3-stop producer and orderly shutdown the server
> 4-start server
> During server startup JBM executes a select to load the persisted messages id's then executes 180 selects loading 500 messages at time.
> With 90.000 messages those 180 selects takes about 10 minutes. The DBMS is Oracle 10g with dedicated instance on a separate machine with no more than 1% cpu load during test and physical db on a very fast NAS.
> While JBM is executing those selects, obviously the server startup hangs until the load is finished.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira