|
Página 1 de 1
|
| Autor |
Mensaje |
sebas_acci 
Usuario/a
Registrado: Julio 2008
Mensajes: 88
Edad: 24
Nombre Real: Sebas
|
 Error Base De Datos
¿Alguien me puede ayudar a solucionar este error en mi web?
Critical Error!
message_die() was called multiple times.
Error #1
Error doing DB query userdata row fetch
Line : 97
File : /home/elarte/public_html/includes/sessions.php
SQL : SELECT u.* FROM ip_users u, ip_sessions_keys k WHERE u.user_id = 2 AND u.user_active = 1 AND k.user_id = u.user_id AND k.key_id = '8c72f8003c5d25384d528e79b41c112b'
Error #2
Error
Could not query log information
Line : 101
File : /home/elarte/public_html/includes/functions_mg_log.php
SQL : SELECT MAX(log_id) max_log_id FROM ip_logs
Le estaré muy agradecido...
_____________________________________________________________________ Icy Phoenix 1.3.0.53b
http://www.elartedetorear.com/
HideMOD
Hosting de pago: Hostgator
|
#1 Martes, 13 Diciembre 2011, 18:49 |
|
 |
Patrocinadores
|
|
|
sebas_acci
Usuario/a
Registrado: Julio 2008
Mensajes: 88
Edad: 24
Nombre Real: Sebas
|
Re: Error Base De Datos
El problema se ha solucionado solo  Sería algo del servidor. Saludos.
_____________________________________________________________________ Icy Phoenix 1.3.0.53b
http://www.elartedetorear.com/
HideMOD
Hosting de pago: Hostgator
|
#2 Miércoles, 14 Diciembre 2011, 09:02 |
|
|
sebas_acci
Usuario/a
Registrado: Julio 2008
Mensajes: 88
Edad: 24
Nombre Real: Sebas
|
Re: Error Base De Datos
De vuelta el mismo error:
Critical Error!
message_die() was called multiple times.
Error #1
Error doing DB query userdata row fetch
Line : 97
File : /home/elarte/public_html/includes/sessions.php
SQL : SELECT u.* FROM ip_users u, ip_sessions_keys k WHERE u.user_id = 2 AND u.user_active = 1 AND k.user_id = u.user_id AND k.key_id = '91cca709a76d65653b383f0bd15d679d'
Error #2
Error
Could not query log information
Line : 101
File : /home/elarte/public_html/includes/functions_mg_log.php
SQL : SELECT MAX(log_id) max_log_id FROM ip_logs
Y un email de hostgator diciéndome que mi web consume muchos recursos:
Hello,
This message is to advise you of a temporary block placed on your database. The database was found to be consuming an inordinate amount of processor time, to the point of degrading overall system performance. While we do limit each account to no more than 25% of a system's CPU in our terms of service, we do not actively disable accounts until they greatly exceed that number, which is what happened in this case. Requests to this database may become degraded by limiting the maximum number of queries or connections for a limited amount of time, or if there are sustained issues, ultimately we may be forced to block access to this database until the issue has been resolved.
Resolving this situation may be as simple as adding additional indexes to your database, optimizing the queries used, or something equally easy. If not, it may simply be a matter of moving this database to dedicated services, as it may have outgrown a shared environment.
If you believe you have a solution to this overuse, we are happy to discuss the situation with you and possibly reinstate the database on the server. Otherwise, we will be happy to assist you with the upgrade process if a dedicated server is the most appropriate solution. Thank you, and we look forward to hearing from you shortly.
~~~
Excessive MySQL activity is caused by (a) a long-running process that locks a table, causing other queries to back up, (b) a query that is not optimized ][example: select all from ... and involving a large or complex query], (c) huge table copies/maintenance during peak hours.
NOTE:, the following are just possible fixes or suggestions, and are not endorsed or supported by HostGator. They are included in the hope that they may apply to your situation, and/or help you reduce the amount of resources your SQL queries consume. As always, it's best to Backup any data before making any changes or adjustments.
First and foremost, you may need to optimize your tables. The frequency depends on the size and usage of the database, but most databases would benefit from doing something like this on a yearly basis: a) Enter your phpMyAdmin/MySQL control panel. Click on the database (not the table, the database name), and on the right hand column your tables should be listed. Scroll down till you see the .Check all. link. Click on that link, make sure all database tables are checked and then from the drop-down next to it, and carefully select .Optimize table..
Additionally, adding indexes to your table(s) may improve performance. If you're not sure what you're doing, it's best not to modify any table; caution is recommended. There are various articles (http://www.developer.com/DB/article.php/3667831/Four-Ways-to-Optimize-Your-MySQL-Database.htm and http://www.databasejournal.com/features/mysql/article.php/1382791/Optimizing-MySQL-Queries-and-Indexes.htm). It may be best to Google for something like [Your Software Name] MySQL indexes for suggestions.
If you reply back to this with your IP address (http://www.hostgator.com/ip.shtml) we will be more than happy to go ahead enable HTTP access for you, so that you can safely work on the script without it causing further issues. Please let us know how you would like to proceed.
CPU_TIME:57 table_rows_read:34699675 SELECTS:245 ROWS_UPDATED:0 ROWS_FETCHED:0 BUSY_TIME:1369 BYTES_SENT:249231 BYTES_RECEIVED:88429 WAIT_TIME:1312
Top table row reads:
DB_USER: elarte_sebas -- TOTAL_CONNECTIONS: 44 -- CPU_TIME: 58 -- TABLE_ROW_READS: 34700098 -- SELECT_COMMANDS: 246 -- UPATE_COMMANDS: 74 -- BUSY_TIME: 1378 -- BYTES_SENT: 249231 -- BYTES_RECEIVED: 88524 -- WAIT_TIME (IO): 1320
Top CPU TIME:
DB_USER: elarte_sebas -- TOTAL_CONNECTIONS: 44 -- CPU_TIME: 58 -- TABLE_ROW_READS: 34700098 -- SELECT_COMMANDS: 246 -- UPATE_COMMANDS: 74 -- BUSY_TIME: -- BYTES_SENT: 249231 -- BYTES_RECEIVED: 88524 -- WAIT_TIME (IO): 1320
elarte 20789 1.1 0.0 27804 12240 ? SN 04:12 0:00 /usr/bin/php /home/elarte/public_html/referrers.php
elarte 20965 1.0 0.0 26464 10728 ? SN 04:12 0:00 /usr/bin/php /home/elarte/public_html/referrers.php
root 21323 0.0 0.0 5492 920 ? SN 04:13 0:00 sh -c ps aux | grep elarte
root 21325 0.0 0.0 4932 664 ? SN 04:13 0:00 grep elarte
Wed Dec 14 04:13:13 CST 2011
Running Processes:
elarte 20789 1.0 0.0 27804 12240 ? SN 04:12 0:00 /usr/bin/php /home/elarte/public_html/referrers.php
elarte 20965 1.0 0.0 26464 10728 ? SN 04:13 0:00 /usr/bin/php /home/elarte/public_html/referrers.php
Running Queries:
*************************** 1. row ***************************
USER: elarte_sebas
DB: elarte_detorear
STATE: Opening tables
TIME: 2
COMMAND: Query
INFO: SELECT * FROM ip_referrers
WHERE referrer_url = 'http://drcan-mf.if.ua/p/drayvera-dlya-vindous-7-skachat/'
*************************** 2. row ***************************
USER: elarte_sebas
DB: elarte_detorear
STATE: Locked
TIME: 9
COMMAND: Query
INFO: UPDATE ip_referrers
SET referrer_hits = referrer_hits + 1, referrer_lastvisit = 1323857591, referrer_ip = '4e8921b0'
WHERE referrer_url='http://dguioi.x777.info/sitemap.html'
*************************** 3. row ***************************
USER: elarte_sebas
DB: elarte_detorear
STATE: Sorting result
TIME: 23
COMMAND: Query
INFO: SELECT * FROM ip_referrers ORDER BY referrer_hits DESC LIMIT 56650, 100
Current Site Requests:
178.239.58.143 elartedetorear.com /
178.239.58.143 elartedetorear.com /
178.239.58.143 elartedetorear.com /
207.46.195.242 elartedetorear.com /ganaderia-barralva-de-nuestro-campo-bravo-rtvcm-vp29757.ht
207.46.195.242 elartedetorear.com /ganaderia-barralva-de-nuestro-campo-bravo-rtvcm-vp29757.ht
46.201.133.134 elartedetorear.com /referrers.php
65.52.104.27 elartedetorear.com /referrers.php?order=DESC&start=398300
77.211.251.171 elartedetorear.com /documental-sobre-andy-cartagena-vt4467.html
79.108.147.137 elartedetorear.com /
85.138.147.31 elartedetorear.com /index.php
Sinceramente no creo que mi web consuma tantos recursos y me temo que sea problema de algún código malicioso que se ha instaurado en la web.
¿Alguien tiene idea de cómo solucionar el problema y me puede ayudar?
Muchas gracias por adelantado!
_____________________________________________________________________ Icy Phoenix 1.3.0.53b
http://www.elartedetorear.com/
HideMOD
Hosting de pago: Hostgator
|
#3 Jueves, 15 Diciembre 2011, 13:47 |
|
|
sebas_acci
Usuario/a
Registrado: Julio 2008
Mensajes: 88
Edad: 24
Nombre Real: Sebas
|
Re: Error Base De Datos
Por favor, ¿nadie tiene alguna idea al respecto? :S
_____________________________________________________________________ Icy Phoenix 1.3.0.53b
http://www.elartedetorear.com/
HideMOD
Hosting de pago: Hostgator
|
#4 Martes, 20 Diciembre 2011, 12:14 |
|
|
 fransaul
Asiduo/a
 
Registrado: Agosto 2007
Mensajes: 148
Edad: 22
|
Re: Error Base De Datos
No soy un gran entendido por lo que mi respuesta igual no te lo soluciona o no es posible pero nose.
intenta subir el archivo de Icy Phoenix de nuevo, si el codigo se modifico "solo" lo volverias a poner por defecto.
por probar no se pierde nada :S, pero como te digo nose si esa sera la solucion :S
Saludos!
_____________________________________________________________________ web: http://www.6afondo.99h.com.ar
Versión de Icy Phoenix: 1.3.0.53
Versión de PHP: 5.2.17
ningun mod instalado
servidor gratuito
template agent_orange
|
#5 Sábado, 24 Diciembre 2011, 00:05 |
|
|
|
|
|
 ¿Este tema fue útil?
 ¿Este tema fue útil?
|
| Media de valoración |
Valoración mínima |
Valoración máxima |
Número de valoraciones |
| 0.00 |
0 |
0 |
0 |
| | Compartir este tema |
|---|
|
|
|
|
Página 1 de 1
|
Usuarios navegando en este tema: 0 registrados, 0 ocultos y 1 invitado
Usuarios registrados conectados: Ninguno
|
No puede crear mensajes
No puede responder temas
No puede editar sus mensajes
No puede borrar sus mensajes
No puede votar en encuestas
No puede adjuntar archivos
No puede descargar archivos
No puede publicar eventos en el calendario
|
|
|
|
Licencia de Icy Phoenix España
© 2008, 2009 Icy Phoenix España - CMS basado en phpBB 2 Icy Phoenix España esta alojada en un dedicado de CyberNETicos
|
|
