[Monetdb-developers] [MonetDB-users] Announcement: New Jun2010 feature release of MonetDB suite

Sjoerd Mullender sjoerd at acm.org
Fri Jul 2 22:43:39 CEST 2010


We have decided to retract the Jun2010 release.

If you have already upgraded, you should be OK when using new databases.

If you have updated with existing databases, and you have already
started a server with a pre-existing database, you will probably
experience the problems described in the bug mentioned in the quoted text.

You can repair your database and make it usable again using the
following procedure.  This procedure is also described in the Jun2010
release notes.

Start the server (again), and connect to it using mclient.  Then give
the following query to find the id of the 'sys' schema:

select id from schemas where name = 'sys';

Make a note of the result.  Then give the following 4 queries, replacing
the value RESULT with the result obtained in the query above:

update _tables set schema_id = RESULT where schema_id not in
       (select id from schemas) and schema_id <> 0;
update functions set schema_id = RESULT where schema_id not in
       (select id from schemas) and schema_id <> 0;
update types set schema_id = RESULT where schema_id not in
       (select id from schemas) and schema_id <> 0;
update sequences set schema_id = RESULT where schema_id not in
       (select id from schemas) and schema_id <> 0;

Stop mclient and, more importantly, the server.  Once you restart the
server, the database should be usable.

However, note that changes to the database schema, especially the
creation of tables, functions, types and sequences, will once again make
the database unusable (until you repeat the above procedure).

We' working on a bug fix release.

On 2010-07-02 12:43, Sjoerd Mullender wrote:
> Watch out when upgrading!
> 
> We just (too late) found a bug that when you upgrade an existing
> (Feb2010) database to the Jun2010 version, things seem to work OK.  But
> when you then stop and restart the server, things don't work anymore.
> 
> Our advice: if you have existing databases, DO NOT UPGRADE.
> 
> See http://bugs.monetdb.org/2573.
> 
> On 2010-07-01 17:14, Sjoerd Mullender wrote:
>> It is not June anymore, but nevertheless, the MonetDB team at
>> CWI/MonetDB BV is pleased to announce the Jun2010
>> feature release of the MonetDB suite of programs.
>>
>> More information (including release notes) on this release is available
>> at <http://monetdb.cwi.nl/Development/Releases/Jun2010/>.
>>
>> The download location has changed to
>> <http://dev.monetdb.org/downloads/>.  Please fix any bookmarks you may have.
> 
> 
> 
> 
> 
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by Sprint
> What will you do first with EVO, the first 4G phone?
> Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
> 
> 
> 
> _______________________________________________
> Monetdb-developers mailing list
> Monetdb-developers at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-developers


-- 
Sjoerd Mullender




More information about the developers-list mailing list