Publishing of trades to `trade-feed` is failing

[willtsai]

Bug Report

Steps to Reproduce:

1. Run the application using docker compose up
2. Navigate to the TraderX web UI and create and submit a trade
3. Trade goes through successfully and gets written to the database
4. Observe error message pop up from when the application tries to publish the trade to trade-feed:

Expected Result:

The trade goes through successfully AND the trade publishes successfully to trade-feed

Actual Result:

The trade goes through processing and is written into the database successfully, but the publish to trade-feed fails. Here are the logs:

ingress-1                | 172.18.0.1 - - [11/Sep/2025:01:37:35 +0000] "GET /socket.io/?EIO=4&transport=polling&t=qnuz4ytm&sid=V38cruQ3evqIFb7iAAAM HTTP/1.1" 200 1 "https://verbose-telegram-6rpgr5gv9whqrj-8080.app.github.dev/trade" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36 Edg/140.0.0.0" "71.212.218.250"
trade-service-1          | 2025-09-11T01:37:45.633Z  INFO 1 --- [omcat-handler-1] f.t.t.controller.TradeOrderController    : Called createTradeOrder
trade-service-1          | 2025-09-11T01:37:45.638Z  INFO 1 --- [omcat-handler-1] f.t.t.controller.TradeOrderController    : Validate ticker finos.traderx.tradeservice.model.Security@2b3ec8e6
trade-service-1          | 2025-09-11T01:37:45.653Z  INFO 1 --- [omcat-handler-1] f.t.t.controller.TradeOrderController    : Validate account finos.traderx.tradeservice.model.Account@25f933f1
trade-service-1          | 2025-09-11T01:37:45.654Z  INFO 1 --- [omcat-handler-1] f.t.t.controller.TradeOrderController    : Trade is valid. Submitting finos.traderx.tradeservice.model.TradeOrder@21c6a396
trade-feed-1             | {"level":"info","message":"Publish /trades -> {\"type\":\"TradeOrder\",\"from\":\"_MZD63nhXcnqMrHWAAAB\",\"topic\":\"/trades\",\"date\":1757554665660,\"payload\":{\"accountId\":22214,\"security\":\"IBM\",\"side\":\"Buy\",\"quantity\":10}}"}
ingress-1                | 172.18.0.1 - - [11/Sep/2025:01:37:45 +0000] "POST /trade-service/trade/ HTTP/1.1" 200 97 "https://verbose-telegram-6rpgr5gv9whqrj-8080.app.github.dev/trade" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36 Edg/140.0.0.0" "71.212.218.250"
trade-processor-1        | 2025-09-11T01:37:45.662Z  INFO 1 --- [    EventThread] f.t.tradeprocessor.TradeFeedHandler      : Raw Payload {"date":1757554665660,"payload":{"accountId":22214,"security":"IBM","side":"Buy","quantity":10},"topic":"/trades","from":"_MZD63nhXcnqMrHWAAAB","type":"TradeOrder"}
trade-processor-1        | 2025-09-11T01:37:45.665Z  INFO 1 --- [    EventThread] f.t.tradeprocessor.TradeFeedHandler      : Incoming Payload: finos.traderx.tradeprocessor.model.TradeOrder@43e2091c
trade-processor-1        | 2025-09-11T01:37:45.665Z  INFO 1 --- [    EventThread] f.t.tradeprocessor.service.TradeService  : Trade order received : finos.traderx.tradeprocessor.model.TradeOrder@43e2091c
trade-processor-1        | 2025-09-11T01:37:45.665Z  INFO 1 --- [    EventThread] f.t.tradeprocessor.service.TradeService  : Setting a random TradeID
trade-processor-1        | 2025-09-11T01:37:45.672Z DEBUG 1 --- [    EventThread] org.hibernate.SQL                        : select p1_0.ACCOUNTID,p1_0.SECURITY,p1_0.QUANTITY,p1_0.UPDATED from POSITIONS p1_0 where p1_0.ACCOUNTID=? and p1_0.SECURITY=?
trade-processor-1        | 2025-09-11T01:37:45.679Z  INFO 1 --- [    EventThread] f.t.tradeprocessor.service.TradeService  : Position for 22214 IBM is finos.traderx.tradeprocessor.model.Position@28bace18
trade-processor-1        | 2025-09-11T01:37:45.680Z  INFO 1 --- [    EventThread] f.t.tradeprocessor.service.TradeService  : Trade finos.traderx.tradeprocessor.model.Trade@3661fba6
trade-processor-1        | 2025-09-11T01:37:45.682Z DEBUG 1 --- [    EventThread] org.hibernate.SQL                        : select t1_0.ID,t1_0.ACCOUNTID,t1_0.CREATED,t1_0.QUANTITY,t1_0.SECURITY,t1_0.SIDE,t1_0.STATE,t1_0.UPDATED from TRADES t1_0 where t1_0.ID=?
trade-processor-1        | 2025-09-11T01:37:45.687Z DEBUG 1 --- [    EventThread] org.hibernate.SQL                        : insert into TRADES (ACCOUNTID,CREATED,QUANTITY,SECURITY,SIDE,STATE,UPDATED,ID) values (?,?,?,?,?,?,?,?)
trade-processor-1        | 2025-09-11T01:37:45.692Z DEBUG 1 --- [    EventThread] org.hibernate.SQL                        : select p1_0.ACCOUNTID,p1_0.SECURITY,p1_0.QUANTITY,p1_0.UPDATED from POSITIONS p1_0 where (p1_0.ACCOUNTID,p1_0.SECURITY) in ((?,?))
trade-processor-1        | 2025-09-11T01:37:45.696Z DEBUG 1 --- [    EventThread] org.hibernate.SQL                        : update POSITIONS set QUANTITY=?,UPDATED=? where ACCOUNTID=? and SECURITY=?
trade-processor-1        | 2025-09-11T01:37:45.705Z DEBUG 1 --- [    EventThread] org.hibernate.SQL                        : select t1_0.ID,t1_0.ACCOUNTID,t1_0.CREATED,t1_0.QUANTITY,t1_0.SECURITY,t1_0.SIDE,t1_0.STATE,t1_0.UPDATED from TRADES t1_0 where t1_0.ID=?
trade-processor-1        | 2025-09-11T01:37:45.709Z DEBUG 1 --- [    EventThread] org.hibernate.SQL                        : update TRADES set ACCOUNTID=?,CREATED=?,QUANTITY=?,SECURITY=?,SIDE=?,STATE=?,UPDATED=? where ID=?
trade-processor-1        | 2025-09-11T01:37:45.712Z  INFO 1 --- [    EventThread] f.t.tradeprocessor.service.TradeService  : Trade Processing complete : finos.traderx.tradeprocessor.model.TradeBookingResult@659cdd76
trade-processor-1        | 2025-09-11T01:37:45.712Z  INFO 1 --- [    EventThread] f.t.tradeprocessor.service.TradeService  : Publishing : finos.traderx.tradeprocessor.model.TradeBookingResult@659cdd76
trade-feed-1             | {"level":"info","message":"Publish /accounts/22214/trades -> {\"type\":\"Trade\",\"from\":\"1LyPRDNeudcveTxtAAAG\",\"topic\":\"/accounts/22214/trades\",\"date\":1757554665715,\"payload\":{\"accountId\":22214,\"security\":\"IBM\",\"side\":\"Buy\",\"quantity\":10,\"created\":1757554665665,\"id\":\"9026f667-2810-418d-af8d-7cf6175b0538\",\"state\":\"Settled\",\"updated\":1757554665704}}"}
trade-processor-1        | 2025-09-11T01:37:45.717Z  INFO 1 --- [    EventThread] f.t.tradeprocessor.TradeFeedHandler      : Connection Error
trade-feed-1             | {"level":"info","message":"Publish /accounts/22214/positions -> {\"type\":\"Position\",\"from\":\"LGymMjej25khguCSAAAF\",\"topic\":\"/accounts/22214/positions\",\"date\":1757554665718,\"payload\":{\"accountId\":22214,\"security\":\"IBM\",\"quantity\":-90,\"updated\":1757553430881}}"}

Environment:

Codespace running Ubuntu 24.04.2 LTS

Additional Context:

...add any other context about the problem here. If applicable, add screenshots to help explain...

[DovOps]

Thanks for reporting this. Just for a data point, on the https://demo.traderx.finos.org you can open /trade-feed in a separate browser window, and see both windows side-by-side where this is working. Will look to reproduce and t-shoot in a codespace.

[DovOps]

Running on a codespace, I get the expected behavior, and the publish takes place, but the log says 'Connection Error' which seems to be incorrect, as this is functioning as desired.

trade-processor-1        | 2025-09-26T10:52:40.500Z  INFO 1 --- [    EventThread] f.t.tradeprocessor.service.TradeService  : 
Publishing : finos.traderx.tradeprocessor.model.TradeBookingResult@aaea054
trade-feed-1             | {"level":"info","message":"Publish /accounts/52355/trades -> {\"type\":\"Trade\",\"from\":\"61hNXk_DLywBwlkBAAAH\",\"topic\":\"/accounts/52355/trades\",\"date\":1758883960520,
\"payload\":{\"accountId\":52355,\"security\":\"MMM\",\"side\":\"Sell\",\"quantity\":1,\"created\":1758883960302,\"id\":
\"48e52b9b-2586-4c41-99f7-7e13e4cb1bdc\",\"state\":\"Settled\",\"updated\":1758883960487}}"}
trade-processor-1        | 2025-09-26T10:52:40.521Z  INFO 1 --- [    EventThread] f.t.tradeprocessor.TradeFeedHandler      : 
Connection Error
trade-feed-1             | {"level":"info","message":"Publish /accounts/52355/positions -> {\"type\":\"Position\",\"from\":\"2zV5kK5uJuINy1ydAAAG\",\"topic\":\"/accounts/52355/positions\",\"date\":
1758883960521,\"payload\":{\"accountId\":52355,\"security\":\"MMM\",\"quantity\":-1}}"}
Gracefully stopping... (press Ctrl+C again to force)

[DovOps]

trade-feed logging the publish messages is evidence this publish took place successfully.
However, I did notice that positions are no longer updating existing rows, but rather inserting multiple rows for the same symbol. This should not be the case. Will open a separate case.