Postgres Giving Errors Incomplete Startup Packet
От
Amit Aggarwal
Тема
Postgres Giving Errors Incomplete Startup Packet
Дата
Msg-id
5f33441b0809290132i22a0f88qa44c191909779d5c@mail.gmail.com
Список
Дерево обсуждения
Postgres Giving Errors Incomplete Startup Packet "Amit Aggarwal" <amit.aggarwal1@gmail.com>
Re: Postgres Giving Errors Incomplete Startup Packet Tom Lane <tgl@sss.pgh.pa.us>
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 ?
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
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
Amit Aggarwal
В списке pgsql-jdbc по дате отправления
