• Как сделать отступ первой строки в абзаце?

    @Hakas_Lepehen Автор вопроса
    WbICHA, А разве css стили можно подключить в pdf?
    Написано
  • Почему подключается defer вместо простого script?

    @Hakas_Lepehen Автор вопроса
    Фёдор, Прошу прощения за невнимательность мою
    Написано
  • После некорректного отключения виртуалки не запускается MySQL. Почему?

    @Hakas_Lepehen Автор вопроса
    Олег Подскажите, а где в логах это можно было бы посмотреть? Или нужно бы файл конфига приложить к вопросу?
    Написано
  • Почему не запускается сервер MySQL?

    @Hakas_Lepehen Автор вопроса
    Антон CityCat4 Sand получил после изменения в настройках по рекомендации anton99zel
    MySQL Query Error: UPDATE b_user SET STORED_HASH = NULL, LAST_LOGIN = now(), TIMESTAMP_X = TIMESTAMP_X, LOGIN_ATTEMPTS = 0 , TIME_ZONE_OFFSET = 3600 WHERE ID=244[[1036]
    Написано
  • Почему не запускается сервер MySQL?

    @Hakas_Lepehen Автор вопроса
    Антон, на Ваш вопрос не смогу дать ответа так как запустили виртуалку с установленным на нем дистрибутивом, распаковали туда архив преоставленный битриксом и оставили как есть. С появлением каких то мелких проблем делали вкладки и ничего более
    Написано
  • Почему не запускается сервер MySQL?

    @Hakas_Lepehen Автор вопроса
    CityCat4, Понял. Благодарю. Где то были бэкапы. Начну качать
    Написано
  • Почему не запускается сервер MySQL?

    @Hakas_Lepehen Автор вопроса
    Sand, -rw-r----- 1 mysql mysql 67108864 дек 25 13:59 /var/lib/mysql/ib_logfile0
    -rw-r----- 1 mysql mysql 67108864 дек 25 13:18 /var/lib/mysql/ib_logfile1

    grep inno /etc/my.cnf
    default-storage-engine = innodb
    innodb_file_per_table
    innodb_buffer_pool_size = 32M
    innodb_flush_log_at_trx_commit = 2
    innodb_log_file_size = 64M
    innodb_flush_method = O_DIRECT
    innodb_strict_mode = OFF
    innodb_log_checksums = ON
    innodb_force_recovery = 4
    Написано
  • Почему не запускается сервер MySQL?

    @Hakas_Lepehen Автор вопроса
    Sand, блин. извиняюсь
    Логи читал в файле
    /var/log/mysql/error.log (наверное это они)
    дек 25 13:19:38 server systemd[1]: Failed to start MySQL Server.
    дек 25 13:19:38 server systemd[1]: Unit mysqld.service entered failed state.
    дек 25 13:19:38 server systemd[1]: mysqld.service failed.
    дек 25 13:19:38 server systemd[1]: mysqld.service holdoff time over, scheduling restart.
    дек 25 13:19:38 server systemd[1]: Stopped MySQL Server.
    дек 25 13:19:38 server systemd[1]: start request repeated too quickly for mysqld.service
    дек 25 13:19:38 server systemd[1]: Failed to start MySQL Server.
    дек 25 13:19:38 server systemd[1]: Unit mysqld.service entered failed state.
    дек 25 13:19:38 server systemd[1]: mysqld.service failed.
    [root@server ~]# cd /etc/
    [root@server etc]# ls
    adjtime crontab fstab issue mc os-release profile.d sasl2 system-release
    aliases cron.weekly gcrypt issue.net mercurial pam.d protocols securetty system-release-cpe
    aliases.db crypttab GeoIP.conf kdump.conf mime.types papersize push-server security tcsd.conf
    alternatives csh.cshrc ghostscript kernel mke2fs.conf passwd python selinux terminfo
    anacrontab csh.login glvnd krb5.conf modprobe.d passwd- rc0.d services tmpfiles.d
    ansible dbus-1 gnupg krb5.conf.d modules-load.d pear rc1.d sestatus.conf tuned
    asound.conf default GREP_COLORS ld.so.cache motd pear.conf rc2.d shadow udev
    audisp depmod.d groff ld.so.conf msmtprc percona-server.cnf rc3.d shadow- vconsole.conf
    audit dhcp group ld.so.conf.d mtab percona-server.conf.d rc4.d shells vimrc
    authbind DIR_COLORS group- letsencrypt munin php.d rc5.d skel virc
    bash_completion.d DIR_COLORS.256color grub2.cfg libaudit.conf my.cnf php.ini rc6.d ssh wgetrc
    bashrc DIR_COLORS.lightbgcolor grub.d libnl my.cnf.d php.ini.201907021450 rc.d ssl wpa_supplicant
    binfmt.d dkms gshadow libpaper.d mysql php.ini.202003091433 rc.local statetab X11
    bitrix-my.cnf dracut.conf gshadow- libuser.conf nagios php.ini.rpmnew redhat-release statetab.d xdg
    centos-release dracut.conf.d gss locale.conf nanorc php-zts.d redis.conf stunnel xinetd.conf
    centos-release-upstream e2fsck.conf host.conf localtime NetworkManager pkcs11 redis-sentinel.conf subgid xinetd.d
    chkconfig.d egl hostname login.defs networks pki resolv.conf subuid yum
    chrony.conf environment hosts logrotate.conf nginx plymouth resolv.conf.save sudo.conf yum.conf
    chrony.keys etckeeper hosts.allow logrotate.d nrpe.d pm rpc sudoers yum.repos.d
    conntrackd ethertypes hosts.deny machine-id nsswitch.conf polkit-1 rpm sudoers.d
    cron.d exports httpd magic nsswitch.conf.rpmnew popt.d rsyncd.conf sudo-ldap.conf
    cron.daily favicon.png init.d mailcap ntp ppp rsyslog.conf sysconfig
    cron.deny filesystems inittab mail.rc ntp.conf

    prelink.conf.d rsyslog.d sysctl.conf
    cron.hourly firewalld inputrc makedumpfile.conf.sample openldap printcap rwtab sysctl.d
    cron.monthly fonts iproute2 man_db.conf opt profile rwtab.d systemd
    [root@server etc]# cd my
    -bash: cd: my: Нет такого файла или каталога
    [root@server etc]# cd mysql/
    [root@server mysql]# ls
    conf.d
    [root@server mysql]# cd conf.d/
    [root@server conf.d]# ls
    bvat.cnf logging.cnf ystemctl status mysqld.service z_bx_custom.cnf
    [root@server conf.d]# nano status
    [root@server conf.d]# cd stat
    -bash: cd: stat: Нет такого файла или каталога
    [root@server conf.d]# cd status
    -bash: cd: status: Нет такого файла или каталога
    [root@server conf.d]# ls
    bvat.cnf logging.cnf ystemctl status mysqld.service z_bx_custom.cnf
    [root@server conf.d]# nano logging.cnf
    [root@server conf.d]# nano /var/log/mysql/error.log

    GNU nano 2.3.1 Файл: /var/log/mysql/error.log

    2020-12-25T03:29:35.212630Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 13919ms. The settings might not be optimal. (flushed=0, during the time.)
    2020-12-25T03:30:49.484454Z 76714 [Note] Got an error reading communication packets
    2020-12-25T03:31:01.120382Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7610ms. The settings might not be optimal. (flushed=0, during the time.)
    2020-12-25T03:35:00.554429Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5991ms. The settings might not be optimal. (flushed=0, during the time.)
    2020-12-25T03:35:16.222370Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4617ms. The settings might not be optimal. (flushed=0, during the time.)
    2020-12-25T03:35:49.489015Z 77013 [Note] Got an error reading communication packets
    2020-12-25T03:40:49.503695Z 77201 [Note] Got an error reading communication packets
    2020-12-25T03:41:01.540308Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5861ms. The settings might not be optimal. (flushed=0, during the time.)
    2020-12-25T03:41:24.309166Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6398ms. The settings might not be optimal. (flushed=0, during the time.)
    2020-12-25T03:45:12.704478Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4696ms. The settings might not be optimal. (flushed=0, during the time.)
    2020-12-25T03:45:38.206678Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6068ms. The settings might not be optimal. (flushed=0, during the time.)
    2020-12-25T03:45:49.521306Z 77498 [Note] Got an error reading communication packets
    2020-12-25T03:49:32.701712Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4480ms. The settings might not be optimal. (flushed=0, during the time.)
    2020-12-25T03:50:49.530561Z 77646 [Note] Got an error reading communication packets
    2020-12-25T03:55:49.767486Z 77818 [Note] Got an error reading communication packets
    2020-12-25T03:58:36.162091Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4246ms. The settings might not be optimal. (flushed=0, during the time.)
    2020-12-25T03:58:41.890415Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4728ms. The settings might not be optimal. (flushed=0, during the time.)
    2020-12-25T10:04:08.082509Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 24642)
    2020-12-25T10:04:08.082892Z 0 [Warning] Changed limits: table_open_cache: 2467 (requested 12288)
    2020-12-25T10:04:08.312133Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
    2020-12-25T10:04:08.315613Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.29-32) starting as process 2104 ...
    2020-12-25T10:04:08.357397Z 0 [Note] InnoDB: PUNCH HOLE support available
    2020-12-25T10:04:08.357442Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    2020-12-25T10:04:08.357446Z 0 [Note] InnoDB: Uses event mutexes
    2020-12-25T10:04:08.357449Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
    2020-12-25T10:04:08.357464Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
    2020-12-25T10:04:08.357471Z 0 [Note] InnoDB: Using Linux native AIO
    2020-12-25T10:04:08.358605Z 0 [Note] InnoDB: Number of pools: 1
    2020-12-25T10:04:08.358720Z 0 [Note] InnoDB: Using

    CPU crc32 instructions
    2020-12-25T10:04:08.377006Z 0 [Note] InnoDB: Initializing buffer pool, total size = 3G, instances = 8, chunk size = 128M
    2020-12-25T10:04:08.540746Z 0 [Note] InnoDB: Completed initialization of buffer pool
    2020-12-25T10:04:08.589226Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
    2020-12-25T10:04:08.672266Z 0 [Note] InnoDB: Recovering partial pages from the parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite
    2020-12-25T10:04:09.003551Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
    2020-12-25T10:04:09.087796Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 389077222946
    2020-12-25T10:04:09.087855Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 389077230270
    2020-12-25T10:04:09.088188Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 389077222946 and the end 389077230270.
    2020-12-25T10:04:09.088596Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
    2020-12-25T04:04:16.635458Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
    2020-12-25T04:04:16.635501Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
    2020-12-25T04:04:16.635507Z 0 [ERROR] Failed to initialize builtin plugins.
    2020-12-25T04:04:16.635513Z 0 [ERROR] Aborting
    Написано
  • Почему не запускается сервер MySQL?

    @Hakas_Lepehen Автор вопроса
    Sand, переместил файлы, перезапустил командой systemctl restart mysql
    В ответ получаю ob for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details
    Далее ввожу
    [root@server ~]# systemctl status mysqld.service
    ● mysqld.service - MySQL Server
    Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
    Active: failed (Result: start-limit) since Пт 2020-12-25 13:19:38 +06; 5min ago
    Docs: man:mysqld(8)
    dev.mysql.com/doc/refman/en/using-systemd.html
    Process: 3002 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=1/FAILURE)
    Process: 2973 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)

    дек 25 13:19:38 server systemd[1]: Failed to start MySQL Server.
    дек 25 13:19:38 server systemd[1]: Unit mysqld.service entered failed state.
    дек 25 13:19:38 server systemd[1]: mysqld.service failed.
    дек 25 13:19:38 server systemd[1]: mysqld.service holdoff time over, scheduling restart.
    дек 25 13:19:38 server systemd[1]: Stopped MySQL Server.
    дек 25 13:19:38 server systemd[1]: start request repeated too quickly for mysqld.service
    дек 25 13:19:38 server systemd[1]: Failed to start MySQL Server.
    дек 25 13:19:38 server systemd[1]: Unit mysqld.service entered failed state.
    дек 25 13:19:38 server systemd[1]: mysqld.service failed.
    Написано
  • Почему не запускается сервер MySQL?

    @Hakas_Lepehen Автор вопроса
    Sand, конечно) не хотелось бы по причине собственной криворукости что то сломать
    Написано
  • Почему не запускается сервер MySQL?

    @Hakas_Lepehen Автор вопроса
    Sand, нашел два таких файла. Удалять их всех?
    Написано
  • Почему не запускается сервер MySQL?

    @Hakas_Lepehen Автор вопроса
    Sand, по указанному вопросу там имеются эти пункты в решении проблемы
    Set innodb_log_checksums = ON on master and slave.
    Remove rm /var/lib/mysql/ib_logfile*.
    Restart.
    Remove rm /var/lib/mysql/ib_logfile*.
    опасно данное удаление чем-либо?
    Написано
  • Почему не запускается сервер MySQL?

    @Hakas_Lepehen Автор вопроса
    Sand, есть такой файл, но это все имеющиеся параметры которые что то говорят об innodb. Или Вам лучше все настройки сообщить?
    # InnoDB parameters
    innodb_file_per_table
    innodb_buffer_pool_size = 32M
    innodb_flush_log_at_trx_commit = 2
    innodb_log_file_size = 64M
    innodb_flush_method = O_DIRECT
    innodb_strict_mode = OFF
    Или можно добавлять недостающие настройки?
    Написано
  • Почему не запускается сервер MySQL?

    @Hakas_Lepehen Автор вопроса
    Sand, нашел это: https://dba.stackexchange.com/questions/163445/inn...
    но не могу найти файл конфигурации. Нашел только файл ~/.my.cnf но при его просмотре увидел только
    # Ansible managed
    [client]
    user=root
    password='Тут пароль'
    socket=/var/lib/mysqld/mysqld.sock
    Написано
  • Почему не запускается сервер MySQL?

    @Hakas_Lepehen Автор вопроса
    Sand, 2020-12-25T05:19:33.916919Z 0 [Note] Binlog end
    2020-12-25T05:19:33.917733Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

    2020-12-25T05:19:34.875669Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 24642)
    2020-12-25T05:19:34.875998Z 0 [Warning] Changed limits: table_open_cache: 2467 (requested 12288)
    2020-12-25T05:19:35.032930Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
    2020-12-25T05:19:35.033957Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.29-32) starting as process 22039 ...
    2020-12-25T05:19:35.039554Z 0 [Note] InnoDB: PUNCH HOLE support available
    2020-12-25T05:19:35.039598Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    2020-12-25T05:19:35.039602Z 0 [Note] InnoDB: Uses event mutexes
    2020-12-25T05:19:35.039605Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
    2020-12-25T05:19:35.039608Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
    2020-12-25T05:19:35.039611Z 0 [Note] InnoDB: Using Linux native AIO
    2020-12-25T05:19:35.039798Z 0 [Note] InnoDB: Number of pools: 1
    2020-12-25T05:19:35.039883Z 0 [Note] InnoDB: Using CPU crc32 instructions
    2020-12-25T05:19:35.041640Z 0 [Note] InnoDB: Initializing buffer pool, total size = 3G, instances = 8, chunk size = 128M
    2020-12-25T05:19:35.097806Z 0 [Note] InnoDB: Completed initialization of buffer pool
    2020-12-25T05:19:35.111665Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
    2020-12-25T05:19:35.131587Z 0 [Note] InnoDB: Recovering partial pages from the parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite
    2020-12-25T05:19:35.169615Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
    2020-12-25T05:19:35.178493Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 389077222946
    2020-12-25T05:19:35.178533Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 389077230270
    2020-12-25T05:19:35.178672Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 389077222946 and the end 389077230270.
    2020-12-25T05:19:35.178864Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
    2020-12-25T05:19:40.304649Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
    2020-12-25T05:19:40.304702Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
    2020-12-25T05:19:40.304713Z 0 [ERROR] Failed to initialize builtin plugins.
    2020-12-25T05:19:40.304723Z 0 [ERROR] Aborting

    2020-12-25T05:19:40.304775Z 0 [Note] Binlog end
    2020-12-25T05:19:40.305459Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

    2020-12-25T05:19:41.362784Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 24642)
    2020-12-25T05:19:41.363125Z 0 [Warning] Changed limits: table_open_cache: 2467 (requested 12288)
    2020-12-25T05:19:41.517045Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
    2020-12-25T05:19:41.518182Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.29-32) starting as process 22104 ...
    2020-12-25T05:19:41.524651Z 0 [Note] InnoDB: PUNCH HOLE support available
    2020-12-25T05:19:41.524696Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    2020-12-25T05:19:41.524700Z 0 [Note] InnoDB: Uses event mutexes
    2020-12-25T05:19:41.524704Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
    2020-12-25T05:19:41.524708Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
    2020-12-25T05:19:41.524711Z 0 [Note] InnoDB: Using Linux native AIO
    2020-12-25T05:19:41.524887Z 0 [Note] InnoDB: Number of pools: 1
    2020-12-25T05:19:41.524995Z 0 [Note] InnoDB: Using CPU crc32 instructions
    2020-12-25T05:19:41.526750Z 0 [Note] InnoDB: Initializing buffer pool, total size = 3G, instances = 8, chunk size = 128M
    2020-12-25T05:19:41.596871Z 0 [Note] InnoDB: Completed initialization of buffer pool
    2020-12-25T05:19:41.613012Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
    2020-12-25T05:19:41.641097Z 0 [Note] InnoDB: Recovering partial pages from the parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite
    2020-12-25T05:19:41.680034Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
    2020-12-25T05:19:41.689377Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 389077222946
    2020-12-25T05:19:41.689428Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 389077230270
    2020-12-25T05:19:41.689582Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 389077222946 and the end 389077230270.
    2020-12-25T05:19:41.689791Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
    Написано