Re: Perl script is killed by SIGPIPE

> Daniel Verite wrote:
> > Yogesh Sharma wrote:
>
> > We have found child script is killed by signal 13 SIGPIPE. When
> > duplicate key violates error occured, script is killed but not all time.
>
> "child script" and this kind of error suggests that a forked process inherits a database connection opened by a parent process.
>
> When the database handle goes out of scope, it might close the connection to the database, affecting the parent process too, since it's the same connection.
>
> If you're using DBI, it has a setting to avoid that issue:
> https://metacpan.org/pod/DBI#InactiveDestroy
>
> Aside from that, inherited connections can't be used simultaneously by parent and child process.
> In general, a child process should open and close its own connection.

In addition to Daniel's advice, be sure you have a try/catch around your DB work. If you've never used
something like that, check out Try::Tiny. Then in the catch, you can print $dbh->errstr() to see what's
really going on.

I think Daniel has it correct though that you may not have a valid $dbh, so this is an app error.

HTH,
Kevin