[Catalyst] flash with DBIC session storage

[Perrin Harkins]

On 7/27/07, Tobias Kremer <list at funkreich.de> wrote:
> While hammering my site with ab (Apache bench) I'm getting loads of the
> the following error message:
>
> Couldn't render template "undef error -
> DBIx::Class::ResultSet::find_or_create(): DBI Exception:
> DBD::mysql::st execute failed: Duplicate entry
> 'flash:4f1bddce6c7828c27b2e47265f614109d4c21f19'
> for key 1 [for Statement "INSERT INTO sessions (id) VALUES (?)"
> with ParamValues: 0='flash:4f1bddce6c7828c27b2e47265f614109d4c21f19']
> at /usr/local/lib/perl5/site_perl/5.8.8/Catalyst/Plugin/
> Session/Store/DBIC/Delegate.pm line 52"
>
> Any ideas what's going on here and how to fix it?

Looks like you have a unique constraint on session.id and you tried to
insert the same one twice.  That sounds like a bug in your session
module to me.  It should be doing an update here, not an INSERT.
Something must be confusing it.

- Perrin