- Accueil
- » Forum
- » Serveurs
- » Mysql à planté
Pages : 1
#1 Le 11/07/2013, à 13:14
- gisclace
Mysql à planté
Bonjour à tous, je rencontre un problème depuis peut.
Hier soir mes différents serveurs tournant avec mysql fonctionnaient niquel, ce midi, en essayant de me connecter sur Owncloud (utilisateur sur bdd mysql) impossible de me connecter, je lance ssh, et fais un reboot.
Et là, c'est le drame.
Impossible de re-lancer mysql depuis...
Entre deux je n'ai pas fait d'update, je n'ai pas déplacé de fichiers....
Quand je fais : sudo service mysql start
j’obtiens : start: Job failed to start
et quand j'essaye de me connecter à mysql avec : mysql -u root
j’obtiens : ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
En effet le fichier var/run/mysqld/ est vide, mais je ne comprends pas comment ça ce fait qu'il se soit supprimé entre hier soir et ce matin ou que tout à coup mysql cherche un fichier qu'il ne cherchait pas jusqu'à présent....
Merci d'avance à celui/celle qui pourra m'aider à fixer mon problème.
Hors ligne
#2 Le 11/07/2013, à 15:09
- tiramiseb
Re : Mysql à planté
Salut,
Que disent les logs de MySQL pour le moment du plantage ?
PS :
je lance ssh, et fais un reboot
Mauvais réflexe.
Sébastien Maccagnoni - https://www.maccagnoni.eu - https://www.domotego.com
Hors ligne
#3 Le 12/07/2013, à 08:50
- gisclace
Re : Mysql à planté
Bonjour,
C'est bizarre je n'ai rien dans les logs.... (/var/log/mysql.log / mysql.err )
Phénomène étrange, ce matin j'arrive à me loguer sur owncloud, alors qu'hier ça ne marchait pas...
Donc j'ai l'impression qu'en gros par moment il marche, et par moment non....
Comment faire pour voir ce qui se passe (si mes log sont vide (ce qui est étrange non ?)) et fixer le tout ?
Hors ligne
#4 Le 12/07/2013, à 09:56
- tiramiseb
Re : Mysql à planté
Et si tu fais :
service mysql stop
puis :
mysqld
ça dit quoi ?
Sébastien Maccagnoni - https://www.maccagnoni.eu - https://www.domotego.com
Hors ligne
#5 Le 12/07/2013, à 10:50
- gisclace
Re : Mysql à planté
service mysql stop :
stop: Unknown instance:
Mysqld :
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
^CInnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
^XInnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
^X^CInnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
130712 11:12:27 InnoDB: Unable to open the first data file
InnoDB: Error in opening ./ibdata1
130712 11:12:27 InnoDB: Operating system error number 11 in a file operation.
InnoDB: Error number 11 means 'Resource temporarily unavailable'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.html
130712 11:12:27 InnoDB: Could not open or create data files.
130712 11:12:27 InnoDB: If you tried to add new data files, and it failed here,
130712 11:12:27 InnoDB: you should now edit innodb_data_file_path in my.cnf back
130712 11:12:27 InnoDB: to what it was, and remove the new ibdata files InnoDB created
130712 11:12:27 InnoDB: in this failed attempt. InnoDB only wrote those files full of
130712 11:12:27 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
130712 11:12:27 InnoDB: remove old data files which contain your precious data!
130712 11:12:27 [ERROR] Plugin 'InnoDB' init function returned error.
130712 11:12:27 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
130712 11:12:27 [ERROR] Unknown/unsupported storage engine: InnoDB
130712 11:12:27 [ERROR] Aborting
130712 11:12:27 [Note] mysqld: Shutdown complete
J'ai voulu profiter que ça semblait fonctionner pour ajouter un truc, j'ai réussis à créer une nouvelle bdd, donner les droits à l’utilisateur... par contre, au moment de créer les tables, j’obtiens une erreur:
L'installation a échouée pour la raison suivante :
Une erreur s'est produite durant la création des tables : [#39 - ALTER TABLE igal3_basket ADD CONSTRAINT igal3_...] SQLSTATE[HY000]: General error: 1114 The table 'igal3_basket' is full
Du coup je me demande si c'est pas le serveur qui est saturé plutôt que mysql qui est bugé
Hors ligne
#6 Le 12/07/2013, à 10:52
- tiramiseb
Re : Mysql à planté
J'ai voulu profiter que ça semblait fonctionner
Pour toi, ça ça veut dire que ça fonctionne !?
130712 11:12:27 [ERROR] Plugin 'InnoDB' init function returned error.
130712 11:12:27 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
130712 11:12:27 [ERROR] Unknown/unsupported storage engine: InnoDB
130712 11:12:27 [ERROR] Aborting
Peut-être que c'est un problème de disque...
Que donne la commande suivante ?
dmesg | tail -n 20
Sébastien Maccagnoni - https://www.maccagnoni.eu - https://www.domotego.com
Hors ligne
#7 Le 12/07/2013, à 10:55
- gisclace
Re : Mysql à planté
Pour toi, ça ça veut dire que ça fonctionne !?
130712 11:12:27 [ERROR] Plugin 'InnoDB' init function returned error. 130712 11:12:27 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 130712 11:12:27 [ERROR] Unknown/unsupported storage engine: InnoDB 130712 11:12:27 [ERROR] Aborting
Non ^_^ mais j'ai fait la bdd avant de tester cette commande, je ne suis pas un as en sql, pour moi, quand je peux lancer sql et faire ce que j'ai à faire c'est que ça marche.
Retour de la commande :
EXT4-fs (xvda1): couldn't mount as ext3 due to feature incompatibilities
EXT4-fs (xvda1): couldn't mount as ext2 due to feature incompatibilities
EXT4-fs (xvda1): mounted filesystem with ordered data mode. Opts: (null)
VFS: Mounted root (ext4 filesystem) readonly on device 202:1.
devtmpfs: mounted
Freeing unused kernel memory: 396k freed
Write protecting the kernel read-only data: 6144k
Freeing unused kernel memory: 784k freed
Freeing unused kernel memory: 1164k freed
udevd[380]: starting version 175
EXT4-fs (xvda1): re-mounted. Opts: errors=remount-ro
init: udev-fallback-graphics main process (763) terminated with status 1
init: failsafe main process (781) killed by TERM signal
NET: Registered protocol family 10
init: mysql pre-start process (885) terminated with status 1
Adding 370684k swap on /dev/xvda2. Priority:-1 extents:1 across:370684k SS
tinyproxy[1334]: segfault at 7fffb5ddfff8 ip 00007fe3d6e2506e sp 00007fffb5de0000 error 6 in libc-2.15.so[7fe3d6da9000+1b5000]
Setting capacity to 20971520
xvda1: detected capacity change from 3221225472 to 10737418240
VFS: busy inodes on changed media or resized disk xvda1
Pour info, ce serveur est hébergé chez Gandi
Hors ligne
#8 Le 12/07/2013, à 10:58
- tiramiseb
Re : Mysql à planté
Il y a des trucs bizarres, comme :
tinyproxy[1334]: segfault at 7fffb5ddfff8 ip 00007fe3d6e2506e sp 00007fffb5de0000 error 6 in libc-2.15.so[7fe3d6da9000+1b5000]
Mais pas de lien direct évident avec MySQL.
Que donnent les commandes suivantes ?
mount
ls -lh /var/lib/mysql
touch /var/lib/mysql/la_tete_a_toto
rm /var/lib/mysql/la_tete_a_toto
Sébastien Maccagnoni - https://www.maccagnoni.eu - https://www.domotego.com
Hors ligne
#9 Le 12/07/2013, à 11:02
- gisclace
Re : Mysql à planté
[hs]J'ai pleins de problèmes avec Tiny proxy, je vais le virer d’ailleurs[/hs]
mount :
/dev/xvda1 on / type ext4 (rw,noatime,errors=remount-ro)
none on /proc type proc (rw,noexec,nosuid)
none on /sys type sysfs (rw,noexec,nosuid,nodev)
none on /sys/kernel/debug type debugfs (rw)
none on /sys/kernel/security type securityfs (rw)
devtmpfs on /dev type devtmpfs (rw,mode=0755)
devpts on /dev/pts type devpts (rw)
none on /run type tmpfs (rw,noexec,nosuid,size=10%,mode=0755)
none on /run/lock type tmpfs (rw,noexec,nosuid,nodev,size=5242880)
none on /run/shm type tmpfs (rw,nosuid,nodev)
tmpfs on /var/gandi type tmpfs (rw,relatime,size=24k,mode=755)
overflow on /tmp type tmpfs (rw,size=1048576,mode=1777)
ls -lh /var/lib/mysql:
total 37M
drwx------ 2 mysql mysql 4.0K May 1 16:12 agora
-rw-r--r-- 1 mysql mysql 0 May 4 16:15 debian-5.5.flag
-rw-rw---- 1 mysql mysql 5.0M Jul 12 11:49 ib_logfile0
-rw-rw---- 1 mysql mysql 5.0M Jul 12 11:49 ib_logfile1
-rw-rw---- 1 mysql mysql 26M Jul 12 11:49 ibdata1
drwx------ 2 mysql mysql 4.0K Jul 12 11:49 jupho
drwx------ 2 mysql mysql 4.0K Mar 26 15:22 mail
drwx------ 2 mysql mysql 4.0K Jun 3 14:26 mail2
drwx------ 2 mysql mysql 4.0K May 4 16:15 mysql
-rw-rw---- 1 mysql mysql 6 May 4 16:15 mysql_upgrade_info
drwx------ 2 mysql mysql 4.0K May 4 16:15 performance_schema
drwx------ 2 mysql mysql 4.0K Jul 11 13:13 photo
drwx------ 2 mysql mysql 4.0K Feb 7 21:01 phpmyadmin
touch /var/lib/mysql/la_tete_a_toto : rien
rm /var/lib/mysql/la_tete_a_toto : rien
(enfin ça créer et efface la_tete_a_toto)
Hors ligne
#10 Le 12/07/2013, à 11:05
- tiramiseb
Re : Mysql à planté
Bon, ça n'a pas l'air d'être un problème de disque alors (d'autant plus que ce risque est largement réduit sur un système virtualisé comme ceux de Gandi).
Es-tu sûr que mysql est bien arrêté ?
ps auxw | grep mysql
Sébastien Maccagnoni - https://www.maccagnoni.eu - https://www.domotego.com
Hors ligne
#11 Le 12/07/2013, à 11:07
- gisclace
Re : Mysql à planté
non il n'est pas arrêté, service mysql stop, ne passe pas :
root@bip:/var/lib/mysql# service mysql stop
stop: Unknown instance:
Hors ligne
#12 Le 12/07/2013, à 11:12
- tiramiseb
Re : Mysql à planté
Et sinon, le résultat de la commande que j'ai demandée, ça donne quoi ?
Sébastien Maccagnoni - https://www.maccagnoni.eu - https://www.domotego.com
Hors ligne
#13 Le 12/07/2013, à 11:55
- gisclace
Re : Mysql à planté
Ha oui :
root 1459 0.0 0.1 36092 1564 ? S Jul11 0:00 sudo /usr/sbin mysqld
mysql 1460 0.0 7.0 1087488 61320 ? Sl Jul11 0:19 /usr/sbin/mysq d
root 5491 0.0 0.0 6504 624 pts/2 S+ 12:54 0:00 grep --color=auto mysql
Hors ligne
#14 Le 12/07/2013, à 11:56
- tiramiseb
Re : Mysql à planté
Ensuite que donnent :
kill 1459
kill 1460
ps auxw | grep mysql
Sébastien Maccagnoni - https://www.maccagnoni.eu - https://www.domotego.com
Hors ligne
#15 Le 12/07/2013, à 11:58
- gisclace
Re : Mysql à planté
Pour kill 1459 : ça passe
pour kill 1460 :
bash: kill: (1460) - No such process
sortie de ps auxw | grep mysql :
root 5494 0.0 0.0 6504 624 pts/2 S+ 12:57 0:00 grep --color=au to mysql
Hors ligne
#16 Le 12/07/2013, à 11:59
- tiramiseb
Re : Mysql à planté
Et si tu relances mysql proprement ensuite ?
service mysql start
puis
ps auxw | grep mysql
Sébastien Maccagnoni - https://www.maccagnoni.eu - https://www.domotego.com
Hors ligne
#17 Le 12/07/2013, à 12:01
- gisclace
Re : Mysql à planté
lancement :
mysql start/running, process 5506
sortie :
mysql 5506 1.8 6.3 549972 55476 ? Ssl 13:00 0:00 /usr/sbin/mysqld
root 5697 0.0 0.0 6504 628 pts/2 S+ 13:00 0:00 grep --color=auto mysql
Hors ligne
#18 Le 12/07/2013, à 12:02
- tiramiseb
Re : Mysql à planté
Et maintenant, ça marche ou toujours pas ?
Sébastien Maccagnoni - https://www.maccagnoni.eu - https://www.domotego.com
Hors ligne
#19 Le 12/07/2013, à 12:05
- gisclace
Re : Mysql à planté
En fait depuis ce matin ça "fonctionne", je peux me loguer sur mes serveurs, j'ai créé une bdd...
Par contre ce qui ne marche toujours pas c'est l'écriture de tables.
Je veux installer Igalerie (http://www.igalerie.org/), que j'ai déjà installé sur un autre serveur sans soucis, je rentre les infos demandés (localhost, login, mdp nom de bdd...)
Et j'ai en sortie :
L'installation a échouée pour la raison suivante :
Une erreur s'est produite durant la création des tables : [#39 - ALTER TABLE igal2_basket ADD CONSTRAINT igal2_...] SQLSTATE[HY000]: General error: 1114 The table 'igal2_basket' is full
Hors ligne
#20 Le 12/07/2013, à 13:44
- tiramiseb
Re : Mysql à planté
Il y a assez d'espace libre sur le disque ?
Sinon, que donne
grep innodb /etc/mysql/my.cnf
?
Dernière modification par tiramiseb (Le 12/07/2013, à 13:44)
Sébastien Maccagnoni - https://www.maccagnoni.eu - https://www.domotego.com
Hors ligne
#21 Le 12/07/2013, à 13:53
- gisclace
Re : Mysql à planté
grep innodb /etc/mysql/my.cnf ne sort rien
Pour ce qui est de l'espace disque, en tapant : df -h | grep '^/'
/dev/xvda1 3.0G 2.5G 331M 89% /
(J'ai 10go normalement...)
Hors ligne
#22 Le 12/07/2013, à 13:55
- tiramiseb
Re : Mysql à planté
If a table-full error occurs, it may be that the disk is full or that the table has reached its maximum size.
Et que donne :
df -i
?
Sébastien Maccagnoni - https://www.maccagnoni.eu - https://www.domotego.com
Hors ligne
#23 Le 12/07/2013, à 13:58
- gisclace
Re : Mysql à planté
Ça me donne :
Filesystem Inodes IUsed IFree IUse% Mounted on
/dev/xvda1 196608 63803 132805 33% /
devtmpfs 92235 340 91895 1% /dev
none 92528 234 92294 1% /run
none 92528 3 92525 1% /run/lock
none 92528 1 92527 1% /run/shm
tmpfs 92528 5 92523 1% /var/gandi
overflow 92528 11 92517 1% /tmp
Hors ligne
#24 Le 12/07/2013, à 14:12
- tiramiseb
Re : Mysql à planté
Bon ben il faut te pencher vers la possibilité « the table has reached its maximum size ».
Voir les configs innodb, etc... Là je ne saurais pas t'aider par le forum...
Sébastien Maccagnoni - https://www.maccagnoni.eu - https://www.domotego.com
Hors ligne
#25 Le 12/07/2013, à 14:16
- gisclace
Re : Mysql à planté
ok, je vais essayer de me pencher dessus.
Merci de ton coup de main
Hors ligne
Pages : 1