If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > Not enough core

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-03-11, 05:02
ablodha ablodha is offline
Registered User
 
Join Date: Sep 2010
Posts: 3
Not enough core

I have a java tool which is executing insert statement in batch, but after some 250000 records it says that could not insert new rows. Not enough core.

When I have less records say (1000) it insert the records.

can anybody help what is this core and how to clear it. Is it java side error or the informix error.
Reply With Quote
  #2 (permalink)  
Old 11-16-11, 00:37
begooden-it begooden-it is offline
Registered User
 
Join Date: Sep 2011
Location: Pont l'Abbé, Brittany, France
Posts: 183
It might be an expected behaviour from informix in the case you are hitting a long transaction. This happens when the number of opérations within a single transaction exeeds the configured size of the logical log. Your application should receive a -458 Error, and in the engine log file you should see something like "Aborting Long Transaction: tx 0xHHHHHHHH username: user_name"
In this case, the solution is to add logical logs to the engine until the transaction succeeds.

If you don't have this error, this is probably a java side error, and I can't do anything for you :-(

Hope this helps
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On