[Catalyst] Session::Store::DBIC and session table (postgres)

[Fernan Aguero]

On Wed, Nov 14, 2012 at 3:09 PM, Francisco Obispo <fobispo at isc.org> wrote:

> Did you use the dbicdump script (or myapp_create.pl model) command to
> create the schema files?
>
> I would suggest you look to see how the 'sessions' table was created and
> use that as the name for the relation.
>
> regards
>

I did not use the dbicdump script originally (these were tables from an old
app). I generated all schema classes using

perl -MDBIx::Class::Schema::Loader=3Ddump_to_dir:lib/ -Mschemaname -e1

where schemaname was a DBIx::Class::Schema::Loader class specifying
connection and loader options (e.g. schema).


However, I've now tried the newer dbicdump script, and still get the same
error:

[debug] Scheduler: Executing /cron/remove_sessions
[error] Scheduler: Error executing /cron/remove_sessions:
DBIx::Class::ResultSet::delete(): DBI Exception: DBD::Pg::st execute
failed: ERROR:  relation "sessions" does not exist [for Statement "DELETE
FROM sessions WHERE ( expires < ? )" with ParamValues: 1=3D'1352925249'] at
/home/fernan/perl5/lib/perl5/Catalyst/Plugin/Session/Store/DBIC.pm

The new classes are slightly different:
lib/GUS/Webapp/Sessions.pm (old)
lib/GUS/Result/WebappSession.pm (new)

but still they both call
__PACKAGE__->table("webapp.sessions");

and function with no issues for creating new sessions in the Pg storage,
updating the session_data, etc. They're only failing at the DELETE
statement, and from the error it is clear that they're failing to fully
qualify the table name.


I'm now CCing FLORA to see if he's aware of this behaviour and/or can help
see if it falls into the Session::Store::DBIC realm ...

Thanks again for all responses!


-- =

fernan
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/catalyst/attachments/20121114/bd65d=
c37/attachment.htm