The OpenNET Project / Index page

[ новости /+++ | форум | теги | ]

форумы  помощь  поиск  регистрация  майллист  вход/выход  слежка  RSS
"Автотарт mysql в openvz"
Вариант для распечатки  
Пред. тема | След. тема 
Форум Открытые системы на сервере (Linux привязка)
Изначальное сообщение [ Отслеживать ]

"Автотарт mysql в openvz"  +/
Сообщение от obl (ok) on 31-Янв-13, 21:04 
Друзья, помогите разобраться в чем дело:

Имеем: сервер CentOS (release 5.9 (Final)) на нем крутятся openvz контейнеры. В одном из них при старте не запускается мускуль. В контенере работает убунта:
root@zabbix:~# lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description:    Ubuntu 12.04.1 LTS
Release:        12.04
Codename:       precise


Мускуль вылетает со следующей ошибкой:
Jan 31 20:47:32 zabbix mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Jan 31 20:47:32 zabbix mysqld: 130131 20:47:32 [Note] Plugin 'FEDERATED' is disabled.
Jan 31 20:47:32 zabbix mysqld: 130131 20:47:32 InnoDB: The InnoDB memory heap is disabled
Jan 31 20:47:32 zabbix mysqld: 130131 20:47:32 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Jan 31 20:47:32 zabbix mysqld: 130131 20:47:32 InnoDB: Compressed tables use zlib 1.2.3.4
Jan 31 20:47:32 zabbix mysqld: 16:47:32 UTC - mysqld got signal 11 ;
Jan 31 20:47:32 zabbix mysqld: This could be because you hit a bug. It is also possible that this binary
Jan 31 20:47:32 zabbix mysqld: or one of the libraries it was linked against is corrupt, improperly built,
Jan 31 20:47:32 zabbix mysqld: or misconfigured. This error can also be caused by malfunctioning hardware.
Jan 31 20:47:32 zabbix mysqld: We will try our best to scrape up some info that will hopefully help
Jan 31 20:47:32 zabbix mysqld: diagnose the problem, but since we have already crashed,
Jan 31 20:47:32 zabbix mysqld: something is definitely wrong and this may fail.
Jan 31 20:47:32 zabbix mysqld:
Jan 31 20:47:32 zabbix mysqld: key_buffer_size=16777216
Jan 31 20:47:32 zabbix mysqld: read_buffer_size=131072
Jan 31 20:47:32 zabbix mysqld: max_used_connections=0
Jan 31 20:47:32 zabbix mysqld: max_threads=151
Jan 31 20:47:32 zabbix mysqld: thread_count=0
Jan 31 20:47:32 zabbix mysqld: connection_count=0
Jan 31 20:47:32 zabbix mysqld: It is possible that mysqld could use up to
Jan 31 20:47:32 zabbix mysqld: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 346681 K  bytes of memory
Jan 31 20:47:32 zabbix mysqld: Hope that's ok; if not, decrease some variables in the equation.
Jan 31 20:47:32 zabbix mysqld:
Jan 31 20:47:32 zabbix mysqld: Thread pointer: 0x0
Jan 31 20:47:32 zabbix mysqld: Attempting backtrace. You can use the following information to find out
Jan 31 20:47:32 zabbix mysqld: where mysqld died. If you see no messages after this, something went
Jan 31 20:47:32 zabbix mysqld: terribly wrong...
Jan 31 20:47:32 zabbix mysqld: stack_bottom = 0 thread_stack 0x30000
Jan 31 20:47:32 zabbix mysqld: /usr/sbin/mysqld(my_print_stacktrace+0x29)[0x7f22d6cca039]
Jan 31 20:47:32 zabbix mysqld: /usr/sbin/mysqld(handle_fatal_signal+0x483)[0x7f22d6b909c3]
Jan 31 20:47:32 zabbix mysqld: /lib/x86_64-linux-gnu/libpthread.so.0(+0xfcb0)[0x7f22d58e1cb0]
Jan 31 20:47:32 zabbix mysqld: /usr/sbin/mysqld(+0x687e58)[0x7f22d6e00e58]
Jan 31 20:47:32 zabbix mysqld: /usr/sbin/mysqld(+0x5da8e6)[0x7f22d6d538e6]
Jan 31 20:47:32 zabbix mysqld: /usr/sbin/mysqld(+0x5db54c)[0x7f22d6d5454c]
Jan 31 20:47:32 zabbix mysqld: /usr/sbin/mysqld(+0x5df9a5)[0x7f22d6d589a5]
Jan 31 20:47:32 zabbix mysqld: /usr/sbin/mysqld(+0x5aadb9)[0x7f22d6d23db9]
Jan 31 20:47:32 zabbix mysqld: /usr/sbin/mysqld(_Z24ha_initialize_handlertonP13st_plugin_int+0x41)[0x7f22d6b93091]
Jan 31 20:47:32 zabbix mysqld: /usr/sbin/mysqld(+0x3081d1)[0x7f22d6a811d1]
Jan 31 20:47:32 zabbix mysqld: /usr/sbin/mysqld(_Z11plugin_initPiPPci+0xa94)[0x7f22d6a847f4]
Jan 31 20:47:32 zabbix mysqld: /usr/sbin/mysqld(+0x281b76)[0x7f22d69fab76]
Jan 31 20:47:32 zabbix mysqld: /usr/sbin/mysqld(_Z11mysqld_mainiPPc+0x59b)[0x7f22d69fe26b]
Jan 31 20:47:32 zabbix mysqld: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xed)[0x7f22d4f3876d]
Jan 31 20:47:32 zabbix mysqld: /usr/sbin/mysqld(+0x27b9b5)[0x7f22d69f49b5]
Jan 31 20:47:32 zabbix mysqld: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
Jan 31 20:47:32 zabbix mysqld: information that should help you find out what is causing the crash.
Jan 31 20:47:32 zabbix mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended


При том что странно, если на центосе выполнить.
vzctl set 202 --ram 1G --save

То руками мускуль запускается отлично.
Вот конфиг контейнера:
KMEMSIZE="14372700:14790164"
LOCKEDPAGES="2048:2048"
PRIVVMPAGES="65536:69632"
SHMPAGES="21504:21504"
NUMPROC="1000"
PHYSPAGES="0:262144"
VMGUARPAGES="33792:unlimited"
OOMGUARPAGES="26112:unlimited"
NUMTCPSOCK="360:360"
NUMFLOCK="188:206"
NUMPTY="16:16"
NUMSIGINFO="256:256"
TCPSNDBUF="1720320:2703360"
TCPRCVBUF="1720320:2703360"
OTHERSOCKBUF="1126080:2097152"
DGRAMRCVBUF="262144:262144"
NUMOTHERSOCK="360:360"
DCACHESIZE="3409920:3624960"
NUMFILE="9312:9312"
AVNUMPROC="180:180"
NUMIPTENT="128:128"


# Disk quota parameters (in form of softlimit:hardlimit)
DISKSPACE="10485760:10485760"
DISKINODES="200000:220000"
QUOTATIME="0"

# CPU fair scheduler parameter
CPUUNITS="2000"
VE_ROOT="/vz/root/$VEID"
VE_PRIVATE="/vz/private/$VEID"
OSTEMPLATE="ubuntu-12.04-x86_64"
ORIGIN_SAMPLE="basic"
IP_ADDRESS="13x.11x.20x.202/26 10.0.0.202/26"
NAMESERVER="8.8.8.8"
HOSTNAME="zabbix"
ONBOOT="yes"
SWAPPAGES="1000"
CPUS="4"
NETIF=""

Ответить | Правка | Cообщить модератору

Оглавление

Сообщения по теме [Сортировка по времени | RSS]


1. "Автотарт mysql в openvz"  +/
Сообщение от stalker37 on 01-Фев-13, 01:11 
Посмотрите что в /proc/user_beancounters
Ответить | Правка | ^ к родителю #0 | Наверх | Cообщить модератору

2. "Автотарт mysql в openvz"  +/
Сообщение от obl (ok) on 01-Фев-13, 12:57 
> Посмотрите что в /proc/user_beancounters

до перезагрузки контейнера:
      202:  kmemsize                 26134489             28352512  9223372036854775807  9223372036854775807                    0
            lockedpages                     0                    0  9223372036854775807  9223372036854775807                    0
            privvmpages                260028               273097  9223372036854775807  9223372036854775807                   13
            shmpages                     9638                10278  9223372036854775807  9223372036854775807                    0
            dummy                           0                    0                    0                    0                    0
            numproc                       107                  135  9223372036854775807  9223372036854775807                    0
            physpages                   76747                79725                    0               262144                    0
            vmguarpages                     0                    0  9223372036854775807  9223372036854775807                    0
            oomguarpages                53347                53347  9223372036854775807  9223372036854775807                    0
            numtcpsock                     16                   34  9223372036854775807  9223372036854775807                    0
            numflock                        9                   10  9223372036854775807  9223372036854775807                    0
            numpty                          0                    1  9223372036854775807  9223372036854775807                    0
            numsiginfo                      0                   69  9223372036854775807  9223372036854775807                    0
            tcpsndbuf                  261600               610664  9223372036854775807  9223372036854775807                    0
            tcprcvbuf                  262144               544272  9223372036854775807  9223372036854775807                    0
            othersockbuf                77720               103344  9223372036854775807  9223372036854775807                    0
            dgramrcvbuf                     0                 4360  9223372036854775807  9223372036854775807                    0
            numothersock                  104                  111  9223372036854775807  9223372036854775807                    0
            dcachesize                5638015              5721107  9223372036854775807  9223372036854775807                    0
            numfile                       670                  850  9223372036854775807  9223372036854775807                    0
            dummy                           0                    0                    0                    0                    0
            dummy                           0                    0                    0                    0                    0
            dummy                           0                    0                    0                    0                    0
            numiptent                      20                   20  9223372036854775807  9223372036854775807                    0


после перезагрузки:
      202:  kmemsize                 11607527             12509184             14372700             14790164                    0
            lockedpages                     0                    0                 2048                 2048                    0
            privvmpages                 59369                67417                65536                69632                    3
            shmpages                     1047                 1063                21504                21504                    0
            dummy                           0                    0                    0                    0                    0
            numproc                        37                   69                 1000                 1000                    0
            physpages                   29347                31828                    0               262144                    0
            vmguarpages                     0                    0                33792  9223372036854775807                    0
            oomguarpages                19685                19685                26112  9223372036854775807                    0
            numtcpsock                     15                   17                  360                  360                    0
            numflock                        6                    7                  188                  206                    0
            numpty                          1                    1                   16                   16                    0
            numsiginfo                      0                   21                  256                  256                    0
            tcpsndbuf                  213904               224936              1720320              2703360                    0
            tcprcvbuf                  214280               218640              1720320              2703360                    0
            othersockbuf                43928               116024              1126080              2097152                    0
            dgramrcvbuf                     0                 4360               262144               262144                    0
            numothersock                   54                   67                  360                  360                    0
            dcachesize                2931115              3001271              3409920              3624960                    0
            numfile                       558                  610                 9312                 9312                    0
            dummy                           0                    0                    0                    0                    0
            dummy                           0                    0                    0                    0                    0
            dummy                           0                    0                    0                    0                    0
            numiptent                      20                   20                  128                  128                    0

после vzctl set 202 --ram 1G --save
      202:  kmemsize                 11609917             12509184  9223372036854775807  9223372036854775807                    0
            lockedpages                     0                    0  9223372036854775807  9223372036854775807                    0
            privvmpages                 59561                67417  9223372036854775807  9223372036854775807                    3
            shmpages                     1047                 1063  9223372036854775807  9223372036854775807                    0
            dummy                           0                    0                    0                    0                    0
            numproc                        37                   69  9223372036854775807  9223372036854775807                    0
            physpages                   29623                32080                    0               262144                    0
            vmguarpages                     0                    0  9223372036854775807  9223372036854775807                    0
            oomguarpages                19957                19957  9223372036854775807  9223372036854775807                    0
            numtcpsock                     16                   17  9223372036854775807  9223372036854775807                    0
            numflock                        6                    7  9223372036854775807  9223372036854775807                    0
            numpty                          1                    1  9223372036854775807  9223372036854775807                    0
            numsiginfo                      0                   21  9223372036854775807  9223372036854775807                    0
            tcpsndbuf                  220576               238016  9223372036854775807  9223372036854775807                    0
            tcprcvbuf                  218640               235024  9223372036854775807  9223372036854775807                    0
            othersockbuf                43928               116024  9223372036854775807  9223372036854775807                    0
            dgramrcvbuf                     0                 4360  9223372036854775807  9223372036854775807                    0
            numothersock                   54                   67  9223372036854775807  9223372036854775807                    0
            dcachesize                2931115              3001271  9223372036854775807  9223372036854775807                    0
            numfile                       558                  610  9223372036854775807  9223372036854775807                    0
            dummy                           0                    0                    0                    0                    0
            dummy                           0                    0                    0                    0                    0
            dummy                           0                    0                    0                    0                    0
            numiptent                      20                   20  9223372036854775807  9223372036854775807                    0

о_0

Ответить | Правка | ^ к родителю #1 | Наверх | Cообщить модератору

3. "Автотарт mysql в openvz"  +/
Сообщение от obl (ok) on 01-Фев-13, 18:23 
Прописал ручками :
KMEMSIZE="1G:1G"
PRIVVMPAGES="1G:1G"
И все как по маслу. Видимо глюк vzctl.

Спасибо!

Ответить | Правка | ^ к родителю #2 | Наверх | Cообщить модератору

Архив | Удалить

Рекомендовать для помещения в FAQ | Индекс форумов | Темы | Пред. тема | След. тема




Партнёры:
PostgresPro
Inferno Solutions
Hosting by Hoster.ru
Хостинг:

Закладки на сайте
Проследить за страницей
Created 1996-2025 by Maxim Chirkov
Добавить, Поддержать, Вебмастеру