You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Sandhya Sundaresan (JIRA)" <ji...@apache.org> on 2019/01/30 07:00:00 UTC
[jira] [Created] (TRAFODION-3268) UDF|TMUDF returns various errors
regarding dlopen cached_libs file
Sandhya Sundaresan created TRAFODION-3268:
---------------------------------------------
Summary: UDF|TMUDF returns various errors regarding dlopen cached_libs file
Key: TRAFODION-3268
URL: https://issues.apache.org/jira/browse/TRAFODION-3268
Project: Apache Trafodion
Issue Type: Bug
Components: sql-general
Reporter: Sandhya Sundaresan
Assignee: Sandhya Sundaresan
Fix For: 2.4
In the latest version, we started to see various random errors returned from queries with UDF or TMUDF. The errors sometimes are 4316 error indicating failures to create the cached_libs directory, sometimes are 11245|11248 errors complaining about 'file too short' with the cached file. Whenever the errors occurred, the actual file appeared to exist in the cached_libs directory on every node.
It is a regression introduced presumably because of the UDF|TMUDF cached_libs concept. This problem doesn't always happen. Sometimes the same sequence of statements failed previously would work fine the next time. It's also not clear if this only happens on a multi-node cluster, as the errors were seen on nap035, which happens to be a 4-node cluster.
Here are a few examples of these failures seen from the SQL regression run:
===========================================================================
SQL>select * from myview v, mytable t
+>where (qa_udf_integer(v.a), qa_udf_integer(t.b)) >
+>all (select qa_udf_integer(a), qa_udf_integer(b) from mytable2
+>where qa_udf_integer(a) = qa_udf_integer(b));
*** ERROR[4316] An error was detected while extracting a udr routine library to local cache : Error 0 creating directory :/opt/trafodion/esgyndb/udr/DB__ROOT/cached_libs/MYTEST/ .
===========================================================================
SQL>select * from
UDF(MYTMFUNC(TABLE(select * from trafodion.zzz_single_stream_features_namespace.mytable),
'TEST_CMPTIME_RUNTIME_OUT_TABLE_DEFINED_USING_PASSTHRU', '3')) t1,
UDF(MYTMFUNC(TABLE(select * from trafodion.zzz_single_stream_features_namespace_myns.mytable),
'TEST_CMPTIME_RUNTIME_OUT_TABLE_DEFINED_USING_PASSTHRU', '3')) t2,
UDF(MYTMFUNC(TABLE(select * from trafodion.zzz_single_stream_features_namespace_myns.mytable_too),
'TEST_CMPTIME_RUNTIME_OUT_TABLE_DEFINED_USING_PASSTHRU', '3')) t3
where t1.a = t2.a and t2.a = t3.a order by 1;
*** ERROR[11245] An error occurred loading library 'qaTmudfTest_212414198362332378.so' from path '/opt/trafodion/esgyndb/udr/DB__ROOT/cached_libs/ZZZ_SINGLE_STREAM_FEATURES_NAMESPACE_MYNS'. [2019-01-14 00:50:22]
*** ERROR[11248] A call to dlopen returned errors 0 and 0. Details:
/opt/trafodion/esgyndb/udr/DB__ROOT/cached_libs/ZZZ_SINGLE_STREAM_FEATURES_NAMESPACE_MYNS/qaTmudfTest_212414198362332378.so: file too short. [2019-01-14 00:50:22]
===========================================================================
SQL>select * from myview v, mytable t
where (qa_udf_integer(v.a), qa_udf_integer(t.b)) >
all (select qa_udf_integer(a), qa_udf_integer(b) from mytable2
where qa_udf_integer(a) = qa_udf_integer(b));
*** ERROR[11245] An error occurred loading library 'qaUdfTest_212414083371782103.so' from path '/opt/trafodion/esgyndb/udr/DB__ROOT/cached_libs/UDF_UDF_GENERAL'. [2019-01-12 15:20:07]
*** ERROR[11248] A call to dlopen returned errors 0 and 0. Details:
/opt/trafodion/esgyndb/udr/DB__ROOT/cached_libs/UDF_UDF_GENERAL/qaUdfTest_212414083371782103.so: file too short. [2019-01-12 15:20:07]
*** ERROR[11245] An error occurred loading library 'qaUdfTest_212414083371782103.so' from path '/opt/trafodion/esgyndb/udr/DB__ROOT/cached_libs/UDF_UDF_GENERAL'. [2019-01-12 15:20:07]
*** ERROR[11248] A call to dlopen returned errors 0 and 0. Details:
/opt/trafodion/esgyndb/udr/DB__ROOT/cached_libs/UDF_UDF_GENERAL/qaUdfTest_212414083371782103.so: file too short. [2019-01-12 15:20:07]
*** ERROR[11245] An error occurred loading library 'qaUdfTest_212414083371782103.so' from path '/opt/trafodion/esgyndb/udr/DB__ROOT/cached_libs/UDF_UDF_GENERAL'. [2019-01-12 15:20:07]
*** ERROR[11248] A call to dlopen returned errors 0 and 0. Details:
/opt/trafodion/esgyndb/udr/DB__ROOT/cached_libs/UDF_UDF_GENERAL/qaUdfTest_212414083371782103.so: file too short. [2019-01-12 15:20:07]
*** ERROR[11245] An error occurred loading library 'qaUdfTest_212414083371782103.so' from path '/opt/trafodion/esgyndb/udr/DB__ROOT/cached_libs/UDF_UDF_GENERAL'. [2019-01-12 15:20:07]
*** ERROR[11248] A call to dlopen returned errors 0 and 0. Details:
/opt/trafodion/esgyndb/udr/DB__ROOT/cached_libs/UDF_UDF_GENERAL/qaUdfTest_212414083371782103.so: file too short. [2019-01-12 15:20:07]
*** ERROR[11245] An error occurred loading library 'qaUdfTest_212414083371782103.so' from path '/opt/trafodion/esgyndb/udr/DB__ROOT/cached_libs/UDF_UDF_GENERAL'. [2019-01-12 15:20:07]
*** ERROR[11248] A call to dlopen returned errors 0 and 0. Details:
/opt/trafodion/esgyndb/udr/DB__ROOT/cached_libs/UDF_UDF_GENERAL/qaUdfTest_212414083371782103.so: file too short. [2019-01-12 15:20:07]
*** ERROR[11245] An error occurred loading library 'qaUdfTest_212414083371782103.so' from path '/opt/trafodion/esgyndb/udr/DB__ROOT/cached_libs/UDF_UDF_GENERAL'. [2019-01-12 15:20:07]
*** ERROR[11248] A call to dlopen returned errors 0 and 0. Details:
/opt/trafodion/esgyndb/udr/DB__ROOT/cached_libs/UDF_UDF_GENERAL/qaUdfTest_212414083371782103.so: file too short. [2019-01-12 15:20:07]
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)