Below is ofbiz and mysql version which I am using.
1. apache-ofbiz-13.07.02
2. mysql-community-server-5.7.9
3. mysql-connector-java-5.1.6.jar
I follow the same step provided from this link
https://cwiki.apache.org/confluence/display/OFBIZ/How+to+migrate+OfBiz+from+Derby+to+MySQL+database . When I run "./ant load-demo", and error happen.
Below is the error message:
There are more than 1 create index error message, I just post 2 of that error message.
………
2015-12-05 18:36:51,487 |source(localmysql)-0 |DatabaseUtil |E| Could not create foreign key indices for entity [GlReconciliationEntry]: SQL Exception while executing the following:
CREATE INDEX GL_RECENT_ACTTXE ON GL_RECONCILIATION_ENTRY (ACCTG_TRANS_ID, ACCTG_TRANS_ENTRY_SEQ_ID)
Error was: java.sql.SQLException: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use ‘ulimit’ to allow mysqld to use more memory or you can add more swap space
2015-12-05 18:36:52,681 |source(localmysql)-0 |DatabaseUtil |E| Could not create foreign key indices for entity [GoodIdentification]: SQL Exception while executing the following:
CREATE INDEX GOOD_ID_TYPE ON GOOD_IDENTIFICATION (GOOD_IDENTIFICATION_TYPE_ID)
Error was: java.sql.SQLException: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use ‘ulimit’ to allow mysqld to use more memory or you can add more swap space
………
However, at the end of the process is pending non-stop while it able to create few foreign key indices as below.
………
2015-12-05 18:56:57,000 |source(localmysql)-0 |DatabaseUtil |I| Created 2 foreign key indices for entity [OrderHeaderNote]
2015-12-05 18:57:13,980 |source(localmysql)-0 |DatabaseUtil |I| Created 2 foreign key indices for entity [OrderHeaderWorkEffort]
2015-12-05 18:59:08,164 |source(localmysql)-0 |DatabaseUtil |I| Created 13 foreign key indices for entity [OrderItem]
……….
This process is pending more than 8 hours.
Locked
