Re: Canceling statement due to user request?

From: Bastiaan Olij <lists(at)basenlily(dot)nl>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Canceling statement due to user request?
Date: 2008-10-08 01:11:04
Message-ID: 48EC08A8.5000603@basenlily.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi All,

Looks like this was a problem on the client side, upgraded a client
module for the environment I work in at it seemed to have gone away.
Sorry about that.

Greetz,

Bas

Bastiaan Olij wrote:
> Hi All,
>
> Hoping someone can help me with this. I did some googling and did find
> something about bug #3790 that may be related to this but not sure.
>
> Anyways, I've got a process that loads up loads of data into my
> database. Its been running fine for awhile but since I recently
> installed 8.3.4 on my vista machine I'm getting this error.
> The process simply starts a transaction, loads up 100 records, commits,
> and repeats this for a couple of thousand records.
>
> At some point, and it seems to change, I get a "Canceling statement due
> to user request" error, usually on the commit. Now there certainly is no
> user involved, the machine doing this is just sitting in a corner being
> left alone, and its the only thing logged onto the database at that
> time, so I am mystified where this is suddenly coming from.
>
> Anybody got any ideas?
>
> Thanks,
>
> Bastiaan Olij
> e-mail/MSN: bastiaan(at)basenlily(dot)nl
> web: http://www.basenlily.nl
> Skype: Mux213
> http://www.linkedin.com/in/bastiaanolij
>

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Wright, George 2008-10-08 19:28:11 threads question
Previous Message Michelle Konzack 2008-10-08 00:59:43 Re: PostgreSQL for Data Warehouse