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 <[email protected]> wrote: > INFO 14:13:21,609 | james.imapserver | ID=1451155144 List failed > org.apache.james.mailbox.exception.MailboxException: Search of mailbox > #private:[email protected]: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: [email protected] > For additional commands, e-mail: [email protected] > >
