sqlmapproject/sqlmap · error · IntegrityError

duplicate key/row, constraint, or foreign key violation

Error message

duplicate key/row, constraint, or foreign key violation

What it means

Error "duplicate key/row, constraint, or foreign key violation" thrown in sqlmapproject/sqlmap.

Source

Thrown at extra/dbwire/sybase.py:287

        length = _u8(data, off); off += 1
        if not length:
            return None, off
        raw, off = data[off:off + length], off + length
    return _decode_value(col, raw, codec), off

def _eed(data, off, codec):
    # EED: number(4) state(1) class(1) sqlstate, status(1) transtate(2) message, server, procedure, line
    number = _i32(data, off)
    severity = _u8(data, off + 5)
    pos = off + 6
    pos += 1 + _u8(data, pos)                           # SQLSTATE
    pos += 1 + 2                                        # status + transaction state
    length = _u16(data, pos); pos += 2
    return number, severity, data[pos:pos + length].decode(codec, "replace").strip()

def _raise_server_error(number, message):
    if number in (2601, 2615, 2627, 1105, 546, 547):    # duplicate key/row, constraint, foreign key
        raise IntegrityError(message)
    if number in (247, 249, 257, 260, 264, 512, 8115):  # conversion, overflow, arithmetic
        raise DataError(message)
    raise ProgrammingError(message)

class Cursor(object):
    def __init__(self, connection):
        self.connection = connection
        self.description = None
        self.rowcount = -1
        self._rows = []
        self._pos = 0

    def execute(self, query, params=None):
        if params is not None:
            raise NotSupportedError("parameter binding is not supported; pass a fully-formed query string")
        self.description, self.rowcount, self._rows, self._pos = None, -1, [], 0
        self.description, self._rows, affected = self.connection._query(query)
        self.rowcount = len(self._rows) if self.description is not None else (affected if affected is not None else -1)

View on GitHub (pinned to 0a35b20e39)

When it happens

Trigger: Thrown at extra/dbwire/sybase.py:287 when the library encounters an invalid state.

Common situations: See trigger scenarios.

AI-assisted analysis of sqlmapproject/sqlmap@0a35b20e39 (2026-08-26). Data as JSON: /api/errors/e441e3d6f8af57da. Report an issue: GitHub.