Error
(psycopg2.errors.SyntaxError) syntax error at or near ":"
LINE 8: ...Output, 20,000 mAh, Simultaneous - Now 99% OFF!', :txt_trans...
^
[SQL:
INSERT INTO content_tickeritem (
ticker_type, text, text_translations, prefix, prefix_translations,
target_url, display_order, is_active,
is_auto_generated, source_product_id, source_signal, expired_at,
created_at, updated_at
) VALUES (
%(type)s, %(text)s, :txt_trans::jsonb, %(prefix)s, :pfx_trans::jsonb,
%(url)s, %(ord)s, true,
true, %(product_id)s, %(signal)s,
now() + %(expiry)s * interval '1 hour',
now(), now()
)
]
[parameters: {'type': 'drop', 'text': 'Mobile Battery, Large Capacity, Supports 22.5 W Output, 20,000 mAh, Simultaneous - Now 99% OFF!', 'prefix': '$32781 DROP', 'url': '/products/mobile-battery-large-capacity-supports-225-w-output-20000-mah-simultaneous-charging-b0gc5hpvj5', 'ord': 1, 'product_id': 15246, 'signal': 'price_drop', 'expiry': 24}]
(Background on this error at: https://sqlalche.me/e/20/f405)
Log Output
19:21:41 | INFO | [HomePromo] 完成: 删除=6, 创建=6
19:21:42 | DEBUG | 序列修复: content_discoveritem_id_seq
19:21:42 | DEBUG | 序列修复: content_discoverscene_id_seq
19:21:42 | INFO | 任务 [首页促销] 执行成功, 耗时 7.4s
19:21:42 | DEBUG | 序列修复: content_tickeritem_id_seq
19:21:43 | ERROR | 任务 [Discover场景] 执行失败: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "content_discoveritem_pkey"
DETAIL: Key (id)=(1862) already exists.
[SQL:
INSERT INTO content_discoveritem
(scene_id, product_id, badge_translations, decision_weights, display_order)
VALUES (%(sid)s, %(pid)s, CAST(%(badge)s AS jsonb), '{}'::jsonb, %(ord)s)
]
[parameters: {'sid': 23, 'pid': 11516, 'badge': '{}', 'ord': 1}]
(Background on this error at: https://sqlalche.me/e/20/gkpj)
19:21:43 | DEBUG | 序列修复: content_discoveritem_id_seq
19:21:44 | DEBUG | 序列修复: content_discoverhotspot_id_seq
19:21:44 | ERROR | 任务 [走马灯通知] 执行失败: (psycopg2.errors.SyntaxError) syntax error at or near ":"
LINE 8: ...Output, 20,000 mAh, Simultaneous - Now 99% OFF!', :txt_trans...
^
[SQL:
INSERT INTO content_tickeritem (
ticker_type, text, text_translations, prefix, prefix_translations,
target_url, display_order, is_active,
is_auto_generated, source_product_id, source_signal, expired_at,
created_at, updated_at
) VALUES (
%(type)s, %(text)s, :txt_trans::jsonb, %(prefix)s, :pfx_trans::jsonb,
%(url)s, %(ord)s, true,
true, %(product_id)s, %(signal)s,
now() + %(expiry)s * interval '1 hour',
now(), now()
)
]
[parameters: {'type': 'drop', 'text': 'Mobile Battery, Large Capacity, Supports 22.5 W Output, 20,000 mAh, Simultaneous - Now 99% OFF!', 'prefix': '$32781 DROP', 'url': '/products/mobile-battery-large-capacity-supports-225-w-output-20000-mah-simultaneous-charging-b0gc5hpvj5', 'ord': 1, 'product_id': 15246, 'signal': 'price_drop', 'expiry': 24}]
(Background on this error at: https://sqlalche.me/e/20/f405)