Uploaded image for project: 'MariaDB Connector/node.js'
  1. MariaDB Connector/node.js
  2. CONJS-78

Read ECONNRESET Error

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 2.0.5
    • N/A
    • pool
    • None

    Description

      MariaDB Node JS connector pool returns "read ECONNRESET Error" randomly with the compress pool option set to true. Here are the options that I used to create the pool

      let options = {
      		 
          host: <host>,
      		 
          acquireTimeout: 10000,
      		 
          port: <port>,
      		 
          database: <db>,
      		 
          user: <user>,
      		 
          password: <pswd>,
      		 
          compress: true,
      		 
          namedPlaceholders: true,
      		 
          connectionLimit: 10,
      		 
          minDelayValidation: 2000
      		 
      }
      		 
       
      		 
      let pool = mariaDb.createPool(options)

      When the "compress" is set to false, the error is not seen. I am not sure if it is related.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          arjunb Arjun B created issue -
          arjunb Arjun B made changes -
          Field Original Value New Value
          Description MariaDB Node JS connector pool returns "read ECONNRESET Error" randomly with the compress pool option set to true. Here are the options that I used to create the pool

          {
              host: <host>,
              acquireTimeout: 10000,
              port: <port>,
              database: <db>,
              user: <user>,
              password: <pswd>,
              compress: true,
              namedPlaceholders: true,
              connectionLimit: 10,
              minDelayValidation: 2000
          }

          		MariaDB Node JS connector pool returns "read ECONNRESET Error" randomly with the compress pool option set to true. Here are the options that I used to create the pool


          {code:json}
          {
              host: <host>,
              acquireTimeout: 10000,
              port: <port>,
              database: <db>,
              user: <user>,
              password: <pswd>,
              compress: true,
              namedPlaceholders: true,
              connectionLimit: 10,
              minDelayValidation: 2000
          }

          {code}


          arjunb Arjun B made changes -
          Description MariaDB Node JS connector pool returns "read ECONNRESET Error" randomly with the compress pool option set to true. Here are the options that I used to create the pool


          {code:json}
          {
              host: <host>,
              acquireTimeout: 10000,
              port: <port>,
              database: <db>,
              user: <user>,
              password: <pswd>,
              compress: true,
              namedPlaceholders: true,
              connectionLimit: 10,
              minDelayValidation: 2000
          }

          {code}


          		MariaDB Node JS connector pool returns "read ECONNRESET Error" randomly with the compress pool option set to true. Here are the options that I used to create the pool


          {code:json}
          let options = {
              host: <host>,
              acquireTimeout: 10000,
              port: <port>,
              database: <db>,
              user: <user>,
              password: <pswd>,
              compress: true,
              namedPlaceholders: true,
              connectionLimit: 10,
              minDelayValidation: 2000
          }

          let pool = mariaDb.createPool(options)

          {code}


          arjunb Arjun B made changes -
          Description MariaDB Node JS connector pool returns "read ECONNRESET Error" randomly with the compress pool option set to true. Here are the options that I used to create the pool


          {code:json}
          let options = {
              host: <host>,
              acquireTimeout: 10000,
              port: <port>,
              database: <db>,
              user: <user>,
              password: <pswd>,
              compress: true,
              namedPlaceholders: true,
              connectionLimit: 10,
              minDelayValidation: 2000
          }

          let pool = mariaDb.createPool(options)

          {code}


          		MariaDB Node JS connector pool returns "read ECONNRESET Error" randomly with the compress pool option set to true. Here are the options that I used to create the pool


          {code:json}
          let options = {
              host: <host>,
              acquireTimeout: 10000,
              port: <port>,
              database: <db>,
              user: <user>,
              password: <pswd>,
              compress: true,
              namedPlaceholders: true,
              connectionLimit: 10,
              minDelayValidation: 2000
          }

          let pool = mariaDb.createPool(options)

          {code}

          When the "compress" is set to false, the error is not seen. I am not sure if it is related.
          arjunb Arjun B made changes -
          Description MariaDB Node JS connector pool returns "read ECONNRESET Error" randomly with the compress pool option set to true. Here are the options that I used to create the pool


          {code:json}
          let options = {
              host: <host>,
              acquireTimeout: 10000,
              port: <port>,
              database: <db>,
              user: <user>,
              password: <pswd>,
              compress: true,
              namedPlaceholders: true,
              connectionLimit: 10,
              minDelayValidation: 2000
          }

          let pool = mariaDb.createPool(options)

          {code}

          When the "compress" is set to false, the error is not seen. I am not sure if it is related.
          		MariaDB Node JS connector pool returns "read ECONNRESET Error" *randomly* with the compress pool option set to true. Here are the options that I used to create the pool


          {code:json}
          let options = {
              host: <host>,
              acquireTimeout: 10000,
              port: <port>,
              database: <db>,
              user: <user>,
              password: <pswd>,
              compress: true,
              namedPlaceholders: true,
              connectionLimit: 10,
              minDelayValidation: 2000
          }

          let pool = mariaDb.createPool(options)

          {code}

          When the "compress" is set to false, the error is not seen. I am not sure if it is related.
          diego dupin Diego Dupin added a comment -

          I've try to reproduced the issue without success.

          "read ECONNRESET Error" means socket has been closed server side.
          Could you check and send server logs here ? (server logs error when closing connection without client explicitly indicating to close connection)

          diego dupin Diego Dupin added a comment - I've try to reproduced the issue without success. "read ECONNRESET Error" means socket has been closed server side. Could you check and send server logs here ? (server logs error when closing connection without client explicitly indicating to close connection)
          diego dupin Diego Dupin added a comment -

          closing since not reproducing and no answer.
          Feel free to open a new issue and link to that one if you reproduced the issue.

          diego dupin Diego Dupin added a comment - closing since not reproducing and no answer. Feel free to open a new issue and link to that one if you reproduced the issue.
          diego dupin Diego Dupin made changes -
          Fix Version/s 0.0.0 [ 23129 ]
          Resolution Cannot Reproduce [ 5 ]
          Status Open [ 1 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 96970 ] MariaDB v4 [ 135260 ]

          People

            diego dupin Diego Dupin
            arjunb Arjun B
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.