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@postgresql.org) Para cambiar tu suscripción: http://www.postgresql.org/mailpref/pgsql-es-ayuda
