Monthly Archives: February 2020

“No route to host” fix for Centos 7

After changing SSH port, If I try to SSH using new port number

I was getting error “no route to host”

The issue was due to IPtables

I have to flush all firewall rules using

IPtables -f

serveice iptables restart

This fixed the ssh port issue

ERROR 1118 (42000) at line 661: Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.

We had this issue while dumping one database

We added below parameter in /etc/my.cnf

innodb_strict_mode = 0

And restarted Mysql

Now mysql dump worked fine