MySQL Forums
Forum List  »  Install & Repo

Installing Mysql Community 7.5.16 on CentOS 6.8
Posted by: Arturo Puente
Date: October 29, 2016 03:47PM

I am trying to install Mysql Community 7.5.16 on CentOS 6.8.
I followed all the instructions in the installation, and almost got to
the end, but when I write the command

service mysqld start

For the first time, mysqld seems to be starting but suddenly goes down.
I am including all the information that the command gives me.

# cat /etc/my.cnf
[mysqld]
datadir = /var/lib/mysql #
socket = /var/lib/mysql/mysql.sock #
port = 3306 #
user = mysql #
explicit_defaults_for_timestamp = 1 #
slow_query_log = 1 #
slow_query_log_file = mysql-slow-queries #
long_query_time = 2 #
# #
[mysqld_safe]
log-error = /var/log/mysqld.log #
pid-file = /var/run/mysqld/mysqld.pid #
# #
[mysql]


First time start of mysqld
**************************

# service mysqld start
Initializing MySQL database:
2016-10-22 T15:48:24.729017Z 0 [Warning] InnoDB: New log files created, LSN=45790
2016-10-22 T15:48:25.271869Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2016-10-22 T15:48:25.367096Z 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: f7dd2da0-986e-11e6-92c8-d067e5e72edb.
2016-10-22 T15:48:25.396388Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2016-10-22 T15:48:25.397246Z 1 [Note] A temporary password is generated for root@localhost: VSb97u*PbDv<
[ OK ]
Installing validate password plugin:
2016-10-22 T15:48:38.718398Z 0 [Warning] Insecure configuration for --secure-file-priv: Location is accessible to all OS users.
Consider choosing a different directory.
2016-10-22 T15:48:38.718438Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.16-log) starting as process 2636 ...
2016-10-22 T15:48:38.721254Z 0 [Note] InnoDB: PUNCH HOLE support available
2016-10-22 T15:48:38.721265Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-10-22 T15:48:38.721269Z 0 [Note] InnoDB: Uses event mutexes
2016-10-22 T15:48:38.721273Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2016-10-22 T15:48:38.721276Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-10-22 T15:48:38.721279Z 0 [Note] InnoDB: Using Linux native AIO
2016-10-22 T15:48:38.721458Z 0 [Note] InnoDB: Number of pools: 1
2016-10-22 T15:48:38.721525Z 0 [Note] InnoDB: Using CPU crc32 instructions
2016-10-22 T15:48:38.722406Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2016-10-22 T15:48:38.728202Z 0 [Note] InnoDB: Completed initialization of buffer pool
2016-10-22 T15:48:38.729762Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed.
See the man page of setpriority().
2016-10-22 T15:48:38.741782Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2016-10-22 T15:48:38.792549Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2016-10-22 T15:48:38.792598Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2016-10-22 T15:48:39.171566Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2016-10-22 T15:48:39.172805Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2016-10-22 T15:48:39.172821Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2016-10-22 T15:48:39.174067Z 0 [Note] InnoDB: Waiting for purge to start
2016-10-22 T15:48:39.224222Z 0 [Note] InnoDB: 5.7.16 started; log sequence number 2532845
2016-10-22 T15:48:39.224662Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2016-10-22 T15:48:39.224814Z 0 [Note] Plugin 'FEDERATED' is disabled.
2016-10-22 T15:48:39.226331Z 0 [Note] InnoDB: Buffer pool(s) load completed at 161022 11:48:39
2016-10-22 T15:48:39.230271Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without
certificate and private key
2016-10-22 T15:48:39.230281Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2016-10-22 T15:48:39.230331Z 0 [Note] IPv6 is available.
2016-10-22 T15:48:39.230337Z 0 [Note] - '::' resolves to '::';
2016-10-22 T15:48:39.230351Z 0 [Note] Server socket created on IP: '::'.
2016-10-22 T15:48:39.272299Z 0 [Note] Event Scheduler: Loaded 0 events
2016-10-22 T15:48:39.272389Z 0 [Note] Execution of init_file '/var/lib/mysql/install-validate-password-plugin.92FH3L.sql' started.
2016-10-22 T15:48:39.314133Z 0 [Note] Execution of init_file '/var/lib/mysql/install-validate-password-plugin.92FH3L.sql' ended.
2016-10-22 T15:48:39.314242Z 0 [Note] /usr/sbin/mysqld: ready for connections.

Version: '5.7.16-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)

2016-10-22 T15:48:39.314524Z 0 [Note] Giving 0 client threads a chance to die gracefully
2016-10-22 T15:48:39.314552Z 0 [Note] Shutting down slave threads
2016-10-22 T15:48:39.314566Z 0 [Note] Forcefully disconnecting 0 remaining clients
2016-10-22 T15:48:39.314582Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2016-10-22 T15:48:39.314693Z 0 [Note] Binlog end
2016-10-22 T15:48:39.315255Z 0 [Note] Shutting down plugin 'ngram'
2016-10-22 T15:48:39.315270Z 0 [Note] Shutting down plugin 'ARCHIVE'
2016-10-22 T15:48:39.315275Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2016-10-22 T15:48:39.315281Z 0 [Note] Shutting down plugin 'partition'
2016-10-22 T15:48:39.315287Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-10-22 T15:48:39.315331Z 0 [Note] Shutting down plugin 'MEMORY'
2016-10-22 T15:48:39.315339Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2016-10-22 T15:48:39.315345Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-10-22 T15:48:39.315350Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-10-22 T15:48:39.315354Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-10-22 T15:48:39.315359Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-10-22 T15:48:39.315364Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-10-22 T15:48:39.315368Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-10-22 T15:48:39.315373Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-10-22 T15:48:39.315378Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-10-22 T15:48:39.315382Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-10-22 T15:48:39.315386Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-10-22 T15:48:39.315391Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-10-22 T15:48:39.315395Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-10-22 T15:48:39.315400Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-10-22 T15:48:39.315404Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-10-22 T15:48:39.315409Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-10-22 T15:48:39.315414Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2016-10-22 T15:48:39.315418Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2016-10-22 T15:48:39.315422Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-10-22 T15:48:39.315427Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-10-22 T15:48:39.315431Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-10-22 T15:48:39.315436Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-10-22 T15:48:39.315440Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-10-22 T15:48:39.315444Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-10-22 T15:48:39.315449Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-10-22 T15:48:39.315453Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-10-22 T15:48:39.315458Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2016-10-22 T15:48:39.315462Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-10-22 T15:48:39.315467Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-10-22 T15:48:39.315471Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2016-10-22 T15:48:39.315475Z 0 [Note] Shutting down plugin 'InnoDB'
2016-10-22 T15:48:39.315582Z 0 [Note] InnoDB: FTS optimize thread exiting.
2016-10-22 T15:48:39.315688Z 0 [Note] InnoDB: Starting shutdown...
2016-10-22 T15:48:39.415830Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2016-10-22 T15:48:39.416106Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 161022 11:48:39
2016-10-22 T15:48:41.054170Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2533084
2016-10-22 T15:48:41.058284Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2016-10-22 T15:48:41.058304Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2016-10-22 T15:48:41.058316Z 0 [Note] Shutting down plugin 'CSV'
2016-10-22 T15:48:41.058325Z 0 [Note] Shutting down plugin 'MyISAM'
2016-10-22 T15:48:41.058334Z 0 [Note] Shutting down plugin 'sha256_password'
2016-10-22 T15:48:41.058340Z 0 [Note] Shutting down plugin 'mysql_native_password'
2016-10-22 T15:48:41.058545Z 0 [Note] Shutting down plugin 'binlog'
2016-10-22 T15:48:41.058925Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

[ OK ]
MySQL Daemon failed to start.
Starting mysqld: [FAILED]


And these are the entries in the log.

entries in /var/log/mysql.log
*****************************

2016-10-22 T15:48:41.684266Z mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2016-10-22 T15:48:41.857323Z mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

What is the reason for mysqld to die suddenly.?

Thank you for your help with this questions.

Arturo Puente

Options: ReplyQuote


Subject
Written By
Posted
Installing Mysql Community 7.5.16 on CentOS 6.8
October 29, 2016 03:47PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.