Skip to content

Calling recent-items when the user has no subscriptions throws a PSQLException #282

@abmargb

Description

@abmargb
org.postgresql.util.PSQLException: ERROR: syntax error at or near ")"
  Position: 16
org.buddycloud.channelserver.packetprocessor.iq.namespace.pubsub.get.RecentItemsGet - org.buddycloud.channelserver.db.exception.NodeStoreException: org.postgresql.util.PSQLException: ERROR: syntax error at or near ")"
  Position: 16
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
    at org.buddycloud.channelserver.db.jdbc.JDBCNodeStore.getRecentItems(JDBCNodeStore.java:1111)
    at org.buddycloud.channelserver.channel.ChannelManagerImpl.getRecentItems(ChannelManagerImpl.java:288)
    at org.buddycloud.channelserver.packetprocessor.iq.namespace.pubsub.get.RecentItemsGet.addRecentItems(RecentItemsGet.java:128)
    at org.buddycloud.channelserver.packetprocessor.iq.namespace.pubsub.get.RecentItemsGet.process(RecentItemsGet.java:78)
    at org.buddycloud.channelserver.packetprocessor.iq.namespace.pubsub.PacketProcessorAbstract.process(PacketProcessorAbstract.java:68)
    at org.buddycloud.channelserver.packetprocessor.iq.namespace.pubsub.PacketProcessorAbstract.process(PacketProcessorAbstract.java:1)
    at org.buddycloud.channelserver.packetprocessor.iq.namespace.AbstractNamespace.process(AbstractNamespace.java:61)
    at org.buddycloud.channelserver.packetprocessor.iq.namespace.AbstractNamespace.process(AbstractNamespace.java:1)
    at org.buddycloud.channelserver.packetprocessor.iq.IQProcessor.processPacket(IQProcessor.java:75)
    at org.buddycloud.channelserver.packetprocessor.iq.IQProcessor.process(IQProcessor.java:51)
    at org.buddycloud.channelserver.queue.InQueueConsumer.consume(InQueueConsumer.java:50)
    at org.buddycloud.channelserver.queue.QueueConsumer$1.run(QueueConsumer.java:29)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
    at java.util.concurrent.FutureTask.run(FutureTask.java:262)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:744)

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions