[Dbix-class] Undefined subroutine DBIx::Class::Exception::catch

2012-08-15 Thread Dave Howorth
Has anybody seen this eror message before?

  Undefined subroutine DBIx::Class::Exception::catch

All my programs that use DBIx::Class on a particular machine have just
broken and now die with that error message.

The reason is undoubtedly connected with some module upgrades I
performed yesterday. I was trying to install a module with a lot of
dependencies (GraphViz2) and though I ultimately aborted the install
because of a perl version dependency, there were a lot of other modules
upgraded and indeed new modules installed as part of the dependencies.

So I'm pretty sure that there's now some version conflict, but given how
many modules were touched, I suspect it will take me a while to track
down. If anybody recognizes the source of the error, I'd appreciate a
pointer.

FWIW, I just went to the DBIx::Class build directory and ran

  make
  make test

make apparently completed OK. make test produces lots of results like
this random example:

t/storage/disable_sth_caching.t .. Undefined subroutine
DBIx::Class::Exception::catch called at
/root/.cpan/build/DBIx-Class-0.08124-HpDxQQ/blib/lib/DBIx/Class/Exception.pm
line 58.
Compilation failed in require at t/lib/DBICTest.pm line 7.
BEGIN failed--compilation aborted at t/lib/DBICTest.pm line 7.
Compilation failed in require at t/storage/disable_sth_caching.t line 6.
BEGIN failed--compilation aborted at t/storage/disable_sth_caching.t line 6.
t/storage/disable_sth_caching.t .. Dubious, test
returned 255 (wstat 65280, 0xff00)
No subtests run


Thanks, Dave

___
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk


Re: [Dbix-class] DBIx::Class 0.08918 install fails? Was: Undefined subroutine DBIx::Class::Exception::catch

2012-08-15 Thread Dave Howorth
Dave Howorth wrote:
 Has anybody seen this eror message before?
 
   Undefined subroutine DBIx::Class::Exception::catch
 
 All my programs that use DBIx::Class on a particular machine have just
 broken and now die with that error message.

So after spending a fruitless few hours looking for the presumed
incompatibility (backward regression?), I decided it wasn't worth
spending any more time on and that I'd try to resolve the problem by
upgrading. But DBIx::Class fails to install (see below).

I see some people are having trouble using 0.08198. But is anybody
seeing failures on install?

Again, any suggestions on how to get this system working again would be
be greatly appreciated.

Cheers, Dave

[snip of successful tests]
t/storage/on_connect_do.t  ok
t/storage/ping_count.t ... ok
t/storage/quote_names.t .. ok
t/storage/reconnect.t  1/?
#   Failed test 'The operation succeeded'
#   at t/storage/reconnect.t line 69.
# died: DBIx::Class::Exception (DBIx::Class::ResultSet::search(): DBI
Exception: DBD::SQLite::db prepare_cached failed: disk I/O error [for
Statement SELECT me.artistid, me.name, me.rank, me.charfield FROM
artist me ORDER BY name DESC] at t/storage/reconnect.t line 68
# )

#   Failed test 'Three artists returned'
#   at t/storage/reconnect.t line 70.
#  got: 0
# expected: 3
# Looks like you failed 2 tests of 36.
t/storage/reconnect.t  Dubious, test
returned 2 (wstat 512, 0x200)
Failed 2/36 subtests
t/storage/replicated.t ... skipped: Test needs
MooseX::Types = 0.21
t/storage/source_bind_compat.t ... ok
t/storage/stats.t  ok
t/storage/txn.t .. ok
t/storage/txn_scope_guard.t .. ok
t/update/all.t ... ok
t/update/ident_cond.t  ok
t/update/type_aware.t  ok
t/zzz_perl_perf_bug.t  ok
t/zzz_sqlite_deadlock.t .. skipped: Skipping
test on plain module install

Test Summary Report
---
t/52leaks.t(Wstat: 0 Tests: 197
Failed: 0)
  TODO passed:   149
t/multi_create/existing_in_chain.t (Wstat: 0 Tests: 10
Failed: 0)
  TODO passed:   1-2, 5-6, 10
t/multi_create/reentrance_count.t  (Wstat: 0 Tests: 18
Failed: 0)
  TODO passed:   1-4, 6-10, 12, 15-16, 18
t/prefetch/via_search_related.t(Wstat: 0 Tests: 24
Failed: 0)
  TODO passed:   21-22
t/row/inflate_result.t (Wstat: 0 Tests: 12
Failed: 0)
  TODO passed:   3
t/storage/reconnect.t  (Wstat: 512 Tests: 36
Failed: 2)
  Failed tests:  5-6
  Non-zero exit status: 2
Files=279, Tests=20205, 325 wallclock secs ( 8.88 usr  2.04 sys + 269.56
cusr 18.32 csys = 298.80 CPU)
Result: FAIL
Failed 1/279 test programs. 2/20205 subtests failed.
make: *** [test_dynamic] Error 255
  FREW/DBIx-Class-0.08198.tar.gz
  /usr/bin/make test -- NOT OK
//hint// to see the cpan-testers results for installing this module, try:
  reports FREW/DBIx-Class-0.08198.tar.gz
Running make install
  make test had returned bad status, won't install without force
Failed during this command:
 FREW/DBIx-Class-0.08198.tar.gz   : make_test NO

cpan[2]

___
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk


Re: [Dbix-class] DBIx::Class 0.08918 install fails? Was: Undefined subroutine DBIx::Class::Exception::catch

2012-08-15 Thread Bill Moseley
On Wed, Aug 15, 2012 at 7:23 AM, Dave Howorth dhowo...@mrc-lmb.cam.ac.ukwrote:

 Dave Howorth wrote:
  Has anybody seen this eror message before?
 
Undefined subroutine DBIx::Class::Exception::catch
 
  All my programs that use DBIx::Class on a particular machine have just
  broken and now die with that error message.

 So after spending a fruitless few hours looking for the presumed
 incompatibility (backward regression?), I decided it wasn't worth
 spending any more time on and that I'd try to resolve the problem by
 upgrading. But DBIx::Class fails to install (see below).


HI Dave,

I had good luck with this version.  Might be worth a try since it's an easy
test.

https://metacpan.org/module/JROBINSON/DBIx-Class-0.08198_01/lib/DBIx/Class.pm





 I see some people are having trouble using 0.08198. But is anybody
 seeing failures on install?

 Again, any suggestions on how to get this system working again would be
 be greatly appreciated.

 Cheers, Dave

 [snip of successful tests]
 t/storage/on_connect_do.t  ok
 t/storage/ping_count.t ... ok
 t/storage/quote_names.t .. ok
 t/storage/reconnect.t  1/?
 #   Failed test 'The operation succeeded'
 #   at t/storage/reconnect.t line 69.
 # died: DBIx::Class::Exception (DBIx::Class::ResultSet::search(): DBI
 Exception: DBD::SQLite::db prepare_cached failed: disk I/O error [for
 Statement SELECT me.artistid, me.name, me.rank, me.charfield FROM
 artist me ORDER BY name DESC] at t/storage/reconnect.t line 68
 # )

 #   Failed test 'Three artists returned'
 #   at t/storage/reconnect.t line 70.
 #  got: 0
 # expected: 3
 # Looks like you failed 2 tests of 36.
 t/storage/reconnect.t  Dubious, test
 returned 2 (wstat 512, 0x200)
 Failed 2/36 subtests
 t/storage/replicated.t ... skipped: Test needs
 MooseX::Types = 0.21
 t/storage/source_bind_compat.t ... ok
 t/storage/stats.t  ok
 t/storage/txn.t .. ok
 t/storage/txn_scope_guard.t .. ok
 t/update/all.t ... ok
 t/update/ident_cond.t  ok
 t/update/type_aware.t  ok
 t/zzz_perl_perf_bug.t  ok
 t/zzz_sqlite_deadlock.t .. skipped: Skipping
 test on plain module install

 Test Summary Report
 ---
 t/52leaks.t(Wstat: 0 Tests: 197
 Failed: 0)
   TODO passed:   149
 t/multi_create/existing_in_chain.t (Wstat: 0 Tests: 10
 Failed: 0)
   TODO passed:   1-2, 5-6, 10
 t/multi_create/reentrance_count.t  (Wstat: 0 Tests: 18
 Failed: 0)
   TODO passed:   1-4, 6-10, 12, 15-16, 18
 t/prefetch/via_search_related.t(Wstat: 0 Tests: 24
 Failed: 0)
   TODO passed:   21-22
 t/row/inflate_result.t (Wstat: 0 Tests: 12
 Failed: 0)
   TODO passed:   3
 t/storage/reconnect.t  (Wstat: 512 Tests: 36
 Failed: 2)
   Failed tests:  5-6
   Non-zero exit status: 2
 Files=279, Tests=20205, 325 wallclock secs ( 8.88 usr  2.04 sys + 269.56
 cusr 18.32 csys = 298.80 CPU)
 Result: FAIL
 Failed 1/279 test programs. 2/20205 subtests failed.
 make: *** [test_dynamic] Error 255
   FREW/DBIx-Class-0.08198.tar.gz
   /usr/bin/make test -- NOT OK
 //hint// to see the cpan-testers results for installing this module, try:
   reports FREW/DBIx-Class-0.08198.tar.gz
 Running make install
   make test had returned bad status, won't install without force
 Failed during this command:
  FREW/DBIx-Class-0.08198.tar.gz   : make_test NO

 cpan[2]

 ___
 List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
 IRC: irc.perl.org#dbix-class
 SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
 Searchable Archive:
 http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk




-- 
Bill Moseley
mose...@hank.org
___
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk

Re: [Dbix-class] DBIx::Class 0.08918 install fails? Was: Undefined subroutine DBIx::Class::Exception::catch

2012-08-15 Thread Alejandro Imass
On Wed, Aug 15, 2012 at 10:48 AM, Bill Moseley mose...@hank.org wrote:


 On Wed, Aug 15, 2012 at 7:23 AM, Dave Howorth dhowo...@mrc-lmb.cam.ac.uk
 wrote:

 Dave Howorth wrote:
  Has anybody seen this eror message before?
 
Undefined subroutine DBIx::Class::Exception::catch
 
  All my programs that use DBIx::Class on a particular machine have just
  broken and now die with that error message.

 # died: DBIx::Class::Exception (DBIx::Class::ResultSet::search(): DBI
 Exception: DBD::SQLite::db prepare_cached failed: disk I/O error [for
 Statement SELECT me.artistid, me.name, me.rank, me.charfield FROM
 artist me ORDER BY name DESC] at t/storage/reconnect.t line 68
 # )

I had the exact same error last night whilst trying to install DBIC on
a new server. It has to do with a test that does some fancy moves to
the sqllite file and then tests the re-connect once the file is in
place again. I assumed it was a problem particular to my environment
because I was running in a FreeBSD Jail so I thought it was some Jail
restriction and since it was the only test failing I just forced the
install.

___
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk


Re: [Dbix-class] DBIx::Class 0.08918 install fails? Was: Undefined subroutine DBIx::Class::Exception::catch

2012-08-15 Thread Dave Howorth
Bill Moseley wrote:
 On Wed, Aug 15, 2012 at 7:23 AM, Dave Howorth 
 dhowo...@mrc-lmb.cam.ac.ukwrote:
 
 Dave Howorth wrote:
 Has anybody seen this eror message before?

   Undefined subroutine DBIx::Class::Exception::catch

 All my programs that use DBIx::Class on a particular machine have just
 broken and now die with that error message.
 So after spending a fruitless few hours looking for the presumed
 incompatibility (backward regression?), I decided it wasn't worth
 spending any more time on and that I'd try to resolve the problem by
 upgrading. But DBIx::Class fails to install (see below).

 
 HI Dave,
 
 I had good luck with this version.  Might be worth a try since it's an easy
 test.

Thanks for the suggestion. I had found that these test failures were
already reported [1] together with a suggested patch. So I applied the
patch and then it installed cleanly. Hopefully there'll be another
release soon.

The new version, or more probably one of the dependency upgrades, also
fixed the machine so my programs work again. So I'm just left with an
unexplained mystery as to exactly what the problem was. C'est la vie.

Cheers, Dave

[1] https://rt.cpan.org/Public/Bug/Display.html?id=78420

___
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk


[Dbix-class] Re: DateTime objects passed to search() are not supported properly

2012-08-15 Thread Bill Moseley
Pinging on this.   Is this new behavior?   I don't remember seeing these
warnings before -- and I am curious why the calling code needs to do this
instead of DBIC.   Sorry if I'm missing something here.

On Sun, Aug 5, 2012 at 10:26 AM, Bill Moseley mose...@hank.org wrote:

 Running tests saw this message:

 DBIx::Class::ResultSet::search(): DateTime objects passed to search() are
 not supported properly (InflateColumn::DateTime formats and settings are
 not respected.) See Formatting DateTime objects in queries in
 DBIx::Class::Manual::Cookbook.

 Cookbook suggests this:

   my $dtf = $schema-storage-datetime_parser;
   my $rs = $schema-resultset('users')-search(
 {
   signup_date = {
 -between = [
   $dtf-format_datetime($dt_start),
   $dtf-format_datetime($dt_end),
 ],
   }
 },
   );


 I'm curious.  If DBIC knows it's a DateTime object and DBIC has a method
 to format it correctly then why is there a warning?  Why not just format it?


 --
 Bill Moseley
 mose...@hank.org




-- 
Bill Moseley
mose...@hank.org
___
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk