row0mysql.c:

  Add a warning to drop database wait if there are still open handles on a table


innobase/row/row0mysql.c:
  Add a warning to drop database wait if there are still open handles on a table

1 files changed, 9 insertions, 1 deletions

diff --git a/innobase/row/row0mysql.c b/innobase/row/row0mysql.c
index 8357ebe7b96..c4a844b3fa9 100644
--- a/innobase/row/row0mysql.c
+++ b/innobase/row/row0mysql.c
@@ -1847,7 +1847,15 @@ loop:
 		if (table->n_mysql_handles_opened > 0) {
 		        mutex_exit(&(dict_sys->mutex));
 
-		        os_thread_sleep(100000);
+			ut_print_timestamp(stderr);
+			fprintf(stderr,
+		"  InnoDB: Warning: MySQL is trying to drop database %s\n"
+	    	"InnoDB: though there are still open handles to table %s.\n",
+				name, table_name);
+
+		        os_thread_sleep(1000000);
+
+		        mem_free(table_name);
 
 		        goto loop;
 		}