MySQL Forums
Forum List  »  General

MySQL on Ubuntu - LOAD XML results in disconnect
Posted by: Anthony Stump
Date: January 28, 2018 01:22PM

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) ~

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.