"Error establishing a database connection" error 는 어떻게 해결하나요.

TechNote Forum Forums Forum "Error establishing a database connection" error 는 어떻게 해결하나요.

Tagged: , ,

This topic contains 2 replies, has 3 voices, and was last updated by  kakao.q 1 year, 1 month ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #930

    technote
    Keymaster

    간혹 홈페이지에 들어와보면 “Error establishing a database connection ” 가 발생하는 경우가 있습니다.

    이런 에러는 왜 발생하고, 어떻게 해결하면 되나요?

    #931

    cefm****
    Participant

    언급한 error는 mysql error입니다. 정확한 error 는 mysql log를 확인하면 알 수 있습니다.

    로그 위치 : /var/log/mysql

     

    하나의 예를 보면 다음과 같습니다. 아래와 같은 경우는 memory 를 할당하지 못해 mysql 이 강제 종료 되었음을 알 수 있습니다.

    180815 22:11:40 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
    180815 22:11:40 [Note] Plugin ‘FEDERATED’ is disabled.
    180815 22:11:40 InnoDB: The InnoDB memory heap is disabled
    180815 22:11:40 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    180815 22:11:40 InnoDB: Compressed tables use zlib 1.2.8
    180815 22:11:40 InnoDB: Using Linux native AIO
    180815 22:11:40 InnoDB: Initializing buffer pool, size = 128.0M
    InnoDB: mmap(137363456 bytes) failed; errno 12
    180815 22:11:40 InnoDB: Completed initialization of buffer pool
    180815 22:11:40 InnoDB: Fatal error: cannot allocate memory for the buffer pool
    180815 22:11:40 [ERROR] Plugin ‘InnoDB’ init function returned error.
    180815 22:11:40 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.
    180815 22:11:40 [ERROR] Unknown/unsupported storage engine: InnoDB
    180815 22:11:40 [ERROR] Aborting

    180815 22:11:40 [Note] /usr/sbin/mysqld: Shutdown complete

    • This reply was modified 1 year, 1 month ago by  cefm****.
    #933

    kakao.q
    Participant
Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.