| From: | Hans-Jürgen Schönig <hs(at)cybertec(dot)at> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Question about DEADLOCK |
| Date: | 2002-11-22 08:16:16 |
| Message-ID: | 3DDDE7D0.5040803@cybertec.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
I recommend reading Tom Lane's talk "Concurrency Issues" at OSCON2002.
This will answer all questions and some more.
Best regards,
Hans
Savita wrote:
>--------------880B7BB5722DEBFDA92AF2C3
>Content-Type: text/plain; charset=us-ascii
>Content-Transfer-Encoding: 7bit
>
>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.
>--
>Best Regards
>- Savita
>----------------------------------------------------
>Hewlett Packard (India)
>+91 80 2051288 (Phone)
>847 1288 (HP Telnet)
>----------------------------------------------------
>
>
>--------------880B7BB5722DEBFDA92AF2C3
>Content-Type: text/html; charset=us-ascii
>Content-Transfer-Encoding: 7bit
>
><!doctype html public "-//w3c//dtd html 4.0 transitional//en">
><html>
>Hi All,
><p>I have a question related to postgres.I have an application which is
>transferring data from MSSQL to Postgres at some regular interval.
><p>I had around 20,000 data in MSSQL which should be transferred to postgres.
><br>After transferring around 12000 data I got a error message
><br><b><font color="#3333FF">ERROR: deadlock detected</font></b>
><br><font color="#000000">And after that data transfer has stopped.</font><font color="#000000"></font>
><p><font color="#000000">How to avoid this error and what is the reason
>for this error.</font>
><br>--
><br>Best Regards
><br>- Savita
><br>----------------------------------------------------
><br>Hewlett Packard (India)
><br>+91 80 2051288 (Phone)
><br>847 1288 (HP Telnet)
><br>----------------------------------------------------
><br> </html>
>
>--------------880B7BB5722DEBFDA92AF2C3--
>
>
>
--
*Cybertec Geschwinde u Schoenig*
Ludo-Hartmannplatz 1/14, A-1160 Vienna, Austria
Tel: +43/1/913 68 09; +43/664/233 90 75
www.postgresql.at <http://www.postgresql.at>, cluster.postgresql.at
<http://cluster.postgresql.at>, www.cybertec.at
<http://www.cybertec.at>, kernel.cybertec.at <http://kernel.cybertec.at>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shridhar Daithankar | 2002-11-22 08:16:44 | Re: PostgreSQL compilation with custom table name |
| Previous Message | Mark Kirkwood | 2002-11-22 08:11:05 | Re: MS-server <-> Ppostgresql |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Pradier | 2002-11-22 09:02:42 | Re: Error when comparing an integer to an empty string. |
| Previous Message | Savita | 2002-11-22 07:10:09 | Re: Question about DEADLOCK |