php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #70375 Bug when using PDO and mysqlnd_ms
Submitted: 2015-08-28 03:20 UTC Modified: 2021-07-30 11:07 UTC
Votes:1
Avg. Score:1.0 ± 0.0
Reproduced:0 of 1 (0.0%)
From: ytanaka at ftri dot co dot jp Assigned:
Status: Suspended Package: mysqlnd_ms (PECL)
PHP Version: 5.4.44 OS: Linux
Private report: No CVE-ID: None
View Add Comment Developer Edit
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please — but make sure to vote on the bug!
Your email address:
MUST BE VALID
Solve the problem:
22 - 19 = ?
Subscribe to this entry?

 
 [2015-08-28 03:20 UTC] ytanaka at ftri dot co dot jp
Description:
------------
I am using PDO and mysqlnd_ms.
My DB is Mariadb Galera Cluster.

My sql query:
 LOAD DATA LOW_PRIORITY local INFILE 'xxxxxxxxx' ...

I have 3 cluster nodes. (mgnode1, mgnode2, mgnode3)

When the node mgnode1 is used , it is OK.
When the node mgnode2 and mgnode3 is used , it is not OK.

Then I changed the position of mgnode1 and mgnode2 in my mysqlnd_ms.json,
mgnode2 became OK and mgnode1 became NG.

So I think it is a bug.


mysqlnd_ms.json
{
  "mariadb_cluster_1": {
    "master": {
      "master_1": {
        "host": "mgnode1",
        "port": "3306"
      },
      "master_2": {
        "host": "mgnode2",
        "port": "3306"
      },
      "master_3": {
        "host": "mgnode3",
        "port": "3306"
      }
    },
    "slave": {
    },
    "filters": {
      "user": { "callback": "func_pickserver" }
    }
  }
}


Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2021-07-30 11:07 UTC] cmb@php.net
-Status: Open +Status: Suspended -Package: *General Issues +Package: mysqlnd_ms
 [2021-07-30 11:07 UTC] cmb@php.net
The mysqlnd_ms package is unmaintained; thus, I suspend this
ticket until a new maintainer is found.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Tue Apr 16 14:01:29 2024 UTC