First entries during last validation:

And here are the last 3 lines of the thousands of orphan entries:

I don't see other type of error.

I'm trying to figure out why there are so many orphaned pages.

I use the python firebird driver to manipulate the database, and often I do this (pseudo code):

cursor = connection.cursor()

for item in list:

    try:

        cursor.execute(sql_statement, (item,))

    except fdb.DatabaseError:

        log("Exception: duplicate found in database for item")

        continue

    finally:    

        con.commit()

Here, I only commit after multiple execute statements, some of which could have raised an exception in the Firebird server. That could be the reason maybe? Perhaps I do need to commit after an exception has been raised in firebird, otherwise that generates an orphan page?

I'm a bit puzzled by the other errors and what could have caused them. Or perhaps I'm no closing my connections to the database consistently which caused some problems.

Anyway, I'm going a bit off topic here.