Warning: [obfuscated]():....

[Vision]

Hello,
each day when i connect on my panel have this error:

Warning: [obfuscated](): No such file or directory in /usr/local/cwpsrv/htdocs/admin/index.php on line 0
mysqld (pid 10652) is running...

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 when i open web page have this error: Could not connect to MySQL

Then refresh panel page and all works fine, but all nigth i have site offline.

Thanks.

[Administrator]

looks like you have some issue with mysql crash, this could be memory related or your site mostly in wordpress case xmlrpc.php is under dos attack.
You should check mysql, messages and apache logs more detailed.

If you don't have experience with linux then you can contact your hosting provider system admin or our managed support to assist you with this issue.

[Vision]

Thanks for aswer,
i have new OS and Panel installation on dedicated server with 2GB RAM, and dont have wordprerss site but only little database.
Memory related?

[Administrator]

the best would be to check the logs when mysql crashed and also to check the other services logs at that time to determinate the cause of the issue.

[vassilis3]

Same problem here
How did you solved the problem?

[robbyq]

Same problem here
How did you solved the problem?

the best would be to check the logs when mysql crashed and also to check the other services logs at that time to determinate the cause of the issue.

+1
4 days broken server at night...

what a solutions for that?
i´m not alone for that problem... more users have problems

Code Select Expand


1- I reset Password CWP
2- Reinstall MariaDB
3- Rebuild all Website with Apache
4- Fix Permisions

Not work nothing...

Instalado:
  MariaDB-client.x86_64 0:10.1.21-1.el6  MariaDB-common.x86_64 0:10.1.21-1.el6  MariaDB-compat.x86_64 0:10.1.21-1.el6  MariaDB-devel.x86_64 0:10.1.21-1.el6  MariaDB-server.x86_64 0:10.1.21-1.el6  galera.x86_64 0:25.3.19-1.rhel6.el6



[robbyq]

Up,

Againd down and 0 solution for fix that.

[robbyq]

Up,

Againd down and 0 solution for fix that.

I try cp /usr/share/mysql/my-huge.cnf /etc/my.cnf and restart for see

[Sandeep]

their will be many reason maybe dos attach or corrupted database, check the log file

[robbyq]

their will be many reason maybe dos attach or corrupted database, check the log file

The db y thinl it ok i fix all account and i repair / optimized DB with options...

At night again down...omg 6 days down website...

[Sandeep]

their will be many reason maybe dos attach or corrupted database, check the log file

The db y thinl it ok i fix all account and i repair / optimized DB with options...

At night again down...omg 6 days down website...

what is in the log ?

[robbyq]

their will be many reason maybe dos attach or corrupted database, check the log file

The db y thinl it ok i fix all account and i repair / optimized DB with options...

At night again down...omg 6 days down website...

what is in the log ?

The log i havnt see errors...
What logs need for see? Mysql? Apache? For paste here?

[Sandeep]

mysql log

[robbyq]

mysql log

Code

Code Select Expand


170126 16:25:13 mysqld_safe mysqld from pid file /var/lib/mysql/ns3010965.ip-188-165-236.eu.pid ended
170126 16:25:13 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2017-01-26 16:25:13 140260204697632 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
2017-01-26 16:25:13 140260204697632 [Note] /usr/sbin/mysqld (mysqld 10.1.21-MariaDB) starting as process 3130 ...
2017-01-26 16:25:13 140260204697632 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-01-26 16:25:13 140260204697632 [Note] InnoDB: The InnoDB memory heap is disabled
2017-01-26 16:25:13 140260204697632 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-01-26 16:25:13 140260204697632 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-01-26 16:25:13 140260204697632 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-01-26 16:25:13 140260204697632 [Note] InnoDB: Using Linux native AIO
2017-01-26 16:25:13 140260204697632 [Note] InnoDB: Using SSE crc32 instructions
2017-01-26 16:25:13 140260204697632 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-01-26 16:25:13 140260204697632 [Note] InnoDB: Completed initialization of buffer pool
2017-01-26 16:25:13 140260204697632 [Note] InnoDB: Highest supported file format is Barracuda.
2017-01-26 16:25:14 140260204697632 [Note] InnoDB: 128 rollback segment(s) are active.
2017-01-26 16:25:14 140260204697632 [Note] InnoDB: Waiting for purge to start
2017-01-26 16:25:14 140260204697632 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 10076517483
2017-01-26 16:25:14 140259140540160 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-01-26 16:25:14 140260204697632 [Note] Plugin 'FEEDBACK' is disabled.
2017-01-26 16:25:14 140260204697632 [Note] Server socket created on IP: '::'.
2017-01-26 16:25:14 140260204697632 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.1.21-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
2017-01-27  3:21:01 140258884406016 [Note] /usr/sbin/mysqld: Normal shutdown
[b]
2017-01-27  3:21:01 140258884406016 [Note] Event Scheduler: Purging the queue. 0 events
2017-01-27  3:21:02 140259119560448 [Note] InnoDB: FTS optimize thread exiting.
2017-01-27  3:21:02 140258884406016 [Note] InnoDB: Starting shutdown...
2017-01-27  3:21:02 140258884406016 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
170127 03:21:03 mysqld_safe A mysqld process already exists
2017-01-27  3:21:04 140258884406016 [Note] InnoDB: Shutdown completed; log sequence number 10095605593
2017-01-27  3:21:04 140258884406016 [Note] /usr/sbin/mysqld: Shutdown complete

170127 03:21:04 mysqld_safe mysqld from pid file /var/lib/mysql/ns3010965.ip-188-165-236.eu.pid ended
[/b]
170127 09:59:21 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2017-01-27  9:59:21 140316613531680 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
2017-01-27  9:59:21 140316613531680 [Note] /usr/sbin/mysqld (mysqld 10.1.21-MariaDB) starting as process 29701 ...
2017-01-27  9:59:21 140316613531680 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-01-27  9:59:21 140316613531680 [Note] InnoDB: The InnoDB memory heap is disabled
2017-01-27  9:59:21 140316613531680 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-01-27  9:59:21 140316613531680 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-01-27  9:59:21 140316613531680 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-01-27  9:59:21 140316613531680 [Note] InnoDB: Using Linux native AIO
2017-01-27  9:59:21 140316613531680 [Note] InnoDB: Using SSE crc32 instructions
2017-01-27  9:59:21 140316613531680 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-01-27  9:59:21 140316613531680 [Note] InnoDB: Completed initialization of buffer pool
2017-01-27  9:59:21 140315719612160 [Warning] InnoDB: Setting thread 29708 nice to 0 failed, current nice 10, errno 13
2017-01-27  9:59:21 140315730102016 [Warning] InnoDB: Setting thread 29707 nice to 0 failed, current nice 10, errno 13
2017-01-27  9:59:21 140315688142592 [Warning] InnoDB: Setting thread 29711 nice to 0 failed, current nice 10, errno 13
2017-01-27  9:59:21 140315740591872 [Warning] InnoDB: Setting thread 29706 nice to 0 failed, current nice 10, errno 13
2017-01-27  9:59:21 140315698632448 [Warning] InnoDB: Setting thread 29710 nice to 0 failed, current nice 10, errno 13
2017-01-27  9:59:21 140315751081728 [Warning] InnoDB: Setting thread 29705 nice to 0 failed, current nice 10, errno 13
2017-01-27  9:59:21 140315669268224 [Warning] InnoDB: Setting thread 29712 nice to 0 failed, current nice 10, errno 13
2017-01-27  9:59:21 140315709122304 [Warning] InnoDB: Setting thread 29709 nice to 0 failed, current nice 10, errno 13
2017-01-27  9:59:21 140315612673792 [Warning] InnoDB: Setting thread 29713 nice to 0 failed, current nice 10, errno 13




all night 3-4

[robbyq]

mysql log

Code

Code Select Expand


170126 16:25:13 mysqld_safe mysqld from pid file /var/lib/mysql/ns3010965.ip-188-165-236.eu.pid ended
170126 16:25:13 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2017-01-26 16:25:13 140260204697632 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
2017-01-26 16:25:13 140260204697632 [Note] /usr/sbin/mysqld (mysqld 10.1.21-MariaDB) starting as process 3130 ...
2017-01-26 16:25:13 140260204697632 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-01-26 16:25:13 140260204697632 [Note] InnoDB: The InnoDB memory heap is disabled
2017-01-26 16:25:13 140260204697632 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-01-26 16:25:13 140260204697632 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-01-26 16:25:13 140260204697632 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-01-26 16:25:13 140260204697632 [Note] InnoDB: Using Linux native AIO
2017-01-26 16:25:13 140260204697632 [Note] InnoDB: Using SSE crc32 instructions
2017-01-26 16:25:13 140260204697632 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-01-26 16:25:13 140260204697632 [Note] InnoDB: Completed initialization of buffer pool
2017-01-26 16:25:13 140260204697632 [Note] InnoDB: Highest supported file format is Barracuda.
2017-01-26 16:25:14 140260204697632 [Note] InnoDB: 128 rollback segment(s) are active.
2017-01-26 16:25:14 140260204697632 [Note] InnoDB: Waiting for purge to start
2017-01-26 16:25:14 140260204697632 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 10076517483
2017-01-26 16:25:14 140259140540160 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-01-26 16:25:14 140260204697632 [Note] Plugin 'FEEDBACK' is disabled.
2017-01-26 16:25:14 140260204697632 [Note] Server socket created on IP: '::'.
2017-01-26 16:25:14 140260204697632 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.1.21-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
2017-01-27  3:21:01 140258884406016 [Note] /usr/sbin/mysqld: Normal shutdown
[b]
2017-01-27  3:21:01 140258884406016 [Note] Event Scheduler: Purging the queue. 0 events
2017-01-27  3:21:02 140259119560448 [Note] InnoDB: FTS optimize thread exiting.
2017-01-27  3:21:02 140258884406016 [Note] InnoDB: Starting shutdown...
2017-01-27  3:21:02 140258884406016 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
170127 03:21:03 mysqld_safe A mysqld process already exists
2017-01-27  3:21:04 140258884406016 [Note] InnoDB: Shutdown completed; log sequence number 10095605593
2017-01-27  3:21:04 140258884406016 [Note] /usr/sbin/mysqld: Shutdown complete

170127 03:21:04 mysqld_safe mysqld from pid file /var/lib/mysql/ns3010965.ip-188-165-236.eu.pid ended
[/b]
170127 09:59:21 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2017-01-27  9:59:21 140316613531680 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
2017-01-27  9:59:21 140316613531680 [Note] /usr/sbin/mysqld (mysqld 10.1.21-MariaDB) starting as process 29701 ...
2017-01-27  9:59:21 140316613531680 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-01-27  9:59:21 140316613531680 [Note] InnoDB: The InnoDB memory heap is disabled
2017-01-27  9:59:21 140316613531680 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-01-27  9:59:21 140316613531680 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-01-27  9:59:21 140316613531680 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-01-27  9:59:21 140316613531680 [Note] InnoDB: Using Linux native AIO
2017-01-27  9:59:21 140316613531680 [Note] InnoDB: Using SSE crc32 instructions
2017-01-27  9:59:21 140316613531680 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-01-27  9:59:21 140316613531680 [Note] InnoDB: Completed initialization of buffer pool
2017-01-27  9:59:21 140315719612160 [Warning] InnoDB: Setting thread 29708 nice to 0 failed, current nice 10, errno 13
2017-01-27  9:59:21 140315730102016 [Warning] InnoDB: Setting thread 29707 nice to 0 failed, current nice 10, errno 13
2017-01-27  9:59:21 140315688142592 [Warning] InnoDB: Setting thread 29711 nice to 0 failed, current nice 10, errno 13
2017-01-27  9:59:21 140315740591872 [Warning] InnoDB: Setting thread 29706 nice to 0 failed, current nice 10, errno 13
2017-01-27  9:59:21 140315698632448 [Warning] InnoDB: Setting thread 29710 nice to 0 failed, current nice 10, errno 13
2017-01-27  9:59:21 140315751081728 [Warning] InnoDB: Setting thread 29705 nice to 0 failed, current nice 10, errno 13
2017-01-27  9:59:21 140315669268224 [Warning] InnoDB: Setting thread 29712 nice to 0 failed, current nice 10, errno 13
2017-01-27  9:59:21 140315709122304 [Warning] InnoDB: Setting thread 29709 nice to 0 failed, current nice 10, errno 13
2017-01-27  9:59:21 140315612673792 [Warning] InnoDB: Setting thread 29713 nice to 0 failed, current nice 10, errno 13




all night 3-4

Today not down, fix?