Opened 3 years ago

Closed 3 years ago

#11663 closed defect (duplicate)

Some tables fail to copy in switch from MySQL to PostgreSQL

Reported by: Quince Owned by: robguttman
Priority: high Component: CodeReviewerPlugin
Severity: major Keywords:
Cc: Trac Release: 1.0

Description (last modified by rjollos)

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 # ./ --in-place /srv/trac postgres://tracuser:xxxxxxxxxx@`
Copying tables:
  attachment table... 37 records.
  auth_cookie table... 4 records.
  cache table... 8 records.
  codereviewer table... Traceback (most recent call last):
  File "./", line 55, in <module>
    sys.exit(main(sys.argv[1:]) or 0)
  File "./", line 51, in main
    return TracMigrationCommand(env)._do_migrate(dest, dburi)
  File "/tmp/m/tracmigrate/", line 29, in _do_migrate
    return self._do_migrate_inplace(dburi)
  File "/tmp/m/tracmigrate/", line 63, in _do_migrate_inplace
    self._copy_tables(src_db, dst_db, src_dburi, dburi, inplace=True)
  File "/tmp/m/tracmigrate/", line 108, in _copy_tables
  File "/tmp/m/tracmigrate/", line 197, in wrapper
  File "/tmp/m/tracmigrate/", line 143, in copy
    cursor.executemany(query, rows)
  File "/usr/lib/python2.7/site-packages/trac/db/", line 85, in executemany
    return self.cursor.executemany(sql_escape_percent(sql), args)
psycopg2.DataError: integer out of range

Attachments (0)

Change History (4)

comment:1 Changed 3 years ago by rjollos

  • Description modified (diff)

comment:2 Changed 3 years ago by Quince

  • Trac Release set to 1.0

comment:3 Changed 3 years ago by jun66j5

  • Component changed from TracMigratePlugin to CodeReviewerPlugin
  • Owner changed from jun66j5 to robguttman

That's a CodeReviewerPlugin issue that it doesn't support PostgreSQL. Also, a duplicate of #11664. Please don't multi-posting.

Last edited 3 years ago by jun66j5 (previous) (diff)

comment:4 Changed 3 years ago by jun66j5

  • Resolution set to duplicate
  • Status changed from new to closed

Add Comment

Modify Ticket

as closed The owner will remain robguttman.
The resolution will be deleted. Next status will be 'reopened'.

E-mail address and user name can be saved in the Preferences.

Note: See TracTickets for help on using tickets.