id summary reporter owner description type status priority component severity resolution keywords cc release 11663 Some tables fail to copy in switch from MySQL to PostgreSQL Quince Rob Guttman "The codereviewer table of CodeReviewerPlugin doesn't get copied. While this error has to do with that plugin, I'm posting it here because the command that fails is part of this plugin. {{{#!sh fatt:/tmp/m # ./trac-migrate.py --in-place /srv/trac postgres://tracuser:xxxxxxxxxx@127.0.0.1/trac?schema=trac` Copying tables: attachment table... 37 records. auth_cookie table... 4 records. cache table... 8 records. codereviewer table... Traceback (most recent call last): File ""./trac-migrate.py"", line 55, in sys.exit(main(sys.argv[1:]) or 0) File ""./trac-migrate.py"", line 51, in main return TracMigrationCommand(env)._do_migrate(dest, dburi) File ""/tmp/m/tracmigrate/admin.py"", line 29, in _do_migrate return self._do_migrate_inplace(dburi) File ""/tmp/m/tracmigrate/admin.py"", line 63, in _do_migrate_inplace self._copy_tables(src_db, dst_db, src_dburi, dburi, inplace=True) File ""/tmp/m/tracmigrate/admin.py"", line 108, in _copy_tables @self._with_transaction(dst_db) File ""/tmp/m/tracmigrate/admin.py"", line 197, in wrapper fn(db) File ""/tmp/m/tracmigrate/admin.py"", line 143, in copy cursor.executemany(query, rows) File ""/usr/lib/python2.7/site-packages/trac/db/util.py"", line 85, in executemany return self.cursor.executemany(sql_escape_percent(sql), args) psycopg2.DataError: integer out of range }}}" defect closed high CodeReviewerPlugin major duplicate 1.0