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) |