Re: [luciddb-users] lost schemas after luciddb upgrade.

[Marc B. <mar...@sq...>]

I mean the tables in my user schema are not listed by *!tables* after I run
install/catalog.sql.
But they did appear just before I ran that script as the last step of the
LucidDbUpgrade process.
It seems to be that the upgrade has discarded my 78G of data.

(I have tried this all again, after making small changes to catalog.sql,
notably removing *create or replace schema ...;
*but it did not help.)

[ Kevin Secretan wrote:]

> Hey Marc. The testHarness stuff is indeed a mistake. I thought I fixed that
> earlier, but I guess not. I recently committed a fix. We'll be merging
> dy/dev up this week, but if you'd like to try again with this build go
> ahead:http://build.dynamobi.com/job/build_eigenbase_release/label=lin64/lastSuccessfulBuild/artifact/bootstrap/dist/luciddb-0.9.4RC32.tar.bz2
>
> I wasn't able to reproduce losing schemas or tables. Are you saying some
> didn't come through from the old version, or did you make some new ones on
> 0.9.4 before the upgrade that didn't stick around?
>
> [Marc Berkowitz wrote:]

> I tried to copy the contents of an old version of luciddb to a new version,
> following the instruction on the eigenwiki pagehttp://pub.eigenbase.org/wiki/LucidDbUpgrade.
>
> There  the last step is to connect to the new server with sqlline and run *
> install/catalog.sql,
> *Before I do so I can see my user schema listed from the command *!tables,
> *but after running this step my schema has disappeared.
>
>