This repository was archived by the owner on Apr 26, 2024. It is now read-only.
This repository was archived by the owner on Apr 26, 2024. It is now read-only.
Update to 0.24 : database error #2572
Description
I have tried to upgrade my personal homeserver from version 0.23.1 to the 0.24, but the upgrade did not get well, the server won't launch, with the following error:
2017-10-24 12:53:41,897 - twisted - 131 - ERROR - - Traceback (most recent call last):
2017-10-24 12:53:41,897 - twisted - 131 - ERROR - - File "/usr/lib64/python2.7/runpy.py", line 162, in _run_module_as_main
2017-10-24 12:53:41,897 - twisted - 131 - ERROR - - "__main__", fname, loader, pkg_name)
2017-10-24 12:53:41,897 - twisted - 131 - ERROR - - File "/usr/lib64/python2.7/runpy.py", line 72, in _run_code
2017-10-24 12:53:41,898 - twisted - 131 - ERROR - - exec code in run_globals
2017-10-24 12:53:41,898 - twisted - 131 - ERROR - - File "/home/matrix/synapse/lib/python2.7/site-packages/synapse/app/homeserver.py", line 450, in <module>
2017-10-24 12:53:41,898 - twisted - 131 - ERROR - - main()
2017-10-24 12:53:41,898 - twisted - 131 - ERROR - - File "/home/matrix/synapse/lib/python2.7/site-packages/synapse/app/homeserver.py", line 445, in main
2017-10-24 12:53:41,899 - twisted - 131 - ERROR - - hs = setup(sys.argv[1:])
2017-10-24 12:53:41,899 - twisted - 131 - ERROR - - File "/home/matrix/synapse/lib/python2.7/site-packages/synapse/app/homeserver.py", line 306, in setup
2017-10-24 12:53:41,899 - twisted - 131 - ERROR - - prepare_database(db_conn, database_engine, config=config)
2017-10-24 12:53:41,899 - twisted - 131 - ERROR - - File "/home/matrix/synapse/lib/python2.7/site-packages/synapse/storage/prepare_database.py", line 62, in prepare_database
2017-10-24 12:53:41,900 - twisted - 131 - ERROR - - cur, user_version, delta_files, upgraded, database_engine, config
2017-10-24 12:53:41,900 - twisted - 131 - ERROR - - File "/home/matrix/synapse/lib/python2.7/site-packages/synapse/storage/prepare_database.py", line 257, in _upgrade_existing_database
2017-10-24 12:53:41,900 - twisted - 131 - ERROR - - executescript(cur, absolute_path)
2017-10-24 12:53:41,900 - twisted - 131 - ERROR - - File "/home/matrix/synapse/lib/python2.7/site-packages/synapse/storage/prepare_database.py", line 337, in executescript
2017-10-24 12:53:41,900 - twisted - 131 - ERROR - - txn.execute(statement)
2017-10-24 12:53:41,901 - twisted - 131 - ERROR - - sqlite3.OperationalError: near "WHERE": syntax error
2017-10-24 12:53:46,130 - twisted - 131 - ERROR - - Traceback (most recent call last):
2017-10-24 12:53:46,131 - twisted - 131 - ERROR - - File "/usr/lib64/python2.7/runpy.py", line 162, in _run_module_as_main
2017-10-24 12:53:46,131 - twisted - 131 - ERROR - - "__main__", fname, loader, pkg_name)
2017-10-24 12:53:46,131 - twisted - 131 - ERROR - - File "/usr/lib64/python2.7/runpy.py", line 72, in _run_code
2017-10-24 12:53:46,132 - twisted - 131 - ERROR - - exec code in run_globals
2017-10-24 12:53:46,132 - twisted - 131 - ERROR - - File "/home/matrix/synapse/lib/python2.7/site-packages/synapse/app/homeserver.py", line 450, in <module>
2017-10-24 12:53:46,132 - twisted - 131 - ERROR - - main()
2017-10-24 12:53:46,132 - twisted - 131 - ERROR - - File "/home/matrix/synapse/lib/python2.7/site-packages/synapse/app/homeserver.py", line 445, in main
2017-10-24 12:53:46,132 - twisted - 131 - ERROR - - hs = setup(sys.argv[1:])
2017-10-24 12:53:46,133 - twisted - 131 - ERROR - - File "/home/matrix/synapse/lib/python2.7/site-packages/synapse/app/homeserver.py", line 306, in setup
2017-10-24 12:53:46,133 - twisted - 131 - ERROR - - prepare_database(db_conn, database_engine, config=config)
2017-10-24 12:53:46,133 - twisted - 131 - ERROR - - File "/home/matrix/synapse/lib/python2.7/site-packages/synapse/storage/prepare_database.py", line 62, in prepare_database
2017-10-24 12:53:46,133 - twisted - 131 - ERROR - - cur, user_version, delta_files, upgraded, database_engine, config
2017-10-24 12:53:46,133 - twisted - 131 - ERROR - - File "/home/matrix/synapse/lib/python2.7/site-packages/synapse/storage/prepare_database.py", line 257, in _upgrade_existing_database
2017-10-24 12:53:46,134 - twisted - 131 - ERROR - - executescript(cur, absolute_path)
2017-10-24 12:53:46,134 - twisted - 131 - ERROR - - File "/home/matrix/synapse/lib/python2.7/site-packages/synapse/storage/prepare_database.py", line 337, in executescript
2017-10-24 12:53:46,134 - twisted - 131 - ERROR - - txn.execute(statement)
2017-10-24 12:53:46,134 - twisted - 131 - ERROR - - sqlite3.OperationalError: near "WHERE": syntax error
I have just made as indicated in https://github.com/matrix-org/synapse/blob/master/UPGRADE.rst, made a pip install -upgrade and tried to restart the service.