게시판 제목 잘보고 올리세요 일반게시판에 홍보글 보이면 바로 회원 차단입니다
구인 분류

서버 에러 수정가능하실분 계실까요~!?

컨텐츠 정보

  • 273 조회
  • 2 댓글
  • 0 추천
  • 0 비추천
  • 목록

본문

안녕하세요. 현재 서버운영은 안하며 , 그냥 이것저것 테스트 해보고있는데 , 매번 동일한 에러가 뜹니다. 

뜰때마다 서버가 끊기는건 아닙니다. 다만 , 눈에 거슬릴뿐 해결이 가능하신분 연락 부탁드리며 사례금 드립니다.

에러 글 남겨드리겠습니다. 

9월 07, 2024 8:05:19 오전 l1j.server.server.model.L1PcInventory saveItem

심각: The last packet successfully received from the server was 46,809,591 milliseconds ago.  The last packet sent successfully to the server was 46,809,593 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 46,809,591 milliseconds ago.  The last packet sent successfully to the server was 46,809,593 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

at java.lang.reflect.Constructor.newInstance(Unknown Source)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)

at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)

at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3358)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1970)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)

at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:989)

at l1j.server.server.storage.mysql.MySqlCharactersItemStorage.executeUpdate(Unknown Source)

at l1j.server.server.storage.mysql.MySqlCharactersItemStorage.updateItemCount(Unknown Source)

at l1j.server.server.model.L1PcInventory.saveItem(Unknown Source)

at l1j.server.server.model.Instance.L1PcInstance.saveInventory(Unknown Source)

at server.threads.pc.AutoSaveThread.run(Unknown Source)

Caused by: java.net.SocketException: Software caused connection abort: socket write error

at java.net.SocketOutputStream.socketWrite0(Native Method)

at java.net.SocketOutputStream.socketWrite(Unknown Source)

at java.net.SocketOutputStream.write(Unknown Source)

at java.io.BufferedOutputStream.flushBuffer(Unknown Source)

at java.io.BufferedOutputStream.flush(Unknown Source)

at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3339)

... 11 more

관련자료

댓글 2
profile_image

나리비님의 댓글

MySQL 데이터베이스 연결 타임아웃 문제입니다.

주요 원인:
마지막 서버 통신 후 약 13시간(46,809,591ms) 동안 연결이 유휴 상태였음
서버의 'wait_timeout' 설정값을 초과하여 연결이 종료됨
전체 1,665 / 59 페이지
번호
제목
이름

개발의뢰

포인트 랭킹


알림 0