Modify

Opened 5 years ago

Closed 2 years ago

#6700 closed defect (wontfix)

Error when migrating components

Reported by: bugs@… Owned by: pacopablo
Priority: normal Component: SqliteToPgScript
Severity: critical Keywords:
Cc: Trac Release: 0.11

Description

When running migration, I reproducably, on different environments encounter this error:

bash-3.2$ ../sqlite2pg -e /absolute/path/to/projdir/ -p 'postgres://trac:xxx@127.0.0.1/db?schema=name'
Traceback (most recent call last):
  File "../sqlite2pg", line 335, in <module>
    sys.exit(main(sys.argv[1:]))
  File "../sqlite2pg", line 331, in main
    Main(opts)
  File "../sqlite2pg", line 244, in Main
    pgenv = getPostgreSQLEnvironment(opts)
  File "../sqlite2pg", line 220, in getPostgreSQLEnvironment
    x.environment_created()
  File "usr/pkg/lib/python2.5/site-packages/trac/env.py", line 496, in environment_created
  File "usr/pkg/lib/python2.5/site-packages/trac/db/util.py", line 57, in executemany
  File "usr/pkg/lib/python2.5/site-packages/trac/db/util.py", line 57, in executemany
psycopg2.ProgrammingError: relation "component" does not exist
LINE 1: INSERT INTO component (name,owner) VALUES (E'component1',E's...

Using latest version of your script and trac 0.11.4 with postgres 8.4.1.

Attachments (0)

Change History (3)

comment:1 Changed 5 years ago by anonymous

Note: When creating database using initenv, everything works fine.

comment:2 Changed 5 years ago by anonymous

Note: however, when after unsuccessful migration I drop the schema, following is shown:

db=# DROP SCHEMA osspc CASCADE;
NOTICE:  drop cascades to 17 other objects
DETAIL:  drop cascades to table osspc.system
drop cascades to table osspc.permission
drop cascades to table osspc.auth_cookie
drop cascades to table osspc.session
drop cascades to table osspc.session_attribute
drop cascades to table osspc.attachment
drop cascades to table osspc.wiki
drop cascades to table osspc.revision
drop cascades to table osspc.node_change
drop cascades to table osspc.ticket
drop cascades to table osspc.ticket_change
drop cascades to table osspc.ticket_custom
drop cascades to table osspc.enum
drop cascades to table osspc.component
drop cascades to table osspc.milestone
drop cascades to table osspc.version
drop cascades to table osspc.report
DROP SCHEMA

So perhaps it is related to #844 ?

comment:3 Changed 2 years ago by rjollos

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

This plugin is deprecated. See the TracMigratePlugin.

Add Comment

Modify Ticket

Action
as closed The owner will remain pacopablo.
The resolution will be deleted. Next status will be 'reopened'.
Author


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

 
Note: See TracTickets for help on using tickets.