mojamoi

Well-Known Member
Jul 23, 2007
186
0
66
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:
Code:
[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
[email protected] [/var/lib/mysql]# service mysql status
ERROR! MySQL is not running, but lock exists
[email protected] [/var/lib/mysql]#
 
Last edited:

mojamoi

Well-Known Member
Jul 23, 2007
186
0
66
installed it by /scripts/upcp

but still the first issue


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:
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,201
363
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.
 

mojamoi

Well-Known Member
Jul 23, 2007
186
0
66
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

- - - 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
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,201
363
Check to make sure none of your partitions are full:

Code:
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.