maria-developers team mailing list archive

[worklog-noreply@xxxxxxxxxxxx]

-----------------------------------------------------------------------
                              WORKLOG TASK
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
TASK...........: Improved upgrade testing in Buildbot
CREATION DATE..: Fri, 19 Mar 2010, 07:56
SUPERVISOR.....: Knielsen
IMPLEMENTOR....: 
COPIES TO......: 
CATEGORY.......: Other
TASK ID........: 109 (http://askmonty.org/worklog/?tid=109)
VERSION........: Server-9.x
STATUS.........: Un-Assigned
PRIORITY.......: 60
WORKED HOURS...: 0
ESTIMATE.......: 50 (hours remain)
ORIG. ESTIMATE.: 50

PROGRESS NOTES:

-=-=(Knielsen - Fri, 19 Mar 2010, 08:00)=-=-
High-Level Specification modified.
--- /tmp/wklog.109.old.3875     2010-03-19 08:00:03.000000000 +0000
+++ /tmp/wklog.109.new.3875     2010-03-19 08:00:03.000000000 +0000
@@ -1 +1,15 @@
+The main tasks here is to prepare sample data, and scripts to first insert the
+data, and second to verify the data. Possibly some existing sample databases
+could be used for this.
 
+There needs to be also developed or found some script/automatic way to check the
+contents of the database.
+
+Such scripts need to be included in the MariaDB source tree (and packages).
+
+Once this is available, the next step is to set up virtual kvm images with this
+sample data for MySQL and MariaDB, to replace the current images used for
+upgrade tests.
+
+It is then a simple matter to re-configure Buildbot to use this new more
+comprehensive upgrade test.



DESCRIPTION:

The current .deb upgrade test is very simplistic. It mainly tests that the .deb
package scripts pre/postinst work correctly.

The actual test of the data is only a single table with a single value, and only
that the table is present. There is no test to check that the data is actually
preserved correctly.

It would be nice to extend this to include a set of example databases, covering
a reasonable range of commonly used column types, indexes, storage engines, etc.

It would also need some facility for checking that the data is correct after the
upgrade.


HIGH-LEVEL SPECIFICATION:



The main tasks here is to prepare sample data, and scripts to first insert the
data, and second to verify the data. Possibly some existing sample databases
could be used for this.

There needs to be also developed or found some script/automatic way to check the
contents of the database.

Such scripts need to be included in the MariaDB source tree (and packages).

Once this is available, the next step is to set up virtual kvm images with this
sample data for MySQL and MariaDB, to replace the current images used for
upgrade tests.

It is then a simple matter to re-configure Buildbot to use this new more
comprehensive upgrade test.


ESTIMATED WORK TIME

ESTIMATED COMPLETION DATE
-----------------------------------------------------------------------
WorkLog (v3.5.9)