Error when migrating components

[bugs@…]

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.

[anonymous]

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

[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 ?

[Ryan J Ollos]

This plugin is deprecated. See the TracMigratePlugin.