[
https://issues.apache.org/jira/browse/TRAFODION-2314?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15763281#comment-15763281
]
ASF GitHub Bot commented on TRAFODION-2314:
-------------------------------------------
GitHub user selvaganesang opened a pull request:
https://github.com/apache/incubator-trafodion/pull/881
[TRAFODION-2314] MXOSRVR sometimes exit abnormally with NAMutex assert
The test suite fails becuase pthread_mutex_unlock returns EPERM error
pthread_mutex_lock and pthread_mutex_unlock always return success when
a program is not linked with -lpthread option. It is linked this way
when a multi-threaded program is run in single thread mode to avoid the
overhead of locking.
The mxosrvr program is now linked with -lpthread. However, it is not
clear how and why it would fix the EPERM error returned from
pthread_mutex_unlock API. But it is good to ensure that mxosrvr .sos and
the binaries are compiled with -lpthread.
Will revisit this issue if the problem persists.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/selvaganesang/incubator-trafodion
trafodion-2314
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/881.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #881
----
commit 6d5cd94e69a05eb1230dd561373ecebc0efd7ead
Author: selvaganesang <[email protected]>
Date: 2016-12-20T04:44:54Z
[TRAFODION-2314] MXOSRVR sometimes exit abnormally with NAMutex assert
The test suite fails becuase pthread_mutex_unlock returns EPERM error
pthread_mutex_lock and pthread_mutex_unlock always return success when
a program is not linked with -lpthread option. It is linked this way
when a multi-threaded program is run in single thread mode to avoid the
overhead of locking.
The mxosrvr program is now linked with -lpthread. However, it is not
clear how and why it would fix the EPERM error returned from
pthread_mutex_unlock API. But it is good to ensure that mxosrvr .sos and
the binaries are compiled with -lpthread.
Will revisit this issue if the problem persists.
----
> MXOSRVR sometimes exit abnormally with NAMutex assert
> -----------------------------------------------------
>
> Key: TRAFODION-2314
> URL: https://issues.apache.org/jira/browse/TRAFODION-2314
> Project: Apache Trafodion
> Issue Type: Bug
> Reporter: Arvind Narain
>
> Following errors were noticed during a jdbc_test regression run. These tests
> usually pass on reruns.
> 2016-10-26 10:54:18 Running TestBigColumnSize
> 2016-10-26 10:54:18 ---
> 2016-10-26 10:54:29 32KColSizeWithUTF8 : Pass
> 2016-10-26 10:54:44 200KColSizeWithUTF8 : Pass
> 2016-10-26 10:54:44 Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time
> elapsed: 25.573 sec - in TestBigColumnSize
> 2016-10-26 10:54:44 Running TestTrx
> 2016-10-26 10:54:44 org.trafodion.jdbc.t4.TrafT4Exception: Server aborted
> abnormally or Connection timed out
> 2016-10-26 10:54:44 at
> org.trafodion.jdbc.t4.TrafT4Messages.createSQLException(TrafT4Messages.java:284)
> 2016-10-26 10:54:44 at
> org.trafodion.jdbc.t4.InputOutput.doIO(InputOutput.java:376)
> 2016-10-26 10:54:44 at
> org.trafodion.jdbc.t4.T4Connection.getReadBuffer(T4Connection.java:157)
> 2016-10-26 10:54:44 at
> org.trafodion.jdbc.t4.T4Connection.InitializeDialogue(T4Connection.java:220)
> 2016-10-26 10:54:44 at
> org.trafodion.jdbc.t4.InterfaceConnection.initDiag(InterfaceConnection.java:534)
> 2016-10-26 10:54:44 at
> org.trafodion.jdbc.t4.InterfaceConnection.secureLogin(InterfaceConnection.java:710)
> 2016-10-26 10:54:44 at
> org.trafodion.jdbc.t4.InterfaceConnection.connect(InterfaceConnection.java:904)
> 2016-10-26 10:54:44 at
> org.trafodion.jdbc.t4.InterfaceConnection.<init>(InterfaceConnection.java:176)
> 2016-10-26 10:54:44 at
> org.trafodion.jdbc.t4.TrafT4Connection.makeConnection(TrafT4Connection.java:1611)
> 2016-10-26 10:54:44 at
> org.trafodion.jdbc.t4.TrafT4Connection.<init>(TrafT4Connection.java:1564)
> 2016-10-26 10:54:44 at
> org.trafodion.jdbc.t4.TrafT4DataSource.getConnection(TrafT4DataSource.java:132)
> 2016-10-26 10:54:44 at
> org.trafodion.jdbc.t4.TrafT4DataSource.getConnection(TrafT4DataSource.java:176)
> 2016-10-26 10:54:44 at
> org.trafodion.jdbc.t4.T4Driver.connect(T4Driver.java:186)
> 2016-10-26 10:54:44 at
> java.sql.DriverManager.getConnection(DriverManager.java:571)
> 2016-10-26 10:54:44 at
> java.sql.DriverManager.getConnection(DriverManager.java:215)
> 2016-10-26 10:54:44 at Utils.getUserConnection(Utils.java:125)
> 2016-10-26 10:54:44 at TestTrx.JDBCTrx1(TestTrx.java:53)
> Corresponding errors in mon.snmp log file:
> 2016-10-26 10:54:44,446, INFO, MON, Node Number: 0,, PIN: 41028 , Process
> Name: $MONITOR,,, TID: 41033, Message ID: 101130801, STDERR redirected from
> slave-ahw23.$Z0012AF.0.45690: mxosrvr: ../common/NAMemory.cpp:183:
> NAMutex::~NAMutex(): Assertion `rc == 0' failed.
> Corresponding message from monitor.map file:
> BEGIN Wed Oct 26 10:48:59 2016 $Z0012AF (0, 45690:47) P(-1, -1:-1) mxosrvr
> ..
> BEGIN Wed Oct 26 10:54:32 2016 $Z0018UZ (0, 53724:84) P(0, 45690:47)
> /home/jenkins/workspace/jdbc_test-hdp/traf_run/tdm_arkcmp
> END Wed Oct 26 10:54:44 2016 $Z0018UZ (0, 53724:84) P(0, 45690:47)
> /home/jenkins/workspace/jdbc_test-hdp/traf_run/tdm_arkcmp
> END Wed Oct 26 10:54:44 2016 $Z0012AF (0, 45690:47) P(-1, -1:-1) mxosrvr
> Corresponding master_exec logs:
> 2016-10-26 10:54:29,069, INFO, SQL, Node Number: 0, CPU: 0, PIN: 45690,
> Process Name: $Z0012AF,,, A compiler process is launched.
> 2016-10-26 10:54:31,914, INFO, DBSECURITY, Node Number: 0, CPU: 0, PIN: 45690
> ,,,, Authentication request: externalUser QA001, databaseUser QA001, userID
> 33334, clientName slave-ahw23, clientUserName jenkins, result 0
> (Authentication successful)
> 2016-10-26 10:54:35,523, INFO, SQL.COMP, Node Number: 0, CPU: 0, PIN: 53724,
> Process Name: $Z0018UZ,,, A compiler process is launched.
> 2016-10-26 10:54:36,778, ERROR, SQL, Node Number: 0, CPU: 0, PIN: 45690,
> Process Name: $Z0012AF, SQLCODE: 1022, QID:
> MXID11000045690212344238939673585000000000206U3333400_119_SQL_CUR_1, ***
> ERROR[1022] Schema TRAFODION.T4QA already exists.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
