Skip Menu |

This queue is for tickets about the DBD-Pg CPAN distribution.

Report information
The Basics
Id: 83017
Status: rejected
Priority: 0/
Queue: DBD-Pg
People
Owner: Nobody in particular
Requestors: purification [...] ukr.net
Cc:
AdminCc:
Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)

History Show all quoted text
  Mon Jan 28 17:13:53 2013 purification [...] ukr.net - Ticket created
Subject: [FEATURE REQUEST] DBD::Pg $sth with server-side prepares fails when executed in forked process due to unreliable prepare_name scheme
Date: Tue, 29 Jan 2013 00:13:37 +0200
To: bug-DBD-Pg [...] rt.cpan.org
From: retaliation <purification [...] ukr.net>
When $sth is prepared inside a forked process, and then executed multiple times in a forked processes, it fails in a second and all next calls due to forked process producing the same prepare_name. The current code is as follows: /* Name is "dbdpg_xPID_#", where x is 'p'ositive or 'n'egative */ sprintf(imp_sth->prepare_name,"dbdpg_%c%d_%d", (imp_dbh->pid_number < 0 ? 'n' : 'p'), abs(imp_dbh->pid_number), imp_dbh->prepare_number); I think it would be better if this code was replaced with a reliable scheme, for example UUID-based.
  Fri Feb 08 16:00:15 2013 greg [...] turnstep.com - Correspondence added
Not sure I understand - wouldn't forking create other problems? One cannot fork active database connections, as the messages will start interfering with each other.
  Fri Feb 08 16:00:16 2013 The RT System itself - Status changed from 'new' to 'open'
  Mon Sep 30 17:23:06 2013 dwheeler [...] cpan.org - Correspondence added
DBI handles do not work across forks. Use something like DBIx::Connector to get around that -- but even still, you cannot prepare a statement handle in one process and execute it in another.
  Mon Sep 30 17:23:07 2013 dwheeler [...] cpan.org - Status changed from 'open' to 'rejected'