{"@timestamp":"2020-04-01T11:49:53.805+00:00","@version":1,"message":"Error while processing: ConsumerRecord(topic = order.po-draft-status-changed, partition = 0, offset = 314, CreateTime = 1585741790774, serialized key size = 36, serialized value size = 221, headers = RecordHeaders(headers = [RecordHeader(key = contentType, value = [34, 97, 112, 112, 108, 105, 99, 97, 116, 105, 111, 110, 47, 106, 115, 111, 110, 34]), RecordHeader(key = spring_json_header_types, value = [123, 34, 99, 111, 110, 116, 101, 110, 116, 84, 121, 112, 101, 34, 58, 34, 106, 97, 118, 97, 46, 108, 97, 110, 103, 46, 83, 116, 114, 105, 110, 103, 34, 125])], isReadOnly = false), key = d82650f2-b6c0-40ae-a403-eb2f9813781b, value = {\"info\":{\"version\":\"1.0\",\"uuid\":\"cb208122-a88a-488c-98ea-e97849e511a5\",\"started_at\":\"2020-04-01T11:49:50.765Z\"},\"data\":{\"type\":\"order-status-changed\",\"order_uuid\":\"25bd0f84-8907-44e6-b6b6-eeacfc8b8e7e\",\"status\":\"FORMED\"}})","logger_name":"org.springframework.kafka.listener.LoggingErrorHandler","thread_name":"[Ljava.lang.String;@4d7fba20.container-0-C-1","level":"ERROR","level_value":40000,"stack_trace":"org.springframework.messaging.MessagingException: Exception thrown while invoking online.oboz.order.draft_to_order_creator.presentation.listener.QueueListener#processTransition[1 args]; nested exception is org.springframework.jdbc.UncategorizedSQLException: jOOQ; uncategorized SQLException for SQL [select \"draft_order\".\"orders\".\"uuid\", \"draft_order\".\"orders\".\"creator_uuid\", \"draft_order\".\"orders\".\"author_uuid\", \"draft_order\".\"orders\".\"client_uuid\", \"draft_order\".\"orders\".\"contractor_uuid\", \"draft_order\".\"orders\".\"logist_uuid\", \"draft_order\".\"orders\".\"number\", \"draft_order\".\"orders\".\"external_number\", \"draft_order\".\"orders\".\"type\", \"draft_order\".\"orders\".\"species\", \"draft_order\".\"orders\".\"risk_color\", \"draft_order\".\"orders\".\"accepted_carrier_colors\", \"draft_order\".\"orders\".\"transportation_way\", \"draft_order\".\"orders\".\"need_tracking\", \"draft_order\".\"orders\".\"is_dangerous\", \"draft_order\".\"orders\".\"resource_class_uuid\", \"draft_order\".\"orders\".\"resource_species_uuid\", \"draft_order\".\"orders\".\"resource_type_uuid\", \"draft_order\".\"orders\".\"number_of_vehicles\", \"draft_order\".\"orders\".\"temperature_regime_uuid\", \"draft_order\".\"orders\".\"cargo_type_uuid\", \"draft_order\".\"orders\".\"cargo_insurance_cost\", \"draft_order\".\"orders\".\"cargo_insurance_currency\", \"draft_order\".\"orders\".\"cargo_weight_in_kg\", \"draft_order\".\"orders\".\"volume_in_cubic_meters\", \"draft_order\".\"orders\".\"accounting_type\", \"draft_order\".\"orders\".\"pallet_count\", \"draft_order\".\"orders\".\"freight_unit_count\", \"draft_order\".\"orders\".\"freight_forwarding_unit_uuid\", \"draft_order\".\"orders\".\"total_price\", \"draft_order\".\"orders\".\"currency\", \"draft_order\".\"orders\".\"logchain_uuid\", \"draft_order\".\"orders\".\"comment\", \"draft_order\".\"orders\".\"status\", \"draft_order\".\"orders\".\"created_at\", \"draft_order\".\"orders\".\"updated_at\", \"draft_order\".\"orders\".\"archived_at\", \"draft_order\".\"orders\".\"deleted_at\", \"draft_order\".\"orders\".\"service_requirements\", \"draft_order\".\"orders\".\"contact_person_fio\", \"draft_order\".\"orders\".\"contact_person_phone\" from \"draft_order\".\"orders\" where (\"draft_order\".\"orders\".\"uuid\" = cast(? as uuid) and \"draft_order\".\"orders\".\"archived_at\" is null and \"draft_order\".\"orders\".\"deleted_at\" is null)]; SQL state [null]; error code [0]; Error while reading field: \"draft_order\".\"orders\".\"cargo_insurance_cost\", at JDBC index: 22; nested exception is java.sql.SQLException: Error while reading field: \"draft_order\".\"orders\".\"cargo_insurance_cost\", at JDBC index: 22\n\tat org.springframework.cloud.stream.binding.StreamListenerMessageHandler.handleRequestMessage(StreamListenerMessageHandler.java:63)\n\tat org.springframework.integration.handler.AbstractReplyProducingMessageHandler.handleMessageInternal(AbstractReplyProducingMessageHandler.java:123)\n\tat org.springframework.integration.handler.AbstractMessageHandler.handleMessage(AbstractMessageHandler.java:169)\n\tat org.springframework.integration.dispatcher.AbstractDispatcher.tryOptimizedDispatch(AbstractDispatcher.java:115)\n\tat org.springframework.integration.dispatcher.UnicastingDispatcher.doDispatch(UnicastingDispatcher.java:132)\n\tat org.springframework.integration.dispatcher.UnicastingDispatcher.dispatch(UnicastingDispatcher.java:105)\n\tat org.springframework.integration.channel.AbstractSubscribableChannel.doSend(AbstractSubscribableChannel.java:73)\n\tat org.springframework.integration.channel.AbstractMessageChannel.send(AbstractMessageChannel.java:453)\n\tat org.springframework.integration.channel.AbstractMessageChannel.send(AbstractMessageChannel.java:401)\n\tat org.springframework.messaging.core.GenericMessagingTemplate.doSend(GenericMessagingTemplate.java:187)\n\tat org.springframework.messaging.core.GenericMessagingTemplate.doSend(GenericMessagingTemplate.java:166)\n\tat org.springframework.messaging.core.GenericMessagingTemplate.doSend(GenericMessagingTemplate.java:47)\n\tat org.springframework.messaging.core.AbstractMessageSendingTemplate.send(AbstractMessageSendingTemplate.java:109)\n\tat org.springframework.integration.endpoint.MessageProducerSupport.sendMessage(MessageProducerSupport.java:205)\n\tat org.springframework.integration.kafka.inbound.KafkaMessageDrivenChannelAdapter.sendMessageIfAny(KafkaMessageDrivenChannelAdapter.java:369)\n\tat org.springframework.integration.kafka.inbound.KafkaMessageDrivenChannelAdapter.access$400(KafkaMessageDrivenChannelAdapter.java:74)\n\tat org.springframework.integration.kafka.inbound.KafkaMessageDrivenChannelAdapter$IntegrationRecordMessageListener.onMessage(KafkaMessageDrivenChannelAdapter.java:431)\n\tat org.springframework.integration.kafka.inbound.KafkaMessageDrivenChannelAdapter$IntegrationRecordMessageListener.onMessage(KafkaMessageDrivenChannelAdapter.java:402)\n\tat org.springframework.kafka.listener.adapter.RetryingMessageListenerAdapter.lambda$onMessage$0(RetryingMessageListenerAdapter.java:120)\n\tat org.springframework.retry.support.RetryTemplate.doExecute(RetryTemplate.java:287)\n\tat org.springframework.retry.support.RetryTemplate.execute(RetryTemplate.java:211)\n\tat org.springframework.kafka.listener.adapter.RetryingMessageListenerAdapter.onMessage(RetryingMessageListenerAdapter.java:114)\n\tat org.springframework.kafka.listener.adapter.RetryingMessageListenerAdapter.onMessage(RetryingMessageListenerAdapter.java:40)\n\tat org.springframework.kafka.listener.KafkaMessageListenerContainer$ListenerConsumer.doInvokeOnMessage(KafkaMessageListenerContainer.java:1275)\n\tat org.springframework.kafka.listener.KafkaMessageListenerContainer$ListenerConsumer.invokeOnMessage(KafkaMessageListenerContainer.java:1258)\n\tat org.springframework.kafka.listener.KafkaMessageListenerContainer$ListenerConsumer.doInvokeRecordListener(KafkaMessageListenerContainer.java:1219)\n\tat org.springframework.kafka.listener.KafkaMessageListenerContainer$ListenerConsumer.doInvokeWithRecords(KafkaMessageListenerContainer.java:1200)\n\tat org.springframework.kafka.listener.KafkaMessageListenerContainer$ListenerConsumer.invokeRecordListener(KafkaMessageListenerContainer.java:1120)\n\tat org.springframework.kafka.listener.KafkaMessageListenerContainer$ListenerConsumer.invokeListener(KafkaMessageListenerContainer.java:935)\n\tat org.springframework.kafka.listener.KafkaMessageListenerContainer$ListenerConsumer.pollAndInvoke(KafkaMessageListenerContainer.java:751)\n\tat org.springframework.kafka.listener.KafkaMessageListenerContainer$ListenerConsumer.run(KafkaMessageListenerContainer.java:700)\n\tat java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)\n\tat java.util.concurrent.FutureTask.run(FutureTask.java:266)\n\tat java.lang.Thread.run(Thread.java:748)\nCaused by: org.springframework.jdbc.UncategorizedSQLException: jOOQ; uncategorized SQLException for SQL [select \"draft_order\".\"orders\".\"uuid\", \"draft_order\".\"orders\".\"creator_uuid\", \"draft_order\".\"orders\".\"author_uuid\", \"draft_order\".\"orders\".\"client_uuid\", \"draft_order\".\"orders\".\"contractor_uuid\", \"draft_order\".\"orders\".\"logist_uuid\", \"draft_order\".\"orders\".\"number\", \"draft_order\".\"orders\".\"external_number\", \"draft_order\".\"orders\".\"type\", \"draft_order\".\"orders\".\"species\", \"draft_order\".\"orders\".\"risk_color\", \"draft_order\".\"orders\".\"accepted_carrier_colors\", \"draft_order\".\"orders\".\"transportation_way\", \"draft_order\".\"orders\".\"need_tracking\", \"draft_order\".\"orders\".\"is_dangerous\", \"draft_order\".\"orders\".\"resource_class_uuid\", \"draft_order\".\"orders\".\"resource_species_uuid\", \"draft_order\".\"orders\".\"resource_type_uuid\", \"draft_order\".\"orders\".\"number_of_vehicles\", \"draft_order\".\"orders\".\"temperature_regime_uuid\", \"draft_order\".\"orders\".\"cargo_type_uuid\", \"draft_order\".\"orders\".\"cargo_insurance_cost\", \"draft_order\".\"orders\".\"cargo_insurance_currency\", \"draft_order\".\"orders\".\"cargo_weight_in_kg\", \"draft_order\".\"orders\".\"volume_in_cubic_meters\", \"draft_order\".\"orders\".\"accounting_type\", \"draft_order\".\"orders\".\"pallet_count\", \"draft_order\".\"orders\".\"freight_unit_count\", \"draft_order\".\"orders\".\"freight_forwarding_unit_uuid\", \"draft_order\".\"orders\".\"total_price\", \"draft_order\".\"orders\".\"currency\", \"draft_order\".\"orders\".\"logchain_uuid\", \"draft_order\".\"orders\".\"comment\", \"draft_order\".\"orders\".\"status\", \"draft_order\".\"orders\".\"created_at\", \"draft_order\".\"orders\".\"updated_at\", \"draft_order\".\"orders\".\"archived_at\", \"draft_order\".\"orders\".\"deleted_at\", \"draft_order\".\"orders\".\"service_requirements\", \"draft_order\".\"orders\".\"contact_person_fio\", \"draft_order\".\"orders\".\"contact_person_phone\" from \"draft_order\".\"orders\" where (\"draft_order\".\"orders\".\"uuid\" = cast(? as uuid) and \"draft_order\".\"orders\".\"archived_at\" is null and \"draft_order\".\"orders\".\"deleted_at\" is null)]; SQL state [null]; error code [0]; Error while reading field: \"draft_order\".\"orders\".\"cargo_insurance_cost\", at JDBC index: 22; nested exception is java.sql.SQLException: Error while reading field: \"draft_order\".\"orders\".\"cargo_insurance_cost\", at JDBC index: 22\n\tat org.jooq_3.12.3.POSTGRES.debug(Unknown Source)\n\tat org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:89)\n\tat org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)\n\tat org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)\n\tat org.springframework.boot.autoconfigure.jooq.JooqExceptionTranslator.translate(JooqExceptionTranslator.java:92)\n\tat org.springframework.boot.autoconfigure.jooq.JooqExceptionTranslator.handle(JooqExceptionTranslator.java:81)\n\tat org.springframework.boot.autoconfigure.jooq.JooqExceptionTranslator.exception(JooqExceptionTranslator.java:55)\n\tat org.jooq.impl.ExecuteListeners.exception(ExecuteListeners.java:261)\n\tat org.jooq.impl.CursorImpl$CursorIterator.fetchNext(CursorImpl.java:1631)\n\tat org.jooq.impl.CursorImpl$CursorIterator.hasNext(CursorImpl.java:1581)\n\tat org.jooq.impl.CursorImpl.fetchNext(CursorImpl.java:353)\n\tat org.jooq.impl.Tools.fetchOne(Tools.java:2079)\n\tat org.jooq.impl.AbstractResultQuery.fetchOne(AbstractResultQuery.java:653)\n\tat org.jooq.impl.SelectImpl.fetchOne(SelectImpl.java:2887)\n\tat online.oboz.order.draft_to_order_creator.infrastructure.repository.Repository.findOrderByUuid(Repository.kt:19)\n\tat online.oboz.order.draft_to_order_creator.infrastructure.repository.Repository$$FastClassBySpringCGLIB$$cbeb2ee7.invoke(<generated>)\n\tat org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)\n\tat org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:749)\n\tat org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)\n\tat org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)\n\tat org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)\n\tat org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)\n\tat online.oboz.order.draft_to_order_creator.infrastructure.repository.Repository$$EnhancerBySpringCGLIB$$793a2bcd.findOrderByUuid(<generated>)\n\tat online.oboz.order.draft_to_order_creator.domain.service.DraftToOrderService.mapOrderToMessage(DraftToOrderService.kt:27)\n\tat online.oboz.order.draft_to_order_creator.domain.service.DraftToOrderService.draftToOrder(DraftToOrderService.kt:23)\n\tat online.oboz.order.draft_to_order_creator.presentation.listener.QueueListener.processTransition(QueueListener.kt:35)\n\tat sun.reflect.GeneratedMethodAccessor147.invoke(Unknown Source)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat java.lang.reflect.Method.invoke(Method.java:498)\n\tat org.springframework.messaging.handler.invocation.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:171)\n\tat org.springframework.messaging.handler.invocation.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:120)\n\tat org.springframework.cloud.stream.binding.StreamListenerMessageHandler.handleRequestMessage(StreamListenerMessageHandler.java:55)\n\t... 33 common frames omitted\nCaused by: java.sql.SQLException: Error while reading field: \"draft_order\".\"orders\".\"cargo_insurance_cost\", at JDBC index: 22\n\tat org.jooq.impl.CursorImpl$CursorIterator$CursorRecordInitialiser.setValue(CursorImpl.java:1735)\n\tat org.jooq.impl.CursorImpl$CursorIterator$CursorRecordInitialiser.operate(CursorImpl.java:1685)\n\tat org.jooq.impl.CursorImpl$CursorIterator$CursorRecordInitialiser.operate(CursorImpl.java:1650)\n\tat org.jooq.impl.RecordDelegate.operate(RecordDelegate.java:130)\n\tat org.jooq.impl.CursorImpl$CursorIterator.fetchNext(CursorImpl.java:1614)\n\t... 56 common frames omitted\nCaused by: org.postgresql.util.PSQLException: Bad value for type int : 3500000000\n\tat org.postgresql.jdbc.PgResultSet.toInt(PgResultSet.java:2838)\n\tat org.postgresql.jdbc.PgResultSet.getInt(PgResultSet.java:2073)\n\tat com.zaxxer.hikari.pool.HikariProxyResultSet.getInt(HikariProxyResultSet.java)\n\tat org.jooq.tools.jdbc.DefaultResultSet.getInt(DefaultResultSet.java:134)\n\tat org.jooq.impl.CursorImpl$CursorResultSet.getInt(CursorImpl.java:773)\n\tat org.jooq.impl.DefaultBinding$DefaultIntegerBinding.get0(DefaultBinding.java:2463)\n\tat org.jooq.impl.DefaultBinding$DefaultIntegerBinding.get0(DefaultBinding.java:2435)\n\tat org.jooq.impl.DefaultBinding$AbstractBinding.get(DefaultBinding.java:824)\n\tat org.jooq.impl.CursorImpl$CursorIterator$CursorRecordInitialiser.setValue(CursorImpl.java:1725)\n\t... 60 common frames omitted\n","app-name":"order-draft-to-order-creator","app-version":"128bc84"}