sqlmapproject/sqlmap · error · SqlmapDataException

boundary limits (%d,%d) are too large. Please rerun with swi

Error message

boundary limits (%d,%d) are too large. Please rerun with switch '--fresh-queries'

What it means

Error "boundary limits (%d,%d) are too large. Please rerun with switch '--fresh-queries'" thrown in sqlmapproject/sqlmap.

Source

Thrown at lib/techniques/error/use.py:383

                else:
                    value = []  # for empty tables
                return value

            if isNumPosStrValue(count) and int(count) > 1:
                # NOTE: the ORDER BY clause is deliberately NOT stripped here. This path fetches each column
                # of a row in a separate LIMIT/OFFSET query, so dropping ORDER BY would let the per-column
                # offsets resolve to different physical rows and silently misalign cells across the row. Huge
                # tables are handled cheaply and safely by keyset (seek) pagination (see plugins/generic/entries.py).
                numThreads = min(conf.threads, (stopLimit - startLimit))

                threadData = getCurrentThreadData()

                try:
                    threadData.shared.limits = iter(xrange(startLimit, stopLimit))
                except OverflowError:
                    errMsg = "boundary limits (%d,%d) are too large. Please rerun " % (startLimit, stopLimit)
                    errMsg += "with switch '--fresh-queries'"
                    raise SqlmapDataException(errMsg)

                threadData.shared.value = BigArray()
                threadData.shared.buffered = []
                threadData.shared.counter = 0
                threadData.shared.lastFlushed = startLimit - 1
                threadData.shared.showEta = conf.eta and (stopLimit - startLimit) > 1

                if threadData.shared.showEta:
                    threadData.shared.progress = ProgressBar(maxValue=(stopLimit - startLimit))

                if kb.dumpTable and (len(expressionFieldsList) < (stopLimit - startLimit) > CHECK_ZERO_COLUMNS_THRESHOLD):
                    for field in expressionFieldsList:
                        if _oneShotErrorUse("SELECT COUNT(%s) FROM %s" % (field, kb.dumpTable)) == '0':
                            emptyFields.append(field)
                            debugMsg = "column '%s' of table '%s' will not be " % (field, kb.dumpTable)
                            debugMsg += "dumped as it appears to be empty"
                            logger.debug(debugMsg)

View on GitHub (pinned to 0a35b20e39)

When it happens

Trigger: Thrown at lib/techniques/error/use.py:383 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/2475c23b48bc68f7. Report an issue: GitHub.