发布物模型提示数据库错误

Blade 未结 1 72

一、该问题的重现步骤是什么?

1. 我使用的是2.0版本并且融合了bladex4.5.0 的物联网系统
报错信息:### Error updating database. Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'data_snapshot' at row 1 ### The error may exist in org/springblade/iot/product/mapper/ProductVersionMapper.java (best guess) ### The error may involve org.springblade.iot.product.mapper.ProductVersionMapper.insert-Inline ### The error occurred while setting parameters ### SQL: INSERT INTO iot_product_version (id, product_id, product_key, version_no, version_desc, data_status, data_snapshot, create_user, create_dept, create_time, update_user, update_time, status, is_deleted) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ### Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'data_snapshot' at row 1 ; Data truncation: Data too long for column 'data_snapshot' at row 1

2. 有四十个属性

{

  "profile": {

    "productKey": "XrSgk3R9MlgQ",

    "version": "2"

  },

  "properties": [

    {

      "identifier": "machRun",

      "name": "机床运行状态",

      "accessMode": "rw",

      "required": true,

      "dataType": {

        "type": "text",

        "specs": {

          "length": "64"

        }

      }

    },

    {

      "identifier": "serAxNum",

      "name": "伺服轴数",

      "accessMode": "rw",

      "required": true,

      "dataType": {

        "type": "text",

        "specs": {

          "length": "64"

        }

      }

    },

image.png

1条回答
  • 如果物模型特别多,容量很大的话,data_snapshot字段改成longtext类型就可以了

    1 讨论(0)
代码语言
提交回复