Backup Crash (More information)

Hi, I have this error when I try to make a full backup on my system (Informix Online Workgroup Server 7.22, NT 4.0 SP3) 1999-05-14 12:48:19 296 0 D:\\Informix\\BIN\\onbar -b -w -L 0 1999-05-14 12:48:22 296 0 Begin level 0 backup rootdbs. 1999-05-14 12:48:23 296 0 Successfully connected to Storage Manager. 1999-05-14 12:48:29 296 0 Completed level 0 backup rootdbs. 1999-05-14 12:48:45 296 0 A system error occurred. Aborting XBSA session. 1999-05-14 12:48:45 296 0 A system error occurred. Aborting XBSA session. 1999-05-14 12:52:58 251 0 D:\\Informix\\BIN\\onbar -b -w -L 0 1999-05-14 12:52:59 251 0 Begin level 0 backup rootdbs. 1999-05-14 12:52:59 251 0 Successfully connected to Storage Manager. 1999-05-14 12:53:05 251 0 Completed level 0 backup rootdbs. 1999-05-14 12:53:29 251 0 Begin level 0 backup ol_summittech. 1999-05-14 12:54:40 251 0 Completed level 0 backup ol_summittech. 1999-05-14 12:58:03 251 0 SQL -239 Could not insert new row - duplicate value in a UNIQUE INDEX column. 1999-05-14 12:58:03 251 0 ISAM -100 ISAM error: duplicate value for a record with unique key. After my previous post, I made some research and found information about this Bug. 74755 ONBAR REPORTS -239/-100 ERROR WHEN CREATING LEVEL 0 ARCHIVE AFTER THE PHYSICAL LOG OR LOGICAL LOGS WERE MOVED TO A NEW DBSPACE. Does someone know any Workaround for this bug ? Best regards, Philippe Fornaciari Summit Technologies International p.fornaciari@summittechnologies.com

Philippe, here is the workaround for the bug: Try to update your sysutils:bar_object table: obj_srv_name obj_oid obj_name obj_type anilk_shm 9 dbs1 ND You have to change the obj_type from "ND" (Non-critical Dbspace) to "CD" (Critical Dbspace) for that dbspace where the PHYSICAL LOG or LOGICAL LOG now resides e.g update bar_object set obj_type = "CD" where obj_name = "dbs1"; --Anil Karkera Philippe Fornaciari wrote: > Hi, > > I have this error when I try to make a full backup on my system > (Informix Online Workgroup Server 7.22, NT 4.0 SP3) > > 1999-05-14 12:48:19 296 0 D:\\Informix\\BIN\\onbar -b -w -L 0 > 1999-05-14 12:48:22 296 0 Begin level 0 backup rootdbs. > 1999-05-14 12:48:23 296 0 Successfully connected to Storage Manager. > 1999-05-14 12:48:29 296 0 Completed level 0 backup rootdbs. > 1999-05-14 12:48:45 296 0 A system error occurred. Aborting XBSA session. > 1999-05-14 12:48:45 296 0 A system error occurred. Aborting XBSA session. > 1999-05-14 12:52:58 251 0 D:\\Informix\\BIN\\onbar -b -w -L 0 > 1999-05-14 12:52:59 251 0 Begin level 0 backup rootdbs. > 1999-05-14 12:52:59 251 0 Successfully connected to Storage Manager. > 1999-05-14 12:53:05 251 0 Completed level 0 backup rootdbs. > 1999-05-14 12:53:29 251 0 Begin level 0 backup ol_summittech. > 1999-05-14 12:54:40 251 0 Completed level 0 backup ol_summittech. > 1999-05-14 12:58:03 251 0 SQL -239 Could not insert new row - duplicate > value in a UNIQUE INDEX column. > 1999-05-14 12:58:03 251 0 ISAM -100 ISAM error: duplicate value > for a record with unique key. > > After my previous post, I made some research and found information about > this Bug. > > 74755 ONBAR REPORTS -239/-100 ERROR WHEN CREATING LEVEL 0 ARCHIVE > AFTER THE PHYSICAL LOG OR LOGICAL LOGS WERE MOVED TO A NEW DBSPACE. > > Does someone know any Workaround for this bug ? > > Best regards, > > Philippe Fornaciari > Summit Technologies International > p.fornaciari@summittechnologies.com