Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Check client logs:
- {"timestamp":"2019-03-06T15:38:34.647+0000","status":404,"error":"Not Found","message":"Coupon not found","path":"/v1/coupon/check"}
- Use&issue client logs:
- {"timestamp":"2019-03-06T15:39:26.771+0000","status":500,"error":"Internal Server Error","message":"REJECTED_SEMAPHORE_EXECUTION"}
- {"timestamp":"2019-03-06T15:39:32.904+0000","status":500,"error":"Internal Server Error","message":"GENERAL"}
- Consumer logs:
- 1)
- 2019-03-06 18:38:34.846 ERROR 1 --- [ntainer#4-0-C-1] o.h.engine.jdbc.spi.SqlExceptionHelper : An I/O error occurred while sending to the backend.
- 2)
- 2019-03-06 18:38:34.846 ERROR 1 --- [ntainer#4-0-C-1] o.h.engine.jdbc.spi.SqlExceptionHelper : FATAL: terminating connection due to administrator command
- Where: SQL statement "INSERT INTO coupon_exemplar(
- number,
- category_id,
- batch_id,
- start_date,
- end_date,
- status,
- create_date,
- issued_date,
- used_date,
- issued_place_shop_number,
- issued_place_shift_number,
- issued_place_purchase_number,
- issued_place_cash_number,
- used_place_shop_number,
- used_place_shift_number,
- used_place_purchase_number,
- used_place_cash_number,
- extended_info)
- SELECT
- generate_exemplar_coupon_number(pPREFIX, vCATEGORY_ID_TEXT, vSERIES_NUMBER_TEXT, ind),
- pCATEGORY_ID,
- pBATCH_ID,
- pSTART_DATE,
- pEND_DATE,
- 0,
- pCREATE_DATE,
- NULL, -- issued date
- NULL, -- used date
- NULL, -- i-shop number
- NULL, -- i-shift number
- NULL, -- i-purchase number
- NULL, -- i-cash number
- NULL, -- u-shop number
- NULL, -- u-shift number
- NULL, -- u-purchase number
- NULL, -- u-cash number
- vJSONB_DETAILS
- FROM generate_series(pSTART_IND, pEND_IND - 1) ind"
- PL/pgSQL function generate_coupon_exemplars(text,integer,integer,bigint,bigint,bigint,timestamp without time zone,timestamp without time zone,text,timestamp without time zone) line 11 at SQL statement
- 3) https://pastebin.com/8xCfVL7Z
- 4)
- 2019-03-06 18:38:34.884 ERROR 1 --- [onnection adder] org.postgresql.Driver : Connection error:
- org.postgresql.util.PSQLException: FATAL: the database system is shutting down
- at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:473) ~[postgresql-42.2.2.jar!/:42.2.2]
- at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:205) ~[postgresql-42.2.2.jar!/:42.2.2]
- at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49) ~[postgresql-42.2.2.jar!/:42.2.2]
- at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195) ~[postgresql-42.2.2.jar!/:42.2.2]
- at org.postgresql.Driver.makeConnection(Driver.java:452) ~[postgresql-42.2.2.jar!/:42.2.2]
- at org.postgresql.Driver.connect(Driver.java:254) ~[postgresql-42.2.2.jar!/:42.2.2]
- at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:117) [HikariCP-2.7.9.jar!/:na]
- at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:123) [HikariCP-2.7.9.jar!/:na]
- at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:365) [HikariCP-2.7.9.jar!/:na]
- at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:194) [HikariCP-2.7.9.jar!/:na]
- at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:460) [HikariCP-2.7.9.jar!/:na]
- at com.zaxxer.hikari.pool.HikariPool.access$100(HikariPool.java:71) [HikariCP-2.7.9.jar!/:na]
- at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:699) [HikariCP-2.7.9.jar!/:na]
- at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:685) [HikariCP-2.7.9.jar!/:na]
- at java.util.concurrent.FutureTask.run(FutureTask.java:266) [na:1.8.0_181]
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_181]
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_181]
- at java.lang.Thread.run(Thread.java:748) [na:1.8.0_181]
- 5)
- 2019-03-06 18:38:34.888 ERROR 1 --- [ntainer#4-0-C-1] o.h.engine.jdbc.spi.SqlExceptionHelper : An I/O error occurred while sending to the backend
- 6) https://pastebin.com/5q1ZM17j
- 7) https://pastebin.com/aT1NbvkN
- 8)
- 2019-03-06 18:38:36.864 ERROR 1 --- [onnection adder] org.postgresql.Driver : Connection error:
- org.postgresql.util.PSQLException: The connection attempt failed.
- at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:257) ~[postgresql-42.2.2.jar!/:42.2.2]
- at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49) ~[postgresql-42.2.2.jar!/:42.2.2]
- at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195) ~[postgresql-42.2.2.jar!/:42.2.2]
- at org.postgresql.Driver.makeConnection(Driver.java:452) ~[postgresql-42.2.2.jar!/:42.2.2]
- at org.postgresql.Driver.connect(Driver.java:254) ~[postgresql-42.2.2.jar!/:42.2.2]
- at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:117) [HikariCP-2.7.9.jar!/:na]
- at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:123) [HikariCP-2.7.9.jar!/:na]
- at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:365) [HikariCP-2.7.9.jar!/:na]
- at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:194) [HikariCP-2.7.9.jar!/:na]
- at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:460) [HikariCP-2.7.9.jar!/:na]
- at com.zaxxer.hikari.pool.HikariPool.access$100(HikariPool.java:71) [HikariCP-2.7.9.jar!/:na]
- at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:699) [HikariCP-2.7.9.jar!/:na]
- at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:685) [HikariCP-2.7.9.jar!/:na]
- at java.util.concurrent.FutureTask.run(FutureTask.java:266) [na:1.8.0_181]
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_181]
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_181]
- at java.lang.Thread.run(Thread.java:748) [na:1.8.0_181]
- Caused by: java.net.SocketException: Connection reset
- at java.net.SocketInputStream.read(SocketInputStream.java:210) ~[na:1.8.0_181]
- at java.net.SocketInputStream.read(SocketInputStream.java:141) ~[na:1.8.0_181]
- at org.postgresql.core.VisibleBufferedInputStream.readMore(VisibleBufferedInputStream.java:140) ~[postgresql-42.2.2.jar!/:42.2.2]
- at org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:109) ~[postgresql-42.2.2.jar!/:42.2.2]
- at org.postgresql.core.VisibleBufferedInputStream.read(VisibleBufferedInputStream.java:67) ~[postgresql-42.2.2.jar!/:42.2.2]
- at org.postgresql.core.PGStream.receiveChar(PGStream.java:293) ~[postgresql-42.2.2.jar!/:42.2.2]
- at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:453) ~[postgresql-42.2.2.jar!/:42.2.2]
- at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:205) ~[postgresql-42.2.2.jar!/:42.2.2]
- ... 16 common frames omitted
- 9)
- 2019-03-06 18:38:37.710 ERROR 1 --- [onnection adder] org.postgresql.Driver : Connection error:
- org.postgresql.util.PSQLException: Connection to master.postgres-production.service.consul:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
- at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:245) ~[postgresql-42.2.2.jar!/:42.2.2]
- at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49) ~[postgresql-42.2.2.jar!/:42.2.2]
- at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:195) ~[postgresql-42.2.2.jar!/:42.2.2]
- at org.postgresql.Driver.makeConnection(Driver.java:452) ~[postgresql-42.2.2.jar!/:42.2.2]
- at org.postgresql.Driver.connect(Driver.java:254) ~[postgresql-42.2.2.jar!/:42.2.2]
- at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:117) [HikariCP-2.7.9.jar!/:na]
- at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:123) [HikariCP-2.7.9.jar!/:na]
- at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:365) [HikariCP-2.7.9.jar!/:na]
- at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:194) [HikariCP-2.7.9.jar!/:na]
- at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:460) [HikariCP-2.7.9.jar!/:na]
- at com.zaxxer.hikari.pool.HikariPool.access$100(HikariPool.java:71) [HikariCP-2.7.9.jar!/:na]
- at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:699) [HikariCP-2.7.9.jar!/:na]
- at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:685) [HikariCP-2.7.9.jar!/:na]
- at java.util.concurrent.FutureTask.run(FutureTask.java:266) [na:1.8.0_181]
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_181]
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_181]
- at java.lang.Thread.run(Thread.java:748) [na:1.8.0_181]
- Caused by: java.net.ConnectException: Connection refused (Connection refused)
- at java.net.PlainSocketImpl.socketConnect(Native Method) ~[na:1.8.0_181]
- at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) ~[na:1.8.0_181]
- at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) ~[na:1.8.0_181]
- at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) ~[na:1.8.0_181]
- at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) ~[na:1.8.0_181]
- at java.net.Socket.connect(Socket.java:589) ~[na:1.8.0_181]
- at org.postgresql.core.PGStream.<init>(PGStream.java:69) ~[postgresql-42.2.2.jar!/:42.2.2]
- at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:156) ~[postgresql-42.2.2.jar!/:42.2.2]
- ... 16 common frames omitted
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement