{"action":"created","issue":{"url":"https://api.github.com/repos/matrix-org/synapse/issues/1147","repository_url":"https://api.github.com/repos/matrix-org/synapse","labels_url":"https://api.github.com/repos/matrix-org/synapse/issues/1147/labels{/name}","comments_url":"https://api.github.com/repos/matrix-org/synapse/issues/1147/comments","events_url":"https://api.github.com/repos/matrix-org/synapse/issues/1147/events","html_url":"https://github.com/matrix-org/synapse/issues/1147","id":179508109,"number":1147,"title":" table device_inbox already exists","user":{"login":"rubo77","id":1591563,"avatar_url":"https://avatars.githubusercontent.com/u/1591563?v=3","gravatar_id":"","url":"https://api.github.com/users/rubo77","html_url":"https://github.com/rubo77","followers_url":"https://api.github.com/users/rubo77/followers","following_url":"https://api.github.com/users/rubo77/following{/other_user}","gists_url":"https://api.github.com/users/rubo77/gists{/gist_id}","starred_url":"https://api.github.com/users/rubo77/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rubo77/subscriptions","organizations_url":"https://api.github.com/users/rubo77/orgs","repos_url":"https://api.github.com/users/rubo77/repos","events_url":"https://api.github.com/users/rubo77/events{/privacy}","received_events_url":"https://api.github.com/users/rubo77/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":6,"created_at":"2016-09-27T14:24:00Z","updated_at":"2016-09-29T05:26:16Z","closed_at":null,"body":"after upgrading from 0.17 to version 0.18 i have the following problem: \r\n\r\n    sqlite3.OperationalError: table device_inbox already exists "},"comment":{"url":"https://api.github.com/repos/matrix-org/synapse/issues/comments/250373434","html_url":"https://github.com/matrix-org/synapse/issues/1147#issuecomment-250373434","issue_url":"https://api.github.com/repos/matrix-org/synapse/issues/1147","id":250373434,"user":{"login":"rubo77","id":1591563,"avatar_url":"https://avatars.githubusercontent.com/u/1591563?v=3","gravatar_id":"","url":"https://api.github.com/users/rubo77","html_url":"https://github.com/rubo77","followers_url":"https://api.github.com/users/rubo77/followers","following_url":"https://api.github.com/users/rubo77/following{/other_user}","gists_url":"https://api.github.com/users/rubo77/gists{/gist_id}","starred_url":"https://api.github.com/users/rubo77/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rubo77/subscriptions","organizations_url":"https://api.github.com/users/rubo77/orgs","repos_url":"https://api.github.com/users/rubo77/repos","events_url":"https://api.github.com/users/rubo77/events{/privacy}","received_events_url":"https://api.github.com/users/rubo77/received_events","type":"User","site_admin":false},"created_at":"2016-09-29T05:26:16Z","updated_at":"2016-09-29T05:26:16Z","body":"```\r\n2016-09-27 12:36:52,939 - synapse.app.homeserver - 289 - INFO - - Server version: Synapse/0.16.1-r1\r\n2016-09-27 12:36:52,941 - synapse.app.homeserver - 308 - INFO - - Preparing database: sqlite3...\r\n2016-09-27 13:48:47,359 - synapse.python_dependencies - 113 - INFO - - Using 'bcrypt' version None from '/home/irc-bridge/.synapse/local/lib/python2.7/site-packages/bcrypt/__init__.pyc' to satisfy 'py-bcrypt'\r\n2016-09-27 13:48:47,359 - synapse.python_dependencies - 113 - INFO - - Using 'frozendict' version None from '/home/irc-bridge/.synapse/local/lib/python2.7/site-packages/frozendict/__init__.pyc' to satisfy 'frozendict>=0.4'\r\n2016-09-27 13:48:47,359 - synapse.python_dependencies - 113 - INFO - - Using 'OpenSSL' version '16.0.0' from '/home/irc-bridge/.synapse/local/lib/python2.7/site-packages/OpenSSL/__init__.pyc' to satisfy 'pyopenssl>=0.14'\r\n2016-09-27 13:48:47,359 - synapse.python_dependencies - 113 - INFO - - Using 'pydenticon' version None from '/home/irc-bridge/.synapse/local/lib/python2.7/site-packages/pydenticon/__init__.pyc' to satisfy 'pydenticon'\r\n2016-09-27 13:48:47,359 - synapse.python_dependencies - 113 - INFO - - Using 'pymacaroons' version '0.9.0' from '/home/irc-bridge/.synapse/local/lib/python2.7/site-packages/pymacaroons/__init__.pyc' to satisfy 'pymacaroons-pynacl'\r\n2016-09-27 13:48:47,359 - synapse.python_dependencies - 113 - INFO - - Using 'service_identity' version '16.0.0' from '/home/irc-bridge/.synapse/local/lib/python2.7/site-packages/service_identity/__init__.pyc' to satisfy 'service_identity>=1.0.0'\r\n2016-09-27 13:48:47,359 - synapse.python_dependencies - 113 - INFO - - Using 'signedjson' version '1.0.0' from '/home/irc-bridge/.synapse/local/lib/python2.7/site-packages/signedjson/__init__.pyc' to satisfy 'signedjson>=1.0.0'\r\n2016-09-27 13:48:47,360 - synapse.python_dependencies - 113 - INFO - - Using 'blist' version '1.3.6' from '/home/irc-bridge/.synapse/local/lib/python2.7/site-packages/blist/__init__.pyc' to satisfy 'blist'\r\n2016-09-27 13:48:47,360 - synapse.python_dependencies - 113 - INFO - - Using 'yaml' version '3.11' from '/home/irc-bridge/.synapse/local/lib/python2.7/site-packages/yaml/__init__.pyc' to satisfy 'pyyaml'\r\n2016-09-27 13:48:47,360 - synapse.python_dependencies - 113 - INFO - - Using 'unpaddedbase64' version '1.1.0' from '/home/irc-bridge/.synapse/local/lib/python2.7/site-packages/unpaddedbase64.pyc' to satisfy 'unpaddedbase64>=1.1.0'\r\n2016-09-27 13:48:47,360 - synapse.python_dependencies - 113 - INFO - - Using 'ujson' version '1.35' from '/home/irc-bridge/.synapse/local/lib/python2.7/site-packages/ujson.so' to satisfy 'ujson'\r\n2016-09-27 13:48:47,360 - synapse.python_dependencies - 113 - INFO - - Using 'nacl' version '0.3.0' from '/home/irc-bridge/.synapse/local/lib/python2.7/site-packages/nacl/__init__.pyc' to satisfy 'pynacl==0.3.0'\r\n...\r\n2016-09-27 13:48:47,361 - synapse.python_dependencies - 113 - INFO - - Using 'PIL' version None from '/home/irc-bridge/.synapse/local/lib/python2.7/site-packages/PIL/__init__.pyc' to satisfy 'pillow'\r\n2016-09-27 13:48:47,418 - synapse.app.homeserver - 290 - INFO - - Server hostname: matrix.myserver.de\r\n2016-09-27 13:48:47,419 - synapse.app.homeserver - 291 - INFO - - Server version: Synapse/0.17.0\r\n2016-09-27 13:48:47,421 - synapse.app.homeserver - 309 - INFO - - Preparing database: sqlite3...\r\n2016-09-27 13:48:47,462 - synapse.storage.prepare_database - 212 - INFO - - Upgrading schema to v33\r\n2016-09-27 13:48:47,786 - synapse.app.homeserver - 327 - INFO - - Database prepared in sqlite3.\r\n2016-09-27 13:48:47,787 - synapse.server - 139 - INFO - - Setting up.\r\n2016-09-27 13:49:37,258 - synapse.storage.event_push_actions - 417 - INFO - - Searching for stream ordering 1 month ago\r\n2016-09-27 13:49:37,544 - synapse.storage.event_push_actions - 423 - INFO - - Found stream ordering 1 month ago: it's 290892\r\n2016-09-27 13:49:37,671 - synapse.config.appservice - 77 - INFO - - Loaded application service: ApplicationService: {'sender': '@xxxx:matrix.myserver.de', 'url': 'http://localhost:3500', 'hs_token': 'xxxxxxxxxxxxxxxx', 'token': 'xxxxxxxxxxxxxxx', 'namespaces': {'aliases': [{'regex': '#hackint_.*:.*', 'exclusive': True}], 'rooms': [{'regex': '!xxxx:matrix.myserver.de', 'exclusive': False}, {'regex': '!xxxx:matrix.myserver.de', 'exclusive': False}, {'regex': '!xxxx:matrix.myserver.de', 'exclusive': False}, {'regex': '!xxxx:matrix.myserver.de', 'exclusive': False}, {'regex': '!xxxx:matrix.myserver.de', 'exclusive': False}, {'regex': '!xxxx:matrix.myserver.de', 'exclusive': False}], 'users': [{'regex': '@irc_.*:.*', 'exclusive': True}]}, 'id': 'xxxxxxxxxxxxxxx'}2016-09-27 13:49:37,672 - synapse.server - 141 - INFO - - Finished setting up.\r\n2016-09-27 13:49:37,699 - synapse.util.httpresourcetree - 43 - INFO - - Attaching <twisted.web.resource.EncodingResourceWrapper object at 0x7f4e4b8edb50> to path /_matrix/client/r0\r\n2016-09-27 13:49:37,700 - synapse.util.httpresourcetree - 43 - INFO - - Attaching FilePath('/home/irc-bridge/.synapse/local/lib/python2.7/site-packages/synapse/static') to path /_matrix/static\r\n2016-09-27 13:49:37,700 - synapse.util.httpresourcetree - 43 - INFO - - Attaching <twisted.web.resource.EncodingResourceWrapper object at 0x7f4e4b8edb50> to path /_matrix/client/versions\r\n...\r\n2016-09-27 13:49:37,701 - synapse.util.httpresourcetree - 43 - INFO - - Attaching <synapse.federation.transport.server.TransportLayerServer object at 0x7f4e4b8edc50> to path /_matrix/federation/v1\r\n2016-09-27 13:49:37,702 - twisted - 154 - INFO - - SynapseSite (TLS) starting on 8448\r\n2016-09-27 13:49:37,702 - twisted - 154 - INFO - - Starting factory <synapse.http.site.SynapseSite instance at 0x7f4e4b91a098>\r\n2016-09-27 13:49:37,702 - synapse.app.homeserver - 199 - INFO - - Synapse now listening on port 8448\r\n2016-09-27 13:49:37,704 - synapse.util.httpresourcetree - 43 - INFO - - Attaching <twisted.web.resource.EncodingResourceWrapper object at 0x7f4e4b8c01d0> to path /_matrix/client/r0\r\n...\r\n2016-09-27 13:49:37,706 - synapse.util.httpresourcetree - 43 - INFO - - Attaching <synapse.federation.transport.server.TransportLayerServer object at 0x7f4e4b8c02d0> to path /_matrix/federation/v1\r\n2016-09-27 13:49:37,706 - twisted - 154 - INFO - - SynapseSite starting on 8008\r\n2016-09-27 13:49:37,706 - twisted - 154 - INFO - - Starting factory <synapse.http.site.SynapseSite instance at 0x7f4e4b91ec20>\r\n2016-09-27 13:49:37,706 - synapse.app.homeserver - 199 - INFO - - Synapse now listening on port 8008\r\n2016-09-27 13:49:37,707 - synapse.app.homeserver - 421 - INFO - - Scheduling stats reporting for 24 hour intervals\r\n2016-09-27 13:49:37,721 - synapse.app.homeserver - 242 - WARNING - - Starting daemon.\r\n2016-09-27 13:49:37,721 - synapse.app.homeserver - 31 - INFO - - Set file limit to: 65536\r\n2016-09-27 13:49:37,729 - synapse.storage.background_updates - 94 - INFO - - Starting background schema updates\r\n2016-09-27 13:49:37,799 - synapse.metrics - 212 - INFO - - Collecting gc 0\r\n2016-09-27 13:49:37,851 - synapse.push.pusherpool - 184 - INFO - - Starting 27 pushers\r\n2016-09-27 13:49:37,851 - synapse.push.pusher - 34 - INFO - - trying to create_pusher for {'lang': u'de', 'kind': ....\r\n...\r\npp_display_name': u'org.matrix.androidsdk.alpha', 'id': 838}\r\n2016-09-27 13:49:37,852 - synapse.push.pusher - 40 - INFO - - email enable notifs: False\r\n2016-09-27 13:49:37,852 - synapse.push.pusher - 46 - INFO - - found pusher\r\n2016-09-27 13:49:37,852 - synapse.push.pusher - 34 - INFO - - trying to create_pusher for {'lang...\r\n...\r\n2016-09-27 13:54:23,892 - synapse.app.homeserver - 70 - WARNING - - Stopping daemon.\r\n2016-09-27 13:57:17,962 - synapse.python_dependencies - 114 - INFO - - Using 'bcrypt' version None from '/home/irc-bridge/.synapse/local/lib/\r\npython2.7/site-packages/bcrypt/__init__.pyc' to satisfy 'py-bcrypt'\r\n2016-09-27 13:57:17,962 - synapse.python_dependencies - 114 - INFO - - Using 'msgpack' version None from '/home/irc-bridge/.synapse/local/lib\r\n/python2.7/site-packages/msgpack/__init__.pyc' to satisfy 'msgpack-python>=0.3.0'\r\n...\r\n2016-09-27 13:57:17,964 - synapse.python_dependencies - 114 - INFO - - Using 'PIL' version None from '/home/irc-bridge/.synapse/local/lib/python2.7/site-packages/PIL/__init__.pyc' to satisfy 'pillow'\r\n2016-09-27 13:57:18,029 - synapse.app.homeserver - 290 - INFO - - Server hostname: matrix.myserver.de\r\n2016-09-27 13:57:18,030 - synapse.app.homeserver - 291 - INFO - - Server version: Synapse/0.18.0\r\n2016-09-27 13:57:18,051 - synapse.app.homeserver - 309 - INFO - - Preparing database: sqlite3...\r\n2016-09-27 13:57:18,053 - synapse.storage.prepare_database - 212 - INFO - - Upgrading schema to v33\r\n2016-09-27 13:57:18,054 - synapse.storage.prepare_database - 212 - INFO - - Upgrading schema to v34\r\n2016-09-27 13:57:18,054 - synapse.storage.prepare_database - 256 - INFO - - Applying schema 34/appservice_stream.sql\r\n2016-09-27 13:57:18,330 - synapse.storage.prepare_database - 245 - INFO - - Running script 34/cache_stream.py\r\n2016-09-27 13:57:18,330 - synapse.storage.prepare_database - 256 - INFO - - Applying schema 34/device_inbox.sql\r\n2016-09-27 13:57:18,642 - synapse.storage.prepare_database - 256 - INFO - - Applying schema 34/push_display_name_rename.sql\r\n2016-09-27 13:57:18,643 - synapse.storage.prepare_database - 245 - INFO - - Running script 34/received_txn_purge.py\r\n2016-09-27 14:02:46,129 - synapse.python_dependencies - 114 - INFO - - Using 'bcrypt' version None from '/home/irc-bridge/.synapse/local/lib/python2.7/site-packages/bcrypt/__init__.pyc' to satisfy 'py-bcrypt'\r\n2016-09-27 14:02:46,129 - synapse.python_dependencies - 114 - INFO - - Using 'msgpack' version None from '/home/irc-bridge/.synapse/local/lib/python2.7/site-packages/msgpack/__init__.pyc' to satisfy 'msgpack-python>=0.3.0'\r\n2016-09-27 14:02:46,129 - synapse.python_dependencies - 114 - INFO - - Using 'frozendict' version None from '/home/irc-bridge/.synapse/local/lib/python2.7/site-packages/frozendict/__init__.pyc' to satisfy 'frozendict>=0.4'\r\n2016-09-27 14:02:46,130 - synapse.python_dependencies - 114 - INFO - - Using 'OpenSSL' version '16.1.0' from '/home/irc-bridge/.synapse/local/lib/python2.7/site-packages/OpenSSL/__init__.pyc' to satisfy 'pyopenssl>=0.14'\r\n2016-09-27 14:02:46,130 - synapse.python_dependencies - 114 - INFO - - Using 'pydenticon' version None from '/home/irc-bridge/.synapse/local/lib/python2.7/site-packages/pydenticon/__init__.pyc' to satisfy 'pydenticon'\r\n2016-09-27 14:02:46,135 - synapse.python_dependencies - 114 - INFO - - Using 'pymacaroons' version '0.9.0' from '/home/irc-bridge/.synapse/local/lib/python2.7/site-packages/pymacaroons/__init__.pyc' to satisfy 'pymacaroons-pynacl'\r\n2016-09-27 14:02:46,135 - synapse.python_dependencies - 114 - INFO - - Using 'service_identity' version '16.0.0' from '/home/irc-bridge/.synapse/local/lib/python2.7/site-packages/service_identity/__init__.pyc' to satisfy 'service_identity>=1.0.0'\r\n2016-09-27 14:02:46,135 - synapse.python_dependencies - 114 - INFO - - Using 'signedjson' version '1.0.0' from '/home/irc-bridge/.synapse/local/lib/python2.7/site-packages/signedjson/__init__.pyc' to satisfy 'signedjson>=1.0.0'\r\n2016-09-27 14:02:46,135 - synapse.python_dependencies - 114 - INFO - - Using 'blist' version '1.3.6' from '/home/irc-bridge/.synapse/local/lib/python2.7/site-packages/blist/__init__.pyc' to satisfy 'blist'\r\n2016-09-27 14:02:46,135 - synapse.python_dependencies - 114 - INFO - - Using 'yaml' version '3.12' from '/home/irc-bridge/.synapse/local/lib/python2.7/site-packages/yaml/__init__.pyc' to satisfy 'pyyaml'\r\n2016-09-27 14:02:46,135 - synapse.python_dependencies - 114 - INFO - - Using 'unpaddedbase64' version '1.1.0' from '/home/irc-bridge/.synapse/local/lib/python2.7/site-packages/unpaddedbase64.pyc' to satisfy 'unpaddedbase64>=1.1.0'\r\n2016-09-27 14:02:46,136 - synapse.python_dependencies - 114 - INFO - - Using 'ujson' version '1.35' from '/home/irc-bridge/.synapse/local/lib/python2.7/site-packages/ujson.so' to satisfy 'ujson'\r\n2016-09-27 14:02:46,136 - synapse.python_dependencies - 114 - INFO - - Using 'nacl' version '0.3.0' from '/home/irc-bridge/.synapse/local/lib/python2.7/site-packages/nacl/__init__.pyc' to satisfy 'pynacl==0.3.0'\r\n2016-09-27 14:02:46,136 - synapse.python_dependencies - 114 - INFO - - Using 'nacl.bindings' version '0.3.0' from '/home/irc-bridge/.synapse/local/lib/python2.7/site-packages/nacl/__init__.pyc' to satisfy 'pynacl==0.3.0'\r\n2016-09-27 14:02:46,136 - synapse.python_dependencies - 114 - INFO - - Using 'daemonize' version '2.4.7' from '/home/irc-bridge/.synapse/local/lib/python2.7/site-packages/daemonize.pyc' to satisfy 'daemonize'\r\n2016-09-27 14:02:46,136 - synapse.python_dependencies - 114 - INFO - - Using 'canonicaljson' version '1.0.0' from '/home/irc-bridge/.synapse/\r\nlocal/lib/python2.7/site-packages/canonicaljson.pyc' to satisfy 'canonicaljson>=1.0.0'\r\n2016-09-27 14:02:46,136 - synapse.python_dependencies - 114 - INFO - - Using 'twisted' version '16.4.1' from '/home/irc-bridge/.synapse/local/lib/python2.7/site-packages/twisted/__init__.pyc' to satisfy 'Twisted>=15.1.0'\r\n2016-09-27 14:02:46,136 - synapse.python_dependencies - 114 - INFO - - Using 'saml2' version '3.0.2' from '/home/irc-bridge/.synapse/local/lib/python2.7/site-packages/saml2/__init__.pyc' to satisfy 'pysaml2>=3.0.0,<4.0.0'\r\n2016-09-27 14:02:46,137 - synapse.python_dependencies - 114 - INFO - - Using 'pyasn1' version '0.1.9' from '/home/irc-bridge/.synapse/local/lib/python2.7/site-packages/pyasn1/__init__.pyc' to satisfy 'pyasn1'\r\n2016-09-27 14:02:46,137 - synapse.python_dependencies - 114 - INFO - - Using 'PIL' version None from '/home/irc-bridge/.synapse/local/lib/python2.7/site-packages/PIL/__init__.pyc' to satisfy 'pillow'\r\n2016-09-27 14:02:46,249 - synapse.app.homeserver - 290 - INFO - - Server hostname: matrix.myserver.de\r\n2016-09-27 14:02:46,249 - synapse.app.homeserver - 291 - INFO - - Server version: Synapse/0.18.0\r\n2016-09-27 14:02:46,283 - synapse.app.homeserver - 309 - INFO - - Preparing database: sqlite3...\r\n2016-09-27 14:03:16,406 - synapse.storage.prepare_database - 212 - INFO - - Upgrading schema to v34\r\n2016-09-27 14:03:16,406 - synapse.storage.prepare_database - 256 - INFO - - Applying schema 34/device_inbox.sql\r\n2016-09-27 14:03:47,077 - synapse.python_dependencies - 114 - INFO - - Using 'bcrypt' version None from '/home/irc-bridge/.synapse/local/lib/python2.7/site-packages/bcrypt/__init__.pyc' to satisfy 'py-bcrypt'\r\n2016-09-27 14:03:47,077 - synapse.python_dependencies - 114 - INFO - - Using 'msgpack' version None from '/home/irc-bridge/.synapse/local/lib/python2.7/site-packages/msgpack/__init__.pyc' to satisfy 'msgpack-python>=0.3.0'\r\n2016-09-27 14:03:47,077 - synapse.python_dependencies - 114 - INFO - - Using 'frozendict' version None from '/home/irc-bridge/.synapse/local/lib/python2.7/site-packages/frozendict/__init__.pyc' to satisfy 'frozendict>=0.4'\r\n2016-09-27 14:03:47,077 - synapse.python_dependencies - 114 - INFO - - Using 'OpenSSL' version '16.1.0' from '/home/irc-bridge/.synapse/local/lib/python2.7/site-packages/OpenSSL/__init__.pyc' to satisfy 'pyopenssl>=0.14'\r\n\r\n```"}}
{"actor":{"display_login":"rubo77"}}