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
Please sign in to leave a comment.
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?
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.
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)
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!
Please attach screenshot of Administration -> Licenses page, or send it to teamcity-feedback@jetbrains.com