Scarab ID_COUNT

FRED.YY.LIN 林宥延 <[email protected]> Wed, 28 Apr 2010 10:31:15 +0800
Newsgroups gmane.comp.java.scarab.user
Message-ID <[email protected]>
------=_Part_25145_1346820749.1272421880881
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: quoted-printable

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]
***************************************************************************=
**********************************************

------------------------------------------------------
http://scarab.tigris.org/ds/viewMessage.do?dsForumId=3D456&dsMessageId=3D25=
97642

To unsubscribe from this discussion, e-mail: [[email protected]=
is.org].
------=_Part_25145_1346820749.1272421880881
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><FONT face=3D=B7s=B2=D3=A9=FA=C5=E9 color=3D#0000ff><SPAN class=3D6863=
12002-28042010>Dear=20
All,</SPAN></FONT></DIV>
<DIV><FONT face=3D=B7s=B2=D3=A9=FA=C5=E9 color=3D#0000ff><SPAN=20
class=3D686312002-28042010></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=3D=B7s=B2=D3=A9=FA=C5=E9 color=3D#0000ff><SPAN class=3D6863=
12002-28042010>Everytime when=20
MySQL was restarted, all module ID jumps by 1.</SPAN></FONT></DIV>
<DIV><FONT face=3D=B7s=B2=D3=A9=FA=C5=E9 color=3D#0000ff><SPAN=20
class=3D686312002-28042010></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=3D=B7s=B2=D3=A9=FA=C5=E9 color=3D#0000ff><SPAN class=3D6863=
12002-28042010>For example=20
now is ABC1 and after MySQL restart again,&nbsp;next new issue&nbsp;jumps t=
o=20
ABC3.</SPAN></FONT></DIV>
<DIV><FONT face=3D=B7s=B2=D3=A9=FA=C5=E9 color=3D#0000ff><SPAN=20
class=3D686312002-28042010></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=3D=B7s=B2=D3=A9=FA=C5=E9 color=3D#0000ff><SPAN class=3D6863=
12002-28042010>I change the=20
ID count from ABC3 to ABC2 and restart tomcat again,&nbsp;the next new=20
issue&nbsp;still goes to ABC4</SPAN></FONT></DIV>
<DIV><FONT face=3D=B7s=B2=D3=A9=FA=C5=E9 color=3D#0000ff><SPAN=20
class=3D686312002-28042010></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=3D=B7s=B2=D3=A9=FA=C5=E9 color=3D#0000ff><SPAN class=3D6863=
12002-28042010>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=B7s=B2=D3=A9=FA=C5=E9 color=3D#0000ff><SPAN=20
class=3D686312002-28042010></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=3D=B7s=B2=D3=A9=FA=C5=E9 color=3D#0000ff><SPAN class=3D6863=
12002-28042010><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=B7s=B2=D3=A9=FA=C5=E9 color=3D#0000ff><SPAN=20
class=3D686312002-28042010></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=3D=B7s=B2=D3=A9=FA=C5=E9 color=3D#0000ff><SPAN class=3D6863=
12002-28042010>Can anyone=20
tell me where it is ?&nbsp; I check all the scarab and MySQL&nbsp;table but=
=20
didn't find it.</SPAN></FONT></DIV>
<DIV><FONT face=3D=B7s=B2=D3=A9=FA=C5=E9 color=3D#0000ff><SPAN=20
class=3D686312002-28042010></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=3D=B7s=B2=D3=A9=FA=C5=E9 color=3D#0000ff><SPAN class=3D6863=
12002-28042010>Or does anyone=20
know how the module issue id increments ?</SPAN></FONT></DIV>
<DIV><FONT face=3D=B7s=B2=D3=A9=FA=C5=E9 color=3D#0000ff><SPAN=20
class=3D686312002-28042010></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=3D=B7s=B2=D3=A9=FA=C5=E9 color=3D#0000ff><SPAN=20
class=3D686312002-28042010>Fred&nbsp;</SPAN></FONT></DIV></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_25145_1346820749.1272421880881--