Cannot get it started on CentOS 7

After years w/vanilla MySQL we’re working to jump to Percona. So we did vanilla install. Starting it up but it errors out… But wait, there’s a process running! Oh good! Oh but wait, I can’t login (see last red circle). How do I log in?

Static hostname: localhost.localdomain
Icon name: computer-vm
Chassis: vm
Machine ID: c82455519f5b4eac85de2ea3c39ab8c8
Boot ID: 8accfd28cf7344ca98ef2a05fb7f40d9
Virtualization: vmware
Operating System: CentOS Linux 7 (Core)
CPE OS Name: cpe:/o:centos:centos:7
Kernel: Linux 3.10.0-693.2.2.el7.x86_64
Architecture: x86-64[/INDENT]

Need to have the following:

  • Percona Server version installed (rpm -qa|grep -i percona)
  • full mysql error log since the upgrade and where PS did not start.
# rpm -qa | grep -i percona

# cat /var/log/mysqld.log | more
2017-09-17T21:11:22.931848Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-09-17T21:11:32.007488Z 0 [Warning] InnoDB: New log files created, LSN=45790
2017-09-17T21:11:33.021294Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2017-09-17T21:11:33.144867Z 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: c832ca29-9bec-11e7-bd62-000c29a5f040.
2017-09-17T21:11:33.147081Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2017-09-17T21:11:33.746547Z 0 [Warning] CA certificate ca.pem is self signed.
2017-09-17T21:11:34.025940Z 1 [Note] A temporary password is generated for root@localhost: ghF1K.fvYJCp
2017-09-17T21:11:42.060654Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-09-17T21:11:42.064374Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.19-17) starting as process 11578 ...
2017-09-17T21:11:42.073968Z 0 [Note] InnoDB: PUNCH HOLE support available
2017-09-17T21:11:42.074063Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-09-17T21:11:42.074072Z 0 [Note] InnoDB: Uses event mutexes
2017-09-17T21:11:42.074078Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-09-17T21:11:42.074084Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2017-09-17T21:11:42.074090Z 0 [Note] InnoDB: Using Linux native AIO
2017-09-17T21:11:42.074939Z 0 [Note] InnoDB: Number of pools: 1
2017-09-17T21:11:42.075307Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2017-09-17T21:11:42.081079Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2017-09-17T21:11:42.094141Z 0 [Note] InnoDB: Completed initialization of buffer pool
2017-09-17T21:11:42.101707Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2017-09-17T21:11:42.115863Z 0 [Note] InnoDB: Crash recovery did not find the parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite
2017-09-17T21:11:42.117462Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2017-09-17T21:11:42.242189Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite, size 3932160 bytes
2017-09-17T21:11:42.254716Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2017-09-17T21:11:42.255040Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2017-09-17T21:11:43.153597Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2017-09-17T21:11:43.156165Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2017-09-17T21:11:43.156210Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2017-09-17T21:11:43.159258Z 0 [Note] InnoDB: Waiting for purge to start
2017-09-17T21:11:43.209836Z 0 [Note] InnoDB: Percona XtraDB ( 5.7.19-17 started; log sequence number 2544743
2017-09-17T21:11:43.210555Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2017-09-17T21:11:43.211401Z 0 [Note] Plugin 'FEDERATED' is disabled.
2017-09-17T21:11:43.215746Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170917 21:11:43
2017-09-17T21:11:43.229544Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2017-09-17T21:11:43.229582Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2017-09-17T21:11:43.233372Z 0 [Warning] CA certificate ca.pem is self signed.
2017-09-17T21:11:43.233693Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2017-09-17T21:11:43.235849Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2017-09-17T21:11:43.236198Z 0 [Note] IPv6 is available.
2017-09-17T21:11:43.236254Z 0 [Note] - '::' resolves to '::';
2017-09-17T21:11:43.236369Z 0 [Note] Server socket created on IP: '::'.
2017-09-17T21:11:43.259093Z 0 [Note] Event Scheduler: Loaded 0 events
2017-09-17T21:11:43.260066Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.19-17' socket: '/var/lib/mysql/mysql.sock' port: 3306 Percona Server (GPL), Release 17, Revision e19a6b7b73f
2017-09-17T21:11:43.260099Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check
2017-09-17T21:11:43.260105Z 0 [Note] Beginning of list of non-natively partitioned tables
2017-09-17T21:11:43.285140Z 0 [Note] End of list of non-natively partitioned tables
2017-09-17T21:12:06.309173Z 3 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2017-09-17T21:12:10.457617Z 4 [Note] Access denied for user 'root'@'localhost' (using password: YES)
2017-09-17T21:12:16.120394Z 5 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2017-09-17T21:12:16.808896Z 6 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2017-09-17T21:15:05.232418Z 0 [Note] Giving 0 client threads a chance to die gracefully
2017-09-17T21:15:05.232539Z 0 [Note] Shutting down slave threads
2017-09-17T21:15:05.232584Z 0 [Note] Forcefully disconnecting 0 remaining clients
2017-09-17T21:15:05.232612Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2017-09-17T21:15:05.232803Z 0 [Note] Binlog end
2017-09-17T21:15:05.234920Z 0 [Note] Shutting down plugin 'validate_password'
2017-09-17T21:15:05.235052Z 0 [Note] Shutting down plugin 'ngram'
2017-09-17T21:15:05.235063Z 0 [Note] Shutting down plugin 'ARCHIVE'
2017-09-17T21:15:05.235069Z 0 [Note] Shutting down plugin 'partition'
2017-09-17T21:15:05.235073Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2017-09-17T21:15:05.235089Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2017-09-17T21:15:05.235159Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2017-09-17T21:15:05.235172Z 0 [Note] Shutting down plugin 'CSV'
2017-09-17T21:15:05.235182Z 0 [Note] Shutting down plugin 'MyISAM'
2017-09-17T21:15:05.235215Z 0 [Note] Shutting down plugin 'MEMORY'
2017-09-17T21:15:05.235233Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2017-09-17T21:15:05.235885Z 0 [Note] InnoDB: FTS optimize thread exiting.
2017-09-17T21:15:05.236370Z 0 [Note] InnoDB: Starting shutdown...
2017-09-17T21:15:05.337035Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2017-09-17T21:15:05.338400Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 170917 21:15:05
2017-09-17T21:15:06.337940Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2017-09-17T21:15:07.852938Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2544771
2017-09-17T21:15:07.855878Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2017-09-17T21:15:07.855899Z 0 [Note] Shutting down plugin 'sha256_password'
2017-09-17T21:15:07.855904Z 0 [Note] Shutting down plugin 'mysql_native_password'
2017-09-17T21:15:07.856522Z 0 [Note] Shutting down plugin 'binlog'
2017-09-17T21:15:07.859126Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

Going to uninstall and try again unless you have other thoughts?

Ping! Any thoughts?

BTW, called the tech support line, got a really nice guy in Philippines but don’t have support contract, yet… Hoping these boards proved L1-type tech support… Plan to purchase support contract if these boards help with the basics…

Hello? Mic check…

Bummed this forums aren’t more active…

Removed everything, reinstalled, works fine.

BTW, default password is here: