onbar error 151

Hello, I start ism and run onbar but after one day working right I receive this error where I try to do a backup for L0, L1 and L2 but onbar -b -C works right. 2016-01-22 04:00:01 15482 15480 /opt/IBM/informix/bin/onbar_d -b -L 2 2016-01-22 03:57:56* 15433 15431 (-43207) Unable to open connection to database server: TIMEOUT. 2016-01-22 03:57:56* 15433 15431 Process 15433 received signal 14; process exiting with code 151 (0x97). 2016-01-22 04:10:01 15532 15530 (-43061) BAR_MAX_BACKUP has been reduced to 5919 to avoid allocating more than SHMTOTAL KB. 2016-01-22 04:10:01 15532 15530 (-43141) The edition of Informix Dynamic Server currently running restricts the number of parallel backup or restore processes to 1. Resetting BAR_MAX_BACKUP to 1. Also I checked user and group informix and it seems right: id informix uid=1001(informix) gid=1001(informix) groups=1001(informix) Any idea? Regards. --94eb2c06a88c8b2d710529e8bd09

Hi, What is the state of the IDS, can you send us the output of: onstat - You're logged as the user informix? Keen regards. On Fri, 22 Jan 2016 at 09:22 Juan Francisco González Navarro < jfrancisco.navarro@gmail.com> wrote: > Hello, > > I start ism and run onbar but after one day working right I receive this > error where I try to do a backup for L0, L1 and L2 but onbar -b -C works > right. > > 2016-01-22 04:00:01 15482 15480 /opt/IBM/informix/bin/onbar_d -b -L 2 > 2016-01-22 03:57:56* 15433 15431 (-43207) Unable to open connection to > database server: TIMEOUT. > 2016-01-22 03:57:56* 15433 15431 Process 15433 received signal 14; > process exiting with code 151 (0x97). > 2016-01-22 04:10:01 15532 15530 (-43061) BAR_MAX_BACKUP has been reduced > to 5919 to avoid allocating more > than SHMTOTAL KB. > 2016-01-22 04:10:01 15532 15530 (-43141) The edition of Informix Dynamic > Server currently running restricts the > number of parallel backup or restore processes to 1. Resetting > BAR_MAX_BACKUP > to 1.> > Also I checked user and group informix and it seems right: > > id informix > uid=1001(informix) gid=1001(informix) groups=1001(informix) > > Any idea? > > Regards. > > --94eb2c06a88c8b2d710529e8bd09 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11405526d0dcfe0529ea8bd5

Hello IBM Informix Dynamic Server Version 11.70.FC8GE -- On-Line -- Up 29 days 18:39:42 -- 3857968 Kbytes An I tried login as root and also as informix and also as root doing su - informix The id of user and group informing are uid=1001(informix) gid=1001(informix) groups=1001(informix) Thank you On Jan 22, 2016 12:31 PM, "Ricardo Henriques" < ricardoaireshenriques@gmail.com> wrote: > Hi, > > What is the state of the IDS, can you send us the output of: > > onstat - > > You're logged as the user informix? > > Keen regards. > > On Fri, 22 Jan 2016 at 09:22 Juan Francisco González Navarro < > jfrancisco.navarro@gmail.com> wrote: > > > Hello, > > > > I start ism and run onbar but after one day working right I receive this > > error where I try to do a backup for L0, L1 and L2 but onbar -b -C works > > right. > > > > 2016-01-22 04:00:01 15482 15480 /opt/IBM/informix/bin/onbar_d -b -L 2 > > 2016-01-22 03:57:56* 15433 15431 (-43207) Unable to open connection to > > database server: TIMEOUT. > > 2016-01-22 03:57:56* 15433 15431 Process 15433 received signal 14; > > process exiting with code 151 (0x97). > > 2016-01-22 04:10:01 15532 15530 (-43061) BAR_MAX_BACKUP has been reduced > > to 5919 to avoid allocating more > > than SHMTOTAL KB. > > 2016-01-22 04:10:01 15532 15530 (-43141) The edition of Informix Dynamic > > Server currently running restricts the > > number of parallel backup or restore processes to 1. Resetting > > BAR_MAX_BACKUP > > to 1.> > > > Also I checked user and group informix and it seems right: > > > > id informix > > uid=1001(informix) gid=1001(informix) groups=1001(informix) > > > > Any idea? > > > > Regards. > > > > --94eb2c06a88c8b2d710529e8bd09 > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --001a11405526d0dcfe0529ea8bd5 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e01538da01293e50529eb83f8

The log you show has three different operations. 1. 2016-01-22 04:00:01 15482 15480 /opt/IBM/informix/bin/onbar_d -b -L 2 This only shows us the start of the process. 2. 2016-01-22 03:57:56* 15433 15431 (-43207) Unable to open connection to database server: TIMEOUT. 2016-01-22 03:57:56* 15433 15431 Process 15433 received signal 14; process exiting with code 151 (0x97). This operation hints a problem, time out, connecting to the database server. Hence I've asked the status of the instance. 3. 2016-01-22 04:10:01 15532 15530 (-43061) BAR_MAX_BACKUP has been reduced to 5919 to avoid allocating more than SHMTOTAL KB. 2016-01-22 04:10:01 15532 15530 (-43141) The edition of Informix Dynamic Server currently running restricts the number of parallel backup or restore processes to 1. Resetting BAR_MAX_BACKUP to 1. Those are only warnings, seems like Growth Edition doesnt support Parallel operations. Try again to issue the backup look to the log only for that operation and see if the error is the same. One way to get more info on the subject is to change the BAR_DEBUG and BAR_DEBUG_LOG. In the 11.70 you can change it by editing the onconfig directly. The values for BAR_DEBUG are: 0 = Do not display debugging information. 1 = Print a small amount of information 2 = Print a message every time ON-Bar: Enters a function. Exits a function. The message includes the return code for the function. 3 = Print exit and entry information with additional details. 4 = Also print information about ON-Bar parallel operations. 5 = Also print information about: Objects that are being backed up or restored. The act_node structure corresponding with the bar_action table. 6 = Print additional information about: Objects that are being backed up or restored. The act_node structure corresponding with the bar_action table. 7 = Also print: Information about the contents of the ins_node structure corresponding with the bar_instance table. Information about modifications to the bar_action table. Information about logical logs and objects that are restored. SQL statements done on the sysutils database and SQLCODES that were returned. 8 = Also print page headers of all pages archived and restored. This setting requires a large amount of space. 9 = Print the contents of: The bar_ins structure after it was initialized. The object descriptors that are cold restored. Keen regards. On Fri, 22 Jan 2016 at 12:40 Juan Francisco González Navarro < jfrancisco.navarro@gmail.com> wrote: > Hello > > IBM Informix Dynamic Server Version 11.70.FC8GE -- On-Line -- Up 29 days > 18:39:42 -- 3857968 Kbytes> > An I tried login as root and also as informix and also as root doing su - > informix > > The id of user and group informing are > > uid=1001(informix) gid=1001(informix) groups=1001(informix) > > Thank you > On Jan 22, 2016 12:31 PM, "Ricardo Henriques" < > ricardoaireshenriques@gmail.com> wrote: > > > Hi, > > > > What is the state of the IDS, can you send us the output of: > > > > onstat - > > > > You're logged as the user informix? > > > > Keen regards. > > > > On Fri, 22 Jan 2016 at 09:22 Juan Francisco González Navarro < > > jfrancisco.navarro@gmail.com> wrote: > > > > > Hello, > > > > > > I start ism and run onbar but after one day working right I receive > this > > > error where I try to do a backup for L0, L1 and L2 but onbar -b -C > works > > > right. > > > > > > 2016-01-22 04:00:01 15482 15480 /opt/IBM/informix/bin/onbar_d -b -L 2 > > > 2016-01-22 03:57:56* 15433 15431 (-43207) Unable to open connection to > > > database server: TIMEOUT. > > > 2016-01-22 03:57:56* 15433 15431 Process 15433 received signal 14; > > > process exiting with code 151 (0x97). > > > 2016-01-22 04:10:01 15532 15530 (-43061) BAR_MAX_BACKUP has been > reduced > > > to 5919 to avoid allocating more > > > than SHMTOTAL KB. > > > 2016-01-22 04:10:01 15532 15530 (-43141) The edition of Informix > Dynamic > > > Server currently running restricts the > > > number of parallel backup or restore processes to 1. Resetting > > > BAR_MAX_BACKUP > > > to 1.> > > > > > Also I checked user and group informix and it seems right: > > > > > > id informix > > > uid=1001(informix) gid=1001(informix) groups=1001(informix) > > > > > > Any idea? > > > > > > Regards. > > > > > > --94eb2c06a88c8b2d710529e8bd09 > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > --001a11405526d0dcfe0529ea8bd5 > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --089e01538da01293e50529eb83f8 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a1140331820d4b40529f05897

Hello : I solved the issue. My INFORMIXSERVER was set up to a ipcshm server and onbar doesn't like this, setting this variable to an soctcp informix server works. I don't know why this happen but it works. Regards. 2016-01-22 19:25 GMT+01:00 Ricardo Henriques < ricardoaireshenriques@gmail.com>: > The log you show has three different operations. > > 1. > 2016-01-22 04:00:01 15482 15480 /opt/IBM/informix/bin/onbar_d -b -L 2 > > This only shows us the start of the process. > > 2. > 2016-01-22 03:57:56* 15433 15431 (-43207) Unable to open connection to > database server: TIMEOUT. > 2016-01-22 03:57:56* 15433 15431 Process 15433 received signal 14; process > exiting with code 151 (0x97). > > This operation hints a problem, time out, connecting to the database > server. Hence I've asked the status of the instance. > > 3. > 2016-01-22 04:10:01 15532 15530 (-43061) BAR_MAX_BACKUP has been reduced to > 5919 to avoid allocating more than SHMTOTAL KB. > 2016-01-22 04:10:01 15532 15530 (-43141) The edition of Informix Dynamic > Server currently running restricts the number of parallel backup or restore > processes to 1. Resetting BAR_MAX_BACKUP to 1. > > Those are only warnings, seems like Growth Edition doesnt support Parallel > operations. > > Try again to issue the backup look to the log only for that operation and > see if the error is the same. > > One way to get more info on the subject is to change the BAR_DEBUG and > BAR_DEBUG_LOG. In the 11.70 you can change it by editing the onconfig > directly. > > The values for BAR_DEBUG are: > 0 = Do not display debugging information. > 1 = Print a small amount of information > 2 = Print a message every time ON-Bar: > Enters a function. > Exits a function. The message includes the return code for the function. > 3 = Print exit and entry information with additional details. > 4 = Also print information about ON-Bar parallel operations. > 5 = Also print information about: > Objects that are being backed up or restored. > The act_node structure corresponding with the bar_action table. > 6 = Print additional information about: > Objects that are being backed up or restored. > The act_node structure corresponding with the bar_action table. > 7 = Also print: > Information about the contents of the ins_node structure corresponding with > the bar_instance table. > Information about modifications to the bar_action table. > Information about logical logs and objects that are restored. > SQL statements done on the sysutils database and SQLCODES that were > returned. > 8 = Also print page headers of all pages archived and restored. This > setting requires a large amount of space. > 9 = Print the contents of: > The bar_ins structure after it was initialized. > The object descriptors that are cold restored. > Keen regards. > > On Fri, 22 Jan 2016 at 12:40 Juan Francisco González Navarro < > jfrancisco.navarro@gmail.com> wrote: > > > Hello > > > > IBM Informix Dynamic Server Version 11.70.FC8GE -- On-Line -- Up 29 days > > 18:39:42 -- 3857968 Kbytes> > > > An I tried login as root and also as informix and also as root doing su - > > informix > > > > The id of user and group informing are > > > > uid=1001(informix) gid=1001(informix) groups=1001(informix) > > > > Thank you > > On Jan 22, 2016 12:31 PM, "Ricardo Henriques" < > > ricardoaireshenriques@gmail.com> wrote: > > > > > Hi, > > > > > > What is the state of the IDS, can you send us the output of: > > > > > > onstat - > > > > > > You're logged as the user informix? > > > > > > Keen regards. > > > > > > On Fri, 22 Jan 2016 at 09:22 Juan Francisco González Navarro < > > > jfrancisco.navarro@gmail.com> wrote: > > > > > > > Hello, > > > > > > > > I start ism and run onbar but after one day working right I receive > > this > > > > error where I try to do a backup for L0, L1 and L2 but onbar -b -C > > works > > > > right. > > > > > > > > 2016-01-22 04:00:01 15482 15480 /opt/IBM/informix/bin/onbar_d -b -L 2 > > > > 2016-01-22 03:57:56* 15433 15431 (-43207) Unable to open connection > to > > > > database server: TIMEOUT. > > > > 2016-01-22 03:57:56* 15433 15431 Process 15433 received signal 14; > > > > process exiting with code 151 (0x97). > > > > 2016-01-22 04:10:01 15532 15530 (-43061) BAR_MAX_BACKUP has been > > reduced > > > > to 5919 to avoid allocating more > > > > than SHMTOTAL KB. > > > > 2016-01-22 04:10:01 15532 15530 (-43141) The edition of Informix > > Dynamic > > > > Server currently running restricts the > > > > number of parallel backup or restore processes to 1. Resetting > > > > BAR_MAX_BACKUP > > > > to 1.> > > > > > > > Also I checked user and group informix and it seems right: > > > > > > > > id informix > > > > uid=1001(informix) gid=1001(informix) groups=1001(informix) > > > > > > > > Any idea? > > > > > > > > Regards. > > > > > > > > --94eb2c06a88c8b2d710529e8bd09 > > > > > > > > > > > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > > > > --001a11405526d0dcfe0529ea8bd5 > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > --089e01538da01293e50529eb83f8 > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --001a1140331820d4b40529f05897 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --047d7b41410a0982c10529f17fc2