| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Savita <savita(at)india(dot)hp(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Question about DEADLOCK |
| Date: | 2002-11-22 07:04:52 |
| Message-ID: | 20021121230328.D5726-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
On Fri, 22 Nov 2002, Savita wrote:
> Hi All,
>
> I have a question related to postgres.I have an application which is
> transferring data from MSSQL to Postgres at some regular interval.
>
> I had around 20,000 data in MSSQL which should be transferred to postgres.
> After transferring around 12000 data I got a error message
> ERROR: deadlock detected
> And after that data transfer has stopped.
>
> How to avoid this error and what is the reason for this error.
Most likely cause would be a concurrent transaction doing something that
caused a foreign key to get into a dead lock situation (the current
implementation grabs overly strong locks). In any case, we'll need more
information about what else was going on probably.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Savita | 2002-11-22 07:10:09 | Re: Question about DEADLOCK |
| Previous Message | Egyud Csaba | 2002-11-22 06:35:56 | Re: Welcom & a problem |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Savita | 2002-11-22 07:10:09 | Re: Question about DEADLOCK |
| Previous Message | Savita | 2002-11-22 06:24:00 | Question about DEADLOCK |