MySQL connection in broadleaf
Posted: Tue Jun 04, 2013 12:55 am
Hi All,
I am new to broadleaf, and i go through the DemoSite project as well explained into this link http://docs.broadleafcommerce.org/dev/Getting-Started.html
And i configure the MySQL database as describe into this link http://docs.broadleafcommerce.org/dev/Switch-To-MySQL-Tutorial.html
I run the first time successfully, and it is running good. But when i stop the server and run again by "ant jetty-demo", it loading all the db stuff again, means at first time i created some users - stop the server - run again , no users in db table afer (BLC_CUSTOMER) after restarting. That should not be a case.
And also i am getting below errors while starting the server
Demo-site is running good after starting the server, but all the db tables are recreated.
Am I missing something ?
Thanks,
Ankit
I am new to broadleaf, and i go through the DemoSite project as well explained into this link http://docs.broadleafcommerce.org/dev/Getting-Started.html
And i configure the MySQL database as describe into this link http://docs.broadleafcommerce.org/dev/Switch-To-MySQL-Tutorial.html
I run the first time successfully, and it is running good. But when i stop the server and run again by "ant jetty-demo", it loading all the db stuff again, means at first time i created some users - stop the server - run again , no users in db table afer (BLC_CUSTOMER) after restarting. That should not be a case.
And also i am getting below errors while starting the server
Code: Select all
[artifact:mvn] [ERROR] 10:50:06 Ejb3Configuration - HHH000050: Container is providing a null PersistenceUnitRootUrl: discovery impossible
[artifact:mvn] [ WARN] 10:50:07 Ejb3Configuration - HHH000144: hibernate.connection.autocommit = false breaks the EJB3 specification
[artifact:mvn] [ WARN] 10:50:09 AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [org.hibernate.cache.spi.UpdateTimestampsCache]; using defaults.
[artifact:mvn] [ WARN] 10:50:09 AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [org.hibernate.cache.internal.StandardQueryCache]; using defaults.
[artifact:mvn] [ WARN] 10:50:09 AbstractEhcacheRegionFactory - HHH020003: Could not find a specific ehcache configuration for cache named [blSandBoxElements]; using defaults.
[artifact:mvn] [ERROR] 10:50:11 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADDITIONAL_OFFER_INFO drop foreign key FK3BFDBD63B5D9C34D
[artifact:mvn] [ERROR] 10:50:11 SchemaExport - Error on rename of './broadleaf/BLC_ADDITIONAL_OFFER_INFO' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:11 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADDITIONAL_OFFER_INFO drop foreign key FK3BFDBD63D5F3FAF4
[artifact:mvn] [ERROR] 10:50:11 SchemaExport - Error on rename of './broadleaf/BLC_ADDITIONAL_OFFER_INFO' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:11 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADDITIONAL_OFFER_INFO drop foreign key FK3BFDBD631891FF79
[artifact:mvn] [ERROR] 10:50:11 SchemaExport - Error on rename of './broadleaf/BLC_ADDITIONAL_OFFER_INFO' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:11 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADDRESS drop foreign key FK299F86CEA46E16CF
[artifact:mvn] [ERROR] 10:50:11 SchemaExport - Error on rename of './broadleaf/BLC_ADDRESS' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:12 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADDRESS drop foreign key FK299F86CEF1A6533F
[artifact:mvn] [ERROR] 10:50:12 SchemaExport - Error on rename of './broadleaf/BLC_ADDRESS' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:12 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADDRESS drop foreign key FK299F86CEBF4449BA
[artifact:mvn] [ERROR] 10:50:12 SchemaExport - Error on rename of './broadleaf/BLC_ADDRESS' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:12 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADDRESS drop foreign key FK299F86CEE12DC0C8
[artifact:mvn] [ERROR] 10:50:12 SchemaExport - Error on rename of './broadleaf/BLC_ADDRESS' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:12 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADDRESS drop foreign key FK299F86CE337C4D50
[artifact:mvn] [ERROR] 10:50:12 SchemaExport - Error on rename of './broadleaf/BLC_ADDRESS' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:12 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADMIN_PERMISSION_ENTITY drop foreign key FK23C09E3DE88B7D38
[artifact:mvn] [ERROR] 10:50:12 SchemaExport - Error on rename of './broadleaf/BLC_ADMIN_PERMISSION_ENTITY' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:13 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADMIN_ROLE_PERMISSION_XREF drop foreign key FK4A819D98E88B7D38
[artifact:mvn] [ERROR] 10:50:13 SchemaExport - Error on rename of './broadleaf/BLC_ADMIN_ROLE_PERMISSION_XREF' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:13 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADMIN_ROLE_PERMISSION_XREF drop foreign key FK4A819D985F43AAD8
[artifact:mvn] [ERROR] 10:50:13 SchemaExport - Error on rename of './broadleaf/BLC_ADMIN_ROLE_PERMISSION_XREF' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:13 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADMIN_SECTION drop foreign key FK7EA7D92FB1A18498
[artifact:mvn] [ERROR] 10:50:13 SchemaExport - Error on rename of './broadleaf/BLC_ADMIN_SECTION' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:14 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADMIN_SEC_PERM_XREF drop foreign key FK5E832966E88B7D38
[artifact:mvn] [ERROR] 10:50:14 SchemaExport - Error on rename of './broadleaf/BLC_ADMIN_SEC_PERM_XREF' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:14 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADMIN_SEC_PERM_XREF drop foreign key FK5E8329663AF7F0FC
[artifact:mvn] [ERROR] 10:50:14 SchemaExport - Error on rename of './broadleaf/BLC_ADMIN_SEC_PERM_XREF' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:14 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADMIN_USER_PERMISSION_XREF drop foreign key FKF0B3BEEDE88B7D38
[artifact:mvn] [ERROR] 10:50:14 SchemaExport - Error on rename of './broadleaf/BLC_ADMIN_USER_PERMISSION_XREF' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:14 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADMIN_USER_PERMISSION_XREF drop foreign key FKF0B3BEED46EBC38
[artifact:mvn] [ERROR] 10:50:14 SchemaExport - Error on rename of './broadleaf/BLC_ADMIN_USER_PERMISSION_XREF' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:14 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADMIN_USER_ROLE_XREF drop foreign key FKFFD33A265F43AAD8
[artifact:mvn] [ERROR] 10:50:14 SchemaExport - Error on rename of './broadleaf/BLC_ADMIN_USER_ROLE_XREF' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:15 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADMIN_USER_ROLE_XREF drop foreign key FKFFD33A2646EBC38
[artifact:mvn] [ERROR] 10:50:15 SchemaExport - Error on rename of './broadleaf/BLC_ADMIN_USER_ROLE_XREF' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:15 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADMIN_USER_SANDBOX drop foreign key FKD0A97E09579FE59D
[artifact:mvn] [ERROR] 10:50:15 SchemaExport - Error on rename of './broadleaf/BLC_ADMIN_USER_SANDBOX' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:15 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ADMIN_USER_SANDBOX drop foreign key FKD0A97E0946EBC38
[artifact:mvn] [ERROR] 10:50:15 SchemaExport - Error on rename of './broadleaf/BLC_ADMIN_USER_SANDBOX' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:15 SchemaExport - HHH000389: Unsuccessful: alter table BLC_AMOUNT_ITEM drop foreign key FKB98530944BC71D98
[artifact:mvn] [ERROR] 10:50:15 SchemaExport - Error on rename of './broadleaf/BLC_AMOUNT_ITEM' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:15 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ASSET_DESC_MAP drop foreign key FKE886BAE3E2BA0C9D
[artifact:mvn] [ERROR] 10:50:15 SchemaExport - Error on rename of './broadleaf/BLC_ASSET_DESC_MAP' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:16 SchemaExport - HHH000389: Unsuccessful: alter table BLC_ASSET_DESC_MAP drop foreign key FKE886BAE367F70B63
[artifact:mvn] [ERROR] 10:50:16 SchemaExport - Error on rename of './broadleaf/BLC_ASSET_DESC_MAP' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:16 SchemaExport - HHH000389: Unsuccessful: alter table BLC_BUNDLE_ORDER_ITEM drop foreign key FK489703DBCCF29B96
[artifact:mvn] [ERROR] 10:50:16 SchemaExport - Error on rename of './broadleaf/BLC_BUNDLE_ORDER_ITEM' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:16 SchemaExport - HHH000389: Unsuccessful: alter table BLC_BUNDLE_ORDER_ITEM drop foreign key FK489703DBB78C9977
[artifact:mvn] [ERROR] 10:50:16 SchemaExport - Error on rename of './broadleaf/BLC_BUNDLE_ORDER_ITEM' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:16 SchemaExport - HHH000389: Unsuccessful: alter table BLC_BUNDLE_ORDER_ITEM drop foreign key FK489703DB9AF166DF
[artifact:mvn] [ERROR] 10:50:16 SchemaExport - Error on rename of './broadleaf/BLC_BUNDLE_ORDER_ITEM' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:16 SchemaExport - HHH000389: Unsuccessful: alter table BLC_BUND_ITEM_FEE_PRICE drop foreign key FK14267A943FC68307
[artifact:mvn] [ERROR] 10:50:16 SchemaExport - Error on rename of './broadleaf/BLC_BUND_ITEM_FEE_PRICE' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:17 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CANDIDATE_FG_OFFER drop foreign key FKCE785605028DC55
[artifact:mvn] [ERROR] 10:50:17 SchemaExport - Error on rename of './broadleaf/BLC_CANDIDATE_FG_OFFER' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:17 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CANDIDATE_FG_OFFER drop foreign key FKCE78560D5F3FAF4
[artifact:mvn] [ERROR] 10:50:17 SchemaExport - Error on rename of './broadleaf/BLC_CANDIDATE_FG_OFFER' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:17 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CANDIDATE_ITEM_OFFER drop foreign key FK9EEE9B2D5F3FAF4
[artifact:mvn] [ERROR] 10:50:17 SchemaExport - Error on rename of './broadleaf/BLC_CANDIDATE_ITEM_OFFER' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:17 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CANDIDATE_ITEM_OFFER drop foreign key FK9EEE9B29AF166DF
[artifact:mvn] [ERROR] 10:50:17 SchemaExport - Error on rename of './broadleaf/BLC_CANDIDATE_ITEM_OFFER' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:17 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CANDIDATE_ORDER_OFFER drop foreign key FK61852289D5F3FAF4
[artifact:mvn] [ERROR] 10:50:17 SchemaExport - Error on rename of './broadleaf/BLC_CANDIDATE_ORDER_OFFER' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:18 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CANDIDATE_ORDER_OFFER drop foreign key FK6185228989FE8A02
[artifact:mvn] [ERROR] 10:50:18 SchemaExport - Error on rename of './broadleaf/BLC_CANDIDATE_ORDER_OFFER' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:18 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CATEGORY drop foreign key FK55F82D44B177E6
[artifact:mvn] [ERROR] 10:50:18 SchemaExport - Error on rename of './broadleaf/BLC_CATEGORY' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:18 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CATEGORY_ATTRIBUTE drop foreign key FK4E441D4115D1A13D
[artifact:mvn] [ERROR] 10:50:18 SchemaExport - Error on rename of './broadleaf/BLC_CATEGORY_ATTRIBUTE' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:18 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CATEGORY_IMAGE drop foreign key FK27CF3E8015D1A13D
[artifact:mvn] [ERROR] 10:50:18 SchemaExport - Error on rename of './broadleaf/BLC_CATEGORY_IMAGE' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:19 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CATEGORY_MEDIA_MAP drop foreign key FKCD24B1066E4720E0
[artifact:mvn] [ERROR] 10:50:19 SchemaExport - Error on rename of './broadleaf/BLC_CATEGORY_MEDIA_MAP' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:19 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CATEGORY_MEDIA_MAP drop foreign key FKCD24B106D786CEA2
[artifact:mvn] [ERROR] 10:50:19 SchemaExport - Error on rename of './broadleaf/BLC_CATEGORY_MEDIA_MAP' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:19 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CATEGORY_PRODUCT_XREF drop foreign key FK635EB1A615D1A13D
[artifact:mvn] [ERROR] 10:50:19 SchemaExport - Error on rename of './broadleaf/BLC_CATEGORY_PRODUCT_XREF' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:19 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CATEGORY_PRODUCT_XREF drop foreign key FK635EB1A65F11A0B7
[artifact:mvn] [ERROR] 10:50:19 SchemaExport - Error on rename of './broadleaf/BLC_CATEGORY_PRODUCT_XREF' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:19 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CATEGORY_XREF drop foreign key FKE8897336D6D45DBE
[artifact:mvn] [ERROR] 10:50:19 SchemaExport - Error on rename of './broadleaf/BLC_CATEGORY_XREF' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:20 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CATEGORY_XREF drop foreign key FKE889733615D1A13D
[artifact:mvn] [ERROR] 10:50:20 SchemaExport - Error on rename of './broadleaf/BLC_CATEGORY_XREF' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:20 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CAT_SEARCH_FACET_EXCL_XREF drop foreign key FK8361EF4E15D1A13D
[artifact:mvn] [ERROR] 10:50:20 SchemaExport - Error on rename of './broadleaf/BLC_CAT_SEARCH_FACET_EXCL_XREF' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:20 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CAT_SEARCH_FACET_EXCL_XREF drop foreign key FK8361EF4EB96B1C93
[artifact:mvn] [ERROR] 10:50:20 SchemaExport - Error on rename of './broadleaf/BLC_CAT_SEARCH_FACET_EXCL_XREF' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:20 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CAT_SEARCH_FACET_XREF drop foreign key FK32210EEB15D1A13D
[artifact:mvn] [ERROR] 10:50:20 SchemaExport - Error on rename of './broadleaf/BLC_CAT_SEARCH_FACET_XREF' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:21 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CAT_SEARCH_FACET_XREF drop foreign key FK32210EEBB96B1C93
[artifact:mvn] [ERROR] 10:50:21 SchemaExport - Error on rename of './broadleaf/BLC_CAT_SEARCH_FACET_XREF' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:22 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CUSTOMER drop foreign key FK7716F0241422B204
[artifact:mvn] [ERROR] 10:50:22 SchemaExport - Error on rename of './broadleaf/BLC_CUSTOMER' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:22 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CUSTOMER drop foreign key FK7716F024A1E1C128
[artifact:mvn] [ERROR] 10:50:22 SchemaExport - Error on rename of './broadleaf/BLC_CUSTOMER' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:23 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CUSTOMER_ADDRESS drop foreign key FK75B95AB9C13085DD
[artifact:mvn] [ERROR] 10:50:23 SchemaExport - Error on rename of './broadleaf/BLC_CUSTOMER_ADDRESS' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:23 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CUSTOMER_ADDRESS drop foreign key FK75B95AB97470F437
[artifact:mvn] [ERROR] 10:50:23 SchemaExport - Error on rename of './broadleaf/BLC_CUSTOMER_ADDRESS' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:23 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CUSTOMER_ATTRIBUTE drop foreign key FKB974C8217470F437
[artifact:mvn] [ERROR] 10:50:23 SchemaExport - Error on rename of './broadleaf/BLC_CUSTOMER_ATTRIBUTE' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:23 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CUSTOMER_OFFER_XREF drop foreign key FK685E80397470F437
[artifact:mvn] [ERROR] 10:50:23 SchemaExport - Error on rename of './broadleaf/BLC_CUSTOMER_OFFER_XREF' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:23 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CUSTOMER_OFFER_XREF drop foreign key FK685E8039D5F3FAF4
[artifact:mvn] [ERROR] 10:50:23 SchemaExport - Error on rename of './broadleaf/BLC_CUSTOMER_OFFER_XREF' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:24 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CUSTOMER_PAYMENT drop foreign key FK8B3DF0CBC13085DD
[artifact:mvn] [ERROR] 10:50:24 SchemaExport - Error on rename of './broadleaf/BLC_CUSTOMER_PAYMENT' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:24 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CUSTOMER_PAYMENT drop foreign key FK8B3DF0CB7470F437
[artifact:mvn] [ERROR] 10:50:24 SchemaExport - Error on rename of './broadleaf/BLC_CUSTOMER_PAYMENT' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:24 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CUSTOMER_PAYMENT_FIELDS drop foreign key FK5CCB14ADCA0B98E0
[artifact:mvn] [ERROR] 10:50:24 SchemaExport - Error on rename of './broadleaf/BLC_CUSTOMER_PAYMENT_FIELDS' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:24 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CUSTOMER_PHONE drop foreign key FK3D28ED737470F437
[artifact:mvn] [ERROR] 10:50:24 SchemaExport - Error on rename of './broadleaf/BLC_CUSTOMER_PHONE' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:24 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CUSTOMER_PHONE drop foreign key FK3D28ED73D894CB5D
[artifact:mvn] [ERROR] 10:50:24 SchemaExport - Error on rename of './broadleaf/BLC_CUSTOMER_PHONE' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:25 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CUSTOMER_ROLE drop foreign key FK548EB7B17470F437
[artifact:mvn] [ERROR] 10:50:25 SchemaExport - Error on rename of './broadleaf/BLC_CUSTOMER_ROLE' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:25 SchemaExport - HHH000389: Unsuccessful: alter table BLC_CUSTOMER_ROLE drop foreign key FK548EB7B1B8587B7
[artifact:mvn] [ERROR] 10:50:25 SchemaExport - Error on rename of './broadleaf/BLC_CUSTOMER_ROLE' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:25 SchemaExport - HHH000389: Unsuccessful: alter table BLC_DATA_DRVN_ENUM_VAL drop foreign key FKB2D5700DA60E0554
[artifact:mvn] [ERROR] 10:50:25 SchemaExport - Error on rename of './broadleaf/BLC_DATA_DRVN_ENUM_VAL' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:25 SchemaExport - HHH000389: Unsuccessful: alter table BLC_DISCRETE_ORDER_ITEM drop foreign key FKBC3A8A845CDFCA80
[artifact:mvn] [ERROR] 10:50:25 SchemaExport - Error on rename of './broadleaf/BLC_DISCRETE_ORDER_ITEM' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:26 SchemaExport - HHH000389: Unsuccessful: alter table BLC_DISCRETE_ORDER_ITEM drop foreign key FKBC3A8A845F11A0B7
[artifact:mvn] [ERROR] 10:50:26 SchemaExport - Error on rename of './broadleaf/BLC_DISCRETE_ORDER_ITEM' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:26 SchemaExport - HHH000389: Unsuccessful: alter table BLC_DISCRETE_ORDER_ITEM drop foreign key FKBC3A8A84B78C9977
[artifact:mvn] [ERROR] 10:50:26 SchemaExport - Error on rename of './broadleaf/BLC_DISCRETE_ORDER_ITEM' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:26 SchemaExport - HHH000389: Unsuccessful: alter table BLC_DISCRETE_ORDER_ITEM drop foreign key FKBC3A8A841285903B
[artifact:mvn] [ERROR] 10:50:26 SchemaExport - Error on rename of './broadleaf/BLC_DISCRETE_ORDER_ITEM' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:26 SchemaExport - HHH000389: Unsuccessful: alter table BLC_DISCRETE_ORDER_ITEM drop foreign key FKBC3A8A849AF166DF
[artifact:mvn] [ERROR] 10:50:26 SchemaExport - Error on rename of './broadleaf/BLC_DISCRETE_ORDER_ITEM' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:27 SchemaExport - HHH000389: Unsuccessful: alter table BLC_DISC_ITEM_FEE_PRICE drop foreign key FK2A641CC8B76B9466
[artifact:mvn] [ERROR] 10:50:27 SchemaExport - Error on rename of './broadleaf/BLC_DISC_ITEM_FEE_PRICE' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:27 SchemaExport - HHH000389: Unsuccessful: alter table BLC_DYN_DISCRETE_ORDER_ITEM drop foreign key FK209DEE9EB76B9466
[artifact:mvn] [ERROR] 10:50:27 SchemaExport - Error on rename of './broadleaf/BLC_DYN_DISCRETE_ORDER_ITEM' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:27 SchemaExport - HHH000389: Unsuccessful: alter table BLC_EMAIL_TRACKING_CLICKS drop foreign key FKFDF9F52AFA1E5D61
[artifact:mvn] [ERROR] 10:50:27 SchemaExport - Error on rename of './broadleaf/BLC_EMAIL_TRACKING_CLICKS' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:27 SchemaExport - HHH000389: Unsuccessful: alter table BLC_EMAIL_TRACKING_OPENS drop foreign key FKA5C3722AFA1E5D61
[artifact:mvn] [ERROR] 10:50:27 SchemaExport - Error on rename of './broadleaf/BLC_EMAIL_TRACKING_OPENS' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:27 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FG_ADJUSTMENT drop foreign key FK468C8F255028DC55
[artifact:mvn] [ERROR] 10:50:27 SchemaExport - Error on rename of './broadleaf/BLC_FG_ADJUSTMENT' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:28 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FG_ADJUSTMENT drop foreign key FK468C8F25D5F3FAF4
[artifact:mvn] [ERROR] 10:50:28 SchemaExport - Error on rename of './broadleaf/BLC_FG_ADJUSTMENT' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:28 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FG_FEE_TAX_XREF drop foreign key FK25426DC071448C19
[artifact:mvn] [ERROR] 10:50:28 SchemaExport - Error on rename of './broadleaf/BLC_FG_FEE_TAX_XREF' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:28 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FG_FEE_TAX_XREF drop foreign key FK25426DC0598F6D02
[artifact:mvn] [ERROR] 10:50:28 SchemaExport - Error on rename of './broadleaf/BLC_FG_FEE_TAX_XREF' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:28 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FG_FG_TAX_XREF drop foreign key FK61BEA45571448C19
[artifact:mvn] [ERROR] 10:50:28 SchemaExport - Error on rename of './broadleaf/BLC_FG_FG_TAX_XREF' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:29 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FG_FG_TAX_XREF drop foreign key FK61BEA4555028DC55
[artifact:mvn] [ERROR] 10:50:29 SchemaExport - Error on rename of './broadleaf/BLC_FG_FG_TAX_XREF' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:29 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FG_ITEM_TAX_XREF drop foreign key FKDD3E844371448C19
[artifact:mvn] [ERROR] 10:50:29 SchemaExport - Error on rename of './broadleaf/BLC_FG_ITEM_TAX_XREF' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:29 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FG_ITEM_TAX_XREF drop foreign key FKDD3E8443E3BBB4D2
[artifact:mvn] [ERROR] 10:50:29 SchemaExport - Error on rename of './broadleaf/BLC_FG_ITEM_TAX_XREF' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:29 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FIELD_SEARCH_TYPES drop foreign key FKF52D130D3C3907C4
[artifact:mvn] [ERROR] 10:50:29 SchemaExport - Error on rename of './broadleaf/BLC_FIELD_SEARCH_TYPES' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:29 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FLD_DEF drop foreign key FK3FCB575EFD2EA299
[artifact:mvn] [ERROR] 10:50:29 SchemaExport - Error on rename of './broadleaf/BLC_FLD_DEF' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:30 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FLD_DEF drop foreign key FK3FCB575E6A79BDB5
[artifact:mvn] [ERROR] 10:50:30 SchemaExport - Error on rename of './broadleaf/BLC_FLD_DEF' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:30 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FLD_ENUM_ITEM drop foreign key FK83A6A84AFD2EA299
[artifact:mvn] [ERROR] 10:50:30 SchemaExport - Error on rename of './broadleaf/BLC_FLD_ENUM_ITEM' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:30 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FULFILLMENT_GROUP drop foreign key FKC5B9EF18C13085DD
[artifact:mvn] [ERROR] 10:50:30 SchemaExport - Error on rename of './broadleaf/BLC_FULFILLMENT_GROUP' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:30 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FULFILLMENT_GROUP drop foreign key FKC5B9EF1881F34C7F
[artifact:mvn] [ERROR] 10:50:30 SchemaExport - Error on rename of './broadleaf/BLC_FULFILLMENT_GROUP' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:30 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FULFILLMENT_GROUP drop foreign key FKC5B9EF1889FE8A02
[artifact:mvn] [ERROR] 10:50:30 SchemaExport - Error on rename of './broadleaf/BLC_FULFILLMENT_GROUP' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:31 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FULFILLMENT_GROUP drop foreign key FKC5B9EF1877F565E1
[artifact:mvn] [ERROR] 10:50:31 SchemaExport - Error on rename of './broadleaf/BLC_FULFILLMENT_GROUP' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:50:31 SchemaExport - HHH000389: Unsuccessful: alter table BLC_FULFILLMENT_GROUP drop foreign key FKC5B9EF18D894CB5D
[artifact:mvn] [ERROR] 10:50:31 SchemaExport - Error on rename of './broadleaf/BLC_FULFILLMENT_GROUP' to './broadleaf/#sql2-3c6-2e' (errno: 152)
[artifact:mvn] [ERROR] 10:55:03 Ejb3Configuration - HHH000050: Container is providing a null PersistenceUnitRootUrl: discovery impossible
[artifact:mvn] [ WARN] 10:55:04 Ejb3Configuration - HHH000144: hibernate.connection.autocommit = false breaks the EJB3 specification
[artifact:mvn] [ERROR] 10:55:04 Ejb3Configuration - HHH000050: Container is providing a null PersistenceUnitRootUrl: discovery impossible
[artifact:mvn] [ WARN] 10:55:04 Ejb3Configuration - HHH000144: hibernate.connection.autocommit = false breaks the EJB3 specification
[artifact:mvn] [ WARN] 10:55:09 CoreContainer - Log watching is not yet implemented for log4j
[artifact:mvn] [ WARN] 10:55:09 SolrCore - New index directory detected: old=null new=/tmp/aspire17/solrhome/core0dir/data/index/
[artifact:mvn] [ WARN] 10:55:09 SolrCore - [primary] Solr index directory '/tmp/aspire17/solrhome/core0dir/data/index' doesn't exist. Creating new index...
[artifact:mvn] [ WARN] 10:55:10 SolrCore - New index directory detected: old=null new=/tmp/aspire17/solrhome/core1dir/data/index/
[artifact:mvn] [ WARN] 10:55:10 SolrCore - [reindex] Solr index directory '/tmp/aspire17/solrhome/core1dir/data/index' doesn't exist. Creating new index...
[artifact:mvn] 2013-06-04 10:55:14.926:INFO:oejsh.ContextHandler:started o.m.j.p.JettyWebAppContext{/,file:/home/aspire17/Ankit/workspace/Broadleaf/DemoSite/site/target/mycompany/},file:/home/aspire17/Ankit/workspace/Broadleaf/DemoSite/site/target/mycompany/
[artifact:mvn] 2013-06-04 10:55:15.030:INFO:/:Initializing Spring FrameworkServlet 'mycompany'
[artifact:mvn] 2013-06-04 10:55:19.444:INFO:oejs.AbstractConnector:Started SelectChannelConnector@0.0.0.0:8080
[artifact:mvn] [INFO] Started Jetty Server
[artifact:mvn] 2013-06-04 10:55:19.930:INFO:oejus.SslContextFactory:Enabled Protocols [SSLv2Hello, SSLv3, TLSv1] of [SSLv2Hello, SSLv3, TLSv1]
[artifact:mvn] 2013-06-04 10:55:19.933:INFO:oejs.AbstractConnector:Started SslSelectChannelConnector@0.0.0.0:8443
Demo-site is running good after starting the server, but all the db tables are recreated.
Am I missing something ?
Thanks,
Ankit