RE: Scarab ID_COUNT
FRED.YY.LIN 林宥延 <[email protected]> Wed, 28 Apr 2010 13:52:29 +0800
| Newsgroups | gmane.comp.java.scarab.user |
|---|---|
| Message-ID | <[email protected]> |
------=_Part_25905_805913084.1272433953323 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Just found that I could modify the ID_Table next_id column to correct it af= ter MySQL restart. =20 But are there any way to prevent it ? or I need to manually modify it each = time I restart MySQL ? =20 Fred ________________________________ From: FRED.YY.LIN =E6=9E=97=E5=AE=A5=E5=BB=B6 [mailto:[email protected]= .TW]=20 Sent: Wednesday, April 28, 2010 10:31 AM To: [email protected] Subject: Scarab ID_COUNT Dear All, =20 Everytime when MySQL was restarted, all module ID jumps by 1. =20 For example now is ABC1 and after MySQL restart again, next new issue jumps= to ABC3. =20 I change the ID count from ABC3 to ABC2 and restart tomcat again, the next = new issue still goes to ABC4 =20 So this didn't work, it seems that Scarab didn't judge the last ID_Count an= d incremented by 1. =20 Although the scarab_issue does have ID_COUNT, the shall be somewhere store = the last ID, isn't it ? =20 Can anyone tell me where it is ? I check all the scarab and MySQL table bu= t didn't find it. =20 Or does anyone know how the module issue id increments ? =20 Fred=20 ***************************************************************************= ********************************************** This email message, including any attachments, is for the sole use of the i= ntended recipient(s) and may contain confidential and privileged informatio= n. Any unauthorized review, use, disclosure or distribution is prohibited. = If you are not the intended recipient, please contact the sender by reply e= -mail and destroy all copies of the original message. [Delta Electronic, IN= C. Taiwan] ***************************************************************************= ********************************************** =09 ***************************************************************************= ********************************************** This email message, including any attachments, is for the sole use of the i= ntended recipient(s) and may contain confidential and privileged informatio= n. Any unauthorized review, use, disclosure or distribution is prohibited. = If you are not the intended recipient, please contact the sender by reply e= -mail and destroy all copies of the original message. [Delta Electronic, IN= C. Taiwan] ***************************************************************************= ********************************************** ------------------------------------------------------ http://scarab.tigris.org/ds/viewMessage.do?dsForumId=3D456&dsMessageId=3D25= 97759 To unsubscribe from this discussion, e-mail: [[email protected]= is.org]. ------=_Part_25905_805913084.1272433953323 Content-Type: text/html; charset="big5" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD><TITLE></TITLE> <META http-equiv=3DContent-Type content=3D"text/html; charset=3Dbig5"> <META content=3D"MSHTML 6.00.2900.3603" name=3DGENERATOR></HEAD> <BODY text=3D#000000 bgColor=3D#ffffff> <DIV dir=3Dltr align=3Dleft><SPAN class=3D810155105-28042010><FONT face=3D= =B7s=B2=D3=A9=FA=C5=E9=20 color=3D#0000ff>Just found that I could modify the ID_Table next_id column = to=20 correct it after MySQL restart.</FONT></SPAN></DIV> <DIV dir=3Dltr align=3Dleft><SPAN class=3D810155105-28042010><FONT face=3D= =B7s=B2=D3=A9=FA=C5=E9=20 color=3D#0000ff></FONT></SPAN> </DIV> <DIV dir=3Dltr align=3Dleft><SPAN class=3D810155105-28042010><FONT face=3D= =B7s=B2=D3=A9=FA=C5=E9=20 color=3D#0000ff>But are there any way to prevent it ? or I need to manually= modify=20 it each time I restart MySQL ?</FONT></SPAN></DIV> <DIV dir=3Dltr align=3Dleft><SPAN class=3D810155105-28042010><FONT face=3D= =B7s=B2=D3=A9=FA=C5=E9=20 color=3D#0000ff></FONT></SPAN> </DIV> <DIV dir=3Dltr align=3Dleft><SPAN class=3D810155105-28042010><FONT face=3D= =B7s=B2=D3=A9=FA=C5=E9=20 color=3D#0000ff>Fred</FONT></SPAN></DIV><BR> <DIV class=3DOutlookMessageHeader lang=3Dzh-tw dir=3Dltr align=3Dleft> <HR tabIndex=3D-1> <FONT face=3DTahoma size=3D2><B>From:</B> FRED.YY.LIN =AAL=AB=C9=A9=B5=20 [mailto:[email protected]] <BR><B>Sent:</B> Wednesday, April 28, 201= 0=20 10:31 AM<BR><B>To:</B> [email protected]<BR><B>Subject:</B> Scarab=20 ID_COUNT<BR></FONT><BR></DIV> <DIV></DIV> <DIV><FONT face=3D?s?ө?olor=3D#0000ff><SPAN class=3D686312002-2804201= 0>Dear=20 All,</SPAN></FONT></DIV> <DIV><FONT face=3D?s?ө?olor=3D#0000ff><SPAN=20 class=3D686312002-28042010></SPAN></FONT> </DIV> <DIV><FONT face=3D?s?ө?olor=3D#0000ff><SPAN class=3D686312002-2804201= 0>Everytime when=20 MySQL was restarted, all module ID jumps by 1.</SPAN></FONT></DIV> <DIV><FONT face=3D?s?ө?olor=3D#0000ff><SPAN=20 class=3D686312002-28042010></SPAN></FONT> </DIV> <DIV><FONT face=3D?s?ө?olor=3D#0000ff><SPAN class=3D686312002-2804201= 0>For example now=20 is ABC1 and after MySQL restart again, next new issue jumps to=20 ABC3.</SPAN></FONT></DIV> <DIV><FONT face=3D?s?ө?olor=3D#0000ff><SPAN=20 class=3D686312002-28042010></SPAN></FONT> </DIV> <DIV><FONT face=3D?s?ө?olor=3D#0000ff><SPAN class=3D686312002-2804201= 0>I change the ID=20 count from ABC3 to ABC2 and restart tomcat again, the next new=20 issue still goes to ABC4</SPAN></FONT></DIV> <DIV><FONT face=3D?s?ө?olor=3D#0000ff><SPAN=20 class=3D686312002-28042010></SPAN></FONT> </DIV> <DIV><FONT face=3D?s?ө?olor=3D#0000ff><SPAN class=3D686312002-2804201= 0>So this didn't=20 work, it seems that Scarab didn't judge the last ID_Count and incremented b= y=20 1.</SPAN></FONT></DIV> <DIV><FONT face=3D?s?ө?olor=3D#0000ff><SPAN=20 class=3D686312002-28042010></SPAN></FONT> </DIV> <DIV><FONT face=3D?s?ө?olor=3D#0000ff><SPAN class=3D686312002-2804201= 0><SPAN=20 class=3D686312002-28042010>Although the scarab_issue does have ID_COUNT,=20 t</SPAN>he shall be somewhere store the last ID, isn't it ?</SPAN></FONT></= DIV> <DIV><FONT face=3D?s?ө?olor=3D#0000ff><SPAN=20 class=3D686312002-28042010></SPAN></FONT> </DIV> <DIV><FONT face=3D?s?ө?olor=3D#0000ff><SPAN class=3D686312002-2804201= 0>Can anyone tell=20 me where it is ? I check all the scarab and MySQL table but didn= 't=20 find it.</SPAN></FONT></DIV> <DIV><FONT face=3D?s?ө?olor=3D#0000ff><SPAN=20 class=3D686312002-28042010></SPAN></FONT> </DIV> <DIV><FONT face=3D?s?ө?olor=3D#0000ff><SPAN class=3D686312002-2804201= 0>Or does anyone=20 know how the module issue id increments ?</SPAN></FONT></DIV> <DIV><FONT face=3D?s?ө?olor=3D#0000ff><SPAN=20 class=3D686312002-28042010></SPAN></FONT> </DIV> <DIV><FONT face=3D?s?ө?olor=3D#0000ff><SPAN=20 class=3D686312002-28042010>Fred </SPAN></FONT></DIV> <TABLE> <TBODY> <TR> <TD bgColor=3D#ffffff><FONT=20 color=3D#000000>*****************************************************= ********************************************************************<BR>Thi= s=20 email message, including any attachments, is for the sole use of the= =20 intended recipient(s) and may contain confidential and privileged=20 information. Any unauthorized review, use, disclosure or distribution= is=20 prohibited. If you are not the intended recipient, please contact the= =20 sender by reply e-mail and destroy all copies of the original message= .=20 [Delta Electronic, INC.=20 Taiwan]<BR>**********************************************************= ***************************************************************<BR></FONT><= /TD></TR></TBODY></TABLE></BODY></HTML> <table><tr><td bgcolor=3D#ffffff><font color=3D#000000>********************= ***************************************************************************= **************************<br> This email message, including any attachments, is for the sole use of the i= ntended recipient(s) and may contain confidential and privileged informatio= n. Any unauthorized review, use, disclosure or distribution is prohibited. = If you are not the intended recipient, please contact the sender by reply e= -mail and destroy all copies of the original message. [Delta Electronic, IN= C. Taiwan]<br> ***************************************************************************= **********************************************<br> </font></td></tr></table> ------=_Part_25905_805913084.1272433953323--