Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

while query identity field encounter a strange issue

3 posts in General Discussion Last posting was on 2012-09-12 08:42:30.0Z
wangtw Posted on 2012-09-12 06:25:47.0Z
Sender: 5b95.50502a67.1804289383@sybase.com
From: wangtw
Newsgroups: sybase.public.ase.general
Subject: while query identity field encounter a strange issue
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <50502aeb.5bc5.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 11 Sep 2012 23:25:47 -0700
X-Trace: forums-1-dub 1347431147 172.20.134.41 (11 Sep 2012 23:25:47 -0700)
X-Original-Trace: 11 Sep 2012 23:25:47 -0700, 172.20.134.41
Lines: 133
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31377
Article PK: 74272

ase is not cluster
select @@version output:
Adaptive Server Enterprise/15.0.3/EBF 16555 ESD#1/P/Linux
Intel/Linux 2.6.9-42.ELsmp i686/ase1503/2680/32-bit/FBO/Thu
Mar 5 04:50:21 2009

My pseudo code&#65306;
static int num1 = 0;
while(true) {
sql = "select field1,field2,field3,field4 form table where
field4 between num1 and num1+500";
resultset = db.exe(sql);
if (resultset.hasNext()) {
int maxV = 0;
while(resultset.next) {
if(resultset.getInt(4) > maxV ) {
naxV = resultset.getInt(4);
}
//other code
}
num1 = maxV + 1;
}
else {
//query min field from table
select min(field4) from table;
if (min(field4) > num1) {
num1 = min(field4);
}
}
}
in my act environment&#65292;things as follows&#65306;
in progarm query sql is "select
create_time,send_time,plan_send_time,priority,counter from
table o where ((plan_Send_Time=null and counter between
72336 and 72835))",create_time is record
created_time,send_time is record doned time,plan_send_time
is record to be process time,couner is a
identity&#65292;this sql query out 62
records&#65292;max(counter) is 72803,min(counter) is
72341&#12290;

but int the table&#65292;records are:
create_time,send_time,plan_send_time,priority,counter
2012-09-07 08:41:15.816,2012-09-07 08:41:19.273,,'1',72341
2012-09-07 08:41:15.843,2012-09-07 08:41:19.273,,'1',72347
2012-09-07 08:41:15.873,2012-09-07 08:41:19.273,,'1',72354
2012-09-07 08:41:15.89,2012-09-07 08:41:19.273,,'1',72356
2012-09-07 08:41:15.9,2012-09-07 08:41:19.273,,'1',72359
2012-09-07 08:41:15.916,2012-09-07 08:41:19.273,,'1',72363
2012-09-07 08:41:15.933,2012-09-07 08:41:19.273,,'1',72369
2012-09-07 08:41:15.97,2012-09-07 08:41:19.273,,'1',72377
2012-09-07 08:41:16.016,2012-09-07 08:41:19.273,,'1',72384
2012-09-07 08:41:16.046,2012-09-07 08:41:19.273,,'1',72392
2012-09-07 08:41:16.073,2012-09-07 08:41:19.273,,'1',72398
2012-09-07 08:41:16.116,2012-09-07 08:41:19.273,,'1',72404
2012-09-07 08:41:16.143,2012-09-07 08:41:19.273,,'1',72410
2012-09-07 08:41:16.17,2012-09-07 08:41:19.273,,'1',72417
2012-09-07 08:41:16.2,2012-09-07 08:41:19.273,,'1',72420
2012-09-07 08:41:16.226,2012-09-07 08:41:19.273,,'1',72427
2012-09-07 08:41:16.253,2012-09-07 08:41:19.273,,'1',72434
2012-09-07 08:41:16.28,2012-09-07 08:41:19.273,,'1',72440
2012-09-07 08:41:16.306,2012-09-07 08:41:19.273,,'1',72444
2012-09-07 08:41:16.326,2012-09-07 08:41:19.273,,'1',72449
2012-09-07 08:41:16.356,2012-09-07 08:41:19.273,,'1',72457
2012-09-07 08:41:16.39,2012-09-07 08:41:19.273,,'1',72461
2012-09-07 08:41:16.42,2012-09-07 08:41:19.273,,'1',72466
2012-09-07 08:41:16.446,2012-09-07 08:41:19.273,,'1',72474
2012-09-07 08:41:16.476,2012-09-07 08:41:19.27,,'1',72481
2012-09-07 08:41:16.523,2012-09-07 08:41:19.27,,'1',72489
2012-09-07 08:41:16.573,2012-09-07 08:41:19.27,,'1',72495
2012-09-07 08:41:16.6,2012-09-07 08:41:19.27,,'1',72502
2012-09-07 08:41:16.626,2012-09-07 08:41:19.273,,'1',72507
2012-09-07 08:41:16.656,2012-09-07 08:41:19.27,,'1',72511
2012-09-07 08:41:16.693,2012-09-07 08:41:19.27,,'1',72517
2012-09-07 08:41:16.733,2012-09-07 08:41:19.273,,'1',72528
2012-09-07 08:41:16.76,2012-09-07 08:41:19.27,,'1',72536
2012-09-07 08:41:16.786,2012-09-07 08:41:19.273,,'1',72541
2012-09-07 08:41:16.826,2012-09-07 08:41:19.273,,'1',72548
2012-09-07 08:41:16.853,2012-09-07 08:41:19.273,,'1',72556
2012-09-07 08:41:16.88,2012-09-07 08:41:19.273,,'1',72562
2012-09-07 08:41:16.913,2012-09-07 08:41:19.273,,'1',72563
2012-09-07 08:41:16.926,2012-09-07 08:41:19.273,,'1',72564
2012-09-07 08:41:16.956,2012-09-07 08:41:19.273,,'1',72565
2012-09-07 08:41:16.98,2012-09-07 09:15:09.54,,'1',72568
2012-09-07 08:41:17.01,2012-09-07 09:15:09.54,,'1',72575
2012-09-07 08:41:17.036,2012-09-07 09:15:09.54,,'1',72581
2012-09-07 08:41:17.073,2012-09-07 09:15:09.54,,'1',72589
2012-09-07 08:41:17.1,2012-09-07 09:15:09.54,,'1',72595
2012-09-07 08:41:17.13,2012-09-07 09:15:09.54,,'1',72601
2012-09-07 08:41:17.16,2012-09-07 09:15:09.54,,'1',72609
2012-09-07 08:41:17.186,2012-09-07 09:15:09.54,,'1',72615
2012-09-07 08:41:17.233,2012-09-07 09:15:09.54,,'1',72621
2012-09-07 08:41:17.26,2012-09-07 09:15:09.54,,'1',72627
2012-09-07 08:41:17.286,2012-09-07 09:15:09.54,,'1',72629
2012-09-07 08:41:17.316,2012-09-07 09:15:09.54,,'1',72636
2012-09-07 08:41:17.343,2012-09-07 09:15:09.54,,'1',72644
2012-09-07 08:41:17.346,2012-09-07 09:15:09.54,,'1',72646
2012-09-07 08:41:17.37,2012-09-07 09:15:09.54,,'1',72653
2012-09-07 08:41:17.396,2012-09-07 09:15:09.54,,'1',72656
2012-09-07 08:41:17.436,2012-09-07 09:15:09.54,,'1',72663
2012-09-07 08:41:17.466,2012-09-07 09:15:09.54,,'1',72671
2012-09-07 08:41:17.493,2012-09-07 08:41:19.273,,'1',72677
2012-09-07 08:41:17.536,2012-09-07 08:41:19.273,,'1',72684
2012-09-07 08:41:17.566,2012-09-07 08:41:19.273,,'1',72691
2012-09-07 08:41:17.593,2012-09-07 08:41:19.273,,'1',72698
2012-09-07 08:41:17.64,2012-09-07 08:41:19.273,,'1',72703
2012-09-07 08:41:17.666,2012-09-07 08:41:19.273,,'1',72709
2012-09-07 08:41:17.693,2012-09-07 08:41:19.273,,'1',72716
2012-09-07 08:41:17.723,2012-09-07 08:41:19.273,,'1',72721
2012-09-07 08:41:17.75,2012-09-07 08:41:19.273,,'1',72728
2012-09-07 08:41:17.776,2012-09-07 08:41:19.273,,'1',72735
2012-09-07 08:41:17.803,2012-09-07 08:41:19.273,,'1',72740
2012-09-07 08:41:17.84,2012-09-07 08:41:19.273,,'1',72747
2012-09-07 08:41:17.866,2012-09-07 08:41:19.273,,'1',72752
2012-09-07 08:41:17.896,2012-09-07 08:41:19.273,,'1',72759
2012-09-07 08:41:17.923,2012-09-07 08:41:19.273,,'1',72763
2012-09-07 08:41:17.95,2012-09-07 08:41:19.273,,'1',72770
2012-09-07 08:41:17.97,2012-09-07 08:41:19.273,,'1',72775
2012-09-07 08:41:17.976,2012-09-07 08:41:19.273,,'1',72778
2012-09-07 08:41:18.003,2012-09-07 08:41:19.273,,'1',72782
2012-09-07 08:41:18.043,2012-09-07 08:41:19.273,,'1',72789
2012-09-07 08:41:18.07,2012-09-07 08:41:19.273,,'1',72797
2012-09-07 08:41:18.096,2012-09-07 08:41:19.273,,'1',72803
2012-09-07 08:41:18.143,2012-09-07 08:41:20.466,,'1',72810
2012-09-07 08:41:18.17,2012-09-07 08:41:20.466,,'1',72817
2012-09-07 08:41:18.196,2012-09-07 08:41:20.466,,'1',72824
2012-09-07 08:41:18.246,2012-09-07 08:41:20.466,,'1',72831

counter from 72568 to 72671 are missed records&#65292;They
had processed when i restart my program&#65292;the send_time
is 2012-09-07 09:15:09.
becourse my english is poor&#65292;please forgive me!
thands!


Rob V Posted on 2012-09-12 08:42:30.0Z
From: Rob V <rob@sypron.nl>
Reply-To: rob@sypron.nl
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:15.0) Gecko/20120907 Thunderbird/15.0.1
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: while query identity field encounter a strange issue
References: <50502aeb.5bc5.1681692777@sybase.com>
In-Reply-To: <50502aeb.5bc5.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <50504af6$1@forums-1-dub>
Date: 12 Sep 2012 01:42:30 -0700
X-Trace: forums-1-dub 1347439350 172.20.134.152 (12 Sep 2012 01:42:30 -0700)
X-Original-Trace: 12 Sep 2012 01:42:30 -0700, vip152.sybase.com
Lines: 159
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31379
Article PK: 74266


On 12-Sep-2012 08:25, wangtw wrote:
> ase is not cluster
> select @@version output:
> Adaptive Server Enterprise/15.0.3/EBF 16555 ESD#1/P/Linux
> Intel/Linux 2.6.9-42.ELsmp i686/ase1503/2680/32-bit/FBO/Thu
> Mar 5 04:50:21 2009
>
> My pseudo code&#65306;
> static int num1 = 0;
> while(true) {
> sql = "select field1,field2,field3,field4 form table where
> field4 between num1 and num1+500";
> resultset = db.exe(sql);
> if (resultset.hasNext()) {
> int maxV = 0;
> while(resultset.next) {
> if(resultset.getInt(4) > maxV ) {
> naxV = resultset.getInt(4);
> }
> //other code
> }
> num1 = maxV + 1;
> }
> else {
> //query min field from table
> select min(field4) from table;
> if (min(field4) > num1) {
> num1 = min(field4);
> }
> }
> }
> in my act environment&#65292;things as follows&#65306;
> in progarm query sql is "select
> create_time,send_time,plan_send_time,priority,counter from
> table o where ((plan_Send_Time=null and counter between
> 72336 and 72835))",create_time is record
> created_time,send_time is record doned time,plan_send_time
> is record to be process time,couner is a
> identity&#65292;this sql query out 62
> records&#65292;max(counter) is 72803,min(counter) is
> 72341&#12290;
>
> but int the table&#65292;records are:
> create_time,send_time,plan_send_time,priority,counter
> 2012-09-07 08:41:15.816,2012-09-07 08:41:19.273,,'1',72341
> 2012-09-07 08:41:15.843,2012-09-07 08:41:19.273,,'1',72347
> 2012-09-07 08:41:15.873,2012-09-07 08:41:19.273,,'1',72354
> 2012-09-07 08:41:15.89,2012-09-07 08:41:19.273,,'1',72356
> 2012-09-07 08:41:15.9,2012-09-07 08:41:19.273,,'1',72359
> 2012-09-07 08:41:15.916,2012-09-07 08:41:19.273,,'1',72363
> 2012-09-07 08:41:15.933,2012-09-07 08:41:19.273,,'1',72369
> 2012-09-07 08:41:15.97,2012-09-07 08:41:19.273,,'1',72377
> 2012-09-07 08:41:16.016,2012-09-07 08:41:19.273,,'1',72384
> 2012-09-07 08:41:16.046,2012-09-07 08:41:19.273,,'1',72392
> 2012-09-07 08:41:16.073,2012-09-07 08:41:19.273,,'1',72398
> 2012-09-07 08:41:16.116,2012-09-07 08:41:19.273,,'1',72404
> 2012-09-07 08:41:16.143,2012-09-07 08:41:19.273,,'1',72410
> 2012-09-07 08:41:16.17,2012-09-07 08:41:19.273,,'1',72417
> 2012-09-07 08:41:16.2,2012-09-07 08:41:19.273,,'1',72420
> 2012-09-07 08:41:16.226,2012-09-07 08:41:19.273,,'1',72427
> 2012-09-07 08:41:16.253,2012-09-07 08:41:19.273,,'1',72434
> 2012-09-07 08:41:16.28,2012-09-07 08:41:19.273,,'1',72440
> 2012-09-07 08:41:16.306,2012-09-07 08:41:19.273,,'1',72444
> 2012-09-07 08:41:16.326,2012-09-07 08:41:19.273,,'1',72449
> 2012-09-07 08:41:16.356,2012-09-07 08:41:19.273,,'1',72457
> 2012-09-07 08:41:16.39,2012-09-07 08:41:19.273,,'1',72461
> 2012-09-07 08:41:16.42,2012-09-07 08:41:19.273,,'1',72466
> 2012-09-07 08:41:16.446,2012-09-07 08:41:19.273,,'1',72474
> 2012-09-07 08:41:16.476,2012-09-07 08:41:19.27,,'1',72481
> 2012-09-07 08:41:16.523,2012-09-07 08:41:19.27,,'1',72489
> 2012-09-07 08:41:16.573,2012-09-07 08:41:19.27,,'1',72495
> 2012-09-07 08:41:16.6,2012-09-07 08:41:19.27,,'1',72502
> 2012-09-07 08:41:16.626,2012-09-07 08:41:19.273,,'1',72507
> 2012-09-07 08:41:16.656,2012-09-07 08:41:19.27,,'1',72511
> 2012-09-07 08:41:16.693,2012-09-07 08:41:19.27,,'1',72517
> 2012-09-07 08:41:16.733,2012-09-07 08:41:19.273,,'1',72528
> 2012-09-07 08:41:16.76,2012-09-07 08:41:19.27,,'1',72536
> 2012-09-07 08:41:16.786,2012-09-07 08:41:19.273,,'1',72541
> 2012-09-07 08:41:16.826,2012-09-07 08:41:19.273,,'1',72548
> 2012-09-07 08:41:16.853,2012-09-07 08:41:19.273,,'1',72556
> 2012-09-07 08:41:16.88,2012-09-07 08:41:19.273,,'1',72562
> 2012-09-07 08:41:16.913,2012-09-07 08:41:19.273,,'1',72563
> 2012-09-07 08:41:16.926,2012-09-07 08:41:19.273,,'1',72564
> 2012-09-07 08:41:16.956,2012-09-07 08:41:19.273,,'1',72565
> 2012-09-07 08:41:16.98,2012-09-07 09:15:09.54,,'1',72568
> 2012-09-07 08:41:17.01,2012-09-07 09:15:09.54,,'1',72575
> 2012-09-07 08:41:17.036,2012-09-07 09:15:09.54,,'1',72581
> 2012-09-07 08:41:17.073,2012-09-07 09:15:09.54,,'1',72589
> 2012-09-07 08:41:17.1,2012-09-07 09:15:09.54,,'1',72595
> 2012-09-07 08:41:17.13,2012-09-07 09:15:09.54,,'1',72601
> 2012-09-07 08:41:17.16,2012-09-07 09:15:09.54,,'1',72609
> 2012-09-07 08:41:17.186,2012-09-07 09:15:09.54,,'1',72615
> 2012-09-07 08:41:17.233,2012-09-07 09:15:09.54,,'1',72621
> 2012-09-07 08:41:17.26,2012-09-07 09:15:09.54,,'1',72627
> 2012-09-07 08:41:17.286,2012-09-07 09:15:09.54,,'1',72629
> 2012-09-07 08:41:17.316,2012-09-07 09:15:09.54,,'1',72636
> 2012-09-07 08:41:17.343,2012-09-07 09:15:09.54,,'1',72644
> 2012-09-07 08:41:17.346,2012-09-07 09:15:09.54,,'1',72646
> 2012-09-07 08:41:17.37,2012-09-07 09:15:09.54,,'1',72653
> 2012-09-07 08:41:17.396,2012-09-07 09:15:09.54,,'1',72656
> 2012-09-07 08:41:17.436,2012-09-07 09:15:09.54,,'1',72663
> 2012-09-07 08:41:17.466,2012-09-07 09:15:09.54,,'1',72671
> 2012-09-07 08:41:17.493,2012-09-07 08:41:19.273,,'1',72677
> 2012-09-07 08:41:17.536,2012-09-07 08:41:19.273,,'1',72684
> 2012-09-07 08:41:17.566,2012-09-07 08:41:19.273,,'1',72691
> 2012-09-07 08:41:17.593,2012-09-07 08:41:19.273,,'1',72698
> 2012-09-07 08:41:17.64,2012-09-07 08:41:19.273,,'1',72703
> 2012-09-07 08:41:17.666,2012-09-07 08:41:19.273,,'1',72709
> 2012-09-07 08:41:17.693,2012-09-07 08:41:19.273,,'1',72716
> 2012-09-07 08:41:17.723,2012-09-07 08:41:19.273,,'1',72721
> 2012-09-07 08:41:17.75,2012-09-07 08:41:19.273,,'1',72728
> 2012-09-07 08:41:17.776,2012-09-07 08:41:19.273,,'1',72735
> 2012-09-07 08:41:17.803,2012-09-07 08:41:19.273,,'1',72740
> 2012-09-07 08:41:17.84,2012-09-07 08:41:19.273,,'1',72747
> 2012-09-07 08:41:17.866,2012-09-07 08:41:19.273,,'1',72752
> 2012-09-07 08:41:17.896,2012-09-07 08:41:19.273,,'1',72759
> 2012-09-07 08:41:17.923,2012-09-07 08:41:19.273,,'1',72763
> 2012-09-07 08:41:17.95,2012-09-07 08:41:19.273,,'1',72770
> 2012-09-07 08:41:17.97,2012-09-07 08:41:19.273,,'1',72775
> 2012-09-07 08:41:17.976,2012-09-07 08:41:19.273,,'1',72778
> 2012-09-07 08:41:18.003,2012-09-07 08:41:19.273,,'1',72782
> 2012-09-07 08:41:18.043,2012-09-07 08:41:19.273,,'1',72789
> 2012-09-07 08:41:18.07,2012-09-07 08:41:19.273,,'1',72797
> 2012-09-07 08:41:18.096,2012-09-07 08:41:19.273,,'1',72803
> 2012-09-07 08:41:18.143,2012-09-07 08:41:20.466,,'1',72810
> 2012-09-07 08:41:18.17,2012-09-07 08:41:20.466,,'1',72817
> 2012-09-07 08:41:18.196,2012-09-07 08:41:20.466,,'1',72824
> 2012-09-07 08:41:18.246,2012-09-07 08:41:20.466,,'1',72831
>
> counter from 72568 to 72671 are missed records&#65292;They
> had processed when i restart my program&#65292;the send_time
> is 2012-09-07 09:15:09.
> becourse my english is poor&#65292;please forgive me!
> thands!
>

Your chance of getting a useful reply in this newsgroup will greatly
increase if you simplify your example by removing all non-SQL elements:
just show the actual SQL code executed and the brief result, and an
explanation why that result is not what you expected.

--
HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Professional DBA for Sybase ASE, IQ, Replication Server

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase IQ Quick Reference Guide"
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------


wangtw Posted on 2012-09-12 06:29:22.0Z
Sender: 5b95.50502a67.1804289383@sybase.com
From: wangtw
Newsgroups: sybase.public.ase.general
Subject: Re: while query identity field encounter a strange issue
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <50502bc2.5c0c.1681692777@sybase.com>
References: <50502aeb.5bc5.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 11 Sep 2012 23:29:22 -0700
X-Trace: forums-1-dub 1347431362 172.20.134.41 (11 Sep 2012 23:29:22 -0700)
X-Original-Trace: 11 Sep 2012 23:29:22 -0700, 172.20.134.41
Lines: 152
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31378
Article PK: 74267

sorry for error Order,below is first part!

hello&#65292;all&#65306;i meet a problem while query
identity field:
Operating system&#65306;Linux Red hat 5.5&#65292;32bit
Sybase version:Ase-15-0
i has a table, it has a identity field as
field4&#65292;numeric,width 12
i use jdbc insert&#12289;query&#12289;update this
table&#65292;every oper has a single thread&#65292;one
thread batch insert record to table;one thread query, sql is
"select field1,field2,field3 from table where field4
between num1 and num1+500&#65292; num1 set to
max(field4)&#65292;my problem is in some time this query
might miss some record between num1 and num1+500&#65292;i
checked my code and log&#65292;can't find the
problem&#65292;please someone can help me&#65311;

> ase is not cluster
> select @@version output:
> Adaptive Server Enterprise/15.0.3/EBF 16555 ESD#1/P/Linux
> Intel/Linux 2.6.9-42.ELsmp
> i686/ase1503/2680/32-bit/FBO/Thu Mar 5 04:50:21 2009
>
> My pseudo code&#65306;
> static int num1 = 0;
> while(true) {
> sql = "select field1,field2,field3,field4 form table where
> field4 between num1 and num1+500";
> resultset = db.exe(sql);
> if (resultset.hasNext()) {
> int maxV = 0;
> while(resultset.next) {
> if(resultset.getInt(4) > maxV ) {
> naxV = resultset.getInt(4);
> }
> //other code
> }
> num1 = maxV + 1;
> }
> else {
> //query min field from table
> select min(field4) from table;
> if (min(field4) > num1) {
> num1 = min(field4);
> }
> }
> }
> in my act environment&#65292;things as follows&#65306;
> in progarm query sql is "select
> create_time,send_time,plan_send_time,priority,counter from
> table o where ((plan_Send_Time=null and counter between
> 72336 and 72835))",create_time is record
> created_time,send_time is record doned time,plan_send_time
> is record to be process time,couner is a
> identity&#65292;this sql query out 62
> records&#65292;max(counter) is 72803,min(counter) is
> 72341&#12290;
>
> but int the table&#65292;records are:
> create_time,send_time,plan_send_time,priority,counter
> 2012-09-07 08:41:15.816,2012-09-07 08:41:19.273,,'1',72341
> 2012-09-07 08:41:15.843,2012-09-07 08:41:19.273,,'1',72347
> 2012-09-07 08:41:15.873,2012-09-07 08:41:19.273,,'1',72354
> 2012-09-07 08:41:15.89,2012-09-07 08:41:19.273,,'1',72356
> 2012-09-07 08:41:15.9,2012-09-07 08:41:19.273,,'1',72359
> 2012-09-07 08:41:15.916,2012-09-07 08:41:19.273,,'1',72363
> 2012-09-07 08:41:15.933,2012-09-07 08:41:19.273,,'1',72369
> 2012-09-07 08:41:15.97,2012-09-07 08:41:19.273,,'1',72377
> 2012-09-07 08:41:16.016,2012-09-07 08:41:19.273,,'1',72384
> 2012-09-07 08:41:16.046,2012-09-07 08:41:19.273,,'1',72392
> 2012-09-07 08:41:16.073,2012-09-07 08:41:19.273,,'1',72398
> 2012-09-07 08:41:16.116,2012-09-07 08:41:19.273,,'1',72404
> 2012-09-07 08:41:16.143,2012-09-07 08:41:19.273,,'1',72410
> 2012-09-07 08:41:16.17,2012-09-07 08:41:19.273,,'1',72417
> 2012-09-07 08:41:16.2,2012-09-07 08:41:19.273,,'1',72420
> 2012-09-07 08:41:16.226,2012-09-07 08:41:19.273,,'1',72427
> 2012-09-07 08:41:16.253,2012-09-07 08:41:19.273,,'1',72434
> 2012-09-07 08:41:16.28,2012-09-07 08:41:19.273,,'1',72440
> 2012-09-07 08:41:16.306,2012-09-07 08:41:19.273,,'1',72444
> 2012-09-07 08:41:16.326,2012-09-07 08:41:19.273,,'1',72449
> 2012-09-07 08:41:16.356,2012-09-07 08:41:19.273,,'1',72457
> 2012-09-07 08:41:16.39,2012-09-07 08:41:19.273,,'1',72461
> 2012-09-07 08:41:16.42,2012-09-07 08:41:19.273,,'1',72466
> 2012-09-07 08:41:16.446,2012-09-07 08:41:19.273,,'1',72474
> 2012-09-07 08:41:16.476,2012-09-07 08:41:19.27,,'1',72481
> 2012-09-07 08:41:16.523,2012-09-07 08:41:19.27,,'1',72489
> 2012-09-07 08:41:16.573,2012-09-07 08:41:19.27,,'1',72495
> 2012-09-07 08:41:16.6,2012-09-07 08:41:19.27,,'1',72502
> 2012-09-07 08:41:16.626,2012-09-07 08:41:19.273,,'1',72507
> 2012-09-07 08:41:16.656,2012-09-07 08:41:19.27,,'1',72511
> 2012-09-07 08:41:16.693,2012-09-07 08:41:19.27,,'1',72517
> 2012-09-07 08:41:16.733,2012-09-07 08:41:19.273,,'1',72528
> 2012-09-07 08:41:16.76,2012-09-07 08:41:19.27,,'1',72536
> 2012-09-07 08:41:16.786,2012-09-07 08:41:19.273,,'1',72541
> 2012-09-07 08:41:16.826,2012-09-07 08:41:19.273,,'1',72548
> 2012-09-07 08:41:16.853,2012-09-07 08:41:19.273,,'1',72556
> 2012-09-07 08:41:16.88,2012-09-07 08:41:19.273,,'1',72562
> 2012-09-07 08:41:16.913,2012-09-07 08:41:19.273,,'1',72563
> 2012-09-07 08:41:16.926,2012-09-07 08:41:19.273,,'1',72564
> 2012-09-07 08:41:16.956,2012-09-07 08:41:19.273,,'1',72565
> 2012-09-07 08:41:16.98,2012-09-07 09:15:09.54,,'1',72568
> 2012-09-07 08:41:17.01,2012-09-07 09:15:09.54,,'1',72575
> 2012-09-07 08:41:17.036,2012-09-07 09:15:09.54,,'1',72581
> 2012-09-07 08:41:17.073,2012-09-07 09:15:09.54,,'1',72589
> 2012-09-07 08:41:17.1,2012-09-07 09:15:09.54,,'1',72595
> 2012-09-07 08:41:17.13,2012-09-07 09:15:09.54,,'1',72601
> 2012-09-07 08:41:17.16,2012-09-07 09:15:09.54,,'1',72609
> 2012-09-07 08:41:17.186,2012-09-07 09:15:09.54,,'1',72615
> 2012-09-07 08:41:17.233,2012-09-07 09:15:09.54,,'1',72621
> 2012-09-07 08:41:17.26,2012-09-07 09:15:09.54,,'1',72627
> 2012-09-07 08:41:17.286,2012-09-07 09:15:09.54,,'1',72629
> 2012-09-07 08:41:17.316,2012-09-07 09:15:09.54,,'1',72636
> 2012-09-07 08:41:17.343,2012-09-07 09:15:09.54,,'1',72644
> 2012-09-07 08:41:17.346,2012-09-07 09:15:09.54,,'1',72646
> 2012-09-07 08:41:17.37,2012-09-07 09:15:09.54,,'1',72653
> 2012-09-07 08:41:17.396,2012-09-07 09:15:09.54,,'1',72656
> 2012-09-07 08:41:17.436,2012-09-07 09:15:09.54,,'1',72663
> 2012-09-07 08:41:17.466,2012-09-07 09:15:09.54,,'1',72671
> 2012-09-07 08:41:17.493,2012-09-07 08:41:19.273,,'1',72677
> 2012-09-07 08:41:17.536,2012-09-07 08:41:19.273,,'1',72684
> 2012-09-07 08:41:17.566,2012-09-07 08:41:19.273,,'1',72691
> 2012-09-07 08:41:17.593,2012-09-07 08:41:19.273,,'1',72698
> 2012-09-07 08:41:17.64,2012-09-07 08:41:19.273,,'1',72703
> 2012-09-07 08:41:17.666,2012-09-07 08:41:19.273,,'1',72709
> 2012-09-07 08:41:17.693,2012-09-07 08:41:19.273,,'1',72716
> 2012-09-07 08:41:17.723,2012-09-07 08:41:19.273,,'1',72721
> 2012-09-07 08:41:17.75,2012-09-07 08:41:19.273,,'1',72728
> 2012-09-07 08:41:17.776,2012-09-07 08:41:19.273,,'1',72735
> 2012-09-07 08:41:17.803,2012-09-07 08:41:19.273,,'1',72740
> 2012-09-07 08:41:17.84,2012-09-07 08:41:19.273,,'1',72747
> 2012-09-07 08:41:17.866,2012-09-07 08:41:19.273,,'1',72752
> 2012-09-07 08:41:17.896,2012-09-07 08:41:19.273,,'1',72759
> 2012-09-07 08:41:17.923,2012-09-07 08:41:19.273,,'1',72763
> 2012-09-07 08:41:17.95,2012-09-07 08:41:19.273,,'1',72770
> 2012-09-07 08:41:17.97,2012-09-07 08:41:19.273,,'1',72775
> 2012-09-07 08:41:17.976,2012-09-07 08:41:19.273,,'1',72778
> 2012-09-07 08:41:18.003,2012-09-07 08:41:19.273,,'1',72782
> 2012-09-07 08:41:18.043,2012-09-07 08:41:19.273,,'1',72789
> 2012-09-07 08:41:18.07,2012-09-07 08:41:19.273,,'1',72797
> 2012-09-07 08:41:18.096,2012-09-07 08:41:19.273,,'1',72803
> 2012-09-07 08:41:18.143,2012-09-07 08:41:20.466,,'1',72810
> 2012-09-07 08:41:18.17,2012-09-07 08:41:20.466,,'1',72817
> 2012-09-07 08:41:18.196,2012-09-07 08:41:20.466,,'1',72824
> 2012-09-07 08:41:18.246,2012-09-07 08:41:20.466,,'1',72831
>
> counter from 72568 to 72671 are missed records&#65292;They
> had processed when i restart my program&#65292;the
> send_time is 2012-09-07 09:15:09.
> becourse my english is poor&#65292;please forgive me!
> thands!