Home » Open Source » Programming Interfaces » SQL DBI Error
SQL DBI Error [message #232340] Fri, 20 April 2007 03:53 Go to next message
ehegagoka
Messages: 493
Registered: July 2005
Senior Member
Hi,
We have a perl script that runs every 30 minutes, but now we are getting this error



DBI execute FAIL -> ORA-01555: snapshot too old: rollback segment number 14 with name "RBS13" too small (DBD ERROR: error possibly near <*> indicator at char 149 in 'select distinct s.synergy_file, s.date_in_queue, s.lot, s.device, s.location, s.testertype, s.txflocs, s.que_reason, m.total_qty, m.datalog_qty from <*>synergy_queue s, metadata m where s.synergy_file = m.filepath and s.location = 'AMT_FM' and (s.que_reason = 'FT:GOOD' or s.que_reason = 'FT:EXTERNAL' or s.que_reason = 'FT:LOTDEV' or s.que_reason = 'FT:NOGZPFILE' or s.que_reason = 'FT:XMLFAIL1' or s.que_reason = 'FT:XMLFAIL2' or s.que_reason = 'FT:XMLFAIL3') and s.date_in_queue between (SYSDATE-5) and SYSDATE and m.category is not null and m.flot is not null and m.total_qty > 100  order by s.date_in_queue ASC, s.TESTERTYPE DESC') 





But when I run that SQL on pl/sql developer it says no rows returned. What could be causing the rollback error Sir/Mam?


Regards,
Rhani
Re: SQL DBI Error [message #232366 is a reply to message #232340] Fri, 20 April 2007 05:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Search for this error. It is one of the most discussed in the past 10 years (at least I started forums in 1997).
All what can be said has already been said on the subject.

In addition, when you use code tags break the lines, I can't find the "submit reply" button it is so far on the right.

Regards
Michel
Re: SQL DBI Error [message #232524 is a reply to message #232366] Fri, 20 April 2007 19:22 Go to previous messageGo to next message
ehegagoka
Messages: 493
Registered: July 2005
Senior Member
Hi,
it's not new to me also, im just wondering why it did not occur when i used it in plsql developer, can you explain why?
thanks for "break the lines.." ill add it in my "must not forget to do".
Regards,
Rhani
Re: SQL DBI Error [message #232525 is a reply to message #232340] Fri, 20 April 2007 20:19 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>im just wondering why it did not occur when i used it in plsql developer, can you explain why?
Please visit http://asktom.oracle.com & do keyword search on ORA-01555
In some cases the session which gets this error is the "victim" of another process which is furiously updating the database.
Re: SQL DBI Error [message #232599 is a reply to message #232525] Sat, 21 April 2007 22:03 Go to previous message
ehegagoka
Messages: 493
Registered: July 2005
Senior Member
Hi,
Thank you so much for your reply Sir, I'll check that.
Regards,
Rhani
Previous Topic: PHP on Oracle
Next Topic: Setup Env. Variables for PHP
Goto Forum:
  


Current Time: Thu Mar 28 08:29:56 CDT 2024