suche 36x36
  • Admin-Scout-small-Banner
           

    CURSOR Admin-Scout

    get the ultimate tool for Informix

    pfeil  
Latest versionsfixlist
14.10.xC10 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

Informix - Problem description

Problem IT38692 Status: Closed

RUNNING A BACKUP WITH ONBAR TO PSM TO AMAZON S3 HANGS WITH
ERROR"IFXCURL_EASY_PERFORM() FAILED(35): SSL CONNECT ERROR."

product:
INFORMIX SERVER / 5725A3900 / E10 - 
Problem description:
When taking an archive using onbar, the PSM storage manager and
devices on Amazon S3, the archive can fail with
"ifxcurl_easy_perform() failed(35): SSL connect error."

A sample bar_act.log may look like this:

 2021-09-08 10:11:51.626379 2491  2489 /onbar_d -b
-L 0
 2021-09-08 10:11:51.659616 2491  2489 Using IBM's PSM version
14.10.FC5 as the Storage Manager. XBSA API version is 1.0.3.
 2021-09-08 10:11:51.967931 2491  2489 Archive started on
 (Requested Level 0).
 2021-09-08 10:11:52.183694 2491  2489 Begin level 0 backup
rootdbs.
 2021-09-08 10:11:52.183754 2491  2489 Starting Filter /bin/pigz
-1c -b 1024  -p 8.
 2021-09-08 10:11:52.185513 2493  2491 The PSM is ready.
 2021-09-08 10:11:52.187883 2493  2491 Informix Primary Storage
Manager session 6 opened.
 2021-09-08 10:11:52.187925 2493  2491 Successfully connected to
Storage Manager.
 2021-09-08 10:11:54.235882 2493  2491 Informix Primary Storage
Manager session 6 closed
 2021-09-08 10:11:54.235921 2493  2491 The child process for the
backup and restore filter is terminating with exit code 0.
 2021-09-08 10:11:54.236945 2491  2489 The PSM is ready.
 2021-09-08 10:11:54.237241 2491  2489 Informix Primary Storage
Manager session 7 opened.
 2021-09-08 10:11:54.237274 2491  2489 Successfully connected to
Storage Manager.
 2021-09-08 10:11:54.250105 2491  2489 Informix Primary Storage
Manager session 7 closed
 2021-09-08 10:11:54.256007 2491  2489 Completed level 0 backup
rootdbs (Storage Manager copy ID: 0 1).
 2021-09-08 10:11:54.780311 2511  2491 Process 2511  2491
successfully forked.
 2021-09-08 10:11:54.791458 2512  2491 Process 2512  2491
successfully forked.
 2021-09-08 10:11:54.802316 2515  2491 Process 2515  2491
successfully forked.
 2021-09-08 10:11:54.813018 2514  2491 Process 2514  2491
successfully forked.
 2021-09-08 10:11:54.823895 2516  2491 Process 2516  2491
successfully forked.
 2021-09-08 10:11:54.834743 2518  2491 Process 2518  2491
successfully forked.
 2021-09-08 10:11:55.789435 2515  2491 Begin level 0 backup
.
 2021-09-08 10:11:55.789485 2515  2491 Starting Filter /bin/pigz
-1c -b 1024  -p 8.
 2021-09-08 10:11:55.791434 2523  2515 The PSM is ready.
 2021-09-08 10:11:55.791801 2523  2515 Informix Primary Storage
Manager session 8 opened.
 2021-09-08 10:11:55.791818 2523  2515 Successfully connected to
Storage Manager.
 2021-09-08 13:28:58.391370 2523  2515 ifxcurl_easy_perform()
failed(35): SSL connect error.
 2021-09-08 13:28:58.401811 2523  2515 Error -88186: A defect in
the program was found. Contact IBM Informix Support.
 2021-09-08 13:28:58.403311 2523  2515 XBSA Error: (BSASendData)
A system error occurred. Aborting XBSA session.
 2021-09-08 13:28:58.408652 2523  2515 Error -88186: A defect in
the program was found. Contact IBM Informix Support.
 2021-09-08 13:28:58.408666 2523  2515 XBSA Error: (BSAEndData)
A system error occurred. Aborting XBSA session.
 2021-09-08 13:28:58.408695 2523  2515 Error -88186: A defect in
the program was found. Contact IBM Informix Support.
 2021-09-08 13:28:58.438123 2523  2515 Error -88186: A defect in
the program was found. Contact IBM Informix Support.
 2021-09-08 13:28:58.438142 2523  2515 XBSA Error:
(BSATerminate) A system error occurred. Aborting XBSA session.
 2021-09-08 10:11:55.789485* 2515  2491 Filter closed.
 2021-09-08 13:28:58.515914 2515  2491 (-43082) Writing to
backup and restore filter failed with error 100.
 2021-09-08 13:28:58.516858 2515  2491 XBSA Error: (BSAEndTxn)
Unable to access NULL pointer.
 2021-09-08 13:28:58.960729 2515  2491 Process 2515  2491
completed.
 2021-09-08 13:28:58.963072 2491  2489 (-43246) The ON-Bar
process 2515 exited with a problem (exit code 255 (0xff),
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* Users of Informix Server prior to 14.10.xC8.                 *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Informix Server 14.10.xC8.                        *
****************************************************************
Local Fix:
A workaround is to use the libcurl library included with the OS:

1) determine the name of the libcurl library file, example:
$ ls -l /usr/lib64/libcurl.so*
lrwxrwxrwx 1 root root 16 Jul 17 2017 /usr/lib64/libcurl.so ->
libcurl.so.3.0.0
lrwxrwxrwx 1 root root 16 Jul 17 2017 /usr/lib64/libcurl.so.3 ->
libcurl.so.3.0.0
-rwxr-xr-x 1 root root 252488 Jan 16 2007
/usr/lib64/libcurl.so.3.0.0

2) In this example, set
IFX_LIBCURL_PATH=/usr/lib64/libcurl.so.3.0.0 (use the path and
name of file returned from your environment).
3) Take the database offline and bring the database server
online with this environment variable set in the server start-up
environment.
4) try the archive to S3 again
Solution
Workaround
****************************************************************
* USERS AFFECTED:                                              *
* Users of Informix Server prior to 14.10.xC8.                 *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Informix Server 14.10.xC8.                        *
****************************************************************
Comment
Fixed in Informix Server 14.10.xC8.
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
13.10.2021
08.04.2022
08.04.2022
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
Informix EditionsInformix Editions
Informix Editions
DocumentationDocumentation
Documentation
IBM NewsletterIBM Newsletter
IBM Newsletter
Current BugsCurrent Bugs
Current Bugs
Bug ResearchBug Research
Bug Research
Bug FixlistsBug Fixlists
Bug Fixlists
Release NotesRelease Notes
Release Notes
Machine NotesMachine Notes
Machine Notes
Release NewsRelease News
Release News
Product LifecycleProduct Lifecycle
Lifecycle
Media DownloadMedia Download
Media Download