Cucmber: Mysql::Error: query: not connected: ROLLBACK


#1

Hi,

I ran in trouble with unexpected rollbacks using cucumber 0.3.0.

My feature-file looks like

Scenario: Create Valid Item
Given I start

and the step is
Given /^I start$/ do
get “/items”
end

In my log/test.log I get
SQL (0.2ms) SET NAMES ‘utf8’
SQL (0.2ms) SET SQL_AUTO_IS_NULL=0
SQL (0.1ms) BEGIN

Processing ItemsController#index (for 127.0.0.1 at 2009-04-19 20:54:08)
[GET]
Item Load (0.2ms) SELECT * FROM items
Rendering template within layouts/application
Rendering items/index
Completed in 41ms (View: 30, DB: 1) | 200 OK
[http://www.example.com/items]
SQL (0.0ms) Mysql::Error: query: not connected: ROLLBACK

If using my browser directing it at /items in the test-environment I get

SQL (0.3ms) SET NAMES ‘utf8’
SQL (0.2ms) SET SQL_AUTO_IS_NULL=0

Processing ItemsController#index (for 192.168.192.1 at 2009-04-19
20:55:07) [GET]
Item Load (0.3ms) SELECT * FROM items
Rendering template within layouts/application
Rendering items/index
Completed in 35ms (View: 23, DB: 1) | 200 OK
[http://192.168.192.25/items]

(see also http://www.pastie.org/451600 for the logs)

Any idea what causes the error?

TIA,
Martin


#2

On Sun, Apr 19, 2009 at 8:56 PM, Martin removed_email_address@domain.invalid wrote:

Hi,

I ran in trouble with unexpected rollbacks using cucumber 0.3.0.

Probably the same issue as this:
https://rspec.lighthouseapp.com/projects/16211/tickets/284-rollbacks-not-working-as-expected

I haven’t found a solution yet, but I’m working on it. I could use some
help
to speed it up.

Aslak


#3

On Sun, Apr 19, 2009 at 10:16 PM, aslak hellesoy
removed_email_address@domain.invalidwrote:

https://rspec.lighthouseapp.com/projects/16211/tickets/284-rollbacks-not-working-as-expected

Scenario: Create Valid Item
SQL (0.1ms) BEGIN

20:55:07) [GET]

See my recent comment about config.cache_classes in the issue I
mentioned
above.

Did you change your test.rb to use
config.cache_classes = false
?

Can I see your test.rb?

Aslak


#4

On Mon, Apr 20, 2009 at 9:07 PM, Martin removed_email_address@domain.invalid wrote:

Hi Aslkak,

I have been called many things, but never that.

The bug is here:
https://rspec.lighthouseapp.com/projects/16211-cucumber/tickets/165

Aslak


#5

Hi Aslkak,

Did you change your test.rb to use
config.cache_classes = false
?

you’re right, I changed it because of rspec-server. Now I found the hint
on
http://wiki.github.com/dchelimsky/rspec/spec_server-autospec-nearly-pure-bdd-joy
that it breaks cucumber…

Thanks,
Martin