Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Bscan联动报错 #8

Open
whoopscs opened this issue Jun 9, 2022 · 2 comments
Open

Bscan联动报错 #8

whoopscs opened this issue Jun 9, 2022 · 2 comments

Comments

@whoopscs
Copy link

whoopscs commented Jun 9, 2022

报错信息如下:
Sylas:
Mysql初始化失败:java.sql.SQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes
无法获取url:java.sql.SQLSyntaxErrorException: Table 'sylas.Url' doesn't exist
image

Bscan:
Error 1146: Table 'sylas.subDomainBscanAlive' doesn't exist
image

@0Chencc
Copy link
Member

0Chencc commented Jun 9, 2022

这个bug可能是由于Mysql自身的问题产生的,如果知道Mysql的版本号可能更好定位问题,我搜索了相关文档描述了这个问题可能在Mysql5.6以及Mysql5.6以下版本产生,我的Mysql环境是8.0所以已经没有了innodb_large_prefix这个参数。
当这个参数为OFF时,会出现表前缀无法超过767个字符的问题,但是塞拉斯的前缀是超过了767的。需要将该参数设置成ON才可以继续下一步
可以尝试使用命令查询innodb_large_prefix这个参数是否为ON

show variables like '%innodb_large_prefix%';

如果为OFF的话,执行如下命令可以解决该问题

set global innodb_large_prefix=on;

我会在下个版本调整这个地方,看看能否将前缀缩小到767以内。

@whoopscs
Copy link
Author

好的,感谢解答,我的MySQL版本确实是5.6,我将按照你的建议操作一下,不行的话我再将MySQL更新至8.0以上,感谢Thanks♪(・ω・)ノ

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants