rspec users - Nov 2007 - Rollbacks, Sqlite3 bug. Has this been reintroduced ?

Hey,
I just updated from the edge and it looks like this _issue_ has resurfaced.
Yesterday things were working (stories  and specs).
No code base changes, only rspec and rspec_on_rails

After updating today I now need to set <config.txn...fixtures>  to  false
in
the spec_helper.rb
to get the specs running, the stories are fine. Looks like the fixture
loading is trying to start a txn.


I will look around a bit more and see.


Cheers!
sinclair



On Oct 24, 2007 10:58 PM, Scott Taylor <mailing_lists at railsnewbie.com>
wrote:
>
> Okay - so the sqlite bug reported a day or so ago on the list is real
> bug.  I''m going to file something in the tracker for that...
>
> I also learned that before(:all)...after(:all) is not wrapped in a
> transaction, the way before(:each)...after(:each) is.  Is there some
> reason behind this?  Can you not wrap transactions inside transactions?
>
> Scott
>
> _______________________________________________
> rspec-users mailing list
> rspec-users at rubyforge.org
> http://rubyforge.org/mailman/listinfo/rspec-users
>


-- 


Cheers!
sinclair
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://rubyforge.org/pipermail/rspec-users/attachments/20071129/0e062bbb/attachment.html

On Nov 29, 2007 10:55 AM, sinclair bain <rspec.user at gmail.com>
wrote:
> Hey,I just updated from the edge and it looks like this _issue_ has
> resurfaced.
>
> Yesterday things were working (stories  and specs).
> No code base changes, only rspec and rspec_on_rails
>
> After updating today I now need to set <config.txn...fixtures>  to 
false in
> the spec_helper.rb
> to get the specs running, the stories are fine. Looks like the fixture
> loading is trying to start a txn.
>
>
> I will look around a bit more and see.
I''m on it - will have a fix in about 5 minutes.
>
>
>
> Cheers!
> sinclair
>
>
>
> On Oct 24, 2007 10:58 PM, Scott Taylor <mailing_lists at railsnewbie.com
>
> wrote:
> >
> > Okay - so the sqlite bug reported a day or so ago on the list is real
> > bug.  I''m going to file something in the tracker for that...
> >
> > I also learned that before(:all)...after(:all) is not wrapped in a
> > transaction, the way before(:each)...after(:each) is.  Is there some
> > reason behind this?  Can you not wrap transactions inside
transactions?
> >
> > Scott
> >
> > _______________________________________________
> > rspec-users mailing list
> > rspec-users at rubyforge.org
> > http://rubyforge.org/mailman/listinfo/rspec-users
> >
>
>
>
> --
>
>
> Cheers!
> sinclair
> _______________________________________________
> rspec-users mailing list
> rspec-users at rubyforge.org
> http://rubyforge.org/mailman/listinfo/rspec-users
>

On Nov 29, 2007 1:55 PM, sinclair bain <rspec.user at gmail.com>
wrote:
> Hey,I just updated from the edge and it looks like this _issue_ has
> resurfaced.
>
> Yesterday things were working (stories  and specs).
> No code base changes, only rspec and rspec_on_rails
>
> After updating today I now need to set <config.txn...fixtures>  to 
false in
> the spec_helper.rb
> to get the specs running, the stories are fine. Looks like the fixture
> loading is trying to start a txn.
>
>
> I will look around a bit more and see.
>
If you are talking about sqlite3-ruby adapter [1] I have submitted a
issue regarding the rollbacks without transactions (#10765) [2]

A few things of the sqlite3 adapter seems not working as expected...
but it didn''t got updated since... a bit.

I ended switching to mysql for testing too, a bit too much, but at least works.

[1] http://rubyforge.org/projects/sqlite-ruby/
[2]
http://rubyforge.org/tracker/index.php?func=detail&aid=10765&group_id=254&atid=1043

-- 
Luis Lavena
Multimedia systems
-
Leaders are made, they are not born. They are made by hard effort,
which is the price which all of us must pay to achieve any goal that
is worthwhile.
Vince Lombardi

On Nov 29, 2007 11:06 AM, David Chelimsky <dchelimsky at gmail.com>
wrote:
> On Nov 29, 2007 10:55 AM, sinclair bain <rspec.user at gmail.com>
wrote:
> > Hey,I just updated from the edge and it looks like this _issue_ has
> > resurfaced.
> >
> > Yesterday things were working (stories  and specs).
> > No code base changes, only rspec and rspec_on_rails
> >
> > After updating today I now need to set <config.txn...fixtures> 
to  false in
> > the spec_helper.rb
> > to get the specs running, the stories are fine. Looks like the fixture
> > loading is trying to start a txn.
> >
> >
> > I will look around a bit more and see.
>
> I''m on it - will have a fix in about 5 minutes.
OK - this is fixed in r3014.

Basically, we''ve been moving some responsibilities around as we
improve interoperability w/ Test::Unit. A side effect was that setup
was getting called twice. Running the pre_commit task against mysql
didn''t show this problem because mysql is happy to run transactions
inside transactions.

Should be all good now.

Cheers,
David
>
>
> >
> >
> >
> > Cheers!
> > sinclair
> >
> >
> >
> > On Oct 24, 2007 10:58 PM, Scott Taylor <mailing_lists at
railsnewbie.com >
> > wrote:
> > >
> > > Okay - so the sqlite bug reported a day or so ago on the list is
real
> > > bug.  I''m going to file something in the tracker for
that...
> > >
> > > I also learned that before(:all)...after(:all) is not wrapped in
a
> > > transaction, the way before(:each)...after(:each) is.  Is there
some
> > > reason behind this?  Can you not wrap transactions inside
transactions?
> > >
> > > Scott
> > >
> > > _______________________________________________
> > > rspec-users mailing list
> > > rspec-users at rubyforge.org
> > > http://rubyforge.org/mailman/listinfo/rspec-users
> > >
> >
> >
> >
> > --
> >
> >
> > Cheers!
> > sinclair
> > _______________________________________________
> > rspec-users mailing list
> > rspec-users at rubyforge.org
> > http://rubyforge.org/mailman/listinfo/rspec-users
> >
>

Great !
As always thanks!

Cheers!
sinclair

On Nov 29, 2007 12:12 PM, David Chelimsky <dchelimsky at gmail.com> wrote:
> On Nov 29, 2007 11:06 AM, David Chelimsky <dchelimsky at gmail.com>
wrote:
> > On Nov 29, 2007 10:55 AM, sinclair bain <rspec.user at
gmail.com> wrote:
> > > Hey,I just updated from the edge and it looks like this _issue_
has
> > > resurfaced.
> > >
> > > Yesterday things were working (stories  and specs).
> > > No code base changes, only rspec and rspec_on_rails
> > >
> > > After updating today I now need to set
<config.txn...fixtures>  to
>  false in
> > > the spec_helper.rb
> > > to get the specs running, the stories are fine. Looks like the
fixture
> > > loading is trying to start a txn.
> > >
> > >
> > > I will look around a bit more and see.
> >
> > I''m on it - will have a fix in about 5 minutes.
>
> OK - this is fixed in r3014.
>
> Basically, we''ve been moving some responsibilities around as we
> improve interoperability w/ Test::Unit. A side effect was that setup
> was getting called twice. Running the pre_commit task against mysql
> didn''t show this problem because mysql is happy to run
transactions
> inside transactions.
>
> Should be all good now.
>
> Cheers,
> David
>
> >
> >
> > >
> > >
> > >
> > > Cheers!
> > > sinclair
> > >
> > >
> > >
> > > On Oct 24, 2007 10:58 PM, Scott Taylor <mailing_lists at
railsnewbie.com>
> > > wrote:
> > > >
> > > > Okay - so the sqlite bug reported a day or so ago on the
list is
> real
> > > > bug.  I''m going to file something in the tracker
for that...
> > > >
> > > > I also learned that before(:all)...after(:all) is not
wrapped in a
> > > > transaction, the way before(:each)...after(:each) is.  Is
there some
> > > > reason behind this?  Can you not wrap transactions inside
> transactions?
> > > >
> > > > Scott
> > > >
> > > > _______________________________________________
> > > > rspec-users mailing list
> > > > rspec-users at rubyforge.org
> > > > http://rubyforge.org/mailman/listinfo/rspec-users
> > > >
> > >
> > >
> > >
> > > --
> > >
> > >
> > > Cheers!
> > > sinclair
> > > _______________________________________________
> > > rspec-users mailing list
> > > rspec-users at rubyforge.org
> > > http://rubyforge.org/mailman/listinfo/rspec-users
> > >
> >
> _______________________________________________
> rspec-users mailing list
> rspec-users at rubyforge.org
> http://rubyforge.org/mailman/listinfo/rspec-users
>


-- 


Cheers!
sinclair
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://rubyforge.org/pipermail/rspec-users/attachments/20071129/1fcec716/attachment.html