Завожу нового пользователя сегодня в середине дня.
Выбираю тариф.
Выбираю ему период номер 10 к примеру, начинающийся с 00:00:00 01-Sept-2005 длиной в месяц.
Прилинковываю айпи.
Результат - все замечательно но в расчетных периодах появляется еще один с номером 11 , началом от момента нажатия на кнопку ПРИМЕНИТЬ и диной в месяц.
При этом в свойствах пользователя четко прописан период с номером 10, начинающийся с 00:00:00 01-Sept-2005 длиной в месяц.
Приходится ручками указывать что период 11 заканчивается например с 16:00:00 01-Sept-2005 чтобы он удалился...
С чего бы такое размножение при заведении каждого нового юзверя?
Тоже самое происходит если от юзверя отлинковать тарифный план.
Зачем???
Плодятся периоды - зачем?
Re: Плодятся периоды - зачем?
Maximas писал(а):Завожу нового пользователя сегодня в середине дня.
Выбираю тариф.
Выбираю ему период номер 10 к примеру, начинающийся с 00:00:00 01-Sept-2005 длиной в месяц.
Прилинковываю айпи.
Результат - все замечательно но в расчетных периодах появляется еще один с номером 11 , началом от момента нажатия на кнопку ПРИМЕНИТЬ и диной в месяц.
При этом в свойствах пользователя четко прописан период с номером 10, начинающийся с 00:00:00 01-Sept-2005 длиной в месяц.
Приходится ручками указывать что период 11 заканчивается например с 16:00:00 01-Sept-2005 чтобы он удалился...
С чего бы такое размножение при заведении каждого нового юзверя?
Тоже самое происходит если от юзверя отлинковать тарифный план.
Зачем???
Короче открываем пользователя, заходим в раздел тарифные планы, нажимаем УДАЛИТЬ.
Далее в расчетных периодах появляется еще один и начинается он с текущей даты.
?Debug : Sep 04 18:03:33 RPCConn[SSL]<init@172.19.33.100>: Call: 0x2035
?Debug : Sep 04 18:03:33 RPCConn[SSL]<init@172.19.33.100>: Call finished...
?Debug : Sep 04 18:03:33 RPCConn[SSL]<init@172.19.33.100>: Call: 0x6002
?Debug : Sep 04 18:03:33 DBCtx: SQL SELECT query: SELECT id,bic,name,city,kschet FROM banks ORDER BY id
?Debug : Sep 04 18:03:33 RPCConn[SSL]<init@172.19.33.100>: Call finished...
?Debug : Sep 04 18:03:33 RPCConn[SSL]<init@172.19.33.100>: Call: 0x7030
?Debug : Sep 04 18:03:33 DBCtx: SQL SELECT query: SELECT act_id FROM acts_templates WHERE is_old='0' AND def='1' AND doc_type
='2'
?Debug : Sep 04 18:03:33 DBCtx: SQL SELECT query: SELECT act_text, landscape FROM acts_templates WHERE is_old='0' AND act_id=
'2'
?Debug : Sep 04 18:03:33 DBCtx: SQL SELECT query: SELECT login,password,basic_account,full_name,juridical_address,actual_addr
ess,tax_number,kpp_number,bank_account,email,passport,bank_id FROM users WHERE id='2'
?Debug : Sep 04 18:03:33 DBCtx: SQL SELECT query: SELECT bic,name,city,kschet FROM banks WHERE id='0'
?Debug : Sep 04 18:03:33 DBCtx: SQL SELECT query: SELECT name,ur_adress,act_adress,inn,kpp,bank_id,account,fio_headman,fio_bo
okeeper,fio_headman_sh,fio_bookeeper_sh,name_sh FROM supplier_info WHERE id='1'
?Debug : Sep 04 18:03:33 DBCtx: SQL SELECT query: SELECT bic,name,city,kschet FROM banks WHERE id='1'
?Debug : Sep 04 18:03:33 RPCConn[SSL]<init@172.19.33.100>: Call finished...
?Debug : Sep 04 18:03:33 RPCConn[SSL]<init@172.19.33.100>: Call: 0x2550
?Debug : Sep 04 18:03:33 RPCConn[SSL]<init@172.19.33.100>: Call finished...
?Debug : Sep 04 18:03:33 RPCConn[SSL]<init@172.19.33.100>: Call: 0x2006
?Debug : Sep 04 18:03:33 DBCtx: SQL SELECT query: SELECT login, password, basic_account
, is_blocked, create_date, last_change_date, who_create, who_c
hange, is_juridical, full_name, juridical_address, actual_address,
work_telephone, home_telephone, mobile_telephone, web_page, icq_n
umber, tax_number, kpp_number, bank_id, bank_account, comments,
discount_period_id, email, house_id, flat_number, entrance,
floor, passport, personal_manager, connect_date, is_send_invoice,
advance_payment FROM users WHERE id='2' AND is_deleted=0
?Debug : Sep 04 18:03:33 DBCtx: SQL SELECT query: SELECT group_id FROM users_groups_link WHERE user_id='2'
?Debug : Sep 04 18:03:33 RPCConn[SSL]<init@172.19.33.100>: Call finished...
?Debug : Sep 04 18:03:33 RPCConn[SSL]<init@172.19.33.100>: Call: 0x2030
?Debug : Sep 04 18:03:33 RPCConn[SSL]<init@172.19.33.100>: Call finished...
?Debug : Sep 04 18:03:33 RPCConn[SSL]<init@172.19.33.100>: Call: 0x2553
?Debug : Sep 04 18:03:33 RPCConn[SSL]<init@172.19.33.100>: Call finished...
Info : Sep 04 18:03:34 RPCServer@0.0.0.0: Client connecting: 172.19.33.100:3470
Info : Sep 04 18:03:34 RPCConn: Connection from: 172.19.33.100:3470
Info : Sep 04 18:03:34 RPCConn: Card user <init@172.19.33.100> is connecting
?Debug : Sep 04 18:03:34 UTM5 DBA: Group: -1 from 1
Info : Sep 04 18:03:34 RPCConn[SSL]<init@172.19.33.100>: Access granted to [SSL]<init@172.19.33.100> (UID: -1)
?Debug : Sep 04 18:03:34 RPCConn[SSL]<init@172.19.33.100>: SSL type requested: SSLv3(2)
?Debug : Sep 04 18:03:34 RPCConn[SSL]<init@172.19.33.100>: Call: 0x2700
?Debug : Sep 04 18:03:34 RPCConn[SSL]<init@172.19.33.100>: Call finished...
?Debug : Sep 04 18:03:38 RPCConn[SSL]<init@172.19.33.100>: Call: 0x3010
?Debug : Sep 04 18:03:38 RPCConn[SSL]<init@172.19.33.100>: Call finished...
?Debug : Sep 04 18:03:38 RPCConn[SSL]<init@172.19.33.100>: Call: 0x3017
?Debug : Sep 04 18:03:38 RPCConn[SSL]<init@172.19.33.100>: Call finished...
?Debug : Sep 04 18:03:39 RPCConn[SSL]<init@172.19.33.100>: Call: 0x3019
?Debug : Sep 04 18:03:39 DBCtx: SQL query: INSERT INTO discount_periods(start_date,end_date,periodic_type,canonical_len,custo
m_duration) VALUES('1125345600','1125842622','3','2678400','1')
?Debug : Sep 04 18:03:39 BusPeriodic: BusPeriodic::rehash_periodic calling pthread_cond_signal
?Debug : Sep 04 18:03:39 DBCtx: SQL query: UPDATE periodic_service_links SET discount_period_id='14' WHERE id='8'
?Debug : Sep 04 18:03:39 BusPeriodic: Wait result:0
?Debug : Sep 04 18:03:39 BusPeriodic: real_rehash start
?Debug : Sep 04 18:03:39 BusPeriodic: real_rehash finished
?Debug : Sep 04 18:03:39 BusPeriodic: 15 events remain
?Debug : Sep 04 18:03:39 BusPeriodic: first event time_t 1125842622
?Debug : Sep 04 18:03:39 BusPeriodic: i am going to wait for 3 sec...
?Debug : Sep 04 18:03:39 DBCtx: SQL query: UPDATE account_tariff_link SET next_tariff_id=0 WHERE id='9'
?Debug : Sep 04 18:03:39 DBCtx: SQL query: UPDATE account_tariff_link SET discount_period_id=14 WHERE id='9'
?Debug : Sep 04 18:03:39 BusPeriodic: BusPeriodic::rehash_periodic calling pthread_cond_signal
?Debug : Sep 04 18:03:39 RPCConn[SSL]<init@172.19.33.100>: Call finished...
?Debug : Sep 04 18:03:39 BusPeriodic: Wait result:0
?Debug : Sep 04 18:03:39 BusPeriodic: real_rehash start
?Debug : Sep 04 18:03:39 BusPeriodic: real_rehash finished
?Debug : Sep 04 18:03:39 BusPeriodic: 15 events remain
?Debug : Sep 04 18:03:39 BusPeriodic: first event time_t 1125842622
?Debug : Sep 04 18:03:39 BusPeriodic: i am going to wait for 3 sec...
?Debug : Sep 04 18:03:42 BusPeriodic: Wait result:110
?Debug : Sep 04 18:03:42 BusPeriodic: 15 events remain
?Debug : Sep 04 18:03:42 BusPeriodic: first event time_t 1125842622
?Debug : Sep 04 18:03:42 BusPeriodic: i am going to wait for 0 sec...
?Debug : Sep 04 18:03:42 BusPeriodic: Wait result:110
?Debug : Sep 04 18:03:42 BusPeriodic: periodic type close4multi_link for 14
?Debug : Sep 04 18:03:42 BusPeriodic: Periodic::func_close_multi called for period_id:14
?Debug : Sep 04 18:03:42 BusPeriodic: Slink id:8 for period_id:14
?Debug : Sep 04 18:03:42 DBA:Ctx: Looking for free context
?Debug : Sep 04 18:03:42 UTM5 DBA: close_discount_period4multi_link slink:8
?Debug : Sep 04 18:03:42 BusClassif: aggregation timeout
?Debug : Sep 04 18:03:42 DBCtx: SQL SELECT query: SELECT qnt FROM downloaded WHERE is_deleted=0 AND downloaded_id='5' AND tcl
ass_id='20'
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE downloaded SET qnt='39597612', discounted='0', downed_as_prepaid='0' WHERE
downloaded_id='5' AND tclass_id='20'
?Debug : Sep 04 18:03:42 UTM5 DBA: Discount:0.000000 p.u. for link:5 account 1
?Debug : Sep 04 18:03:42 UTM5 DBA: Checking for rehash: flags 3, balance 99.990 (old 99.990), credit 0.000
?Debug : Sep 04 18:03:42 DBAGiga: Rehash: Target: 10; Action: 1; Ptr: 5ed0ad0
?Debug : Sep 04 18:03:42 HSPlugin: Rehash: Target: 10; Action: 1; Ptr: 5ed0ad0
?Debug : Sep 04 18:03:42 Radius: Account '1': 99.990/0.000 send...
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE accounts SET balance='99.9897' WHERE id = '1'
?Debug : Sep 04 18:03:42 DBCtx: SQL query: INSERT INTO discount_transactions_all(account_id,incoming_rest,outgoing_rest,disco
unt,discount_without_tax,discount_with_tax,service_id,service_type,slink_id,discount_date,comment,discount_period_id) VALUES(
'1','99.9897','99.9897','0','0','0','3','3','5','1125842622','IP discount','2')
?Debug : Sep 04 18:03:42 DBCtx: SQL SELECT query: SELECT balance FROM special_accounts WHERE id=2
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE special_accounts SET balance='0' WHERE id=2
?Debug : Sep 04 18:03:42 DBCtx: SQL query: INSERT INTO special_transactions(date,incoming_rest,outgoing_rest,discount_transac
tion_id,transaction_type) VALUES('1125842622','0','0','205','2')
?Debug : Sep 04 18:03:42 DBCtx: SQL SELECT query: SELECT balance FROM special_accounts WHERE id=3
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE special_accounts SET balance='2401.01' WHERE id=3
?Debug : Sep 04 18:03:42 DBCtx: SQL query: INSERT INTO special_transactions(date,incoming_rest,outgoing_rest,discount_transac
tion_id,transaction_type) VALUES('1125842622','2401.01','2401.01','205','3')
?Debug : Sep 04 18:03:42 BusLogic: BLM(37) pushed (comment: ruh block)
?Debug : Sep 04 18:03:42 BusLogic: try to execute 37
?Debug : Sep 04 18:03:42 BusLogic: hw_block_handler with code 37
?Debug : Sep 04 18:03:42 BusLogic: finished unknown
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE dtagg_iptraffic SET discounted='0.000000',discounted_without_tax='0.000000'
, bytes='39597612.000000' WHERE id='6'
?Debug : Sep 04 18:03:42 DBCtx: SQL query: INSERT INTO discount_transactions_iptraffic_all(id,account_id,discount,discount_wi
th_tax,service_id,slink_id,discount_date,discount_date_hour,discount_date_day,discount_date_month,t_class,base_cost,ipid,byte
s,discount_period_id) VALUES('205','1','0','0','3','5','1125842622','1125842400','1125777600','1125518400','20','0','-1408237
468','921','2')
?Debug : Sep 04 18:03:42 DBCtx: SQL SELECT query: SELECT qnt FROM downloaded WHERE is_deleted=0 AND downloaded_id='5' AND tcl
ass_id='10'
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE downloaded SET qnt='78954128', discounted='0', downed_as_prepaid='78954128'
WHERE downloaded_id='5' AND tclass_id='10'
?Debug : Sep 04 18:03:42 UTM5 DBA: Discount:0.000000 p.u. for link:5 account 1
?Debug : Sep 04 18:03:42 UTM5 DBA: Checking for rehash: flags 3, balance 99.990 (old 99.990), credit 0.000
?Debug : Sep 04 18:03:42 DBAGiga: Rehash: Target: 10; Action: 1; Ptr: 5ed0ab0
?Debug : Sep 04 18:03:42 HSPlugin: Rehash: Target: 10; Action: 1; Ptr: 5ed0ab0
?Debug : Sep 04 18:03:42 Radius: Account '1': 99.990/0.000 send...
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE accounts SET balance='99.9897' WHERE id = '1'
?Debug : Sep 04 18:03:42 DBCtx: SQL query: INSERT INTO discount_transactions_all(account_id,incoming_rest,outgoing_rest,disco
unt,discount_without_tax,discount_with_tax,service_id,service_type,slink_id,discount_date,comment,discount_period_id) VALUES(
'1','99.9897','99.9897','0','0','0','3','3','5','1125842622','IP discount','2')
?Debug : Sep 04 18:03:42 DBCtx: SQL SELECT query: SELECT balance FROM special_accounts WHERE id=2
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE special_accounts SET balance='0' WHERE id=2
?Debug : Sep 04 18:03:42 DBCtx: SQL query: INSERT INTO special_transactions(date,incoming_rest,outgoing_rest,discount_transac
tion_id,transaction_type) VALUES('1125842622','0','0','206','2')
?Debug : Sep 04 18:03:42 DBCtx: SQL SELECT query: SELECT balance FROM special_accounts WHERE id=3
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE special_accounts SET balance='2401.01' WHERE id=3
?Debug : Sep 04 18:03:42 DBCtx: SQL query: INSERT INTO special_transactions(date,incoming_rest,outgoing_rest,discount_transac
tion_id,transaction_type) VALUES('1125842622','2401.01','2401.01','206','3')
?Debug : Sep 04 18:03:42 BusLogic: BLM(37) pushed (comment: ruh block)
?Debug : Sep 04 18:03:42 BusLogic: try to execute 37
?Debug : Sep 04 18:03:42 BusLogic: hw_block_handler with code 37
?Debug : Sep 04 18:03:42 BusLogic: finished unknown
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE dtagg_iptraffic SET discounted='0.000000',discounted_without_tax='0.000000'
, bytes='78954128.000000' WHERE id='7'
?Debug : Sep 04 18:03:42 DBCtx: SQL query: INSERT INTO discount_transactions_iptraffic_all(id,account_id,discount,discount_wi
th_tax,service_id,slink_id,discount_date,discount_date_hour,discount_date_day,discount_date_month,t_class,base_cost,ipid,byte
s,discount_period_id) VALUES('206','1','0','0','3','5','1125842622','1125842400','1125777600','1125518400','10','0','-1408237
468','699','2')
?Debug : Sep 04 18:03:42 UTM5 DBA: Generating invoices started. Total accounts:0 Total slinks:1
?Debug : Sep 04 18:03:42 UTM5 DBA: Generating invoice for slink:8 discount_period:14
?Debug : Sep 04 18:03:42 UTM5 DBA: Generating invoice for account_id:2 service_link:8 service_type:3
?Debug : Sep 04 18:03:42 UTM5 DBA: Generating invoice as st_periodic
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE dtagg_periodic SET discounted='0.000000',discounted_without_tax='0.000000'
WHERE id='8'
?Debug : Sep 04 18:03:42 UTM5 DBA: Generating invoice as st_iptraffic
?Debug : Sep 04 18:03:42 DBCtx: SQL query: INSERT INTO invoices(invoice_date,uid,account_id) VALUES('1125842622','2','2')
?Debug : Sep 04 18:03:42 DBCtx: SQL query: INSERT INTO invoice_entry(invoice_id,name,slink_id,discount_period_id,date,qnt,bas
e_cost,sum_cost,tax_amount) VALUES('6','100МБ за 300','8','14','1125842622','1','300','300','0')
?Debug : Sep 04 18:03:42 UTM5 DBA: Generating invoices finished. Total time:0 sec. Total slinks:1
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE periodic_service_links SET discounted_in_curr_period=0,unabon_period=0,unpr
epay_period=0 WHERE id='8'
?Debug : Sep 04 18:03:42 DBCtx: SQL query: INSERT INTO discount_periods(start_date,end_date,periodic_type,canonical_len, cust
om_duration, static_id) VALUES('1125842622','1128434622','3','2592000','1','1')
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE periodic_service_links SET discount_period_id='15' WHERE id='8'
?Debug : Sep 04 18:03:42 DBCtx: SQL SELECT query: SELECT link_date FROM account_tariff_link WHERE id='9'
?Debug : Sep 04 18:03:42 DBCtx: SQL query: INSERT INTO tariffs_history(account_id,tariff_id,link_date,unlink_date,tariff_name) VALUES('2','1','1125842455','1125842622','Тестовый')
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE account_tariff_link SET is_deleted=1 WHERE id='9'
?Debug : Sep 04 18:03:42 UTM5 DBA: Calling __delete_slink_internal for slink:8
?Debug : Sep 04 18:03:42 UTM5 DBA: __delete_slink_internal called with slinkid:8
?Debug : Sep 04 18:03:42 DBCtx: SQL SELECT query: SELECT id FROM blocks_info WHERE what_blocked='3' AND service_id='8' AND bl
ock_type='0' AND start_date<='1125842622' AND expire_date>='1125842622' AND is_deleted='0'
?Debug : Sep 04 18:03:42 DBCtx: SQL SELECT query: SELECT id FROM blocks_info WHERE what_blocked='3' AND service_id='8' AND bl
ock_type='1' AND start_date<='1125842622' AND expire_date>='1125842622' AND is_deleted='0'
?Debug : Sep 04 18:03:42 DBCtx: SQL SELECT query: SELECT id FROM blocks_info WHERE what_blocked='3' AND service_id='8' AND bl
ock_type='2' AND start_date<='1125842622' AND expire_date>='1125842622' AND is_deleted='0'
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE blocks_info SET is_deleted=1,expire_date='1125842622' WHERE what_blocked=3
AND slink_id=8
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE downloaded SET is_deleted=1 WHERE downloaded_id='8'
?Debug : Sep 04 18:03:42 DBA_IPgroups: Sending rehash to radius for ipgroup id=<8> erase.
?Debug : Sep 04 18:03:42 DBAGiga: Rehash: Target: 1; Action: 3; Ptr: 5ed0b70
?Debug : Sep 04 18:03:42 HSPlugin: Rehash: Target: 1; Action: 3; Ptr: 5ed0b70
?Debug : Sep 04 18:03:42 Radius: 8 IP from Group[1] send
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE ip_groups SET is_deleted=1, delete_date='1125842622' WHERE ip_group_id='8'
AND ip='-1408237465' AND mask='-1' AND is_deleted=0
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE ip_groups SET is_deleted=1, delete_date='1125842622' WHERE ip_group_id='8'
AND is_deleted=0
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE iptraffic_service_links SET is_deleted=1 WHERE id='8'
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE dtagg_periodic SET discounted='0.000000',discounted_without_tax='0.000000'
WHERE id='8'
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE service_links SET is_deleted=1 WHERE id='8'
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE periodic_service_links SET is_deleted=1 WHERE id='8'
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE discount_periods set is_expired=1 WHERE id='14'
?Debug : Sep 04 18:03:42 DBA:Ctx: Pushing back free context
-Stats : Sep 04 18:03:42 UTM5 DBA: Stats: Uptime: 00:00:00. Events: 0; Errors: 0
?Debug : Sep 04 18:03:42 BusPeriodic: real_rehash start
?Debug : Sep 04 18:03:42 BusPeriodic: real_rehash finished
?Debug : Sep 04 18:03:42 BusPeriodic: 14 events remain
?Debug : Sep 04 18:03:42 BusPeriodic: first event time_t 1128024000
?Debug : Sep 04 18:03:42 BusPeriodic: i am going to wait for 216000 sec...
?Debug : Sep 04 18:03:47 RPCConn[SSL]<init@172.19.33.100>: Call: 0x2005
ERROR : Sep 04 18:03:48 UTMCtx: Encrypt: No ctx found
Warn : Sep 04 18:03:48 UTMCtx: Unencrypted message passed!
?Debug : Sep 04 18:03:48 DBCtx: SQL query: UPDATE users SET password='test',last_change_date='1125842628',who_change='-1',ful
l_name='',is_juridical='0',juridical_address='',is_send_invoice ='0',advance_payment ='0',actual_address='',flat_number='',ho
use_id='0',entrance='',floor='',passport='',work_telephone='',home_telephone='',mobile_telephone='',web_page='',icq_number='',tax_number='',kpp_number='',email='',bank_id='0',bank_account='',comments='',personal_manager='',connect_date='-10800' WHERE
id='2'
?Debug : Sep 04 18:03:48 RPCConn[SSL]<init@172.19.33.100>: Call finished...
?Debug : Sep 04 18:03:48 RPCConn[SSL]<init@172.19.33.100>: Call: 0x2032
?Debug : Sep 04 18:03:48 DBCtx: SQL query: UPDATE accounts SET dealer_account_id='0' WHERE id='2'
?Debug : Sep 04 18:03:48 DBCtx: SQL query: UPDATE accounts SET vat_rate='0',sale_tax_rate='0' WHERE id='2'
?Debug : Sep 04 18:03:48 DBCtx: SQL query: UPDATE accounts SET credit='0.000000' WHERE id='2'
?Debug : Sep 04 18:03:48 BusLogic: BLM(37) pushed (comment: ruh block)
?Debug : Sep 04 18:03:48 UTM5 DBA: Checking for rehash[set_account_credit]: flags 3, balance -289.000, credit 0.000
?Debug : Sep 04 18:03:48 DBAGiga: Rehash: Target: 10; Action: 1; Ptr: b6bbbfa0
?Debug : Sep 04 18:03:48 HSPlugin: Rehash: Target: 10; Action: 1; Ptr: b6bbbfa0
?Debug : Sep 04 18:03:48 Radius: Account '2': -289.000/0.000 send...
?Debug : Sep 04 18:03:48 DBCtx: SQL query: UPDATE accounts SET discount_period_id='1' WHERE id='2'
?Debug : Sep 04 18:03:48 BusLogic: try to execute 37
?Debug : Sep 04 18:03:48 BusLogic: hw_block_handler with code 37
?Debug : Sep 04 18:03:48 BusLogic: finished unknown
?Debug : Sep 04 18:03:48 DBCtx: SQL query: UPDATE accounts SET int_status='0' WHERE id='2'
?Debug : Sep 04 18:03:48 BusLogic: BLM(38) pushed (comment: )
?Debug : Sep 04 18:03:48 UTM5 DBA: hw block for account 2
?Debug : Sep 04 18:03:48 DBCtx: SQL query: UPDATE accounts SET block_recalc_abon='0',block_recalc_prepaid='0' WHERE id='2'
?Debug : Sep 04 18:03:48 BusLogic: try to execute 38
?Debug : Sep 04 18:03:48 BusLogic: hw_block_handler with code 38
?Debug : Sep 04 18:03:48 BusLogic: hw_block_handler start bla_user_hw_unblock|bla_user_hw_block
?Debug : Sep 04 18:03:48 RPCConn[SSL]<init@172.19.33.100>: Call finished...
?Debug : Sep 04 18:03:48 DBCtx: SQL SELECT query: SELECT rule_on,rule_off,router_id FROM firewall_rules WHERE is_deleted='0'
AND ((uid='2' AND uid!='0') OR is_for_all='1' )
?Debug : Sep 04 18:03:48 ModFWMan: Ready to execute 1 FW rules for UID 2. State:0
?Debug : Sep 04 18:03:48 DBCtx: SQL SELECT query: SELECT id,router_type,router_ip,login,password,router_comments
FROM routers_info WHERE is_deleted='0'
?Debug : Sep 04 18:03:48 BusLogic: hw_block_handler end bla_user_hw_unblock|bla_user_hw_block
?Debug : Sep 04 18:03:48 BusLogic: finished unknown
?Debug : Sep 04 18:03:48 RPCConn[SSL]<init@172.19.33.100>: Call: 0x2011
?Debug : Sep 04 18:03:48 RPCConn[SSL]<init@172.19.33.100>: Call finished...
?Debug : Sep 04 18:03:48 RPCConn[SSL]<init@172.19.33.100>: Call: 0x2400
?Debug : Sep 04 18:03:48 DBCtx: SQL SELECT query: SELECT id, group_name FROM groups
?Debug : Sep 04 18:03:48 RPCConn[SSL]<init@172.19.33.100>: Call finished...
?Debug : Sep 04 18:03:48 RPCConn[SSL]<init@172.19.33.100>: Call: 0x2001
?Debug : Sep 04 18:03:48 RPCConn[SSL]<init@172.19.33.100>: Call finished...
?Debug : Sep 04 18:03:55 RPCConn[SSL]<init@172.19.33.100>: Call: 0x2600
?Debug : Sep 04 18:03:55 RPCConn[SSL]<init@172.19.33.100>: Call finished...
?Debug : Sep 04 18:03:55 RPCConn[SSL]<init@172.19.33.100>: Call: 0x2600
?Debug : Sep 04 18:03:55 RPCConn[SSL]<init@172.19.33.100>: Call finished...
?Debug : Sep 04 18:04:31 RPCConn[SSL]<vans@172.19.33.100>: Call: 0xffffbfda
?Debug : Sep 04 18:04:31 RPCConn[SSL]<vans@172.19.33.100>: Call finished...
?Debug : Sep 04 18:04:31 RPCConn[SSL]<vans@172.19.33.100>: Call: 0xffffbfd8
?Debug : Sep 04 18:04:31 DBCtx: SQL query: UPDATE messages SET recv_date='1125842671' WHERE recv_date=0 AND receiver_id='1'
AND send_date>='1125842552' AND send_date<='1125842671'
?Debug : Sep 04 18:04:31 DBCtx: SQL SELECT query: SELECT id,sender_id,subject,message,send_date,recv_date FROM messages WHERE
(receiver_id='1' OR is_for_all=1) AND send_date>='1125842552' AND send_date<='1125842671'
?Debug : Sep 04 18:04:31 RPCConn[SSL]<vans@172.19.33.100>: Call finished...
?Debug : Sep 04 18:05:18 BusClassif: aggregation timeout
?Debug : Sep 04 18:05:18 DBCtx: SQL SELECT query: SELECT qnt FROM downloaded WHERE is_deleted=0 AND downloaded_id='5' AND tcl
ass_id='10'
?Debug : Sep 04 18:05:18 DBCtx: SQL query: UPDATE downloaded SET qnt='79026868', discounted='0', downed_as_prepaid='79026868'
WHERE downloaded_id='5' AND tclass_id='10'
?Debug : Sep 04 18:05:18 UTM5 DBA: Discount:0.000000 p.u. for link:5 account 1
?Debug : Sep 04 18:05:18 UTM5 DBA: Checking for rehash: flags 3, balance 99.990 (old 99.990), credit 0.000
?Debug : Sep 04 18:05:18 DBAGiga: Rehash: Target: 10; Action: 1; Ptr: 4acf0f0
?Debug : Sep 04 18:05:18 HSPlugin: Rehash: Target: 10; Action: 1; Ptr: 4acf0f0
?Debug : Sep 04 18:05:18 Radius: Account '1': 99.990/0.000 send...
?Debug : Sep 04 18:05:18 DBCtx: SQL query: UPDATE accounts SET balance='99.9897' WHERE id = '1'
?Debug : Sep 04 18:05:18 DBCtx: SQL query: INSERT INTO discount_transactions_all(account_id,incoming_rest,outgoing_rest,disco
unt,discount_without_tax,discount_with_tax,service_id,service_type,slink_id,discount_date,comment,discount_period_id) VALUES(
'1','99.9897','99.9897','0','0','0','3','3','5','1125842718','IP discount','2')
?Debug : Sep 04 18:05:18 DBCtx: SQL SELECT query: SELECT balance FROM special_accounts WHERE id=2
?Debug : Sep 04 18:05:18 DBCtx: SQL query: UPDATE special_accounts SET balance='0' WHERE id=2
?Debug : Sep 04 18:05:18 DBCtx: SQL query: INSERT INTO special_transactions(date,incoming_rest,outgoing_rest,discount_transac
tion_id,transaction_type) VALUES('1125842718','0','0','207','2')
?Debug : Sep 04 18:05:18 DBCtx: SQL SELECT query: SELECT balance FROM special_accounts WHERE id=3
?Debug : Sep 04 18:05:18 DBCtx: SQL query: UPDATE special_accounts SET balance='2401.01' WHERE id=3
?Debug : Sep 04 18:05:18 DBCtx: SQL query: INSERT INTO special_transactions(date,incoming_rest,outgoing_rest,discount_transac
tion_id,transaction_type) VALUES('1125842718','2401.01','2401.01','207','3')
?Debug : Sep 04 18:05:18 BusLogic: BLM(37) pushed (comment: ruh block)
?Debug : Sep 04 18:05:18 BusLogic: try to execute 37
?Debug : Sep 04 18:05:18 BusLogic: hw_block_handler with code 37
?Debug : Sep 04 18:05:18 BusLogic: finished unknown
?Debug : Sep 04 18:05:18 DBCtx: SQL query: UPDATE dtagg_iptraffic SET discounted='0.000000',discounted_without_tax='0.000000'
, bytes='79026868.000000' WHERE id='7'
?Debug : Sep 04 18:05:18 DBCtx: SQL query: INSERT INTO discount_transactions_iptraffic_all(id,account_id,discount,discount_wi
th_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('207','1','0','0','3','5','1125842718','1125842400','1125777600','1125518400','10','0','-1408237
468','72740','2')
Далее в расчетных периодах появляется еще один и начинается он с текущей даты.
?Debug : Sep 04 18:03:33 RPCConn[SSL]<init@172.19.33.100>: Call: 0x2035
?Debug : Sep 04 18:03:33 RPCConn[SSL]<init@172.19.33.100>: Call finished...
?Debug : Sep 04 18:03:33 RPCConn[SSL]<init@172.19.33.100>: Call: 0x6002
?Debug : Sep 04 18:03:33 DBCtx: SQL SELECT query: SELECT id,bic,name,city,kschet FROM banks ORDER BY id
?Debug : Sep 04 18:03:33 RPCConn[SSL]<init@172.19.33.100>: Call finished...
?Debug : Sep 04 18:03:33 RPCConn[SSL]<init@172.19.33.100>: Call: 0x7030
?Debug : Sep 04 18:03:33 DBCtx: SQL SELECT query: SELECT act_id FROM acts_templates WHERE is_old='0' AND def='1' AND doc_type
='2'
?Debug : Sep 04 18:03:33 DBCtx: SQL SELECT query: SELECT act_text, landscape FROM acts_templates WHERE is_old='0' AND act_id=
'2'
?Debug : Sep 04 18:03:33 DBCtx: SQL SELECT query: SELECT login,password,basic_account,full_name,juridical_address,actual_addr
ess,tax_number,kpp_number,bank_account,email,passport,bank_id FROM users WHERE id='2'
?Debug : Sep 04 18:03:33 DBCtx: SQL SELECT query: SELECT bic,name,city,kschet FROM banks WHERE id='0'
?Debug : Sep 04 18:03:33 DBCtx: SQL SELECT query: SELECT name,ur_adress,act_adress,inn,kpp,bank_id,account,fio_headman,fio_bo
okeeper,fio_headman_sh,fio_bookeeper_sh,name_sh FROM supplier_info WHERE id='1'
?Debug : Sep 04 18:03:33 DBCtx: SQL SELECT query: SELECT bic,name,city,kschet FROM banks WHERE id='1'
?Debug : Sep 04 18:03:33 RPCConn[SSL]<init@172.19.33.100>: Call finished...
?Debug : Sep 04 18:03:33 RPCConn[SSL]<init@172.19.33.100>: Call: 0x2550
?Debug : Sep 04 18:03:33 RPCConn[SSL]<init@172.19.33.100>: Call finished...
?Debug : Sep 04 18:03:33 RPCConn[SSL]<init@172.19.33.100>: Call: 0x2006
?Debug : Sep 04 18:03:33 DBCtx: SQL SELECT query: SELECT login, password, basic_account
, is_blocked, create_date, last_change_date, who_create, who_c
hange, is_juridical, full_name, juridical_address, actual_address,
work_telephone, home_telephone, mobile_telephone, web_page, icq_n
umber, tax_number, kpp_number, bank_id, bank_account, comments,
discount_period_id, email, house_id, flat_number, entrance,
floor, passport, personal_manager, connect_date, is_send_invoice,
advance_payment FROM users WHERE id='2' AND is_deleted=0
?Debug : Sep 04 18:03:33 DBCtx: SQL SELECT query: SELECT group_id FROM users_groups_link WHERE user_id='2'
?Debug : Sep 04 18:03:33 RPCConn[SSL]<init@172.19.33.100>: Call finished...
?Debug : Sep 04 18:03:33 RPCConn[SSL]<init@172.19.33.100>: Call: 0x2030
?Debug : Sep 04 18:03:33 RPCConn[SSL]<init@172.19.33.100>: Call finished...
?Debug : Sep 04 18:03:33 RPCConn[SSL]<init@172.19.33.100>: Call: 0x2553
?Debug : Sep 04 18:03:33 RPCConn[SSL]<init@172.19.33.100>: Call finished...
Info : Sep 04 18:03:34 RPCServer@0.0.0.0: Client connecting: 172.19.33.100:3470
Info : Sep 04 18:03:34 RPCConn: Connection from: 172.19.33.100:3470
Info : Sep 04 18:03:34 RPCConn: Card user <init@172.19.33.100> is connecting
?Debug : Sep 04 18:03:34 UTM5 DBA: Group: -1 from 1
Info : Sep 04 18:03:34 RPCConn[SSL]<init@172.19.33.100>: Access granted to [SSL]<init@172.19.33.100> (UID: -1)
?Debug : Sep 04 18:03:34 RPCConn[SSL]<init@172.19.33.100>: SSL type requested: SSLv3(2)
?Debug : Sep 04 18:03:34 RPCConn[SSL]<init@172.19.33.100>: Call: 0x2700
?Debug : Sep 04 18:03:34 RPCConn[SSL]<init@172.19.33.100>: Call finished...
?Debug : Sep 04 18:03:38 RPCConn[SSL]<init@172.19.33.100>: Call: 0x3010
?Debug : Sep 04 18:03:38 RPCConn[SSL]<init@172.19.33.100>: Call finished...
?Debug : Sep 04 18:03:38 RPCConn[SSL]<init@172.19.33.100>: Call: 0x3017
?Debug : Sep 04 18:03:38 RPCConn[SSL]<init@172.19.33.100>: Call finished...
?Debug : Sep 04 18:03:39 RPCConn[SSL]<init@172.19.33.100>: Call: 0x3019
?Debug : Sep 04 18:03:39 DBCtx: SQL query: INSERT INTO discount_periods(start_date,end_date,periodic_type,canonical_len,custo
m_duration) VALUES('1125345600','1125842622','3','2678400','1')
?Debug : Sep 04 18:03:39 BusPeriodic: BusPeriodic::rehash_periodic calling pthread_cond_signal
?Debug : Sep 04 18:03:39 DBCtx: SQL query: UPDATE periodic_service_links SET discount_period_id='14' WHERE id='8'
?Debug : Sep 04 18:03:39 BusPeriodic: Wait result:0
?Debug : Sep 04 18:03:39 BusPeriodic: real_rehash start
?Debug : Sep 04 18:03:39 BusPeriodic: real_rehash finished
?Debug : Sep 04 18:03:39 BusPeriodic: 15 events remain
?Debug : Sep 04 18:03:39 BusPeriodic: first event time_t 1125842622
?Debug : Sep 04 18:03:39 BusPeriodic: i am going to wait for 3 sec...
?Debug : Sep 04 18:03:39 DBCtx: SQL query: UPDATE account_tariff_link SET next_tariff_id=0 WHERE id='9'
?Debug : Sep 04 18:03:39 DBCtx: SQL query: UPDATE account_tariff_link SET discount_period_id=14 WHERE id='9'
?Debug : Sep 04 18:03:39 BusPeriodic: BusPeriodic::rehash_periodic calling pthread_cond_signal
?Debug : Sep 04 18:03:39 RPCConn[SSL]<init@172.19.33.100>: Call finished...
?Debug : Sep 04 18:03:39 BusPeriodic: Wait result:0
?Debug : Sep 04 18:03:39 BusPeriodic: real_rehash start
?Debug : Sep 04 18:03:39 BusPeriodic: real_rehash finished
?Debug : Sep 04 18:03:39 BusPeriodic: 15 events remain
?Debug : Sep 04 18:03:39 BusPeriodic: first event time_t 1125842622
?Debug : Sep 04 18:03:39 BusPeriodic: i am going to wait for 3 sec...
?Debug : Sep 04 18:03:42 BusPeriodic: Wait result:110
?Debug : Sep 04 18:03:42 BusPeriodic: 15 events remain
?Debug : Sep 04 18:03:42 BusPeriodic: first event time_t 1125842622
?Debug : Sep 04 18:03:42 BusPeriodic: i am going to wait for 0 sec...
?Debug : Sep 04 18:03:42 BusPeriodic: Wait result:110
?Debug : Sep 04 18:03:42 BusPeriodic: periodic type close4multi_link for 14
?Debug : Sep 04 18:03:42 BusPeriodic: Periodic::func_close_multi called for period_id:14
?Debug : Sep 04 18:03:42 BusPeriodic: Slink id:8 for period_id:14
?Debug : Sep 04 18:03:42 DBA:Ctx: Looking for free context
?Debug : Sep 04 18:03:42 UTM5 DBA: close_discount_period4multi_link slink:8
?Debug : Sep 04 18:03:42 BusClassif: aggregation timeout
?Debug : Sep 04 18:03:42 DBCtx: SQL SELECT query: SELECT qnt FROM downloaded WHERE is_deleted=0 AND downloaded_id='5' AND tcl
ass_id='20'
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE downloaded SET qnt='39597612', discounted='0', downed_as_prepaid='0' WHERE
downloaded_id='5' AND tclass_id='20'
?Debug : Sep 04 18:03:42 UTM5 DBA: Discount:0.000000 p.u. for link:5 account 1
?Debug : Sep 04 18:03:42 UTM5 DBA: Checking for rehash: flags 3, balance 99.990 (old 99.990), credit 0.000
?Debug : Sep 04 18:03:42 DBAGiga: Rehash: Target: 10; Action: 1; Ptr: 5ed0ad0
?Debug : Sep 04 18:03:42 HSPlugin: Rehash: Target: 10; Action: 1; Ptr: 5ed0ad0
?Debug : Sep 04 18:03:42 Radius: Account '1': 99.990/0.000 send...
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE accounts SET balance='99.9897' WHERE id = '1'
?Debug : Sep 04 18:03:42 DBCtx: SQL query: INSERT INTO discount_transactions_all(account_id,incoming_rest,outgoing_rest,disco
unt,discount_without_tax,discount_with_tax,service_id,service_type,slink_id,discount_date,comment,discount_period_id) VALUES(
'1','99.9897','99.9897','0','0','0','3','3','5','1125842622','IP discount','2')
?Debug : Sep 04 18:03:42 DBCtx: SQL SELECT query: SELECT balance FROM special_accounts WHERE id=2
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE special_accounts SET balance='0' WHERE id=2
?Debug : Sep 04 18:03:42 DBCtx: SQL query: INSERT INTO special_transactions(date,incoming_rest,outgoing_rest,discount_transac
tion_id,transaction_type) VALUES('1125842622','0','0','205','2')
?Debug : Sep 04 18:03:42 DBCtx: SQL SELECT query: SELECT balance FROM special_accounts WHERE id=3
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE special_accounts SET balance='2401.01' WHERE id=3
?Debug : Sep 04 18:03:42 DBCtx: SQL query: INSERT INTO special_transactions(date,incoming_rest,outgoing_rest,discount_transac
tion_id,transaction_type) VALUES('1125842622','2401.01','2401.01','205','3')
?Debug : Sep 04 18:03:42 BusLogic: BLM(37) pushed (comment: ruh block)
?Debug : Sep 04 18:03:42 BusLogic: try to execute 37
?Debug : Sep 04 18:03:42 BusLogic: hw_block_handler with code 37
?Debug : Sep 04 18:03:42 BusLogic: finished unknown
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE dtagg_iptraffic SET discounted='0.000000',discounted_without_tax='0.000000'
, bytes='39597612.000000' WHERE id='6'
?Debug : Sep 04 18:03:42 DBCtx: SQL query: INSERT INTO discount_transactions_iptraffic_all(id,account_id,discount,discount_wi
th_tax,service_id,slink_id,discount_date,discount_date_hour,discount_date_day,discount_date_month,t_class,base_cost,ipid,byte
s,discount_period_id) VALUES('205','1','0','0','3','5','1125842622','1125842400','1125777600','1125518400','20','0','-1408237
468','921','2')
?Debug : Sep 04 18:03:42 DBCtx: SQL SELECT query: SELECT qnt FROM downloaded WHERE is_deleted=0 AND downloaded_id='5' AND tcl
ass_id='10'
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE downloaded SET qnt='78954128', discounted='0', downed_as_prepaid='78954128'
WHERE downloaded_id='5' AND tclass_id='10'
?Debug : Sep 04 18:03:42 UTM5 DBA: Discount:0.000000 p.u. for link:5 account 1
?Debug : Sep 04 18:03:42 UTM5 DBA: Checking for rehash: flags 3, balance 99.990 (old 99.990), credit 0.000
?Debug : Sep 04 18:03:42 DBAGiga: Rehash: Target: 10; Action: 1; Ptr: 5ed0ab0
?Debug : Sep 04 18:03:42 HSPlugin: Rehash: Target: 10; Action: 1; Ptr: 5ed0ab0
?Debug : Sep 04 18:03:42 Radius: Account '1': 99.990/0.000 send...
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE accounts SET balance='99.9897' WHERE id = '1'
?Debug : Sep 04 18:03:42 DBCtx: SQL query: INSERT INTO discount_transactions_all(account_id,incoming_rest,outgoing_rest,disco
unt,discount_without_tax,discount_with_tax,service_id,service_type,slink_id,discount_date,comment,discount_period_id) VALUES(
'1','99.9897','99.9897','0','0','0','3','3','5','1125842622','IP discount','2')
?Debug : Sep 04 18:03:42 DBCtx: SQL SELECT query: SELECT balance FROM special_accounts WHERE id=2
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE special_accounts SET balance='0' WHERE id=2
?Debug : Sep 04 18:03:42 DBCtx: SQL query: INSERT INTO special_transactions(date,incoming_rest,outgoing_rest,discount_transac
tion_id,transaction_type) VALUES('1125842622','0','0','206','2')
?Debug : Sep 04 18:03:42 DBCtx: SQL SELECT query: SELECT balance FROM special_accounts WHERE id=3
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE special_accounts SET balance='2401.01' WHERE id=3
?Debug : Sep 04 18:03:42 DBCtx: SQL query: INSERT INTO special_transactions(date,incoming_rest,outgoing_rest,discount_transac
tion_id,transaction_type) VALUES('1125842622','2401.01','2401.01','206','3')
?Debug : Sep 04 18:03:42 BusLogic: BLM(37) pushed (comment: ruh block)
?Debug : Sep 04 18:03:42 BusLogic: try to execute 37
?Debug : Sep 04 18:03:42 BusLogic: hw_block_handler with code 37
?Debug : Sep 04 18:03:42 BusLogic: finished unknown
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE dtagg_iptraffic SET discounted='0.000000',discounted_without_tax='0.000000'
, bytes='78954128.000000' WHERE id='7'
?Debug : Sep 04 18:03:42 DBCtx: SQL query: INSERT INTO discount_transactions_iptraffic_all(id,account_id,discount,discount_wi
th_tax,service_id,slink_id,discount_date,discount_date_hour,discount_date_day,discount_date_month,t_class,base_cost,ipid,byte
s,discount_period_id) VALUES('206','1','0','0','3','5','1125842622','1125842400','1125777600','1125518400','10','0','-1408237
468','699','2')
?Debug : Sep 04 18:03:42 UTM5 DBA: Generating invoices started. Total accounts:0 Total slinks:1
?Debug : Sep 04 18:03:42 UTM5 DBA: Generating invoice for slink:8 discount_period:14
?Debug : Sep 04 18:03:42 UTM5 DBA: Generating invoice for account_id:2 service_link:8 service_type:3
?Debug : Sep 04 18:03:42 UTM5 DBA: Generating invoice as st_periodic
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE dtagg_periodic SET discounted='0.000000',discounted_without_tax='0.000000'
WHERE id='8'
?Debug : Sep 04 18:03:42 UTM5 DBA: Generating invoice as st_iptraffic
?Debug : Sep 04 18:03:42 DBCtx: SQL query: INSERT INTO invoices(invoice_date,uid,account_id) VALUES('1125842622','2','2')
?Debug : Sep 04 18:03:42 DBCtx: SQL query: INSERT INTO invoice_entry(invoice_id,name,slink_id,discount_period_id,date,qnt,bas
e_cost,sum_cost,tax_amount) VALUES('6','100МБ за 300','8','14','1125842622','1','300','300','0')
?Debug : Sep 04 18:03:42 UTM5 DBA: Generating invoices finished. Total time:0 sec. Total slinks:1
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE periodic_service_links SET discounted_in_curr_period=0,unabon_period=0,unpr
epay_period=0 WHERE id='8'
?Debug : Sep 04 18:03:42 DBCtx: SQL query: INSERT INTO discount_periods(start_date,end_date,periodic_type,canonical_len, cust
om_duration, static_id) VALUES('1125842622','1128434622','3','2592000','1','1')
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE periodic_service_links SET discount_period_id='15' WHERE id='8'
?Debug : Sep 04 18:03:42 DBCtx: SQL SELECT query: SELECT link_date FROM account_tariff_link WHERE id='9'
?Debug : Sep 04 18:03:42 DBCtx: SQL query: INSERT INTO tariffs_history(account_id,tariff_id,link_date,unlink_date,tariff_name) VALUES('2','1','1125842455','1125842622','Тестовый')
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE account_tariff_link SET is_deleted=1 WHERE id='9'
?Debug : Sep 04 18:03:42 UTM5 DBA: Calling __delete_slink_internal for slink:8
?Debug : Sep 04 18:03:42 UTM5 DBA: __delete_slink_internal called with slinkid:8
?Debug : Sep 04 18:03:42 DBCtx: SQL SELECT query: SELECT id FROM blocks_info WHERE what_blocked='3' AND service_id='8' AND bl
ock_type='0' AND start_date<='1125842622' AND expire_date>='1125842622' AND is_deleted='0'
?Debug : Sep 04 18:03:42 DBCtx: SQL SELECT query: SELECT id FROM blocks_info WHERE what_blocked='3' AND service_id='8' AND bl
ock_type='1' AND start_date<='1125842622' AND expire_date>='1125842622' AND is_deleted='0'
?Debug : Sep 04 18:03:42 DBCtx: SQL SELECT query: SELECT id FROM blocks_info WHERE what_blocked='3' AND service_id='8' AND bl
ock_type='2' AND start_date<='1125842622' AND expire_date>='1125842622' AND is_deleted='0'
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE blocks_info SET is_deleted=1,expire_date='1125842622' WHERE what_blocked=3
AND slink_id=8
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE downloaded SET is_deleted=1 WHERE downloaded_id='8'
?Debug : Sep 04 18:03:42 DBA_IPgroups: Sending rehash to radius for ipgroup id=<8> erase.
?Debug : Sep 04 18:03:42 DBAGiga: Rehash: Target: 1; Action: 3; Ptr: 5ed0b70
?Debug : Sep 04 18:03:42 HSPlugin: Rehash: Target: 1; Action: 3; Ptr: 5ed0b70
?Debug : Sep 04 18:03:42 Radius: 8 IP from Group[1] send
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE ip_groups SET is_deleted=1, delete_date='1125842622' WHERE ip_group_id='8'
AND ip='-1408237465' AND mask='-1' AND is_deleted=0
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE ip_groups SET is_deleted=1, delete_date='1125842622' WHERE ip_group_id='8'
AND is_deleted=0
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE iptraffic_service_links SET is_deleted=1 WHERE id='8'
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE dtagg_periodic SET discounted='0.000000',discounted_without_tax='0.000000'
WHERE id='8'
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE service_links SET is_deleted=1 WHERE id='8'
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE periodic_service_links SET is_deleted=1 WHERE id='8'
?Debug : Sep 04 18:03:42 DBCtx: SQL query: UPDATE discount_periods set is_expired=1 WHERE id='14'
?Debug : Sep 04 18:03:42 DBA:Ctx: Pushing back free context
-Stats : Sep 04 18:03:42 UTM5 DBA: Stats: Uptime: 00:00:00. Events: 0; Errors: 0
?Debug : Sep 04 18:03:42 BusPeriodic: real_rehash start
?Debug : Sep 04 18:03:42 BusPeriodic: real_rehash finished
?Debug : Sep 04 18:03:42 BusPeriodic: 14 events remain
?Debug : Sep 04 18:03:42 BusPeriodic: first event time_t 1128024000
?Debug : Sep 04 18:03:42 BusPeriodic: i am going to wait for 216000 sec...
?Debug : Sep 04 18:03:47 RPCConn[SSL]<init@172.19.33.100>: Call: 0x2005
ERROR : Sep 04 18:03:48 UTMCtx: Encrypt: No ctx found
Warn : Sep 04 18:03:48 UTMCtx: Unencrypted message passed!
?Debug : Sep 04 18:03:48 DBCtx: SQL query: UPDATE users SET password='test',last_change_date='1125842628',who_change='-1',ful
l_name='',is_juridical='0',juridical_address='',is_send_invoice ='0',advance_payment ='0',actual_address='',flat_number='',ho
use_id='0',entrance='',floor='',passport='',work_telephone='',home_telephone='',mobile_telephone='',web_page='',icq_number='',tax_number='',kpp_number='',email='',bank_id='0',bank_account='',comments='',personal_manager='',connect_date='-10800' WHERE
id='2'
?Debug : Sep 04 18:03:48 RPCConn[SSL]<init@172.19.33.100>: Call finished...
?Debug : Sep 04 18:03:48 RPCConn[SSL]<init@172.19.33.100>: Call: 0x2032
?Debug : Sep 04 18:03:48 DBCtx: SQL query: UPDATE accounts SET dealer_account_id='0' WHERE id='2'
?Debug : Sep 04 18:03:48 DBCtx: SQL query: UPDATE accounts SET vat_rate='0',sale_tax_rate='0' WHERE id='2'
?Debug : Sep 04 18:03:48 DBCtx: SQL query: UPDATE accounts SET credit='0.000000' WHERE id='2'
?Debug : Sep 04 18:03:48 BusLogic: BLM(37) pushed (comment: ruh block)
?Debug : Sep 04 18:03:48 UTM5 DBA: Checking for rehash[set_account_credit]: flags 3, balance -289.000, credit 0.000
?Debug : Sep 04 18:03:48 DBAGiga: Rehash: Target: 10; Action: 1; Ptr: b6bbbfa0
?Debug : Sep 04 18:03:48 HSPlugin: Rehash: Target: 10; Action: 1; Ptr: b6bbbfa0
?Debug : Sep 04 18:03:48 Radius: Account '2': -289.000/0.000 send...
?Debug : Sep 04 18:03:48 DBCtx: SQL query: UPDATE accounts SET discount_period_id='1' WHERE id='2'
?Debug : Sep 04 18:03:48 BusLogic: try to execute 37
?Debug : Sep 04 18:03:48 BusLogic: hw_block_handler with code 37
?Debug : Sep 04 18:03:48 BusLogic: finished unknown
?Debug : Sep 04 18:03:48 DBCtx: SQL query: UPDATE accounts SET int_status='0' WHERE id='2'
?Debug : Sep 04 18:03:48 BusLogic: BLM(38) pushed (comment: )
?Debug : Sep 04 18:03:48 UTM5 DBA: hw block for account 2
?Debug : Sep 04 18:03:48 DBCtx: SQL query: UPDATE accounts SET block_recalc_abon='0',block_recalc_prepaid='0' WHERE id='2'
?Debug : Sep 04 18:03:48 BusLogic: try to execute 38
?Debug : Sep 04 18:03:48 BusLogic: hw_block_handler with code 38
?Debug : Sep 04 18:03:48 BusLogic: hw_block_handler start bla_user_hw_unblock|bla_user_hw_block
?Debug : Sep 04 18:03:48 RPCConn[SSL]<init@172.19.33.100>: Call finished...
?Debug : Sep 04 18:03:48 DBCtx: SQL SELECT query: SELECT rule_on,rule_off,router_id FROM firewall_rules WHERE is_deleted='0'
AND ((uid='2' AND uid!='0') OR is_for_all='1' )
?Debug : Sep 04 18:03:48 ModFWMan: Ready to execute 1 FW rules for UID 2. State:0
?Debug : Sep 04 18:03:48 DBCtx: SQL SELECT query: SELECT id,router_type,router_ip,login,password,router_comments
FROM routers_info WHERE is_deleted='0'
?Debug : Sep 04 18:03:48 BusLogic: hw_block_handler end bla_user_hw_unblock|bla_user_hw_block
?Debug : Sep 04 18:03:48 BusLogic: finished unknown
?Debug : Sep 04 18:03:48 RPCConn[SSL]<init@172.19.33.100>: Call: 0x2011
?Debug : Sep 04 18:03:48 RPCConn[SSL]<init@172.19.33.100>: Call finished...
?Debug : Sep 04 18:03:48 RPCConn[SSL]<init@172.19.33.100>: Call: 0x2400
?Debug : Sep 04 18:03:48 DBCtx: SQL SELECT query: SELECT id, group_name FROM groups
?Debug : Sep 04 18:03:48 RPCConn[SSL]<init@172.19.33.100>: Call finished...
?Debug : Sep 04 18:03:48 RPCConn[SSL]<init@172.19.33.100>: Call: 0x2001
?Debug : Sep 04 18:03:48 RPCConn[SSL]<init@172.19.33.100>: Call finished...
?Debug : Sep 04 18:03:55 RPCConn[SSL]<init@172.19.33.100>: Call: 0x2600
?Debug : Sep 04 18:03:55 RPCConn[SSL]<init@172.19.33.100>: Call finished...
?Debug : Sep 04 18:03:55 RPCConn[SSL]<init@172.19.33.100>: Call: 0x2600
?Debug : Sep 04 18:03:55 RPCConn[SSL]<init@172.19.33.100>: Call finished...
?Debug : Sep 04 18:04:31 RPCConn[SSL]<vans@172.19.33.100>: Call: 0xffffbfda
?Debug : Sep 04 18:04:31 RPCConn[SSL]<vans@172.19.33.100>: Call finished...
?Debug : Sep 04 18:04:31 RPCConn[SSL]<vans@172.19.33.100>: Call: 0xffffbfd8
?Debug : Sep 04 18:04:31 DBCtx: SQL query: UPDATE messages SET recv_date='1125842671' WHERE recv_date=0 AND receiver_id='1'
AND send_date>='1125842552' AND send_date<='1125842671'
?Debug : Sep 04 18:04:31 DBCtx: SQL SELECT query: SELECT id,sender_id,subject,message,send_date,recv_date FROM messages WHERE
(receiver_id='1' OR is_for_all=1) AND send_date>='1125842552' AND send_date<='1125842671'
?Debug : Sep 04 18:04:31 RPCConn[SSL]<vans@172.19.33.100>: Call finished...
?Debug : Sep 04 18:05:18 BusClassif: aggregation timeout
?Debug : Sep 04 18:05:18 DBCtx: SQL SELECT query: SELECT qnt FROM downloaded WHERE is_deleted=0 AND downloaded_id='5' AND tcl
ass_id='10'
?Debug : Sep 04 18:05:18 DBCtx: SQL query: UPDATE downloaded SET qnt='79026868', discounted='0', downed_as_prepaid='79026868'
WHERE downloaded_id='5' AND tclass_id='10'
?Debug : Sep 04 18:05:18 UTM5 DBA: Discount:0.000000 p.u. for link:5 account 1
?Debug : Sep 04 18:05:18 UTM5 DBA: Checking for rehash: flags 3, balance 99.990 (old 99.990), credit 0.000
?Debug : Sep 04 18:05:18 DBAGiga: Rehash: Target: 10; Action: 1; Ptr: 4acf0f0
?Debug : Sep 04 18:05:18 HSPlugin: Rehash: Target: 10; Action: 1; Ptr: 4acf0f0
?Debug : Sep 04 18:05:18 Radius: Account '1': 99.990/0.000 send...
?Debug : Sep 04 18:05:18 DBCtx: SQL query: UPDATE accounts SET balance='99.9897' WHERE id = '1'
?Debug : Sep 04 18:05:18 DBCtx: SQL query: INSERT INTO discount_transactions_all(account_id,incoming_rest,outgoing_rest,disco
unt,discount_without_tax,discount_with_tax,service_id,service_type,slink_id,discount_date,comment,discount_period_id) VALUES(
'1','99.9897','99.9897','0','0','0','3','3','5','1125842718','IP discount','2')
?Debug : Sep 04 18:05:18 DBCtx: SQL SELECT query: SELECT balance FROM special_accounts WHERE id=2
?Debug : Sep 04 18:05:18 DBCtx: SQL query: UPDATE special_accounts SET balance='0' WHERE id=2
?Debug : Sep 04 18:05:18 DBCtx: SQL query: INSERT INTO special_transactions(date,incoming_rest,outgoing_rest,discount_transac
tion_id,transaction_type) VALUES('1125842718','0','0','207','2')
?Debug : Sep 04 18:05:18 DBCtx: SQL SELECT query: SELECT balance FROM special_accounts WHERE id=3
?Debug : Sep 04 18:05:18 DBCtx: SQL query: UPDATE special_accounts SET balance='2401.01' WHERE id=3
?Debug : Sep 04 18:05:18 DBCtx: SQL query: INSERT INTO special_transactions(date,incoming_rest,outgoing_rest,discount_transac
tion_id,transaction_type) VALUES('1125842718','2401.01','2401.01','207','3')
?Debug : Sep 04 18:05:18 BusLogic: BLM(37) pushed (comment: ruh block)
?Debug : Sep 04 18:05:18 BusLogic: try to execute 37
?Debug : Sep 04 18:05:18 BusLogic: hw_block_handler with code 37
?Debug : Sep 04 18:05:18 BusLogic: finished unknown
?Debug : Sep 04 18:05:18 DBCtx: SQL query: UPDATE dtagg_iptraffic SET discounted='0.000000',discounted_without_tax='0.000000'
, bytes='79026868.000000' WHERE id='7'
?Debug : Sep 04 18:05:18 DBCtx: SQL query: INSERT INTO discount_transactions_iptraffic_all(id,account_id,discount,discount_wi
th_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('207','1','0','0','3','5','1125842718','1125842400','1125777600','1125518400','10','0','-1408237
468','72740','2')
Если не появляются, то разработчикам нужно подумать, как перед удалением у пользозвателя ТП либо производилась проверка на наличие включенных в этом ТП услуг с выводом соотвествующих воплей, дабы администратора самостоятельно ручками повыключал все активные услуги, либо откоючение услуг производилось автоматически.
А подобным образом расплодившиеся расчетные периоды я удалял просто - выставлял дату окончания периода на ближайшие час-два, и они сами удалялись.
А подобным образом расплодившиеся расчетные периоды я удалял просто - выставлял дату окончания периода на ближайшие час-два, и они сами удалялись.