tarting on Tuesday after updates pushed over Ubuntu 17.10, MySQL v5.7.21.
I am trying to import a local "XML" RSS feed file located in /var/lib/mysql-files
mysql> load xml local infile '/var/lib/mysql-files/NewsFeedKMBC.rss' ignore into table Feeds.RSSFeeds character set 'utf8' rows identified by '<item>';
ERROR 2013 (HY000): Lost connection to MySQL server during query
The data in NewsFeedKMBC.rss is less than 16 KB in size, you can download that RSS file from
http://www.kshb.com/feeds/rssFeed?obfType=RSS_FEED&siteId=10014&categoryId=20000
Server settings pertinent are as follows:
mysql> SHOW GLOBAL VARIABLES LIKE '%allowed_packet%';
+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| max_allowed_packet | 268435456 |
| slave_max_allowed_packet | 1073741824 |
+--------------------------+------------+
SHOW GLOBAL VARIABLES LIKE 'local_infile';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| local_infile | ON |
+---------------+-------+
Table structure as follows:
+-------------+---------------+------+-----+-------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+---------------+------+-----+-------------------+-------+
| guid | varchar(1024) | NO | PRI | NULL | |
| title | varchar(255) | YES | | NULL | |
| link | varchar(255) | YES | | NULL | |
| description | mediumtext | YES | | NULL | |
| pubDate | varchar(50) | YES | | NULL | |
| GetTime | timestamp | NO | | CURRENT_TIMESTAMP | |
+-------------+---------------+------+-----+-------------------+-------+
6 rows in set (0.00 sec)
mysql> select count(guid) from Feeds.RSSFeeds;
+-------------+
| count(guid) |
+-------------+
| 184177 |
+-------------+
1 row in set (0.18 sec)
In the /var/log/mysql/error.log it states:
2018-01-27T15:48:28.632969Z 4 [Note] Aborted connection 4 to db: 'Feeds' user: '_____' host: 'localhost' (Got packets out of order) ~