Skip to content

Instantly share code, notes, and snippets.

@armouti
Created November 11, 2018 16:02
Show Gist options
  • Save armouti/877a8b4405330c44e4009ebae3df822c to your computer and use it in GitHub Desktop.
Save armouti/877a8b4405330c44e4009ebae3df822c to your computer and use it in GitHub Desktop.
Log output when trying to connect node.js docker container to mysql docker container on the same host machine.
$ docker-compose up
Creating topsectiondb ... done
Creating topsection-server ... done
Attaching to topsectiondb, topsection-server
topsectiondb | Initializing database
topsectiondb | 2018-11-11T15:36:31.913885Z 0 [Note] Basedir set to /usr/
topsectiondb | 2018-11-11T15:36:31.914120Z 0 [Warning] The syntax '--symbolic-links/-s' is deprecated and will be removed in a future release
topsectiondb | 2018-11-11T15:36:31.917931Z 0 [Warning] You need to use --log-bin to make --log-slave-updates work.
topsectiondb | libnuma: Warning: /sys not mounted or invalid. Assuming one node: No such file or directory
topsectiondb | mbind: Operation not permitted
topsectiondb | mbind: Operation not permitted
topsection-server |
topsection-server | > topsection-service-ismail@1.0.0 start /usr/app
topsection-server | > nodemon /server/server.js
topsection-server |
topsection-server | [nodemon] 1.18.6
topsection-server | [nodemon] to restart at any time, enter `rs`
topsection-server | [nodemon] watching: *.*
topsection-server | [nodemon] starting `node /server/server.js ./server/server.js`
topsectiondb | 2018-11-11T15:36:34.023848Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 91af4ed9-e5c7-11e8-9a24-0242ac120002.
topsectiondb | 2018-11-11T15:36:34.027418Z 0 [Warning] You have not provided a mandatory server-id. Servers in a replication topology must have unique server-ids. Please refer to the proper server start-up parameters documentation.
topsectiondb | 2018-11-11T15:36:34.030429Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
topsectiondb | 2018-11-11T15:36:34.032617Z 5 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
topsection-server | db_user root
topsection-server | listening on port 7777
topsection-server | (node:32) UnhandledPromiseRejectionWarning: Error: getaddrinfo ENOTFOUND jdbc:mysql://localhost:3306 jdbc:mysql://localhost:3306:3306
topsection-server | at GetAddrInfoReqWrap.onlookup [as oncomplete] (dns.js:57:26)
topsection-server | --------------------
topsection-server | at Protocol._enqueue (/usr/app/node_modules/mysql/lib/protocol/Protocol.js:144:48)
topsection-server | at Protocol.handshake (/usr/app/node_modules/mysql/lib/protocol/Protocol.js:51:23)
topsection-server | at Connection.connect (/usr/app/node_modules/mysql/lib/Connection.js:118:18)
topsection-server | at Object.<anonymous> (/usr/app/db/db.js:15:12)
topsection-server | at Module._compile (internal/modules/cjs/loader.js:688:30)
topsection-server | at Object.Module._extensions..js (internal/modules/cjs/loader.js:699:10)
topsection-server | at Module.load (internal/modules/cjs/loader.js:598:32)
topsection-server | at tryModuleLoad (internal/modules/cjs/loader.js:537:12)
topsection-server | at Function.Module._load (internal/modules/cjs/loader.js:529:3)
topsection-server | at Module.require (internal/modules/cjs/loader.js:636:17)
topsection-server | (node:32) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). (rejection id: 1)
topsection-server | (node:32) [DEP0018] DeprecationWarning: Unhandled promise rejections are deprecated. In the future, promise rejections that are not handled will terminate the Node.js process with a non-zero exit code.
topsectiondb | 2018-11-11T15:36:35.523106Z 5 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode.
topsectiondb | 2018-11-11T15:36:35.523568Z 5 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
topsectiondb | 2018-11-11T15:36:35.524094Z 5 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
topsectiondb | 2018-11-11T15:36:35.524400Z 5 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
topsectiondb | 2018-11-11T15:36:35.525379Z 5 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
topsectiondb | 2018-11-11T15:36:35.525937Z 5 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
topsectiondb | 2018-11-11T15:36:35.527049Z 5 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
topsectiondb | 2018-11-11T15:36:35.527232Z 5 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
topsectiondb | Database initialized
topsectiondb | Initializing certificates
topsectiondb | Generating a 2048 bit RSA private key
topsectiondb | .....................+++
topsectiondb | ..............................................................................+++
topsectiondb | unable to write 'random state'
topsectiondb | writing new private key to 'ca-key.pem'
topsectiondb | -----
topsectiondb | Generating a 2048 bit RSA private key
topsectiondb | ........................+++
topsectiondb | ..................................+++
topsectiondb | unable to write 'random state'
topsectiondb | writing new private key to 'server-key.pem'
topsectiondb | -----
topsectiondb | Generating a 2048 bit RSA private key
topsectiondb | ...........................+++
topsectiondb | .....................+++
topsectiondb | unable to write 'random state'
topsectiondb | writing new private key to 'client-key.pem'
topsectiondb | -----
topsectiondb | Certificates initialized
topsectiondb | MySQL init process in progress...
topsectiondb | 2018-11-11T15:36:38.844474Z 0 [Note] Basedir set to /usr/
topsectiondb | 2018-11-11T15:36:38.844739Z 0 [Warning] The syntax '--symbolic-links/-s' is deprecated and will be removed in a future release
topsectiondb | 2018-11-11T15:36:38.844836Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
topsectiondb | 2018-11-11T15:36:38.844892Z 0 [Note] /usr/sbin/mysqld (mysqld 8.0.3-rc-log) starting as process 88 ...
topsectiondb | 2018-11-11T15:36:38.847487Z 0 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=ef2fa5f5de83-bin' to avoid this problem.
topsectiondb | 2018-11-11T15:36:38.851000Z 0 [Note] InnoDB: Using Linux native AIO
topsectiondb | 2018-11-11T15:36:38.851349Z 0 [Note] Plugin 'FEDERATED' is disabled.
topsectiondb | 2018-11-11T15:36:38.854179Z 1 [Note] InnoDB: PUNCH HOLE support available
topsectiondb | 2018-11-11T15:36:38.854224Z 1 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
topsectiondb | 2018-11-11T15:36:38.854245Z 1 [Note] InnoDB: Uses event mutexes
topsectiondb | 2018-11-11T15:36:38.854264Z 1 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
topsectiondb | 2018-11-11T15:36:38.854284Z 1 [Note] InnoDB: Compressed tables use zlib 1.2.11
topsectiondb | 2018-11-11T15:36:38.854579Z 1 [Note] InnoDB: Number of pools: 1
topsectiondb | 2018-11-11T15:36:38.854731Z 1 [Note] InnoDB: Using CPU crc32 instructions
topsectiondb | 2018-11-11T15:36:38.855966Z 1 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
topsectiondb | libnuma: Warning: /sys not mounted or invalid. Assuming one node: No such file or directory
topsectiondb | mbind: Operation not permitted
topsectiondb | mbind: Operation not permitted
topsectiondb | 2018-11-11T15:36:38.869956Z 1 [Note] InnoDB: Completed initialization of buffer pool
topsectiondb | 2018-11-11T15:36:38.872244Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
topsectiondb | 2018-11-11T15:36:38.887663Z 1 [Note] InnoDB: Using 'tablespaces.open.1' max LSN: 13791155
topsectiondb | 2018-11-11T15:36:38.892185Z 1 [Note] InnoDB: Applying a batch of 0 redo log records ...
topsectiondb | 2018-11-11T15:36:38.892255Z 1 [Note] InnoDB: Apply batch completed!
topsectiondb | 2018-11-11T15:36:38.893950Z 1 [Note] InnoDB: Opened 2 existing undo tablespaces.
topsectiondb | 2018-11-11T15:36:38.913516Z 1 [Note] InnoDB: Creating shared tablespace for temporary tables
topsectiondb | 2018-11-11T15:36:38.913642Z 1 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
topsectiondb | 2018-11-11T15:36:38.971051Z 1 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
topsectiondb | 2018-11-11T15:36:38.976775Z 1 [Note] InnoDB: Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.
topsectiondb | 2018-11-11T15:36:38.977369Z 1 [Note] InnoDB: 8.0.3 started; log sequence number 15050591
topsectiondb | 2018-11-11T15:36:39.063213Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
topsectiondb | 2018-11-11T15:36:39.067356Z 0 [Note] InnoDB: Buffer pool(s) load completed at 181111 15:36:39
topsectiondb | 2018-11-11T15:36:39.112062Z 1 [Note] Found data dictionary with version 1
topsectiondb | 2018-11-11T15:36:39.156633Z 0 [Note] InnoDB: DDL log recovery : begin
topsectiondb | 2018-11-11T15:36:39.156789Z 0 [Note] InnoDB: DDL log recovery : end
topsectiondb | 2018-11-11T15:36:39.157620Z 0 [Note] InnoDB: Waiting for purge to start
topsectiondb | 2018-11-11T15:36:39.217349Z 0 [Warning] You have not provided a mandatory server-id. Servers in a replication topology must have unique server-ids. Please refer to the proper server start-up parameters documentation.
topsectiondb | 2018-11-11T15:36:39.222497Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
topsectiondb | 2018-11-11T15:36:39.223032Z 0 [Warning] CA certificate ca.pem is self signed.
topsectiondb | 2018-11-11T15:36:39.244738Z 0 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode.
topsectiondb | 2018-11-11T15:36:39.244863Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
topsectiondb | 2018-11-11T15:36:39.244896Z 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
topsectiondb | 2018-11-11T15:36:39.244951Z 0 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
topsectiondb | 2018-11-11T15:36:39.244983Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
topsectiondb | 2018-11-11T15:36:39.245058Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
topsectiondb | 2018-11-11T15:36:39.250778Z 0 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
topsectiondb | 2018-11-11T15:36:39.250859Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
topsectiondb | 2018-11-11T15:36:39.263439Z 4 [Note] Event Scheduler: scheduler thread started with id 4
topsectiondb | 2018-11-11T15:36:39.263627Z 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '8.0.3-rc-log' socket: '/var/run/mysqld/mysqld.sock' port: 0 MySQL Community Server (GPL)
topsectiondb | Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
topsectiondb | Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
topsectiondb | Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
^CGracefully stopping... (press Ctrl+C again to force)
Stopping topsection-server ... done
Stopping topsectiondb ... done
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment