TeamCity 8.1.5 not allowing me to authorize agents within my limits

This is an urgent issue for us. We are using the free version of TeamCity 8.1.5 and have had 3 windows agents on it working fine. Then recently we needed to do a mysql database upgrade. Somehow, our user accounts (basic built-in authentication) were lost in the process. What was weirder was that for some reason, it only authorized 2 out of my 3 agents. If I click on the Agents tab, it says:

"Additional agents cannot be authorized because there are no agent licenses left. View available licenses at Manage licenses page."

When I click the link, it clearly says I am authorized to have up to 3 agents. And yet, it was not allowing me to authorize that last agent. Weird.

The next day (today), the problem got worse. Now only 1 agent is authorized and 2 are unauthorized, and TeamCity is not permitting me to authorize any more. Please see screenshot attached for proof. Notice how in the Connection section it has 1 agent, and in the unauthorized section there are 2 agents.

This is an urgent issue that needs a quick resolution. Please let me know what I can do to fix this issue asap.



Attachment(s):
Screen Shot 2014-12-16 at 10.37.50 AM.png
5 comments
Comment actions Permalink

Hi,

It seems that the problem was caused by database upgrade. Could you please send database upgrade log and also teamcity-server.log. Did you stop teamcity server before database upgrade?

0
Comment actions Permalink

Hello,

you can restart TeamCity server and try again.
If it didn't help, please provide us with results of the following queries:

    select * from agent_type;

    select * from agent;

Thanks.

0
Comment actions Permalink

Here are the db query results:

mysql> select * from agent_type;

+---------------+---------------+------------+------------+----------+--------+

| agent_type_id | agent_pool_id | cloud_code | profile_id | image_id | policy |

+---------------+---------------+------------+------------+----------+--------+

|            1 |            0 | A          | A          | real-2  |      1 |

|            2 |            0 | A          | A          | real-1  |      1 |

|            3 |            0 | A          | A          | real-3  |      1 |

|            4 |            0 | A          | A          | real-4  |      1 |

|            5 |            0 | A          | A          | real-5  |      1 |

+---------------+---------------+------------+------------+----------+--------+

5 rows in set (0.00 sec)

mysql> select * from agent;

+----+----------------+---------------+------+---------------+--------+------------+------------+------------------------+------------------------+---------------------+----------------------------------+-------------------+----------------------------+

| id | name          | host_addr    | port | agent_type_id | status | authorized | registered | registration_timestamp | last_binding_timestamp | unregistered_reason | authorization_token              | status_to_restore | status_restoring_timestamp |

+----+----------------+---------------+------+---------------+--------+------------+------------+------------------------+------------------------+---------------------+----------------------------------+-------------------+----------------------------+

|  4 | Win764100Clone | 10.87.244.126 | 9090 |            4 |      1 |          0 |          1 |          1418674565166 |          1418938319170 | NULL                | 2e65a896f223e7fa32617cf58324a6d3 |              NULL |                      NULL |

|  5 | Win764cloneSD  | 10.87.244.76  | 9090 |            5 |      1 |          0 |          1 |          1418711357452 |          1418938360379 | NULL                | 57c6125c9c2466eff10164a75a4ed087 |              NULL |                      NULL |

+----+----------------+---------------+------+---------------+--------+------------+------------+------------------------+------------------------+---------------------+----------------------------------+-------------------+----------------------------+

2 rows in set (0.00 sec)

0
Comment actions Permalink

Hello Syed,

looks like a kind of problem with licensing.
I'll ask my colleague to investigate this problem.

Could you please also attach the 'teamcity-server.log.*' files?

Thanks!

0
Comment actions Permalink

Please attach screenshot of Administration -> Licenses page, or send it to teamcity-feedback@jetbrains.com

0

Please sign in to leave a comment.