[GeoNode-users] Missing columns after migrating data from Geonode 2.4 to 2.6
Simone Dalmasso
simone.dalmasso at gmail.com
Thu Oct 19 02:23:12 PDT 2017
Thanks
2017-10-19 10:51 GMT+02:00 Israel López <asralf at gmail.com>:
> Done it.
>
> Good day
>
> 2017-10-19 2:33 GMT-05:00 Simone Dalmasso <simone.dalmasso at gmail.com>:
>
>> Ok thanks a lot, then we need to create the missing migration. Could you
>> please open a ticket on this?
>>
>> best
>>
>> 2017-10-19 2:06 GMT+02:00 Israel López <asralf at gmail.com>:
>>
>>> Hi everybody, just in this moment I found the same error trying to
>>> delete some layers.
>>>
>>> Looking around I found that the file migration is missing for the Upload
>>> app, it only has the
>>> 24_initial.py, but this file includes the creation of the new fields,
>>> the right way have to be two files,
>>> the initial24.py and the 24_to_26.py as the other apps.
>>>
>>> So as we run initial--fake, the tables are not created, the solution for
>>> me was to delete the old
>>> upload and upload_file tables (I don't know why are empty), delete the
>>> fake migration in the
>>> django_migrations table and run the migrate comand for upload, and thats
>>> it, the tables were
>>> created.
>>>
>>> Hope this helps somebody. Greetings from Mexico.
>>>
>>> 2017-10-18 13:39 GMT-05:00 Simone Dalmasso <simone.dalmasso at gmail.com>:
>>>
>>>> Thanks all for the answers and feedbacks, we should investigate why
>>>> "migrate" did not add those columns. It should be its job.
>>>>
>>>> Best
>>>>
>>>> 2017-10-18 20:10 GMT+02:00 Eric Goddard <egoddard1010 at gmail.com>:
>>>>
>>>>> Thanks Annalisa, I ended up going that route too. I added those
>>>>> columns and removed the not null constraint on last_login on
>>>>> people_profile.
>>>>>
>>>>> Eric
>>>>>
>>>>> On Wed, Oct 18, 2017 at 2:49 AM, Annalisa Schiavon
>>>>> <annalisa.schiavon at gmail.com> wrote:
>>>>> > Dear Eric,
>>>>> > on 3 July I found a similar issue: upload_upload table hasn't 4
>>>>> attribute:
>>>>> > mosaic_time_regex,
>>>>> > mosaic_time_value, mosaic_elev_regex and mosaic_elev_value.
>>>>> > I added those columns and solved my problem.
>>>>> >
>>>>> > Regards,
>>>>> > Annalisa
>>>>> >
>>>>> > 2017-10-16 16:24 GMT+02:00 Eric Goddard <egoddard1010 at gmail.com>:
>>>>> >>
>>>>> >> Hi all,
>>>>> >>
>>>>> >> We're trying to upgrade from GeoNode 2.4 to 2.6. I have a new VM
>>>>> with
>>>>> >> Geonode 2.6 installed on Ubuntu 16.04 from the PPA. I dumped the
>>>>> >> postgres data from our 2.4 server and created new DBs on the Geonode
>>>>> >> 2.6 instance and updated settings.py to point to the geonode 2.4
>>>>> >> geonode and geonode_data DBs.
>>>>> >>
>>>>> >> Following the suggestion in this thread
>>>>> >>
>>>>> >> (http://osgeo-org.1560.x6.nabble.com/Help-for-migrate-data-f
>>>>> rom-2-4-to-2-6-td5323208.html),
>>>>> >> I ran geonode migrate --fake-initial and everything appears to have
>>>>> >> worked, however if I try to create a new account from the geonode
>>>>> >> registration page, or delete an existing account from the admin
>>>>> panel
>>>>> >> I get some errors.
>>>>> >>
>>>>> >> Trying to create a new account results in the following error:
>>>>> >> IntegrityError: null value in column "last_login" violates not-null
>>>>> >> constraint
>>>>> >>
>>>>> >> Trying to delete an account results in the following error:
>>>>> >> ProgrammingError: column upload_upload.mosaic_time_regex does not
>>>>> exist
>>>>> >>
>>>>> >> It looks like the migration didn't run correctly. If anyone has
>>>>> advice
>>>>> >> on how fix/work a round this issue it would be greatly appreciated!
>>>>> >> We'll be reloading the data anyway so our main concern is just
>>>>> >> migrating the accounts and groups.
>>>>> >>
>>>>> >> If it helps, here is the comparison of the geonode 2.4 and 2.6
>>>>> schemas
>>>>> >> for the upload_upload table. The mosaic* columns are missing from
>>>>> the
>>>>> >> 2.4 database that was migrated:
>>>>> >>
>>>>> >> geonode 2.4 database (after running migrate):
>>>>> >> geonode24=# \d upload_upload
>>>>> >> Table "public.upload_upload"
>>>>> >> Column | Type |
>>>>> Modifiers
>>>>> >>
>>>>> >> ------------+--------------------------+--------------------
>>>>> ----------------------------------------
>>>>> >> id | integer | not null default
>>>>> >> nextval('upload_upload_id_seq'::regclass)
>>>>> >> import_id | bigint |
>>>>> >> user_id | integer |
>>>>> >> state | character varying(16) | not null
>>>>> >> date | timestamp with time zone | not null
>>>>> >> layer_id | integer |
>>>>> >> upload_dir | character varying(100) |
>>>>> >> name | character varying(64) |
>>>>> >> complete | boolean | not null
>>>>> >> session | text |
>>>>> >> metadata | text |
>>>>> >> Indexes:
>>>>> >> "upload_upload_pkey" PRIMARY KEY, btree (id)
>>>>> >> "upload_upload_layer_id" btree (layer_id)
>>>>> >> "upload_upload_user_id" btree (user_id)
>>>>> >> Foreign-key constraints:
>>>>> >> "upload_upload_layer_id_fkey" FOREIGN KEY (layer_id) REFERENCES
>>>>> >> layers_layer(resourcebase_ptr_id) DEFERRABLE INITIALLY DEFERRED
>>>>> >> "upload_upload_user_id_fkey" FOREIGN KEY (user_id) REFERENCES
>>>>> >> people_profile(id) DEFERRABLE INITIALLY DEFERRED
>>>>> >> Referenced by:
>>>>> >> TABLE "upload_uploadfile" CONSTRAINT
>>>>> >> "upload_uploadfile_upload_id_fkey" FOREIGN KEY (upload_id)
>>>>> REFERENCES
>>>>> >> upload_upload(id) DEFERRABLE INITIALLY DEFERRED
>>>>> >>
>>>>> >> Geonode 2.6 database (from initial install):
>>>>> >> geonode=# \d upload_upload
>>>>> >> Table "public.upload_upload"
>>>>> >> Column | Type |
>>>>> >> Modifiers
>>>>> >>
>>>>> >> -------------------+--------------------------+-------------
>>>>> -----------------------------------------------
>>>>> >> id | integer | not null default
>>>>> >> nextval('upload_upload_id_seq'::regclass)
>>>>> >> import_id | bigint |
>>>>> >> state | character varying(16) | not null
>>>>> >> date | timestamp with time zone | not null
>>>>> >> upload_dir | character varying(100) |
>>>>> >> name | character varying(64) |
>>>>> >> complete | boolean | not null
>>>>> >> session | text |
>>>>> >> metadata | text |
>>>>> >> mosaic_time_regex | character varying(128) |
>>>>> >> mosaic_time_value | character varying(128) |
>>>>> >> mosaic_elev_regex | character varying(128) |
>>>>> >> mosaic_elev_value | character varying(128) |
>>>>> >> layer_id | integer |
>>>>> >> user_id | integer |
>>>>> >> Indexes:
>>>>> >> "upload_upload_pkey" PRIMARY KEY, btree (id)
>>>>> >> "upload_upload_7a39a38c" btree (layer_id)
>>>>> >> "upload_upload_e8701ad4" btree (user_id)
>>>>> >> Foreign-key constraints:
>>>>> >> "u_layer_id_6346de911330a880_fk_layers_layer_resourcebase_p
>>>>> tr_id"
>>>>> >> FOREIGN KEY (layer_id) REFERENCES layers_layer(resourcebase_ptr_id)
>>>>> >> DEFERRABLE INITIALLY DEFERRED
>>>>> >> "upload_upload_user_id_7fad116c8478bf31_fk_people_profile_id"
>>>>> >> FOREIGN KEY (user_id) REFERENCES people_profile(id) DEFERRABLE
>>>>> >> INITIALLY DEFERRED
>>>>> >> Referenced by:
>>>>> >> TABLE "upload_uploadfile" CONSTRAINT
>>>>> >> "upload_uploadfil_upload_id_21ef448d17dd4b6b_fk_upload_upload_id"
>>>>> >> FOREIGN KEY (upload_id) REFERENCES upload_upload(id) DEFERRABLE
>>>>> >> INITIALLY DEFERRED
>>>>> >>
>>>>> >>
>>>>> >> Thanks!
>>>>> >>
>>>>> >> Eric
>>>>> >> _______________________________________________
>>>>> >> geonode-users mailing list
>>>>> >> geonode-users at lists.osgeo.org
>>>>> >> https://lists.osgeo.org/mailman/listinfo/geonode-users
>>>>> >
>>>>> >
>>>>> _______________________________________________
>>>>> geonode-users mailing list
>>>>> geonode-users at lists.osgeo.org
>>>>> https://lists.osgeo.org/mailman/listinfo/geonode-users
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Simone
>>>>
>>>> _______________________________________________
>>>> geonode-users mailing list
>>>> geonode-users at lists.osgeo.org
>>>> https://lists.osgeo.org/mailman/listinfo/geonode-users
>>>>
>>>>
>>>
>>
>>
>> --
>> Simone
>>
>
>
--
Simone
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geonode-users/attachments/20171019/fd868eff/attachment.html>
More information about the geonode-users
mailing list