apache / incubator-seata

:fire: Seata is an easy-to-use, high-performance, open source distributed transaction solution.
https://seata.apache.org/
Apache License 2.0
25.31k stars 8.78k forks source link

Data too long for column table_name? #3572

Open Martinprobu opened 3 years ago

Martinprobu commented 3 years ago

{ "code": "S0001", "engDesc": null, "chnDesc": null, "detail": "供应商操作失败:{0}", "content": "错误描述:供应商操作失败:{0}\n### Error updating database. Cause: java.sql.SQLException: io.seata.core.exception.RmTransactionException: Response[ TransactionException[branch register request failed. xid=10.18.51.187:8091:115140992675065856, msg=Data truncation: Data too long for column table_name at row 1] ]\n### The error may exist in class path resource [com/zy/supplier/downsource/impl/mapper/SupInfoProductDomainMtpcatalevelMapper.xml]\n### The error may involve defaultParameterMap\n### The error occurred while setting parameters\n### SQL: insert into sup_info_product_domain_mtpcatalevel ( global_supplier_id, catalog_level_id, catalog_level, version, status ) values( ?, ?, ?, ?, ? )\n### Cause: java.sql.SQLException: io.seata.core.exception.RmTransactionException: Response[ TransactionException[branch register request failed. xid=10.18.51.187:8091:115140992675065856, msg=Data truncation: Data too long for column table_name at row 1] ]\n; uncategorized SQLException; SQL state [null]; error code [0]; io.seata.core.exception.RmTransactionException: Response[ TransactionException[branch register request failed. xid=10.18.51.187:8091:115140992675065856, msg=Data truncation: Data too long for column table_name at row 1] ]; nested exception is java.sql.SQLException: io.seata.core.exception.RmTransactionException: Response[ TransactionException[branch register request failed. xid=10.18.51.187:8091:115140992675065856, msg=Data truncation: Data too long for column table_name at row 1] ] [98]" }

caohdgege commented 3 years ago

这个字段可以自己调长

zhaluo-box commented 2 years ago

image

你把seata-server ,lock_table 表 table_name 这个字段 的长度改长一点就可以了 ,默认是32 你肯定有一张表的表名长度太长了