[SPIP Zone] log spip

Archives Zone
1

Bonjour,

Y a t'il un article/site qui explique les logs générés par spip?

Car j'ai un certain nombre de fichiers (prive_spip.log, prive_mysql.log, mysql.log, invalideur.log, prive_invalideur.log, spip.log) log qui contient des erreurs et lignes que je comprends pas.

Merci de votre aide

Nicolas

2

Le 28/04/10 11:53, nicolas a écrit :

Y a t'il un article/site qui explique les logs générés par spip?

hé non.

Car j'ai un certain nombre de fichiers (prive_spip.log, prive_mysql.log,
mysql.log, invalideur.log, prive_invalideur.log, spip.log) log qui
contient des erreurs et lignes que je comprends pas.

précisemment ?

3

denisb wrote:

Le 28/04/10 11:53, nicolas a écrit :

Y a t'il un article/site qui explique les logs générés par spip?

hé non.

merde...

Car j'ai un certain nombre de fichiers (prive_spip.log, prive_mysql.log,
mysql.log, invalideur.log, prive_invalideur.log, spip.log) log qui
contient des erreurs et lignes que je comprends pas.

précisemment ?

du genre dans :
Invalideur :
Apr 28 10:14:23 88.170.229.*** (pid 21694) Taille du CACHE estimee (9): 0.2 Mo
Apr 28 10:39:41 86.76.162.** (pid 5553) Taille du CACHE estimee (a): 0.9 Mo

dans Mysql.log

Apr 28 10:14:18 88.170.229.*** (pid 21642) Table './nom_de_la_base/spipva_visites_articles' is marked as crashed and last (automatic?) repair failed -
SELECT COUNT(*)
FROM `nom_de_la_base`.spipva_visites_articles
WHERE id_article=40 AND date='2010-04-28'
Apr 28 10:14:18 88.170.229.** (pid 21642) Table './nom_de_la_base/spipva_visites_articles' is marked as crashed and last (automatic?) repair failed -
SELECT COUNT(*)
FROM spip_visites_articles
WHERE id_article=40 AND date='2010-04-28'
Apr 28 10:14:18 88.170.229.*** (pid 21642) Table './nom_de_la_base/spipva_visites_articles' is marked as crashed and last (automatic?) repair failed - INSERT INTO spipva_visites_articles (id_article,visites,date) VALUES (40,0,'2010-04-28')
Apr 28 10:14:18 88.170.229.*** (pid 21642) Table './nom_de_la_base/spipva_visites_articles' is marked as crashed and last (automatic?) repair failed -
UPDATE `nom_de_la_base`.spipva_visites_articles
SET visites=visites+1
WHERE date='2010-04-28' AND ((id_article IN (40)))
Apr 28 10:25:42 193.251.176.*** (pid 12942) Table './nom_de_la_base/spipva_visites_articles' is marked as crashed and last (automatic?) repair failed -
SELECT COUNT(*)
FROM `nom_de_la_base`.spipva_visites_articles
WHERE id_article=946 AND date='2010-04-28'
Apr 28 10:25:42 193.251.176.*** (pid 12942) Table './nom_de_la_base/spipva_visites_articles' is marked as crashed and last (automatic?) repair failed -
SELECT COUNT(*)
FROM spip_visites_articles
WHERE id_article=946 AND date='2010-04-28'
Apr 28 10:25:42 193.251.176.** (pid 12942) Table './nom_de_la_base/spipva_visites_articles' is marked as crashed and last (automatic?) repair failed - INSERT INTO spipva_visites_articles (id_article,visites,date) VALUES (946,0,'2010-04-28')
Apr 28 10:25:42 193.251.176.** (pid 12942) Table './nom_de_la_base/spipva_visites_articles' is marked as crashed and last (automatic?) repair failed -
UPDATE `nom_de_la_base`.spipva_visites_articles
SET visites=visites+1
WHERE date='2010-04-28' AND ((id_article IN (946)))
Apr 28 10:55:14 193.251.176.** (pid 3805) Duplicate entry '1936-1075-article' for key 1 - INSERT INTO spipva_documents_liens (id_objet,objet,id_document,vu) VALUES (1075,'article',1936,'oui')
Apr 28 10:55:45 193.251.176.253 (pid 4214) Duplicate entry '1936-1075-article' for key 1 - INSERT INTO spipva_documents_liens (id_objet,objet,id_document,vu) VALUES (1075,'article',1936,'oui')
Apr 28 11:02:03 193.251.176.*** (pid 11503) Duplicate entry '1915-1065-article' for key 1 - INSERT INTO spipva_documents_liens (id_objet,objet,id_document,vu) VALUES (1065,'article',1915,'oui')

dans prive_mysql.log

Apr 28 10:28:16 193.251.176.*** (pid 14852) Unknown column 'agenda' in 'field list' -
SELECT agenda
FROM `Apr 28 10:28:16 193.251.176.253 (pid 14852) Unknown column 'agenda' in 'field list' -
SELECT agenda
FROM `nom_de_la_base`.spipva_rubriques
WHERE id_rubrique=17
Apr 28 10:28:16 193.251.176/*** (pid 14852) Unknown column 'agenda' in 'field list' -
SELECT agenda
FROM spip_rubriques
WHERE id_rubrique=17
Apr 28 10:28:16 193.251.176.*** (pid 14852) Unknown column 'agenda' in 'where clause' -
SELECT COUNT(*)
FROM `Apr 28 10:28:16 193.251.176.253 (pid 14852) Unknown column 'agenda' in 'field list' -
SELECT agenda
FROM `nom_de_la_base`.spipva_rubriques
WHERE id_rubrique=17
Apr 28 10:28:16 193.251.176.*** (pid 14852) Unknown column 'agenda' in 'field list' -
SELECT agenda
FROM spip_rubriques
WHERE id_rubrique=17
Apr 28 10:28:16 193.251.176.*** (pid 14852) Unknown column 'agenda' in 'where clause' -
SELECT COUNT(*)
FROM `nom_de_la_base`.spipva_rubriques
WHERE agenda=1`.spipva_rubriques
WHERE id_rubrique=17
Apr 28 10:28:16 193.251.176.*** (pid 14852) Unknown column 'agenda' in 'field list' -
SELECT agenda
FROM spip_rubriques
WHERE id_rubrique=17
Apr 28 10:28:16 193.251.176.*** (pid 14852) Unknown column 'agenda' in 'where clause' -
SELECT COUNT(*)
FROM `Apr 28 10:28:16 193.251.176.*** (pid 14852) Unknown column 'agenda' in 'field list' -
SELECT agenda
FROM `nom_de_la_base`.spipva_rubriques
WHERE id_rubrique=17
Apr 28 10:28:16 193.251.176.*** (pid 14852) Unknown column 'agenda' in 'field list' -
SELECT agenda
FROM spip_rubriques
WHERE id_rubrique=17
Apr 28 10:28:16 193.251.176.*** (pid 14852) Unknown column 'agenda' in 'where clause' -
SELECT COUNT(*)
FROM `nom_de_la_base`.spipva_rubriques
WHERE agenda=1`.spipva_rubriques
WHERE agenda=1
Apr 28 10:45:10 193.251.176.*** (pid 28229) Table './nom_de_la_base/spipva_visites_articles' is marked as crashed and last (automatic?) repair failed -
SELECT COUNT(*)
FROM `nom_de_la_base`.spipva_visites_articles
WHERE id_article=34 AND date='2010-04-28'
Apr 28 10:45:10 193.251.176.*** (pid 28229) Table './nom_de_la_base/spipva_visites_articles' is marked as crashed and last (automatic?) repair failed -
SELECT COUNT(*)
FROM spip_visites_articles
WHERE id_article=34 AND date='2010-04-28'
Apr 28 10:45:10 193.251.176.*** (pid 28229) Table './nom_de_la_base/spipva_visites_articles' is marked as crashed and last (automatic?) repair failed - INSERT INTO spipva_visites_articles (id_article,visites,date) VALUES (34,0,'2010-04-28')
Apr 28 10:45:10 193.251.176.*** (pid 28229) Table './nom_de_la_base/spipva_visites_articles' is marked as crashed and last (automatic?) repair failed -
UPDATE `nom_de_la_base`.spipva_visites_articles
SET visites=visites+1
WHERE date='2010-04-28' AND ((id_article IN (34)))

dans prive_spip.log

Apr 28 11:10:57 193.251.176.*** (pid 18544) Erreur mysql 144
Apr 28 11:10:57 193.251.176.*** (pid 18544) Table './nom_de_la_base/spipva_visites_articles' is marked as crashed and last (automatic?) repair failed -
SELECT COUNT(*)
FROM spip_visites_articles
WHERE id_article=184 AND date='2010-04-28'
Apr 28 11:10:57 193.251.176.*** (pid 18544) Erreur systeme 144
Apr 28 11:10:57 193.251.176.*** (pid 18544) Erreur SQL: <tt><br /><br /><blink>Erreur syst&egrave;me (errno 144)</blink><br />
<b>Le disque dur est peut-&ecirc;tre plein, ou la base de donn&eacute;es endommag&eacute;e. <br />
    <font color='red'>Essayez de <a href='http://www.ville-****.fr/ecrire/?exec=admin_repair'>r&eacute;parer la base</a>,
    ou contactez votre h&eacute;bergeur.</font></b><br /> | ()
Apr 28 11:10:57 193.251.176.*** (pid 18544) Erreur mysql 144
Apr 28 11:10:57 193.251.176.*** (pid 18544) Table './nom_de_la_base/spipva_visites_articles' is marked as crashed and last (automatic?) repair failed - INSERT INTO spipva_visites_articles (id_article,visites,date) VALUES (184,0,'2010-04-28')
Apr 28 11:10:57 193.251.176.*** (pid 18544) Erreur mysql 144
Apr 28 11:10:57 193.251.176.*** (pid 18544) Table './nom_de_la_base/spipva_visites_articles' is marked as crashed and last (automatic?) repair failed -
SELECT COUNT(*)
FROM `nom_de_la_base`.spipva_visites_articles
WHERE id_article=983 AND date='2010-04-28'

Pour finir je suis dans phpmyadmin pour effectuer une réparation de base de donnée.

J'attends de voir si les erreurs reviennent !

merci

nicolas

_______________________________________________
spip-zone@rezo.net - http://listes.rezo.net/mailman/listinfo/spip-zone