title: Error: #1436 - Thread stack overrun with MySQL trigger
body: <p>Given error:  #1436 - Thread stack overrun:  6024 bytes used of a 131072 byte stack, and 128000 bytes needed.  Use 'mysqld -O thread_stack=#' to specify a bigger stack. </p>
  
  <pre><code>DROP TRIGGER IF EXISTS `After_delete_area_package`;
  DELIMITER //
  CREATE TRIGGER `After_delete_area_package` AFTER DELETE ON `area_package`
  FOR EACH ROW BEGIN    
  DELETE FROM accounts_areas
  WHERE (area_id = 1); 
  END
  //
  DELIMITER ;
  </code></pre>
  
  <p>simple as hell i would guess. 
  The only area_id in table accounts_areas is 1<br>
  Before that i tried old.package_area_id</p>
  
  <p>I do not have foreign key restraints and my overhead goes red in phpMyAdmin set to 28B.</p>
  
  <p>RDMS: myISAM</p>
  
  <p>SQLFIDDLE: <a href="http://sqlfiddle.com/#!2/79a41" rel="nofollow">http://sqlfiddle.com/#!2/79a41</a></p>
  
  <p>Question: Why would my trigger not delete all the rows from accounts_areas where area_id = 1</p>