[jboss-jira] [JBoss JIRA] Commented: (JBMESSAGING-1780) When i change the default db schemas of jbm tables the DLQ - if it contains message - run in deadlock by the next server restart, because it wants to use the default schema instead of the modified db schema

[Howard Gao (JIRA)]

    [ https://jira.jboss.org/browse/JBMESSAGING-1780?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12538723#action_12538723 ] 

Howard Gao commented on JBMESSAGING-1780:
-----------------------------------------

Hi Karl,

Can you please upload your mysql-persistence-service.xml here? Thanks

Howard


> When i change the default db schemas of jbm tables the DLQ - if it contains message -  run in deadlock by the next server restart, because it wants to use the default schema instead of the modified db schema 
> ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: JBMESSAGING-1780
>                 URL: https://jira.jboss.org/browse/JBMESSAGING-1780
>             Project: JBoss Messaging
>          Issue Type: Bug
>    Affects Versions: 1.4.0.SP3.CP09, 1.4.5.GA, 1.4.6.GA
>         Environment: JBoss 5.1.GA+Seam 2.1.1.GA+mysql 5.1
>            Reporter: Karl Max
>            Assignee: Howard Gao
>             Fix For: 1.4.0.SP3.CP11, 1.4.8.GA
>
>
> At first, I modified the default schema of jbm tables in mysql-persistence-service.xml
> so, I changed the sql properties  JBM_DUAL to  newSchema.JBM_DUAL and so on...
> Everything works fine with the modified schema, until I add a posion message to the dead letter queue.
> Then I want to restart the JBoss server, I get an exception to it run in dead lock, because didn't find the jbm_msg tables (but it would be newSchema.jbm_msg  )

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