InnoDB error: Total number of locks exceeds the lock table size

 mysql> show slave status\G
 *************************** 1. row ***************************
 Slave_IO_State: Waiting for master to send event
 Master_Host: reporting.com
 Master_User: replication
 Master_Port: 3306
 Connect_Retry: 10
 Master_Log_File: mysql3308-bin-log.000488
 Read_Master_Log_Pos: 340658086
 Relay_Log_File: mysql3319-relay-log.000156
 Relay_Log_Pos: 4983506
 Relay_Master_Log_File: mysql3308-bin-log.000462
 Slave_IO_Running: Yes
 Slave_SQL_Running: No
 Replicate_Do_DB:
 Replicate_Ignore_DB:
 Replicate_Do_Table:
 Replicate_Ignore_Table:
 Replicate_Wild_Do_Table:
 Replicate_Wild_Ignore_Table: 
 Last_Errno: 1206
 Last_Error: Error 'The total number of locks exceeds the lock table size' on query. Default database: 'production'. Query: 'create table Summary SELECT Dimension.calendarYearMonth, count(*) as EmailsSent, count(distinct Email_Sent.UserID) as "Unique Recipients"
 FROM Dimension, Email_Sent
 WHERE
 Email_Sent.DateID = Dimension.id
 AND Dimension.date >= '2010-11-01'
 GROUP BY 1'
 Skip_Counter: 0
 Exec_Master_Log_Pos: 4983353
 Relay_Log_Space: 14212286599
 Until_Condition: None
 Until_Log_File:
 Until_Log_Pos: 0
 Master_SSL_Allowed: No
 Master_SSL_CA_File:
 Master_SSL_CA_Path:
 Master_SSL_Cert:
 Master_SSL_Cipher:
 Master_SSL_Key:
 Seconds_Behind_Master: NULL
 Master_SSL_Verify_Server_Cert: No
 Last_IO_Errno: 0
 Last_IO_Error:
 Last_SQL_Errno: 1206
 Last_SQL_Error: Error 'The total number of locks exceeds the lock table size' on query. Default database: 'production'. Query: 'create table Summary SELECT Dimension.calendarYearMonth, count(*) as EmailsSent, count(distinct Email_Sent.UserID) as "Unique Recipients"
 FROM Dimension, Email_Sent
 WHERE
 Email_Sent.DateID = Dimension.id
 AND Dimension.date >= '2010-11-01'
 GROUP BY 1'
 1 row in set (0.00 sec)

 ---TRANSACTION 5722EE5D, ACTIVE 18100 sec, process no 13052, OS thread id 1222195536 fetching rows
 mysql tables in use 2, locked 2
 2653776 lock struct(s), heap size 327759856, 677089582 row lock(s)
 MySQL thread id 2860, query id 1863366 Copying to tmp table on disk
 create table Summary SELECT Dimension.calendarYearMonth, count(*) as EmailsSent, count(distinct Email_Sent.UserID) as "Unique Recipients"
 FROM Dimension, Email_Sent
 WHERE
 Email_Sent.DateID = Dimension.id
 AND Dimension.date >= '2010-11-01'
 GROUP BY 1
 TABLE LOCK table `production`.`Email_Sent` trx id 5722EE5D lock mode IS
 RECORD LOCKS space id 5623 page no 11 n bits 440 index `ClientID` of table `production`.`Email_Sent` trx id 5722EE5D lock mode S
 TABLE LOCK table `production`.`Date_Dimension` trx id 5722EE5D lock mode IS
 RECORD LOCKS space id 5611 page no 34 n bits 240 index `PRIMARY` of table `production`.`Date_Dimension` trx id 5722EE5D lock mode S locks rec but not gap
 RECORD LOCKS space id 5623 page no 12 n bits 440 index `ClientID` of table `production`.`Email_Sent` trx id 5722EE5D lock mode S
 RECORD LOCKS space id 5623 page no 15 n bits 272 index `ClientID` of table `production`.`Email_Sent` trx id 5722EE5D lock mode S
 RECORD LOCKS space id 5623 page no 18 n bits 440 index `ClientID` of table `production`.`Email_Sent` trx id 5722EE5D lock mode S
 RECORD LOCKS space id 5623 page no 21 n bits 224 index `ClientID` of table `production`.`Email_Sent` trx id 5722EE5D lock mode S
 RECORD LOCKS space id 5623 page no 29 n bits 440 index `ClientID` of table `production`.`Email_Sent` trx id 5722EE5D lock mode S
 RECORD LOCKS space id 5623 page no 31 n bits 440 index `ClientID` of table `production`.`Email_Sent` trx id 5722EE5D lock mode S
 TOO LOCKS PRINTED FOR THIS TRX: SUPPRESSING FURTHER PRINTS