[Koha-bugs] [Bug 35462] New: "savepoint_0 does not exist" when saving patron

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35462

            Bug ID: 35462
           Summary: "savepoint_0 does not exist" when saving patron
 Change sponsored?: ---
           Product: Koha
           Version: 22.11
          Hardware: All
                OS: All
            Status: NEW
          Severity: major
          Priority: P5 - low
         Component: Patrons
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: magnus at libriotech.no
        QA Contact: testopia at bugs.koha-community.org
                CC: gmcharlt at gmail.com, kyle.m.hall at gmail.com

When trying to save a new patron, clicking on "Save" sends me right back to the
form for adding the new patron, but some of the information I entered is
missing (at least firstname and cardnumber). There is no error message
displayed. 

I see this in the logs: 

==> /var/log/koha/konaturvard/plack-error.log <==
DBIx::Class::Storage::DBI::mysql::_exec_svp_release(): DBI Exception:
DBD::mysql::db do failed: SAVEPOINT savepoint_0 does not exist at
/usr/share/koha/lib/Koha/Object.pm line 170
Patron creation failed! -
DBIx::Class::Storage::DBI::mysql::_exec_svp_release(): DBI Exception:
DBD::mysql::db do failed: SAVEPOINT savepoint_0 does not exist at
/usr/share/koha/lib/Koha/Object.pm line 170

The code around /usr/share/koha/lib/Koha/Object.pm line 170 looks like this (in
"sub store"):

169     try {
170         return $self->_result()->update_or_insert() ? $self : undef;
171     }

The error "Patron creation failed!" comes from members/memberentry.pl:

424 ###  Error checks should happen before this line.
425 $nok = $nok || scalar(@errors);
426 if ((!$nok) and $nodouble and ($op eq 'insert' or $op eq 'save')){
427     my $success;
428         if ($op eq 'insert'){
429                 # we know it's not a duplicate borrowernumber or there
would already be an error
430         delete $newdata{password2};
431         $patron = eval { Koha::Patron->new(\%newdata)->store };
432         if ( $@ ) {
433             # FIXME Urgent error handling here, we cannot fail without
relevant feedback
434             # Lot of code will need to be removed from this script to
handle exceptions raised by Koha::Patron->store
435             warn "Patron creation failed! - $@"; # Maybe we must die
instead of just warn
436             push @messages, {error => 'error_on_insert_patron'};
437             $op = "add";

This happens in two different instances on the same server, but not on other
servers with similar setups. 

Koha version: 22.11.10-2 (Debian packages)
OS: Ubuntu 18.04.6 LTS
DB: 10.3.38-MariaDB-0ubuntu0.20.04.1-log

Must be related to bug 26639, I guess.

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.