Not the answer you need?
Register and ask your own question!

Cannot get it started on CentOS 7

gmillikangmillikan ContributorCurrent User Role Contributor
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]


  • jriverajrivera Percona Support Engineer Percona Staff Role
    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.
  • gmillikangmillikan Contributor Current User Role Contributor
    # 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
  • gmillikangmillikan Contributor Current User Role Contributor
    Going to uninstall and try again unless you have other thoughts?
  • gmillikangmillikan Contributor Current User Role Contributor
    Ping! Any thoughts?
  • gmillikangmillikan Contributor Current User Role Contributor
    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...
  • gmillikangmillikan Contributor Current User Role Contributor
    Hello? Mic check...
  • gmillikangmillikan Contributor Current User Role Contributor
    Bummed this forums aren't more active...
  • gmillikangmillikan Contributor Current User Role Contributor
    Removed everything, reinstalled, works fine.
  • gmillikangmillikan Contributor Current User Role Contributor
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.