Petals BC SQL

No MONIT trace is logged if an error occurs getting a database connection

Details

  • Type: Bug Bug
  • Status: Resolved Resolved
  • Priority: Major Major
  • Resolution: Fixed
  • Affects Version/s: 1.6.2
  • Fix Version/s: 1.6.3
  • Component/s: None
  • Security Level: Public
  • Description:
    Hide

    If an error occurs about getting a database connection when execution a SQL request, no MONIT traces is logged:

    2017/03/17 15:10:58,351 GMT+0100 MONIT [org.ow2.petals.component.framework.UnderTestWithDefaultConf] :  traceCode = 'provideFlowStepBegin', flowInstanceId = '8b12ff30-0b1b-11e7-b8e6-02425ee4dbdb', flowStepId = '8b1437b0-0b1b-11e7-b8e6-02425ee4dbdb', flowStepInterfaceName = '{http://petals.ow2.org/components/sql/version-1}SQLInterface', flowStepServiceName = '{http://petals.ow2.org/components/sql/service/1}SQLService', flowStepOperationName = '{http://petals.ow2.org/components/sql/version-1}select', flowStepEndpointName = 'sqlEndpointName', flowPreviousStepId = '8b12ff31-0b1b-11e7-b8e6-02425ee4dbdb'
2017/03/17 15:10:58,389 GMT+0100 WARNING [org.ow2.petals.component.framework.UnderTestWithDefaultConf] : Cannot create PoolableConnectionFactory (java.net.ConnectException : erreur lors de la connexion au serveur localhost sur le port 1 527 avec le message Connexion refusée.)
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (java.net.ConnectException : erreur lors de la connexion au serveur localhost sur le port 1 527 avec le message Connexion refusée.)
	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
	at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
	...
2017/03/17 15:10:58,392 GMT+0100 FINE [org.ow2.petals.component.framework.UnderTestWithDefaultConf] : Send an asynchronous exchange with id : tests:8b12d820-0b1b-11e7-b8e6-02425ee4dbdb
2017/03/17 15:10:58,393 GMT+0100 FINE [org.ow2.petals.component.framework.UnderTestWithDefaultConf] : Intercepting message processing on ACCEPT_RESPONSE
2017/03/17 15:10:58,395 GMT+0100 MONIT [org.ow2.petals.component.framework.UnderTestWithDefaultConf] :  traceCode = 'provideFlowStepFailure', flowInstanceId = '8b12ff30-0b1b-11e7-b8e6-02425ee4dbdb', flowStepId = '8b1437b0-0b1b-11e7-b8e6-02425ee4dbdb', failureMessage = 'org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (java.net.ConnectException : erreur lors de la connexion au serveur localhost sur le port 1 527 avec le message Connexion refusée.) - 	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225) - 	at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880) - 	...'

    The following MONIT traces are expected:

    1. provideExtFlowStepBegin,
    2. followed by provideExtFlowStepFailure.
    Show
    If an error occurs about getting a database connection when execution a SQL request, no MONIT traces is logged: 
    2017/03/17 15:10:58,351 GMT+0100 MONIT [org.ow2.petals.component.framework.UnderTestWithDefaultConf] :  traceCode = 'provideFlowStepBegin', flowInstanceId = '8b12ff30-0b1b-11e7-b8e6-02425ee4dbdb', flowStepId = '8b1437b0-0b1b-11e7-b8e6-02425ee4dbdb', flowStepInterfaceName = '{http://petals.ow2.org/components/sql/version-1}SQLInterface', flowStepServiceName = '{http://petals.ow2.org/components/sql/service/1}SQLService', flowStepOperationName = '{http://petals.ow2.org/components/sql/version-1}select', flowStepEndpointName = 'sqlEndpointName', flowPreviousStepId = '8b12ff31-0b1b-11e7-b8e6-02425ee4dbdb'
2017/03/17 15:10:58,389 GMT+0100 WARNING [org.ow2.petals.component.framework.UnderTestWithDefaultConf] : Cannot create PoolableConnectionFactory (java.net.ConnectException : erreur lors de la connexion au serveur localhost sur le port 1 527 avec le message Connexion refusée.)
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (java.net.ConnectException : erreur lors de la connexion au serveur localhost sur le port 1 527 avec le message Connexion refusée.)
	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
	at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
	...
2017/03/17 15:10:58,392 GMT+0100 FINE [org.ow2.petals.component.framework.UnderTestWithDefaultConf] : Send an asynchronous exchange with id : tests:8b12d820-0b1b-11e7-b8e6-02425ee4dbdb
2017/03/17 15:10:58,393 GMT+0100 FINE [org.ow2.petals.component.framework.UnderTestWithDefaultConf] : Intercepting message processing on ACCEPT_RESPONSE
2017/03/17 15:10:58,395 GMT+0100 MONIT [org.ow2.petals.component.framework.UnderTestWithDefaultConf] :  traceCode = 'provideFlowStepFailure', flowInstanceId = '8b12ff30-0b1b-11e7-b8e6-02425ee4dbdb', flowStepId = '8b1437b0-0b1b-11e7-b8e6-02425ee4dbdb', failureMessage = 'org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (java.net.ConnectException : erreur lors de la connexion au serveur localhost sur le port 1 527 avec le message Connexion refusée.) - 	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225) - 	at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880) - 	...'
    The following MONIT traces are expected:
    1. provideExtFlowStepBegin,
    2. followed by provideExtFlowStepFailure.
  • Environment:
    -

Activity

Ascending order - Click to sort in descending order
Christophe DENEUX made changes - Fri, 17 Mar 2017 - 15:16:51 +0100
Field Original Value New Value
Status New [ 10000 ] Open [ 10002 ]
Priority Major [ 3 ]
Christophe DENEUX made changes - Fri, 17 Mar 2017 - 15:16:53 +0100
Status Open [ 10002 ] In Progress [ 10003 ]
Christophe DENEUX made changes - Fri, 17 Mar 2017 - 15:17:47 +0100
Description If an error occurs about getting a database connection when execution a SQL request, no MONIT traces is logged:
{code}
2017/03/17 15:10:58,351 GMT+0100 MONIT [org.ow2.petals.component.framework.UnderTestWithDefaultConf] : traceCode = 'provideFlowStepBegin', flowInstanceId = '8b12ff30-0b1b-11e7-b8e6-02425ee4dbdb', flowStepId = '8b1437b0-0b1b-11e7-b8e6-02425ee4dbdb', flowStepInterfaceName = '{http://petals.ow2.org/components/sql/version-1}SQLInterface', flowStepServiceName = '{http://petals.ow2.org/components/sql/service/1}SQLService', flowStepOperationName = '{http://petals.ow2.org/components/sql/version-1}select', flowStepEndpointName = 'sqlEndpointName', flowPreviousStepId = '8b12ff31-0b1b-11e7-b8e6-02425ee4dbdb'
2017/03/17 15:10:58,389 GMT+0100 WARNING [org.ow2.petals.component.framework.UnderTestWithDefaultConf] : Cannot create PoolableConnectionFactory (java.net.ConnectException : erreur lors de la connexion au serveur localhost sur le port 1 527 avec le message Connexion refusée.)
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (java.net.ConnectException : erreur lors de la connexion au serveur localhost sur le port 1 527 avec le message Connexion refusée.)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
...
2017/03/17 15:10:58,392 GMT+0100 FINE [org.ow2.petals.component.framework.UnderTestWithDefaultConf] : Send an asynchronous exchange with id : tests:8b12d820-0b1b-11e7-b8e6-02425ee4dbdb
2017/03/17 15:10:58,393 GMT+0100 FINE [org.ow2.petals.component.framework.UnderTestWithDefaultConf] : Intercepting message processing on ACCEPT_RESPONSE
2017/03/17 15:10:58,395 GMT+0100 MONIT [org.ow2.petals.component.framework.UnderTestWithDefaultConf] : traceCode = 'provideFlowStepFailure', flowInstanceId = '8b12ff30-0b1b-11e7-b8e6-02425ee4dbdb', flowStepId = '8b1437b0-0b1b-11e7-b8e6-02425ee4dbdb', failureMessage = 'org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (java.net.ConnectException : erreur lors de la connexion au serveur localhost sur le port 1 527 avec le message Connexion refusée.) - at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225) - at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880) - ...'
{code} 		If an error occurs about getting a database connection when execution a SQL request, no MONIT traces is logged:
{code}
2017/03/17 15:10:58,351 GMT+0100 MONIT [org.ow2.petals.component.framework.UnderTestWithDefaultConf] : traceCode = 'provideFlowStepBegin', flowInstanceId = '8b12ff30-0b1b-11e7-b8e6-02425ee4dbdb', flowStepId = '8b1437b0-0b1b-11e7-b8e6-02425ee4dbdb', flowStepInterfaceName = '{http://petals.ow2.org/components/sql/version-1}SQLInterface', flowStepServiceName = '{http://petals.ow2.org/components/sql/service/1}SQLService', flowStepOperationName = '{http://petals.ow2.org/components/sql/version-1}select', flowStepEndpointName = 'sqlEndpointName', flowPreviousStepId = '8b12ff31-0b1b-11e7-b8e6-02425ee4dbdb'
2017/03/17 15:10:58,389 GMT+0100 WARNING [org.ow2.petals.component.framework.UnderTestWithDefaultConf] : Cannot create PoolableConnectionFactory (java.net.ConnectException : erreur lors de la connexion au serveur localhost sur le port 1 527 avec le message Connexion refusée.)
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (java.net.ConnectException : erreur lors de la connexion au serveur localhost sur le port 1 527 avec le message Connexion refusée.)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
...
2017/03/17 15:10:58,392 GMT+0100 FINE [org.ow2.petals.component.framework.UnderTestWithDefaultConf] : Send an asynchronous exchange with id : tests:8b12d820-0b1b-11e7-b8e6-02425ee4dbdb
2017/03/17 15:10:58,393 GMT+0100 FINE [org.ow2.petals.component.framework.UnderTestWithDefaultConf] : Intercepting message processing on ACCEPT_RESPONSE
2017/03/17 15:10:58,395 GMT+0100 MONIT [org.ow2.petals.component.framework.UnderTestWithDefaultConf] : traceCode = 'provideFlowStepFailure', flowInstanceId = '8b12ff30-0b1b-11e7-b8e6-02425ee4dbdb', flowStepId = '8b1437b0-0b1b-11e7-b8e6-02425ee4dbdb', failureMessage = 'org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (java.net.ConnectException : erreur lors de la connexion au serveur localhost sur le port 1 527 avec le message Connexion refusée.) - at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225) - at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880) - ...'
{code}

The following MONIT traces are expected: {{provideExtFlowStepBegin}} followed by {{provideExtFlowStepFailure}}.
Christophe DENEUX made changes - Fri, 17 Mar 2017 - 15:18:19 +0100
Description If an error occurs about getting a database connection when execution a SQL request, no MONIT traces is logged:
{code}
2017/03/17 15:10:58,351 GMT+0100 MONIT [org.ow2.petals.component.framework.UnderTestWithDefaultConf] : traceCode = 'provideFlowStepBegin', flowInstanceId = '8b12ff30-0b1b-11e7-b8e6-02425ee4dbdb', flowStepId = '8b1437b0-0b1b-11e7-b8e6-02425ee4dbdb', flowStepInterfaceName = '{http://petals.ow2.org/components/sql/version-1}SQLInterface', flowStepServiceName = '{http://petals.ow2.org/components/sql/service/1}SQLService', flowStepOperationName = '{http://petals.ow2.org/components/sql/version-1}select', flowStepEndpointName = 'sqlEndpointName', flowPreviousStepId = '8b12ff31-0b1b-11e7-b8e6-02425ee4dbdb'
2017/03/17 15:10:58,389 GMT+0100 WARNING [org.ow2.petals.component.framework.UnderTestWithDefaultConf] : Cannot create PoolableConnectionFactory (java.net.ConnectException : erreur lors de la connexion au serveur localhost sur le port 1 527 avec le message Connexion refusée.)
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (java.net.ConnectException : erreur lors de la connexion au serveur localhost sur le port 1 527 avec le message Connexion refusée.)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
...
2017/03/17 15:10:58,392 GMT+0100 FINE [org.ow2.petals.component.framework.UnderTestWithDefaultConf] : Send an asynchronous exchange with id : tests:8b12d820-0b1b-11e7-b8e6-02425ee4dbdb
2017/03/17 15:10:58,393 GMT+0100 FINE [org.ow2.petals.component.framework.UnderTestWithDefaultConf] : Intercepting message processing on ACCEPT_RESPONSE
2017/03/17 15:10:58,395 GMT+0100 MONIT [org.ow2.petals.component.framework.UnderTestWithDefaultConf] : traceCode = 'provideFlowStepFailure', flowInstanceId = '8b12ff30-0b1b-11e7-b8e6-02425ee4dbdb', flowStepId = '8b1437b0-0b1b-11e7-b8e6-02425ee4dbdb', failureMessage = 'org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (java.net.ConnectException : erreur lors de la connexion au serveur localhost sur le port 1 527 avec le message Connexion refusée.) - at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225) - at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880) - ...'
{code}

The following MONIT traces are expected: {{provideExtFlowStepBegin}} followed by {{provideExtFlowStepFailure}}. 		If an error occurs about getting a database connection when execution a SQL request, no MONIT traces is logged:
{code}
2017/03/17 15:10:58,351 GMT+0100 MONIT [org.ow2.petals.component.framework.UnderTestWithDefaultConf] : traceCode = 'provideFlowStepBegin', flowInstanceId = '8b12ff30-0b1b-11e7-b8e6-02425ee4dbdb', flowStepId = '8b1437b0-0b1b-11e7-b8e6-02425ee4dbdb', flowStepInterfaceName = '{http://petals.ow2.org/components/sql/version-1}SQLInterface', flowStepServiceName = '{http://petals.ow2.org/components/sql/service/1}SQLService', flowStepOperationName = '{http://petals.ow2.org/components/sql/version-1}select', flowStepEndpointName = 'sqlEndpointName', flowPreviousStepId = '8b12ff31-0b1b-11e7-b8e6-02425ee4dbdb'
2017/03/17 15:10:58,389 GMT+0100 WARNING [org.ow2.petals.component.framework.UnderTestWithDefaultConf] : Cannot create PoolableConnectionFactory (java.net.ConnectException : erreur lors de la connexion au serveur localhost sur le port 1 527 avec le message Connexion refusée.)
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (java.net.ConnectException : erreur lors de la connexion au serveur localhost sur le port 1 527 avec le message Connexion refusée.)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
...
2017/03/17 15:10:58,392 GMT+0100 FINE [org.ow2.petals.component.framework.UnderTestWithDefaultConf] : Send an asynchronous exchange with id : tests:8b12d820-0b1b-11e7-b8e6-02425ee4dbdb
2017/03/17 15:10:58,393 GMT+0100 FINE [org.ow2.petals.component.framework.UnderTestWithDefaultConf] : Intercepting message processing on ACCEPT_RESPONSE
2017/03/17 15:10:58,395 GMT+0100 MONIT [org.ow2.petals.component.framework.UnderTestWithDefaultConf] : traceCode = 'provideFlowStepFailure', flowInstanceId = '8b12ff30-0b1b-11e7-b8e6-02425ee4dbdb', flowStepId = '8b1437b0-0b1b-11e7-b8e6-02425ee4dbdb', failureMessage = 'org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (java.net.ConnectException : erreur lors de la connexion au serveur localhost sur le port 1 527 avec le message Connexion refusée.) - at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225) - at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880) - ...'
{code}

The following MONIT traces are expected:
# {{provideExtFlowStepBegin}},
# followed by {{provideExtFlowStepFailure}}.
Hide
Permalink
Christophe DENEUX added a comment - Fri, 17 Mar 2017 - 17:32:12 +0100

Fixed in trunk

Show
Christophe DENEUX added a comment - Fri, 17 Mar 2017 - 17:32:12 +0100 Fixed in trunk
Christophe DENEUX made changes - Fri, 17 Mar 2017 - 17:32:12 +0100
Status In Progress [ 10003 ] Resolved [ 10004 ]
Fix Version/s 1.6.3 [ 10685 ]
Resolution Fixed [ 1 ]
Transition Status Change Time Execution Times Last Executer Last Execution Date
New New Open Open
15s
1
Christophe DENEUX
Fri, 17 Mar 2017 - 15:16:51 +0100
Open Open In Progress In Progress
2s
1
Christophe DENEUX
Fri, 17 Mar 2017 - 15:16:53 +0100
In Progress In Progress Resolved Resolved
2h 15m
1
Christophe DENEUX
Fri, 17 Mar 2017 - 17:32:12 +0100

People

Dates

  • Created:
    Fri, 17 Mar 2017 - 15:16:36 +0100
    Updated:
    Fri, 17 Mar 2017 - 17:32:12 +0100
    Resolved:
    Fri, 17 Mar 2017 - 17:32:11 +0100
Atlassian JIRA (v4.1.2#531) | Report a problem | Request a feature | Contact administrators
Powered by a free Atlassian JIRA open source license for Petals ESB. Try JIRA - bug tracking software for your team.