| 제목 | 처음 보는 현상인데 한번 봐주세요 | ||
|---|---|---|---|
| 글쓴이 | 조주상 | 작성시각 | 2014/08/01 13:59:32 |
|
|
|||
|
어제 갑자기 DB서버에 접속이 안되는 증상이 생겨서 오늘 로그를 확인해보니 아래처럼 증상이 나타났습니다. 해당 주소는 자카르타로 나오고 아래처럼 로그가 발생됬습니다. 동시에 저렇게 에러가 발생되니 디비에서 차단을 해서 해당 서비스가 완전히 중단 되서 한시간동안 문제가 생겼었네요 혹시 이런 현상이 뭔지 알고 계신분 계신가요 ㅠㅠ 혹은 이런식의 문제가 생기면 차단하는 것이 잇을까요 INFO - 2014-07-31 20:37:07 --> Validation Page --------------------------------------------- INFO - 2014-07-31 20:37:07 --> user- ip : 114.124.x.xx INFO - 2014-07-31 20:37:07 --> user_agent : 앱 이름 (iPad; iPhone OS 5.1.1; id_ID) DEBUG - 2014-07-31 20:37:20 --> Final output sent to browser DEBUG - 2014-07-31 20:37:20 --> Total execution time: 376.9427 DEBUG - 2014-07-31 20:37:29 --> Utf8 Class Initialized DEBUG - 2014-07-31 20:37:29 --> Model Class Initialized DEBUG - 2014-07-31 20:37:29 --> Utf8 Class Initialized DEBUG - 2014-07-31 20:37:29 --> Utf8 Class Initialized DEBUG - 2014-07-31 20:37:29 --> Utf8 Class Initialized DEBUG - 2014-07-31 20:37:29 --> Utf8 Class Initialized DEBUG - 2014-07-31 20:37:29 --> Utf8 Class Initialized DEBUG - 2014-07-31 20:37:29 --> Utf8 Class Initialized DEBUG - 2014-07-31 20:37:29 --> Utf8 Class Initialized DEBUG - 2014-07-31 20:37:29 --> Utf8 Class Initialized DEBUG - 2014-07-31 20:37:29 --> Utf8 Class Initialized DEBUG - 2014-07-31 20:37:29 --> Utf8 Class Initialized DEBUG - 2014-07-31 20:37:29 --> Utf8 Class Initialized DEBUG - 2014-07-31 20:37:29 --> UTF-8 Support Enabled DEBUG - 2014-07-31 20:37:29 --> UTF-8 Support Enabled DEBUG - 2014-07-31 20:37:29 --> UTF-8 Support Enabled DEBUG - 2014-07-31 20:37:29 --> UTF-8 Support Enabled DEBUG - 2014-07-31 20:37:29 --> UTF-8 Support Enabled DEBUG - 2014-07-31 20:37:29 --> UTF-8 Support Enabled DEBUG - 2014-07-31 20:37:29 --> UTF-8 Support Enabled DEBUG - 2014-07-31 20:37:29 --> UTF-8 Support Enabled DEBUG - 2014-07-31 20:37:29 --> UTF-8 Support Enabled DEBUG - 2014-07-31 20:37:29 --> UTF-8 Support Enabled DEBUG - 2014-07-31 20:37:29 --> UTF-8 Support Enabled DEBUG - 2014-07-31 20:37:29 --> UTF-8 Support Enabled DEBUG - 2014-07-31 20:38:08 --> URI Class Initialized DEBUG - 2014-07-31 20:38:08 --> URI Class Initialized DEBUG - 2014-07-31 20:38:08 --> URI Class Initialized DEBUG - 2014-07-31 20:38:08 --> URI Class Initialized DEBUG - 2014-07-31 20:38:08 --> URI Class Initialized DEBUG - 2014-07-31 20:38:08 --> URI Class Initialized DEBUG - 2014-07-31 20:38:08 --> URI Class Initialized DEBUG - 2014-07-31 20:38:08 --> URI Class Initialized DEBUG - 2014-07-31 20:38:08 --> URI Class Initialized DEBUG - 2014-07-31 20:38:08 --> Model Class Initialized DEBUG - 2014-07-31 20:38:08 --> URI Class Initialized DEBUG - 2014-07-31 20:38:09 --> URI Class Initialized DEBUG - 2014-07-31 20:38:09 --> URI Class Initialized DEBUG - 2014-07-31 20:38:09 --> Router Class Initialized DEBUG - 2014-07-31 20:38:09 --> Router Class Initialized DEBUG - 2014-07-31 20:38:09 --> Router Class Initialized DEBUG - 2014-07-31 20:38:09 --> Router Class Initialized DEBUG - 2014-07-31 20:38:09 --> Router Class Initialized DEBUG - 2014-07-31 20:38:09 --> Router Class Initialized DEBUG - 2014-07-31 20:38:09 --> Router Class Initialized DEBUG - 2014-07-31 20:38:09 --> Router Class Initialized DEBUG - 2014-07-31 20:38:09 --> Router Class Initialized DEBUG - 2014-07-31 20:38:09 --> Router Class Initialized DEBUG - 2014-07-31 20:38:09 --> Router Class Initialized DEBUG - 2014-07-31 20:38:10 --> Router Class Initialized DEBUG - 2014-07-31 20:38:10 --> Output Class Initialized DEBUG - 2014-07-31 20:38:10 --> Output Class Initialized DEBUG - 2014-07-31 20:38:10 --> Output Class Initialized DEBUG - 2014-07-31 20:38:10 --> Output Class Initialized DEBUG - 2014-07-31 20:38:10 --> Output Class Initialized DEBUG - 2014-07-31 20:38:10 --> Output Class Initialized DEBUG - 2014-07-31 20:38:10 --> Output Class Initialized DEBUG - 2014-07-31 20:38:10 --> Output Class Initialized DEBUG - 2014-07-31 20:38:10 --> Output Class Initialized DEBUG - 2014-07-31 20:38:17 --> Output Class Initialized DEBUG - 2014-07-31 20:38:17 --> Output Class Initialized DEBUG - 2014-07-31 20:38:17 --> Security Class Initialized DEBUG - 2014-07-31 20:38:17 --> Security Class Initialized DEBUG - 2014-07-31 20:38:17 --> Security Class Initialized DEBUG - 2014-07-31 20:38:17 --> Security Class Initialized DEBUG - 2014-07-31 20:38:17 --> Security Class Initialized DEBUG - 2014-07-31 20:38:17 --> Security Class Initialized DEBUG - 2014-07-31 20:38:17 --> Security Class Initialized DEBUG - 2014-07-31 20:38:17 --> Security Class Initialized DEBUG - 2014-07-31 20:38:17 --> Security Class Initialized DEBUG - 2014-07-31 20:38:17 --> Security Class Initialized DEBUG - 2014-07-31 20:38:17 --> Security Class Initialized DEBUG - 2014-07-31 20:38:17 --> Output Class Initialized DEBUG - 2014-07-31 20:38:17 --> Security Class Initialized DEBUG - 2014-07-31 20:38:17 --> Input Class Initialized DEBUG - 2014-07-31 20:38:17 --> Input Class Initialized DEBUG - 2014-07-31 20:38:17 --> Input Class Initialized DEBUG - 2014-07-31 20:38:17 --> Input Class Initialized DEBUG - 2014-07-31 20:38:17 --> Input Class Initialized DEBUG - 2014-07-31 20:38:17 --> Input Class Initialized DEBUG - 2014-07-31 20:38:17 --> Input Class Initialized DEBUG - 2014-07-31 20:38:17 --> Input Class Initialized DEBUG - 2014-07-31 20:38:17 --> Input Class Initialized DEBUG - 2014-07-31 20:38:17 --> Input Class Initialized DEBUG - 2014-07-31 20:38:17 --> Input Class Initialized DEBUG - 2014-07-31 20:38:17 --> Global POST and COOKIE data sanitized DEBUG - 2014-07-31 20:38:17 --> Global POST and COOKIE data sanitized DEBUG - 2014-07-31 20:38:17 --> Global POST and COOKIE data sanitized DEBUG - 2014-07-31 20:38:17 --> Global POST and COOKIE data sanitized DEBUG - 2014-07-31 20:38:17 --> Global POST and COOKIE data sanitized DEBUG - 2014-07-31 20:38:17 --> Global POST and COOKIE data sanitized DEBUG - 2014-07-31 20:38:17 --> Global POST and COOKIE data sanitized DEBUG - 2014-07-31 20:38:17 --> Global POST and COOKIE data sanitized DEBUG - 2014-07-31 20:38:17 --> Global POST and COOKIE data sanitized DEBUG - 2014-07-31 20:38:17 --> Global POST and COOKIE data sanitized DEBUG - 2014-07-31 20:38:17 --> Global POST and COOKIE data sanitized DEBUG - 2014-07-31 20:38:17 --> Language Class Initialized DEBUG - 2014-07-31 20:38:17 --> Language Class Initialized DEBUG - 2014-07-31 20:38:17 --> Language Class Initialized DEBUG - 2014-07-31 20:38:17 --> Language Class Initialized DEBUG - 2014-07-31 20:38:17 --> Language Class Initialized DEBUG - 2014-07-31 20:38:17 --> Language Class Initialized DEBUG - 2014-07-31 20:38:17 --> Language Class Initialized DEBUG - 2014-07-31 20:38:17 --> Language Class Initialized DEBUG - 2014-07-31 20:38:17 --> Language Class Initialized DEBUG - 2014-07-31 20:38:17 --> Language Class Initialized DEBUG - 2014-07-31 20:38:17 --> Language Class Initialized DEBUG - 2014-07-31 20:38:17 --> Input Class Initialized DEBUG - 2014-07-31 20:38:17 --> Global POST and COOKIE data sanitized DEBUG - 2014-07-31 20:38:17 --> Language Class Initialized DEBUG - 2014-07-31 20:38:18 --> Loader Class Initialized DEBUG - 2014-07-31 20:38:18 --> Loader Class Initialized DEBUG - 2014-07-31 20:38:18 --> Loader Class Initialized DEBUG - 2014-07-31 20:38:18 --> Controller Class Initialized DEBUG - 2014-07-31 20:38:18 --> Loader Class Initialized DEBUG - 2014-07-31 20:38:18 --> Controller Class Initialized DEBUG - 2014-07-31 20:38:18 --> Loader Class Initialized DEBUG - 2014-07-31 20:38:18 --> Loader Class Initialized DEBUG - 2014-07-31 20:38:18 --> Loader Class Initialized DEBUG - 2014-07-31 20:38:18 --> Loader Class Initialized DEBUG - 2014-07-31 20:38:18 --> Controller Class Initialized DEBUG - 2014-07-31 20:38:18 --> Controller Class Initialized DEBUG - 2014-07-31 20:38:18 --> Controller Class Initialized DEBUG - 2014-07-31 20:38:18 --> Controller Class Initialized DEBUG - 2014-07-31 20:38:18 --> Controller Class Initialized DEBUG - 2014-07-31 20:38:18 --> Loader Class Initialized DEBUG - 2014-07-31 20:38:18 --> Loader Class Initialized DEBUG - 2014-07-31 20:38:18 --> Loader Class Initialized DEBUG - 2014-07-31 20:38:18 --> Loader Class Initialized DEBUG - 2014-07-31 20:38:18 --> Controller Class Initialized DEBUG - 2014-07-31 20:38:18 --> Controller Class Initialized DEBUG - 2014-07-31 20:38:18 --> Controller Class Initialized DEBUG - 2014-07-31 20:38:18 --> Controller Class Initialized DEBUG - 2014-07-31 20:38:18 --> Controller Class Initialized DEBUG - 2014-07-31 20:38:18 --> Session Class Initialized DEBUG - 2014-07-31 20:38:18 --> Session Class Initialized DEBUG - 2014-07-31 20:38:18 --> Session Class Initialized DEBUG - 2014-07-31 20:38:18 --> Session Class Initialized DEBUG - 2014-07-31 20:38:18 --> Session Class Initialized DEBUG - 2014-07-31 20:38:18 --> Session Class Initialized DEBUG - 2014-07-31 20:38:18 --> Session Class Initialized DEBUG - 2014-07-31 20:38:18 --> Session Class Initialized DEBUG - 2014-07-31 20:38:18 --> Session Class Initialized DEBUG - 2014-07-31 20:38:18 --> Helper loaded: string_helper DEBUG - 2014-07-31 20:38:18 --> Helper loaded: string_helper DEBUG - 2014-07-31 20:38:18 --> Helper loaded: string_helper DEBUG - 2014-07-31 20:38:18 --> Helper loaded: string_helper DEBUG - 2014-07-31 20:38:18 --> Helper loaded: string_helper DEBUG - 2014-07-31 20:38:18 --> Helper loaded: string_helper DEBUG - 2014-07-31 20:38:18 --> Helper loaded: string_helper DEBUG - 2014-07-31 20:38:18 --> Helper loaded: string_helper DEBUG - 2014-07-31 20:38:18 --> Helper loaded: string_helper DEBUG - 2014-07-31 20:38:19 --> Database Driver Class Initialized DEBUG - 2014-07-31 20:38:19 --> Database Driver Class Initialized DEBUG - 2014-07-31 20:38:19 --> Database Driver Class Initialized DEBUG - 2014-07-31 20:38:19 --> Database Driver Class Initialized DEBUG - 2014-07-31 20:38:19 --> Database Driver Class Initialized DEBUG - 2014-07-31 20:38:19 --> Database Driver Class Initialized DEBUG - 2014-07-31 20:38:19 --> Database Driver Class Initialized DEBUG - 2014-07-31 20:38:19 --> Database Driver Class Initialized DEBUG - 2014-07-31 20:38:19 --> Database Driver Class Initialized DEBUG - 2014-07-31 20:38:19 --> Database Driver Class Initialized DEBUG - 2014-07-31 20:38:19 --> Database Driver Class Initialized DEBUG - 2014-07-31 20:38:19 --> Database Driver Class Initialized |
|||
| 다음글 | Ci가 아닌 클래스에서 config 값을 가져올 수 있... (2) | ||
| 이전글 | 서버가 데이터를 전송하지 않아 웹페이지를 로드할 수 없... (15) | ||
|
변종원(웅파)
/
2014/08/01 14:50:11 /
추천
0
|
|
조주상
/
2014/08/01 16:06:19 /
추천
0
변종원님 답변 감사합니다.
기존에 slow query 에 대해 로그를 기록하고 있지 않아서 오늘 로그하도록 넣었네요.. 혹시 저런 시도나 에러가 발생되면 바로 팅겨내거나 막을 수 있는 방법이 있을런지요.. 그리고 서버에 등록된 쿼리중에 어떠한 쿼리도 2초이상걸리는게 없는데 왜 갑자기 저렇게 됬을 까요 |
|
변종원(웅파)
/
2014/08/01 16:49:50 /
추천
0
sql injection일수도 있구요.
서버쪽 전문이 아니라서 확실하게 있는지는 모르겠지만 프로세스를 감시하면 될 거 같습니다. apache process가 몇초이상 실행되고 있으면 alert 혹은 그 프로세스 죽이기.. ^^ |
차단하더라도 slow query 문제라면 계속 발생할겁니다.
우선 slow query때문에 그런건지 불법시도때문인건지 파악을 하시는게 좋겠네요