Can't merge tickets current transaction is aborted

Technical assistance
1
  • Used Zammad version: 5.2.1
  • Used Zammad installation type: package
  • Operating system: Ubuntu Server
  • Browser + version: Chrome

Expected behavior:

When merge two tickets I have successfull result (one active ticket with ibformation about two tickets).

Actual behavior:

I can’t merge two tickets becouse the error “FailedSQLTransaction: Errortransaction is aborted…”. Attached screenshot

Steps to reproduce the behavior:

Just merge two tickets
transaction

2

I’ll assume your using PostgreSQL, I would start with checking the logs.

tail -f /usr/local/var/log/postgres.log

My guess is you have a transaction failed or a malformed SQL transaction for whatever reason was passed to the DB, maybe datatype format etc… DMY, MDY as an example, ( could be anything, without a log i am guessing) and the DB failed to roll back or release the savepoint, you need to read the logs when it happens.

I would read the logs and restart the system before I would do anything else.

Thanks
Robert

1 Like
3

This error most likely is caused by e.g. a trigger with no longer existing information.
Have a look what trigger might be affected and correct those. Should work after that.

1 Like
4

This topic was automatically closed 120 days after the last reply. New replies are no longer allowed.