Modify

Opened 8 years ago

Closed 5 years ago

#6700 closed defect (wontfix)

Error when migrating components

Reported by: bugs@… Owned by: John Hampton
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 8 years ago by anonymous

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

comment:2 Changed 8 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 5 years ago by Ryan J Ollos

Resolution: wontfix
Status: newclosed

This plugin is deprecated. See the TracMigratePlugin.

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain John Hampton.
The resolution will be deleted.

Add Comment


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

 
Note: See TracTickets for help on using tickets.