nifi-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pierre Villard (Jira)" <j...@apache.org>
Subject [jira] [Resolved] (NIFI-6936) NiFi Stateless - Controller service DBCPConnectionPool will not be initialized
Date Tue, 21 Apr 2020 08:07:00 GMT

     [ https://issues.apache.org/jira/browse/NIFI-6936?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Pierre Villard resolved NIFI-6936.
----------------------------------
      Assignee: Pierre Villard
    Resolution: Duplicate

Closing as duplicate of NIFI-7380 where I submitted a pull request.

> NiFi Stateless - Controller service DBCPConnectionPool will not be initialized
> ------------------------------------------------------------------------------
>
>                 Key: NIFI-6936
>                 URL: https://issues.apache.org/jira/browse/NIFI-6936
>             Project: Apache NiFi
>          Issue Type: Bug
>    Affects Versions: 1.10.0
>            Reporter: Don Bosco Nguyen van Hoi
>            Assignee: Pierre Villard
>            Priority: Minor
>         Attachments: image-2019-12-10-13-13-15-953.png
>
>
> h3. When trying to initialize a Flow with the controller service DBCPConnectionPool
1.10.0, it will fail.
>  
> h3. Configuration: 
> !image-2019-12-10-13-13-15-953.png!
> JSON-Example for stateless-configuration
> {code:javascript}
> {
>   "registryUrl": "http://localhost:18080",
>   "bucketId": "9ee153c5-ae62-4616-96e2-9335e2bd442b",
>   "flowId" : "87fccff0-336d-4d34-b3a4-293390364e0c",
>   "parameters": {
>     "sql_connection_url" : "jdbc:mariadb://xx.xx.xx.xx:3306/test",
>     "sql_user": "test",
>     "sql_password": { "sensitive": "true", "value": "anypassword" },
>     "sql_driver_name" : "org.mariadb.jdbc.Driver",
>     "sql_driver_location": "/var/www/share/nifi_data/configuration_resources/custom_lib/mariadb-java-client-2.3.0.jar"
>   }
> }{code}
> The error i get is the following
> {noformat}
> 12:59:51.542 [main] INFO org.apache.nifi.stateless.bootstrap.ExtensionDiscovery - Successfully
discovered extensions in 6255 milliseconds
> 12:59:51.549 [main] DEBUG org.apache.nifi.stateless.core.ComponentFactory - Setting context
class loader to org.apache.nifi.nar.InstanceClassLoader@1124dd79 (parent = org.apache.nifi.nar.NarClassLoader[/var/www/share/nifi_archive/nifi-1.10.0/work/stateless-nars/nifi-dbcp-service-nar-1.10.0.nar-unpacked])
to create org.apache.nifi.dbcp.DBCPConnectionPool
> 12:59:51.562 [main] DEBUG org.apache.nifi.parameter.ExpressionLanguageAwareParameterParser
- For input #{sql_driver_location} found 1 Parameter references: [org.apache.nifi.parameter.StandardParameterReference@3265995e]
> 12:59:51.565 [main] DEBUG org.apache.nifi.parameter.ExpressionLanguageAwareParameterParser
- For input /var/www/share/nifi_data/configuration_resources/custom_lib/mariadb-java-client-2.3.0.jar
found 0 Parameter references: []
> 12:59:51.566 [main] DEBUG org.apache.nifi.parameter.ExpressionLanguageAwareParameterParser
- For input 500 millis found 0 Parameter references: []
> 12:59:51.566 [main] DEBUG org.apache.nifi.parameter.ExpressionLanguageAwareParameterParser
- For input 8 found 0 Parameter references: []
> 12:59:51.566 [main] DEBUG org.apache.nifi.parameter.ExpressionLanguageAwareParameterParser
- For input 0 found 0 Parameter references: []
> 12:59:51.566 [main] DEBUG org.apache.nifi.parameter.ExpressionLanguageAwareParameterParser
- For input 8 found 0 Parameter references: []
> 12:59:51.567 [main] DEBUG org.apache.nifi.parameter.ExpressionLanguageAwareParameterParser
- For input -1 found 0 Parameter references: []
> 12:59:51.567 [main] DEBUG org.apache.nifi.parameter.ExpressionLanguageAwareParameterParser
- For input -1 found 0 Parameter references: []
> 12:59:51.567 [main] DEBUG org.apache.nifi.parameter.ExpressionLanguageAwareParameterParser
- For input 30 mins found 0 Parameter references: []
> 12:59:51.567 [main] DEBUG org.apache.nifi.parameter.ExpressionLanguageAwareParameterParser
- For input -1 found 0 Parameter references: []
> Exception in thread "main" java.lang.reflect.InvocationTargetException
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> 	at java.lang.reflect.Method.invoke(Method.java:498)
> 	at org.apache.nifi.bootstrap.RunStatelessNiFi.main(RunStatelessNiFi.java:69)
> Caused by: java.lang.reflect.InvocationTargetException
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> 	at java.lang.reflect.Method.invoke(Method.java:498)
> 	at org.apache.nifi.StatelessNiFi.main(StatelessNiFi.java:103)
> 	... 5 more
> Caused by: java.lang.RuntimeException: Failed to enable Controller Service {id=92c03c8d-ae33-31fd-93e6-827768979734,
name=SQL-Verbindung, type=class org.apache.nifi.dbcp.DBCPConnectionPool} because validation
failed: ['Database Connection URL' is invalid because Database Connection URL is required,
'Database Driver Class Name' is invalid because Database Driver Class Name is required]
> 	at org.apache.nifi.stateless.core.StatelessControllerServiceLookup.enableControllerServices(StatelessControllerServiceLookup.java:133)
> 	at org.apache.nifi.stateless.core.StatelessFlow.<init>(StatelessFlow.java:153)
> 	at org.apache.nifi.stateless.core.StatelessFlow.createAndEnqueueFromJSON(StatelessFlow.java:469)
> 	at org.apache.nifi.stateless.runtimes.Program.runLocal(Program.java:133)
> 	at org.apache.nifi.stateless.runtimes.Program.launch(Program.java:67)
> 	... 10 more{noformat}
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Mime
View raw message