You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@ofbiz.apache.org by "sameeralwosaby (Jira)" <ji...@apache.org> on 2024/08/05 08:02:00 UTC
[jira] [Created] (OFBIZ-13129) Apache ofbiz 14/15 with PostgreSQL 13 db on docker
sameeralwosaby created OFBIZ-13129:
--------------------------------------
Summary: Apache ofbiz 14/15 with PostgreSQL 13 db on docker
Key: OFBIZ-13129
URL: https://issues.apache.org/jira/browse/OFBIZ-13129
Project: OFBiz
Issue Type: Bug
Components: Docker
Affects Versions: 18.12.15, 18.12.14
Reporter: sameeralwosaby
Hi All,
This below issues coming when try install apache ofbiz 18.12.14/15 with PostgreSQL 13 db on docker ,but when we try with old versions like 8.12.10 or with 22.01. it's working properly.
please any solution
*------------------------------------------------------*
> Task :compileJava UP-TO-DATE
> Task :compileGroovy UP-TO-DATE
> Task :processResources
> Task :classes
> Task :jar
> Task :startScripts
> Task :distTar
> Task :distZip
> Task :assemble
> Task :checkstyleMain
Checkstyle rule violations were found. See the report at: file:///ofbiz/build/reports/checkstyle/main.html
Checkstyle files with violations: 1043
Checkstyle violations by severity: [error:38219]
> Task :compileTestJava UP-TO-DATE
> Task :compileTestGroovy
> Task :processTestResources NO-SOURCE
> Task :testClasses
> Task :checkstyleTest
Checkstyle rule violations were found. See the report at: file:///ofbiz/build/reports/checkstyle/test.html
Checkstyle files with violations: 6
Checkstyle violations by severity: [error:34]
> Task :test
> Task :check
> Task :build
> Task :ofbiz --load-data readers=seed,seed-initial
Config.java using configuration file load-data.properties
Set OFBIZ_HOME to - /ofbiz
Admin socket not configured; set to port 0
Shutdown hook disabled
2024-08-05 07:25:31,619 |main |ContainerLoader |I| [Startup] Loading containers...
2024-08-05 07:25:31,913 |main |ContainerLoader |I| Loading container: component-container
2024-08-05 07:25:31,936 |main |ComponentContainer |I| Auto-Loading component directory : [/ofbiz/framework]
2024-08-05 07:25:31,993 |main |ComponentContainer |I| Added class path for component : [base]
2024-08-05 07:25:32,027 |main |ComponentContainer |I| Added class path for component : [entity]
2024-08-05 07:25:32,059 |main |ComponentContainer |I| Added class path for component : [security]
2024-08-05 07:25:32,092 |main |ComponentContainer |I| Added class path for component : [datafile]
2024-08-05 07:25:32,122 |main |ComponentContainer |I| Added class path for component : [minilang]
2024-08-05 07:25:32,171 |main |ComponentContainer |I| Added class path for component : [common]
2024-08-05 07:25:32,238 |main |ComponentContainer |I| Added class path for component : [service]
2024-08-05 07:25:32,276 |main |ComponentContainer |I| Added class path for component : [catalina]
2024-08-05 07:25:32,334 |main |ComponentContainer |I| Added class path for component : [entityext]
2024-08-05 07:25:32,366 |main |ComponentContainer |I| Added class path for component : [webapp]
2024-08-05 07:25:32,390 |main |ComponentContainer |I| Added class path for component : [widget]
2024-08-05 07:25:32,410 |main |ComponentContainer |I| Added class path for component : [testtools]
2024-08-05 07:25:32,432 |main |ComponentContainer |I| Added class path for component : [webtools]
2024-08-05 07:25:32,432 |main |ComponentContainer |I| Auto-Loading component directory : [/ofbiz/themes]
2024-08-05 07:25:32,536 |main |ComponentContainer |I| Added class path for component : [bluelight]
2024-08-05 07:25:32,536 |main |ComponentContainer |I| Added class path for component : [common-theme]
2024-08-05 07:25:32,536 |main |ComponentContainer |I| Added class path for component : [flatgrey]
2024-08-05 07:25:32,536 |main |ComponentContainer |I| Added class path for component : [rainbowstone]
2024-08-05 07:25:32,536 |main |ComponentContainer |I| Added class path for component : [tomahawk]
2024-08-05 07:25:32,536 |main |ComponentContainer |I| Auto-Loading component directory : [/ofbiz/applications]
2024-08-05 07:25:32,565 |main |ComponentContainer |I| Added class path for component : [datamodel]
2024-08-05 07:25:32,584 |main |ComponentContainer |I| Added class path for component : [party]
2024-08-05 07:25:32,603 |main |ComponentContainer |I| Added class path for component : [securityext]
2024-08-05 07:25:32,622 |main |ComponentContainer |I| Added class path for component : [content]
2024-08-05 07:25:32,642 |main |ComponentContainer |I| Added class path for component : [workeffort]
2024-08-05 07:25:32,668 |main |ComponentContainer |I| Added class path for component : [product]
2024-08-05 07:25:32,687 |main |ComponentContainer |I| Added class path for component : [manufacturing]
2024-08-05 07:25:32,707 |main |ComponentContainer |I| Added class path for component : [accounting]
2024-08-05 07:25:32,731 |main |ComponentContainer |I| Added class path for component : [humanres]
2024-08-05 07:25:32,750 |main |ComponentContainer |I| Added class path for component : [order]
2024-08-05 07:25:32,769 |main |ComponentContainer |I| Added class path for component : [marketing]
2024-08-05 07:25:32,788 |main |ComponentContainer |I| Added class path for component : [commonext]
2024-08-05 07:25:32,788 |main |ComponentContainer |I| Auto-Loading component directory : [/ofbiz/plugins]
2024-08-05 07:25:33,155 |main |ComponentContainer |I| Added class path for component : [AlmusbahEmail]
2024-08-05 07:25:33,155 |main |ComponentContainer |I| Added class path for component : [assetmaint]
2024-08-05 07:25:33,156 |main |ComponentContainer |I| Added class path for component : [bi]
2024-08-05 07:25:33,156 |main |ComponentContainer |I| Not loading component [birt] because it's disabled
2024-08-05 07:25:33,156 |main |ComponentContainer |I| Added class path for component : [cmssite]
2024-08-05 07:25:33,156 |main |ComponentContainer |I| Added class path for component : [ebay]
2024-08-05 07:25:33,156 |main |ComponentContainer |I| Not loading component [ebaystore] because it's disabled
2024-08-05 07:25:33,156 |main |ComponentContainer |I| Added class path for component : [ecommerce]
2024-08-05 07:25:33,157 |main |ComponentContainer |I| Added class path for component : [example]
2024-08-05 07:25:33,157 |main |ComponentContainer |I| Added class path for component : [exampleext]
2024-08-05 07:25:33,157 |main |ComponentContainer |I| Added class path for component : [ldap]
2024-08-05 07:25:33,157 |main |ComponentContainer |I| Added class path for component : [lucene]
2024-08-05 07:25:33,157 |main |ComponentContainer |I| Added class path for component : [multiflex]
2024-08-05 07:25:33,157 |main |ComponentContainer |I| Added class path for component : [myportal]
2024-08-05 07:25:33,158 |main |ComponentContainer |I| Added class path for component : [passport]
2024-08-05 07:25:33,158 |main |ComponentContainer |I| Added class path for component : [pricat]
2024-08-05 07:25:33,158 |main |ComponentContainer |I| Added class path for component : [projectmgr]
2024-08-05 07:25:33,158 |main |ComponentContainer |I| Added class path for component : [scrum]
2024-08-05 07:25:33,159 |main |ComponentContainer |I| Added class path for component : [solr]
2024-08-05 07:25:33,159 |main |ComponentContainer |I| Added class path for component : [webpos]
2024-08-05 07:25:33,162 |main |ComponentContainer |I| All components loaded
2024-08-05 07:25:33,162 |main |ContainerLoader |I| Loaded container: component-container
2024-08-05 07:25:33,162 |main |ContainerLoader |I| [Startup] Loading component containers...
2024-08-05 07:25:33,163 |main |ContainerLoader |I| Loading container: service-container
2024-08-05 07:25:33,170 |main |ContainerLoader |I| Loaded container: service-container
2024-08-05 07:25:33,170 |main |ContainerLoader |I| Loading container: dataload-container
2024-08-05 07:25:33,208 |delegator-startup-1 |DelegatorFactoryImpl |I| Creating new delegator [default] (delegator-startup-1)
2024-08-05 07:25:34,244 |delegator-startup-1 |ModelViewEntity |W| [TestingCryptoRawView]: Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: rawEncryptedValue
2024-08-05 07:25:34,244 |delegator-startup-1 |ModelViewEntity |W| [TestingCryptoRawView]: Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: rawSaltedEncryptedValue
2024-08-05 07:25:34,346 |delegator-startup-1 |ModelViewEntity |W| [OrderItemQuantityReportGroupByItem]: Conversion for complex-alias needs to be i mplemented for cache and in-memory eval stuff to work correctly, will not work for alias: quantityOrdered
2024-08-05 07:25:34,346 |delegator-startup-1 |ModelViewEntity |W| [OrderItemQuantityReportGroupByItem]: Conversion for complex-alias needs to be i mplemented for cache and in-memory eval stuff to work correctly, will not work for alias: quantityOpen
2024-08-05 07:25:34,347 |delegator-startup-1 |ModelViewEntity |W| [OrderItemQuantityReportGroupByProduct]: Conversion for complex-alias needs to b e implemented for cache and in-memory eval stuff to work correctly, will not work for alias: quantityOrdered
2024-08-05 07:25:34,347 |delegator-startup-1 |ModelViewEntity |W| [OrderItemQuantityReportGroupByProduct]: Conversion for complex-alias needs to b e implemented for cache and in-memory eval stuff to work correctly, will not work for alias: quantityOpen
2024-08-05 07:25:34,351 |delegator-startup-1 |ModelViewEntity |W| [OrderReportSalesGroupByProduct]: Conversion for complex-alias needs to be imple mented for cache and in-memory eval stuff to work correctly, will not work for alias: quantityOrdered
2024-08-05 07:25:34,352 |delegator-startup-1 |ModelViewEntity |W| [OrderReportSalesGroupByProduct]: Conversion for complex-alias needs to be imple mented for cache and in-memory eval stuff to work correctly, will not work for alias: amount
2024-08-05 07:25:34,355 |delegator-startup-1 |ModelViewEntity |W| [OrderItemAndShipGrpInvResAndItemSum]: Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: quantityOrdered
2024-08-05 07:25:34,357 |delegator-startup-1 |ModelViewEntity |W| [OrderItemAndShipGrpInvResAndItemSum]: Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: totQuantityAvailable
2024-08-05 07:25:34,360 |delegator-startup-1 |ModelViewEntity |W| [ExampleStatusDetail]: Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: statusDelay
2024-08-05 07:25:34,374 |delegator-startup-1 |ModelViewEntity |W| [ProjectPhaseTaskActualRatedHoursView]: Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: totalRatedHours
2024-08-05 07:25:34,505 |delegator-startup-1 |ModelReader |I| Finished loading entities; #Entities=868 #ViewEntities=321 #Fields=9147 #Relatio nships=2976 #AutoRelationships=2178
2024-08-05 07:25:34,546 |delegator-startup-1 |GenericDelegator |I| Doing entity definition check...
2024-08-05 07:25:34,550 |delegator-startup-1 |ModelEntityChecker |I| [initReservedWords] array length = 1025
2024-08-05 07:25:34,656 |delegator-startup-1 |GenericDelegator |W| =-=-=-=-= Found 3 warnings when checking the entity definitions:
2024-08-05 07:25:34,657 |delegator-startup-1 |GenericDelegator |W| [RelationFieldTypesDifferent] The field type (id) of email_status_code of entity email_status is not the same as field type (name) of email_status_code of entity msbhr_almusbah_email for relation msbhr_almusbah_email.
2024-08-05 07:25:34,657 |delegator-startup-1 |GenericDelegator |W| [FieldNameRW] Column name STATUS of entity msbhr_almusbah_email is a reserved wo rd.
2024-08-05 07:25:34,657 |delegator-startup-1 |GenericDelegator |W| [RelationFieldTypesDifferent] The field type (name) of email_status_code of enti ty msbhr_almusbah_email is not the same as field type (id) of email_status_code of entity email_status for relation email_status.
2024-08-05 07:25:34,660 |OFBiz-batch-1 |GenericDelegator |I| Delegator "default" initializing helper "localderbyolap" for entity group "org.a pache.ofbiz.olap".
2024-08-05 07:25:34,664 |OFBiz-batch-1 |GenericDelegator |I| Doing database check as requested in entityengine.xml with addMissing=true
2024-08-05 07:25:34,668 |OFBiz-batch-2 |GenericDelegator |I| Delegator "default" initializing helper "localpostgres" for entity group "org.ap ache.ofbiz".
2024-08-05 07:25:34,668 |OFBiz-batch-3 |GenericDelegator |I| Delegator "default" initializing helper "localderbytenant" for entity group "org .apache.ofbiz.tenant".
2024-08-05 07:25:34,686 |OFBiz-batch-3 |GenericDelegator |I| Doing database check as requested in entityengine.xml with addMissing=true
2024-08-05 07:25:34,693 |OFBiz-batch-2 |GenericDelegator |I| Doing database check as requested in entityengine.xml with addMissing=true
2024-08-05 07:25:35,151 |OFBiz-batch-2 |DatabaseUtil |E| Unable to establish a connection with the database for helperName [localpostgres ]... Error was: java.sql.SQLException: Unable to acquire a new connection from the pool
2024-08-05 07:25:35,151 |OFBiz-batch-2 |DatabaseUtil |E| Unable to establish a connection with the database, no additional information av ailable.
2024-08-05 07:25:35,151 |OFBiz-batch-2 |DatabaseUtil |E| Could not get table name information from the database, aborting.
2024-08-05 07:25:36,213 |OFBiz-batch-3 |DatabaseUtil |I| Database Product Name is Apache Derby
2024-08-05 07:25:36,213 |OFBiz-batch-1 |DatabaseUtil |I| Database Product Name is Apache Derby
2024-08-05 07:25:36,213 |OFBiz-batch-3 |DatabaseUtil |I| Database Product Version is 10.14.2.0 - (1828579)
2024-08-05 07:25:36,213 |OFBiz-batch-1 |DatabaseUtil |I| Database Product Version is 10.14.2.0 - (1828579)
2024-08-05 07:25:36,213 |OFBiz-batch-3 |DatabaseUtil |I| Database Driver Name is Apache Derby Embedded JDBC Driver
2024-08-05 07:25:36,213 |OFBiz-batch-1 |DatabaseUtil |I| Database Driver Name is Apache Derby Embedded JDBC Driver
2024-08-05 07:25:36,214 |OFBiz-batch-3 |DatabaseUtil |I| Database Driver Version is 10.14.2.0 - (1828579)
2024-08-05 07:25:36,214 |OFBiz-batch-3 |DatabaseUtil |I| Database Driver JDBC Version is 4.2
2024-08-05 07:25:36,214 |OFBiz-batch-3 |DatabaseUtil |I| Database Setting/Support Information (those with a * should be true):
2024-08-05 07:25:36,214 |OFBiz-batch-3 |DatabaseUtil |I| - supports transactions [true]*
2024-08-05 07:25:36,214 |OFBiz-batch-3 |DatabaseUtil |I| - isolation None [false]
2024-08-05 07:25:36,214 |OFBiz-batch-3 |DatabaseUtil |I| - isolation ReadCommitted [true]
2024-08-05 07:25:36,214 |OFBiz-batch-3 |DatabaseUtil |I| - isolation ReadUncommitted [true]
2024-08-05 07:25:36,214 |OFBiz-batch-3 |DatabaseUtil |I| - isolation RepeatableRead [true]
2024-08-05 07:25:36,214 |OFBiz-batch-3 |DatabaseUtil |I| - isolation Serializable [true]
2024-08-05 07:25:36,215 |OFBiz-batch-3 |DatabaseUtil |I| - forward only type [true]
2024-08-05 07:25:36,215 |OFBiz-batch-3 |DatabaseUtil |I| - scroll sensitive type [false]
2024-08-05 07:25:36,215 |OFBiz-batch-3 |DatabaseUtil |I| - scroll insensitive type [true]
2024-08-05 07:25:36,215 |OFBiz-batch-3 |DatabaseUtil |I| - is case sensitive [false]
2024-08-05 07:25:36,215 |OFBiz-batch-3 |DatabaseUtil |I| - stores LowerCase [false]
2024-08-05 07:25:36,215 |OFBiz-batch-3 |DatabaseUtil |I| - stores MixedCase [false]
2024-08-05 07:25:36,215 |OFBiz-batch-3 |DatabaseUtil |I| - stores UpperCase [true]
2024-08-05 07:25:36,215 |OFBiz-batch-3 |DatabaseUtil |I| - max table name length [128]
2024-08-05 07:25:36,215 |OFBiz-batch-3 |DatabaseUtil |I| - max column name length [128]
2024-08-05 07:25:36,216 |OFBiz-batch-3 |DatabaseUtil |I| - concurrent connections [0]
2024-08-05 07:25:36,216 |OFBiz-batch-3 |DatabaseUtil |I| - concurrent statements [0]
2024-08-05 07:25:36,216 |OFBiz-batch-3 |DatabaseUtil |I| - ANSI SQL92 Entry [true]
2024-08-05 07:25:36,216 |OFBiz-batch-3 |DatabaseUtil |I| - ANSI SQL92 Intermediate [false]
2024-08-05 07:25:36,216 |OFBiz-batch-3 |DatabaseUtil |I| - ANSI SQL92 Full [false]
2024-08-05 07:25:36,217 |OFBiz-batch-3 |DatabaseUtil |I| - ODBC SQL Grammar Core [false]
2024-08-05 07:25:36,217 |OFBiz-batch-3 |DatabaseUtil |I| - ODBC SQL Grammar Extended [false]
2024-08-05 07:25:36,217 |OFBiz-batch-3 |DatabaseUtil |I| - ODBC SQL Grammar Minimum [true]
2024-08-05 07:25:36,217 |OFBiz-batch-3 |DatabaseUtil |I| - outer joins [true]*
2024-08-05 07:25:36,217 |OFBiz-batch-3 |DatabaseUtil |I| - limited outer joins [true]
2024-08-05 07:25:36,217 |OFBiz-batch-3 |DatabaseUtil |I| - full outer joins [false]
2024-08-05 07:25:36,217 |OFBiz-batch-3 |DatabaseUtil |I| - group by [true]*
2024-08-05 07:25:36,218 |OFBiz-batch-3 |DatabaseUtil |I| - group by not in select [true]
2024-08-05 07:25:36,214 |OFBiz-batch-1 |DatabaseUtil |I| Database Driver Version is 10.14.2.0 - (1828579)
2024-08-05 07:25:36,222 |OFBiz-batch-1 |DatabaseUtil |I| Database Driver JDBC Version is 4.2
2024-08-05 07:25:36,222 |OFBiz-batch-1 |DatabaseUtil |I| Database Setting/Support Information (those with a * should be true):
2024-08-05 07:25:36,222 |OFBiz-batch-1 |DatabaseUtil |I| - supports transactions [true]*
2024-08-05 07:25:36,222 |OFBiz-batch-1 |DatabaseUtil |I| - isolation None [false]
2024-08-05 07:25:36,222 |OFBiz-batch-1 |DatabaseUtil |I| - isolation ReadCommitted [true]
2024-08-05 07:25:36,222 |OFBiz-batch-1 |DatabaseUtil |I| - isolation ReadUncommitted [true]
2024-08-05 07:25:36,224 |OFBiz-batch-3 |DatabaseUtil |I| - column aliasing [true]
2024-08-05 07:25:36,224 |OFBiz-batch-3 |DatabaseUtil |I| - order by not in select [false]
2024-08-05 07:25:36,224 |OFBiz-batch-3 |DatabaseUtil |I| - alter table add column [true]*
2024-08-05 07:25:36,225 |OFBiz-batch-3 |DatabaseUtil |I| - non-nullable column [true]*
2024-08-05 07:25:36,226 |OFBiz-batch-1 |DatabaseUtil |I| - isolation RepeatableRead [true]
2024-08-05 07:25:36,226 |OFBiz-batch-1 |DatabaseUtil |I| - isolation Serializable [true]
2024-08-05 07:25:36,227 |OFBiz-batch-1 |DatabaseUtil |I| - forward only type [true]
2024-08-05 07:25:36,227 |OFBiz-batch-1 |DatabaseUtil |I| - scroll sensitive type [false]
2024-08-05 07:25:36,227 |OFBiz-batch-3 |DatabaseUtil |I| - default fetchsize [1]
2024-08-05 07:25:36,228 |OFBiz-batch-3 |DatabaseUtil |I| - named parameters [ SKIPPED ]
2024-08-05 07:25:36,228 |OFBiz-batch-3 |DatabaseUtil |I| Getting Table Info From Database
2024-08-05 07:25:36,229 |OFBiz-batch-1 |DatabaseUtil |I| - scroll insensitive type [true]
2024-08-05 07:25:36,229 |OFBiz-batch-1 |DatabaseUtil |I| - is case sensitive [false]
2024-08-05 07:25:36,230 |OFBiz-batch-1 |DatabaseUtil |I| - stores LowerCase [false]
2024-08-05 07:25:36,230 |OFBiz-batch-1 |DatabaseUtil |I| - stores MixedCase [false]
2024-08-05 07:25:36,230 |OFBiz-batch-1 |DatabaseUtil |I| - stores UpperCase [true]
2024-08-05 07:25:36,231 |OFBiz-batch-1 |DatabaseUtil |I| - max table name length [128]
2024-08-05 07:25:36,240 |OFBiz-batch-1 |DatabaseUtil |I| - max column name length [128]
2024-08-05 07:25:36,241 |OFBiz-batch-1 |DatabaseUtil |I| - concurrent connections [0]
2024-08-05 07:25:36,241 |OFBiz-batch-1 |DatabaseUtil |I| - concurrent statements [0]
2024-08-05 07:25:36,241 |OFBiz-batch-1 |DatabaseUtil |I| - ANSI SQL92 Entry [true]
2024-08-05 07:25:36,242 |OFBiz-batch-1 |DatabaseUtil |I| - ANSI SQL92 Intermediate [false]
2024-08-05 07:25:36,244 |OFBiz-batch-1 |DatabaseUtil |I| - ANSI SQL92 Full [false]
2024-08-05 07:25:36,246 |OFBiz-batch-1 |DatabaseUtil |I| - ODBC SQL Grammar Core [false]
2024-08-05 07:25:36,264 |OFBiz-batch-1 |DatabaseUtil |I| - ODBC SQL Grammar Extended [false]
2024-08-05 07:25:36,264 |OFBiz-batch-1 |DatabaseUtil |I| - ODBC SQL Grammar Minimum [true]
2024-08-05 07:25:36,265 |OFBiz-batch-1 |DatabaseUtil |I| - outer joins [true]*
2024-08-05 07:25:36,266 |OFBiz-batch-1 |DatabaseUtil |I| - limited outer joins [true]
2024-08-05 07:25:36,266 |OFBiz-batch-1 |DatabaseUtil |I| - full outer joins [false]
2024-08-05 07:25:36,267 |OFBiz-batch-1 |DatabaseUtil |I| - group by [true]*
2024-08-05 07:25:36,267 |OFBiz-batch-1 |DatabaseUtil |I| - group by not in select [true]
2024-08-05 07:25:36,269 |OFBiz-batch-1 |DatabaseUtil |I| - column aliasing [true]
2024-08-05 07:25:36,270 |OFBiz-batch-1 |DatabaseUtil |I| - order by not in select [false]
2024-08-05 07:25:36,270 |OFBiz-batch-1 |DatabaseUtil |I| - alter table add column [true]*
2024-08-05 07:25:36,271 |OFBiz-batch-1 |DatabaseUtil |I| - non-nullable column [true]*
2024-08-05 07:25:36,272 |OFBiz-batch-1 |DatabaseUtil |I| - default fetchsize [1]
2024-08-05 07:25:36,272 |OFBiz-batch-1 |DatabaseUtil |I| - named parameters [ SKIPPED ]
2024-08-05 07:25:36,273 |OFBiz-batch-1 |DatabaseUtil |I| Getting Table Info From Database
2024-08-05 07:25:36,664 |OFBiz-batch-3 |DatabaseUtil |W| Entity [Component] has no table in the database
2024-08-05 07:25:36,664 |OFBiz-batch-1 |DatabaseUtil |W| Entity [CurrencyDimension] has no table in the database
2024-08-05 07:25:36,665 |OFBiz-batch-1 |DatabaseUtil |W| Entity [DateDimension] has no table in the database
2024-08-05 07:25:36,665 |OFBiz-batch-1 |DatabaseUtil |W| Entity [InventoryItemFact] has no table in the database
2024-08-05 07:25:36,665 |OFBiz-batch-1 |DatabaseUtil |W| Entity [ProductDimension] has no table in the database
2024-08-05 07:25:36,665 |OFBiz-batch-1 |DatabaseUtil |W| Entity [SalesInvoiceItemFact] has no table in the database
2024-08-05 07:25:36,665 |OFBiz-batch-1 |DatabaseUtil |W| Entity [SalesOrderItemFact] has no table in the database
2024-08-05 07:25:36,667 |OFBiz-batch-3 |DatabaseUtil |W| Entity [Tenant] has no table in the database
2024-08-05 07:25:36,667 |OFBiz-batch-3 |DatabaseUtil |W| Entity [TenantComponent] has no table in the database
2024-08-05 07:25:36,668 |OFBiz-batch-3 |DatabaseUtil |W| Entity [TenantDataSource] has no table in the database
2024-08-05 07:25:36,668 |OFBiz-batch-3 |DatabaseUtil |W| Entity [TenantDomainName] has no table in the database
2024-08-05 07:25:36,669 |OFBiz-batch-3 |DatabaseUtil |W| Entity [TenantKeyEncryptingKey] has no table in the database
2024-08-05 07:25:36,722 |pool-3-thread-1 |DatabaseUtil |I| Created table [OFBIZ.COMPONENT]
2024-08-05 07:25:36,726 |pool-2-thread-1 |DatabaseUtil |I| Created table [OFBIZ.CURRENCY_DIMENSION]
2024-08-05 07:25:36,748 |pool-3-thread-1 |DatabaseUtil |I| Created table [OFBIZ.TENANT]
2024-08-05 07:25:36,766 |pool-2-thread-1 |DatabaseUtil |I| Created table [OFBIZ.DATE_DIMENSION]
2024-08-05 07:25:36,775 |pool-3-thread-1 |DatabaseUtil |I| Created table [OFBIZ.TENANT_COMPONENT]
2024-08-05 07:25:36,795 |pool-2-thread-1 |DatabaseUtil |I| Created table [OFBIZ.INVENTORY_ITEM_FACT]
2024-08-05 07:25:36,800 |pool-3-thread-1 |DatabaseUtil |I| Created table [OFBIZ.TENANT_DATA_SOURCE]
2024-08-05 07:25:36,817 |pool-2-thread-1 |DatabaseUtil |I| Created table [OFBIZ.PRODUCT_DIMENSION]
2024-08-05 07:25:36,819 |pool-3-thread-1 |DatabaseUtil |I| Created table [OFBIZ.TENANT_DOMAIN_NAME]
2024-08-05 07:25:36,838 |pool-3-thread-1 |DatabaseUtil |I| Created table [OFBIZ.TENANT_KEY_ENCRYPTING_KEY]
2024-08-05 07:25:36,846 |pool-2-thread-1 |DatabaseUtil |I| Created table [OFBIZ.SALES_INVOICE_ITEM_FACT]
2024-08-05 07:25:36,879 |pool-3-thread-1 |DatabaseUtil |I| Created 2 foreign key indices for entity [TenantComponent]
2024-08-05 07:25:36,891 |pool-2-thread-1 |DatabaseUtil |I| Created table [OFBIZ.SALES_ORDER_ITEM_FACT]
2024-08-05 07:25:36,898 |pool-3-thread-1 |DatabaseUtil |I| Created 1 foreign key indices for entity [TenantDataSource]
2024-08-05 07:25:36,912 |pool-3-thread-1 |DatabaseUtil |I| Created 1 foreign key indices for entity [TenantDomainName]
2024-08-05 07:25:36,925 |pool-3-thread-1 |DatabaseUtil |I| Created 1 foreign key indices for entity [TenantKeyEncryptingKey]
2024-08-05 07:25:36,925 |OFBiz-batch-3 |DatabaseUtil |I| ==== TOTAL Foreign Key Indices Created: 5
2024-08-05 07:25:36,955 |pool-2-thread-1 |DatabaseUtil |I| Created 3 foreign key indices for entity [InventoryItemFact]
2024-08-05 07:25:36,961 |OFBiz-batch-3 |DatabaseUtil |I| Created 2 foreign keys for entity [TenantComponent]
2024-08-05 07:25:36,968 |OFBiz-batch-3 |DatabaseUtil |I| Created 1 foreign keys for entity [TenantDataSource]
2024-08-05 07:25:36,984 |OFBiz-batch-3 |DatabaseUtil |I| Created 1 foreign keys for entity [TenantDomainName]
2024-08-05 07:25:36,992 |OFBiz-batch-3 |DatabaseUtil |I| Created 1 foreign keys for entity [TenantKeyEncryptingKey]
2024-08-05 07:25:36,993 |OFBiz-batch-3 |DatabaseUtil |I| ==== TOTAL Foreign Keys Created: 5
2024-08-05 07:25:37,013 |pool-2-thread-1 |DatabaseUtil |I| Created 3 foreign key indices for entity [SalesInvoiceItemFact]
2024-08-05 07:25:37,021 |pool-3-thread-1 |DatabaseUtil |I| Created 2 declared indices for entity [Component]
2024-08-05 07:25:37,049 |pool-3-thread-1 |DatabaseUtil |I| Created 2 declared indices for entity [Tenant]
2024-08-05 07:25:37,064 |pool-2-thread-1 |DatabaseUtil |I| Created 3 foreign key indices for entity [SalesOrderItemFact]
2024-08-05 07:25:37,065 |OFBiz-batch-1 |DatabaseUtil |I| ==== TOTAL Foreign Key Indices Created: 9
2024-08-05 07:25:37,077 |pool-3-thread-1 |DatabaseUtil |I| Created 2 declared indices for entity [TenantComponent]
2024-08-05 07:25:37,093 |OFBiz-batch-1 |DatabaseUtil |I| Created 3 foreign keys for entity [InventoryItemFact]
2024-08-05 07:25:37,117 |pool-3-thread-1 |DatabaseUtil |I| Created 2 declared indices for entity [TenantDataSource]
2024-08-05 07:25:37,140 |OFBiz-batch-1 |DatabaseUtil |I| Created 3 foreign keys for entity [SalesInvoiceItemFact]
2024-08-05 07:25:37,142 |pool-3-thread-1 |DatabaseUtil |I| Created 2 declared indices for entity [TenantDomainName]
2024-08-05 07:25:37,166 |pool-3-thread-1 |DatabaseUtil |I| Created 2 declared indices for entity [TenantKeyEncryptingKey]
2024-08-05 07:25:37,167 |OFBiz-batch-3 |DatabaseUtil |I| ==== TOTAL Declared Indices Created: 12
2024-08-05 07:25:37,167 |OFBiz-batch-1 |DatabaseUtil |I| Created 3 foreign keys for entity [SalesOrderItemFact]
2024-08-05 07:25:37,167 |OFBiz-batch-1 |DatabaseUtil |I| ==== TOTAL Foreign Keys Created: 9
2024-08-05 07:25:37,192 |pool-2-thread-1 |DatabaseUtil |I| Created 2 declared indices for entity [CurrencyDimension]
2024-08-05 07:25:37,217 |pool-2-thread-1 |DatabaseUtil |I| Created 2 declared indices for entity [DateDimension]
2024-08-05 07:25:37,242 |pool-2-thread-1 |DatabaseUtil |I| Created 2 declared indices for entity [InventoryItemFact]
2024-08-05 07:25:37,275 |pool-2-thread-1 |DatabaseUtil |I| Created 2 declared indices for entity [ProductDimension]
2024-08-05 07:25:37,305 |pool-2-thread-1 |DatabaseUtil |I| Created 2 declared indices for entity [SalesInvoiceItemFact]
2024-08-05 07:25:37,336 |pool-2-thread-1 |DatabaseUtil |I| Created 2 declared indices for entity [SalesOrderItemFact]
2024-08-05 07:25:37,336 |OFBiz-batch-1 |DatabaseUtil |I| ==== TOTAL Declared Indices Created: 12
2024-08-05 07:25:37,396 |kJoinPool-1-worker-1 |EntityEcaUtil |I| Loaded [11] Entity ECA definitions from /ofbiz/applications/content/entitydef/ee cas.xml in loader main
2024-08-05 07:25:37,400 |OFBiz-batch-3 |ServiceGroupReader |I| Loaded [1] Group definitions from file:/ofbiz/framework/common/servicedef/groups _test.xml
2024-08-05 07:25:37,409 |kJoinPool-1-worker-1 |EntityEcaUtil |I| Loaded [4] Entity ECA definitions from /ofbiz/applications/workeffort/entitydef/ eecas.xml in loader main
2024-08-05 07:25:37,410 |OFBiz-batch-3 |ServiceGroupReader |I| Loaded [4] Group definitions from file:/ofbiz/framework/entityext/servicedef/gro ups.xml
2024-08-05 07:25:37,415 |OFBiz-batch-3 |ServiceGroupReader |I| Loaded [2] Group definitions from file:/ofbiz/applications/workeffort/servicedef /service_groups.xml
2024-08-05 07:25:37,418 |OFBiz-batch-3 |ServiceGroupReader |I| Loaded [1] Group definitions from file:/ofbiz/applications/product/servicedef/gr oups.xml
2024-08-05 07:25:37,419 |kJoinPool-1-worker-1 |EntityEcaUtil |I| Loaded [14] Entity ECA definitions from /ofbiz/applications/product/entitydef/ee cas.xml in loader main
2024-08-05 07:25:37,422 |OFBiz-batch-3 |ServiceGroupReader |I| Loaded [4] Group definitions from file:/ofbiz/applications/accounting/servicedef /groups.xml
2024-08-05 07:25:37,425 |kJoinPool-1-worker-1 |EntityEcaUtil |I| Loaded [2] Entity ECA definitions from /ofbiz/applications/accounting/entitydef/ eecas.xml in loader main
2024-08-05 07:25:37,430 |kJoinPool-1-worker-1 |EntityEcaUtil |I| Loaded [3] Entity ECA definitions from /ofbiz/applications/order/entitydef/eecas .xml in loader main
2024-08-05 07:25:37,440 |kJoinPool-1-worker-1 |ServiceEcaUtil |I| Loaded [3] Service ECA Rules from file:/ofbiz/framework/common/servicedef/secas_ test.xml
2024-08-05 07:25:37,445 |kJoinPool-1-worker-1 |ServiceEcaUtil |I| Loaded [0] Service ECA Rules from file:/ofbiz/framework/common/servicedef/secas_ cdyne.xml
2024-08-05 07:25:37,453 |kJoinPool-1-worker-1 |ServiceEcaUtil |I| Loaded [3] Service ECA Rules from file:/ofbiz/framework/service/servicedef/secas _test_se.xml
2024-08-05 07:25:37,461 |kJoinPool-1-worker-1 |ServiceEcaUtil |I| Loaded [25] Service ECA Rules from file:/ofbiz/applications/party/servicedef/sec as.xml
2024-08-05 07:25:37,466 |kJoinPool-1-worker-1 |EntityEcaUtil |I| Loaded [15] Entity ECA definitions from /ofbiz/plugins/lucene/entitydef/eecas_pr oduct.xml in loader main
2024-08-05 07:25:37,472 |kJoinPool-1-worker-1 |ServiceEcaUtil |I| Loaded [25] Service ECA Rules from file:/ofbiz/applications/content/servicedef/s ecas.xml
2024-08-05 07:25:37,478 |kJoinPool-1-worker-1 |EntityEcaUtil |I| Loaded [1] Entity ECA definitions from /ofbiz/plugins/projectmgr/entitydef/eecas .xml in loader main
2024-08-05 07:25:37,484 |kJoinPool-1-worker-1 |ServiceEcaUtil |I| Loaded [10] Service ECA Rules from file:/ofbiz/applications/workeffort/servicede f/secas.xml
2024-08-05 07:25:37,492 |kJoinPool-1-worker-1 |ServiceEcaUtil |I| Loaded [26] Service ECA Rules from file:/ofbiz/applications/product/servicedef/s ecas.xml
2024-08-05 07:25:37,498 |kJoinPool-1-worker-1 |ServiceEcaUtil |I| Loaded [23] Service ECA Rules from file:/ofbiz/applications/product/servicedef/s ecas_shipment.xml
2024-08-05 07:25:37,510 |kJoinPool-1-worker-1 |ServiceEcaUtil |I| Loaded [4] Service ECA Rules from file:/ofbiz/applications/manufacturing/service def/secas.xml
2024-08-05 07:25:37,527 |kJoinPool-1-worker-1 |ServiceEcaUtil |I| Loaded [23] Service ECA Rules from file:/ofbiz/applications/accounting/servicede f/secas.xml
2024-08-05 07:25:37,532 |kJoinPool-1-worker-1 |EntityEcaUtil |I| Loaded [0] Entity ECA definitions from /ofbiz/plugins/solr/entitydef/eecas.xml i n loader main
2024-08-05 07:25:37,546 |kJoinPool-1-worker-1 |ServiceEcaUtil |I| Loaded [8] Service ECA Rules from file:/ofbiz/applications/accounting/servicedef /secas_payment.xml
2024-08-05 07:25:37,556 |kJoinPool-1-worker-1 |ServiceEcaUtil |I| Loaded [22] Service ECA Rules from file:/ofbiz/applications/accounting/servicede f/secas_ledger.xml
2024-08-05 07:25:37,564 |kJoinPool-1-worker-1 |ServiceEcaUtil |I| Loaded [6] Service ECA Rules from file:/ofbiz/applications/accounting/servicedef /secas_invoice.xml
2024-08-05 07:25:37,575 |kJoinPool-1-worker-1 |ServiceEcaUtil |I| Loaded [80] Service ECA Rules from file:/ofbiz/applications/order/servicedef/sec as.xml
2024-08-05 07:25:37,602 |kJoinPool-1-worker-1 |ServiceEcaUtil |I| Loaded [10] Service ECA Rules from file:/ofbiz/applications/marketing/servicedef /secas.xml
2024-08-05 07:25:37,634 |kJoinPool-1-worker-1 |ServiceEcaUtil |I| Loaded [0] Service ECA Rules from file:/ofbiz/applications/commonext/servicedef/ secas.xml
2024-08-05 07:25:37,651 |kJoinPool-1-worker-1 |ServiceEcaUtil |I| Loaded [5] Service ECA Rules from file:/ofbiz/plugins/assetmaint/servicedef/seca s.xml
2024-08-05 07:25:37,657 |kJoinPool-1-worker-1 |ServiceEcaUtil |I| Loaded [5] Service ECA Rules from file:/ofbiz/plugins/bi/servicedef/secas.xml
2024-08-05 07:25:37,665 |kJoinPool-1-worker-1 |ServiceEcaUtil |I| Loaded [1] Service ECA Rules from file:/ofbiz/plugins/ebay/servicedef/secas.xml
2024-08-05 07:25:37,671 |kJoinPool-1-worker-1 |ServiceEcaUtil |I| Loaded [3] Service ECA Rules from file:/ofbiz/plugins/example/servicedef/secas.x ml
2024-08-05 07:25:37,685 |kJoinPool-1-worker-1 |ServiceEcaUtil |I| Loaded [9] Service ECA Rules from file:/ofbiz/plugins/scrum/servicedef/secas.xml
2024-08-05 07:25:37,713 |kJoinPool-1-worker-1 |ServiceEcaUtil |I| Loaded [0] Service ECA Rules from file:/ofbiz/plugins/solr/servicedef/secas.xml
2024-08-05 07:25:37,730 |OFBiz-batch-3 |GenericDelegator |E| Failure in removeByCondition operation for entity [ServiceSemaphore]: org.apache .ofbiz.entity.GenericDataSourceException: Generic Entity Exception occurred in deleteByCondition (Unable to establish a connection with the database. (Unable to acquire a new connection from the pool)). Rolling back transaction.
org.apache.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occurred in deleteByCondition (Unable to establish a connection with the database. ( Unable to acquire a new connection from the pool))
at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1125) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.datasource.GenericHelperDAO.removeByCondition(GenericHelperDAO.java:169) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.GenericDelegator.removeByCondition(GenericDelegator.java:1118) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.GenericDelegator.removeByAnd(GenericDelegator.java:1083) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.GenericDelegator.removeByAnd(GenericDelegator.java:1074) ~[ofbiz.jar:?]
at org.apache.ofbiz.service.ServiceDispatcher.<init>(ServiceDispatcher.java:105) ~[ofbiz.jar:?]
at org.apache.ofbiz.service.ServiceDispatcher.<init>(ServiceDispatcher.java:136) ~[ofbiz.jar:?]
at org.apache.ofbiz.service.ServiceDispatcher.getInstance(ServiceDispatcher.java:167) ~[ofbiz.jar:?]
at org.apache.ofbiz.service.ServiceDispatcher.getLocalDispatcher(ServiceDispatcher.java:147) ~[ofbiz.jar:?]
at org.apache.ofbiz.service.GenericDispatcherFactory.createLocalDispatcher(GenericDispatcherFactory.java:40) ~[ofbiz.jar:?]
at org.apache.ofbiz.service.ServiceContainer.getLocalDispatcher(ServiceContainer.java:92) ~[ofbiz.jar:?]
at org.apache.ofbiz.entityext.EntityServiceFactory.getLocalDispatcher(EntityServiceFactory.java:34) ~[ofbiz.jar:?]
at org.apache.ofbiz.entityext.EntityServiceFactory.getDispatchContext(EntityServiceFactory.java:39) ~[ofbiz.jar:?]
at org.apache.ofbiz.entityext.eca.DelegatorEcaHandler.lambda$setDelegator$0(DelegatorEcaHandler.java:61) ~[ofbiz.jar:?]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_422]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0_422]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_422]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_422]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_422]
at java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_422]
Caused by: org.apache.ofbiz.entity.GenericDataSourceException: Unable to establish a connection with the database. (Unable to acquire a new connection from the p ool)
at org.apache.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:264) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:367) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:338) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1144) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1122) ~[ofbiz.jar:?]
... 19 more
Caused by: java.sql.SQLException: Unable to acquire a new connection from the pool
at org.apache.commons.dbcp2.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:145) ~[commons-dbcp2-2.5.0.jar:2.5.0]
at org.apache.commons.dbcp2.managed.ManagedConnection.<init>(ManagedConnection.java:75) ~[commons-dbcp2-2.5.0.jar:2.5.0]
at org.apache.commons.dbcp2.managed.ManagedDataSource.getConnection(ManagedDataSource.java:80) ~[commons-dbcp2-2.5.0.jar:2.5.0]
at org.apache.ofbiz.entity.connection.DebugManagedDataSource.getConnection(DebugManagedDataSource.java:51) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:66) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.transaction.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:79) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:261) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:367) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:338) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1144) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1122) ~[ofbiz.jar:?]
... 19 more
Caused by: java.util.NoSuchElementException: Unable to activate object
at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:474) ~[commons-pool2-2.6.0.jar:2.6.0]
at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:365) ~[commons-pool2-2.6.0.jar:2.6.0]
at org.apache.commons.dbcp2.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:142) ~[commons-dbcp2-2.5.0.jar:2.5.0]
at org.apache.commons.dbcp2.managed.ManagedConnection.<init>(ManagedConnection.java:75) ~[commons-dbcp2-2.5.0.jar:2.5.0]
at org.apache.commons.dbcp2.managed.ManagedDataSource.getConnection(ManagedDataSource.java:80) ~[commons-dbcp2-2.5.0.jar:2.5.0]
at org.apache.ofbiz.entity.connection.DebugManagedDataSource.getConnection(DebugManagedDataSource.java:51) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:66) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.transaction.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:79) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:261) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:367) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:338) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1144) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1122) ~[ofbiz.jar:?]
... 19 more
Caused by: org.postgresql.util.PSQLException: This ResultSet is closed.
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.checkClosed(AbstractJdbc2ResultSet.java:2654) ~[postgresql-9.1-901.jdbc4.jar:?]
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.setFetchSize(AbstractJdbc2ResultSet.java:1771) ~[postgresql-9.1-901.jdbc4.jar:?]
at org.postgresql.jdbc4.Jdbc4Statement.createResultSet(Jdbc4Statement.java:39) ~[postgresql-9.1-901.jdbc4.jar:?]
at org.postgresql.jdbc2.AbstractJdbc2Statement$StatementResultHandler.handleResultRows(AbstractJdbc2Statement.java:211) ~[postgresql-9.1-901.jdbc4.jar:?]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1773) ~[postgresql-9.1-901.jdbc4.jar:?]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) ~[postgresql-9.1-901.jdbc4.jar:?]
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512) ~[postgresql-9.1-901.jdbc4.jar:?]
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374) ~[postgresql-9.1-901.jdbc4.jar:?]
at org.postgresql.jdbc2.AbstractJdbc2Connection.execSQLUpdate(AbstractJdbc2Connection.java:263) ~[postgresql-9.1-901.jdbc4.jar:?]
at org.postgresql.jdbc2.AbstractJdbc2Connection.getTransactionIsolation(AbstractJdbc2Connection.java:775) ~[postgresql-9.1-901.jdbc4.jar:?]
at org.apache.commons.dbcp2.DelegatingConnection.getTransactionIsolation(DelegatingConnection.java:414) ~[commons-dbcp2-2.5.0.jar:2.5.0]
at org.apache.commons.dbcp2.PoolableConnectionFactory.activateObject(PoolableConnectionFactory.java:434) ~[commons-dbcp2-2.5.0.jar:2.5.0]
at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:465) ~[commons-pool2-2.6.0.jar:2.6.0]
at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:365) ~[commons-pool2-2.6.0.jar:2.6.0]
at org.apache.commons.dbcp2.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:142) ~[commons-dbcp2-2.5.0.jar:2.5.0]
at org.apache.commons.dbcp2.managed.ManagedConnection.<init>(ManagedConnection.java:75) ~[commons-dbcp2-2.5.0.jar:2.5.0]
at org.apache.commons.dbcp2.managed.ManagedDataSource.getConnection(ManagedDataSource.java:80) ~[commons-dbcp2-2.5.0.jar:2.5.0]
at org.apache.ofbiz.entity.connection.DebugManagedDataSource.getConnection(DebugManagedDataSource.java:51) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:66) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.transaction.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:79) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:261) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:367) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:338) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1144) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1122) ~[ofbiz.jar:?]
... 19 more
2024-08-05 07:25:37,736 |OFBiz-batch-3 |TransactionUtil |I| Transaction rolled back
2024-08-05 07:25:37,736 |OFBiz-batch-3 |ServiceDispatcher |E| null
org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occurred in deleteByCondition (Unabl e to establish a connection with the database. (Unable to acquire a new connection from the pool)) (Generic Entity Exception occurred in deleteByCondition (Unabl e to establish a connection with the database. (Unable to acquire a new connection from the pool)))
at org.apache.ofbiz.entity.GenericDelegator.removeByCondition(GenericDelegator.java:1135) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.GenericDelegator.removeByAnd(GenericDelegator.java:1083) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.GenericDelegator.removeByAnd(GenericDelegator.java:1074) ~[ofbiz.jar:?]
at org.apache.ofbiz.service.ServiceDispatcher.<init>(ServiceDispatcher.java:105) ~[ofbiz.jar:?]
at org.apache.ofbiz.service.ServiceDispatcher.<init>(ServiceDispatcher.java:136) ~[ofbiz.jar:?]
at org.apache.ofbiz.service.ServiceDispatcher.getInstance(ServiceDispatcher.java:167) ~[ofbiz.jar:?]
at org.apache.ofbiz.service.ServiceDispatcher.getLocalDispatcher(ServiceDispatcher.java:147) ~[ofbiz.jar:?]
at org.apache.ofbiz.service.GenericDispatcherFactory.createLocalDispatcher(GenericDispatcherFactory.java:40) ~[ofbiz.jar:?]
at org.apache.ofbiz.service.ServiceContainer.getLocalDispatcher(ServiceContainer.java:92) ~[ofbiz.jar:?]
at org.apache.ofbiz.entityext.EntityServiceFactory.getLocalDispatcher(EntityServiceFactory.java:34) ~[ofbiz.jar:?]
at org.apache.ofbiz.entityext.EntityServiceFactory.getDispatchContext(EntityServiceFactory.java:39) ~[ofbiz.jar:?]
at org.apache.ofbiz.entityext.eca.DelegatorEcaHandler.lambda$setDelegator$0(DelegatorEcaHandler.java:61) ~[ofbiz.jar:?]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_422]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0_422]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_422]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_422]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_422]
at java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_422]
Caused by: org.apache.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occurred in deleteByCondition (Unable to establish a connection with the database. (Unable to acquire a new connection from the pool))
at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1125) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.datasource.GenericHelperDAO.removeByCondition(GenericHelperDAO.java:169) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.GenericDelegator.removeByCondition(GenericDelegator.java:1118) ~[ofbiz.jar:?]
... 17 more
Caused by: org.apache.ofbiz.entity.GenericDataSourceException: Unable to establish a connection with the database. (Unable to acquire a new connection from the p ool)
at org.apache.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:264) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:367) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:338) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1144) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1122) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.datasource.GenericHelperDAO.removeByCondition(GenericHelperDAO.java:169) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.GenericDelegator.removeByCondition(GenericDelegator.java:1118) ~[ofbiz.jar:?]
... 17 more
Caused by: java.sql.SQLException: Unable to acquire a new connection from the pool
at org.apache.commons.dbcp2.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:145) ~[commons-dbcp2-2.5.0.jar:2.5.0]
at org.apache.commons.dbcp2.managed.ManagedConnection.<init>(ManagedConnection.java:75) ~[commons-dbcp2-2.5.0.jar:2.5.0]
at org.apache.commons.dbcp2.managed.ManagedDataSource.getConnection(ManagedDataSource.java:80) ~[commons-dbcp2-2.5.0.jar:2.5.0]
at org.apache.ofbiz.entity.connection.DebugManagedDataSource.getConnection(DebugManagedDataSource.java:51) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:66) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.transaction.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:79) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:261) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:367) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:338) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1144) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1122) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.datasource.GenericHelperDAO.removeByCondition(GenericHelperDAO.java:169) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.GenericDelegator.removeByCondition(GenericDelegator.java:1118) ~[ofbiz.jar:?]
... 17 more
Caused by: java.util.NoSuchElementException: Unable to activate object
at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:474) ~[commons-pool2-2.6.0.jar:2.6.0]
at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:365) ~[commons-pool2-2.6.0.jar:2.6.0]
at org.apache.commons.dbcp2.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:142) ~[commons-dbcp2-2.5.0.jar:2.5.0]
at org.apache.commons.dbcp2.managed.ManagedConnection.<init>(ManagedConnection.java:75) ~[commons-dbcp2-2.5.0.jar:2.5.0]
at org.apache.commons.dbcp2.managed.ManagedDataSource.getConnection(ManagedDataSource.java:80) ~[commons-dbcp2-2.5.0.jar:2.5.0]
at org.apache.ofbiz.entity.connection.DebugManagedDataSource.getConnection(DebugManagedDataSource.java:51) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:66) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.transaction.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:79) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:261) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:367) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:338) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1144) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1122) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.datasource.GenericHelperDAO.removeByCondition(GenericHelperDAO.java:169) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.GenericDelegator.removeByCondition(GenericDelegator.java:1118) ~[ofbiz.jar:?]
... 17 more
Caused by: org.postgresql.util.PSQLException: This ResultSet is closed.
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.checkClosed(AbstractJdbc2ResultSet.java:2654) ~[postgresql-9.1-901.jdbc4.jar:?]
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.setFetchSize(AbstractJdbc2ResultSet.java:1771) ~[postgresql-9.1-901.jdbc4.jar:?]
at org.postgresql.jdbc4.Jdbc4Statement.createResultSet(Jdbc4Statement.java:39) ~[postgresql-9.1-901.jdbc4.jar:?]
at org.postgresql.jdbc2.AbstractJdbc2Statement$StatementResultHandler.handleResultRows(AbstractJdbc2Statement.java:211) ~[postgresql-9.1-901.jdbc4.jar:?]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1773) ~[postgresql-9.1-901.jdbc4.jar:?]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) ~[postgresql-9.1-901.jdbc4.jar:?]
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512) ~[postgresql-9.1-901.jdbc4.jar:?]
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374) ~[postgresql-9.1-901.jdbc4.jar:?]
at org.postgresql.jdbc2.AbstractJdbc2Connection.execSQLUpdate(AbstractJdbc2Connection.java:263) ~[postgresql-9.1-901.jdbc4.jar:?]
at org.postgresql.jdbc2.AbstractJdbc2Connection.getTransactionIsolation(AbstractJdbc2Connection.java:775) ~[postgresql-9.1-901.jdbc4.jar:?]
at org.apache.commons.dbcp2.DelegatingConnection.getTransactionIsolation(DelegatingConnection.java:414) ~[commons-dbcp2-2.5.0.jar:2.5.0]
at org.apache.commons.dbcp2.PoolableConnectionFactory.activateObject(PoolableConnectionFactory.java:434) ~[commons-dbcp2-2.5.0.jar:2.5.0]
at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:465) ~[commons-pool2-2.6.0.jar:2.6.0]
at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:365) ~[commons-pool2-2.6.0.jar:2.6.0]
at org.apache.commons.dbcp2.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:142) ~[commons-dbcp2-2.5.0.jar:2.5.0]
at org.apache.commons.dbcp2.managed.ManagedConnection.<init>(ManagedConnection.java:75) ~[commons-dbcp2-2.5.0.jar:2.5.0]
at org.apache.commons.dbcp2.managed.ManagedDataSource.getConnection(ManagedDataSource.java:80) ~[commons-dbcp2-2.5.0.jar:2.5.0]
at org.apache.ofbiz.entity.connection.DebugManagedDataSource.getConnection(DebugManagedDataSource.java:51) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:66) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.transaction.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:79) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:261) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:367) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:338) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1144) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.datasource.GenericDAO.deleteByCondition(GenericDAO.java:1122) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.datasource.GenericHelperDAO.removeByCondition(GenericHelperDAO.java:169) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.GenericDelegator.removeByCondition(GenericDelegator.java:1118) ~[ofbiz.jar:?]
... 17 more
2024-08-05 07:25:37,802 |kJoinPool-1-worker-1 |ModelServiceReader |I| Loaded [126] Services from file:/ofbiz/framework/common/servicedef/services.xml
2024-08-05 07:25:37,810 |kJoinPool-1-worker-1 |ModelServiceReader |I| Loaded [2] Services from file:/ofbiz/framework/common/servicedef/services_cdyne. xml
2024-08-05 07:25:37,819 |kJoinPool-1-worker-1 |ModelServiceReader |I| Loaded [18] Services from file:/ofbiz/framework/common/servicedef/services_email .xml
2024-08-05 07:25:37,826 |kJoinPool-1-worker-1 |ModelServiceReader |I| Loaded [3] Services from file:/ofbiz/framework/common/servicedef/services_enum.x ml
2024-08-05 07:25:37,833 |kJoinPool-1-worker-1 |ModelServiceReader |I| Loaded [6] Services from file:/ofbiz/framework/common/servicedef/services_method .xml
2024-08-05 07:25:37,841 |kJoinPool-1-worker-1 |ModelServiceReader |I| Loaded [12] Services from file:/ofbiz/framework/common/servicedef/services_geo.x ml
2024-08-05 07:25:37,849 |kJoinPool-1-worker-1 |ModelServiceReader |I| Loaded [1] Services from file:/ofbiz/framework/common/servicedef/services_qrcode .xml
2024-08-05 07:25:37,882 |main |EntityDataLoadContainer |I| =-=-=-=-=-=-= Doing a data load using delegator 'default' with the following fil es:
2024-08-05 07:25:37,887 |main |EntityDataLoadContainer |I| file:/ofbiz/framework/security/data/SecurityPermissionSeedData.xml
2024-08-05 07:25:37,887 |main |EntityDataLoadContainer |I| file:/ofbiz/framework/common/data/CommonSecurityPermissionSeedData.xml
2024-08-05 07:25:37,887 |main |EntityDataLoadContainer |I| file:/ofbiz/framework/common/data/CommonSystemPropertyData.xml
2024-08-05 07:25:37,888 |main |EntityDataLoadContainer |I| file:/ofbiz/framework/common/data/CommonTypeData.xml
2024-08-05 07:25:37,888 |main |EntityDataLoadContainer |I| file:/ofbiz/framework/common/data/CurrencyData.xml
2024-08-05 07:25:37,888 |main |EntityDataLoadContainer |I| file:/ofbiz/framework/common/data/CountryCodeData.xml
2024-08-05 07:25:37,888 |main |EntityDataLoadContainer |I| file:/ofbiz/framework/common/data/GeoData.xml
2024-08-05 07:25:37,888 |main |EntityDataLoadContainer |I| file:/ofbiz/framework/common/data/GeoData_AU.xml
2024-08-05 07:25:37,888 |main |EntityDataLoadContainer |I| file:/ofbiz/framework/common/data/GeoData_BG.xml
2024-08-05 07:25:37,888 |main |EntityDataLoadContainer |I| file:/ofbiz/framework/common/data/GeoData_BR.xml
2024-08-05 07:25:37,888 |main |EntityDataLoadContainer |I| file:/ofbiz/framework/common/data/GeoData_CA.xml
2024-08-05 07:25:37,888 |main |EntityDataLoadContainer |I| file:/ofbiz/framework/common/data/GeoData_CH.xml
2024-08-05 07:25:37,888 |main |EntityDataLoadContainer |I| file:/ofbiz/framework/common/data/GeoData_CN.xml
2024-08-05 07:25:37,888 |main |EntityDataLoadContainer |I| file:/ofbiz/framework/common/data/GeoData_CO.xml
2024-08-05 07:25:37,888 |main |EntityDataLoadContainer |I| file:/ofbiz/framework/common/data/GeoData_DE.xml
2024-08-05 07:25:37,888 |main |EntityDataLoadContainer |I| file:/ofbiz/framework/common/data/GeoData_ES.xml
2024-08-05 07:25:37,888 |main |EntityDataLoadContainer |I| file:/ofbiz/framework/common/data/GeoData_FR.xml
2024-08-05 07:25:37,888 |main |EntityDataLoadContainer |I| file:/ofbiz/framework/common/data/GeoData_IE.xml
2024-08-05 07:25:37,888 |main |EntityDataLoadContainer |I| file:/ofbiz/framework/common/data/GeoData_IL.xml
2024-08-05 07:25:37,888 |main |EntityDataLoadContainer |I| file:/ofbiz/framework/common/data/GeoData_IN.xml
2024-08-05 07:25:37,888 |main |EntityDataLoadContainer |I| file:/ofbiz/framework/common/data/GeoData_IT.xml
2024-08-05 07:25:37,888 |main |EntityDataLoadContainer |I| file:/ofbiz/framework/common/data/GeoData_JP.xml
2024-08-05 07:25:37,888 |main |EntityDataLoadContainer |I| file:/ofbiz/framework/common/data/GeoData_MX.xml
2024-08-05 07:25:37,888 |main |EntityDataLoadContainer |I| file:/ofbiz/framework/common/data/GeoData_MY.xml
2024-08-05 07:25:37,888 |main |EntityDataLoadContainer |I| file:/ofbiz/framework/common/data/GeoData_NL.xml
2024-08-05 07:25:37,888 |main |EntityDataLoadContainer |I| file:/ofbiz/framework/common/data/GeoData_NZ.xml
2024-08-05 07:25:37,888 |main |EntityDataLoadContainer |I| file:/ofbiz/framework/common/data/GeoData_PL.xml
2024-08-05 07:25:37,889 |main |EntityDataLoadContainer |I| file:/ofbiz/framework/common/data/GeoData_TH.xml
2024-08-05 07:25:37,889 |main |EntityDataLoadContainer |I| file:/ofbiz/framework/common/data/GeoData_UK.xml
2024-08-05 07:25:37,889 |main |EntityDataLoadContainer |I| file:/ofbiz/framework/common/data/GeoData_US.xml
2024-08-05 07:25:37,889 |main |EntityDataLoadContainer |I| file:/ofbiz/framework/common/data/LanguageData.xml
2024-08-05 07:25:37,889 |main |EntityDataLoadContainer |I| file:/ofbiz/framework/common/data/UnitData.xml
2024-08-05 07:25:37,889 |main |EntityDataLoadContainer |I| file:/ofbiz/framework/common/data/PeriodData.xml
2024-08-05 07:25:37,889 |main |EntityDataLoadContainer |I| file:/ofbiz/framework/common/data/CommonPortletData.xml
2024-08-05 07:25:37,889 |main |EntityDataLoadContainer |I| file:/ofbiz/framework/service/data/ScheduledServiceData.xml
2024-08-05 07:25:37,889 |main |EntityDataLoadContainer |I| file:/ofbiz/framework/service/data/ServiceSeedData.xml
2024-08-05 07:25:37,889 |main |EntityDataLoadContainer |I| file:/ofbiz/framework/service/data/ServiceSecurityPermissionSeedData.xml
2024-08-05 07:25:37,889 |main |EntityDataLoadContainer |I| file:/ofbiz/framework/entityext/data/EntityExtTypeData.xml
2024-08-05 07:25:37,889 |main |EntityDataLoadContainer |I| file:/ofbiz/framework/entityext/data/EntityExtSecurityPermissionSeedData.xml
2024-08-05 07:25:37,889 |main |EntityDataLoadContainer |I| file:/ofbiz/framework/webtools/data/WebtoolsSecurityPermissionSeedData.xml
2024-08-05 07:25:37,889 |main |EntityDataLoadContainer |I| file:/ofbiz/themes/bluelight/data/BlueLightThemeData.xml
2024-08-05 07:25:37,889 |main |EntityDataLoadContainer |I| file:/ofbiz/themes/common-theme/data/CommonThemeData.xml
2024-08-05 07:25:37,889 |main |EntityDataLoadContainer |I| file:/ofbiz/themes/flatgrey/data/FlatGreyThemeData.xml
2024-08-05 07:25:37,889 |main |EntityDataLoadContainer |I| file:/ofbiz/themes/rainbowstone/data/RainbowStoneThemeData.xml
2024-08-05 07:25:37,889 |main |EntityDataLoadContainer |I| file:/ofbiz/themes/tomahawk/data/TomahawkThemeData.xml
2024-08-05 07:25:37,889 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/datamodel/data/seed/PartySeedData.xml
2024-08-05 07:25:37,889 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/datamodel/data/seed/SecurityExtSeedData.xml
2024-08-05 07:25:37,889 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/datamodel/data/seed/ProductSeedData.xml
2024-08-05 07:25:37,889 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/datamodel/data/seed/ContentSeedData.xml
2024-08-05 07:25:37,889 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/datamodel/data/seed/WorkEffortSeedData.xml
2024-08-05 07:25:37,889 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/datamodel/data/seed/ManufacturingSeedData.xml
2024-08-05 07:25:37,890 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/datamodel/data/seed/AccountingSeedData.xml
2024-08-05 07:25:37,908 |kJoinPool-1-worker-1 |ModelServiceReader |I| Loaded [20] Services from file:/ofbiz/framework/common/servicedef/services_secur ity.xml
2024-08-05 07:25:37,890 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/datamodel/data/seed/HumanResSeedData.xml
2024-08-05 07:25:37,909 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/datamodel/data/seed/OrderSeedData.xml
2024-08-05 07:25:37,909 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/datamodel/data/seed/MarketingSeedData.xml
2024-08-05 07:25:37,912 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/datamodel/data/seed/CommonExtSeedData.xml
2024-08-05 07:25:37,915 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/party/data/PartyTypeData.xml
2024-08-05 07:25:37,915 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/party/data/PartyGeoPointData.xml
2024-08-05 07:25:37,915 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/party/data/PartyPortletData.xml
2024-08-05 07:25:37,921 |kJoinPool-1-worker-1 |ModelServiceReader |I| Loaded [27] Services from file:/ofbiz/framework/common/servicedef/services_test. xml
2024-08-05 07:25:37,937 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/content/data/ContentHelpData.xml
2024-08-05 07:25:37,937 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/content/data/ContentHttpErrorData.xml
2024-08-05 07:25:37,937 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/content/data/ContentPortletData.xml
2024-08-05 07:25:37,937 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/content/data/PartyHelpData.xml
2024-08-05 07:25:37,938 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/content/data/WebtoolsHelpData.xml
2024-08-05 07:25:37,938 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/workeffort/data/WorkEffortTypeData.xml
2024-08-05 07:25:37,938 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/workeffort/data/WorkEffortPortletData.xml
2024-08-05 07:25:37,938 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/product/data/ProductHelpData.xml
2024-08-05 07:25:37,938 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/product/data/ProductSecurityPermissionSeedData.xml
2024-08-05 07:25:37,938 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/product/data/FacilitySecurityPermissionSeedData.xml
2024-08-05 07:25:37,938 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/product/data/ApiSchemaDhl.xml
2024-08-05 07:25:37,938 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/product/data/ProductPortletData.xml
2024-08-05 07:25:37,938 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/product/data/PromoCustomMethodData.xml
2024-08-05 07:25:37,938 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/manufacturing/data/ManufacturingSecurityPermissionSeedD ata.xml
2024-08-05 07:25:37,938 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/manufacturing/data/ManufacturingHelpData_EN.xml
2024-08-05 07:25:37,938 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/manufacturing/data/ManufacturingHelpData_NL.xml
2024-08-05 07:25:37,938 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/accounting/data/AccountingHelpData.xml
2024-08-05 07:25:37,938 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/accounting/data/AccountingSecurityPermissionSeedData.xm l
2024-08-05 07:25:37,938 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/accounting/data/AccountingPortletData.xml
2024-08-05 07:25:37,938 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/humanres/data/HumanResHelpData.xml
2024-08-05 07:25:37,938 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/humanres/data/HumanResSecurityPermissionSeedData.xml
2024-08-05 07:25:37,938 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/humanres/data/HumanResPortletData.xml
2024-08-05 07:25:37,938 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/order/data/OrderTypeData.xml
2024-08-05 07:25:37,938 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/order/data/OrderPortletData.xml
2024-08-05 07:25:37,938 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/order/data/OrderSecurityPermissionSeedData.xml
2024-08-05 07:25:37,938 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/order/data/OrderHelpData.xml
2024-08-05 07:25:37,938 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/marketing/data/MarketingSecurityPermissionSeedData.xml
2024-08-05 07:25:37,938 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/marketing/data/MarketingHelpData.xml
2024-08-05 07:25:37,938 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/marketing/data/SfaPortletData.xml
2024-08-05 07:25:37,938 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/commonext/data/CommonExtSecurityPermissionSeedData.xml
2024-08-05 07:25:37,938 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/commonext/data/CommonExtHelpData.xml
2024-08-05 07:25:37,939 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/commonext/data/SystemInfoPortletData.xml
2024-08-05 07:25:37,939 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/commonext/data/SetupData.xml
2024-08-05 07:25:37,939 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/commonext/data/OfbizSetupSecurityPermissionSeedData.xml
2024-08-05 07:25:37,939 |main |EntityDataLoadContainer |I| file:/ofbiz/plugins/AlmusbahEmail/data/AlmusbahEmailTypeData.xml
2024-08-05 07:25:37,939 |main |EntityDataLoadContainer |I| file:/ofbiz/plugins/AlmusbahEmail/data/AlmusbahEmailSecurityPermissionSeedData.x ml
2024-08-05 07:25:37,939 |main |EntityDataLoadContainer |I| file:/ofbiz/plugins/assetmaint/data/AssetMaintSecurityPermissionSeedData.xml
2024-08-05 07:25:37,939 |main |EntityDataLoadContainer |I| file:/ofbiz/plugins/assetmaint/data/AssetMaintSeedData.xml
2024-08-05 07:25:37,939 |main |EntityDataLoadContainer |I| file:/ofbiz/plugins/bi/data/BiTypeData.xml
2024-08-05 07:25:37,939 |main |EntityDataLoadContainer |I| file:/ofbiz/plugins/bi/data/BiSecurityPermissionSeedData.xml
2024-08-05 07:25:37,939 |main |EntityDataLoadContainer |I| file:/ofbiz/plugins/ebay/data/EbaySecurityPermissionSeedData.xml
2024-08-05 07:25:37,939 |main |EntityDataLoadContainer |I| file:/ofbiz/plugins/ebay/data/EbayTypeData.xml
2024-08-05 07:25:37,939 |main |EntityDataLoadContainer |I| file:/ofbiz/plugins/ebay/data/EbayHelpData.xml
2024-08-05 07:25:37,939 |main |EntityDataLoadContainer |I| file:/ofbiz/plugins/ecommerce/data/EcommerceTypeData.xml
2024-08-05 07:25:37,939 |main |EntityDataLoadContainer |I| file:/ofbiz/plugins/ecommerce/data/EcommerceSecurityData.xml
2024-08-05 07:25:37,939 |main |EntityDataLoadContainer |I| file:/ofbiz/plugins/ecommerce/data/EcommerceSystemPropertyData.xml
2024-08-05 07:25:37,939 |main |EntityDataLoadContainer |I| file:/ofbiz/plugins/example/data/ExampleTypeData.xml
2024-08-05 07:25:37,939 |main |EntityDataLoadContainer |I| file:/ofbiz/plugins/example/data/ExampleSecurityPermissionSeedData.xml
2024-08-05 07:25:37,939 |main |EntityDataLoadContainer |I| file:/ofbiz/plugins/example/data/ExamplePortletData.xml
2024-08-05 07:25:37,939 |main |EntityDataLoadContainer |I| file:/ofbiz/plugins/example/data/ExamplePortalSeedData.xml
2024-08-05 07:25:37,939 |main |EntityDataLoadContainer |I| file:/ofbiz/plugins/example/data/ExampleHelpData.xml
2024-08-05 07:25:37,939 |main |EntityDataLoadContainer |I| file:/ofbiz/plugins/multiflex/data/MultiflexThemeData.xml
2024-08-05 07:25:37,939 |main |EntityDataLoadContainer |I| file:/ofbiz/plugins/myportal/data/MyPortalSecurityPermissionSeedData.xml
2024-08-05 07:25:37,939 |main |EntityDataLoadContainer |I| file:/ofbiz/plugins/passport/data/OAuth2CommonSeedData.xml
2024-08-05 07:25:37,939 |main |EntityDataLoadContainer |I| file:/ofbiz/plugins/pricat/data/PricatData.xml
2024-08-05 07:25:37,939 |main |EntityDataLoadContainer |I| file:/ofbiz/plugins/projectmgr/data/ProjectMgrTypeData.xml
2024-08-05 07:25:37,939 |main |EntityDataLoadContainer |I| file:/ofbiz/plugins/projectmgr/data/ProjectMgrHelpData.xml
2024-08-05 07:25:37,939 |main |EntityDataLoadContainer |I| file:/ofbiz/plugins/projectmgr/data/ProjectMgrSecurityPermissionSeedData.xml
2024-08-05 07:25:37,940 |main |EntityDataLoadContainer |I| file:/ofbiz/plugins/projectmgr/data/ProjectMgrPortletData.xml
2024-08-05 07:25:37,940 |main |EntityDataLoadContainer |I| file:/ofbiz/plugins/scrum/data/scrumTypeData.xml
2024-08-05 07:25:37,940 |main |EntityDataLoadContainer |I| file:/ofbiz/plugins/scrum/data/scrumSecurityPermissionSeedData.xml
2024-08-05 07:25:37,940 |main |EntityDataLoadContainer |I| file:/ofbiz/plugins/scrum/data/scrumHelpData.xml
2024-08-05 07:25:37,940 |main |EntityDataLoadContainer |I| file:/ofbiz/plugins/webpos/data/WebPosSecurityPermissionSeedData.xml
2024-08-05 07:25:37,940 |main |EntityDataLoadContainer |I| file:/ofbiz/plugins/webpos/data/PosSecurityData.xml
2024-08-05 07:25:37,940 |main |EntityDataLoadContainer |I| file:/ofbiz/plugins/webpos/data/PosTypeData.xml
2024-08-05 07:25:37,940 |main |EntityDataLoadContainer |I| file:/ofbiz/framework/service/data/ScheduledServices.xml
2024-08-05 07:25:37,940 |main |EntityDataLoadContainer |I| file:/ofbiz/framework/entityext/data/EntityScheduledServices.xml
2024-08-05 07:25:37,940 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/datamodel/data/seed-initial/PartySeedInitialData.xml
2024-08-05 07:25:37,940 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/datamodel/data/seed-initial/WorkEffortSeedInitialData.x ml
2024-08-05 07:25:37,940 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/product/data/ProductScheduledServices.xml
2024-08-05 07:25:37,940 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/product/data/CatalogSystemPropertyData.xml
2024-08-05 07:25:37,940 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/accounting/data/AccountingScheduledServiceData.xml
2024-08-05 07:25:37,940 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/order/data/OrderScheduledServices.xml
2024-08-05 07:25:37,940 |main |EntityDataLoadContainer |I| file:/ofbiz/applications/order/data/OrderSystemPropertyData.xml
2024-08-05 07:25:37,940 |main |EntityDataLoadContainer |I| file:/ofbiz/plugins/bi/data/BiSystemPropertyData.xml
2024-08-05 07:25:37,940 |main |EntityDataLoadContainer |I| file:/ofbiz/plugins/projectmgr/data/ProjectMgrSystemPropertyData.xml
2024-08-05 07:25:37,941 |main |EntityDataLoadContainer |I| =-=-=-=-=-=-= Starting the data load...
2024-08-05 07:25:37,947 |main |EntitySaxReader |I| Beginning import from URL: file:/ofbiz/framework/security/data/SecurityPermissio nSeedData.xml
2024-08-05 07:25:37,952 |kJoinPool-1-worker-1 |ModelServiceReader |I| Loaded [34] Services from file:/ofbiz/framework/service/servicedef/services.xml
2024-08-05 07:25:37,965 |kJoinPool-1-worker-1 |ModelServiceReader |I| Loaded [28] Services from file:/ofbiz/framework/service/servicedef/services_test _se.xml
2024-08-05 07:25:37,966 |main |EntitySaxReader |I| Transaction Timeout set to 2 hours (7200 seconds)
2024-08-05 07:25:38,005 |kJoinPool-1-worker-1 |ModelServiceReader |I| Loaded [68] Services from file:/ofbiz/framework/entityext/servicedef/services.xm l
2024-08-05 07:25:38,017 |kJoinPool-1-worker-1 |ModelServiceReader |I| Loaded [6] Services from file:/ofbiz/framework/entityext/servicedef/services_gro up.xml
org.apache.ofbiz.base.start.StartupException: Cannot init() dataload-container (org.apache.ofbiz.entity.GenericEntityException: [loadData]: Error loading XML Res ource "file:/ofbiz/framework/security/data/SecurityPermissionSeedData.xml"; Error was: A transaction error occurred reading data (A transaction error occurred re ading data) ([loadData]: Error loading XML Resource "file:/ofbiz/framework/security/data/SecurityPermissionSeedData.xml"; Error was: A transaction error occurred reading data (A transaction error occurred reading data)))
at org.apache.ofbiz.base.container.ContainerLoader.loadContainer(ContainerLoader.java:136)
at org.apache.ofbiz.base.container.ContainerLoader.loadContainersFromConfigurations(ContainerLoader.java:99)
at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:69)
at org.apache.ofbiz.base.start.StartupControlPanel.loadStartupLoaders(StartupControlPanel.java:218)
at org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:71)
at org.apache.ofbiz.base.start.Start.main(Start.java:85)
2024-08-05 07:25:38,024 |kJoinPool-1-worker-1 |ModelServiceReader |I| Loaded [3] Services from file:/ofbiz/framework/entityext/servicedef/services_syn chronization.xml
Caused by: org.apache.ofbiz.base.container.ContainerException: org.apache.ofbiz.entity.GenericEntityException: [loadData]: Error loading XML Resource "file:/ofbi z/framework/security/data/SecurityPermissionSeedData.xml"; Error was: A transaction error occurred reading data (A transaction error occurred reading data) ([loa dData]: Error loading XML Resource "file:/ofbiz/framework/security/data/SecurityPermissionSeedData.xml"; Error was: A transaction error occurred reading data (A transaction error occurred reading data))
at org.apache.ofbiz.entityext.data.EntityDataLoadContainer.loadData(EntityDataLoadContainer.java:445)
at org.apache.ofbiz.entityext.data.EntityDataLoadContainer.loadDataForDelegator(EntityDataLoadContainer.java:184)
at org.apache.ofbiz.entityext.data.EntityDataLoadContainer.init(EntityDataLoadContainer.java:116)
at org.apache.ofbiz.base.container.ContainerLoader.loadContainer(ContainerLoader.java:134)
... 5 more
Caused by: org.apache.ofbiz.entity.GenericEntityException: [loadData]: Error loading XML Resource "file:/ofbiz/framework/security/data/SecurityPermissionSeedData .xml"; Error was: A transaction error occurred reading data (A transaction error occurred reading data)
at org.apache.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:275)
at org.apache.ofbiz.entityext.data.EntityDataLoadContainer.loadData(EntityDataLoadContainer.java:437)
... 8 more
Caused by: org.xml.sax.SAXException: A transaction error occurred reading data
org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericDataSourceException: Unable to establish a connection with the database. (Unable t o acquire a new connection from the pool) (Unable to establish a connection with the database. (Unable to acquire a new connection from the pool))
at org.apache.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:240)
at org.apache.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:205)
at org.apache.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:268)
... 9 more
Caused by: org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericDataSourceException: Unable to establish a connection with the database . (Unable to acquire a new connection from the pool) (Unable to establish a connection with the database. (Unable to acquire a new connection from the pool))
at org.apache.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1358)
at org.apache.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:258)
at org.apache.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:228)
... 11 more
Caused by: org.apache.ofbiz.entity.GenericDataSourceException: Unable to establish a connection with the database. (Unable to acquire a new connection from the p ool)
at org.apache.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:264)
at org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:367)
at org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:351)
at org.apache.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:488)
at org.apache.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:466)
at org.apache.ofbiz.entity.datasource.GenericHelperDAO.findByPrimaryKey(GenericHelperDAO.java:81)
at org.apache.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1314)
... 13 more
Caused by: java.sql.SQLException: Unable to acquire a new connection from the pool
at org.apache.commons.dbcp2.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:145)
at org.apache.commons.dbcp2.managed.ManagedConnection.<init>(ManagedConnection.java:75)
at org.apache.commons.dbcp2.managed.ManagedDataSource.getConnection(ManagedDataSource.java:80)
at org.apache.ofbiz.entity.connection.DebugManagedDataSource.getConnection(DebugManagedDataSource.java:51)
at org.apache.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:66)
at org.apache.ofbiz.entity.transaction.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:79)
at org.apache.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:261)
... 19 more
Caused by: java.util.NoSuchElementException: Unable to activate object
at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:474)
at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:365)
at org.apache.commons.dbcp2.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:142)
... 25 more
Caused by: org.postgresql.util.PSQLException: This ResultSet is closed.
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.checkClosed(AbstractJdbc2ResultSet.java:2654)
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.setFetchSize(AbstractJdbc2ResultSet.java:1771)
at org.postgresql.jdbc4.Jdbc4Statement.createResultSet(Jdbc4Statement.java:39)
at org.postgresql.jdbc2.AbstractJdbc2Statement$StatementResultHandler.handleResultRows(AbstractJdbc2Statement.java:211)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1773)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
at org.postgresql.jdbc2.AbstractJdbc2Connection.execSQLUpdate(AbstractJdbc2Connection.java:263)
at org.postgresql.jdbc2.AbstractJdbc2Connection.getTransactionIsolation(AbstractJdbc2Connection.java:775)
at org.apache.commons.dbcp2.DelegatingConnection.getTransactionIsolation(DelegatingConnection.java:414)
at org.apache.commons.dbcp2.PoolableConnectionFactory.activateObject(PoolableConnectionFactory.java:434)
at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:465)
... 27 more
2024-08-05 07:25:38,024 |main |GenericDelegator |E| Failure in storeAll operation: org.apache.ofbiz.entity.GenericDataSourceExceptio n: Unable to establish a connection with the database. (Unable to acquire a new connection from the pool). Rolling back transaction.
org.apache.ofbiz.entity.GenericDataSourceException: Unable to establish a connection with the database. (Unable to acquire a new connection from the pool)
at org.apache.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:264) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:367) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:351) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:488) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:466) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.datasource.GenericHelperDAO.findByPrimaryKey(GenericHelperDAO.java:81) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1314) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:258) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:228) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:205) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:268) ~[ofbiz.jar:?]
at org.apache.ofbiz.entityext.data.EntityDataLoadContainer.loadData(EntityDataLoadContainer.java:437) ~[ofbiz.jar:?]
at org.apache.ofbiz.entityext.data.EntityDataLoadContainer.loadDataForDelegator(EntityDataLoadContainer.java:184) ~[ofbiz.jar:?]
at org.apache.ofbiz.entityext.data.EntityDataLoadContainer.init(EntityDataLoadContainer.java:116) ~[ofbiz.jar:?]
at org.apache.ofbiz.base.container.ContainerLoader.loadContainer(ContainerLoader.java:134) ~[ofbiz.jar:?]
at org.apache.ofbiz.base.container.ContainerLoader.loadContainersFromConfigurations(ContainerLoader.java:99) ~[ofbiz.jar:?]
at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:69) ~[ofbiz.jar:?]
at org.apache.ofbiz.base.start.StartupControlPanel.loadStartupLoaders(StartupControlPanel.java:218) ~[ofbiz.jar:?]
at org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:71) ~[ofbiz.jar:?]
at org.apache.ofbiz.base.start.Start.main(Start.java:85) ~[ofbiz.jar:?]
Caused by: java.sql.SQLException: Unable to acquire a new connection from the pool
at org.apache.commons.dbcp2.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:145) ~[commons-dbcp2-2.5.0.jar:2.5.0]
at org.apache.commons.dbcp2.managed.ManagedConnection.<init>(ManagedConnection.java:75) ~[commons-dbcp2-2.5.0.jar:2.5.0]
at org.apache.commons.dbcp2.managed.ManagedDataSource.getConnection(ManagedDataSource.java:80) ~[commons-dbcp2-2.5.0.jar:2.5.0]
at org.apache.ofbiz.entity.connection.DebugManagedDataSource.getConnection(DebugManagedDataSource.java:51) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:66) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.transaction.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:79) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:261) ~[ofbiz.jar:?]
... 19 more
Caused by: java.util.NoSuchElementException: Unable to activate object
at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:474) ~[commons-pool2-2.6.0.jar:2.6.0]
at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:365) ~[commons-pool2-2.6.0.jar:2.6.0]
at org.apache.commons.dbcp2.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:142) ~[commons-dbcp2-2.5.0.jar:2.5.0]
at org.apache.commons.dbcp2.managed.ManagedConnection.<init>(ManagedConnection.java:75) ~[commons-dbcp2-2.5.0.jar:2.5.0]
at org.apache.commons.dbcp2.managed.ManagedDataSource.getConnection(ManagedDataSource.java:80) ~[commons-dbcp2-2.5.0.jar:2.5.0]
at org.apache.ofbiz.entity.connection.DebugManagedDataSource.getConnection(DebugManagedDataSource.java:51) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:66) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.transaction.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:79) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:261) ~[ofbiz.jar:?]
... 19 more
Caused by: org.postgresql.util.PSQLException: This ResultSet is closed.
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.checkClosed(AbstractJdbc2ResultSet.java:2654) ~[postgresql-9.1-901.jdbc4.jar:?]
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.setFetchSize(AbstractJdbc2ResultSet.java:1771) ~[postgresql-9.1-901.jdbc4.jar:?]
at org.postgresql.jdbc4.Jdbc4Statement.createResultSet(Jdbc4Statement.java:39) ~[postgresql-9.1-901.jdbc4.jar:?]
at org.postgresql.jdbc2.AbstractJdbc2Statement$StatementResultHandler.handleResultRows(AbstractJdbc2Statement.java:211) ~[postgresql-9.1-901.jdbc4.jar:?]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1773) ~[postgresql-9.1-901.jdbc4.jar:?]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) ~[postgresql-9.1-901.jdbc4.jar:?]
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512) ~[postgresql-9.1-901.jdbc4.jar:?]
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374) ~[postgresql-9.1-901.jdbc4.jar:?]
at org.postgresql.jdbc2.AbstractJdbc2Connection.execSQLUpdate(AbstractJdbc2Connection.java:263) ~[postgresql-9.1-901.jdbc4.jar:?]
at org.postgresql.jdbc2.AbstractJdbc2Connection.getTransactionIsolation(AbstractJdbc2Connection.java:775) ~[postgresql-9.1-901.jdbc4.jar:?]
at org.apache.commons.dbcp2.DelegatingConnection.getTransactionIsolation(DelegatingConnection.java:414) ~[commons-dbcp2-2.5.0.jar:2.5.0]
at org.apache.commons.dbcp2.PoolableConnectionFactory.activateObject(PoolableConnectionFactory.java:434) ~[commons-dbcp2-2.5.0.jar:2.5.0]
at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:465) ~[commons-pool2-2.6.0.jar:2.6.0]
at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:365) ~[commons-pool2-2.6.0.jar:2.6.0]
at org.apache.commons.dbcp2.managed.ManagedConnection.updateTransactionStatus(ManagedConnection.java:142) ~[commons-dbcp2-2.5.0.jar:2.5.0]
at org.apache.commons.dbcp2.managed.ManagedConnection.<init>(ManagedConnection.java:75) ~[commons-dbcp2-2.5.0.jar:2.5.0]
at org.apache.commons.dbcp2.managed.ManagedDataSource.getConnection(ManagedDataSource.java:80) ~[commons-dbcp2-2.5.0.jar:2.5.0]
at org.apache.ofbiz.entity.connection.DebugManagedDataSource.getConnection(DebugManagedDataSource.java:51) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.connection.DBCPConnectionFactory.getConnection(DBCPConnectionFactory.java:66) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.transaction.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:79) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:261) ~[ofbiz.jar:?]
... 19 more
> Task :ofbiz --load-data readers=seed,seed-initial FAILED
FAILURE: Build failed with an exception.
* What went wrong:
Execution failed for task ':ofbiz --load-data readers=seed,seed-initial'.
> Process 'command '/opt/java/openjdk/bin/java'' finished with non-zero exit value 1
* Try:
Run with --stacktrace option to get the stack trace. Run with --info or --debug option to get more log output. Run with --scan to get full insights.
* Get more help at https://help.gradle.org
BUILD FAILED in 1m 53s
13 actionable tasks: 10 executed, 3 up-to-date
samir@amgmdchr1:~/ofbizPros/almusbahemail/docker-postgres-ofbiz-main$ 2024-08-05 07:25:38,017 |kJoinPool-1-worker-1 |ModelServiceReader |I| Loaded [6] Services from file:/ofbiz/framework/entityext/servicedef/services_gro up.xml
org.apache.ofbiz.base.start.StartupException: Cannot init() dataload-container (org.apache.ofbiz.entity.GenericEntityException: [loadData]: Error loading XML Res ource "file:/ofbiz/framework/security/data/SecurityPermissionSeedData.xml"; Error was: A transaction error occurred reading data (A transaction error occurred re ading data) ([loadData]: Error loading XML Resource "file:/ofbiz/framework/security/data/SecurityPermissionSeedData.xml"; Error was: A transaction error occurred reading data (A transaction error occurred reading data)))
at org.apache.ofbiz.base.container.ContainerLoader.loadContainer(ContainerLoader.java:136)
at org.apache.ofbiz.base.container.ContainerLoader.loadContainersFromConfigurations(ContainerLoader.java:99)
at org.apache.ofbiz.base.container.ContainerLoader.load(ContainerLoader.java:69)
at org.apache.ofbiz.base.start.StartupControlPanel.loadStartupLoaders(StartupControlPanel.java:218)
at org.apache.ofbiz.base.start.StartupControlPanel.start(StartupControlPanel.java:71)
at org.apache.ofbiz.base.start.Start.main(Start.java:85)
2024-08-05 07:25:38,024 |kJoinPool-1-worker-1 |ModelServiceReader |I| Loaded [3] Services from file:/ofbiz/framework/entityext/servicedef/services_syn chronization.xml
Caused by: org.apache.ofbiz.base.container.ContainerException: org.apache.ofbiz.entity.GenericEntityException: [loadData]: Error loading XML Resource "file:/ofbi z/framework/security/data/SecurityPermissionSeedData.xml"; Error was: A transaction error occurred reading data (A transaction error occurred reading data) ([loa dData]: Error loading XML Resource "file:/ofbiz/framework/security/data/SecurityPermissionSeedData.xml"; Error was: A transaction error occurred reading data (A transaction error occurred reading data))
at org.apache.ofbiz.entityext.data.EntityDataLoadContainer.loadData(EntityDataLoadContainer.java:445)
at org.apache.ofbiz.entityext.data.EntityDataLoadContainer.loadDataForDelegator(EntityDataLoadContainer.java:184)
at org.apache.ofbiz.entityext.data.EntityDataLoadContainer.init(EntityDataLoadContainer.java:116)
at org.apache.ofbiz.base.container.ContainerLoader.loadContainer(ContainerLoader.java:134)
... 5 more
Caused by: org.apache.ofbiz.entity.GenericEntityException: [loadData]: Error loading XML Resource "file:/ofbiz/framework/security/data/SecurityPermissionSeedData .xml"; Error was: A transaction error occurred reading data (A transaction error occurred reading data)
at org.apache.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:275)
at org.apache.ofbiz.entityext.data.EntityDataLoadContainer.loadData(EntityDataLoadContainer.java:437)
... 8 more
--
This message was sent by Atlassian Jira
(v8.20.10#820010)