Question

数据类型： MySql 8.0

使用产品：iserver 11i 11.1

问题详细描述：iServer发布数据服务后，数据源里面没有数据集，D:\SuperMap\SuperMapiServer11i\support\objectsjava\bin\log里有错误信息

2023-11-21 14:29:32 [error] SHOULD_SET_LARGE_PACKET_SIZE, ThreadID: 21864, Timespan(ms): 5562, ResourceID: 0x0000000064, SourceCode: f:\teamcity\ugo9dtrunkvs2017\01_sourcecode\src\enginemysql\ugdatasourcemysql.cpp(2717)
2023-11-21 14:29:32 [error] Failed Exec strSQL : Create Table 永久基本农田.SmUserInfo (SmID int PRIMARY KEY NOT NULL AUTO_INCREMENT,SmDatasetID INT DEFAULT 0 NOT NULL,SmDatasetType INT DEFAULT 1,SmUserType VarChar(256) DEFAULT ' ' NOT NULL,SmByte LONGBLOB)ENGINE =MyISAM-Table 'smuserinfo' already exists

我的数据库里已经有永久基本农田.SmUserInfo这个表，表名是全小写字母，在执行创建表肯定报错啊，是不是bug,

下面是我MySql数据库表结构

Answer 1

您好，“SHOULD_SET_LARGE_PACKET_SIZE"报错是由于mysql数据库的字符缓冲区大小或blob类型大小限制导致的。
解决办法如下：

1. 修改windows的my.ini或Linux下的my.cnf文件中的变量（默认只有4m）： max_allowed_packet=256m

2. 重启mysql服务，然后连接mysql查看是否生效了： mysql -u root -p show VARIABLES like ‘%max_allowed_packet%’;

Comments

第一个错误没有了，谢谢

后续这几个错误提示还是有，iServer数据服务里的数据集是空的

2023-11-21 17:36:11 [error] Failed Exec strSQL : Create Table 永久基本农田.SmUserInfo (SmID int PRIMARY KEY NOT NULL AUTO_INCREMENT,SmDatasetID INT DEFAULT 0 NOT NULL,SmDatasetType INT DEFAULT 1,SmUserType VarChar(256) DEFAULT ' ' NOT NULL,SmByte LONGBLOB)ENGINE =MyISAM-Table 'smuserinfo' already exists
, ThreadID: 14000, Timespan(ms): 5984, ResourceID: 0x0094967196, SourceCode: f:\teamcity\ugo9dtrunkvs2017\01_sourcecode\src\enginemysql\ugdatasourcemysql.cpp(4501)
2023-11-21 17:36:11 [error] Failed Exec strSQL : Create Table 永久基本农田.SmUserInfo (SmID int PRIMARY KEY NOT NULL AUTO_INCREMENT,SmDatasetID INT DEFAULT 0 NOT NULL,SmDatasetType INT DEFAULT 1,SmUserType VarChar(256) DEFAULT ' ' NOT NULL,SmByte LONGBLOB)ENGINE =MyISAM-Table 'smuserinfo' already exists
, ThreadID: 14000, Timespan(ms): 0, ResourceID: 0x00FFFFFF00, SourceCode: f:\teamcity\ugo9dtrunkvs2017\01_sourcecode\src\enginemysql\ugdatasourcemysql.cpp(4501)
2023-11-21 17:36:11 [error] 删除用户信息失败, ThreadID: 14000, Timespan(ms): 0, ResourceID: 0x00300101AF, SourceCode: f:\teamcity\ugo9dtrunkvs2017\01_sourcecode\src\enginemysql\ugdatasourcemysql.cpp(4505)
2023-11-21 17:36:11 [error] Failed Exec strSQL : SELECT a.SmDatasetName FROM test.SmImgRegister a , (SELECT distinct(SmDatasetID) FROM test.SmBandRegister where SmPyramidLevel=0) b Where a.SmDatasetID=b.SmDatasetID-Unknown database 'test', ThreadID: 14000, Timespan(ms): 94, ResourceID: 0x0010010200, SourceCode: f:\teamcity\ugo9dtrunkvs2017\01_sourcecode\src\mysqlci\ugmyrecordset.cpp(91)
2023-11-21 17:36:11 [error] Failed Exec strSQL : Create Table 永久基本农田.SmUserInfo (SmID int PRIMARY KEY NOT NULL AUTO_INCREMENT,SmDatasetID INT DEFAULT 0 NOT NULL,SmDatasetType INT DEFAULT 1,SmUserType VarChar(256) DEFAULT ' ' NOT NULL,SmByte LONGBLOB)ENGINE =MyISAM-Table 'smuserinfo' already exists
, ThreadID: 14000, Timespan(ms): 0, ResourceID: 0x0094967196, SourceCode: f:\teamcity\ugo9dtrunkvs2017\01_sourcecode\src\enginemysql\ugdatasourcemysql.cpp(2427)
2023-11-21 17:36:11 [error] Failed Exec strSQL : Create Table 永久基本农田.SmUserInfo (SmID int PRIMARY KEY NOT NULL AUTO_INCREMENT,SmDatasetID INT DEFAULT 0 NOT NULL,SmDatasetType INT DEFAULT 1,SmUserType VarChar(256) DEFAULT ' ' NOT NULL,SmByte LONGBLOB)ENGINE =MyISAM-Table 'smuserinfo' already exists
, ThreadID: 14000, Timespan(ms): 0, ResourceID: 0x00FFFFFF00, SourceCode: f:\teamcity\ugo9dtrunkvs2017\01_sourcecode\src\enginemysql\ugdatasourcemysql.cpp(2427)
2023-11-21 17:36:11 [error] 获取数据集名失败, ThreadID: 14000, Timespan(ms): 0, ResourceID: 0x00300101D3, SourceCode: f:\teamcity\ugo9dtrunkvs2017\01_sourcecode\src\enginemysql\ugdatasourcemysql.cpp(2471)
2023-11-21 17:36:14 [error] 统计专题图计算字段极值失败, ThreadID: 8620, Timespan(ms): 2594, ResourceID: 0x004001007D, SourceCode: f:\teamcity\ugo9dtrunkvs2017\01_sourcecode\src\map\ugthemegraph.cpp(2026)
2023-11-21 17:36:14 [error] 统计专题图计算字段极值失败, ThreadID: 8620, Timespan(ms): 15, ResourceID: 0x004001007D, SourceCode: f:\teamcity\ugo9dtrunkvs2017\01_sourcecode\src\map\ugthemegraph.cpp(2026)

但是我数据库里有数据集

---

您这边是否可以远程呢，我私信您我的联系方式，了解一下具体情况

---

可以，我怎么联系您

---

您看下私信，之前就发您了哈

---

远程客户查看该问题为1110版本缺陷，已在1111版本修复，官网下载1111版本iserver发布即可。