| Lists: | pgsql-jdbc |
|---|
| 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 |
| 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
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Amit Aggarwal" <amit(dot)aggarwal1(at)gmail(dot)com> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org, Vikas <mailvgarg(at)gmail(dot)com> |
| Subject: | Re: Postgres Giving Errors Incomplete Startup Packet |
| Date: | 2008-09-29 16:34:21 |
| Message-ID: | 14713.1222706061@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-jdbc |
"Amit Aggarwal" <amit(dot)aggarwal1(at)gmail(dot)com> writes:
> 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 ?
The probable cause is something connecting to port 5432 and then
disconnecting without sending anything. The fact that the occurrences
are exactly a minute apart suggests that it's some sort of monitoring
tool. I've heard that there's stuff out there that makes a cheesy probe
that Postgres is "up" by just seeing if it can connect to 5432.
regards, tom lane