LINUX.ORG.RU
ФорумAdmin

Не работает mysql-server

 , , , ,


0

1

Не запускается mysql. Не знаю что делать(((

Выкладываю логи:

160530 13:24:26 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 160530 13:24:26 [Note] /usr/sbin/mysqld (mysqld 5.5.43-MariaDB-1~precise-log) starting as process 4042 ... 160530 13:24:26 InnoDB: The InnoDB memory heap is disabled 160530 13:24:26 InnoDB: Mutexes and rw_locks use GCC atomic builtins 160530 13:24:26 InnoDB: Compressed tables use zlib 1.2.3.4 160530 13:24:26 InnoDB: Using Linux native AIO 160530 13:24:26 InnoDB: Initializing buffer pool, size = 2.0G 160530 13:24:27 InnoDB: Completed initialization of buffer pool 160530 13:24:27 InnoDB: highest supported file format is Barracuda. InnoDB: Log scan progressed past the checkpoint lsn 16100349735 160530 13:24:27 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... InnoDB: Doing recovery: scanned up to log sequence number 16100354898 160530 13:24:28 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 160530 13:24:28 [ERROR] mysqld got signal 11 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware.

To report this bug, see http://kb.askmonty.org/en/reporting-bugs

We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail.

Server version: 5.5.43-MariaDB-1~precise-log key_buffer_size=16777216 read_buffer_size=131072 max_used_connections=0 max_threads=153 thread_count=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 352025 K bytes of memory Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x0x0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0x0 thread_stack 0x30000 /usr/sbin/mysqld(my_print_stacktrace+0x2b)[0xa79d9b] /usr/sbin/mysqld(handle_fatal_signal+0x398)[0x6cfc58] /lib/x86_64-linux-gnu/libpthread.so.0(+0xfcb0)[0x7f2cd007fcb0] /usr/sbin/mysqld[0x92d396] /usr/sbin/mysqld[0x92e814] /usr/sbin/mysqld[0x9152dc] /usr/sbin/mysqld[0x916faa] 160530 13:24:26 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 160530 13:24:26 [Note] /usr/sbin/mysqld (mysqld 5.5.43-MariaDB-1~precise-log) starting as process 4042 ... 160530 13:24:26 InnoDB: The InnoDB memory heap is disabled 160530 13:24:26 InnoDB: Mutexes and rw_locks use GCC atomic builtins 160530 13:24:26 InnoDB: Compressed tables use zlib 1.2.3.4 160530 13:24:26 InnoDB: Using Linux native AIO 160530 13:24:26 InnoDB: Initializing buffer pool, size = 2.0G 160530 13:24:27 InnoDB: Completed initialization of buffer pool 160530 13:24:27 InnoDB: highest supported file format is Barracuda. InnoDB: Log scan progressed past the checkpoint lsn 16100349735 160530 13:24:27 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... InnoDB: Doing recovery: scanned up to log sequence number 16100354898 160530 13:24:28 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 160530 13:24:28 [ERROR] mysqld got signal 11 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware.

To report this bug, see http://kb.askmonty.org/en/reporting-bugs

We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail.

Server version: 5.5.43-MariaDB-1~precise-log key_buffer_size=16777216 read_buffer_size=131072 max_used_connections=0 max_threads=153 thread_count=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 352025 K bytes of memory Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x0x0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0x0 thread_stack 0x30000 /usr/sbin/mysqld(my_print_stacktrace+0x2b)[0xa79d9b] /usr/sbin/mysqld(handle_fatal_signal+0x398)[0x6cfc58] /lib/x86_64-linux-gnu/libpthread.so.0(+0xfcb0)[0x7f2cd007fcb0] /usr/sbin/mysqld[0x92d396] /usr/sbin/mysqld[0x92e814] /usr/sbin/mysqld[0x9152dc] /usr/sbin/mysqld[0x916faa] /usr/sbin/mysqld[0x89bb87] /usr/sbin/mysqld[0x8db666] /usr/sbin/mysqld[0x848848] /lib/x86_64-linux-gnu/libpthread.so.0(+0x7e9a)[0x7f2cd0077e9a] /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f2cce70b38d] The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. 160530 13:24:28 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

mysqld_safe --log-error=/var/log/mysql.err

160530 13:27:44 mysqld_safe Can't log to error log and syslog at the same time. Remove all --log-error configuration options for --syslog to take effect. 160530 13:27:44 mysqld_safe Logging to '/var/log/mysql.err'. 160530 13:27:44 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 160530 13:27:46 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

Помоги с данной задачей(. Спасибо.


Ответ на: комментарий от vit667

Прошу прощенья, я только осваиваю Linux, не могли бы подсказать как проверить статус? Спасибо.

ggg-
() автор топика
Ответ на: комментарий от ggg-

Выполнить команду mount в консоли

Выйдет что-то вроде этого Где /dev/sd* Ваш раздел на жестком диске, а параметры в скобках (rw,relatime,user_xattr,barrier=1,data=ordered) это опции с которыми этот раздел подключен к системе (rw - чтиние/запись) и где on /mnt как в моем случае, директория, куда подключен раздел

проверьте не ro ли там? ( ro - read only )

sysfs on /sys type sysfs (rw,nosuid,nodev,noexec,relatime) proc on /proc type proc (rw,nosuid,nodev,noexec,relatime) udev on /dev type devtmpfs (rw,relatime,size=10240k,nr_inodes=4091320,mode=755) devpts on /dev/pts type devpts (rw,nosuid,noexec,relatime,gid=5,mode=620,ptmxmode=000) tmpfs on /run type tmpfs (rw,nosuid,noexec,relatime,size=3274400k,mode=755) /dev/disk/by-uuid/523717bb-4d80-41ca-a029-d9d1f0770ca4 on / type ext4 (rw,relatime,errors=remount-ro,user_xattr,barrier=1,data=ordered) tmpfs on /run/lock type tmpfs (rw,nosuid,nodev,noexec,relatime,size=5120k) tmpfs on /run/shm type tmpfs (rw,nosuid,nodev,noexec,relatime,size=9900940k) /dev/md1 on /boot type ext2 (rw,relatime,errors=continue) rpc_pipefs on /var/lib/nfs/rpc_pipefs type rpc_pipefs (rw,relatime) /dev/sdc1 on /mnt type ext4 (rw,relatime,user_xattr,barrier=1,data=ordered)

vit667
()
Ответ на: комментарий от vit667

#mount

/dev/xvda1 on / type ext4 (rw,errors=remount-ro) proc on /proc type proc (rw,noexec,nosuid,nodev) sysfs on /sys type sysfs (rw,noexec,nosuid,nodev) none on /sys/fs/fuse/connections type fusectl (rw) none on /sys/kernel/debug type debugfs (rw) none on /sys/kernel/security type securityfs (rw) udev on /dev type devtmpfs (rw,mode=0755) devpts on /dev/pts type devpts (rw,noexec,nosuid,gid=5,mode=0620) tmpfs on /run type tmpfs (rw,noexec,nosuid,size=10%,mode=0755) none on /run/lock type tmpfs (rw,noexec,nosuid,nodev,size=5242880) none on /run/shm type tmpfs (rw,nosuid,nodev) /dev/xvdb5 on /mnt/disk type ext4 (rw) none on /proc/xen type xenfs (rw)

ggg-
() автор топика
Ответ на: комментарий от vit667

Жесткий диск забился данными, пришлось примонтировать новый, сделал бэкап базы, и перенес ее на новый диск. Ссылкой прокинул туда где и была. Выставил права. Перезапустил mysql. Вот в принципе и все мои действия. В чем может быть проблема?

ggg-
() автор топика
Ответ на: комментарий от ggg-

не могли бы вы предоставить гостевой доступ в свою систему, чтобы я мог подробнее посмотреть всё. Мои контакты в профиле

vit667
()
Ответ на: комментарий от vit667

Вот что выводит команда:
mysqld_safe --log-error=/var/log/mysql.err


160530 13:27:44 mysqld_safe Can't log to error log and syslog at the same time. Remove all --log-error configuration options for --syslog to take effect.
160530 13:27:44 mysqld_safe Logging to '/var/log/mysql.err'.
160530 13:27:44 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160530 13:27:46 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

ggg-
() автор топика
Ответ на: комментарий от vit667

Checking MyISAM file: /var/lib/mysql/mysql/columns_priv.MYI Data records: 0 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1

---------

Checking MyISAM file: /var/lib/mysql/mysql/db.MYI Data records: 5 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check data record references index: 2

---------

Checking MyISAM file: /var/lib/mysql/mysql/event.MYI Data records: 0 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check record links

---------

Checking MyISAM file: /var/lib/mysql/mysql/func.MYI Data records: 0 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1

---------

Checking MyISAM file: /var/lib/mysql/mysql/help_category.MYI Data records: 39 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check data record references index: 2 - check record links

---------

Checking MyISAM file: /var/lib/mysql/mysql/help_keyword.MYI Data records: 464 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check data record references index: 2

---------

Checking MyISAM file: /var/lib/mysql/mysql/help_relation.MYI Data records: 1028 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1

---------

Checking MyISAM file: /var/lib/mysql/mysql/help_topic.MYI Data records: 508 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check data record references index: 2 - check record links

---------

Checking MyISAM file: /var/lib/mysql/mysql/host.MYI Data records: 0 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1

---------

Checking MyISAM file: /var/lib/mysql/mysql/ndb_binlog_index.MYI Data records: 0 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check record links

---------

Checking MyISAM file: /var/lib/mysql/mysql/plugin.MYI Data records: 0 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check record links

---------

Checking MyISAM file: /var/lib/mysql/mysql/proc.MYI Data records: 8 Deleted blocks: 1 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check record links

---------

Checking MyISAM file: /var/lib/mysql/mysql/procs_priv.MYI Data records: 0 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check data record references index: 2

---------

Checking MyISAM file: /var/lib/mysql/mysql/proxies_priv.MYI Data records: 2 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check data record references index: 2

---------

Checking MyISAM file: /var/lib/mysql/mysql/servers.MYI Data records: 0 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1

---------

Checking MyISAM file: /var/lib/mysql/mysql/tables_priv.MYI Data records: 0 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check data record references index: 2

---------

Checking MyISAM file: /var/lib/mysql/mysql/time_zone_leap_second.MYI Data records: 0 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1

---------

Checking MyISAM file: /var/lib/mysql/mysql/time_zone.MYI Data records: 0 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1

---------

Checking MyISAM file: /var/lib/mysql/mysql/time_zone_name.MYI Data records: 0 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1

---------

Checking MyISAM file: /var/lib/mysql/mysql/time_zone_transition.MYI Data records: 0 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1

---------

Checking MyISAM file: /var/lib/mysql/mysql/time_zone_transition_type.MYI Data records: 0 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1

---------

Checking MyISAM file: /var/lib/mysql/mysql/user.MYI Data records: 10 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check record links

---------

Checking MyISAM file: /var/lib/mysql/zgdb/ds_sensors.MYI Data records: 4 Deleted blocks: 6 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check record links

---------

Checking MyISAM file: /var/lib/mysql/zgdb/ds_temps.MYI Data records: 58068 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1

К сожалению доступ к серверу предоставить не могу(

ggg-
() автор топика
Ответ на: комментарий от ggg-

На будущее, скрипт для бэкапа баз данных и веб хостов

#!/bin/bash

#Settings

BACKUP_PATH="/home/BACKUP"
TIMESTAMP=$(date +"%F")
MYSQL=/usr/bin/mysql
MYSQLDUMP=/usr/bin/mysqldump
MYSQL_USER="user"
MYSQL_PASS="password"
SITES_DIR="/var/www"

## Files backup

for i in `ls $SITES_DIR`; do

if [[ ! -e $BACKUP_PATH/vhosts/$i ]]; then
            mkdir $BACKUP_PATH/vhosts/$i
fi

tar czf $BACKUP_PATH/vhosts/$i/$i-$TIMESTAMP.tar.gz $SITES_DIR/$i
done

databases=`$MYSQL --user=$MYSQL_USER -p$MYSQL_PASS -e "SHOW DATABASES;" | grep -Ev "(Database|information_schema|performance_schema)"`

for db in $databases; do

if [[ ! -e $BACKUP_PATH/bases/$db ]]; then
            mkdir $BACKUP_PATH/bases/$db
fi

  $MYSQLDUMP --force --opt --user=$MYSQL_USER -p$MYSQL_PASS --databases $db | gzip > "$BACKUP_PATH/bases/$db/$db-$TIMESTAMP.gz"
done

## Remove old backups

find $BACKUP_PATH/vhosts -mtime +3|xargs rm -f
find $BACKUP_PATH/bases -mtime +3|xargs rm -f

vit667
()
Ответ на: комментарий от vit667

А как? как исправить данную ошибку? Подскажите пожалуйста, очень нужно.

ggg-
() автор топика
Вы не можете добавлять комментарии в эту тему. Тема перемещена в архив.