IDS 7.23 Problem - Please help !!!
Posted in 1999
Topics: Backup & Restore, Storage & Space Management, Error Codes & Troubleshooting, Logging & Checkpoints, Platform-Specific Issues, Versions, Editions & End-of-Life
We are running IDS 7.23 UC6 under AIX 4.2.1 in a IBM F50 machine
Today we've had a problem with our database. It went down suddenly, and we
just don't understand what happened. I hope somebody can help us.
At the time of the crash, the database sent a message to the terminal wich was
executing the backup of the logical logs (ontape -c):
Logbackup failed - buc_fe.c : Archive API processing failed at line 422
The log file is listed below.
LOG FILE ======== 15:48:07 Logical Log 19096 - Backup Completed 15:52:40
Checkpoint Completed: duration was 3 seconds. 15:54:23 Logical Log 19097
Complete. 15:54:24 Process exited with return code 255: /bin/sh /bin/sh -c
usr/informix/etc/log_full.sh 2 23 "Logical Log 19097 Complete." "Logical Log
19097 Complete." 15:54:27 Logical Log 19097 - Backup Started 15:54:28
Logical Log 19097 - Backup Completed 15:57:43 Checkpoint Completed: duration
was 2 seconds. 16:00:12 Logical Log 19098 Complete. 16:00:13 Logical Log
19098 - Backup Started 16:00:13 Process exited with return code 255: /bin/sh
/bin/sh -c /usr/informix/etc/log_full.sh 2 23 "Logical Log 19098 Complete."
"Logical Log 19098 Complete." 16:00:14 Logical Log 19098 - Backup Completed
16:02:44 Assert Failed: Internal Error - Segmentation Violation 16:02:44
Who: Thread(20, flush_sub(4), 4003b554, 1) 16:02:44 Results: OnLine mustabort 16:02:44 Action: Reinitialize shared memory 16:02:44 See Also:
/tmp/af.147053 16:02:44 rsinit.c, line 9968, thread 20, proc id 16460,
Segmentation Violation. 16:02:44 PANIC: Attempting to bring system down
Tue Mar 9 16:58:27 1999
16:58:27 Event alarms enabled. ALARMPROG = '/usr/informix/etc/log_full.sh'
16:58:33 DR: DRAUTO is 0 (Off)
16:58:33 AIX MP latch code enabled
16:58:35
16:58:35
16:58:35 INFORMIX-OnLine Initialized -- Shared Memory Initialized.
16:58:35 Physical Recovery Started.
16:58:35
16:58:36 Physical Recovery Complete: 397 Pages Restored.
16:58:36 Logical Recovery Started.
16:58:39 Logical Recovery Complete.312 Committed, 1 Rolled Back, 0 Open, 0 Bad Locks
16:58:40 Dataskip is now OFF for all dbspaces
16:58:43 Checkpoint Completed: duration was 3 seconds.
16:58:43 Dropping temporary TBLspace 1000e0, recovering 8 pages.
16:58:43 Dropping temporary TBLspace 1000e1, recovering 8 pages.
16:58:43 Dropping temporary TBLspace 1000e2, recovering 8 pages.
16:58:43 Dropping temporary TBLspace 1000e3, recovering 8 pages.
16:58:43 Dropping temporary TBLspace 1000e4, recovering 8 pages.
16:58:43 Dropping temporary TBLspace 1000e5, recovering 8 pages.
16:58:43 Dropping temporary TBLspace 1000e6, recovering 8 pages.
16:58:43 Dropping temporary TBLspace 1000e7, recovering 8 pages.
16:58:43 On-Line Mode
16:58:43 Affinity not enabled for this server
16:59:07 Logical Log 19099 Complete.
16:59:09 Process exited with return code 255: /bin/sh /bin/sh -c/usr/informix/etc/log_full.sh 2 23 "Logical Log 19099 Complete." "Logical Log
19099 Complete."
16:59:40 Logical Log 19100 Complete.
16:59:42 Process exited with return code 255: /bin/sh /bin/sh -c/usr/informix/etc/log_full.sh 2 23 "Logical Log 19100 Complete." "Logical Log
19100 Complete."
17:00:15 Logical Log 19101 Complete.
17:00:16 Process exited with return code 255: /bin/sh /bin/sh -c/usr/informix/etc/log_full.sh 2 23 "Logical Log 19101 Complete." "Logical Log
19101 Complete."
The database now is online, working normally.
Can somebody help us ???
TIA
Paulo Roberto Marelli de Amorim
TS&0 Consulting
Brasil
5511-9900-3644
-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Send this log info with the contents of the /tmp/af.147053 file to
your friendly Informix Support Tech (800-274-8184 in the USA). The
assert failure (af.*) file contents have been signicantly enhanced in
7.3x - ask the tech about upgrade issues.
-Kevyn
On Thu, 11 Mar 1999 13:17:20 GMT, Paulo Amorim
<pauloamorim@uol.com.br> wrote:
>We are running IDS 7.23 UC6 under AIX 4.2.1 in a IBM F50 machine
>
>Today we've had a problem with our database. It went down suddenly, and we
>just don't understand what happened. I hope somebody can help us.
>
>At the time of the crash, the database sent a message to the terminal wich was
>executing the backup of the logical logs (ontape -c):
>
>Logbackup failed - buc_fe.c : Archive API processing failed at line 422
>
>The log file is listed below.
>
>LOG FILE ======== 15:48:07 Logical Log 19096 - Backup Completed 15:52:40
>Checkpoint Completed: duration was 3 seconds. 15:54:23 Logical Log 19097
>Complete. 15:54:24 Process exited with return code 255: /bin/sh /bin/sh -c
>usr/informix/etc/log_full.sh 2 23 "Logical Log 19097 Complete." "Logical Log
>19097 Complete." 15:54:27 Logical Log 19097 - Backup Started 15:54:28
>Logical Log 19097 - Backup Completed 15:57:43 Checkpoint Completed: duration
>was 2 seconds. 16:00:12 Logical Log 19098 Complete. 16:00:13 Logical Log
>19098 - Backup Started 16:00:13 Process exited with return code 255: /bin/sh
>/bin/sh -c /usr/informix/etc/log_full.sh 2 23 "Logical Log 19098 Complete."
>"Logical Log 19098 Complete." 16:00:14 Logical Log 19098 - Backup Completed
>16:02:44 Assert Failed: Internal Error - Segmentation Violation 16:02:44
>Who: Thread(20, flush_sub(4), 4003b554, 1) 16:02:44 Results: OnLine must>abort 16:02:44 Action: Reinitialize shared memory 16:02:44 See Also:
>/tmp/af.147053 16:02:44 rsinit.c, line 9968, thread 20, proc id 16460,
>Segmentation Violation. 16:02:44 PANIC: Attempting to bring system down
>
>Tue Mar 9 16:58:27 1999
>
>16:58:27 Event alarms enabled. ALARMPROG = '/usr/informix/etc/log_full.sh'
>16:58:33 DR: DRAUTO is 0 (Off)
>16:58:33 AIX MP latch code enabled
>16:58:35
>16:58:35
>16:58:35 INFORMIX-OnLine Initialized -- Shared Memory Initialized.
>16:58:35 Physical Recovery Started.
>16:58:35
>16:58:36 Physical Recovery Complete: 397 Pages Restored.
>16:58:36 Logical Recovery Started.
>16:58:39 Logical Recovery Complete.>312 Committed, 1 Rolled Back, 0 Open, 0 Bad Locks
>16:58:40 Dataskip is now OFF for all dbspaces
>16:58:43 Checkpoint Completed: duration was 3 seconds.
>16:58:43 Dropping temporary TBLspace 1000e0, recovering 8 pages.
>16:58:43 Dropping temporary TBLspace 1000e1, recovering 8 pages.
>16:58:43 Dropping temporary TBLspace 1000e2, recovering 8 pages.
>16:58:43 Dropping temporary TBLspace 1000e3, recovering 8 pages.
>16:58:43 Dropping temporary TBLspace 1000e4, recovering 8 pages.
>16:58:43 Dropping temporary TBLspace 1000e5, recovering 8 pages.
>16:58:43 Dropping temporary TBLspace 1000e6, recovering 8 pages.
>16:58:43 Dropping temporary TBLspace 1000e7, recovering 8 pages.
>16:58:43 On-Line Mode
>16:58:43 Affinity not enabled for this server
>
>16:59:07 Logical Log 19099 Complete.
>16:59:09 Process exited with return code 255: /bin/sh /bin/sh -c>/usr/informix/etc/log_full.sh 2 23 "Logical Log 19099 Complete." "Logical Log
>19099 Complete."
>16:59:40 Logical Log 19100 Complete.
>16:59:42 Process exited with return code 255: /bin/sh /bin/sh -c>/usr/informix/etc/log_full.sh 2 23 "Logical Log 19100 Complete." "Logical Log
>19100 Complete."
>17:00:15 Logical Log 19101 Complete.
>17:00:16 Process exited with return code 255: /bin/sh /bin/sh -c>/usr/informix/etc/log_full.sh 2 23 "Logical Log 19101 Complete." "Logical Log
>19101 Complete."
>
>
>The database now is online, working normally.
>Can somebody help us ???
>
>TIA
>
>Paulo Roberto Marelli de Amorim
>TS&0 Consulting
>Brasil
>5511-9900-3644
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own