Skip to content

Instantly share code, notes, and snippets.

@ankit01ojha
Created March 25, 2017 10:00
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ankit01ojha/c3dbc09d19a400a7ea601f70cc04cec5 to your computer and use it in GitHub Desktop.
Save ankit01ojha/c3dbc09d19a400a7ea601f70cc04cec5 to your computer and use it in GitHub Desktop.
error while runnig fedmsg-hub for statscache
(virtualenv) [ankit@foss virtualenv]$ cd statscache
(virtualenv) [ankit@foss statscache]$ sudo fedmsg-hub
[2017-03-25 15:13:49][ fedmsg INFO] Setting RLIMIT_NOFILE to 4096
[2017-03-25 15:13:49][ fedmsg INFO] RLIMIT_NOFILE is set to (4096, 4096)
[2017-03-25 15:13:50][moksha.hub WARNING] Cannot find qpid python module. Make sure you have python-qpid installed.
[2017-03-25 15:13:50][moksha.hub INFO] Loading the Moksha Hub
[2017-03-25 15:13:50][moksha.hub WARNING] No 'zmq_publish_endpoints' set. Are you sure?
[2017-03-25 15:13:51][moksha.hub INFO] Loading Consumers
[2017-03-25 15:13:51][moksha.hub DEBUG] Loading from entry-points.
[2017-03-25 15:13:51][ fedmsg DEBUG] fedmsg.consumers.relay.enabled is None
[2017-03-25 15:13:51][ fedmsg INFO] * disabled by config - fedmsg.consumers.relay:RelayConsumer
[2017-03-25 15:13:51][moksha.hub INFO] fedmsg.consumers.relay:RelayConsumer not initialized.
[2017-03-25 15:13:51][ fedmsg DEBUG] fedmsg.consumers.dummy.enabled is None
[2017-03-25 15:13:51][ fedmsg INFO] * disabled by config - fedmsg.consumers.dummy:DummyConsumer
[2017-03-25 15:13:51][moksha.hub INFO] fedmsg.consumers.dummy:DummyConsumer not initialized.
[2017-03-25 15:13:51][ fedmsg DEBUG] fedmsg.consumers.ircbot.enabled is None
[2017-03-25 15:13:51][ fedmsg INFO] * disabled by config - fedmsg.consumers.ircbot:IRCBotConsumer
[2017-03-25 15:13:51][moksha.hub INFO] fedmsg.consumers.ircbot:IRCBotConsumer not initialized.
[2017-03-25 15:13:51][ fedmsg DEBUG] fedmsg.consumers.gateway.enabled is None
[2017-03-25 15:13:51][ fedmsg INFO] * disabled by config - fedmsg.consumers.gateway:GatewayConsumer
[2017-03-25 15:13:51][moksha.hub INFO] fedmsg.consumers.gateway:GatewayConsumer not initialized.
[2017-03-25 15:13:51][ fedmsg DEBUG] statscache consumer initializing
[2017-03-25 15:13:51][ fedmsg DEBUG] statscache.consumer.enabled is True
[2017-03-25 15:13:51][ fedmsg INFO] enabled by config - statscache.consumer:StatsConsumer
[2017-03-25 15:13:51][moksha.hub DEBUG] Subscribing to consumer topic *
[2017-03-25 15:13:51][moksha.hub DEBUG] Subscribing to on 'ZmqEndpoint(type='connect', address='tcp://hub.fedoraproject.org:9940')'
[2017-03-25 15:13:51][moksha.hub DEBUG] Creating new txzmq factory.
[2017-03-25 15:13:51][moksha.hub DEBUG] Subscribing to on 'ZmqEndpoint(type='connect', address='tcp://127.0.0.1:4001')'
[2017-03-25 15:13:51][moksha.hub DEBUG] Creating new txzmq factory.
[2017-03-25 15:13:51][ fedmsg INFO] No backlog handling. status: None, url: None
[2017-03-25 15:13:51][statscache INFO] Loading plugin <class 'plugins.amis.Plugin'>
[2017-03-25 15:13:51][statscache INFO] Loading plugin <class 'plugins.artifacts.Plugin'>
[2017-03-25 15:13:51][statscache INFO] Loading plugin <class 'plugins.compose.Plugin'>
[2017-03-25 15:13:51][statscache INFO] Loading plugin <class 'plugins.updates.Plugin'>
[2017-03-25 15:13:51][ fedmsg INFO] instantiated plugins: volume-1s, volume-5s, volume-1m, release-engineering-event-logs, volume-by-category-1s, volume-by-category-15s, volume-by-category-1m, volume-by-category-1h, volume-by-category-1d
2017-03-25 15:13:51,845 INFO sqlalchemy.engine.base.Engine SELECT CAST('test plain returns' AS VARCHAR(60)) AS anon_1
2017-03-25 15:13:51,845 INFO sqlalchemy.engine.base.Engine ()
2017-03-25 15:13:51,847 INFO sqlalchemy.engine.base.Engine SELECT CAST('test unicode returns' AS VARCHAR(60)) AS anon_1
2017-03-25 15:13:51,847 INFO sqlalchemy.engine.base.Engine ()
2017-03-25 15:13:51,852 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("data_releng_dashboard")
2017-03-25 15:13:51,852 INFO sqlalchemy.engine.base.Engine ()
2017-03-25 15:13:51,854 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("data_volume_by_category_15s")
2017-03-25 15:13:51,854 INFO sqlalchemy.engine.base.Engine ()
2017-03-25 15:13:51,855 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("data_volume_5s")
2017-03-25 15:13:51,855 INFO sqlalchemy.engine.base.Engine ()
2017-03-25 15:13:51,855 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("data_volume_by_category_1h")
2017-03-25 15:13:51,856 INFO sqlalchemy.engine.base.Engine ()
2017-03-25 15:13:51,856 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("data_volume_by_category_1m")
2017-03-25 15:13:51,856 INFO sqlalchemy.engine.base.Engine ()
2017-03-25 15:13:51,856 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("data_volume_by_category_1d")
2017-03-25 15:13:51,856 INFO sqlalchemy.engine.base.Engine ()
2017-03-25 15:13:51,857 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("data_volume_1s")
2017-03-25 15:13:51,857 INFO sqlalchemy.engine.base.Engine ()
2017-03-25 15:13:51,857 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("data_volume_1m")
2017-03-25 15:13:51,857 INFO sqlalchemy.engine.base.Engine ()
2017-03-25 15:13:51,857 INFO sqlalchemy.engine.base.Engine PRAGMA table_info("data_volume_by_category_1s")
2017-03-25 15:13:51,858 INFO sqlalchemy.engine.base.Engine ()
[2017-03-25 15:13:51][ fedmsg INFO] consuming historical fedmsg traffic from 2015-08-08 00:00:00 up to 2017-03-25 15:13:51.750172
[2017-03-25 15:13:56][moksha.hub ERROR] Failed to init <class 'statscache.consumer.StatsConsumer'> consumer.
Traceback (most recent call last):
File "/usr/lib/python2.7/site-packages/moksha/hub/hub.py", line 379, in __init_consumers
c = c_class(self)
File "/home/ankit/gsoc/virtualenv/statscache/statscache/consumer.py", line 78, in __init__
plugin.revert(start, session)
File "/home/ankit/gsoc/virtualenv/statscache/statscache/plugins/__init__.py", line 130, in revert
session.query(self.model).filter(self.model.timestamp >= when).delete()
File "build/bdist.linux-x86_64/egg/sqlalchemy/orm/query.py", line 3188, in delete
delete_op.exec_()
File "build/bdist.linux-x86_64/egg/sqlalchemy/orm/persistence.py", line 1179, in exec_
self._do_exec()
File "build/bdist.linux-x86_64/egg/sqlalchemy/orm/persistence.py", line 1363, in _do_exec
mapper=self.mapper)
File "build/bdist.linux-x86_64/egg/sqlalchemy/orm/session.py", line 1107, in execute
bind, close_with_result=True).execute(clause, params or {})
File "build/bdist.linux-x86_64/egg/sqlalchemy/engine/base.py", line 945, in execute
return meth(self, multiparams, params)
File "build/bdist.linux-x86_64/egg/sqlalchemy/sql/elements.py", line 263, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "build/bdist.linux-x86_64/egg/sqlalchemy/engine/base.py", line 1053, in _execute_clauseelement
compiled_sql, distilled_params
File "build/bdist.linux-x86_64/egg/sqlalchemy/engine/base.py", line 1189, in _execute_context
context)
File "build/bdist.linux-x86_64/egg/sqlalchemy/engine/base.py", line 1393, in _handle_dbapi_exception
exc_info
File "build/bdist.linux-x86_64/egg/sqlalchemy/util/compat.py", line 203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "build/bdist.linux-x86_64/egg/sqlalchemy/engine/base.py", line 1182, in _execute_context
context)
File "build/bdist.linux-x86_64/egg/sqlalchemy/engine/default.py", line 470, in do_execute
cursor.execute(statement, parameters)
OperationalError: (sqlite3.OperationalError) database is locked [SQL: u'DELETE FROM data_volume_1s WHERE data_volume_1s.timestamp >= ?'] [parameters: ('2015-08-08 00:00:00.000000',)]
[2017-03-25 15:13:56][moksha.hub INFO] Loading Producers
[2017-03-25 15:13:56][moksha.hub DEBUG] Loading from entry-points.
[2017-03-25 15:13:56][moksha.hub INFO] Initializing StatsProducer producer
[2017-03-25 15:13:56][ fedmsg DEBUG] statscache producer initializing
[2017-03-25 15:13:56][moksha.hub DEBUG] Setting a 1.0 second timer
[2017-03-25 15:13:56][moksha.hub ERROR] Failed to init <class 'statscache.producer.StatsProducer'> producer.
Traceback (most recent call last):
File "/usr/lib/python2.7/site-packages/moksha/hub/hub.py", line 424, in __init_producers
producer_obj = producer_class(self)
File "/home/ankit/gsoc/virtualenv/statscache/statscache/producer.py", line 24, in __init__
self.plugins = statscache.utils.find_stats_consumer(self.hub).plugins
File "/home/ankit/gsoc/virtualenv/statscache/statscache/utils.py", line 25, in find_stats_consumer
raise ValueError('StatsConsumer not found.')
ValueError: StatsConsumer not found.
[2017-03-25 15:13:56][moksha.hub INFO] Initializing MonitoringProducer producer
[2017-03-25 15:13:56][moksha.hub.monitoring INFO] No 'moksha.monitoring.socket' defined. Monitoring disabled.
[2017-03-25 15:13:56][moksha.hub INFO] moksha.hub.monitoring:MonitoringProducer not initialized.
[2017-03-25 15:13:56][moksha.hub INFO] Running the MokshaHub reactor
[2017-03-25 15:13:56][moksha.hub INFO] Suggesting threadpool size at 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment