Упала база, пропала часть сервисов. Вернул обратно.
Если сервисы удалены (is_deleted) - стартует нормально. При восстановлении - вываливается с указанным ниже логом (окончание, при "удалённых до этого места практически то же самое).
?Debug : Mar 17 00:26:00 DBCtx: <138740656> SQL SELECT query: SELECT id,vendor,attr,value FROM radius_data WHERE owner_id='59777' AND owner_type='10000'
?Debug : Mar 17 00:26:00 DBA_IPgroups: IPtree deleting ip <169283038> mask <-1> for slink <59777> ip_from <0>
?Debug : Mar 17 00:26:00 DBA_IPgroups: IPtree adding ip <169283038> mask <-1> for slink <59777> ip_from <0>
?Debug : Mar 17 00:26:00 DBCtx: <138740656> SQL SELECT query: SELECT id,cost,drop_from_group FROM once_service_data WHERE is_deleted=0
?Debug : Mar 17 00:26:00 DBCtx: <138740656> SQL SELECT query: SELECT id,discount_date FROM once_service_links WHERE is_deleted=0
?Debug : Mar 17 00:26:00 DBCtx: <138740656> SQL SELECT query: SELECT id FROM tel_service_links WHERE is_deleted='0'
?Debug : Mar 17 00:26:00 DBCtx: <138740656> SQL SELECT query: SELECT tariff_id, service_id FROM tariffs_services_link WHERE is_deleted=0
ERROR : Mar 17 00:26:00 DBAExistingError: trying to get not existing ip traffic service 8
?Trace : Mar 17 00:26:00 trace: Obtained 12 stack frames.
?Trace : Mar 17 00:26:00 trace: /netup/utm5/bin/utm5_core(_Z15print_backtracev+0x1d) [0x830ecc5]
?Trace : Mar 17 00:26:00 trace: /netup/utm5/bin/utm5_core(_ZN3UTM8DBAErrorC2ERKSsS2_+0x40) [0x81aa28c]
?Trace : Mar 17 00:26:00 trace: /netup/utm5/bin/utm5_core(_ZN3UTM16DBAExistingErrorC1ESs+0x36) [0x81a867e]
?Trace : Mar 17 00:26:00 trace: /netup/utm5/bin/utm5_core(_ZN3UTM8DBAccess21get_iptraffic_serviceEi+0x7e) [0x81ba786]
?Trace : Mar 17 00:26:00 trace: /netup/utm5/bin/utm5_core(_ZN3UTM8DBAccess24__fill_downed_as_prepaidEv+0x85) [0x81f5b21]
?Trace : Mar 17 00:26:00 trace: /netup/utm5/bin/utm5_core(_ZN3UTM8DBAccess18fill_mega_storagesEv+0x152) [0x81a546a]
?Trace : Mar 17 00:26:00 trace: /netup/utm5/bin/utm5_core(_ZN3UTM8DBAccess11dbamod_initEPNS_6ModTopES2_+0x40) [0x81a4db8]
?Trace : Mar 17 00:26:00 trace: /netup/utm5/bin/utm5_core(_ZN3UTM6ModTop4initEPS0_+0x33) [0x81a862b]
?Trace : Mar 17 00:26:00 trace: /netup/utm5/bin/utm5_core(_ZN3UTM6ModMap7sub_putEPNS_6ModTopE+0x137) [0x81a7477]
?Trace : Mar 17 00:26:00 trace: /netup/utm5/bin/utm5_core(main+0x7cb) [0x82b4be3]
?Trace : Mar 17 00:26:00 trace: /lib/tls/libc.so.6(__libc_start_main+0xd3) [0x351de3]
?Trace : Mar 17 00:26:00 trace: /netup/utm5/bin/utm5_core(dlopen+0x41) [0x81a4bd9]
-Stats : Mar 17 00:26:00 DBA Groups: Stats: Uptime: 00:00:11. Events: 0; Errors: 0
*ALERT : Mar 17 00:26:00 UTM5 DBA: Exception caught on startup. See debug log for detail
*ALERT : Mar 17 00:26:00 UTM5 DBA: Exception caught on startup. See debug log for detail
*CRIT : Mar 17 00:26:00 UTM5 Core: ModMap fatal init exception. Aborting
*CRIT : Mar 17 00:26:00 UTM5 Core: ModMap fatal init exception. Aborting
в verificator.log последнее:
-- ERROR unexpected row in iptraffic_service_links with id 23952
-- SQL DESC delete row (NOT RECOMMENDED)
-- UPDATE iptraffic_service_links SET is_deleted=1 WHERE id='23952';
есть мысль что чего-то где-то не хватает.
Ошибка 'trying to get not existing ip traffic service'
проверьте все таблички :
tariffs_services_link
services_data
periodic_services_data
iptraffic_services_data
dialup_services_data
hotspot_services_data
tel_services_data
once_services_data
в них вернуть is_deleted=0 везде где стало is_deleted=1 для сервисной связки
ip traffic service 8
tariffs_services_link
services_data
periodic_services_data
iptraffic_services_data
dialup_services_data
hotspot_services_data
tel_services_data
once_services_data
в них вернуть is_deleted=0 везде где стало is_deleted=1 для сервисной связки
ip traffic service 8
ERROR : Mar 17 00:26:00 DBAExistingError: trying to get not existing ip traffic service 8
