https://bugzilla.wikimedia.org/show_bug.cgi?id=64140
Bug ID: 64140
Summary: Killed Mysql queries still runing
Product: Tools
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: [Other]
Assignee: [email protected]
Reporter: [email protected]
Web browser: ---
Mobile Platform: ---
Hello, I got a problem during import English templates into project
templatetiger. It seem that 18GB was too much.
So I kill the query after one week but it's still existing:
MariaDB [(none)]> show processlist;
+----------+--------+-------------------+-------------------------+---------+--------+-----------+------------------------------------------------------------------------------------------------------+----------+
| Id | User | Host | db | Command |
Time | State | Info
| Progress |
+----------+--------+-------------------+-------------------------+---------+--------+-----------+------------------------------------------------------------------------------------------------------+----------+
| 12142236 | s51071 | 10.68.17.64:38639 | s51071__templatetiger_p | Killed |
983903 | query end | LOAD DATA LOCAL INFILE
'/data/project/templatetiger/public_html/dumps/sort/enwiki-2014-04-02-lPqO.t |
50.000 |
| 17047860 | s51071 | 10.68.16.32:56063 | s51071__templatetiger_p | Killed |
155552 | query end | LOAD DATA LOCAL INFILE
'/data/project/templatetiger/public_html/dumps/sort/svwiki-2014-04-13.txt' I |
50.000 |
| 17294673 | s51071 | 10.68.16.37:51890 | s51071__templatetiger_p | Query |
77689 | query end | LOAD DATA LOCAL INFILE
'/data/project/templatetiger/public_html/dumps/sort/fiwiki-2014-04-07.txt' I |
50.000 |
| 17365449 | s51071 | 10.68.16.7:47700 | NULL | Query |
0 | NULL | show processlist
| 0.000 |
+----------+--------+-------------------+-------------------------+---------+--------+-----------+------------------------------------------------------------------------------------------------------+----------+
It seems that this slow down also my other imports, that runs fine in the past.
So I try to kill import of sv-wiki without success and fiwiki is running to
long. My next try would be to split enwiki into little pieces of 2 GB.
Please kill the queries for me.
--
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
