Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

CREATE PROCEDURE DJANGO_SITE_RS failed #136

Open
devops724 opened this issue Nov 13, 2022 · 0 comments
Open

CREATE PROCEDURE DJANGO_SITE_RS failed #136

devops724 opened this issue Nov 13, 2022 · 0 comments

Comments

@devops724
Copy link

devops724 commented Nov 13, 2022

on django version 3.0.14 i get this
$ python manage.py migrate
Operations to perform:
Apply all migrations: admin, auth, contenttypes, sessions, sites
Running migrations:
Applying contenttypes.0001_initial... OK
Applying auth.0001_initial... OK
Applying admin.0001_initial... OK
Applying admin.0002_logentry_remove_auto_add... OK
Applying admin.0003_logentry_add_action_flag_choices... OK
Applying contenttypes.0002_remove_content_type_name... OK
Applying auth.0002_alter_permission_name_max_length... OK
Applying auth.0003_alter_user_email_max_length... OK
Applying auth.0004_alter_user_username_opts... OK
Applying auth.0005_alter_user_last_login_null... OK
Applying auth.0006_require_contenttypes_0002... OK
Applying auth.0007_alter_validators_add_error_messages... OK
Applying auth.0008_alter_user_username_max_length... OK
Applying auth.0009_alter_user_last_name_max_length... OK
Applying auth.0010_alter_group_name_max_length... OK
Applying auth.0011_update_proxy_permissions... OK
Applying sessions.0001_initial... OK
Applying sites.0001_initial... OK
Applying sites.0002_alter_domain_unique... OK
Traceback (most recent call last):
File "/home/user/env/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql)
File "/home/user/env/lib/python3.9/site-packages/django/db/backends/firebird/base.py", line 564, in execute
return self.cursor.execute(q, params)
File "/home/user/env/lib/python3.9/site-packages/fdb/fbcore.py", line 3695, in execute
self._ps._execute(parameters)
File "/home/user/env/lib/python3.9/site-packages/fdb/fbcore.py", line 3388, in _execute
raise exception_from_status(DatabaseError, self._isc_status,
fdb.fbcore.DatabaseError: ('Error while executing SQL statement:\n- SQLCODE: -104\n- unsuccessful metadata update\n- CREATE PROCEDURE DJANGO_SITE_RS failed\n- Dynamic SQL Error\n- SQL error code = -104\n- unknown ISC error 335545265', -104, 335544351)

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

Traceback (most recent call last):
File "/home/user/server/manage.py", line 33, in
main()
File "/home/user/server/manage.py", line 29, in main
execute_from_command_line(sys.argv)
File "/home/user/env/lib/python3.9/site-packages/django/core/management/init.py", line 401, in execute_from_command_line
utility.execute()
File "/home/user/env/lib/python3.9/site-packages/django/core/management/init.py", line 395, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/home/user/env/lib/python3.9/site-packages/django/core/management/base.py", line 328, in run_from_argv
self.execute(*args, **cmd_options)
File "/home/user/env/lib/python3.9/site-packages/django/core/management/base.py", line 369, in execute
output = self.handle(*args, **options)
File "/home/user/env/lib/python3.9/site-packages/django/core/management/base.py", line 83, in wrapped
res = handle_func(*args, **kwargs)
File "/home/user/env/lib/python3.9/site-packages/django/core/management/commands/migrate.py", line 255, in handle
emit_post_migrate_signal(
File "/home/user/env/lib/python3.9/site-packages/django/core/management/sql.py", line 44, in emit_post_migrate_signal
models.signals.post_migrate.send(
File "/home/user/env/lib/python3.9/site-packages/django/dispatch/dispatcher.py", line 173, in send
return [
File "/home/user/env/lib/python3.9/site-packages/django/dispatch/dispatcher.py", line 174, in
(receiver, receiver(signal=self, sender=sender, **named))
File "/home/user/env/lib/python3.9/site-packages/django/contrib/sites/management.py", line 38, in create_default_site
cursor.execute(command)
File "/home/user/env/lib/python3.9/site-packages/django/db/backends/utils.py", line 100, in execute
return super().execute(sql, params)
File "/home/user/env/lib/python3.9/site-packages/django/db/backends/utils.py", line 68, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/home/user/env/lib/python3.9/site-packages/django/db/backends/utils.py", line 77, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/home/user/env/lib/python3.9/site-packages/django/db/backends/utils.py", line 86, in _execute
return self.cursor.execute(sql, params)
File "/home/user/env/lib/python3.9/site-packages/django/db/utils.py", line 90, in exit
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/home/user/env/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql)
File "/home/user/env/lib/python3.9/site-packages/django/db/backends/firebird/base.py", line 564, in execute
return self.cursor.execute(q, params)
File "/home/user/env/lib/python3.9/site-packages/fdb/fbcore.py", line 3695, in execute
self._ps._execute(parameters)
File "/home/user/env/lib/python3.9/site-packages/fdb/fbcore.py", line 3388, in _execute
raise exception_from_status(DatabaseError, self._isc_status,
django.db.utils.DatabaseError: ('Error while executing SQL statement:\n- SQLCODE: -104\n- unsuccessful metadata update\n- CREATE PROCEDURE DJANGO_SITE_RS failed\n- Dynamic SQL Error\n- SQL error code = -104\n- unknown ISC error 335545265', -104, 335544351)

python 3.9
django-3.0.14
firebird 2.2

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant