1
*****************************************************************
3
This is an old comment about how it was to run crash-me on empress
4
the first time. I think it was on Empress 6.0
5
*****************************************************************
7
start testing empress ...
8
added a nice line for the max join ....
9
strip the as out of the from field ...
10
that's working on empress ....
12
at this moment with ....
13
max constant string size in where .... taking a lot of memory ...
14
at this moment (it's still growing just waiting till it stops ..) 99mb ..
15
sorry it started growing again ...
16
max 170 mb ... then it gives an error ...
18
at max constant string size in where ... with IOT trap/Abort(core dumped) :-)
19
nice isn't it ... hope it saved the things ....
20
I outcommented the sig story because I could see how the script is running
21
and I wasn't sure if SIG{PIPE} ='DEFAULT' ... is working ...
22
restarting with limit 8333xxx ... couldn't see it any more ...
23
query is printed ...(200000 lines ..). mmm Nice IOT trap/Abort ...
24
and again ..and again ...
25
aha ... and now it's going further ...
26
max constant string string size in select: ...
28
crashing over and over again ....
29
max simple expressions ...
30
is taking ... 82 mb ...
31
mmmm this is taking very very very long .... after 10 minutes I will kill it and run it again ... I think he can't proces this query that fast ... and will crash any way ...
32
still growing very slow to the 90 mb ...
33
killed it ... strange is ... it don't react on ctrl-c ... but kill 15 does work
34
mmm still bussy with killing his self ... memory is growing to 128 mb ...
35
sorry .. 150 mb .. and then the output ..
36
maybe something for the extra things for crash-me ...
38
if length $query > 300 ... just print $errstr .. else print $query + $errstr ..
39
at this moment he is still bussy printing ....
40
first clear all locks ... with empadm test lockclear ... else it will give me
41
the error with a lock ...
42
restarting at 4194297 .... mmm a bit high I think ...
43
after 5 minutes I will kill it ...
44
mmm have to kill it again ... took 30 mb ..now growing to 42 mb ..
45
restarting at 838859 ... hope this will crash normaly ... :-)
46
I will give it again 5 minutes to complete ...
47
taking 12 mb .... will kill it ... after 4 minutes ....
48
restarting at 167771 ... taking 6 mb ... give it again 5 minutes ....
49
will kill it again ... else it becomes to late tonight ...
50
mmm started with 33xxxx and it crashes ...:-) yes ...
51
can't we build in a function which will restart his self again ...
52
mmmm this is really boring .. start it over and over again ...
54
Restarting this with high limit: 4097
56
*** Program Bug *** setexpr: unknown EXPR = 1254 (4e6)
57
isn't it ... starting it again ...
58
finally finished with 4092 ....
59
now max big expression .....
60
directly taking .. 85 mb ... give it again 5 minutes ...
61
mmm I am going to kill it again ... mmm it grows to 146 mb ...
62
restarting with 1026 ... taking 25 mb ..
63
won't give him that long ... because it will crash any way (just a ques) ..
65
restarting at 205 ... hope this will work ....
66
won't think so ... give it 2 minutes ... taking 12 mb ...
67
killed it ...restarting at ... 40 ... yes it crashes ...
68
7 is crashing ... 1 ....is good .. finaly ... a long way ...
69
now max stacked expressions ....
70
taking 80 mb ... mmmm what sort of test is this ...it looks more like a harddisk test .. but it crashes .. nice ...
71
mmm a YACC overflow ... that's a nice error ...
72
but it goes on ... yep it didn't crashed just an error ...
74
my patch for the join didn't work ... let's take a look what goes wrong ...
75
saw it ... forgot some little thing .. mm not .. them ... another little typo
76
mmm again a really nice bug ...
77
Restarting this with high limit: 131
79
*** Program Bug *** xflkadd: too many read locks
80
them the lock forgotten ....
81
mmmm bigger problem ...
82
with empadm test lockinfo ... gives ...
83
*** System Problem *** no more clients can be registered in coordinator
85
*** User Error *** '/usr/local/empress/rdbms/bin/test' is not a valid database
86
that's really really nice ....
87
hmmm after coordclear ... it's fine again ...
89
after restarting it again the script ... it is going further ....
90
the overflow trick is nice and working good ...
91
now I have table 'crash_q' does not exist for every thing ...
92
normal ...???? mmm went after all good .. so I think it's normal ...
93
mmmm a lot of table 'crash_q' does not exist ... again ...
94
sometimes when the overflow is there ... I restart it and it is saying ...
95
restarting at xxxx that's not good ... but hey ... what the hack ...
96
maybe that's good because if one test run's more then 200 times ....
97
it won't exceeds that test ...
99
yes finally the end of crash-me ...
100
at last ... crash-me safe: yes ...
101
yep don't think so he ....
added
removed
tests/sql-bench/Comments/Empress.crash-me
