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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers