APAR status
Closed as program error.
Error description
The C++ I/O interface supports dates whose year falls in the range 1400 to 9999. Selecting dates from Hadoop tables outside this range can result in the following error: . SQL 5199: ERROR [57067] [IBM][DB2/LINUXX8664] The statement failed because a connection to a Hadoop I/O component could not be established or maintained.  Hadoop I/O component name: "C++ DFSIO". Reason code: "1". Database partition number: "n". . On the Big SQL physical worker on which the error occurred (identified by "n" in the above message), the db2diag.log entry will include the following entry: . 2017-04-24-20.44.25.664949+330 E932064E816 LEVEL: Critical PID : 38140 TID : 139665697560320 PROC : db2fmp ( INSTANCE: bigsql NODE : 008 HOSTNAME: iopint17 FUNCTION: DB2 UDB, oper system services, sqlo_db2fmp_trca_nokill, probe:10 MESSAGE : ADM14001C An unexpected and critical error has occurred: "FmpTrap". The instance may have been shutdown as a result. "Automatic" FODC (First Occurrence Data Capture) has been invoked and diagnostic information has been recorded in directory "/var/ibm/bigsql/diag/DIAG0008/FODC_FmpTrap_2017-04-24-20.44.25. 66487 6_0008/". Please look in this directory for detailed evidence about what happened and contact IBM support if necessary to diagnose the problem. . In the indicated FODC directory, there will be the following stack : . <StackTrace> -----FUNC-ADDR---- ------FUNCTION + OFFSET------ 0x00007F7AA50201E6 _Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm + 0x0356 (/home/bigsql/sqllib/lib64/libdb2osse.so.1) 0x00007F7AA501FE2B ossDumpStackTraceV98 + 0x002b (/home/bigsql/sqllib/lib64/libdb2osse.so.1) 0x00007F7AA501BFD7 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 0x00d7 (/home/bigsql/sqllib/lib64/libdb2osse.so.1) 0x00007F7AA6698277 sqlo_db2fmp_trca_nokill + 0x04d7 (/home/bigsql/sqllib/lib64/libdb2.so.1) 0x00007F7AA4BA9370 address: 0x00007F7AA4BA9370 ; dladdress: 0x00007F7AA4B9A000 ; offset in lib: 0x000000000000F370 ; (/lib64/libpthread.so.0) 0x00007F7AA4BA923B raise + 0x002b (/lib64/libpthread.so.0) 0x00007F7A9CB1995E address: 0x00007F7A9CB1995E ; dladdress: 0x00007F7A9CB03000 ; offset in lib: 0x000000000001695E ; (/home/bigsql/sqllib/java/jdk64/jre/lib/amd64/default/libj9prt28 .so) 0x00007F7A9C4CC020 address: 0x00007F7A9C4CC020 ; dladdress: 0x00007F7A9C4C4000 ; offset in lib: 0x0000000000008020 ; (/home/bigsql/sqllib/java/jdk64/jre/lib/amd64/default/libj9dmp28 .so) 0x00007F7A9C4C83D5 address: 0x00007F7A9C4C83D5 ; dladdress: 0x00007F7A9C4C4000 ; offset in lib: 0x00000000000043D5 ; (/home/bigsql/sqllib/java/jdk64/jre/lib/amd64/default/libj9dmp28 .so) 0x00007F7A9CB28C65 address: 0x00007F7A9CB28C65 ; dladdress: 0x00007F7A9CB03000 ; offset in lib: 0x0000000000025C65 ; (/home/bigsql/sqllib/java/jdk64/jre/lib/amd64/default/libj9prt28 .so) 0x00007F7A9C4C8399 address: 0x00007F7A9C4C8399 ; dladdress: 0x00007F7A9C4C4000 ; offset in lib: 0x0000000000004399 ; (/home/bigsql/sqllib/java/jdk64/jre/lib/amd64/default/libj9dmp28 .so) 0x00007F7A9C4CC3EA address: 0x00007F7A9C4CC3EA ; dladdress: 0x00007F7A9C4C4000 ; offset in lib: 0x00000000000083EA ; (/home/bigsql/sqllib/java/jdk64/jre/lib/amd64/default/libj9dmp28 .so) 0x00007F7A9C4E0D24 address: 0x00007F7A9C4E0D24 ; dladdress: 0x00007F7A9C4C4000 ; offset in lib: 0x000000000001CD24 ; (/home/bigsql/sqllib/java/jdk64/jre/lib/amd64/default/libj9dmp28 .so) 0x00007F7A9C4CE2FD address: 0x00007F7A9C4CE2FD ; dladdress: 0x00007F7A9C4C4000 ; offset in lib: 0x000000000000A2FD ; (/home/bigsql/sqllib/java/jdk64/jre/lib/amd64/default/libj9dmp28 .so) 0x00007F7AA3FED250 address: 0x00007F7AA3FED250 ; dladdress: 0x00007F7AA3FB8000 ; offset in lib: 0x0000000000035250 ; (/lib64/libc.so.6) 0x00007F7AA3FED1D7 gsignal + 0x0037 (/lib64/libc.so.6) 0x00007F7AA3FEE8C8 abort + 0x0148 (/lib64/libc.so.6) 0x00007F7AA45EF9D5 _ZN9__gnu_cxx27__verbose_terminate_handlerEv + 0x0165 (/lib64/libstdc++.so.6) 0x00007F7AA45ED946 address: 0x00007F7AA45ED946 ; dladdress: 0x00007F7AA458F000 ; offset in lib: 0x000000000005E946 ; (/lib64/libstdc++.so.6) 0x00007F7AA45ED973 address: 0x00007F7AA45ED973 ; dladdress: 0x00007F7AA458F000 ; offset in lib: 0x000000000005E973 ; (/lib64/libstdc++.so.6) 0x00007F7AA45EDB93 address: 0x00007F7AA45EDB93 ; dladdress: 0x00007F7AA458F000 ; offset in lib: 0x000000000005EB93 ; (/lib64/libstdc++.so.6) 0x00007F798E503123 _ZN5boost2CV23simple_exception_policyItLt1400ELt10000ENS_9gregor ian8bad_yearEE8on_errorEttNS0_14violation_enumE + 0x01b3 (/home/bigsql/sqllib/lib64/libdfsreader.so) 0x00007F798E62C0A2 _ZN5boost9date_time23gregorian_calendar_baseINS0_19year_month_da y_baseINS_9gregorian9greg_yearENS3_10greg_monthENS3_8greg_dayEEE jE15from_day_numberEj + 0x0112 (/home/bigsql/sqllib/lib64/libdfsreader.so) 0x00007F798E8F7DB4 _Z12serializeRowP20db2ExtTableInterfaceP11DFSReaderCBPN6impala8T upleRowEPNS3_13RowDescriptorEPN9ibmbidfsr16DB2RowSerializerEPhm + 0x0d54 (/home/bigsql/sqllib/lib64/libdfsreader.so) 0x00007F798E8F86D7 serializeDB2BufferFromRowBatch + 0x0387 (/home/bigsql/sqllib/lib64/libdfsreader.so) 0x00007F798E589F09 _ZN6impala17DB2ScannerContext24doRowBatchPostProcessingEPNS_8Row BatchE + 0x00f9 (/home/bigsql/sqllib/lib64/libdfsreader.so) 0x00007F798E540771 _ZN6impala11HdfsScanner10CommitRowsEi + 0x00c1 (/home/bigsql/sqllib/lib64/libdfsreader.so) 0x00007F798E56D9BD _ZN6impala18HdfsParquetScanner12AssembleRowsEi + 0x02bd (/home/bigsql/sqllib/lib64/libdfsreader.so) 0x00007F798E56E917 _ZN6impala18HdfsParquetScanner12ProcessSplitEv + 0x0287 (/home/bigsql/sqllib/lib64/libdfsreader.so) 0x00007F798E52ECC1 _ZN6impala12HdfsScanNode13ScannerThreadEv + 0x0711 (/home/bigsql/sqllib/lib64/libdfsreader.so) 0x00007F798E8E1F51 _ZN6impala6Thread15SuperviseThreadERKSsS2_N5boost8functionIFvvEE EPNS_7PromiseIlEE + 0x0341 (/home/bigsql/sqllib/lib64/libdfsreader.so) 0x00007F798E8E2970 _ZN5boost6detail11thread_dataINS_3_bi6bind_tIvPFvRKSsS5_NS_8func tionIFvvEEEPN6impala7PromiseIlEEENS2_5list4INS2_5valueISsEESH_NS G_IS8_EENSG_ISC_EEEEEEE3runEv + 0x0080 (/home/bigsql/sqllib/lib64/libdfsreader.so) 0x00007F798E99E823 thread_proxy + 0x0063 (/home/bigsql/sqllib/lib64/libdfsreader.so) 0x00007F7AA4BA1DC5 address: 0x00007F7AA4BA1DC5 ; dladdress: 0x00007F7AA4B9A000 ; offset in lib: 0x0000000000007DC5 ; (/lib64/libpthread.so.0) 0x00007F7AA40AF73D clone + 0x006d (/lib64/libc.so.6) </StackTrace> . Note the "bad_year" boost exception.
Local fix
Problem summary
see error description
Problem conclusion
Problem was fixed first in BigInsights 4.3 and later Fix Packs
Temporary fix
Comments
APAR Information
APAR number
PI67016
Reported component name
INFO BIGINSIGHT
Reported component ID
5725C0900
Reported release
410
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-08-04
Closed date
2017-04-28
Last modified date
2017-04-28
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
n/a
Fix information
Fixed component name
INFO BIGINSIGHT
Fixed component ID
5725C0900
Applicable component levels
R430 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCRJT","label":"IBM Db2 Big SQL"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"410","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
25 August 2020