chunk size problem

From: Martín Marqués <martin(at)bugs(dot)unl(dot)edu(dot)ar>
To: pgsql-hackers(at)postgresql(dot)org
Cc: PostgreSQL general list <pgsql-general(at)postgresql(dot)org>
Subject: chunk size problem
Date: 2001-09-14 20:05:41
Message-ID: 20010914200543.A2D042AB46@bugs.unl.edu.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

I started getting these error messages

webunl=> \dt
NOTICE: AllocSetFree: detected write past chunk end in
TransactionCommandContext 3a4608 pqReadData() -- backend closed the channel
unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
The connection to the server was lost.
Attempting reset: Failed.
!>

The logs on the first times today I had these problems said this:

Sep 14 10:55:41 bugs postgres[1318]: [ID 748848 local0.debug] [12-1] DEBUG:
query: SELECT c.relname as "Name", 'table'::text as "Type", u.usename as
"Owner"
Sep 14 10:55:41 bugs postgres[1318]: [ID 748848 local0.debug] [12-2] FROM
pg_class c, pg_user u
Sep 14 10:55:41 bugs postgres[1318]: [ID 748848 local0.debug] [12-3] WHERE
c.relowner = u.usesysid AND c.relkind = 'r'
Sep 14 10:55:41 bugs postgres[1318]: [ID 748848 local0.debug] [12-4] AND
c.relname !~ '^pg_'
Sep 14 10:55:41 bugs postgres[1318]: [ID 748848 local0.debug] [12-5] UNION
Sep 14 10:55:41 bugs postgres[1318]: [ID 748848 local0.debug] [12-6] SELECT
c.relname as "Name", 'table'::text as "Type", NULL as "Owner"
Sep 14 10:55:41 bugs postgres[1318]: [ID 748848 local0.debug] [12-7] FROM
pg_class c
Sep 14 10:55:41 bugs postgres[1318]: [ID 748848 local0.debug] [12-8] WHERE
c.relkind = 'r'
Sep 14 10:55:41 bugs postgres[1318]: [ID 748848 local0.debug] [12-9] AND
not exists (select 1 from pg_user where usesysid = c.relowner)
Sep 14 10:55:41 bugs postgres[1318]: [ID 748848 local0.debug] [12-10] AND
c.relname !~ '^pg_'
Sep 14 10:55:41 bugs postgres[1318]: [ID 748848 local0.debug] [12-11] ORDER
BY "Name"
Sep 14 10:55:42 bugs postgres[1318]: [ID 553393 local0.notice] [13] NOTICE:
AllocSetFree: detected write past chunk end in TransactionCommandContext
3a4608
Sep 14 10:55:42 bugs postgres[1318]: [ID 553393 local0.notice] [14] NOTICE:
AllocSetFree: detected write past chunk end in TransactionCommandContext
3a4608
Sep 14 10:55:42 bugs postgres[1318]: [ID 553393 local0.notice] [15] NOTICE:
AllocSetFree: detected write past chunk end in TransactionCommandContext
3a4608
Sep 14 10:55:42 bugs postgres[1318]: [ID 553393 local0.notice] [16] NOTICE:
AllocSetFree: detected write past chunk end in TransactionCommandContext
3a4608
Sep 14 10:55:42 bugs postgres[1318]: [ID 553393 local0.notice] [17] NOTICE:
AllocSetFree: detected write past chunk end in TransactionCommandContext
3aadf0
Sep 14 10:55:42 bugs postgres[1318]: [ID 553393 local0.notice] [18] NOTICE:
AllocSetFree: detected write past chunk end in TransactionCommandContext
3aadf0
Sep 14 10:55:42 bugs postgres[1318]: [ID 553393 local0.notice] [19] NOTICE:
AllocSetFree: detected write past chunk end in TransactionCommandContext
3aadf0
Sep 14 10:55:42 bugs postgres[1318]: [ID 553393 local0.notice] [20] NOTICE:
AllocSetFree: detected write past chunk end in TransactionCommandContext
3aadf0

Any idea? Some databases are screwed up

Saludos... :-)

--
Porqué usar una base de datos relacional cualquiera,
si podés usar PostgreSQL?
-----------------------------------------------------------------
Martín Marqués | mmarques(at)unl(dot)edu(dot)ar
Programador, Administrador, DBA | Centro de Telematica
Universidad Nacional
del Litoral
-----------------------------------------------------------------

Browse pgsql-general by date

  From Date Subject
Next Message Steve Wolfe 2001-09-14 20:09:49 Re: How to make a REALLY FAST db server?
Previous Message T.R.Missner 2001-09-14 20:05:18 how to speed query

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim Buttafuoco 2001-09-14 21:33:42 Status of index location patch
Previous Message Andrew Gould 2001-09-14 18:40:00 Re: count of occurences