mysql> describe mantis_bug_relationship_table;
+--------------------+-----------------+------+-----+---------+----------------+
| Field              | Type            | Null | Key | Default | Extra          |
+--------------------+-----------------+------+-----+---------+----------------+
| id                 | int(7) unsigned | NO   | PRI | NULL    | auto_increment |
| source_bug_id      | int(7) unsigned | NO   | MUL | 0       |                |
| destination_bug_id | int(7) unsigned | NO   | MUL | 0       |                |
| relationship_type  | int(2)          | NO   |     | 0       |                |
+--------------------+-----------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)

mysql> select * FROM mantis_bug_relationship_table WHERE source_bug_id=13 OR destination_bug_id=13;
Empty set (0.00 sec)

mysql> select * FROM mantis_bug_relationship_table WHERE source_bug_id=3973 OR destination_bug_id=3973;
Empty set (0.00 sec)


mysql> select * FROM mantis_bug_text_table WHERE id=3973;
+------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| id   | description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | steps_to_reproduce | additional_information                                                                                                                                                                                                                                         |
+------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 3973 | Sometimes (not always but nearly), when a connection between two hubs is lost,
the link does not come back up even though it is set to autoconnect in the
config file.

The ircd "sees" the split (ie "Lost connection to ..." notice and SQUIT in the
logs), but remains on its own indefinitely (10 hours in the last instance until
someone reconnected manually).

It seems that the problem builds up over time, ie. the first couple of
disconnections after a restart/rehash are usually handled correctly (autotonnect
kicks in), but later on, autoconnect just does not happen any longer. |                    | The only clue so far is:
[Wed Dec  1 00:19:13 2010] - WARNING: Time jumped ~23 seconds ahead! (1291159130
-> 1291159153)
[Wed Dec  1 00:19:13 2010] - [TimeShift] Resetting some timers!

The server has ntpd running and has *not* skipped ahead itself. |
+------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> select * FROM mantis_bug_table WHERE id=3973;
+------+------------+-------------+------------+--------------+----------+----------+-----------------+--------+------------+------------+-----+-------------+-------+-----------+----------+---------+------------------+-------+------------+------------+-------------------------------------------------+-------------------+--------+----------------+-------------+----------------+----------+--------------+
| id   | project_id | reporter_id | handler_id | duplicate_id | priority | severity | reproducibility | status | resolution | projection | eta | bug_text_id | os    | os_build  | platform | version | fixed_in_version | build | profile_id | view_state | summary                                         | sponsorship_total | sticky | target_version | category_id | date_submitted | due_date | last_updated |
+------+------------+-------------+------------+--------------+----------+----------+-----------------+--------+------------+------------+-----+-------------+-------+-----------+----------+---------+------------------+-------+------------+------------+-------------------------------------------------+-------------------+--------+----------------+-------------+----------------+----------+--------------+
| 3973 |          2 |        6352 |          0 |            0 |       30 |       60 |              30 |     10 |         10 |         10 |  10 |        3973 | Linux | 2.6.22.19 | x86      | 3.2.8   |                  |       |          0 |         10 | Autoconnect link does not reconnect after split |                 0 |      0 |                |           7 |     1291856436 |        1 |   1291856436 |
+------+------------+-------------+------------+--------------+----------+----------+-----------------+--------+------------+------------+-----+-------------+-------+-----------+----------+---------+------------------+-------+------------+------------+-------------------------------------------------+-------------------+--------+----------------+-------------+----------------+----------+--------------+
1 row in set (0.00 sec)