[jira] [Commented] (AMQ-4120) SqlServer - SQL Syntax error in initial table creation
[ https://issues.apache.org/jira/browse/AMQ-4120?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13967250#comment-13967250 ] Gurinder commented on AMQ-4120: --- I see this also in 5.9.0 I am using jdbcPersistenceAdapter and my datasource is using the bean class: org.apache.commons.dbcp.BasicDataSource SqlServer - SQL Syntax error in initial table creation -- Key: AMQ-4120 URL: https://issues.apache.org/jira/browse/AMQ-4120 Project: ActiveMQ Issue Type: Improvement Affects Versions: 5.7.0 Environment: Windows Server 2008 R2, 64bit, MS SQL Server 2008 persistence adapter. Reporter: Rasitha Wijesinghe Priority: Minor Fix For: NEEDS_REVIEW When using SQL Server as the backing data store and creating the AMQ tables for the very first time, the following error is logged: INFO | jvm 1| 2012/10/19 11:12:03 | WARN | Could not create JDBC tables; they could already exist. Failure was: ALTER TABLE ACTIVEMQ_ACKS DROP PRIMARY KEY Message: Incorrect syntax near the keyword 'PRIMARY'. SQLState: S1000 Vendor code: 156 INFO | jvm 1| 2012/10/19 11:12:03 | WARN | Failure details: Incorrect syntax near the keyword 'PRIMARY'. INFO | jvm 1| 2012/10/19 11:12:03 | java.sql.SQLException: Incorrect syntax near the keyword 'PRIMARY'. Since there is no specific adapter for SQL Server it uses the DefaultJDBCAdapter which has getDropAckPKAlterStatementEnd() returning DROP PRIMARY KEY. Not sure if this is an issue with other databases as well. (Note: If you already have the tables, this error is still present but only logs a DEBUG entry). Does it make sense to add a MSSqlJDBCAdapter that overrides getDropAckPKAlterStatementEnd? -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Commented] (AMQ-4920) AmqpErrorException occurs with multiple concurrent amqp topic consumers
[ https://issues.apache.org/jira/browse/AMQ-4920?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13956818#comment-13956818 ] Gurinder commented on AMQ-4920: --- So essentially multiple topic consumers even running from different instances do not work. This pretty much makes publish-subscribe system unworkable since in any production environment you would have more than 1 subscriber to the same topic. Or is there any other way.? Btw any idea when 5.10 is coming out AmqpErrorException occurs with multiple concurrent amqp topic consumers --- Key: AMQ-4920 URL: https://issues.apache.org/jira/browse/AMQ-4920 Project: ActiveMQ Issue Type: Bug Reporter: Kevin Earls Assignee: Kevin Earls Attachments: rp.out I'll add a test to reproduce this. There are currently 2 problems. The more frequent one looks like: org.apache.qpid.amqp_1_0.type.AmqpErrorException at org.apache.qpid.amqp_1_0.codec.ValueHandler.readConstructor(ValueHandler.java:99) at org.apache.qpid.amqp_1_0.codec.ValueHandler.parse(ValueHandler.java:90) at org.apache.qpid.amqp_1_0.codec.ValueHandler.readConstructor(ValueHandler.java:105) at org.apache.qpid.amqp_1_0.codec.ValueHandler.parse(ValueHandler.java:90) … repeated many times at org.apache.qpid.amqp_1_0.codec.ValueHandler.readConstructor(ValueHandler.java:105) at org.apache.qpid.amqp_1_0.codec.ValueHandler.parse(ValueHandler.java:90) at org.apache.qpid.amqp_1_0.messaging.SectionDecoderImpl.parseAll(SectionDecoderImpl.java:49) at org.apache.qpid.amqp_1_0.client.Receiver.receive(Receiver.java:280) at org.apache.qpid.amqp_1_0.jms.impl.MessageConsumerImpl.receive0(MessageConsumerImpl.java:286) at org.apache.qpid.amqp_1_0.jms.impl.MessageConsumerImpl.receiveImpl(MessageConsumerImpl.java:255) at org.apache.qpid.amqp_1_0.jms.impl.MessageConsumerImpl.receive(MessageConsumerImpl.java:238) at org.apache.qpid.amqp_1_0.jms.impl.MessageConsumerImpl.receive(MessageConsumerImpl.java:56) at org.apache.activemq.transport.amqp.ENTMQ466ConsumerThread.run(ENTMQ466Test.java:123) This occurs at the line final EncodedMessage amqp = outboundTransformer.transform(jms); in the ConsumerContext.pumpOutbound() method of AmqpProtocolConverter(). This call sometimes returns with its content (amqp.getArray()) set to all zeros. On those messages this line LOG.info(In pumpOutbound, setting currentBuffer to offset {} length {} content [{}], amqp.getArrayOffset(), amqp.getLength(), amqp.getArray()); returns: 2013-11-26 17:19:16,680 [calhost] Task-3] - INFO AmqpProtocolConverter - In pumpOutbound, setting currentBuffer to offset 0 length 162 content [[0, 0, 0, 0, 0, \ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,\ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0\ , 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]] At the root of this, outboundTransformer is a (proton) AutoOutboundTransformer. It calls AMQPNativeOutboundTransformer.transform(), which calls msg.readBytes(data), which sometimes writes all 0s to data. Here msg is an ActiveMQBytesMessage. -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Comment Edited] (AMQ-4920) AmqpErrorException occurs with multiple concurrent amqp topic consumers
[ https://issues.apache.org/jira/browse/AMQ-4920?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13956818#comment-13956818 ] Gurinder edited comment on AMQ-4920 at 4/1/14 6:02 PM: --- So essentially multiple topic consumers even running from different instances do not work. This pretty much makes publish-subscribe system unworkable since in any production environment you would have more than 1 subscriber to the same topic. Or is there any other way.? Btw any idea when 5.10 is coming out. Also is it the broker or client problem? was (Author: gurilubana): So essentially multiple topic consumers even running from different instances do not work. This pretty much makes publish-subscribe system unworkable since in any production environment you would have more than 1 subscriber to the same topic. Or is there any other way.? Btw any idea when 5.10 is coming out AmqpErrorException occurs with multiple concurrent amqp topic consumers --- Key: AMQ-4920 URL: https://issues.apache.org/jira/browse/AMQ-4920 Project: ActiveMQ Issue Type: Bug Reporter: Kevin Earls Assignee: Kevin Earls Attachments: rp.out I'll add a test to reproduce this. There are currently 2 problems. The more frequent one looks like: org.apache.qpid.amqp_1_0.type.AmqpErrorException at org.apache.qpid.amqp_1_0.codec.ValueHandler.readConstructor(ValueHandler.java:99) at org.apache.qpid.amqp_1_0.codec.ValueHandler.parse(ValueHandler.java:90) at org.apache.qpid.amqp_1_0.codec.ValueHandler.readConstructor(ValueHandler.java:105) at org.apache.qpid.amqp_1_0.codec.ValueHandler.parse(ValueHandler.java:90) … repeated many times at org.apache.qpid.amqp_1_0.codec.ValueHandler.readConstructor(ValueHandler.java:105) at org.apache.qpid.amqp_1_0.codec.ValueHandler.parse(ValueHandler.java:90) at org.apache.qpid.amqp_1_0.messaging.SectionDecoderImpl.parseAll(SectionDecoderImpl.java:49) at org.apache.qpid.amqp_1_0.client.Receiver.receive(Receiver.java:280) at org.apache.qpid.amqp_1_0.jms.impl.MessageConsumerImpl.receive0(MessageConsumerImpl.java:286) at org.apache.qpid.amqp_1_0.jms.impl.MessageConsumerImpl.receiveImpl(MessageConsumerImpl.java:255) at org.apache.qpid.amqp_1_0.jms.impl.MessageConsumerImpl.receive(MessageConsumerImpl.java:238) at org.apache.qpid.amqp_1_0.jms.impl.MessageConsumerImpl.receive(MessageConsumerImpl.java:56) at org.apache.activemq.transport.amqp.ENTMQ466ConsumerThread.run(ENTMQ466Test.java:123) This occurs at the line final EncodedMessage amqp = outboundTransformer.transform(jms); in the ConsumerContext.pumpOutbound() method of AmqpProtocolConverter(). This call sometimes returns with its content (amqp.getArray()) set to all zeros. On those messages this line LOG.info(In pumpOutbound, setting currentBuffer to offset {} length {} content [{}], amqp.getArrayOffset(), amqp.getLength(), amqp.getArray()); returns: 2013-11-26 17:19:16,680 [calhost] Task-3] - INFO AmqpProtocolConverter - In pumpOutbound, setting currentBuffer to offset 0 length 162 content [[0, 0, 0, 0, 0, \ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,\ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0\ , 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]] At the root of this, outboundTransformer is a (proton) AutoOutboundTransformer. It calls AMQPNativeOutboundTransformer.transform(), which calls msg.readBytes(data), which sometimes writes all 0s to data. Here msg is an ActiveMQBytesMessage. -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Commented] (AMQ-4920) AmqpErrorException occurs with multiple concurrent amqp topic consumers
[ https://issues.apache.org/jira/browse/AMQ-4920?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13951265#comment-13951265 ] Gurinder commented on AMQ-4920: --- Is there a workaround for this bug. AmqpErrorException occurs with multiple concurrent amqp topic consumers --- Key: AMQ-4920 URL: https://issues.apache.org/jira/browse/AMQ-4920 Project: ActiveMQ Issue Type: Bug Reporter: Kevin Earls Assignee: Kevin Earls Attachments: rp.out I'll add a test to reproduce this. There are currently 2 problems. The more frequent one looks like: org.apache.qpid.amqp_1_0.type.AmqpErrorException at org.apache.qpid.amqp_1_0.codec.ValueHandler.readConstructor(ValueHandler.java:99) at org.apache.qpid.amqp_1_0.codec.ValueHandler.parse(ValueHandler.java:90) at org.apache.qpid.amqp_1_0.codec.ValueHandler.readConstructor(ValueHandler.java:105) at org.apache.qpid.amqp_1_0.codec.ValueHandler.parse(ValueHandler.java:90) … repeated many times at org.apache.qpid.amqp_1_0.codec.ValueHandler.readConstructor(ValueHandler.java:105) at org.apache.qpid.amqp_1_0.codec.ValueHandler.parse(ValueHandler.java:90) at org.apache.qpid.amqp_1_0.messaging.SectionDecoderImpl.parseAll(SectionDecoderImpl.java:49) at org.apache.qpid.amqp_1_0.client.Receiver.receive(Receiver.java:280) at org.apache.qpid.amqp_1_0.jms.impl.MessageConsumerImpl.receive0(MessageConsumerImpl.java:286) at org.apache.qpid.amqp_1_0.jms.impl.MessageConsumerImpl.receiveImpl(MessageConsumerImpl.java:255) at org.apache.qpid.amqp_1_0.jms.impl.MessageConsumerImpl.receive(MessageConsumerImpl.java:238) at org.apache.qpid.amqp_1_0.jms.impl.MessageConsumerImpl.receive(MessageConsumerImpl.java:56) at org.apache.activemq.transport.amqp.ENTMQ466ConsumerThread.run(ENTMQ466Test.java:123) This occurs at the line final EncodedMessage amqp = outboundTransformer.transform(jms); in the ConsumerContext.pumpOutbound() method of AmqpProtocolConverter(). This call sometimes returns with its content (amqp.getArray()) set to all zeros. On those messages this line LOG.info(In pumpOutbound, setting currentBuffer to offset {} length {} content [{}], amqp.getArrayOffset(), amqp.getLength(), amqp.getArray()); returns: 2013-11-26 17:19:16,680 [calhost] Task-3] - INFO AmqpProtocolConverter - In pumpOutbound, setting currentBuffer to offset 0 length 162 content [[0, 0, 0, 0, 0, \ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,\ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0\ , 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]] At the root of this, outboundTransformer is a (proton) AutoOutboundTransformer. It calls AMQPNativeOutboundTransformer.transform(), which calls msg.readBytes(data), which sometimes writes all 0s to data. Here msg is an ActiveMQBytesMessage. -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Comment Edited] (AMQ-4920) AmqpErrorException occurs with multiple concurrent amqp topic consumers
[ https://issues.apache.org/jira/browse/AMQ-4920?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13951265#comment-13951265 ] Gurinder edited comment on AMQ-4920 at 3/28/14 7:21 PM: Is there a workaround for this bug. I am using qpid-java-amqp-1-0-client-jms-0.26 and still hit this error. was (Author: gurilubana): Is there a workaround for this bug. AmqpErrorException occurs with multiple concurrent amqp topic consumers --- Key: AMQ-4920 URL: https://issues.apache.org/jira/browse/AMQ-4920 Project: ActiveMQ Issue Type: Bug Reporter: Kevin Earls Assignee: Kevin Earls Attachments: rp.out I'll add a test to reproduce this. There are currently 2 problems. The more frequent one looks like: org.apache.qpid.amqp_1_0.type.AmqpErrorException at org.apache.qpid.amqp_1_0.codec.ValueHandler.readConstructor(ValueHandler.java:99) at org.apache.qpid.amqp_1_0.codec.ValueHandler.parse(ValueHandler.java:90) at org.apache.qpid.amqp_1_0.codec.ValueHandler.readConstructor(ValueHandler.java:105) at org.apache.qpid.amqp_1_0.codec.ValueHandler.parse(ValueHandler.java:90) … repeated many times at org.apache.qpid.amqp_1_0.codec.ValueHandler.readConstructor(ValueHandler.java:105) at org.apache.qpid.amqp_1_0.codec.ValueHandler.parse(ValueHandler.java:90) at org.apache.qpid.amqp_1_0.messaging.SectionDecoderImpl.parseAll(SectionDecoderImpl.java:49) at org.apache.qpid.amqp_1_0.client.Receiver.receive(Receiver.java:280) at org.apache.qpid.amqp_1_0.jms.impl.MessageConsumerImpl.receive0(MessageConsumerImpl.java:286) at org.apache.qpid.amqp_1_0.jms.impl.MessageConsumerImpl.receiveImpl(MessageConsumerImpl.java:255) at org.apache.qpid.amqp_1_0.jms.impl.MessageConsumerImpl.receive(MessageConsumerImpl.java:238) at org.apache.qpid.amqp_1_0.jms.impl.MessageConsumerImpl.receive(MessageConsumerImpl.java:56) at org.apache.activemq.transport.amqp.ENTMQ466ConsumerThread.run(ENTMQ466Test.java:123) This occurs at the line final EncodedMessage amqp = outboundTransformer.transform(jms); in the ConsumerContext.pumpOutbound() method of AmqpProtocolConverter(). This call sometimes returns with its content (amqp.getArray()) set to all zeros. On those messages this line LOG.info(In pumpOutbound, setting currentBuffer to offset {} length {} content [{}], amqp.getArrayOffset(), amqp.getLength(), amqp.getArray()); returns: 2013-11-26 17:19:16,680 [calhost] Task-3] - INFO AmqpProtocolConverter - In pumpOutbound, setting currentBuffer to offset 0 length 162 content [[0, 0, 0, 0, 0, \ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,\ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0\ , 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]] At the root of this, outboundTransformer is a (proton) AutoOutboundTransformer. It calls AMQPNativeOutboundTransformer.transform(), which calls msg.readBytes(data), which sometimes writes all 0s to data. Here msg is an ActiveMQBytesMessage. -- This message was sent by Atlassian JIRA (v6.2#6252)