生产事故 java_生产事故 java.lang.OutOfMemoryError: GC overhead limit exceeded

状况：Caused by: java.lang.OutOfMemoryError: GC overhead limit exceeded  内存溢出导致服务挂机

具体过程：才在上文中跑完百万级数据导入，这篇文章就出现了问题，原因是代码中非空判断不严谨，导致当前端传过来空值时，查询时sql执行了全量查询，直接干崩服务器

### SQL: select id, customer_no_Individual, customer_no_group, account_no, account_pwd, account_initpwd, account_level, authcenter_user_level, authcenter_real_level, is_agree, status, merge_to, office_id, register_type, firstAction_time, is_login_app, first_login_time, bind_ori, bind_time, overlap_time, recommend_name, agentins_type, agentin_platfrom, channel_type, customer_name, certificate_no, certificate_type, gender, birthday, mobile, email, role, creater, modifier, make_date, make_time, modify_date, modify_time, fetch_status, account_id from office_account a where 1=1 and a.status = ?

### Cause: java.sql.SQLException: Error

解决方案：重启(哈哈哈)

外附上查询问题的方法

1、使用top命令，查找pid

2、显示线程，查找线程tid

ps -mp #pid# -o THREAD,tid,time | sort -rn

3、将线程id转化为16进制0xtid

printf "%x\n" #tid#

4、显示线程的堆栈信息

jstack #pid#|grep #0xtid# -A 30