Bugs item #2819966, was opened at 2009-07-11 13:22
Message generated for change (Comment added) made by heangu
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2819966&group_id=56967
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: z lh (zlh)
Assigned to: Nobody/Anonymous (nobody)
Summary: can't start server
Initial Comment:
sql>create table t(i int);
Timer 11.531 msec 0 rows
sql>create table x(a int);
Timer 2.792 msec 0 rows
sql>insert into t values(1);
Rows affected 1
Timer 33.536 msec 0 rows
sql>insert into t select i+count(i) from t;
Rows affected 1
Timer 2.659 msec 0 rows
sql>insert into t select i+count(i) from t;
Rows affected 2
Timer 2.461 msec 0 rows
sql>insert into t select i+count(i) from t;
Rows affected 4
Timer 2.266 msec 0 rows
sql>insert into t select i+count(i) from t;
Rows affected 8
Timer 10.562 msec 0 rows
sql>insert into t select i+count(i) from t;
Rows affected 16
Timer 2.193 msec 0 rows
sql>insert into t select i+count(i) from t;
Rows affected 32
Timer 2.254 msec 0 rows
sql>insert into t select i+count(i) from t;
Rows affected 64
Timer 2.396 msec 0 rows
sql>insert into t select i+count(i) from t;
Rows affected 128
Timer 2.265 msec 0 rows
sql>insert into t select i+count(i) from t;
Rows affected 256
Timer 8.952 msec 0 rows
sql>insert into t select i+count(i) from t;
Rows affected 512
Timer 10.674 msec 0 rows
sql>insert into t select i+count(i) from t;
Rows affected 1024
Timer 2.563 msec 0 rows
sql>insert into t select i+count(i) from t;
Rows affected 2048
Timer 2.994 msec 0 rows
sql>insert into t select i+count(i) from t;
Rows affected 4096
Timer 3.305 msec 0 rows
sql>insert into x select * from t;
Rows affected 8192
Timer 8.288 msec 0 rows
restart the server
sql>update x set a = a+1 where a<1000 and a>500;
Rows affected 499
Timer 7.050 msec
sql>update x set a = a+1 where a<5000 and a>4500;
Rows affected 499
Timer 11.554 msec
restart the server
sql>delete from x where a > 800 and a < 2000;
Rows affected 1200
Timer 7.002 msec
restart the server
sql>delete from x;
Rows affected 6992
Timer 4.455 msec
restart the server
sql>insert into x select * from t;
Rows affected 8192
Timer 175010.603 msec
sql>
restart the server
sql>select count(*) from t;
+--------+
| count_ |
+========+
| 8192 |
+--------+
Timer 5849.920 msec 1 rows
sql>update x set a = a+100;
Rows affected 8192
Timer 2000.985 msec 1 rows
sql>delete from x;
restart the server
sql>insert into x values(1);
Rows affected 1
restart the server, but the server crashed on startup
the error message is
mserver5: gdk_bat.c:1856: void_inplace: Assertion `BATcount(b) > (id
-b->H->seq)' failed.
(gdb) bt
#0 0x0000003a0a430045 in raise () from /lib64/libc.so.6
#1 0x0000003a0a431ae0 in abort () from /lib64/libc.so.6
#2 0x0000003a0a429756 in __assert_fail () from /lib64/libc.so.6
#3 0x00002aaaaba198cf in void_inplace (b=0xa5669a8, id=65553, val=0xafd8928,
force=1 '\001') at gdk_bat.c:1856
#4 0x00002aaaaba19c2f in void_replace_bat (b=0xa5669a8, u=0xa571a48, force=1
'\001') at gdk_bat.c:1881
#5 0x00002aaabdf0d220 in load_bat (bat=0xaf87c48, type=6, sz=1024,
cnt=0xaf879b0) at bat_storage.c:470
#6 0x00002aaabdf0d6f1 in create_col (tr=0xadbfa48, c=0xaf87b28) at
bat_storage.c:586
#7 0x00002aaabdef62f0 in load_column (tr=0xadbfa48, t=0xaf87978, rid=172) at
store.c:501
#8 0x00002aaabdef6871 in load_table (tr=0xadbfa48, s=0xadbfab8, rid=172) at
store.c:568
#9 0x00002aaabdef7d61 in load_schema (tr=0xadbfa48, id=1310, rid=31) at
store.c:835
#10 0x00002aaabdef813a in load_trans (tr=0xadbfa48, id=1310) at store.c:891
#11 0x00002aaabdefa2d9 in store_init (debug=0, store=store_bat,
logdir=0xa585398 "/home/tzf/opt/MonetDB/var/MonetDB5/sql_logs",
dbname=0xa585228 "tan", stk=0)
at store.c:1350
#12 0x00002aaabded15c5 in mvc_init (debug=0, store=store_bat, stk=0) at
sql_mvc.c:37
#13 0x00002aaabde68975 in SQLinit (c=0x6049c0) at sql_scenario.c:163
#14 0x00002aaaaab01074 in initScenario (c=0x6049c0, s=0x2aaaaad1e570) at
mal_scenario.c:74
#15 0x00002aaaaab01c4d in setScenario (c=0x6049c0, nme=0xaadb603 "sql") at
mal_scenario.c:295
#16 0x00002aaaaaac8718 in MSscheduleClient (command=0xaadb5c8 "LIT",
challenge=0x41000f80 "UE7a1Mgwag",
fin=0xa94c9e0, fout=0xaad72c0) at mal_session.c:270
#17 0x00002aaabb9acd8b in doChallenge (cmd=0x0, in=0xaa50f90, out=0xa54c720) at
mal_mapi.c:108
#18 0x00002aaabb9ad045 in SERVERlistenThread (Sock=0xaa4fef8) at mal_mapi.c:190
#19 0x0000003a0b0062e7 in start_thread () from /lib64/libpthread.so.0
#20 0x0000003a0a4ce3bd in clone () from /lib64/libc.so.6
I could not reproduce the bug, but I encountered many times.
note:I spoted the count of ubat is bigger than the count of primary bat in disk.
----------------------------------------------------------------------
Comment By: heangu (heangu)
Date: 2009-07-13 09:12
Message:
It's really a bug. But seems strange.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2819966&group_id=56967
------------------------------------------------------------------------------
Enter the BlackBerry Developer Challenge
This is your chance to win up to $100,000 in prizes! For a limited time,
vendors submitting new applications to BlackBerry App World(TM) will have
the opportunity to enter the BlackBerry Developer Challenge. See full prize
details at: http://p.sf.net/sfu/Challenge
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
