When I use H2 in-memory DB, the demo data gets generated and processed successfully and very fast. But when I switch to a MySQL DB the orders data does not get generated fully and server hangs. I tried various combinations and tweaked the randomizer to generate very few values but same issue persists. Then I ran it in debug mode and added breakpoints and traced thru the code. This time it worked. But in release mode it still hangs.. Is there some timing issue here? Any tips?
* snippet of stack trace below **
2018-06-27 11:07:57.100 INFO 3140 --- [ main] o.hibernate.annotations.common.Version : HCANN000001: Hibernate Commons Annotations {5.0.1.Final}
2018-06-27 11:07:57.446 INFO 3140 --- [ main] org.hibernate.dialect.Dialect : HHH000400: Using dialect: org.hibernate.dialect.MySQL5Dialect
2018-06-27 11:08:05.886 INFO 3140 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2018-06-27 11:08:07.311 INFO 3140 --- [ main] o.h.h.i.QueryTranslatorFactoryInitiator : HHH000397: Using ASTQueryTranslatorFactory
2018-06-27 11:08:08.023 INFO 3140 --- [ main] com.gmail.nitin.app.DataGenerator : Generating demo data
2018-06-27 11:08:08.023 INFO 3140 --- [ main] com.gmail.nitin.app.DataGenerator : ... generating users
2018-06-27 11:08:09.516 INFO 3140 --- [ main] com.gmail.nitin.app.DataGenerator : ... generating documents
2018-06-27 11:08:09.849 INFO 3140 --- [ main] com.gmail.nitin.app.DataGenerator : ... generating pickup locations
2018-06-27 11:08:10.182 INFO 3140 --- [ main] com.gmail.nitin.app.DataGenerator : ... generating orders
When I use H2 in-memory DB, the demo data gets generated and processed successfully and very fast. But when I switch to a MySQL DB the orders data does not get generated fully and server hangs. I tried various combinations and tweaked the randomizer to generate very few values but same issue persists. Then I ran it in debug mode and added breakpoints and traced thru the code. This time it worked. But in release mode it still hangs.. Is there some timing issue here? Any tips?
* snippet of stack trace below **
2018-06-27 11:07:57.100 INFO 3140 --- [ main] o.hibernate.annotations.common.Version : HCANN000001: Hibernate Commons Annotations {5.0.1.Final} 2018-06-27 11:07:57.446 INFO 3140 --- [ main] org.hibernate.dialect.Dialect : HHH000400: Using dialect: org.hibernate.dialect.MySQL5Dialect 2018-06-27 11:08:05.886 INFO 3140 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default' 2018-06-27 11:08:07.311 INFO 3140 --- [ main] o.h.h.i.QueryTranslatorFactoryInitiator : HHH000397: Using ASTQueryTranslatorFactory 2018-06-27 11:08:08.023 INFO 3140 --- [ main] com.gmail.nitin.app.DataGenerator : Generating demo data 2018-06-27 11:08:08.023 INFO 3140 --- [ main] com.gmail.nitin.app.DataGenerator : ... generating users 2018-06-27 11:08:09.516 INFO 3140 --- [ main] com.gmail.nitin.app.DataGenerator : ... generating documents 2018-06-27 11:08:09.849 INFO 3140 --- [ main] com.gmail.nitin.app.DataGenerator : ... generating pickup locations 2018-06-27 11:08:10.182 INFO 3140 --- [ main] com.gmail.nitin.app.DataGenerator : ... generating orders