Thread: [Fwd: Re: How to trace client sql requests?]
On Fri, July 10, 2009 16:10, hubert depesz lubaczewski wrote: > > truncate. but first simple question - did you commit the inserts? > But if it were done with truncate then I would see truncate in the log file, yes? Second, I am working with PG through an ORM called ActiveRecord, part of the Rails framework. I do not see a COMMIT anywhere in the log. Should I? This is a test run using the Rails test, actually cucumber, environment. I know that they do some things differently with DB connections in this environment but I believe that this is limited to transactions and rollbacks. The thing is that this problem only arises when testing the script inside the test harness. In production it runs just fine. Further, if I list the contents of the table from a call in the test harness immediately prior to executing the script under test then the data is there. I do not know what is going on. -- *** E-Mail is NOT a SECURE channel *** James B. Byrne mailto:ByrneJB@Harte-Lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton, Ontario fax: +1 905 561 0757 Canada L8E 3C3 -- *** E-Mail is NOT a SECURE channel *** James B. Byrne mailto:ByrneJB@Harte-Lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton, Ontario fax: +1 905 561 0757 Canada L8E 3C3
On Jul 10, 2009, at 1:31 PM, James B. Byrne wrote: > > > On Fri, July 10, 2009 16:10, hubert depesz lubaczewski wrote: > >> >> truncate. but first simple question - did you commit the inserts? >> > > But if it were done with truncate then I would see truncate in the > log file, yes? > > Second, I am working with PG through an ORM called ActiveRecord, > part of the Rails framework. I do not see a COMMIT anywhere in the > log. Should I? This is a test run using the Rails test, actually > cucumber, environment. I know that they do some things differently > with DB connections in this environment but I believe that this is > limited to transactions and rollbacks. > > The thing is that this problem only arises when testing the script > inside the test harness. In production it runs just fine. Further, > if I list the contents of the table from a call in the test harness > immediately prior to executing the script under test then the data > is there. I'm not sure about cucumber but I'm fairly certain that the Rails test runs don't commit their transactions. That means that if the test that is not seeing the data is perhaps being run with a different db connection from that that inserted the data then it won't see it. Erik Jones, Database Administrator Engine Yard Support, Scalability, Reliability 866.518.9273 x 260 Location: US/Pacific IRC: mage2k