this error happened.
Traceback (most recent call last):
File "server.py", line 112, in <module>
location = Location(galileo, gateway, processing)
File "C:\Desenvolvimento\locations\Location.py", line 41, in __init__
'device' : Table('device', galileo, autoload=True,
autoload_with=galileo.bin
d),
File
"C:\Python27\lib\site-packages\sqlalchemy-0.9.8-py2.7.egg\sqlalchemy\sql\
schema.py", line 406, in __new__
table._init(name, metadata, *args, **kw)
File
"C:\Python27\lib\site-packages\sqlalchemy-0.9.8-py2.7.egg\sqlalchemy\sql\
schema.py", line 479, in _init
self._autoload(metadata, autoload_with, include_columns)
File
"C:\Python27\lib\site-packages\sqlalchemy-0.9.8-py2.7.egg\sqlalchemy\sql\
schema.py", line 491, in _autoload
self, include_columns, exclude_columns
File
"C:\Python27\lib\site-packages\sqlalchemy-0.9.8-py2.7.egg\sqlalchemy\engi
ne\base.py", line 1732, in run_callable
return conn.run_callable(callable_, *args, **kwargs)
File
"C:\Python27\lib\site-packages\sqlalchemy-0.9.8-py2.7.egg\sqlalchemy\engi
ne\base.py", line 1241, in run_callable
return callable_(self, *args, **kwargs)
File
"C:\Python27\lib\site-packages\sqlalchemy-0.9.8-py2.7.egg\sqlalchemy\engi
ne\default.py", line 356, in reflecttable
return insp.reflecttable(table, include_columns, exclude_columns)
File
"C:\Python27\lib\site-packages\sqlalchemy-0.9.8-py2.7.egg\sqlalchemy\engi
ne\reflection.py", line 450, in reflecttable
table_name, schema, **table.dialect_kwargs)
File
"C:\Python27\lib\site-packages\sqlalchemy-0.9.8-py2.7.egg\sqlalchemy\engi
ne\reflection.py", line 221, in get_table_options
info_cache=self.info_cache, **kw)
File "<string>", line 2, in get_table_options
File
"C:\Python27\lib\site-packages\sqlalchemy-0.9.8-py2.7.egg\sqlalchemy\engi
ne\reflection.py", line 54, in cache
ret = fn(self, con, *args, **kw)
File
"C:\Python27\lib\site-packages\sqlalchemy-0.9.8-py2.7.egg\sqlalchemy\dial
ects\mysql\base.py", line 2516, in get_table_options
connection, table_name, schema, **kw)
File
"C:\Python27\lib\site-packages\sqlalchemy-0.9.8-py2.7.egg\sqlalchemy\dial
ects\mysql\base.py", line 2636, in _parsed_state_or_create
info_cache=kw.get('info_cache', None)
File "<string>", line 2, in _setup_parser
File
"C:\Python27\lib\site-packages\sqlalchemy-0.9.8-py2.7.egg\sqlalchemy\engi
ne\reflection.py", line 54, in cache
ret = fn(self, con, *args, **kw)
File
"C:\Python27\lib\site-packages\sqlalchemy-0.9.8-py2.7.egg\sqlalchemy\dial
ects\mysql\base.py", line 2661, in _setup_parser
full_name=full_name)
File
"C:\Python27\lib\site-packages\sqlalchemy-0.9.8-py2.7.egg\sqlalchemy\dial
ects\mysql\base.py", line 2748, in _show_create_table
raise exc.NoSuchTableError(full_name)
NoSuchTableError: `device`
In my code I'm using this:
self.galileo = { 'meta' : galileo,
'engine' : galileo.bind,
'device' : Table('device', galileo, autoload=True,
autoload_with=galileo.bind),
'location' : Table('location', galileo, autoload=True,
autoload_with=galileo.bind),
'location_p' : Table('location_p', galileo, autoload=True,
autoload_with=galileo.bind),
'location_10_14' : Table('location_10_14', galileo,
autoload=True, autoload_with=galileo.bind),
'processing_deliver' : Table('processing_deliver', galileo,
autoload=True, autoload_with=galileo.bind),
}
This is a problem?
Your implementation that you gave me that did not happen
Em sábado, 4 de abril de 2015 12:42:01 UTC-3, Henrique Fleury escreveu:
>
> When the database restarts my services are flooding the database
> connection. I wonder if in SQLAlchemy has a parameter that step
> create_engine () it does a delay between an attempt and another connection.
> I need him to try to connect if you can not it wait X time to make a new
> attempt.
>
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
