Author Topic: problem with start Mysql  (Read 1051 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
problem with start Mysql
« on: January 07, 2017, 11:56:51 PM »
Hi all i have a install after 8 months a cwp and worked perfect but in this night i try to login in cwp pannel and my password is not worked ... i reboot my server and now i recive this error :

Warning: [obfuscated](): No such file or directory in /usr/local/cwpsrv/htdocs/admin/index.php on line 0
ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists

Trying to start mysql server, please wait!
Try to restart CentOS Web Panel with command: service cwpsrv restart

**Check your MySQL root password in: /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php and /root/.my.cnf

Could not connect: No such file or directory

and i specific: in /root/.my.cnf and /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php is same password !!!

AND I HAVE THIS VERSION:  mysql  Ver 15.1 Distrib 10.1.20-MariaDB, for Linux (x86_64) using readline 5.1


i try to restart mysqld manualy and recive :
[root@srv ~]# service mysqld start
Starting MySQL.170108 01:58:56 mysqld_safe Logging to '/var/lib/mysql/srv.netlinkunix.eu.err'.
.. ERROR!

and in /var/lib/mysql/srv.netlinkunix.eu.err     have this :
170108 02:00:28 mysqld_safe mysqld from pid file /var/lib/mysql/srv.netlinkunix.eu.pid ended
170108 02:00:33 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2017-01-08  2:00:34 139957175629856 [Note] /usr/sbin/mysqld (mysqld 10.1.20-MariaDB) starting as process 16418 ...
2017-01-08  2:00:34 139957175629856 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-01-08  2:00:34 139957175629856 [Note] InnoDB: The InnoDB memory heap is disabled
2017-01-08  2:00:34 139957175629856 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-01-08  2:00:34 139957175629856 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-01-08  2:00:34 139957175629856 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-01-08  2:00:34 139957175629856 [Note] InnoDB: Using Linux native AIO
2017-01-08  2:00:34 139957175629856 [Note] InnoDB: Using SSE crc32 instructions
2017-01-08  2:00:34 139957175629856 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-01-08  2:00:34 139957175629856 [Note] InnoDB: Completed initialization of buffer pool
2017-01-08  2:00:34 139957175629856 [Note] InnoDB: Highest supported file format is Barracuda.
2017-01-08  2:00:34 139957175629856 [Note] InnoDB: 128 rollback segment(s) are active.
2017-01-08  2:00:34 139957175629856 [Note] InnoDB: Waiting for purge to start
2017-01-08  2:00:34 139957175629856 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 1$
2017-01-08  2:00:34 139957175629856 [Note] Plugin 'FEEDBACK' is disabled.
2017-01-08  2:00:34 139957175629856 [Note] Recovering after a crash using tc.log
2017-01-08  2:00:34 139957175629856 [ERROR] Can't init tc log
2017-01-08  2:00:34 139957175629856 [ERROR] Aborting




I need help to solved this problem !!!


Tnx
« Last Edit: January 08, 2017, 11:32:35 AM by vinceent »

Offline
*
Re: problem with start Mysql
« Reply #1 on: January 08, 2017, 11:40:09 AM »
SOLVED !!!!

cd /var/lib/mysql/
and after delete this:  rm -rf tc.log
after:  service mysqld restart


Offline
**
Re: problem with start Mysql
« Reply #2 on: January 24, 2017, 10:10:09 AM »
SOLVED !!!!

cd /var/lib/mysql/
and after delete this:  rm -rf tc.log
after:  service mysqld restart

i am same error
Code: [Select]
Warning: [obfuscated](): No such file or directory in /usr/local/cwpsrv/htdocs/admin/index.php on line 0
SUCCESS! MySQL running (27041)

Trying to start mysql server, please wait!
Try to restart CentOS Web Panel with command: service cwpsrv restart

**Check your MySQL root password in: /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php and /root/.my.cnf

Could not connect: No such file or directory