Mailing List Archive: DBMail: users

Problems upgrading from 2.2.17 to 3.0.2 (postgresql 8.3)

Index | Next | Previous | View Threaded

lordvan at lordvan

Jul 12, 2012, 10:08 PM

Post #1 of 2 (280 views)
Permalink

Problems upgrading from 2.2.17 to 3.0.2 (postgresql 8.3)

Hi.

I've been having problems with the databas upgrade from 2.2.17 to 3.0.2 (postgresql 8.3).

just a quick list of what I did:

1) dbmail-util -a (2.2.17)
2) backup DB
3) install dbmail 3.0.2
4) run dbmail_2_2-3_0 upgrade script
5) run dbmail-util -a (3.0.2)
--> Error:

Jul 12 15:02:52 server dbmail/maintenance[31422]: [0x748a31a510] EMERGENCY:[db] check_table_exists(+803): 2.0 database incompatible. You need to add the header tables.
Jul 12 15:03:08 server dbmail/maintenance[31442]: [0x5655692390] EMERGENCY:[db] check_table_exists(+803): 2.0 database incompatible. You need to add the header tables.

I am attaching the logs as .tgz (it is only 6kB so I am sending it instead of uploading somewhere)

Contents are:

-) dbmail_2012-07-12_schema.sql
old DB schema before upgrade

-) dbmail_schema_after_migrate.sql
DB schema after update

-) dbmailutil.error
dbmail-util complete output (3.0.2)

-) dbmailutil_2.2_output
dbmail-util 2.2.17 output

-) dbupdate.log
output from running the migration script.

Please let me know what I did wrong or how to fix this (this is just from a very small test-server, but with it like this I do not dare to attempt an upgrade on my live mail server which has GBytes of my emails -- and is remote)

Thanks & Regards,
Thomas Raschbacher
--
Thomas Raschbacher
http://www.lordvan.com

Attachments:

dbmail_2.2-3.0_upgradeproblems.tgz (5.82 KB)

paul at nfg

Aug 1, 2012, 4:17 AM

Post #2 of 2 (251 views)
Permalink

Re: Problems upgrading from 2.2.17 to 3.0.2 (postgresql 8.3) [In reply to]

On 07/13/2012 07:08 AM, Thomas Raschbacher wrote:
> Hi.
>
> I've been having problems with the databas upgrade from 2.2.17 to 3.0.2 (postgresql 8.3).
>
> just a quick list of what I did:
>
> 1) dbmail-util -a (2.2.17)
> 2) backup DB
> 3) install dbmail 3.0.2
> 4) run dbmail_2_2-3_0 upgrade script
> 5) run dbmail-util -a (3.0.2)
> --> Error:
>
> Jul 12 15:02:52 server dbmail/maintenance[31422]: [0x748a31a510] EMERGENCY:[db] check_table_exists(+803): 2.0 database incompatible. You need to add the header tables.
> Jul 12 15:03:08 server dbmail/maintenance[31442]: [0x5655692390] EMERGENCY:[db] check_table_exists(+803): 2.0 database incompatible. You need to add the header tables.

My guess is there is a permission/ownership problem.

Try psql dbmail
dbmail=# \d

all tables, sequences and views must be owned by the db-user specified
in your dbmail.conf

--
________________________________________________________________
Paul J Stevens pjstevns @ gmail, twitter, skype, linkedin

* Premium Hosting Services and Web Application Consultancy *

www.nfg.nl/info [at] nfg/+31.85.877.99.97
________________________________________________________________

_______________________________________________
DBmail mailing list
DBmail [at] dbmail
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads