Skip to content

Instantly share code, notes, and snippets.

View ptahchiev's full-sized avatar

Petar Tahchiev ptahchiev

View GitHub Profile
Caused by: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '570815759038240-5985290002' for key 'product.UKg8rqvkpg874jadtsmf6y8yqx8'
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:117)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1092)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchSerially(ClientPreparedStatement.java:832)
... 347 more
2021-06-08 07:42:18,221 io.nemesis.platform.core.mapper.catalog.SyncMappingContext [NemesisClusteredScheduler_Worker-5] ERROR: org.hibernate.exception.ConstraintViolationException: could not execute batch
javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationExcep
2021-01-15 11:06:46,981 io.nemesis.platform.core.batch.listener.NemesisChunkLoggingListener [search-export-4] INFO : ------------------------------------------------------------
2021-01-15 11:06:46,981 io.nemesis.platform.core.batch.listener.NemesisChunkLoggingListener [search-export-4] INFO : 200 product search export processed
2021-01-15 11:06:46,981 io.nemesis.platform.core.batch.listener.NemesisChunkLoggingListener [search-export-4] INFO : ------------------------------------------------------------
2021-01-15 11:06:47,016 org.springframework.batch.core.step.tasklet.TaskletStep [search-export-1] ERROR: Rolling back with transaction in unknown state
2021-01-15 11:06:47,016 org.springframework.orm.jpa.EntityManagerFactoryUtils [search-export-1] ERROR: Failed to release JPA EntityManager
java.lang.NullPointerException
at org.hibernate.engine.internal.StatefulPersistenceContext.clear(StatefulPersistenceContext.java:236)
at org.hibernate.internal.SessionImpl.cleanupOnClose(SessionImpl.java:532)
at org.
[{"ids_kat_tree":1,"kat_tree_name_bg":"root","kat_tree_name_en":"","kat_tree_code":"214","kat_tree_active":true,"order":1,"ids_parent":0},{"ids_kat_tree":2,"kat_tree_name_bg":"Плочки","kat_tree_name_en":"","kat_tree_code":"01","kat_tree_active":true,"order":1,"ids_parent":1},{"ids_kat_tree":3,"kat_tree_name_bg":"Теракот","kat_tree_name_en":"","kat_tree_code":"012","kat_tree_active":true,"order":2,"ids_parent":2},{"ids_kat_tree":4,"kat_tree_name_bg":"Гранитогрес","kat_tree_name_en":"","kat_tree_code":"011","kat_tree_active":true,"order":1,"ids_parent":2},{"ids_kat_tree":5,"kat_tree_name_bg":"Фаянс","kat_tree_name_en":"","kat_tree_code":"013","kat_tree_active":true,"order":3,"ids_parent":2},{"ids_kat_tree":6,"kat_tree_name_bg":"Декор","kat_tree_name_en":"","kat_tree_code":"014","kat_tree_active":true,"order":4,"ids_parent":2},{"ids_kat_tree":7,"kat_tree_name_bg":"Санитарен порцелан","kat_tree_name_en":"","kat_tree_code":"02","kat_tree_active":true,"order":2,"ids_parent":1},{"ids_kat_tree":8,"kat_tree_name_bg":"
2020-07-17 00:15:20,195 com.zaxxer.hikari.pool.ProxyLeakTask [samplestoreDB housekeeper] WARN : Connection leak detection triggered for com.mysql.cj.jdbc.ConnectionImpl@3003fa2 on thread platform-batch-2, stack trace follows
java.lang.Exception: Apparent connection leak detected
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
at org.springframework.jdbc.datasource.lookup.AbstractRoutingDataSource.getConnection(AbstractRoutingDataSource.java:170)
at org.hibernate.engine.jdbc.connections.spi.AbstractDataSourceBasedMultiTenantConnectionProviderImpl.getConnection(AbstractDataSourceBasedMultiTenantConnectionProviderImpl.java:35)
at org.hibernate.internal.ContextualJdbcConnectionAccess.obtainConnection(ContextualJdbcConnectionAccess.java:43)
at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:104)
at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.getPhysicalConnection(LogicalConnecti
@ptahchiev
ptahchiev / gist:1c4bfaf3d70ca7b7f4fc5ffb0b827663
Created July 16, 2020 07:53
Connection is not available
FD4398A8AE7524B840FFBB7B05CF3224 2020-07-16 07:51:48,811 com.nemesis.platform.module.restservices.facade.impl.EntityFacadeImpl [https-jsse-nio-0.0.0.0-8112-exec-1] ERROR: org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction; nested exception is org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection
java.util.concurrent.ExecutionException: org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction; nested exception is org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection
at java.base/java.util.concurrent.FutureTask.report(FutureTask.java:122)
at java.base/java.util.concurrent.FutureTask.get(FutureTask.java:205)
at com.nemesis.platform.module.restservices.facade.impl.EntityFacadeImpl.getAllEntitySearchMarkups(EntityFacadeImpl.java:338)
at com.nemesis.platform.module.restservices.facade.impl.EntityFacadeImpl$$FastClassBySpringCGLIB$$a5d
<?xml version="1.0" encoding="UTF-8"?>
<definitions id="cashback" name="Cashback points"
namespace="https://www.drools.org/kie-dmn"
xmlns="http://www.omg.org/spec/DMN/20151101/dmn.xsd"
xmlns:kie="https://www.drools.org/kie-dmn"
xmlns:feel="http://www.omg.org/spec/FEEL/20140401"
xmlns:biodi="http://bpmn.io/schema/dmn/biodi/1.0">
<inputData id="InputData_1jm0c5f" name="Order Total">
<extensionElements>
<biodi:bounds x="-412" y="414" width="125" height="45" />
[INFO] --- frontend-maven-plugin:1.4:yarn (yarn install) @ nemesis-console-v2 ---
[INFO] Running 'yarn install' in /mnt/e/webdemo/nemesis-console-v2-master/src/main/frontend
[ERROR] /mnt/e/webdemo/nemesis-console-v2-master/target/node/yarn/dist/bin/yarn: 15: /mnt/e/webdemo/nemesis-console-v2-master/target/node/yarn/dist/bin/yarn: [[: not found
[INFO] yarn install v0.24.0
[INFO] [1/4] Resolving packages...
[INFO] [2/4] Fetching packages...
[ERROR] warning fsevents@1.0.17: The platform "linux" is incompatible with this module.
[INFO] info "fsevents@1.0.17" is an optional dependency and failed compatibility check. Excluding it from installation.
[ERROR] warning fsevents@1.1.2: The platform "linux" is incompatible with this module.
[INFO] info "fsevents@1.1.2" is an optional dependency and failed compatibility check. Excluding it from installation.
@ptahchiev
ptahchiev / gist:b4fd27fb8e80040900c5c8657a721d03
Created February 20, 2019 15:12
MessageSourceProperty.equals
Hibernate:
/* select
messageSourcePropertyEntity
from
message_source_property messageSourcePropertyEntity
left join
messageSourcePropertyEntity.description as messageSourcePropertyEntity_description_0 with key(messageSourcePropertyEntity_description_0) = ?1
where
messageSourcePropertyEntity_description_0.value = ?2 */ select
messagesou0_.id as id1_119_,
@ptahchiev
ptahchiev / gist:4d0563d3c1ef7863c1ba06577ef4d627
Created February 20, 2019 15:09
msp.description contains
Hibernate:
/* select
messageSourcePropertyEntity
from
message_source_property messageSourcePropertyEntity
left join
messageSourcePropertyEntity.description as messageSourcePropertyEntity_description_0 with key(messageSourcePropertyEntity_description_0) = ?1
where
locate(?2,messageSourcePropertyEntity_description_0.value)-1 >= ?3 */ select
messagesou0_.id as id1_119_,
2018-11-28 11:27:09,954 [main] WARN : SQL Error: 23505, SQLState: 23505
2018-11-28 11:27:09,954 [main] ERROR: Unique index or primary key violation: "UKFTA2GXFMD8NXPDVU2BFAJ41AT_INDEX_E ON PUBLIC.CMS_TEMPLATE(CATALOG_VERSION_ID, CODE) VALUES (565844515286192, 'testThymeleafTemplate', 42505637343650864)"; SQL statement:
update cms_template set code=?, created_by=?, created_date=?, last_modified_by=?, last_modified_date=?, catalog_version_id=?, css_classes=?, frontendtemplatename=?, name=?, style=? where id=? [23505-197]
2018-11-28 11:27:09,957 [main] ERROR: org.hibernate.exception.ConstraintViolationException: could not execute statement
javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:149)
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:157)
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverte