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 }}}

Change History (0)

Note: See TracTickets for help on using tickets.