dogu-team / dogu

Dogu is unified test automation platform for cross platform game and app
https://docs.dogutech.io
GNU Affero General Public License v3.0
10 stars 0 forks source link

[Bug]: Same serial devices are registered in an organization #462

Closed Ikalli closed 1 year ago

Ikalli commented 1 year ago

Environment

Development (for Dogu developers)

Steps to reproduce

  1. Create host and connect device

Actually, this is not reproducible, but worth to investigating

image

DB - Device table

device_id                           |serial                              |serial_unique                       |name                                |platform|model     |model_name           |version   |manufacturer|resolution_width|resolution_height|is_global|is_host|is_virtual|display_error                  |enable_host_device|connection_state|max_parallel_jobs|heartbeat                    |organization_id                     |host_id                             |created_at                   |updated_at                   |deleted_at|
------------------------------------+------------------------------------+------------------------------------+------------------------------------+--------+----------+---------------------+----------+------------+----------------+-----------------+---------+-------+----------+-------------------------------+------------------+----------------+-----------------+-----------------------------+------------------------------------+------------------------------------+-----------------------------+-----------------------------+----------+
7dde7240-c9ba-4aaa-bec7-5f04da4481dc|00008030-001549891E3B802E           |00008030-001549891E3B802E           |00008030-001549891E3B802E           |      40|iPhone12,8|iPhone SE (2nd gen)  |16.6      |            |             375|              667|        0|      0|         0|IosDeviceAgent error. no signal|                 0|               1|                1|2023-09-12 20:07:50.766 +0900|78a43b02-56d4-45f0-8665-bf7c0d58ad12|5f76f9d5-8d53-4982-876b-fd62950b2a44|2023-09-12 18:39:12.872 +0900|2023-09-12 20:08:02.631 +0900|          |
5ba83dd4-109b-40d6-b46c-b7e5d28a8803|00008030-001549891E3B802E           |00008030-001549891E3B802E           |00008030-001549891E3B802E           |      40|iPhone12,8|iPhone SE (2nd gen)  |16.6      |            |             375|              667|        0|      0|         0|                               |                 0|               1|                1|                             |78a43b02-56d4-45f0-8665-bf7c0d58ad12|5f76f9d5-8d53-4982-876b-fd62950b2a44|2023-09-12 18:39:12.868 +0900|2023-09-12 18:39:12.965 +0900|          |
fc40352b-9a46-4152-9c02-ce300d493c94|8d244e26-e71f-55c6-b383-8fc3a612580d|8d244e26-e71f-55c6-b383-8fc3a612580d|8d244e26-e71f-55c6-b383-8fc3a612580d|      10|Mac14,2   |MacBook Air M2 (2022)|13.3.1 (a)|Apple Inc.  |               0|                0|        0|      1|         0|                               |                 0|               1|                1|2023-09-13 16:41:33.488 +0900|78a43b02-56d4-45f0-8665-bf7c0d58ad12|5f76f9d5-8d53-4982-876b-fd62950b2a44|2023-09-12 18:12:34.278 +0900|2023-09-13 16:41:44.118 +0900|          |
773165f4-1ad9-4165-a3ac-7bf602494acb|00008030-001549891E3B802E           |00008030-001549891E3B802E           |00008030-001549891E3B802E           |      40|iPhone12,8|iPhone SE (2nd gen)  |16.6      |            |             375|              667|        0|      0|         0|                               |                 0|               1|                1|                             |78a43b02-56d4-45f0-8665-bf7c0d58ad12|5f76f9d5-8d53-4982-876b-fd62950b2a44|2023-09-12 18:39:12.882 +0900|2023-09-12 18:39:12.957 +0900|          |
5903a8b9-23e9-4e70-8432-7d8f1f9a363f|00008030-001549891E3B802E           |00008030-001549891E3B802E           |00008030-001549891E3B802E           |      40|iPhone12,8|iPhone SE (2nd gen)  |16.6      |            |             375|              667|        0|      0|         0|IosDeviceAgent error. no signal|                 0|               1|                1|2023-09-12 18:40:28.701 +0900|78a43b02-56d4-45f0-8665-bf7c0d58ad12|5f76f9d5-8d53-4982-876b-fd62950b2a44|2023-09-12 18:39:12.892 +0900|2023-09-12 20:07:51.114 +0900|          |
77eabf85-3f6c-4fe0-8b8d-d5f3f5215051|00008030-001549891E3B802E           |00008030-001549891E3B802E           |00008030-001549891E3B802E           |      40|iPhone12,8|iPhone SE (2nd gen)  |16.6      |            |             375|              667|        0|      0|         0|                               |                 0|               1|                1|                             |78a43b02-56d4-45f0-8665-bf7c0d58ad12|5f76f9d5-8d53-4982-876b-fd62950b2a44|2023-09-12 18:39:12.888 +0900|2023-09-12 18:39:12.960 +0900|          |
99042539-9ebe-4c91-b4e0-f418b564d38c|00008030-001549891E3B802E           |00008030-001549891E3B802E           |00008030-001549891E3B802E           |      40|iPhone12,8|iPhone SE (2nd gen)  |16.6      |            |             375|              667|        0|      0|         0|                               |                 0|               1|                1|                             |78a43b02-56d4-45f0-8665-bf7c0d58ad12|5f76f9d5-8d53-4982-876b-fd62950b2a44|2023-09-12 18:39:12.885 +0900|2023-09-12 18:39:12.958 +0900|          |
a90eb394-0abf-48a4-9962-eda8087082de|00008030-001549891E3B802E           |00008030-001549891E3B802E           |00008030-001549891E3B802E           |      40|iPhone12,8|iPhone SE (2nd gen)  |16.6      |            |             375|              667|        0|      0|         0|                               |                 0|               1|                1|                             |78a43b02-56d4-45f0-8665-bf7c0d58ad12|5f76f9d5-8d53-4982-876b-fd62950b2a44|2023-09-12 18:39:12.901 +0900|2023-09-12 18:39:12.958 +0900|          |
0c153ed1-d7d6-4731-8f34-ab34e0bc4dbc|00008030-001549891E3B802E           |00008030-001549891E3B802E           |00008030-001549891E3B802E           |      40|iPhone12,8|iPhone SE (2nd gen)  |16.6      |            |             375|              667|        0|      0|         0|                               |                 0|               1|                1|                             |78a43b02-56d4-45f0-8665-bf7c0d58ad12|5f76f9d5-8d53-4982-876b-fd62950b2a44|2023-09-12 18:39:12.896 +0900|2023-09-12 18:39:12.963 +0900|          |
21dd6a10-2638-4acd-a7ef-364972dc73cc|R39M30N0KHM                         |R39M30N0KHM                         |R39M30N0KHM                         |      30|SM-G970N  |Galaxy S10e          |12        |samsung     |            1080|             2280|        1|      0|         0|agent not alive                |                 0|               1|                1|2023-09-13 16:22:29.945 +0900|78a43b02-56d4-45f0-8665-bf7c0d58ad12|5f76f9d5-8d53-4982-876b-fd62950b2a44|2023-09-12 18:12:56.947 +0900|2023-09-13 16:22:39.985 +0900|          |

Expected behavior

Device with same serial must be registered only one time.

Actual behavor

Devices with same serial registered multiple times

Version

Development