Mysql no puede crear una nueva instancia de conexion:
Posibles soluciones:
1- En mysql.ini ajustar el parametro max_connection a 2048 o más.
2- Intenta conectar con mysql_connect y no con mysql_pconnect (conexiones persistentes).
Luego de realizar cambios en mysql.ini no olvides restartear el APACHE.
A mi me ocurre eso con la galería de mi web,pero esas opciones que dices,¿Dónde tengo que hacerlas?,es que yo de estas cosas no me entero
Gracias de antemano
Hola, si tienes acceso como root a tu hosting debes editar el mysql.ini o my.ini o my.cnf – segun la version – que esta localizado generalmente en /etc/my.ini . Lo editas con vim /etc/my.ini
Debes cambiar el parametro max_connection como indiqué . Si no tienes acceso debes solicitarlo al soporte tecnico de tu hosting.
Ok,pero cuando modifico eso,luego lo tengo que subir al servidor donde tengo instalada la galería?
Gracias de antemano
Un saludo
1- En mysql.ini ajustar el parametro max_connection a 2048 o más.
Esto lo debes solicitar a tu soporte tecnico o admin de servidor, solo si tu servidor es dedicado.
2- Intenta conectar con mysql_connect y no con mysql_pconnect (conexiones persistentes).
Esto lo ves en el archivo de conexion a la base de datos de tu aplicacion, dependiendo de la aplicacion (joomla, wordpress, etc, etc) estan con distintos nombres y ubicados en distintos directorios.
Sds
Pues adivina….ahora resulta que le mensaje es distinto,ahora pone esto
MySQL said: Lost connection to MySQL server at ‘reading initial communication packet’, system error: 113
¿Qué significa?
Gracias de antemano
Un saludo
Bueno aqui te pongo una tabla con las decripciones de codigos MySQL:
OS error code 1: Operation not permitted
OS error code 2: No such file or directory
OS error code 3: No such process
OS error code 4: Interrupted system call
OS error code 5: Input/output error
OS error code 6: No such device or address
OS error code 7: Argument list too long
OS error code 8: Exec format error
OS error code 9: Bad file descriptor
OS error code 10: No child processes
OS error code 11: Resource temporarily unavailable
OS error code 12: Cannot allocate memory
OS error code 13: Permission denied
OS error code 14: Bad address
OS error code 15: Block device required
OS error code 16: Device or resource busy
OS error code 17: File exists
OS error code 18: Invalid cross-device link
OS error code 19: No such device
OS error code 20: Not a directory
OS error code 21: Is a directory
OS error code 22: Invalid argument
OS error code 23: Too many open files in system
OS error code 24: Too many open files
OS error code 25: Inappropriate ioctl for device
OS error code 26: Text file busy
OS error code 27: File too large
OS error code 28: No space left on device
OS error code 30: Read-only file system
OS error code 31: Too many links
OS error code 32: Broken pipe
OS error code 33: Numerical argument out of domain
OS error code 34: Numerical result out of range
OS error code 35: Resource deadlock avoided
OS error code 36: File name too long
OS error code 37: No locks available
OS error code 38: Function not implemented
OS error code 39: Directory not empty
OS error code 40: Too many levels of symbolic links
OS error code 42: No message of desired type
OS error code 43: Identifier removed
OS error code 44: Channel number out of range
OS error code 45: Level 2 not synchronized
OS error code 46: Level 3 halted
OS error code 47: Level 3 reset
OS error code 48: Link number out of range
OS error code 49: Protocol driver not attached
OS error code 50: No CSI structure available
OS error code 51: Level 2 halted
OS error code 52: Invalid exchange
OS error code 53: Invalid request descriptor
OS error code 54: Exchange full
OS error code 55: No anode
OS error code 56: Invalid request code
OS error code 57: Invalid slot
OS error code 59: Bad font file format
OS error code 60: Device not a stream
OS error code 61: No data available
OS error code 62: Timer expired
OS error code 63: Out of streams resources
OS error code 64: Machine is not on the network
OS error code 65: Package not installed
OS error code 66: Object is remote
OS error code 67: Link has been severed
OS error code 68: Advertise error
OS error code 69: Srmount error
OS error code 70: Communication error on send
OS error code 71: Protocol error
OS error code 72: Multihop attempted
OS error code 73: RFS specific error
OS error code 74: Bad message
OS error code 75: Value too large for defined data type
OS error code 76: Name not unique on network
OS error code 77: File descriptor in bad state
OS error code 78: Remote address changed
OS error code 79: Can not access a needed shared library
OS error code 80: Accessing a corrupted shared library
OS error code 81: .lib section in a.out corrupted
OS error code 82: Attempting to link in too many shared libraries
OS error code 83: Cannot exec a shared library directly
OS error code 84: Invalid or incomplete multibyte or wide character
OS error code 85: Interrupted system call should be restarted
OS error code 86: Streams pipe error
OS error code 87: Too many users
OS error code 88: Socket operation on non-socket
OS error code 89: Destination address required
OS error code 90: Message too long
OS error code 91: Protocol wrong type for socket
OS error code 92: Protocol not available
OS error code 93: Protocol not supported
OS error code 94: Socket type not supported
OS error code 95: Operation not supported
OS error code 96: Protocol family not supported
OS error code 97: Address family not supported by protocol
OS error code 98: Address already in use
OS error code 99: Cannot assign requested address
OS error code 100: Network is down
OS error code 101: Network is unreachable
OS error code 102: Network dropped connection on reset
OS error code 103: Software caused connection abort
OS error code 104: Connection reset by peer
OS error code 105: No buffer space available
OS error code 106: Transport endpoint is already connected
OS error code 107: Transport endpoint is not connected
OS error code 108: Cannot send after transport endpoint shutdown
OS error code 109: Too many references: cannot splice
OS error code 110: Connection timed out
OS error code 111: Connection refused
OS error code 112: Host is down
OS error code 113: No route to host
OS error code 114: Operation already in progress
OS error code 115: Operation now in progress
OS error code 116: Stale NFS file handle
OS error code 117: Structure needs cleaning
OS error code 118: Not a XENIX named type file
OS error code 119: No XENIX semaphores available
OS error code 120: Is a named type file
OS error code 121: Remote I/O error
OS error code 122: Disk quota exceeded
OS error code 123: No medium found
OS error code 124: Wrong medium type
OS error code 125: Operation canceled
MySQL error code 126: Index file is crashed
MySQL error code 127: Record-file is crashed
MySQL error code 128: Out of memory
MySQL error code 130: Incorrect file format
MySQL error code 131: Command not supported by database
MySQL error code 132: Old database file
MySQL error code 133: No record read before update
MySQL error code 134: Record was already deleted (or record file crashed)
MySQL error code 135: No more room in record file
MySQL error code 136: No more room in index file
MySQL error code 137: No more records (read after end of file)
MySQL error code 138: Unsupported extension used for table
MySQL error code 139: Too big row
MySQL error code 140: Wrong create options
MySQL error code 141: Duplicate unique key or constraint on write or update
MySQL error code 142: Unknown character set used
MySQL error code 143: Conflicting table definitions in sub-tables of MERGE table
MySQL error code 144: Table is crashed and last repair failed
MySQL error code 145: Table was marked as crashed and should be repaired
MySQL error code 146: Lock timed out; Retry transaction
MySQL error code 147: Lock table is full; Restart program with a larger locktable
MySQL error code 148: Updates are not allowed under a read only transactions
MySQL error code 149: Lock deadlock; Retry transaction
MySQL error code 150: Foreign key constraint is incorrectly formed
MySQL error code 151: Cannot add a child row
MySQL error code 152: Cannot delete a parent row
Como verás el Codigo 113 se refiere a que no hay conexion al servidor, si no esta Ubicado en el mismo servidor donde se encuentra la aplicación, verifica eso mismo si pudes pingear.
Intenta conectar manualmente al servidor de MySQL desde la linea de comando.
Verifica colocar la aplicacion en el mismo servidor donde esté el motor MySQL para ir descartando chances.
Espero que te sirva!
Uf amigo no te puedes imaginar lo que me ha pasado,la galería me funciona,pero mira lo que me aparece
Notice: Undefined offset: 8192 in /usr/export/www/vhosts/funnetwork/hosting/cohen12/cpg1410/include/debugger.inc.php on line 112
¿Qué significa ?
Gracias de antemano
Un cordial saludo
Hola, eso es un error de PHP debes intentar abrir el archivo /usr/export/www/vhosts/funnetwork/hosting/cohen12/cpg1410/include/debugger.inc.php ubicar la linea 112 y volcar a pantalla el contenido del array que no tiene un offset 8192 y ver porque puede ser. El volcado lo podes hacer con print »; var_dump($variable_array); print »;
Espero que te comience a ayudar.
Pero ese archivo que debo abrir,¿Desde dónde tengo que hacerlo?
Gracias de antemano
Un cordial saludo
Bueno, es un archivo de texto, con codigo PHP, asique te alcanza con abrirlo desde el wordpad. Pero es mejor utilizar DreamWeaver o Zend Studio, donde puedes ver el codigo resaltado la sintaxis.