MRatWork Forum by Mustafa Ramadhan
Sawo Project - Kloxo-MR Discussions => Kloxo-MR Technical Helps => Topic started by: hoangsang on 2016-01-06, 03:20:39
-
I'm run script but error :(
[root@bns ~]# sh /script/resetpassword master 'XXXXXXX'
Notice : The resource you have requested doesn't exist. The server returned the error message: <br> only_admin_can_modify_general nname <br>
Please help me!
-
Inform here your 'sh /script/sysinfo'.
How to fix depend on your Kloxo-MR version.
-
Because MySQL is stop :(
i'm run
sh /script/upcp
but show error:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused")
and MySQL restart failured
My System:
[root@bns ~]# sh /script/sysinfo
A. Kloxo-MR: 7.0.0.b-2016010501
- Web: hiawatha-9.13.0-f.6.mr.el6.x86_64
- PHP: php54s-5.4.41-1.ius.el6 (fpm mode)
B. Plateform:
- OS: CentOS release 6.6 (Final) x86_64
- Hostname: bns.cbder.com
C. Services:
1. MySQL: MariaDB-server-10.0.20-1.el6.x86_64
2. PHP:
- Branch: php54-cli-5.4.45-1.ius.el6.x86_64
- Multiple:
* php52m-5.2.17-102.mr.el6
* php53m-5.3.29-1.ius.el6
* php54m-5.4.41-1.ius.el6
* php55m-5.5.25-1.ius.el6
* php56m-5.6.9-1.ius.el6
- Used: --Use PHP Branch--
3. Httpd: httpd-2.2.31-1.mr.el6.x86_64
- PHP Type: [unknown]
4. Lighttpd: --uninstalled--
5. Hiawatha: --unused--
6. Nginx: --uninstalled--
7. Cache: --uninstalled--
8. Dns: bind-9.9.7-1.mr.el6.x86_64
9. Qmail: qmail-toaster-1.03-1.3.55.mr.el6.x86_64
- with: courier-imap-toaster-4.1.2-1.3.18.mr.el6.x86_64
D. Memory:
total used free shared buffers cached
Mem: 7857 7016 840 0 81 6293
-/+ buffers/cache: 642 7215
Swap: 7999 0 7999
E. Disk Space:
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_bachngoddfh-lv_root
50G 47G 0 100% /
*** Process Time: 00:00:00:02.2920 (dd:hh:mm:ss:xxxxxx) ***
* Note: run 'sh /script/sysinfo -y' if you want run 'fix-service-list' also
(importance after Kloxo-MR update)
-
Try:
sh /script/reset-mysql-root-password YOURPASSWORD
sh /script/mysql-optimize --select=upgrade
and then try again resetpassword
-
Try:
sh /script/reset-mysql-root-password YOURPASSWORD
sh /script/mysql-optimize --select=upgrade
and then try again resetpassword
MySQL don't start :(
[root@bns script]# sh /script/reset-mysql-root-password Hongxxxx890
Stop MySQL service...
MySQL ROOT password reset...
Start MySQL service...
-
Inform here 'service mysql restart'.
-
Inform here 'service mysql restart'.
[root@bns script]# service mysql restart
ERROR! MySQL server PID file could not be found!
Starting MySQL...
and
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused")
-
Open '/etc/my.cnf.d/server.cnf' and change 'skip-innodb' to '#skip-innodb'.
-
Open '/etc/my.cnf.d/server.cnf' and change 'skip-innodb' to '#skip-innodb'.
this file changed
# These groups are read by MariaDB server.
# Use it for options that only the server (but not clients) should see
#
# See the examples of server my.cnf files in /usr/share/mysql/
#
# this is read by the standalone daemon and embedded servers
[server]
# this is only for the mysqld standalone daemon
[mysqld]
max_connections = 400
max_user_connections=600
performance_schema=on
default-storage-engine=myisam
#skip-innodb
#OpenVZ AIO bug fix
innodb_use_native_aio=0
#
#
max_allowed_packet=18M
#
#
# this is only for embedded server
[embedded]
# This group is only read by MariaDB servers, not by MySQL.
# If you use the same .cnf file for MySQL and MariaDB,
# you can put MariaDB-only options here
[mariadb]
# This group is only read by MariaDB-10.0 servers.
# If you use the same .cnf file for MariaDB of different versions,
# use this group for options that older servers don't understand
[mariadb-10.0]
~
~
but don't start MySQL
ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists
[root@bns ~]# rm -f /var/lock/subsys/mysql
[root@bns ~]# service mysql restart
ERROR! MySQL server PID file could not be found!
Starting MySQL... ERROR!
-
Inform here 'cat /var/lib/mysql/*.err' (need 20 latest line of file content).
-
Inform here 'cat /var/lib/mysql/*.err' (need 20 latest line of file content).
MySQL is running, but website error
Mysqli prepare error: Can't find file: './bachngoc_bnsxen/xf_thread_view.MYI' (errno: 2 "No such file or directory")
Log.
160106 15:29:03 [Note] /usr/sbin/mysqld (mysqld 10.0.20-MariaDB) starting as process 29438 ...
160106 15:29:03 [Note] InnoDB: Using mutexes to ref count buffer pool pages
160106 15:29:03 [Note] InnoDB: The InnoDB memory heap is disabled
160106 15:29:03 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
160106 15:29:03 [Note] InnoDB: Memory barrier is not used
160106 15:29:03 [Note] InnoDB: Compressed tables use zlib 1.2.3
160106 15:29:03 [Note] InnoDB: Using CPU crc32 instructions
160106 15:29:03 [Note] InnoDB: Initializing buffer pool, size = 128.0M
160106 15:29:03 [Note] InnoDB: Completed initialization of buffer pool
160106 15:29:03 [Note] InnoDB: Highest supported file format is Barracuda.
160106 15:29:03 [Note] InnoDB: 128 rollback segment(s) are active.
160106 15:29:03 [Note] InnoDB: Waiting for purge to start
160106 15:29:03 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.24-72.2 started; log sequence number 158940094253
160106 15:29:03 [Note] Plugin 'FEEDBACK' is disabled.
160106 15:29:03 [Note] Server socket created on IP: '::'.
160106 15:29:03 [Note] Event Scheduler: Loaded 0 events
160106 15:29:03 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.0.20-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
160106 15:29:04 [ERROR] mysqld: Table './bachngoc_bnsxen/xf_error_log' is marked as crashed and should be repaired
160106 15:29:04 [Warning] Checking table: './bachngoc_bnsxen/xf_error_log'
160106 15:29:04 [Warning] Recovering table: './bachngoc_bnsxen/xf_error_log'
160106 15:29:45 [Warning] mysqld: Disk is full writing './bachngoc_bnsxen/xf_error_log.MYD' (Errcode: 28 "No space left on device"). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
160106 15:29:45 [Warning] mysqld: Retry in 60 secs. Message reprinted in 600 secs
2016-01-06 15:29:46 7f9de7bff700 InnoDB: Error: Write to file ./bachngoc_bnsdru/cache_menu.ibd failed at offset 13333692416.
InnoDB: 1048576 bytes should have been written, only 0 were written.
InnoDB: Operating system error number 28.
InnoDB: Check that your OS and file system support files of this size.
InnoDB: Check also that the disk is not full or a disk quota exceeded.
InnoDB: Error number 28 means 'No space left on device'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
FAIL160106 15:29:46 [ERROR] mysqld: The table 'cache_menu' is full
FAIL160106 15:29:48 [ERROR] mysqld: The table 'cache_menu' is full
FAIL160106 15:29:54 [ERROR] mysqld: The table 'cache_menu' is full
FAIL160106 15:29:54 [ERROR] mysqld: The table 'cache_menu' is full
FAIL160106 15:29:54 [ERROR] mysqld: The table 'cache_menu' is full
FAIL160106 15:31:55 [ERROR] mysqld: The table 'cache_menu' is full
160106 15:34:11 [ERROR] mysqld: Table './bachngoc_bnsxen/xf_mail_queue' is marked as crashed and should be repaired
160106 15:34:11 [Warning] Checking table: './bachngoc_bnsxen/xf_mail_queue'
160106 15:34:11 [ERROR] mysqld: Table './bachngoc_bnsxen/xf_poll_response' is marked as crashed and should be repaired
160106 15:34:11 [Warning] Checking table: './bachngoc_bnsxen/xf_poll_response'
160106 15:34:11 [ERROR] mysqld: Table './bachngoc_bnsxen/xf_poll_vote' is marked as crashed and should be repaired
160106 15:34:11 [Warning] Checking table: './bachngoc_bnsxen/xf_poll_vote'
160106 15:34:11 [ERROR] mysqld: Table './bachngoc_bnsxen/xf_store_product' is marked as crashed and should be repaired
160106 15:34:11 [Warning] Checking table: './bachngoc_bnsxen/xf_store_product'
160106 15:34:12 [ERROR] mysqld: Table './bachngoc_bnsxen/xf_store_transaction' is marked as crashed and should be repaired
160106 15:34:12 [Warning] Checking table: './bachngoc_bnsxen/xf_store_transaction'
160106 15:34:12 [ERROR] mysqld: Table './bachngoc_bnsxen/xf_user_status' is marked as crashed and should be repaired
160106 15:34:[root@bns tmp]#
-
There something wrong with database with innodb storage-engine (error like '[ERROR] mysqld: Table './bachngoc_bnsxen/xf_user_status' is marked as crashed and should be repaired'.
-
MySQL is Stop :(
Log file :(
160106 17:43:14 [Note] InnoDB: Initializing buffer pool, size = 128.0M
160106 17:43:14 [Note] InnoDB: Completed initialization of buffer pool
160106 17:43:14 [Note] InnoDB: Highest supported file format is Barracuda.
160106 17:43:14 [Note] InnoDB: The log sequence numbers 159528416482 and 159528416482 in ibdata files do not match the log sequence number 162756977297 in the ib_logfiles!
160106 17:43:14 [Note] InnoDB: Database was not shutdown normally!
160106 17:43:14 [Note] InnoDB: Starting crash recovery.
160106 17:43:14 [Note] InnoDB: Reading tablespace information from the .ibd files...
160106 17:43:14 [Note] InnoDB: Restoring possible half-written data pages
160106 17:43:14 [Note] InnoDB: from the doublewrite buffer...
InnoDB: 1 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 1 row operations to undo
InnoDB: Trx id counter is 21706496
160106 17:43:14 [Note] InnoDB: 128 rollback segment(s) are active.
InnoDB: Starting in background the rollback of uncommitted transactions
2016-01-06 17:43:14 7f16943ff700 InnoDB: Rolling back trx with id 21706000, 1 rows to undo
160106 17:43:14 [Note] InnoDB: Waiting for purge to start
2016-01-06 17:43:14 7f16943ff700 InnoDB: Error: Write to file ./bachngoc_bnsdru/cache_menu.ibd failed at offset 16840130560.
InnoDB: 1048576 bytes should have been written, only 307200 were written.
InnoDB: Operating system error number 28.
InnoDB: Check that your OS and file system support files of this size.
InnoDB: Check also that the disk is not full or a disk quota exceeded.
InnoDB: Error number 28 means 'No space left on device'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
FAIL160106 17:43:14 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.24-72.2 started; log sequence number 162756977297
160106 17:43:14 [Note] Plugin 'FEEDBACK' is disabled.
160106 17:43:14 [Note] Server socket created on IP: '::'.
160106 17:43:14 [ERROR] mysqld: Error writing file '/var/lib/mysql/bns.bachngocsach.com.pid' (Errcode: 28 "No space left on device")
160106 17:43:14 [ERROR] Can't start server: can't create PID file: No space left on device
160106 17:43:14 mysqld_safe Number of processes running now: 0
160106 17:43:14 mysqld_safe mysqld restarted
160106 17:43:14 [Note] /usr/sbin/mysqld (mysqld 10.0.20-MariaDB) starting as process 28619 ...
160106 17:43:14 [Note] InnoDB: Using mutexes to ref count buffer pool pages
160106 17:43:14 [Note] InnoDB: The InnoDB memory heap is disabled
160106 17:43:14 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
160106 17:43:14 [Note] InnoDB: Memory barrier is not used
160106 17:43:14 [Note] InnoDB: Compressed tables use zlib 1.2.3
160106 17:43:14 [Note] InnoDB: Using CPU crc32 instructions
160106 17:43:14 [Note] InnoDB: Initializing buffer pool, size = 128.0M
160106 17:43:14 [Note] InnoDB: Completed initialization of buffer pool
160106 17:43:14 [Note] InnoDB: Highest supported file format is Barracuda.
160106 17:43:14 [Note] InnoDB: The log sequence numbers 159528416482 and 159528416482 in ibdata files do not match the log sequence number 162756977297 in the ib_logfiles!
160106 17:43:14 [Note] InnoDB: Database was not shutdown normally!
160106 17:43:14 [Note] InnoDB: Starting crash recovery.
160106 17:43:14 [Note] InnoDB: Reading tablespace information from the .ibd files...
160106 17:43:14 [Note] InnoDB: Restoring possible half-written data pages
16010[root@bns ~]# service mysql restart
ERROR! MySQL server PID file could not be found!
Starting MySQL...^C
Please help me!
-
Add 'innodb_force_recovery = 1' in /etc/my.cnf.d/server.cnf under '[mysqld]' and then restart mysql with 'sh /script/restart-mysql -y'.
-
Add 'innodb_force_recovery = 1' in /etc/my.cnf.d/server.cnf under '[mysqld]' and then restart mysql with 'sh /script/restart-mysql -y'.
MySQL stops due to full disk filesystem.
Currently my SQL subdirectory of /var/lib/mysql/. How long do I move it to the directory /home/DB/ ?
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_bachngoddfh-lv_root
50G 47G 0 100% /
-
Your / (root) directory is full. Not able to move to other directory.
-
Your / (root) directory is full. Not able to move to other directory.
But /home directory is avail 429GB
[root@bns ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_bachngocsach-lv_root
50G 49G 100% /
tmpfs 3.9G 0 3.9G 0% /dev/shm
/dev/sda1 477M 73M 379M 17% /boot
/dev/mapper/vg_bachngocsach-lv_home
492G 39G 429G 9% /home
Move mysql database to other path?
-
Yes, able move/copy to directory under /home.