[Pgpool-general] "failed to read kind from frontend. frontend abnormally exited"?

Sun Dec 20 11:20:57 UTC 2009

On 18.12.2009 13:51, Tatsuo Ishii wrote:
> We have just released 2.3.1, which will show:
> 
>> Dec 18 12:06:28 pg1 pgpool: 2009-12-18 12:06:28 ERROR: pid 4121: kind mismatch among backends. Possible last query was: "INSERT INTO "ghistoryday" ("data_id", "date", "bytes", "protocol_id") VALUES (1, E'2009-12-18', 2802555, 2)" kind details are: 0[C] 1[E]
> 
> why you got 1[E] (means node #1 PostgreSQL sends error message, while
> node #0 completed the query normaly).
> 
> Alternatively you could look into #1 PostgreSQL log to look for what's
> going on.

This is more or less when the error happened:

2009-12-18 12:12:12 UTC ERROR:  duplicate key value violates unique constraint "core_billinghistoryday_pkey"
2009-12-18 12:12:12 UTC STATEMENT:  INSERT INTO "core_billinghistoryday" ("data_id", "date", "bytes", "protocol_id") VALUES (1, E'2009-12-18', 2802555, 2)
2009-12-18 12:12:12 UTC LOG:  unexpected EOF on client connection

Earlier, I had lots of entries like:

2009-12-18 01:39:41 UTC NOTICE:  CREATE TABLE will create implicit sequence "auth_permission_id_seq" for serial column "auth_permission.id"
2009-12-18 01:39:41 UTC NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "auth_permission_pkey" for table "auth_permission"
2009-12-18 01:39:41 UTC NOTICE:  CREATE TABLE / UNIQUE will create implicit index "auth_permission_content_type_id_key" for table "auth_permission"
2009-12-18 01:39:41 UTC NOTICE:  CREATE TABLE will create implicit sequence "auth_group_id_seq" for serial column "auth_group.id"
2009-12-18 01:39:41 UTC NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "auth_group_pkey" for table "auth_group"
2009-12-18 01:39:41 UTC NOTICE:  CREATE TABLE / UNIQUE will create implicit index "auth_group_name_key" for table "auth_group"
2009-12-18 01:39:41 UTC NOTICE:  CREATE TABLE will create implicit sequence "auth_user_id_seq" for serial column "auth_user.id"
2009-12-18 01:39:41 UTC NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "auth_user_pkey" for table "auth_user"
2009-12-18 01:39:41 UTC NOTICE:  CREATE TABLE / UNIQUE will create implicit index "auth_user_username_key" for table "auth_user"
2009-12-18 01:39:41 UTC NOTICE:  CREATE TABLE will create implicit sequence "auth_message_id_seq" for serial column "auth_message.id"
2009-12-18 01:39:41 UTC NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "auth_message_pkey" for table "auth_message"
2009-12-18 01:39:41 UTC NOTICE:  CREATE TABLE will create implicit sequence "django_content_type_id_seq" for serial column "django_content_type.id"
2009-12-18 01:39:41 UTC NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "django_content_type_pkey" for table "django_content_type"
2009-12-18 01:39:41 UTC NOTICE:  CREATE TABLE / UNIQUE will create implicit index "django_content_type_app_label_key" for table "django_content_type"
2009-12-18 01:39:41 UTC NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "django_session_pkey" for table "django_session"
2009-12-18 01:39:41 UTC NOTICE:  CREATE TABLE will create implicit sequence "django_site_id_seq" for serial column "django_site.id"
2009-12-18 01:39:41 UTC NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "django_site_pkey" for table "django_site"
2009-12-18 01:39:41 UTC NOTICE:  CREATE TABLE will create implicit sequence "django_admin_log_id_seq" for serial column "django_admin_log.id"
2009-12-18 01:39:41 UTC NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "django_admin_log_pkey" for table "django_admin_log"
2009-12-18 01:39:41 UTC NOTICE:  CREATE TABLE will create implicit sequence "core_company_id_seq" for serial column "core_company.id"
2009-12-18 01:39:41 UTC NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "core_company_pkey" for table "core_company"
2009-12-18 01:39:41 UTC NOTICE:  CREATE TABLE will create implicit sequence "core_billinplan_id_seq" for serial column "core_billinplan.id"
2009-12-18 01:39:41 UTC NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "core_billinplan_pkey" for table "core_billinplan"
2009-12-18 01:39:41 UTC NOTICE:  CREATE TABLE / UNIQUE will create implicit index "core_billinplan_company_id_key" for table "core_billinplan"
2009-12-18 01:39:41 UTC NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "core_cdnuser_pkey" for table "core_cdnuser"
2009-12-18 01:39:41 UTC NOTICE:  CREATE TABLE will create implicit sequence "core_distributionpolicy_id_seq" for serial column "core_distributionpolicy.id"
2009-12-18 01:39:41 UTC NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "core_distributionpolicy_pkey" for table "core_distributionpolicy"
2009-12-18 01:39:41 UTC NOTICE:  CREATE TABLE will create implicit sequence "core_eventableobject_id_seq" for serial column "core_eventableobject.id"
2009-12-18 01:39:41 UTC NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "core_eventableobject_pkey" for table "core_eventableobject"
2009-12-18 01:39:41 UTC NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "core_smartobject_pkey" for table "core_smartobject"
2009-12-18 01:39:41 UTC NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "core_stream_pkey" for table "core_stream"
2009-12-18 01:39:41 UTC NOTICE:  CREATE TABLE will create implicit sequence "core_protocol_id_seq" for serial column "core_protocol.id"
2009-12-18 01:39:41 UTC NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "core_protocol_pkey" for table "core_protocol"
2009-12-18 01:39:42 UTC NOTICE:  CREATE TABLE will create implicit sequence "core_event_id_seq" for serial column "core_event.id"
2009-12-18 01:39:42 UTC NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "core_event_pkey" for table "core_event"
2009-12-18 01:39:42 UTC NOTICE:  CREATE TABLE will create implicit sequence "core_bandwidthusagestats_id_seq" for serial column "core_bandwidthusagestats.id"
2009-12-18 01:39:42 UTC NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "core_bandwidthusagestats_pkey" for table "core_bandwidthusagestats"

until:

2009-12-18 01:39:42 UTC NOTICE:  CREATE TABLE / UNIQUE will create implicit index "auth_user_user_permissions_user_id_key" for table "auth_user_user_permissions"
2009-12-18 01:39:49 UTC ERROR:  null value in column "object_id" violates not-null constraint
2009-12-18 01:39:49 UTC STATEMENT:  INSERT INTO "core_event" ("id","ip","when","bytes","protocol_id","country") VALUES (800,E'serv1',E'2009-12-09 12:00:13',3
2009-12-18 01:39:49 UTC ERROR:  current transaction is aborted, commands ignored until end of transaction block
2009-12-18 01:39:49 UTC STATEMENT:  INSERT INTO "django_content_type" ("id","name","app_label","model") VALUES (1,E'permission',E'auth',E'permission');
2009-12-18 01:39:49 UTC ERROR:  current transaction is aborted, commands ignored until end of transaction block

-- 
Tomasz Chmielewski
http://wpkg.org