Search found 5 matches

by petrj
23 Oct 2018, 14:42
Forum: Help
Topic: PostgreSQL migration to 6.0.6 - wrong sequences names
Replies: 2
Views: 33526

Re: PostgreSQL migration to 6.0.6 - wrong sequences names

Hello Peter, yesterday I finally upgraded OTRS to 6.0.12. And because "sequence check" had moved to to SupportDataCollecor - https://github.com/OTRS/otrs/blob/87629f00b8a02498bf28c802419865b3286ead2e/Kernel/System/SupportDataCollector/Plugin/Database/postgresql/PrimaryKeySequences.pm , the...
by petrj
28 Mar 2018, 10:20
Forum: Help
Topic: PostgreSQL migration to 6.0.6 - wrong sequences names
Replies: 2
Views: 33526

PostgreSQL migration to 6.0.6 - wrong sequences names

When I try to migrate OTRS with PostgreSQL to 6.0.6 I got this errors: 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 PostgreSQ...
by petrj
09 Jan 2018, 18:37
Forum: Help
Topic: 6.0.1 QueueView very slow and error message
Replies: 11
Views: 8367

Re: 6.0.1 QueueView very slow and error message

Hi Roy, thanks for your reply. This helps, I found solution in postgres log. Load of index.pl?Action=AgentTicketQueue with 8 open tickets took about 5,5s (measurement in chromium dev console). Sum of postgres statements (while loading AgentTicketQueue) durations was ~5s. In pg log I found repeated s...
by petrj
08 Jan 2018, 18:54
Forum: Help
Topic: 6.0.1 QueueView very slow and error message
Replies: 11
Views: 8367

Re: 6.0.1 QueueView very slow and error message

Please, has anyone resolved this issue? Any ideas?

Could this be PostgreSQL related - do you ( akipt/ felix123) use postgres?

I'm considering downgrade OTRS (probably not posible) or new OTRS instance on 5.x without data migration...
Sadly, our agents are not able to use OTRS.
by petrj
30 Dec 2017, 20:11
Forum: Help
Topic: 6.0.1 QueueView very slow and error message
Replies: 11
Views: 8367

Re: 6.0.1 QueueView very slow and error message

We have very similar issue after upgrading OTRS from 5.0.20 to 6.0.3. Load of page index.pl?Action=AgentTicketQueue is realy slow, about 4s with 6 tickets in queue (10s with 17 tickets in queue). It's really difficult to use OTRS in this state. During loading AgentTicketQueue there is load in Postgr...