### Query1 ### SELECT u.idutilisateur AS id, IF( MAX( IF(a.dateDeDebut <= NOW() AND a.dateDeFin >= NOW(), 1, 0)) = 1, TRUE, FALSE) AS subscriber, u.nom AS nom, u.prenom AS prenom, IF (u.sexe='M', 'Homme', 'Femme') AS sexe, ch.libeleFR AS cheveux, y.libeleFR AS yeux, ta.libeleFR AS age, p.nom AS pays, GROUP_CONCAT( DISTINCT l.nom_fr, ': ', ELT(cl.niveau, 'notion', 'courant', 'bilingue') ORDER BY l.nom_fr SEPARATOR ' - ' ) AS langues FROM utilisateur u JOIN comedien c ON u.idutilisateur=c.idutilisateur LEFT JOIN adhesion a ON c.idutilisateur=a.idutilisateur JOIN trancheAge ta ON c.idtrancheAge=ta.idtrancheAge JOIN couleurCheveux ch ON ch.idcouleurCheveux=c.idcouleurCheveux JOIN couleurYeux y ON y.idcouleurYeux = c.idcouleurYeux JOIN pays p ON p.idpays = u.idpays LEFT JOIN comedien_has_langue cl ON cl.idutilisateur=c.idutilisateur LEFT JOIN langue l ON l.idlangue = cl.idlangue WHERE a.dateDeDebut <= NOW() AND a.dateDeFin >= NOW() AND u.prenom='Olivier' AND u.sexe = 'M' AND 2 IN (SELECT l.idlangue FROM langue l JOIN comedien_has_langue cal USING(idlangue) WHERE cal.idutilisateur=u.idutilisateur) GROUP BY id ORDER BY subscriber DESC, u.nom, u.prenom, u.idutilisateur LIMIT 0, 10 ### Explain of query1 ### +----+--------------------+-------+--------+---------------------------------------------------+---------------+---------+-----------------------------+------+-----------------------------------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+--------------------+-------+--------+---------------------------------------------------+---------------+---------+-----------------------------+------+-----------------------------------------------------+ | 1 | PRIMARY | u | ref | PRIMARY,prenom,pays | prenom | 32 | const | 53 | Using where; Using temporary; Using filesort | | 1 | PRIMARY | p | eq_ref | PRIMARY | PRIMARY | 1 | comoedia.u.idpays | 1 | | | 1 | PRIMARY | a | ref | debut,fin,idutilisateur | idutilisateur | 3 | comoedia.u.idutilisateur | 2 | Using where | | 1 | PRIMARY | c | eq_ref | PRIMARY,trancheAge,couleurYeuxId,couleurCheveuxId | PRIMARY | 3 | comoedia.u.idutilisateur | 1 | | | 1 | PRIMARY | ta | eq_ref | PRIMARY | PRIMARY | 1 | comoedia.c.idtrancheAge | 1 | | | 1 | PRIMARY | y | eq_ref | PRIMARY | PRIMARY | 1 | comoedia.c.idcouleurYeux | 1 | | | 1 | PRIMARY | ch | eq_ref | PRIMARY | PRIMARY | 1 | comoedia.c.idcouleurCheveux | 1 | | | 1 | PRIMARY | cl | ref | comedienId | comedienId | 3 | comoedia.c.idutilisateur | 2 | | | 1 | PRIMARY | l | eq_ref | PRIMARY | PRIMARY | 1 | comoedia.cl.idlangue | 1 | | | 2 | DEPENDENT SUBQUERY | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables | +----+--------------------+-------+--------+---------------------------------------------------+---------------+---------+-----------------------------+------+-----------------------------------------------------+ ### Query2 ### SELECT u.idutilisateur AS id, IF( MAX( IF(a.dateDeDebut <= NOW() AND a.dateDeFin >= NOW(), 1, 0)) = 1, TRUE, FALSE) AS subscriber, u.nom AS nom, u.prenom AS prenom, IF (u.sexe='M', 'Homme', 'Femme') AS sexe, ch.libeleFR AS cheveux, y.libeleFR AS yeux, ta.libeleFR AS age, p.nom AS pays, GROUP_CONCAT( DISTINCT l.nom_fr, ': ', ELT(cl.niveau, 'notion', 'courant', 'bilingue') ORDER BY l.nom_fr SEPARATOR ' - ' ) AS langues FROM utilisateur u JOIN comedien c ON u.idutilisateur=c.idutilisateur LEFT JOIN adhesion a ON c.idutilisateur=a.idutilisateur JOIN trancheAge ta ON c.idtrancheAge=ta.idtrancheAge JOIN couleurCheveux ch ON ch.idcouleurCheveux=c.idcouleurCheveux JOIN couleurYeux y ON y.idcouleurYeux = c.idcouleurYeux JOIN pays p ON p.idpays = u.idpays LEFT JOIN comedien_has_langue cl ON cl.idutilisateur=c.idutilisateur LEFT JOIN langue l ON l.idlangue = cl.idlangue WHERE a.dateDeDebut <= NOW() AND a.dateDeFin >= NOW() AND u.prenom='Olivier' AND u.sexe = 'M' AND (SELECT count(l.idlangue) FROM langue l JOIN comedien_has_langue cal USING(idlangue) WHERE cal.idutilisateur=u.idutilisateur and l.idlangue=2) > 0 GROUP BY id ORDER BY subscriber DESC, u.nom, u.prenom, u.idutilisateur LIMIT 0, 10 ### Explain of query2 ### +----+--------------------+-------+--------+---------------------------------------------------+---------------+---------+--------------------------------+------+----------------------------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+--------------------+-------+--------+---------------------------------------------------+---------------+---------+--------------------------------+------+----------------------------------------------+ | 1 | PRIMARY | u | ref | PRIMARY,prenom,pays | prenom | 32 | const | 53 | Using where; Using temporary; Using filesort | | 1 | PRIMARY | p | eq_ref | PRIMARY | PRIMARY | 1 | comoedia.u.idpays | 1 | | | 1 | PRIMARY | a | ref | debut,fin,idutilisateur | idutilisateur | 3 | comoedia.u.idutilisateur | 2 | Using where | | 1 | PRIMARY | c | eq_ref | PRIMARY,trancheAge,couleurYeuxId,couleurCheveuxId | PRIMARY | 3 | comoedia.u.idutilisateur | 1 | | | 1 | PRIMARY | ta | eq_ref | PRIMARY | PRIMARY | 1 | comoedia.c.idtrancheAge | 1 | | | 1 | PRIMARY | y | eq_ref | PRIMARY | PRIMARY | 1 | comoedia.c.idcouleurYeux | 1 | | | 1 | PRIMARY | ch | eq_ref | PRIMARY | PRIMARY | 1 | comoedia.c.idcouleurCheveux | 1 | | | 1 | PRIMARY | cl | ref | comedienId | comedienId | 3 | comoedia.c.idutilisateur | 2 | | | 1 | PRIMARY | l | eq_ref | PRIMARY | PRIMARY | 1 | comoedia.cl.idlangue | 1 | | | 2 | DEPENDENT SUBQUERY | l | const | PRIMARY | PRIMARY | 1 | const | 1 | Using index | | 2 | DEPENDENT SUBQUERY | cal | eq_ref | PRIMARY,comedienId | PRIMARY | 4 | const,comoedia.u.idutilisateur | 1 | Using index | +----+--------------------+-------+--------+---------------------------------------------------+---------------+---------+--------------------------------+------+----------------------------------------------+ ### Error log on master server ### Jan 3 10:25:23 boo249027 mysqld[29485]: mysqld got signal 11; Jan 3 10:25:23 boo249027 mysqld[29485]: This could be because you hit a bug. It is also possible that this binary Jan 3 10:25:23 boo249027 mysqld[29485]: or one of the libraries it was linked against is corrupt, improperly built, Jan 3 10:25:23 boo249027 mysqld[29485]: or misconfigured. This error can also be caused by malfunctioning hardware. Jan 3 10:25:23 boo249027 mysqld[29485]: We will try our best to scrape up some info that will hopefully help diagnose Jan 3 10:25:23 boo249027 mysqld[29485]: the problem, but since we have already crashed, something is definitely wrong Jan 3 10:25:23 boo249027 mysqld[29485]: and this may fail. Jan 3 10:25:23 boo249027 mysqld[29485]: Jan 3 10:25:23 boo249027 mysqld[29485]: key_buffer_size=16777216 Jan 3 10:25:23 boo249027 mysqld[29485]: read_buffer_size=131072 Jan 3 10:25:23 boo249027 mysqld[29485]: max_used_connections=10 Jan 3 10:25:23 boo249027 mysqld[29485]: max_connections=100 Jan 3 10:25:23 boo249027 mysqld[29485]: threads_connected=4 Jan 3 10:25:23 boo249027 mysqld[29485]: It is possible that mysqld could use up to Jan 3 10:25:23 boo249027 mysqld[29485]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 233983 K Jan 3 10:25:23 boo249027 mysqld[29485]: bytes of memory Jan 3 10:25:23 boo249027 mysqld[29485]: Hope that's ok; if not, decrease some variables in the equation. Jan 3 10:25:23 boo249027 mysqld[29485]: Jan 3 10:25:23 boo249027 mysqld[29485]: thd=0x8ae1de8 Jan 3 10:25:23 boo249027 mysqld[29485]: Attempting backtrace. You can use the following information to find out Jan 3 10:25:23 boo249027 mysqld[29485]: where mysqld died. If you see no messages after this, something went Jan 3 10:25:23 boo249027 mysqld[29485]: terribly wrong... Jan 3 10:25:23 boo249027 mysqld[29485]: Cannot determine thread, fp=0xbe3fef18, backtrace may not be correct. Jan 3 10:25:23 boo249027 mysqld[29485]: Stack range sanity check OK, backtrace follows: Jan 3 10:25:23 boo249027 mysqld[29485]: 0x81be4c4 Jan 3 10:25:23 boo249027 mysqld[29485]: 0x4005c825 Jan 3 10:25:23 boo249027 mysqld[29485]: (nil) Jan 3 10:25:23 boo249027 mysqld[29485]: 0x81b05de Jan 3 10:25:23 boo249027 mysqld[29485]: 0x81dad56 Jan 3 10:25:23 boo249027 mysqld[29485]: 0x81d15c7 Jan 3 10:25:23 boo249027 mysqld[29485]: 0x81d10ed Jan 3 10:25:23 boo249027 mysqld[29485]: 0x81d0512 Jan 3 10:25:23 boo249027 mysqld[29485]: 0x40056e51 Jan 3 10:25:23 boo249027 mysqld[29485]: 0x402a18aa Jan 3 10:25:23 boo249027 mysqld[29485]: New value of fp=(nil) failed sanity check, terminating stack trace! Jan 3 10:25:23 boo249027 mysqld[29485]: Please read http://dev.mysql.com/doc/mysql/en/using-stack-trace.html and follow instructions on how to resolve the stack trace. Resolved Jan 3 10:25:23 boo249027 mysqld[29485]: stack trace is much more helpful in diagnosing the problem, so please do Jan 3 10:25:23 boo249027 mysqld[29485]: resolve it Jan 3 10:25:23 boo249027 mysqld[29485]: Trying to get some variables. Jan 3 10:25:23 boo249027 mysqld[29485]: Some pointers may be invalid and cause the dump to abort... Jan 3 10:25:23 boo249027 mysqld[29485]: thd->query at 0x8ba8668 = SELECT Jan 3 10:25:23 boo249027 mysqld[29485]: u.idutilisateur AS id, Jan 3 10:25:23 boo249027 mysqld[29485]: IF( MAX( IF(a.dateDeDebut <= NOW() AND a.dateDeFin >= NOW(), 1, 0)) = 1, TRUE, FALSE) AS subscriber Jan 3 10:25:23 boo249027 mysqld[29485]: Jan 3 10:25:23 boo249027 mysqld[29485]: , Jan 3 10:25:23 boo249027 mysqld[29485]: u.nom AS nom, Jan 3 10:25:23 boo249027 mysqld[29485]: u.prenom AS prenom, Jan 3 10:25:23 boo249027 mysqld[29485]: IF (u.sexe='M', 'Homme', 'Femme') AS sexe, Jan 3 10:25:23 boo249027 mysqld[29485]: ch.libeleFR AS cheveux, Jan 3 10:25:23 boo249027 mysqld[29485]: y.libeleFR AS yeux, Jan 3 10:25:23 boo249027 mysqld[29485]: ta.libeleFR AS age, Jan 3 10:25:23 boo249027 mysqld[29485]: p.nom AS pays, Jan 3 10:25:23 boo249027 mysqld[29485]: GROUP_CONCAT( DISTINCT Jan 3 10:25:23 boo249027 mysqld[29485]: l.nom_fr, Jan 3 10:25:23 boo249027 mysqld[29485]: ': ', Jan 3 10:25:23 boo249027 mysqld[29485]: ELT(cl.niveau, 'notion', 'courant', 'bilingue') Jan 3 10:25:23 boo249027 mysqld[29485]: ORDER BY l.nom_fr Jan 3 10:25:23 boo249027 mysqld[29485]: SEPARATOR ' - ' Jan 3 10:25:23 boo249027 mysqld[29485]: ) AS langues Jan 3 10:25:23 boo249027 mysqld[29485]: Jan 3 10:25:23 boo249027 mysqld[29485]: FROM Jan 3 10:25:23 boo249027 mysqld[29485]: utilisateur u Jan 3 10:25:23 boo249027 mysqld[29485]: JOIN comedien c ON u.idutilisateur=c.idutilisateur Jan 3 10:25:23 boo249027 mysqld[29485]: LEFT JOIN adhesion a ON c.idutilisateur=a.idutilisateur Jan 3 10:25:23 boo249027 mysqld[29485]: JOIN trancheAge ta ON c.idtrancheAge=ta.idtrancheAge Jan 3 10:25:23 boo249027 mysqld[29485]: JOIN couleurCheveux ch ON ch.idcouleurCheveux=c.idcouleurCheveux Jan 3 10:25:23 boo249027 mysqld[29485]: JOIN couleurYeux y ON y.idcouleurYeux = c.idcouleurYeux Jan 3 10:25:23 boo249027 mysqld[29485]: JOIN pays p ON p.idpays = u.idpays Jan 3 10:25:23 boo249027 mysqld[29485]: LEFT JOIN comedien_has_langue cl ON cl.idutilisateur=c.idutilisateur Jan 3 10:25:23 boo249027 mysqld[29485]: LEFT JOIN langue l ON l.idlangue = cl.idlang Jan 3 10:25:23 boo249027 mysqld[29485]: thd->thread_id=2229 Jan 3 10:25:23 boo249027 mysqld[29485]: The manual page at http://www.mysql.com/doc/en/Crashing.html contains Jan 3 10:25:23 boo249027 mysqld[29485]: information that should help you find out what is causing the crash. Jan 3 10:25:23 boo249027 mysqld_safe[2513]: Number of processes running now: 0 Jan 3 10:25:23 boo249027 mysqld_safe[2515]: restarted Jan 3 10:25:23 boo249027 mysqld[2518]: 070103 10:25:23 InnoDB: Database was not shut down normally! Jan 3 10:25:23 boo249027 mysqld[2518]: InnoDB: Starting crash recovery. Jan 3 10:25:23 boo249027 mysqld[2518]: InnoDB: Reading tablespace information from the .ibd files... Jan 3 10:25:23 boo249027 mysqld[2518]: InnoDB: Restoring possible half-written data pages from the doublewrite Jan 3 10:25:23 boo249027 mysqld[2518]: InnoDB: buffer... Jan 3 10:25:23 boo249027 mysqld[2518]: 070103 10:25:23 InnoDB: Starting log scan based on checkpoint at Jan 3 10:25:23 boo249027 mysqld[2518]: InnoDB: log sequence number 0 8518250. Jan 3 10:25:23 boo249027 mysqld[2518]: InnoDB: Doing recovery: scanned up to log sequence number 0 8518250 Jan 3 10:25:23 boo249027 mysqld[2518]: InnoDB: Last MySQL binlog file position 0 1541428, file name /var/log/mysql/mysql-bin.000654 Jan 3 10:25:23 boo249027 mysqld[2518]: 070103 10:25:23 InnoDB: Started; log sequence number 0 8518250 Jan 3 10:25:23 boo249027 mysqld[2518]: 070103 10:25:23 [Note] Recovering after a crash using /var/log/mysql/mysql-bin Jan 3 10:25:23 boo249027 mysqld[2518]: 070103 10:25:23 [Note] Starting crash recovery... Jan 3 10:25:23 boo249027 mysqld[2518]: 070103 10:25:23 [Note] Crash recovery finished. Jan 3 10:25:23 boo249027 mysqld[2518]: 070103 10:25:23 [Note] /usr/sbin/mysqld: ready for connections. Jan 3 10:25:23 boo249027 mysqld[2518]: Version: '5.0.30-Debian_0.dotdeb.1-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Dotdeb Sarge backport ### Stack trace resolution on master ### 0x81be4c4 handle_segfault + 676 0x4005c825 _end + 932708533 (nil) 0x81b05de _ZN3THD19cleanup_after_queryEv + 62 0x81dad56 _Z11mysql_parseP3THDPcj + 246 0x81d15c7 _Z16dispatch_command19enum_server_commandP3THDPcj + 1159 0x81d10ed _Z10do_commandP3THD + 141 0x81d0512 handle_one_connection + 466 0x40056e51 _end + 932685537 0x402a18aa _end + 935088442 ### Error log on slave server ### Jan 3 11:28:31 deb3067 mysqld[26721]: mysqld got signal 11; Jan 3 11:28:31 deb3067 mysqld[26721]: This could be because you hit a bug. It is also possible that this binary Jan 3 11:28:31 deb3067 mysqld[26721]: or one of the libraries it was linked against is corrupt, improperly built, Jan 3 11:28:31 deb3067 mysqld[26721]: or misconfigured. This error can also be caused by malfunctioning hardware. Jan 3 11:28:31 deb3067 mysqld[26721]: We will try our best to scrape up some info that will hopefully help diagnose Jan 3 11:28:31 deb3067 mysqld[26721]: the problem, but since we have already crashed, something is definitely wrong Jan 3 11:28:31 deb3067 mysqld[26721]: and this may fail. Jan 3 11:28:31 deb3067 mysqld[26721]: Jan 3 11:28:31 deb3067 mysqld[26721]: key_buffer_size=16777216 Jan 3 11:28:31 deb3067 mysqld[26721]: read_buffer_size=131072 Jan 3 11:28:31 deb3067 mysqld[26721]: max_used_connections=1 Jan 3 11:28:31 deb3067 mysqld[26721]: max_connections=100 Jan 3 11:28:31 deb3067 mysqld[26721]: threads_connected=1 Jan 3 11:28:31 deb3067 mysqld[26721]: It is possible that mysqld could use up to Jan 3 11:28:31 deb3067 mysqld[26721]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 233983 K Jan 3 11:28:31 deb3067 mysqld[26721]: bytes of memory Jan 3 11:28:31 deb3067 mysqld[26721]: Hope that's ok; if not, decrease some variables in the equation. Jan 3 11:28:31 deb3067 mysqld[26721]: Jan 3 11:28:31 deb3067 mysqld[26721]: thd=0x8b52eb0 Jan 3 11:28:31 deb3067 mysqld[26721]: Attempting backtrace. You can use the following information to find out Jan 3 11:28:31 deb3067 mysqld[26721]: where mysqld died. If you see no messages after this, something went Jan 3 11:28:31 deb3067 mysqld[26721]: terribly wrong... Jan 3 11:28:31 deb3067 mysqld[26721]: Cannot determine thread, fp=0xb3f44f88, backtrace may not be correct. Jan 3 11:28:31 deb3067 mysqld[26721]: Stack range sanity check OK, backtrace follows: Jan 3 11:28:31 deb3067 mysqld[26721]: 0x81be4c4 Jan 3 11:28:31 deb3067 mysqld[26721]: (nil) Jan 3 11:28:31 deb3067 mysqld[26721]: 0x81b05de Jan 3 11:28:31 deb3067 mysqld[26721]: 0x81dad56 Jan 3 11:28:31 deb3067 mysqld[26721]: 0x81d15c7 Jan 3 11:28:31 deb3067 mysqld[26721]: 0x81d10ed Jan 3 11:28:31 deb3067 mysqld[26721]: 0x81d0512 Jan 3 11:28:31 deb3067 mysqld[26721]: 0xb7f81b63 Jan 3 11:28:31 deb3067 mysqld[26721]: 0xb7df918a Jan 3 11:28:31 deb3067 mysqld[26721]: New value of fp=(nil) failed sanity check, terminating stack trace! Jan 3 11:28:31 deb3067 mysqld[26721]: Please read http://dev.mysql.com/doc/mysql/en/using-stack-trace.html and follow instructions on how to resolve the stack trace. Resolved Jan 3 11:28:31 deb3067 mysqld[26721]: stack trace is much more helpful in diagnosing the problem, so please do Jan 3 11:28:31 deb3067 mysqld[26721]: resolve it Jan 3 11:28:31 deb3067 mysqld[26721]: Trying to get some variables. Jan 3 11:28:31 deb3067 mysqld[26721]: Some pointers may be invalid and cause the dump to abort... Jan 3 11:28:31 deb3067 mysqld[26721]: thd->query at 0x8b66c68 = SELECT u.idutilisateur AS id, IF( MAX( IF(a.dateDeDebut <= NOW() AND a.dateDeFin >= NOW(), 1, 0)) = 1, TRUE, FALSE) AS subscriber , u.nom AS nom, u.prenom AS prenom, IF (u.sexe='M', 'Homme', 'Femme') AS sexe, ch.libeleFR AS cheveux, y.libeleFR AS yeux, ta.libeleFR AS age, p.nom AS pays, GROUP_CONCAT( DISTINCT l.nom_fr, ': ', ELT(cl.niveau, 'notion', 'courant', 'bilingue') ORDER BY l.nom_fr SEPARATOR ' - ' ) AS langues FROM utilisateur u JOIN comedien c ON u.idutilisateur=c.idutilisateur LEFT JOIN adhesion a ON c.idutilisateur=a.idutilisateur JOIN trancheAge ta ON c.idtrancheAge=ta.idtrancheAge JOIN couleurCheveux ch ON ch.idcouleurCheveux=c.idcouleurCheveux JOIN couleurYeux y ON y.idcouleurYeux = c.idcouleurYeux JOIN pays p ON p.idpays = u.idpays LEFT JOIN comedien_has_langue cl ON cl.idutilisateur=c Jan 3 11:28:31 deb3067 mysqld[26721]: l ON l.idlangue = cl.idlang Jan 3 11:28:31 deb3067 mysqld[26721]: thd->thread_id=3 Jan 3 11:28:31 deb3067 mysqld[26721]: The manual page at http://www.mysql.com/doc/en/Crashing.html contains Jan 3 11:28:31 deb3067 mysqld[26721]: information that should help you find out what is causing the crash. Jan 3 11:28:31 deb3067 mysqld_safe[26763]: Number of processes running now: 0 Jan 3 11:28:31 deb3067 mysqld_safe[26765]: restarted Jan 3 11:28:31 deb3067 mysqld[26768]: 070103 11:28:31 InnoDB: Database was not shut down normally! Jan 3 11:28:31 deb3067 mysqld[26768]: InnoDB: Starting crash recovery. Jan 3 11:28:31 deb3067 mysqld[26768]: InnoDB: Reading tablespace information from the .ibd files... Jan 3 11:28:31 deb3067 mysqld[26768]: InnoDB: Restoring possible half-written data pages from the doublewrite Jan 3 11:28:31 deb3067 mysqld[26768]: InnoDB: buffer... Jan 3 11:28:31 deb3067 mysqld[26768]: 070103 11:28:31 InnoDB: Starting log scan based on checkpoint at Jan 3 11:28:31 deb3067 mysqld[26768]: InnoDB: log sequence number 0 8417122. Jan 3 11:28:31 deb3067 mysqld[26768]: InnoDB: Doing recovery: scanned up to log sequence number 0 8417122 Jan 3 11:28:31 deb3067 mysqld[26768]: InnoDB: In a MySQL replication slave the last master binlog file Jan 3 11:28:31 deb3067 mysqld[26768]: InnoDB: position 0 726, file name mysql-bin.000654 Jan 3 11:28:31 deb3067 mysqld[26768]: InnoDB: Last MySQL binlog file position 0 12520, file name /var/log/mysql/mysql-bin.000107 Jan 3 11:28:31 deb3067 mysqld[26768]: 070103 11:28:31 InnoDB: Started; log sequence number 0 8417122 Jan 3 11:28:31 deb3067 mysqld[26768]: 070103 11:28:31 [Note] Recovering after a crash using /var/log/mysql/mysql-bin Jan 3 11:28:31 deb3067 mysqld[26768]: 070103 11:28:31 [Note] Starting crash recovery... Jan 3 11:28:31 deb3067 mysqld[26768]: 070103 11:28:31 [Note] Crash recovery finished. Jan 3 11:28:31 deb3067 mysqld[26768]: 070103 11:28:31 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=deb3067-relay-bin' to avoid this problem. Jan 3 11:28:31 deb3067 mysqld[26768]: 070103 11:28:31 [Note] /usr/sbin/mysqld: ready for connections. Jan 3 11:28:31 deb3067 mysqld[26768]: Version: '5.0.30-Debian_0.dotdeb.1-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Dotdeb Sarge backport Jan 3 11:28:31 deb3067 mysqld[26768]: 070103 11:28:31 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000661' at position 10563, relay log './deb3067-relay-bin.000050' position: 10700 Jan 3 11:28:31 deb3067 mysqld[26768]: 070103 11:28:31 [Note] Slave I/O thread: connected to master 'cloner@127.0.0.1:3307', replication started in log 'mysql-bin.000661' at position 10563 ### stack trace resolution on slave server ### 0x81be4c4 handle_segfault + 676 (nil) 0x81b05de _ZN3THD19cleanup_after_queryEv + 62 0x81dad56 _Z11mysql_parseP3THDPcj + 246 0x81d15c7 _Z16dispatch_command19enum_server_commandP3THDPcj + 1159 0x81d10ed _Z10do_commandP3THD + 141 0x81d0512 handle_one_connection + 466 0xb7f81b63 _end + -1349889037 0xb7df918a _end + -1351497190 ### Create statements for corresponding tables ### CREATE TABLE `utilisateur` ( `idutilisateur` mediumint(8) unsigned NOT NULL auto_increment, `titre` enum('Monsieur','Madame','Mademoiselle') NOT NULL default 'Monsieur', `sexe` enum('M','F') NOT NULL default 'M', `nom` varchar(30) NOT NULL default '', `prenom` varchar(30) NOT NULL default '', `adresse1` varchar(80) default NULL, `adresse2` varchar(80) default NULL, `codePostal` varchar(10) default NULL, `idpays` tinyint(3) unsigned NOT NULL default '1', `ville` varchar(50) default NULL, `prefixeTel` varchar(4) default NULL, `telPerso` varchar(14) default NULL, `telPro` varchar(14) default NULL, `telPortable` varchar(14) default NULL, `fax` varchar(14) default NULL, `email` varchar(50) default NULL, `login` varchar(20) default NULL, `motDePasse` varchar(41) default NULL, `dateDeModification` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `dateDeCreation` timestamp NOT NULL default '0000-00-00 00:00:00', `idtypeUtilisateur` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`idutilisateur`), UNIQUE KEY `login` (`login`), KEY `email` (`email`), KEY `prenom` (`prenom`), KEY `nomPrenom` (`nom`,`prenom`), KEY `pays` (`idpays`), KEY `motDePasse` (`motDePasse`), KEY `typeId` (`idtypeUtilisateur`), FULLTEXT KEY `fullNomPrenom` (`nom`,`prenom`) ) ENGINE=MyISAM AUTO_INCREMENT=11183 DEFAULT CHARSET=latin1 CREATE TABLE `comedien` ( `idutilisateur` mediumint(8) unsigned NOT NULL default '0', `idtrancheAge` tinyint(1) unsigned NOT NULL default '0', `idcouleurYeux` tinyint(2) unsigned NOT NULL default '0', `idcouleurCheveux` tinyint(2) unsigned NOT NULL default '0', `taille` tinyint(4) unsigned default NULL, `poids` tinyint(3) unsigned default NULL, `photographe` varchar(30) default NULL, `idagence` mediumint(8) unsigned default NULL, `idagent` mediumint(8) unsigned default NULL, `dateDeModification` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `sitePerso` varchar(255) default NULL, `idaffiliation` tinyint(4) NOT NULL default '1', `masquerTelPerso` enum('Y','N') NOT NULL default 'N' COMMENT 'Shall we mask the personal phone number for current users on the site', `masquerTelPortable` enum('Y','N') NOT NULL default 'N' COMMENT 'Shall we mask the cellular phone number for current users on the site', PRIMARY KEY (`idutilisateur`), KEY `trancheAge` (`idtrancheAge`), KEY `couleurYeuxId` (`idcouleurYeux`), KEY `couleurCheveuxId` (`idcouleurCheveux`), KEY `agence` (`idagence`), KEY `agent` (`idagent`), KEY `idaffiliation` (`idaffiliation`), KEY `masquerTel` (`masquerTelPerso`), KEY `masquerTelPortable` (`masquerTelPortable`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 CREATE TABLE `adhesion` ( `idadhesion` bigint(20) unsigned NOT NULL auto_increment, `idutilisateur` mediumint(8) unsigned NOT NULL default '0', `dateDeDebut` date NOT NULL default '0000-00-00', `dateDeFin` date NOT NULL default '0000-00-00', PRIMARY KEY (`idadhesion`), KEY `debut` (`dateDeDebut`), KEY `fin` (`dateDeFin`), KEY `idutilisateur` (`idutilisateur`) ) ENGINE=MyISAM AUTO_INCREMENT=3103 DEFAULT CHARSET=latin1 CREATE TABLE `trancheAge` ( `idtrancheAge` tinyint(1) unsigned NOT NULL default '0', `libeleFR` varchar(7) NOT NULL default '', `libeleEN` varchar(7) NOT NULL default '', PRIMARY KEY (`idtrancheAge`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 CREATE TABLE `couleurCheveux` ( `idcouleurCheveux` tinyint(2) unsigned NOT NULL default '0', `libeleFR` varchar(20) NOT NULL default '', `libeleEN` varchar(20) NOT NULL default '', PRIMARY KEY (`idcouleurCheveux`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 CREATE TABLE `couleurYeux` ( `idcouleurYeux` tinyint(2) unsigned NOT NULL default '0', `libeleFR` varchar(20) NOT NULL default '', `libeleEN` varchar(20) NOT NULL default '', PRIMARY KEY (`idcouleurYeux`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 CREATE TABLE `pays` ( `idpays` tinyint(3) unsigned NOT NULL auto_increment, `nom` varchar(50) NOT NULL default '', PRIMARY KEY (`idpays`) ) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1 CREATE TABLE `comedien_has_langue` ( `idlangue` tinyint(3) unsigned NOT NULL default '0', `idutilisateur` mediumint(8) unsigned NOT NULL default '0', `niveau` enum('1','2','3') NOT NULL default '1', PRIMARY KEY (`idlangue`,`idutilisateur`), KEY `comedienId` (`idutilisateur`), KEY `niveau` (`niveau`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 CREATE TABLE `langue` ( `idlangue` tinyint(3) unsigned NOT NULL auto_increment, `nom_fr` varchar(50) NOT NULL default '', `nom_en` varchar(50) NOT NULL default '', PRIMARY KEY (`idlangue`), KEY `nomFR` (`nom_fr`), KEY `nomEN` (`nom_en`) ) ENGINE=MyISAM AUTO_INCREMENT=73 DEFAULT CHARSET=latin1