james-server-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From lclhst <l0c4lh0st.d...@gmail.com>
Subject Re: Escape strings still not correct with latest beta4 PGSQL
Date Tue, 06 Mar 2012 13:28:35 GMT
Some more threads on this problem:
https://www.google.nl/webhp?sourceid=chrome-instant&ix=seb&ie=UTF-8&ion=1#hl=nl&safe=off&output=search&sclient=psy-ab&q=%22Invalid%20escape%20string%22&pbx=1&oq=&aq=&aqi=&aql=&gs_sm=&gs_upl=&gs_l=&fp=ebc5b602cbd83cfb&ix=seb&ion=1&bav=on.2,or.r_gc.r_pw.r_cp.r_qf.,cf.osb&biw=1280&bih=939


I hackety-fixed it now by adding
standard_conforming_strings = off
to my postgresql.conf.

On Tue, Mar 6, 2012 at 2:15 PM, l0c4l h0st <l0c4lh0st.dump@gmail.com> wrote:

> INFO  14:13:21,609 | james.imapserver | ID=1451155144 List failed
> org.apache.james.mailbox.exception.MailboxException: Search of mailbox
> #private:xxx@yyy.nl:Trash failed
>        at
> org.apache.james.mailbox.jpa.mail.JPAMailboxMapper.findMailboxWithPathLike(JPAMailboxMapper.java:124)
>        at
> org.apache.james.mailbox.store.StoreMailboxManager.search(StoreMailboxManager.java:508)
>        at
> org.apache.james.imap.processor.ListProcessor.doProcess(ListProcessor.java:166)
>        at
> org.apache.james.imap.processor.ListProcessor.doProcess(ListProcessor.java:64)
>        at
> org.apache.james.imap.processor.ListProcessor.doProcess(ListProcessor.java:47)
>        at
> org.apache.james.imap.processor.AbstractMailboxProcessor.doProcess(AbstractMailboxProcessor.java:100)
>        at
> org.apache.james.imap.processor.AbstractMailboxProcessor.process(AbstractMailboxProcessor.java:89)
>        at
> org.apache.james.imap.processor.AbstractMailboxProcessor.doProcess(AbstractMailboxProcessor.java:83)
>        at
> org.apache.james.imap.processor.AbstractMailboxProcessor.doProcess(AbstractMailboxProcessor.java:66)
>        at
> org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:52)
>        at
> org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:54)
>        at
> org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:54)
>        at
> org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:54)
>        at
> org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:54)
>        at
> org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:54)
>        at
> org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:54)
>        at
> org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:54)
>        at
> org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:54)
>        at
> org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:54)
>        at
> org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:54)
>        at
> org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:54)
>        at
> org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:54)
>        at
> org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:54)
>        at
> org.apache.james.imap.processor.base.AbstractChainedProcessor.process(AbstractChainedProcessor.java:54)
>        at
> org.apache.james.imapserver.netty.ImapChannelUpstreamHandler.messageReceived(ImapChannelUpstreamHandler.java:181)
>        at
> org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:75)
>        at
> org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:558)
>        at
> org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:777)
>        at
> org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:296)
>        at
> org.jboss.netty.handler.codec.frame.FrameDecoder.unfoldAndFireMessageReceived(FrameDecoder.java:327)
>        at
> org.jboss.netty.handler.codec.frame.FrameDecoder.callDecode(FrameDecoder.java:305)
>        at
> org.jboss.netty.handler.codec.frame.FrameDecoder.messageReceived(FrameDecoder.java:207)
>        at
> org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:75)
>        at
> org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:558)
>        at
> org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:777)
>        at
> org.jboss.netty.handler.execution.ChannelUpstreamEventRunnable.run(ChannelUpstreamEventRunnable.java:44)
>        at
> org.jboss.netty.handler.execution.OrderedMemoryAwareThreadPoolExecutor$ChildExecutor.run(OrderedMemoryAwareThreadPoolExecutor.java:312)
>        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
>        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
> Source)
>        at java.lang.Thread.run(Unknown Source)
> Caused by: <openjpa-2.1.0-r422266:1071316 fatal general error>
> org.apache.openjpa.persistence.PersistenceException: ERROR: invalid
> escape string
>  Hint: Escape string must be empty or one character. {prepstmnt
> 174928937 SELECT t0.mailbox_id, t0.mailbox_highest_modseq,
> t0.mailbox_last_uid, t0.mailbox_name, t0.mailbox_namespace,
> t0.mailbox_uid_validity, t0.user_name FRO
> M public.james_mailbox t0 WHERE (t0.mailbox_name LIKE ? ESCAPE '\\'
> AND t0.user_name = ? AND t0.mailbox_namespace = ?) [params=?, ?, ?]}
> [code=0, state=22025]
> FailedObject: SELECT mailbox FROM Mailbox mailbox WHERE mailbox.name
> LIKE :nameParam and mailbox.user= :userParam and mailbox.namespace=
> :namespaceParam [java.lang.String]
>        at
> org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4869)
>        at
> org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4829)
>        at
> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:136)
>        at
> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:118)
>        at
> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:70)
>        at
> org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.handleCheckedException(SelectResultObjectProvider.java:155)
>        at
> org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:40)
>        at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1251)
>        at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1007)
>        at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:863)
>        at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:794)
>        at
> org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:542)
>        at
> org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:305)
>        at
> org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:319)
>        at
> org.apache.james.mailbox.jpa.mail.JPAMailboxMapper.findMailboxWithPathLike(JPAMailboxMapper.java:121)
>        ... 39 more
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: ERROR:
> invalid escape string
>  Hint: Escape string must be empty or one character. {prepstmnt
> 174928937 SELECT t0.mailbox_id, t0.mailbox_highest_modseq,
> t0.mailbox_last_uid, t0.mailbox_name, t0.mailbox_namespace,
> t0.mailbox_uid_validity, t0.user_name FRO
> M public.james_mailbox t0 WHERE (t0.mailbox_name LIKE ? ESCAPE '\\'
> AND t0.user_name = ? AND t0.mailbox_namespace = ?) [params=?, ?, ?]}
> [code=0, state=22025]
>        at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:281)
>        at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:265)
>        at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:72)
>        at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1183)
>        at
> org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:284)
>        at
> org.apache.openjpa.jdbc.sql.PostgresDictionary$PostgresPreparedStatement.executeQuery(PostgresDictionary.java:1004)
>        at
> org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:284)
>        at
> org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeQuery(JDBCStoreManager.java:1785)
>        at
> org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:274)
>        at
> org.apache.openjpa.jdbc.sql.SelectImpl.executeQuery(SelectImpl.java:499)
>        at
> org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:424)
>        at
> org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:391)
>        at
> org.apache.openjpa.jdbc.sql.LogicalUnion$UnionSelect.execute(LogicalUnion.java:427)
>        at
> org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:230)
>        at
> org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:220)
>        at
> org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:94)
>        at
> org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:34)
>        ... 47 more
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
> For additional commands, e-mail: server-dev-help@james.apache.org
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message