Address "0.0.0.0" is a wildcard address, which will not match against any specific address. Do not use the 'inet-address' configuration elementto specify that an interface should use a wildcard address; use 'any-address', 'any-ipv4-address', or 'any-ipv6-address'
解决:在jboss/standalone/configuration/standlone.xml文件中改
<interface>中inet-address为any-ipv4-address重启 jboss/bin/standlone.sh
3、登录应用项目,提示密码错误,无法登陆
经排查,为mysql5.6数据库升级为mysql5.7而出现的故障,需在my.cnf文件中加入sql_mode=,故障消除
4、应用项目查询特别慢问题
经排查为mysql5.6数据库升级为mysql5.7而出现的故障,需要关闭derived_merge,在mysql启动后执行
mysql -u*** -p*** -e "set GLOBAL optimizer_switch='derived_merge=off';"
重新进入应用项目,查询速度恢复正常。
5、配置jboss/wildfly数据源,因数据源超时问题的解决
Caused by: java.lang.RuntimeException: org.springframework.dao.RecoverableDataAccessException:
### Error querying database. Cause: com.mysql.cj.jdbc.exceptions.CommunicationsException: The last packet successfully received from the server was 154,231 milliseconds ago. The last packet sent successfully to the server was 154,231 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
可以更改my.cnf文件中的
wait_timeout=2147483
interactive_timeout=2147483
将两个值改大,也不能改的太大。
重启mysql服务器,重启应用,问题解决。
Linux公社的RSS地址:https://www.linuxidc.com/rssFeed.aspx