@robocoder
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.,
- https://bugs.php.net/bug.php?id=46964 - this was a compilation error prior to 5.2.9 for older versions of mysql
- https://bugs.php.net/bug.php?id=54158 - the "fix" from 46964 broke 5.3 thru 5.3.8
- https://bugs.php.net/bug.php?id=62889 - the "fix" from 54158 only fixed it for php 5.3.9+ using mysqlnd
(In [7600]) fixes #3605 - add detection for mysqlnd
(In [7601]) refs #3605 - correct information in phpdocs
@mattab
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
Minimum:
- 5.2.1+ with mysqli
- 5.3.9+ with pdo_mysql using mysqlnd
Maximum:
- 5.2.8 with pdo_mysql using libmysqlclient
@vipsoft I would like to follow up [7600] 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 [7677]) 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