# Debugging ActiveRecord.save failure

**URL:** <https://www.ruby-forum.com/t/debugging-activerecord-save-failure/145328>\
**Category:** Rails\
**Created:** [August 8, 2008, 1:45am UTC](https://www.ruby-forum.com/t/debugging-activerecord-save-failure/145328 "2008-08-08T01:45:52Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Aaron\_T](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/e79b87/32.png) [@Aaron\_T](https://www.ruby-forum.com/u/Aaron_T)\
**Post date:** [August 8, 2008, 1:45am UTC](https://www.ruby-forum.com/t/debugging-activerecord-save-failure/145328/1 "2008-08-08T01:45:52Z")

</div>

Trying to debug a ActiveRecord problem with creating new records:

> > a = Appliance.new(:serial =\> ‘0105-0000-0000-aaaa’)  
> > =\> #\<Appliance id: nil, serial: “0105-0000-0000-aaaa”,  
> > kickstart\_times: 0, first\_kickstart\_date: nil, last\_kickstart\_date:  
> > nil, pemfile: nil, lspci: nil, verify: nil, created\_at: nil,  
> > updated\_at: nil, kickstart\_mode: “disabled”, lspci\_log: nil,  
> > verify\_log: nil, ks\_log: nil, status: nil\>

> > a.save  
> > =\> false

> > a.save!  
> > ActiveRecord::RecordNotSaved: ActiveRecord::RecordNotSaved  
> > from  
> > /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active\_record/base.rb:2206:in  
> > `save_without_validation!' from /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/validations.rb:911:in `save\_without\_dirty!’  
> > from  
> > /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active\_record/dirty.rb:83:in  
> > `save_without_transactions!' from /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/transactions.rb:110:in `save!’  
> > from  
> > /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active\_record/connection\_adapters/abstract/database\_statements.rb:66:in  
> > `transaction' from /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/transactions.rb:79:in `transaction’  
> > from  
> > /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active\_record/transactions.rb:98:in  
> > `transaction' from /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/transactions.rb:110:in `save!’  
> > from  
> > /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active\_record/transactions.rb:118:in  
> > `rollback_active_record_state!' from /usr/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/transactions.rb:110:in `save!’  
> > from (irb):3

> > a.errors.full\_messages  
> > =\> []

I can edit/delete records via ActiveRecord just fine, and creating  
records manually via the sqlite3 shell works fine. Any suggestions on  
how to figure out what is causing the problem? I’m surprised there  
aren’t any listed errors.

–  
Aaron T.  
[http://synfin.net/](http://synfin.net/)  
[http://tcpreplay.synfin.net/](http://tcpreplay.synfin.net/) - Pcap editing and replay tools for Unix &  
Windows  
They that can give up essential liberty to obtain a little temporary  
safety deserve neither liberty nor safety. – Benjamin Franklin

---

<div class="post-metadata">

**Author:** ![Aaron\_T](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/e79b87/32.png) [@Aaron\_T](https://www.ruby-forum.com/u/Aaron_T)\
**Post date:** [August 8, 2008, 3:15pm UTC](https://www.ruby-forum.com/t/debugging-activerecord-save-failure/145328/2 "2008-08-08T15:15:29Z")

</div>

Hi Aaron,

Aaron T. wrote:

> =\> false  
>   
> I can edit/delete records via ActiveRecord just fine, and creating  
> records manually via the sqlite3 shell works fine. Any suggestions on  
> how to figure out what is causing the problem? I’m surprised there  
> aren’t any listed errors.

First thing I’d suspect is that my validations were doing something I  
didn’t  
expect. Try …  
a.save\_with\_validations(false)  
If the record saves successfully, look at your validations. If not,  
you’ll  
need to post some additional info about your models and migrations for  
us to  
be much help.

Best regards,  
Bill

---

<div class="post-metadata">

**Author:** ![Aaron\_T](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/e79b87/32.png) [@Aaron\_T](https://www.ruby-forum.com/u/Aaron_T)\
**Post date:** [August 8, 2008, 11:03pm UTC](https://www.ruby-forum.com/t/debugging-activerecord-save-failure/145328/3 "2008-08-08T23:03:31Z")

</div>

On Fri, Aug 8, 2008 at 6:14 AM, Bill W. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
wrote:

> > nil, pemfile: nil, lspci: nil, verify: nil, created\_at: nil,
> 
> First thing I’d suspect is that my validations were doing something I didn’t  
> expect. Try …  
> a.save\_with\_validations(false)  
> If the record saves successfully, look at your validations. If not, you’ll  
> need to post some additional info about your models and migrations for us to  
> be much help.

Thanks Bill. I actually tracked down the problem to a before\_create  
method which was returning false.

–  
Aaron T.  
[http://synfin.net/](http://synfin.net/)  
[http://tcpreplay.synfin.net/](http://tcpreplay.synfin.net/) - Pcap editing and replay tools for Unix &  
Windows  
They that can give up essential liberty to obtain a little temporary  
safety deserve neither liberty nor safety. – Benjamin Franklin
