среда, 21 декабря 2011 г.

Ошибка при обновлении модулей Drupal

Блок кода0
Их было слишком много...
Выводы, резюме
Поначалу я несказано увеличил в /etc/php.ini
memory_limit = 1024M ; Maximum amount of memory a script may consume (16MB)
вместо 16М первоначально установленных. До этого Drupal вообще не работал (см. предыдущий пост про белый лист).
Конечно, 1Г под работу скриптов - это слишком (Рекомендовано для Trottle), так что надо будет уменьшить..., буду выбирать тарифный план для хостинга - займусь.
user warning: Got a packet bigger than 'max_allowed_packet' bytes query: UPDATE cache_update SET data ='**********', created = 1324411664, expire = 1324415264, serialized = 1 WHERE cid = 'update_project_data' in /var/www/html/op622/modules/update/update.module on line 553.
Чтобы устранить предупреждение в /etc/my.cnf добавил строчки
# this string Altersego insert from http://groups.drupal.org/node/13844
set-variable = max_allowed_packet=64M
Основной текст поста2
feedURL

20 комментариев:

  1. Конфигурационный файл /etc/my.cnf
    [mysqld]
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    user=mysql
    # Default to using old password format for compatibility with mysql 3.x
    # clients (those using the mysqlclient10 compatibility package).
    old_passwords=1

    # Disabling symbolic-links is recommended to prevent assorted security risks;
    # to do so, uncomment this line:
    # symbolic-links=0

    [mysqld_safe]
    log-error=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid

    ОтветитьУдалить
  2. # cd /var/lib/mysql
    [root@localhost mysql]# ls
    ibdata1 ib_logfile1 mysql openpub_6 openpub_7 test
    ib_logfile0 localhost.pid mysql.sock openpub_6_last tattler_1
    [root@localhost mysql]# ls /mysql
    ls: /mysql: No such file or directory
    [root@localhost mysql]# ls mysql
    columns_priv.frm help_relation.MYI time_zone_leap_second.frm
    columns_priv.MYD help_topic.frm time_zone_leap_second.MYD
    columns_priv.MYI help_topic.MYD time_zone_leap_second.MYI
    db.frm help_topic.MYI time_zone.MYD
    db.MYD host.frm time_zone.MYI
    db.MYI host.MYD time_zone_name.frm
    func.frm host.MYI time_zone_name.MYD
    func.MYD proc.frm time_zone_name.MYI
    func.MYI proc.MYD time_zone_transition.frm
    help_category.frm proc.MYI time_zone_transition.MYD
    help_category.MYD procs_priv.frm time_zone_transition.MYI
    help_category.MYI procs_priv.MYD time_zone_transition_type.frm
    help_keyword.frm procs_priv.MYI time_zone_transition_type.MYD
    help_keyword.MYD tables_priv.frm time_zone_transition_type.MYI
    help_keyword.MYI tables_priv.MYD user.frm
    help_relation.frm tables_priv.MYI user.MYD
    help_relation.MYD time_zone.frm user.MYI

    ОтветитьУдалить
  3. # ls openpub_6
    access.frm flags.MYD
    accesslog.frm flags.MYI
    accesslog.MYD flag_types.frm
    accesslog.MYI flag_types.MYD
    access.MYD flag_types.MYI
    access.MYI flood.frm
    actions_aid.frm flood.MYD
    actions_aid.MYD flood.MYI
    actions_aid.MYI history.frm
    actions.frm history.MYD
    actions.MYD history.MYI
    actions.MYI

    ОтветитьУдалить
  4. Как видно из предыдущего комментария (там только часть таблиц из базы openpub_6), каждая таблица хранится в трех файлах:
    .frm - файл содержит структуру таблицы, где хранится информация об именах и типах столбцов и индексов.
    .myd - файл данных таблицы (MYDATA)
    .myi - файл с индексами таблиц (MYIndex ...часто создается автоматически)

    ОтветитьУдалить
  5. # mysql -uroot -p1
    Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 8
    Server version: 5.0.77 Source distribution
    mysql> help;

    For information about MySQL products and services, visit:
    http://www.mysql.com/
    For developer information, including the MySQL Reference Manual, visit:
    http://dev.mysql.com/
    To buy MySQL Network Support, training, or other products, visit:
    https://shop.mysql.com/

    List of all MySQL commands:
    Note that all text commands must be first on line and end with ';'
    ? (\?) Synonym for `help'.
    clear (\c) Clear command.
    connect (\r) Reconnect to the server. Optional arguments are db and host.
    delimiter (\d) Set statement delimiter. NOTE: Takes the rest of the line as new delimiter.
    edit (\e) Edit command with $EDITOR.
    ego (\G) Send command to mysql server, display result vertically.
    exit (\q) Exit mysql. Same as quit.
    go (\g) Send command to mysql server.
    help (\h) Display this help.
    nopager (\n) Disable pager, print to stdout.
    notee (\t) Don't write into outfile.
    pager (\P) Set PAGER [to_pager]. Print the query results via PAGER.
    print (\p) Print current command.
    prompt (\R) Change your mysql prompt.
    quit (\q) Quit mysql.
    rehash (\#) Rebuild completion hash.
    source (\.) Execute an SQL script file. Takes a file name as an argument.
    status (\s) Get status information from the server.
    system (\!) Execute a system shell command.
    tee (\T) Set outfile [to_outfile]. Append everything into given outfile.
    use (\u) Use another database. Takes database name as argument.
    charset (\C) Switch to another charset. Might be needed for processing binlog with multi-byte charsets.
    warnings (\W) Show warnings after every statement.
    nowarning (\w) Don't show warnings after every statement.

    For server side help, type 'help contents'

    ОтветитьУдалить
  6. show variables;
    +---------------------------------+-----------------------------------------------------
    -------+
    | Variable_name | Value
    |
    +---------------------------------+-----------------------------------------------------
    -------+
    | auto_increment_increment | 1
    |
    | auto_increment_offset | 1
    |
    | automatic_sp_privileges | ON
    |
    | back_log | 50
    |
    | basedir | /usr/
    |
    | bdb_cache_size | 8384512
    |
    | bdb_home | /var/lib/mysql/
    |
    | bdb_log_buffer_size | 262144
    |
    | bdb_logdir |
    |
    | bdb_max_lock | 10000
    |
    | bdb_shared_data | OFF
    |
    | bdb_tmpdir | /tmp/
    |
    | binlog_cache_size | 32768
    |
    | bulk_insert_buffer_size | 8388608
    |
    | character_set_client | latin1
    |
    | character_set_connection | latin1
    |
    | character_set_database | latin1
    |
    | character_set_filesystem | binary
    |
    | character_set_results | latin1
    |
    | character_set_server | latin1
    |
    | character_set_system | utf8
    |
    | character_sets_dir | /usr/share/mysql/charsets/
    |
    | collation_connection | latin1_swedish_ci
    |
    | collation_database | latin1_swedish_ci
    |
    | collation_server | latin1_swedish_ci

    ОтветитьУдалить
  7. | completion_type | 0
    |
    | concurrent_insert | 1
    |
    | connect_timeout | 10
    |
    | datadir | /var/lib/mysql/
    |
    | date_format | %Y-%m-%d
    |
    | datetime_format | %Y-%m-%d %H:%i:%s
    |
    | default_week_format | 0
    |
    | delay_key_write | ON
    |
    | delayed_insert_limit | 100
    |
    | delayed_insert_timeout | 300
    |
    | delayed_queue_size | 1000
    |
    | div_precision_increment | 4
    |
    | keep_files_on_create | OFF
    |
    | engine_condition_pushdown | OFF
    |
    | expire_logs_days | 0
    |
    | flush | OFF
    |
    | flush_time | 0
    |
    | ft_boolean_syntax | + -><()~*:""&|
    |
    | ft_max_word_len | 84
    |
    | ft_min_word_len | 4
    |
    | ft_query_expansion_limit | 20
    |
    | ft_stopword_file | (built-in)
    |
    | group_concat_max_len | 1024
    |
    | have_archive | NO
    |
    | have_bdb | YES
    |
    | have_blackhole_engine | NO
    |
    | have_compress | YES
    |
    | have_crypt | YES
    |
    | have_csv | NO
    |
    | have_dynamic_loading | YES
    |
    | have_example_engine | NO
    |
    | have_federated_engine | NO
    |
    | have_geometry | YES
    |
    | have_innodb | YES
    |
    | have_isam | NO
    |
    | have_merge_engine | YES
    |
    | have_ndbcluster | NO
    |
    | have_openssl | DISABLED
    |
    | have_ssl | DISABLED
    |
    | have_query_cache | YES
    |
    | have_raid | NO
    |
    | have_rtree_keys | YES
    |
    | have_symlink | YES

    ОтветитьУдалить
  8. | hostname | localhost.localdomain
    |
    | init_connect |
    |
    | init_file |
    |
    | init_slave |
    |
    | innodb_additional_mem_pool_size | 1048576
    |
    | innodb_autoextend_increment | 8
    |
    | innodb_buffer_pool_awe_mem_mb | 0
    |
    | innodb_buffer_pool_size | 8388608
    |
    | innodb_checksums | ON
    |
    | innodb_commit_concurrency | 0
    |
    | innodb_concurrency_tickets | 500
    |
    | innodb_data_file_path | ibdata1:10M:autoextend
    |
    | innodb_data_home_dir |
    |
    | innodb_adaptive_hash_index | ON
    |
    | innodb_doublewrite | ON
    |
    | innodb_fast_shutdown | 1
    |
    | innodb_file_io_threads | 4
    |
    | innodb_file_per_table | OFF
    |
    | innodb_flush_log_at_trx_commit | 1
    |
    | innodb_flush_method |
    |
    | innodb_force_recovery | 0
    |
    | innodb_lock_wait_timeout | 50
    |
    | innodb_locks_unsafe_for_binlog | OFF
    |
    | innodb_log_arch_dir |
    |
    | innodb_log_archive | OFF
    |
    | innodb_log_buffer_size | 1048576
    |
    | innodb_log_file_size | 5242880
    |
    | innodb_log_files_in_group | 2
    |
    | innodb_log_group_home_dir | ./
    |
    | innodb_max_dirty_pages_pct | 90
    |
    | innodb_max_purge_lag | 0
    |
    | innodb_mirrored_log_groups | 1
    |
    | innodb_open_files | 300
    |
    | innodb_rollback_on_timeout | OFF
    |
    | innodb_support_xa | ON
    |
    | innodb_sync_spin_loops | 20
    |
    | innodb_table_locks | ON
    |
    | innodb_thread_concurrency | 8
    |
    | innodb_thread_sleep_delay | 10000
    |
    | interactive_timeout | 28800
    |
    | join_buffer_size | 131072
    |
    | key_buffer_size | 8384512
    |
    | key_cache_age_threshold | 300
    |
    | key_cache_block_size | 1024
    |
    | key_cache_division_limit | 100
    |
    | language | /usr/share/mysql/english/

    ОтветитьУдалить
  9. | large_files_support | ON
    |
    | large_page_size | 0
    |
    | large_pages | OFF
    |
    | lc_time_names | en_US
    |
    | license | GPL
    |
    | local_infile | ON
    |
    | locked_in_memory | OFF
    |
    | log | OFF
    |
    | log_bin | OFF
    |
    | log_bin_trust_function_creators | OFF
    |
    | log_error |
    |
    | log_queries_not_using_indexes | OFF
    |
    | log_slave_updates | OFF
    |
    | log_slow_queries | OFF
    |
    | log_warnings | 1
    |
    | long_query_time | 10
    |
    | low_priority_updates | OFF
    |
    | lower_case_file_system | OFF
    |
    | lower_case_table_names | 0
    |
    | max_allowed_packet | 67108864
    |
    | max_binlog_cache_size | 18446744073709547520
    |
    | max_binlog_size | 1073741824
    |
    | max_connect_errors | 10
    |
    | max_connections | 100
    |
    | max_delayed_threads | 20
    |
    | max_error_count | 64
    |
    | max_heap_table_size | 16777216
    |
    | max_insert_delayed_threads | 20
    |
    | max_join_size | 18446744073709551615
    |
    | max_length_for_sort_data | 1024
    |
    | max_prepared_stmt_count | 16382
    |
    | max_relay_log_size | 0
    |
    | max_seeks_for_key | 18446744073709551615
    |
    | max_sort_length | 1024
    |
    | max_sp_recursion_depth | 0
    |
    | max_tmp_tables | 32
    |
    | max_user_connections | 0
    |
    | max_write_lock_count | 18446744073709551615
    |
    | multi_range_count | 256
    |
    | myisam_data_pointer_size | 6
    |
    | myisam_max_sort_file_size | 9223372036853727232
    |
    | myisam_recover_options | OFF
    |
    | myisam_repair_threads | 1
    |
    | myisam_sort_buffer_size | 8388608
    |
    | myisam_stats_method | nulls_unequal

    ОтветитьУдалить
  10. | net_buffer_length | 16384
    |
    | net_read_timeout | 30
    |
    | net_retry_count | 10
    |
    | net_write_timeout | 60
    |
    | new | OFF
    |
    | old_passwords | ON
    |
    | open_files_limit | 1024
    |
    | optimizer_prune_level | 1
    |
    | optimizer_search_depth | 62
    |
    | pid_file | /var/run/mysqld/mysqld.pid
    |
    | plugin_dir |
    |
    | port | 3306
    |
    | preload_buffer_size | 32768
    |
    | profiling | OFF
    |
    | profiling_history_size | 15
    |
    | protocol_version | 10
    |
    | query_alloc_block_size | 8192
    |
    | query_cache_limit | 1048576
    |
    | query_cache_min_res_unit | 4096
    |
    | query_cache_size | 0
    |
    | query_cache_type | ON
    |
    | query_cache_wlock_invalidate | OFF
    |
    | query_prealloc_size | 8192
    |
    | range_alloc_block_size | 4096
    |
    | read_buffer_size | 131072
    |
    | read_only | OFF
    |
    | read_rnd_buffer_size | 262144
    |
    | relay_log |
    |
    | relay_log_index |
    |
    | relay_log_info_file | relay-log.info
    |
    | relay_log_purge | ON
    |
    | relay_log_space_limit | 0
    |
    | rpl_recovery_rank | 0
    |
    | secure_auth | OFF
    |
    | secure_file_priv |
    |
    | server_id | 0
    |
    | skip_external_locking | ON
    |
    | skip_networking | OFF
    |
    | skip_show_database | OFF
    |
    | slave_compressed_protocol | OFF
    |
    | slave_load_tmpdir | /tmp/
    |
    | slave_net_timeout | 3600
    |
    | slave_skip_errors | OFF
    |
    | slave_transaction_retries | 10
    |
    | slow_launch_time | 2
    |
    | socket | /var/lib/mysql/mysql.sock

    ОтветитьУдалить
  11. | sort_buffer_size | 2097144
    |
    | sql_big_selects | ON
    |
    | sql_mode |
    |
    | sql_notes | ON
    |
    | sql_warnings | OFF
    |
    | ssl_ca |
    |
    | ssl_capath |
    |
    | ssl_cert |
    |
    | ssl_cipher |
    |
    | ssl_key |
    |
    | storage_engine | MyISAM
    |
    | sync_binlog | 0
    |
    | sync_frm | ON
    |
    | system_time_zone | MSK
    |
    | table_cache | 64
    |
    | table_lock_wait_timeout | 50
    |
    | table_type | MyISAM
    |
    | thread_cache_size | 0
    |
    | thread_stack | 262144
    |
    | time_format | %H:%i:%s
    |
    | time_zone | SYSTEM |
    | timed_mutexes | OFF |
    | tmp_table_size | 33554432 |
    | tmpdir | /tmp/ |
    | transaction_alloc_block_size | 8192 |
    | transaction_prealloc_size | 4096 |
    | tx_isolation | REPEATABLE-READ |
    | updatable_views_with_limit | YES |
    | version | 5.0.77 |
    | version_bdb | Sleepycat Software: Berkeley DB 4.1.24: (January 29, 2009) |
    | version_comment | Source distribution |
    | version_compile_machine | x86_64 |
    | version_compile_os | redhat-linux-gnu |
    | wait_timeout | 28800 |
    +---------------------------------+----------------------------------------------------- -------+
    239 rows in set (0.00 sec)

    ОтветитьУдалить
  12. Я уже добавил в /etc/my.cnf строчку
    # this string Altersego insert from http://groups.drupal.org/node/13844
    set-variable = max_allowed_packet=64M
    и теперь проверяю параметры всех переменных, начинающихся с max_
    mysql> show variables like 'max_%'
    -> ;
    +----------------------------+----------------------+
    | Variable_name | Value |
    +----------------------------+----------------------+
    | max_allowed_packet | 67108864 |
    | max_binlog_cache_size | 18446744073709547520 |
    | max_binlog_size | 1073741824 |
    | max_connect_errors | 10 |
    | max_connections | 100 |
    | max_delayed_threads | 20 |
    | max_error_count | 64 |
    | max_heap_table_size | 16777216 |
    | max_insert_delayed_threads | 20 |
    | max_join_size | 18446744073709551615 |
    | max_length_for_sort_data | 1024 |
    | max_prepared_stmt_count | 16382 |
    | max_relay_log_size | 0 |
    | max_seeks_for_key | 18446744073709551615 |
    | max_sort_length | 1024 |
    | max_sp_recursion_depth | 0 |
    | max_tmp_tables | 32 |
    | max_user_connections | 0 |
    | max_write_lock_count | 18446744073709551615 |
    +----------------------------+----------------------+
    19 rows in set (0.00 sec)

    ОтветитьУдалить
  13. Переменная max_allowed_packet определяет предельный размер одного пакета, т.е., единичный SQL-запрос к SQL-серверу не может быть больше 64М.
    Первоначально, буфер сообщений имеет значение net_buffer_length, однако, при необходимости автоматически увеличивается до max_allowed_packet.
    У меня эта переменная составляет по умолчанию (ее нет в файле my.cnf) 16К
    Об этом свидетельствует запись (в комменте наверху) net_buffer_length | 16384

    ОтветитьУдалить
  14. Описание ошибки на сайте для разработчиков
    http://dev.mysql.com/doc/refman/5.1/en/replication-features-max-allowed-packet.html

    ОтветитьУдалить
  15. А вот файл c://xampp/mysql/bin/my.ini
    # Example MySQL config file for medium systems.
    #
    # This is for a system with little memory (32M - 64M) where MySQL plays
    # an important part, or systems up to 128M where MySQL is used together with
    # other programs (such as a web server)
    #
    # You can copy this file to
    # /etc/my.cnf to set global options,
    # mysql-data-dir/my.cnf to set server-specific options (in this
    # installation this directory is @localstatedir@) or
    # ~/.my.cnf to set user-specific options.
    #
    # In this file, you can use all long options that a program supports.
    # If you want to know which options a program supports, run the program
    # with the "--help" option.

    # The following options will be passed to all MySQL clients
    [client]
    #user = your_username
    #password = your_password
    host = .
    port = 3306
    socket = "MySQL"

    # Here follows entries for some specific programs

    # The MySQL server

    ОтветитьУдалить
  16. [mysqld]
    basedir = "C:/xampp/mysql/"
    datadir = "C:/xampp/mysql/data/"
    port = 3306
    socket = "MySQL"
    skip-locking
    key_buffer = 16M
    max_allowed_packet = 1M
    table_cache = 64
    sort_buffer_size = 512K
    net_buffer_length = 8K
    read_buffer_size = 256K
    read_rnd_buffer_size = 512K
    myisam_sort_buffer_size = 8M

    default-time-zone = "Europe/Moscow"

    log_error = "C:/xampp/mysql/data/mysql.err"
    pid_file = "mysql.pid"
    general_log = 0
    general_log_file = "C:/xampp/mysql/data/mysql.log"
    slow_query_log = 0
    slow_query_log_file = "C:/xampp/mysql/data/mysql-slow.log"

    # Don't listen on a TCP/IP port at all. This can be a security enhancement,
    # if all processes that need to connect to mysqld run on the same host.
    # All interaction with mysqld must be made via Unix sockets or named pipes.
    # Note that using this option without enabling named pipes on Windows
    # (via the "enable-named-pipe" option) will render mysqld useless!
    #
    #skip-networking
    enable-named-pipe

    # Disable Federated by default
    skip-federated

    ОтветитьУдалить
  17. # Replication Master Server (default)
    # binary logging is required for replication
    #log-bin = mysql-bin

    # binary logging format - mixed recommended
    #binlog_format = mixed

    # required unique id between 1 and 2^32 - 1
    # defaults to 1 if master-host is not set
    # but will not function as a master if omitted
    server-id = 1

    # Replication Slave (comment out master section to use this)
    #
    # To configure this host as a replication slave, you can choose between
    # two methods :
    #
    # 1) Use the CHANGE MASTER TO command (fully described in our manual) -
    # the syntax is:
    #
    # CHANGE MASTER TO MASTER_HOST=, MASTER_PORT=,
    # MASTER_USER=, MASTER_PASSWORD= ;
    #
    # where you replace , , by quoted strings and
    # by the master's port number (3306 by default).
    #
    # Example:
    #
    # CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
    # MASTER_USER='joe', MASTER_PASSWORD='secret';
    #
    # OR
    #
    # 2) Set the variables below. However, in case you choose this method, then
    # start replication for the first time (even unsuccessfully, for example
    # if you mistyped the password in master-password and the slave fails to
    # connect), the slave will create a master.info file, and any later
    # change in this file to the variables' values below will be ignored and
    # overridden by the content of the master.info file, unless you shutdown
    # the slave server, delete master.info and restart the slaver server.
    # For that reason, you may want to leave the lines below untouched
    # (commented) and instead use CHANGE MASTER TO (see above)
    #
    # required unique id between 2 and 2^32 - 1
    # (and different from the master)
    # defaults to 2 if master-host is set
    # but will not function as a slave if omitted
    #server-id = 2

    ОтветитьУдалить
  18. #
    # The replication master for this slave - required
    #master-host =
    #
    # The username the slave will use for authentication when connecting
    # to the master - required
    #master-user =
    #
    # The password the slave will authenticate with when connecting to
    # the master - required
    #master-password =
    #
    # The port the master is listening on.
    # optional - defaults to 3306
    #master-port =
    #
    # binary logging - not required for slaves, but recommended
    #log-bin = mysql-bin

    # Point the following paths to different dedicated disks
    tmpdir = "C:/xampp/tmp/"
    #log-update = "C:/xampp/tmp/mysql"

    # Uncomment the following if you are using InnoDB tables
    #skip-innodb
    innodb_data_home_dir = "C:/xampp/mysql/data/"
    innodb_data_file_path = ibdata1:30M:autoextend
    innodb_log_group_home_dir = "C:/xampp/mysql/data/"
    # You can set .._buffer_pool_size up to 50 - 80 %
    # of RAM but beware of setting memory usage too high
    innodb_buffer_pool_size = 16M
    innodb_additional_mem_pool_size = 2M
    # Set .._log_file_size to 25 % of buffer pool size
    innodb_log_file_size = 5M
    innodb_log_buffer_size = 8M
    innodb_flush_log_at_trx_commit = 1
    innodb_lock_wait_timeout = 50

    ОтветитьУдалить
  19. [mysqldump]
    quick
    max_allowed_packet = 16M

    [mysql]
    no-auto-rehash
    # Remove the next comment character if you are not familiar with SQL
    #safe-updates

    [isamchk]
    key_buffer = 20M
    sort_buffer_size = 20M
    read_buffer = 2M
    write_buffer = 2M

    [myisamchk]
    key_buffer = 20M
    sort_buffer_size = 20M
    read_buffer = 2M
    write_buffer = 2M

    [mysqlhotcopy]
    interactive-timeout

    ОтветитьУдалить
  20. Пришлось вставлять длинный файл c://xampp/mysql/bin/my.ini в несколько комментариев (все сверху).
    Теперь можно начать анализировать файл, но при этом не стоит забывать про сайт авторов книги

    softtime.ru/forum/index.php?id_forum=3

    сайт грузится со скоростью невероятной, и вопросы можно задавать... есть, у кого спросить, как отладить XAMPP

    ОтветитьУдалить