Postgres Giving Errors Incomplete Startup Packet

From: "Amit Aggarwal" <amit(dot)aggarwal1(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Cc: Vikas <mailvgarg(at)gmail(dot)com>
Subject: Postgres Giving Errors Incomplete Startup Packet
Date: 2008-09-29 08:32:26
Message-ID: 5f33441b0809290132i22a0f88qa44c191909779d5c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,

We are running a web application making connections to postgres using jdbc.
It is fairly database intensive, but we find the logs filled with the
following dump. What could be the possible causes for this ?

Sep 29 11:08:10 DB1 postgres[12575]: [2-1] *ERROR: duplicate key violates
unique constraint "users_mobile_key"
*Sep 29 11:08:10 DB1 postgres[12575]: [2-2] STATEMENT: insert into
users(name, phone, e_verified, e_activated, email, m_verified, m_activated,
mobile, mbl_ne
twork,
Sep 29 11:08:10 DB1 postgres[12575]: [2-3] mbl_handset, password,
txn_password, role, confirm_code, activated) values
($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$1
2,$13,$14,$15)
Sep 29 11:08:32 DB1 postgres[21957]: [1-1] LOG: incomplete startup packet
Sep 29 11:09:32 DB1 postgres[22020]: [1-1] LOG: incomplete startup packet
Sep 29 11:10:32 DB1 postgres[22112]: [1-1] LOG: incomplete startup packet
Sep 29 11:11:32 DB1 postgres[22183]: [1-1] LOG: incomplete startup packet
Sep 29 11:12:32 DB1 postgres[22250]: [1-1] LOG: incomplete startup packet
Sep 29 11:13:32 DB1 postgres[22319]: [1-1] LOG: incomplete startup packet
Sep 29 11:14:32 DB1 postgres[22383]: [1-1] LOG: incomplete startup packet
Sep 29 11:15:32 DB1 postgres[22438]: [1-1] LOG: incomplete startup packet
Sep 29 11:16:00 DB1 postgres[19523]: [1-1] LOG: unexpected EOF on client
connection
Sep 29 11:16:32 DB1 postgres[22526]: [1-1] LOG: incomplete startup packet
Sep 29 11:17:32 DB1 postgres[22580]: [1-1] LOG: incomplete startup packet
Sep 29 11:18:32 DB1 postgres[22640]: [1-1] LOG: incomplete startup packet
Sep 29 11:19:32 DB1 postgres[22715]: [1-1] LOG: incomplete startup packet
Sep 29 11:20:32 DB1 postgres[22802]: [1-1] LOG: incomplete startup packet
Sep 29 11:21:32 DB1 postgres[22864]: [1-1] LOG: incomplete startup packet
Sep 29 11:22:32 DB1 postgres[22920]: [1-1] LOG: incomplete startup packet
Sep 29 11:23:32 DB1 postgres[22998]: [1-1] LOG: incomplete startup packet
Sep 29 11:24:32 DB1 postgres[23046]: [1-1] LOG: incomplete startup packet
Sep 29 11:25:32 DB1 postgres[23133]: [1-1] LOG: incomplete startup packet
Sep 29 11:26:32 DB1 postgres[23196]: [1-1] LOG: incomplete startup packet
Sep 29 11:27:32 DB1 postgres[23259]: [1-1] LOG: incomplete startup packet
Sep 29 11:28:32 DB1 postgres[23322]: [1-1] LOG: incomplete startup packet
Sep 29 11:29:32 DB1 postgres[23382]: [1-1] LOG: incomplete startup packet
Sep 29 11:30:32 DB1 postgres[23460]: [1-1] LOG: incomplete startup packet
Sep 29 11:31:32 DB1 postgres[23527]: [1-1] LOG: incomplete startup packet
Sep 29 11:32:32 DB1 postgres[23583]: [1-1] LOG: incomplete startup packet
Sep 29 11:33:32 DB1 postgres[23638]: [1-1] LOG: incomplete startup packet
Sep 29 11:34:32 DB1 postgres[23707]: [1-1] LOG: incomplete startup packet
Sep 29 11:35:32 DB1 postgres[23776]: [1-1] LOG: incomplete startup packet
Sep 29 11:36:32 DB1 postgres[23843]: [1-1] LOG: incomplete startup packet
Sep 29 11:37:32 DB1 postgres[23911]: [1-1] LOG: incomplete startup packet
Sep 29 11:38:32 DB1 postgres[23967]: [1-1] LOG: incomplete startup packet
Sep 29 11:39:32 DB1 postgres[24040]: [1-1] LOG: incomplete startup packet
Sep 29 11:40:32 DB1 postgres[24121]: [1-1] LOG: incomplete startup packet
Sep 29 11:41:32 DB1 postgres[24173]: [1-1] LOG: incomplete startup packet
Sep 29 11:42:32 DB1 postgres[24239]: [1-1] LOG: incomplete startup packet
Sep 29 11:43:05 DB1 postgres[20760]: [5-1] *ERROR:* *duplicate key violates
unique constraint "users_email_key"
*Sep 29 11:43:05 DB1 postgres[20760]: [5-2] STATEMENT: insert into
users(name, phone, e_verified, e_activated, email, m_verified, m_activated,
mobile, mbl_ne
twork,
Sep 29 11:43:05 DB1 postgres[20760]: [5-3] mbl_handset, password,
txn_password, role, confirm_code, activated) values
($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$1
2,$13,$14,$15)
Sep 29 11:43:32 DB1 postgres[24323]: [1-1] LOG: incomplete startup packet
Sep 29 11:44:32 DB1 postgres[24396]: [1-1] LOG: incomplete startup packet
Sep 29 11:45:31 DB1 postgres[12758]: [1-1] *ERROR: duplicate key violates
unique constraint "orders_pkey"
*Sep 29 11:45:31 DB1 postgres[12758]: [1-2] STATEMENT: insert into orders
(id, lead_id, user_id, status, purchase_mode, bid_id, amt_charged_buyer,
payment_me

Regards
Amit Aggarwal

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Tom Lane 2008-09-29 16:34:21 Re: Postgres Giving Errors Incomplete Startup Packet
Previous Message Kris Jurka 2008-09-26 05:39:50 Re: [JDBC] need help of getting PK after insertRow in JDBC