Buenas tardes, nos sucede esto en la instancia de Produccion de la unversidad, y a días de inscripción de materias (como de costumbre en el momento justo)
Les consulto por un problema que nos surgió al reiniciar informix porqué estaba colgado por tanta concurrencia.
Resulta que no lo pudimos levantar, con oninit -v se queda colgado en ‘Checking for temporary tables to drop…’
les envío los logs:
onstat -m
16:19:46 Physical Recovery Started at Page (1:136363).
16:20:14 Dynamically allocated new virtual shared memory segment (size 8192KB)
16:20:56 Dynamically allocated new virtual shared memory segment (size 8192KB)
16:21:56 Dynamically allocated new virtual shared memory segment (size 8192KB)
16:22:31 Dynamically allocated new virtual shared memory segment (size 15168KB)
16:22:31 Physical Recovery Complete: 404128 Pages Examined, 403530 Pages Restored.
16:22:31 Logical Recovery Started.
16:22:31 10 recovery worker threads will be started.
16:22:31 Dynamically allocated new virtual shared memory segment (size 8192KB)
16:22:35 Logical Recovery has reached the transaction cleanup phase.
16:22:35 Logical Recovery Complete.
774 Committed, 2 Rolled Back, 0 Open, 0 Bad Locks
16:22:36 Dataskip is now OFF for all dbspaces
16:22:38 Logical Log Files are Full – Backup is Needed
onstat -l
IBM Informix Dynamic Server Version 10.00.UC2E – Quiescent (CKPT REQ) – Up 00:04:53 – 67252 Kbytes
Blocked:CKPT
Physical Logging
Buffer bufused bufsize numpages numwrits pages/io
P-2 0 16 0 0 0.00
phybegin physize phypos phyused %used
1:263 1024000 567170 431070 42.10
Logical Logging
Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
L-1 1 16 0 0 0 0.0 0.0
Subsystem numrecs Log Space used
Buffer Waiting
Buffer ioproc flags
L-1 444f9018 0x1 0
address number flags uniqid begin size used %used
445330b0 2 U-B---- 2348 1:1074263 50000 50000 100.00
445330f8 3 U-B---- 2349 1:1124263 50000 50000 100.00
44533140 4 U-B---- 2350 1:1174263 50000 50000 100.00
44533188 5 U-B---- 2351 1:1224263 50000 50000 100.00
445331d0 6 U-B-C-L 2352 1:1274263 50000 50000 100.00
44533218 7 U—C-- 2353 1:1324263 50000 4461 8.92
44533260 8 U-B---- 2340 1:1374263 50000 50000 100.00
445332a8 9 U-B---- 2341 1:1424263 50000 50000 100.00
445332f0 1 U-B---- 2342 3:992903 18750 18750 100.00
44533338 12 U-B---- 2343 1:1041394 17187 17187 100.00
44533380 13 U-B---- 2344 1:1805163 16796 16796 100.00
445333c8 14 U-B---- 2345 1:1854048 16699 16699 100.00
44533410 10 U-B---- 2346 1:1474263 50000 50000 100.00
44533458 11 U-B---- 2347 1:1581049 25000 25000 100.00
14 active, 14 total
Adjunto el onconfig.
Estoy intentando backupear los logs con ontape -a pero se queda ‘colgado’ o no se si termina, en este momento lo estoy dejando correr pero no da indicios de nada.
Entiendo que es un tema de los checkpoint al intentar levantar de nuevo pero como podría solucionarlo ???
Saludos
onconfig.ol_desarrollo.txt (11.2 KB)