sanpshot too old 
Author Message
 sanpshot too old

This is the situation. During batch processing, the UNIX shell script calls
a Pro*C program to extract data from a remote database and then insert the
data into a local table A. Once it is finished(commited), the shell script
then calls another one in background(using nohup) to create index for the
table A. It then continues running by updating another table. The program
uesd to create index return the error 'snapshot too old'. Sine the server is
dedicated to run one application and I am sure there is no other program
running to update table A at the same time, why will this error happen?


Wed, 18 Jun 1902 08:00:00 GMT
 sanpshot too old


Quote:

> This is the situation. During batch processing, the UNIX shell script
calls
> a Pro*C program to extract data from a remote database and then
insert the
> data into a local table A. Once it is finished(commited), the shell
script
> then calls another one in background(using nohup) to create index for
the
> table A. It then continues running by updating another table. The
program
> uesd to create index return the error 'snapshot too old'. Sine the
server is
> dedicated to run one application and I am sure there is no other
program
> running to update table A at the same time, why will this error
happen?

If there are in fact no other open transactions againt the table then
my best guess is you are running into the 1555 due to delayed block
clean-out.  I am not sure why, and do not think you should be getting
an error, but I do not know what else it could be so try performing a
select count(*) from A before running the build index script.  Also
make sure the commit is issued before the build index script is
nohup'd.
--
Mark D. Powell -- The only advice that counts is the advice that
you follow so follow your own advice --

Sent via Deja.com http://www.deja.com/
Before you buy.



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. table sanpshot

2. sanpshot output

3. sanpshot replication with immediating update

4. testing last sanpshot in QNX platform

5. testing last sanpshot in QNX platform

6. Replicating (sanpshot replication) Referenced tables

7. OLD YES VERY OLD SYSTEM - HELP PLEASE

8. Old Old databases and VB5

9. Old Old versions

10. Import old Forms, Queries, Reports from old Access database to sql 2000

11. Master, msdb and model (old version and new version) i need old version

12. Import old Forms, Queries, Reports from old Access database to sql 2000


 
Powered by phpBB® Forum Software