category-service_1  | 12.03 11:27:14.039 ERROR [SqlExceptionHelper:131] - Batch entry 0 insert into coupon_category (area_effect, create_date, description, end_date, name, start_date, type, update_date, id) values ('RECEIPT', '2019-03-12 11:27:14.034+03', 'Заполним только необходимые поля ', '2019-01-25 10:56:31.172+03', '222Заполним только необходимые поля 25819c8a-a977-48ef-9a5d-abba4ef2ab07', '2019-01-24 10:56:31.172+03', 'UNIQUE', NULL, 102) was aborted: ERROR: duplicate key value violates unique constraint "pk_coupon_category_key"
category-service_1  |   Detail: Key (id)=(102) already exists.  Call getNextException to see other errors in the batch.
category-service_1  | 12.03 11:27:14.040 WARN [SqlExceptionHelper:129] - SQL Error: 0, SQLState: 23505
category-service_1  | 12.03 11:27:14.040 ERROR [SqlExceptionHelper:131] - ERROR: duplicate key value violates unique constraint "pk_coupon_category_key"
category-service_1  |   Detail: Key (id)=(102) already exists.
category-service_1  | 12.03 11:27:14.040 ERROR [ExceptionMapperStandardImpl:39] - HHH000346: Error during managed flush [org.hibernate.exception.ConstraintViolationException: could not execute batch]
category-service_1  | 12.03 11:27:14.042 ERROR [DirectJDKLog:182] - Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException: could not execute batch; SQL [insert into coupon_category (area_effect, create_date, description, end_date, name, start_date, type, update_date, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?)]; constraint [pk_coupon_category_key]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute batch] with root cause
category-service_1  | org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "pk_coupon_category_key"
category-service_1  |   Detail: Key (id)=(102) already exists.
category-service_1  |   at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2433)
category-service_1  |   at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2178)
category-service_1  |   at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:479)
category-service_1  |   at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:835)
category-service_1  |   at org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1556)
category-service_1  |   at com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:128)
category-service_1  |   at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java)
category-service_1  |   at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:118)
category-service_1  |   at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:104)
category-service_1  |   at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:147)
category-service_1  |   at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcCoordinatorImpl.java:212)
category-service_1  |   at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:629)
category-service_1  |   at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:474)
category-service_1  |   at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:337)
category-service_1  |   at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)
category-service_1  |   at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1437)
category-service_1  |   at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:494)
category-service_1  |   at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3245)
category-service_1  |   at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2451)
category-service_1  |   at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:473)
category-service_1  |   at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:156)
category-service_1  |   at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$100(JdbcResourceLocalTransactionCoordinatorImpl.java:38)
category-service_1  |   at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:231)
category-service_1  |   at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:68)
category-service_1  |   at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:536)
category-service_1  |   at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:746)
category-service_1  |   at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:714)
category-service_1  |   at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:532)
category-service_1  |   at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:304)
category-service_1  |   at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
category-service_1  |   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
category-service_1  |   at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
category-service_1  |   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
category-service_1  |   at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:135)
category-service_1  |   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
category-service_1  |   at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
category-service_1  |   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
category-service_1  |   at org.springframework.data.repository.core.support.SurroundingTransactionDetectorMethodInterceptor.invoke(SurroundingTransactionDetectorMethodInterceptor.java:61)
category-service_1  |   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
category-service_1  |   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
category-service_1  |   at com.sun.proxy.$Proxy147.save(Unknown Source)
category-service_1  |   at ru.crystals.processing.coupons.category.service.CategoryService.createCategory(CategoryService.java:47)
category-service_1  |   at ru.crystals.processing.coupons.category.controller.v1.CategoryController.create(CategoryController.java:32)
category-service_1  |   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
category-service_1  |   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
category-service_1  |   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
category-service_1  |   at java.lang.reflect.Method.invoke(Method.java:498)
category-service_1  |   at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:209)
category-service_1  |   at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)
category-service_1  |   at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)
category-service_1  |   at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:877)
category-service_1  |   at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:783)
category-service_1  |   at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
category-service_1  |   at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:991)
category-service_1  |   at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:925)
category-service_1  |   at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:974)
category-service_1  |   at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:877)
category-service_1  |   at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
category-service_1  |   at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:851)
category-service_1  |   at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
category-service_1  |   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
category-service_1  |   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
category-service_1  |   at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
category-service_1  |   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
category-service_1  |   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
category-service_1  |   at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.filterAndRecordMetrics(WebMvcMetricsFilter.java:158)
category-service_1  |   at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.filterAndRecordMetrics(WebMvcMetricsFilter.java:126)
category-service_1  |   at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:111)
category-service_1  |   at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
category-service_1  |   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
category-service_1  |   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
category-service_1  |   at org.springframework.boot.actuate.web.trace.servlet.HttpTraceFilter.doFilterInternal(HttpTraceFilter.java:84)
category-service_1  |   at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
category-service_1  |   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
category-service_1  |   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
category-service_1  |   at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
category-service_1  |   at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
category-service_1  |   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
category-service_1  |   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
category-service_1  |   at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:109)
category-service_1  |   at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
category-service_1  |   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
category-service_1  |   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
category-service_1  |   at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81)
category-service_1  |   at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
category-service_1  |   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
category-service_1  |   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
category-service_1  |   at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
category-service_1  |   at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
category-service_1  |   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
category-service_1  |   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
category-service_1  |   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
category-service_1  |   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
category-service_1  |   at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:496)
category-service_1  |   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
category-service_1  |   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
category-service_1  |   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
category-service_1  |   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
category-service_1  |   at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803)
category-service_1  |   at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
category-service_1  |   at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790)
category-service_1  |   at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1468)
category-service_1  |   at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
category-service_1  |   at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
category-service_1  |   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
category-service_1  |   at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
category-service_1  |   at java.lang.Thread.run(Thread.java:748)