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

Prochaines sessions de formation

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)

Mardi 23 avril (10h30-12h)

Jeudi 16 mai (16h-17h30)

Jeudi 13 juin (10h30-12h)

  
 

Planifiez avec ProjeQtOr

3 et 4 avril (9h - 12h30)

  
 

Administrez avec ProjeQtOr

10 et 11 avril (9h - 12h30)

  

 

 
 

Getting SQLSTATE 25P02 Error

More
18 Jan 2021 06:28 #1 by divyesh
Getting SQLSTATE 25P02 Error was created 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 Connexion or Create an account to join the conversation.

More
23 Jan 2021 11:01 #2 by babynus
Replied by babynus on topic Getting SQLSTATE 25P02 Error
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 Connexion or Create an account to join the conversation.

More
23 Jan 2021 13:19 #3 by divyesh
Replied by divyesh on topic Getting SQLSTATE 25P02 Error
Thanks for response.
As per query no rows found.

Please Connexion or Create an account to join the conversation.

More
23 Jan 2021 18:29 #4 by babynus
Replied by babynus on topic Getting SQLSTATE 25P02 Error
So I think issue won't reproduce
Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
01 Fév 2021 10:57 #5 by divyesh
Replied by divyesh on topic Getting SQLSTATE 25P02 Error
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 Connexion or Create an account to join the conversation.

More
01 Fév 2021 11:15 #6 by babynus
Replied by babynus on topic Getting SQLSTATE 25P02 Error

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 Connexion or Create an account to join the conversation.

Moderators: babynus, protion
Time to create page: 0.045 seconds

Paramétrages de cookies

×

Cookies fonctionnels

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

Veuillez vous connecter pour voir vos activités!

Autres cookies

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

Login Form