[ https://issues.apache.org/jira/browse/OFBIZ-13129?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17871049#comment-17871049 ]
Daniel Watford commented on OFBIZ-13129: ---------------------------------------- Also [~sameeralwosaby] , if you are not using the postgres-demo as a starting point, the error messages you posted mention an issue establishing a connection to the database. Is postgres up and running and can you connect to it from outside of ofbiz? We'll need a description of your environment and docker compose file/docker command lines to investigate further. > 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.14, 18.12.15 > Reporter: sameeralwosaby > Priority: Major > > 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)