Scanned too many databases when querying INFORMATION_SCHEMA
查询 INFORMATION_SCHEMA 时导致过多的跨库扫描
查询时 INFORMATION_SCHEMA 时显式指明库和表
D:\projects\fundbi\1>python manage.py syncdb
C:\Users\xuyuming\AppData\Roaming\Python\Python27\site-packages\django\core\management\commands\syncdb.py:24: RemovedInDjango19Warning: The syncdb command will be removed in Django 1.9
warnings.warn("The syncdb command will be removed in Django 1.9", RemovedInDjango19Warning)
Traceback (most recent call last):
File "manage.py", line 10, in <module>
execute_from_command_line(sys.argv)
File "C:\Users\xuyuming\AppData\Roaming\Python\Python27\site-packages\django\core\management\__init__.py", line 338, in execute_from_command_line
utility.execute()
File "C:\Users\xuyuming\AppData\Roaming\Python\Python27\site-packages\django\core\management\__init__.py", line 330, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "C:\Users\xuyuming\AppData\Roaming\Python\Python27\site-packages\django\core\management\base.py", line 390, in run_from_argv
self.execute(*args, **cmd_options)
File "C:\Users\xuyuming\AppData\Roaming\Python\Python27\site-packages\django\core\management\base.py", line 441, in execute
output = self.handle(*args, **options)
File "C:\Users\xuyuming\AppData\Roaming\Python\Python27\site-packages\django\core\management\commands\syncdb.py", line 25, in handle
call_command("migrate", **options)
File "C:\Users\xuyuming\AppData\Roaming\Python\Python27\site-packages\django\core\management\__init__.py", line 120, in call_command
return command.execute(*args, **defaults)
File "C:\Users\xuyuming\AppData\Roaming\Python\Python27\site-packages\django\core\management\base.py", line 441, in execute
output = self.handle(*args, **options)
File "C:\Users\xuyuming\AppData\Roaming\Python\Python27\site-packages\django\core\management\commands\migrate.py", line 93, in handle
executor = MigrationExecutor(connection, self.migration_progress_callback)
File "C:\Users\xuyuming\AppData\Roaming\Python\Python27\site-packages\django\db\migrations\executor.py", line 19, in __init__
self.loader = MigrationLoader(self.connection)
File "C:\Users\xuyuming\AppData\Roaming\Python\Python27\site-packages\django\db\migrations\loader.py", line 47, in __init__
self.build_graph()
File "C:\Users\xuyuming\AppData\Roaming\Python\Python27\site-packages\django\db\migrations\loader.py", line 180, in build_graph
self.applied_migrations = recorder.applied_migrations()
File "C:\Users\xuyuming\AppData\Roaming\Python\Python27\site-packages\django\db\migrations\recorder.py", line 59, in applied_migrations
self.ensure_schema()
File "C:\Users\xuyuming\AppData\Roaming\Python\Python27\site-packages\django\db\migrations\recorder.py", line 53, in ensure_schema
editor.create_model(self.Migration)
File "C:\Users\xuyuming\AppData\Roaming\Python\Python27\site-packages\django\db\backends\base\schema.py", line 285, in create_model
self.deferred_sql.extend(self._model_indexes_sql(model))
File "C:\Users\xuyuming\AppData\Roaming\Python\Python27\site-packages\django\db\backends\mysql\schema.py", line 55, in _model_indexes_sql
self.connection.cursor(), model._meta.db_table
File "C:\Users\xuyuming\AppData\Roaming\Python\Python27\site-packages\django\db\backends\mysql\introspection.py", line 142, in get_storage_engine
"WHERE table_name = %s", [table_name])
File "C:\Users\xuyuming\AppData\Roaming\Python\Python27\site-packages\django\db\backends\utils.py", line 79, in execute
return super(CursorDebugWrapper, self).execute(sql, params)
File "C:\Users\xuyuming\AppData\Roaming\Python\Python27\site-packages\django\db\backends\utils.py", line 64, in execute
return self.cursor.execute(sql, params)
File "C:\Users\xuyuming\AppData\Roaming\Python\Python27\site-packages\django\db\utils.py", line 97, in __exit__
six.reraise(dj_exc_type, dj_exc_value, traceback)
File "C:\Users\xuyuming\AppData\Roaming\Python\Python27\site-packages\django\db\backends\utils.py", line 64, in execute
return self.cursor.execute(sql, params)
File "C:\Users\xuyuming\AppData\Roaming\Python\Python27\site-packages\django\db\backends\mysql\base.py", line 124, in execute
return self.cursor.execute(query, args)
File "C:\Users\xuyuming\AppData\Local\Continuum\Anaconda2\lib\site-packages\sae\_restful_mysql\cursors.py", line 174, in execute
self.errorhandler(self, exc, value)
File "C:\Users\xuyuming\AppData\Local\Continuum\Anaconda2\lib\site-packages\sae\_restful_mysql\connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
django.db.utils.InterfaceError: (-1, 'error totally whack(13013)')