[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]

RE: MySQL: Readiness probe failed



I have also some weird docker issue which is maybe related?
I'm on some weird verion: oc v1.2.0-rc1-13-g2e62fab
docker status shows me:
level=error msg="Error reading loginuid: open /proc/59143/loginuid: no such f... directory"
level=error msg="Error reading loginuid: open /proc/59143/loginuid: no such f... directory"
level=error msg="Error reading loginuid: open /proc/59143/loginuid: no such f... directory"


From: dencowboy hotmail com
To: bparees redhat com
Subject: RE: MySQL: Readiness probe failed
Date: Tue, 21 Jun 2016 16:51:41 +0000
CC: users lists openshift redhat com

So it seems the mysql isn't able to resolve the service name mysql to its IP:
because this works inside the container:
mysql -u user -h 172.30.183.216 -p
password: xx
---> mysql (works)

This doesn't work:
mysql -u user h mysql -p
password: xx
--> error unkown mysql server host 'mysql'

mysql is the service name and service IP is 172.30.183.216
here are all the logs of the container:

Warning: Can't detect memory limit from cgroups
Warning: Can't detect number of CPU cores from cgroups
---> 16:19:51     Processing MySQL configuration files ...
---> 16:19:51     Initializing database ...
---> 16:19:51     Running mysql_install_db ...
2016-06-21 16:19:51 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-06-21 16:19:51 0 [Note] /opt/rh/rh-mysql56/root/usr/libexec/mysqld (mysqld 5.6.26) starting as process 17 ...
2016-06-21 16:19:51 663521f0b840 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-06-21 16:19:51 17 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-06-21 16:19:51 17 [Note] InnoDB: The InnoDB memory heap is disabled
2016-06-21 16:19:51 17 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-06-21 16:19:51 17 [Note] InnoDB: Memory barrier is not used
2016-06-21 16:19:51 17 [Note] InnoDB: Compressed tables use zlib 1.2.7
2016-06-21 16:19:51 17 [Note] InnoDB: Using Linux native AIO
2016-06-21 16:19:51 17 [Note] InnoDB: Using CPU crc32 instructions
2016-06-21 16:19:51 17 [Note] InnoDB: Initializing buffer pool, size = 32.0M
2016-06-21 16:19:51 17 [Note] InnoDB: Completed initialization of buffer pool
2016-06-21 16:19:51 17 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2016-06-21 16:19:51 17 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2016-06-21 16:19:51 17 [Note] InnoDB: Database physically writes the file full: wait...
2016-06-21 16:19:51 17 [Note] InnoDB: Setting log file ./ib_logfile101 size to 8 MB
2016-06-21 16:19:52 17 [Note] InnoDB: Setting log file ./ib_logfile1 size to 8 MB
2016-06-21 16:19:52 17 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2016-06-21 16:19:52 17 [Warning] InnoDB: New log files created, LSN=45781
2016-06-21 16:19:52 17 [Note] InnoDB: Doublewrite buffer not found: creating new
2016-06-21 16:19:52 17 [Note] InnoDB: Doublewrite buffer created
2016-06-21 16:19:52 17 [Note] InnoDB: 128 rollback segment(s) are active.
2016-06-21 16:19:52 17 [Warning] InnoDB: Creating foreign key constraint system tables.
2016-06-21 16:19:52 17 [Note] InnoDB: Foreign key constraint system tables created
2016-06-21 16:19:52 17 [Note] InnoDB: Creating tablespace and datafile system tables.
2016-06-21 16:19:52 17 [Note] InnoDB: Tablespace and datafile system tables created.
2016-06-21 16:19:52 17 [Note] InnoDB: Waiting for purge to start
2016-06-21 16:19:52 17 [Note] InnoDB: 5.6.26 started; log sequence number 0
2016-06-21 16:19:52 17 [Note] RSA private key file not found: /var/lib/mysql/data//private_key.pem. Some authentication plugins will not work.
2016-06-21 16:19:52 17 [Note] RSA public key file not found: /var/lib/mysql/data//public_key.pem. Some authentication plugins will not work.
2016-06-21 16:19:55 17 [Note] Binlog end
2016-06-21 16:19:55 17 [Note] InnoDB: FTS optimize thread exiting.
2016-06-21 16:19:55 17 [Note] InnoDB: Starting shutdown...
2016-06-21 16:19:56 17 [Note] InnoDB: Shutdown completed; log sequence number 1625977


2016-06-21 16:19:56 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-06-21 16:19:56 0 [Note] /opt/rh/rh-mysql56/root/usr/libexec/mysqld (mysqld 5.6.26) starting as process 39 ...
2016-06-21 16:19:56 6ef05c1a6840 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-06-21 16:19:56 39 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-06-21 16:19:56 39 [Note] InnoDB: The InnoDB memory heap is disabled
2016-06-21 16:19:56 39 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-06-21 16:19:56 39 [Note] InnoDB: Memory barrier is not used
2016-06-21 16:19:56 39 [Note] InnoDB: Compressed tables use zlib 1.2.7
2016-06-21 16:19:56 39 [Note] InnoDB: Using Linux native AIO
2016-06-21 16:19:56 39 [Note] InnoDB: Using CPU crc32 instructions
2016-06-21 16:19:56 39 [Note] InnoDB: Initializing buffer pool, size = 32.0M
2016-06-21 16:19:56 39 [Note] InnoDB: Completed initialization of buffer pool
2016-06-21 16:19:56 39 [Note] InnoDB: Highest supported file format is Barracuda.
2016-06-21 16:19:56 39 [Note] InnoDB: 128 rollback segment(s) are active.
2016-06-21 16:19:56 39 [Note] InnoDB: Waiting for purge to start
2016-06-21 16:19:57 39 [Note] InnoDB: 5.6.26 started; log sequence number 1625977
2016-06-21 16:19:57 39 [Note] RSA private key file not found: /var/lib/mysql/data//private_key.pem. Some authentication plugins will not work.
2016-06-21 16:19:57 39 [Note] RSA public key file not found: /var/lib/mysql/data//public_key.pem. Some authentication plugins will not work.
2016-06-21 16:19:57 39 [Note] Binlog end
2016-06-21 16:19:57 39 [Note] InnoDB: FTS optimize thread exiting.
2016-06-21 16:19:57 39 [Note] InnoDB: Starting shutdown...
2016-06-21 16:19:58 39 [Note] InnoDB: Shutdown completed; log sequence number 1625987




PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

  /opt/rh/rh-mysql56/root/usr/bin/mysqladmin -u root password 'new-password'
  /opt/rh/rh-mysql56/root/usr/bin/mysqladmin -u root -h mysql-1-irei5 password 'new-password'

Alternatively you can run:

  /opt/rh/rh-mysql56/root/usr/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

Please report any problems at http://bugs.mysql.com/

The latest information about MySQL is available on the web at

  http://www.mysql.com

Support MySQL by buying support/licenses at http://shop.mysql.com

Note: new default config file not created.
Please make sure your config file is current

WARNING: Default config file /etc/opt/rh/rh-mysql56/my.cnf exists on the system
This file will be read by default by the MySQL server
If you do not want to use this, either remove it, or use the
--defaults-file argument to mysqld_safe when starting the server

---> 16:19:59     Starting MySQL server with disabled networking ...
---> 16:19:59     Waiting for MySQL to start ...
2016-06-21 16:19:59 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-06-21 16:19:59 0 [Note] /opt/rh/rh-mysql56/root/usr/libexec/mysqld (mysqld 5.6.26) starting as process 70 ...
2016-06-21 16:19:59 70 [Note] Plugin 'FEDERATED' is disabled.
2016-06-21 16:19:59 772efa0dd840 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-06-21 16:19:59 70 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-06-21 16:19:59 70 [Note] InnoDB: The InnoDB memory heap is disabled
2016-06-21 16:19:59 70 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-06-21 16:19:59 70 [Note] InnoDB: Memory barrier is not used
2016-06-21 16:19:59 70 [Note] InnoDB: Compressed tables use zlib 1.2.7
2016-06-21 16:19:59 70 [Note] InnoDB: Using Linux native AIO
2016-06-21 16:19:59 70 [Note] InnoDB: Using CPU crc32 instructions
2016-06-21 16:19:59 70 [Note] InnoDB: Initializing buffer pool, size = 32.0M
2016-06-21 16:19:59 70 [Note] InnoDB: Completed initialization of buffer pool
2016-06-21 16:19:59 70 [Note] InnoDB: Highest supported file format is Barracuda.
2016-06-21 16:19:59 70 [Note] InnoDB: 128 rollback segment(s) are active.
2016-06-21 16:19:59 70 [Note] InnoDB: Waiting for purge to start
2016-06-21 16:19:59 70 [Note] InnoDB: 5.6.26 started; log sequence number 1625987
2016-06-21 16:19:59 70 [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: 00162ab4-37cc-11e6-beb2-02420a010003.
2016-06-21 16:19:59 70 [Note] RSA private key file not found: /var/lib/mysql/data//private_key.pem. Some authentication plugins will not work.
2016-06-21 16:19:59 70 [Note] RSA public key file not found: /var/lib/mysql/data//public_key.pem. Some authentication plugins will not work.
2016-06-21 16:19:59 70 [Warning] 'user' entry 'root mysql-1-irei5' ignored in --skip-name-resolve mode.
2016-06-21 16:19:59 70 [Warning] 'user' entry '@mysql-1-irei5' ignored in --skip-name-resolve mode.
2016-06-21 16:19:59 70 [Warning] 'proxies_priv' entry '@ root mysql-1-irei5' ignored in --skip-name-resolve mode.
2016-06-21 16:19:59 70 [Note] Event Scheduler: Loaded 0 events
2016-06-21 16:19:59 70 [Note] /opt/rh/rh-mysql56/root/usr/libexec/mysqld: ready for connections.
Version: '5.6.26'  socket: '/tmp/mysql.sock'  port: 0  MySQL Community Server (GPL)
---> 16:20:00     MySQL started successfully
---> 16:20:00     Creating user specified by MYSQL_USER (user) ...
---> 16:20:00     Creating database db ...
---> 16:20:00     Granting privileges to user user for db ...
2016-06-21 16:20:00 70 [Warning] 'user' entry 'root mysql-1-irei5' ignored in --skip-name-resolve mode.
2016-06-21 16:20:00 70 [Warning] 'user' entry '@mysql-1-irei5' ignored in --skip-name-resolve mode.
2016-06-21 16:20:00 70 [Warning] 'proxies_priv' entry '@ root mysql-1-irei5' ignored in --skip-name-resolve mode.
---> 16:20:00     Initialization finished
---> 16:20:00     Setting passwords ...
2016-06-21 16:20:00 70 [Warning] 'user' entry 'root mysql-1-irei5' ignored in --skip-name-resolve mode.
2016-06-21 16:20:00 70 [Warning] 'user' entry '@mysql-1-irei5' ignored in --skip-name-resolve mode.
2016-06-21 16:20:00 70 [Warning] 'proxies_priv' entry '@ root mysql-1-irei5' ignored in --skip-name-resolve mode.
---> 16:20:00     Sourcing post-init.sh ...
---> 16:20:00     Shutting down MySQL ...
2016-06-21 16:20:00 70 [Warning] 'user' entry 'root mysql-1-irei5' ignored in --skip-name-resolve mode.
2016-06-21 16:20:00 70 [Warning] 'user' entry '@mysql-1-irei5' ignored in --skip-name-resolve mode.
2016-06-21 16:20:00 70 [Warning] 'proxies_priv' entry '@ root mysql-1-irei5' ignored in --skip-name-resolve mode.
2016-06-21 16:20:00 70 [Note] /opt/rh/rh-mysql56/root/usr/libexec/mysqld: Normal shutdown

2016-06-21 16:20:00 70 [Note] Giving 0 client threads a chance to die gracefully
2016-06-21 16:20:00 70 [Note] Event Scheduler: Purging the queue. 0 events
2016-06-21 16:20:00 70 [Note] Shutting down slave threads
2016-06-21 16:20:00 70 [Note] Forcefully disconnecting 0 remaining clients
2016-06-21 16:20:00 70 [Note] Binlog end
2016-06-21 16:20:00 70 [Note] Shutting down plugin 'partition'
2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_METRICS'
2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_CMP'
2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-06-21 16:20:00 70 [Note] Shutting down plugin 'INNODB_TRX'
2016-06-21 16:20:00 70 [Note] Shutting down plugin 'InnoDB'
2016-06-21 16:20:00 70 [Note] InnoDB: FTS optimize thread exiting.
2016-06-21 16:20:00 70 [Note] InnoDB: Starting shutdown...
2016-06-21 16:20:01 70 [Note] InnoDB: Shutdown completed; log sequence number 1625997
2016-06-21 16:20:01 70 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-06-21 16:20:01 70 [Note] Shutting down plugin 'ARCHIVE'
2016-06-21 16:20:01 70 [Note] Shutting down plugin 'BLACKHOLE'
2016-06-21 16:20:01 70 [Note] Shutting down plugin 'MRG_MYISAM'
2016-06-21 16:20:01 70 [Note] Shutting down plugin 'MyISAM'
2016-06-21 16:20:01 70 [Note] Shutting down plugin 'MEMORY'
2016-06-21 16:20:01 70 [Note] Shutting down plugin 'CSV'
2016-06-21 16:20:01 70 [Note] Shutting down plugin 'sha256_password'
2016-06-21 16:20:01 70 [Note] Shutting down plugin 'mysql_old_password'
2016-06-21 16:20:01 70 [Note] Shutting down plugin 'mysql_native_password'
2016-06-21 16:20:01 70 [Note] Shutting down plugin 'binlog'
2016-06-21 16:20:01 70 [Note] /opt/rh/rh-mysql56/root/usr/libexec/mysqld: Shutdown complete

---> 16:20:02     Cleaning up environment variables MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE and MYSQL_ROOT_PASSWORD ...
---> 16:20:02     Running final exec -- Only MySQL server logs after this point
2016-06-21 16:20:02 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-06-21 16:20:02 0 [Note] /opt/rh/rh-mysql56/root/usr/libexec/mysqld (mysqld 5.6.26) starting as process 1 ...
2016-06-21 16:20:02 1 [Note] Plugin 'FEDERATED' is disabled.
2016-06-21 16:20:02 6c4828a2d840 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-06-21 16:20:02 1 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-06-21 16:20:02 1 [Note] InnoDB: The InnoDB memory heap is disabled
2016-06-21 16:20:02 1 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-06-21 16:20:02 1 [Note] InnoDB: Memory barrier is not used
2016-06-21 16:20:02 1 [Note] InnoDB: Compressed tables use zlib 1.2.7
2016-06-21 16:20:02 1 [Note] InnoDB: Using Linux native AIO
2016-06-21 16:20:02 1 [Note] InnoDB: Using CPU crc32 instructions
2016-06-21 16:20:02 1 [Note] InnoDB: Initializing buffer pool, size = 32.0M
2016-06-21 16:20:02 1 [Note] InnoDB: Completed initialization of buffer pool
2016-06-21 16:20:02 1 [Note] InnoDB: Highest supported file format is Barracuda.
2016-06-21 16:20:02 1 [Note] InnoDB: 128 rollback segment(s) are active.
2016-06-21 16:20:02 1 [Note] InnoDB: Waiting for purge to start
2016-06-21 16:20:02 1 [Note] InnoDB: 5.6.26 started; log sequence number 1625997
2016-06-21 16:20:02 1 [Note] RSA private key file not found: /var/lib/mysql/data//private_key.pem. Some authentication plugins will not work.
2016-06-21 16:20:02 1 [Note] RSA public key file not found: /var/lib/mysql/data//public_key.pem. Some authentication plugins will not work.
2016-06-21 16:20:02 1 [Note] Server hostname (bind-address): '*'; port: 3306
2016-06-21 16:20:02 1 [Note] IPv6 is available.
2016-06-21 16:20:02 1 [Note]   - '::' resolves to '::';
2016-06-21 16:20:02 1 [Note] Server socket created on IP: '::'.
2016-06-21 16:20:02 1 [Warning] 'user' entry 'root mysql-1-irei5' ignored in --skip-name-resolve mode.
2016-06-21 16:20:02 1 [Warning] 'user' entry '@mysql-1-irei5' ignored in --skip-name-resolve mode.
2016-06-21 16:20:02 1 [Warning] 'proxies_priv' entry '@ root mysql-1-irei5' ignored in --skip-name-resolve mode.
2016-06-21 16:20:02 1 [Note] Event Scheduler: Loaded 0 events
2016-06-21 16:20:02 1 [Note] /opt/rh/rh-mysql56/root/usr/libexec/mysqld: ready for connections.
Version: '5.6.26'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)


From: bparees redhat com
Date: Tue, 21 Jun 2016 11:20:22 -0400
Subject: Re: MySQL: Readiness probe failed
To: dencowboy hotmail com
CC: users lists openshift redhat com

can you provide the logs from the postgres pod?


On Tue, Jun 21, 2016 at 10:44 AM, Den Cowboy <dencowboy hotmail com> wrote:
I'm using the MySQL template and started it with the right environment variables
The MySQL is running fine but I got this error and I'm not able to access my mysql on its service name:

mysql -u myuser -h mysql -p
password:xxx


Readiness probe failed: sh: cannot set terminal process group (-1): Inappropriate ioctl for device sh: no job control in this shell ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111)


_______________________________________________
users mailing list
users lists openshift redhat com
http://lists.openshift.redhat.com/openshiftmm/listinfo/users




--
Ben Parees | OpenShift


_______________________________________________ users mailing list users lists openshift redhat com http://lists.openshift.redhat.com/openshiftmm/listinfo/users

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]