[rt-users] Problems upgrading from 3.9.3

[Ruslan Zakirov]

On Thu, Apr 25, 2013 at 1:22 PM, saxmad <g.mason at fairfx.com> wrote:

> I tried setting up the database as Thomas suggested, and it certainly made
> a
> difference.  However, I did get the following errors.  Should I be worried
> by them, or can they be ignored, based on what I am trying to do ?
>
>
No, they can not be ignored. What Thomas suggested just creates empty
database
and grants rights to rt_user, but it doesn't work as expected. ACL step
doesn't grant rights
as objects (tables, sequences, indexes...) are not there.

What you can do is:

1) create database:

rt-setup-database-4 --action create

2) upload data dump without privileges as DBA user into this new DB, see -x
option of pg_dump.

3) create rt_user and grant him permissions:

rt-setup-database-4 --action acl


Your log should be clean of all DBD::Pg::st errors.



> Working with:
> Type:   Pg
> Host:   localhost
> Name:   rtdb
> User:   rtuser
> DBA:    postgres
> Now creating a Pg database rtdb for RT.
> Done.
> Now inserting database ACLs.
> DBD::Pg::st execute failed: ERROR:  relation "attachments_id_seq" does not
> exist at /usr/share/request-tracker4/lib/RT/Handle.pm line 439, <STDIN>
> line
> 1.
> DBD::Pg::st execute failed: ERROR:  relation "attachments_id_seq" does not
> exist at /usr/share/request-tracker4/lib/RT/Handle.pm line 439, <STDIN>
> line
> 1.
>
> I carried on with importing my data and ran another upgrade.  This time it
> got a lot further, but it still stopped early with the following text :-
>
> Processing 3.9.8
> Now populating database schema.
> Now inserting data.
> [Thu Apr 25 09:20:33 2013] [warning]: DBD::Pg::db table_info failed: ERROR:
> column t.spclocation does not exist
> LINE 11: ...t(t.spcname) AS "pg_tablespace_name", quote_ident(t.spclocat...
>                                                               ^ at
> /usr/share/request-tracker4/etc/upgrade/3.9.8/content line 3.
> (/usr/share/request-tracker4/etc/upgrade/3.9.8/content:3)
> Couldn't finish 'upgrade' step.
>
> ERROR: One of initial functions failed: DBD::Pg::db table_info failed:
> ERROR:  column t.spclocation does not exist
> LINE 11: ...t(t.spcname) AS "pg_tablespace_name", quote_ident(t.spclocat...
>                                                               ^ at
> /usr/share/request-tracker4/etc/upgrade/3.9.8/content line 3.
>
> What can I do to get the upgrade past this point ?
>
>
>
>
> --
> View this message in context:
> http://requesttracker.8502.n7.nabble.com/Problems-upgrading-from-3-9-3-tp53543p53610.html
> Sent from the Request Tracker - User mailing list archive at Nabble.com.
>



-- 
Best regards, Ruslan.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20130425/7191ec91/attachment.htm>