线上关于数据库的诊断问题

来源: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程所使用的连接池配置。

0
0

MySQL提升课程 全面讲解MySQL架构设计

面面俱到讲解影响MySQL性能的各个因素,让MySQL架构了然于胸。

4419 学习 · 547 问题

查看课程