시스템 로그 시 오류
- 작성자 :
- 김*상
- 작성일 :
- 2016-02-19 00:08:03
- 조회수 :
- 3,004
- 구분 :
- 실행환경
- 진행상태 :
- 완료
Q
안녕하세요.
시스템 로그 시도시 오류가 발생하여 문의 드립니다.
로그는 아래와 같습니다.
감사합니다.
2016-02-19 00:00:43,300 DEBUG [egovframework.rte.fdl.idgnr.impl.EgovTableIdGnrService] [IDGeneration Service] Allocating a new block of 10 ids for key_table SYSLOG_ID.
2016-02-19 00:00:43,301 DEBUG [egovframework.rte.fdl.idgnr.impl.EgovTableIdGnrService] Select Query : SELECT next_id FROM COMTECOPSEQ WHERE table_name = ?
2016-02-19 00:00:43,302 DEBUG [egovframework.rte.fdl.idgnr.impl.EgovTableIdGnrService] Update Query : UPDATE COMTECOPSEQ SET next_id = ? WHERE table_name = ?
2016-02-19 00:00:43,303 DEBUG [egovframework.rte.fdl.cmmn.aspect.ExceptionTransfer] execute ExceptionTransfer.transfer
2016-02-19 00:00:43,303 DEBUG [egovframework.rte.fdl.cmmn.aspect.ExceptionTransfer] FdlException case :: FdlException
2016-02-19 00:00:43,303 ERROR [egovframework.com.sym.log.lgm.service.impl.EgovSysLogServiceImpl] [IDGeneration Service] Encountered an exception attempting to update the SYSLOG_ID table.
2016-02-19 00:00:43,303 DEBUG [egovframework.rte.fdl.cmmn.aspect.ExceptionTransfer] execute ExceptionTransfer.transfer
2016-02-19 00:00:43,303 DEBUG [egovframework.rte.fdl.cmmn.aspect.ExceptionTransfer] FdlException case :: FdlException
2016-02-19 00:00:43,304 ERROR [egovframework.com.cop.bbs.service.impl.EgovBBSManageServiceImpl] [IDGeneration Service] Encountered an exception attempting to update the SYSLOG_ID table.
egovframework.rte.fdl.cmmn.exception.FdlException: [IDGeneration Service] Encountered an exception attempting to update the SYSLOG_ID table.
at egovframework.rte.fdl.idgnr.impl.EgovTableIdGnrService$1.doInTransaction(EgovTableIdGnrService.java:222)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:131)
at egovframework.rte.fdl.idgnr.impl.EgovTableIdGnrService.allocateIdBlock(EgovTableIdGnrService.java:160)
at egovframework.rte.fdl.idgnr.impl.EgovTableIdGnrService.allocateLongIdBlock(EgovTableIdGnrService.java:254)
at egovframework.rte.fdl.idgnr.impl.AbstractDataBlockIdGnrService.getNextLongIdInner(AbstractDataBlockIdGnrService.java:120)
at egovframework.rte.fdl.idgnr.impl.AbstractIdGnrService.getNextBigDecimalId(AbstractIdGnrService.java:182)
at egovframework.rte.fdl.idgnr.impl.AbstractIdGnrService.getNextStringId(AbstractIdGnrService.java:236)
at egovframework.com.sym.log.lgm.service.impl.EgovSysLogServiceImpl.logInsertSysLog(EgovSysLogServiceImpl.java:49)
시스템 로그 시도시 오류가 발생하여 문의 드립니다.
로그는 아래와 같습니다.
감사합니다.
2016-02-19 00:00:43,300 DEBUG [egovframework.rte.fdl.idgnr.impl.EgovTableIdGnrService] [IDGeneration Service] Allocating a new block of 10 ids for key_table SYSLOG_ID.
2016-02-19 00:00:43,301 DEBUG [egovframework.rte.fdl.idgnr.impl.EgovTableIdGnrService] Select Query : SELECT next_id FROM COMTECOPSEQ WHERE table_name = ?
2016-02-19 00:00:43,302 DEBUG [egovframework.rte.fdl.idgnr.impl.EgovTableIdGnrService] Update Query : UPDATE COMTECOPSEQ SET next_id = ? WHERE table_name = ?
2016-02-19 00:00:43,303 DEBUG [egovframework.rte.fdl.cmmn.aspect.ExceptionTransfer] execute ExceptionTransfer.transfer
2016-02-19 00:00:43,303 DEBUG [egovframework.rte.fdl.cmmn.aspect.ExceptionTransfer] FdlException case :: FdlException
2016-02-19 00:00:43,303 ERROR [egovframework.com.sym.log.lgm.service.impl.EgovSysLogServiceImpl] [IDGeneration Service] Encountered an exception attempting to update the SYSLOG_ID table.
2016-02-19 00:00:43,303 DEBUG [egovframework.rte.fdl.cmmn.aspect.ExceptionTransfer] execute ExceptionTransfer.transfer
2016-02-19 00:00:43,303 DEBUG [egovframework.rte.fdl.cmmn.aspect.ExceptionTransfer] FdlException case :: FdlException
2016-02-19 00:00:43,304 ERROR [egovframework.com.cop.bbs.service.impl.EgovBBSManageServiceImpl] [IDGeneration Service] Encountered an exception attempting to update the SYSLOG_ID table.
egovframework.rte.fdl.cmmn.exception.FdlException: [IDGeneration Service] Encountered an exception attempting to update the SYSLOG_ID table.
at egovframework.rte.fdl.idgnr.impl.EgovTableIdGnrService$1.doInTransaction(EgovTableIdGnrService.java:222)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:131)
at egovframework.rte.fdl.idgnr.impl.EgovTableIdGnrService.allocateIdBlock(EgovTableIdGnrService.java:160)
at egovframework.rte.fdl.idgnr.impl.EgovTableIdGnrService.allocateLongIdBlock(EgovTableIdGnrService.java:254)
at egovframework.rte.fdl.idgnr.impl.AbstractDataBlockIdGnrService.getNextLongIdInner(AbstractDataBlockIdGnrService.java:120)
at egovframework.rte.fdl.idgnr.impl.AbstractIdGnrService.getNextBigDecimalId(AbstractIdGnrService.java:182)
at egovframework.rte.fdl.idgnr.impl.AbstractIdGnrService.getNextStringId(AbstractIdGnrService.java:236)
at egovframework.com.sym.log.lgm.service.impl.EgovSysLogServiceImpl.logInsertSysLog(EgovSysLogServiceImpl.java:49)
A
김원상님 안녕하세요.
표준프레임워크센터입니다.
ID Generation에셔 에러가 난다면
<property name="blockSize" value="10"/>
에서 블럭사이즈를 10이나 적절한 값으로 설정해 보시기 바랍니다.
blockSize 는 Id Generation 내부적으로 사용하는 정보로
ID 요청시 지정된 횟수가 될 경우만 DB에 접근해서 업데이트 하니 참고 바랍니다.
매우 빈번한 억세스가 발생한다면,
oracle의 경우 ID생성부분을 sequence를 사용하거나
mysql이면 autoincrement기능을 사용하여 구현하는것을 검토해 보시기 바랍니다.
감사합니다.
(참고)
http://www.egovframe.go.kr/wiki/doku.php?id=egovframework:rte2:fdl:id_generation
표준프레임워크센터입니다.
ID Generation에셔 에러가 난다면
<property name="blockSize" value="10"/>
에서 블럭사이즈를 10이나 적절한 값으로 설정해 보시기 바랍니다.
blockSize 는 Id Generation 내부적으로 사용하는 정보로
ID 요청시 지정된 횟수가 될 경우만 DB에 접근해서 업데이트 하니 참고 바랍니다.
매우 빈번한 억세스가 발생한다면,
oracle의 경우 ID생성부분을 sequence를 사용하거나
mysql이면 autoincrement기능을 사용하여 구현하는것을 검토해 보시기 바랍니다.
감사합니다.
(참고)
http://www.egovframe.go.kr/wiki/doku.php?id=egovframework:rte2:fdl:id_generation