Psycopg2 errors undefinedtable ошибка отношение не существует

Traceback (most recent call last):
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1249, in _execute_context
    cursor, statement, parameters, context
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 580, in do_execute
    cursor.execute(statement, parameters)
psycopg2.errors.UndefinedTable: relation "organizations" does not exist
LINE 2: FROM organizations 
             ^

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

Traceback (most recent call last):
  File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 2463, in __call__
    return self.wsgi_app(environ, start_response)
  File "/usr/local/lib/python3.7/site-packages/werkzeug/middleware/proxy_fix.py", line 232, in __call__
    return self.app(environ, start_response)
  File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 2449, in wsgi_app
    response = self.handle_exception(e)
  File "/usr/local/lib/python3.7/site-packages/flask_restful/__init__.py", line 269, in error_router
    return original_handler(e)
  File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 1866, in handle_exception
    reraise(exc_type, exc_value, tb)
  File "/usr/local/lib/python3.7/site-packages/flask/_compat.py", line 39, in reraise
    raise value
  File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 2446, in wsgi_app
    response = self.full_dispatch_request()
  File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 1951, in full_dispatch_request
    rv = self.handle_user_exception(e)
  File "/usr/local/lib/python3.7/site-packages/flask_restful/__init__.py", line 269, in error_router
    return original_handler(e)
  File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 1820, in handle_user_exception
    reraise(exc_type, exc_value, tb)
  File "/usr/local/lib/python3.7/site-packages/flask/_compat.py", line 39, in reraise
    raise value
  File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 1949, in full_dispatch_request
    rv = self.dispatch_request()
  File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 1935, in dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "/usr/local/lib/python3.7/site-packages/flask_limiter/extension.py", line 442, in __inner
    return obj(*a, **k)
  File "/app/redash/handlers/authentication.py", line 190, in login
    if current_org == None and not settings.MULTI_ORG:
  File "/usr/local/lib/python3.7/site-packages/werkzeug/local.py", line 370, in <lambda>
    __eq__ = lambda x, o: x._get_current_object() == o
  File "/usr/local/lib/python3.7/site-packages/werkzeug/local.py", line 307, in _get_current_object
    return self.__local()
  File "/app/redash/authentication/org_resolving.py", line 18, in _get_current_org
    g.org = Organization.get_by_slug(slug)
  File "/app/redash/models/organizations.py", line 31, in get_by_slug
    return cls.query.filter(cls.slug == slug).first()
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3240, in first
    ret = list(self[0:1])
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3018, in __getitem__
    return list(res)
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3342, in __iter__
    return self._execute_and_instances(context)
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3367, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 988, in execute
    return meth(self, multiparams, params)
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 287, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1107, in _execute_clauseelement
    distilled_params,
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1253, in _execute_context
    e, statement, parameters, cursor, context
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1473, in _handle_dbapi_exception
    util.raise_from_cause(sqlalchemy_exception, exc_info)
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 398, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb, cause=cause)
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 152, in reraise
    raise value.with_traceback(tb)
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1249, in _execute_context
    cursor, statement, parameters, context
  File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 580, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedTable) relation "organizations" does not exist
LINE 2: FROM organizations 
             ^

[SQL: SELECT organizations.updated_at AS organizations_updated_at, organizations.created_at AS organizations_created_at, organizations.id AS organizations_id, organizations.name AS organizations_name, organizations.slug AS organizations_slug, organizations.settings AS organizations_settings 
FROM organizations 
WHERE organizations.slug = %(slug_1)s 
 LIMIT %(param_1)s]
[parameters: {'slug_1': 'default', 'param_1': 1}]
(Background on this error at: http://sqlalche.me/e/f405)

Technical details:

Redash Version: e9bcc3c
How did you install Redash: docker-compose up —build (+ some dep fixes, otherwise it would not start)

Источник

Issue

I tried to start using Postgresql instead of sqlite in my Django project.
I installed postgreqL ON MY Windows, creatred a new database, user and password.

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql_psycopg2',
        'NAME': 'database_name',
        'USER': 'admin',
        'PASSWORD': 'admin',
        'HOST': 'localhost',
        'PORT': '5432',
    }
}

But when I try to migrate or makemigrations, I got this:

File
«C:Userss…venvlibsite-packagesdjangodbbackendsutils.py»,
line 85, in _execute
return self.cursor.execute(sql, params) psycopg2.errors.UndefinedTable: relation «authentication_author» does
not exist LINE 1: …hentication_author».»is_doctor» FROM
«authentic…

here is my model:

class Author(models.Model):
    user = models.OneToOneField(User, on_delete=models.CASCADE, null=True, related_name="author")
    slug = models.CharField(max_length=50, null=True, blank=True,)
    is_doctor = models.BooleanField(default=False)

And yes, I deleted the sqlite3 database, all the migrations folders and I created new ones with the init.py inside of them.

But still get the same problem.

Updated
Traceback screenshots:
second-error

first error

Solution

It happens with Django. Sometimes you can invoke some code that relies on a new DB schema at the time you’re trying to makemigrations.

All you need in this situation is to temporarily comment out all the code that connects makemigrations with your new model’s schema. As it was in this question, you can trace related blocks of code just using full traceback.

Answered By — Yevgeniy Kosmak

Источник

New in version 2.8.

Changed in version 2.8.4: added errors introduced in PostgreSQL 12

Changed in version 2.8.6: added errors introduced in PostgreSQL 13

Changed in version 2.9.2: added errors introduced in PostgreSQL 14

Changed in version 2.9.4: added errors introduced in PostgreSQL 15

This module exposes the classes psycopg raises upon receiving an error from
the database with a SQLSTATE value attached (available in the
pgcode attribute). The content of the module is generated
from the PostgreSQL source code and includes classes for every error defined
by PostgreSQL in versions between 9.1 and 15.

Every class in the module is named after what referred as “condition name” in
the documentation, converted to CamelCase: e.g. the error 22012,
division_by_zero is exposed by this module as the class DivisionByZero.

Every exception class is a subclass of one of the standard DB-API
exception and expose the Error interface.
Each class’ superclass is what used to be raised by psycopg in versions before
the introduction of this module, so everything should be compatible with
previously written code catching one the DB-API class: if your code used to
catch IntegrityError to detect a duplicate entry, it will keep on working
even if a more specialised subclass such as UniqueViolation is raised.

The new classes allow a more idiomatic way to check and process a specific
error among the many the database may return. For instance, in order to check
that a table is locked, the following code could have been used previously:

try:
    cur.execute("LOCK TABLE mytable IN ACCESS EXCLUSIVE MODE NOWAIT")
except psycopg2.OperationalError as e:
    if e.pgcode == psycopg2.errorcodes.LOCK_NOT_AVAILABLE:
        locked = True
    else:
        raise

While this method is still available, the specialised class allows for a more
idiomatic error handler:

try:
    cur.execute("LOCK TABLE mytable IN ACCESS EXCLUSIVE MODE NOWAIT")
except psycopg2.errors.LockNotAvailable:
    locked = True

psycopg2.errors.lookup(code)¶

Lookup an error code and return its exception class.

Raise KeyError if the code is not found.

try:
    cur.execute("LOCK TABLE mytable IN ACCESS EXCLUSIVE MODE NOWAIT")
except psycopg2.errors.lookup("55P03"):
    locked = True

SQLSTATE exception classes¶

The following table contains the list of all the SQLSTATE classes exposed by
the module.

Note that, for completeness, the module also exposes all the
DB-API-defined exceptions and a few
psycopg-specific ones exposed by the extensions
module, which are not listed here.

SQLSTATE	Exception	Base exception
Class 02: No Data (this is also a warning class per the SQL standard)
`02000`	`NoData`	`DatabaseError`
`02001`	`NoAdditionalDynamicResultSetsReturned`	`DatabaseError`
Class 03: SQL Statement Not Yet Complete
`03000`	`SqlStatementNotYetComplete`	`DatabaseError`
Class 08: Connection Exception
`08000`	`ConnectionException`	`OperationalError`
`08001`	`SqlclientUnableToEstablishSqlconnection`	`OperationalError`
`08003`	`ConnectionDoesNotExist`	`OperationalError`
`08004`	`SqlserverRejectedEstablishmentOfSqlconnection`	`OperationalError`
`08006`	`ConnectionFailure`	`OperationalError`
`08007`	`TransactionResolutionUnknown`	`OperationalError`
`08P01`	`ProtocolViolation`	`OperationalError`
Class 09: Triggered Action Exception
`09000`	`TriggeredActionException`	`DatabaseError`
Class 0A: Feature Not Supported
`0A000`	`FeatureNotSupported`	`NotSupportedError`
Class 0B: Invalid Transaction Initiation
`0B000`	`InvalidTransactionInitiation`	`DatabaseError`
Class 0F: Locator Exception
`0F000`	`LocatorException`	`DatabaseError`
`0F001`	`InvalidLocatorSpecification`	`DatabaseError`
Class 0L: Invalid Grantor
`0L000`	`InvalidGrantor`	`DatabaseError`
`0LP01`	`InvalidGrantOperation`	`DatabaseError`
Class 0P: Invalid Role Specification
`0P000`	`InvalidRoleSpecification`	`DatabaseError`
Class 0Z: Diagnostics Exception
`0Z000`	`DiagnosticsException`	`DatabaseError`
`0Z002`	`StackedDiagnosticsAccessedWithoutActiveHandler`	`DatabaseError`
Class 20: Case Not Found
`20000`	`CaseNotFound`	`ProgrammingError`
Class 21: Cardinality Violation
`21000`	`CardinalityViolation`	`ProgrammingError`
Class 22: Data Exception
`22000`	`DataException`	`DataError`
`22001`	`StringDataRightTruncation`	`DataError`
`22002`	`NullValueNoIndicatorParameter`	`DataError`
`22003`	`NumericValueOutOfRange`	`DataError`
`22004`	`NullValueNotAllowed`	`DataError`
`22005`	`ErrorInAssignment`	`DataError`
`22007`	`InvalidDatetimeFormat`	`DataError`
`22008`	`DatetimeFieldOverflow`	`DataError`
`22009`	`InvalidTimeZoneDisplacementValue`	`DataError`
`2200B`	`EscapeCharacterConflict`	`DataError`
`2200C`	`InvalidUseOfEscapeCharacter`	`DataError`
`2200D`	`InvalidEscapeOctet`	`DataError`
`2200F`	`ZeroLengthCharacterString`	`DataError`
`2200G`	`MostSpecificTypeMismatch`	`DataError`
`2200H`	`SequenceGeneratorLimitExceeded`	`DataError`
`2200L`	`NotAnXmlDocument`	`DataError`
`2200M`	`InvalidXmlDocument`	`DataError`
`2200N`	`InvalidXmlContent`	`DataError`
`2200S`	`InvalidXmlComment`	`DataError`
`2200T`	`InvalidXmlProcessingInstruction`	`DataError`
`22010`	`InvalidIndicatorParameterValue`	`DataError`
`22011`	`SubstringError`	`DataError`
`22012`	`DivisionByZero`	`DataError`
`22013`	`InvalidPrecedingOrFollowingSize`	`DataError`
`22014`	`InvalidArgumentForNtileFunction`	`DataError`
`22015`	`IntervalFieldOverflow`	`DataError`
`22016`	`InvalidArgumentForNthValueFunction`	`DataError`
`22018`	`InvalidCharacterValueForCast`	`DataError`
`22019`	`InvalidEscapeCharacter`	`DataError`
`2201B`	`InvalidRegularExpression`	`DataError`
`2201E`	`InvalidArgumentForLogarithm`	`DataError`
`2201F`	`InvalidArgumentForPowerFunction`	`DataError`
`2201G`	`InvalidArgumentForWidthBucketFunction`	`DataError`
`2201W`	`InvalidRowCountInLimitClause`	`DataError`
`2201X`	`InvalidRowCountInResultOffsetClause`	`DataError`
`22021`	`CharacterNotInRepertoire`	`DataError`
`22022`	`IndicatorOverflow`	`DataError`
`22023`	`InvalidParameterValue`	`DataError`
`22024`	`UnterminatedCString`	`DataError`
`22025`	`InvalidEscapeSequence`	`DataError`
`22026`	`StringDataLengthMismatch`	`DataError`
`22027`	`TrimError`	`DataError`
`2202E`	`ArraySubscriptError`	`DataError`
`2202G`	`InvalidTablesampleRepeat`	`DataError`
`2202H`	`InvalidTablesampleArgument`	`DataError`
`22030`	`DuplicateJsonObjectKeyValue`	`DataError`
`22031`	`InvalidArgumentForSqlJsonDatetimeFunction`	`DataError`
`22032`	`InvalidJsonText`	`DataError`
`22033`	`InvalidSqlJsonSubscript`	`DataError`
`22034`	`MoreThanOneSqlJsonItem`	`DataError`
`22035`	`NoSqlJsonItem`	`DataError`
`22036`	`NonNumericSqlJsonItem`	`DataError`
`22037`	`NonUniqueKeysInAJsonObject`	`DataError`
`22038`	`SingletonSqlJsonItemRequired`	`DataError`
`22039`	`SqlJsonArrayNotFound`	`DataError`
`2203A`	`SqlJsonMemberNotFound`	`DataError`
`2203B`	`SqlJsonNumberNotFound`	`DataError`
`2203C`	`SqlJsonObjectNotFound`	`DataError`
`2203D`	`TooManyJsonArrayElements`	`DataError`
`2203E`	`TooManyJsonObjectMembers`	`DataError`
`2203F`	`SqlJsonScalarRequired`	`DataError`
`2203G`	`SqlJsonItemCannotBeCastToTargetType`	`DataError`
`22P01`	`FloatingPointException`	`DataError`
`22P02`	`InvalidTextRepresentation`	`DataError`
`22P03`	`InvalidBinaryRepresentation`	`DataError`
`22P04`	`BadCopyFileFormat`	`DataError`
`22P05`	`UntranslatableCharacter`	`DataError`
`22P06`	`NonstandardUseOfEscapeCharacter`	`DataError`
Class 23: Integrity Constraint Violation
`23000`	`IntegrityConstraintViolation`	`IntegrityError`
`23001`	`RestrictViolation`	`IntegrityError`
`23502`	`NotNullViolation`	`IntegrityError`
`23503`	`ForeignKeyViolation`	`IntegrityError`
`23505`	`UniqueViolation`	`IntegrityError`
`23514`	`CheckViolation`	`IntegrityError`
`23P01`	`ExclusionViolation`	`IntegrityError`
Class 24: Invalid Cursor State
`24000`	`InvalidCursorState`	`InternalError`
Class 25: Invalid Transaction State
`25000`	`InvalidTransactionState`	`InternalError`
`25001`	`ActiveSqlTransaction`	`InternalError`
`25002`	`BranchTransactionAlreadyActive`	`InternalError`
`25003`	`InappropriateAccessModeForBranchTransaction`	`InternalError`
`25004`	`InappropriateIsolationLevelForBranchTransaction`	`InternalError`
`25005`	`NoActiveSqlTransactionForBranchTransaction`	`InternalError`
`25006`	`ReadOnlySqlTransaction`	`InternalError`
`25007`	`SchemaAndDataStatementMixingNotSupported`	`InternalError`
`25008`	`HeldCursorRequiresSameIsolationLevel`	`InternalError`
`25P01`	`NoActiveSqlTransaction`	`InternalError`
`25P02`	`InFailedSqlTransaction`	`InternalError`
`25P03`	`IdleInTransactionSessionTimeout`	`InternalError`
Class 26: Invalid SQL Statement Name
`26000`	`InvalidSqlStatementName`	`OperationalError`
Class 27: Triggered Data Change Violation
`27000`	`TriggeredDataChangeViolation`	`OperationalError`
Class 28: Invalid Authorization Specification
`28000`	`InvalidAuthorizationSpecification`	`OperationalError`
`28P01`	`InvalidPassword`	`OperationalError`
Class 2B: Dependent Privilege Descriptors Still Exist
`2B000`	`DependentPrivilegeDescriptorsStillExist`	`InternalError`
`2BP01`	`DependentObjectsStillExist`	`InternalError`
Class 2D: Invalid Transaction Termination
`2D000`	`InvalidTransactionTermination`	`InternalError`
Class 2F: SQL Routine Exception
`2F000`	`SqlRoutineException`	`InternalError`
`2F002`	`ModifyingSqlDataNotPermitted`	`InternalError`
`2F003`	`ProhibitedSqlStatementAttempted`	`InternalError`
`2F004`	`ReadingSqlDataNotPermitted`	`InternalError`
`2F005`	`FunctionExecutedNoReturnStatement`	`InternalError`
Class 34: Invalid Cursor Name
`34000`	`InvalidCursorName`	`OperationalError`
Class 38: External Routine Exception
`38000`	`ExternalRoutineException`	`InternalError`
`38001`	`ContainingSqlNotPermitted`	`InternalError`
`38002`	`ModifyingSqlDataNotPermittedExt`	`InternalError`
`38003`	`ProhibitedSqlStatementAttemptedExt`	`InternalError`
`38004`	`ReadingSqlDataNotPermittedExt`	`InternalError`
Class 39: External Routine Invocation Exception
`39000`	`ExternalRoutineInvocationException`	`InternalError`
`39001`	`InvalidSqlstateReturned`	`InternalError`
`39004`	`NullValueNotAllowedExt`	`InternalError`
`39P01`	`TriggerProtocolViolated`	`InternalError`
`39P02`	`SrfProtocolViolated`	`InternalError`
`39P03`	`EventTriggerProtocolViolated`	`InternalError`
Class 3B: Savepoint Exception
`3B000`	`SavepointException`	`InternalError`
`3B001`	`InvalidSavepointSpecification`	`InternalError`
Class 3D: Invalid Catalog Name
`3D000`	`InvalidCatalogName`	`ProgrammingError`
Class 3F: Invalid Schema Name
`3F000`	`InvalidSchemaName`	`ProgrammingError`
Class 40: Transaction Rollback
`40000`	`TransactionRollback`	`OperationalError`
`40001`	`SerializationFailure`	`OperationalError`
`40002`	`TransactionIntegrityConstraintViolation`	`OperationalError`
`40003`	`StatementCompletionUnknown`	`OperationalError`
`40P01`	`DeadlockDetected`	`OperationalError`
Class 42: Syntax Error or Access Rule Violation
`42000`	`SyntaxErrorOrAccessRuleViolation`	`ProgrammingError`
`42501`	`InsufficientPrivilege`	`ProgrammingError`
`42601`	`SyntaxError`	`ProgrammingError`
`42602`	`InvalidName`	`ProgrammingError`
`42611`	`InvalidColumnDefinition`	`ProgrammingError`
`42622`	`NameTooLong`	`ProgrammingError`
`42701`	`DuplicateColumn`	`ProgrammingError`
`42702`	`AmbiguousColumn`	`ProgrammingError`
`42703`	`UndefinedColumn`	`ProgrammingError`
`42704`	`UndefinedObject`	`ProgrammingError`
`42710`	`DuplicateObject`	`ProgrammingError`
`42712`	`DuplicateAlias`	`ProgrammingError`
`42723`	`DuplicateFunction`	`ProgrammingError`
`42725`	`AmbiguousFunction`	`ProgrammingError`
`42803`	`GroupingError`	`ProgrammingError`
`42804`	`DatatypeMismatch`	`ProgrammingError`
`42809`	`WrongObjectType`	`ProgrammingError`
`42830`	`InvalidForeignKey`	`ProgrammingError`
`42846`	`CannotCoerce`	`ProgrammingError`
`42883`	`UndefinedFunction`	`ProgrammingError`
`428C9`	`GeneratedAlways`	`ProgrammingError`
`42939`	`ReservedName`	`ProgrammingError`
`42P01`	`UndefinedTable`	`ProgrammingError`
`42P02`	`UndefinedParameter`	`ProgrammingError`
`42P03`	`DuplicateCursor`	`ProgrammingError`
`42P04`	`DuplicateDatabase`	`ProgrammingError`
`42P05`	`DuplicatePreparedStatement`	`ProgrammingError`
`42P06`	`DuplicateSchema`	`ProgrammingError`
`42P07`	`DuplicateTable`	`ProgrammingError`
`42P08`	`AmbiguousParameter`	`ProgrammingError`
`42P09`	`AmbiguousAlias`	`ProgrammingError`
`42P10`	`InvalidColumnReference`	`ProgrammingError`
`42P11`	`InvalidCursorDefinition`	`ProgrammingError`
`42P12`	`InvalidDatabaseDefinition`	`ProgrammingError`
`42P13`	`InvalidFunctionDefinition`	`ProgrammingError`
`42P14`	`InvalidPreparedStatementDefinition`	`ProgrammingError`
`42P15`	`InvalidSchemaDefinition`	`ProgrammingError`
`42P16`	`InvalidTableDefinition`	`ProgrammingError`
`42P17`	`InvalidObjectDefinition`	`ProgrammingError`
`42P18`	`IndeterminateDatatype`	`ProgrammingError`
`42P19`	`InvalidRecursion`	`ProgrammingError`
`42P20`	`WindowingError`	`ProgrammingError`
`42P21`	`CollationMismatch`	`ProgrammingError`
`42P22`	`IndeterminateCollation`	`ProgrammingError`
Class 44: WITH CHECK OPTION Violation
`44000`	`WithCheckOptionViolation`	`ProgrammingError`
Class 53: Insufficient Resources
`53000`	`InsufficientResources`	`OperationalError`
`53100`	`DiskFull`	`OperationalError`
`53200`	`OutOfMemory`	`OperationalError`
`53300`	`TooManyConnections`	`OperationalError`
`53400`	`ConfigurationLimitExceeded`	`OperationalError`
Class 54: Program Limit Exceeded
`54000`	`ProgramLimitExceeded`	`OperationalError`
`54001`	`StatementTooComplex`	`OperationalError`
`54011`	`TooManyColumns`	`OperationalError`
`54023`	`TooManyArguments`	`OperationalError`
Class 55: Object Not In Prerequisite State
`55000`	`ObjectNotInPrerequisiteState`	`OperationalError`
`55006`	`ObjectInUse`	`OperationalError`
`55P02`	`CantChangeRuntimeParam`	`OperationalError`
`55P03`	`LockNotAvailable`	`OperationalError`
`55P04`	`UnsafeNewEnumValueUsage`	`OperationalError`
Class 57: Operator Intervention
`57000`	`OperatorIntervention`	`OperationalError`
`57014`	`QueryCanceled`	`OperationalError`
`57P01`	`AdminShutdown`	`OperationalError`
`57P02`	`CrashShutdown`	`OperationalError`
`57P03`	`CannotConnectNow`	`OperationalError`
`57P04`	`DatabaseDropped`	`OperationalError`
`57P05`	`IdleSessionTimeout`	`OperationalError`
Class 58: System Error (errors external to PostgreSQL itself)
`58000`	`SystemError`	`OperationalError`
`58030`	`IoError`	`OperationalError`
`58P01`	`UndefinedFile`	`OperationalError`
`58P02`	`DuplicateFile`	`OperationalError`
Class 72: Snapshot Failure
`72000`	`SnapshotTooOld`	`DatabaseError`
Class F0: Configuration File Error
`F0000`	`ConfigFileError`	`InternalError`
`F0001`	`LockFileExists`	`InternalError`
Class HV: Foreign Data Wrapper Error (SQL/MED)
`HV000`	`FdwError`	`OperationalError`
`HV001`	`FdwOutOfMemory`	`OperationalError`
`HV002`	`FdwDynamicParameterValueNeeded`	`OperationalError`
`HV004`	`FdwInvalidDataType`	`OperationalError`
`HV005`	`FdwColumnNameNotFound`	`OperationalError`
`HV006`	`FdwInvalidDataTypeDescriptors`	`OperationalError`
`HV007`	`FdwInvalidColumnName`	`OperationalError`
`HV008`	`FdwInvalidColumnNumber`	`OperationalError`
`HV009`	`FdwInvalidUseOfNullPointer`	`OperationalError`
`HV00A`	`FdwInvalidStringFormat`	`OperationalError`
`HV00B`	`FdwInvalidHandle`	`OperationalError`
`HV00C`	`FdwInvalidOptionIndex`	`OperationalError`
`HV00D`	`FdwInvalidOptionName`	`OperationalError`
`HV00J`	`FdwOptionNameNotFound`	`OperationalError`
`HV00K`	`FdwReplyHandle`	`OperationalError`
`HV00L`	`FdwUnableToCreateExecution`	`OperationalError`
`HV00M`	`FdwUnableToCreateReply`	`OperationalError`
`HV00N`	`FdwUnableToEstablishConnection`	`OperationalError`
`HV00P`	`FdwNoSchemas`	`OperationalError`
`HV00Q`	`FdwSchemaNotFound`	`OperationalError`
`HV00R`	`FdwTableNotFound`	`OperationalError`
`HV010`	`FdwFunctionSequenceError`	`OperationalError`
`HV014`	`FdwTooManyHandles`	`OperationalError`
`HV021`	`FdwInconsistentDescriptorInformation`	`OperationalError`
`HV024`	`FdwInvalidAttributeValue`	`OperationalError`
`HV090`	`FdwInvalidStringLengthOrBufferLength`	`OperationalError`
`HV091`	`FdwInvalidDescriptorFieldIdentifier`	`OperationalError`
Class P0: PL/pgSQL Error
`P0000`	`PlpgsqlError`	`InternalError`
`P0001`	`RaiseException`	`InternalError`
`P0002`	`NoDataFound`	`InternalError`
`P0003`	`TooManyRows`	`InternalError`
`P0004`	`AssertFailure`	`InternalError`
Class XX: Internal Error
`XX000`	`InternalError_`	`InternalError`
`XX001`	`DataCorrupted`	`InternalError`
`XX002`	`IndexCorrupted`	`InternalError`

Источник

Avatar

In odoo 15, i got the issue after trying to create Many2many field in settings:

psycopg2.errors.UndefinedTable: relation «product_product_res_config_settings_rel» does not exist

My code:

from odoo import api, fields, models
from ast import literal_evalclass SchoolSettings(models.TransientModel):
    _inherit = 'res.config.settings'
    product_default = fields.Many2many('product.product', string='Default Product')
    @api.model
    def get_values(self):
        res = super(SchoolSettings, self).get_values()
        if self.env['ir.config_parameter'].sudo().get_param('school.school_default_teacher'):
            product_default = self.env['ir.config_parameter'].sudo().get_param('school.product_default')
            res.update(
                product_default=[(6, 0, literal_eval(product_default))]
            )
        return res
    def set_values(self):
        super(SchoolSettings, self).set_values()
        self.env['ir.config_parameter'].set_param('school.product_default', self.product_default.ids)

Xml:
<div class="content-group">
    <label string="Default Product" for="product_default"/>
    <field name="product_default" widget="many2many_tags"/>
</div>



Please help, thanks.

3Answers

I’ve found the answer based on «Kiran K» answer:

from odoo import api, fields, models
from ast import literal_evalclass SchoolSettings(models.TransientModel):
    _inherit = 'res.config.settings'
    # many2many will give you multiselect options, when many2one only give you select option
    # to use many2many, we must declare the middle table to connect 2 tables together.
    # in this example, i create a new table named 'config_product_rel'
    # with 2 column connect 2 table that is 'id' for the 'ir_config_parameter' table
    # and 'product_id' for 'product_product' table
    product_default_many2many = fields.Many2many('product.product', 'config_product_rel', 'id', 'product_id',
                  'Default Product Many2many')
    @api.model
    def get_values(self):
        res = super(SchoolSettings, self).get_values()
        # set values for many2many field
        if self.env['ir.config_parameter'].sudo().get_param('school.product_default_many2many'):
            product_default_many2many = self.env['ir.config_parameter'].sudo().get_param('school.product_default_many2many')
            res['product_default_many2many'] = [(6, 0, literal_eval(product_default_many2many))]
        return res
    def set_values(self):
        # get values for many2many field
        self.env['ir.config_parameter'].set_param('school.product_default_many2many', self.product_default_many2many.ids)

Thanks.

class ResCompany(models.Model):
    _inherit = 'res.company'    def _active_products(self):
        return self.env['product.product'].search([]).ids
    product_ids = fields.Many2many('product.product', 'company_product_rel', 'company_id', 'product_id',
                  'Default Product',default=_active_products)
class ResConfigSettings(models.TransientModel):
    _inherit = 'res.config.settings'
    product_ids = fields.Many2many(related='company_id.product_ids', relation='product.product', readonly=False)

Hope it helps,
Kiran K

Lo definí así y funciono.

classProductWizard(models.TransientModel):

_name = «product.wizard»

_description = «See all Products and warehause»

pricelist_ids = fields.Many2many(comodel_name=‘product.pricelist’, string=‘Pricelist’, required=True)

Источник

Я использую Travis для CI / CD как часть моего приложения Django с базой данных postgresql. (Джанго 2.1.4)

Сборка постоянно завершается неудачей на Travis, как только запускаются тесты. Я получаю эту ошибку:

psycopg2.errors.UndefinedTable: relation "auth_user" does not exist

Я пробовал: makemigrations, migrate auth, migrate myapp, migrate --run-syncdb. Все из которых терпят неудачу с той же ошибкой.

Тесты выполняются локально с базой данных sqlite3, а также в похожей на prod среде heroku с базой данных postgresql.

.travis.yml

...
before script:
-psql -c 'create database travis_ci_test;' -U postgres
services:
-postgresql
script:
-yes | python3 manage.py makemigrations
-python3 manage.py migrate auth
-python3 manage.py migrate --run-syncdb
-python3 manage.py tests test/unit_tests

Settings.py

...
DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql_psycopg2',
        'NAME': 'travis_ci_test',
        'USER': 'postgres',
        'PASSWORD': '',
        'HOST': 'localhost',
        }
    }

...
INSTALLED_APPS = [...
        'django.contrib.auth',
        ]

Вот результат неудачной сборки на Travis. ‘миграция аутентификации’ выполнена успешно (я думаю, что это ключевая строка для auth_user: Applying auth.0001_initial... OK)

0.22s$ psql -c 'create database travis_ci_test;' -U postgres
CREATE DATABASE
1.50s$ yes | python3 manage.py makemigrations
TEST_ENV...
AWS_INTEGRATION...
Databases ... {'ENGINE': 'django.db.backends.postgresql_psycopg2', 'NAME': 'travis_ci_test', 'USER': 'postgres', 'PASSWORD': '', 'HOST': 'localhost'}
Installed Apps ... ['django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'races.apps.RacesConfig', 'storages']
No changes detected
The command "yes | python3 manage.py makemigrations" exited with 0.
1.68s$ python3 manage.py migrate auth
TEST_ENV...
AWS_INTEGRATION...
Databases ... {'ENGINE': 'django.db.backends.postgresql_psycopg2', 'NAME': 'travis_ci_test', 'USER': 'postgres', 'PASSWORD': '', 'HOST': 'localhost'}
Installed Apps ... ['django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'races.apps.RacesConfig', 'storages']
Operations to perform:
  Apply all migrations: auth
Running migrations:
  Applying contenttypes.0001_initial... OK
  Applying auth.0001_initial... 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
The command "python3 manage.py migrate auth" exited with 0.
1.57s$ python3 manage.py migrate --run-syncdb
TEST_ENV...
AWS_INTEGRATION...
Databases ... {'ENGINE': 'django.db.backends.postgresql_psycopg2', 'NAME': 'travis_ci_test', 'USER': 'postgres', 'PASSWORD': '', 'HOST': 'localhost'}
Installed Apps ... ['django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'myapp.apps.MyAppConfig', 'storages']
Operations to perform:
  Synchronize unmigrated apps: messages, myapp, staticfiles, storages
  Apply all migrations: admin, auth, contenttypes, sessions
Synchronizing apps without migrations:
  Creating tables...
    Creating table myapp_model1
    Creating table myapp_model2
    Creating table myapp_model3
    Creating table myapp_model4
    Creating table myapp_model5
    Running deferred SQL...
Running migrations:
  Applying admin.0001_initial... OK
  Applying admin.0002_logentry_remove_auto_add... OK
  Applying admin.0003_logentry_add_action_flag_choices... OK
  Applying sessions.0001_initial... OK
The command "python3 manage.py migrate --run-syncdb" exited with 0.
1.40s$ python3 manage.py test tests/unit_tests
TEST_ENV...
AWS_INTEGRATION...
Databases ... {'ENGINE': 'django.db.backends.postgresql_psycopg2', 'NAME': 'travis_ci_test', 'USER': 'postgres', 'PASSWORD': '', 'HOST': 'localhost'}
Installed Apps ... ['django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'app.apps.MyAppConfig', 'storages']
Creating test database for alias 'default'...
Traceback (most recent call last):
  File "/home/travis/virtualenv/python3.6.7/lib/python3.6/site-packages/django/db/backends/utils.py", line 85, in _execute
    return self.cursor.execute(sql, params)
psycopg2.errors.UndefinedTable: relation "auth_user" does not exist
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
  File "manage.py", line 10, in <module>
    execute_from_command_line(sys.argv)
  File "/home/travis/virtualenv/python3.6.7/lib/python3.6/site-packages/django/core/management/__init__.py", line 381, in execute_from_command_line
    utility.execute()
  File "/home/travis/virtualenv/python3.6.7/lib/python3.6/site-packages/django/core/management/__init__.py", line 375, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/home/travis/virtualenv/python3.6.7/lib/python3.6/site-packages/django/core/management/commands/test.py", line 26, in run_from_argv
    super().run_from_argv(argv)
  File "/home/travis/virtualenv/python3.6.7/lib/python3.6/site-packages/django/core/management/base.py", line 316, in run_from_argv
    self.execute(*args, **cmd_options)
  File "/home/travis/virtualenv/python3.6.7/lib/python3.6/site-packages/django/core/management/base.py", line 353, in execute
    output = self.handle(*args, **options)
  File "/home/travis/virtualenv/python3.6.7/lib/python3.6/site-packages/django/core/management/commands/test.py", line 56, in handle
    failures = test_runner.run_tests(test_labels)
  File "/home/travis/virtualenv/python3.6.7/lib/python3.6/site-packages/django/test/runner.py", line 604, in run_tests
    old_config = self.setup_databases()
  File "/home/travis/virtualenv/python3.6.7/lib/python3.6/site-packages/django/test/runner.py", line 551, in setup_databases
    self.parallel, **kwargs
  File "/home/travis/virtualenv/python3.6.7/lib/python3.6/site-packages/django/test/utils.py", line 174, in setup_databases
    serialize=connection.settings_dict.get('TEST', {}).get('SERIALIZE', True),
  File "/home/travis/virtualenv/python3.6.7/lib/python3.6/site-packages/django/db/backends/base/creation.py", line 68, in create_test_db
    run_syncdb=True,
  File "/home/travis/virtualenv/python3.6.7/lib/python3.6/site-packages/django/core/management/__init__.py", line 148, in call_command
    return command.execute(*args, **defaults)
  File "/home/travis/virtualenv/python3.6.7/lib/python3.6/site-packages/django/core/management/base.py", line 353, in execute
    output = self.handle(*args, **options)
  File "/home/travis/virtualenv/python3.6.7/lib/python3.6/site-packages/django/core/management/base.py", line 83, in wrapped
    res = handle_func(*args, **kwargs)
  File "/home/travis/virtualenv/python3.6.7/lib/python3.6/site-packages/django/core/management/commands/migrate.py", line 172, in handle
    self.sync_apps(connection, executor.loader.unmigrated_apps)
  File "/home/travis/virtualenv/python3.6.7/lib/python3.6/site-packages/django/core/management/commands/migrate.py", line 310, in sync_apps
    self.stdout.write("    Running deferred SQL...n")
  File "/home/travis/virtualenv/python3.6.7/lib/python3.6/site-packages/django/db/backends/base/schema.py", line 106, in __exit__
    self.execute(sql)
  File "/home/travis/virtualenv/python3.6.7/lib/python3.6/site-packages/django/db/backends/base/schema.py", line 133, in execute
    cursor.execute(sql, params)
  File "/home/travis/virtualenv/python3.6.7/lib/python3.6/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/travis/virtualenv/python3.6.7/lib/python3.6/site-packages/django/db/backends/utils.py", line 77, in _execute_with_wrappers
    return executor(sql, params, many, context)
  File "/home/travis/virtualenv/python3.6.7/lib/python3.6/site-packages/django/db/backends/utils.py", line 85, in _execute
    return self.cursor.execute(sql, params)
  File "/home/travis/virtualenv/python3.6.7/lib/python3.6/site-packages/django/db/utils.py", line 89, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
  File "/home/travis/virtualenv/python3.6.7/lib/python3.6/site-packages/django/db/backends/utils.py", line 85, in _execute
    return self.cursor.execute(sql, params)
django.db.utils.ProgrammingError: relation "auth_user" does not exist
The command "python3 manage.py test tests/unit_tests" exited with 1.

Источник

Psycopg2 errors undefinedtable ошибка отношение не существует

Technical details:

Issue

Solution

SQLSTATE exception classes¶

3Answers

А вот еще интересные материалы: