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

sql connection lost #162

Closed
spirillen opened this issue Dec 27, 2020 · 5 comments
Closed

sql connection lost #162

spirillen opened this issue Dec 27, 2020 · 5 comments
Assignees
Labels
Milestone

Comments

@spirillen
Copy link
Contributor

Is your feature request related to a problem? Please describe.
Append a reconnect/retry to the sql

Describe the solution you'd like

bigsexvideos.net                                                                                     ACTIVE      WHOIS      03-oct-2021       Unknown    AVAILABILITY 
/home/spirillen/miniconda/envs/pyfunceble4/lib/python3.9/site-packages/sqlalchemy/engine/default.py:409: SAWarning: Exception attempting to detect unicode returns: OperationalError("(pymysql.err.OperationalError) (2013, 'Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)')")
  util.warn

With this we can minimize lost results, in case the DB is to busy or what have made it temponary unavailble, it could also be as simple as a security update of the DB, reboot etc.

In addition we should add a short wait like x seconds until test continues

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

@funilrys funilrys self-assigned this Dec 27, 2020
@funilrys funilrys added the bug label Dec 27, 2020
@funilrys funilrys added this to the 4.0.0 milestone Dec 27, 2020
funilrys added a commit that referenced this issue Dec 27, 2020
This patch fixes #162.

Contributors:
  * @spirillen
@spirillen
Copy link
Contributor Author

spirillen commented Dec 28, 2020

TEST FAILED

./pyfunceble4.sh https://gitlab.com/ZeroDot1/CoinBlockerLists/-/raw/master/hosts
        I'm your hungry cheese missing a piece...
        Are you ready to go hunting the red pills
        so we can hunt down evil ghosts

        Are you ready to start?

        loading kacman...
Enter output directory for test results: /tmp/pyfunceble4/1156
Which version of PyFunceble would you like to use?: pyfunceble4: pyfunceble4
Enter any custom test string: --share-logs -dbr 6 -ex --dns 192.168.1.104:53 -w 6 -a --database-type mariadb --no-files --local
Would you like to use your default pyfunceble enviroment
  /$HOME/miniconda/envs/pyfunceble4?: [Y/n] Y
Collecting package metadata (current_repodata.json): ...working... done
Solving environment: ...working... done

# All requested packages already installed.

pyfunceble 4.0.0a38.dev (Blue Duckling)
uhb-whitelist 3.25.0
01.easyx.cc                                                                                          INACTIVE    STDLOOKUP  Unknown           Unknown    AVAILABILITY 
Exception during reset or similar
Traceback (most recent call last):
  File "/$HOME/.local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 749, in _rollback_impl
    self.engine.dialect.do_rollback(self.connection)
  File "/$HOME/.local/lib/python3.9/site-packages/sqlalchemy/dialects/mysql/base.py", line 2496, in do_rollback
    dbapi_connection.rollback()
  File "/$HOME/.local/lib/python3.9/site-packages/pymysql/connections.py", line 431, in rollback
    self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
  File "/$HOME/.local/lib/python3.9/site-packages/pymysql/connections.py", line 742, in _execute_command
    raise err.InterfaceError(0, '')
pymysql.err.InterfaceError: (0, '')

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

Traceback (most recent call last):
  File "/$HOME/.local/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 697, in _finalize_fairy
    fairy._reset(pool)
  File "/$HOME/.local/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 891, in _reset
    self._reset_agent.rollback()
  File "/$HOME/.local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1751, in rollback
    self._do_rollback()
  File "/$HOME/.local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1789, in _do_rollback
    self.connection._rollback_impl()
  File "/$HOME/.local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 751, in _rollback_impl
    self._handle_dbapi_exception(e, None, None, None, None)
  File "/$HOME/.local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception
    util.raise_(
  File "/$HOME/.local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
    raise exception
  File "/$HOME/.local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 749, in _rollback_impl
    self.engine.dialect.do_rollback(self.connection)
  File "/$HOME/.local/lib/python3.9/site-packages/sqlalchemy/dialects/mysql/base.py", line 2496, in do_rollback
    dbapi_connection.rollback()
  File "/$HOME/.local/lib/python3.9/site-packages/pymysql/connections.py", line 431, in rollback
    self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
  File "/$HOME/.local/lib/python3.9/site-packages/pymysql/connections.py", line 742, in _execute_command
    raise err.InterfaceError(0, '')
sqlalchemy.exc.InterfaceError: (pymysql.err.InterfaceError) (0, '')
(Background on this error at: http://sqlalche.me/e/13/rvf5)
Exception during reset or similar
Traceback (most recent call last):
  File "/$HOME/.local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 749, in _rollback_impl
    self.engine.dialect.do_rollback(self.connection)
  File "/$HOME/.local/lib/python3.9/site-packages/sqlalchemy/dialects/mysql/base.py", line 2496, in do_rollback
    dbapi_connection.rollback()
  File "/$HOME/.local/lib/python3.9/site-packages/pymysql/connections.py", line 431, in rollback
    self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
  File "/$HOME/.local/lib/python3.9/site-packages/pymysql/connections.py", line 742, in _execute_command
    raise err.InterfaceError(0, '')
pymysql.err.InterfaceError: (0, '')

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

Traceback (most recent call last):
  File "/$HOME/.local/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 697, in _finalize_fairy
    fairy._reset(pool)
  File "/$HOME/.local/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 891, in _reset
    self._reset_agent.rollback()
  File "/$HOME/.local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1751, in rollback
    self._do_rollback()
  File "/$HOME/.local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1789, in _do_rollback
    self.connection._rollback_impl()
  File "/$HOME/.local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 751, in _rollback_impl
    self._handle_dbapi_exception(e, None, None, None, None)
  File "/$HOME/.local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception
    util.raise_(
  File "/$HOME/.local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
    raise exception
  File "/$HOME/.local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 749, in _rollback_impl
    self.engine.dialect.do_rollback(self.connection)
  File "/$HOME/.local/lib/python3.9/site-packages/sqlalchemy/dialects/mysql/base.py", line 2496, in do_rollback
    dbapi_connection.rollback()
  File "/$HOME/.local/lib/python3.9/site-packages/pymysql/connections.py", line 431, in rollback
    self._execute_command(COMMAND.COM_QUERY, "ROLLBACK")
  File "/$HOME/.local/lib/python3.9/site-packages/pymysql/connections.py", line 742, in _execute_command
    raise err.InterfaceError(0, '')
sqlalchemy.exc.InterfaceError: (pymysql.err.InterfaceError) (0, '')
(Background on this error at: http://sqlalche.me/e/13/rvf5)
01.node.hiveon.net

https://asciinema.org/a/fPZJ4ALWcwxFAg24EBS4k2cwf Skip to ~512 minutes

asciicast

@spirillen
Copy link
Contributor Author

😭

Very looong log output
Process pyfunceble_tester_worker_3:
Traceback (most recent call last):
  File "$HOME/miniconda/envs/pyfunceble4/lib/python3.9/multiprocessing/process.py", line 315, in _bootstrap
    self.run()
  File "$HOME/miniconda/envs/pyfunceble4/lib/python3.9/site-packages/PyFunceble/cli/processes/workers/base.py", line 370, in run
    raise exception
  File "$HOME/miniconda/envs/pyfunceble4/lib/python3.9/site-packages/PyFunceble/cli/processes/workers/base.py", line 354, in run
    result = self.target(consumed)
  File "$HOME/miniconda/envs/pyfunceble4/lib/python3.9/site-packages/PyFunceble/cli/processes/workers/tester.py", line 254, in target
    testing_object.set_subject(test_dataset["idna_subject"])
  File "$HOME/miniconda/envs/pyfunceble4/lib/python3.9/site-packages/PyFunceble/checker/base.py", line 198, in set_subject
    self.subject = value
  File "$HOME/miniconda/envs/pyfunceble4/lib/python3.9/site-packages/PyFunceble/checker/base.py", line 104, in wrapper
    self.subject_propagator()
  File "$HOME/miniconda/envs/pyfunceble4/lib/python3.9/site-packages/PyFunceble/checker/availability/base.py", line 422, in subject_propagator
    self.dns_query_tool.set_subject(self.idna_subject)
  File "$HOME/miniconda/envs/pyfunceble4/lib/python3.9/site-packages/PyFunceble/query/dns/query_tool.py", line 287, in set_subject
    self.subject = value
  File "$HOME/miniconda/envs/pyfunceble4/lib/python3.9/site-packages/PyFunceble/query/dns/query_tool.py", line 137, in wrapper
    self.dns_name = self.get_dns_name_from_subject_and_query_type()
  File "$HOME/miniconda/envs/pyfunceble4/lib/python3.9/site-packages/PyFunceble/query/dns/query_tool.py", line 211, in wrapper
    return func(self, *args, **kwargs)  # pylint: disable=not-callable
  File "$HOME/miniconda/envs/pyfunceble4/lib/python3.9/site-packages/PyFunceble/query/dns/query_tool.py", line 245, in get_dns_name_from_subject_and_query_type
    return dns.name.from_text(self.subject)
  File "$HOME/.local/lib/python3.9/site-packages/dns/name.py", line 964, in from_text
    return Name(labels)
  File "$HOME/.local/lib/python3.9/site-packages/dns/name.py", line 324, in __init__
    _validate_labels(self.labels)
  File "$HOME/.local/lib/python3.9/site-packages/dns/name.py", line 284, in _validate_labels
    raise LabelTooLong
dns.name.LabelTooLong: A DNS label is > 63 octets long.
1                                                                                                    ACTIVE      NETINFO    Unknown           Unknown    AVAILABILITY 
Lisens                                                                                               INVALID     SYNTAX     Unknown           Unknown    AVAILABILITY 
day                                                                                                  INVALID     SYNTAX     Unknown           Unknown    AVAILABILITY 
/                                                                                                    INVALID     SYNTAX     Unknown           Unknown    AVAILABILITY 
Licence:                                                                                             INVALID     SYNTAX     Unknown           Unknown    AVAILABILITY 
https://github.com/DandelionSprout/adfilt/blob/master/LICENSE.md                                     INACTIVE    STDLOOKUP  Unknown           200        AVAILABILITY 
^C
Thank you for using PyFunceble!
Do you have a feedback, an issue or an improvement idea? Let us know on GitHub!
Process pyfunceble_tester_worker_4:
Process pyfunceble_tester_worker_5:
Process pyfunceble_producer_worker_1:
Process pyfunceble_tester_worker_2:
Process pyfunceble_tester_worker_6:
Process pyfunceble_tester_worker_1:
Traceback (most recent call last):
Traceback (most recent call last):
Traceback (most recent call last):
  File "$HOME/miniconda/envs/pyfunceble4/lib/python3.9/multiprocessing/process.py", line 315, in _bootstrap
    self.run()
  File "$HOME/miniconda/envs/pyfunceble4/lib/python3.9/multiprocessing/process.py", line 315, in _bootstrap
    self.run()
  File "$HOME/miniconda/envs/pyfunceble4/lib/python3.9/multiprocessing/process.py", line 315, in _bootstrap
    self.run()
  File "$HOME/miniconda/envs/pyfunceble4/lib/python3.9/site-packages/PyFunceble/cli/processes/workers/base.py", line 354, in run
    result = self.target(consumed)
  File "$HOME/miniconda/envs/pyfunceble4/lib/python3.9/site-packages/PyFunceble/cli/processes/workers/base.py", line 354, in run
    result = self.target(consumed)
  File "$HOME/miniconda/envs/pyfunceble4/lib/python3.9/site-packages/PyFunceble/cli/processes/workers/base.py", line 354, in run
    result = self.target(consumed)
  File "$HOME/miniconda/envs/pyfunceble4/lib/python3.9/site-packages/PyFunceble/cli/processes/workers/tester.py", line 210, in target
    if self.continue_dataset.exists(test_dataset):
  File "$HOME/miniconda/envs/pyfunceble4/lib/python3.9/site-packages/PyFunceble/cli/processes/workers/tester.py", line 210, in target
    if self.continue_dataset.exists(test_dataset):
  File "$HOME/miniconda/envs/pyfunceble4/lib/python3.9/site-packages/PyFunceble/cli/processes/workers/tester.py", line 210, in target
    if self.continue_dataset.exists(test_dataset):
  File "$HOME/miniconda/envs/pyfunceble4/lib/python3.9/site-packages/PyFunceble/dataset/db_base.py", line 106, in wrapper
    return func(self, *args, **kwargs)  # pylint: disable=not-callable
  File "$HOME/miniconda/envs/pyfunceble4/lib/python3.9/site-packages/PyFunceble/dataset/db_base.py", line 106, in wrapper
    return func(self, *args, **kwargs)  # pylint: disable=not-callable
  File "$HOME/miniconda/envs/pyfunceble4/lib/python3.9/site-packages/PyFunceble/dataset/db_base.py", line 106, in wrapper
    return func(self, *args, **kwargs)  # pylint: disable=not-callable
  File "$HOME/miniconda/envs/pyfunceble4/lib/python3.9/site-packages/PyFunceble/dataset/mariadb_base.py", line 115, in wrapper
    return func(self, *args, **kwargs)  # pylint: disable=not-callable
  File "$HOME/miniconda/envs/pyfunceble4/lib/python3.9/site-packages/PyFunceble/dataset/mariadb_base.py", line 115, in wrapper
    return func(self, *args, **kwargs)  # pylint: disable=not-callable
  File "$HOME/miniconda/envs/pyfunceble4/lib/python3.9/site-packages/PyFunceble/dataset/mariadb_base.py", line 267, in exists
    return result.first() is not None
  File "$HOME/miniconda/envs/pyfunceble4/lib/python3.9/site-packages/PyFunceble/dataset/mariadb_base.py", line 115, in wrapper
    return func(self, *args, **kwargs)  # pylint: disable=not-callable
  File "$HOME/miniconda/envs/pyfunceble4/lib/python3.9/site-packages/PyFunceble/dataset/mariadb_base.py", line 267, in exists
    return result.first() is not None
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3429, in first
    ret = list(self[0:1])
  File "$HOME/miniconda/envs/pyfunceble4/lib/python3.9/site-packages/PyFunceble/dataset/mariadb_base.py", line 267, in exists
    return result.first() is not None
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3429, in first
    ret = list(self[0:1])
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3203, in __getitem__
    return list(res)
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3429, in first
    ret = list(self[0:1])
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3203, in __getitem__
    return list(res)
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3535, in __iter__
    return self._execute_and_instances(context)
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3203, in __getitem__
    return list(res)
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3535, in __iter__
    return self._execute_and_instances(context)
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3556, in _execute_and_instances
    conn = self._get_bind_args(
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3535, in __iter__
    return self._execute_and_instances(context)
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3560, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3571, in _get_bind_args
    return fn(
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3560, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1011, in execute
    return meth(self, multiparams, params)
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3550, in _connection_from_session
    conn = self.session.connection(**kw)
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1011, in execute
    return meth(self, multiparams, params)
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1138, in connection
    return self._connection_for_bind(
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement
    ret = self._execute_context(
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1146, in _connection_for_bind
    return self.transaction._connection_for_bind(
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement
    ret = self._execute_context(
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context
    self._handle_dbapi_exception(
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 433, in _connection_for_bind
    conn = bind._contextual_connect()
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context
    self._handle_dbapi_exception(
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1514, in _handle_dbapi_exception
    util.raise_(exc_info[1], with_traceback=exc_info[2])
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2302, in _contextual_connect
    self._wrap_pool_connect(self.pool.connect, None),
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1514, in _handle_dbapi_exception
    util.raise_(exc_info[1], with_traceback=exc_info[2])
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
    raise exception
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2336, in _wrap_pool_connect
    return fn()
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
    raise exception
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
    self.dialect.do_execute(
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 364, in connect
    return _ConnectionFairy._checkout(self)
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
    self.dialect.do_execute(
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute
    cursor.execute(statement, parameters)
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 778, in _checkout
    fairy = _ConnectionRecord.checkout(pool)
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute
    cursor.execute(statement, parameters)
  File "$HOME/.local/lib/python3.9/site-packages/pymysql/cursors.py", line 163, in execute
    result = self._query(query)
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 495, in checkout
    rec = pool._do_get()
  File "$HOME/.local/lib/python3.9/site-packages/pymysql/cursors.py", line 163, in execute
    result = self._query(query)
  File "$HOME/.local/lib/python3.9/site-packages/pymysql/cursors.py", line 321, in _query
    conn.query(q)
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/pool/impl.py", line 241, in _do_get
    return self._create_connection()
  File "$HOME/.local/lib/python3.9/site-packages/pymysql/cursors.py", line 321, in _query
    conn.query(q)
  File "$HOME/.local/lib/python3.9/site-packages/pymysql/connections.py", line 505, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 309, in _create_connection
    return _ConnectionRecord(self)
  File "$HOME/.local/lib/python3.9/site-packages/pymysql/connections.py", line 505, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "$HOME/.local/lib/python3.9/site-packages/pymysql/connections.py", line 724, in _read_query_result
    result.read()
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 440, in __init__
    self.__connect(first_connect_check=True)
  File "$HOME/.local/lib/python3.9/site-packages/pymysql/connections.py", line 724, in _read_query_result
    result.read()
  File "$HOME/.local/lib/python3.9/site-packages/pymysql/connections.py", line 1069, in read
    first_packet = self.connection._read_packet()
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/pool/base.py", line 668, in __connect
    pool.dispatch.connect(self.connection, self)
  File "$HOME/.local/lib/python3.9/site-packages/pymysql/connections.py", line 1069, in read
    first_packet = self.connection._read_packet()
  File "$HOME/.local/lib/python3.9/site-packages/pymysql/connections.py", line 646, in _read_packet
    packet_header = self._read_bytes(4)
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/event/attr.py", line 322, in __call__
    fn(*args, **kw)
  File "$HOME/.local/lib/python3.9/site-packages/pymysql/connections.py", line 646, in _read_packet
    packet_header = self._read_bytes(4)
  File "$HOME/.local/lib/python3.9/site-packages/pymysql/connections.py", line 683, in _read_bytes
    data = self._rfile.read(num_bytes)
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/engine/strategies.py", line 189, in on_connect
    do_on_connect(conn)
  File "$HOME/.local/lib/python3.9/site-packages/pymysql/connections.py", line 683, in _read_bytes
    data = self._rfile.read(num_bytes)
  File "$HOME/miniconda/envs/pyfunceble4/lib/python3.9/socket.py", line 704, in readinto
    return self._sock.recv_into(b)
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/dialects/mysql/mysqldb.py", line 131, in on_connect
    cursor.execute("SET NAMES %s" % charset_name)
  File "$HOME/miniconda/envs/pyfunceble4/lib/python3.9/socket.py", line 704, in readinto
    return self._sock.recv_into(b)
  File "$HOME/.local/lib/python3.9/site-packages/pymysql/cursors.py", line 163, in execute
    result = self._query(query)
KeyboardInterrupt
  File "$HOME/.local/lib/python3.9/site-packages/pymysql/cursors.py", line 321, in _query
    conn.query(q)
KeyboardInterrupt
  File "$HOME/.local/lib/python3.9/site-packages/pymysql/connections.py", line 505, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "$HOME/.local/lib/python3.9/site-packages/pymysql/connections.py", line 724, in _read_query_result
    result.read()
  File "$HOME/.local/lib/python3.9/site-packages/pymysql/connections.py", line 1069, in read
    first_packet = self.connection._read_packet()
  File "$HOME/.local/lib/python3.9/site-packages/pymysql/connections.py", line 646, in _read_packet
    packet_header = self._read_bytes(4)
  File "$HOME/.local/lib/python3.9/site-packages/pymysql/connections.py", line 683, in _read_bytes
    data = self._rfile.read(num_bytes)
  File "$HOME/miniconda/envs/pyfunceble4/lib/python3.9/socket.py", line 704, in readinto
    return self._sock.recv_into(b)
KeyboardInterrupt
Traceback (most recent call last):
  File "$HOME/miniconda/envs/pyfunceble4/lib/python3.9/multiprocessing/process.py", line 315, in _bootstrap
    self.run()
  File "$HOME/miniconda/envs/pyfunceble4/lib/python3.9/site-packages/PyFunceble/cli/processes/workers/base.py", line 354, in run
    result = self.target(consumed)
  File "$HOME/miniconda/envs/pyfunceble4/lib/python3.9/site-packages/PyFunceble/cli/processes/workers/producer.py", line 381, in target
    self.run_inactive_backup(test_dataset, test_result)
  File "$HOME/miniconda/envs/pyfunceble4/lib/python3.9/site-packages/PyFunceble/cli/processes/workers/producer.py", line 245, in run_inactive_backup
    self.inactive_dataset.update(dataset)
  File "$HOME/miniconda/envs/pyfunceble4/lib/python3.9/site-packages/PyFunceble/dataset/db_base.py", line 106, in wrapper
    return func(self, *args, **kwargs)  # pylint: disable=not-callable
  File "$HOME/miniconda/envs/pyfunceble4/lib/python3.9/site-packages/PyFunceble/dataset/mariadb_base.py", line 198, in update
    self.add(row)
  File "$HOME/miniconda/envs/pyfunceble4/lib/python3.9/site-packages/PyFunceble/dataset/db_base.py", line 106, in wrapper
    return func(self, *args, **kwargs)  # pylint: disable=not-callable
  File "$HOME/miniconda/envs/pyfunceble4/lib/python3.9/site-packages/PyFunceble/dataset/mariadb_base.py", line 115, in wrapper
    return func(self, *args, **kwargs)  # pylint: disable=not-callable
  File "$HOME/miniconda/envs/pyfunceble4/lib/python3.9/site-packages/PyFunceble/dataset/mariadb_base.py", line 330, in add
    db_session.commit()
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1042, in commit
    self.transaction.commit()
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 504, in commit
    self._prepare_impl()
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 483, in _prepare_impl
    self.session.flush()
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2536, in flush
    self._flush(objects)
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2678, in _flush
    transaction.rollback(_capture_exception=True)
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
    compat.raise_(
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
    raise exception
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2638, in _flush
    flush_context.execute()
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 422, in execute
    rec.execute(self)
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 586, in execute
    persistence.save_obj(
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 239, in save_obj
    _emit_insert_statements(
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1135, in _emit_insert_statements
    result = cached_connections[connection].execute(
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1011, in execute
    return meth(self, multiparams, params)
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement
    ret = self._execute_context(
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context
    self._handle_dbapi_exception(
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1514, in _handle_dbapi_exception
    util.raise_(exc_info[1], with_traceback=exc_info[2])
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
    raise exception
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
    self.dialect.do_execute(
  File "$HOME/.local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute
    cursor.execute(statement, parameters)
  File "$HOME/.local/lib/python3.9/site-packages/pymysql/cursors.py", line 163, in execute
    result = self._query(query)
  File "$HOME/.local/lib/python3.9/site-packages/pymysql/cursors.py", line 321, in _query
    conn.query(q)
  File "$HOME/.local/lib/python3.9/site-packages/pymysql/connections.py", line 505, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "$HOME/.local/lib/python3.9/site-packages/pymysql/connections.py", line 724, in _read_query_result
    result.read()
  File "$HOME/.local/lib/python3.9/site-packages/pymysql/connections.py", line 1069, in read
    first_packet = self.connection._read_packet()
  File "$HOME/.local/lib/python3.9/site-packages/pymysql/connections.py", line 646, in _read_packet
    packet_header = self._read_bytes(4)
  File "$HOME/.local/lib/python3.9/site-packages/pymysql/connections.py", line 683, in _read_bytes
    data = self._rfile.read(num_bytes)
  File "$HOME/miniconda/envs/pyfunceble4/lib/python3.9/socket.py", line 704, in readinto
    return self._sock.recv_into(b)
KeyboardInterrupt


        Thank you for feting me with all that junk food, I used to like you too...
^CTraceback (most recent call last):
  File "$HOME/miniconda/envs/pyfunceble4/bin/pyfunceble", line 8, in <module>
    sys.exit(tool())
  File "$HOME/miniconda/envs/pyfunceble4/lib/python3.9/site-packages/PyFunceble/cli/entry_points/pyfunceble/cli.py", line 1037, in tool

@spirillen
Copy link
Contributor Author

spirillen commented Jan 5, 2021

Appendix to the above

I did forget to add the --adblock #161 to the args line....

2 runs before these got stocked with the --local while using our cdb

Stocked example
Subject                                                                                              Status      Source     Expiration Date   HTTP Code  Checker      
---------------------------------------------------------------------------------------------------- ----------- ---------- ----------------- ---------- -------------
0.0.0.0.0.0.0.0.0.x.free.fr                                                                          ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
0.0.0.0.0.0.0.0.0.y.free.fr                                                                          ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
0.0.0.0.0.0.0.0.0z1.free.fr                                                                          ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
0.0.0.0.0.0.0.0.chat.free.fr                                                                         ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
0.0.0.0.001.free.fr                                                                                  ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
0.0.0.0.002.free.fr                                                                                  ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
0.0.0.0.00.free.fr                                                                                   ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
0.0.0.005.free.fr                                                                                    ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
0.0.0.006.free.fr                                                                                    ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
0.0.0.0071.free.fr                                                                                   ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
0.0.0.008.free.fr                                                                                    ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
0.0.0.0.09.free.fr                                                                                   ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
0.0.0.009.free.fr                                                                                    ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
00000nwebcamnow.com                                                                                  ACTIVE      WHOIS      30-jul-2024       Unknown    AVAILABILITY 
0.0.0.0.0.rencontre.free.fr                                                                          ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
0.0000sex.com                                                                                        ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
0000114.com                                                                                          ACTIVE      WHOIS      10-nov-2021       Unknown    AVAILABILITY 
0000.1.free.fr                                                                                       ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000069.com                                                                                           ACTIVE      WHOIS      08-dec-2021       Unknown    AVAILABILITY 
0001011.com                                                                                          ACTIVE      WHOIS      28-may-2021       Unknown    AVAILABILITY 
000111casino.com                                                                                     ACTIVE      WHOIS      29-mar-2021       Unknown    AVAILABILITY 
0001casino.com                                                                                       ACTIVE      WHOIS      26-mar-2022       Unknown    AVAILABILITY 
0.0.04.free.fr                                                                                       ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000-475-843.tumblr.com                                                                               ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
0005.us                                                                                              ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
00069maninstockings.over-blog.com                                                                    ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000adultfantasy.com                                                                                  ACTIVE      WHOIS      08-dec-2021       Unknown    AVAILABILITY 
000ahlalorrainesexe.free.fr                                                                          ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000babes.com                                                                                         ACTIVE      WHOIS      26-may-2021       Unknown    AVAILABILITY 
000boy.free.fr                                                                                       ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000charmex.free.fr                                                                                   ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000cum.com                                                                                           ACTIVE      WHOIS      02-jun-2021       Unknown    AVAILABILITY 
000-coralinne-xxx-sara-calixto.tumblr.com                                                            ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000dn.com                                                                                            ACTIVE      WHOIS      23-jul-2021       Unknown    AVAILABILITY 
000dom.revenuedirect.com                                                                             ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000dvd.com                                                                                           ACTIVE      WHOIS      16-oct-2021       Unknown    AVAILABILITY 
000freeporn.com                                                                                      ACTIVE      WHOIS      28-jan-2021       Unknown    AVAILABILITY 
000free.us                                                                                           ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000gay.free.fr                                                                                       ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000.gaysexe.free.fr                                                                                  ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000girl.tumblr.com                                                                                   ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000h.com                                                                                             ACTIVE      WHOIS      23-feb-2025       Unknown    AVAILABILITY 
000hdusexe.free.fr                                                                                   ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000iblogchix.blogspot.ae                                                                             ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000iblogchix.blogspot.al                                                                             ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000iblogchix.blogspot.am                                                                             ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000iblogchix.blogspot.ba                                                                             ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000iblogchix.blogspot.be                                                                             ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000iblogchix.blogspot.bg                                                                             ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000iblogchix.blogspot.ca                                                                             ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000iblogchix.blogspot.ch                                                                             ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000iblogchix.blogspot.cl                                                                             ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000iblogchix.blogspot.co.at                                                                          ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000iblogchix.blogspot.co.id                                                                          ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000iblogchix.blogspot.co.ke                                                                          ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000iblogchix.blogspot.com                                                                            ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000iblogchix.blogspot.co.il                                                                          ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000iblogchix.blogspot.com.ar                                                                         ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000iblogchix.blogspot.com.au                                                                         ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000iblogchix.blogspot.com.br                                                                         ACTIVE      WHOIS      05-dec-2021       Unknown    AVAILABILITY 
000iblogchix.blogspot.com.co                                                                         ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000iblogchix.blogspot.com.by                                                                         ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000iblogchix.blogspot.com.cy                                                                         ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000iblogchix.blogspot.com.ee                                                                         ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000iblogchix.blogspot.com.eg                                                                         ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000iblogchix.blogspot.com.es                                                                         ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000iblogchix.blogspot.com.mt                                                                         ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000iblogchix.blogspot.com.ng                                                                         ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000iblogchix.blogspot.com.tr                                                                         ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000iblogchix.blogspot.co.nz                                                                          ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000iblogchix.blogspot.co.uk                                                                          ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000iblogchix.blogspot.co.za                                                                          ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000iblogchix.blogspot.cz                                                                             ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000iblogchix.blogspot.com.uy                                                                         ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000iblogchix.blogspot.de                                                                             ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000iblogchix.blogspot.fi                                                                             ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000iblogchix.blogspot.fr                                                                             ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000iblogchix.blogspot.dk                                                                             ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000iblogchix.blogspot.gr                                                                             ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000iblogchix.blogspot.hk                                                                             ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000pussy69pornxxxporno.com                                                                           ACTIVE      WHOIS      24-may-2021       Unknown    AVAILABILITY 
000modelle.com                                                                                       INACTIVE    STDLOOKUP  Unknown           Unknown    AVAILABILITY 
000pussy.com                                                                                         ACTIVE      WHOIS      02-jun-2021       Unknown    AVAILABILITY 
000-sex.com                                                                                          ACTIVE      WHOIS      19-feb-2021       Unknown    AVAILABILITY 
000sexe.com                                                                                          ACTIVE      WHOIS      25-jun-2022       Unknown    AVAILABILITY 
000-sex-guide.dk                                                                                     INACTIVE    STDLOOKUP  Unknown           Unknown    AVAILABILITY 
0-0-0-sexdyr.dk                                                                                      INACTIVE    STDLOOKUP  Unknown           Unknown    AVAILABILITY 
000------------sexo--amadoras.kit.net                                                                ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000--------sexogratis.kit.net                                                                        ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000-sex-porno-erotik-guide.dk                                                                        INACTIVE    STDLOOKUP  Unknown           Unknown    AVAILABILITY 
000-sex-porno-erotik-gratis-billeder-mpeg-avi-video-tgp.dk                                           INACTIVE    STDLOOKUP  Unknown           Unknown    AVAILABILITY 
000.top-100.pl                                                                                       ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000.toplista.pl                                                                                      ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000tristanprod.free.fr                                                                               ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
000-sex-porno-erotik-mpeg-avi-video-livesex-guide.dk                                                 INACTIVE    STDLOOKUP  Unknown           Unknown    AVAILABILITY 
000-xxx.tumblr.com                                                                                   ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
00101001.com                                                                                         ACTIVE      WHOIS      03-may-2021       Unknown    AVAILABILITY 
0011cartoons.com                                                                                     ACTIVE      WHOIS      20-apr-2021       Unknown    AVAILABILITY 
0.011.free.fr                                                                                        ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
0013langford.tumblr.com                                                                              ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
001famosas.com                                                                                       ACTIVE      WHOIS      20-feb-2021       Unknown    AVAILABILITY 
001-all-free-sex-pics.com                                                                            INACTIVE    STDLOOKUP  Unknown           Unknown    AVAILABILITY 
001hentai.com                                                                                        ACTIVE      WHOIS      15-nov-2021       Unknown    AVAILABILITY 
001pic.com                                                                                           ACTIVE      WHOIS      10-aug-2021       Unknown    AVAILABILITY 
001st.com                                                                                            ACTIVE      WHOIS      27-dec-2021       Unknown    AVAILABILITY 
001x.com                                                                                             ACTIVE      WHOIS      07-may-2021       Unknown    AVAILABILITY 
00-1-porno-diimal.da.ru                                                                              ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
001xx.com                                                                                            ACTIVE      WHOIS      25-jan-2021       Unknown    AVAILABILITY 
001x.net                                                                                             INACTIVE    STDLOOKUP  Unknown           Unknown    AVAILABILITY 
0024aaaa.com                                                                                         ACTIVE      WHOIS      17-mar-2021       Unknown    AVAILABILITY 
002lzj.com                                                                                           ACTIVE      WHOIS      19-jul-2021       Unknown    AVAILABILITY 
003store.com                                                                                         ACTIVE      WHOIS      28-apr-2021       Unknown    AVAILABILITY 
00-44.com                                                                                            ACTIVE      WHOIS      09-apr-2021       Unknown    AVAILABILITY 
005.0x1f4b0.com                                                                                      ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
005.free-counter.co.uk                                                                               ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
0069.org                                                                                             ACTIVE      WHOIS      18-dec-2021       Unknown    AVAILABILITY 
005.free-counters.co.uk                                                                              ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
006a039c957c142bb.com                                                                                ACTIVE      WHOIS      31-jul-2021       Unknown    AVAILABILITY 
006.free-counter.co.uk                                                                               ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
006.free-counters.co.uk                                                                              ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
007adulthosting.com                                                                                  ACTIVE      WHOIS      02-nov-2021       Unknown    AVAILABILITY 
007adulthosting.net                                                                                  ACTIVE      WHOIS      15-nov-2021       Unknown    AVAILABILITY 
007amateurs.com                                                                                      ACTIVE      WHOIS      05-aug-2021       Unknown    AVAILABILITY 
007angels.com                                                                                        ACTIVE      WHOIS      14-may-2021       Unknown    AVAILABILITY 
007annuaire.com                                                                                      ACTIVE      WHOIS      18-dec-2021       Unknown    AVAILABILITY 
007auction.com                                                                                       ACTIVE      WHOIS      09-mar-2021       Unknown    AVAILABILITY 
007av.com                                                                                            ACTIVE      WHOIS      19-jun-2021       Unknown    AVAILABILITY 
007blackbooty.com                                                                                    ACTIVE      WHOIS      11-jun-2021       Unknown    AVAILABILITY 
007celeb.com                                                                                         ACTIVE      WHOIS      05-nov-2021       Unknown    AVAILABILITY 
007ch.com                                                                                            ACTIVE      WHOIS      10-jul-2022       Unknown    AVAILABILITY 
007cd.com                                                                                            INACTIVE    STDLOOKUP  Unknown           Unknown    AVAILABILITY 
007dating.com                                                                                        ACTIVE      WHOIS      02-dec-2021       Unknown    AVAILABILITY 
007escorts.com                                                                                       ACTIVE      WHOIS      15-mar-2021       Unknown    AVAILABILITY 
007escorts.co.uk                                                                                     ACTIVE      WHOIS      09-jan-2022       Unknown    AVAILABILITY 
007events.de                                                                                         ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
007famosas.com                                                                                       ACTIVE      WHOIS      20-feb-2021       Unknown    AVAILABILITY 
007footfetish.com                                                                                    ACTIVE      WHOIS      13-nov-2021       Unknown    AVAILABILITY 
007.free-counter.co.uk                                                                               ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
007.free-counters.co.uk                                                                              ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
007girl.com                                                                                          ACTIVE      WHOIS      03-jan-2022       Unknown    AVAILABILITY 
007game.ru                                                                                           ACTIVE      WHOIS      04-may-2021       Unknown    AVAILABILITY 
007girls.net                                                                                         ACTIVE      WHOIS      04-apr-2021       Unknown    AVAILABILITY 
007heaven.com                                                                                        ACTIVE      WHOIS      27-aug-2021       Unknown    AVAILABILITY 
007porno.com                                                                                         ACTIVE      WHOIS      28-feb-2021       Unknown    AVAILABILITY 
007jamesbondfragrances.ugc.bazaarvoice.com                                                           ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
007pornvideos.com                                                                                    ACTIVE      WHOIS      20-jul-2021       Unknown    AVAILABILITY 
007post.com                                                                                          ACTIVE      WHOIS      15-dec-2021       Unknown    AVAILABILITY 
007se.com                                                                                            ACTIVE      WHOIS      19-jun-2021       Unknown    AVAILABILITY 
007premium-escort.de                                                                                 INACTIVE    STDLOOKUP  Unknown           Unknown    AVAILABILITY 
007sexshop.com.ar                                                                                    ACTIVE      WHOIS      11-aug-2021       Unknown    AVAILABILITY 
007sexy.com                                                                                          ACTIVE      WHOIS      28-sep-2021       Unknown    AVAILABILITY 
007shemales.com                                                                                      ACTIVE      WHOIS      06-nov-2021       Unknown    AVAILABILITY 
007teens.com                                                                                         ACTIVE      WHOIS      28-feb-2021       Unknown    AVAILABILITY 
007top.com                                                                                           ACTIVE      WHOIS      27-apr-2021       Unknown    AVAILABILITY 
007undercover.com                                                                                    INACTIVE    STDLOOKUP  Unknown           Unknown    AVAILABILITY 
007-vibrators.com                                                                                    INACTIVE    STDLOOKUP  Unknown           Unknown    AVAILABILITY 
007wildgirl.com                                                                                      ACTIVE      WHOIS      13-sep-2021       Unknown    AVAILABILITY 
007-x.com                                                                                            ACTIVE      WHOIS      28-oct-2020       Unknown    AVAILABILITY 
00880808.com                                                                                         ACTIVE      WHOIS      14-mar-2021       Unknown    AVAILABILITY 
008844.cc                                                                                            ACTIVE      WHOIS      25-may-2021       Unknown    AVAILABILITY 
008.free-counter.co.uk                                                                               ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
008.free-counters.co.uk                                                                              ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
008k.com                                                                                             ACTIVE      WHOIS      12-oct-2024       Unknown    AVAILABILITY 
009.bapi.adsafeprotected.com                                                                         ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
009-yli-241.mktoresp.com                                                                             ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
00aaa2d81c1d174.com                                                                                  ACTIVE      WHOIS      26-jul-2021       Unknown    AVAILABILITY 
00aa.com                                                                                             ACTIVE      WHOIS      31-jul-2021       Unknown    AVAILABILITY 
00adult.com                                                                                          ACTIVE      WHOIS      25-jan-2021       Unknown    AVAILABILITY 
00ae8b5a9c1d597.com                                                                                  ACTIVE      WHOIS      31-may-2021       Unknown    AVAILABILITY 
0-0-adult-superstore.com                                                                             INACTIVE    STDLOOKUP  Unknown           Unknown    AVAILABILITY 
00artoferotica.com                                                                                   ACTIVE      WHOIS      17-dec-2021       Unknown    AVAILABILITY 
00author.com                                                                                         ACTIVE      WHOIS      13-mar-2021       Unknown    AVAILABILITY 
00bloggers.ru                                                                                        ACTIVE      WHOIS      22-nov-2021       Unknown    AVAILABILITY 
00-big-boobs-hooters.com                                                                             INACTIVE    STDLOOKUP  Unknown           Unknown    AVAILABILITY 
00buck.com                                                                                           ACTIVE      WHOIS      04-sep-2021       Unknown    AVAILABILITY 
00-cameraboys.com                                                                                    ACTIVE      WHOIS      20-nov-2021       Unknown    AVAILABILITY 
00cash.com                                                                                           ACTIVE      WHOIS      22-mar-2021       Unknown    AVAILABILITY 
00de.de                                                                                              ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
00extreme.com                                                                                        ACTIVE      WHOIS      19-sep-2021       Unknown    AVAILABILITY 
00fun.com                                                                                            ACTIVE      WHOIS      05-aug-2021       Unknown    AVAILABILITY 
00-gay.com                                                                                           ACTIVE      WHOIS      04-may-2021       Unknown    AVAILABILITY 
00girl.com                                                                                           ACTIVE      WHOIS      22-apr-2027       Unknown    AVAILABILITY 
00go.com                                                                                             ACTIVE      WHOIS      22-mar-2021       Unknown    AVAILABILITY 
00h10.com                                                                                            ACTIVE      WHOIS      28-apr-2021       Unknown    AVAILABILITY 
00-gov.cn                                                                                            ACTIVE      WHOIS      23-apr-2021       Unknown    AVAILABILITY 
00hard.com                                                                                           ACTIVE      WHOIS      08-aug-2021       Unknown    AVAILABILITY 
00it.com                                                                                             ACTIVE      WHOIS      13-mar-2021       Unknown    AVAILABILITY 
00hahh.com                                                                                           INACTIVE    STDLOOKUP  Unknown           Unknown    AVAILABILITY 
00l.com                                                                                              ACTIVE      WHOIS      27-sep-2021       Unknown    AVAILABILITY 
00penis.com                                                                                          ACTIVE      WHOIS      11-oct-2021       Unknown    AVAILABILITY 
00-porn.com                                                                                          ACTIVE      WHOIS      15-sep-2021       Unknown    AVAILABILITY 
00porno.com                                                                                          ACTIVE      WHOIS      28-feb-2021       Unknown    AVAILABILITY 
00sex.de                                                                                             ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
0-0-sex.de                                                                                           INACTIVE    STDLOOKUP  Unknown           Unknown    AVAILABILITY 
00sex.net                                                                                            ACTIVE      WHOIS      14-aug-2021       Unknown    AVAILABILITY 
00sexshop.com                                                                                        INACTIVE    STDLOOKUP  Unknown           Unknown    AVAILABILITY 
0-0-sex.dk                                                                                           INACTIVE    STDLOOKUP  Unknown           Unknown    AVAILABILITY 
00t.net                                                                                              ACTIVE      WHOIS      10-oct-2021       Unknown    AVAILABILITY 
00videoporno.com                                                                                     ACTIVE      WHOIS      22-jul-2022       Unknown    AVAILABILITY 
0-0wearingglassesnakedmen.tumblr.com                                                                 ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
00webcams.com                                                                                        ACTIVE      WHOIS      21-jan-2022       Unknown    AVAILABILITY 
0-0-sz.inc.antpool.com                                                                               ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
00www.com                                                                                            ACTIVE      WHOIS      20-apr-2022       Unknown    AVAILABILITY 
00xxx.com                                                                                            ACTIVE      WHOIS      02-oct-2021       Unknown    AVAILABILITY 
00young.com                                                                                          ACTIVE      WHOIS      11-oct-2022       Unknown    AVAILABILITY 
00zx.com                                                                                             ACTIVE      WHOIS      11-nov-2021       Unknown    AVAILABILITY 
0-100.abseits.ski                                                                                    ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
0-100.burst-team.us                                                                                  ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
0-100.burst.wickedmine.com                                                                           ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
0-100.coinlab.biz                                                                                    ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
0-100-pool.abseits.ski                                                                               ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
0-100-newbi.ikpool.com                                                                               ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
0-100pool.abseits.ski                                                                                ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
0-100-pool.burst-alliance.org                                                                        ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
0-100pool.burstcoin.ro                                                                               ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
0-100-pool.coinlab.biz                                                                               ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
0-100-pool.burst.cryptoguru.org                                                                      ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
0-100pool.coinlab.biz                                                                                ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
01010101.com                                                                                         ACTIVE      WHOIS      28-jun-2021       Unknown    AVAILABILITY 
0101011.com                                                                                          ACTIVE      WHOIS      06-jul-2021       Unknown    AVAILABILITY 
0101footworld.com                                                                                    ACTIVE      WHOIS      27-dec-2022       Unknown    AVAILABILITY 
0.1.01.0.1.sexeshop.free.fr                                                                          INACTIVE    STDLOOKUP  Unknown           Unknown    AVAILABILITY 
0-109.vk.com                                                                                         ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
010uws007.coin-hive.com                                                                              ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
0-11-213-95.vk.com                                                                                   ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
011adult.com                                                                                         ACTIVE      WHOIS      06-feb-2021       Unknown    AVAILABILITY 
0-118-213-95.vk.com                                                                                  ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
0120391515.com                                                                                       ACTIVE      WHOIS      05-dec-2021       Unknown    AVAILABILITY 
0-11.vk.com                                                                                          ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
0123hardcore.com                                                                                     ACTIVE      WHOIS      22-may-2021       Unknown    AVAILABILITY 
01234.over-blog.fr                                                                                   ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
0.123videos.free.fr                                                                                  ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
0.123voyeur.free.fr                                                                                  ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
012469af389a1d1246d.com                                                                              ACTIVE      WHOIS      31-jul-2021       Unknown    AVAILABILITY 
0127538a552.com                                                                                      ACTIVE      WHOIS      24-oct-2021       Unknown    AVAILABILITY 
0137.net                                                                                             ACTIVE      WHOIS      13-jan-2021       Unknown    AVAILABILITY 
0-12.vk.com                                                                                          ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
0141yo.com                                                                                           ACTIVE      WHOIS      18-jun-2021       Unknown    AVAILABILITY 
0141yo.net                                                                                           ACTIVE      WHOIS      18-jun-2021       Unknown    AVAILABILITY 
01-49.com                                                                                            ACTIVE      WHOIS      10-feb-2021       Unknown    AVAILABILITY 
015.us                                                                                               ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
016.us                                                                                               ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
017gj.com                                                                                            ACTIVE      WHOIS      03-mar-2021       Unknown    AVAILABILITY 
018520.com                                                                                           ACTIVE      WHOIS      06-dec-2021       Unknown    AVAILABILITY 
018.us                                                                                               ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
0190844944.com                                                                                       ACTIVE      WHOIS      18-may-2021       Unknown    AVAILABILITY 
0190bizarr.de                                                                                        ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
0190-dialer.com                                                                                      ACTIVE      WHOIS      03-mar-2021       Unknown    AVAILABILITY 
0190erotic.de                                                                                        ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
0190livecam.hotpage.net                                                                              ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
0190sex.de                                                                                           ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
0190-telefonsex.de                                                                                   ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
0190telefonsex.de                                                                                    ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
0190-telefonsex-girls.de                                                                             ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
0190-telefonsexworld.de                                                                              ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
0-196.vk.com                                                                                         ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
0199968.com                                                                                          ACTIVE      WHOIS      20-may-2021       Unknown    AVAILABILITY 
019.us                                                                                               ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
01aa.com                                                                                             ACTIVE      WHOIS      07-jul-2021       Unknown    AVAILABILITY 
01.abseits.ski                                                                                       ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
01.adnxs.com                                                                                         ACTIVE      DNSLOOKUP  Unknown           Unknown    AVAILABILITY 
01adult.net                                                                                          ACTIVE      WHOIS      20-oct-2021       Unknown    AVAILABILITY 





^C

asciicast

@funilrys
Copy link
Owner

funilrys commented Jan 5, 2021

Considering this as successful. @\me if I'm wrong 😉

funilrys added a commit that referenced this issue Jan 5, 2021
This patch touches #162.

Indeed, before this patch, we were not handling long labels correctely.

Contributors:
  * @spirillen
@spirillen
Copy link
Contributor Author

Since the DB test is still running from yesterday, i'll say it is :)

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

No branches or pull requests

2 participants