[JBoss JIRA] Created: (JBMESSAGING-1037) JDBCPersistenceManager.java - reference should be inserted after message (ORA-02291: integrity constraint)
11:50 a.m.
JDBCPersistenceManager.java - reference should be inserted after message (ORA-02291:
integrity constraint)
----------------------------------------------------------------------------------------------------------
Key: JBMESSAGING-1037
URL: http://jira.jboss.com/jira/browse/JBMESSAGING-1037
Project: JBoss Messaging
Issue Type: Patch
Components: Messaging Core Persistence
Affects Versions: 1.4.0.CR1
Environment: Windows XP / Oracle 10g
Reporter: Mariusz Olejnik
Assigned To: Tim Fox
Priority: Critical
Fix For: 1.4.0.CR1
Reference should be inserted after message because:
oracle-persistence-service.xml
CREATE TABLE JBM_MSG_REF (
CHANNEL_ID INTEGER,
MESSAGE_ID INTEGER REFERENCES JBM_MSG(MESSAGE_ID)
[...]
--
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
11:53 a.m.
New subject: [JBoss JIRA] Updated: (JBMESSAGING-1037) JDBCPersistenceManager.java - reference should be inserted after message (ORA-02291: integrity constraint)
[ http://jira.jboss.com/jira/browse/JBMESSAGING-1037?page=all ]
Mariusz Olejnik updated JBMESSAGING-1037:
-----------------------------------------
Attachment: jboss-messaging-trunk-rev2988.patch
addReference(channelID, ref, psReference, false);
^
|
v
updateWithRetry(psMessage);
JDBCPersistenceManager.java - reference should be inserted after
message (ORA-02291: integrity constraint)
----------------------------------------------------------------------------------------------------------
Key: JBMESSAGING-1037
URL: http://jira.jboss.com/jira/browse/JBMESSAGING-1037
Project: JBoss Messaging
Issue Type: Patch
Components: Messaging Core Persistence
Affects Versions: 1.4.0.CR1
Environment: Windows XP / Oracle 10g
Reporter: Mariusz Olejnik
Assigned To: Tim Fox
Priority: Critical
Fix For: 1.4.0.CR1
Attachments: jboss-messaging-trunk-rev2988.patch
Reference should be inserted after message because:
oracle-persistence-service.xml
CREATE TABLE JBM_MSG_REF (
CHANNEL_ID INTEGER,
MESSAGE_ID INTEGER REFERENCES JBM_MSG(MESSAGE_ID)
[...]
--
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
9:07 a.m.
New subject: [JBoss JIRA] Commented: (JBMESSAGING-1037) JDBCPersistenceManager.java - reference should be inserted after message (ORA-02291: integrity constraint)
[ http://jira.jboss.com/jira/browse/JBMESSAGING-1037?page=comments#action_1... ]
Gabriele Garuglieri commented on JBMESSAGING-1037:
--------------------------------------------------
Being bitten by the same problem with Postgres.
1.4.0.CR1 looks to be completely unusable because it fails with constraint violation as
soon as i try to send a message.
JDBCPersistenceManager.java - reference should be inserted after
message (ORA-02291: integrity constraint)
----------------------------------------------------------------------------------------------------------
Key: JBMESSAGING-1037
URL: http://jira.jboss.com/jira/browse/JBMESSAGING-1037
Project: JBoss Messaging
Issue Type: Patch
Components: Messaging Core Persistence
Affects Versions: 1.4.0.CR1
Environment: Windows XP / Oracle 10g
Reporter: Mariusz Olejnik
Assigned To: Tim Fox
Priority: Critical
Fix For: 1.4.0.CR1
Attachments: jboss-messaging-trunk-rev2988.patch
Reference should be inserted after message because:
oracle-persistence-service.xml
CREATE TABLE JBM_MSG_REF (
CHANNEL_ID INTEGER,
MESSAGE_ID INTEGER REFERENCES JBM_MSG(MESSAGE_ID)
[...]
--
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
12:30 p.m.
New subject: [JBoss JIRA] Closed: (JBMESSAGING-1037) JDBCPersistenceManager.java - reference should be inserted after message (ORA-02291: integrity constraint)
[ http://jira.jboss.com/jira/browse/JBMESSAGING-1037?page=all ]
Tim Fox closed JBMESSAGING-1037.
--------------------------------
Resolution: Rejected
1.4.0.CR1 is *MySQL only* - this was explained in the forums.
1.4.0.CR2 is tested with Oracle.
JDBCPersistenceManager.java - reference should be inserted after
message (ORA-02291: integrity constraint)
----------------------------------------------------------------------------------------------------------
Key: JBMESSAGING-1037
URL: http://jira.jboss.com/jira/browse/JBMESSAGING-1037
Project: JBoss Messaging
Issue Type: Patch
Components: Messaging Core Persistence
Affects Versions: 1.4.0.CR1
Environment: Windows XP / Oracle 10g
Reporter: Mariusz Olejnik
Assigned To: Tim Fox
Priority: Critical
Fix For: 1.4.0.CR1
Attachments: jboss-messaging-trunk-rev2988.patch
Reference should be inserted after message because:
oracle-persistence-service.xml
CREATE TABLE JBM_MSG_REF (
CHANNEL_ID INTEGER,
MESSAGE_ID INTEGER REFERENCES JBM_MSG(MESSAGE_ID)
[...]
--
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
12:51 p.m.
New subject: [JBoss JIRA] Commented: (JBMESSAGING-1037) JDBCPersistenceManager.java - reference should be inserted after message (ORA-02291: integrity constraint)
[
https://issues.jboss.org/browse/JBMESSAGING-1037?page=com.atlassian.jira....
]
Prashanto Chatterjee commented on JBMESSAGING-1037:
---------------------------------------------------
I apologize if this question has been answered already. I would like to know what was the
final resolution for this issue. I can see that this issue has been rejected but we are
facing this issue very frequently on the field. We use JBoss 4.2.3 GA with Postgres 9.0.2
and the JBM tables go out of sync very often. We do the suggested workaround on JBoss
restart. However we need a viable solution that does not require manual intervention. Any
thoughts?
JDBCPersistenceManager.java - reference should be inserted after
message (ORA-02291: integrity constraint)
----------------------------------------------------------------------------------------------------------
Key: JBMESSAGING-1037
URL: https://issues.jboss.org/browse/JBMESSAGING-1037
Project: JBoss Messaging
Issue Type: Patch
Components: Messaging Core Persistence
Affects Versions: 1.4.0.CR1
Environment: Windows XP / Oracle 10g
Reporter: Mariusz Olejnik
Assignee: Tim Fox
Priority: Critical
Fix For: 1.4.0.CR1
Attachments: jboss-messaging-trunk-rev2988.patch
Reference should be inserted after message because:
oracle-persistence-service.xml
CREATE TABLE JBM_MSG_REF (
CHANNEL_ID INTEGER,
MESSAGE_ID INTEGER REFERENCES JBM_MSG(MESSAGE_ID)
[...]
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
3:54 p.m.
New subject: [JBoss JIRA] Commented: (JBMESSAGING-1037) JDBCPersistenceManager.java - reference should be inserted after message (ORA-02291: integrity constraint)
[
https://issues.jboss.org/browse/JBMESSAGING-1037?page=com.atlassian.jira....
]
Yong Hao Gao commented on JBMESSAGING-1037:
-------------------------------------------
Hi,
Make sure you use the latest JBM release. JBM now is in maintenance mode and no more
community releases. Users are encouraged to use HornetQ, the successor to JBM with better
performance and richer features.
Thanks
Howard
JDBCPersistenceManager.java - reference should be inserted after
message (ORA-02291: integrity constraint)
----------------------------------------------------------------------------------------------------------
Key: JBMESSAGING-1037
URL: https://issues.jboss.org/browse/JBMESSAGING-1037
Project: JBoss Messaging
Issue Type: Patch
Components: Messaging Core Persistence
Affects Versions: 1.4.0.CR1
Environment: Windows XP / Oracle 10g
Reporter: Mariusz Olejnik
Assignee: Tim Fox
Priority: Critical
Fix For: 1.4.0.CR1
Attachments: jboss-messaging-trunk-rev2988.patch
Reference should be inserted after message because:
oracle-persistence-service.xml
CREATE TABLE JBM_MSG_REF (
CHANNEL_ID INTEGER,
MESSAGE_ID INTEGER REFERENCES JBM_MSG(MESSAGE_ID)
[...]
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
4635
days inactive
6098
days old
5 comments
5 participants
participants (5)
-
Gabriele Garuglieri (JIRA) -
Mariusz Olejnik (JIRA)
-
Prashanto Chatterjee (JIRA)
-
Tim Fox (JIRA)
-
Yong Hao Gao (JIRA)