브렌쏭의 Veritas_Garage
MySQL && ELK #has not received any packets from the server 본문
[Project_만들다]/[Project_문제해결]
MySQL && ELK #has not received any packets from the server
브렌쏭 2022. 4. 24. 11:15The last packet sent successfully to the server was 0 milliseconds ago.
The driver has not received any packets from the server.
기절하겠네
찾아본 해결책
https://taepcsiandwe.tistory.com/entry/mysql-%EC%9B%90%EA%B2%A9%EC%A0%91%EC%86%8D-%EC%98%A4%EB%A5%98
bind-address 127.0.0.1 문제. 나는 mySQL을 도커에서 돌리고 있는데, 관련이 있을까? 내부적으로 같은 망이니 127이 맞을거 같긴 한데.
2011년 글이지만 서버라는게 그렇게 휙휙 바뀌던가.....
https://stackoverflow.com/questions/15949/javatomcat-dying-database-connection
자바를 사용하는 경우, Java의 autoReconnect=true, 로 바꾸면 된다고 하네.
어쨌든 ELK사용하던 중에 일어난 일이니까, 엘라스틱에 물어본다.
Are you sure that the jdbc_connection_string is correct? A communication link failure exception usually happens when jdbc is not able to connect at all.
This could be because of a TLS error, or your bind-address for your mysql server is not 0.0.0.0, your port is incorrect or not listening, your sql server is not running, a firewall is preventing external connections, and much more. You need to check all the basics first.
문제해결
docker-compose.yaml 파일의 경로설정에서 오타가 있었다. 미칠거같았는데 찾아보니 그냥 미친거 맞는거 같다
'[Project_만들다] > [Project_문제해결]' 카테고리의 다른 글
2020420, 문제해결 (0) | 2022.04.20 |
---|---|
Cannot return null.... (0) | 2022.04.18 |
나는 나는 무얼 놓쳤나 #20220411 (0) | 2022.04.12 |
Doesn't have default value.. (0) | 2022.04.11 |
Incorrect table definition; (0) | 2022.04.11 |
Cannot determine a GraphQL input type (0) | 2022.04.10 |
Comments