Хелп((( Подвисает админка... непонятная ошибка...

Технические вопросы по UTM 5.0
Ответить
Davion
Сообщения: 267
Зарегистрирован: Чт дек 01, 2005 13:36

Хелп((( Подвисает админка... непонятная ошибка...

Сообщение Davion »

После непредвиденого ночного зависания серва начала подтормаживать админка...
Вот что нашел в дебаге...

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

 ERROR &#58; Dec 16 09&#58;58&#58;33 DBCtx&#58; <155314072> MySQL query failed&#58; 
 ERROR &#58; Dec 16 09&#58;58&#58;33 DBASQLError&#58; MySQL query failed&#58; 
?Trace &#58; Dec 16 09&#58;58&#58;33 trace&#58; Obtained 16 stack frames.
?Trace &#58; Dec 16 09&#58;58&#58;33 trace&#58; /netup/utm5/bin/utm5_core&#40;_Z15print_backtracev+0x22&#41; &#91;0x837cf12&#93;

?Trace &#58; Dec 16 09&#58;58&#58;33 trace&#58; /netup/utm5/bin/utm5_core&#40;_ZN3UTM8DBAErrorC2ERKSsS2_+0x50&#41; &#91;0x81dd330&#93;

?Trace &#58; Dec 16 09&#58;58&#58;33 trace&#58; /netup/utm5/bin/utm5_core&#40;_ZN3UTM11DBASQLErrorC1ESs+0x47&#41; &#91;0x81dd5e7&#93;

?Trace &#58; Dec 16 09&#58;58&#58;33 trace&#58; /netup/utm5/bin/utm5_core&#40;_ZN3UTM12DBACtx_mysql11_sql_insertERKSsRNS_12sql_result_tE+0x164&#41; &#91;0x836cfd4&#93;

?Trace &#58; Dec 16 09&#58;58&#58;33 trace&#58; /netup/utm5/bin/utm5_core&#40;_ZN3UTM6DBACtx10sql_insertERKSsRNS_12sql_result_tE+0xa7&#41; &#91;0x81e7377&#93;

?Trace &#58; Dec 16 09&#58;58&#58;33 trace&#58; /netup/utm5/bin/utm5_core&#40;_ZN3UTM8DBAClass10sql_insertERKSsRNS_12sql_result_tE+0x26&#41; &#91;0x81e7436&#93;

?Trace &#58; Dec 16 09&#58;58&#58;33 trace&#58; /netup/utm5/bin/utm5_core&#40;_ZN3UTM8DBAccess10raw_sql_iuEPKcPNS_12sql_result_tE+0x49&#41; &#91;0x81e7499&#93;

?Trace &#58; Dec 16 09&#58;58&#58;33 trace&#58; /netup/utm5/bin/utm5_core&#40;_ZN3UTM8DBAccess18sql_dhs_access_putERKNS_14dhs_access_logE+0x1ba&#41; &#91;0x82571da&#93;

?Trace &#58; Dec 16 09&#58;58&#58;33 trace&#58; /netup/utm5/lib/utm5_radius/liburfa-radius.so&#40;_ZN3UTM8DBAccess14dhs_access_putERKNS_14dhs_access_logE+0x3f&#41; &#91;0x79490f&#93;

?Trace &#58; Dec 16 09&#58;58&#58;33 trace&#58; /netup/utm5/lib/utm5_radius/liburfa-radius.so&#40;_ZN6Radius12RadiusPlugin14put_access_logERN3UTM7MessageERSt6vectorIS2_SaIS2_EE+0x185&#41; &#91;0x764de5&#93;

?Trace &#58; Dec 16 09&#58;58&#58;33 trace&#58; /netup/utm5/lib/utm5_radius/liburfa-radius.so&#40;_ZN6Radius12RadiusPlugin6handleERN3UTM7MessageERSt6vectorIS2_SaIS2_EE+0x1c5&#41; &#91;0x766135&#93;

?Trace &#58; Dec 16 09&#58;58&#58;33 trace&#58; /netup/utm5/bin/utm5_core&#40;_ZN3UTM16StreamConnection4mainEv+0x235&#41; &#91;0x83541b5&#93;

?Trace &#58; Dec 16 09&#58;58&#58;33 trace&#58; /netup/utm5/bin/utm5_core&#40;_ZN3UTM16StreamConnection3runEv+0x5e&#41; &#91;0x83550fe&#93;

?Trace &#58; Dec 16 09&#58;58&#58;33 trace&#58; /netup/utm5/bin/utm5_core&#40;_ZN3UTM8Runnable6threadEPv+0x1a&#41; &#91;0x837d18a&#93;

?Trace &#58; Dec 16 09&#58;58&#58;33 trace&#58; /lib/libpthread.so.0 &#91;0x98249b&#93;

?Trace &#58; Dec 16 09&#58;58&#58;33 trace&#58; /lib/libc.so.6&#40;clone+0x5e&#41; &#91;0x8d942e&#93;

 ERROR &#58; Dec 16 09&#58;58&#58;33 DBCtx&#58; Exception while doing SQL insert/update ! 
Хелп что делать((([/code]

Davion
Сообщения: 267
Зарегистрирован: Чт дек 01, 2005 13:36

Сообщение Davion »

и походу дела не все впн сесии попадают в отчеты билинга..

Davion
Сообщения: 267
Зарегистрирован: Чт дек 01, 2005 13:36

Сообщение Davion »

:roll: починил
mysql> CHECK TABLE dhs_access_log;
+---------------------+-------+----------+-------------------------------------
--------------------+
| Table | Op | Msg_type | Msg_text
|
+---------------------+-------+----------+-------------------------------------
--------------------+
| utm5.dhs_access_log | check | warning | 8 clients are using or haven't close
the table properly |
| utm5.dhs_access_log | check | warning | Size of datafile is: 91707008
hould be: 91706964 |
| utm5.dhs_access_log | check | error | Found 2080750 keys of 2080749
|
| utm5.dhs_access_log | check | error | Corrupt
|
+---------------------+-------+----------+-------------------------------------
--------------------+
4 rows in set (0.73 sec)

mysql> REPAIR TABLE dhs_access_log;
+---------------------+--------+----------+------------------------------------
-----------+
| Table | Op | Msg_type | Msg_text
|
+---------------------+--------+----------+------------------------------------
-----------+
| utm5.dhs_access_log | repair | warning | Number of rows changed from 2080749
to 2080750 |
| utm5.dhs_access_log | repair | status | OK
|
+---------------------+--------+----------+------------------------------------
-----------+
2 rows in set (5.70 sec)

Ответить