devsparkles
commented
4 years ago Just to say that the problem is still there
2020-07-10 21:34:09.500 DEBUG 79728 --- [ restartedMain] c.devsparkle.config.CacheConfiguration : Starting HazelcastCacheManager 2020-07-10 21:34:10.314 ERROR 79728 --- [ store-task-1] liquibase.changelog.ChangeSet : Change Set config/liquibase/changelog/20200710202847_added_entity_Customer.xml::20200710202847-1-data::jhipster failed. Error: org.h2.jdbc.JdbcBatchUpdateException: Unique index or primary key violation: "PUBLIC.UX_CUSTOMER_USER_ID_INDEX_5 ON PUBLIC.CUSTOMER(USER_ID) VALUES 2"; SQL statement: INSERT INTO PUBLIC.customer(id, first_name, last_name, gender, email, phone, address_line_1, address_line_2, city, country, user_id) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [23505-200] 2020-07-10 21:34:10.319 ERROR 79728 --- [ store-task-1] i.g.j.c.liquibase.AsyncSpringLiquibase : Liquibase could not start correctly, your database is NOT ready: Migration failed for change set config/liquibase/changelog/20200710202847_added_entity_Customer.xml::20200710202847-1-data::jhipster: Reason: liquibase.exception.DatabaseException: org.h2.jdbc.JdbcBatchUpdateException: Unique index or primary key violation: "PUBLIC.UX_CUSTOMER_USER_ID_INDEX_5 ON PUBLIC.CUSTOMER(USER_ID) VALUES 2"; SQL statement: INSERT INTO PUBLIC.customer(id, first_name, last_name, gender, email, phone, address_line_1, address_line_2, city, country, user_id) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [23505-200]
liquibase.exception.MigrationFailedException: Migration failed for change set config/liquibase/changelog/20200710202847_added_entity_Customer.xml::20200710202847-1-data::jhipster: Reason: liquibase.exception.DatabaseException: org.h2.jdbc.JdbcBatchUpdateException: Unique index or primary key violation: "PUBLIC.UX_CUSTOMER_USER_ID_INDEX_5 ON PUBLIC.CUSTOMER(USER_ID) VALUES 2"; SQL statement: INSERT INTO PUBLIC.customer(id, first_name, last_name, gender, email, phone, address_line_1, address_line_2, city, country, user_id) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [23505-200] at liquibase.changelog.ChangeSet.execute(ChangeSet.java:646) at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:53) at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:83) at liquibase.Liquibase.update(Liquibase.java:202) at liquibase.Liquibase.update(Liquibase.java:179) at liquibase.integration.spring.SpringLiquibase.performUpdate(SpringLiquibase.java:366) at liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:314) at org.springframework.boot.autoconfigure.liquibase.DataSourceClosingSpringLiquibase.afterPropertiesSet(DataSourceClosingSpringLiquibase.java:46) at io.github.jhipster.config.liquibase.AsyncSpringLiquibase.initDb(AsyncSpringLiquibase.java:118) at io.github.jhipster.config.liquibase.AsyncSpringLiquibase.lambda$afterPropertiesSet$0(AsyncSpringLiquibase.java:93) at io.github.jhipster.async.ExceptionHandlingAsyncTaskExecutor.lambda$createWrappedRunnable$1(ExceptionHandlingAsyncTaskExecutor.java:78) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:834) Caused by: liquibase.exception.DatabaseException: org.h2.jdbc.JdbcBatchUpdateException: Unique index or primary key violation: "PUBLIC.UX_CUSTOMER_USER_ID_INDEX_5 ON PUBLIC.CUSTOMER(USER_ID) VALUES 2"; SQL statement: INSERT INTO PUBLIC.customer(id, first_name, last_name, gender, email, phone, address_line_1, address_line_2, city, country, user_id) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [23505-200] at liquibase.statement.ExecutablePreparedStatementBase.execute(ExecutablePreparedStatementBase.java:87) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:117) at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1276) at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1258) at liquibase.changelog.ChangeSet.execute(ChangeSet.java:609) ... 13 common frames omitted Caused by: org.h2.jdbc.JdbcBatchUpdateException: Unique index or primary key violation: "PUBLIC.UX_CUSTOMER_USER_ID_INDEX_5 ON PUBLIC.CUSTOMER(USER_ID) VALUES 2"; SQL statement: INSERT INTO PUBLIC.customer(id, first_name, last_name, gender, email, phone, address_line_1, address_line_2, city, country, user_id) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [23505-200] at org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1235) at com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:128) at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java) at liquibase.statement.BatchDmlExecutablePreparedStatement.executePreparedStatement(BatchDmlExecutablePreparedStatement.java:65) at liquibase.statement.ExecutablePreparedStatementBase.execute(ExecutablePreparedStatementBase.java:85) ... 17 common frames omitted
2020-07-10 21:34:10.702 DEBUG 79728 --- [ restartedMain] c.d.config.DatabaseConfiguration : H2 database is available on port 18080
Here is my JDL export to generate the project
application {
config {
applicationType monolith
authenticationType jwt
baseName store
blueprints []
buildTool gradle
cacheProvider hazelcast
clientFramework angularX
clientPackageManager npm
clientTheme none
creationTimestamp 1593596133788
databaseType sql
devDatabaseType h2Disk
dtoSuffix DTO
embeddableLaunchScript false
enableHibernateCache true
enableSwaggerCodegen false
enableTranslation true
jhiPrefix jhi
jhipsterVersion "6.10.0"
jwtSecretKey "Zjg1ODZhNmE2ZTk0YTdkZjc1Y2IyOTJmYjU3ZmNlMTM2YmM4OTVhNTc1M2Q3YjdjY2Y0YmQ2MDc1NDMyNDQ0NDBkZjgwNmE0NTBjNmI5NjZkOTA2MWJkMzljYWVkOTc3ZjJhOWFmNzZkOGVjYzczYTJmNTc0MmRjY2JiNTJkYjY="
languages [en]
messageBroker false
nativeLanguage en
otherModules []
packageName com.devsparkle
prodDatabaseType mysql
searchEngine false
serverPort 8080
serviceDiscoveryType false
skipClient false
skipServer false
skipUserManagement false
testFrameworks [protractor]
useSass true
websocket spring-websocket
}
entities Customer, Invoice, OrderItem, Product, ProductCategory, ProductOrder, Shipment
}
entity Customer {
firstName String required,
lastName String required,
gender Gender required,
email String required pattern(/^[^@\s]+@[^@\s]+\.[^@\s]+$/),
phone String required,
addressLine1 String required,
addressLine2 String,
city String required,
country String required
}
entity Invoice {
date Instant required,
details String,
status InvoiceStatus required,
paymentMethod PaymentMethod required,
paymentDate Instant required,
paymentAmount BigDecimal required,
code String required
}
entity OrderItem {
quantity Integer required min(0),
totalPrice BigDecimal required min(0),
status OrderItemStatus required
}
entity Product {
name String required,
description String,
price BigDecimal required min(0),
size Size required,
image ImageBlob
}
entity ProductCategory {
name String required,
description String
}
entity ProductOrder {
placedDate Instant required,
status OrderStatus required,
code String required
}
entity Shipment {
trackingCode String,
date Instant required,
details String
}
enum Gender {
MALE,
FEMALE,
OTHER
}
enum InvoiceStatus {
PAID,
ISSUED,
CANCELLED
}
enum PaymentMethod {
CREDIT_CARD,
CASH_ON_DELIVERY,
PAYPAL
}
enum OrderItemStatus {
AVAILABLE,
OUT_OF_STOCK,
BACK_ORDER
}
enum Size {
S,
M,
L,
XL,
XXL
}
enum OrderStatus {
COMPLETED,
PENDING,
CANCELLED
}
relationship OneToOne {
Customer{user(login) required} to User
}
relationship OneToMany {
ProductOrder{invoice} to Invoice{order(code) required},
ProductOrder{orderItem} to OrderItem{order(code) required},
ProductCategory{product} to Product{productCategory(name)},
Customer{order} to ProductOrder{customer(email) required},
Invoice{shipment} to Shipment{invoice(code) required}
}
relationship ManyToOne {
OrderItem{product(name) required} to Product
}
paginate Customer, Invoice, OrderItem, Product, ProductOrder, Shipment with pagination
service Customer, Invoice, OrderItem, Product, ProductCategory, ProductOrder, Shipment with serviceClass
jhipster --version 6.10.0 java --version openjdk 11.0.7 2020-04-14 OpenJDK Runtime Environment AdoptOpenJDK (build 11.0.7+10) OpenJDK 64-Bit Server VM AdoptOpenJDK (build 11.0.7+10, mixed mode)
pmverma
Overview of the issue
For my Angular / H2 monolith, jHipster generates fake data which doesn't honor the
uniqueconstraint on myShipmententity. Liquibase fails to load the fake data for this entity.order_idcolumn (second from right) has4three times and9twice.Here is the stacktrace:
Motivation for or Use Case
I have a valid JDL file that jHipster imports without reporting an error. However, the generated fake data is wrong and prevents the application from running correctly.
Reproduce the error
./gradlewto start the application.Related issues
9721: This bug is about wrong columns in the fake data. However, I actually mentioned the unique violation described here in a comment.
Suggest a Fix
JHipster Version(s)
JHipster 6.1.2, Java 11
JHipster configuration
JHipster configuration, a
.yo-rc.jsonfile generated in the root folder.yo-rc.json file
{ "generator-jhipster": { "databaseType": "sql", "devDatabaseType": "h2Disk", "enableHibernateCache": true, "enableSwaggerCodegen": false, "enableTranslation": true, "jhiPrefix": "bpf", "languages": ["en", "de"], "messageBroker": false, "nativeLanguage": "en", "packageName": "com.betterprojectsfaster.tutorial.jhipsterdocker", "packageFolder": "com/betterprojectsfaster/tutorial/jhipsterdocker", "prodDatabaseType": "postgresql", "searchEngine": false, "serviceDiscoveryType": false, "skipClient": false, "skipServer": false, "testFrameworks": ["protractor"], "websocket": "spring-websocket", "baseName": "my_simple_shop", "applicationType": "monolith", "authenticationType": "jwt", "buildTool": "gradle", "cacheProvider": "ehcache", "clientFramework": "angularX", "useSass": true, "clientPackageManager": "npm", "jhipsterVersion": "6.1.2", "skipUserManagement": false, "serverPort": "8080", "jwtSecretKey": "bXktc2VjcmV0LXRva2VuLXRvLWNoYW5nZS1pbi1wcm9kdWN0aW9uLWFuZC10by1rZWVwLWluLWEtc2VjdXJlLXBsYWNl", "clientTheme": "none", "entitySuffix": "", "dtoSuffix": "DTO", "otherModules": [] }, "entities": ["Product", "Address", "ShoppingOrder", "ProductOrder", "Shipment"] }JDL for the Entity configuration(s)
entityName.jsonfiles generated in the.jhipsterdirectoryJDL entity definitions
entity Product { name String required unique minlength(2) maxlength(90), price Float required min(0), description TextBlob required, picture ImageBlob required, specification AnyBlob, category ProductCategory, inventory Integer required min(0) } entity Address { addressLine1 String required minlength(2) maxlength(80), addressLine2 String minlength(2) maxlength(80), city String minlength(2) maxlength(80), postalCode String minlength(5) maxlength(5) } entity ShoppingOrder { name String required unique minlength(2) maxlength(90), totalAmount Float min(0), ordered ZonedDateTime } entity ProductOrder { amount Integer required min(0) max(5) } entity Shipment { shippedAt ZonedDateTime required } enum ProductCategory { Laptop, Desktop, Phone, Tablet, Accessory } relationship OneToOne { Shipment{order(name) required} to ShoppingOrder{shipment required} } relationship OneToMany { Product{order required} to ProductOrder{product(name) required}, ShoppingOrder{orders required} to ProductOrder{overallOrder(name)} } relationship ManyToOne { Address{user(login) required} to User, ShoppingOrder{buyer(login) required} to User, ProductOrder{buyer(login) required} to User, Shipment{shippedBy(login) required} to User } dto Product, Address, ShoppingOrder, ProductOrder, Shipment with mapstruct service Product, Address, ShoppingOrder, ProductOrder, Shipment with serviceClassEnvironment and Tools
openjdk version "11.0.3" 2019-04-16 OpenJDK Runtime Environment AdoptOpenJDK (build 11.0.3+7) OpenJDK 64-Bit Server VM AdoptOpenJDK (build 11.0.3+7, mixed mode)
git version 2.22.0
node: v10.15.3
npm: 6.9.0
yeoman: 2.0.6
Docker version 18.09.2, build 6247962
docker-compose version 1.23.2, build 1110ad01
Entity configuration(s)
entityName.jsonfiles generated in the.jhipsterdirectoryShipment.jsonBrowsers and Operating System
macOS Mojave 10.14.4, Safari