Hi Edwin,
This is the same as the bug you reported here right?
https://github.com/translate/pootle/issues/3953
We thought it was fixed but really we needed you to test that.
Are you able to share a copy of your 2.5.1 database so that we can run it
through our migration mill? Likely that's quicker then use having to guess
at a fix and wait for you to test it.
To get the server back up I'd suggest restoring the backup you made of
2.5.1.
On 6 January 2016 at 09:24, Edwin Boersma <edwin.boer...@fasterminds.com>
wrote:
> Hi,
>
> I never seem to be able to perform an update without running into
> problems I cannot solve myself.
>
> Upgrading from 2.5.1 to latest, I get stuck in the intermediate update
> to 2.6. After running successfully 'pip install --upgrade
> "Pootle>=2.6,<2.7"', I ran 'pootle setup'.
>
> Now it fails with this output:
>
> 2016-01-06 10:13:51,575 INFO Loading custom settings from
>
> '/var/www/pootle/env/lib/python2.7/site-packages/pootle/settings/90-local.conf'...
> 2016-01-06 09:13:51,667 INFO Using Python PO
> 2016-01-06 09:13:51,735 INFO Upgrading existing Pootle installation.
> Syncing...
> Creating tables ...
> Installing custom SQL ...
> Installing indexes ...
> Installed 0 object(s) from 0 fixture(s)
>
> Synced:
> > django.contrib.sessions
> > django.contrib.auth
> > django.contrib.contenttypes
> > django.contrib.sites
> > django.contrib.admin
> > django.contrib.messages
> > django.contrib.staticfiles
> > allauth
> > allauth.account
> > djblets.siteconfig
> > django_assets
> > south
>
> Not synced (use migrations):
> - accounts
> - pootle_app
> - pootle_store
> - pootle_language
> - pootle_project
> - pootle_translationproject
> - pootle_statistics
> - pootle_tagging
> - pootle_notifications
> - reports
> - staticpages
> - virtualfolder
> - allauth.socialaccount
> (use ./manage.py migrate to migrate these)
> Running migrations for accounts:
> - Migrating forwards to 0009_drop_registration_remnant.
> >
>
> pootle_translationproject:0002_auto__del_field_translationproject_description_html__chg_field_transla
> FATAL ERROR - The following SQL query failed: ALTER TABLE
> `pootle_app_translationproject` DROP COLUMN `description_html` CASCADE;
> The error was: (1091, "Can't DROP 'description_html'; check that
> column/key exists")
> ! Error found during real run of migration! Aborting.
>
> ! Since you have a database that does not support running
> ! schema-altering statements in transactions, we have had
> ! to leave it in an interim state between migrations.
>
> ! You *might* be able to recover with: = ALTER TABLE
> `pootle_app_translationproject` ADD COLUMN `description_html` longtext
> NOT NULL; []
> - no dry run output for alter_column() due to dynamic DDL, sorry
> - no dry run output for alter_column() due to dynamic DDL, sorry
>
> ! The South developers regret this has happened, and would
> ! like to gently persuade you to consider a slightly
> ! easier-to-deal-with DBMS (one that supports DDL transactions)
> ! NOTE: The error which caused the migration to fail is further up.
> Error in migration:
>
> pootle_translationproject:0002_auto__del_field_translationproject_description_html__chg_field_transla
> Traceback (most recent call last):
> File "/var/www/pootle/env/bin/pootle", line 9, in <module>
> load_entry_point('Pootle==2.6.2', 'console_scripts', 'pootle')()
> File
> "/var/www/pootle/env/local/lib/python2.7/site-packages/pootle/runner.py",
> line
> 171, in main
> django_settings_module='pootle.settings')
> File
> "/var/www/pootle/env/local/lib/python2.7/site-packages/pootle/runner.py",
> line
> 150, in run_app
> management.execute_from_command_line([runner_name] + remainder)
> File
>
> "/var/www/pootle/env/local/lib/python2.7/site-packages/django/core/management/__init__.py",
> line 399, in execute_from_command_line
> utility.execute()
> File
>
> "/var/www/pootle/env/local/lib/python2.7/site-packages/django/core/management/__init__.py",
> line 392, in execute
> self.fetch_command(subcommand).run_from_argv(self.argv)
> File
>
> "/var/www/pootle/env/local/lib/python2.7/site-packages/django/core/management/base.py",
> line 242, in run_from_argv
> self.execute(*args, **options.__dict__)
> File
>
> "/var/www/pootle/env/local/lib/python2.7/site-packages/django/core/management/base.py",
> line 285, in execute
> output = self.handle(*args, **options)
> File
>
> "/var/www/pootle/env/local/lib/python2.7/site-packages/django/core/management/base.py",
> line 415, in handle
> return self.handle_noargs(**options)
> File
>
> "/var/www/pootle/env/local/lib/python2.7/site-packages/pootle/apps/pootle_app/management/commands/setup.py",
> line 77, in handle_noargs
> call_command('migrate', interactive=False)
> File
>
> "/var/www/pootle/env/local/lib/python2.7/site-packages/django/core/management/__init__.py",
> line 159, in call_command
> return klass.execute(*args, **defaults)
> File
>
> "/var/www/pootle/env/local/lib/python2.7/site-packages/django/core/management/base.py",
> line 285, in execute
> output = self.handle(*args, **options)
> File
>
> "/var/www/pootle/env/local/lib/python2.7/site-packages/south/management/commands/migrate.py",
> line 111, in handle
> ignore_ghosts = ignore_ghosts,
> File
>
> "/var/www/pootle/env/local/lib/python2.7/site-packages/south/migration/__init__.py",
> line 220, in migrate_app
> success = migrator.migrate_many(target, workplan, database)
> File
>
> "/var/www/pootle/env/local/lib/python2.7/site-packages/south/migration/migrators.py",
> line 256, in migrate_many
> result = migrator.__class__.migrate_many(migrator, target,
> migrations, database)
> File
>
> "/var/www/pootle/env/local/lib/python2.7/site-packages/south/migration/migrators.py",
> line 331, in migrate_many
> result = self.migrate(migration, database)
> File
>
> "/var/www/pootle/env/local/lib/python2.7/site-packages/south/migration/migrators.py",
> line 133, in migrate
> result = self.run(migration, database)
> File
>
> "/var/www/pootle/env/local/lib/python2.7/site-packages/south/migration/migrators.py",
> line 114, in run
> return self.run_migration(migration, database)
> File
>
> "/var/www/pootle/env/local/lib/python2.7/site-packages/south/migration/migrators.py",
> line 84, in run_migration
> migration_function()
> File
>
> "/var/www/pootle/env/local/lib/python2.7/site-packages/south/migration/migrators.py",
> line 60, in <lambda>
> return (lambda: direction(orm))
> File
>
> "/var/www/pootle/env/local/lib/python2.7/site-packages/pootle/apps/pootle_translationproject/migrations/0002_auto__del_field_translationproject_description_html__chg_field_transla.py",
> line 12, in forwards
> db.delete_column('pootle_app_translationproject', 'description_html')
> File
> "/var/www/pootle/env/local/lib/python2.7/site-packages/south/db/mysql.py",
> line 28, in _column_rm
> return func(self, table_name, column_name, *args, **opts)
> File
> "/var/www/pootle/env/local/lib/python2.7/site-packages/south/db/mysql.py",
> line 227, in delete_column
> super(DatabaseOperations, self).delete_column(table_name, name)
> File
>
> "/var/www/pootle/env/local/lib/python2.7/site-packages/south/db/generic.py",
> line 54, in _column_rm
> return func(self, table, column, *args, **opts)
> File
>
> "/var/www/pootle/env/local/lib/python2.7/site-packages/south/db/generic.py",
> line 911, in delete_column
> self.execute(self.delete_column_string % params, [])
> File
>
> "/var/www/pootle/env/local/lib/python2.7/site-packages/south/db/generic.py",
> line 282, in execute
> cursor.execute(sql, params)
> File
>
> "/var/www/pootle/env/local/lib/python2.7/site-packages/django/db/backends/util.py",
> line 53, in execute
> return self.cursor.execute(sql, params)
> File
> "/var/www/pootle/env/local/lib/python2.7/site-packages/django/db/utils.py",
> line 99, in __exit__
> six.reraise(dj_exc_type, dj_exc_value, traceback)
> File
>
> "/var/www/pootle/env/local/lib/python2.7/site-packages/django/db/backends/util.py",
> line 53, in execute
> return self.cursor.execute(sql, params)
> File
>
> "/var/www/pootle/env/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py",
> line 124, in execute
> return self.cursor.execute(query, args)
> File
> "/var/www/pootle/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py",
> line 205, in execute
> self.errorhandler(self, exc, value)
> File
>
> "/var/www/pootle/env/local/lib/python2.7/site-packages/MySQLdb/connections.py",
> line 36, in defaulterrorhandler
> raise errorclass, errorvalue
> django.db.utils.OperationalError: (1091, "Can't DROP 'description_html';
> check that column/key exists")
>
>
> I need a fix for this asap, since our Pootle server is now unvailable.
>
> Kind regards,
>
> Edwin Boersma
>
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Translate-pootle mailing list
> Translate-pootle@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/translate-pootle
>
--
Dwayne
*Translate*
+27 12 460 1095 (work)
------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140
_______________________________________________
Translate-pootle mailing list
Translate-pootle@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/translate-pootle
