View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Getting SQLSTATE 25P02 Error - ProjeQtOr
 
 

Getting SQLSTATE 25P02 Error

More
18 Jan 2021 06:28 #1 by divyesh
We are using postgresql 13.1 in centos linux with Projeqtor 9.0.2 latest version.
We have two issues.
[1] We have enable history archiving which is reflecting sql state 23505 error in log file.
[2] Frequent Exception-[25P02] SQLSTATE[25P02]: In failed sql transaction: 7 ERROR:  current transaction is aborted, commands ignored until end of transaction block error is also reflected on user ticket entry screen.

Whole logs file while time of above issue is provided for further investigation.
Request you to please brief for above two issues.
 
Attachments:

Please Log in or Create an account to join the conversation.

More
23 Jan 2021 11:01 #2 by babynus
Hi,

You have duplicates : lines of history stored in historyarchive but still existing in history.

Delte these lines with the query
DELETE FROM `historyarchive` WHERE id IN (SELECT id from `history`);

This query will be added to V9.0.3 to avoid similar issues

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
23 Jan 2021 13:19 #3 by divyesh
Thanks for response.
As per query no rows found.

Please Log in or Create an account to join the conversation.

More
23 Jan 2021 18:29 #4 by babynus
So I think issue won't reproduce

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
01 Feb 2021 10:57 #5 by divyesh
Same errors encountered from user end after your reply.
Seems two different status from treatment window and GUI status modification produces this type of error.

Please Log in or Create an account to join the conversation.

More
01 Feb 2021 11:15 #6 by babynus

Seems two different status from treatment window and GUI status modification produces this type of error.

Sorry, I don't understand, could you explain use case that produces the error ?

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.043 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.