[Dbix-class] Undefined subroutine DBIx::Class::Exception::catch
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
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
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
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
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
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