[Koha-bugs] [Bug 33972] Possible deadlock in C4::ImportBatch::SetimportBatchStatus from BatchCommitRecords

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

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

--- Comment #20 from Marcel de Rooy <m.de.rooy at rijksmuseum.nl> ---
(In reply to David Cook from comment #19)
> Side note: We assume that "Koha::Database->schema->storage->dbh" always
> returns the same database handle, but that's not necessarily true.
> 
> According to the documentation and source code at
> https://metacpan.org/pod/DBIx::Class::Storage::DBI#dbh it seems that it
> tries to fetch a cached database handle but if for whatever reason that
> cached database handle doesn't seem connected, it'll create a new handle and
> connect. 
> 
> Probably not related but just noticed that while looking at something else...

wait_timeout defaults to  28800 (seconds) == 8 hours. 
The worker is a continuous process. It does db reads itself for the job
details. At some point probably a _resultset call in Koha objects or so
triggers a reconnect and we get a new handle.
But this problem seems to be reproduced every time. The reconnect should
logically not occur when we already read job details and continue in the child?
So there must be something else going on too..

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