Совсем недавно столкнулся с UTM'ом, поэтому извиняюсь за, возможно, нелепые вопросы... Поиск по форуму к решению проблемы, к сожалению, не привел.
ОС с ядром: FreeBSD 6.2
Внезапно перестала работать админка. Вернее все открывается, но очень уж долго (минут 10 требуется для ее загрузки, а то и больше).
Вот, что пишется в логах:
debug.log:
?Debug : May 11 15:22:50 DBCtx: MySQL query failed:<The table 'discount_transactions_all' is full> Trying to reconnect: 0
?Debug : May 11 15:22:52 DBCtx: MySQL query failed:<The table 'discount_transactions_iptraffic_all' is full> Trying to reconnect: 1
?Debug : May 11 15:22:52 DBCtx: MySQL query failed:<The table 'discount_transactions_all' is full> Trying to reconnect: 1
?Debug : May 11 15:22:54 DBCtx: MySQL query failed:<The table 'discount_transactions_iptraffic_all' is full> Trying to reconnect: 2
?Debug : May 11 15:22:54 DBCtx: MySQL query failed:<The table 'discount_transactions_all' is full> Trying to reconnect: 2
?Debug : May 11 15:22:56 DBCtx: MySQL query failed:<The table 'discount_transactions_iptraffic_all' is full> Trying to reconnect: 3
?Debug : May 11 15:22:56 DBCtx: MySQL query failed:<The table 'discount_transactions_all' is full> Trying to reconnect: 3
?Debug : May 11 15:22:58 DBCtx: MySQL query failed:<The table 'discount_transactions_iptraffic_all' is full> Trying to reconnect: 4
?Debug : May 11 15:22:58 DBCtx: MySQL query failed:<The table 'discount_transactions_all' is full> Trying to reconnect: 4
ERROR : May 11 15:23:00 DBCtx: MySQL query failed:
ERROR : May 11 15:23:00 DBASQLError: MySQL query failed:
ERROR : May 11 15:23:00 DBCtx: Exception while doing SQL insert/update !
?Debug : May 11 15:23:00 DBCtx: SQL query: COMMIT
?Debug : May 11 15:23:00 DBCtx: DB transaction commit
?Debug : May 11 15:23:00 DBA:Ctx: Pushing back free context
-Stats : May 11 15:23:00 UTM5 DBA: Stats: Uptime: 00:00:20. Events: 0; Errors: 0
?Debug : May 11 15:23:00 BusClassif: aggregation interval reached for slink <280> ip <-1019338710> tclass <60>
?Debug : May 11 15:23:00 UTM5 DBA: DBAccess instance created
?Debug : May 11 15:23:00 DBA:Ctx: Looking for free context
?Debug : May 11 15:23:00 DBCtx: SQL query: BEGIN
?Debug : May 11 15:23:00 DBCtx: DB transaction begin
?Debug : May 11 15:23:00 DBCtx: SQL SELECT query: SELECT discounted,qnt,downed_as_prepaid FROM downloaded WHERE is_deleted=0 AND downloaded_id='174' AND tclass_id='60'
?Debug : May 11 15:23:00 DBCtx: SQL query: UPDATE downloaded SET qnt='1812721372', discounted='0', downed_as_prepaid='0' WHERE downloaded_id='174' AND tclass_id='60'
?Debug : May 11 15:23:00 UTM5 DBA: Discount:0.000000 p.u. for link:280 account 4
?Debug : May 11 15:23:00 UTM5 DBA: Checking for rehash: flags 3, balance 930459.573 (old 930459.573), credit 0.000
?Debug : May 11 15:23:00 Radius: Account '4': 930459.573/0.000 send...
?Debug : May 11 15:23:00 DBAGiga: Rehash: Target: 10; Action: 1; Ptr: beffba8c
?Debug : May 11 15:23:00 DBCtx: SQL query: UPDATE accounts SET balance='930459.5728379888' WHERE id = '4'
?Debug : May 11 15:23:00 DBCtx: SQL query: INSERT INTO discount_transactions_all(account_id,incoming_rest,outgoing_rest,discount,discount_without_tax,discount_with_tax,service_id,service_type,slink_id,discount_date,comment,discount_period_id) VALUES('4','930459.5728379888','930459.5728379888','0','0','0','62','3','280','1273576980','IP discount','406')
?Debug : May 11 15:23:00 DBCtx: MySQL query failed:<The table 'discount_transactions_all' is full> Trying to reconnect: 0
ERROR : May 11 15:23:00 DBCtx: MySQL query failed:
ERROR : May 11 15:23:00 DBASQLError: MySQL query failed:
ERROR : May 11 15:23:00 DBCtx: Exception while doing SQL insert/update !
?Debug : May 11 15:23:00 BusLogic: BLM(37) pushed (comment: ruh block)
?Debug : May 11 15:23:00 BusLogic: try to execute 37
?Debug : May 11 15:23:00 BusLogic: hw_block_handler with code 37
?Debug : May 11 15:23:00 BusLogic: finished unknown
?Debug : May 11 15:23:00 UTM5 DBA: discount_from_account tel zoneid <1000002> h.base_cost <0.000000>
?Debug : May 11 15:23:00 DBCtx: SQL query: UPDATE dtagg_telephony SET discounted='0.000000',discounted_without_tax='0.000000', duration='9544' WHERE id='83'
?Debug : May 11 15:23:00 Radius: edit_session_log id <50923> input octets <0> output octet <0>
?Debug : May 11 15:23:00 Radius: session log with id <50923> found in the cache
?Debug : May 11 15:23:00 DBCtx: SQL query: UPDATE tel_sessions_log SET account_id='25', slink_id='27', last_update_date='1273576980', Acct_Status_Type='2', Acct_Input_Packets ='0', Acct_Input_Octets ='0', Acct_Input_Gigawords ='0', Acct_Output_Packets ='0', Acct_Output_Octets ='0', Acct_Output_Gigawords ='0', h323_connect_time='', Acct_Terminate_Cause='0', h323_disconnect_cause='h323-disconnect-cause=10', Acct_Session_Time ='0' WHERE id='-1123083704'
?Debug : May 11 15:23:00 Radius: id2core removing key <50923>
?Debug : May 11 15:23:00 DBCtx: SQL query: INSERT INTO tel_sessions_detail(dhs_sess_id,disc_per_id,slink_id,recv_date,account_id,trange_id,duration,base_cost,sum_cost) VALUES('-1123083704','126','27','1273576980','25','1000002','0','0','0')
?Debug : May 11 15:23:00 DBCtx: MySQL query failed:<The table 'tel_sessions_detail' is full> Trying to reconnect: 0
?Debug : May 11 15:23:02 DBCtx: MySQL query failed:<The table 'discount_transactions_all' is full> Trying to reconnect: 1
main.log:
ERROR : May 11 15:24:20 DBCtx: Exception while doing SQL insert/update !
ERROR : May 11 15:24:21 DBCtx: MySQL query failed:
ERROR : May 11 15:24:21 DBASQLError: MySQL query failed:
ERROR : May 11 15:24:21 DBCtx: Exception while doing SQL insert/update !
ERROR : May 11 15:24:30 DBCtx: MySQL query failed:
ERROR : May 11 15:24:30 DBASQLError: MySQL query failed:
ERROR : May 11 15:24:30 DBCtx: Exception while doing SQL insert/update !
ERROR : May 11 15:24:31 DBCtx: MySQL query failed:
ERROR : May 11 15:24:31 DBASQLError: MySQL query failed:
ERROR : May 11 15:24:31 DBCtx: Exception while doing SQL insert/update !
ERROR : May 11 15:24:40 DBCtx: MySQL query failed:
ERROR : May 11 15:24:40 DBASQLError: MySQL query failed:
ERROR : May 11 15:24:40 DBCtx: Exception while doing SQL insert/update !
ERROR : May 11 15:24:41 DBCtx: MySQL query failed:
ERROR : May 11 15:24:41 DBASQLError: MySQL query failed:
ERROR : May 11 15:24:41 DBCtx: Exception while doing SQL insert/update !
ERROR : May 11 15:24:50 DBCtx: MySQL query failed:
ERROR : May 11 15:24:50 DBASQLError: MySQL query failed:
ERROR : May 11 15:24:50 DBCtx: Exception while doing SQL insert/update !
ERROR : May 11 15:24:51 DBCtx: MySQL query failed:
ERROR : May 11 15:24:51 DBASQLError: MySQL query failed:
ERROR : May 11 15:24:51 DBCtx: Exception while doing SQL insert/update !
ERROR : May 11 15:25:01 DBCtx: MySQL query failed:
ERROR : May 11 15:25:01 DBASQLError: MySQL query failed:
ERROR : May 11 15:25:01 DBCtx: Exception while doing SQL insert/update !
ERROR : May 11 15:25:01 DBCtx: MySQL query failed:
ERROR : May 11 15:25:01 DBASQLError: MySQL query failed:
ERROR : May 11 15:25:01 DBCtx: Exception while doing SQL insert/update !
verificator.log:
-- WARNING slink 370 exists only in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=370;
-- WARNING slink 370 exists only in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=370;
-- WARNING slink 370 exists only in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=370;
-- WARNING slink 370 exists only in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=370;
-- WARNING slink 372 exists only in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=372;
-- WARNING slink 373 exists only in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=373;
-- WARNING slink 373 exists only in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=373;
-- WARNING slink 374 exists only in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=374;
-- WARNING slink 374 exists only in dtagg_iptraffic
-- SQL DESC check slink exists and delete dtagg_iptraffic entry for deleted slink
UPDATE dtagg_iptraffic SET is_closed=1 WHERE slink_id=374;
-- WARNING lost IP group 263
-- SQL DESC delete ip group
UPDATE ip_groups SET is_deleted=1 WHERE ip_group_id='263';
-- 13 errors
-- 2208 warnings
-- affected tables: downloaded dtagg_iptraffic dtagg_once dtagg_periodic dtagg_telephony ip_groups
Подвисание админской панели
английский язык как?
?Debug : May 11 15:22:50 DBCtx: MySQL query failed:<The table 'discount_transactions_all' is full> Trying to reconnect: 0
?Debug : May 11 15:22:52 DBCtx: MySQL query failed:<The table 'discount_transactions_iptraffic_all' is full> Trying to reconnect: 1
и еще, залейте в базу verificator.log.
?Debug : May 11 15:22:50 DBCtx: MySQL query failed:<The table 'discount_transactions_all' is full> Trying to reconnect: 0
?Debug : May 11 15:22:52 DBCtx: MySQL query failed:<The table 'discount_transactions_iptraffic_all' is full> Trying to reconnect: 1
и еще, залейте в базу verificator.log.