线上关于数据库的诊断问题
来源:9-2 数据库可用性监控

苦瓜苦也
2020-07-20
2020-07-18 23:33:24 ERROR - 【订单系统异常】:
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error updating database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.alibaba.druid.pool.GetConnectionTimeoutException: wait millis 60000, active 3, maxActive 50, creating 1, runningSqlCount 1 : SELECT o.free_strategy_id AS freeStrategyId, o.customer_name AS customerName, o.customer_phone AS customerPhone, o.live_contact_phone AS liveContactPhone, o.actual_contact_phone AS actualContactPhone
, org.organization_code AS organizationCode, org.organization_name AS organizationName, org.h5_synchronous_switch AS h5SynchronousSwitch, o.supplier_code AS supplierCode, o.bank_card_type AS bankCardType
, o.bank_customer_no AS bankCustomerNo, o.bank_card_no AS bankCardNo, o.customer_label_code AS customerLabelCode, o.authorizer AS authorizer, o.string_code AS stringCode
, o.is_pr_list AS isPrList, o.billing_method AS billingMethod, o.third_order_no AS thirdOrderNo, o.big_service_type_code AS bigServiceTypeCode, o.small_service_type_code AS smallServiceTypeCode
, o.reservation_time AS reservationTime, date_format(o.reservation_time, '%Y-%m-%d %H:%i:%s') AS reservationTimeStr, o.estimated_mileage AS estimatedMileage
, o.actual_mileage AS actualMileage, o.order_no AS orderNo, o.h5_order_no AS h5OrderNo, o.state, o.source
, o.remark, ge.dep_location AS depLocation, ge.destination, ge.city_code AS cityCode, o.driver_code AS driverCode
, o.perm_code AS permCode, o.driver_name AS driverName, o.driver_phone AS driverPhone, o.vehicle_model AS vehicleModel, o.vehicle_grade AS vehicleGrade
, o.carNo AS carNo, ge.longitude AS longitude, ge.latitude AS latitude, ge.country, o.open_case_style AS openCaseStyle
, o.rights_code AS rightsCode, o.is_arrive_time AS isArriveTime, o.is_complete AS isComplete, o.is_outer_ring AS isOuterRing, a.flight_no AS flightNo
, o.virtual_phone AS virtualPhone, o.premium_customers AS premiumCustomers, o.cancel_reason AS cancelReason
, (
SELECT os.operator
FROM y_order_state_time os
WHERE os.order_no = o.order_no
AND os.time_type = ?
LIMIT ?
) AS cancelOperator
, (
SELECT os.operator
FROM y_order_state_time os
WHERE os.order_no = o.order_no
AND os.time_type = ?
LIMIT ?
说是JAVA连不上数据库 数据库的连接数没有占满会有什么错误导致
写回答
1回答
-
sqlercn
2020-07-20
这个并不是课程中的问题,你可以看一下你的Java程所使用的连接池配置。
00
相似问题
关于mysql与程序端连接异常断开的问题
回答 1
写入内存会不会造成数据丢失?
回答 2
关于对已有数据的大表进行水平分表?
回答 1
从数据库中断复制的恢复方法
回答 1
什么是主从数据库?
回答 1