IDS 11.? error 244
We have a web application using the PDO library (php). In one page we are doing a simple update where we update two fields in a table where a third field is a particular value. -ie- update my_table set field1='123', field2 = 'test' where field3 = '9928'; Normally this works with no problems, but recently we have been getting error -244 when we try this. As normal It "Always" happens to our production people, and "Seldom" happens to me which makes it VERY difficult to figure out. The way I read the finderr 244 output hints at a hardware problem. Anyone else seen this or have any hints here? Charlie
Charlie: I would make sure that you have updated statistics on the table, especially on field3. It looks like you update might not be using and index and doing a sequential scan and encountering a lock. If you do not have an index which has a leading column of field3, then this is your problem. John F. Miller III STSM, Support Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 09/02/2009 10:28:34 PM: > [image removed] > > IDS 11.? error 244 [16846] > > Charlie Wyble > > to: > > ids > > 09/02/2009 10:29 PM > > Sent by: > > ids-bounces@iiug.org > > Please respond to ids > > We have a web application using the PDO library (php). > In one page we are doing a simple update where we update two fields in a > table where a third field is a particular value. > -ie- update my_table set field1='123', field2 = 'test' where field3 = > '9928'; > > Normally this works with no problems, but recently we have been getting > error -244 when we try this. As normal It "Always" happens to our > production people, and "Seldom" happens to me which makes it VERY > difficult to figure out. > > The way I read the finderr 244 output hints at a hardware problem. > Anyone else seen this or have any hints here? > > Charlie > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
The error is likely just a lockout error. The ISAM error code would explain why the row could not be accessed. You probably just need to set the LOCK MODE TO WAIT <nseconds> in each connection so that transient locks do not prevent legitimate transactions from completing. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Sep 3, 2009 at 1:28 AM, Charlie Wyble <cwyble@verizon.net> wrote: > We have a web application using the PDO library (php). > In one page we are doing a simple update where we update two fields in a > table where a third field is a particular value. > -ie- update my_table set field1='123', field2 = 'test' where field3 = > '9928'; > > Normally this works with no problems, but recently we have been getting > error -244 when we try this. As normal It "Always" happens to our > production people, and "Seldom" happens to me which makes it VERY > difficult to figure out. > > The way I read the finderr 244 output hints at a hardware problem. > Anyone else seen this or have any hints here? > > Charlie > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0023545bd658d09e780472a6079f