2026-06-07 00:00:00 [INFO] Log rotation completed successfully. Archive: logs/archived/q2-2026-06-06.log.gz
2026-06-07 00:00:00 [INFO] Log rotation scheduled for 2026-06-08T00:00:00Z (in 86399995ms)
2026-06-07 00:00:05 [ERROR] Archive cleanup failed: %FunctionClauseError{module: DateTime, function: :from_unix, arity: 3, kind: nil, args: nil, clauses: nil}
2026-06-07 00:34:11 [INFO] GET /
2026-06-07 00:34:11 [DEBUG] Processing with UpiWeb.PageController.home/2
  Parameters: %{}
  Pipelines: [:browser]
2026-06-07 00:34:11 [INFO] Sent 200 in 7ms
2026-06-07 00:42:25 [INFO] GET /
2026-06-07 00:42:25 [DEBUG] Processing with UpiWeb.PageController.home/2
  Parameters: %{}
  Pipelines: [:browser]
2026-06-07 00:42:25 [INFO] Sent 200 in 5ms
2026-06-07 01:40:02 [INFO] GET /
2026-06-07 01:40:02 [DEBUG] ** (Phoenix.Router.NoRouteError) no route found for GET / (UpiDynamic.Router)
    (upi_dynamic 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/phoenix/lib/phoenix/router.ex:465: UpiDynamic.Router.call/2
    (upi_dynamic 0.1.0) lib/upi_dynamic/endpoint.ex:1: UpiDynamic.Endpoint.plug_builder_call/2
    (upi_dynamic 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/plug/lib/plug/debugger.ex:155: UpiDynamic.Endpoint."call (overridable 3)"/2
    (upi_dynamic 0.1.0) lib/upi_dynamic/endpoint.ex:1: UpiDynamic.Endpoint.call/2
    (phoenix 1.8.0) lib/phoenix/endpoint/sync_code_reload_plug.ex:22: Phoenix.Endpoint.SyncCodeReloadPlug.do_call/4
    (bandit 1.7.0) lib/bandit/pipeline.ex:131: Bandit.Pipeline.call_plug!/2
    (bandit 1.7.0) lib/bandit/pipeline.ex:42: Bandit.Pipeline.run/5
    (bandit 1.7.0) lib/bandit/http1/handler.ex:13: Bandit.HTTP1.Handler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:18: Bandit.DelegatingHandler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:8: Bandit.DelegatingHandler.handle_continue/2
    (stdlib 5.2.3.2) gen_server.erl:1085: :gen_server.try_handle_continue/3
    (stdlib 5.2.3.2) gen_server.erl:995: :gen_server.loop/7
    (stdlib 5.2.3.2) proc_lib.erl:241: :proc_lib.init_p_do_apply/3

2026-06-07 01:46:47 [INFO] GET /
2026-06-07 01:46:47 [DEBUG] ** (Phoenix.Router.NoRouteError) no route found for GET / (UpiDynamic.Router)
    (upi_dynamic 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/phoenix/lib/phoenix/router.ex:465: UpiDynamic.Router.call/2
    (upi_dynamic 0.1.0) lib/upi_dynamic/endpoint.ex:1: UpiDynamic.Endpoint.plug_builder_call/2
    (upi_dynamic 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/plug/lib/plug/debugger.ex:155: UpiDynamic.Endpoint."call (overridable 3)"/2
    (upi_dynamic 0.1.0) lib/upi_dynamic/endpoint.ex:1: UpiDynamic.Endpoint.call/2
    (phoenix 1.8.0) lib/phoenix/endpoint/sync_code_reload_plug.ex:22: Phoenix.Endpoint.SyncCodeReloadPlug.do_call/4
    (bandit 1.7.0) lib/bandit/pipeline.ex:131: Bandit.Pipeline.call_plug!/2
    (bandit 1.7.0) lib/bandit/pipeline.ex:42: Bandit.Pipeline.run/5
    (bandit 1.7.0) lib/bandit/http1/handler.ex:13: Bandit.HTTP1.Handler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:18: Bandit.DelegatingHandler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:8: Bandit.DelegatingHandler.handle_continue/2
    (stdlib 5.2.3.2) gen_server.erl:1085: :gen_server.try_handle_continue/3
    (stdlib 5.2.3.2) gen_server.erl:995: :gen_server.loop/7
    (stdlib 5.2.3.2) proc_lib.erl:241: :proc_lib.init_p_do_apply/3

2026-06-07 02:37:44 [INFO] GET /
2026-06-07 02:37:44 [DEBUG] ** (Phoenix.Router.NoRouteError) no route found for GET / (UpiDynamic.Router)
    (upi_dynamic 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/phoenix/lib/phoenix/router.ex:465: UpiDynamic.Router.call/2
    (upi_dynamic 0.1.0) lib/upi_dynamic/endpoint.ex:1: UpiDynamic.Endpoint.plug_builder_call/2
    (upi_dynamic 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/plug/lib/plug/debugger.ex:155: UpiDynamic.Endpoint."call (overridable 3)"/2
    (upi_dynamic 0.1.0) lib/upi_dynamic/endpoint.ex:1: UpiDynamic.Endpoint.call/2
    (phoenix 1.8.0) lib/phoenix/endpoint/sync_code_reload_plug.ex:22: Phoenix.Endpoint.SyncCodeReloadPlug.do_call/4
    (bandit 1.7.0) lib/bandit/pipeline.ex:131: Bandit.Pipeline.call_plug!/2
    (bandit 1.7.0) lib/bandit/pipeline.ex:42: Bandit.Pipeline.run/5
    (bandit 1.7.0) lib/bandit/http1/handler.ex:13: Bandit.HTTP1.Handler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:18: Bandit.DelegatingHandler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:8: Bandit.DelegatingHandler.handle_continue/2
    (stdlib 5.2.3.2) gen_server.erl:1085: :gen_server.try_handle_continue/3
    (stdlib 5.2.3.2) gen_server.erl:995: :gen_server.loop/7
    (stdlib 5.2.3.2) proc_lib.erl:241: :proc_lib.init_p_do_apply/3

2026-06-07 02:47:17 [INFO] GET /
2026-06-07 02:47:17 [DEBUG] ** (Phoenix.Router.NoRouteError) no route found for GET / (UpiDynamic.Router)
    (upi_dynamic 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/phoenix/lib/phoenix/router.ex:465: UpiDynamic.Router.call/2
    (upi_dynamic 0.1.0) lib/upi_dynamic/endpoint.ex:1: UpiDynamic.Endpoint.plug_builder_call/2
    (upi_dynamic 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/plug/lib/plug/debugger.ex:155: UpiDynamic.Endpoint."call (overridable 3)"/2
    (upi_dynamic 0.1.0) lib/upi_dynamic/endpoint.ex:1: UpiDynamic.Endpoint.call/2
    (phoenix 1.8.0) lib/phoenix/endpoint/sync_code_reload_plug.ex:22: Phoenix.Endpoint.SyncCodeReloadPlug.do_call/4
    (bandit 1.7.0) lib/bandit/pipeline.ex:131: Bandit.Pipeline.call_plug!/2
    (bandit 1.7.0) lib/bandit/pipeline.ex:42: Bandit.Pipeline.run/5
    (bandit 1.7.0) lib/bandit/http1/handler.ex:13: Bandit.HTTP1.Handler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:18: Bandit.DelegatingHandler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:8: Bandit.DelegatingHandler.handle_continue/2
    (stdlib 5.2.3.2) gen_server.erl:1085: :gen_server.try_handle_continue/3
    (stdlib 5.2.3.2) gen_server.erl:995: :gen_server.loop/7
    (stdlib 5.2.3.2) proc_lib.erl:241: :proc_lib.init_p_do_apply/3

2026-06-07 03:48:48 [ERROR] ** (Bandit.HTTPError) Request line HTTP error: "MGLNDD_78.47.213.209_4040\n"
2026-06-07 03:49:39 [DEBUG] Tzdata polling for update.
2026-06-07 03:49:40 [DEBUG] Tzdata polling shows the loaded tz database is up to date.
2026-06-07 04:13:54 [ERROR] ** (Bandit.HTTPError) Request line HTTP error: "MGLNDD_78.47.213.211_4040\n"
2026-06-07 04:21:53 [ERROR] ** (Bandit.HTTPError) Request line HTTP error: "MGLNDD_78.47.213.210_4040\n"
2026-06-07 04:22:32 [INFO] GET /
2026-06-07 04:22:32 [DEBUG] ** (Phoenix.Router.NoRouteError) no route found for GET / (UpiStatic.Router)
    (upi_static 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/phoenix/lib/phoenix/router.ex:465: UpiStatic.Router.call/2
    (upi_static 0.1.0) lib/upi_static/endpoint.ex:1: UpiStatic.Endpoint.plug_builder_call/2
    (upi_static 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/plug/lib/plug/debugger.ex:155: UpiStatic.Endpoint."call (overridable 3)"/2
    (upi_static 0.1.0) lib/upi_static/endpoint.ex:1: UpiStatic.Endpoint.call/2
    (phoenix 1.8.0) lib/phoenix/endpoint/sync_code_reload_plug.ex:22: Phoenix.Endpoint.SyncCodeReloadPlug.do_call/4
    (bandit 1.7.0) lib/bandit/pipeline.ex:131: Bandit.Pipeline.call_plug!/2
    (bandit 1.7.0) lib/bandit/pipeline.ex:42: Bandit.Pipeline.run/5
    (bandit 1.7.0) lib/bandit/http1/handler.ex:13: Bandit.HTTP1.Handler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:18: Bandit.DelegatingHandler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:8: Bandit.DelegatingHandler.handle_continue/2
    (stdlib 5.2.3.2) gen_server.erl:1085: :gen_server.try_handle_continue/3
    (stdlib 5.2.3.2) gen_server.erl:995: :gen_server.loop/7
    (stdlib 5.2.3.2) proc_lib.erl:241: :proc_lib.init_p_do_apply/3

2026-06-07 04:38:13 [ERROR] ** (Bandit.HTTPError) Request line HTTP error: "*1\r\n"
2026-06-07 04:38:27 [ERROR] ** (Bandit.TransportError) Unrecoverable error: timeout
2026-06-07 04:51:18 [INFO] GET /
2026-06-07 04:51:18 [DEBUG] ** (Phoenix.Router.NoRouteError) no route found for GET / (UpiStatic.Router)
    (upi_static 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/phoenix/lib/phoenix/router.ex:465: UpiStatic.Router.call/2
    (upi_static 0.1.0) lib/upi_static/endpoint.ex:1: UpiStatic.Endpoint.plug_builder_call/2
    (upi_static 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/plug/lib/plug/debugger.ex:155: UpiStatic.Endpoint."call (overridable 3)"/2
    (upi_static 0.1.0) lib/upi_static/endpoint.ex:1: UpiStatic.Endpoint.call/2
    (phoenix 1.8.0) lib/phoenix/endpoint/sync_code_reload_plug.ex:22: Phoenix.Endpoint.SyncCodeReloadPlug.do_call/4
    (bandit 1.7.0) lib/bandit/pipeline.ex:131: Bandit.Pipeline.call_plug!/2
    (bandit 1.7.0) lib/bandit/pipeline.ex:42: Bandit.Pipeline.run/5
    (bandit 1.7.0) lib/bandit/http1/handler.ex:13: Bandit.HTTP1.Handler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:18: Bandit.DelegatingHandler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:8: Bandit.DelegatingHandler.handle_continue/2
    (stdlib 5.2.3.2) gen_server.erl:1085: :gen_server.try_handle_continue/3
    (stdlib 5.2.3.2) gen_server.erl:995: :gen_server.loop/7
    (stdlib 5.2.3.2) proc_lib.erl:241: :proc_lib.init_p_do_apply/3

2026-06-07 05:37:19 [INFO] GET /
2026-06-07 05:37:19 [DEBUG] ** (Phoenix.Router.NoRouteError) no route found for GET / (UpiStatic.Router)
    (upi_static 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/phoenix/lib/phoenix/router.ex:465: UpiStatic.Router.call/2
    (upi_static 0.1.0) lib/upi_static/endpoint.ex:1: UpiStatic.Endpoint.plug_builder_call/2
    (upi_static 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/plug/lib/plug/debugger.ex:155: UpiStatic.Endpoint."call (overridable 3)"/2
    (upi_static 0.1.0) lib/upi_static/endpoint.ex:1: UpiStatic.Endpoint.call/2
    (phoenix 1.8.0) lib/phoenix/endpoint/sync_code_reload_plug.ex:22: Phoenix.Endpoint.SyncCodeReloadPlug.do_call/4
    (bandit 1.7.0) lib/bandit/pipeline.ex:131: Bandit.Pipeline.call_plug!/2
    (bandit 1.7.0) lib/bandit/pipeline.ex:42: Bandit.Pipeline.run/5
    (bandit 1.7.0) lib/bandit/http1/handler.ex:13: Bandit.HTTP1.Handler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:18: Bandit.DelegatingHandler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:8: Bandit.DelegatingHandler.handle_continue/2
    (stdlib 5.2.3.2) gen_server.erl:1085: :gen_server.try_handle_continue/3
    (stdlib 5.2.3.2) gen_server.erl:995: :gen_server.loop/7
    (stdlib 5.2.3.2) proc_lib.erl:241: :proc_lib.init_p_do_apply/3

2026-06-07 05:46:18 [INFO] GET /
2026-06-07 05:46:18 [DEBUG] ** (Phoenix.Router.NoRouteError) no route found for GET / (UpiStatic.Router)
    (upi_static 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/phoenix/lib/phoenix/router.ex:465: UpiStatic.Router.call/2
    (upi_static 0.1.0) lib/upi_static/endpoint.ex:1: UpiStatic.Endpoint.plug_builder_call/2
    (upi_static 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/plug/lib/plug/debugger.ex:155: UpiStatic.Endpoint."call (overridable 3)"/2
    (upi_static 0.1.0) lib/upi_static/endpoint.ex:1: UpiStatic.Endpoint.call/2
    (phoenix 1.8.0) lib/phoenix/endpoint/sync_code_reload_plug.ex:22: Phoenix.Endpoint.SyncCodeReloadPlug.do_call/4
    (bandit 1.7.0) lib/bandit/pipeline.ex:131: Bandit.Pipeline.call_plug!/2
    (bandit 1.7.0) lib/bandit/pipeline.ex:42: Bandit.Pipeline.run/5
    (bandit 1.7.0) lib/bandit/http1/handler.ex:13: Bandit.HTTP1.Handler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:18: Bandit.DelegatingHandler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:8: Bandit.DelegatingHandler.handle_continue/2
    (stdlib 5.2.3.2) gen_server.erl:1085: :gen_server.try_handle_continue/3
    (stdlib 5.2.3.2) gen_server.erl:995: :gen_server.loop/7
    (stdlib 5.2.3.2) proc_lib.erl:241: :proc_lib.init_p_do_apply/3

2026-06-07 09:35:35 [ERROR] ** (Bandit.HTTPError) Request line HTTP error: "MGLNDD_78.47.213.209_4040\n"
2026-06-07 09:44:08 [ERROR] ** (Bandit.HTTPError) Request line HTTP error: "MGLNDD_78.47.213.210_4040\n"
2026-06-07 09:45:24 [ERROR] ** (Bandit.HTTPError) Request line HTTP error: "MGLNDD_78.47.213.211_4040\n"
2026-06-07 11:36:36 [INFO] GET /
2026-06-07 11:36:36 [DEBUG] Processing with UpiWeb.PageController.home/2
  Parameters: %{}
  Pipelines: [:browser]
2026-06-07 11:36:36 [INFO] Sent 200 in 7ms
2026-06-07 11:36:49 [INFO] POST /mcp
2026-06-07 11:36:49 [DEBUG] ** (Phoenix.Router.NoRouteError) no route found for POST /mcp (UpiWeb.Router)
    (upi_web 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/phoenix/lib/phoenix/router.ex:465: UpiWeb.Router.call/2
    (upi_web 0.1.0) lib/upi_web/endpoint.ex:1: UpiWeb.Endpoint.plug_builder_call/2
    (upi_web 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/plug/lib/plug/debugger.ex:155: UpiWeb.Endpoint."call (overridable 3)"/2
    (upi_web 0.1.0) lib/upi_web/endpoint.ex:1: UpiWeb.Endpoint.call/2
    (phoenix 1.8.0) lib/phoenix/endpoint/sync_code_reload_plug.ex:22: Phoenix.Endpoint.SyncCodeReloadPlug.do_call/4
    (bandit 1.7.0) lib/bandit/pipeline.ex:131: Bandit.Pipeline.call_plug!/2
    (bandit 1.7.0) lib/bandit/pipeline.ex:42: Bandit.Pipeline.run/5
    (bandit 1.7.0) lib/bandit/http1/handler.ex:13: Bandit.HTTP1.Handler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:18: Bandit.DelegatingHandler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:8: Bandit.DelegatingHandler.handle_continue/2
    (stdlib 5.2.3.2) gen_server.erl:1085: :gen_server.try_handle_continue/3
    (stdlib 5.2.3.2) gen_server.erl:995: :gen_server.loop/7
    (stdlib 5.2.3.2) proc_lib.erl:241: :proc_lib.init_p_do_apply/3

2026-06-07 17:30:00 [INFO] [Scheduler] settlement trigger fired at 2026-06-07T17:30:00.000660Z
2026-06-07 17:30:00 [DEBUG] [Scheduler] next tick in 11099s
2026-06-07 17:30:00 [DEBUG] QUERY OK source="merchants" db=3.6ms idle=1351.7ms
SELECT m0.`id`, m0.`mid`, m0.`tid`, m0.`sid`, m0.`sub_code`, m0.`merchant_type`, m0.`merchant_genre`, m0.`onboarding_type`, m0.`inst_code`, m0.`country_code`, m0.`network_inst_id`, m0.`merchant_code`, m0.`brand_name`, m0.`legal_name`, m0.`franchise_name`, m0.`ownership_type`, m0.`merchant_vpa`, m0.`business_type`, m0.`business_category`, m0.`static_qr_code`, m0.`qr_enabled`, m0.`dynamic_qr_enabled`, m0.`max_transaction_limit`, m0.`daily_transaction_limit`, m0.`corridor`, m0.`local_currency`, m0.`fx_markup_rate`, m0.`settlement_frequency`, m0.`settlement_account_intl`, m0.`settlement_account_number`, m0.`settlement_account_ifsc`, m0.`settlement_account_type`, m0.`settlement_bank_country`, m0.`contact_person`, m0.`contact_email`, m0.`contact_phone`, m0.`address`, m0.`city`, m0.`state`, m0.`pincode`, m0.`gstin`, m0.`pan`, m0.`regulatory_license`, m0.`compliance_status`, m0.`risk_category`, m0.`intl_status`, m0.`status`, m0.`onboarded_at`, m0.`last_transaction_at`, m0.`partner_managed`, m0.`partner_id`, m0.`inserted_at`, m0.`updated_at` FROM `merchants` AS m0 WHERE (m0.`status` = 'active') []
[90m↳ UpiSettlement.SettlementService.run_settlement_pass/1, at: lib/upi_settlement/settlement_service.ex:106[0m
2026-06-07 17:30:00 [DEBUG] QUERY OK source="settlements" db=0.6ms idle=1355.6ms
SELECT TRUE FROM `settlements` AS s0 WHERE (((s0.`merchant_id` = ?) AND (s0.`settlement_window_start` = ?)) AND (s0.`settlement_window_end` = ?)) LIMIT 1 [1, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.SettlementService.generate_merchant_settlement_batch/3, at: lib/upi_settlement/settlement_service.ex:82[0m
2026-06-07 17:30:00 [DEBUG] QUERY OK source="transactions" db=4.3ms idle=1356.4ms
SELECT t0.`id`, t0.`settlement_status`, t0.`settlement_id`, t0.`org_txn_id`, t0.`parent_qr_validation_id`, t0.`payer_addr`, t0.`payer_name`, t0.`payee_addr`, t0.`payee_name`, t0.`payee_mid`, t0.`payer_bank_ref`, t0.`inr_amount`, t0.`currency`, t0.`foreign_amount`, t0.`foreign_currency`, t0.`fx_rate`, t0.`markup_rate`, t0.`markup_pct`, t0.`corridor`, t0.`transaction_type`, t0.`fx_provider`, t0.`fx_locked_at`, t0.`ver_token`, t0.`network_inst_id`, t0.`req_msg_id`, t0.`resp_msg_id`, t0.`current_state`, t0.`status`, t0.`npci_received_at`, t0.`debit_secured_at`, t0.`credit_requested_at`, t0.`partner_credited_at`, t0.`credit_completed_at`, t0.`chktxn_requested_at`, t0.`chktxn_ref_id`, t0.`reversal_requested_at`, t0.`completed_at`, t0.`finalized_at`, t0.`failure_code`, t0.`failure_reason`, t0.`deemed`, t0.`partner_txn_id`, t0.`npci_reversal_ref`, t0.`partner_id`, t0.`merchant_id`, t0.`inserted_at`, t0.`updated_at` FROM `transactions` AS t0 WHERE (((((t0.`merchant_id` = ?) AND (t0.`settlement_id` IS NULL)) AND ((t0.`status` = 'success') OR (t0.`deemed` = TRUE))) AND (t0.`inserted_at` >= ?)) AND (t0.`inserted_at` <= ?)) [1, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.Settlements.aggregate_eligible_transactions/2, at: lib/upi_settlement/settlements.ex:194[0m
2026-06-07 17:30:00 [DEBUG] [SettlementService] no eligible transactions merchant=1 date=2026-06-07
2026-06-07 17:30:00 [DEBUG] QUERY OK source="settlements" db=2.1ms idle=1361.2ms
SELECT TRUE FROM `settlements` AS s0 WHERE (((s0.`merchant_id` = ?) AND (s0.`settlement_window_start` = ?)) AND (s0.`settlement_window_end` = ?)) LIMIT 1 [2, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.SettlementService.generate_merchant_settlement_batch/3, at: lib/upi_settlement/settlement_service.ex:82[0m
2026-06-07 17:30:00 [DEBUG] QUERY OK source="transactions" db=1.7ms idle=1363.6ms
SELECT t0.`id`, t0.`settlement_status`, t0.`settlement_id`, t0.`org_txn_id`, t0.`parent_qr_validation_id`, t0.`payer_addr`, t0.`payer_name`, t0.`payee_addr`, t0.`payee_name`, t0.`payee_mid`, t0.`payer_bank_ref`, t0.`inr_amount`, t0.`currency`, t0.`foreign_amount`, t0.`foreign_currency`, t0.`fx_rate`, t0.`markup_rate`, t0.`markup_pct`, t0.`corridor`, t0.`transaction_type`, t0.`fx_provider`, t0.`fx_locked_at`, t0.`ver_token`, t0.`network_inst_id`, t0.`req_msg_id`, t0.`resp_msg_id`, t0.`current_state`, t0.`status`, t0.`npci_received_at`, t0.`debit_secured_at`, t0.`credit_requested_at`, t0.`partner_credited_at`, t0.`credit_completed_at`, t0.`chktxn_requested_at`, t0.`chktxn_ref_id`, t0.`reversal_requested_at`, t0.`completed_at`, t0.`finalized_at`, t0.`failure_code`, t0.`failure_reason`, t0.`deemed`, t0.`partner_txn_id`, t0.`npci_reversal_ref`, t0.`partner_id`, t0.`merchant_id`, t0.`inserted_at`, t0.`updated_at` FROM `transactions` AS t0 WHERE (((((t0.`merchant_id` = ?) AND (t0.`settlement_id` IS NULL)) AND ((t0.`status` = 'success') OR (t0.`deemed` = TRUE))) AND (t0.`inserted_at` >= ?)) AND (t0.`inserted_at` <= ?)) [2, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.Settlements.aggregate_eligible_transactions/2, at: lib/upi_settlement/settlements.ex:194[0m
2026-06-07 17:30:00 [DEBUG] [SettlementService] no eligible transactions merchant=2 date=2026-06-07
2026-06-07 17:30:00 [DEBUG] QUERY OK source="settlements" db=0.7ms idle=1365.8ms
SELECT TRUE FROM `settlements` AS s0 WHERE (((s0.`merchant_id` = ?) AND (s0.`settlement_window_start` = ?)) AND (s0.`settlement_window_end` = ?)) LIMIT 1 [3, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.SettlementService.generate_merchant_settlement_batch/3, at: lib/upi_settlement/settlement_service.ex:82[0m
2026-06-07 17:30:00 [DEBUG] QUERY OK source="transactions" db=2.1ms idle=368.0ms
SELECT t0.`id`, t0.`settlement_status`, t0.`settlement_id`, t0.`org_txn_id`, t0.`parent_qr_validation_id`, t0.`payer_addr`, t0.`payer_name`, t0.`payee_addr`, t0.`payee_name`, t0.`payee_mid`, t0.`payer_bank_ref`, t0.`inr_amount`, t0.`currency`, t0.`foreign_amount`, t0.`foreign_currency`, t0.`fx_rate`, t0.`markup_rate`, t0.`markup_pct`, t0.`corridor`, t0.`transaction_type`, t0.`fx_provider`, t0.`fx_locked_at`, t0.`ver_token`, t0.`network_inst_id`, t0.`req_msg_id`, t0.`resp_msg_id`, t0.`current_state`, t0.`status`, t0.`npci_received_at`, t0.`debit_secured_at`, t0.`credit_requested_at`, t0.`partner_credited_at`, t0.`credit_completed_at`, t0.`chktxn_requested_at`, t0.`chktxn_ref_id`, t0.`reversal_requested_at`, t0.`completed_at`, t0.`finalized_at`, t0.`failure_code`, t0.`failure_reason`, t0.`deemed`, t0.`partner_txn_id`, t0.`npci_reversal_ref`, t0.`partner_id`, t0.`merchant_id`, t0.`inserted_at`, t0.`updated_at` FROM `transactions` AS t0 WHERE (((((t0.`merchant_id` = ?) AND (t0.`settlement_id` IS NULL)) AND ((t0.`status` = 'success') OR (t0.`deemed` = TRUE))) AND (t0.`inserted_at` >= ?)) AND (t0.`inserted_at` <= ?)) [3, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.Settlements.aggregate_eligible_transactions/2, at: lib/upi_settlement/settlements.ex:194[0m
2026-06-07 17:30:00 [DEBUG] [SettlementService] no eligible transactions merchant=3 date=2026-06-07
2026-06-07 17:30:00 [DEBUG] QUERY OK source="settlements" db=0.5ms idle=370.6ms
SELECT TRUE FROM `settlements` AS s0 WHERE (((s0.`merchant_id` = ?) AND (s0.`settlement_window_start` = ?)) AND (s0.`settlement_window_end` = ?)) LIMIT 1 [4, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.SettlementService.generate_merchant_settlement_batch/3, at: lib/upi_settlement/settlement_service.ex:82[0m
2026-06-07 17:30:00 [DEBUG] QUERY OK source="transactions" db=2.6ms idle=371.4ms
SELECT t0.`id`, t0.`settlement_status`, t0.`settlement_id`, t0.`org_txn_id`, t0.`parent_qr_validation_id`, t0.`payer_addr`, t0.`payer_name`, t0.`payee_addr`, t0.`payee_name`, t0.`payee_mid`, t0.`payer_bank_ref`, t0.`inr_amount`, t0.`currency`, t0.`foreign_amount`, t0.`foreign_currency`, t0.`fx_rate`, t0.`markup_rate`, t0.`markup_pct`, t0.`corridor`, t0.`transaction_type`, t0.`fx_provider`, t0.`fx_locked_at`, t0.`ver_token`, t0.`network_inst_id`, t0.`req_msg_id`, t0.`resp_msg_id`, t0.`current_state`, t0.`status`, t0.`npci_received_at`, t0.`debit_secured_at`, t0.`credit_requested_at`, t0.`partner_credited_at`, t0.`credit_completed_at`, t0.`chktxn_requested_at`, t0.`chktxn_ref_id`, t0.`reversal_requested_at`, t0.`completed_at`, t0.`finalized_at`, t0.`failure_code`, t0.`failure_reason`, t0.`deemed`, t0.`partner_txn_id`, t0.`npci_reversal_ref`, t0.`partner_id`, t0.`merchant_id`, t0.`inserted_at`, t0.`updated_at` FROM `transactions` AS t0 WHERE (((((t0.`merchant_id` = ?) AND (t0.`settlement_id` IS NULL)) AND ((t0.`status` = 'success') OR (t0.`deemed` = TRUE))) AND (t0.`inserted_at` >= ?)) AND (t0.`inserted_at` <= ?)) [4, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.Settlements.aggregate_eligible_transactions/2, at: lib/upi_settlement/settlements.ex:194[0m
2026-06-07 17:30:00 [DEBUG] [SettlementService] no eligible transactions merchant=4 date=2026-06-07
2026-06-07 17:30:00 [DEBUG] QUERY OK source="settlements" db=1.0ms idle=374.4ms
SELECT TRUE FROM `settlements` AS s0 WHERE (((s0.`merchant_id` = ?) AND (s0.`settlement_window_start` = ?)) AND (s0.`settlement_window_end` = ?)) LIMIT 1 [5, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.SettlementService.generate_merchant_settlement_batch/3, at: lib/upi_settlement/settlement_service.ex:82[0m
2026-06-07 17:30:00 [DEBUG] QUERY OK source="transactions" db=1.0ms idle=20.4ms
SELECT t0.`id`, t0.`settlement_status`, t0.`settlement_id`, t0.`org_txn_id`, t0.`parent_qr_validation_id`, t0.`payer_addr`, t0.`payer_name`, t0.`payee_addr`, t0.`payee_name`, t0.`payee_mid`, t0.`payer_bank_ref`, t0.`inr_amount`, t0.`currency`, t0.`foreign_amount`, t0.`foreign_currency`, t0.`fx_rate`, t0.`markup_rate`, t0.`markup_pct`, t0.`corridor`, t0.`transaction_type`, t0.`fx_provider`, t0.`fx_locked_at`, t0.`ver_token`, t0.`network_inst_id`, t0.`req_msg_id`, t0.`resp_msg_id`, t0.`current_state`, t0.`status`, t0.`npci_received_at`, t0.`debit_secured_at`, t0.`credit_requested_at`, t0.`partner_credited_at`, t0.`credit_completed_at`, t0.`chktxn_requested_at`, t0.`chktxn_ref_id`, t0.`reversal_requested_at`, t0.`completed_at`, t0.`finalized_at`, t0.`failure_code`, t0.`failure_reason`, t0.`deemed`, t0.`partner_txn_id`, t0.`npci_reversal_ref`, t0.`partner_id`, t0.`merchant_id`, t0.`inserted_at`, t0.`updated_at` FROM `transactions` AS t0 WHERE (((((t0.`merchant_id` = ?) AND (t0.`settlement_id` IS NULL)) AND ((t0.`status` = 'success') OR (t0.`deemed` = TRUE))) AND (t0.`inserted_at` >= ?)) AND (t0.`inserted_at` <= ?)) [5, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.Settlements.aggregate_eligible_transactions/2, at: lib/upi_settlement/settlements.ex:194[0m
2026-06-07 17:30:00 [DEBUG] [SettlementService] no eligible transactions merchant=5 date=2026-06-07
2026-06-07 17:30:00 [DEBUG] QUERY OK source="settlements" db=0.5ms idle=19.9ms
SELECT TRUE FROM `settlements` AS s0 WHERE (((s0.`merchant_id` = ?) AND (s0.`settlement_window_start` = ?)) AND (s0.`settlement_window_end` = ?)) LIMIT 1 [6, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.SettlementService.generate_merchant_settlement_batch/3, at: lib/upi_settlement/settlement_service.ex:82[0m
2026-06-07 17:30:00 [DEBUG] QUERY OK source="transactions" db=0.9ms idle=16.0ms
SELECT t0.`id`, t0.`settlement_status`, t0.`settlement_id`, t0.`org_txn_id`, t0.`parent_qr_validation_id`, t0.`payer_addr`, t0.`payer_name`, t0.`payee_addr`, t0.`payee_name`, t0.`payee_mid`, t0.`payer_bank_ref`, t0.`inr_amount`, t0.`currency`, t0.`foreign_amount`, t0.`foreign_currency`, t0.`fx_rate`, t0.`markup_rate`, t0.`markup_pct`, t0.`corridor`, t0.`transaction_type`, t0.`fx_provider`, t0.`fx_locked_at`, t0.`ver_token`, t0.`network_inst_id`, t0.`req_msg_id`, t0.`resp_msg_id`, t0.`current_state`, t0.`status`, t0.`npci_received_at`, t0.`debit_secured_at`, t0.`credit_requested_at`, t0.`partner_credited_at`, t0.`credit_completed_at`, t0.`chktxn_requested_at`, t0.`chktxn_ref_id`, t0.`reversal_requested_at`, t0.`completed_at`, t0.`finalized_at`, t0.`failure_code`, t0.`failure_reason`, t0.`deemed`, t0.`partner_txn_id`, t0.`npci_reversal_ref`, t0.`partner_id`, t0.`merchant_id`, t0.`inserted_at`, t0.`updated_at` FROM `transactions` AS t0 WHERE (((((t0.`merchant_id` = ?) AND (t0.`settlement_id` IS NULL)) AND ((t0.`status` = 'success') OR (t0.`deemed` = TRUE))) AND (t0.`inserted_at` >= ?)) AND (t0.`inserted_at` <= ?)) [6, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.Settlements.aggregate_eligible_transactions/2, at: lib/upi_settlement/settlements.ex:194[0m
2026-06-07 17:30:00 [DEBUG] [SettlementService] no eligible transactions merchant=6 date=2026-06-07
2026-06-07 17:30:00 [DEBUG] QUERY OK source="settlements" db=0.5ms idle=14.7ms
SELECT TRUE FROM `settlements` AS s0 WHERE (((s0.`merchant_id` = ?) AND (s0.`settlement_window_start` = ?)) AND (s0.`settlement_window_end` = ?)) LIMIT 1 [7, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.SettlementService.generate_merchant_settlement_batch/3, at: lib/upi_settlement/settlement_service.ex:82[0m
2026-06-07 17:30:00 [DEBUG] QUERY OK source="transactions" db=1.0ms idle=13.5ms
SELECT t0.`id`, t0.`settlement_status`, t0.`settlement_id`, t0.`org_txn_id`, t0.`parent_qr_validation_id`, t0.`payer_addr`, t0.`payer_name`, t0.`payee_addr`, t0.`payee_name`, t0.`payee_mid`, t0.`payer_bank_ref`, t0.`inr_amount`, t0.`currency`, t0.`foreign_amount`, t0.`foreign_currency`, t0.`fx_rate`, t0.`markup_rate`, t0.`markup_pct`, t0.`corridor`, t0.`transaction_type`, t0.`fx_provider`, t0.`fx_locked_at`, t0.`ver_token`, t0.`network_inst_id`, t0.`req_msg_id`, t0.`resp_msg_id`, t0.`current_state`, t0.`status`, t0.`npci_received_at`, t0.`debit_secured_at`, t0.`credit_requested_at`, t0.`partner_credited_at`, t0.`credit_completed_at`, t0.`chktxn_requested_at`, t0.`chktxn_ref_id`, t0.`reversal_requested_at`, t0.`completed_at`, t0.`finalized_at`, t0.`failure_code`, t0.`failure_reason`, t0.`deemed`, t0.`partner_txn_id`, t0.`npci_reversal_ref`, t0.`partner_id`, t0.`merchant_id`, t0.`inserted_at`, t0.`updated_at` FROM `transactions` AS t0 WHERE (((((t0.`merchant_id` = ?) AND (t0.`settlement_id` IS NULL)) AND ((t0.`status` = 'success') OR (t0.`deemed` = TRUE))) AND (t0.`inserted_at` >= ?)) AND (t0.`inserted_at` <= ?)) [7, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.Settlements.aggregate_eligible_transactions/2, at: lib/upi_settlement/settlements.ex:194[0m
2026-06-07 17:30:00 [DEBUG] [SettlementService] no eligible transactions merchant=7 date=2026-06-07
2026-06-07 17:30:00 [DEBUG] QUERY OK source="settlements" db=0.4ms idle=13.9ms
SELECT TRUE FROM `settlements` AS s0 WHERE (((s0.`merchant_id` = ?) AND (s0.`settlement_window_start` = ?)) AND (s0.`settlement_window_end` = ?)) LIMIT 1 [8, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.SettlementService.generate_merchant_settlement_batch/3, at: lib/upi_settlement/settlement_service.ex:82[0m
2026-06-07 17:30:00 [DEBUG] QUERY OK source="transactions" db=0.9ms idle=12.3ms
SELECT t0.`id`, t0.`settlement_status`, t0.`settlement_id`, t0.`org_txn_id`, t0.`parent_qr_validation_id`, t0.`payer_addr`, t0.`payer_name`, t0.`payee_addr`, t0.`payee_name`, t0.`payee_mid`, t0.`payer_bank_ref`, t0.`inr_amount`, t0.`currency`, t0.`foreign_amount`, t0.`foreign_currency`, t0.`fx_rate`, t0.`markup_rate`, t0.`markup_pct`, t0.`corridor`, t0.`transaction_type`, t0.`fx_provider`, t0.`fx_locked_at`, t0.`ver_token`, t0.`network_inst_id`, t0.`req_msg_id`, t0.`resp_msg_id`, t0.`current_state`, t0.`status`, t0.`npci_received_at`, t0.`debit_secured_at`, t0.`credit_requested_at`, t0.`partner_credited_at`, t0.`credit_completed_at`, t0.`chktxn_requested_at`, t0.`chktxn_ref_id`, t0.`reversal_requested_at`, t0.`completed_at`, t0.`finalized_at`, t0.`failure_code`, t0.`failure_reason`, t0.`deemed`, t0.`partner_txn_id`, t0.`npci_reversal_ref`, t0.`partner_id`, t0.`merchant_id`, t0.`inserted_at`, t0.`updated_at` FROM `transactions` AS t0 WHERE (((((t0.`merchant_id` = ?) AND (t0.`settlement_id` IS NULL)) AND ((t0.`status` = 'success') OR (t0.`deemed` = TRUE))) AND (t0.`inserted_at` >= ?)) AND (t0.`inserted_at` <= ?)) [8, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.Settlements.aggregate_eligible_transactions/2, at: lib/upi_settlement/settlements.ex:194[0m
2026-06-07 17:30:00 [DEBUG] [SettlementService] no eligible transactions merchant=8 date=2026-06-07
2026-06-07 17:30:00 [DEBUG] QUERY OK source="settlements" db=0.3ms idle=12.8ms
SELECT TRUE FROM `settlements` AS s0 WHERE (((s0.`merchant_id` = ?) AND (s0.`settlement_window_start` = ?)) AND (s0.`settlement_window_end` = ?)) LIMIT 1 [9, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.SettlementService.generate_merchant_settlement_batch/3, at: lib/upi_settlement/settlement_service.ex:82[0m
2026-06-07 17:30:00 [DEBUG] QUERY OK source="transactions" db=0.5ms idle=10.6ms
SELECT t0.`id`, t0.`settlement_status`, t0.`settlement_id`, t0.`org_txn_id`, t0.`parent_qr_validation_id`, t0.`payer_addr`, t0.`payer_name`, t0.`payee_addr`, t0.`payee_name`, t0.`payee_mid`, t0.`payer_bank_ref`, t0.`inr_amount`, t0.`currency`, t0.`foreign_amount`, t0.`foreign_currency`, t0.`fx_rate`, t0.`markup_rate`, t0.`markup_pct`, t0.`corridor`, t0.`transaction_type`, t0.`fx_provider`, t0.`fx_locked_at`, t0.`ver_token`, t0.`network_inst_id`, t0.`req_msg_id`, t0.`resp_msg_id`, t0.`current_state`, t0.`status`, t0.`npci_received_at`, t0.`debit_secured_at`, t0.`credit_requested_at`, t0.`partner_credited_at`, t0.`credit_completed_at`, t0.`chktxn_requested_at`, t0.`chktxn_ref_id`, t0.`reversal_requested_at`, t0.`completed_at`, t0.`finalized_at`, t0.`failure_code`, t0.`failure_reason`, t0.`deemed`, t0.`partner_txn_id`, t0.`npci_reversal_ref`, t0.`partner_id`, t0.`merchant_id`, t0.`inserted_at`, t0.`updated_at` FROM `transactions` AS t0 WHERE (((((t0.`merchant_id` = ?) AND (t0.`settlement_id` IS NULL)) AND ((t0.`status` = 'success') OR (t0.`deemed` = TRUE))) AND (t0.`inserted_at` >= ?)) AND (t0.`inserted_at` <= ?)) [9, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.Settlements.aggregate_eligible_transactions/2, at: lib/upi_settlement/settlements.ex:194[0m
2026-06-07 17:30:00 [DEBUG] [SettlementService] no eligible transactions merchant=9 date=2026-06-07
2026-06-07 17:30:00 [DEBUG] QUERY OK source="settlements" db=0.5ms idle=10.1ms
SELECT TRUE FROM `settlements` AS s0 WHERE (((s0.`merchant_id` = ?) AND (s0.`settlement_window_start` = ?)) AND (s0.`settlement_window_end` = ?)) LIMIT 1 [10, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.SettlementService.generate_merchant_settlement_batch/3, at: lib/upi_settlement/settlement_service.ex:82[0m
2026-06-07 17:30:00 [DEBUG] QUERY OK source="transactions" db=0.5ms idle=9.5ms
SELECT t0.`id`, t0.`settlement_status`, t0.`settlement_id`, t0.`org_txn_id`, t0.`parent_qr_validation_id`, t0.`payer_addr`, t0.`payer_name`, t0.`payee_addr`, t0.`payee_name`, t0.`payee_mid`, t0.`payer_bank_ref`, t0.`inr_amount`, t0.`currency`, t0.`foreign_amount`, t0.`foreign_currency`, t0.`fx_rate`, t0.`markup_rate`, t0.`markup_pct`, t0.`corridor`, t0.`transaction_type`, t0.`fx_provider`, t0.`fx_locked_at`, t0.`ver_token`, t0.`network_inst_id`, t0.`req_msg_id`, t0.`resp_msg_id`, t0.`current_state`, t0.`status`, t0.`npci_received_at`, t0.`debit_secured_at`, t0.`credit_requested_at`, t0.`partner_credited_at`, t0.`credit_completed_at`, t0.`chktxn_requested_at`, t0.`chktxn_ref_id`, t0.`reversal_requested_at`, t0.`completed_at`, t0.`finalized_at`, t0.`failure_code`, t0.`failure_reason`, t0.`deemed`, t0.`partner_txn_id`, t0.`npci_reversal_ref`, t0.`partner_id`, t0.`merchant_id`, t0.`inserted_at`, t0.`updated_at` FROM `transactions` AS t0 WHERE (((((t0.`merchant_id` = ?) AND (t0.`settlement_id` IS NULL)) AND ((t0.`status` = 'success') OR (t0.`deemed` = TRUE))) AND (t0.`inserted_at` >= ?)) AND (t0.`inserted_at` <= ?)) [10, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.Settlements.aggregate_eligible_transactions/2, at: lib/upi_settlement/settlements.ex:194[0m
2026-06-07 17:30:00 [DEBUG] [SettlementService] no eligible transactions merchant=10 date=2026-06-07
2026-06-07 17:30:00 [DEBUG] QUERY OK source="settlements" db=0.3ms idle=9.4ms
SELECT TRUE FROM `settlements` AS s0 WHERE (((s0.`merchant_id` = ?) AND (s0.`settlement_window_start` = ?)) AND (s0.`settlement_window_end` = ?)) LIMIT 1 [11, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.SettlementService.generate_merchant_settlement_batch/3, at: lib/upi_settlement/settlement_service.ex:82[0m
2026-06-07 17:30:00 [DEBUG] QUERY OK source="transactions" db=0.6ms idle=8.9ms
SELECT t0.`id`, t0.`settlement_status`, t0.`settlement_id`, t0.`org_txn_id`, t0.`parent_qr_validation_id`, t0.`payer_addr`, t0.`payer_name`, t0.`payee_addr`, t0.`payee_name`, t0.`payee_mid`, t0.`payer_bank_ref`, t0.`inr_amount`, t0.`currency`, t0.`foreign_amount`, t0.`foreign_currency`, t0.`fx_rate`, t0.`markup_rate`, t0.`markup_pct`, t0.`corridor`, t0.`transaction_type`, t0.`fx_provider`, t0.`fx_locked_at`, t0.`ver_token`, t0.`network_inst_id`, t0.`req_msg_id`, t0.`resp_msg_id`, t0.`current_state`, t0.`status`, t0.`npci_received_at`, t0.`debit_secured_at`, t0.`credit_requested_at`, t0.`partner_credited_at`, t0.`credit_completed_at`, t0.`chktxn_requested_at`, t0.`chktxn_ref_id`, t0.`reversal_requested_at`, t0.`completed_at`, t0.`finalized_at`, t0.`failure_code`, t0.`failure_reason`, t0.`deemed`, t0.`partner_txn_id`, t0.`npci_reversal_ref`, t0.`partner_id`, t0.`merchant_id`, t0.`inserted_at`, t0.`updated_at` FROM `transactions` AS t0 WHERE (((((t0.`merchant_id` = ?) AND (t0.`settlement_id` IS NULL)) AND ((t0.`status` = 'success') OR (t0.`deemed` = TRUE))) AND (t0.`inserted_at` >= ?)) AND (t0.`inserted_at` <= ?)) [11, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.Settlements.aggregate_eligible_transactions/2, at: lib/upi_settlement/settlements.ex:194[0m
2026-06-07 17:30:00 [DEBUG] [SettlementService] no eligible transactions merchant=11 date=2026-06-07
2026-06-07 17:30:00 [DEBUG] QUERY OK source="settlements" db=0.5ms idle=8.9ms
SELECT TRUE FROM `settlements` AS s0 WHERE (((s0.`merchant_id` = ?) AND (s0.`settlement_window_start` = ?)) AND (s0.`settlement_window_end` = ?)) LIMIT 1 [14, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.SettlementService.generate_merchant_settlement_batch/3, at: lib/upi_settlement/settlement_service.ex:82[0m
2026-06-07 17:30:00 [DEBUG] QUERY OK source="transactions" db=0.5ms idle=8.3ms
SELECT t0.`id`, t0.`settlement_status`, t0.`settlement_id`, t0.`org_txn_id`, t0.`parent_qr_validation_id`, t0.`payer_addr`, t0.`payer_name`, t0.`payee_addr`, t0.`payee_name`, t0.`payee_mid`, t0.`payer_bank_ref`, t0.`inr_amount`, t0.`currency`, t0.`foreign_amount`, t0.`foreign_currency`, t0.`fx_rate`, t0.`markup_rate`, t0.`markup_pct`, t0.`corridor`, t0.`transaction_type`, t0.`fx_provider`, t0.`fx_locked_at`, t0.`ver_token`, t0.`network_inst_id`, t0.`req_msg_id`, t0.`resp_msg_id`, t0.`current_state`, t0.`status`, t0.`npci_received_at`, t0.`debit_secured_at`, t0.`credit_requested_at`, t0.`partner_credited_at`, t0.`credit_completed_at`, t0.`chktxn_requested_at`, t0.`chktxn_ref_id`, t0.`reversal_requested_at`, t0.`completed_at`, t0.`finalized_at`, t0.`failure_code`, t0.`failure_reason`, t0.`deemed`, t0.`partner_txn_id`, t0.`npci_reversal_ref`, t0.`partner_id`, t0.`merchant_id`, t0.`inserted_at`, t0.`updated_at` FROM `transactions` AS t0 WHERE (((((t0.`merchant_id` = ?) AND (t0.`settlement_id` IS NULL)) AND ((t0.`status` = 'success') OR (t0.`deemed` = TRUE))) AND (t0.`inserted_at` >= ?)) AND (t0.`inserted_at` <= ?)) [14, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.Settlements.aggregate_eligible_transactions/2, at: lib/upi_settlement/settlements.ex:194[0m
2026-06-07 17:30:00 [DEBUG] [SettlementService] no eligible transactions merchant=14 date=2026-06-07
2026-06-07 17:30:00 [DEBUG] QUERY OK source="settlements" db=0.5ms idle=8.4ms
SELECT TRUE FROM `settlements` AS s0 WHERE (((s0.`merchant_id` = ?) AND (s0.`settlement_window_start` = ?)) AND (s0.`settlement_window_end` = ?)) LIMIT 1 [15, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.SettlementService.generate_merchant_settlement_batch/3, at: lib/upi_settlement/settlement_service.ex:82[0m
2026-06-07 17:30:00 [DEBUG] QUERY OK source="transactions" db=0.9ms idle=7.8ms
SELECT t0.`id`, t0.`settlement_status`, t0.`settlement_id`, t0.`org_txn_id`, t0.`parent_qr_validation_id`, t0.`payer_addr`, t0.`payer_name`, t0.`payee_addr`, t0.`payee_name`, t0.`payee_mid`, t0.`payer_bank_ref`, t0.`inr_amount`, t0.`currency`, t0.`foreign_amount`, t0.`foreign_currency`, t0.`fx_rate`, t0.`markup_rate`, t0.`markup_pct`, t0.`corridor`, t0.`transaction_type`, t0.`fx_provider`, t0.`fx_locked_at`, t0.`ver_token`, t0.`network_inst_id`, t0.`req_msg_id`, t0.`resp_msg_id`, t0.`current_state`, t0.`status`, t0.`npci_received_at`, t0.`debit_secured_at`, t0.`credit_requested_at`, t0.`partner_credited_at`, t0.`credit_completed_at`, t0.`chktxn_requested_at`, t0.`chktxn_ref_id`, t0.`reversal_requested_at`, t0.`completed_at`, t0.`finalized_at`, t0.`failure_code`, t0.`failure_reason`, t0.`deemed`, t0.`partner_txn_id`, t0.`npci_reversal_ref`, t0.`partner_id`, t0.`merchant_id`, t0.`inserted_at`, t0.`updated_at` FROM `transactions` AS t0 WHERE (((((t0.`merchant_id` = ?) AND (t0.`settlement_id` IS NULL)) AND ((t0.`status` = 'success') OR (t0.`deemed` = TRUE))) AND (t0.`inserted_at` >= ?)) AND (t0.`inserted_at` <= ?)) [15, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.Settlements.aggregate_eligible_transactions/2, at: lib/upi_settlement/settlements.ex:194[0m
2026-06-07 17:30:00 [DEBUG] [SettlementService] no eligible transactions merchant=15 date=2026-06-07
2026-06-07 17:30:00 [DEBUG] QUERY OK source="settlements" db=0.2ms idle=8.2ms
SELECT TRUE FROM `settlements` AS s0 WHERE (((s0.`merchant_id` = ?) AND (s0.`settlement_window_start` = ?)) AND (s0.`settlement_window_end` = ?)) LIMIT 1 [16, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.SettlementService.generate_merchant_settlement_batch/3, at: lib/upi_settlement/settlement_service.ex:82[0m
2026-06-07 17:30:00 [DEBUG] QUERY OK source="transactions" db=0.6ms idle=7.8ms
SELECT t0.`id`, t0.`settlement_status`, t0.`settlement_id`, t0.`org_txn_id`, t0.`parent_qr_validation_id`, t0.`payer_addr`, t0.`payer_name`, t0.`payee_addr`, t0.`payee_name`, t0.`payee_mid`, t0.`payer_bank_ref`, t0.`inr_amount`, t0.`currency`, t0.`foreign_amount`, t0.`foreign_currency`, t0.`fx_rate`, t0.`markup_rate`, t0.`markup_pct`, t0.`corridor`, t0.`transaction_type`, t0.`fx_provider`, t0.`fx_locked_at`, t0.`ver_token`, t0.`network_inst_id`, t0.`req_msg_id`, t0.`resp_msg_id`, t0.`current_state`, t0.`status`, t0.`npci_received_at`, t0.`debit_secured_at`, t0.`credit_requested_at`, t0.`partner_credited_at`, t0.`credit_completed_at`, t0.`chktxn_requested_at`, t0.`chktxn_ref_id`, t0.`reversal_requested_at`, t0.`completed_at`, t0.`finalized_at`, t0.`failure_code`, t0.`failure_reason`, t0.`deemed`, t0.`partner_txn_id`, t0.`npci_reversal_ref`, t0.`partner_id`, t0.`merchant_id`, t0.`inserted_at`, t0.`updated_at` FROM `transactions` AS t0 WHERE (((((t0.`merchant_id` = ?) AND (t0.`settlement_id` IS NULL)) AND ((t0.`status` = 'success') OR (t0.`deemed` = TRUE))) AND (t0.`inserted_at` >= ?)) AND (t0.`inserted_at` <= ?)) [16, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.Settlements.aggregate_eligible_transactions/2, at: lib/upi_settlement/settlements.ex:194[0m
2026-06-07 17:30:00 [DEBUG] [SettlementService] no eligible transactions merchant=16 date=2026-06-07
2026-06-07 17:30:00 [DEBUG] QUERY OK source="settlements" db=0.3ms idle=7.9ms
SELECT TRUE FROM `settlements` AS s0 WHERE (((s0.`merchant_id` = ?) AND (s0.`settlement_window_start` = ?)) AND (s0.`settlement_window_end` = ?)) LIMIT 1 [19, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.SettlementService.generate_merchant_settlement_batch/3, at: lib/upi_settlement/settlement_service.ex:82[0m
2026-06-07 17:30:00 [DEBUG] QUERY OK source="transactions" db=0.9ms queue=0.2ms idle=7.7ms
SELECT t0.`id`, t0.`settlement_status`, t0.`settlement_id`, t0.`org_txn_id`, t0.`parent_qr_validation_id`, t0.`payer_addr`, t0.`payer_name`, t0.`payee_addr`, t0.`payee_name`, t0.`payee_mid`, t0.`payer_bank_ref`, t0.`inr_amount`, t0.`currency`, t0.`foreign_amount`, t0.`foreign_currency`, t0.`fx_rate`, t0.`markup_rate`, t0.`markup_pct`, t0.`corridor`, t0.`transaction_type`, t0.`fx_provider`, t0.`fx_locked_at`, t0.`ver_token`, t0.`network_inst_id`, t0.`req_msg_id`, t0.`resp_msg_id`, t0.`current_state`, t0.`status`, t0.`npci_received_at`, t0.`debit_secured_at`, t0.`credit_requested_at`, t0.`partner_credited_at`, t0.`credit_completed_at`, t0.`chktxn_requested_at`, t0.`chktxn_ref_id`, t0.`reversal_requested_at`, t0.`completed_at`, t0.`finalized_at`, t0.`failure_code`, t0.`failure_reason`, t0.`deemed`, t0.`partner_txn_id`, t0.`npci_reversal_ref`, t0.`partner_id`, t0.`merchant_id`, t0.`inserted_at`, t0.`updated_at` FROM `transactions` AS t0 WHERE (((((t0.`merchant_id` = ?) AND (t0.`settlement_id` IS NULL)) AND ((t0.`status` = 'success') OR (t0.`deemed` = TRUE))) AND (t0.`inserted_at` >= ?)) AND (t0.`inserted_at` <= ?)) [19, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.Settlements.aggregate_eligible_transactions/2, at: lib/upi_settlement/settlements.ex:194[0m
2026-06-07 17:30:00 [DEBUG] [SettlementService] no eligible transactions merchant=19 date=2026-06-07
2026-06-07 17:30:00 [DEBUG] QUERY OK source="settlements" db=0.5ms idle=8.7ms
SELECT TRUE FROM `settlements` AS s0 WHERE (((s0.`merchant_id` = ?) AND (s0.`settlement_window_start` = ?)) AND (s0.`settlement_window_end` = ?)) LIMIT 1 [21, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.SettlementService.generate_merchant_settlement_batch/3, at: lib/upi_settlement/settlement_service.ex:82[0m
2026-06-07 17:30:00 [DEBUG] QUERY OK source="transactions" db=0.7ms queue=0.2ms idle=8.6ms
SELECT t0.`id`, t0.`settlement_status`, t0.`settlement_id`, t0.`org_txn_id`, t0.`parent_qr_validation_id`, t0.`payer_addr`, t0.`payer_name`, t0.`payee_addr`, t0.`payee_name`, t0.`payee_mid`, t0.`payer_bank_ref`, t0.`inr_amount`, t0.`currency`, t0.`foreign_amount`, t0.`foreign_currency`, t0.`fx_rate`, t0.`markup_rate`, t0.`markup_pct`, t0.`corridor`, t0.`transaction_type`, t0.`fx_provider`, t0.`fx_locked_at`, t0.`ver_token`, t0.`network_inst_id`, t0.`req_msg_id`, t0.`resp_msg_id`, t0.`current_state`, t0.`status`, t0.`npci_received_at`, t0.`debit_secured_at`, t0.`credit_requested_at`, t0.`partner_credited_at`, t0.`credit_completed_at`, t0.`chktxn_requested_at`, t0.`chktxn_ref_id`, t0.`reversal_requested_at`, t0.`completed_at`, t0.`finalized_at`, t0.`failure_code`, t0.`failure_reason`, t0.`deemed`, t0.`partner_txn_id`, t0.`npci_reversal_ref`, t0.`partner_id`, t0.`merchant_id`, t0.`inserted_at`, t0.`updated_at` FROM `transactions` AS t0 WHERE (((((t0.`merchant_id` = ?) AND (t0.`settlement_id` IS NULL)) AND ((t0.`status` = 'success') OR (t0.`deemed` = TRUE))) AND (t0.`inserted_at` >= ?)) AND (t0.`inserted_at` <= ?)) [21, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.Settlements.aggregate_eligible_transactions/2, at: lib/upi_settlement/settlements.ex:194[0m
2026-06-07 17:30:00 [DEBUG] [SettlementService] no eligible transactions merchant=21 date=2026-06-07
2026-06-07 17:30:00 [DEBUG] QUERY OK source="settlements" db=0.7ms idle=9.0ms
SELECT TRUE FROM `settlements` AS s0 WHERE (((s0.`merchant_id` = ?) AND (s0.`settlement_window_start` = ?)) AND (s0.`settlement_window_end` = ?)) LIMIT 1 [22, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.SettlementService.generate_merchant_settlement_batch/3, at: lib/upi_settlement/settlement_service.ex:82[0m
2026-06-07 17:30:00 [DEBUG] QUERY OK source="transactions" db=0.5ms idle=9.1ms
SELECT t0.`id`, t0.`settlement_status`, t0.`settlement_id`, t0.`org_txn_id`, t0.`parent_qr_validation_id`, t0.`payer_addr`, t0.`payer_name`, t0.`payee_addr`, t0.`payee_name`, t0.`payee_mid`, t0.`payer_bank_ref`, t0.`inr_amount`, t0.`currency`, t0.`foreign_amount`, t0.`foreign_currency`, t0.`fx_rate`, t0.`markup_rate`, t0.`markup_pct`, t0.`corridor`, t0.`transaction_type`, t0.`fx_provider`, t0.`fx_locked_at`, t0.`ver_token`, t0.`network_inst_id`, t0.`req_msg_id`, t0.`resp_msg_id`, t0.`current_state`, t0.`status`, t0.`npci_received_at`, t0.`debit_secured_at`, t0.`credit_requested_at`, t0.`partner_credited_at`, t0.`credit_completed_at`, t0.`chktxn_requested_at`, t0.`chktxn_ref_id`, t0.`reversal_requested_at`, t0.`completed_at`, t0.`finalized_at`, t0.`failure_code`, t0.`failure_reason`, t0.`deemed`, t0.`partner_txn_id`, t0.`npci_reversal_ref`, t0.`partner_id`, t0.`merchant_id`, t0.`inserted_at`, t0.`updated_at` FROM `transactions` AS t0 WHERE (((((t0.`merchant_id` = ?) AND (t0.`settlement_id` IS NULL)) AND ((t0.`status` = 'success') OR (t0.`deemed` = TRUE))) AND (t0.`inserted_at` >= ?)) AND (t0.`inserted_at` <= ?)) [22, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.Settlements.aggregate_eligible_transactions/2, at: lib/upi_settlement/settlements.ex:194[0m
2026-06-07 17:30:00 [DEBUG] [SettlementService] no eligible transactions merchant=22 date=2026-06-07
2026-06-07 17:30:00 [DEBUG] QUERY OK source="settlements" db=0.6ms idle=10.6ms
SELECT TRUE FROM `settlements` AS s0 WHERE (((s0.`merchant_id` = ?) AND (s0.`settlement_window_start` = ?)) AND (s0.`settlement_window_end` = ?)) LIMIT 1 [23, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.SettlementService.generate_merchant_settlement_batch/3, at: lib/upi_settlement/settlement_service.ex:82[0m
2026-06-07 17:30:00 [DEBUG] QUERY OK source="transactions" db=0.9ms idle=10.3ms
SELECT t0.`id`, t0.`settlement_status`, t0.`settlement_id`, t0.`org_txn_id`, t0.`parent_qr_validation_id`, t0.`payer_addr`, t0.`payer_name`, t0.`payee_addr`, t0.`payee_name`, t0.`payee_mid`, t0.`payer_bank_ref`, t0.`inr_amount`, t0.`currency`, t0.`foreign_amount`, t0.`foreign_currency`, t0.`fx_rate`, t0.`markup_rate`, t0.`markup_pct`, t0.`corridor`, t0.`transaction_type`, t0.`fx_provider`, t0.`fx_locked_at`, t0.`ver_token`, t0.`network_inst_id`, t0.`req_msg_id`, t0.`resp_msg_id`, t0.`current_state`, t0.`status`, t0.`npci_received_at`, t0.`debit_secured_at`, t0.`credit_requested_at`, t0.`partner_credited_at`, t0.`credit_completed_at`, t0.`chktxn_requested_at`, t0.`chktxn_ref_id`, t0.`reversal_requested_at`, t0.`completed_at`, t0.`finalized_at`, t0.`failure_code`, t0.`failure_reason`, t0.`deemed`, t0.`partner_txn_id`, t0.`npci_reversal_ref`, t0.`partner_id`, t0.`merchant_id`, t0.`inserted_at`, t0.`updated_at` FROM `transactions` AS t0 WHERE (((((t0.`merchant_id` = ?) AND (t0.`settlement_id` IS NULL)) AND ((t0.`status` = 'success') OR (t0.`deemed` = TRUE))) AND (t0.`inserted_at` >= ?)) AND (t0.`inserted_at` <= ?)) [23, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.Settlements.aggregate_eligible_transactions/2, at: lib/upi_settlement/settlements.ex:194[0m
2026-06-07 17:30:00 [DEBUG] [SettlementService] no eligible transactions merchant=23 date=2026-06-07
2026-06-07 17:30:00 [DEBUG] QUERY OK source="settlements" db=2.2ms idle=11.0ms
SELECT TRUE FROM `settlements` AS s0 WHERE (((s0.`merchant_id` = ?) AND (s0.`settlement_window_start` = ?)) AND (s0.`settlement_window_end` = ?)) LIMIT 1 [24, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.SettlementService.generate_merchant_settlement_batch/3, at: lib/upi_settlement/settlement_service.ex:82[0m
2026-06-07 17:30:00 [DEBUG] QUERY OK source="transactions" db=0.5ms idle=12.7ms
SELECT t0.`id`, t0.`settlement_status`, t0.`settlement_id`, t0.`org_txn_id`, t0.`parent_qr_validation_id`, t0.`payer_addr`, t0.`payer_name`, t0.`payee_addr`, t0.`payee_name`, t0.`payee_mid`, t0.`payer_bank_ref`, t0.`inr_amount`, t0.`currency`, t0.`foreign_amount`, t0.`foreign_currency`, t0.`fx_rate`, t0.`markup_rate`, t0.`markup_pct`, t0.`corridor`, t0.`transaction_type`, t0.`fx_provider`, t0.`fx_locked_at`, t0.`ver_token`, t0.`network_inst_id`, t0.`req_msg_id`, t0.`resp_msg_id`, t0.`current_state`, t0.`status`, t0.`npci_received_at`, t0.`debit_secured_at`, t0.`credit_requested_at`, t0.`partner_credited_at`, t0.`credit_completed_at`, t0.`chktxn_requested_at`, t0.`chktxn_ref_id`, t0.`reversal_requested_at`, t0.`completed_at`, t0.`finalized_at`, t0.`failure_code`, t0.`failure_reason`, t0.`deemed`, t0.`partner_txn_id`, t0.`npci_reversal_ref`, t0.`partner_id`, t0.`merchant_id`, t0.`inserted_at`, t0.`updated_at` FROM `transactions` AS t0 WHERE (((((t0.`merchant_id` = ?) AND (t0.`settlement_id` IS NULL)) AND ((t0.`status` = 'success') OR (t0.`deemed` = TRUE))) AND (t0.`inserted_at` >= ?)) AND (t0.`inserted_at` <= ?)) [24, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.Settlements.aggregate_eligible_transactions/2, at: lib/upi_settlement/settlements.ex:194[0m
2026-06-07 17:30:00 [DEBUG] [SettlementService] no eligible transactions merchant=24 date=2026-06-07
2026-06-07 17:30:00 [DEBUG] QUERY OK source="settlements" db=0.3ms idle=13.0ms
SELECT TRUE FROM `settlements` AS s0 WHERE (((s0.`merchant_id` = ?) AND (s0.`settlement_window_start` = ?)) AND (s0.`settlement_window_end` = ?)) LIMIT 1 [25, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.SettlementService.generate_merchant_settlement_batch/3, at: lib/upi_settlement/settlement_service.ex:82[0m
2026-06-07 17:30:00 [DEBUG] QUERY OK source="transactions" db=0.5ms idle=12.2ms
SELECT t0.`id`, t0.`settlement_status`, t0.`settlement_id`, t0.`org_txn_id`, t0.`parent_qr_validation_id`, t0.`payer_addr`, t0.`payer_name`, t0.`payee_addr`, t0.`payee_name`, t0.`payee_mid`, t0.`payer_bank_ref`, t0.`inr_amount`, t0.`currency`, t0.`foreign_amount`, t0.`foreign_currency`, t0.`fx_rate`, t0.`markup_rate`, t0.`markup_pct`, t0.`corridor`, t0.`transaction_type`, t0.`fx_provider`, t0.`fx_locked_at`, t0.`ver_token`, t0.`network_inst_id`, t0.`req_msg_id`, t0.`resp_msg_id`, t0.`current_state`, t0.`status`, t0.`npci_received_at`, t0.`debit_secured_at`, t0.`credit_requested_at`, t0.`partner_credited_at`, t0.`credit_completed_at`, t0.`chktxn_requested_at`, t0.`chktxn_ref_id`, t0.`reversal_requested_at`, t0.`completed_at`, t0.`finalized_at`, t0.`failure_code`, t0.`failure_reason`, t0.`deemed`, t0.`partner_txn_id`, t0.`npci_reversal_ref`, t0.`partner_id`, t0.`merchant_id`, t0.`inserted_at`, t0.`updated_at` FROM `transactions` AS t0 WHERE (((((t0.`merchant_id` = ?) AND (t0.`settlement_id` IS NULL)) AND ((t0.`status` = 'success') OR (t0.`deemed` = TRUE))) AND (t0.`inserted_at` >= ?)) AND (t0.`inserted_at` <= ?)) [25, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.Settlements.aggregate_eligible_transactions/2, at: lib/upi_settlement/settlements.ex:194[0m
2026-06-07 17:30:00 [DEBUG] [SettlementService] no eligible transactions merchant=25 date=2026-06-07
2026-06-07 17:30:00 [DEBUG] QUERY OK source="settlements" db=0.2ms idle=12.0ms
SELECT TRUE FROM `settlements` AS s0 WHERE (((s0.`merchant_id` = ?) AND (s0.`settlement_window_start` = ?)) AND (s0.`settlement_window_end` = ?)) LIMIT 1 [26, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.SettlementService.generate_merchant_settlement_batch/3, at: lib/upi_settlement/settlement_service.ex:82[0m
2026-06-07 17:30:00 [DEBUG] QUERY OK source="transactions" db=0.8ms idle=11.3ms
SELECT t0.`id`, t0.`settlement_status`, t0.`settlement_id`, t0.`org_txn_id`, t0.`parent_qr_validation_id`, t0.`payer_addr`, t0.`payer_name`, t0.`payee_addr`, t0.`payee_name`, t0.`payee_mid`, t0.`payer_bank_ref`, t0.`inr_amount`, t0.`currency`, t0.`foreign_amount`, t0.`foreign_currency`, t0.`fx_rate`, t0.`markup_rate`, t0.`markup_pct`, t0.`corridor`, t0.`transaction_type`, t0.`fx_provider`, t0.`fx_locked_at`, t0.`ver_token`, t0.`network_inst_id`, t0.`req_msg_id`, t0.`resp_msg_id`, t0.`current_state`, t0.`status`, t0.`npci_received_at`, t0.`debit_secured_at`, t0.`credit_requested_at`, t0.`partner_credited_at`, t0.`credit_completed_at`, t0.`chktxn_requested_at`, t0.`chktxn_ref_id`, t0.`reversal_requested_at`, t0.`completed_at`, t0.`finalized_at`, t0.`failure_code`, t0.`failure_reason`, t0.`deemed`, t0.`partner_txn_id`, t0.`npci_reversal_ref`, t0.`partner_id`, t0.`merchant_id`, t0.`inserted_at`, t0.`updated_at` FROM `transactions` AS t0 WHERE (((((t0.`merchant_id` = ?) AND (t0.`settlement_id` IS NULL)) AND ((t0.`status` = 'success') OR (t0.`deemed` = TRUE))) AND (t0.`inserted_at` >= ?)) AND (t0.`inserted_at` <= ?)) [26, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.Settlements.aggregate_eligible_transactions/2, at: lib/upi_settlement/settlements.ex:194[0m
2026-06-07 17:30:00 [DEBUG] [SettlementService] no eligible transactions merchant=26 date=2026-06-07
2026-06-07 17:30:00 [DEBUG] QUERY OK source="settlements" db=0.5ms idle=11.4ms
SELECT TRUE FROM `settlements` AS s0 WHERE (((s0.`merchant_id` = ?) AND (s0.`settlement_window_start` = ?)) AND (s0.`settlement_window_end` = ?)) LIMIT 1 [28, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.SettlementService.generate_merchant_settlement_batch/3, at: lib/upi_settlement/settlement_service.ex:82[0m
2026-06-07 17:30:00 [DEBUG] QUERY OK source="transactions" db=0.4ms idle=11.4ms
SELECT t0.`id`, t0.`settlement_status`, t0.`settlement_id`, t0.`org_txn_id`, t0.`parent_qr_validation_id`, t0.`payer_addr`, t0.`payer_name`, t0.`payee_addr`, t0.`payee_name`, t0.`payee_mid`, t0.`payer_bank_ref`, t0.`inr_amount`, t0.`currency`, t0.`foreign_amount`, t0.`foreign_currency`, t0.`fx_rate`, t0.`markup_rate`, t0.`markup_pct`, t0.`corridor`, t0.`transaction_type`, t0.`fx_provider`, t0.`fx_locked_at`, t0.`ver_token`, t0.`network_inst_id`, t0.`req_msg_id`, t0.`resp_msg_id`, t0.`current_state`, t0.`status`, t0.`npci_received_at`, t0.`debit_secured_at`, t0.`credit_requested_at`, t0.`partner_credited_at`, t0.`credit_completed_at`, t0.`chktxn_requested_at`, t0.`chktxn_ref_id`, t0.`reversal_requested_at`, t0.`completed_at`, t0.`finalized_at`, t0.`failure_code`, t0.`failure_reason`, t0.`deemed`, t0.`partner_txn_id`, t0.`npci_reversal_ref`, t0.`partner_id`, t0.`merchant_id`, t0.`inserted_at`, t0.`updated_at` FROM `transactions` AS t0 WHERE (((((t0.`merchant_id` = ?) AND (t0.`settlement_id` IS NULL)) AND ((t0.`status` = 'success') OR (t0.`deemed` = TRUE))) AND (t0.`inserted_at` >= ?)) AND (t0.`inserted_at` <= ?)) [28, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.Settlements.aggregate_eligible_transactions/2, at: lib/upi_settlement/settlements.ex:194[0m
2026-06-07 17:30:00 [DEBUG] [SettlementService] no eligible transactions merchant=28 date=2026-06-07
2026-06-07 17:30:00 [DEBUG] QUERY OK source="settlements" db=1.8ms queue=0.4ms idle=9.7ms
SELECT TRUE FROM `settlements` AS s0 WHERE (((s0.`merchant_id` = ?) AND (s0.`settlement_window_start` = ?)) AND (s0.`settlement_window_end` = ?)) LIMIT 1 [29, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.SettlementService.generate_merchant_settlement_batch/3, at: lib/upi_settlement/settlement_service.ex:82[0m
2026-06-07 17:30:00 [DEBUG] QUERY OK source="transactions" db=0.6ms idle=11.1ms
SELECT t0.`id`, t0.`settlement_status`, t0.`settlement_id`, t0.`org_txn_id`, t0.`parent_qr_validation_id`, t0.`payer_addr`, t0.`payer_name`, t0.`payee_addr`, t0.`payee_name`, t0.`payee_mid`, t0.`payer_bank_ref`, t0.`inr_amount`, t0.`currency`, t0.`foreign_amount`, t0.`foreign_currency`, t0.`fx_rate`, t0.`markup_rate`, t0.`markup_pct`, t0.`corridor`, t0.`transaction_type`, t0.`fx_provider`, t0.`fx_locked_at`, t0.`ver_token`, t0.`network_inst_id`, t0.`req_msg_id`, t0.`resp_msg_id`, t0.`current_state`, t0.`status`, t0.`npci_received_at`, t0.`debit_secured_at`, t0.`credit_requested_at`, t0.`partner_credited_at`, t0.`credit_completed_at`, t0.`chktxn_requested_at`, t0.`chktxn_ref_id`, t0.`reversal_requested_at`, t0.`completed_at`, t0.`finalized_at`, t0.`failure_code`, t0.`failure_reason`, t0.`deemed`, t0.`partner_txn_id`, t0.`npci_reversal_ref`, t0.`partner_id`, t0.`merchant_id`, t0.`inserted_at`, t0.`updated_at` FROM `transactions` AS t0 WHERE (((((t0.`merchant_id` = ?) AND (t0.`settlement_id` IS NULL)) AND ((t0.`status` = 'success') OR (t0.`deemed` = TRUE))) AND (t0.`inserted_at` >= ?)) AND (t0.`inserted_at` <= ?)) [29, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.Settlements.aggregate_eligible_transactions/2, at: lib/upi_settlement/settlements.ex:194[0m
2026-06-07 17:30:00 [DEBUG] [SettlementService] no eligible transactions merchant=29 date=2026-06-07
2026-06-07 17:30:00 [DEBUG] QUERY OK source="settlements" db=0.4ms idle=9.5ms
SELECT TRUE FROM `settlements` AS s0 WHERE (((s0.`merchant_id` = ?) AND (s0.`settlement_window_start` = ?)) AND (s0.`settlement_window_end` = ?)) LIMIT 1 [30, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.SettlementService.generate_merchant_settlement_batch/3, at: lib/upi_settlement/settlement_service.ex:82[0m
2026-06-07 17:30:00 [DEBUG] QUERY OK source="transactions" db=0.4ms idle=9.3ms
SELECT t0.`id`, t0.`settlement_status`, t0.`settlement_id`, t0.`org_txn_id`, t0.`parent_qr_validation_id`, t0.`payer_addr`, t0.`payer_name`, t0.`payee_addr`, t0.`payee_name`, t0.`payee_mid`, t0.`payer_bank_ref`, t0.`inr_amount`, t0.`currency`, t0.`foreign_amount`, t0.`foreign_currency`, t0.`fx_rate`, t0.`markup_rate`, t0.`markup_pct`, t0.`corridor`, t0.`transaction_type`, t0.`fx_provider`, t0.`fx_locked_at`, t0.`ver_token`, t0.`network_inst_id`, t0.`req_msg_id`, t0.`resp_msg_id`, t0.`current_state`, t0.`status`, t0.`npci_received_at`, t0.`debit_secured_at`, t0.`credit_requested_at`, t0.`partner_credited_at`, t0.`credit_completed_at`, t0.`chktxn_requested_at`, t0.`chktxn_ref_id`, t0.`reversal_requested_at`, t0.`completed_at`, t0.`finalized_at`, t0.`failure_code`, t0.`failure_reason`, t0.`deemed`, t0.`partner_txn_id`, t0.`npci_reversal_ref`, t0.`partner_id`, t0.`merchant_id`, t0.`inserted_at`, t0.`updated_at` FROM `transactions` AS t0 WHERE (((((t0.`merchant_id` = ?) AND (t0.`settlement_id` IS NULL)) AND ((t0.`status` = 'success') OR (t0.`deemed` = TRUE))) AND (t0.`inserted_at` >= ?)) AND (t0.`inserted_at` <= ?)) [30, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.Settlements.aggregate_eligible_transactions/2, at: lib/upi_settlement/settlements.ex:194[0m
2026-06-07 17:30:00 [DEBUG] [SettlementService] no eligible transactions merchant=30 date=2026-06-07
2026-06-07 17:30:00 [DEBUG] QUERY OK source="settlements" db=0.5ms idle=9.4ms
SELECT TRUE FROM `settlements` AS s0 WHERE (((s0.`merchant_id` = ?) AND (s0.`settlement_window_start` = ?)) AND (s0.`settlement_window_end` = ?)) LIMIT 1 [31, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.SettlementService.generate_merchant_settlement_batch/3, at: lib/upi_settlement/settlement_service.ex:82[0m
2026-06-07 17:30:00 [DEBUG] QUERY OK source="transactions" db=0.8ms idle=9.6ms
SELECT t0.`id`, t0.`settlement_status`, t0.`settlement_id`, t0.`org_txn_id`, t0.`parent_qr_validation_id`, t0.`payer_addr`, t0.`payer_name`, t0.`payee_addr`, t0.`payee_name`, t0.`payee_mid`, t0.`payer_bank_ref`, t0.`inr_amount`, t0.`currency`, t0.`foreign_amount`, t0.`foreign_currency`, t0.`fx_rate`, t0.`markup_rate`, t0.`markup_pct`, t0.`corridor`, t0.`transaction_type`, t0.`fx_provider`, t0.`fx_locked_at`, t0.`ver_token`, t0.`network_inst_id`, t0.`req_msg_id`, t0.`resp_msg_id`, t0.`current_state`, t0.`status`, t0.`npci_received_at`, t0.`debit_secured_at`, t0.`credit_requested_at`, t0.`partner_credited_at`, t0.`credit_completed_at`, t0.`chktxn_requested_at`, t0.`chktxn_ref_id`, t0.`reversal_requested_at`, t0.`completed_at`, t0.`finalized_at`, t0.`failure_code`, t0.`failure_reason`, t0.`deemed`, t0.`partner_txn_id`, t0.`npci_reversal_ref`, t0.`partner_id`, t0.`merchant_id`, t0.`inserted_at`, t0.`updated_at` FROM `transactions` AS t0 WHERE (((((t0.`merchant_id` = ?) AND (t0.`settlement_id` IS NULL)) AND ((t0.`status` = 'success') OR (t0.`deemed` = TRUE))) AND (t0.`inserted_at` >= ?)) AND (t0.`inserted_at` <= ?)) [31, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.Settlements.aggregate_eligible_transactions/2, at: lib/upi_settlement/settlements.ex:194[0m
2026-06-07 17:30:00 [DEBUG] [SettlementService] no eligible transactions merchant=31 date=2026-06-07
2026-06-07 17:30:00 [DEBUG] QUERY OK source="settlements" db=0.6ms idle=10.3ms
SELECT TRUE FROM `settlements` AS s0 WHERE (((s0.`merchant_id` = ?) AND (s0.`settlement_window_start` = ?)) AND (s0.`settlement_window_end` = ?)) LIMIT 1 [33, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.SettlementService.generate_merchant_settlement_batch/3, at: lib/upi_settlement/settlement_service.ex:82[0m
2026-06-07 17:30:00 [DEBUG] QUERY OK source="transactions" db=1.2ms idle=10.2ms
SELECT t0.`id`, t0.`settlement_status`, t0.`settlement_id`, t0.`org_txn_id`, t0.`parent_qr_validation_id`, t0.`payer_addr`, t0.`payer_name`, t0.`payee_addr`, t0.`payee_name`, t0.`payee_mid`, t0.`payer_bank_ref`, t0.`inr_amount`, t0.`currency`, t0.`foreign_amount`, t0.`foreign_currency`, t0.`fx_rate`, t0.`markup_rate`, t0.`markup_pct`, t0.`corridor`, t0.`transaction_type`, t0.`fx_provider`, t0.`fx_locked_at`, t0.`ver_token`, t0.`network_inst_id`, t0.`req_msg_id`, t0.`resp_msg_id`, t0.`current_state`, t0.`status`, t0.`npci_received_at`, t0.`debit_secured_at`, t0.`credit_requested_at`, t0.`partner_credited_at`, t0.`credit_completed_at`, t0.`chktxn_requested_at`, t0.`chktxn_ref_id`, t0.`reversal_requested_at`, t0.`completed_at`, t0.`finalized_at`, t0.`failure_code`, t0.`failure_reason`, t0.`deemed`, t0.`partner_txn_id`, t0.`npci_reversal_ref`, t0.`partner_id`, t0.`merchant_id`, t0.`inserted_at`, t0.`updated_at` FROM `transactions` AS t0 WHERE (((((t0.`merchant_id` = ?) AND (t0.`settlement_id` IS NULL)) AND ((t0.`status` = 'success') OR (t0.`deemed` = TRUE))) AND (t0.`inserted_at` >= ?)) AND (t0.`inserted_at` <= ?)) [33, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.Settlements.aggregate_eligible_transactions/2, at: lib/upi_settlement/settlements.ex:194[0m
2026-06-07 17:30:00 [DEBUG] [SettlementService] no eligible transactions merchant=33 date=2026-06-07
2026-06-07 17:30:00 [DEBUG] QUERY OK source="settlements" db=0.4ms idle=11.4ms
SELECT TRUE FROM `settlements` AS s0 WHERE (((s0.`merchant_id` = ?) AND (s0.`settlement_window_start` = ?)) AND (s0.`settlement_window_end` = ?)) LIMIT 1 [40, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.SettlementService.generate_merchant_settlement_batch/3, at: lib/upi_settlement/settlement_service.ex:82[0m
2026-06-07 17:30:00 [DEBUG] QUERY OK source="transactions" db=0.7ms idle=11.5ms
SELECT t0.`id`, t0.`settlement_status`, t0.`settlement_id`, t0.`org_txn_id`, t0.`parent_qr_validation_id`, t0.`payer_addr`, t0.`payer_name`, t0.`payee_addr`, t0.`payee_name`, t0.`payee_mid`, t0.`payer_bank_ref`, t0.`inr_amount`, t0.`currency`, t0.`foreign_amount`, t0.`foreign_currency`, t0.`fx_rate`, t0.`markup_rate`, t0.`markup_pct`, t0.`corridor`, t0.`transaction_type`, t0.`fx_provider`, t0.`fx_locked_at`, t0.`ver_token`, t0.`network_inst_id`, t0.`req_msg_id`, t0.`resp_msg_id`, t0.`current_state`, t0.`status`, t0.`npci_received_at`, t0.`debit_secured_at`, t0.`credit_requested_at`, t0.`partner_credited_at`, t0.`credit_completed_at`, t0.`chktxn_requested_at`, t0.`chktxn_ref_id`, t0.`reversal_requested_at`, t0.`completed_at`, t0.`finalized_at`, t0.`failure_code`, t0.`failure_reason`, t0.`deemed`, t0.`partner_txn_id`, t0.`npci_reversal_ref`, t0.`partner_id`, t0.`merchant_id`, t0.`inserted_at`, t0.`updated_at` FROM `transactions` AS t0 WHERE (((((t0.`merchant_id` = ?) AND (t0.`settlement_id` IS NULL)) AND ((t0.`status` = 'success') OR (t0.`deemed` = TRUE))) AND (t0.`inserted_at` >= ?)) AND (t0.`inserted_at` <= ?)) [40, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.Settlements.aggregate_eligible_transactions/2, at: lib/upi_settlement/settlements.ex:194[0m
2026-06-07 17:30:00 [DEBUG] [SettlementService] no eligible transactions merchant=40 date=2026-06-07
2026-06-07 17:30:00 [DEBUG] QUERY OK source="settlements" db=1.8ms idle=10.1ms
SELECT TRUE FROM `settlements` AS s0 WHERE (((s0.`merchant_id` = ?) AND (s0.`settlement_window_start` = ?)) AND (s0.`settlement_window_end` = ?)) LIMIT 1 [42, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.SettlementService.generate_merchant_settlement_batch/3, at: lib/upi_settlement/settlement_service.ex:82[0m
2026-06-07 17:30:00 [DEBUG] QUERY OK source="transactions" db=0.6ms idle=11.7ms
SELECT t0.`id`, t0.`settlement_status`, t0.`settlement_id`, t0.`org_txn_id`, t0.`parent_qr_validation_id`, t0.`payer_addr`, t0.`payer_name`, t0.`payee_addr`, t0.`payee_name`, t0.`payee_mid`, t0.`payer_bank_ref`, t0.`inr_amount`, t0.`currency`, t0.`foreign_amount`, t0.`foreign_currency`, t0.`fx_rate`, t0.`markup_rate`, t0.`markup_pct`, t0.`corridor`, t0.`transaction_type`, t0.`fx_provider`, t0.`fx_locked_at`, t0.`ver_token`, t0.`network_inst_id`, t0.`req_msg_id`, t0.`resp_msg_id`, t0.`current_state`, t0.`status`, t0.`npci_received_at`, t0.`debit_secured_at`, t0.`credit_requested_at`, t0.`partner_credited_at`, t0.`credit_completed_at`, t0.`chktxn_requested_at`, t0.`chktxn_ref_id`, t0.`reversal_requested_at`, t0.`completed_at`, t0.`finalized_at`, t0.`failure_code`, t0.`failure_reason`, t0.`deemed`, t0.`partner_txn_id`, t0.`npci_reversal_ref`, t0.`partner_id`, t0.`merchant_id`, t0.`inserted_at`, t0.`updated_at` FROM `transactions` AS t0 WHERE (((((t0.`merchant_id` = ?) AND (t0.`settlement_id` IS NULL)) AND ((t0.`status` = 'success') OR (t0.`deemed` = TRUE))) AND (t0.`inserted_at` >= ?)) AND (t0.`inserted_at` <= ?)) [42, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.Settlements.aggregate_eligible_transactions/2, at: lib/upi_settlement/settlements.ex:194[0m
2026-06-07 17:30:00 [DEBUG] [SettlementService] no eligible transactions merchant=42 date=2026-06-07
2026-06-07 17:30:00 [DEBUG] QUERY OK source="settlements" db=0.6ms idle=11.8ms
SELECT TRUE FROM `settlements` AS s0 WHERE (((s0.`merchant_id` = ?) AND (s0.`settlement_window_start` = ?)) AND (s0.`settlement_window_end` = ?)) LIMIT 1 [43, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.SettlementService.generate_merchant_settlement_batch/3, at: lib/upi_settlement/settlement_service.ex:82[0m
2026-06-07 17:30:00 [DEBUG] QUERY OK source="transactions" db=0.6ms idle=12.7ms
SELECT t0.`id`, t0.`settlement_status`, t0.`settlement_id`, t0.`org_txn_id`, t0.`parent_qr_validation_id`, t0.`payer_addr`, t0.`payer_name`, t0.`payee_addr`, t0.`payee_name`, t0.`payee_mid`, t0.`payer_bank_ref`, t0.`inr_amount`, t0.`currency`, t0.`foreign_amount`, t0.`foreign_currency`, t0.`fx_rate`, t0.`markup_rate`, t0.`markup_pct`, t0.`corridor`, t0.`transaction_type`, t0.`fx_provider`, t0.`fx_locked_at`, t0.`ver_token`, t0.`network_inst_id`, t0.`req_msg_id`, t0.`resp_msg_id`, t0.`current_state`, t0.`status`, t0.`npci_received_at`, t0.`debit_secured_at`, t0.`credit_requested_at`, t0.`partner_credited_at`, t0.`credit_completed_at`, t0.`chktxn_requested_at`, t0.`chktxn_ref_id`, t0.`reversal_requested_at`, t0.`completed_at`, t0.`finalized_at`, t0.`failure_code`, t0.`failure_reason`, t0.`deemed`, t0.`partner_txn_id`, t0.`npci_reversal_ref`, t0.`partner_id`, t0.`merchant_id`, t0.`inserted_at`, t0.`updated_at` FROM `transactions` AS t0 WHERE (((((t0.`merchant_id` = ?) AND (t0.`settlement_id` IS NULL)) AND ((t0.`status` = 'success') OR (t0.`deemed` = TRUE))) AND (t0.`inserted_at` >= ?)) AND (t0.`inserted_at` <= ?)) [43, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.Settlements.aggregate_eligible_transactions/2, at: lib/upi_settlement/settlements.ex:194[0m
2026-06-07 17:30:00 [DEBUG] [SettlementService] no eligible transactions merchant=43 date=2026-06-07
2026-06-07 17:30:00 [DEBUG] QUERY OK source="settlements" db=1.3ms queue=0.3ms idle=12.7ms
SELECT TRUE FROM `settlements` AS s0 WHERE (((s0.`merchant_id` = ?) AND (s0.`settlement_window_start` = ?)) AND (s0.`settlement_window_end` = ?)) LIMIT 1 [44, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.SettlementService.generate_merchant_settlement_batch/3, at: lib/upi_settlement/settlement_service.ex:82[0m
2026-06-07 17:30:00 [DEBUG] QUERY OK source="transactions" db=0.7ms idle=14.0ms
SELECT t0.`id`, t0.`settlement_status`, t0.`settlement_id`, t0.`org_txn_id`, t0.`parent_qr_validation_id`, t0.`payer_addr`, t0.`payer_name`, t0.`payee_addr`, t0.`payee_name`, t0.`payee_mid`, t0.`payer_bank_ref`, t0.`inr_amount`, t0.`currency`, t0.`foreign_amount`, t0.`foreign_currency`, t0.`fx_rate`, t0.`markup_rate`, t0.`markup_pct`, t0.`corridor`, t0.`transaction_type`, t0.`fx_provider`, t0.`fx_locked_at`, t0.`ver_token`, t0.`network_inst_id`, t0.`req_msg_id`, t0.`resp_msg_id`, t0.`current_state`, t0.`status`, t0.`npci_received_at`, t0.`debit_secured_at`, t0.`credit_requested_at`, t0.`partner_credited_at`, t0.`credit_completed_at`, t0.`chktxn_requested_at`, t0.`chktxn_ref_id`, t0.`reversal_requested_at`, t0.`completed_at`, t0.`finalized_at`, t0.`failure_code`, t0.`failure_reason`, t0.`deemed`, t0.`partner_txn_id`, t0.`npci_reversal_ref`, t0.`partner_id`, t0.`merchant_id`, t0.`inserted_at`, t0.`updated_at` FROM `transactions` AS t0 WHERE (((((t0.`merchant_id` = ?) AND (t0.`settlement_id` IS NULL)) AND ((t0.`status` = 'success') OR (t0.`deemed` = TRUE))) AND (t0.`inserted_at` >= ?)) AND (t0.`inserted_at` <= ?)) [44, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.Settlements.aggregate_eligible_transactions/2, at: lib/upi_settlement/settlements.ex:194[0m
2026-06-07 17:30:00 [DEBUG] [SettlementService] no eligible transactions merchant=44 date=2026-06-07
2026-06-07 17:30:00 [DEBUG] QUERY OK source="settlements" db=0.6ms idle=13.9ms
SELECT TRUE FROM `settlements` AS s0 WHERE (((s0.`merchant_id` = ?) AND (s0.`settlement_window_start` = ?)) AND (s0.`settlement_window_end` = ?)) LIMIT 1 [45, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.SettlementService.generate_merchant_settlement_batch/3, at: lib/upi_settlement/settlement_service.ex:82[0m
2026-06-07 17:30:00 [DEBUG] QUERY OK source="transactions" db=0.7ms idle=13.3ms
SELECT t0.`id`, t0.`settlement_status`, t0.`settlement_id`, t0.`org_txn_id`, t0.`parent_qr_validation_id`, t0.`payer_addr`, t0.`payer_name`, t0.`payee_addr`, t0.`payee_name`, t0.`payee_mid`, t0.`payer_bank_ref`, t0.`inr_amount`, t0.`currency`, t0.`foreign_amount`, t0.`foreign_currency`, t0.`fx_rate`, t0.`markup_rate`, t0.`markup_pct`, t0.`corridor`, t0.`transaction_type`, t0.`fx_provider`, t0.`fx_locked_at`, t0.`ver_token`, t0.`network_inst_id`, t0.`req_msg_id`, t0.`resp_msg_id`, t0.`current_state`, t0.`status`, t0.`npci_received_at`, t0.`debit_secured_at`, t0.`credit_requested_at`, t0.`partner_credited_at`, t0.`credit_completed_at`, t0.`chktxn_requested_at`, t0.`chktxn_ref_id`, t0.`reversal_requested_at`, t0.`completed_at`, t0.`finalized_at`, t0.`failure_code`, t0.`failure_reason`, t0.`deemed`, t0.`partner_txn_id`, t0.`npci_reversal_ref`, t0.`partner_id`, t0.`merchant_id`, t0.`inserted_at`, t0.`updated_at` FROM `transactions` AS t0 WHERE (((((t0.`merchant_id` = ?) AND (t0.`settlement_id` IS NULL)) AND ((t0.`status` = 'success') OR (t0.`deemed` = TRUE))) AND (t0.`inserted_at` >= ?)) AND (t0.`inserted_at` <= ?)) [45, ~U[2026-06-06 17:30:00Z], ~U[2026-06-07 17:29:59Z]]
[90m↳ UpiSettlement.Settlements.aggregate_eligible_transactions/2, at: lib/upi_settlement/settlements.ex:194[0m
2026-06-07 17:30:00 [DEBUG] [SettlementService] no eligible transactions merchant=45 date=2026-06-07
2026-06-07 17:30:00 [INFO] [Scheduler] settlement pass done ok=31 errors=0
2026-06-07 17:55:25 [WARN] Connection that looks like TLS received on a clear channel
2026-06-07 17:55:26 [WARN] Connection that looks like TLS received on a clear channel
2026-06-07 17:55:28 [INFO] GET /
2026-06-07 17:55:28 [DEBUG] ** (Phoenix.Router.NoRouteError) no route found for GET / (UpiDynamic.Router)
    (upi_dynamic 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/phoenix/lib/phoenix/router.ex:465: UpiDynamic.Router.call/2
    (upi_dynamic 0.1.0) lib/upi_dynamic/endpoint.ex:1: UpiDynamic.Endpoint.plug_builder_call/2
    (upi_dynamic 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/plug/lib/plug/debugger.ex:155: UpiDynamic.Endpoint."call (overridable 3)"/2
    (upi_dynamic 0.1.0) lib/upi_dynamic/endpoint.ex:1: UpiDynamic.Endpoint.call/2
    (phoenix 1.8.0) lib/phoenix/endpoint/sync_code_reload_plug.ex:22: Phoenix.Endpoint.SyncCodeReloadPlug.do_call/4
    (bandit 1.7.0) lib/bandit/pipeline.ex:131: Bandit.Pipeline.call_plug!/2
    (bandit 1.7.0) lib/bandit/pipeline.ex:42: Bandit.Pipeline.run/5
    (bandit 1.7.0) lib/bandit/http1/handler.ex:13: Bandit.HTTP1.Handler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:18: Bandit.DelegatingHandler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:8: Bandit.DelegatingHandler.handle_continue/2
    (stdlib 5.2.3.2) gen_server.erl:1085: :gen_server.try_handle_continue/3
    (stdlib 5.2.3.2) gen_server.erl:995: :gen_server.loop/7
    (stdlib 5.2.3.2) proc_lib.erl:241: :proc_lib.init_p_do_apply/3

2026-06-07 17:56:07 [WARN] Connection that looks like TLS received on a clear channel
2026-06-07 17:56:08 [INFO] GET /.well-known/security.txt
2026-06-07 17:56:08 [DEBUG] ** (Phoenix.Router.NoRouteError) no route found for GET /.well-known/security.txt (UpiDynamic.Router)
    (upi_dynamic 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/phoenix/lib/phoenix/router.ex:465: UpiDynamic.Router.call/2
    (upi_dynamic 0.1.0) lib/upi_dynamic/endpoint.ex:1: UpiDynamic.Endpoint.plug_builder_call/2
    (upi_dynamic 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/plug/lib/plug/debugger.ex:155: UpiDynamic.Endpoint."call (overridable 3)"/2
    (upi_dynamic 0.1.0) lib/upi_dynamic/endpoint.ex:1: UpiDynamic.Endpoint.call/2
    (phoenix 1.8.0) lib/phoenix/endpoint/sync_code_reload_plug.ex:22: Phoenix.Endpoint.SyncCodeReloadPlug.do_call/4
    (bandit 1.7.0) lib/bandit/pipeline.ex:131: Bandit.Pipeline.call_plug!/2
    (bandit 1.7.0) lib/bandit/pipeline.ex:42: Bandit.Pipeline.run/5
    (bandit 1.7.0) lib/bandit/http1/handler.ex:13: Bandit.HTTP1.Handler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:18: Bandit.DelegatingHandler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:8: Bandit.DelegatingHandler.handle_continue/2
    (stdlib 5.2.3.2) gen_server.erl:1085: :gen_server.try_handle_continue/3
    (stdlib 5.2.3.2) gen_server.erl:995: :gen_server.loop/7
    (stdlib 5.2.3.2) proc_lib.erl:241: :proc_lib.init_p_do_apply/3

2026-06-07 17:56:18 [WARN] Connection that looks like TLS received on a clear channel
2026-06-07 17:56:19 [WARN] Connection that looks like TLS received on a clear channel
2026-06-07 17:56:26 [INFO] GET /
2026-06-07 17:56:26 [DEBUG] ** (Phoenix.Router.NoRouteError) no route found for GET / (UpiStatic.Router)
    (upi_static 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/phoenix/lib/phoenix/router.ex:465: UpiStatic.Router.call/2
    (upi_static 0.1.0) lib/upi_static/endpoint.ex:1: UpiStatic.Endpoint.plug_builder_call/2
    (upi_static 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/plug/lib/plug/debugger.ex:155: UpiStatic.Endpoint."call (overridable 3)"/2
    (upi_static 0.1.0) lib/upi_static/endpoint.ex:1: UpiStatic.Endpoint.call/2
    (phoenix 1.8.0) lib/phoenix/endpoint/sync_code_reload_plug.ex:22: Phoenix.Endpoint.SyncCodeReloadPlug.do_call/4
    (bandit 1.7.0) lib/bandit/pipeline.ex:131: Bandit.Pipeline.call_plug!/2
    (bandit 1.7.0) lib/bandit/pipeline.ex:42: Bandit.Pipeline.run/5
    (bandit 1.7.0) lib/bandit/http1/handler.ex:13: Bandit.HTTP1.Handler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:18: Bandit.DelegatingHandler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:8: Bandit.DelegatingHandler.handle_continue/2
    (stdlib 5.2.3.2) gen_server.erl:1085: :gen_server.try_handle_continue/3
    (stdlib 5.2.3.2) gen_server.erl:995: :gen_server.loop/7
    (stdlib 5.2.3.2) proc_lib.erl:241: :proc_lib.init_p_do_apply/3

2026-06-07 17:57:10 [WARN] Connection that looks like TLS received on a clear channel
2026-06-07 17:57:11 [INFO] GET /.well-known/security.txt
2026-06-07 17:57:11 [DEBUG] ** (Phoenix.Router.NoRouteError) no route found for GET /.well-known/security.txt (UpiStatic.Router)
    (upi_static 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/phoenix/lib/phoenix/router.ex:465: UpiStatic.Router.call/2
    (upi_static 0.1.0) lib/upi_static/endpoint.ex:1: UpiStatic.Endpoint.plug_builder_call/2
    (upi_static 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/plug/lib/plug/debugger.ex:155: UpiStatic.Endpoint."call (overridable 3)"/2
    (upi_static 0.1.0) lib/upi_static/endpoint.ex:1: UpiStatic.Endpoint.call/2
    (phoenix 1.8.0) lib/phoenix/endpoint/sync_code_reload_plug.ex:22: Phoenix.Endpoint.SyncCodeReloadPlug.do_call/4
    (bandit 1.7.0) lib/bandit/pipeline.ex:131: Bandit.Pipeline.call_plug!/2
    (bandit 1.7.0) lib/bandit/pipeline.ex:42: Bandit.Pipeline.run/5
    (bandit 1.7.0) lib/bandit/http1/handler.ex:13: Bandit.HTTP1.Handler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:18: Bandit.DelegatingHandler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:8: Bandit.DelegatingHandler.handle_continue/2
    (stdlib 5.2.3.2) gen_server.erl:1085: :gen_server.try_handle_continue/3
    (stdlib 5.2.3.2) gen_server.erl:995: :gen_server.loop/7
    (stdlib 5.2.3.2) proc_lib.erl:241: :proc_lib.init_p_do_apply/3

2026-06-07 18:42:39 [WARN] Connection that looks like TLS received on a clear channel
2026-06-07 18:43:17 [WARN] Connection that looks like TLS received on a clear channel
2026-06-07 18:43:31 [INFO] GET /
2026-06-07 18:43:31 [DEBUG] ** (Phoenix.Router.NoRouteError) no route found for GET / (UpiDynamic.Router)
    (upi_dynamic 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/phoenix/lib/phoenix/router.ex:465: UpiDynamic.Router.call/2
    (upi_dynamic 0.1.0) lib/upi_dynamic/endpoint.ex:1: UpiDynamic.Endpoint.plug_builder_call/2
    (upi_dynamic 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/plug/lib/plug/debugger.ex:155: UpiDynamic.Endpoint."call (overridable 3)"/2
    (upi_dynamic 0.1.0) lib/upi_dynamic/endpoint.ex:1: UpiDynamic.Endpoint.call/2
    (phoenix 1.8.0) lib/phoenix/endpoint/sync_code_reload_plug.ex:22: Phoenix.Endpoint.SyncCodeReloadPlug.do_call/4
    (bandit 1.7.0) lib/bandit/pipeline.ex:131: Bandit.Pipeline.call_plug!/2
    (bandit 1.7.0) lib/bandit/pipeline.ex:42: Bandit.Pipeline.run/5
    (bandit 1.7.0) lib/bandit/http1/handler.ex:13: Bandit.HTTP1.Handler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:18: Bandit.DelegatingHandler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:8: Bandit.DelegatingHandler.handle_continue/2
    (stdlib 5.2.3.2) gen_server.erl:1085: :gen_server.try_handle_continue/3
    (stdlib 5.2.3.2) gen_server.erl:995: :gen_server.loop/7
    (stdlib 5.2.3.2) proc_lib.erl:241: :proc_lib.init_p_do_apply/3

2026-06-07 18:44:06 [ERROR] ** (Bandit.HTTPError) Request line HTTP error: "OPTIONS / RTSP/1.0\r\n"
2026-06-07 18:44:08 [ERROR] ** (Bandit.TransportError) Unrecoverable error: timeout
2026-06-07 18:45:20 [ERROR] ** (Bandit.HTTPError) Request line HTTP error: "*1\r\n"
2026-06-07 18:46:13 [INFO] GET /
2026-06-07 18:46:13 [DEBUG] ** (Phoenix.Router.NoRouteError) no route found for GET / (UpiDynamic.Router)
    (upi_dynamic 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/phoenix/lib/phoenix/router.ex:465: UpiDynamic.Router.call/2
    (upi_dynamic 0.1.0) lib/upi_dynamic/endpoint.ex:1: UpiDynamic.Endpoint.plug_builder_call/2
    (upi_dynamic 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/plug/lib/plug/debugger.ex:155: UpiDynamic.Endpoint."call (overridable 3)"/2
    (upi_dynamic 0.1.0) lib/upi_dynamic/endpoint.ex:1: UpiDynamic.Endpoint.call/2
    (phoenix 1.8.0) lib/phoenix/endpoint/sync_code_reload_plug.ex:22: Phoenix.Endpoint.SyncCodeReloadPlug.do_call/4
    (bandit 1.7.0) lib/bandit/pipeline.ex:131: Bandit.Pipeline.call_plug!/2
    (bandit 1.7.0) lib/bandit/pipeline.ex:42: Bandit.Pipeline.run/5
    (bandit 1.7.0) lib/bandit/http1/handler.ex:13: Bandit.HTTP1.Handler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:18: Bandit.DelegatingHandler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:8: Bandit.DelegatingHandler.handle_continue/2
    (stdlib 5.2.3.2) gen_server.erl:1085: :gen_server.try_handle_continue/3
    (stdlib 5.2.3.2) gen_server.erl:995: :gen_server.loop/7
    (stdlib 5.2.3.2) proc_lib.erl:241: :proc_lib.init_p_do_apply/3

2026-06-07 19:38:01 [INFO] GET /
2026-06-07 19:38:01 [DEBUG] ** (Phoenix.Router.NoRouteError) no route found for GET / (UpiDynamic.Router)
    (upi_dynamic 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/phoenix/lib/phoenix/router.ex:465: UpiDynamic.Router.call/2
    (upi_dynamic 0.1.0) lib/upi_dynamic/endpoint.ex:1: UpiDynamic.Endpoint.plug_builder_call/2
    (upi_dynamic 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/plug/lib/plug/debugger.ex:155: UpiDynamic.Endpoint."call (overridable 3)"/2
    (upi_dynamic 0.1.0) lib/upi_dynamic/endpoint.ex:1: UpiDynamic.Endpoint.call/2
    (phoenix 1.8.0) lib/phoenix/endpoint/sync_code_reload_plug.ex:22: Phoenix.Endpoint.SyncCodeReloadPlug.do_call/4
    (bandit 1.7.0) lib/bandit/pipeline.ex:131: Bandit.Pipeline.call_plug!/2
    (bandit 1.7.0) lib/bandit/pipeline.ex:42: Bandit.Pipeline.run/5
    (bandit 1.7.0) lib/bandit/http1/handler.ex:13: Bandit.HTTP1.Handler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:18: Bandit.DelegatingHandler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:8: Bandit.DelegatingHandler.handle_continue/2
    (stdlib 5.2.3.2) gen_server.erl:1085: :gen_server.try_handle_continue/3
    (stdlib 5.2.3.2) gen_server.erl:995: :gen_server.loop/7
    (stdlib 5.2.3.2) proc_lib.erl:241: :proc_lib.init_p_do_apply/3

2026-06-07 19:41:05 [INFO] GET /
2026-06-07 19:41:05 [DEBUG] ** (Phoenix.Router.NoRouteError) no route found for GET / (UpiDynamic.Router)
    (upi_dynamic 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/phoenix/lib/phoenix/router.ex:465: UpiDynamic.Router.call/2
    (upi_dynamic 0.1.0) lib/upi_dynamic/endpoint.ex:1: UpiDynamic.Endpoint.plug_builder_call/2
    (upi_dynamic 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/plug/lib/plug/debugger.ex:155: UpiDynamic.Endpoint."call (overridable 3)"/2
    (upi_dynamic 0.1.0) lib/upi_dynamic/endpoint.ex:1: UpiDynamic.Endpoint.call/2
    (phoenix 1.8.0) lib/phoenix/endpoint/sync_code_reload_plug.ex:22: Phoenix.Endpoint.SyncCodeReloadPlug.do_call/4
    (bandit 1.7.0) lib/bandit/pipeline.ex:131: Bandit.Pipeline.call_plug!/2
    (bandit 1.7.0) lib/bandit/pipeline.ex:42: Bandit.Pipeline.run/5
    (bandit 1.7.0) lib/bandit/http1/handler.ex:13: Bandit.HTTP1.Handler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:18: Bandit.DelegatingHandler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:8: Bandit.DelegatingHandler.handle_continue/2
    (stdlib 5.2.3.2) gen_server.erl:1085: :gen_server.try_handle_continue/3
    (stdlib 5.2.3.2) gen_server.erl:995: :gen_server.loop/7
    (stdlib 5.2.3.2) proc_lib.erl:241: :proc_lib.init_p_do_apply/3

2026-06-07 19:41:19 [INFO] GET /
2026-06-07 19:41:19 [DEBUG] ** (Phoenix.Router.NoRouteError) no route found for GET / (UpiStatic.Router)
    (upi_static 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/phoenix/lib/phoenix/router.ex:465: UpiStatic.Router.call/2
    (upi_static 0.1.0) lib/upi_static/endpoint.ex:1: UpiStatic.Endpoint.plug_builder_call/2
    (upi_static 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/plug/lib/plug/debugger.ex:155: UpiStatic.Endpoint."call (overridable 3)"/2
    (upi_static 0.1.0) lib/upi_static/endpoint.ex:1: UpiStatic.Endpoint.call/2
    (phoenix 1.8.0) lib/phoenix/endpoint/sync_code_reload_plug.ex:22: Phoenix.Endpoint.SyncCodeReloadPlug.do_call/4
    (bandit 1.7.0) lib/bandit/pipeline.ex:131: Bandit.Pipeline.call_plug!/2
    (bandit 1.7.0) lib/bandit/pipeline.ex:42: Bandit.Pipeline.run/5
    (bandit 1.7.0) lib/bandit/http1/handler.ex:13: Bandit.HTTP1.Handler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:18: Bandit.DelegatingHandler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:8: Bandit.DelegatingHandler.handle_continue/2
    (stdlib 5.2.3.2) gen_server.erl:1085: :gen_server.try_handle_continue/3
    (stdlib 5.2.3.2) gen_server.erl:995: :gen_server.loop/7
    (stdlib 5.2.3.2) proc_lib.erl:241: :proc_lib.init_p_do_apply/3

2026-06-07 19:42:21 [INFO] GET /
2026-06-07 19:42:21 [DEBUG] Processing with UpiWeb.PageController.home/2
  Parameters: %{}
  Pipelines: [:browser]
2026-06-07 19:42:21 [INFO] Sent 200 in 7ms
2026-06-07 19:43:33 [INFO] GET /
2026-06-07 19:43:33 [DEBUG] ** (Phoenix.Router.NoRouteError) no route found for GET / (UpiStatic.Router)
    (upi_static 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/phoenix/lib/phoenix/router.ex:465: UpiStatic.Router.call/2
    (upi_static 0.1.0) lib/upi_static/endpoint.ex:1: UpiStatic.Endpoint.plug_builder_call/2
    (upi_static 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/plug/lib/plug/debugger.ex:155: UpiStatic.Endpoint."call (overridable 3)"/2
    (upi_static 0.1.0) lib/upi_static/endpoint.ex:1: UpiStatic.Endpoint.call/2
    (phoenix 1.8.0) lib/phoenix/endpoint/sync_code_reload_plug.ex:22: Phoenix.Endpoint.SyncCodeReloadPlug.do_call/4
    (bandit 1.7.0) lib/bandit/pipeline.ex:131: Bandit.Pipeline.call_plug!/2
    (bandit 1.7.0) lib/bandit/pipeline.ex:42: Bandit.Pipeline.run/5
    (bandit 1.7.0) lib/bandit/http1/handler.ex:13: Bandit.HTTP1.Handler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:18: Bandit.DelegatingHandler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:8: Bandit.DelegatingHandler.handle_continue/2
    (stdlib 5.2.3.2) gen_server.erl:1085: :gen_server.try_handle_continue/3
    (stdlib 5.2.3.2) gen_server.erl:995: :gen_server.loop/7
    (stdlib 5.2.3.2) proc_lib.erl:241: :proc_lib.init_p_do_apply/3

2026-06-07 19:43:57 [WARN] Connection that looks like TLS received on a clear channel
2026-06-07 19:45:29 [INFO] GET /
2026-06-07 19:45:30 [DEBUG] ** (Phoenix.Router.NoRouteError) no route found for GET / (UpiDynamic.Router)
    (upi_dynamic 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/phoenix/lib/phoenix/router.ex:465: UpiDynamic.Router.call/2
    (upi_dynamic 0.1.0) lib/upi_dynamic/endpoint.ex:1: UpiDynamic.Endpoint.plug_builder_call/2
    (upi_dynamic 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/plug/lib/plug/debugger.ex:155: UpiDynamic.Endpoint."call (overridable 3)"/2
    (upi_dynamic 0.1.0) lib/upi_dynamic/endpoint.ex:1: UpiDynamic.Endpoint.call/2
    (phoenix 1.8.0) lib/phoenix/endpoint/sync_code_reload_plug.ex:22: Phoenix.Endpoint.SyncCodeReloadPlug.do_call/4
    (bandit 1.7.0) lib/bandit/pipeline.ex:131: Bandit.Pipeline.call_plug!/2
    (bandit 1.7.0) lib/bandit/pipeline.ex:42: Bandit.Pipeline.run/5
    (bandit 1.7.0) lib/bandit/http1/handler.ex:13: Bandit.HTTP1.Handler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:18: Bandit.DelegatingHandler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:8: Bandit.DelegatingHandler.handle_continue/2
    (stdlib 5.2.3.2) gen_server.erl:1085: :gen_server.try_handle_continue/3
    (stdlib 5.2.3.2) gen_server.erl:995: :gen_server.loop/7
    (stdlib 5.2.3.2) proc_lib.erl:241: :proc_lib.init_p_do_apply/3

2026-06-07 19:46:40 [ERROR] ** (Bandit.HTTPError) Request line HTTP error: "OPTIONS / RTSP/1.0\r\n"
2026-06-07 20:07:51 [INFO] GET /
2026-06-07 20:07:51 [DEBUG] Processing with UpiWeb.PageController.home/2
  Parameters: %{}
  Pipelines: [:browser]
2026-06-07 20:07:51 [INFO] Sent 200 in 6ms
2026-06-07 20:11:52 [INFO] GET /
2026-06-07 20:11:52 [DEBUG] Processing with UpiWeb.PageController.home/2
  Parameters: %{}
  Pipelines: [:browser]
2026-06-07 20:11:52 [INFO] Sent 200 in 5ms
2026-06-07 20:16:03 [INFO] GET /
2026-06-07 20:16:03 [DEBUG] ** (Phoenix.Router.NoRouteError) no route found for GET / (UpiStatic.Router)
    (upi_static 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/phoenix/lib/phoenix/router.ex:465: UpiStatic.Router.call/2
    (upi_static 0.1.0) lib/upi_static/endpoint.ex:1: UpiStatic.Endpoint.plug_builder_call/2
    (upi_static 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/plug/lib/plug/debugger.ex:155: UpiStatic.Endpoint."call (overridable 3)"/2
    (upi_static 0.1.0) lib/upi_static/endpoint.ex:1: UpiStatic.Endpoint.call/2
    (phoenix 1.8.0) lib/phoenix/endpoint/sync_code_reload_plug.ex:22: Phoenix.Endpoint.SyncCodeReloadPlug.do_call/4
    (bandit 1.7.0) lib/bandit/pipeline.ex:131: Bandit.Pipeline.call_plug!/2
    (bandit 1.7.0) lib/bandit/pipeline.ex:42: Bandit.Pipeline.run/5
    (bandit 1.7.0) lib/bandit/http1/handler.ex:13: Bandit.HTTP1.Handler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:18: Bandit.DelegatingHandler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:8: Bandit.DelegatingHandler.handle_continue/2
    (stdlib 5.2.3.2) gen_server.erl:1085: :gen_server.try_handle_continue/3
    (stdlib 5.2.3.2) gen_server.erl:995: :gen_server.loop/7
    (stdlib 5.2.3.2) proc_lib.erl:241: :proc_lib.init_p_do_apply/3

2026-06-07 20:17:56 [INFO] GET /
2026-06-07 20:17:56 [DEBUG] ** (Phoenix.Router.NoRouteError) no route found for GET / (UpiDynamic.Router)
    (upi_dynamic 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/phoenix/lib/phoenix/router.ex:465: UpiDynamic.Router.call/2
    (upi_dynamic 0.1.0) lib/upi_dynamic/endpoint.ex:1: UpiDynamic.Endpoint.plug_builder_call/2
    (upi_dynamic 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/plug/lib/plug/debugger.ex:155: UpiDynamic.Endpoint."call (overridable 3)"/2
    (upi_dynamic 0.1.0) lib/upi_dynamic/endpoint.ex:1: UpiDynamic.Endpoint.call/2
    (phoenix 1.8.0) lib/phoenix/endpoint/sync_code_reload_plug.ex:22: Phoenix.Endpoint.SyncCodeReloadPlug.do_call/4
    (bandit 1.7.0) lib/bandit/pipeline.ex:131: Bandit.Pipeline.call_plug!/2
    (bandit 1.7.0) lib/bandit/pipeline.ex:42: Bandit.Pipeline.run/5
    (bandit 1.7.0) lib/bandit/http1/handler.ex:13: Bandit.HTTP1.Handler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:18: Bandit.DelegatingHandler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:8: Bandit.DelegatingHandler.handle_continue/2
    (stdlib 5.2.3.2) gen_server.erl:1085: :gen_server.try_handle_continue/3
    (stdlib 5.2.3.2) gen_server.erl:995: :gen_server.loop/7
    (stdlib 5.2.3.2) proc_lib.erl:241: :proc_lib.init_p_do_apply/3

2026-06-07 20:18:26 [INFO] GET /
2026-06-07 20:18:26 [DEBUG] ** (Phoenix.Router.NoRouteError) no route found for GET / (UpiDynamic.Router)
    (upi_dynamic 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/phoenix/lib/phoenix/router.ex:465: UpiDynamic.Router.call/2
    (upi_dynamic 0.1.0) lib/upi_dynamic/endpoint.ex:1: UpiDynamic.Endpoint.plug_builder_call/2
    (upi_dynamic 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/plug/lib/plug/debugger.ex:155: UpiDynamic.Endpoint."call (overridable 3)"/2
    (upi_dynamic 0.1.0) lib/upi_dynamic/endpoint.ex:1: UpiDynamic.Endpoint.call/2
    (phoenix 1.8.0) lib/phoenix/endpoint/sync_code_reload_plug.ex:22: Phoenix.Endpoint.SyncCodeReloadPlug.do_call/4
    (bandit 1.7.0) lib/bandit/pipeline.ex:131: Bandit.Pipeline.call_plug!/2
    (bandit 1.7.0) lib/bandit/pipeline.ex:42: Bandit.Pipeline.run/5
    (bandit 1.7.0) lib/bandit/http1/handler.ex:13: Bandit.HTTP1.Handler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:18: Bandit.DelegatingHandler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:8: Bandit.DelegatingHandler.handle_continue/2
    (stdlib 5.2.3.2) gen_server.erl:1085: :gen_server.try_handle_continue/3
    (stdlib 5.2.3.2) gen_server.erl:995: :gen_server.loop/7
    (stdlib 5.2.3.2) proc_lib.erl:241: :proc_lib.init_p_do_apply/3

2026-06-07 20:34:53 [INFO] GET /
2026-06-07 20:34:54 [DEBUG] Processing with UpiWeb.PageController.home/2
  Parameters: %{}
  Pipelines: [:browser]
2026-06-07 20:34:54 [INFO] Sent 200 in 5ms
2026-06-07 20:35:00 [INFO] [Scheduler] ingest trigger fired at 2026-06-07T20:35:00.000685Z
2026-06-07 20:35:00 [DEBUG] [Scheduler] next tick in 75300s
2026-06-07 20:35:00 [DEBUG] client will use strict KEX ordering
2026-06-07 20:35:00 [ERROR] Erlang SSH :client version: 5.1.4.3 (OpenSSL 3.0.13 30 Jan 2024).
Address: 127.0.0.1:58684
Peer server version: ~c"SSH-2.0-OpenSSH_9.6p1 Ubuntu-3ubuntu13.16"
Peer address: 127.0.0.1:22
badarg

2026-06-07 20:35:00 [INFO] Erlang SSH :client version: 5.1.4.3 (OpenSSL 3.0.13 30 Jan 2024).
Address: 127.0.0.1:58684
Peer server version: ~c"SSH-2.0-OpenSSH_9.6p1 Ubuntu-3ubuntu13.16"
Peer address: 127.0.0.1:22
Disconnects with code = 11 [RFC4253 11.1]: Internal error
State = {userauth,client}
Module = ssh_connection_handler, Line = 1424.
Details:
  Reason: badarg

2026-06-07 20:35:00 [ERROR] GenStateMachine #PID<0.8363.0> terminating
** (ArgumentError) errors were found at the given arguments:

  * 1st argument: not valid character data (an iodata term)

    (stdlib 5.2.3.2) unicode.erl:895: :unicode.characters_to_binary({:error, :enotsup})
    (ssh 5.1.4.3) ssh_auth.erl:121: :ssh_auth.password_msg/1
    (ssh 5.1.4.3) ssh_auth.erl:59: :ssh_auth.userauth_request_msg/1
    (ssh 5.1.4.3) ssh_fsm_userauth_client.erl:92: :ssh_fsm_userauth_client.handle_event/4
    (stdlib 5.2.3.2) gen_statem.erl:1397: :gen_statem.loop_state_callback/11
    (stdlib 5.2.3.2) proc_lib.erl:241: :proc_lib.init_p_do_apply/3
State: [data: [{~c"State", {:data, #PID<0.1339.0>, [], {:connection, [], #Reference<0.784845562.2175926275.142343>, 0, :undefined, %{internal_options: %{connection_sup: #PID<0.8362.0>, negotiation_timeout: :infinity, user_pid: #PID<0.1339.0>}, ssh_msg_debug_fun: #Function<49.126434157/4 in :ssh_options.default/1>, max_random_length_padding: 15, auth_methods: ~c"publickey,keyboard-interactive,password", ecdsa_pass_phrase: :"***", idle_time: :infinity, keyboard_interact_fun: :undefined, vsn: {2, 0}, save_accepted_host: true, key_cb: {:ssh_file, []}, send_ext_info: true, user_dir: false, connect_timeout: :infinity, dh_gex_limits: {1024, 6144, 8192}, user_interaction: true, preferred_algorithms: [kex: [:"curve25519-sha256", :"curve25519-sha256@libssh.org", :"curve448-sha512", :"ecdh-sha2-nistp521", :"ecdh-sha2-nistp384", :"ecdh-sha2-nistp256", :"diffie-hellman-group-exchange-sha256", :"diffie-hellman-group16-sha512", :"diffie-hellman-group18-sha512", :"diffie-hellman-group14-sha256"], public_key: [:"ssh-ed25519", :"ssh-ed448", :"ecdsa-sha2-nistp521", :"ecdsa-sha2-nistp384", :"ecdsa-sha2-nistp256", :"rsa-sha2-512", :"rsa-sha2-256"], cipher: [client2server: [:"aes256-gcm@openssh.com", :"aes256-ctr", :"aes192-ctr", :"aes128-gcm@openssh.com", :"aes128-ctr", :"chacha20-poly1305@openssh.com", :"aes256-cbc", :"aes192-cbc", :"aes128-cbc", :"3des-cbc"], server2client: [:"aes256-gcm@openssh.com", :"aes256-ctr", :"aes192-ctr", :"aes128-gcm@openssh.com", :"aes128-ctr", :"chacha20-poly1305@openssh.com", :"aes256-cbc", :"aes192-cbc", :"aes128-cbc", :"3des-cbc"]], mac: [client2server: [:"hmac-sha2-512-etm@openssh.com", :"hmac-sha2-256-etm@openssh.com", :"hmac-sha2-512", :"hmac-sha2-256", :"hmac-sha1-etm@openssh.com", :"hmac-sha1"], server2client: [:"hmac-sha2-512-etm@openssh.com", :"hmac-sha2-256-etm@openssh.com", :"hmac-sha2-512", :"hmac-sha2-256", :"hmac-sha1-etm@openssh.com", :"hmac-sha1"]], compression: [client2server: [:none, :"zlib@openssh.com", :zlib], server2client: [:none, :"zlib@openssh.com", :zlib]]], quiet_mode: false, silently_accept_hosts: true, disconnectfun: #Function<45.126434157/1 in :ssh_options.default/1>, key_cb_options: [silently_accept_hosts: true, user: []], recv_ext_info: true, password: :"***", user: [], max_log_item_len: 500, pref_public_key_algs: [:"ssh-ed25519", :"ssh-ed448", :"ecdsa-sha2-nistp521", :"ecdsa-sha2-nistp384", :"ecdsa-sha2-nistp256", :"rsa-sha2-512", :"rsa-sha2-256"], id_string: ~c"Erlang/5.1.4.3", profile: :default, tstflg: [], socket_options: [], rsa_pass_phrase: :"***", user_dir_fun: :undefined, dsa_pass_phrase: :"***", transport: {:tcp, :gen_tcp, :tcp_closed}, unexpectedfun: #Function<47.126434157/2 in :ssh_options.default/1>, modify_algorithms: :undefined, rekey_limit: {...}}, 425984, 65536, :undefined, #PID<0.8362.0>}, 0, :tcp, :gen_tcp, :tcp_closed, {:ssh, :client, {~c"127.0.0.1", {{127, 0, 0, 1}, 22}}, {{127, 0, 0, 1}, 58684}, {2, 0}, {2, 0}, ~c"SSH-2.0-Erlang/5.1.4.3", ~c"SSH-2.0-OpenSSH_9.6p1 Ubuntu-3ubuntu13.16", :"****", :"****", true, true, true, {:alg, :"curve25519-sha256", :"ssh-ed25519", :AEAD_AES_256_GCM, :AEAD_AES_256_GCM, :AEAD_AES_256_GCM, :AEAD_AES_256_GCM, :none, :none, :none, :none, true, true, true}, :AEAD_AES_256_GCM, :"****", :"****", :AEAD_AES_256_GCM, :"****", :"****", :AEAD_AES_256_GCM, :aes_256_gcm, :"****", 16, :"****", :AEAD_AES_256_GCM, :aes_256_gcm, :"****", 16, :"****", :none, :"****", :none, :"****", :none, :none, true, ...}, #Port<0.216>, :"****", :"****", "", :undefined, :"****", 0, [], :"****"}}]]
Callback mode: :handle_event_function
Postponed events: []
Last event: {:internal, {:ssh_msg_userauth_failure, ~c"publickey,password", false}}
Queued events: []
State: [data: [{~c"State", {:data, #PID<0.1339.0>, [], {:connection, [], #Reference<0.784845562.2175926275.142343>, 0, :undefined, %{internal_options: %{connection_sup: #PID<0.8362.0>, negotiation_timeout: :infinity, user_pid: #PID<0.1339.0>}, ssh_msg_debug_fun: #Function<49.126434157/4 in :ssh_options.default/1>, max_random_length_padding: 15, auth_methods: ~c"publickey,keyboard-interactive,password", ecdsa_pass_phrase: :"***", idle_time: :infinity, keyboard_interact_fun: :undefined, vsn: {2, 0}, save_accepted_host: true, key_cb: {:ssh_file, []}, send_ext_info: true, user_dir: false, connect_timeout: :infinity, dh_gex_limits: {1024, 6144, 8192}, user_interaction: true, preferred_algorithms: [kex: [:"curve25519-sha256", :"curve25519-sha256@libssh.org", :"curve448-sha512", :"ecdh-sha2-nistp521", :"ecdh-sha2-nistp384", :"ecdh-sha2-nistp256", :"diffie-hellman-group-exchange-sha256", :"diffie-hellman-group16-sha512", :"diffie-hellman-group18-sha512", :"diffie-hellman-group14-sha256"], public_key: [:"ssh-ed25519", :"ssh-ed448", :"ecdsa-sha2-nistp521", :"ecdsa-sha2-nistp384", :"ecdsa-sha2-nistp256", :"rsa-sha2-512", :"rsa-sha2-256"], cipher: [client2server: [:"aes256-gcm@openssh.com", :"aes256-ctr", :"aes192-ctr", :"aes128-gcm@openssh.com", :"aes128-ctr", :"chacha20-poly1305@openssh.com", :"aes256-cbc", :"aes192-cbc", :"aes128-cbc", :"3des-cbc"], server2client: [:"aes256-gcm@openssh.com", :"aes256-ctr", :"aes192-ctr", :"aes128-gcm@openssh.com", :"aes128-ctr", :"chacha20-poly1305@openssh.com", :"aes256-cbc", :"aes192-cbc", :"aes128-cbc", :"3des-cbc"]], mac: [client2server: [:"hmac-sha2-512-etm@openssh.com", :"hmac-sha2-256-etm@openssh.com", :"hmac-sha2-512", :"hmac-sha2-256", :"hmac-sha1-etm@openssh.com", :"hmac-sha1"], server2client: [:"hmac-sha2-512-etm@openssh.com", :"hmac-sha2-256-etm@openssh.com", :"hmac-sha2-512", :"hmac-sha2-256", :"hmac-sha1-etm@openssh.com", :"hmac-sha1"]], compression: [client2server: [:none, :"zlib@openssh.com", :zlib], server2client: [:none, :"zlib@openssh.com", :zlib]]], quiet_mode: false, silently_accept_hosts: true, disconnectfun: #Function<45.126434157/1 in :ssh_options.default/1>, key_cb_options: [silently_accept_hosts: true, user: []], recv_ext_info: true, password: :"***", user: [], max_log_item_len: 500, pref_public_key_algs: [:"ssh-ed25519", :"ssh-ed448", :"ecdsa-sha2-nistp521", :"ecdsa-sha2-nistp384", :"ecdsa-sha2-nistp256", :"rsa-sha2-512", :"rsa-sha2-256"], id_string: ~c"Erlang/5.1.4.3", profile: :default, tstflg: [], socket_options: [], rsa_pass_phrase: :"***", user_dir_fun: :undefined, dsa_pass_phrase: :"***", transport: {:tcp, :gen_tcp, :tcp_closed}, unexpectedfun: #Function<47.126434157/2 in :ssh_options.default/1>, modify_algorithms: :undefined, rekey_limit: {...}}, 425984, 65536, :undefined, #PID<0.8362.0>}, 0, :tcp, :gen_tcp, :tcp_closed, {:ssh, :client, {~c"127.0.0.1", {{127, 0, 0, 1}, 22}}, {{127, 0, 0, 1}, 58684}, {2, 0}, {2, 0}, ~c"SSH-2.0-Erlang/5.1.4.3", ~c"SSH-2.0-OpenSSH_9.6p1 Ubuntu-3ubuntu13.16", :"****", :"****", true, true, true, {:alg, :"curve25519-sha256", :"ssh-ed25519", :AEAD_AES_256_GCM, :AEAD_AES_256_GCM, :AEAD_AES_256_GCM, :AEAD_AES_256_GCM, :none, :none, :none, :none, true, true, true}, :AEAD_AES_256_GCM, :"****", :"****", :AEAD_AES_256_GCM, :"****", :"****", :AEAD_AES_256_GCM, :aes_256_gcm, :"****", 16, :"****", :AEAD_AES_256_GCM, :aes_256_gcm, :"****", 16, :"****", :none, :"****", :none, :"****", :none, :none, true, ...}, #Port<0.216>, :"****", :"****", "", :undefined, :"****", 0, [], :"****"}}]]
2026-06-07 20:35:00 [ERROR] [NpciFile.Ingestion] SFTP download failed: {:badarg, [{:unicode, :characters_to_binary, [error: :enotsup], [file: ~c"unicode.erl", line: 895, error_info: %{module: :erl_stdlib_errors}]}, {:ssh_auth, :password_msg, 1, [file: ~c"ssh_auth.erl", line: 121]}, {:ssh_auth, :userauth_request_msg, 1, [file: ~c"ssh_auth.erl", line: 59]}, {:ssh_fsm_userauth_client, :handle_event, 4, [file: ~c"ssh_fsm_userauth_client.erl", line: 92]}, {:gen_statem, :loop_state_callback, 11, [file: ~c"gen_statem.erl", line: 1397]}, {:proc_lib, :init_p_do_apply, 3, [file: ~c"proc_lib.erl", line: 241]}]}
2026-06-07 20:35:00 [DEBUG] QUERY OK source="disputes" db=1.9ms idle=1074.8ms
SELECT d0.`id`, d0.`dispute_type`, d0.`status`, d0.`amount`, d0.`dispute_ref`, d0.`utxn_id`, d0.`rrn`, d0.`reason_code`, d0.`deadline_at`, d0.`remarks`, d0.`window_start`, d0.`window_end`, d0.`rrc_ref`, d0.`rrc_confirmed_at`, d0.`merchant_id`, d0.`transaction_id`, d0.`inserted_at`, d0.`updated_at` FROM `disputes` AS d0 WHERE ((d0.`status` = 'open') AND (d0.`deadline_at` <= ?)) [~D[2026-06-07]]
[90m↳ UpiSettlement.DisputeService.check_deemed_deadlines/0, at: lib/upi_settlement/dispute_service.ex:104[0m
2026-06-07 20:38:17 [INFO] GET /
2026-06-07 20:38:17 [DEBUG] Processing with UpiWeb.PageController.home/2
  Parameters: %{}
  Pipelines: [:browser]
2026-06-07 20:38:17 [INFO] Sent 200 in 6ms
2026-06-07 20:41:04 [INFO] GET /
2026-06-07 20:41:04 [DEBUG] Processing with UpiWeb.PageController.home/2
  Parameters: %{}
  Pipelines: [:browser]
2026-06-07 20:41:04 [INFO] Sent 200 in 5ms
2026-06-07 20:42:58 [WARN] Connection that looks like TLS received on a clear channel
2026-06-07 20:44:06 [ERROR] ** (Bandit.TransportError) Unrecoverable error: timeout
2026-06-07 20:44:13 [ERROR] ** (Bandit.HTTPError) Request line HTTP error: <<3, 0, 0, 38, 33, 224, 0, 0, 254, 202, 0, 67, 111, 111, 107, 105, 101, 58, 32, 109, 115, 116, 115, 104, 97, 115, 104, 61, 13, 10>>
2026-06-07 20:44:53 [ERROR] ** (Bandit.HTTPError) Request line HTTP error: <<3, 0, 0, 38, 33, 224, 0, 0, 254, 202, 0, 67, 111, 111, 107, 105, 101, 58, 32, 109, 115, 116, 115, 104, 97, 115, 104, 61, 13, 10>>
2026-06-07 21:19:05 [INFO] GET /
2026-06-07 21:19:05 [DEBUG] ** (Phoenix.Router.NoRouteError) no route found for GET / (UpiStatic.Router)
    (upi_static 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/phoenix/lib/phoenix/router.ex:465: UpiStatic.Router.call/2
    (upi_static 0.1.0) lib/upi_static/endpoint.ex:1: UpiStatic.Endpoint.plug_builder_call/2
    (upi_static 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/plug/lib/plug/debugger.ex:155: UpiStatic.Endpoint."call (overridable 3)"/2
    (upi_static 0.1.0) lib/upi_static/endpoint.ex:1: UpiStatic.Endpoint.call/2
    (phoenix 1.8.0) lib/phoenix/endpoint/sync_code_reload_plug.ex:22: Phoenix.Endpoint.SyncCodeReloadPlug.do_call/4
    (bandit 1.7.0) lib/bandit/pipeline.ex:131: Bandit.Pipeline.call_plug!/2
    (bandit 1.7.0) lib/bandit/pipeline.ex:42: Bandit.Pipeline.run/5
    (bandit 1.7.0) lib/bandit/http1/handler.ex:13: Bandit.HTTP1.Handler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:18: Bandit.DelegatingHandler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:8: Bandit.DelegatingHandler.handle_continue/2
    (stdlib 5.2.3.2) gen_server.erl:1085: :gen_server.try_handle_continue/3
    (stdlib 5.2.3.2) gen_server.erl:995: :gen_server.loop/7
    (stdlib 5.2.3.2) proc_lib.erl:241: :proc_lib.init_p_do_apply/3

2026-06-07 21:19:49 [INFO] GET /
2026-06-07 21:19:49 [DEBUG] Processing with UpiWeb.PageController.home/2
  Parameters: %{}
  Pipelines: [:browser]
2026-06-07 21:19:49 [INFO] Sent 200 in 6ms
2026-06-07 21:23:28 [INFO] GET /
2026-06-07 21:23:28 [DEBUG] ** (Phoenix.Router.NoRouteError) no route found for GET / (UpiDynamic.Router)
    (upi_dynamic 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/phoenix/lib/phoenix/router.ex:465: UpiDynamic.Router.call/2
    (upi_dynamic 0.1.0) lib/upi_dynamic/endpoint.ex:1: UpiDynamic.Endpoint.plug_builder_call/2
    (upi_dynamic 0.1.0) /var/www/internaltesting/madhoolika/staticverification/upi_psp_platform/deps/plug/lib/plug/debugger.ex:155: UpiDynamic.Endpoint."call (overridable 3)"/2
    (upi_dynamic 0.1.0) lib/upi_dynamic/endpoint.ex:1: UpiDynamic.Endpoint.call/2
    (phoenix 1.8.0) lib/phoenix/endpoint/sync_code_reload_plug.ex:22: Phoenix.Endpoint.SyncCodeReloadPlug.do_call/4
    (bandit 1.7.0) lib/bandit/pipeline.ex:131: Bandit.Pipeline.call_plug!/2
    (bandit 1.7.0) lib/bandit/pipeline.ex:42: Bandit.Pipeline.run/5
    (bandit 1.7.0) lib/bandit/http1/handler.ex:13: Bandit.HTTP1.Handler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:18: Bandit.DelegatingHandler.handle_data/3
    (bandit 1.7.0) lib/bandit/delegating_handler.ex:8: Bandit.DelegatingHandler.handle_continue/2
    (stdlib 5.2.3.2) gen_server.erl:1085: :gen_server.try_handle_continue/3
    (stdlib 5.2.3.2) gen_server.erl:995: :gen_server.loop/7
    (stdlib 5.2.3.2) proc_lib.erl:241: :proc_lib.init_p_do_apply/3

2026-06-08 00:00:00 [INFO] Starting log rotation: logs/q2.log -> logs/archived/q2-2026-06-07.log.gz
