[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