0

I am trying to create a table from a simple select statement that joins two tables and has a group by .. having .. clause.

The SQL statement returns a The total number of locks exceeds the lock table size error. In stack overflow, someone else has had the same problem and was advised to increase innodb_buffer_pool_size(see here). This is what I did, but I am still facing the same issue.

The select statement without create table statement runs perfectly and returns some 250 records.

I am wondering why I get this error. I am hard pressed to find a reason to lock anything in order to create a table. And I am also looking for a workable solution to create a table with a mere 250 records.

René Nyffenegger
  • 39,402
  • 33
  • 158
  • 293
  • Can you link to the question you found with that advice? – Barmar Jun 17 '19 at 21:20
  • @Barmar please see my edit. – René Nyffenegger Jun 18 '19 at 05:41
  • Possible duplicate of [The total number of locks exceeds the lock table size](https://stackoverflow.com/questions/6901108/the-total-number-of-locks-exceeds-the-lock-table-size) – Rakesh Jun 18 '19 at 07:24
  • @Rakesh, I have done what the (not accepted!) answers of that question advised - to no avail. Futhermore, I have also asked why I need locks to create a table. Thus, this cannot be a duplication of said questin. – René Nyffenegger Jun 18 '19 at 07:39

0 Answers0