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
-----------------------------------------------------------------
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 |
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 |