Spring framework 서버 tomcat 에러 고수님들 한번 봐주세요 !!

Question

안녕하세요 구글링을 해도 못찾아서... 어디에문제가있는지 부탁드립니다!!!!오류뜨는 위치에다가 주석으로 표시했는데 nullpointer exception 이 나옵니다.널을 확인하는 if에서 nullpointer exception 이라니..ㅠㅠ이 에러가 뜬 이후에 하루뒤에 heap이 부족하다고 outofmemory 라는 에러가 또 나옵니다...(outofmemory 로 인한 nullpointer exception인지... 서버에 tomcat에 war파일 돌리고있습니다.) 2주 잘되다가 에러가 발생합니다... 제소스가 문제가 있는게아니라 원래 메모리가 부족해서 발생한건지.. 서버를 제가 개발하던게 아니라서 거기에 추가적인 소스만 붙힌건데 서버는 spring framework 고웹 서버에 저는 servlet 부분만 추가해서 scheduler 로 매 자정에 db를 insert해주는것만 추가했습니다. package com.forest.smart_k.service.system; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.text.DateFormat; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Calendar; import java.util.Date; import org.springframework.scheduling.annotation.Scheduled; import org.springframework.stereotype.Component; &#64;Component public class ScheduleAutoInsetService { String[] identifier &#61; { &#34;NC211&#34;, &#34;NC212&#34;, &#34;NC213&#34;, &#34;NC223&#34;, &#34;NC231&#34;, &#34;NC232&#34;, &#34;NC233&#34;, &#34;NC234&#34;, &#34;NC241&#34;, &#34;NC243&#34;, &#34;NC244&#34;, &#34;NC245&#34;, &#34;NC246&#34;, &#34;NC247&#34;, &#34;NC248&#34;, }; String[] AllState &#61; { &#34;state_A&#34;, &#34;state_B&#34;, &#34;state_C&#34;, &#34;state_D&#34;, &#34;state_E&#34;, &#34;state_F&#34;, &#34;state_G&#34;, &#34;state_H&#34;, &#34;state_I&#34;, &#34;state_J&#34;, &#34;state_K&#34;, &#34;state_L&#34;, &#34;state_M&#34;, &#34;state_N&#34;, &#34;state_O&#34;, &#34;state_P&#34;, &#34;state_Q&#34;, &#34;state_R&#34;, &#34;state_S&#34;, &#34;state_T&#34; }; // 초 분 시 일 월 요일 //&#64;Scheduled(fixedDelay &#61; 6000) &#64;Scheduled(cron &#61; &#34;0 0 0 * * *&#34;) public void cronTest4() { if (exception()) setData(); } //여기에러 nullpointer exception public boolean exception() { Connection conn &#61; null; PreparedStatement ps &#61; null; ResultSet rs &#61; null; String Date &#61; null; String sql &#61; &#34;select time from m_breakcount where time &#61;'&#34; &#43; getCurrentDate() &#43; &#34;' limit 1&#34;; try { Class.forName(&#34;com.mysql.jdbc.Driver&#34;); conn &#61; DriverManager.getConnection(&#34;jdbc:mysql://&#34;); ps &#61; conn.prepareStatement(sql); rs &#61; ps.executeQuery(); while (rs.next()) { Date &#61; rs.getString(&#34;time&#34;); System.out.println(Date); } } catch (Exception e) { e.printStackTrace(); } finally { try { ps.close(); conn.close(); rs.close(); } catch (SQLException e) { e.printStackTrace(); } } if (Date !&#61; null) { //여기에러 nullpointer exception System.out.println(&#34;이미 데이터가 들어가 있습니다.&#34;); return false; } else { return true; } } public void setData() { PreparedStatement ps; Connection conn; try { Class.forName(&#34;com.mysql.jdbc.Driver&#34;); conn &#61; DriverManager.getConnection(&#34;jdbc:mysql://&#34;); ps &#61; conn.prepareStatement(&#34;insert into m_breakcount(time, m_name,state_name, state) values (?, ?, ?, ?)&#34;); for (int j &#61; 0; j < identifier.length; j&#43;&#43;) { for (int i &#61; 0; i < 15; i&#43;&#43;) { ps.setTimestamp(1, new java.sql.Timestamp(new java.util.Date().getTime())); ps.setString(2, identifier[j]); ps.setString(3, AllState[i]); ps.setString(4, &#34;2&#34;); ps.executeUpdate(); } } ps.close(); conn.close(); } catch (Exception e) { System.out.println(&#34;Android 3정 5S m_breakcount 데이터베이스가 이미 추가되었습니다.&#34;); } setData1(); } public void setData1() { PreparedStatement ps; Connection conn; try { Class.forName(&#34;com.mysql.jdbc.Driver&#34;); conn &#61; DriverManager.getConnection(&#34;jdbc:mysql://&#34;); ps &#61; conn.prepareStatement( &#34;insert into m_statlist(check_date, identifier, machine_check, working_check, first_register) values (?, ?, ?, ?, ?)&#34;); for (int j &#61; 0; j < identifier.length; j&#43;&#43;) { ps.setDate(1, getCurrentDate()); ps.setString(2, identifier[j]); ps.setString(3, &#34;w&#34;); ps.setString(4, &#34;w&#34;); ps.setString(5, null); ps.executeUpdate(); } ps.close(); conn.close(); } catch (Exception e) { // System.out.println(&#34;데이터 중복 Insert&#34;); // e.printStackTrace(); System.out.println(&#34;Android 3정 5S m_statlist 데이터베이스가 이미 추가되었습니다.&#34;); } } private static java.sql.Date getCurrentDate() { java.util.Date today &#61; new java.util.Date(); return new java.sql.Date(today.getTime()); } } 18일날 이런에러가...[2017-02-18 00:00:01] [TaskUtils$LoggingErrorHandler] [95] [ERROR] Unexpected error occurred in scheduled task. java.lang.NullPointerException at com.forest.smart_k.service.system.ScheduleAutoInsetService.exception(ScheduleAutoInsetService.java:63) at com.forest.smart_k.service.system.ScheduleAutoInsetService.cronTest4(ScheduleAutoInsetService.java:34) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:65) at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:81) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) 19일에는 이런에러가 발생했습니다.... [2017-02-19 00:00:01] [TaskUtils$LoggingErrorHandler] [95] [ERROR] Unexpected error occurred in scheduled task. java.lang.NullPointerException at com.forest.smart_k.service.system.ScheduleAutoInsetService.exception(ScheduleAutoInsetService.java:63) at com.forest.smart_k.service.system.ScheduleAutoInsetService.cronTest4(ScheduleAutoInsetService.java:34) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:65) at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:81) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) [2017-02-19 05:32:53] [TaskUtils$LoggingErrorHandler] [95] [ERROR] Unexpected error occurred in scheduled task. java.lang.OutOfMemoryError: Java heap space at java.util.Arrays.copyOfRange(Unknown Source) at java.lang.String.<init>(Unknown Source) at oracle.jdbc.driver.CharCommonAccessor.getString(CharCommonAccessor.java:463) at oracle.jdbc.driver.T4CVarcharAccessor.getString(T4CVarcharAccessor.java:464) at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:1297) at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:498) at com.forest.smart_k.service.system.ScheduledService.getHumanInfo(ScheduledService.java:79) at com.forest.smart_k.service.system.ScheduledService.updateHumanInfo(ScheduledService.java:31) at sun.reflect.GeneratedMethodAccessor114.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:65) at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:81) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) [2017-02-19 05:33:01] [TaskUtils$LoggingErrorHandler] [95] [ERROR] Unexpected error occurred in scheduled task. java.lang.OutOfMemoryError: Java heap space at oracle.jdbc.driver.KeywordValueI.unmarshal(KeywordValueI.java:126) at oracle.jdbc.driver.T4C8Oall.readRPA(T4C8Oall.java:855) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:364) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:886) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3657) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495) at com.forest.smart_k.service.system.ScheduledService.getHumanInfo(ScheduledService.java:74) at com.forest.smart_k.service.system.ScheduledService.updateHumanInfo(ScheduledService.java:31) at sun.reflect.GeneratedMethodAccessor114.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:65) at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:81) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) [2017-02-19 05:33:23] [TaskUtils$LoggingErrorHandler] [95] [ERROR] Unexpected error occurred in scheduled task. java.lang.OutOfMemoryError: Java heap space [2017-02-19 05:33:46] [TaskUtils$LoggingErrorHandler] [95] [ERROR] Unexpected error occurred in scheduled task. java.lang.OutOfMemoryError: Java heap space [2017-02-19 05:34:07] [TaskUtils$LoggingErrorHandler] [95] [ERROR] Unexpected error occurred in scheduled task. java.lang.OutOfMemoryError: Java heap space [2017-02-19 05:34:33] [TaskUtils$LoggingErrorHandler] [95] [ERROR] Unexpected error occurred in scheduled task. java.lang.OutOfMemoryError: Java heap space [2017-02-19 05:35:01] [TaskUtils$LoggingErrorHandler] [95] [ERROR] Unexpected error occurred in scheduled task. java.lang.OutOfMemoryError: Java heap space [2017-02-19 05:35:26] [TaskUtils$LoggingErrorHandler] [95] [ERROR] Unexpected error occurred in scheduled task. java.lang.OutOfMemoryError: Java heap space [2017-02-19 05:35:53] [TaskUtils$LoggingErrorHandler] [95] [ERROR] Unexpected error occurred in scheduled task. java.lang.OutOfMemoryError: Java heap space 왜그런지 모르겠습니다 ㅠㅠㅠㅠㅠㅠ 도와주세요ㅠㅠ

GAN · Accepted Answer

NPE 는 해당 부분이 아닌 그 위쪽의 rs.close() 하는 부분에서 발생하는 것 같습니다. OOM 으로 인해 rs 를 얻지 못하고 catch(Exception e) 에서 로그를 찍고 finally 에서 rs.close() 를 하면서 NPE 가 발생하는 것 같네요. finally close 하는 부분에 rs, ps, conn null 체크 후 close 하도록 수정하시면 NPE 는 발생하지 않을 것 같습니다.단, 근본적으로 OOM 이 발생하면서 생기는 문제이고 2주간 정상 동작을 하다가 에러가 발생하는 상황이라면 어디선가 메모리릭이 발생하고 있을 수 있으니 해당 부분을 찾아서 수정하시거나 주기적으로 tomcat 재시작을 해주셔야할 것 같습니다. http://egloos.zum.com/shadowxx/v/10781286 http://d2.naver.com/helloworld/1326256 http://egloos.zum.com/lemonfish/v/5380639

ㅇㅈㅎ · Answer

답변 진심으로 감사드립니다. 하나더 여주어보고싶은게 있는데 &#64;Scheduled(cron &#61; &#34;0 0 0 * * *&#34;) 예제소스 보면 cron &#61; &#34;0 0 0 * * ? &#34; *가 아닌 -> ?예제밖에 보이지 않는데 ? 와 * 의 메모리 잡아먹는 차이가 있을까요??

GAN · Answer

스케쥴러에서 메모리릭이 나는지는 모르겠지만 요일에 * 과 ? 의 차이는 없어 보입니다. http://bitlog.tistory.com/38

ㅇㅈㅎ · Answer

네 감사합니다 !!!! ^^

Spring framework 서버 tomcat 에러 고수님들 한번 봐주세요 !!

4개의 답변

Q&A 목록