Re: Problemas de invalid memory alloc request size

El 09/04/2013 16:41, Alvaro Herrera escribió:
> Alejandro Brust at federacion escribió:
>
>> Hace poco tiempo se me clavo el servidor maestro (uso streaming rep) y
> ¿qué significa "se me clavó el servidor maestro"? Sé específico.
>
>> en la replica(ahora máster) me están apareciendo errores al hacer
>> algunas consultas sobre tablas con el siguiente error
>>
>> "invalid memory alloc request size 18446744073709551613"
> Normalmente esta manifestación tiene que ver con corrupción de punteros
> TOAST. Es posible que tengas páginas completas con datos corruptos;
> pero al menos ciertas secciones de la página (el encabezado) está
> suficientemente bien que pasa determinados controles de sanidad. ¿Qué
> script usaste para chequear las tablas? ¿Pasó la prueba, o no?
>
>> A la tabla en cuestión le hacemos "count/reindex" desde pgadmin y sale
>> ok, pero en ciertas
>> consultas tira este error.
> Hm, raro .. si hay algo corrupto, deberían detectarlo, aunque si tienes
> campos "varlena" que no están cubiertos por ningún índice, podría no ser
> descubierto. Si hiciste count(*) entonces el motor no se molestará en
> ver los valores de los campos, tampoco.
>
Hola Alvaro gracias por responder tan rápido

Cuando digo se me "clavo" hablo de un kernel panic del SO(perdon...).

Actualmente le pase desde pgadmin las siguientes pruebas
Reindex
ERROR: index row requires 1048608 bytes, maximum size is 8191

VACUUM:
INFO: vacuuming "public.ncaft00"
INFO: index "ncaft00_pkey" now contains 294740 row versions in 2551 pages
DETALLE: 0 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.01s/0.00u sec elapsed 0.01 sec.
INFO: index "incaft0010" now contains 294741 row versions in 5268 pages
DETALLE: 0 index row versions were removed.
1247 index pages have been deleted, 1247 are currently reusable.
CPU 0.01s/0.00u sec elapsed 0.03 sec.
INFO: index "incaft0011" now contains 294741 row versions in 6560 pages
DETALLE: 0 index row versions were removed.
1785 index pages have been deleted, 1785 are currently reusable.
CPU 0.02s/0.00u sec elapsed 0.03 sec.
INFO: index "incaft0012" now contains 294741 row versions in 6696 pages
DETALLE: 0 index row versions were removed.
1677 index pages have been deleted, 1677 are currently reusable.
CPU 0.02s/0.00u sec elapsed 0.04 sec.
INFO: index "incaft0013" now contains 294741 row versions in 5301 pages
DETALLE: 0 index row versions were removed.
1319 index pages have been deleted, 1319 are currently reusable.
CPU 0.01s/0.00u sec elapsed 0.03 sec.
INFO: index "incaft0014" now contains 294741 row versions in 6914 pages
DETALLE: 0 index row versions were removed.
1698 index pages have been deleted, 1698 are currently reusable.
CPU 0.03s/0.00u sec elapsed 0.05 sec.
INFO: index "incaft002" now contains 294741 row versions in 4864 pages
DETALLE: 0 index row versions were removed.
1358 index pages have been deleted, 1358 are currently reusable.
CPU 0.02s/0.00u sec elapsed 0.04 sec.
INFO: index "incaft003" now contains 294741 row versions in 4892 pages
DETALLE: 0 index row versions were removed.
1020 index pages have been deleted, 1020 are currently reusable.
CPU 0.02s/0.00u sec elapsed 0.05 sec.
INFO: index "incaft004" now contains 294741 row versions in 4823 pages
DETALLE: 0 index row versions were removed.
1069 index pages have been deleted, 1069 are currently reusable.
CPU 0.03s/0.00u sec elapsed 0.05 sec.
INFO: index "incaft005" now contains 294741 row versions in 5118 pages
DETALLE: 0 index row versions were removed.
1213 index pages have been deleted, 1213 are currently reusable.
CPU 0.02s/0.00u sec elapsed 0.05 sec.
INFO: index "incaft006" now contains 294741 row versions in 5298 pages
DETALLE: 0 index row versions were removed.
1294 index pages have been deleted, 1294 are currently reusable.
CPU 0.02s/0.01u sec elapsed 0.05 sec.
INFO: index "incaft007" now contains 294741 row versions in 5321 pages
DETALLE: 0 index row versions were removed.
1278 index pages have been deleted, 1278 are currently reusable.
CPU 0.03s/0.00u sec elapsed 0.06 sec.
INFO: index "incaft008" now contains 294741 row versions in 5272 pages
DETALLE: 0 index row versions were removed.
1247 index pages have been deleted, 1247 are currently reusable.
CPU 0.03s/0.00u sec elapsed 0.05 sec.
INFO: index "incaft009" now contains 294741 row versions in 5328 pages
DETALLE: 0 index row versions were removed.
1333 index pages have been deleted, 1333 are currently reusable.
CPU 0.02s/0.01u sec elapsed 0.05 sec.
INFO: index "uncaft001" now contains 294741 row versions in 2291 pages
DETALLE: 0 index row versions were removed.
1 index pages have been deleted, 1 are currently reusable.
CPU 0.02s/0.00u sec elapsed 0.03 sec.
INFO: index "uncaft002" now contains 294741 row versions in 2241 pages
DETALLE: 0 index row versions were removed.
10 index pages have been deleted, 10 are currently reusable.
CPU 0.01s/0.00u sec elapsed 0.03 sec.
INFO: index "uncaft003" now contains 294741 row versions in 3365 pages
DETALLE: 0 index row versions were removed.
368 index pages have been deleted, 368 are currently reusable.
CPU 0.02s/0.00u sec elapsed 0.04 sec.
INFO: index "uncaft004" now contains 294741 row versions in 6198 pages
DETALLE: 0 index row versions were removed.
4 index pages have been deleted, 4 are currently reusable.
CPU 0.04s/0.00u sec elapsed 0.06 sec.
INFO: "ncaft00": found 0 removable, 291280 nonremovable row versions in
86323 out of 86753 pages
DETALLE: 0 dead row versions cannot be removed yet.
There were 927022 unused item pointers.
0 pages are entirely empty.
CPU 0.57s/0.32u sec elapsed 1.16 sec.
INFO: vacuuming "pg_toast.pg_toast_309805806"
INFO: index "pg_toast_309805806_index" now contains 29 row versions in
2 pages
DETALLE: 0 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO: "pg_toast_309805806": found 0 removable, 29 nonremovable row
versions in 8 out of 8 pages
DETALLE: 0 dead row versions cannot be removed yet.
There were 19 unused item pointers.
0 pages are entirely empty.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
Tiempo total de ejecución de la consulta: 1244 ms.

VACUUM FULL:
INFO: vacuuming "public.ncaft00"
ERROR: invalid memory alloc request size 1496187552

VACUUM FREEZE:

NFO: vacuuming "public.ncaft00"
INFO: index "ncaft00_pkey" now contains 294740 row versions in 2551 pages
DETALLE: 0 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.00s/0.00u sec elapsed 0.01 sec.
INFO: index "incaft0010" now contains 294741 row versions in 5268 pages
DETALLE: 0 index row versions were removed.
1247 index pages have been deleted, 1247 are currently reusable.
CPU 0.00s/0.01u sec elapsed 0.14 sec.
INFO: index "incaft0011" now contains 294741 row versions in 6560 pages
DETALLE: 0 index row versions were removed.
1785 index pages have been deleted, 1785 are currently reusable.
CPU 0.00s/0.02u sec elapsed 0.04 sec.
INFO: index "incaft0012" now contains 294741 row versions in 6696 pages
DETALLE: 0 index row versions were removed.
1677 index pages have been deleted, 1677 are currently reusable.
CPU 0.02s/0.00u sec elapsed 0.04 sec.
INFO: index "incaft0013" now contains 294741 row versions in 5301 pages
DETALLE: 0 index row versions were removed.
1319 index pages have been deleted, 1319 are currently reusable.
CPU 0.02s/0.00u sec elapsed 0.03 sec.
INFO: index "incaft0014" now contains 294741 row versions in 6914 pages
DETALLE: 0 index row versions were removed.
1698 index pages have been deleted, 1698 are currently reusable.
CPU 0.01s/0.01u sec elapsed 0.03 sec.
INFO: index "incaft002" now contains 294741 row versions in 4864 pages
DETALLE: 0 index row versions were removed.
1358 index pages have been deleted, 1358 are currently reusable.
CPU 0.01s/0.00u sec elapsed 0.03 sec.
INFO: index "incaft003" now contains 294741 row versions in 4892 pages
DETALLE: 0 index row versions were removed.
1020 index pages have been deleted, 1020 are currently reusable.
CPU 0.01s/0.00u sec elapsed 0.02 sec.
INFO: index "incaft004" now contains 294741 row versions in 4823 pages
DETALLE: 0 index row versions were removed.
1069 index pages have been deleted, 1069 are currently reusable.
CPU 0.01s/0.00u sec elapsed 0.02 sec.
INFO: index "incaft005" now contains 294741 row versions in 5118 pages
DETALLE: 0 index row versions were removed.
1213 index pages have been deleted, 1213 are currently reusable.
CPU 0.00s/0.01u sec elapsed 0.03 sec.
INFO: index "incaft006" now contains 294741 row versions in 5298 pages
DETALLE: 0 index row versions were removed.
1294 index pages have been deleted, 1294 are currently reusable.
CPU 0.01s/0.00u sec elapsed 0.03 sec.
INFO: index "incaft007" now contains 294741 row versions in 5321 pages
DETALLE: 0 index row versions were removed.
1278 index pages have been deleted, 1278 are currently reusable.
CPU 0.01s/0.00u sec elapsed 0.04 sec.
INFO: index "incaft008" now contains 294741 row versions in 5272 pages
DETALLE: 0 index row versions were removed.
1247 index pages have been deleted, 1247 are currently reusable.
CPU 0.01s/0.00u sec elapsed 0.03 sec.
INFO: index "incaft009" now contains 294741 row versions in 5328 pages
DETALLE: 0 index row versions were removed.
1333 index pages have been deleted, 1333 are currently reusable.
CPU 0.01s/0.00u sec elapsed 0.03 sec.
INFO: index "uncaft001" now contains 294741 row versions in 2291 pages
DETALLE: 0 index row versions were removed.
1 index pages have been deleted, 1 are currently reusable.
CPU 0.00s/0.00u sec elapsed 0.01 sec.
INFO: index "uncaft002" now contains 294741 row versions in 2241 pages
DETALLE: 0 index row versions were removed.
10 index pages have been deleted, 10 are currently reusable.
CPU 0.01s/0.00u sec elapsed 0.08 sec.
INFO: index "uncaft003" now contains 294741 row versions in 3365 pages
DETALLE: 0 index row versions were removed.
368 index pages have been deleted, 368 are currently reusable.
CPU 0.01s/0.00u sec elapsed 0.13 sec.
INFO: index "uncaft004" now contains 294741 row versions in 6198 pages
DETALLE: 0 index row versions were removed.
4 index pages have been deleted, 4 are currently reusable.
CPU 0.01s/0.00u sec elapsed 0.08 sec.
INFO: "ncaft00": found 0 removable, 294773 nonremovable row versions in
86753 out of 86753 pages
DETALLE: 0 dead row versions cannot be removed yet.
There were 928277 unused item pointers.
0 pages are entirely empty.
CPU 0.62s/1.99u sec elapsed 8.70 sec.
INFO: vacuuming "pg_toast.pg_toast_309805806"
INFO: index "pg_toast_309805806_index" now contains 29 row versions in
2 pages
DETALLE: 0 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO: "pg_toast_309805806": found 0 removable, 29 nonremovable row
versions in 8 out of 8 pages
DETALLE: 0 dead row versions cannot be removed yet.
There were 19 unused item pointers.
0 pages are entirely empty.
CPU 0.00s/0.00u sec elapsed 0.00 sec.

Tiempo total de ejecución de la consulta: 8772 ms.

VACUUM ANALIZE:
INFO: vacuuming "public.ncaft00"
INFO: index "ncaft00_pkey" now contains 294740 row versions in 2551 pages
DETALLE: 0 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.00s/0.01u sec elapsed 0.01 sec.
INFO: index "incaft0010" now contains 294741 row versions in 5268 pages
DETALLE: 0 index row versions were removed.
1247 index pages have been deleted, 1247 are currently reusable.
CPU 0.00s/0.00u sec elapsed 0.04 sec.
INFO: index "incaft0011" now contains 294741 row versions in 6560 pages
DETALLE: 0 index row versions were removed.
1785 index pages have been deleted, 1785 are currently reusable.
CPU 0.02s/0.00u sec elapsed 0.03 sec.
INFO: index "incaft0012" now contains 294741 row versions in 6696 pages
DETALLE: 0 index row versions were removed.
1677 index pages have been deleted, 1677 are currently reusable.
CPU 0.01s/0.01u sec elapsed 0.05 sec.
INFO: index "incaft0013" now contains 294741 row versions in 5301 pages
DETALLE: 0 index row versions were removed.
1319 index pages have been deleted, 1319 are currently reusable.
CPU 0.00s/0.01u sec elapsed 0.03 sec.
INFO: index "incaft0014" now contains 294741 row versions in 6914 pages
DETALLE: 0 index row versions were removed.
1698 index pages have been deleted, 1698 are currently reusable.
CPU 0.00s/0.02u sec elapsed 0.03 sec.
INFO: index "incaft002" now contains 294741 row versions in 4864 pages
DETALLE: 0 index row versions were removed.
1358 index pages have been deleted, 1358 are currently reusable.
CPU 0.02s/0.00u sec elapsed 0.02 sec.
INFO: index "incaft003" now contains 294741 row versions in 4892 pages
DETALLE: 0 index row versions were removed.
1020 index pages have been deleted, 1020 are currently reusable.
CPU 0.01s/0.00u sec elapsed 0.02 sec.
INFO: index "incaft004" now contains 294741 row versions in 4823 pages
DETALLE: 0 index row versions were removed.
1069 index pages have been deleted, 1069 are currently reusable.
CPU 0.02s/0.00u sec elapsed 0.02 sec.
INFO: index "incaft005" now contains 294741 row versions in 5118 pages
DETALLE: 0 index row versions were removed.
1213 index pages have been deleted, 1213 are currently reusable.
CPU 0.02s/0.00u sec elapsed 0.04 sec.
INFO: index "incaft006" now contains 294741 row versions in 5298 pages
DETALLE: 0 index row versions were removed.
1294 index pages have been deleted, 1294 are currently reusable.
CPU 0.02s/0.00u sec elapsed 0.03 sec.
INFO: index "incaft007" now contains 294741 row versions in 5321 pages
DETALLE: 0 index row versions were removed.
1278 index pages have been deleted, 1278 are currently reusable.
CPU 0.01s/0.00u sec elapsed 0.03 sec.
INFO: index "incaft008" now contains 294741 row versions in 5272 pages
DETALLE: 0 index row versions were removed.
1247 index pages have been deleted, 1247 are currently reusable.
CPU 0.01s/0.00u sec elapsed 0.02 sec.
INFO: index "incaft009" now contains 294741 row versions in 5328 pages
DETALLE: 0 index row versions were removed.
1333 index pages have been deleted, 1333 are currently reusable.
CPU 0.01s/0.00u sec elapsed 0.02 sec.
INFO: index "uncaft001" now contains 294741 row versions in 2291 pages
DETALLE: 0 index row versions were removed.
1 index pages have been deleted, 1 are currently reusable.
CPU 0.00s/0.00u sec elapsed 0.01 sec.
INFO: index "uncaft002" now contains 294741 row versions in 2241 pages
DETALLE: 0 index row versions were removed.
10 index pages have been deleted, 10 are currently reusable.
CPU 0.00s/0.00u sec elapsed 0.01 sec.
INFO: index "uncaft003" now contains 294741 row versions in 3365 pages
DETALLE: 0 index row versions were removed.
368 index pages have been deleted, 368 are currently reusable.
CPU 0.01s/0.00u sec elapsed 0.03 sec.
INFO: index "uncaft004" now contains 294741 row versions in 6198 pages
DETALLE: 0 index row versions were removed.
4 index pages have been deleted, 4 are currently reusable.
CPU 0.00s/0.01u sec elapsed 0.03 sec.
INFO: "ncaft00": found 0 removable, 41 nonremovable row versions in 31
out of 86753 pages
DETALLE: 0 dead row versions cannot be removed yet.
There were 581 unused item pointers.
0 pages are entirely empty.
CPU 0.22s/0.13u sec elapsed 0.57 sec.
INFO: vacuuming "pg_toast.pg_toast_309805806"
INFO: index "pg_toast_309805806_index" now contains 29 row versions in
2 pages
DETALLE: 0 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO: "pg_toast_309805806": found 0 removable, 29 nonremovable row
versions in 8 out of 8 pages
DETALLE: 0 dead row versions cannot be removed yet.
There were 19 unused item pointers.
0 pages are entirely empty.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO: analyzing "public.ncaft00"
INFO: "ncaft00": scanned 15000 of 86753 pages, containing 50757 live
rows and 0 dead rows; 15000 rows in sample, 293555 estimated total rows
Tiempo total de ejecución de la consulta: 3139 ms.

nuevamente un vacuum full
INFO: vacuuming "public.ncaft00"
ERROR: invalid memory alloc request size 1496187552

ME llama mucho la atención el error del reindex.

Alguna sugerencia que me pueda ayudar?
gracias por adelantado nuevamente

-
Enviado a la lista de correo pgsql-es-ayuda (pgsql-es-ayuda(at)postgresql(dot)org)
Para cambiar tu suscripción:
http://www.postgresql.org/mailpref/pgsql-es-ayuda