File: README.1

package info (click to toggle)
derby 10.14.2.0-3
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid, trixie
  • size: 79,056 kB
  • sloc: java: 691,961; sql: 42,686; xml: 20,512; sh: 3,373; sed: 96; makefile: 60
file content (362 lines) | stat: -rw-r--r-- 11,721 bytes parent folder | download | duplicates (4)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
<!--
  Licensed to the Apache Software Foundation (ASF) under one or more
  contributor license agreements.  See the NOTICE file distributed with
  this work for additional information regarding copyright ownership.
  The ASF licenses this file to you under the Apache License, Version 2.0
  (the "License"); you may not use this file except in compliance with
  the License.  You may obtain a copy of the License at

      http://www.apache.org/licenses/LICENSE-2.0

  Unless required by applicable law or agreed to in writing, software
  distributed under the License is distributed on an "AS IS" BASIS,
  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  See the License for the specific language governing permissions and
  limitations under the License.
-->

Short Story:
**************************************************************************
 1. Create top level directory structure - See APPENDIX 1.
 2. Checkout Derby to ${DERBYDIR} - preferably NOT the very latest version
    since we want to use ${TOOLDIR}/updateDerby to create version info for reports.
 2. Copy and modify env.sh, testenv.sh from tools/testing/reporting/TEMPLATES/ to ${DERBYDIR}.
    Copy and modify index.html, index.shtml from tools/testing/reporting/TEMPLATES/ to ${DERBYDIR}/../
 3. ${TOOLDIR}/initDERBYDIR
 4. ${TOOLDIR}/updateDerby [revision]
 5. ${TOOLDIR}/buildDerby "[MKBUILDZIP]" [antpropertyFile]
 6. Create ${DERBYDIR}/testing/builds/baseline.size from ${DERBYDIR}/testing/builds/<revision>.size
 7. Edit ${DERBYDIR}/testing/testhostlist
 8. ${TOOLDIR}/testDerby ${DERBYDIR}/testing/testhostlist
 8. touch ${DERBYDIR}/testing/testlog/${PLATFORM}/externallyVisible for platforms that should be 
    visible in public reports.
 9. ${TOOLDIR}/createBaselineFiles <revision>
10. ${TOOLDIR}/mkAllDerbyTestInfo
    Optional: ${TOOLDIR}/mkAllDerbyTestInfo.public
    Optional: ${TOOLDIR}/mkAllPlotDataAndPlots [INIT] # Use INIT when new baselines created.

After having established the sandbox and report structure you will normally do
4., 5., 8. and 10. 
${TOOLDIR}/updateBuildTestDerby  "[MKBUILDZIP]" "[revision]" [antpropertyfile] executes 4, 5 and 8.







Long Story
****************************************************************************
The scripts assume Derby is checked out to
a directory ${DERBYDIR} 
such that we will have e.g.
 DERBYDIR=${HOME}/Apache/Derby
 BRANCH_DIR=trunk
 derby_source=${DERBYDIR}/${BRANCH_DIR}
or
 DERBYDIR=${HOME}/Apache/Derby-10.1
 BRANCH_DIR=10.1
 derby_source=${DERBYDIR}/${BRANCH_DIR}


The directory structure I have below ${DERBYDIR} is shown in APPENDIX 1..


In ${DERBYDIR}/ I have env.sh and testenv.sh which is sourced to 
set up the environment for update and build(env.sh) and testing(testenv.sh).
Templates which can be copied to ${DERBYDIR}/ and modified to suite your
environment are found in ${derby_source}/tools/testing/reporting/TEMPLATES/.



The scripts are in TOOLDIR=${DERBYDIR}/${BRANCH_DIR}/tools/testing/reporting/scripts
Templates for env.sh and testenv.sh are in 
   TEMPLATEDIR=${DERBYDIR}/${BRANCH_DIR}/tools/testing/reporting/TEMPLATES



Main scripts
************

1. ${TOOLDIR}/updateDerby [revision] (Do '. ./env.sh' first)
   ==================================
   cd's to 'derby_source=${DERBYDIR}/${BRANCH_DIR}' as defined
   in env.sh.
   Does 'svn update'.
   Creates/adds to testing/revisionlist. 
   Creates testing/UpdateInfo/<revision>.txt
   Updates status files(updateOK, update.out) in UpdateLog.
   Creates directory UpdateLog/<revision>/ with status info.
   used in test reports.


2. ${TOOLDIR}/buildDerby "[MKBUILDZIP]" "[antpropertyFile]" (Do '. ./env.sh' first)
   =================================
   cd's to 'derby_source=${DERBYDIR}/${BRANCH_DIR}' as defined
   in env.sh.
   If UpdateLog/updateOK was not created because svn update in 1.
   was not done, build is not attempted.
   
   If build is successful BuildLog/buildOK is created. Creates
   BuildLog/<revision>/ with info used in test reports.

   After the first successful build you should copy ${DERBYDIR}/testing/builds/<revision>.size
   to ${DERBYDIR}/testing/builds/baseline.size and edit it to the format for the 
   baseline.size file shown in this example: # FIXME: create a script...
# 474376
# My.first.build
derby.jar 2257078
derbynet.jar 186619
derbyclient.jar 375758
derbytools.jar 157327
derbyrun.jar 11771
derbyTesting.jar 5563839

   Or you might want to use data for some other build...


3. ${TOOLDIR}/testDerby ${HOSTLISTFILE} (Do . ./testenv.sh first)
   ====================================
   Will exit if UpdateLog/updateOK is not found.
   ${HOSTLISTFILE} (Usually ${DERBYDIR}/testing/testhostlist) must 
   contain the list of machines where tests should be run.
   Assumes ${DERBYDIR} is accessible on all hosts.
   Uses rsh (or ssh if you choose so) to connect to the hosts
   and run "${TOOLDIR}/startDerbyTests ${DERBYDIR}.
   If you just want to run the tests on the build host, remove 
   the loop over machines and run startDerbyTests locally.
   
   ${TOOLDIR}/startDerbyTests executes 
   ${TOOLDIR}/runAllTests using ${DERBYDIR}/testing/testlist which
   lists the Derby testsuites to be run (one testsuite name per line).
   
   Tests are executed in TESTEXECUTIONDIR: e.g.
   TESTEXECUTIONDIR="/export/home/tmp/${USER}/testingDerby<platform>/"
   defined in testenv.sh.

   Test results are reported in ${DERBYDIR}/testing/testlog/<platform>/. 
   ${DERBYDIR}/testing/testlog/ MUST exist.
   A zip file containing the ${DERBYDIR}/testing/testlog/<platform>/ is # FIXME FIXME
   also included in ${DERBYDIR}/testing/testlog/<platform>/. Files
   matching exceptions listed in ${DERBYDIR}/testing/ExcludeFromZip
   are NOT included. I use the following exception:
   
      **.dat
      **.ctrl
      **Tester*.out



 ${TOOLDIR}/updateBuildTestDerby  "[MKBUILDZIP]" "[revision]" [antpropertyfile] 
 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 executes 1, 2 and 3.


4. Creating web presentations
   ==========================

   Important: cd to ${DERBYDIR} and do '. ./env.sh'.

   Execute '${TOOLDIR}/createBaselineFiles <revision>' to
   create a baseline for testsuite execution times for all platforms.
   Or '${TOOLDIR}/createBaselineFilesOnePlatform <revision> <platform>'
   to create a baseline for one specific platform. (<platform>/Directory name as found in
   ${DERBYDIR}/testing/testlog/).

   To make data for a platform publicly visible do
   'touch ${DERBYDIR}/testing/testlog/${PLATFORM}/externallyVisible'.

   The web pages are created by the scripts (check for parameters!)
   ${TOOLDIR}/testSummariesDerby <revision> [details] :
          builds a page for platforms/testsuites.
   ${TOOLDIR}/mkAllDerbyTestInfo
   ${TOOLDIR}/mkAllDerbyTestInfo.public :
          builds pages for current, previous and 2 newest numbered revisions :
                                 ${TOOLDIR}/testSummariesDerby ${LATESTREVISION}
                                 ${TOOLDIR}/testSummariesDerby ${PREVIOUSREVISION}
                                 ${TOOLDIR}/testSummariesDerby current
                                 ${TOOLDIR}/testSummariesDerby previous
          builds pages for revisions/testsuites :
                                 (${TOOLDIR}/testHistoriesDerby)
          builds pages for platforms/revisions :
                                 (${TOOLDIR}/testPlatformsDerby)
          builds top level presentation page :
                                 (${TOOLDIR}/mkDerbyTestIndex)

   'mkAllDerbyTestInfo' and 'mkAllDerbyTestInfo.public' creates index/top level pages for a 
   limited number of tests over revisions. To create a complete index over *all*
   tests where test results have been collected do
   '${TOOLDIR}/mkDerbyTestIndex_all details' and '${TOOLDIR}/mkDerbyTestIndex_all'.
   The index/top level pages contain a link to these labeled "See full history here!".


   With the parameter 'details', pages are created in ${DERBYDIR}/testing/Full/,
   without the parameter 'details', pages are created in ${DERBYDIR}/testing/Limited/.


4.1 Creating test suite duration plots
    ++++++++++++++++++++++++++++++++++
    
   Duration plots are only visible on "Full" pages. Do
   '${TOOLDIR}/mkAllPlotDataAndPlots [INIT]', using 'INIT' the first time and
   after baseline files have been modified.
   NB. Requires gnuplot!
   

4.2 Adding new platforms
    ++++++++++++++++++++
   Assuming test runs have been completed for the new platforms:
  
4.2.1 Create baseline files
      ---------------------
   'cd ${DERBYDIR};. ./env.sh;. ./testenv.sh'.
   For each of the newly added platforms do
   '${TOOLDIR}/createBaselineFilesOnePlatform ${REVISION} ${PLATFORM}'.
   Remember to do '${TOOLDIR}/mkAllPlotDataAndPlots INIT' to reestablish 
   all plots using the new baseline.

4.2.2 Present results on "Limited" pages
      --------------------------
   To show results for the newly added platforms in "Limited" pages create
   the file externallyVisible in 
   ${DERBYDIR}/testing/testlog/${PLATFORM}/.
   E.g. 'touch ${DERBYDIR}/testing/testlog/${PLATFORM}/externallyVisible'.


4.3 Adding revision specific Notes to index pages
    +++++++++++++++++++++++++++++++++++++++++++++

    If you want to display notes on a revision add a <revision number>.txt file
    to ${DERBYDIR}/testing/Notes/.
    HTML formatting is accepted.
    The note is also displayed in the 'testSummary-<revision number>.html' file.


==============================

   OBSERVE: All commands sending mail for update, build and test status are 
   commented out and must be explicitly enabled!



-----------------------------------------------------------------------------
#####################
   OBSERVE: All commands using scp or ssh to copy or manipulate information
   on the external publishing web host are commented out and must be explicitly
    enabled!

   FIXME: Will be removed alltogether: Use e.g. 'rsync' instead for publishing.

#####################




-----------------------------------------------------------------------------

APPENDIX 1.
==========
${DERBYDIR} structure:

BuildLog/
    ...
    474376/
    ...
    474695/
        buildDetails
        buildInfo
        buildInfo.err
        info
        localChanges
        sysinfo.err
        sysinfo.txt
    buildOK
    currentSysInfo.txt
    lastBuildInfo

FailReports/
    ...
    474376.html
    ...
    474695.html

Failures -> trunk/tools/testing/reporting/Failures

TestRunLogs/
    hostA.err
    hostA.log
    ....
    hostN.err
    nostN.log

UpdateInfo/
    ...
    474376.txt
    ...
    474695.txt
    LatestUpdateRevision.txt

UpdateLog/
    ...
    474376/
    ...
    474695/
        UpdateTime
        status-u.err
        status-u.out
        svn--version
        update.err
        update.out

    update.out
    updateOK

builds/
    ...
    474376.size
    ...
    474695.size
    baseline.size

env.sh
summary-full.txt
summary.txt
testenv.sh

testing/
    ExcludeFromZip
    Full/
    Limited/
    Notes/
    ReadyToStartOnCygWin
    UpdateInfo -> ../UpdateInfo
    builds -> ../builds
    revisionlist
    showtestlist -> testlist
    testhostlist
    testlist

    testlog/
        ...
        Linux-2.6.9-34.ELsmp_x86_64-x86_64/
        SunOS-5.10_i86pc-i386/
        SunOS-5.10_sun4u-sparc/
            ...
            474664.zip
            474695-cpu_mem
            474695-system
            474695.csv
            474695.javainfo
            474695.txt
            ...
            baseline.csv
            current.csv
            externallyVisible
            previous.csv
            suiteStart.txt

        ...

trunk/ # or 10.1 or ....
    ...
    ...