store | blogs | forums | twitter | facebook | wiki | downloads | support portal
Atomic Secure Linux
It is currently Tue Oct 15, 2019 10:19 pm

» Feed - Atomicorp

All times are UTC - 5 hours [ DST ]




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: Mysql start/stop
Unread postPosted: Fri Jun 07, 2013 5:06 am 
Offline
New Forum User
New Forum User

Joined: Fri Jun 07, 2013 4:55 am
Posts: 2
Location: Moscow
[root@CentOS-63-64-minimal log]# mysql -V
mysql Ver 14.14 Distrib 5.5.31, for Linux (x86_64) using readline 5.1

if i have enabled skip-networking in config all fine.
But if skip-networking is disabled i have some errors. Mysql cannot turn off himself.
Code:
[root@CentOS-63-64-minimal log]# ps ax | grep mysql
 2018 pts/0    S      0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid --basedir=/usr --user=mysql
 2396 pts/0    Sl     0:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/CentOS-63-64-minimal.err --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock --port=3306
 2489 pts/0    S+     0:00 grep mysql
[root@CentOS-63-64-minimal log]# service mysqld stop
Stopping mysqld:                                           [  OK  ]
[root@CentOS-63-64-minimal log]# ps ax | grep mysql
 2528 ?        SN     0:00 /bin/sh /etc/init.d/mysqld start
 2562 ?        SN     0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid --basedir=/usr --user=mysql
 2944 ?        SNl    0:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/CentOS-63-64-minimal.err --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock --port=3306
 2970 pts/0    S+     0:00 grep mysql
[root@CentOS-63-64-minimal log]# service mysqld stop
Stopping mysqld:                                           [  OK  ]
[root@CentOS-63-64-minimal log]# ps ax | grep mysql
 3017 pts/0    S+     0:00 grep mysql
[root@CentOS-63-64-minimal log]#


and if i'll start mysql after when i have stoped this at first time, i have errors

Code:
Version: '5.5.31-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL) by Atomicorp
130531 23:45:11 [Warning] IP address '218.93.205.140' could not be resolved: Name or service not known
130601  7:57:20 [Warning] IP address '66.199.146.70' could not be resolved: Name or service not known
130602  9:10:55 [Warning] IP address '173.208.202.182' could not be resolved: Name or service not known
130603 19:43:50 [Warning] IP address '218.8.245.123' could not be resolved: Name or service not known
130604  7:01:41 [Warning] IP address '118.119.254.21' could not be resolved: Name or service not known
130604  7:25:05 [Warning] IP address '173.208.240.203' could not be resolved: Name or service not known
130605 13:30:10 [Warning] IP address '222.73.86.69' could not be resolved: Name or service not known
130605 14:57:00 [Note] /usr/libexec/mysqld: Normal shutdown

130605 14:57:00 [Note] Event Scheduler: Purging the queue. 0 events
130605 14:57:00  InnoDB: Starting shutdown...
130605 14:57:02  InnoDB: Shutdown completed; log sequence number 951248779
130605 14:57:02 [Note] /usr/libexec/mysqld: Shutdown complete

130605 14:57:02 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
130605 14:57:03 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130605 14:57:03 [Note] libgovernor.so not found
130605 14:57:03 [Note] Plugin 'FEDERATED' is disabled.
130605 14:57:03 InnoDB: The InnoDB memory heap is disabled
130605 14:57:03 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130605 14:57:03 InnoDB: Compressed tables use zlib 1.2.3
130605 14:57:03 InnoDB: Using Linux native AIO
130605 14:57:03 InnoDB: Initializing buffer pool, size = 128.0M
130605 14:57:03 InnoDB: Completed initialization of buffer pool
130605 14:57:03 InnoDB: highest supported file format is Barracuda.
130605 14:57:03  InnoDB: Waiting for the background threads to start
130605 14:57:04 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130605 14:57:04 [Note] libgovernor.so not found
130605 14:57:04 [Note] Plugin 'FEDERATED' is disabled.
130605 14:57:04 InnoDB: The InnoDB memory heap is disabled
130605 14:57:04 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130605 14:57:04 InnoDB: Compressed tables use zlib 1.2.3
130605 14:57:04 InnoDB: Using Linux native AIO
130605 14:57:04 InnoDB: Initializing buffer pool, size = 128.0M
130605 14:57:04 InnoDB: Completed initialization of buffer pool
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
130605 14:57:04  InnoDB: Retrying to lock the first data file
130605 14:57:04 InnoDB: 5.5.31 started; log sequence number 951248779
130605 14:57:04 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130605 14:57:04 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
130605 14:57:04 [Note] Server socket created on IP: '0.0.0.0'.
130605 14:57:04 [Note] Event Scheduler: Loaded 0 events
130605 14:57:04 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.31-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL) by Atomicorp
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process


And only when i stoping mysql at second time i have no errors.


Top
 Profile  
Reply with quote  
 Post subject: Re: Mysql start/stop
Unread postPosted: Fri Jun 07, 2013 2:28 pm 
Offline
Long Time Forum Regular
Long Time Forum Regular

Joined: Thu Dec 09, 2004 11:19 am
Posts: 2321
Does this help: http://serverfault.com/questions/393862 ... e-resolved

Please note the comments about security that are also made in that post.

_________________
--------------------------------
<advert>
If you want to rent a UK-based VPS that comes with friendly advice and support from a fellow ART fan, please get in touch.
</advert>


Top
 Profile  
Reply with quote  
 Post subject: Re: Mysql start/stop
Unread postPosted: Sat Jun 08, 2013 5:18 pm 
Offline
New Forum User
New Forum User

Joined: Fri Jun 07, 2013 4:55 am
Posts: 2
Location: Moscow
no, problem not in resolving. In MySQL 5.1 I don't have same problem.


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

» Feed - Atomicorp

All times are UTC - 5 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group