You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2019/01/30 08:00:00 UTC
[jira] [Work logged] (TRAFODION-3268) UDF|TMUDF returns various
errors regarding dlopen cached_libs file
[ https://issues.apache.org/jira/browse/TRAFODION-3268?focusedWorklogId=192083&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-192083 ]
ASF GitHub Bot logged work on TRAFODION-3268:
---------------------------------------------
Author: ASF GitHub Bot
Created on: 30/Jan/19 07:59
Start Date: 30/Jan/19 07:59
Worklog Time Spent: 10m
Work Description: sandhyasun commented on pull request #1784: [TRAFODION-3268] [TRAFODION-3269] [TRAFODION-3269] Library manager fixes and LOB alter fix
URL: https://github.com/apache/trafodion/pull/1784
Fixes for library management
1. A non existent library would not return an error during create due to incorrect error/diagnostics handling
2. Added a retry during extract of libraries to try to avoid random "file too short" errors.
3. Made a fix to LOB alter code to avoid creating LOB_MD table when one already exists.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Issue Time Tracking
-------------------
Worklog Id: (was: 192083)
Time Spent: 10m
Remaining Estimate: 0h
> 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
> Priority: Major
> Fix For: 2.4
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> 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)