-
Notifications
You must be signed in to change notification settings - Fork 20
Connection Pooling support #223
-
Hi team, Do we have connection pooling support so that we don't open a new connection everytime we want to query timebase. Thanks for the same. Regards |
Beta Was this translation helpful? Give feedback.
All reactions
Replies: 4 comments · 10 replies
-
Please take a look |
Beta Was this translation helpful? Give feedback.
All reactions
-
2. deltix_TimeBase-2023-04-28.24.log 28 Apr 05:33:46 INFO 28 Apr 05:33:46 INFO QuantServer Version: 6.1.12 28 Apr 05:46:42 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.X.XXX.XXX:57578 28 Apr 08:21:38 FATAL [user=, ip=/127.0.0.1:44956, app=Timebase Shell] Query stream error: 28 Apr 08:28:25 INFO Stream [db_trades] already has path associated with space = (20220825). Assign new name: (63094761@20220825) 28 Apr 10:05:56 FATAL [user=, ip=/127.0.0.1:48198, app=Timebase Shell] Query stream error: 28 Apr 10:06:30 FATAL [user=, ip=/127.0.0.1:48198, app=Timebase Shell] Query stream error: 28 Apr 12:01:04 FATAL [user=, ip=/127.0.0.1:44956, app=Timebase Shell] Query stream error: 28 Apr 12:01:11 FATAL [user=, ip=/127.0.0.1:44956, app=Timebase Shell] Query stream error: 28 Apr 12:02:40 FATAL [user=, ip=/127.0.0.1:54782, app=Timebase Shell] Query stream error: 28 Apr 12:12:43 FATAL [user=, ip=/127.0.0.1:55188, app=Timebase Shell] Query stream error: 28 Apr 12:59:27 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /127.0.0.1:55188 28 Apr 12:59:40 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /127.0.0.1:48198 28 Apr 12:59:40 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /127.0.0.1:43230 28 Apr 13:01:24 INFO 28 Apr 13:01:24 INFO QuantServer Version: 6.1.12 28 Apr 15:03:45 FATAL [user=, ip=/127.0.0.1:34454, app=Timebase Shell] Query stream error: 28 Apr 15:04:32 FATAL [user=, ip=/127.0.0.1:34454, app=Timebase Shell] Query stream error: 28 Apr 15:18:38 FATAL [user=, ip=/127.0.0.1:34454, app=Timebase Shell] Query stream error: 28 Apr 15:19:24 FATAL [user=, ip=/127.0.0.1:34454, app=Timebase Shell] Query stream error: 28 Apr 15:57:26 INFO 28 Apr 15:57:26 INFO QuantServer Version: 6.1.12 28 Apr 15:59:10 INFO QuantServer Version: 6.1.12 28 Apr 15:59:10 INFO Shutting QuantServer... 28 Apr 16:02:17 INFO QuantServer Version: 6.1.12 28 Apr 16:02:37 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX.128.197:47296 28 Apr 16:02:37 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX76.225:58158 28 Apr 16:02:37 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX76.225:58161 28 Apr 16:02:37 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX.128.197:47312 28 Apr 16:02:37 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX76.225:58164 28 Apr 16:02:37 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX.128.197:47304 28 Apr 16:02:37 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX76.225:58165 28 Apr 16:02:37 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX.128.197:47302 28 Apr 16:02:37 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX.76.225:58160 28 Apr 16:03:14 INFO 28 Apr 16:03:14 INFO QuantServer Version: 6.1.12 28 Apr 16:03:33 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX76.225:60904 28 Apr 16:03:33 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX76.225:60902 28 Apr 16:03:33 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX.128.197:49354 28 Apr 16:03:33 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX76.225:60900 28 Apr 16:03:33 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX76.225:60898 28 Apr 16:03:33 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX.128.197:49346 28 Apr 16:03:33 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX.128.197:49350 28 Apr 16:03:34 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX76.225:60906 28 Apr 16:03:34 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX.128.197:49352 28 Apr 16:06:02 INFO 28 Apr 16:06:02 INFO QuantServer Version: 6.1.12 28 Apr 16:06:22 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX.128.197:56876 28 Apr 16:06:22 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX76.225:39440 28 Apr 16:06:22 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX76.225:39436 28 Apr 16:06:22 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX.128.197:56880 28 Apr 16:06:22 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX76.225:39437 28 Apr 16:06:22 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX.128.197:56878 28 Apr 16:06:22 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX76.225:39442 28 Apr 16:06:22 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX.128.197:56888 28 Apr 16:08:31 INFO 28 Apr 16:08:31 INFO QuantServer Version: 6.1.12 28 Apr 16:31:18 INFO QuantServer Version: 6.1.12 28 Apr 16:31:37 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX76.225:45874 28 Apr 16:31:37 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX.128.197:39658 28 Apr 16:31:37 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX.128.197:39654 28 Apr 16:31:37 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX76.225:45868 28 Apr 16:31:37 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX.128.197:39661 28 Apr 16:31:37 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX.128.197:39652 28 Apr 16:31:37 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX.128.197:39664 28 Apr 16:31:37 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX.128.197:39650 28 Apr 16:31:37 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX76.225:45876 28 Apr 16:31:37 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX76.225:45872 28 Apr 16:31:37 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX.128.197:39656 28 Apr 16:31:37 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX.128.197:39660 28 Apr 16:33:16 INFO 28 Apr 16:33:16 INFO QuantServer Version: 6.1.12 28 Apr 16:33:35 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX76.225:50714 28 Apr 16:33:35 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX.128.197:44710 28 Apr 16:33:35 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX.128.197:44708 28 Apr 16:33:35 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX76.225:50718 28 Apr 16:33:35 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX76.225:50721 28 Apr 16:33:35 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX.128.197:44704 28 Apr 16:33:35 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX.128.197:44702 28 Apr 16:33:35 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX.128.197:44698 28 Apr 16:33:35 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX.128.197:44706 28 Apr 16:33:35 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX.128.197:44700 28 Apr 16:33:35 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX76.225:50720 28 Apr 16:33:35 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX.128.197:44696 28 Apr 16:36:10 INFO 28 Apr 16:36:10 INFO QuantServer Version: 6.1.12 28 Apr 16:36:19 INFO Transport channel has stopped. Remote address: /XX.XXX76.225:57390. Error: SocketException. Message: Connection reset 28 Apr 16:36:19 INFO Transport channel has stopped. Remote address: /XX.XXX76.225:57388. Error: SocketException. Message: Connection reset 28 Apr 16:36:19 INFO Restore socket com.epam.deltix.util.vsocket.VSocketImpl@767f2e5c#33 from: com.epam.deltix.util.vsocket.VSocketImpl@767f2e5c#6 28 Apr 16:36:19 INFO Restore socket com.epam.deltix.util.vsocket.VSocketImpl@2413e4e4#31 from: com.epam.deltix.util.vsocket.VSocketImpl@2413e4e4#10 28 Apr 16:36:19 INFO Restore socket com.epam.deltix.util.vsocket.VSocketImpl@48d56edf#30 from: com.epam.deltix.util.vsocket.VSocketImpl@48d56edf#8 28 Apr 16:36:19 INFO Restore socket com.epam.deltix.util.vsocket.VSocketImpl@5894b8c4#28 from: com.epam.deltix.util.vsocket.VSocketImpl@5894b8c4#12 28 Apr 16:36:19 INFO Transport channel has stopped. Remote address: /XX.XXX.128.197:52036. Error: SocketException. Message: Connection reset 28 Apr 16:36:19 INFO Restoring connection (1821725825 / 6c955481) for 100.64.115.223:a16f55znm424_1g3:MyAPI API:a16f55znm424_1iu 28 Apr 16:36:19 INFO Restore socket com.epam.deltix.util.vsocket.VSocketImpl@83c54cf#37 from: com.epam.deltix.util.vsocket.VSocketImpl@83c54cf#3 28 Apr 16:36:19 INFO Transport channel has stopped. Remote address: /XX.XXX.128.197:52108. Error: SocketException. Message: Connection reset 28 Apr 16:36:19 INFO Restoring connection (927337266 / 37460b32) for 100.64.115.223:a16f55znm424_1g7:MyAPI API:a16f55znm424_1it 28 Apr 16:36:19 ERROR Error reading request, ignored 28 Apr 16:36:29 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX76.225:57344 28 Apr 16:36:29 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX.128.197:52040 28 Apr 16:36:29 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX76.225:57346 28 Apr 16:36:29 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX76.225:57338 28 Apr 16:36:29 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX.128.197:52028 28 Apr 16:36:29 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX.128.197:52029 28 Apr 16:36:29 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX76.225:57340 28 Apr 16:36:29 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX.128.197:52034 28 Apr 16:36:29 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX76.225:57342 28 Apr 16:36:29 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX.128.197:52032 28 Apr 16:37:12 INFO 28 Apr 16:37:12 INFO QuantServer Version: 6.1.12 28 Apr 16:37:32 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX76.225:59940 28 Apr 16:37:32 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX76.225:59944 28 Apr 16:37:32 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX.128.197:55072 28 Apr 16:37:32 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX76.225:59932 28 Apr 16:37:32 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX.128.197:55076 28 Apr 16:37:32 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX.128.197:55068 28 Apr 16:37:32 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX76.225:59938 28 Apr 16:37:32 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX.128.197:55074 28 Apr 16:37:32 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX76.225:59933 28 Apr 16:37:32 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX.128.197:55062 28 Apr 16:37:32 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX.128.197:55070 28 Apr 16:37:32 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX.128.197:55060 28 Apr 17:46:32 INFO Transport channel has stopped. Remote address: /XX.XXX.XX.XXX:59442. Error: SocketException. Message: Connection reset 28 Apr 17:46:42 WARN Disconnecting due to unrecoverable transport channel loss. Remote address: /XX.XXX.XX.XXX:55744 28 Apr 19:51:56 INFO Transport channel has stopped. Remote address: /XX.XXX.XX.XXX:60878. Error: SocketException. Message: Connection timed out (Read failed) |
Beta Was this translation helpful? Give feedback.
All reactions
-
3. deltix_TimeBase-2023-04-29.25.log 29 Apr 12:17:10 INFO Transport channel has stopped. Remote address: /XX.X.XXX.XXX:XXXXX. Error: SocketException. Message: Connection timed out (Read failed) 29 Apr 16:30:38 INFO Transport channel has stopped. Remote address: /XX.X.XXX.XXX:XXXXX. Error: SocketException. Message: Connection reset |
Beta Was this translation helpful? Give feedback.
All reactions
-
4. deltix_TimeBase-2023-05-02.26.log 2 May 07:29:38 INFO Transport channel has stopped. Remote address: /XX.X.XXX.XXX:56313. Error: SocketException. Message: Connection reset |
Beta Was this translation helpful? Give feedback.
All reactions
-
@alex-karpovich |
Beta Was this translation helpful? Give feedback.
All reactions
-
Hello @alex-karpovich |
Beta Was this translation helpful? Give feedback.
All reactions
-
Grettings, @bardale "MyAPI API" this is your application?
|
Beta Was this translation helpful? Give feedback.
All reactions
-
Hi @alex-karpovich |
Beta Was this translation helpful? Give feedback.
All reactions
-
also error like this
means that stream was deleted having opened live cursor |
Beta Was this translation helpful? Give feedback.
All reactions
-
please use JVM settings for docker-compose from here |
Beta Was this translation helpful? Give feedback.
Please take a look
https://github.com/epam/TimebaseWS/blob/main/java/ws-server/src/main/java/com/epam/deltix/tbwg/webapp/services/timebase/TimebaseServiceImpl.java#L162