The ArchiveProcessing test using Mysqli is passing when using LOAD DATA INFILE, so it isn't a MySQL / AppArmor configuration issue. (I also checked that the "piwik" db user has the FILE privilege.)
On the VM, the mysqli.so and pdo_mysql.so extensions both appear to use libmysqlclient. On dev6, our 5.3.x builds used the new mysqlnd (native driver) extension.
So, this points to a pdo_mysql bug ... i.e.,
All in all, what is the minimum recommended php version? is the latest 5.3.x enough to enjoy LOAD DATAINFILE. Since it's a big improvement boost, we could add it in the system check list as a "warning" - high traffic users will want to know this setting.
Otherwise this ticket cna be closed since tests pass? Thanks so much for finding this info it was doing my head in! we are going green
@vipsoft I would like to follow up  and add a warning if box is Jenkins AND isBulkInsertTestable() returns false (since we should know when jenkins stops running these tests). how could we detect if the current server is Jenkins?
(In ) Fixes #3605 Marking the test as "skipped" even if it's not testable.
This will be annoying to always see it in the test output so I probably disable it for jenkins later