处理启动失败问题

puzhibing

2026-02-12 698bfd0466194891a191c8cda57f31c46e64572b

处理启动失败问题

 sql/nacos_config_export_20260212142234.zip

Binary files differ

 xp-robotaxi-automaticPilot-boot/src/main/resources/bootstrap.yml

@@ -157,4 +157,203 @@
        file-extension: yml
        # 共享配置
        shared-configs:
          - application-${spring.profiles.active}.${spring.cloud.nacos.config.file-extension}
          - application-${spring.profiles.active}.${spring.cloud.nacos.config.file-extension}

---

spring:
  shardingsphere:
    mode:
      type: Standalone
      repository:
        type: File
      overwrite: true
    datasource:
      names: xp0
      xp0:
        type: com.alibaba.druid.pool.DruidDataSource
        driver-class-name: com.mysql.cj.jdbc.Driver
        url: jdbc:mysql://192.168.110.34:3306/xprt_maintenance?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
        username: root
        password: 123456
        druid:
          # 连接池初始化时创建的连接数。
          # 应根据实际应用场景设置，确保应用程序启动时即可获取数据库连接。
          initial-size: 10
          # 连接池中最小的空闲连接数，保证即使在低负载时也有足够的连接可用。
          min-idle: 10
          # 连接池中最大活动连接数，限制并发请求时的数据库连接数，避免过多的连接消耗系统资源。
          max-active: 100
          # 获取连接时的最大等待时间，超过该时间则抛出异常。单位通常为毫秒。
          max-wait: 60000
          # 两个连接检查之间的时间间隔，用于检测和清理空闲过久的连接。单位为毫秒。
          time-between-eviction-runs-millis: 60000
          # 连接在被清理前的最小空闲时间。单位为毫秒。
          min-evictable-idle-time-millis: 300000
          # 用于验证连接有效性的 SQL 查询语句。
          validation-query: SELECT 1
          # 如果为真，则连接空闲时会被定期测试有效性。
          test-while-idle: true
          # 如果为真，在获取连接前进行有效性测试。
          test-on-borrow: false
          # 如果为真，在归还连接时进行有效性测试。
          test-on-return: false
          # 是否开启 PreparedStatement 缓存。
          pool-prepared-statements: true
          # 单个连接上缓存的 PreparedStatement 最大数量。
          max-pool-prepared-statement-per-connection-size: 20
          # 指定要启用的过滤器，如 stat, log4j, wall 等，用于监控和日志记录。
          filters: stat,wall,log4j
          # 连接属性，例如配置日志级别或慢 SQL 阈值。
          connection-properties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000
          # 是否自动回收超时连接
          remove-abandoned: true
          # 超时时间，单位秒
          remove-abandoned-timeout: 1800
          # 是否记录被遗弃的连接
          log-abandoned: true
          # StatViewServlet配置，访问监控页面
          stat-view-servlet:
            enabled: true
            url-pattern: /druid/*
            login-username: admin
            login-password: admin
            reset-enable: false
          # 防火墙配置
          wall:
            config:
              multi-statement-allow: false
    rules:
      sharding:
        tables:
          xp_charging_record:
            standard:
              sharding-column: vehicle_id
              sharding-algorithm-name: xp_charging_record_inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
          xp_clock_in:
            standard:
              sharding-column: app_user_id
              sharding-algorithm-name: xp_clock_in_inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
          xp_task:
            standard:
              sharding-column: vehicle_id
              sharding-algorithm-name: xp_task_inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
          xp_task_handle_detail:
            standard:
              sharding-column: task_id
              sharding-algorithm-name: xp_task_handle_detail_inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
          xp_task_handle_detail_routine:
            standard:
              sharding-column: task_id
              sharding-algorithm-name: xp_task_handle_detail_routine_inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
          xp_vehicle_detection:
            standard:
              sharding-column: task_id
              sharding-algorithm-name: xp_vehicle_detection_inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
          xp_vehicle_preparation:
            standard:
              sharding-column: task_id
              sharding-algorithm-name: xp_vehicle_preparation_inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
          xp_vehicle_repair:
            standard:
              sharding-column: task_id
              sharding-algorithm-name: xp_vehicle_repair_inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
          xp_work_order:
            standard:
              sharding-column: feedback_user_phone
              sharding-algorithm-name: xp_work_order_inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
          xp_work_order_log:
            standard:
              sharding-column: work_order_id
              sharding-algorithm-name: xp_work_order_log_inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
      sharding-algorithms:
        xp_charging_record_inline:
          type: INLINE
          props:
            algorithm-expression: xp0.xp_charging_record_${vehicle_id % 20}
        xp_clock_in_inline:
          type: INLINE
          props:
            algorithm-expression: xp0.xp_clock_in_${app_user_id % 10}
        xp_task_inline:
          type: INLINE
          props:
            algorithm-expression: xp0.xp_task_${vehicle_id % 20}
        xp_task_handle_detail_inline:
          type: INLINE
          props:
            algorithm-expression: xp0.xp_task_handle_detail_${task_id % 20}
        xp_task_handle_detail_routine_inline:
          type: INLINE
          props:
            algorithm-expression: xp0.xp_task_handle_detail_routine_${task_id % 20}
        xp_vehicle_detection_inline:
          type: INLINE
          props:
            algorithm-expression: xp0.xp_vehicle_detection_${task_id % 10}
        xp_vehicle_preparation_inline:
          type: INLINE
          props:
            algorithm-expression: xp0.xp_vehicle_preparation_${task_id % 10}
        xp_vehicle_repair_inline:
          type: INLINE
          props:
            algorithm-expression: xp0.xp_vehicle_repair_${task_id % 10}
        xp_work_order_inline:
          type: INLINE
          props:
            algorithm-expression: xp0.xp_work_order_${feedback_user_phone % 10}
        xp_work_order_log_inline:
          type: INLINE
          props:
            algorithm-expression: xp0.xp_work_order_log_${work_order_id % 20}

        single-table:
          tables:
            - xp0.xp_check_location
            - xp0.xp_fleet
            - xp0.xp_fleet_operations
            - xp0.xp_fleet_vehicle
            - xp0.xp_policy_application
            - xp0.xp_position
            - xp0.xp_scheduling
            - xp0.xp_scheduling_detail
            - xp0.xp_shift
            - xp0.xp_task_rule
            - xp0.xp_task_rule_role
            - xp0.xp_vehicle
            - xp0.xp_vehicle_clean
            - xp0.xp_vehicle_description
    props:
      sql-show: true
      sql-simple: true

 xp-robotaxi-pushMessage-boot/src/main/resources/bootstrap.yml

@@ -157,4 +157,139 @@
        file-extension: yml
        # 共享配置
        shared-configs:
          - application-${spring.profiles.active}.${spring.cloud.nacos.config.file-extension}
          - application-${spring.profiles.active}.${spring.cloud.nacos.config.file-extension}

---
spring:
  shardingsphere:
    mode:
      type: Standalone
      repository:
        type: File
      overwrite: true
    datasource:
      names: xp0
      xp0:
        type: com.alibaba.druid.pool.DruidDataSource
        driver-class-name: com.mysql.cj.jdbc.Driver
        url: jdbc:mysql://192.168.110.34:3306/xprt_operation?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
        username: root
        password: 123456
        druid:
          # 连接池初始化时创建的连接数。
          # 应根据实际应用场景设置，确保应用程序启动时即可获取数据库连接。
          initial-size: 10
          # 连接池中最小的空闲连接数，保证即使在低负载时也有足够的连接可用。
          min-idle: 10
          # 连接池中最大活动连接数，限制并发请求时的数据库连接数，避免过多的连接消耗系统资源。
          max-active: 100
          # 获取连接时的最大等待时间，超过该时间则抛出异常。单位通常为毫秒。
          max-wait: 60000
          # 两个连接检查之间的时间间隔，用于检测和清理空闲过久的连接。单位为毫秒。
          time-between-eviction-runs-millis: 60000
          # 连接在被清理前的最小空闲时间。单位为毫秒。
          min-evictable-idle-time-millis: 300000
          # 用于验证连接有效性的 SQL 查询语句。
          validation-query: SELECT 1
          # 如果为真，则连接空闲时会被定期测试有效性。
          test-while-idle: true
          # 如果为真，在获取连接前进行有效性测试。
          test-on-borrow: false
          # 如果为真，在归还连接时进行有效性测试。
          test-on-return: false
          # 是否开启 PreparedStatement 缓存。
          pool-prepared-statements: true
          # 单个连接上缓存的 PreparedStatement 最大数量。
          max-pool-prepared-statement-per-connection-size: 20
          # 指定要启用的过滤器，如 stat, log4j, wall 等，用于监控和日志记录。
          filters: stat,wall,log4j
          # 连接属性，例如配置日志级别或慢 SQL 阈值。
          connection-properties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000
          # 是否自动回收超时连接
          remove-abandoned: true
          # 超时时间，单位秒
          remove-abandoned-timeout: 1800
          # 是否记录被遗弃的连接
          log-abandoned: true
          # StatViewServlet配置，访问监控页面
          stat-view-servlet:
            enabled: true
            url-pattern: /druid/*
            login-username: admin
            login-password: admin
            reset-enable: false
          # 防火墙配置
          wall:
            config:
              multi-statement-allow: false
    rules:
      sharding:
        tables:
          sys_oper_log:
            standard:
              sharding-column: userId
              sharding-algorithm-name: sys_oper_log_inline
            key-generate-strategy:
              column: oper_id
              key-generator-name: snowflake
          xp_agreement_app_user:
            standard:
              sharding-column: app_user_id
              sharding-algorithm-name: xp_agreement_app_user_inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
          xp_point:
            standard:
              sharding-column: id
              sharding-algorithm-name: xp_point_inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
      sharding-algorithms:
        sys_oper_log_inline:
          type: INLINE
          props:
            algorithm-expression: xp0.sys_oper_log_${userId % 10}
        xp_agreement_app_user_inline:
          type: INLINE
          props:
            algorithm-expression: xp0.xp_agreement_app_user_${app_user_id % 10}
        xp_point_inline:
          type: INLINE
          props:
            algorithm-expression: xp0.xp_point_${id % 10}

        single-table:
          tables:
            - xp0.sys_config
            - xp0.sys_dict_data
            - xp0.sys_dict_type
            - xp0.sys_logininfor
            - xp0.sys_menu
            - xp0.xp_acticity
            - xp0.xp_acticity_coupon
            - xp0.xp_agreement
            - xp0.xp_banner
            - xp0.xp_coupon
            - xp0.xp_electronic_fence
            - xp0.xp_electronic_fence_area
            - xp0.xp_feedback_type
            - xp0.xp_frequently_asked_questions
            - xp0.xp_invitation_code
            - xp0.xp_notification
            - xp0.xp_open_city
            - xp0.xp_pricing
            - xp0.xp_pricing_item
            - xp0.xp_region
            - xp0.xp_ride_guide
            - xp0.xp_route_plan
            - xp0.xp_system_setting
            - xp0.xp_trading_strategy
            - xp0.xp_trading_strategy_city
            - xp0.xp_user_feedback
            - xp0.xp_whitelist
            - xp0.xp_whitelist_operlog
    props:
      sql-show: true
      sql-simple: true

 xp-robotaxi-remoteDriving-boot/src/main/resources/bootstrap.yml

@@ -159,4 +159,140 @@
        file-extension: yml
        # 共享配置
        shared-configs:
          - application-${spring.profiles.active}.${spring.cloud.nacos.config.file-extension}
          - application-${spring.profiles.active}.${spring.cloud.nacos.config.file-extension}


---
spring:
  shardingsphere:
    mode:
      type: Standalone
      repository:
        type: File
      overwrite: true
    datasource:
      names: xp0
      xp0:
        type: com.alibaba.druid.pool.DruidDataSource
        driver-class-name: com.mysql.cj.jdbc.Driver
        url: jdbc:mysql://192.168.110.34:3306/xprt_operation?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
        username: root
        password: 123456
        druid:
          # 连接池初始化时创建的连接数。
          # 应根据实际应用场景设置，确保应用程序启动时即可获取数据库连接。
          initial-size: 10
          # 连接池中最小的空闲连接数，保证即使在低负载时也有足够的连接可用。
          min-idle: 10
          # 连接池中最大活动连接数，限制并发请求时的数据库连接数，避免过多的连接消耗系统资源。
          max-active: 100
          # 获取连接时的最大等待时间，超过该时间则抛出异常。单位通常为毫秒。
          max-wait: 60000
          # 两个连接检查之间的时间间隔，用于检测和清理空闲过久的连接。单位为毫秒。
          time-between-eviction-runs-millis: 60000
          # 连接在被清理前的最小空闲时间。单位为毫秒。
          min-evictable-idle-time-millis: 300000
          # 用于验证连接有效性的 SQL 查询语句。
          validation-query: SELECT 1
          # 如果为真，则连接空闲时会被定期测试有效性。
          test-while-idle: true
          # 如果为真，在获取连接前进行有效性测试。
          test-on-borrow: false
          # 如果为真，在归还连接时进行有效性测试。
          test-on-return: false
          # 是否开启 PreparedStatement 缓存。
          pool-prepared-statements: true
          # 单个连接上缓存的 PreparedStatement 最大数量。
          max-pool-prepared-statement-per-connection-size: 20
          # 指定要启用的过滤器，如 stat, log4j, wall 等，用于监控和日志记录。
          filters: stat,wall,log4j
          # 连接属性，例如配置日志级别或慢 SQL 阈值。
          connection-properties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000
          # 是否自动回收超时连接
          remove-abandoned: true
          # 超时时间，单位秒
          remove-abandoned-timeout: 1800
          # 是否记录被遗弃的连接
          log-abandoned: true
          # StatViewServlet配置，访问监控页面
          stat-view-servlet:
            enabled: true
            url-pattern: /druid/*
            login-username: admin
            login-password: admin
            reset-enable: false
          # 防火墙配置
          wall:
            config:
              multi-statement-allow: false
    rules:
      sharding:
        tables:
          sys_oper_log:
            standard:
              sharding-column: userId
              sharding-algorithm-name: sys_oper_log_inline
            key-generate-strategy:
              column: oper_id
              key-generator-name: snowflake
          xp_agreement_app_user:
            standard:
              sharding-column: app_user_id
              sharding-algorithm-name: xp_agreement_app_user_inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
          xp_point:
            standard:
              sharding-column: id
              sharding-algorithm-name: xp_point_inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
      sharding-algorithms:
        sys_oper_log_inline:
          type: INLINE
          props:
            algorithm-expression: xp0.sys_oper_log_${userId % 10}
        xp_agreement_app_user_inline:
          type: INLINE
          props:
            algorithm-expression: xp0.xp_agreement_app_user_${app_user_id % 10}
        xp_point_inline:
          type: INLINE
          props:
            algorithm-expression: xp0.xp_point_${id % 10}

        single-table:
          tables:
            - xp0.sys_config
            - xp0.sys_dict_data
            - xp0.sys_dict_type
            - xp0.sys_logininfor
            - xp0.sys_menu
            - xp0.xp_acticity
            - xp0.xp_acticity_coupon
            - xp0.xp_agreement
            - xp0.xp_banner
            - xp0.xp_coupon
            - xp0.xp_electronic_fence
            - xp0.xp_electronic_fence_area
            - xp0.xp_feedback_type
            - xp0.xp_frequently_asked_questions
            - xp0.xp_invitation_code
            - xp0.xp_notification
            - xp0.xp_open_city
            - xp0.xp_pricing
            - xp0.xp_pricing_item
            - xp0.xp_region
            - xp0.xp_ride_guide
            - xp0.xp_route_plan
            - xp0.xp_system_setting
            - xp0.xp_trading_strategy
            - xp0.xp_trading_strategy_city
            - xp0.xp_user_feedback
            - xp0.xp_whitelist
            - xp0.xp_whitelist_operlog
    props:
      sql-show: true
      sql-simple: true

 xp-robotaxi-vehicleConvoy-boot/src/main/java/com/xiaopeng/vehicleConvoy/controller/XpFleetController.java

@@ -5,8 +5,6 @@
import com.xiaopeng.vehicleConvoy.service.IXpFleetService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.apache.shardingsphere.transaction.annotation.ShardingSphereTransactionType;
import org.apache.shardingsphere.transaction.core.TransactionType;
import org.springframework.util.CollectionUtils;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestBody;

 xp-robotaxi-vehicleConvoy-boot/src/main/resources/bootstrap.yml

@@ -160,7 +160,137 @@
          - application-${spring.profiles.active}.${spring.cloud.nacos.config.file-extension}

---
logging:
  level:
    springfox: DEBUG
    org.springframework.web: DEBUG

spring:
  shardingsphere:
    mode:
      type: Standalone
      repository:
        type: File
      overwrite: true
    datasource:
      names: xp0
      xp0:
        type: com.alibaba.druid.pool.DruidDataSource
        driver-class-name: com.mysql.cj.jdbc.Driver
        url: jdbc:mysql://192.168.110.34:3306/xprt_operation?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
        username: root
        password: 123456
        druid:
          # 连接池初始化时创建的连接数。
          # 应根据实际应用场景设置，确保应用程序启动时即可获取数据库连接。
          initial-size: 10
          # 连接池中最小的空闲连接数，保证即使在低负载时也有足够的连接可用。
          min-idle: 10
          # 连接池中最大活动连接数，限制并发请求时的数据库连接数，避免过多的连接消耗系统资源。
          max-active: 100
          # 获取连接时的最大等待时间，超过该时间则抛出异常。单位通常为毫秒。
          max-wait: 60000
          # 两个连接检查之间的时间间隔，用于检测和清理空闲过久的连接。单位为毫秒。
          time-between-eviction-runs-millis: 60000
          # 连接在被清理前的最小空闲时间。单位为毫秒。
          min-evictable-idle-time-millis: 300000
          # 用于验证连接有效性的 SQL 查询语句。
          validation-query: SELECT 1
          # 如果为真，则连接空闲时会被定期测试有效性。
          test-while-idle: true
          # 如果为真，在获取连接前进行有效性测试。
          test-on-borrow: false
          # 如果为真，在归还连接时进行有效性测试。
          test-on-return: false
          # 是否开启 PreparedStatement 缓存。
          pool-prepared-statements: true
          # 单个连接上缓存的 PreparedStatement 最大数量。
          max-pool-prepared-statement-per-connection-size: 20
          # 指定要启用的过滤器，如 stat, log4j, wall 等，用于监控和日志记录。
          filters: stat,wall,log4j
          # 连接属性，例如配置日志级别或慢 SQL 阈值。
          connection-properties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000
          # 是否自动回收超时连接
          remove-abandoned: true
          # 超时时间，单位秒
          remove-abandoned-timeout: 1800
          # 是否记录被遗弃的连接
          log-abandoned: true
          # StatViewServlet配置，访问监控页面
          stat-view-servlet:
            enabled: true
            url-pattern: /druid/*
            login-username: admin
            login-password: admin
            reset-enable: false
          # 防火墙配置
          wall:
            config:
              multi-statement-allow: false
    rules:
      sharding:
        tables:
          sys_oper_log:
            standard:
              sharding-column: userId
              sharding-algorithm-name: sys_oper_log_inline
            key-generate-strategy:
              column: oper_id
              key-generator-name: snowflake
          xp_agreement_app_user:
            standard:
              sharding-column: app_user_id
              sharding-algorithm-name: xp_agreement_app_user_inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
          xp_point:
            standard:
              sharding-column: id
              sharding-algorithm-name: xp_point_inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
      sharding-algorithms:
        sys_oper_log_inline:
          type: INLINE
          props:
            algorithm-expression: xp0.sys_oper_log_${userId % 10}
        xp_agreement_app_user_inline:
          type: INLINE
          props:
            algorithm-expression: xp0.xp_agreement_app_user_${app_user_id % 10}
        xp_point_inline:
          type: INLINE
          props:
            algorithm-expression: xp0.xp_point_${id % 10}

        single-table:
          tables:
            - xp0.sys_config
            - xp0.sys_dict_data
            - xp0.sys_dict_type
            - xp0.sys_logininfor
            - xp0.sys_menu
            - xp0.xp_acticity
            - xp0.xp_acticity_coupon
            - xp0.xp_agreement
            - xp0.xp_banner
            - xp0.xp_coupon
            - xp0.xp_electronic_fence
            - xp0.xp_electronic_fence_area
            - xp0.xp_feedback_type
            - xp0.xp_frequently_asked_questions
            - xp0.xp_invitation_code
            - xp0.xp_notification
            - xp0.xp_open_city
            - xp0.xp_pricing
            - xp0.xp_pricing_item
            - xp0.xp_region
            - xp0.xp_ride_guide
            - xp0.xp_route_plan
            - xp0.xp_system_setting
            - xp0.xp_trading_strategy
            - xp0.xp_trading_strategy_city
            - xp0.xp_user_feedback
            - xp0.xp_whitelist
            - xp0.xp_whitelist_operlog
    props:
      sql-show: true
      sql-simple: true