Re: [Mailmanager-users] Setting up 2.0.4 from scratch on Slackware 10.1.

[Kevin C. <ke...@lo...>]

On Tue, Jan 10, 2006 at 10:36:32AM -0500, Samuel J Stanaitis wrote:
> I've migrated to 2.0.5 and the PostgreSQL database.  The last entry in the
> event.log file is:
> 
> 2006-01-10T10:19:05 ERROR Zope.SiteErrorLog http://jobe:8080/mm/migrate
> Traceback (most recent call last):
>   File "/usr/local/zope/lib/python/ZPublisher/Publish.py", line 113, in
> publish
>     request, bind=1)
>   File "/usr/local/zope/lib/python/ZPublisher/mapply.py", line 88, in mapply
>     if debug is not None: return debug(object,args,context)
>   File "/usr/local/zope/lib/python/ZPublisher/Publish.py", line 40, in
> call_object
>     result=apply(object,args) # Type s<cr> to step into published object.
>   File "/usr/local/zope/mailManager/Products/MailManager/migration.py", line
> 123, in migrate
>     self.sql.createTables()
>   File "/usr/local/zope/lib/python/Shared/DC/ZRDB/DA.py", line 454, in
> __call__
>     else: result=DB__.query(query, self.max_rows_)
>   File "/usr/local/zope/mailManager/Products/ZPsycopgDA/db.py", line 246, in
> query
>     raise err
> IntegrityError: ERROR:  duplicate key violates unique constraint
> "pg_class_relname_nsp_index"
> 
> CREATE TABLE mm_user (
>     username VARCHAR(12) PRIMARY KEY,
>     real_name TEXT,
>     email TEXT,
>     signature TEXT,
>     tickets BOOL DEFAULT 'f',
>     reports BOOL DEFAULT 'f',
>     settings BOOL DEFAULT 'f',
>     password VARCHAR(42)
> )

This sounds like an internal postgres error from a quick scan on mailing lists.
What is the version of postgres you are using? This may be from adding on the 
text search functionality.

> Zope/MailManager is reporting that the migration was successful and
> everything is up to date, is this error a problem?  Also, how do I go about
> eliminating the 3.5gb ZODB file now?

The migration script is not transactional in certain cases, so this could 
potentially be a problem although it's unlikely if the data seems to be 
imported correctly. Where does it report that the migration was sucessful?

Regards,
Kevin

--
Kevin Campbell 
Software Engineer 
Logicalware Ltd
GPG Key: F480EC23