Задать вопрос
qqwweerr

Габит Шынарбай

Типа программист
Комментарии

  • Выходит ошибка в кнопке применить изменения, как решить вопрос?

    qqwweerr
    @qqwweerr Автор вопроса
    Andrey Barbolin, Ааххахах.
    Написано

  • Выходит ошибка в кнопке применить изменения, как решить вопрос?

    qqwweerr
    @qqwweerr Автор вопроса
    Andrey Barbolin,
    [root@freepbx ~]# less /var/log/mariadb/mariadb.log
    InnoDB: Cannot continue operation.
    211019 06:59:17 mysqld_safe Number of processes running now: 0
    211019 06:59:17 mysqld_safe mysqld restarted
    211019 6:59:17 [Note] /usr/libexec/mysqld (mysqld 5.5.65-MariaDB) starting as process 21520 ...
    211019 6:59:17 InnoDB: The InnoDB memory heap is disabled
    211019 6:59:17 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    211019 6:59:17 InnoDB: Compressed tables use zlib 1.2.7
    211019 6:59:17 InnoDB: Using Linux native AIO
    211019 6:59:17 InnoDB: Initializing buffer pool, size = 128.0M
    211019 6:59:17 InnoDB: Completed initialization of buffer pool
    211019 6:59:17 InnoDB: highest supported file format is Barracuda.
    211019 6:59:17 InnoDB: Starting crash recovery from checkpoint LSN=10771858347
    InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
    211019 6:59:17 InnoDB: Starting final batch to recover 2 pages from redo log
    211019 6:59:18 InnoDB: Waiting for the background threads to start
    211019 6:59:19 Percona XtraDB (www.percona.com) 5.5.61-MariaDB-38.13 started; log sequence number 10771859043
    211019 6:59:19 [Note] Plugin 'FEEDBACK' is disabled.
    211019 6:59:19 [Note] Server socket created on IP: '0.0.0.0'.
    211019 6:59:19 [Note] Event Scheduler: Loaded 0 events
    211019 6:59:19 [Note] /usr/libexec/mysqld: ready for connections.
    Version: '5.5.65-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
    211019 7:09:28 [Note] /usr/libexec/mysqld: Normal shutdown
    211019 7:09:28 [Note] Event Scheduler: Purging the queue. 0 events
    211019 7:09:28 InnoDB: Starting shutdown...
    211019 7:09:30 InnoDB: Shutdown completed; log sequence number 10772182049
    211019 7:09:30 [Note] /usr/libexec/mysqld: Shutdown complete

    211019 07:09:30 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
    211019 07:11:29 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    211019 7:11:29 [Note] /usr/libexec/mysqld (mysqld 5.5.65-MariaDB) starting as process 1518 ...
    211019 7:11:29 InnoDB: The InnoDB memory heap is disabled
    211019 7:11:29 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    211019 7:11:29 InnoDB: Compressed tables use zlib 1.2.7
    211019 7:11:29 InnoDB: Using Linux native AIO
    211019 7:11:29 InnoDB: Initializing buffer pool, size = 128.0M
    211019 7:11:29 InnoDB: Completed initialization of buffer pool
    211019 7:11:30 InnoDB: highest supported file format is Barracuda.
    211019 7:11:34 InnoDB: Waiting for the background threads to start
    211019 7:11:35 Percona XtraDB (www.percona.com) 5.5.61-MariaDB-38.13 started; log sequence number 10772182049
    211019 7:11:35 [Note] Plugin 'FEEDBACK' is disabled.
    211019 7:11:35 [Note] Server socket created on IP: '0.0.0.0'.
    211019 7:11:36 [Note] Event Scheduler: Loaded 0 events
    211019 7:11:36 [Note] /usr/libexec/mysqld: ready for connections.
    Version: '5.5.65-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
    Написано

  • Выходит ошибка в кнопке применить изменения, как решить вопрос?

    qqwweerr
    @qqwweerr Автор вопроса
    Andrey Barbolin,
    [root@freepbx ~]# less /var/log/mariadb/mariadb.log
    210211 11:33:28 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    210211 11:33:28 [Note] /usr/libexec/mysqld (mysqld 5.5.65-MariaDB) starting as process 8771 ...
    210211 11:33:28 InnoDB: The InnoDB memory heap is disabled
    210211 11:33:28 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    210211 11:33:28 InnoDB: Compressed tables use zlib 1.2.7
    210211 11:33:28 InnoDB: Using Linux native AIO
    210211 11:33:28 InnoDB: Initializing buffer pool, size = 128.0M
    210211 11:33:28 InnoDB: Completed initialization of buffer pool
    InnoDB: The first specified data file ./ibdata1 did not exist:
    InnoDB: a new database to be created!
    210211 11:33:28 InnoDB: Setting file ./ibdata1 size to 10 MB
    InnoDB: Database physically writes the file full: wait...
    210211 11:33:28 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
    InnoDB: Setting log file ./ib_logfile0 size to 5 MB
    InnoDB: Database physically writes the file full: wait...
    210211 11:33:28 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
    InnoDB: Setting log file ./ib_logfile1 size to 5 MB
    InnoDB: Database physically writes the file full: wait...
    InnoDB: Doublewrite buffer not found: creating new
    InnoDB: Doublewrite buffer created
    InnoDB: 127 rollback segment(s) active.
    InnoDB: Creating foreign key constraint system tables
    InnoDB: Foreign key constraint system tables created
    210211 11:33:28 InnoDB: Waiting for the background threads to start
    210211 11:33:29 Percona XtraDB (www.percona.com) 5.5.61-MariaDB-38.13 started; log sequence number 0
    210211 11:33:29 [Note] Plugin 'FEEDBACK' is disabled.
    210211 11:33:29 [Note] Server socket created on IP: '0.0.0.0'.
    210211 11:33:29 [Note] Event Scheduler: Loaded 0 events
    210211 11:33:29 [Note] /usr/libexec/mysqld: ready for connections.
    Version: '5.5.65-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
    210211 11:34:02 [Note] /usr/libexec/mysqld: Normal shutdown
    210211 11:34:02 [Note] Event Scheduler: Purging the queue. 0 events
    210211 11:34:02 InnoDB: Starting shutdown...
    210211 11:34:04 InnoDB: Shutdown completed; log sequence number 14516021
    210211 11:34:04 [Note] /usr/libexec/mysqld: Shutdown complete

    210211 11:34:04 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
    210211 11:46:44 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    210211 11:46:47 [Note] /usr/libexec/mysqld (mysqld 5.5.65-MariaDB) starting as process 1465 ...
    210211 11:46:47 InnoDB: The InnoDB memory heap is disabled
    210211 11:46:47 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    210211 11:46:47 InnoDB: Compressed tables use zlib 1.2.7
    210211 11:46:47 InnoDB: Using Linux native AIO
    210211 11:46:48 InnoDB: Initializing buffer pool, size = 128.0M
    210211 11:46:48 InnoDB: Completed initialization of buffer pool
    210211 11:46:48 InnoDB: highest supported file format is Barracuda.
    210211 11:46:50 InnoDB: Waiting for the background threads to start
    210211 11:46:51 Percona XtraDB (www.percona.com) 5.5.61-MariaDB-38.13 started; log sequence number 14516021
    210211 11:46:52 [Note] Plugin 'FEEDBACK' is disabled
    Написано

  • Выходит ошибка в кнопке применить изменения, как решить вопрос?

    qqwweerr
    @qqwweerr Автор вопроса
    Andrey Barbolin,
    ps aux | grep sql
    mysql 1299 0.1 1.2 1168248 98768 ? Sl 04:35 0:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mariadb/mariadb.log --pid-file=/var/run/mariadb/mariadb.pid --socket=/var/lib/mysql/mysql.sock
    mysql 1329 0.0 0.0 113412 1592 ? Ss Oct18 0:00 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
    root 1877 0.0 0.0 112808 964 pts/0 S+ 04:40 0:00 grep --color=auto sql

    netstat -anlp | grep 3306
    tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 1299/mysqld
    tcp 0 0 127.0.0.1:55442 127.0.0.1:3306 ESTABLISHED 1492/node /var/www/
    tcp 0 0 127.0.0.1:3306 127.0.0.1:55442 ESTABLISHED 1299/mysqld

    [root@freepbx ~]# mysqlcheck --repair --all-databases
    asterisk.admin
    note : The storage engine for the table doesn't support repair
    asterisk.adv_recovery_backuprestore_log
    note : The storage engine for the table doesn't support repair
    asterisk.adv_recovery_heartbeat_log
    note : The storage engine for the table doesn't support repair
    asterisk.adv_recovery_notifications_log
    note : The storage engine for the table doesn't support repair
    asterisk.adv_recovery_primary_server_settings
    note : The storage engine for the table doesn't support repair
    asterisk.adv_recovery_serviceswitch_log
    note : The storage engine for the table doesn't support repair
    asterisk.ampusers
    note : The storage engine for the table doesn't support repair
    asterisk.announcement
    note : The storage engine for the table doesn't support repair
    asterisk.api_access_tokens
    note : The storage engine for the table doesn't support repair
    asterisk.api_applications
    note : The storage engine for the table doesn't support repair
    asterisk.api_asynchronous_transaction_history
    note : The storage engine for the table doesn't support repair
    asterisk.api_auth_codes
    note : The storage engine for the table doesn't support repair
    mysqlcheck: Got error: 2013: Lost connection to MySQL server during query when executing 'REPAIR TABLE ... '
    Написано

  • Выходит ошибка в кнопке применить изменения, как решить вопрос?

    qqwweerr
    @qqwweerr Автор вопроса
    Andrey Barbolin,
    Filesystem Size Used Avail Use% Mounted on
    devtmpfs 3.8G 0 3.8G 0% /dev
    tmpfs 3.8G 0 3.8G 0% /dev/shm
    tmpfs 3.8G 17M 3.8G 1% /run
    tmpfs 3.8G 0 3.8G 0% /sys/fs/cgroup
    /dev/sdb3 50G 29G 22G 58% /
    /dev/sdc1 932G 692M 931G 1% /home
    /dev/sdb1 1014M 85M 930M 9% /boot
    tmpfs 770M 0 770M 0% /run/user/0
    Написано

  • Выходит ошибка в кнопке применить изменения, как решить вопрос?

    qqwweerr
    @qqwweerr Автор вопроса
    Drno, вот что говорит
    An exception occurred while executing 'SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_ru
    le */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.constraint_name = k.constraint_name AND c.table_name = 'api_r
    efresh_tokens' */ WHERE k.table_name = 'api_refresh_tokens' AND k.table_schema = 'asterisk' /*!50116 AND c.constraint_schema = 'asterisk' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL'
    :

    SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query

    In Database.class.php line 247:

    SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query
    Написано

  • АТС выдаёт ошибку, DRDY ERR что это?

    qqwweerr
    @qqwweerr Автор вопроса
    Дмитрий, диск умирает ? Или возможно просто поменять sata кабель ?
    Написано

  • АТС выдаёт ошибку, DRDY ERR что это?

    qqwweerr
    @qqwweerr Автор вопроса
    DRDY ERR
    ICRC ABRT
    Вы про эту ошибку ?
    Написано

  • Как поставить оповещение на старые задачи в Redmine?

    qqwweerr
    @qqwweerr Автор вопроса
    Владимир Питин: А вообще у нас есть такие плагины ?
    Написано

  • Как поставить оповещение на старые задачи в Redmine?

    qqwweerr
    @qqwweerr Автор вопроса
    Владимир Питин: А как можно это сделать ?
    Написано