Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

0400 Puppet (err): Failed to apply catalog: BUG! removeinfectedconnections should have been '0' or '1' #590

Open
vijayalp opened this issue Apr 6, 2022 · 19 comments

Comments

@vijayalp
Copy link
Contributor

vijayalp commented Apr 6, 2022

I get below error for datasources
0400 Puppet (err): Failed to apply catalog: BUG! removeinfectedconnections should have been '0' or '1'

Environment: RHEL 8.4, weblogic 14110, biemond orawls 2.0.12, puppet 4.10.1

This error is not observed when weblogic 12214 and rhel 7.8 with same stated above puppet and biemond orawls.

can you help what need to check.

@vijayalp
Copy link
Contributor Author

vijayalp commented Apr 6, 2022

datasource looks like below:
wls_datasources:
"%{hiera('domain_name')}/TestDemoDataSource":
ensure: present
drivername: oracle.jdbc.driver.OracleDriver
globaltransactionsprotocol: TwoPhaseCommit
initialcapacity: '1'
maxcapacity: '15'
mincapacity: '1'
statementcachesize: '10'
jndinames:
- amdocs.xpidemo.DataSource
target: "%{hiera('targets')}"
targettype: "%{hiera('targettypes')}"
testconnectionsonreserve: '0'
secondstotrustidlepoolconnection: '10'
testfrequency: '400'
connectioncreationretryfrequency: '0'
usexa: '0'
testtablename: SQL SELECT 1 FROM DUAL
initsql: SQL ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_NUMERIC_CHARACTERS
= '.,'
url: jdbc:oracle:thin:@testdbhost:1521:NONDB
user: "test13"
password: "test3"

@biemond
Copy link
Owner

biemond commented Apr 6, 2022

Hey , I would expect this is a new datasource option of wls 14

@vijayalp
Copy link
Contributor Author

vijayalp commented Apr 7, 2022 via email

@vijayalp
Copy link
Contributor Author

Hi Edwin,
As per you comment, if removeinfectedconnections is necessary parameter, we get to see same error message during datasource creation objects. therefore, after commenting the BUG line in the file orawls/lib/puppet/type/wls_datasource/removeinfectedconnections.rb, such error is not seen and datasource creation is successfull. Could you help how this work around in removeinfectedconnection.rb can be fixed? is there any higher version this issue been fixed.
Regards,
Vijaya.

@vijayalp
Copy link
Contributor Author

Hi
Can you help here?
Regards,
Vijaya.

@biemond
Copy link
Owner

biemond commented Apr 19, 2022

ok, few things you can try .

put puppet in debug mode and look at the datasource output or follow this yourself https://github.com/biemond/biemond-orawls/tree/puppet4/files/providers/wls_datasource see if the mbean property is there and what goes wrong with the wlst scripts

maybe this true param makes it required or not type

or add a default value https://github.com/biemond/biemond-orawls/blob/puppet4/lib/puppet/type/wls_datasource/fanenabled.rb#L8

@vijayalp
Copy link
Contributor Author

Hi,
i have enabled puppet debug for wls_datasource creation, all the datasources are created successfully and have property "RemoveInfectedConnections" and still get to see the error BUG! removeinfectedconnections should have been '0' or '1'

2022-04-19 09:26:47 -0400 Scope(Class[Amd_wls_datasources::Create_wls_datasources]) (notice): wls_datasources= {XPIDemoDomain/XPIDemoDataSource => {ensure => present, drivername => oracle.jdbc.driver.OracleDriver, globaltransactionsprotocol => TwoPhaseCommit, initialcapacity => 1, maxcapacity => 20, mincapacity => 1, statementcachesize => 10, jndinames => [amdocs.xpidemo.DataSource], target => XPIDemoCluster, targettype => Cluster, testconnectionsonreserve => 0, secondstotrustidlepoolconnection => 10, testfrequency => 400, connectioncreationretryfrequency => 0, usexa => 0, testtablename => SQL SELECT 1 FROM DUAL, initsql => SQL ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_NUMERIC_CHARACTERS = '.,', url => jdbc:oracle:thin:@10.238.149.157:1521:NONTLSDB, user => test13, password => ******}, XPIDemoDomain/XPIDemoTrxDataSource => {ensure => present, drivername => oracle.jdbc.xa.client.OracleXADataSource, globaltransactionsprotocol => TwoPhaseCommit, initialcapacity => 1, maxcapacity => 15, mincapacity => 1, statementcachesize => 10, jndinames => [amdocs.xpidemo.Trx.DataSource], target => XPIDemoCluster, targettype => Cluster, testconnectionsonreserve => 0, secondstotrustidlepoolconnection => 10, testfrequency => 400, connectioncreationretryfrequency => 0, usexa => 1, testtablename => SQL SELECT 1 FROM DUAL, initsql => SQL ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_NUMERIC_CHARACTERS = '.,', url => jdbc:oracle:thin:@10.238.149.157:1521:NONTLSDB, user => test13, password => ******, xaproperties => [RollbackLocalTxUponConnClose=0, RecoverOnlyOnce=0, KeepLogicalConnOpenOnRelease=0, KeepXaConnTillTxComplete=1, XaTransactionTimeout=0, XaRetryIntervalSeconds=60, XaRetryDurationSeconds=0, ResourceHealthMonitoring=1, NewXaConnForCommit=0, XaSetTransactionTimeout=0, XaEndOnlyOnce=0, NeedTxCtxOnClose=0]}, XPIDemoDomain/TestDemoDataSource => {ensure => present, drivername => oracle.jdbc.driver.OracleDriver, globaltransactionsprotocol => TwoPhaseCommit, initialcapacity => 1, maxcapacity => 15, mincapacity => 1, statementcachesize => 10, jndinames => [amdocs.testdemo.DataSource], target => XPIDemoCluster, targettype => Cluster, testconnectionsonreserve => 0, secondstotrustidlepoolconnection => 10, testfrequency => 400, connectioncreationretryfrequency => 0, usexa => 0, testtablename => SQL SELECT 1 FROM DUAL, initsql => SQL ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_NUMERIC_CHARACTERS = '.,', url => jdbc:oracle:thin:@10.238.149.157:1521:NONTLSDB, user => test13, password => ******}, XPIDemoDomain/TestDemoTrxDataSource => {ensure => present, drivername => oracle.jdbc.xa.client.OracleXADataSource, globaltransactionsprotocol => TwoPhaseCommit, initialcapacity => 1, maxcapacity => 15, mincapacity => 1, statementcachesize => 10, jndinames => [amdocs.testdemo.Trx.DataSource], target => XPIDemoCluster, targettype => Cluster, testconnectionsonreserve => 0, secondstotrustidlepoolconnection => 10, testfrequency => 400, connectioncreationretryfrequency => 0, usexa => 1, testtablename => SQL SELECT 1 FROM DUAL, initsql => SQL ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_NUMERIC_CHARACTERS = '.,', url => jdbc:oracle:thin:@10.238.149.157:1521:NONTLSDB, user => test13, password => ******, xaproperties => [RollbackLocalTxUponConnClose=0, RecoverOnlyOnce=0, KeepLogicalConnOpenOnRelease=0, KeepXaConnTillTxComplete=1, XaTransactionTimeout=0, XaRetryIntervalSeconds=60, XaRetryDurationSeconds=0, ResourceHealthMonitoring=1, NewXaConnForCommit=0, XaSetTransactionTimeout=0, XaEndOnlyOnce=0, NeedTxCtxOnClose=0], extraproperties => [SendStreamAsBlob=true, oracle.net.CONNECT_TIMEOUT=1000, oracle.net.ssl_server_dn_match=false]}}
2022-04-19 09:26:47 -0400 Puppet (debug): wls_setting_file is overridden to /users/acdwrk1/wls_setting.yaml
2022-04-19 09:26:47 -0400 Puppet (debug): Adding relationship from Class[Amd_common_config] to Class[Amd_wls_datasources::Create_wls_datasources] with 'before'
2022-04-19 09:26:47 -0400 Puppet (notice): Compiled catalog for eaasrt.corp.amdocs.com in environment production in 0.33 seconds
2022-04-19 09:26:47 -0400 Puppet (debug): Creating default schedules
2022-04-19 09:26:47 -0400 Puppet (debug): Loaded state in 0.01 seconds
2022-04-19 09:26:47 -0400 Puppet (debug): Loaded state in 0.01 seconds
2022-04-19 09:26:47 -0400 Puppet (debug): Loaded transaction store file in 0.00 seconds
2022-04-19 09:26:47 -0400 Puppet (info): Applying configuration version '1650374807'
2022-04-19 09:26:47 -0400 /Stage[main]/Amd_common_config/before (debug): subscribes to Class[Amd_wls_datasources::Create_wls_datasources]
2022-04-19 09:26:48 -0400 Puppet (debug): Prefetching simple resources for wls_datasource
2022-04-19 09:26:48 -0400 Puppet (debug): index wls_datasource
2022-04-19 09:26:48 -0400 Puppet (debug): Evicting cache entry for environment 'production'
2022-04-19 09:26:48 -0400 Puppet (debug): Caching environment 'production' (ttl = 0 sec)
2022-04-19 09:26:48 -0400 Puppet (debug): Executing: wlstScript with action index
2022-04-19 09:26:48 -0400 Puppet (debug): domain found XPIDemoDomain
2022-04-19 09:26:48 -0400 Puppet (debug): no custom trust
2022-04-19 09:26:48 -0400 Puppet (info): Starting the wls daemon for domain XPIDemoDomain
2022-04-19 09:26:48 -0400 Puppet (debug): Defining common methods...
2022-04-19 09:26:48 -0400 Puppet (info): Executing wls-script /tmp/wlstCommonScript.py20220419-527594-1sjd1dx
2022-04-19 09:26:48 -0400 Puppet (info): Executing wls-script /tmp/wlstScript20220419-527594-4kfx7p.py with timeout = 120
2022-04-19 09:26:48 -0400 Puppet (debug): Passing domain XPIDemoDomain
2022-04-19 09:26:48 -0400 Puppet (debug): Passing tmp script location
2022-04-19 09:26:48 -0400 Puppet (debug): Passing use_default_value_when_empty True
2022-04-19 09:26:48 -0400 Puppet (debug): Passing credentials to WLST
2022-04-19 09:26:48 -0400 Puppet (info): Connecting to wls on url t3://eaasrt:27000
2022-04-19 09:26:48 -0400 Puppet (debug): CLASSPATH=/usr/java/jdk1.8.0_291-amd64/lib/tools.jar:/opt/wls1411/wlserver/modules/features/wlst.wls.classpath.jar:
2022-04-19 09:26:48 -0400 Puppet (debug):
2022-04-19 09:26:48 -0400 Puppet (debug): PATH=/opt/wls1411/wlserver/server/bin:/opt/wls1411/wlserver/../oracle_common/modules/thirdparty/org.apache.ant/1.10.5.0.0/apache-ant-1.10.5/bin:/usr/java/jdk1.8.0_291-amd64/jre/bin:/usr/java/jdk1.8.0_291-amd64/bin:/usr/java/jdk1.8.0_291-amd64/bin:/opt/puppetlabs/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/opt/wls1411/wlserver/../oracle_common/modules/thirdparty/apache-maven_bundle/3.6.1.0.0/apache-maven-3.6.1/bin
2022-04-19 09:26:48 -0400 Puppet (debug):
2022-04-19 09:26:48 -0400 Puppet (debug): Your environment has been set.
2022-04-19 09:26:48 -0400 Puppet (debug):
2022-04-19 09:26:48 -0400 Puppet (debug): Initializing WebLogic Scripting Tool (WLST) ...
2022-04-19 09:26:48 -0400 Puppet (debug):
2022-04-19 09:26:57 -0400 Puppet (debug): Welcome to WebLogic Server Administration Scripting Shell
2022-04-19 09:26:57 -0400 Puppet (debug):
2022-04-19 09:26:57 -0400 Puppet (debug): Type help() for help on available commands
2022-04-19 09:26:57 -0400 Puppet (debug):
2022-04-19 09:26:57 -0400 Puppet (debug): wls:/offline> execfile('/tmp/wlstCommonScript.py20220419-527594-1sjd1dx')
2022-04-19 09:26:58 -0400 Puppet (debug): wls:/offline> domain = 'XPIDemoDomain'
2022-04-19 09:26:58 -0400 Puppet (debug): wls:/offline> tmp_script = '/tmp/wlstScriptXPIDemoDomain.out'
2022-04-19 09:26:58 -0400 Puppet (debug): wls:/offline> use_default_value_when_empty = True
2022-04-19 09:26:58 -0400 Puppet (debug): wls:/offline> weblogicUser = 'acdadmin'
2022-04-19 09:26:58 -0400 Puppet (debug): wls:/offline> weblogicPassword = 'acdadmin1'
2022-04-19 09:26:58 -0400 Puppet (debug): wls:/offline> connect('acdadmin','acdadmin1','t3://eaasrt:27000')
2022-04-19 09:26:59 -0400 Puppet (debug): Connecting to t3://eaasrt:27000 with userid acdadmin ...
2022-04-19 09:27:00 -0400 Puppet (debug): Successfully connected to Admin Server "XPIDemoServer" that belongs to domain "XPIDemoDomain".
2022-04-19 09:27:00 -0400 Puppet (debug):
2022-04-19 09:27:00 -0400 Puppet (debug): Warning: An insecure protocol was used to connect to the server.
2022-04-19 09:27:00 -0400 Puppet (debug): To ensure on-the-wire security, the SSL port or Admin port should be used instead.
2022-04-19 09:27:00 -0400 Puppet (debug):
2022-04-19 09:27:00 -0400 Puppet (debug): wls:/XPIDemoDomain/serverConfig/> execfile('/tmp/wlstScript20220419-527594-4kfx7p.py')
2022-04-19 09:27:00 -0400 Puppet (debug): dr-- TestDemoDataSource
2022-04-19 09:27:00 -0400 Puppet (debug): dr-- TestDemoTrxDataSource
2022-04-19 09:27:00 -0400 Puppet (debug): dr-- XPIDemoDataSource
2022-04-19 09:27:00 -0400 Puppet (debug): dr-- XPIDemoTrxDataSource
2022-04-19 09:27:01 -0400 Puppet (debug):
2022-04-19 09:27:01 -0400 Puppet (debug): TestDemoDataSource
2022-04-19 09:27:01 -0400 Puppet (debug): get att DatasourceType
2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [None, None, None])
2022-04-19 09:27:01 -0400 Puppet (debug): Getting generic property DatasourceType
2022-04-19 09:27:01 -0400 Puppet (debug): get att Url
2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [None, None, None])
2022-04-19 09:27:01 -0400 Puppet (debug): Getting generic property Url
2022-04-19 09:27:01 -0400 Puppet (debug): get att DriverName
2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [None, None, None])
2022-04-19 09:27:01 -0400 Puppet (debug): Getting generic property DriverName
2022-04-19 09:27:01 -0400 Puppet (debug): get att UseXaDataSourceInterface
2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', True, None])
2022-04-19 09:27:01 -0400 Puppet (debug): Getting boolean property UseXaDataSourceInterface
2022-04-19 09:27:01 -0400 Puppet (debug): get att MaxCapacity
2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'int', 15, None])
2022-04-19 09:27:01 -0400 Puppet (debug): getting integer property MaxCapacity
2022-04-19 09:27:01 -0400 Puppet (debug): get att InitialCapacity
2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'int', 1, None])
2022-04-19 09:27:01 -0400 Puppet (debug): getting integer property InitialCapacity
2022-04-19 09:27:01 -0400 Puppet (debug): get att MinCapacity
2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'int', 1, None])
2022-04-19 09:27:01 -0400 Puppet (debug): getting integer property MinCapacity
2022-04-19 09:27:01 -0400 Puppet (debug): get att StatementCacheType
2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [None, u'LRU', None])
2022-04-19 09:27:01 -0400 Puppet (debug): Getting generic property StatementCacheType
2022-04-19 09:27:01 -0400 Puppet (debug): get att StatementCacheSize
2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'int', 10, None])
2022-04-19 09:27:01 -0400 Puppet (debug): getting integer property StatementCacheSize
2022-04-19 09:27:01 -0400 Puppet (debug): get att TestConnectionsOnReserve
2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', False, None])
2022-04-19 09:27:01 -0400 Puppet (debug): Getting boolean property TestConnectionsOnReserve
2022-04-19 09:27:01 -0400 Puppet (debug): get att InactiveConnectionTimeoutSeconds
2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'int', 0, None])
2022-04-19 09:27:01 -0400 Puppet (debug): getting integer property InactiveConnectionTimeoutSeconds
2022-04-19 09:27:01 -0400 Puppet (debug): get att ConnectionReserveTimeoutSeconds
2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'int', 10, None])
2022-04-19 09:27:01 -0400 Puppet (debug): getting integer property ConnectionReserveTimeoutSeconds
2022-04-19 09:27:01 -0400 Puppet (debug): get att ShrinkFrequencySeconds
2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'int', 900, None])
2022-04-19 09:27:01 -0400 Puppet (debug): getting integer property ShrinkFrequencySeconds
2022-04-19 09:27:01 -0400 Puppet (debug): get att SecondsToTrustAnIdlePoolConnection
2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'int', 10, None])
2022-04-19 09:27:01 -0400 Puppet (debug): getting integer property SecondsToTrustAnIdlePoolConnection
2022-04-19 09:27:01 -0400 Puppet (debug): get att TestFrequencySeconds
2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'int', 120, None])
2022-04-19 09:27:01 -0400 Puppet (debug): getting integer property TestFrequencySeconds
2022-04-19 09:27:01 -0400 Puppet (debug): get att ConnectionCreationRetryFrequencySeconds
2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'int', 0, None])
2022-04-19 09:27:01 -0400 Puppet (debug): getting integer property ConnectionCreationRetryFrequencySeconds
2022-04-19 09:27:01 -0400 Puppet (debug): get att InitSql
2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [None, None, None])
2022-04-19 09:27:01 -0400 Puppet (debug): Getting generic property InitSql
2022-04-19 09:27:01 -0400 Puppet (debug): get att StatementTimeout
2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'int', -1, None])
2022-04-19 09:27:01 -0400 Puppet (debug): getting integer property StatementTimeout
2022-04-19 09:27:01 -0400 Puppet (debug): get att LoginDelaySeconds
2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'int', 0, None])
2022-04-19 09:27:01 -0400 Puppet (debug): getting integer property LoginDelaySeconds
2022-04-19 09:27:01 -0400 Puppet (debug): get att WrapTypes
2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', True, None])
2022-04-19 09:27:01 -0400 Puppet (debug): Getting boolean property WrapTypes
2022-04-19 09:27:01 -0400 Puppet (debug): get att RemoveInfectedConnections
2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', True, None])
2022-04-19 09:27:01 -0400 Puppet (debug): Getting boolean property RemoveInfectedConnections
2022-04-19 09:27:01 -0400 Puppet (debug): get att RowPrefetch
2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', False, None])
2022-04-19 09:27:01 -0400 Puppet (debug): Getting boolean property RowPrefetch
2022-04-19 09:27:01 -0400 Puppet (debug): get att RowPrefetchSize
2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'int', 48, None])
2022-04-19 09:27:01 -0400 Puppet (debug): getting integer property RowPrefetchSize
2022-04-19 09:27:01 -0400 Puppet (debug): get att TestTableName
2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [None, None, None])
2022-04-19 09:27:01 -0400 Puppet (debug): Getting generic property TestTableName
2022-04-19 09:27:01 -0400 Puppet (debug): get att GlobalTransactionsProtocol
2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [None, u'OnePhaseCommit', None])
2022-04-19 09:27:01 -0400 Puppet (debug): Getting generic property GlobalTransactionsProtocol
2022-04-19 09:27:01 -0400 Puppet (debug): get att FanEnabled
2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', False, None])
2022-04-19 09:27:01 -0400 Puppet (debug): Getting boolean property FanEnabled
2022-04-19 09:27:01 -0400 Puppet (debug): get att OnsNodeList
2022-04-19 09:27:01 -0400 Puppet (debug): array(java.lang.Object, [None, None, None])
2022-04-19 09:27:01 -0400 Puppet (debug): Getting generic property OnsNodeList
2022-04-19 09:27:01 -0400 Puppet (debug): dr-- user
2022-04-19 09:27:01 -0400 Puppet (debug):
2022-04-19 09:27:01 -0400 Puppet (debug): dr-- XPIDemoCluster
2022-04-19 09:27:01 -0400 Puppet (debug):
2022-04-19 09:27:01 -0400 Puppet (debug): dr-- XPIDemoServer
2022-04-19 09:27:01 -0400 Puppet (debug):
2022-04-19 09:27:02 -0400 Puppet (debug): TestDemoTrxDataSource
2022-04-19 09:27:02 -0400 Puppet (debug): get att DatasourceType
2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [None, None, None])
2022-04-19 09:27:02 -0400 Puppet (debug): Getting generic property DatasourceType
2022-04-19 09:27:02 -0400 Puppet (debug): get att Url
2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [None, None, None])
2022-04-19 09:27:02 -0400 Puppet (debug): Getting generic property Url
2022-04-19 09:27:02 -0400 Puppet (debug): get att DriverName
2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [None, None, None])
2022-04-19 09:27:02 -0400 Puppet (debug): Getting generic property DriverName
2022-04-19 09:27:02 -0400 Puppet (debug): get att UseXaDataSourceInterface
2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', True, None])
2022-04-19 09:27:02 -0400 Puppet (debug): Getting boolean property UseXaDataSourceInterface
2022-04-19 09:27:02 -0400 Puppet (debug): get att MaxCapacity
2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'int', 15, None])
2022-04-19 09:27:02 -0400 Puppet (debug): getting integer property MaxCapacity
2022-04-19 09:27:02 -0400 Puppet (debug): get att InitialCapacity
2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'int', 1, None])
2022-04-19 09:27:02 -0400 Puppet (debug): getting integer property InitialCapacity
2022-04-19 09:27:02 -0400 Puppet (debug): get att MinCapacity
2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'int', 1, None])
2022-04-19 09:27:02 -0400 Puppet (debug): getting integer property MinCapacity
2022-04-19 09:27:02 -0400 Puppet (debug): get att StatementCacheType
2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [None, u'LRU', None])
2022-04-19 09:27:02 -0400 Puppet (debug): Getting generic property StatementCacheType
2022-04-19 09:27:02 -0400 Puppet (debug): get att StatementCacheSize
2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'int', 10, None])
2022-04-19 09:27:02 -0400 Puppet (debug): getting integer property StatementCacheSize
2022-04-19 09:27:02 -0400 Puppet (debug): get att TestConnectionsOnReserve
2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', False, None])
2022-04-19 09:27:02 -0400 Puppet (debug): Getting boolean property TestConnectionsOnReserve
2022-04-19 09:27:02 -0400 Puppet (debug): get att InactiveConnectionTimeoutSeconds
2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'int', 0, None])
2022-04-19 09:27:02 -0400 Puppet (debug): getting integer property InactiveConnectionTimeoutSeconds
2022-04-19 09:27:02 -0400 Puppet (debug): get att ConnectionReserveTimeoutSeconds
2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'int', 10, None])
2022-04-19 09:27:02 -0400 Puppet (debug): getting integer property ConnectionReserveTimeoutSeconds
2022-04-19 09:27:02 -0400 Puppet (debug): get att ShrinkFrequencySeconds
2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'int', 900, None])
2022-04-19 09:27:02 -0400 Puppet (debug): getting integer property ShrinkFrequencySeconds
2022-04-19 09:27:02 -0400 Puppet (debug): get att SecondsToTrustAnIdlePoolConnection
2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'int', 10, None])
2022-04-19 09:27:02 -0400 Puppet (debug): getting integer property SecondsToTrustAnIdlePoolConnection
2022-04-19 09:27:02 -0400 Puppet (debug): get att TestFrequencySeconds
2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'int', 120, None])
2022-04-19 09:27:02 -0400 Puppet (debug): getting integer property TestFrequencySeconds
2022-04-19 09:27:02 -0400 Puppet (debug): get att ConnectionCreationRetryFrequencySeconds
2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'int', 0, None])
2022-04-19 09:27:02 -0400 Puppet (debug): getting integer property ConnectionCreationRetryFrequencySeconds
2022-04-19 09:27:02 -0400 Puppet (debug): get att InitSql
2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [None, None, None])
2022-04-19 09:27:02 -0400 Puppet (debug): Getting generic property InitSql
2022-04-19 09:27:02 -0400 Puppet (debug): get att StatementTimeout
2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'int', -1, None])
2022-04-19 09:27:02 -0400 Puppet (debug): getting integer property StatementTimeout
2022-04-19 09:27:02 -0400 Puppet (debug): get att LoginDelaySeconds
2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'int', 0, None])
2022-04-19 09:27:02 -0400 Puppet (debug): getting integer property LoginDelaySeconds
2022-04-19 09:27:02 -0400 Puppet (debug): get att WrapTypes
2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', True, None])
2022-04-19 09:27:02 -0400 Puppet (debug): Getting boolean property WrapTypes
2022-04-19 09:27:02 -0400 Puppet (debug): get att RemoveInfectedConnections
2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', True, None])
2022-04-19 09:27:02 -0400 Puppet (debug): Getting boolean property RemoveInfectedConnections
2022-04-19 09:27:02 -0400 Puppet (debug): get att RowPrefetch
2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', False, None])
2022-04-19 09:27:02 -0400 Puppet (debug): Getting boolean property RowPrefetch
2022-04-19 09:27:02 -0400 Puppet (debug): get att RowPrefetchSize
2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'int', 48, None])
2022-04-19 09:27:02 -0400 Puppet (debug): getting integer property RowPrefetchSize
2022-04-19 09:27:02 -0400 Puppet (debug): get att TestTableName
2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [None, None, None])
2022-04-19 09:27:02 -0400 Puppet (debug): Getting generic property TestTableName
2022-04-19 09:27:02 -0400 Puppet (debug): get att GlobalTransactionsProtocol
2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [None, u'OnePhaseCommit', None])
2022-04-19 09:27:02 -0400 Puppet (debug): Getting generic property GlobalTransactionsProtocol
2022-04-19 09:27:02 -0400 Puppet (debug): get att FanEnabled
2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', False, None])
2022-04-19 09:27:02 -0400 Puppet (debug): Getting boolean property FanEnabled
2022-04-19 09:27:02 -0400 Puppet (debug): get att OnsNodeList
2022-04-19 09:27:02 -0400 Puppet (debug): array(java.lang.Object, [None, None, None])
2022-04-19 09:27:02 -0400 Puppet (debug): Getting generic property OnsNodeList
2022-04-19 09:27:02 -0400 Puppet (debug): dr-- SendStreamAsBlob
2022-04-19 09:27:02 -0400 Puppet (debug): dr-- oracle.net.CONNECT_TIMEOUT
2022-04-19 09:27:02 -0400 Puppet (debug): dr-- oracle.net.ssl_server_dn_match
2022-04-19 09:27:02 -0400 Puppet (debug): dr-- user
2022-04-19 09:27:02 -0400 Puppet (debug):
2022-04-19 09:27:03 -0400 Puppet (debug): dr-- XPIDemoCluster
2022-04-19 09:27:03 -0400 Puppet (debug):
2022-04-19 09:27:03 -0400 Puppet (debug): dr-- XPIDemoServer
2022-04-19 09:27:03 -0400 Puppet (debug):
2022-04-19 09:27:03 -0400 Puppet (debug): XPIDemoDataSource
2022-04-19 09:27:03 -0400 Puppet (debug): get att DatasourceType
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, None, None])
2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property DatasourceType
2022-04-19 09:27:03 -0400 Puppet (debug): get att Url
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, None, None])
2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property Url
2022-04-19 09:27:03 -0400 Puppet (debug): get att DriverName
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, None, None])
2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property DriverName
2022-04-19 09:27:03 -0400 Puppet (debug): get att UseXaDataSourceInterface
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', True, None])
2022-04-19 09:27:03 -0400 Puppet (debug): Getting boolean property UseXaDataSourceInterface
2022-04-19 09:27:03 -0400 Puppet (debug): get att MaxCapacity
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 15, None])
2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property MaxCapacity
2022-04-19 09:27:03 -0400 Puppet (debug): get att InitialCapacity
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 1, None])
2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property InitialCapacity
2022-04-19 09:27:03 -0400 Puppet (debug): get att MinCapacity
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 1, None])
2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property MinCapacity
2022-04-19 09:27:03 -0400 Puppet (debug): get att StatementCacheType
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, u'LRU', None])
2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property StatementCacheType
2022-04-19 09:27:03 -0400 Puppet (debug): get att StatementCacheSize
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 10, None])
2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property StatementCacheSize
2022-04-19 09:27:03 -0400 Puppet (debug): get att TestConnectionsOnReserve
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', False, None])
2022-04-19 09:27:03 -0400 Puppet (debug): Getting boolean property TestConnectionsOnReserve
2022-04-19 09:27:03 -0400 Puppet (debug): get att InactiveConnectionTimeoutSeconds
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 0, None])
2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property InactiveConnectionTimeoutSeconds
2022-04-19 09:27:03 -0400 Puppet (debug): get att ConnectionReserveTimeoutSeconds
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 10, None])
2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property ConnectionReserveTimeoutSeconds
2022-04-19 09:27:03 -0400 Puppet (debug): get att ShrinkFrequencySeconds
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 900, None])
2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property ShrinkFrequencySeconds
2022-04-19 09:27:03 -0400 Puppet (debug): get att SecondsToTrustAnIdlePoolConnection
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 10, None])
2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property SecondsToTrustAnIdlePoolConnection
2022-04-19 09:27:03 -0400 Puppet (debug): get att TestFrequencySeconds
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 120, None])
2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property TestFrequencySeconds
2022-04-19 09:27:03 -0400 Puppet (debug): get att ConnectionCreationRetryFrequencySeconds
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 0, None])
2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property ConnectionCreationRetryFrequencySeconds
2022-04-19 09:27:03 -0400 Puppet (debug): get att InitSql
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, None, None])
2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property InitSql
2022-04-19 09:27:03 -0400 Puppet (debug): get att StatementTimeout
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', -1, None])
2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property StatementTimeout
2022-04-19 09:27:03 -0400 Puppet (debug): get att LoginDelaySeconds
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 0, None])
2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property LoginDelaySeconds
2022-04-19 09:27:03 -0400 Puppet (debug): get att WrapTypes
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', True, None])
2022-04-19 09:27:03 -0400 Puppet (debug): Getting boolean property WrapTypes
2022-04-19 09:27:03 -0400 Puppet (debug): get att RemoveInfectedConnections
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', True, None])
2022-04-19 09:27:03 -0400 Puppet (debug): Getting boolean property RemoveInfectedConnections
2022-04-19 09:27:03 -0400 Puppet (debug): get att RowPrefetch
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', False, None])
2022-04-19 09:27:03 -0400 Puppet (debug): Getting boolean property RowPrefetch
2022-04-19 09:27:03 -0400 Puppet (debug): get att RowPrefetchSize
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 48, None])
2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property RowPrefetchSize
2022-04-19 09:27:03 -0400 Puppet (debug): get att TestTableName
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, None, None])
2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property TestTableName
2022-04-19 09:27:03 -0400 Puppet (debug): get att GlobalTransactionsProtocol
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, u'OnePhaseCommit', None])
2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property GlobalTransactionsProtocol
2022-04-19 09:27:03 -0400 Puppet (debug): get att FanEnabled
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', False, None])
2022-04-19 09:27:03 -0400 Puppet (debug): Getting boolean property FanEnabled
2022-04-19 09:27:03 -0400 Puppet (debug): get att OnsNodeList
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, None, None])
2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property OnsNodeList
2022-04-19 09:27:03 -0400 Puppet (debug): dr-- user
2022-04-19 09:27:03 -0400 Puppet (debug):
2022-04-19 09:27:03 -0400 Puppet (debug): dr-- XPIDemoCluster
2022-04-19 09:27:03 -0400 Puppet (debug):
2022-04-19 09:27:03 -0400 Puppet (debug): dr-- XPIDemoServer
2022-04-19 09:27:03 -0400 Puppet (debug):
2022-04-19 09:27:03 -0400 Puppet (debug): XPIDemoTrxDataSource
2022-04-19 09:27:03 -0400 Puppet (debug): get att DatasourceType
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, None, None])
2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property DatasourceType
2022-04-19 09:27:03 -0400 Puppet (debug): get att Url
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, None, None])
2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property Url
2022-04-19 09:27:03 -0400 Puppet (debug): get att DriverName
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, None, None])
2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property DriverName
2022-04-19 09:27:03 -0400 Puppet (debug): get att UseXaDataSourceInterface
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', True, None])
2022-04-19 09:27:03 -0400 Puppet (debug): Getting boolean property UseXaDataSourceInterface
2022-04-19 09:27:03 -0400 Puppet (debug): get att MaxCapacity
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 15, None])
2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property MaxCapacity
2022-04-19 09:27:03 -0400 Puppet (debug): get att InitialCapacity
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 1, None])
2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property InitialCapacity
2022-04-19 09:27:03 -0400 Puppet (debug): get att MinCapacity
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 1, None])
2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property MinCapacity
2022-04-19 09:27:03 -0400 Puppet (debug): get att StatementCacheType
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, u'LRU', None])
2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property StatementCacheType
2022-04-19 09:27:03 -0400 Puppet (debug): get att StatementCacheSize
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 10, None])
2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property StatementCacheSize
2022-04-19 09:27:03 -0400 Puppet (debug): get att TestConnectionsOnReserve
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', False, None])
2022-04-19 09:27:03 -0400 Puppet (debug): Getting boolean property TestConnectionsOnReserve
2022-04-19 09:27:03 -0400 Puppet (debug): get att InactiveConnectionTimeoutSeconds
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 0, None])
2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property InactiveConnectionTimeoutSeconds
2022-04-19 09:27:03 -0400 Puppet (debug): get att ConnectionReserveTimeoutSeconds
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 10, None])
2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property ConnectionReserveTimeoutSeconds
2022-04-19 09:27:03 -0400 Puppet (debug): get att ShrinkFrequencySeconds
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 900, None])
2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property ShrinkFrequencySeconds
2022-04-19 09:27:03 -0400 Puppet (debug): get att SecondsToTrustAnIdlePoolConnection
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 10, None])
2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property SecondsToTrustAnIdlePoolConnection
2022-04-19 09:27:03 -0400 Puppet (debug): get att TestFrequencySeconds
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 120, None])
2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property TestFrequencySeconds
2022-04-19 09:27:03 -0400 Puppet (debug): get att ConnectionCreationRetryFrequencySeconds
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 0, None])
2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property ConnectionCreationRetryFrequencySeconds
2022-04-19 09:27:03 -0400 Puppet (debug): get att InitSql
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, None, None])
2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property InitSql
2022-04-19 09:27:03 -0400 Puppet (debug): get att StatementTimeout
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', -1, None])
2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property StatementTimeout
2022-04-19 09:27:03 -0400 Puppet (debug): get att LoginDelaySeconds
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 0, None])
2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property LoginDelaySeconds
2022-04-19 09:27:03 -0400 Puppet (debug): get att WrapTypes
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', True, None])
2022-04-19 09:27:03 -0400 Puppet (debug): Getting boolean property WrapTypes
2022-04-19 09:27:03 -0400 Puppet (debug): get att RemoveInfectedConnections
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', True, None])
2022-04-19 09:27:03 -0400 Puppet (debug): Getting boolean property RemoveInfectedConnections
2022-04-19 09:27:03 -0400 Puppet (debug): get att RowPrefetch
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', False, None])
2022-04-19 09:27:03 -0400 Puppet (debug): Getting boolean property RowPrefetch
2022-04-19 09:27:03 -0400 Puppet (debug): get att RowPrefetchSize
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'int', 48, None])
2022-04-19 09:27:03 -0400 Puppet (debug): getting integer property RowPrefetchSize
2022-04-19 09:27:03 -0400 Puppet (debug): get att TestTableName
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, None, None])
2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property TestTableName
2022-04-19 09:27:03 -0400 Puppet (debug): get att GlobalTransactionsProtocol
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, u'OnePhaseCommit', None])
2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property GlobalTransactionsProtocol
2022-04-19 09:27:03 -0400 Puppet (debug): get att FanEnabled
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', False, None])
2022-04-19 09:27:03 -0400 Puppet (debug): Getting boolean property FanEnabled
2022-04-19 09:27:03 -0400 Puppet (debug): get att OnsNodeList
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [None, None, None])
2022-04-19 09:27:03 -0400 Puppet (debug): Getting generic property OnsNodeList
2022-04-19 09:27:03 -0400 Puppet (debug): dr-- user
2022-04-19 09:27:04 -0400 Puppet (debug):
2022-04-19 09:27:04 -0400 Puppet (debug): dr-- XPIDemoCluster
2022-04-19 09:27:04 -0400 Puppet (debug):
2022-04-19 09:27:04 -0400 Puppet (debug): dr-- XPIDemoServer
2022-04-19 09:27:04 -0400 Puppet (debug):
2022-04-19 09:27:04 -0400 Puppet (debug): ~~~~COMMAND SUCCESFULL~~~~
2022-04-19 09:27:04 -0400 Puppet (debug): Storing state
2022-04-19 09:27:04 -0400 Puppet (debug): Stored state in 0.01 seconds
2022-04-19 09:27:04 -0400 Puppet (err): Failed to apply catalog: BUG! removeinfectedconnections should have been '0' or '1'
2022-04-19 09:27:04 -0400 Puppet (debug): Applying settings catalog for sections main, reporting, metrics
2022-04-19 09:27:04 -0400 Puppet (debug): Using settings: adding file resource 'confdir': 'File[/users/acdwrk1/.puppetlabs/etc/puppet]{:path=>"/users

@biemond
Copy link
Owner

biemond commented Apr 19, 2022 via email

@vijayalp
Copy link
Contributor Author

vijayalp commented Apr 20, 2022

Hi,
debug from puppet output for RemoveInfectedConnections
2022-04-19 09:27:03 -0400 Puppet (debug): get att RemoveInfectedConnections
2022-04-19 09:27:03 -0400 Puppet (debug): array(java.lang.Object, [u'boolean', True, None])
2022-04-19 09:27:03 -0400 Puppet (debug): Getting boolean property RemoveInfectedConnections

Results for your questions::

can you add it to create also on retrieving it requires a boolean or 1 .
probably it had a default value .

I have added removeinfectedconnections to the datasource but still same error. and it seems default value is true
https://docs.oracle.com/en/middleware/standalone/weblogic-server/14.1.1.0/wlmbr/core/index.html
RemoveInfectedConnections
Privileges: Read/Write
Type: boolean
Default Value: true

Reference link: https://docs.oracle.com/en/middleware/standalone/weblogic-server/14.1.1.0/jdbcp/phys_conr.html#GUID-EFD6823F-D6AA-450F-B216-84B4DF45A3B2

can you also check the mbeans in wlst to see this property and its type

please find wlst outputs for 'RemoveInfectedConnections','TestConnectionsOnReserve' and property when weblogic 14c and weblogic 12c

wlst:
In WLS 14110c,: return type of the property
wls:/XPIDemoDomain/serverConfig/JDBCSystemResources/TestDemoDataSource/JDBCResource/TestDemoDataSource/JDBCConnectionPoolParams/TestDemoDataSource> get('RemoveInfectedConnections')
True

wls:/XPIDemoDomain/serverConfig/JDBCSystemResources/TestDemoDataSource/JDBCResource/TestDemoDataSource/JDBCConnectionPoolParams/TestDemoDataSource> get('TestConnectionsOnReserve')
False

wls:/XPIDemoDomain/serverConfig/JDBCSystemResources/TestDemoDataSource/JDBCResource/TestDemoDataSource/JDBCConnectionPoolParams/TestDemoDataSource> ls()

-r-- CapacityIncrement 1
-r-- ConnectionCreationRetryFrequencySeconds 0
-r-- ConnectionHarvestMaxCount 1
-r-- ConnectionHarvestTriggerCount -1
-r-- ConnectionLabelingCallback null
-r-- ConnectionReserveTimeoutSeconds 10
-r-- CountOfRefreshFailuresTillDisable 2
-r-- CountOfTestFailuresTillFlush 2
-r-- CredentialMappingEnabled false
-r-- DriverInterceptor null
-r-- FatalErrorCodes null
-r-- HighestNumWaiters 2147483647
-r-- IdentityBasedConnectionPoolingEnabled false
-r-- IgnoreInUseConnectionsEnabled true
-r-- InactiveConnectionTimeoutSeconds 0
-r-- InitSql SQL ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_NUMERIC_CHARACTERS = '.,'
-r-- InitialCapacity 1
-r-- InvokeBeginEndRequest true
-r-- JDBCXADebugLevel 10
-r-- LoginDelaySeconds 0
-r-- MaxCapacity 15
-r-- MinCapacity 1
-r-- PinnedToThread false
-r-- ProfileConnectionLeakTimeoutSeconds 0
-r-- ProfileHarvestFrequencySeconds 300
-r-- ProfileType 0
-r-- RemoveInfectedConnections true
-r-- SecondsToTrustAnIdlePoolConnection 10
-r-- ShrinkFrequencySeconds 900
-r-- StatementCacheSize 10
-r-- StatementCacheType LRU
-r-- StatementTimeout -1
-r-- TestConnectionsOnReserve false
-r-- TestFrequencySeconds 400
-r-- TestTableName SQL SELECT 1 FROM DUAL
-r-- WrapJdbc true
-r-- WrapTypes true

-r-x isSet Boolean : String(propertyName)
-r-x unSet Void : String(propertyName)

In WLS 12214: return type for the property.
wls:/XPIDemoDomain/serverConfig/JDBCSystemResources/TestDemoDataSource/JDBCResource/TestDemoDataSource/JDBCConnectionPoolParams/TestDemoDataSource> get('RemoveInfectedConnections')
1

wls:/XPIDemoDomain/serverConfig/JDBCSystemResources/TestDemoDataSource/JDBCResource/TestDemoDataSource/JDBCConnectionPoolParams/TestDemoDataSource> get('TestConnectionsOnReserve')
0

Also though RemoveInfectedConnections, TestConnectionsOnReserve are of boolean type, the implementation for them in orawls 2.0.12 files under are different.
/opt/puppetlabs/puppet/modules/orawls/lib/puppet/type/wls_datasource/testconnectionsonreserve.rb
/opt/puppetlabs/puppet/modules/orawls/lib/puppet/type/wls_datasource/removeinfectedconnections.rb

@vijayalp
Copy link
Contributor Author

vijayalp commented May 2, 2022

Hi,
Any updates?

@vijayalp
Copy link
Contributor Author

vijayalp commented May 5, 2022

For Weblogic 14c,
in the file /opt/puppetlabs/puppet/modules/orawls/lib/puppet/type/wls_datasource/removeinfectedconnections.rb
the return value for raw_resource['removeinfectedconnections'] is True instead of '1' or '0'
Therefore , always for 2nd time rerun (that is idempotent case), even though the datasource created, always fail is executed.

to_translate_to_resource do |raw_resource|
return :true if raw_resource['removeinfectedconnections'] == '1'
return :false if raw_resource['removeinfectedconnections'] == '0'
fail('BUG! removeinfectedconnections should have been '0' or '1'')
end

Please help us update here.

@vijayalp
Copy link
Contributor Author

Hi Edwin,
Can you help us here in priority? We are stuck here?

REgards,
Vijaya.

@biemond
Copy link
Owner

biemond commented May 11, 2022

will check how we can remove it , then you can do this and try it out plus a make PR

@vijayalp
Copy link
Contributor Author

Hi Edwin,
after removing all the lines you mentioned above in the files, the error is gone.
But i have query, if someone needs this functionality to set removeinfectedconnection, then above removal of lines will not work.
is this ok to remove lines in the files mentioned above would be compatible for WLS 12 and WLS 14?

Regards,
Vijaya.

@vijayalp
Copy link
Contributor Author

vijayalp commented May 17, 2022

Hi Edwin,
instead of removing the lines in files, i have updated removeinfectedconnections.rb file which worked for me.
please tell me where should i request for PR for this file. I am attaching this file here.
wls_datasource_removeinfectedconnections.zip

@vijayalp
Copy link
Contributor Author

Opened, PR ==> #591
Please verify , approve and merge.

@vijayalp
Copy link
Contributor Author

vijayalp commented Oct 11, 2022 via email

@biemond
Copy link
Owner

biemond commented Oct 11, 2022 via email

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants