ÇÏÓÐÏÄÁ ÒÁÚÒÁÂÏÔÞÉËÉ! ÉÄÅÎÔÉÞÎÁÑ ÓÉÔÕ£×ÉÎÁ Ä×Á ÒÁÚÁ ÚÁ Ä×Å ÎÅÄÅÌÉ ÍÅÚÁÎÓÃÅÎÁ ÔÁËÁÑ
1. ÐÏÄËÌÀÞÅÎÉÑ Ë ÂÁÚÅ ÂÅÚ ÓÂÏÒËÉ ÍÕÓÏÒÁ 2. ÎÁÂÅÇÁÅÔ ÒÁÚÂÅÇ ÔÒÁÎÚÁËÃÉÊ (× ÐÏÓÌÅÄÎÉÊ ÒÁÚ ÂÙÌÏ ÏËÏÌÏ 180 000) 3. ÎÁ ÒÏÌÌÂÁËÅ ÓÅÒ×ÅÒ ÐÁÄÁÅÔ ×ÏÔ Ó ÔÁËÉÍ ÌÏÇÏÍ: PROLIANT (Server) Tue Apr 25 12:11:29 2006 Database: GOODS.GDB deadlock deadlock update conflicts with concurrent update operation was cancelled internal gds software consistency check (error during savepoint backout (290)) PROLIANT (Client) Tue Apr 25 12:13:02 2006 fbserver.exe: terminated abnormally (4294967295) 4. ÓÙÐÑÔÓÑ ðë (ÔÏ ÂÉÛØ ËÏÎÓÔÒÅÊÎÔÙ ×ÅÝÁÔØ ÎÁÞÉÎÁÀÔ Ï ÎÁÒÕÛÅÎÉÉ) ÍÙ Ó ÷ÌÁÄÏÍ óÁÎÙÞÅÍ 07.12.2005 ÉÍÅÌÉ ÞÁÓÔÎÙÊ ÒÁÚÇÏ×ÏÒ ÎÁ ÔÅÍÕ ÎÅËÏÒÒÅËÔÎÏÇÏ ÐÏ×ÅÄÅÎÉÑ ðë ÐÒÉ ÏÔËÌÀÞÅÎÎÏÊ ÓÂÏÒËÅ ÍÕÓÏÒÁ ÜÔÁ ÔÒÁÂÌÁ ÉÚ ÔÏÇÏ ÖÅ ÐÏÒÑÄËÁ? ======================================================== ÇÁÍÁÒÄÖÏÂÁ, ÷ÌÁÄ óÁÎÙÞ! ÓÌÕÈÁÊ, ÎÅ ×ÓÔÒÅÞÁÌÁÓØ ÔÁËÁÑ ÐÒÏÂÌÅÍÁ? recreate table a ( ID Integer not null primary key ,f1 Integer ,f2 Date); commit; insert into a values(1, 5, '01.01.05'); commit; insert into a values(2, 5, '01.01.05'); commit; delete from a where id=1; commit; create unique index a2 on a(f1, f2); attempt to store duplicate value (visible to active transactions) in unique index "A2". ======================================================== æ£ÄÏÒÏ× å×ÇÅÎÉÊ. úáï "ôÒÅÓÔ-í". åËÁÔÅÒÉÎÂÕÒÇ.
