Opened 10 years ago
Last modified 10 years ago
#11663 closed defect
Some tables fail to copy in switch from MySQL to PostgreSQL — at Initial Version
Reported by: | Quince | Owned by: | Jun Omae |
---|---|---|---|
Priority: | high | Component: | CodeReviewerPlugin |
Severity: | major | Keywords: | |
Cc: | Trac Release: | 1.0 |
Description
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.
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 <module>
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 }}}