[Bucardo-general] Error loop

Jaryd Malbin jaryd at duckduckgo.com
Tue Oct 9 16:34:12 UTC 2012


Hi Greg,

It looks like we have run into this issue again. Here's the full thread
from the logs (these 5 lines repeat in our logs until we stop Bucardo)

Oct  8 21:33:34 server2 postgres[27286]: [4-1] 2012-10-08 21:33:34 EDT
WARNING:  nonstandard use of \\ in a string literal at character 135
Oct  8 21:33:34 server2 postgres[27286]: [4-2] 2012-10-08 21:33:34 EDT
HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.
Oct  8 21:33:34 server2 postgres[27286]: [5-1] 2012-10-08 21:33:34 EDT
ERROR:  duplicate key value violates unique constraint "pages_pkey"
Oct  8 21:33:34 server2 postgres[27286]: [5-2] 2012-10-08 21:33:34 EDT
CONTEXT:  COPY pages, line 1:
"spirit\\light\\speed#011deeps\\thgil\\tirips#011#011A#011#011[Ian Astbury]
- '''Ian Robert Astbury''' (born 14 May ..."
Oct  8 21:33:34 server2 postgres[27286]: [5-3] 2012-10-08 21:33:34 EDT
STATEMENT:  /* Bucardo 4.99.5 */COPY
public.pages("search_title","search_title_rev","title","type","redirect","internal_links","external_links","image_url","image_name","image_caption","abstract","source","source_url","summaries")
FROM STDIN

Hope this helps with debugging the issue! Let me know if you need any more
information.

Best,
Jaryd

On Fri, Sep 21, 2012 at 1:42 PM, Greg Sabino Mullane <greg at endpoint.com>wrote:

> On Wed, Sep 12, 2012 at 02:46:31PM -0400, Gabriel Weinberg wrote:
> > It doesn't seem like I have it, unfortunately.
>
> Can you tell me about the table it is having problems on? What type
> of primary key does it have? Anything non-standard about the sync?
>
> --
> Greg Sabino Mullane greg at endpoint.com
> End Point Corporation
> PGP Key: 0x14964AC8
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20121009/4ad7c24c/attachment.html>


More information about the Bucardo-general mailing list