mysql error
Hi
What is solution for thei mysql error?
MySQL error in file: /engine/classes/mysqli.class.php at line 52
Error Number: 1
The Error returned was:
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
SQL query:
/etc/my.cnf has following values:
I get this error root@se [/var/lib/mysql]# service mysql status ERROR! MySQL is not running, but lock exists root@se [/var/lib/mysql]#
[mysqld]
datadir=/var/lib/mysql
local-infile=0
safe-show-database
query_cache_limit=128M
query_cache_size=128M ## 32MB for every 1GB of RAM
query_cache_type=1
max_user_connections=2000
max_connections=300
#interactive_timeout=40
interactive_timeout=15
#wait_timeout=40
wait_timeout=15
#connect_timeout=40
connect_timeout=10
thread_cache_size=128
key_buffer=256M ## 128MB for every 1GB of RAM
join_buffer=1M
max_connect_errors=20
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=2M ## 1MB for every 1GB of RAM
read_buffer_size=2M ## 1MB for every 1GB of RAM
read_rnd_buffer_size=2M ## 1MB for every 1GB of RAM
thread_concurrency=8 ## Number of CPUs x 2
myisam_sort_buffer_size=64M
server-id=1
collation-server=latin1_general_ci
skip-name-resolve
log_slow_queries = 10
slow_query_log_file = /var/log/mysql/slow_query_log
open_files_limit=50000
innodb_file_per_table=1
innodb_thread_concurrency =0
open_files_limit=4162
user = mysql
skip-external-locking
I get this error root@se [/var/lib/mysql]# service mysql status ERROR! MySQL is not running, but lock exists root@se [/var/lib/mysql]#
-
I did yum remove mysql on teh server cpanel what can i do to reinstall it 0 -
installed it by /scripts/upcp but still the first issue [QUOTE]MySQL Error! MySQL error in file: /engine/classes/mysqli.class.php at line 52 Error Number: 1 The Error returned was: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) SQL query: 0 -
Hello :) Please attempt to restart MySQL and let us know the error message you see in /var/lib/mysql/$hostname.err when the restart fails. Thank you. 0 -
Restart of mysql never fails however it always gives the error above in running state It always starts However the status shows as not running at times [COLOR="silver">- - - Updated - - - Here are log files from $hostname.err 120923 13:05:06 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 120923 13:05:06 [Note] Plugin 'FEDERATED' is disabled. 120923 13:05:07 InnoDB: Initializing buffer pool, size = 8.0M 120923 13:05:07 InnoDB: Completed initialization of buffer pool InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 120923 13:05:07 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 120923 13:05:13 InnoDB: Started; log sequence number 5 2084801700 120923 13:05:14 [Note] Event Scheduler: Loaded 0 events 120923 13:05:14 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.1.63-cll' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 120923 13:05:42 [ERROR] /usr/sbin/mysqld: Table './eximstats/sends' is marked as crashed and last (automatic?) repair failed 120923 13:05:42 [ERROR] /usr/sbin/mysqld: Table './eximstats/sends' is marked as crashed and last (automatic?) repair failed 120923 13:05:43 [ERROR] /usr/sbin/mysqld: Table './eximstats/smtp' is marked as crashed and last (automatic?) repair failed 0 -
Check to make sure none of your partitions are full: df -h df -i
If not, please open a support ticket using the link in my signature so we can take a closer look. You can post the ticket number here so we can update this thread with the outcome. Thank you.0
Please sign in to leave a comment.
Comments
5 comments