Дублирование данных при формировании запросов абонентов.

[Shir]

Здравствуйте. Помогите пожалуйста разобраться с такой проблемой.
При формировании отчета по трафику дублируются данные. Дебуга выдает какой то двойной запрос.

?Debug : Nov 17 10:14:13 29168100 RPCConn[SSL]<XXX@XXX>: Call: 0x3009 (rpcf_traffic_report_ex)
?Debug : Nov 17 10:14:13 29168100 RPCConn[SSL]<XXX@XXX>: Real Call: 0x3009 (rpcf_traffic_report_ex)
?Debug : Nov 17 10:14:13 29168100 UTM5 DBA: DBAccess instance created
?Debug : Nov 17 10:14:13 29168100 DBA:Ctx: Looking for free context (system=0)
?Debug : Nov 17 10:14:13 29168100 RPCServer@0.0.0.0: rpcf_traffic_report_ex: type=<0>, uid=<6>, aid=<0>, gid=<0>, apid=<0>, t_start=<1320091200>, t_end=<1322683200>
?Debug : Nov 17 10:14:13 29168100 DBCtx: <684518400> SQL SELECT query: SELECT value FROM utm5_settings WHERE variable='bytes_in_kbyte'
?Debug : Nov 17 10:14:13 29168100 RPCServer@0.0.0.0: rpcf_traffic_report_ex: accounts size=<2>
?Debug : Nov 17 10:14:13 29168100 RPCServer@0.0.0.0: rpcf_traffic_report_ex: calling dba.reports_account_traffic_ex for account_id <6>
?Debug : Nov 17 10:14:13 29168100 DBCtx: <684518400> SQL SELECT query: SELECT archive_id,start_date,end_date FROM archives ORDER BY id
?Debug : Nov 17 10:14:13 29168100 DBCtx: <684518400> SQL SELECT query: SELECT account_id, slink_id, t_class, SUM(bytes), base_cost, SUM(discount),
SUM(discount_with_tax) FROM discount_transactions_iptraffic_all WHERE discount_date>='1320091200' AND discount_date <='1322683200' AND account_id='6'
GROUP BY t_class,base_cost,account_id,slink_id ORDER BY account_id, t_class, base_cost
?Debug : Nov 17 10:14:13 29168100 RPCServer@0.0.0.0: rpcf_traffic_report_ex: data size: <2>
?Debug : Nov 17 10:14:13 29168100 RPCServer@0.0.0.0: rpcf_traffic_report_ex: calling dba.reports_account_traffic_ex for account_id <6>
?Debug : Nov 17 10:14:13 29168100 DBCtx: <684518400> SQL SELECT query: SELECT archive_id,start_date,end_date FROM archives ORDER BY id
?Debug : Nov 17 10:14:13 29168100 DBCtx: <684518400> SQL SELECT query: SELECT account_id, slink_id, t_class, SUM(bytes), base_cost, SUM(discount),
SUM(discount_with_tax) FROM discount_transactions_iptraffic_all WHERE discount_date>='1320091200' AND discount_date <='1322683200' AND account_id='6'
GROUP BY t_class,base_cost,account_id,slink_id ORDER BY account_id, t_class, base_cost
?Debug : Nov 17 10:14:13 29168100 RPCServer@0.0.0.0: rpcf_traffic_report_ex: data size: <2>
?Debug : Nov 17 10:14:13 29168100 DBA:Ctx: Pushing back free context (system=0)
-Stats : Nov 17 10:14:13 29168100 UTM5 DBA: Stats: Uptime: 00:00:00. Events: 0; Errors: 0
?Debug : Nov 17 10:14:13 29168100 RPCConn[SSL]<XXX@XXX>: Call 0x3009 (rpcf_traffic_report_ex) finished...

Куда капать дальше не знаем.

[TiRider]

что в verificator.log? А то вот эта строчка явным образом говорить про SQL.

Код: Выделить всё

?Debug &#58; Nov 17 10&#58;14&#58;13 29168100 DBCtx&#58; <684518400> SQL SELECT query&#58; SELECT account_id, slink_id, t_class, SUM&#40;bytes&#41;, base_cost, SUM&#40;discount&#41;, 
SUM&#40;discount_with_tax&#41; FROM discount_transactions_iptraffic_all WHERE discount_date>='1320091200' AND discount_date <='1322683200' AND account_id='6' 
GROUP BY t_class,base_cost,account_id,slink_id ORDER BY account_id, t_class, base_cost

[Shir]

Файл verificator.log в папке /netup/utm5/log не обнаружил. Сделал вывод, что ошибок в базе нет.

Визуально эта ошибка выглядит так:
6 dom_knigi Incoming (10) 550.066591
6 dom_knigi Outgoing (20) 52.695241
6 dom_knigi Incoming (10) 550.066591
6 dom_knigi Outgoing (20) 52.695241
Суммарно Incoming (10) 1100.133182
Суммарно Outgoing (20) 105.390482
Итого 1205.5236639999998

При выполнении аналогичных действий на тестовом стенде запрос не дублируется.
?Debug : Nov 17 11:29:18 RPCConn[SSL]<YYY@YYY>: Call: 0x3009 (rpcf_traffic_report_ex)
?Debug : Nov 17 11:29:18 RPCConn[SSL]<YYY@YYY>: Real Call: 0x3009 (rpcf_traffic_report_ex)
?Debug : Nov 17 11:29:18 UTM5 DBA: DBAccess instance created
?Debug : Nov 17 11:29:18 DBA:Ctx: Looking for free context (system=0)
?Debug : Nov 17 11:29:18 RPCServer@0.0.0.0: rpcf_traffic_report_ex: type=<0>, uid=<6>, aid=<0>, gid=<0>, apid=<0>, t_start=<1320094800>, t_end=<1322686800>
?Debug : Nov 17 11:29:18 DBCtx: <14015032> SQL SELECT query: SELECT value FROM utm5_settings WHERE variable='bytes_in_kbyte'
?Debug : Nov 17 11:29:18 RPCServer@0.0.0.0: rpcf_traffic_report_ex: accounts size=<1>
?Debug : Nov 17 11:29:18 RPCServer@0.0.0.0: rpcf_traffic_report_ex: calling dba.reports_account_traffic_ex for account_id <6>
?Debug : Nov 17 11:29:18 DBCtx: <14015032> SQL SELECT query: SELECT archive_id,start_date,end_date FROM archives ORDER BY id
?Debug : Nov 17 11:29:18 DBCtx: <14015032> SQL SELECT query: SELECT account_id, slink_id, t_class, SUM(bytes), base_cost, SUM(discount), SUM(discount_with_tax) FROM discount_transactions_iptraffic_all WHERE discount_date>='1320094800' AND discount_date <='1322686800' AND account_id='6' GROUP BY t_class,base_cost,account_id,slink_id ORDER BY account_id, t_class, base_cost
?Debug : Nov 17 11:29:18 RPCServer@0.0.0.0: rpcf_traffic_report_ex: data size: <0>
?Debug : Nov 17 11:29:18 DBA:Ctx: Pushing back free context (system=0)
-Stats : Nov 17 11:29:18 UTM5 DBA: Stats: Uptime: 00:00:00. Events: 0; Errors: 0
?Debug : Nov 17 11:29:18 RPCConn[SSL]<YYY@YYY>: Call 0x3009 (rpcf_traffic_report_ex) finished...