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
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
I found similar topic here - viewtopic.php?t=38482
I use OTRS on Ubuntu with PostgreSQL 10, upgrading from 6.0.4