Error connecting to MariaDB using Docker-Compose, "Connection Lost: The server closed the connection"

Question

I'm trying to connect the official MariaDB docker image to an image of my client-side application with the command docker-compose up; it successfully connects to the server but when trying to connect to the MariaDB database, after about a minute logs "Error: Connection lost: The server closed the connection." I have no problem connecting to the database locally when starting the server, but it throws the error when trying to link docker images of the same code.

My docker-compose.yml:

version: '3.1'
services:
  webapp:

    image: client
    ports:
      - "3306:3306"
    links: 
      - db
    depends_on:
      - db
    environment:
      DATABASE_URL: "mysql://root:root@db/yelp"
db:
  image: mariadb:latest
  restart: always
  environment:
    MYSQL_ROOT_PASSWORD: root
    MYSQL_DATABASE: yelp

adminer:
  image: adminer
  restart: always
  ports:
    - 3001:3001

Dockerfile:

FROM node:10

WORKDIR /cadenza/documents/SDC/leaveReview

COPY package*.json ./

RUN npm install

COPY . .

EXPOSE 3306

CMD ["npm", "start"]

mysql/MariaDB index.js connection file:

var mysql = require('mysql')
var connection = mysql.createConnection({
    host: '127.0.0.1',
    user: 'root',
    password: 'root',
    database: 'yelp'
});

connection.connect((err) => {
    if (err) {
        console.log('error when connecting to db', err);
    } else {
        console.log('connected to db')
    }
});

module.exports = connection;

Logs when running docker-compose up:

    docker-compose up
Starting leavereview_db_1      ... done
Starting leavereview_adminer_1 ... done
Starting leavereview_webapp_1  ... done
Attaching to leavereview_adminer_1, leavereview_db_1, leavereview_webapp_1
adminer_1  | PHP 7.2.7 Development Server started at Tue Jul  3 02:34:03 2018
webapp_1   |
webapp_1   | > yelp-reviews@1.0.0 start /cadenza/documents/SDC/leaveReview
webapp_1   | > nodemon server/index.js
webapp_1   |
db_1       | 2018-07-03  2:34:04 0 [Note] mysqld (mysqld 10.3.7-MariaDB-1:10.3.7+maria~jessie) starting as process 1 ...
db_1       | 2018-07-03  2:34:04 0 [Note] InnoDB: Using Linux native AIO
db_1       | 2018-07-03  2:34:04 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
db_1       | 2018-07-03  2:34:04 0 [Note] InnoDB: Uses event mutexes
db_1       | 2018-07-03  2:34:04 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
db_1       | 2018-07-03  2:34:04 0 [Note] InnoDB: Number of pools: 1
db_1       | 2018-07-03  2:34:04 0 [Note] InnoDB: Using SSE2 crc32 instructions
db_1       | 2018-07-03  2:34:04 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
db_1       | 2018-07-03  2:34:04 0 [Note] InnoDB: Completed initialization of buffer pool
db_1       | 2018-07-03  2:34:04 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
db_1       | 2018-07-03  2:34:04 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1630896
db_1       | 2018-07-03  2:34:04 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
db_1       | 2018-07-03  2:34:04 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
db_1       | 2018-07-03  2:34:04 0 [Note] InnoDB: Creating shared tablespace for temporary tables
db_1       | 2018-07-03  2:34:04 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
db_1       | 2018-07-03  2:34:04 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
db_1       | 2018-07-03  2:34:04 0 [Note] InnoDB: Waiting for purge to start
webapp_1   | [nodemon] 1.17.5
webapp_1   | [nodemon] to restart at any time, enter `rs`
webapp_1   | [nodemon] watching: *.*
webapp_1   | [nodemon] starting `node server/index.js`
db_1       | 2018-07-03  2:34:04 0 [Note] InnoDB: 10.3.7 started; log sequence number 1630905; transaction id 21
db_1       | 2018-07-03  2:34:04 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
db_1       | 2018-07-03  2:34:04 0 [Note] Plugin 'FEEDBACK' is disabled.
db_1       | 2018-07-03  2:34:04 0 [Note] Recovering after a crash using tc.log
db_1       | 2018-07-03  2:34:04 0 [Note] Starting crash recovery...
db_1       | 2018-07-03  2:34:04 0 [Note] Crash recovery finished.
db_1       | 2018-07-03  2:34:04 0 [Note] Server socket created on IP: '::'.
db_1       | 2018-07-03  2:34:04 0 [Note] InnoDB: Buffer pool(s) load completed at 180703  2:34:04
db_1       | 2018-07-03  2:34:04 0 [Warning] 'proxies_priv' entry '@% root@a1a244ac54cf' ignored in --skip-name-resolve mode.
db_1       | 2018-07-03  2:34:04 0 [Note] Reading of all Master_info entries succeded
db_1       | 2018-07-03  2:34:04 0 [Note] Added new Master_info '' to hash table
db_1       | 2018-07-03  2:34:04 0 [Note] mysqld: ready for connections.
db_1       | Version: '10.3.7-MariaDB-1:10.3.7+maria~jessie'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution
webapp_1   | Listening on port  3306
webapp_1   | error when connecting to db { Error: Connection lost: The server closed the connection.
webapp_1   |     at Protocol.end (/cadenza/documents/SDC/leaveReview/node_modules/mysql/lib/protocol/Protocol.js:113:13)
webapp_1   |     at Socket. (/cadenza/documents/SDC/leaveReview/node_modules/mysql/lib/Connection.js:109:28)
webapp_1   |     at Socket.emit (events.js:187:15)
webapp_1   |     at endReadableNT (_stream_readable.js:1081:12)
webapp_1   |     at process._tickCallback (internal/process/next_tick.js:63:19)
webapp_1   |     --------------------
webapp_1   |     at Protocol._enqueue (/cadenza/documents/SDC/leaveReview/node_modules/mysql/lib/protocol/Protocol.js:145:48)
webapp_1   |     at Protocol.handshake (/cadenza/documents/SDC/leaveReview/node_modules/mysql/lib/protocol/Protocol.js:52:23)
webapp_1   |     at Connection.connect (/cadenza/documents/SDC/leaveReview/node_modules/mysql/lib/Connection.js:130:18)
webapp_1   |     at Object. (/cadenza/documents/SDC/leaveReview/database/index.js:9:12)
webapp_1   |     at Module._compile (internal/modules/cjs/loader.js:702:30)
webapp_1   |     at Object.Module._extensions..js (internal/modules/cjs/loader.js:713:10)
webapp_1   |     at Module.load (internal/modules/cjs/loader.js:612:32)
webapp_1   |     at tryModuleLoad (internal/modules/cjs/loader.js:551:12)
webapp_1   |     at Function.Module._load (internal/modules/cjs/loader.js:543:3)
webapp_1   |     at Module.require (internal/modules/cjs/loader.js:650:17) fatal: true, code: 'PROTOCOL_CONNECTION_LOST' }
webapp_1   | (node:29) [DEP0096] DeprecationWarning: timers.unenroll() is deprecated. Please use clearTimeout instead.

It should be logging "connected to db". I have also tried solutions that people have suggest for handling server disconnect due to being idle etc etc, but it doesn't even connect to the database in the first place.

Caden Wang · Accepted Answer

So it connected after I changed the host in the database connection index.js file from '127.0.0.1' to:

var connection = mysql.createConnection({
host: 'db',
user: 'root',
password: 'root',
database: 'yelp'
});

where 'db' is referring to the 'db' image in my docker-compose.yml file.

Error connecting to MariaDB using Docker-Compose, "Connection Lost: The server closed the connection"

Answers (2)

Related Questions

Error connecting to MariaDB using Docker-Compose, &quot;Connection Lost: The server closed the connection&quot;

Answers (2)

Related Questions

Error connecting to MariaDB using Docker-Compose, "Connection Lost: The server closed the connection"