Error #2002 phpmyadmin no me deja acceder a mysql ni reiniciar

  • Autor Autor xaiborweb
  • Fecha de inicio Fecha de inicio
xaiborweb

xaiborweb

Programador
No recomendado
¡Usuario con pocos negocios! ¡Utiliza siempre saldo de Forobeta!
hola compañeros del foro cada ves que instalo vestacp en mi vps ovh y subo la pagina que tengo con un sql grande de 2gb después de un tiempo siempre me aparece esto
IMAGEN
en /var/log/mysql/error.log me aparece esto
Insertar CODE, HTML o PHP:
2017-08-26T13:51:29.481793Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 10000)
2017-08-26T13:51:29.481908Z 0 [Warning] Changed limits: max_connections: 214 (requested 2000)
2017-08-26T13:51:29.678828Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-08-26T13:51:29.678864Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2017-08-26T13:51:29.681809Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.19-0ubuntu0.16.04.1) starting as process 9797 ...
2017-08-26T13:51:29.718062Z 0 [Note] InnoDB: PUNCH HOLE support available
2017-08-26T13:51:29.718102Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-08-26T13:51:29.718110Z 0 [Note] InnoDB: Uses event mutexes
2017-08-26T13:51:29.718114Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-08-26T13:51:29.718117Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2017-08-26T13:51:29.718121Z 0 [Note] InnoDB: Using Linux native AIO
2017-08-26T13:51:29.718657Z 0 [Note] InnoDB: Number of pools: 1
2017-08-26T13:51:29.718867Z 0 [Note] InnoDB: Using CPU crc32 instructions
2017-08-26T13:51:29.721677Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2017-08-26T13:51:29.740430Z 0 [Note] InnoDB: Completed initialization of buffer pool
2017-08-26T13:51:29.744107Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2017-08-26T13:51:29.759042Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2017-08-26T13:51:29.785839Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2017-08-26T13:51:29.785946Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2017-08-26T13:51:29.796944Z 0 [Warning] InnoDB: 1048576 bytes should have been written. Only 770048 bytes written. Retrying for the remaining bytes.
2017-08-26T13:51:29.796981Z 0 [Warning] InnoDB: Retry attempts for writing partial data failed.
2017-08-26T13:51:29.796994Z 0 [ERROR] InnoDB: Write to file ./ibtmp1failed at offset 7340032, 1048576 bytes should have been written, only 770048 were written. Operating system error number 28. Check that your OS and file system support files of this size. Check also that the disk is not full or a disk quota exceeded.
2017-08-26T13:51:29.797010Z 0 [ERROR] InnoDB: Error number 28 means 'No space left on device'
2017-08-26T13:51:29.797016Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2017-08-26T13:51:29.797024Z 0 [ERROR] InnoDB: Could not set the file size of './ibtmp1'. Probably out of disk space
2017-08-26T13:51:29.797032Z 0 [ERROR] InnoDB: Unable to create the shared innodb_temporary
2017-08-26T13:51:29.797039Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2017-08-26T13:51:30.399429Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2017-08-26T13:51:30.399458Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2017-08-26T13:51:30.399463Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-08-26T13:51:30.399468Z 0 [ERROR] Failed to initialize plugins.
2017-08-26T13:51:30.399471Z 0 [ERROR] Aborting

2017-08-26T13:51:30.399484Z 0 [Note] Binlog end
2017-08-26T13:51:30.399565Z 0 [Note] Shutting down plugin 'MyISAM'
2017-08-26T13:51:30.399914Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
y no se como solucionarlo alguien que ya halla pasado por lo mismo podría compartir su sabiduría para orientarme por favor.
 
Deberás de cambiar los valores en el my.conf max_open_files y max_connections

Pero, esos valores esta mal deberías de optimizar tu script y base de datos por lo que te esta pidiendo es absurdo.

También tienes que revisar tu espacio estas sin espacio.
 
Si es un VPS de OVH puede que llegues al limite fisico impuesto en tu nodo, es normal en los vps revisa los logs del sistema probablemente sea el caso del porque crashea mysql.

Saludos.
 
El mensaje esta muy claro:

Could not set the file size of './ibtmp1'. Probably out of disk space
[MENTION=35077]xaiborweb[/MENTION] lo ideal es que solicites un aumento de plan o migres a un servidor dedicado de los de Kimsufi o Soyoustart.
 
Atrás
Arriba