ERROR : Jul 05 16:02:59 UTM5 DBA: DBAError throws in __discount_from_account(discount_info_iptraffic *): commit_ip_traffic_downloaded: bad database structure, more than one lines with downloaded_id=451 and tclass_id=20
ERROR : Jul 05 16:03:05 DBAInternalError: commit_ip_traffic_downloaded: bad database structure, more than one lines with downloaded_id=451 and tclass_id=20
ERROR : Jul 05 16:03:05 UTM5 DBA: DBAError throws in __discount_from_account(discount_info_iptraffic *): commit_ip_traffic_downloaded: bad database structure, more than one lines with downloaded_id=451 and tclass_id=20
ERROR : Jul 05 16:03:11 DBAInternalError: commit_ip_traffic_downloaded: bad database structure, more than one lines with downloaded_id=451 and tclass_id=20
ERROR : Jul 05 16:03:11 UTM5 DBA: DBAError throws in __discount_from_account(discount_info_iptraffic *): commit_ip_traffic_downloaded: bad database structure, more than one lines with downloaded_id=451 and tclass_id=20
ERROR : Jul 05 16:03:17 DBAInternalError: commit_ip_traffic_downloaded: bad database structure, more than one lines with downloaded_id=451 and tclass_id=20
ERROR : Jul 05 16:03:17 UTM5 DBA: DBAError throws in __discount_from_account(discount_info_iptraffic *): commit_ip_traffic_downloaded: bad database structure, more than one lines with downloaded_id=451 and tclass_id=20
ERROR : Jul 05 16:03:23 DBAInternalError: commit_ip_traffic_downloaded: bad database structure, more than one lines with downloaded_id=451 and tclass_id=20
ERROR : Jul 05 16:03:23 UTM5 DBA: DBAError throws in __discount_from_account(discount_info_iptraffic *): commit_ip_traffic_downloaded: bad database structure, more than one lines with downloaded_id=451 and tclass_id=20
Это достаточно критичная проблема. Мы рекомендуем при выключенном ядре
UTM5
сделать резерную копию БД UTM5, а затем пометить удаленными
(is_deleted=1) в
БД все строчки, кроме одной, относящиеся к downloaded_id=1 and
tclass_id=20
в таблице downloaded. После чего запустить UTM5.
P.S. Напоминаем, что наша компания не может гарантировать
работоспособность
биллинга при внесении изменений в БД. При возникновении проблем
восстановите БД из
резервной копии.
SELECT `downloaded_id`, `tclass_id`, COUNT(*) AS count FROM `downloaded` WHERE `is_deleted`
= 0 GROUP BY `downloaded_id`, `tclass_id` HAVING count > 1;
Это достаточно критичная проблема. Мы рекомендуем при выключенном ядре
UTM5
сделать резерную копию БД UTM5, а затем пометить удаленными
(is_deleted=1) в
БД все строчки, кроме одной, относящиеся к downloaded_id=1 and
tclass_id=20
в таблице downloaded. После чего запустить UTM5.
P.S. Напоминаем, что наша компания не может гарантировать
работоспособность
биллинга при внесении изменений в БД. При возникновении проблем
восстановите БД из
резервной копии.
SELECT `downloaded_id`, `tclass_id`, COUNT(*) AS count FROM `downloaded` WHERE `is_deleted`
= 0 GROUP BY `downloaded_id`, `tclass_id` HAVING count > 1;
ERROR : Jul 06 09:42:29 DBAExistingError: trying to get unexist link 0
ERROR : Jul 06 09:42:29 Radius: Exception couthed while sending ip information
ERROR : Jul 06 09:42:29 DBAExistingError: trying to get unexist link 0
ERROR : Jul 06 09:42:29 Radius: Exception couthed while sending ip information
ERROR : Jul 06 09:42:29 DBAExistingError: trying to get unexist link 0
ERROR : Jul 06 09:42:29 Radius: Exception couthed while sending ip information
ERROR : Jul 06 09:42:29 DBAExistingError: trying to get unexist link 0
ERROR : Jul 06 09:42:29 Radius: Exception couthed while sending ip information
ERROR : Jul 06 09:42:29 DBAExistingError: trying to get unexist link 0
ERROR : Jul 06 09:42:29 Radius: Exception couthed while sending ip information
ERROR : Jul 06 09:42:29 DBAExistingError: trying to get unexist link 0
ERROR : Jul 06 09:42:29 Radius: Exception couthed while sending ip information
ERROR : Jul 06 09:42:29 DBAExistingError: trying to get unexist link 0
ERROR : Jul 06 09:42:29 Radius: Exception couthed while sending ip information
ERROR : Jul 06 09:42:29 DBAExistingError: trying to get unexist link 0
ERROR : Jul 06 09:42:29 Radius: Exception couthed while sending ip information
ERROR : Jul 06 09:42:29 DBAExistingError: trying to get unexist link 0
ERROR : Jul 06 09:42:29 Radius: Exception couthed while sending ip information
*ALERT : Jul 06 09:57:38 UTM5 DBA: IP <10.189.0.75> linked in the database but not exist in IPTree (1 intersections in ip_groups table)
*ALERT : Jul 06 09:57:38 UTM5 DBA: IP <10.189.2.5> linked in the database but not exist in IPTree (1 intersections in ip_groups table)
*ALERT : Jul 06 09:57:38 UTM5 DBA: IP <80.67.###.###> linked in the database but not exist in IPTree (1 intersections in ip_groups table)
*ALERT : Jul 06 09:57:38 UTM5 DBA: IP <80.67.###.###> linked in the database but not exist in IPTree (1 intersections in ip_groups table)
*ALERT : Jul 06 09:57:38 UTM5 DBA: IP <10.189.0.75> linked in the database but not exist in IPTree (1 intersections in ip_groups table)
*ALERT : Jul 06 09:57:38 UTM5 DBA: IP <10.189.2.5> linked in the database but not exist in IPTree (1 intersections in ip_groups table)
*ALERT : Jul 06 09:57:38 UTM5 DBA: IP <80.67.###.###> linked in the database but not exist in IPTree (1 intersections in ip_groups table)
*ALERT : Jul 06 09:57:38 UTM5 DBA: IP <80.67.###.###> linked in the database but not exist in IPTree (1 intersections in ip_groups table)
По всей видимости вы удалили не только дуюлирующие записи но и основные. Одна запись из двух всёже должна сохраниться.
ERROR : Sep 03 16:41:47 899d1ec0 DBAInternalError: commit_ip_traffic_downloaded: bad database structure, more than one lines with downloaded_id=1026 and tclass_id=1000
ERROR : Sep 03 16:41:47 899d1ec0 UTM5 DBA: DBAError throws in __discount_from_account(discount_info_iptraffic *): commit_ip_traffic_downloaded: bad database structure, more than one lines with downloaded_id=
1026 and tclass_id=1000
Подскажите пожалуйста конкретный запрос на исправление данной петрушки