포럼
DB Error가 나면서 서버가 2시간마다 한번씩 다운이 됩니다.
2013.06.29 06:10
지난 두 주일 전부터 웹사이트가 아래와 같은 DB 에러가 나오면서 열리지를 않습니다. 또한, 호스팅에 전화를 걸어서 서버를 재 부팅하면 웹사이트가 정상가동합니다. 같은 서버에 있는 다른 웹사이트도 열리지 않는 것으로 보아 아래의 에러가 나옴과 동시에 서버가 다운이 되는 것 같은데, 문제는 이런 일들이 매 한두시간 간격으로 일어나는데 있습니다.
호스팅 관계자들은 데이터베이스 스크립트에서 문제가 있어서 개발자가 손을 보아야 한다고 하고, 개발을 도와 주시는 분은 DB 스크립이나 테이블은 아무런 문제가 없다고 합니다. 이런 경우는 어떻게 해야 할지 정말 답답합니다. 고수들께 급 조언을 부탁드립니다.
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/churchwe/public_html/classes/db/DBMysql.class.php on line 139
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/churchwe/public_html/classes/db/DBMysql.class.php on line 141
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/churchwe/public_html/classes/db/DBMysql.class.php on line 139
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/churchwe/public_html/classes/db/DBMysql.class.php on line 141
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/churchwe/public_html/classes/db/DBMysql.class.php on line 139
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/churchwe/public_html/classes/db/DBMysql.class.php on line 141
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/churchwe/public_html/classes/db/DBMysql.class.php on line 139
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/churchwe/public_html/classes/db/DBMysql.class.php on line 141
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/churchwe/public_html/classes/db/DBMysql.class.php on line 139
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/churchwe/public_html/classes/db/DBMysql.class.php on line 141
Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/churchwe/public_html/classes/db/DBMysql.class.php:139) in /home/churchwe/public_html/classes/context/Context.class.php on line 143
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/churchwe/public_html/classes/db/DBMysql.class.php on line 139
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/churchwe/public_html/classes/db/DBMysql.class.php on line 141
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/churchwe/public_html/classes/db/DBMysql.class.php on line 139
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/churchwe/public_html/classes/db/DBMysql.class.php on line 141
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/churchwe/public_html/classes/db/DBMysql.class.php on line 139
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/churchwe/public_html/classes/db/DBMysql.class.php on line 141
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/churchwe/public_html/classes/db/DBMysql.class.php on line 139
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/churchwe/public_html/classes/db/DBMysql.class.php on line 141
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/churchwe/public_html/classes/db/DBMysql.class.php on line 139
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/churchwe/public_html/classes/db/DBMysql.class.php on line 141
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/churchwe/public_html/classes/db/DBMysql.class.php on line 139
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/churchwe/public_html/classes/db/DBMysql.class.php on line 141
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/churchwe/public_html/classes/db/DBMysql.class.php on line 139
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/churchwe/public_html/classes/db/DBMysql.class.php on line 141
Warning: Cannot modify header information - headers already sent by (output started at /home/churchwe/public_html/classes/db/DBMysql.class.php:139) in /home/churchwe/public_html/modules/message/message.view.php on line 21
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/churchwe/public_html/classes/db/DBMysql.class.php on line 139
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/churchwe/public_html/classes/db/DBMysql.class.php on line 141
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/churchwe/public_html/classes/db/DBMysql.class.php on line 139
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/churchwe/public_html/classes/db/DBMysql.class.php on line 141
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/churchwe/public_html/classes/db/DBMysql.class.php on line 139
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/churchwe/public_html/classes/db/DBMysql.class.php on line 141
Warning: Cannot modify header information - headers already sent by (output started at /home/churchwe/public_html/classes/db/DBMysql.class.php:139) in /home/churchwe/public_html/modules/message/message.view.php on line 21
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/churchwe/public_html/classes/db/DBMysql.class.php on line 139
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/churchwe/public_html/classes/db/DBMysql.class.php on line 141
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/churchwe/public_html/classes/db/DBMysql.class.php on line 139
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/churchwe/public_html/classes/db/DBMysql.class.php on line 141
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/churchwe/public_html/classes/db/DBMysql.class.php on line 139
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/churchwe/public_html/classes/db/DBMysql.class.php on line 141
Warning: Cannot modify header information - headers already sent by (output started at /home/churchwe/public_html/classes/db/DBMysql.class.php:139) in /home/churchwe/public_html/classes/display/DisplayHandler.class.php on line 62
Warning: Cannot modify header information - headers already sent by (output started at /home/churchwe/public_html/classes/db/DBMysql.class.php:139) in /home/churchwe/public_html/classes/display/DisplayHandler.class.php on line 267
Warning: Cannot modify header information - headers already sent by (output started at /home/churchwe/public_html/classes/db/DBMysql.class.php:139) in /home/churchwe/public_html/classes/display/DisplayHandler.class.php on line 77
Warning: Cannot modify header information - headers already sent by (output started at /home/churchwe/public_html/classes/db/DBMysql.class.php:139) in /home/churchwe/public_html/classes/display/DisplayHandler.class.php on line 77
Sorry!
404
Not Found
DB 접속 오류가 발생했습니다.
DB정보를 다시 확인해주세요.
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/churchwe/public_html/classes/db/DBMysql.class.php on line 139
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/churchwe/public_html/classes/db/DBMysql.class.php on line 141
댓글 4
-
Lansi
2013.06.30 02:22
-
트랙백 공격 받으시나요?
-
아래 내용 참조 (출처 : "왕초보를 위한 XE사용설명서" 중 발췌)1) 테이블 최적화MyISAM을 사용할 때 phpMyAdmin으로 데이타베이스에 접속해보면 테이블에 OverHead가 생긴 것을 볼 수 있다.
이는 데이타 삭제 등으로 테이블에 빈 공간이 생긴 것으로 속도에 영향을 줄 뿐만 아니라 심하면 데이타베이스가 다운되므로 주기적으로 최적화 해주어야 한다.
하단의 "Check table having overhead"를 클릭하면 오버헤드가 생긴 테이블만 선택된다. "With selected:" 에서 "Optimize table"을 선택하면 테이블이 최적화된다
-
초보개발자
2013.07.02 03:03
고수님들의 조언에 감사를 드립니다.
푸시아님의 예상대로 문제는 트랙백 공격에서 부터 시작된 것 같습니다. 몇 주 전에 제가 가지고 있던 모든 웹사이트의 게시판에 하루에도 몇천개씩의 트랙백이 쌓이면서 문제가 된것 같네요. 일단 Mysql에서 모든 트랙백을 제거하고 트랙백을 차단까진 했는데, 다음 문제는 DB가 수시로 다운이 되는 것입니다.
위즈님의 말씀대로 DB 최적화가 필요할 것 같고요, 데이터센터의 의견으로는 Lansi님의 예상대로 트랙백 공격이후 램부족 현상이 일어났답니다.
현제 상황은 가지고 있는 호스팅 서버를 업그레이드 하는 작업에 착수 했습니다. 결과가 나오는 데로 다시 알려드리겠습니다. 여러 고수님들의 조언에 거듭 감사를 드립니다.
재부팅 해서 되면 램 부족일수도 있겠네요
저는 아파치 서버가 일정 간격으로 죽어서 결국 재설치 했는데 잘 되더군요