Strange error in WordPress plugin in Help

edited May 2016 in Help
Hello,

Im having a strange error with Visual Composer plugin.

Always I try to edit a large page or use the visual editor, my WordPress breaks down and show this error: Error establishing a database connection.

In phpmyadmin I get this error:
#2002 - No such file or directory. The server is not responding (or the local server's socket is not correctly configured).
mysqli_real_connect(): (HY000/2002): No such file or directory

And I need always to restart the server to back to normal. It seems that mysql is breaking when I open these large pages with Visual Composer.

Anyone can help me?

My server config is: CentOS 6 with LEMP stack

Comments

  • Mysql error log:

    160511 20:45:32 mysqld_safe Number of processes running now: 0
    160511 20:45:32 mysqld_safe mysqld restarted
    2016-05-11 20:45:33 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
    2016-05-11 20:45:33 0 [Note] /usr/libexec/mysqld (mysqld 5.6.29-log) starting as process 1724 ...
    2016-05-11 20:45:33 1724 [Note] Plugin 'FEDERATED' is disabled.
    2016-05-11 20:45:33 1724 [Note] InnoDB: Using atomics to ref count buffer pool pages
    2016-05-11 20:45:33 1724 [Note] InnoDB: The InnoDB memory heap is disabled
    2016-05-11 20:45:33 1724 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    2016-05-11 20:45:33 1724 [Note] InnoDB: Memory barrier is not used
    2016-05-11 20:45:33 1724 [Note] InnoDB: Compressed tables use zlib 1.2.3
    2016-05-11 20:45:33 1724 [Note] InnoDB: Using Linux native AIO
    2016-05-11 20:45:33 1724 [Note] InnoDB: Using CPU crc32 instructions
    2016-05-11 20:45:33 1724 [Note] InnoDB: Initializing buffer pool, size = 128.0M
    InnoDB: mmap(137363456 bytes) failed; errno 12
    2016-05-11 20:45:33 1724 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
    2016-05-11 20:45:33 1724 [ERROR] Plugin 'InnoDB' init function returned error.
    2016-05-11 20:45:33 1724 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
    2016-05-11 20:45:33 1724 [ERROR] Unknown/unsupported storage engine: InnoDB
    2016-05-11 20:45:33 1724 [ERROR] Aborting

    2016-05-11 20:45:33 1724 [Note] Binlog end
    2016-05-11 20:45:33 1724 [Note] Shutting down plugin 'partition'
    2016-05-11 20:45:33 1724 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
    2016-05-11 20:45:33 1724 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
    2016-05-11 20:45:33 1724 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
    2016-05-11 20:45:33 1724 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
    2016-05-11 20:45:33 1724 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
    2016-05-11 20:45:33 1724 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
    2016-05-11 20:45:33 1724 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
    2016-05-11 20:45:33 1724 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
    2016-05-11 20:45:33 1724 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
    2016-05-11 20:45:33 1724 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
    2016-05-11 20:45:33 1724 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
    2016-05-11 20:45:33 1724 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
    2016-05-11 20:45:33 1724 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
    2016-05-11 20:45:33 1724 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
    2016-05-11 20:45:33 1724 [Note] Shutting down plugin 'INNODB_FT_DELETED'
    2016-05-11 20:45:33 1724 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
    2016-05-11 20:45:33 1724 [Note] Shutting down plugin 'INNODB_METRICS'
    2016-05-11 20:45:33 1724 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
    2016-05-11 20:45:33 1724 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
    2016-05-11 20:45:33 1724 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
    2016-05-11 20:45:33 1724 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
    2016-05-11 20:45:33 1724 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
    2016-05-11 20:45:33 1724 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
    2016-05-11 20:45:33 1724 [Note] Shutting down plugin 'INNODB_CMPMEM'
    2016-05-11 20:45:33 1724 [Note] Shutting down plugin 'INNODB_CMP_RESET'
    2016-05-11 20:45:33 1724 [Note] Shutting down plugin 'INNODB_CMP'
    2016-05-11 20:45:33 1724 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
    2016-05-11 20:45:33 1724 [Note] Shutting down plugin 'INNODB_LOCKS'
    2016-05-11 20:45:33 1724 [Note] Shutting down plugin 'INNODB_TRX'
    2016-05-11 20:45:33 1724 [Note] Shutting down plugin 'ARCHIVE'
    2016-05-11 20:45:33 1724 [Note] Shutting down plugin 'BLACKHOLE'
    2016-05-11 20:45:33 1724 [Note] Shutting down plugin 'CSV'
    2016-05-11 20:45:33 1724 [Note] Shutting down plugin 'MEMORY'
    2016-05-11 20:45:33 1724 [Note] Shutting down plugin 'MRG_MYISAM'
    2016-05-11 20:45:33 1724 [Note] Shutting down plugin 'MyISAM'
    2016-05-11 20:45:33 1724 [Note] Shutting down plugin 'sha256_password'
    2016-05-11 20:45:33 1724 [Note] Shutting down plugin 'mysql_old_password'
    2016-05-11 20:45:33 1724 [Note] Shutting down plugin 'mysql_native_password'
    2016-05-11 20:45:33 1724 [Note] Shutting down plugin 'binlog'
    2016-05-11 20:45:33 1724 [Note] /usr/libexec/mysqld: Shutdown complete

    160511 20:45:33 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
  • edited May 2016
    It appears InnoDB is failing to start because it's unable to reserve the requested amount of memory for the innodb buffer pool. You should be able to solve this by either:

    (1) lowering the amount of memory requested in your config
    (2) upgrading your instance plan
    or (3) setting up a swap file:

    https://www.vultr.com/docs/setup-swap-file-on-linux

  • Im having mysql stops again, now its just happening with the normal access.

    Please, check my logs:

    160517 04:59:56 mysqld_safe Number of processes running now: 0
    160517 04:59:56 mysqld_safe mysqld restarted
    2016-05-17 04:59:57 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
    2016-05-17 04:59:57 0 [Note] /usr/libexec/mysqld (mysqld 5.6.30-log) starting as process 3129 ...
    2016-05-17 04:59:57 3129 [Note] Plugin 'FEDERATED' is disabled.
    2016-05-17 04:59:57 3129 [Note] InnoDB: Using atomics to ref count buffer pool pages
    2016-05-17 04:59:57 3129 [Note] InnoDB: The InnoDB memory heap is disabled
    2016-05-17 04:59:57 3129 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    2016-05-17 04:59:57 3129 [Note] InnoDB: Memory barrier is not used
    2016-05-17 04:59:57 3129 [Note] InnoDB: Compressed tables use zlib 1.2.3
    2016-05-17 04:59:57 3129 [Note] InnoDB: Using Linux native AIO
    2016-05-17 04:59:57 3129 [Note] InnoDB: Using CPU crc32 instructions
    2016-05-17 04:59:57 3129 [Note] InnoDB: Initializing buffer pool, size = 1.0G
    InnoDB: mmap(137363456 bytes) failed; errno 12
    2016-05-17 04:59:57 3129 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
    2016-05-17 04:59:57 3129 [ERROR] Plugin 'InnoDB' init function returned error.
    2016-05-17 04:59:57 3129 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
    2016-05-17 04:59:57 3129 [ERROR] Unknown/unsupported storage engine: InnoDB
    2016-05-17 04:59:57 3129 [ERROR] Aborting

    2016-05-17 04:59:57 3129 [Note] Binlog end
    2016-05-17 04:59:57 3129 [Note] Shutting down plugin 'partition'
    2016-05-17 04:59:57 3129 [Note] Shutting down plugin 'ARCHIVE'
    2016-05-17 04:59:57 3129 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
    2016-05-17 04:59:57 3129 [Note] Shutting down plugin 'BLACKHOLE'
    2016-05-17 04:59:57 3129 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
    2016-05-17 04:59:57 3129 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
    2016-05-17 04:59:57 3129 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
    2016-05-17 04:59:57 3129 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
    2016-05-17 04:59:57 3129 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
    2016-05-17 04:59:57 3129 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
    2016-05-17 04:59:57 3129 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
    2016-05-17 04:59:57 3129 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
    2016-05-17 04:59:57 3129 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
    2016-05-17 04:59:57 3129 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
    2016-05-17 04:59:57 3129 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
    2016-05-17 04:59:57 3129 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
    2016-05-17 04:59:57 3129 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
    2016-05-17 04:59:57 3129 [Note] Shutting down plugin 'INNODB_FT_DELETED'
    2016-05-17 04:59:57 3129 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
    2016-05-17 04:59:57 3129 [Note] Shutting down plugin 'INNODB_METRICS'
    2016-05-17 04:59:57 3129 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
    2016-05-17 04:59:57 3129 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
    2016-05-17 04:59:57 3129 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
    2016-05-17 04:59:57 3129 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
    2016-05-17 04:59:57 3129 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
    2016-05-17 04:59:57 3129 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
    2016-05-17 04:59:57 3129 [Note] Shutting down plugin 'INNODB_CMPMEM'
    2016-05-17 04:59:57 3129 [Note] Shutting down plugin 'INNODB_CMP_RESET'
    2016-05-17 04:59:57 3129 [Note] Shutting down plugin 'INNODB_CMP'
    2016-05-17 04:59:57 3129 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
    2016-05-17 04:59:57 3129 [Note] Shutting down plugin 'INNODB_LOCKS'
    2016-05-17 04:59:57 3129 [Note] Shutting down plugin 'INNODB_TRX'
    2016-05-17 04:59:57 3129 [Note] Shutting down plugin 'CSV'
    2016-05-17 04:59:57 3129 [Note] Shutting down plugin 'MEMORY'
    2016-05-17 04:59:57 3129 [Note] Shutting down plugin 'MRG_MYISAM'
    2016-05-17 04:59:57 3129 [Note] Shutting down plugin 'MyISAM'
    2016-05-17 04:59:57 3129 [Note] Shutting down plugin 'sha256_password'
    2016-05-17 04:59:57 3129 [Note] Shutting down plugin 'mysql_old_password'
    2016-05-17 04:59:57 3129 [Note] Shutting down plugin 'mysql_native_password'
    2016-05-17 04:59:57 3129 [Note] Shutting down plugin 'binlog'
    2016-05-17 04:59:57 3129 [Note] /usr/libexec/mysqld: Shutdown complete

    160517 04:59:57 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
    160517 15:16:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    2016-05-17 15:16:33 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
    2016-05-17 15:16:33 0 [Note] /usr/libexec/mysqld (mysqld 5.6.30-log) starting as process 1390 ...
    2016-05-17 15:16:33 1390 [Note] Plugin 'FEDERATED' is disabled.
    2016-05-17 15:16:33 1390 [Note] InnoDB: Using atomics to ref count buffer pool pages
    2016-05-17 15:16:33 1390 [Note] InnoDB: The InnoDB memory heap is disabled
    2016-05-17 15:16:33 1390 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    2016-05-17 15:16:33 1390 [Note] InnoDB: Memory barrier is not used
    2016-05-17 15:16:33 1390 [Note] InnoDB: Compressed tables use zlib 1.2.3
    2016-05-17 15:16:33 1390 [Note] InnoDB: Using Linux native AIO
    2016-05-17 15:16:33 1390 [Note] InnoDB: Using CPU crc32 instructions
    2016-05-17 15:16:33 1390 [Note] InnoDB: Initializing buffer pool, size = 1.0G
    2016-05-17 15:16:33 1390 [Note] InnoDB: Completed initialization of buffer pool
    2016-05-17 15:16:33 1390 [Note] InnoDB: Highest supported file format is Barracuda.
    2016-05-17 15:16:33 1390 [Note] InnoDB: Log scan progressed past the checkpoint lsn 45428079
    2016-05-17 15:16:33 1390 [Note] InnoDB: Database was not shutdown normally!
    2016-05-17 15:16:33 1390 [Note] InnoDB: Starting crash recovery.
    2016-05-17 15:16:33 1390 [Note] InnoDB: Reading tablespace information from the .ibd files...
    2016-05-17 15:16:33 1390 [Note] InnoDB: Restoring possible half-written data pages
    2016-05-17 15:16:33 1390 [Note] InnoDB: from the doublewrite buffer...
    InnoDB: Doing recovery: scanned up to log sequence number 45428319
    2016-05-17 15:16:33 1390 [Note] InnoDB: Starting an apply batch of log records to the database...
    InnoDB: Progress in percent: 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
    InnoDB: Apply batch completed
    2016-05-17 15:16:33 1390 [Note] InnoDB: 128 rollback segment(s) are active.
    2016-05-17 15:16:33 1390 [Note] InnoDB: Waiting for purge to start
    2016-05-17 15:16:33 1390 [Note] InnoDB: 5.6.30 started; log sequence number 45428319
    2016-05-17 15:16:33 1390 [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work.
    2016-05-17 15:16:33 1390 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work.
    2016-05-17 15:16:33 1390 [Note] Server hostname (bind-address): '*'; port: 3306
    2016-05-17 15:16:33 1390 [Note] IPv6 is available.
    2016-05-17 15:16:33 1390 [Note] - '::' resolves to '::';
    2016-05-17 15:16:33 1390 [Note] Server socket created on IP: '::'.
    2016-05-17 15:16:33 1390 [Note] Event Scheduler: Loaded 0 events
    2016-05-17 15:16:33 1390 [Note] /usr/libexec/mysqld: ready for connections.
    Version: '5.6.30-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Distributed by The IUS Community Project
Sign In or Register to comment.

Registration Required

A VULTR.com account is required to use the forum. Click here to sign in.

Quick Links

In this Discussion