[OSGeoLive] #2360: EOxServer fails to launch

[OSGeoLive]

#2360: EOxServer fails to launch
-------------------------------+----------------------------
 Reporter:  darkblueb          |       Owner:  osgeolive@…
     Type:  defect             |      Status:  new
 Priority:  critical           |   Milestone:  OSGeoLive15.0
Component:  OSGeoLive          |  Resolution:
 Keywords:  eoxserver, django  |
-------------------------------+----------------------------
Comment (by kalxas):

 After adding jsonfield, there is progress in the installation but there is
 a new error when adding data to the database:

 {{{
 Extracting demonstration data in
 /usr/local/share/eoxserver/eoxserver_demonstration.
 INFO: Successfully imported coverage type 'RGB'
 Successfully created product type 'MERIS_product_type'
 Successfully created collection type 'MERIS_collection_type'
 Successfully created collection 'MER_FRS_1P_RGB_reduced'
 Traceback (most recent call last):
   File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line
 84, in _execute
     return self.cursor.execute(sql, params)
 psycopg2.errors.NotNullViolation: null value in column "identifier" of
 relation "coverages_eoobject" violates not-null constraint
 DETAIL:  Failing row contains (2, null, null, null, null, 2022-07-03
 15:48:36.568182+00, 2022-07-03 15:48:36.568196+00).


 The above exception was the direct cause of the following exception:

 Traceback (most recent call last):
   File "/usr/local/share/eoxserver/eoxserver_demonstration/manage.py",
 line 22, in <module>
     execute_from_command_line(sys.argv)
   File "/usr/lib/python3/dist-
 packages/django/core/management/__init__.py", line 381, in
 execute_from_command_line
     utility.execute()
   File "/usr/lib/python3/dist-
 packages/django/core/management/__init__.py", line 375, in execute
     self.fetch_command(subcommand).run_from_argv(self.argv)
   File "/usr/lib/python3/dist-packages/django/core/management/base.py",
 line 323, in run_from_argv
     self.execute(*args, **cmd_options)
   File "/usr/lib/python3/dist-packages/django/core/management/base.py",
 line 364, in execute
     output = self.handle(*args, **options)
   File "/usr/lib/python3.10/contextlib.py", line 79, in inner
     return func(*args, **kwds)
   File "/usr/lib/python3/dist-
 packages/eoxserver/resources/coverages/management/commands/product.py",
 line 239, in handle
     self.handle_register(*args, **kwargs)
   File "/usr/lib/python3/dist-
 packages/eoxserver/resources/coverages/management/commands/product.py",
 line 264, in handle_register
     product, replaced = ProductRegistrator().register(
   File "/usr/lib/python3/dist-
 packages/eoxserver/resources/coverages/registration/product.py", line 147,
 in register
     product = models.Product.objects.create(
   File "/usr/lib/python3/dist-packages/django/db/models/manager.py", line
 82, in manager_method
     return getattr(self.get_queryset(), name)(*args, **kwargs)
   File "/usr/lib/python3/dist-packages/django/db/models/query.py", line
 422, in create
     obj.save(force_insert=True, using=self.db)
   File "/usr/lib/python3/dist-packages/django/db/models/base.py", line
 743, in save
     self.save_base(using=using, force_insert=force_insert,
   File "/usr/lib/python3/dist-packages/django/db/models/base.py", line
 779, in save_base
     parent_inserted = self._save_parents(cls, using, update_fields)
   File "/usr/lib/python3/dist-packages/django/db/models/base.py", line
 808, in _save_parents
     updated = self._save_table(
   File "/usr/lib/python3/dist-packages/django/db/models/base.py", line
 873, in _save_table
     result = self._do_insert(cls._base_manager, using, fields, update_pk,
 raw)
   File "/usr/lib/python3/dist-packages/django/db/models/base.py", line
 910, in _do_insert
     return manager._insert([self], fields=fields, return_id=update_pk,
   File "/usr/lib/python3/dist-packages/django/db/models/manager.py", line
 82, in manager_method
     return getattr(self.get_queryset(), name)(*args, **kwargs)
   File "/usr/lib/python3/dist-packages/django/db/models/query.py", line
 1186, in _insert
     return query.get_compiler(using=using).execute_sql(return_id)
   File "/usr/lib/python3/dist-packages/django/db/models/sql/compiler.py",
 line 1377, in execute_sql
     cursor.execute(sql, params)
   File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line
 67, in execute
     return self._execute_with_wrappers(sql, params, many=False,
 executor=self._execute)
   File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line
 76, in _execute_with_wrappers
     return executor(sql, params, many, context)
   File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line
 80, in _execute
     with self.db.wrap_database_errors:
   File "/usr/lib/python3/dist-packages/django/db/utils.py", line 89, in
 __exit__
     raise dj_exc_value.with_traceback(traceback) from exc_value
   File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line
 84, in _execute
     return self.cursor.execute(sql, params)
 django.db.utils.IntegrityError: null value in column "identifier" of
 relation "coverages_eoobject" violates not-null constraint
 DETAIL:  Failing row contains (2, null, null, null, null, 2022-07-03
 15:48:36.568182+00, 2022-07-03 15:48:36.568196+00).
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/osgeolive/ticket/2360#comment:10>
OSGeoLive <https://live.osgeo.org/>
self-contained bootable DVD, USB thumb drive or Virtual Machine based on Lubuntu, that allows you to try a wide variety of open source geospatial software without installing anything.