db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From adam.s.allga...@exxonmobil.com
Subject Re: idbroker generates existing ID's
Date Thu, 15 Nov 2007 18:50:28 GMT
Do you have an "id_table" and a separate "ID_TABLE"?  I have run into that
before.




                                                                           
             "Hidde                                                        
             Boonstra [Us                                                  
             Media]"                                                    To 
             <hidde.boonstr           Apache Torque Users List             
             a@usmedia.nl>            <torque-user@db.apache.org>          
                                                                        cc 
                                                                           
             11/15/07 12:02                                        Subject 
             PM                       Re: idbroker generates existing ID's 
                                                                           
                                                                           
             Please respond                                                
                   to                                                      
             "Apache Torque                                                
              Users List"                                                  
             <torque-user@d                                                
             b.apache.org>                                                 
                                                                           
                                                                           
                                                                           
                                                                           




Hi will,

thanks for your response.

No, I don't. I have thought about the possibility of transactions (or
the lack of transactions) causing the problem, but since it also occurs
with Postgres I thought I could rule it out. The weird thing is that the
id_table states (for example) a next id of 180000 and a quantity of
1400, but the exception states it trying to insert an entry with id
24000. It does increment with each call (although I haven't tried 1400
calls). I have never had this problem with earlier version (i.e. pre 3.3
releases of Torque) and similar usage patterns.

Will Glass-Husain wrote:
> Are you having multiple servers or multiple applications access the
> database?   This can cause problems in the absence of transactions.
>
> WILL
>
> On Nov 15, 2007 5:40 AM, Hidde Boonstra [Us Media] <
> hidde.boonstra@usmedia.nl> wrote:
>
>> Hi all,
>>
>> we're experiencing some weird trouble while using the IDBroker. Two of
>> our sites (one running on MySQL 5.x + Torque 3.3-RC1 and one running on
>> Postgres 8.x + Torque 3.3-RC2) start throwing duplicate key exceptions
>> after running (without problems) for a while. The IDs generated are much
>> lower than the next_id entry in the id_table. When I restart the
>> application the problem is gone, but after a while (days/weeks) it
>> returns. Does anybody know what is going on, or has experienced similar
>> problems?
>>
>> Thanks in advanced,
>>
>> with kind regards,

--
Hidde Boonstra
Us Media B.V.
Stadhouderskade 115
1073 AX Amsterdam

t: 020 428 68 68
f: 020 470 69 05
www.usmedia.nl

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org




---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message