mysql 锁启动失败_关于mysql锁的错误Lock wait timeout exceeded; try restarting transaction 【求解】...

最新推荐文章于 2024-08-15 16:10:18 发布

王忠林俊杰

最新推荐文章于 2024-08-15 16:10:18 发布

阅读量615

点赞数

文章标签： mysql 锁启动失败

本文链接：https://blog.csdn.net/weixin_33266588/article/details/113345447

版权

2020-03-13 18:44:18 | INFO | http-nio-8085-exec-10 | com.newretail.hospital.controller.HAdviceController | 新增一条医嘱信息：controller:param:{"adviceDTOS":[{"adviceDetailParts":[{"partCode":"eyebu_bodyPart","partName":"眼部"}],"adviceDetailPartsName":"眼部","checkPicture":[],"classApplyNo":"JC2003000019","classesCode":"mGeneralClasses1912120018","classesName":"单项检查","code":"mProvides1912130064","dayNumber":"1","detailCode":"hAdviceDetail2003130017","detailId":11,"id":11,"isRefund":"0","isSetMeal":"1","medicalAdvice":"","name":"间接眼底镜检查","organizations":[{"orgCode":"mRooms1912120009","orgName":"检查室18","orgNo":""}],"organizationsName":"检查室18","paymentStatus":"1","price":20,"provideType":"check","quantity":"1","realPrice":0,"remark":"","sellMealCode":"SELL2003120002","status":"0","unitCode":"ci_provideUnit","unitName":"次"},{"adviceDetailParts":[{"partCode":"eyebu_bodyPart","partName":"眼部"}],"adviceDetailPartsName":"眼部","checkPicture":[],"classApplyNo":"JC2003000020","classesCode":"mGeneralClasses1912120018","classesName":"单项检查","code":"mProvides1912260001","dayNumber":"1","detailCode":"hAdviceDetail2003130018","detailId":12,"id":12,"isRefund":"0","isSetMeal":"1","medicalAdvice":"","name":"泪液分泌检测(棉线)","organizations":[{"orgCode":"mRooms1912120007","orgName":"检查室6","orgNo":""}],"organizationsName":"检查室6","paymentStatus":"1","price":10,"provideType":"check","quantity":"1","realPrice":0,"remark":"","sellMealCode":"SELL2003120002","status":"0","unitCode":"ci_provideUnit","unitName":"次"},{"adviceDetailParts":[{"partCode":"eyebu_bodyPart","partName":"眼部"}],"adviceDetailPartsName":"眼部","checkPicture":[],"classApplyNo":"JC2003000021","classesCode":"mGeneralClasses1912120018","classesName":"单项检查","code":"mProvides1912120026","dayNumber":"1","detailCode":"hAdviceDetail2003130019","detailId":13,"id":13,"isRefund":"0","isSetMeal":"1","medicalAdvice":"","name":"裸眼远视力检查","organizations":[{"orgCode":"mRooms1912120001","orgName":"初检室1","orgNo":""}],"organizationsName":"初检室1","paymentStatus":"1","price":5,"provideType":"check","quantity":"1","realPrice":0,"remark":"","sellMealCode":"SELL2003130004","status":"0","unitCode":"ci_provideUnit","unitName":"次"},{"adviceDetailParts":[{"partCode":"eyebu_bodyPart","partName":"眼部"}],"adviceDetailPartsName":"眼部","checkPicture":[],"classApplyNo":"JC2003000022","classesCode":"mGeneralClasses1912120018","classesName":"单项检查","code":"mProvides1912120025","dayNumber":"1","detailCode":"hAdviceDetail2003130020","detailId":14,"id":14,"isRefund":"0","isSetMeal":"1","medicalAdvice":"","name":"裸眼近视力检查","organizations":[{"orgCode":"mRooms1912120001","orgName":"初检室1","orgNo":""}],"organizationsName":"初检室1","paymentStatus":"1","price":5,"provideType":"check","quantity":"1","realPrice":0,"remark":"","sellMealCode":"SELL2003130004","status":"0","unitCode":"ci_provideUnit","unitName":"次"},{"adviceDetailParts":[{"partCode":"eyebu_bodyPart","partName":"眼部"}],"adviceDetailPartsName":"眼部","checkPicture":[],"classApplyNo":"JC2003000023","classesCode":"mGeneralClasses1912120018","classesName":"单项检查","code":"mProvides1912120027","dayNumber":"1","detailCode":"hAdviceDetail2003130021","detailId":15,"id":15,"isRefund":"0","isSetMeal":"1","medicalAdvice":"","name":"色觉检查","organizations":[{"orgCode":"mRooms1912120001","orgName":"初检室1","orgNo":""}],"organizationsName":"初检室1","paymentStatus":"1","price":10,"provideType":"check","quantity":"1","realPrice":0,"remark":"","sellMealCode":"SELL2003130004","status":"0","unitCode":"ci_provideUnit","unitName":"次"},{"adviceDetailParts":[{"partCode":"eyebu_bodyPart","partName":"眼部"}],"adviceDetailPartsName":"眼部","checkPicture":[],"classApplyNo":"JC2003000026","classesCode":"mGeneralClasses1912120018","classesName":"单项检查","code":"mProvides1912130047","dayNumber":"1","detailCode":"hAdviceDetail2003130024","detailId":18,"id":18,"isRefund":"0","isSetMeal":"1","medicalAdvice":"","name":"近立体式检查","organizations":[{"orgCode":"mRooms1912120012","orgName":"验光室5","orgNo":""}],"organizationsName":"验光室5","paymentStatus":"1","price":10,"provideType":"check","quantity":"1","realPrice":0,"remark":"","sellMealCode":"SELL2003120002","status":"0","unitCode":"ci_provideUnit","unitName":"次"},{"adviceDetailParts":[{"partCode":"eyebu_bodyPart","partName":"眼部"}],"adviceDetailPartsName":"眼部","checkPicture":[],"classApplyNo":"JC2003000027","classesCode":"mGeneralClasses1912120018","classesName":"单项检查","code":"mProvides1912120029","dayNumber":"1","detailCode":"hAdviceDetail2003130025","detailId":19,"id":19,"isRefund":"0","isSetMeal":"1","medicalAdvice":"","name":"非接触眼压","organizations":[{"orgCode":"mRooms1912120001","orgName":"初检室1","orgNo":""}],"organizationsName":"初检室1","paymentStatus":"1","price":10,"provideType":"check","quantity":"1","realPrice":0,"remark":"","sellMealCode":"SELL2003120002","status":"0","unitCode":"ci_provideUnit","unitName":"次"},{"adviceDetailParts":[{"partCode":"eyebu_bodyPart","partName":"眼部"}],"adviceDetailPartsName":"眼部","checkPicture":[],"classApplyNo":"JC2003000028","classesCode":"mGeneralClasses1912120018","classesName":"单项检查","code":"mProvides1912130028","dayNumber":"1","detailCode":"hAdviceDetail2003130026","detailId":20,"id":20,"isRefund":"0","isSetMeal":"1","medicalAdvice":"","name":"裂隙灯检查","organizations":[{"orgCode":"mRooms1912120005","orgName":"诊室8","orgNo":""}],"organizationsName":"诊室8","paymentStatus":"1","price":10,"provideType":"check","quantity":"1","realPrice":0,"remark":"","sellMealCode":"SELL2003120002","status":"0","unitCode":"ci_provideUnit","unitName":"次"},{"adviceDetailParts":[{"partCode":"eyebu_bodyPart","partName":"眼部"}],"adviceDetailPartsName":"眼部","checkPicture":[],"classApplyNo":"JC2003000029","classesCode":"mGeneralClasses1912120018","classesName":"单项检查","code":"mProvides1912130048","dayNumber":"1","detailCode":"hAdviceDetail2003130027","detailId":21,"id":21,"isRefund":"0","isSetMeal":"1","medicalAdvice":"","name":"原镜度数测量(焦度计测量)","organizations":[{"orgCode":"mRooms1912120012","orgName":"验光室5","orgNo":""}],"organizationsName":"验光室5","paymentStatus":"1","price":10,"provideType":"check","quantity":"1","realPrice":0,"remark":"","sellMealCode":"SELL2003120002","status":"0","unitCode":"ci_provideUnit","unitName":"次"},{"adviceDetailParts":[{"partCode":"eyebu_bodyPart","partName":"眼部"}],"adviceDetailPartsName":"眼部","checkPicture":[],"classApplyNo":"JC2003000031","classesCode":"mGeneralClasses1912120018","classesName":"单项检查","code":"mProvides1912130045","dayNumber":"1","detailCode":"hAdviceDetail2003130029","detailId":23,"id":23,"isRefund":"0","isSetMeal":"1","medicalAdvice":"","name":"散瞳验光","organizations":[{"orgCode":"mRooms1912120013","orgName":"验光室9","orgNo":""}],"organizationsName":"验光室9","paymentStatus":"1","price":50,"provideType":"check","quantity":"1","realPrice":0,"remark":"","sellMealCode":"SELL2003120002","status":"0","unitCode":"ci_provideUnit","unitName":"次"},{"adviceDetailParts":[{"partCode":"eyebu_bodyPart","partName":"眼部"}],"adviceDetailPartsName":"眼部","checkPicture":[],"classApplyNo":"JC2003000034","classesCode":"mGeneralClasses1912120018","classesName":"单项检查","code":"mProvides1912130045","dayNumber":"1","detailCode":"hAdviceDetail2003130032","detailId":26,"id":26,"isRefund":"0","isSetMeal":"1","medicalAdvice":"","name":"散瞳验光","organizations":[{"orgCode":"mRooms1912120013","orgName":"验光室9","orgNo":""}],"organizationsName":"验光室9","paymentStatus":"1","price":50,"provideType":"check","quantity":"1","realPrice":0,"remark":"","sellMealCode":"SELL2003120002","status":"0","unitCode":"ci_provideUnit","unitName":"次"},{"adviceDetailParts":[{"partCode":"eyebu_bodyPart","partName":"眼部"}],"adviceDetailPartsName":"眼部","classesCode":"mGeneralClasses1912120018","classesName":"单项检查","code":"mProvides1912120025","dayNumber":"1","id":25,"invoiceClassesCode":"mInvoiceClasses1912120004","isCommon":"0","isPayItems":"1","isPaySpecial":"0","isSetMeal":"1","mealCode":"mSetMeal20191213112835000009","mealDetailCode":"mSetMealProvides2003040169","medicalAdvice":"","name":"裸眼近视力检查","organizations":[{"orgCode":"mRooms1912120001","orgName":"初检室1","orgNo":""}],"organizationsName":"初检室1","paymentStatus":"0","price":5,"provideType":"check","quantity":"1","realPrice":0,"sellMealCode":"SELL2003120002","status":"0","unitCode":"ci_provideUnit","unitName":"次"}],"adviceType":"1","assistantCode":"","assistantName":"","assistantNo":"","medicalNo":"20000115","memberCode":"CMember2003120006","memberName":"测试数据","visitCode":"HVisit2003130004"}

Creating a new SqlSession

Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4b7b1f50]

JDBC Connection [com.p6spy.engine.wrapper.ConnectionWrapper@6a3fec38] will be managed by Spring

==> Preparing: SELECT COUNT( 1 ) FROM h_operation WHERE is_delete = ? AND is_effect = ? AND member_code = ? AND create_date > ?

==> Parameters: false(Boolean), true(Boolean), CMember2003120006(String), 2019-12-13 18:44:18(String)

SELECT COUNT( 1 ) FROM h_operation WHERE is_delete = false AND is_effect = true AND member_code = 'CMember2003120006' AND create_date > '2019-12-13 18:44:18';

<== Columns: COUNT( 1 )

<== Row: 0

<== Total: 1

Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4b7b1f50]

Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4b7b1f50] from current transaction

==> Preparing: SELECT id,member_code,member_name,member_birthday,certificate_type,certificate_id,gender,mobile_phone,reservation_code,reservation_date,visit_type,register_type,medical_no,dept_code,dept_no,dept_name,doctor_code,doctor_no,doctor_name,level_code,level_name,counselor_code,counselor_no,counselor_name,outside_doctor,visit_time,status,line_number,charge_type,charge_channel,reservation_type,illness_type_name,illness_type_code,counselor_status,contain_set_meal,register_price,company_code,com_group_code,code,remark,is_effect,is_delete,create_by_code,create_by_no,create_by_name,create_date,update_by_code,update_by_no,update_by_name,update_date,tenant_id,version FROM h_visit WHERE code = ?

==> Parameters: HVisit2003130004(String)

SELECT id,member_code,member_name,member_birthday,certificate_type,certificate_id,gender,mobile_phone,reservation_code,reservation_date,visit_type,register_type,medical_no,dept_code,dept_no,dept_name,doctor_code,doctor_no,doctor_name,level_code,level_name,counselor_code,counselor_no,counselor_name,outside_doctor,visit_time,status,line_number,charge_type,charge_channel,reservation_type,illness_type_name,illness_type_code,counselor_status,contain_set_meal,register_price,company_code,com_group_code,code,remark,is_effect,is_delete,create_by_code,create_by_no,create_by_name,create_date,update_by_code,update_by_no,update_by_name,update_date,tenant_id,version FROM h_visit WHERE code = 'HVisit2003130004';

<== Columns: id, member_code, member_name, member_birthday, certificate_type, certificate_id, gender, mobile_phone, reservation_code, reservation_date, visit_type, register_type, medical_no, dept_code, dept_no, dept_name, doctor_code, doctor_no, doctor_name, level_code, level_name, counselor_code, counselor_no, counselor_name, outside_doctor, visit_time, status, line_number, charge_type, charge_channel, reservation_type, illness_type_name, illness_type_code, counselor_status, contain_set_meal, register_price, company_code, com_group_code, code, remark, is_effect, is_delete, create_by_code, create_by_no, create_by_name, create_date, update_by_code, update_by_no, update_by_name, update_date, tenant_id, version

<== Row: 219, CMember2003120006, 测试数据, 1990-02-04 00:00:00, china_id_certificateType, 391018199002041147, female, 18716677814, RReservation2003130004, 2020-03-13 16:00:00, operation_start, walking_registerType, 20000115, organization20191212150433000014, null, 眼科(医生组), mEmployees1912130016, null, 陶冶, ordinary, 普通挂号费, mEmployees1912120005, null, 徐铮, , 2020-03-13 16:21:05, get_check, 450, self_chargeType, lineOff_customerFromType, outpatient_scheduleClassType, 屈光手术, refractive_surgery, 0, 1, 850.5000, company191212140126000001, null, HVisit2003130004, , 1, 0, user191216154506000003, , 陶冶, 2020-03-13 16:21:10, user191216154506000003, , 陶冶, 2020-03-13 16:21:26, null, 21

<== Total: 1

Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4b7b1f50]

Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4b7b1f50] from current transaction

==> Preparing: SELECT id,member_code,member_name,mobile_phone,is_signature,dept_code,dept_no,dept_name,doctor_code,doctor_no,doctor_name,assistant_code,assistant_name,appointment_code,license_no,call_status,status,visit_code,medical_no,level,revisit_time,visit_time,visit_type,company_code,com_group_code,code,remark,is_effect,is_delete,create_by_code,create_by_no,create_by_name,create_date,update_by_code,update_by_no,update_by_name,update_date,tenant_id,version FROM h_call_number WHERE visit_code = ?

==> Parameters: HVisit2003130004(String)

SELECT id,member_code,member_name,mobile_phone,is_signature,dept_code,dept_no,dept_name,doctor_code,doctor_no,doctor_name,assistant_code,assistant_name,appointment_code,license_no,call_status,status,visit_code,medical_no,level,revisit_time,visit_time,visit_type,company_code,com_group_code,code,remark,is_effect,is_delete,create_by_code,create_by_no,create_by_name,create_date,update_by_code,update_by_no,update_by_name,update_date,tenant_id,version FROM h_call_number WHERE visit_code = 'HVisit2003130004';

<== Columns: id, member_code, member_name, mobile_phone, is_signature, dept_code, dept_no, dept_name, doctor_code, doctor_no, doctor_name, assistant_code, assistant_name, appointment_code, license_no, call_status, status, visit_code, medical_no, level, revisit_time, visit_time, visit_type, company_code, com_group_code, code, remark, is_effect, is_delete, create_by_code, create_by_no, create_by_name, create_date, update_by_code, update_by_no, update_by_name, update_date, tenant_id, version

<== Row: 87, CMember2003120006, 测试数据, 18716677814, 0, organization20191212150433000014, , 眼科(医生组), mEmployees1912130016, , 陶冶, , , RReservation2003130004, 450, 5, 2, HVisit2003130004, 20000115, 2, null, null, operation_start, company191212140126000001, null, hCallNumber2003130002, null, 1, 0, user191216154506000003, taoye, 陶冶, 2020-03-13 16:21:27, user191216154506000003, taoye, 陶冶, 2020-03-13 17:39:53, null, 9

<== Total: 1

Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4b7b1f50]

Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4b7b1f50] from current transaction

==> Preparing: UPDATE h_visit SET status=?, version=version+1 WHERE code = ?

==> Parameters: yes_doctor(String), HVisit2003130004(String)

UPDATE h_visit SET status='yes_doctor', version=version+1 WHERE code = 'HVisit2003130004';

<== Updates: 1

Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4b7b1f50]

Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4b7b1f50] from current transaction

==> Preparing: UPDATE h_visit_detail SET visit_code=?, provide_type=?, status=?, update_date=?, version=version+1 WHERE visit_code = ? AND provide_type = ?

==> Parameters: HVisit2003130004(String), visit_advice(String), 3(String), 2020-03-13 18:44:18(String), HVisit2003130004(String), visit_advice(String)

UPDATE h_visit_detail SET visit_code='HVisit2003130004', provide_type='visit_advice', status='3', update_date='2020-03-13 18:44:18', version=version+1 WHERE visit_code = 'HVisit2003130004' AND provide_type = 'visit_advice';

<== Updates: 1

Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4b7b1f50]

Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4b7b1f50] from current transaction

==> Preparing: UPDATE h_call_number SET assistant_code=?, assistant_name=?, call_status=?, status=?, visit_code=?, update_date=?, version=version+1 WHERE visit_code = ?

==> Parameters: (String), (String), 5(String), 2(String), HVisit2003130004(String), 2020-03-13 18:44:18(String), HVisit2003130004(String)

UPDATE h_call_number SET assistant_code='', assistant_name='', call_status='5', status='2', visit_code='HVisit2003130004', update_date='2020-03-13 18:44:18', version=version+1 WHERE visit_code = 'HVisit2003130004';

<== Updates: 1

Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4b7b1f50]

2020-03-13 18:44:18 | INFO | http-nio-8085-exec-10 | com.newretail.hospital.service.impl.HAdviceServiceImpl | 更改叫号状态：result:1

2020-03-13 18:44:18 | INFO | http-nio-8085-exec-10 | com.newretail.common.util.UserInfoUtils | ---getUserInfo code as taoye---

2020-03-13 18:44:18 | INFO | http-nio-8085-exec-10 | com.newretail.common.util.SequenceUtil | create sequence hAdvice2003130033, date: Fri Mar 13 18:44:18 CST 2020

2020-03-13 18:44:18 | INFO | http-nio-8085-exec-10 | com.newretail.common.util.UserInfoUtils | ---getUserInfo code as taoye---

2020-03-13 18:44:18 | INFO | http-nio-8085-exec-10 | com.newretail.hospital.service.impl.HAdviceServiceImpl | 执行地转换处理：[OrgTypeDTO(orgCode=mRooms1912120001, orgNo=, orgName=初检室1)]

2020-03-13 18:44:18 | INFO | http-nio-8085-exec-10 | com.newretail.common.util.UserInfoUtils | ---getUserInfo code as taoye---

2020-03-13 18:44:19 | INFO | http-nio-8085-exec-10 | com.newretail.common.util.SequenceUtil | create sequence hAdviceDetail2003130046, date: Fri Mar 13 18:44:19 CST 2020

2020-03-13 18:44:19 | INFO | http-nio-8085-exec-10 | com.newretail.common.util.SequenceUtil | create sequence JC2003000048, date: Fri Mar 13 18:44:19 CST 2020

2020-03-13 18:44:19 | INFO | http-nio-8085-exec-10 | com.newretail.common.util.UserInfoUtils | ---getUserInfo code as taoye---

Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4b7b1f50] from current transaction

==> Preparing: INSERT INTO h_advice_detail_parts ( detail_code, part_name, part_code, company_code, code, create_by_code, create_by_no, create_by_name, create_date, update_by_code, update_by_no, update_by_name, update_date ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )

==> Parameters: CMember2003120006(String), 眼部(String), eyebu_bodyPart(String), company191212140126000001(String), hAdviceDetail2003130046(String), user191216154506000003(String), taoye(String), 陶冶(String), 2020-03-13 18:44:19(String), user191216154506000003(String), taoye(String), 陶冶(String), 2020-03-13 18:44:19(String)

INSERT INTO h_advice_detail_parts ( detail_code, part_name, part_code, company_code, code, create_by_code, create_by_no, create_by_name, create_date, update_by_code, update_by_no, update_by_name, update_date ) VALUES ( 'CMember2003120006', '眼部', 'eyebu_bodyPart', 'company191212140126000001', 'hAdviceDetail2003130046', 'user191216154506000003', 'taoye', '陶冶', '2020-03-13 18:44:19', 'user191216154506000003', 'taoye', '陶冶', '2020-03-13 18:44:19' );

<== Updates: 1

Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4b7b1f50]

Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4b7b1f50] from current transaction

==> Preparing: UPDATE h_visit_detail SET visit_code=?, provide_type=?, status=?, update_date=?, version=version+1 WHERE visit_code = ? AND provide_type = ?

==> Parameters: HVisit2003130004(String), visit_check(String), 1(String), 2020-03-13 18:44:19(String), HVisit2003130004(String), visit_check(String)

UPDATE h_visit_detail SET visit_code='HVisit2003130004', provide_type='visit_check', status='1', update_date='2020-03-13 18:44:19', version=version+1 WHERE visit_code = 'HVisit2003130004' AND provide_type = 'visit_check';

<== Updates: 1

Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4b7b1f50]

Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4b7b1f50] from current transaction

==> Preparing: INSERT INTO h_advice_detail ( advice_code, class_type, class_apply_no, sell_meal_code, set_meal_code, set_meal_detail_code, provide_code, provide_no, provide_name, unit_code, unit_name, quantity, day_number, dept_code, dept_no, dept_name, organization, price, real_price, payment_type, payment_status, status, invoice_classes_code, classes_code, classes_name, company_code, code, remark, create_by_code, create_by_no, create_by_name, create_date, update_by_code, update_by_no, update_by_name, update_date ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )

==> Parameters: hAdvice2003130033(String), check(String), JC2003000048(String), SELL2003120002(String), mSetMeal20191213112835000009(String), mSetMealProvides2003040169(String), mProvides1912120025(String), (String), 裸眼近视力检查(String), ci_provideUnit(String), 次(String), 1(BigDecimal), 1(BigDecimal), organization20191212150433000014(String), 001(String), 眼科(医生组)(String), [{"orgCode":"mRooms1912120001","orgName":"初检室1","orgNo":""}](String), 5(BigDecimal), 0(BigDecimal), 1(String), 1(String), 0(String), mInvoiceClasses1912120004(String), mGeneralClasses1912120018(String), 单项检查(String), company191212140126000001(String), hAdviceDetail2003130046(String), (String), user191216154506000003(String), taoye(String), 陶冶(String), 2020-03-13 18:44:19(String), user191216154506000003(String), taoye(String), 陶冶(String), 2020-03-13 18:44:19(String)

INSERT INTO h_advice_detail ( advice_code, class_type, class_apply_no, sell_meal_code, set_meal_code, set_meal_detail_code, provide_code, provide_no, provide_name, unit_code, unit_name, quantity, day_number, dept_code, dept_no, dept_name, organization, price, real_price, payment_type, payment_status, status, invoice_classes_code, classes_code, classes_name, company_code, code, remark, create_by_code, create_by_no, create_by_name, create_date, update_by_code, update_by_no, update_by_name, update_date ) VALUES ( 'hAdvice2003130033', 'check', 'JC2003000048', 'SELL2003120002', 'mSetMeal20191213112835000009', 'mSetMealProvides2003040169', 'mProvides1912120025', '', '裸眼近视力检查', 'ci_provideUnit', '次', 1, 1, 'organization20191212150433000014', '001', '眼科(医生组)', '[{"orgCode":"mRooms1912120001","orgName":"初检室1","orgNo":""}]', 5, 0, '1', '1', '0', 'mInvoiceClasses1912120004', 'mGeneralClasses1912120018', '单项检查', 'company191212140126000001', 'hAdviceDetail2003130046', '', 'user191216154506000003', 'taoye', '陶冶', '2020-03-13 18:44:19', 'user191216154506000003', 'taoye', '陶冶', '2020-03-13 18:44:19' );

<== Updates: 1

Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4b7b1f50]

2020-03-13 18:44:19 | INFO | http-nio-8085-exec-10 | com.newretail.common.util.UserInfoUtils | ---getUserInfo code as taoye---

Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4b7b1f50] from current transaction

==> Parameters: HVisit2003130004(String)

<== Row: 219, CMember2003120006, 测试数据, 1990-02-04 00:00:00, china_id_certificateType, 391018199002041147, female, 18716677814, RReservation2003130004, 2020-03-13 16:00:00, operation_start, walking_registerType, 20000115, organization20191212150433000014, null, 眼科(医生组), mEmployees1912130016, null, 陶冶, ordinary, 普通挂号费, mEmployees1912120005, null, 徐铮, , 2020-03-13 16:21:05, yes_doctor, 450, self_chargeType, lineOff_customerFromType, outpatient_scheduleClassType, 屈光手术, refractive_surgery, 0, 1, 850.5000, company191212140126000001, null, HVisit2003130004, , 1, 0, user191216154506000003, , 陶冶, 2020-03-13 16:21:10, user191216154506000003, , 陶冶, 2020-03-13 16:21:26, null, 22

<== Total: 1

Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4b7b1f50]

2020-03-13 18:44:19 | INFO | http-nio-8085-exec-10 | com.newretail.hospital.service.impl.HCheckServiceImpl | 新增检查信息获取就诊记录hVisit:HVisit(memberCode=CMember2003120006, memberName=测试数据, memberBirthday=1990-02-04 00:00:00, certificateType=china_id_certificateType, certificateId=391018199002041147, gender=female, mobilePhone=18716677814, reservationCode=RReservation2003130004, reservationDate=2020-03-13 16:00:00, visitType=operation_start, registerType=walking_registerType, medicalNo=20000115, deptCode=organization20191212150433000014, deptNo=null, deptName=眼科(医生组), doctorCode=mEmployees1912130016, doctorNo=null, doctorName=陶冶, levelCode=ordinary, levelName=普通挂号费, counselorCode=mEmployees1912120005, counselorNo=null, counselorName=徐铮, outsideDoctor=, visitTime=2020-03-13 16:21:05, status=yes_doctor, lineNumber=450, chargeType=self_chargeType, chargeChannel=lineOff_customerFromType, reservationType=outpatient_scheduleClassType, illnessTypeName=屈光手术, illnessTypeCode=refractive_surgery, counselorStatus=0, containSetMeal=true, registerPrice=850.5000, visitDetails=null, age=0, paramName=null, provideStatus=null, startTime=null, endTime=null, diagnosis=null, visitTypes=null, provideCode=null, genderName=null, caseHistoryNo=null, memberBirthdayShow=null, visitTypeName=null, roomName=null, memberType=null, marker=null, isAppointment=null, mealFee=null, registFee=null, type=null, checkProjects=null, provideName=null, operationStatus=null, isHaveCase=null)

2020-03-13 18:44:19 | INFO | http-nio-8085-exec-10 | com.newretail.hospital.service.impl.HCheckServiceImpl | room:{result=true, msg=查询成功, data={ascs=[], descs=[], id=1, code=mRooms1912120001, isEffect=true, isDelete=false, createByCode=user191212140126000001, createByNo=北京茗视光眼科admin, createByName=北京茗视光眼科管理员, createDate=2019-12-12 15:21:21, updateByCode=user191212140126000001, updateByNo=北京茗视光眼科admin, updateByName=北京茗视光眼科管理员, updateDate=2019-12-12 15:21:21, version=1, companyCode=company191212140126000001, isShared=false, deviceNo=001, name=初检室1, purposeType=preliminary_laboratory, isExecution=true}}

2020-03-13 18:44:19 | INFO | http-nio-8085-exec-10 | com.newretail.common.util.SequenceUtil | create sequence hCheck2003130045, date: Fri Mar 13 18:44:19 CST 2020

2020-03-13 18:44:19 | INFO | http-nio-8085-exec-10 | com.newretail.common.util.UserInfoUtils | ---getUserInfo code as taoye---

Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4b7b1f50] from current transaction

==> Preparing: INSERT INTO h_check ( check_no, medical_no, visit_code, advice_detail_code, member_code, member_name, gender, certificate_type, certificate_id, member_birthday, mobile, line_no, order_no, dept_code, dept_no, dept_name, doctor_code, doctor_no, doctor_name, provide_code, provide_no, provide_name, room_use, room_code, room_name, call_status, company_code, code, remark, create_by_code, create_by_no, create_by_name, create_date, update_by_code, update_by_no, update_by_name, update_date ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )

==> Parameters: JC2003000048(String), 20000115(String), HVisit2003130004(String), hAdviceDetail2003130046(String), CMember2003120006(String), 测试数据(String), female(String), china_id_certificateType(String), 391018199002041147(String), 1990-02-04 00:00:00(String), 18716677814(String), 450(Integer), 450(Integer), organization20191212150433000014(String), 001(String), 眼科(医生组)(String), mEmployees1912130016(String), 00031(String), 陶冶(String), mProvides1912120025(String), (String), 裸眼近视力检查(String), preliminary_laboratory(String), mRooms1912120001(String), 初检室1(String), 0(String), company191212140126000001(String), hCheck2003130045(String), (String), user191216154506000003(String), (String), 陶冶(String), 2020-03-13 18:44:19(String), user191216154506000003(String), (String), 陶冶(String), 2020-03-13 18:44:19(String)

INSERT INTO h_check ( check_no, medical_no, visit_code, advice_detail_code, member_code, member_name, gender, certificate_type, certificate_id, member_birthday, mobile, line_no, order_no, dept_code, dept_no, dept_name, doctor_code, doctor_no, doctor_name, provide_code, provide_no, provide_name, room_use, room_code, room_name, call_status, company_code, code, remark, create_by_code, create_by_no, create_by_name, create_date, update_by_code, update_by_no, update_by_name, update_date ) VALUES ( 'JC2003000048', '20000115', 'HVisit2003130004', 'hAdviceDetail2003130046', 'CMember2003120006', '测试数据', 'female', 'china_id_certificateType', '391018199002041147', '1990-02-04 00:00:00', '18716677814', 450, 450, 'organization20191212150433000014', '001', '眼科(医生组)', 'mEmployees1912130016', '00031', '陶冶', 'mProvides1912120025', '', '裸眼近视力检查', 'preliminary_laboratory', 'mRooms1912120001', '初检室1', '0', 'company191212140126000001', 'hCheck2003130045', '', 'user191216154506000003', '', '陶冶', '2020-03-13 18:44:19', 'user191216154506000003', '', '陶冶', '2020-03-13 18:44:19' );

<== Updates: 1

Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4b7b1f50]

Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4b7b1f50] from current transaction

==> Preparing: UPDATE h_visit SET status=?, version=version+1 WHERE code = ?

==> Parameters: get_check(String), HVisit2003130004(String)

UPDATE h_visit SET status='get_check', version=version+1 WHERE code = 'HVisit2003130004';

<== Updates: 1

Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4b7b1f50]

2020-03-13 18:44:19 | INFO | http-nio-8085-exec-10 | com.newretail.hospital.service.impl.HAdviceServiceImpl | 返回写入检查表信息结果：service:result:true

Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4b7b1f50] from current transaction

==> Preparing: UPDATE c_member_set_meal SET status=?, is_effect=?, version=version+1 WHERE sell_meal_code = ? AND set_meal_code = ? AND member_code = ? AND set_meal_detail_code = ?

==> Parameters: 1(String), false(Boolean), SELL2003120002(String), mSetMeal20191213112835000009(String), CMember2003120006(String), mSetMealProvides2003040169(String)

UPDATE c_member_set_meal SET status='1', is_effect=false, version=version+1 WHERE sell_meal_code = 'SELL2003120002' AND set_meal_code = 'mSetMeal20191213112835000009' AND member_code = 'CMember2003120006' AND set_meal_detail_code = 'mSetMealProvides2003040169';

<== Updates: 1

Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4b7b1f50]

Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4b7b1f50] from current transaction

==> Preparing: INSERT INTO h_advice ( advice_type, visit_code, medical_no, member_code, member_name, gender, certificate_type, certificate_id, mobile, diagnosis_result, assistant_code, assistant_no, assistant_name, doctor_code, doctor_no, doctor_name, dept_code, dept_no, dept_name, payment_status, company_code, code, create_by_code, create_by_no, create_by_name, create_date, update_by_code, update_by_no, update_by_name, update_date ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )

==> Parameters: 1(String), HVisit2003130004(String), 20000115(String), CMember2003120006(String), 测试数据(String), female(String), china_id_certificateType(String), 391018199002041147(String), 18716677814(String), 临床诊断结果(String), (String), (String), (String), mEmployees1912130016(String), 00031(String), 陶冶(String), organization20191212150433000014(String), 001(String), 眼科(医生组)(String), 0(String), company191212140126000001(String), hAdvice2003130033(String), user191216154506000003(String), taoye(String), 陶冶(String), 2020-03-13 18:44:18(String), user191216154506000003(String), taoye(String), 陶冶(String), 2020-03-13 18:44:18(String)

INSERT INTO h_advice ( advice_type, visit_code, medical_no, member_code, member_name, gender, certificate_type, certificate_id, mobile, diagnosis_result, assistant_code, assistant_no, assistant_name, doctor_code, doctor_no, doctor_name, dept_code, dept_no, dept_name, payment_status, company_code, code, create_by_code, create_by_no, create_by_name, create_date, update_by_code, update_by_no, update_by_name, update_date ) VALUES ( '1', 'HVisit2003130004', '20000115', 'CMember2003120006', '测试数据', 'female', 'china_id_certificateType', '391018199002041147', '18716677814', '临床诊断结果', '', '', '', 'mEmployees1912130016', '00031', '陶冶', 'organization20191212150433000014', '001', '眼科(医生组)', '0', 'company191212140126000001', 'hAdvice2003130033', 'user191216154506000003', 'taoye', '陶冶', '2020-03-13 18:44:18', 'user191216154506000003', 'taoye', '陶冶', '2020-03-13 18:44:18' );

<== Updates: 1

Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4b7b1f50]

2020-03-13 18:44:19 | INFO | http-nio-8085-exec-10 | com.newretail.common.util.SequenceUtil | create sequence CF200313000033, date: Fri Mar 13 18:44:19 CST 2020

2020-03-13 18:44:19 | INFO | http-nio-8085-exec-10 | com.newretail.hospital.service.impl.HAdviceServiceImpl | 调用付款请求结果：service:param:[BaseModel{companyCode='null', isShared=false}]

2020-03-13 18:44:19 | INFO | http-nio-8085-exec-2 | com.newretail.hospital.controller.HVisitController | 分页查询就诊表,param:HVisitDTO(memberCode=null, memberName=null, memberBirthday=null, certificateType=null, certificateId=null, gender=null, mobilePhone=null, reservationCode=null, reservationDate=null, visitType=null, registerType=null, medicalNo=null, deptCode=null, deptNo=null, deptName=null, doctorCode=null, doctorNo=null, doctorName=null, levelCode=null, levelName=null, counselorCode=null, counselorNo=null, counselorName=null, visitTime=null, status=null, neStatus=null, visitDetails=null, marker=null, memberType=null, lineNumber=null, chargeType=null, chargeChannel=null, reservationType=null, illnessTypeName=null, illnessTypeCode=null, counselorStatus=null, containSetMeal=null, registerPrice=null, age=0, paramName=null, provideStatus=null, startTime=null, endTime=null, diagnosis=null, visitTypes=null, provideCode=null, genderName=null, caseHistoryNo=null, memberBirthdayShow=null, visitTypeName=null, roomName=null, queryStr=null)

Creating a new SqlSession

SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2dcec57d] was not registered for synchronization because synchronization is not active

JDBC Connection [com.p6spy.engine.wrapper.ConnectionWrapper@797e31b4] will not be managed by Spring

==> Parameters: HVisit2003130004(String)

<== Total: 1

Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2dcec57d]

2020-03-13 18:44:19 | INFO | http-nio-8085-exec-3 | com.newretail.hospital.controller.HAdviceDetailController | 支付成功或者失败更改支付状态:controller:param:{"adviceDTOS":[{"classApplyNo":"JC2003000048","code":"hAdviceDetail2003130046","dayNumber":"0","paymentStatus":"0","provideType":"check","realPrice":0,"status":"0"}],"updateDate":"2020-03-13 18:44:18","visitCode":"HVisit2003130004"}

Creating a new SqlSession

Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@3b66462c]

JDBC Connection [com.p6spy.engine.wrapper.ConnectionWrapper@114ae7f8] will be managed by Spring

==> Preparing: UPDATE h_visit_detail SET visit_code=?, provide_type=?, status=?, update_date=?, version=version+1 WHERE visit_code = ? AND provide_type = ?

==> Parameters: HVisit2003130004(String), visit_check(String), 2(String), 2020-03-13 18:44:19(String), HVisit2003130004(String), visit_check(String)

UPDATE h_visit_detail SET visit_code='HVisit2003130004', provide_type='visit_check', status='2', update_date='2020-03-13 18:44:19', version=version+1 WHERE visit_code = 'HVisit2003130004' AND provide_type = 'visit_check';

Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@3b66462c]

Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@3b66462c]

Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@3b66462c]

2020-03-13 18:45:10 | WARN | http-nio-8085-exec-3 | com.newretail.hospital.config.ControllerAdvice | 未知异常

com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:123)

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)

at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)

at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:974)

at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:391)

at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)

at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)

at com.p6spy.engine.wrapper.PreparedStatementWrapper.execute(PreparedStatementWrapper.java:362)

at sun.reflect.GeneratedMethodAccessor168.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)

at com.sun.proxy.$Proxy255.execute(Unknown Source)

at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47)

at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)

at sun.reflect.GeneratedMethodAccessor273.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)

at com.sun.proxy.$Proxy254.update(Unknown Source)

at com.baomidou.mybatisplus.core.executor.MybatisSimpleExecutor.doUpdate(MybatisSimpleExecutor.java:54)

at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)

at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)

at sun.reflect.GeneratedMethodAccessor272.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)

at com.baomidou.mybatisplus.extension.plugins.OptimisticLockerInterceptor.intercept(OptimisticLockerInterceptor.java:117)

at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)

at com.sun.proxy.$Proxy252.update(Unknown Source)

at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:197)

at sun.reflect.GeneratedMethodAccessor405.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)

at com.sun.proxy.$Proxy148.update(Unknown Source)

at org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:294)

at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:63)

at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:62)

at com.sun.proxy.$Proxy163.update(Unknown Source)

at com.newretail.hospital.service.impl.HVisitDetailServiceImpl.updateVisitDetailStatus(HVisitDetailServiceImpl.java:46)

at com.newretail.hospital.service.impl.HVisitDetailServiceImpl$$FastClassBySpringCGLIB$$10352248.invoke()

at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)

at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:749)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)

at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294)

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)

at com.baomidou.dynamic.datasource.aop.DynamicDataSourceAnnotationInterceptor.invoke(DynamicDataSourceAnnotationInterceptor.java:52)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)

at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)

at com.newretail.hospital.service.impl.HVisitDetailServiceImpl$$EnhancerBySpringCGLIB$$ad1158b.updateVisitDetailStatus()

at com.newretail.hospital.service.impl.HAdviceDetailServiceImpl.updateStatus(HAdviceDetailServiceImpl.java:1510)

at com.newretail.hospital.service.impl.HAdviceDetailServiceImpl$$FastClassBySpringCGLIB$$58c69a3d.invoke()