PostgreSQL migration to 6.0.6 - wrong sequences names

Moderator: crythias

Post Reply
petrj
OTRS newbie
Posts: 4
Joined: 30 Dec 2017, 18:29
OTRS Version?: 6.0.*
Company: UOL

PostgreSQL migration to 6.0.6 - wrong sequences names

Post by petrj » 28 Mar 2018, 10:20

When I try to migrate OTRS with PostgreSQL to 6.0.6 I got this errors:

Code: Select all

Requirement check for: Upgrade database structure ...
Error: The following sequences with possible wrong names have been found. Please rename them manually.
article_attachment_id_seq
article_plain_id_seq
article_id_seq1
PostgreSQL info about sequence ...

Code: Select all

otrs=# SELECT * FROM article_attachment_id_seq;
 last_value | log_cnt | is_called 
------------+---------+-----------
          1 |       0 | f
(1 row)

Code: Select all

otrs=# \d+ article_attachment_id_seq
                 Sequence "public.article_attachment_id_seq"
  Type  | Start | Minimum |       Maximum       | Increment | Cycles? | Cache 
--------+-------+---------+---------------------+-----------+---------+-------
 bigint |     1 |       1 | 9223372036854775807 |         1 | no      |     1
Owned by: public.article_data_mime_attachment.id
A realy don't know how to fix this

I found similar topic here - viewtopic.php?t=38482

I use OTRS on Ubuntu with PostgreSQL 10, upgrading from 6.0.4
OTRS 6.0.3, Ubuntu, PostgreSQL, LDAP

Post Reply