Код: Выделить всё
?Debug : Oct 07 07:10:27 DBCtx: DB transaction begin
?Debug : Oct 07 07:10:27 DBCtx: <173772184> SQL query: INSERT INTO discount_transactions_all(account_id,discount,discount_with_tax,service_type,discount_date,charge_type) VALUES('0','0','0','3','1317957027','19')
?Debug : Oct 07 07:10:27 DBCtx: <173772184> MySQL query failed:<Duplicate entry '2147483647' for key 'PRIMARY'> Trying to reconnect: 0
?Debug : Oct 07 07:10:29 DBCtx: <173772184> SQL query: INSERT INTO discount_transactions_iptraffic_all(id,account_id,discount,discount_with_tax,slink_id,discount_date,discount_date_hour,discount_date_day,discount_date_month,t_class,bytes) VALUES('2147483647','0','0','0','0','1317957027','1317956400','1317931200','1317412800','0','30316')
?Debug : Oct 07 07:10:29 DBCtx: <173772184> MySQL query failed:<Duplicate entry '2147483647' for key 'PRIMARY'> Trying to reconnect: 0
?Debug : Oct 07 07:10:31 DBCtx: <173772184> MySQL query failed:<Duplicate entry '2147483647' for key 'PRIMARY'> Trying to reconnect: 1
?Debug : Oct 07 07:10:33 DBCtx: <173772184> MySQL query failed:<Duplicate entry '2147483647' for key 'PRIMARY'> Trying to reconnect: 2
?Debug : Oct 07 07:10:35 DBCtx: <173772184> MySQL query failed:<Duplicate entry '2147483647' for key 'PRIMARY'> Trying to reconnect: 3
?Debug : Oct 07 07:10:37 DBCtx: <173772184> MySQL query failed:<Duplicate entry '2147483647' for key 'PRIMARY'> Trying to reconnect: 4
?Debug : Oct 07 07:10:38 FW@MikroTik: ping reply received
ERROR : Oct 07 07:10:39 DBCtx: <173772184> MySQL query failed:
ERROR : Oct 07 07:10:39 DBASQLError: MySQL query failed:
?Trace : Oct 07 07:10:39 trace: Obtained 14 stack frames.
?Trace : Oct 07 07:10:39 trace: /netup/utm5/bin/utm5_core(_Z15print_backtracev+0x22) [0x8458ae2]
?Trace : Oct 07 07:10:39 trace: /netup/utm5/bin/utm5_core(_ZN3UTM8DBAErrorC2ERKSsS2_b+0x6b) [0x822fa5b]
?Trace : Oct 07 07:10:39 trace: /netup/utm5/bin/utm5_core(_ZN3UTM11DBASQLErrorC1ESs+0x4f) [0x822fd0f]
?Trace : Oct 07 07:10:39 trace: /netup/utm5/bin/utm5_core(_ZN3UTM12DBACtx_mysql11_sql_insertERKSsRNS_12sql_result_tE+0x164) [0x843b024]
?Trace : Oct 07 07:10:39 trace: /netup/utm5/bin/utm5_core(_ZN3UTM6DBACtx10sql_insertERKSsRNS_12sql_result_tE+0xa7) [0x823a257]
?Trace : Oct 07 07:10:39 trace: /netup/utm5/bin/utm5_core(_ZN3UTM8DBAClass10sql_insertERKSsRNS_12sql_result_tE+0x27) [0x823a317]
?Trace : Oct 07 07:10:39 trace: /netup/utm5/bin/utm5_core(_ZN3UTM8DBAccess10raw_sql_iuEPKcPNS_12sql_result_tE+0x49) [0x823a379]
?Trace : Oct 07 07:10:39 trace: /netup/utm5/bin/utm5_core(_ZN3UTM8DBAccess29__register_unassigned_trafficEPNS_23discount_info_iptrafficE+0x320) [0x82c3390]
?Trace : Oct 07 07:10:39 trace: /netup/utm5/bin/utm5_core(_ZN3UTM8DBAccess23__discount_from_accountEPNS_23discount_info_iptrafficEb+0x28) [0x82c5978]
?Trace : Oct 07 07:10:39 trace: /netup/utm5/bin/utm5_core(_ZN3UTM10BusClassif10__blm_sendERKNS0_9cache_hdrERKNS0_10cache_infoE+0x8c) [0x83f4b7c]
?Trace : Oct 07 07:10:39 trace: /netup/utm5/bin/utm5_core(_ZN3UTM10BusClassif23process_expired_recordsEv+0x130) [0x83f4ce0]
?Trace : Oct 07 07:10:39 trace: /netup/utm5/bin/utm5_core(_ZN3UTM10BusClassif16periodic_cleanupEPv+0x50) [0x83f5ba0]
?Trace : Oct 07 07:10:39 trace: /lib/libpthread.so.0 [0xca9832]
?Trace : Oct 07 07:10:39 trace: /lib/libc.so.6(clone+0x5e) [0xbe945e]
ERROR : Oct 07 07:10:39 DBCtx: Exception while doing SQL insert/update !
?Debug : Oct 07 07:10:39 DBCtx: <173772184> SQL query: COMMIT
?Debug : Oct 07 07:10:39 DBCtx: DB transaction commit
?Debug : Oct 07 07:10:39 DBA:Ctx: Pushing back free context (system=1)
-Stats : Oct 07 07:10:39 UTM5 DBA: Stats: Uptime: 00:00:12. Events: 0; Errors: 0
?Debug : Oct 07 07:10:39 BusClassif: aggregation interval reached for slink <448> ip <1307082874> tclass <10>
?Debug : Oct 07 07:10:39 UTM5 DBA: DBAccess instance created
?Debug : Oct 07 07:10:39 DBA:Ctx: Looking for free context (system=1)
?Debug : Oct 07 07:10:39 DBCtx: <173746344> SQL query: BEGIN
?Debug : Oct 07 07:10:39 DBCtx: DB transaction begin
?Debug : Oct 07 07:10:39 TransactionQueueManager: pushing transaction <0xb570b878> into queue <1> (default)
?Debug : Oct 07 07:10:39 TransactionHandlerImpl: push: transaction ptr <0xb570b878> (size 1, Events [ 95 ])
?Debug : Oct 07 07:10:39 DBCtx: <173746344> SQL SELECT query: SELECT discounted,qnt,downed_as_prepaid FROM downloaded WHERE is_deleted=0 AND downloaded_id='112' AND tclass_id='10'
?Debug : Oct 07 07:10:39 TransactionHandlerImpl: incoming transaction ptr <0xb570b878>, outgoing transaction ptr <0x0a836b18>
?Debug : Oct 07 07:10:39 DBA:Ctx: Looking for free context (system=1)
?Debug : Oct 07 07:10:39 PluginManagerImpl: Got DynaShapePlugin plugin for event EventProcessShaping/95
?Debug : Oct 07 07:10:39 DBCtx: <173746344> SQL query: UPDATE downloaded SET qnt='7597854344', discounted='0', downed_as_prepaid='0' WHERE downloaded_id='112' AND tclass_id='10'
?Debug : Oct 07 07:10:39 DTAgg: update dtagg_iptraffic for slink_id 448
?Debug : Oct 07 07:10:39 DBCtx: <173746344> SQL query: UPDATE dtagg_iptraffic SET discounted='0.000000', discounted_without_tax='0.000000', bytes='7597854344' WHERE id='5878'
?Debug : Oct 07 07:10:39 UTM5 DBA: Charge:0.000000 p.u. for link:448 account 86
?Debug : Oct 07 07:10:39 DBCtx: <173746344> SQL query: UPDATE accounts SET balance='40' WHERE id = '86'
?Debug : Oct 07 07:10:39 DBCtx: <173746344> SQL query: INSERT INTO discount_transactions_all(account_id,incoming_rest,outgoing_rest,discount,discount_with_tax,service_id,service_type,slink_id,discount_date,charge_type,discount_period_id) VALUES('86','40','40','0','0','30','3','448','1317957039','3','38')
?Debug : Oct 07 07:10:39 DBCtx: <173746344> MySQL query failed:<Duplicate entry '2147483647' for key 'PRIMARY'> Trying to reconnect: 0
?Debug : Oct 07 07:10:41 DBCtx: <173746344> MySQL query failed:<Duplicate entry '2147483647' for key 'PRIMARY'> Trying to reconnect: 1
?Debug : Oct 07 07:10:43 DBCtx: <173746344> MySQL query failed:<Duplicate entry '2147483647' for key 'PRIMARY'> Trying to reconnect: 2
?Debug : Oct 07 07:10:45 DBCtx: <173746344> MySQL query failed:<Duplicate entry '2147483647' for key 'PRIMARY'> Trying to reconnect: 3
?Debug : Oct 07 07:10:47 DBCtx: <173746344> MySQL query failed:<Duplicate entry '2147483647' for key 'PRIMARY'> Trying to reconnect: 4
ERROR : Oct 07 07:10:49 DBCtx: <173746344> MySQL query failed:
ERROR : Oct 07 07:10:49 DBASQLError: MySQL query failed:
?Trace : Oct 07 07:10:49 trace: Obtained 14 stack frames.
?Trace : Oct 07 07:10:49 trace: /netup/utm5/bin/utm5_core(_Z15print_backtracev+0x22) [0x8458ae2]
?Trace : Oct 07 07:10:49 trace: /netup/utm5/bin/utm5_core(_ZN3UTM8DBAErrorC2ERKSsS2_b+0x6b) [0x822fa5b]
?Trace : Oct 07 07:10:49 trace: /netup/utm5/bin/utm5_core(_ZN3UTM11DBASQLErrorC1ESs+0x4f) [0x822fd0f]
?Trace : Oct 07 07:10:49 trace: /netup/utm5/bin/utm5_core(_ZN3UTM12DBACtx_mysql11_sql_insertERKSsRNS_12sql_result_tE+0x164) [0x843b024]
?Trace : Oct 07 07:10:49 trace: /netup/utm5/bin/utm5_core(_ZN3UTM6DBACtx10sql_insertERKSsRNS_12sql_result_tE+0xa7) [0x823a257]
?Trace : Oct 07 07:10:49 trace: /netup/utm5/bin/utm5_core(_ZN3UTM8DBAClass10sql_insertERKSsRNS_12sql_result_tE+0x27) [0x823a317]
?Trace : Oct 07 07:10:49 trace: /netup/utm5/bin/utm5_core(_ZN3UTM8DBAccess10raw_sql_iuEPKcPNS_12sql_result_tE+0x49) [0x823a379]
?Trace : Oct 07 07:10:49 trace: /netup/utm5/bin/utm5_core(_ZN3UTM8DBAccess8__chargeEPNS_11charge_infoE+0x3c4) [0x82c4214]
?Trace : Oct 07 07:10:49 trace: /netup/utm5/bin/utm5_core(_ZN3UTM8DBAccess23__discount_from_accountEPNS_23discount_info_iptrafficEb+0x156) [0x82c5aa6]
?Trace : Oct 07 07:10:49 trace: /netup/utm5/bin/utm5_core(_ZN3UTM10BusClassif10__blm_sendERKNS0_9cache_hdrERKNS0_10cache_infoE+0x8c) [0x83f4b7c]
?Trace : Oct 07 07:10:49 trace: /netup/utm5/bin/utm5_core(_ZN3UTM10BusClassif23process_expired_recordsEv+0x130) [0x83f4ce0]
?Trace : Oct 07 07:10:49 trace: /netup/utm5/bin/utm5_core(_ZN3UTM10BusClassif16periodic_cleanupEPv+0x50) [0x83f5ba0]
?Trace : Oct 07 07:10:49 trace: /lib/libpthread.so.0 [0xca9832]
?Trace : Oct 07 07:10:49 trace: /lib/libc.so.6(clone+0x5e) [0xbe945e]
ERROR : Oct 07 07:10:49 DBCtx: Exception while doing SQL insert/update !
?Debug : Oct 07 07:10:49 UTM5 DBA: Checking for rehash: flags 3, balance 40.000 (old 40.000), credit 750.000
?Debug : Oct 07 07:10:49 DBAGiga: Rehash: Target: 10; Action: 1; Ptr: b700fe98
?Debug : Oct 07 07:10:49 Radius: Account '86': 40.000/750.000 send...
?Debug : Oct 07 07:10:49 BusLogic: currently blm with code 37 executing
?Debug : Oct 07 07:10:49 BusLogic: BLM(37) pushed (comment: ruh block)
?Debug : Oct 07 07:10:49 DBCtx: <173746344> SQL query: INSERT INTO discount_transactions_iptraffic_all(id,account_id,discount,discount_with_tax,service_id,slink_id,discount_date,discount_date_hour,discount_date_day,discount_date_month,t_class,base_cost,ipid,bytes,discount_period_id) VALUES('0','86','0','0','30','448','1317957039','1317956400','1317931200','1317412800','10','0','1307082874','67347','38')
?Debug : Oct 07 07:10:49 DBCtx: <173746344> MySQL query failed:<Duplicate entry '0' for key 'PRIMARY'> Trying to reconnect: 0
?Debug : Oct 07 07:10:51 DBCtx: <173746344> MySQL query failed:<Duplicate entry '0' for key 'PRIMARY'> Trying to reconnect: 1
?Debug : Oct 07 07:10:53 DBCtx: <173746344> MySQL query failed:<Duplicate entry '0' for key 'PRIMARY'> Trying to reconnect: 2
?Debug : Oct 07 07:10:55 DBCtx: <173746344> MySQL query failed:<Duplicate entry '0' for key 'PRIMARY'> Trying to reconnect: 3
?Debug : Oct 07 07:10:57 DBCtx: <173746344> MySQL query failed:<Duplicate entry '0' for key 'PRIMARY'> Trying to reconnect: 4
ERROR : Oct 07 07:10:59 DBCtx: <173746344> MySQL query failed:
ERROR : Oct 07 07:10:59 DBASQLError: MySQL query failed:
?Trace : Oct 07 07:10:59 trace: Obtained 13 stack frames.
?Trace : Oct 07 07:10:59 trace: /netup/utm5/bin/utm5_core(_Z15print_backtracev+0x22) [0x8458ae2]
?Trace : Oct 07 07:10:59 trace: /netup/utm5/bin/utm5_core(_ZN3UTM8DBAErrorC2ERKSsS2_b+0x6b) [0x822fa5b]
?Trace : Oct 07 07:10:59 trace: /netup/utm5/bin/utm5_core(_ZN3UTM11DBASQLErrorC1ESs+0x4f) [0x822fd0f]
?Trace : Oct 07 07:10:59 trace: /netup/utm5/bin/utm5_core(_ZN3UTM12DBACtx_mysql11_sql_insertERKSsRNS_12sql_result_tE+0x164) [0x843b024]
?Trace : Oct 07 07:10:59 trace: /netup/utm5/bin/utm5_core(_ZN3UTM6DBACtx10sql_insertERKSsRNS_12sql_result_tE+0xa7) [0x823a257]
?Trace : Oct 07 07:10:59 trace: /netup/utm5/bin/utm5_core(_ZN3UTM8DBAClass10sql_insertERKSsRNS_12sql_result_tE+0x27) [0x823a317]
?Trace : Oct 07 07:10:59 trace: /netup/utm5/bin/utm5_core(_ZN3UTM8DBAccess10raw_sql_iuEPKcPNS_12sql_result_tE+0x49) [0x823a379]
?Trace : Oct 07 07:10:59 trace: /netup/utm5/bin/utm5_core(_ZN3UTM8DBAccess23__discount_from_accountEPNS_23discount_info_iptrafficEb+0x47b) [0x82c5dcb]
?Trace : Oct 07 07:10:59 trace: /netup/utm5/bin/utm5_core(_ZN3UTM10BusClassif10__blm_sendERKNS0_9cache_hdrERKNS0_10cache_infoE+0x8c) [0x83f4b7c]
?Trace : Oct 07 07:10:59 trace: /netup/utm5/bin/utm5_core(_ZN3UTM10BusClassif23process_expired_recordsEv+0x130) [0x83f4ce0]
?Trace : Oct 07 07:10:59 trace: /netup/utm5/bin/utm5_core(_ZN3UTM10BusClassif16periodic_cleanupEPv+0x50) [0x83f5ba0]
?Trace : Oct 07 07:10:59 trace: /lib/libpthread.so.0 [0xca9832]
?Trace : Oct 07 07:10:59 trace: /lib/libc.so.6(clone+0x5e) [0xbe945e]
ERROR : Oct 07 07:10:59 DBCtx: Exception while doing SQL insert/update !