System Logs
Total: 29599
Errors
| Time | Level | Category | Symbol | Source | Message |
|---|---|---|---|---|---|
| 02-18 22:51:47 | INFO | order | tiger_client | Retrieved 2 filled orders | |
| 02-18 22:51:47 | INFO | order | tiger_client | Getting filled orders from 2026-02-17 to 2026-02-18 | |
| 02-18 22:51:47 | INFO | order | tiger_client | Getting filled orders from 2026-02-17 to 2026-02-18 | |
| 02-18 22:51:47 | WARN | trailing_stop | trailing_stop_scheduler | ⚠️ Qty mismatch for NFLX (real): DB trailing_stop=1.0, Tiger=4 | |
| 02-18 22:51:47 | INFO | sync | trailing_stop_engine | 📊 Syncing avg cost for NFLX: 77.93 -> 78.23 | |
| 02-18 22:51:47 | INFO | position | trailing_stop_engine | 📊 Syncing quantity for NFLX: 1.0 -> 4 | |
| 02-18 22:51:47 | INFO | sync | trailing_stop_engine | 📊 Syncing avg cost for NFLX: 77.94 -> 77.95 | |
| 02-18 22:51:47 | INFO | trailing_stop | trailing_stop_scheduler | 🔄 Full sync: Processing 2 active trailing stop positions (API verification) | |
| 02-18 22:51:47 | INFO | position | tiger_client | Position: NFLX, Qty: 10, Cost: 78.227 | |
| 02-18 22:51:47 | INFO | position | tiger_client | Getting positions for symbol: all | |
| 02-18 22:51:46 | INFO | order | tiger_client | Retrieved 2 filled orders | |
| 02-18 22:51:46 | INFO | order | tiger_client | Getting filled orders from 2026-02-17 to 2026-02-18 | |
| 02-18 22:51:46 | INFO | position | tiger_client | Position: NFLX, Qty: 4, Cost: 77.9465 | |
| 02-18 22:51:46 | INFO | position | tiger_client | Getting positions for symbol: all | |
| 02-18 22:51:46 | WARN | trailing_stop | trailing_stop_scheduler | ⚠️ Qty mismatch for NFLX (real): DB trailing_stop=1.0, Tiger=4 | |
| 02-18 22:51:46 | INFO | sync | trailing_stop_engine | 📊 Syncing avg cost for NFLX: 77.93 -> 78.23 | |
| 02-18 22:51:46 | INFO | position | trailing_stop_engine | 📊 Syncing quantity for NFLX: 1.0 -> 4 | |
| 02-18 22:51:46 | INFO | sync | trailing_stop_engine | 📊 Syncing avg cost for NFLX: 77.94 -> 77.95 | |
| 02-18 22:51:46 | INFO | trailing_stop | trailing_stop_scheduler | 🔄 Full sync: Processing 2 active trailing stop positions (API verification) | |
| 02-18 22:51:46 | INFO | position | tiger_client | Position: NFLX, Qty: 10, Cost: 78.227 | |
| 02-18 22:51:46 | INFO | position | tiger_client | Getting positions for symbol: all | |
| 02-18 22:51:46 | INFO | position | tiger_client | Position: NFLX, Qty: 4, Cost: 77.9465 | |
| 02-18 22:51:45 | INFO | position | tiger_client | Getting positions for symbol: all | |
| 02-18 22:51:41 | WARN | websocket | trailing_stop_scheduler | 🔄 Auto re-subscribed symbols with stale WebSocket data: ['NFLX'] | |
| 02-18 22:51:40 | WARN | websocket | trailing_stop_scheduler | 🔄 Auto re-subscribed symbols with stale WebSocket data: ['NFLX'] | |
| 02-18 22:51:11 | INFO | error | trailing_stop_engine | 📊 NFLX API backoff set for 120s due to repeated errors | |
| 02-18 22:51:11 | ERROR | error | tiger_client | Error getting latest trade for NFLX: code=4 msg=4000:permission denied(Current user and device do not have permissions in the US market) | |
| 02-18 22:51:11 | WARN | general | tiger_client | Extended hours price not available for NFLX, falling back to briefs | |
| 02-18 22:51:11 | ERROR | error | tiger_client | Error getting extended hours price for NFLX: code=4 msg=4000:permission denied(Current user and device do not have permissions in the US market) | |
| 02-18 22:51:11 | WARN | error | tiger_client | Batch briefs fallback failed: code=4 msg=4000:permission denied(Current user and device do not have permissions in the US market) | |
| 02-18 22:51:11 | WARN | error | tiger_client | Batch timeline fetch failed: code=4 msg=4000:permission denied(Current user and device do not have permissions in the US market) | |
| 02-18 22:51:10 | INFO | error | trailing_stop_engine | 📊 NFLX API backoff set for 120s due to repeated errors | |
| 02-18 22:51:10 | ERROR | error | tiger_client | Error getting latest trade for NFLX: code=4 msg=4000:permission denied(Current user and device do not have permissions in the US market) | |
| 02-18 22:51:10 | WARN | general | tiger_client | Extended hours price not available for NFLX, falling back to briefs | |
| 02-18 22:51:10 | ERROR | error | tiger_client | Error getting extended hours price for NFLX: code=4 msg=4000:permission denied(Current user and device do not have permissions in the US market) | |
| 02-18 22:51:10 | WARN | error | tiger_client | Batch briefs fallback failed: code=4 msg=4000:permission denied(Current user and device do not have permissions in the US market) | |
| 02-18 22:51:10 | WARN | error | tiger_client | Batch timeline fetch failed: code=4 msg=4000:permission denied(Current user and device do not have permissions in the US market) | |
| 02-18 22:50:45 | ERROR | order | order_tracker_service | ❌ Error in handle_fill_event for 42277739866882048: Failed to create Position for NFLX paper 2026-02-18 after 5 attempts | |
| 02-18 22:50:45 | WARN | trailing_stop | position_service | 🔁 Position key collision for NFLX_2026-02-18_1 (paper), retrying with next sequence: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "ix_position_position_key" DETAIL: Key (position_key)=(NFLX_2026-02-18_1) already exists. [SQL: INSERT INTO position (position_key, symbol, account_type, trade_date, sequence_number, side, status, total_entry_quantity, total_exit_quantity, avg_entry_price, avg_exit_price, realized_pnl, commission, trailing_stop_id, opened_at, closed_at, created_at, updated_at) VALUES (%(position_key)s, %(symbol)s, %(account_type)s, %(trade_date)s, %(sequence_number)s, %(side)s, %(status)s, %(total_entry_quantity)s, %(total_exit_quantity)s, %(avg_entry_price)s, %(avg_exit_price)s, %(realized_pnl)s, %(commission)s, %(trailing_stop_id)s, %(opened_at)s, %(closed_at)s, %(created_at)s, %(updated_at)s) RETURNING position.id] [parameters: {'position_key': 'NFLX_2026-02-18_1', 'symbol': 'NFLX', 'account_type': 'paper', 'trade_date': datetime.date(2026, 2, 18), 'sequence_number': 1, 'side': 'long', 'status': 'OPEN', 'total_entry_quantity': 0, 'total_exit_quantity': 0, 'avg_entry_price': None, 'avg_exit_price': None, 'realized_pnl': None, 'commission': None, 'trailing_stop_id': None, 'opened_at': datetime.datetime(2026, 2, 18, 22, 50, 45, 754640), 'closed_at': None, 'created_at': datetime.datetime(2026, 2, 18, 22, 50, 45, 786123), 'updated_at': datetime.datetime(2026, 2, 18, 22, 50, 45, 786129)}] (Background on this error at: https://sqlalche.me/e/20/gkpj) | |
| 02-18 22:50:45 | WARN | trailing_stop | position_service | 🔁 Position key collision for NFLX_2026-02-18_1 (paper), retrying with next sequence: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "ix_position_position_key" DETAIL: Key (position_key)=(NFLX_2026-02-18_1) already exists. [SQL: INSERT INTO position (position_key, symbol, account_type, trade_date, sequence_number, side, status, total_entry_quantity, total_exit_quantity, avg_entry_price, avg_exit_price, realized_pnl, commission, trailing_stop_id, opened_at, closed_at, created_at, updated_at) VALUES (%(position_key)s, %(symbol)s, %(account_type)s, %(trade_date)s, %(sequence_number)s, %(side)s, %(status)s, %(total_entry_quantity)s, %(total_exit_quantity)s, %(avg_entry_price)s, %(avg_exit_price)s, %(realized_pnl)s, %(commission)s, %(trailing_stop_id)s, %(opened_at)s, %(closed_at)s, %(created_at)s, %(updated_at)s) RETURNING position.id] [parameters: {'position_key': 'NFLX_2026-02-18_1', 'symbol': 'NFLX', 'account_type': 'paper', 'trade_date': datetime.date(2026, 2, 18), 'sequence_number': 1, 'side': 'long', 'status': 'OPEN', 'total_entry_quantity': 0, 'total_exit_quantity': 0, 'avg_entry_price': None, 'avg_exit_price': None, 'realized_pnl': None, 'commission': None, 'trailing_stop_id': None, 'opened_at': datetime.datetime(2026, 2, 18, 22, 50, 45, 754640), 'closed_at': None, 'created_at': datetime.datetime(2026, 2, 18, 22, 50, 45, 780585), 'updated_at': datetime.datetime(2026, 2, 18, 22, 50, 45, 780591)}] (Background on this error at: https://sqlalche.me/e/20/gkpj) | |
| 02-18 22:50:45 | WARN | trailing_stop | position_service | 🔁 Position key collision for NFLX_2026-02-18_1 (paper), retrying with next sequence: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "ix_position_position_key" DETAIL: Key (position_key)=(NFLX_2026-02-18_1) already exists. [SQL: INSERT INTO position (position_key, symbol, account_type, trade_date, sequence_number, side, status, total_entry_quantity, total_exit_quantity, avg_entry_price, avg_exit_price, realized_pnl, commission, trailing_stop_id, opened_at, closed_at, created_at, updated_at) VALUES (%(position_key)s, %(symbol)s, %(account_type)s, %(trade_date)s, %(sequence_number)s, %(side)s, %(status)s, %(total_entry_quantity)s, %(total_exit_quantity)s, %(avg_entry_price)s, %(avg_exit_price)s, %(realized_pnl)s, %(commission)s, %(trailing_stop_id)s, %(opened_at)s, %(closed_at)s, %(created_at)s, %(updated_at)s) RETURNING position.id] [parameters: {'position_key': 'NFLX_2026-02-18_1', 'symbol': 'NFLX', 'account_type': 'paper', 'trade_date': datetime.date(2026, 2, 18), 'sequence_number': 1, 'side': 'long', 'status': 'OPEN', 'total_entry_quantity': 0, 'total_exit_quantity': 0, 'avg_entry_price': None, 'avg_exit_price': None, 'realized_pnl': None, 'commission': None, 'trailing_stop_id': None, 'opened_at': datetime.datetime(2026, 2, 18, 22, 50, 45, 754640), 'closed_at': None, 'created_at': datetime.datetime(2026, 2, 18, 22, 50, 45, 774933), 'updated_at': datetime.datetime(2026, 2, 18, 22, 50, 45, 774939)}] (Background on this error at: https://sqlalche.me/e/20/gkpj) | |
| 02-18 22:50:45 | WARN | trailing_stop | position_service | 🔁 Position key collision for NFLX_2026-02-18_1 (paper), retrying with next sequence: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "ix_position_position_key" DETAIL: Key (position_key)=(NFLX_2026-02-18_1) already exists. [SQL: INSERT INTO position (position_key, symbol, account_type, trade_date, sequence_number, side, status, total_entry_quantity, total_exit_quantity, avg_entry_price, avg_exit_price, realized_pnl, commission, trailing_stop_id, opened_at, closed_at, created_at, updated_at) VALUES (%(position_key)s, %(symbol)s, %(account_type)s, %(trade_date)s, %(sequence_number)s, %(side)s, %(status)s, %(total_entry_quantity)s, %(total_exit_quantity)s, %(avg_entry_price)s, %(avg_exit_price)s, %(realized_pnl)s, %(commission)s, %(trailing_stop_id)s, %(opened_at)s, %(closed_at)s, %(created_at)s, %(updated_at)s) RETURNING position.id] [parameters: {'position_key': 'NFLX_2026-02-18_1', 'symbol': 'NFLX', 'account_type': 'paper', 'trade_date': datetime.date(2026, 2, 18), 'sequence_number': 1, 'side': 'long', 'status': 'OPEN', 'total_entry_quantity': 0, 'total_exit_quantity': 0, 'avg_entry_price': None, 'avg_exit_price': None, 'realized_pnl': None, 'commission': None, 'trailing_stop_id': None, 'opened_at': datetime.datetime(2026, 2, 18, 22, 50, 45, 754640), 'closed_at': None, 'created_at': datetime.datetime(2026, 2, 18, 22, 50, 45, 768782), 'updated_at': datetime.datetime(2026, 2, 18, 22, 50, 45, 768789)}] (Background on this error at: https://sqlalche.me/e/20/gkpj) | |
| 02-18 22:50:45 | WARN | trailing_stop | position_service | 🔁 Position key collision for NFLX_2026-02-18_1 (paper), retrying with next sequence: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "ix_position_position_key" DETAIL: Key (position_key)=(NFLX_2026-02-18_1) already exists. [SQL: INSERT INTO position (position_key, symbol, account_type, trade_date, sequence_number, side, status, total_entry_quantity, total_exit_quantity, avg_entry_price, avg_exit_price, realized_pnl, commission, trailing_stop_id, opened_at, closed_at, created_at, updated_at) VALUES (%(position_key)s, %(symbol)s, %(account_type)s, %(trade_date)s, %(sequence_number)s, %(side)s, %(status)s, %(total_entry_quantity)s, %(total_exit_quantity)s, %(avg_entry_price)s, %(avg_exit_price)s, %(realized_pnl)s, %(commission)s, %(trailing_stop_id)s, %(opened_at)s, %(closed_at)s, %(created_at)s, %(updated_at)s) RETURNING position.id] [parameters: {'position_key': 'NFLX_2026-02-18_1', 'symbol': 'NFLX', 'account_type': 'paper', 'trade_date': datetime.date(2026, 2, 18), 'sequence_number': 1, 'side': 'long', 'status': 'OPEN', 'total_entry_quantity': 0, 'total_exit_quantity': 0, 'avg_entry_price': None, 'avg_exit_price': None, 'realized_pnl': None, 'commission': None, 'trailing_stop_id': None, 'opened_at': datetime.datetime(2026, 2, 18, 22, 50, 45, 754640), 'closed_at': None, 'created_at': datetime.datetime(2026, 2, 18, 22, 50, 45, 762732), 'updated_at': datetime.datetime(2026, 2, 18, 22, 50, 45, 762749)}] (Background on this error at: https://sqlalche.me/e/20/gkpj) | |
| 02-18 22:50:45 | INFO | order | order_tracker_service | 📋 Order 42277739866882048 FILLED (source=polling): NFLX entry qty=10 price=$77.93 pnl=$0.00 | |
| 02-18 22:50:45 | INFO | order | tiger_client | Order 42277739866882048 Tiger data: avgFillPrice=77.929, filledQuantity=10, totalQuantity=10, realizedPnl=0, commission=2.98, reason=, order_type=LMT, outside_rth=True | |
| 02-18 22:50:45 | INFO | order | tiger_client | Order 42277739866882048 available attributes: ['account', 'action', 'active', 'adjust_limit', 'algo_params', 'algo_strategy', 'attr_desc', 'attr_list', 'aux_price', 'avg_fill_price', 'can_modify', 'charges', 'combo_type', 'combo_type_desc', 'commission', 'contract', 'contract_legs', 'discount', 'expire_time', 'external_id', 'filled', 'filled_cash_amount', 'filled_scale', 'gst', 'id', 'is_open', 'is_partially_filled', 'latest_price', 'limit_price', 'liquidation', 'order_id', 'order_legs', 'order_time', 'order_type', 'orders', 'outside_rth', 'parent_id', 'percent_offset', 'quantity', 'quantity_scale', 'realized_pnl', 'reason', 'refund_cash_amount', 'remaining', 'secret_key', 'source', 'status', 'sub_ids', 'time_in_force', 'to_dict', 'total_cash_amount', 'trade_time', 'trading_session_type', 'trail_stop_price', 'trailing_percent', 'update_time', 'user_mark'] | |
| 02-18 22:50:45 | INFO | order | tiger_client | Retrieved 0 filled orders | |
| 02-18 22:50:44 | INFO | order | tiger_client | Getting filled orders from 2026-02-17 to 2026-02-18 | |
| 02-18 22:50:44 | ERROR | order | order_tracker_service | ❌ Error in handle_fill_event for 42277739866882048: Failed to create Position for NFLX paper 2026-02-18 after 5 attempts | |
| 02-18 22:50:44 | WARN | trailing_stop | position_service | 🔁 Position key collision for NFLX_2026-02-18_1 (paper), retrying with next sequence: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "ix_position_position_key" DETAIL: Key (position_key)=(NFLX_2026-02-18_1) already exists. [SQL: INSERT INTO position (position_key, symbol, account_type, trade_date, sequence_number, side, status, total_entry_quantity, total_exit_quantity, avg_entry_price, avg_exit_price, realized_pnl, commission, trailing_stop_id, opened_at, closed_at, created_at, updated_at) VALUES (%(position_key)s, %(symbol)s, %(account_type)s, %(trade_date)s, %(sequence_number)s, %(side)s, %(status)s, %(total_entry_quantity)s, %(total_exit_quantity)s, %(avg_entry_price)s, %(avg_exit_price)s, %(realized_pnl)s, %(commission)s, %(trailing_stop_id)s, %(opened_at)s, %(closed_at)s, %(created_at)s, %(updated_at)s) RETURNING position.id] [parameters: {'position_key': 'NFLX_2026-02-18_1', 'symbol': 'NFLX', 'account_type': 'paper', 'trade_date': datetime.date(2026, 2, 18), 'sequence_number': 1, 'side': 'long', 'status': 'OPEN', 'total_entry_quantity': 0, 'total_exit_quantity': 0, 'avg_entry_price': None, 'avg_exit_price': None, 'realized_pnl': None, 'commission': None, 'trailing_stop_id': None, 'opened_at': datetime.datetime(2026, 2, 18, 22, 50, 44, 607286), 'closed_at': None, 'created_at': datetime.datetime(2026, 2, 18, 22, 50, 44, 652580), 'updated_at': datetime.datetime(2026, 2, 18, 22, 50, 44, 652585)}] (Background on this error at: https://sqlalche.me/e/20/gkpj) | |
| 02-18 22:50:44 | INFO | order | tiger_client | Retrieved 2 filled orders | |
| 02-18 22:50:44 | WARN | trailing_stop | position_service | 🔁 Position key collision for NFLX_2026-02-18_1 (paper), retrying with next sequence: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "ix_position_position_key" DETAIL: Key (position_key)=(NFLX_2026-02-18_1) already exists. [SQL: INSERT INTO position (position_key, symbol, account_type, trade_date, sequence_number, side, status, total_entry_quantity, total_exit_quantity, avg_entry_price, avg_exit_price, realized_pnl, commission, trailing_stop_id, opened_at, closed_at, created_at, updated_at) VALUES (%(position_key)s, %(symbol)s, %(account_type)s, %(trade_date)s, %(sequence_number)s, %(side)s, %(status)s, %(total_entry_quantity)s, %(total_exit_quantity)s, %(avg_entry_price)s, %(avg_exit_price)s, %(realized_pnl)s, %(commission)s, %(trailing_stop_id)s, %(opened_at)s, %(closed_at)s, %(created_at)s, %(updated_at)s) RETURNING position.id] [parameters: {'position_key': 'NFLX_2026-02-18_1', 'symbol': 'NFLX', 'account_type': 'paper', 'trade_date': datetime.date(2026, 2, 18), 'sequence_number': 1, 'side': 'long', 'status': 'OPEN', 'total_entry_quantity': 0, 'total_exit_quantity': 0, 'avg_entry_price': None, 'avg_exit_price': None, 'realized_pnl': None, 'commission': None, 'trailing_stop_id': None, 'opened_at': datetime.datetime(2026, 2, 18, 22, 50, 44, 607286), 'closed_at': None, 'created_at': datetime.datetime(2026, 2, 18, 22, 50, 44, 638098), 'updated_at': datetime.datetime(2026, 2, 18, 22, 50, 44, 638105)}] (Background on this error at: https://sqlalche.me/e/20/gkpj) | |
| 02-18 22:50:44 | WARN | trailing_stop | position_service | 🔁 Position key collision for NFLX_2026-02-18_1 (paper), retrying with next sequence: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "ix_position_position_key" DETAIL: Key (position_key)=(NFLX_2026-02-18_1) already exists. [SQL: INSERT INTO position (position_key, symbol, account_type, trade_date, sequence_number, side, status, total_entry_quantity, total_exit_quantity, avg_entry_price, avg_exit_price, realized_pnl, commission, trailing_stop_id, opened_at, closed_at, created_at, updated_at) VALUES (%(position_key)s, %(symbol)s, %(account_type)s, %(trade_date)s, %(sequence_number)s, %(side)s, %(status)s, %(total_entry_quantity)s, %(total_exit_quantity)s, %(avg_entry_price)s, %(avg_exit_price)s, %(realized_pnl)s, %(commission)s, %(trailing_stop_id)s, %(opened_at)s, %(closed_at)s, %(created_at)s, %(updated_at)s) RETURNING position.id] [parameters: {'position_key': 'NFLX_2026-02-18_1', 'symbol': 'NFLX', 'account_type': 'paper', 'trade_date': datetime.date(2026, 2, 18), 'sequence_number': 1, 'side': 'long', 'status': 'OPEN', 'total_entry_quantity': 0, 'total_exit_quantity': 0, 'avg_entry_price': None, 'avg_exit_price': None, 'realized_pnl': None, 'commission': None, 'trailing_stop_id': None, 'opened_at': datetime.datetime(2026, 2, 18, 22, 50, 44, 607286), 'closed_at': None, 'created_at': datetime.datetime(2026, 2, 18, 22, 50, 44, 631011), 'updated_at': datetime.datetime(2026, 2, 18, 22, 50, 44, 631017)}] (Background on this error at: https://sqlalche.me/e/20/gkpj) | |
| 02-18 22:50:44 | WARN | trailing_stop | position_service | 🔁 Position key collision for NFLX_2026-02-18_1 (paper), retrying with next sequence: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "ix_position_position_key" DETAIL: Key (position_key)=(NFLX_2026-02-18_1) already exists. [SQL: INSERT INTO position (position_key, symbol, account_type, trade_date, sequence_number, side, status, total_entry_quantity, total_exit_quantity, avg_entry_price, avg_exit_price, realized_pnl, commission, trailing_stop_id, opened_at, closed_at, created_at, updated_at) VALUES (%(position_key)s, %(symbol)s, %(account_type)s, %(trade_date)s, %(sequence_number)s, %(side)s, %(status)s, %(total_entry_quantity)s, %(total_exit_quantity)s, %(avg_entry_price)s, %(avg_exit_price)s, %(realized_pnl)s, %(commission)s, %(trailing_stop_id)s, %(opened_at)s, %(closed_at)s, %(created_at)s, %(updated_at)s) RETURNING position.id] [parameters: {'position_key': 'NFLX_2026-02-18_1', 'symbol': 'NFLX', 'account_type': 'paper', 'trade_date': datetime.date(2026, 2, 18), 'sequence_number': 1, 'side': 'long', 'status': 'OPEN', 'total_entry_quantity': 0, 'total_exit_quantity': 0, 'avg_entry_price': None, 'avg_exit_price': None, 'realized_pnl': None, 'commission': None, 'trailing_stop_id': None, 'opened_at': datetime.datetime(2026, 2, 18, 22, 50, 44, 607286), 'closed_at': None, 'created_at': datetime.datetime(2026, 2, 18, 22, 50, 44, 624531), 'updated_at': datetime.datetime(2026, 2, 18, 22, 50, 44, 624541)}] (Background on this error at: https://sqlalche.me/e/20/gkpj) | |
| 02-18 22:50:44 | WARN | trailing_stop | position_service | 🔁 Position key collision for NFLX_2026-02-18_1 (paper), retrying with next sequence: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "ix_position_position_key" DETAIL: Key (position_key)=(NFLX_2026-02-18_1) already exists. [SQL: INSERT INTO position (position_key, symbol, account_type, trade_date, sequence_number, side, status, total_entry_quantity, total_exit_quantity, avg_entry_price, avg_exit_price, realized_pnl, commission, trailing_stop_id, opened_at, closed_at, created_at, updated_at) VALUES (%(position_key)s, %(symbol)s, %(account_type)s, %(trade_date)s, %(sequence_number)s, %(side)s, %(status)s, %(total_entry_quantity)s, %(total_exit_quantity)s, %(avg_entry_price)s, %(avg_exit_price)s, %(realized_pnl)s, %(commission)s, %(trailing_stop_id)s, %(opened_at)s, %(closed_at)s, %(created_at)s, %(updated_at)s) RETURNING position.id] [parameters: {'position_key': 'NFLX_2026-02-18_1', 'symbol': 'NFLX', 'account_type': 'paper', 'trade_date': datetime.date(2026, 2, 18), 'sequence_number': 1, 'side': 'long', 'status': 'OPEN', 'total_entry_quantity': 0, 'total_exit_quantity': 0, 'avg_entry_price': None, 'avg_exit_price': None, 'realized_pnl': None, 'commission': None, 'trailing_stop_id': None, 'opened_at': datetime.datetime(2026, 2, 18, 22, 50, 44, 607286), 'closed_at': None, 'created_at': datetime.datetime(2026, 2, 18, 22, 50, 44, 616793), 'updated_at': datetime.datetime(2026, 2, 18, 22, 50, 44, 616802)}] (Background on this error at: https://sqlalche.me/e/20/gkpj) | |
| 02-18 22:50:44 | INFO | order | order_tracker_service | 📋 Order 42277739866882048 FILLED (source=polling): NFLX entry qty=10 price=$77.93 pnl=$0.00 | |
| 02-18 22:50:44 | INFO | order | tiger_client | Order 42277739866882048 Tiger data: avgFillPrice=77.929, filledQuantity=10, totalQuantity=10, realizedPnl=0, commission=2.98, reason=, order_type=LMT, outside_rth=True | |
| 02-18 22:50:44 | INFO | order | tiger_client | Order 42277739866882048 available attributes: ['account', 'action', 'active', 'adjust_limit', 'algo_params', 'algo_strategy', 'attr_desc', 'attr_list', 'aux_price', 'avg_fill_price', 'can_modify', 'charges', 'combo_type', 'combo_type_desc', 'commission', 'contract', 'contract_legs', 'discount', 'expire_time', 'external_id', 'filled', 'filled_cash_amount', 'filled_scale', 'gst', 'id', 'is_open', 'is_partially_filled', 'latest_price', 'limit_price', 'liquidation', 'order_id', 'order_legs', 'order_time', 'order_type', 'orders', 'outside_rth', 'parent_id', 'percent_offset', 'quantity', 'quantity_scale', 'realized_pnl', 'reason', 'refund_cash_amount', 'remaining', 'secret_key', 'source', 'status', 'sub_ids', 'time_in_force', 'to_dict', 'total_cash_amount', 'trade_time', 'trading_session_type', 'trail_stop_price', 'trailing_percent', 'update_time', 'user_mark'] | |
| 02-18 22:50:44 | INFO | order | tiger_client | Getting filled orders from 2026-02-17 to 2026-02-18 | |
| 02-18 22:50:44 | WARN | trailing_stop | trailing_stop_scheduler | ⚠️ Qty mismatch for NFLX (real): DB trailing_stop=1.0, Tiger=4 | |
| 02-18 22:50:44 | INFO | sync | trailing_stop_engine | 📊 Syncing avg cost for NFLX: 77.93 -> 78.23 | |
| 02-18 22:50:44 | INFO | position | trailing_stop_engine | 📊 Syncing quantity for NFLX: 1.0 -> 4 | |
| 02-18 22:50:44 | INFO | sync | trailing_stop_engine | 📊 Syncing avg cost for NFLX: 77.94 -> 77.95 | |
| 02-18 22:50:44 | INFO | trailing_stop | trailing_stop_scheduler | 🔄 Full sync: Processing 2 active trailing stop positions (API verification) | |
| 02-18 22:50:44 | INFO | position | tiger_client | Position: NFLX, Qty: 10, Cost: 78.227 | |
| 02-18 22:50:44 | INFO | order | tiger_client | Retrieved 0 filled orders | |
| 02-18 22:50:43 | INFO | position | tiger_client | Getting positions for symbol: all | |
| 02-18 22:50:43 | INFO | order | tiger_client | Getting filled orders from 2026-02-17 to 2026-02-18 | |
| 02-18 22:50:43 | INFO | position | tiger_client | Position: NFLX, Qty: 4, Cost: 77.9465 | |
| 02-18 22:50:43 | INFO | position | tiger_client | Getting positions for symbol: all | |
| 02-18 22:50:43 | INFO | order | tiger_client | Retrieved 2 filled orders | |
| 02-18 22:50:43 | INFO | order | tiger_client | Getting filled orders from 2026-02-17 to 2026-02-18 | |
| 02-18 22:50:43 | WARN | trailing_stop | trailing_stop_scheduler | ⚠️ Qty mismatch for NFLX (real): DB trailing_stop=1.0, Tiger=4 | |
| 02-18 22:50:43 | INFO | sync | trailing_stop_engine | 📊 Syncing avg cost for NFLX: 77.93 -> 78.23 | |
| 02-18 22:50:43 | INFO | position | trailing_stop_engine | 📊 Syncing quantity for NFLX: 1.0 -> 4 | |
| 02-18 22:50:43 | INFO | sync | trailing_stop_engine | 📊 Syncing avg cost for NFLX: 77.94 -> 77.95 | |
| 02-18 22:50:43 | INFO | trailing_stop | trailing_stop_scheduler | 🔄 Full sync: Processing 2 active trailing stop positions (API verification) | |
| 02-18 22:50:43 | INFO | position | tiger_client | Position: NFLX, Qty: 10, Cost: 78.227 | |
| 02-18 22:50:42 | INFO | position | tiger_client | Getting positions for symbol: all | |
| 02-18 22:50:42 | INFO | position | tiger_client | Position: NFLX, Qty: 4, Cost: 77.9465 | |
| 02-18 22:50:42 | INFO | position | tiger_client | Getting positions for symbol: all | |
| 02-18 22:49:47 | INFO | position | holdings_sync | Holdings sync [paper]: 0 new, 1 updated, 0 removed, 1 total | |
| 02-18 22:49:47 | INFO | position | tiger_client | Position: NFLX, Qty: 10, Cost: 78.227 | |
| 02-18 22:49:45 | INFO | position | tiger_client | Getting positions for symbol: all | |
| 02-18 22:49:45 | INFO | position | holdings_sync | Holdings sync [real]: 0 new, 1 updated, 0 removed, 1 total | |
| 02-18 22:49:45 | INFO | position | tiger_client | Position: NFLX, Qty: 4, Cost: 77.9465 | |
| 02-18 22:49:45 | INFO | position | tiger_client | Getting positions for symbol: all | |
| 02-18 22:49:42 | INFO | position | holdings_sync | Holdings sync [paper]: 0 new, 1 updated, 0 removed, 1 total | |
| 02-18 22:49:42 | INFO | position | tiger_client | Position: NFLX, Qty: 10, Cost: 78.227 | |
| 02-18 22:49:42 | INFO | position | tiger_client | Getting positions for symbol: all | |
| 02-18 22:49:41 | INFO | position | holdings_sync | Holdings sync [real]: 0 new, 1 updated, 0 removed, 1 total | |
| 02-18 22:49:41 | INFO | position | tiger_client | Position: NFLX, Qty: 4, Cost: 77.9465 | |
| 02-18 22:49:41 | INFO | position | tiger_client | Getting positions for symbol: all | |
| 02-18 22:49:17 | ERROR | error | tiger_client | Error getting bars for AMAT: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute) | |
| 02-18 22:49:17 | ERROR | error | tiger_client | Error getting bars for ATOM: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute) | |
| 02-18 22:49:17 | ERROR | error | tiger_client | Error getting bars for REMX: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute) | |
| 02-18 22:49:17 | ERROR | error | tiger_client | Error getting bars for EQIX: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute) | |
| 02-18 22:49:17 | ERROR | error | tiger_client | Error getting bars for CIEN: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute) | |
| 02-18 22:49:17 | ERROR | error | tiger_client | Error getting bars for ANET: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute) | |
| 02-18 22:49:16 | ERROR | error | MSFT | tiger_client | Error getting bars for MSFT: code=4 msg=5:rate limit error(current limiting interface:kline, up to 60 times per minute) |