rebuild database

[Tatiana Canelhas]

Hi group,

I just install a fresh version of AM 1.11 (ubuntu 18), and as I to do to the steps listed in Post Install Configuration and open the dashboard, I got the error: 

Internal server error

Sorry! Something wrong happened. Please, contact with your administrator.

So, in the dashboard log, there is: 

ERROR     2020-12-18 19:47:16  django.request:base:handle_uncaught_exception:256:  Internal Server Error: /installer/welcome/

Traceback (most recent call last):

  File "/usr/share/archivematica/virtualenvs/archivematica-dashboard/local/lib/python2.7/site-packages/django/core/handlers/base.py", line 132, in get_response

    response = wrapped_callback(request, *callback_args, **callback_kwargs)

  File "/usr/share/archivematica/dashboard/installer/views.py", line 40, in welcome

    set_up_user = not User.objects.exists()

  File "/usr/share/archivematica/virtualenvs/archivematica-dashboard/local/lib/python2.7/site-packages/django/db/models/manager.py", line 127, in manager_method

    return getattr(self.get_queryset(), name)(*args, **kwargs)

  File "/usr/share/archivematica/virtualenvs/archivematica-dashboard/local/lib/python2.7/site-packages/django/db/models/query.py", line 586, in exists

    return self.query.has_results(using=self.db)

  File "/usr/share/archivematica/virtualenvs/archivematica-dashboard/local/lib/python2.7/site-packages/django/db/models/sql/query.py", line 484, in has_results

    return compiler.has_results()

  File "/usr/share/archivematica/virtualenvs/archivematica-dashboard/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 811, in has_results

    return bool(self.execute_sql(SINGLE))

  File "/usr/share/archivematica/virtualenvs/archivematica-dashboard/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 840, in execute_sql

    cursor.execute(sql, params)

  File "/usr/share/archivematica/virtualenvs/archivematica-dashboard/local/lib/python2.7/site-packages/django/db/backends/utils.py", line 64, in execute

    return self.cursor.execute(sql, params)

  File "/usr/share/archivematica/virtualenvs/archivematica-dashboard/local/lib/python2.7/site-packages/django/db/utils.py", line 98, in __exit__

    six.reraise(dj_exc_type, dj_exc_value, traceback)

  File "/usr/share/archivematica/virtualenvs/archivematica-dashboard/local/lib/python2.7/site-packages/django/db/backends/utils.py", line 64, in execute

    return self.cursor.execute(sql, params)

  File "/usr/share/archivematica/virtualenvs/archivematica-dashboard/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py", line 124, in execute

    return self.cursor.execute(query, args)

  File "/usr/share/archivematica/virtualenvs/archivematica-dashboard/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 226, in execute

    self.errorhandler(self, exc, value)

  File "/usr/share/archivematica/virtualenvs/archivematica-dashboard/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler

    raise errorvalue

ProgrammingError: (1146, "Table 'MCP.auth_user' doesn't exist")

Is there a way to reinstall, rebuild the database?

Thanks,

Tatiana Canelhas

[Rams Jay]

Hi Tatiana,

Could you please let me know will you manage to fix the above issue? I'm also experiencing same issue in our environment set up.

Thanks

Ram

[Tatiana Canelhas]

Hi Ram,

now I am using the latest version (1.13.2), and got no error.

Are you on 1.11?

[Rams Jay]

Hi Tatiana,

Yes, I 'm also using the latest version 1.13.2 and getting the similar error.

Internal server error

Sorry! Something wrong happened. Please, contact with your administrator.

Dashboard log:

ERROR     2022-02-10 12:07:44  django.request:exception:handle_uncaught_exception:135:  Internal Server Error: /installer/welcome/

Traceback (most recent call last):

  File "/usr/share/archivematica/virtualenvs/archivematica/lib/python3.6/site-packages/django/db/backends/utils.py", line 64, in execute
    return self.cursor.execute(sql, params)
  File "/usr/share/archivematica/virtualenvs/archivematica/lib/python3.6/site-packages/django/db/backends/mysql/base.py", line 101, in execute
    return self.cursor.execute(query, args)
  File "/usr/share/archivematica/virtualenvs/archivematica/lib/python3.6/site-packages/MySQLdb/cursors.py", line 209, in execute
    res = self._query(query)
  File "/usr/share/archivematica/virtualenvs/archivematica/lib/python3.6/site-packages/MySQLdb/cursors.py", line 315, in _query
    db.query(q)
  File "/usr/share/archivematica/virtualenvs/archivematica/lib/python3.6/site-packages/MySQLdb/connections.py", line 239, in query
    _mysql.connection.query(self, query)
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'MCP.auth_user' doesn't exist")

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

Traceback (most recent call last):

  File "/usr/share/archivematica/virtualenvs/archivematica/lib/python3.6/site-packages/django/core/handlers/exception.py", line 41, in inner
    response = get_response(request)
  File "/usr/share/archivematica/virtualenvs/archivematica/lib/python3.6/site-packages/django/core/handlers/base.py", line 187, in _get_response
    response = self.process_exception_by_middleware(e, request)
  File "/usr/share/archivematica/virtualenvs/archivematica/lib/python3.6/site-packages/django/core/handlers/base.py", line 185, in _get_response

    response = wrapped_callback(request, *callback_args, **callback_kwargs)
  File "/usr/share/archivematica/dashboard/installer/views.py", line 40, in welcome
    set_up_user = not User.objects.exists()

  File "/usr/share/archivematica/virtualenvs/archivematica/lib/python3.6/site-packages/django/db/models/manager.py", line 85, in manager_method
    return getattr(self.get_queryset(), name)(*args, **kwargs)
  File "/usr/share/archivematica/virtualenvs/archivematica/lib/python3.6/site-packages/django/db/models/query.py", line 673, in exists
    return self.query.has_results(using=self.db)
  File "/usr/share/archivematica/virtualenvs/archivematica/lib/python3.6/site-packages/django/db/models/sql/query.py", line 517, in has_results
    return compiler.has_results()
  File "/usr/share/archivematica/virtualenvs/archivematica/lib/python3.6/site-packages/django/db/models/sql/compiler.py", line 858, in has_results
    return bool(self.execute_sql(SINGLE))
  File "/usr/share/archivematica/virtualenvs/archivematica/lib/python3.6/site-packages/django/db/models/sql/compiler.py", line 899, in execute_sql
    raise original_exception
  File "/usr/share/archivematica/virtualenvs/archivematica/lib/python3.6/site-packages/django/db/models/sql/compiler.py", line 889, in execute_sql
    cursor.execute(sql, params)
  File "/usr/share/archivematica/virtualenvs/archivematica/lib/python3.6/site-packages/django/db/backends/utils.py", line 64, in execute
    return self.cursor.execute(sql, params)
  File "/usr/share/archivematica/virtualenvs/archivematica/lib/python3.6/site-packages/django/db/utils.py", line 94, in __exit__
    six.reraise(dj_exc_type, dj_exc_value, traceback)
  File "/usr/share/archivematica/virtualenvs/archivematica/lib/python3.6/site-packages/django/utils/six.py", line 685, in reraise
    raise value.with_traceback(tb)
  File "/usr/share/archivematica/virtualenvs/archivematica/lib/python3.6/site-packages/django/db/backends/utils.py", line 64, in execute
    return self.cursor.execute(sql, params)
  File "/usr/share/archivematica/virtualenvs/archivematica/lib/python3.6/site-packages/django/db/backends/mysql/base.py", line 101, in execute
    return self.cursor.execute(query, args)
  File "/usr/share/archivematica/virtualenvs/archivematica/lib/python3.6/site-packages/MySQLdb/cursors.py", line 209, in execute
    res = self._query(query)
  File "/usr/share/archivematica/virtualenvs/archivematica/lib/python3.6/site-packages/MySQLdb/cursors.py", line 315, in _query
    db.query(q)
  File "/usr/share/archivematica/virtualenvs/archivematica/lib/python3.6/site-packages/MySQLdb/connections.py", line 239, in query
    _mysql.connection.query(self, query)
django.db.utils.ProgrammingError: (1146, "Table 'MCP.auth_user' doesn't exist")

Any updates on how you fixed it in your older version? Or you have upgraded to latest version and it helps to resolve the issue?

Else any DB activities needs to be done? Pls confirm.

Regards

Ram

[Daniel Monteiro]

Dear, 

The database installation was not performed, in this case, it is necessary to reinstall.

Daniel R. Monteiro

Enviado do meu iPhone

Em 18 de dez. de 2020, à(s) 17:01, Tatiana Canelhas <tat...@gmail.com> escreveu:



--
You received this message because you are subscribed to the Google Groups "archivematica" group.
To unsubscribe from this group and stop receiving emails from it, send an email to archivematic...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/archivematica/b4e17ad5-5b9b-46f9-83dc-ff5faec42515n%40googlegroups.com.

[Rams Jay]

Thanks a lot Daniel. Dropped the existing DB and re-installed helped to resolved the issue.

Regards

Ram