magic
magic copied to clipboard
dtyq
[Bug]: Linux下安装后无法登录
Component
Super Magic (Super Magic)
Deployment Type
Self-hosted (Docker)
Bug Description
群晖NAS、飞牛NAS、全新Debian12系统均无法登录，只有MAC上使用项目内的部署步骤访问成功。
Steps to Reproduce
未提供
Expected Behavior
正常登录
Actual Behavior
无法登录（未提供具体表现）
Environment
未提供
Logs and Error Messages
No response
Additional Context
No response
Checklist
- [ ] I have searched for existing issues before creating this report
- [ ] I have provided all the required information above
- [ ] This issue is reproducible
@admin10101010 这里单独讨论 他们mac那边的问题跟linux的应该不一样
magic-service | Migrating: 2025_02_27_170952_create_magic_api_premium_endpoints
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:1.1] select * from information_schema.tables where table_schema = 'magic' and table_name = 'magic_api_premium_endpoints']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:10.59] create table `magic_api_premium_endpoints` (`id` bigint unsigned not null auto_increment primary key, `type` varchar(255) not null comment '接入点类型。用户需要自己保证不与其他业务重复', `provider` varchar(255) null comment '提供商', `name` varchar(255) not null comment '接入点名称', `config` text null comment '让用户自己存一些配置信息', `enabled` tinyint not null default '1' comment '是否启用: 1=启用, 0=禁用', `circuit_breaker_status` varchar(32) not null default 'closed' comment '熔断状态: closed=正常服务中, open=熔断中, half_open=尝试恢复中', `resources` varchar(255) null comment '资源的消耗 id 列表，一次请求可能消耗多种资源', `created_at` datetime null, `updated_at` datetime null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' COMMENT = 'API接入点表，关联了接入点的可消耗资源信息']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:5.92] alter table `magic_api_premium_endpoints` add unique `unique_enabled_type_provider_name`(`enabled`, `type`, `provider`, `name`)]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:1.09] insert into `migrations` (`migration`, `batch`) values ('2025_02_27_170952_create_magic_api_premium_endpoints', '1')]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_02_27_170952_create_magic_api_premium_endpoints
magic-service | Migrating: 2025_02_27_170952_create_magic_api_premium_exceptions
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:0.73] select * from information_schema.tables where table_schema = 'magic' and table_name = 'magic_api_premium_exceptions']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:6.84] create table `magic_api_premium_exceptions` (`id` bigint unsigned not null auto_increment primary key, `exception_type` varchar(255) not null comment '异常类型', `can_retry` tinyint(1) null comment '是否可以重试', `retry_max_times` int null comment '重试最大次数', `retry_interval` int null comment '重试时间间隔', `created_at` datetime null, `updated_at` datetime null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' COMMENT = '异常信息表，储存异常类型，是否可以重试，重试最大次数，重试时间间隔']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:1.19] insert into `migrations` (`migration`, `batch`) values ('2025_02_27_170952_create_magic_api_premium_exceptions', '1')]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_02_27_170952_create_magic_api_premium_exceptions
magic-service | Migrating: 2025_02_27_171757_create_magic_api_premium_resource_table
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:0.77] select * from information_schema.tables where table_schema = 'magic' and table_name = 'magic_api_premium_resources']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:6.99] create table `magic_api_premium_resources` (`id` bigint unsigned not null auto_increment primary key, `endpoint_id` varchar(64) not null comment '接入点ID', `resource_name` varchar(64) not null comment '资源名称', `billing_cycle_value` int not null default '0' comment '计费周期值', `billing_cycle_type` tinyint not null default '0' comment '0: 总量, 1：秒, 2：分钟, 3：小时, 4：天', `total_usage` int not null default '0' comment '总量', `created_at` timestamp null, `updated_at` timestamp null, `deleted_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' COMMENT = 'API资源计费规则表，支持总量或者速率计费']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:5.96] alter table `magic_api_premium_resources` add index `index_endpoint_id`(`endpoint_id`, `id`)]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:1.02] insert into `migrations` (`migration`, `batch`) values ('2025_02_27_171757_create_magic_api_premium_resource_table', '1')]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_02_27_171757_create_magic_api_premium_resource_table
magic-service | Migrating: 2025_02_27_201305_magic_flow_execute_log_add_more
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:12.28] alter table `magic_flow_execute_logs` add `organization_code` varchar(255) not null default '' comment '组织代码', add `flow_type` varchar(255) not null default '' comment '流程类型', add `parent_flow_code` varchar(255) not null default '' comment '父流程代码', add `operator_id` varchar(255) not null default '' comment '操作员ID', add `level` int not null default '0' comment '级别', add `execution_type` varchar(255) not null default '' comment '执行类型']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:1.31] insert into `migrations` (`migration`, `batch`) values ('2025_02_27_201305_magic_flow_execute_log_add_more', '1')]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_02_27_201305_magic_flow_execute_log_add_more
magic-service | Migrating: 2025_02_28_113828_create_service_provider_original_models_table
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:0.87] select * from information_schema.tables where table_schema = 'magic' and table_name = 'service_provider_original_models']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:6.65] create table `service_provider_original_models` (`id` bigint unsigned not null auto_increment primary key, `model_id` varchar(255) not null comment '原始模型ID', `created_at` timestamp null, `updated_at` timestamp null, `deleted_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:1.89] insert into `migrations` (`migration`, `batch`) values ('2025_02_28_113828_create_service_provider_original_models_table', '1')]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_02_28_113828_create_service_provider_original_models_table
magic-service | Migrating: 2025_03_05_175314_add_visibility_config_to_magic_bots_and_versions_table
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:13.48] alter table `magic_bot_versions` add `visibility_config` json null comment '可见性配置，包含可见范围类型和可见成员/部门列表']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:1.18] insert into `migrations` (`migration`, `batch`) values ('2025_03_05_175314_add_visibility_config_to_magic_bots_and_versions_table', '1')]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_03_05_175314_add_visibility_config_to_magic_bots_and_versions_table
magic-service | Migrating: 2025_03_08_070000_magic_flow_knowledge_add_retrieve_config
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:17.37] alter table `magic_flow_knowledge` add `retrieve_config` varchar(2000) null comment '检索配置']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:1.42] insert into `migrations` (`migration`, `batch`) values ('2025_03_08_070000_magic_flow_knowledge_add_retrieve_config', '1')]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_03_08_070000_magic_flow_knowledge_add_retrieve_config
magic-service | Migrating: 2025_03_09_213222_create_magic_flow_multi_modal_logs
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:5.19] create table `magic_flow_multi_modal_logs` (`id` bigint unsigned not null auto_increment primary key, `message_id` varchar(64) not null default '' comment '消息ID', `type` tinyint not null default '0' comment '多模态类型。1 图片', `model` varchar(128) not null default '' comment '识别所使用的模型', `analysis_result` text not null comment '分析结果', `created_at` datetime null, `updated_at` datetime null) default character set utf8mb4 collate 'utf8mb4_unicode_ci']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:5.65] alter table `magic_flow_multi_modal_logs` add index `magic_flow_multi_modal_logs_message_id_index`(`message_id`)]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:1.12] insert into `migrations` (`migration`, `batch`) values ('2025_03_09_213222_create_magic_flow_multi_modal_logs', '1')]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_03_09_213222_create_magic_flow_multi_modal_logs
magic-service | Migrating: 2025_03_10_171247_update_magic_contact_users_table
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:18.69] ALTER TABLE magic_contact_users CHANGE extra extra TEXT CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci` COMMENT '用户扩展信息']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:0.92] insert into `migrations` (`migration`, `batch`) values ('2025_03_10_171247_update_magic_contact_users_table', '1')]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_03_10_171247_update_magic_contact_users_table
magic-service | Migrating: 2025_03_11_140010_create_admin_global_settings_table
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:5.73] create table `admin_global_settings` (`id` bigint unsigned not null auto_increment primary key, `type` int unsigned not null comment '类型', `status` tinyint unsigned not null default '0' comment '状态', `extra` json null comment '额外配置', `organization` varchar(255) not null comment '组织编码', `created_at` datetime null, `updated_at` datetime null) default character set utf8mb4 collate 'utf8mb4_unicode_ci']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:5.36] alter table `admin_global_settings` add unique `unique_type_organization`(`type`, `organization`)]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:0.96] insert into `migrations` (`migration`, `batch`) values ('2025_03_11_140010_create_admin_global_settings_table', '1')]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_03_11_140010_create_admin_global_settings_table
magic-service | Migrating: 2025_03_11_144310_add_type_to_magic_api_model_configs
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:3.78] ALTER TABLE magic_api_model_configs CHANGE model model VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci` COMMENT '实际上代表 endpoint']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:10.92] alter table `magic_api_model_configs` add `type` varchar(80) not null default '' comment '模型类型' after `model`]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:5.65] alter table `magic_api_model_configs` add index `idx_type`(`type`)]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:1.14] insert into `migrations` (`migration`, `batch`) values ('2025_03_11_144310_add_type_to_magic_api_model_configs', '1')]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_03_11_144310_add_type_to_magic_api_model_configs
magic-service | Migrating: 2025_03_13_163952_add_indexes_to_magic_chat_sequences_table
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:1.42] select * from information_schema.tables where table_schema = 'magic' and table_name = 'magic_chat_sequences']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:0.89] SHOW INDEX FROM `magic_chat_sequences` WHERE Key_name = 'idx_object_type_id_refer_message_id']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:6.17] CREATE INDEX idx_object_type_id_refer_message_id
magic-service | ON `magic_chat_sequences` (object_type, object_id, refer_message_id, seq_id DESC)]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:0.64] SHOW INDEX FROM `magic_chat_sequences` WHERE Key_name = 'idx_object_type_id_seq_id']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:5.66] CREATE INDEX idx_object_type_id_seq_id
magic-service | ON `magic_chat_sequences` (object_type, object_id, seq_id)]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:0.91] SHOW INDEX FROM `magic_chat_sequences` WHERE Key_name = 'idx_conversation_id_seq_id']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:6.86] CREATE INDEX idx_conversation_id_seq_id
magic-service | ON `magic_chat_sequences` (conversation_id, seq_id DESC)]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:0.91] insert into `migrations` (`migration`, `batch`) values ('2025_03_13_163952_add_indexes_to_magic_chat_sequences_table', '1')]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_03_13_163952_add_indexes_to_magic_chat_sequences_table
magic-service | Migrating: 2025_03_17_154058_add_field_translates_service_provider
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:14.12] alter table `service_provider` add `translate` json not null default (JSON_ARRAY()) comment '多语言配置，格式：{\"\": \"名称\", \"en_US\": \"name\"}']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:0.92] insert into `migrations` (`migration`, `batch`) values ('2025_03_17_154058_add_field_translates_service_provider', '1')]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_03_17_154058_add_field_translates_service_provider
magic-service | Migrating: 2025_03_18_114222_delete_service_provider_model_status
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:3.86] drop table if exists `service_provider_model_status`]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:0.84] insert into `migrations` (`migration`, `batch`) values ('2025_03_18_114222_delete_service_provider_model_status', '1')]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_03_18_114222_delete_service_provider_model_status
magic-service | Migrating: 2025_03_19_162432_add_field_service_provider_configs_alias_table
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:11.6] alter table `service_provider_configs` add `alias` varchar(255) not null default '' comment '别名']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:1.08] insert into `migrations` (`migration`, `batch`) values ('2025_03_19_162432_add_field_service_provider_configs_alias_table', '1')]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_03_19_162432_add_field_service_provider_configs_alias_table
magic-service | Migrating: 2025_03_19_171257_add_password_to_magic_contact_accounts
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:11.95] alter table `magic_contact_accounts` add `password` varchar(128) not null default '' comment '密码']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:1.36] insert into `migrations` (`migration`, `batch`) values ('2025_03_19_171257_add_password_to_magic_contact_accounts', '1')]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_03_19_171257_add_password_to_magic_contact_accounts
magic-service | Migrating: 2025_03_19_180923_add_field_service_provider_original_models_table
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:10.57] alter table `service_provider_original_models` add `type` tinyint not null default '0' comment '类型，0：系统默认，1：自己添加', add `organization_code` varchar(255) not null default '' comment '组织编码']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:0.82] insert into `migrations` (`migration`, `batch`) values ('2025_03_19_180923_add_field_service_provider_original_models_table', '1')]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_03_19_180923_add_field_service_provider_original_models_table
magic-service | Migrating: 2025_03_20_191830_add_field_service_provider_configs_table
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:13.16] alter table `service_provider_configs` add `translate` json not null default (JSON_ARRAY()) comment '多语言配置，格式：{\"\": \"名称\", \"en_US\": \"name\"}']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:0.89] insert into `migrations` (`migration`, `batch`) values ('2025_03_20_191830_add_field_service_provider_configs_table', '1')]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_03_20_191830_add_field_service_provider_configs_table
magic-service | Migrating: 2025_03_20_192250_add_field_service_provider_models_table
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:16.1] alter table `service_provider_models` add `translate` json not null default (JSON_ARRAY()) comment '多语言配置，格式：{\"\": \"名称\", \"en_US\": \"name\"}']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:1.19] insert into `migrations` (`migration`, `batch`) values ('2025_03_20_192250_add_field_service_provider_models_table', '1')]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_03_20_192250_add_field_service_provider_models_table
magic-service | Migrating: 2025_03_25_191114_add_field_service_provider_table
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:11.74] alter table `service_provider` add `remark` varchar(255) not null default '' comment '备注']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:0.87] insert into `migrations` (`migration`, `batch`) values ('2025_03_25_191114_add_field_service_provider_table', '1')]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_03_25_191114_add_field_service_provider_table
magic-service | Migrating: 2025_03_26_150000_update_indexes_and_comments
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:7.89] truncate `magic_api_premium_endpoint_statistics`]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:15.56] ALTER TABLE magic_api_premium_endpoint_statistics CHANGE statistics_time statistics_time DATETIME DEFAULT NULL COMMENT '统计时间段', CHANGE statistics_level statistics_level INT DEFAULT NULL COMMENT '统计级别：0-秒级，1-分钟级，2-小时级，3-天级']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:1.54] select index_name as `name`, group_concat(column_name order by seq_in_index) as `columns`, index_type as `type`, not non_unique as `unique` from information_schema.statistics where table_schema = 'magic' and table_name = 'magic_api_premium_endpoint_responses' group by index_name, index_type, non_unique]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:0.67] select index_name as `name`, group_concat(column_name order by seq_in_index) as `columns`, index_type as `type`, not non_unique as `unique` from information_schema.statistics where table_schema = 'magic' and table_name = 'magic_api_premium_endpoint_responses' group by index_name, index_type, non_unique]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:3.25] alter table `magic_api_premium_endpoint_responses` drop index `endpoint_id_created_at_index`]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:3.06] alter table `magic_api_premium_endpoint_responses` drop index `request_id_index`]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:3.88] alter table `magic_api_premium_endpoint_responses` add index `endpoint_id_created_at_index`(`created_at`, `endpoint_id`)]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:0.91] select index_name as `name`, group_concat(column_name order by seq_in_index) as `columns`, index_type as `type`, not non_unique as `unique` from information_schema.statistics where table_schema = 'magic' and table_name = 'magic_api_premium_endpoint_statistics' group by index_name, index_type, non_unique]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:4.75] alter table `magic_api_premium_endpoint_statistics` drop index `unique_endpoint_id_statistics_level_time`]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:4.83] alter table `magic_api_premium_endpoint_statistics` add unique `unique_statistics_time`(`statistics_time`, `statistics_level`, `endpoint_id`)]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:0.9] insert into `migrations` (`migration`, `batch`) values ('2025_03_26_150000_update_indexes_and_comments', '1')]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_03_26_150000_update_indexes_and_comments
magic-service | Migrating: 2025_03_29_000000_create_knowledge_base_documents
magic-service | [INFO] [2025-08-05 15:08:35][sql][[default:6.58] create table `knowledge_base_documents` (`id` bigint unsigned not null auto_increment primary key, `knowledge_base_code` varchar(255) not null comment '关联知识库code', `name` varchar(255) not null comment '文档名称', `description` varchar(255) not null comment '描述', `code` varchar(255) not null comment '文档code', `version` int unsigned not null default '1' comment '版本', `enabled` tinyint(1) not null default '1' comment '1 启用 0 禁用', `doc_type` int unsigned not null comment '文档类型', `doc_metadata` json null comment '文档元数据', `sync_status` tinyint not null default '0' comment '同步状态', `sync_times` tinyint not null default '0' comment '同步次数', `sync_status_message` varchar(1000) not null default '' comment '同步状态消息', `organization_code` varchar(255) not null comment '组织编码', `word_count` bigint unsigned not null default '0' comment '字数统计', `embedding_model` varchar(255) not null comment '嵌入模型', `vector_db` varchar(255) not null comment '向量数据库', `retrieve_config` json null comment '检索配置', `fragment_config` json null comment '分段配置', `embedding_config` json null comment '嵌入配置', `vector_db_config` json null comment '向量数据库配置', `created_uid` varchar(255) not null comment '创建者ID', `updated_uid` varchar(255) not null comment '更新者ID', `created_at` datetime null, `updated_at` datetime null, `deleted_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:5.52] alter table `knowledge_base_documents` add unique `unique_code_version`(`code`, `version`)]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:5.52] alter table `knowledge_base_documents` add index `knowledge_base_documents_knowledge_base_code_index`(`knowledge_base_code`)]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:1.89] insert into `migrations` (`migration`, `batch`) values ('2025_03_29_000000_create_knowledge_base_documents', '1')]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_03_29_000000_create_knowledge_base_documents
magic-service | Migrating: 2025_03_29_000001_update_knowledge_base_fragments
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:0.82] select `column_key` as `column_key`, `column_name` as `column_name`, `data_type` as `data_type`, `column_comment` as `column_comment`, `extra` as `extra`, `column_type` as `column_type` from information_schema.columns where `table_schema` = 'magic' and `table_name` = 'magic_flow_knowledge_fragment' order by ORDINAL_POSITION]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:0.81] select `column_key` as `column_key`, `column_name` as `column_name`, `data_type` as `data_type`, `column_comment` as `column_comment`, `extra` as `extra`, `column_type` as `column_type` from information_schema.columns where `table_schema` = 'magic' and `table_name` = 'magic_flow_knowledge_fragment' order by ORDINAL_POSITION]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:12.66] alter table `magic_flow_knowledge_fragment` add `document_code` varchar(255) not null default '' comment '关联文档code', add `word_count` bigint unsigned not null default '0' comment '字数统计']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:5.86] alter table `magic_flow_knowledge_fragment` add index `magic_flow_knowledge_fragment_document_code_index`(`document_code`)]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:1.15] insert into `migrations` (`migration`, `batch`) values ('2025_03_29_000001_update_knowledge_base_fragments', '1')]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_03_29_000001_update_knowledge_base_fragments
magic-service | Migrating: 2025_03_29_203243_update_knowledge_bases
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:11.65] alter table `magic_flow_knowledge` add `word_count` bigint unsigned not null default '0' comment '字数统计']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:1.9] insert into `migrations` (`migration`, `batch`) values ('2025_03_29_203243_update_knowledge_bases', '1')]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_03_29_203243_update_knowledge_bases
magic-service | Migrating: 2025_03_31_110014_add_field_service_provider_models_table
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:13.27] alter table `service_provider_models` add `model_parent_id` bigint not null default '0' comment '依赖的model_id，有些模型信息依赖其他模型']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:1.42] insert into `migrations` (`migration`, `batch`) values ('2025_03_31_110014_add_field_service_provider_models_table', '1')]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_03_31_110014_add_field_service_provider_models_table
magic-service | Migrating: 2025_04_01_000000_add_icon_to_knowledge_base_table
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:12.35] alter table `magic_flow_knowledge` add `icon` varchar(255) not null default '' comment '图标']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:1.12] insert into `migrations` (`migration`, `batch`) values ('2025_04_01_000000_add_icon_to_knowledge_base_table', '1')]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_04_01_000000_add_icon_to_knowledge_base_table
magic-service | Migrating: 2025_04_03_140930_add_filed_magic_bots_table
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:1.01] select `column_key` as `column_key`, `column_name` as `column_name`, `data_type` as `data_type`, `column_comment` as `column_comment`, `extra` as `extra`, `column_type` as `column_type` from information_schema.columns where `table_schema` = 'magic' and `table_name` = 'magic_bots' order by ORDINAL_POSITION]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:11.15] alter table `magic_bots` add `start_page` tinyint(1) not null default '0' comment '启动页开关']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:1.1] insert into `migrations` (`migration`, `batch`) values ('2025_04_03_140930_add_filed_magic_bots_table', '1')]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_04_03_140930_add_filed_magic_bots_table
magic-service | Migrating: 2025_04_03_201425_add_index_service_provider_models_table
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:6.1] alter table `service_provider_models` add index `service_provider_models_model_parent_id_status_index`(`model_parent_id`, `status`)]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:1.37] insert into `migrations` (`migration`, `batch`) values ('2025_04_03_201425_add_index_service_provider_models_table', '1')]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_04_03_201425_add_index_service_provider_models_table
magic-service | Migrating: 2025_04_03_201650_add_field_service_provider_models_table
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:17.75] alter table `service_provider_models` add `visible_organizations` json not null default (JSON_ARRAY()) comment '模型可见的组织编码']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:1.16] insert into `migrations` (`migration`, `batch`) values ('2025_04_03_201650_add_field_service_provider_models_table', '1')]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_04_03_201650_add_field_service_provider_models_table
magic-service | Migrating: 2025_04_06_011435_add_is_office_to_service_provider_models_table
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:12.32] alter table `service_provider_models` add `is_office` tinyint not null default '0' comment '是否为官方模型：0-否，1-是']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:1.02] insert into `migrations` (`migration`, `batch`) values ('2025_04_06_011435_add_is_office_to_service_provider_models_table', '1')]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_04_06_011435_add_is_office_to_service_provider_models_table
magic-service | Migrating: 2025_04_09_212635_modify_knowledge_base_documents_unique_index
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:4.55] alter table `knowledge_base_documents` drop index `unique_code_version`]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:6.68] alter table `knowledge_base_documents` add unique `unique_knowledge_base_code_code_version`(`knowledge_base_code`, `code`, `version`)]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:1.15] insert into `migrations` (`migration`, `batch`) values ('2025_04_09_212635_modify_knowledge_base_documents_unique_index', '1')]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_04_09_212635_modify_knowledge_base_documents_unique_index
magic-service | Migrating: 2025_04_12_212635_modify_service_provider_models_index
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:1.48] select index_name as `name`, group_concat(column_name order by seq_in_index) as `columns`, index_type as `type`, not non_unique as `unique` from information_schema.statistics where table_schema = 'magic' and table_name = 'service_provider_models' group by index_name, index_type, non_unique]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:0.83] select index_name as `name`, group_concat(column_name order by seq_in_index) as `columns`, index_type as `type`, not non_unique as `unique` from information_schema.statistics where table_schema = 'magic' and table_name = 'service_provider_models' group by index_name, index_type, non_unique]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:5.34] alter table `service_provider_models` add index `idx_model_id_status_organization_code`(`model_id`, `status`, `organization_code`)]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:7.75] alter table `service_provider_models` add index `idx_organization_code_status_model_version`(`organization_code`, `status`, `model_version`)]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:0.95] insert into `migrations` (`migration`, `batch`) values ('2025_04_12_212635_modify_service_provider_models_index', '1')]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_04_12_212635_modify_service_provider_models_index
magic-service | Migrating: 2025_04_22_000000_create_knowledge_base_parent_fragments
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:5.5] create table `knowledge_base_parent_fragments` (`id` bigint unsigned not null auto_increment primary key, `knowledge_base_code` varchar(255) not null, `knowledge_base_document_code` varchar(255) not null comment '关联知识库文档code', `organization_code` varchar(255) not null comment '组织编码', `created_uid` varchar(255) not null comment '创建者ID', `updated_uid` varchar(255) not null comment '更新者ID', `created_at` datetime null, `updated_at` datetime null, `deleted_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:6.45] alter table `knowledge_base_parent_fragments` add index `index_knowledge_base_code_document_code`(`knowledge_base_code`, `knowledge_base_document_code`)]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:1.48] insert into `migrations` (`migration`, `batch`) values ('2025_04_22_000000_create_knowledge_base_parent_fragments', '1')]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_04_22_000000_create_knowledge_base_parent_fragments
magic-service | Migrating: 2025_04_22_000001_add_parent_fragment_id_to_knowledge_base_fragments
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:0.86] select `column_key` as `column_key`, `column_name` as `column_name`, `data_type` as `data_type`, `column_comment` as `column_comment`, `extra` as `extra`, `column_type` as `column_type` from information_schema.columns where `table_schema` = 'magic' and `table_name` = 'magic_flow_knowledge_fragment' order by ORDINAL_POSITION]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:12.07] alter table `magic_flow_knowledge_fragment` add `parent_fragment_id` bigint unsigned null comment '父片段id']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:5.59] alter table `magic_flow_knowledge_fragment` add index `magic_flow_knowledge_fragment_parent_fragment_id_index`(`parent_fragment_id`)]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:1.05] insert into `migrations` (`migration`, `batch`) values ('2025_04_22_000001_add_parent_fragment_id_to_knowledge_base_fragments', '1')]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_04_22_000001_add_parent_fragment_id_to_knowledge_base_fragments
magic-service | Migrating: 2025_04_22_000002_update_knowledge_bases
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:0.77] select `column_key` as `column_key`, `column_name` as `column_name`, `data_type` as `data_type`, `column_comment` as `column_comment`, `extra` as `extra`, `column_type` as `column_type` from information_schema.columns where `table_schema` = 'magic' and `table_name` = 'magic_flow_knowledge' order by ORDINAL_POSITION]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:0.99] select `column_key` as `column_key`, `column_name` as `column_name`, `data_type` as `data_type`, `column_comment` as `column_comment`, `extra` as `extra`, `column_type` as `column_type` from information_schema.columns where `table_schema` = 'magic' and `table_name` = 'magic_flow_knowledge' order by ORDINAL_POSITION]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:1.21] select `column_key` as `column_key`, `column_name` as `column_name`, `data_type` as `data_type`, `column_comment` as `column_comment`, `extra` as `extra`, `column_type` as `column_type` from information_schema.columns where `table_schema` = 'magic' and `table_name` = 'magic_flow_knowledge' order by ORDINAL_POSITION]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:13.79] alter table `magic_flow_knowledge` add `fragment_config` varchar(2000) null comment '分段配置', add `embedding_config` varchar(2000) null comment '嵌入配置', add `is_draft` tinyint not null default '0' comment '是否为草稿']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:1.25] insert into `migrations` (`migration`, `batch`) values ('2025_04_22_000002_update_knowledge_bases', '1')]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_04_22_000002_update_knowledge_bases
magic-service | Migrating: 2025_04_23_151055_add_field_service_provider_models_table
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:15.04] alter table `service_provider_models` add `disabled_by` varchar(20) not null default '' comment '禁用来源：OFFICIAL-官方禁用，USER-用户禁用，空字符串-未禁用' after `status`]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:1] insert into `migrations` (`migration`, `batch`) values ('2025_04_23_151055_add_field_service_provider_models_table', '1')]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_04_23_151055_add_field_service_provider_models_table
magic-service | Migrating: 2025_04_24_000000_add_document_file_to_knowledge_base_documents
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:13.23] alter table `knowledge_base_documents` add `document_file` json null comment '文档文件信息']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:1.19] insert into `migrations` (`migration`, `batch`) values ('2025_04_24_000000_add_document_file_to_knowledge_base_documents', '1')]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_04_24_000000_add_document_file_to_knowledge_base_documents
magic-service | Migrating: 2025_04_25_000000_add_version_to_magic_flow_knowledge_fragment
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:0.8] select `column_key` as `column_key`, `column_name` as `column_name`, `data_type` as `data_type`, `column_comment` as `column_comment`, `extra` as `extra`, `column_type` as `column_type` from information_schema.columns where `table_schema` = 'magic' and `table_name` = 'magic_flow_knowledge_fragment' order by ORDINAL_POSITION]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:13.35] alter table `magic_flow_knowledge_fragment` add `version` int unsigned not null default '1' comment '版本号']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:0.88] select index_name as `name`, group_concat(column_name order by seq_in_index) as `columns`, index_type as `type`, not non_unique as `unique` from information_schema.statistics where table_schema = 'magic' and table_name = 'magic_flow_knowledge_fragment' group by index_name, index_type, non_unique]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:0.61] select index_name as `name`, group_concat(column_name order by seq_in_index) as `columns`, index_type as `type`, not non_unique as `unique` from information_schema.statistics where table_schema = 'magic' and table_name = 'magic_flow_knowledge_fragment' group by index_name, index_type, non_unique]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:6.03] alter table `magic_flow_knowledge_fragment` add index `idx_knowledge_document_version`(`knowledge_code`, `document_code`, `version`)]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:0.91] insert into `migrations` (`migration`, `batch`) values ('2025_04_25_000000_add_version_to_magic_flow_knowledge_fragment', '1')]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_04_25_000000_add_version_to_magic_flow_knowledge_fragment
magic-service | Migrating: 2025_05_08_144352_update_magic_chat_message_versions
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:0.77] SELECT [敏感数据] FROM magic_chat_message_versions [查询已脱敏]]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:14.62] alter table `magic_chat_message_versions` add `message_type` varchar(64) null comment '消息类型']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:1.34] insert into `migrations` (`migration`, `batch`) values ('2025_05_08_144352_update_magic_chat_message_versions', '1')]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_05_08_144352_update_magic_chat_message_versions
magic-service | Migrating: 2025_05_13_000001_add_third_platform_fields_to_knowledge_base_documents
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:13.19] alter table `knowledge_base_documents` add `third_platform_type` varchar(255) null comment '第三方平台类型', add `third_file_id` varchar(255) null comment '第三方文件ID']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:6.26] alter table `knowledge_base_documents` add index `index_third_platform_type_id`(`third_platform_type`, `third_file_id`)]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:1.8] insert into `migrations` (`migration`, `batch`) values ('2025_05_13_000001_add_third_platform_fields_to_knowledge_base_documents', '1')]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_05_13_000001_add_third_platform_fields_to_knowledge_base_documents
magic-service | Migrating: 2025_05_14_160532_create_m_c_p_servers_table
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:6.94] create table `magic_mcp_servers` (`id` bigint unsigned not null auto_increment primary key, `organization_code` varchar(32) not null comment '组织编码', `code` varchar(80) not null comment '唯一编码', `name` varchar(64) not null default '' comment 'MCP服务名称', `description` varchar(255) not null default '' comment 'MCP服务描述', `icon` varchar(255) not null default '' comment 'MCP服务图标', `type` varchar(16) not null default 'sse' comment '服务类型: sse或stdio', `enabled` tinyint(1) not null default '0' comment '是否启用: 0-禁用, 1-启用', `creator` varchar(64) not null default '' comment '创建者', `created_at` datetime not null comment '创建时间', `modifier` varchar(64) not null default '' comment '修改者', `updated_at` datetime not null comment '更新时间', `deleted_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:5.46] alter table `magic_mcp_servers` add unique `magic_mcp_servers_organization_code_code_unique`(`organization_code`, `code`)]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:5.72] alter table `magic_mcp_servers` add unique `magic_mcp_servers_code_unique`(`code`)]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:1.23] insert into `migrations` (`migration`, `batch`) values ('2025_05_14_160532_create_m_c_p_servers_table', '1')]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_05_14_160532_create_m_c_p_servers_table
magic-service | Migrating: 2025_05_16_155124_create_m_c_p_server_tools_table
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:8.37] create table `magic_mcp_server_tools` (`id` bigint unsigned not null auto_increment primary key, `organization_code` varchar(32) not null comment '组织编码', `mcp_server_code` varchar(80) not null comment '关联的 mcp 服务 code', `name` varchar(64) not null default '' comment '工具名称', `description` varchar(512) not null default '' comment '工具描述', `source` tinyint not null default '0' comment '工具来源', `rel_code` varchar(80) not null default '' comment '关联的工具 code', `rel_version_code` varchar(80) not null default '' comment '关联的工具版本 code', `rel_info` json null comment '关联的信息', `version` varchar(80) not null default '' comment '工具版本', `enabled` tinyint(1) not null default '0' comment '是否启用: 0-禁用, 1-启用', `options` json null comment '工具配置 name、description、inputSchema', `creator` varchar(64) not null default '' comment '创建者', `created_at` datetime not null comment '创建时间', `modifier` varchar(64) not null default '' comment '修改者', `updated_at` datetime not null comment '更新时间') default character set utf8mb4 collate 'utf8mb4_unicode_ci']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:5.35] alter table `magic_mcp_server_tools` add index `magic_mcp_server_tools_mcp_server_code_index`(`mcp_server_code`)]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:1] insert into `migrations` (`migration`, `batch`) values ('2025_05_16_155124_create_m_c_p_server_tools_table', '1')]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_05_16_155124_create_m_c_p_server_tools_table
magic-service | Migrating: 2025_05_23_000001_add_source_type_to_knowledge_bases
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:1.12] select `column_key` as `column_key`, `column_name` as `column_name`, `data_type` as `data_type`, `column_comment` as `column_comment`, `extra` as `extra`, `column_type` as `column_type` from information_schema.columns where `table_schema` = 'magic' and `table_name` = 'magic_flow_knowledge' order by ORDINAL_POSITION]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:13.58] alter table `magic_flow_knowledge` add `source_type` int null comment '数据源类型']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:1.47] insert into `migrations` (`migration`, `batch`) values ('2025_05_23_000001_add_source_type_to_knowledge_bases', '1')]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_05_23_000001_add_source_type_to_knowledge_bases
magic-service | Migrating: 2025_05_23_161154_m_c_p_tools_version_change_length
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:3.48] ALTER TABLE magic_mcp_server_tools CHANGE version version VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT '' NOT NULL COLLATE `utf8mb4_unicode_ci` COMMENT '工具版本']{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:1.02] insert into `migrations` (`migration`, `batch`) values ('2025_05_23_161154_m_c_p_tools_version_change_length', '1')]{"system_info":{"request_id":811252688162394112,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_05_23_161154_m_c_p_tools_version_change_length
magic-service | PHP Warning: PHP Startup: Swow pdo_pgsql hook not enabled, libpq.so not found, (search paths: ) in Unknown on line 0
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:3.37] select * from information_schema.tables where table_schema = 'magic' and table_name = 'migrations']{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:0.77] select `migration` from `migrations` order by `batch` asc, `migration` asc]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:0.36] select max(`batch`) as aggregate from `migrations`]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | Migrating: 2025_03_21_000001_create_magic_super_agent_message
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:0.64] select * from information_schema.tables where table_schema = 'magic' and table_name = 'magic_super_agent_message']{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:6.56] create table `magic_super_agent_message` (`id` bigint unsigned not null auto_increment primary key, `sender_type` varchar(32) not null comment '发送者类型(user/ai)', `sender_uid` varchar(64) not null comment '发送者ID', `receiver_uid` varchar(64) not null comment '接收者ID', `message_id` varchar(64) not null comment '消息ID', `type` varchar(32) not null comment '消息类型', `task_id` varchar(64) not null comment '任务ID', `topic_id` bigint null comment '话题ID', `status` varchar(32) null comment '任务状态', `content` text not null comment '消息内容', `steps` json null comment '步骤信息', `tool` json null comment '工具调用信息', `event` varchar(64) not null comment '事件类型', `send_timestamp` int not null comment '发送时间戳', `created_at` timestamp null, `updated_at` timestamp null, `deleted_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci']{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:5.94] alter table `magic_super_agent_message` add index `idx_task_type`(`task_id`, `type`)]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:5.37] alter table `magic_super_agent_message` add index `idx_sender_created`(`sender_uid`, `created_at`)]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:4.78] alter table `magic_super_agent_message` add index `idx_receiver_created`(`receiver_uid`, `created_at`)]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:6.92] alter table `magic_super_agent_message` add unique `magic_super_agent_message_message_id_unique`(`message_id`)]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:0.99] insert into `migrations` (`migration`, `batch`) values ('2025_03_21_000001_create_magic_super_agent_message', '2')]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_03_21_000001_create_magic_super_agent_message
magic-service | Migrating: 2025_03_29_120000_create_magic_super_agent_workspaces_table
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:0.98] select * from information_schema.tables where table_schema = 'magic' and table_name = 'magic_super_agent_workspaces']{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:6.95] create table `magic_super_agent_workspaces` (`id` bigint unsigned not null auto_increment primary key, `user_id` varchar(64) not null comment '用户id', `user_organization_code` varchar(64) not null comment '用户组织编码', `chat_conversation_id` varchar(64) not null comment '聊天会话id', `name` varchar(64) not null comment '工作区名称', `is_archived` tinyint not null default '0' comment '是否归档 0否 1是', `created_uid` varchar(64) not null default '' comment '创建者用户ID', `updated_uid` varchar(64) not null default '' comment '更新者用户ID', `created_at` datetime null, `updated_at` datetime null, `deleted_at` timestamp null, `current_topic_id` bigint unsigned null comment '当前话题ID', `status` tinyint not null default '0' comment '状态 0:正常 1:不显示 2：删除') default character set utf8mb4 collate 'utf8mb4_unicode_ci']{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:5.66] alter table `magic_super_agent_workspaces` add index `idx_user_id`(`user_id`)]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:5.5] alter table `magic_super_agent_workspaces` add index `idx_chat_conversation_id`(`chat_conversation_id`)]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:1.88] insert into `migrations` (`migration`, `batch`) values ('2025_03_29_120000_create_magic_super_agent_workspaces_table', '2')]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_03_29_120000_create_magic_super_agent_workspaces_table
magic-service | Migrating: 2025_03_31_000001_create_magic_super_agent_task_files_table
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:0.73] select * from information_schema.tables where table_schema = 'magic' and table_name = 'magic_super_agent_task_files']{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:5.7] create table `magic_super_agent_task_files` (`file_id` bigint unsigned not null auto_increment primary key comment '主键', `user_id` varchar(128) not null comment 'user_id', `organization_code` varchar(64) not null comment '组织编码', `topic_id` bigint not null comment 'magic_general_agent_topics 的id', `task_id` bigint not null comment 'magic_general_agent_task 的id', `file_type` varchar(32) not null default '' comment '文件类型', `file_name` varchar(256) not null default '' comment '文件名', `file_extension` varchar(32) not null default '' comment '文件扩展名', `file_key` varchar(255) not null default '' comment '文件存储路径', `file_size` bigint unsigned not null default '0' comment '文件大小', `external_url` varchar(1024) not null default '' comment '外链地址', `deleted_at` timestamp null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci']{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:6.36] alter table `magic_super_agent_task_files` add index `idx_topic_id`(`topic_id`)]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:5.08] alter table `magic_super_agent_task_files` add index `idx_task_id`(`task_id`)]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:5.04] alter table `magic_super_agent_task_files` add index `idx_user_id`(`user_id`)]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:1.33] insert into `migrations` (`migration`, `batch`) values ('2025_03_31_000001_create_magic_super_agent_task_files_table', '2')]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_03_31_000001_create_magic_super_agent_task_files_table
magic-service | Migrating: 2025_03_31_000002_create_magic_super_agent_topics_table
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:1] select * from information_schema.tables where table_schema = 'magic' and table_name = 'magic_super_agent_topics']{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:6.71] create table `magic_super_agent_topics` (`id` bigint unsigned not null auto_increment primary key, `user_id` varchar(64) not null default '' comment '用户ID', `workspace_id` bigint unsigned not null default '0' comment '工作区ID', `chat_conversation_id` varchar(64) not null default '' comment 'chat的会话id', `chat_topic_id` varchar(64) not null default '' comment 'chat的话题id', `sandbox_id` varchar(64) not null default '' comment '沙箱id', `current_task_id` varchar(64) not null default '' comment '当前任务id', `current_task_status` varchar(64) not null default '' comment '当前任务状态 waiting, running，finished，error', `topic_name` varchar(64) not null default '' comment '话题名称', `work_dir` varchar(255) not null default '' comment '工作区目录', `created_uid` varchar(64) not null default '' comment '创建者用户ID', `updated_uid` varchar(64) not null default '' comment '更新者用户ID', `created_at` datetime null, `updated_at` datetime null, `deleted_at` timestamp null comment '删除时间') default character set utf8mb4 collate 'utf8mb4_unicode_ci']{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:5.46] alter table `magic_super_agent_topics` add index `idx_user_workspace`(`user_id`, `workspace_id`)]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:1.12] insert into `migrations` (`migration`, `batch`) values ('2025_03_31_000002_create_magic_super_agent_topics_table', '2')]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_03_31_000002_create_magic_super_agent_topics_table
magic-service | Migrating: 2025_03_31_000003_create_magic_super_agent_tasks_table
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:1.16] select * from information_schema.tables where table_schema = 'magic' and table_name = 'magic_super_agent_task']{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:7.42] create table `magic_super_agent_task` (`id` bigint unsigned not null auto_increment primary key, `user_id` varchar(64) not null comment '用户id。', `workspace_id` bigint unsigned not null comment '工作区id。', `topic_id` bigint unsigned not null comment '话题id。', `task_id` varchar(64) not null comment '任务id。沙箱服务返回的', `sandbox_id` varchar(64) not null comment '沙箱id。', `prompt` varchar(5000) not null comment '用户的问题。', `attachments` varchar(500) not null comment '用户上传的附件信息。用 json格式存储', `task_status` varchar(64) not null comment '任务状态 waiting, running，finished，error', `work_dir` varchar(255) not null comment '工作区目录', `created_at` timestamp null, `updated_at` timestamp null, `deleted_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci']{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:5.86] alter table `magic_super_agent_task` add index `idx_user_workspace`(`user_id`, `workspace_id`)]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:1.04] insert into `migrations` (`migration`, `batch`) values ('2025_03_31_000003_create_magic_super_agent_tasks_table', '2')]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_03_31_000003_create_magic_super_agent_tasks_table
magic-service | Migrating: 2025_04_01_000001_create_resource_shares_table
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:1.56] select * from information_schema.tables where table_schema = 'magic' and table_name = 'magic_resource_shares']{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:7.55] create table `magic_resource_shares` (`id` bigint unsigned not null auto_increment primary key, `resource_id` varchar(64) not null comment '资源ID', `resource_type` tinyint unsigned not null comment '资源类型', `resource_name` varchar(255) not null comment '资源名称', `share_code` varchar(64) not null comment '分享代码', `share_type` tinyint unsigned not null comment '分享类型', `password` varchar(64) null comment '访问密码', `expire_at` timestamp null comment '过期时间', `view_count` int unsigned not null default '0' comment '查看次数', `created_uid` varchar(64) not null default '' comment '创建者用户ID', `updated_uid` varchar(64) not null default '' comment '更新者用户ID', `organization_code` varchar(64) not null comment '组织代码', `target_ids` json null comment '目标IDs', `created_at` timestamp null, `updated_at` timestamp null, `deleted_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci']{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:8.73] alter table `magic_resource_shares` add index `magic_resource_shares_resource_id_index`(`resource_id`)]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:8.1] alter table `magic_resource_shares` add index `magic_resource_shares_resource_type_resource_id_index`(`resource_type`, `resource_id`)]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:8.39] alter table `magic_resource_shares` add index `magic_resource_shares_created_uid_organization_code_index`(`created_uid`, `organization_code`)]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:8.93] alter table `magic_resource_shares` add index `magic_resource_shares_created_at_index`(`created_at`)]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:6.54] alter table `magic_resource_shares` add index `magic_resource_shares_expire_at_index`(`expire_at`)]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:7.53] alter table `magic_resource_shares` add unique `magic_resource_shares_share_code_unique`(`share_code`)]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:1.19] insert into `migrations` (`migration`, `batch`) values ('2025_04_01_000001_create_resource_shares_table', '2')]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_04_01_000001_create_resource_shares_table
magic-service | Migrating: 2025_04_12_000001_add_attachments_to_magic_super_agent_message
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:19.93] alter table `magic_super_agent_message` add `attachments` json null comment '附件信息' after `tool`]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:36][sql][[default:1.68] insert into `migrations` (`migration`, `batch`) values ('2025_04_12_000001_add_attachments_to_magic_super_agent_message', '2')]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_04_12_000001_add_attachments_to_magic_super_agent_message
magic-service | Migrating: 2025_04_13_000001_add_sandbox_config_to_magic_super_agent_topics
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:18.59] alter table `magic_super_agent_topics` add `sandbox_config` json null comment '沙箱配置信息' after `sandbox_id`]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:1.16] insert into `migrations` (`migration`, `batch`) values ('2025_04_13_000001_add_sandbox_config_to_magic_super_agent_topics', '2')]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_04_13_000001_add_sandbox_config_to_magic_super_agent_topics
magic-service | Migrating: 2025_04_14_000001_add_menu_to_magic_super_task_files_table
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:13.29] alter table `magic_super_agent_task_files` add `menu` varchar(255) null comment '菜单信息']{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:1.2] insert into `migrations` (`migration`, `batch`) values ('2025_04_14_000001_add_menu_to_magic_super_task_files_table', '2')]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_04_14_000001_add_menu_to_magic_super_task_files_table
magic-service | Migrating: 2025_04_15_000001_change_attachments_to_json_in_magic_super_agent_tasks_table
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:4.13] ALTER TABLE magic_super_agent_task CHANGE attachments attachments VARCHAR(5000) CHARACTER SET utf8mb4 NOT NULL COLLATE `utf8mb4_unicode_ci` COMMENT '用户上传的附件信息。用 json格式存储']{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:1.26] insert into `migrations` (`migration`, `batch`) values ('2025_04_15_000001_change_attachments_to_json_in_magic_super_agent_tasks_table', '2')]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_04_15_000001_change_attachments_to_json_in_magic_super_agent_tasks_table
magic-service | Migrating: 2025_04_23_213016_add_task_mode_to_magic_super_agent_topics_table
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.81] select `column_key` as `column_key`, `column_name` as `column_name`, `data_type` as `data_type`, `column_comment` as `column_comment`, `extra` as `extra`, `column_type` as `column_type` from information_schema.columns where `table_schema` = 'magic' and `table_name` = 'magic_super_agent_topics' order by ORDINAL_POSITION]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:11.57] alter table `magic_super_agent_topics` add `task_mode` varchar(50) not null default 'chat' comment '聊天模式: chat-聊天模式, plan-规划模式']{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:2.13] insert into `migrations` (`migration`, `batch`) values ('2025_04_23_213016_add_task_mode_to_magic_super_agent_topics_table', '2')]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_04_23_213016_add_task_mode_to_magic_super_agent_topics_table
magic-service | Migrating: 2025_04_23_213744_add_task_mode_to_magic_super_agent_task_table
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.8] select `column_key` as `column_key`, `column_name` as `column_name`, `data_type` as `data_type`, `column_comment` as `column_comment`, `extra` as `extra`, `column_type` as `column_type` from information_schema.columns where `table_schema` = 'magic' and `table_name` = 'magic_super_agent_task' order by ORDINAL_POSITION]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:11.56] alter table `magic_super_agent_task` add `task_mode` varchar(50) not null default 'chat' comment '聊天模式: chat-聊天模式, plan-规划模式']{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.95] insert into `migrations` (`migration`, `batch`) values ('2025_04_23_213744_add_task_mode_to_magic_super_agent_task_table', '2')]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_04_23_213744_add_task_mode_to_magic_super_agent_task_table
magic-service | Migrating: 2025_04_24_000001_add_err_msg_to_magic_super_agent_task_table
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:1.03] select `column_key` as `column_key`, `column_name` as `column_name`, `data_type` as `data_type`, `column_comment` as `column_comment`, `extra` as `extra`, `column_type` as `column_type` from information_schema.columns where `table_schema` = 'magic' and `table_name` = 'magic_super_agent_task' order by ORDINAL_POSITION]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:10.53] alter table `magic_super_agent_task` add `err_msg` varchar(500) null comment '错误信息']{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:1.05] insert into `migrations` (`migration`, `batch`) values ('2025_04_24_000001_add_err_msg_to_magic_super_agent_task_table', '2')]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_04_24_000001_add_err_msg_to_magic_super_agent_task_table
magic-service | Migrating: 2025_05_06_213343_magic_super_agent_task_files_add_storage_type_field
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:13.11] alter table `magic_super_agent_task_files` add `storage_type` varchar(32) not null default 'workspace' comment '存储类型']{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:1.1] insert into `migrations` (`migration`, `batch`) values ('2025_05_06_213343_magic_super_agent_task_files_add_storage_type_field', '2')]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_05_06_213343_magic_super_agent_task_files_add_storage_type_field
magic-service | Migrating: 2025_05_10_000001_add_user_organization_code_to_magic_super_agent_topics_table
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:1.07] select `column_key` as `column_key`, `column_name` as `column_name`, `data_type` as `data_type`, `column_comment` as `column_comment`, `extra` as `extra`, `column_type` as `column_type` from information_schema.columns where `table_schema` = 'magic' and `table_name` = 'magic_super_agent_topics' order by ORDINAL_POSITION]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:10.93] alter table `magic_super_agent_topics` add `user_organization_code` varchar(64) not null default '' comment '用户组织编码' after `user_id`]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:1.39] insert into `migrations` (`migration`, `batch`) values ('2025_05_10_000001_add_user_organization_code_to_magic_super_agent_topics_table', '2')]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_05_10_000001_add_user_organization_code_to_magic_super_agent_topics_table
magic-service | Migrating: 2025_05_10_000002_add_show_in_ui_to_magic_super_agent_message_table
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:13.46] alter table `magic_super_agent_message` add `show_in_ui` tinyint not null default '1' comment '是否在UI中显示，1是，0否']{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:1.18] insert into `migrations` (`migration`, `batch`) values ('2025_05_10_000002_add_show_in_ui_to_magic_super_agent_message_table', '2')]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_05_10_000002_add_show_in_ui_to_magic_super_agent_message_table
magic-service | Migrating: 2025_05_15_000001_add_is_hidden_to_magic_super_agent_task_files_table
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:14.66] alter table `magic_super_agent_task_files` add `is_hidden` tinyint not null default '0' comment '是否为隐藏文件：0-否，1-是']{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:1.19] insert into `migrations` (`migration`, `batch`) values ('2025_05_15_000001_add_is_hidden_to_magic_super_agent_task_files_table', '2')]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_05_15_000001_add_is_hidden_to_magic_super_agent_task_files_table
magic-service | Migrating: 2025_05_27_000001_create_magic_super_agent_token_usage_records
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.75] select * from information_schema.tables where table_schema = 'magic' and table_name = 'magic_super_agent_token_usage_records']{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:5.82] create table `magic_super_agent_token_usage_records` (`id` bigint unsigned not null auto_increment primary key, `topic_id` bigint not null comment '话题ID', `task_id` varchar(64) not null comment '任务ID', `sandbox_id` varchar(64) null comment '沙箱ID', `organization_code` varchar(64) not null comment '组织代码', `user_id` varchar(64) not null comment '用户ID', `task_status` varchar(32) not null comment '任务状态', `usage_type` varchar(32) not null comment '使用类型(summary/item)', `total_input_tokens` int null default '0' comment '总输入token数', `total_output_tokens` int null default '0' comment '总输出token数', `total_tokens` int null default '0' comment '总token数', `model_id` varchar(128) null comment '模型ID', `model_name` varchar(128) null comment '模型名称', `cached_tokens` int null default '0' comment '缓存token数', `cache_write_tokens` int null default '0' comment '缓存写入token数', `reasoning_tokens` int null default '0' comment '推理token数', `usage_details` json null comment '完整的使用详情JSON', `created_at` timestamp null, `updated_at` timestamp null, `deleted_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci']{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:6.51] alter table `magic_super_agent_token_usage_records` add index `idx_task_topic`(`task_id`, `topic_id`)]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:5.7] alter table `magic_super_agent_token_usage_records` add index `idx_org_user_created`(`organization_code`, `user_id`, `created_at`)]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:7.84] alter table `magic_super_agent_token_usage_records` add index `idx_created_at`(`created_at`)]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:6.21] alter table `magic_super_agent_token_usage_records` add index `idx_usage_type`(`usage_type`)]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:1.02] insert into `migrations` (`migration`, `batch`) values ('2025_05_27_000001_create_magic_super_agent_token_usage_records', '2')]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_05_27_000001_create_magic_super_agent_token_usage_records
magic-service | Migrating: 2025_05_29_000001_add_performance_indexes_to_magic_super_agent_message_table
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:1.34] select * from information_schema.tables where table_schema = 'magic' and table_name = 'magic_super_agent_message']{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.8] select index_name as `name`, group_concat(column_name order by seq_in_index) as `columns`, index_type as `type`, not non_unique as `unique` from information_schema.statistics where table_schema = 'magic' and table_name = 'magic_super_agent_message' group by index_name, index_type, non_unique]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.59] select index_name as `name`, group_concat(column_name order by seq_in_index) as `columns`, index_type as `type`, not non_unique as `unique` from information_schema.statistics where table_schema = 'magic' and table_name = 'magic_super_agent_message' group by index_name, index_type, non_unique]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:5.79] alter table `magic_super_agent_message` add index `idx_id`(`id`)]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:6.71] alter table `magic_super_agent_message` add index `idx_topic_show_deleted`(`topic_id`, `show_in_ui`, `deleted_at`)]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:1.57] insert into `migrations` (`migration`, `batch`) values ('2025_05_29_000001_add_performance_indexes_to_magic_super_agent_message_table', '2')]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_05_29_000001_add_performance_indexes_to_magic_super_agent_message_table
magic-service | Migrating: 2025_05_29_215711_add_message_id_index_to_magic_super_agent_message
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.88] select * from information_schema.tables where table_schema = 'magic' and table_name = 'magic_super_agent_message']{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.78] select index_name as `name`, group_concat(column_name order by seq_in_index) as `columns`, index_type as `type`, not non_unique as `unique` from information_schema.statistics where table_schema = 'magic' and table_name = 'magic_super_agent_message' group by index_name, index_type, non_unique]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:12.13] alter table `magic_super_agent_message` add index `idx_message_id`(`message_id`)]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:1.74] insert into `migrations` (`migration`, `batch`) values ('2025_05_29_215711_add_message_id_index_to_magic_super_agent_message', '2')]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_05_29_215711_add_message_id_index_to_magic_super_agent_message
magic-service | Migrating: 2025_06_03_000003_add_unique_index_to_token_usage_records
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:1.66] select * from information_schema.tables where table_schema = 'magic' and table_name = 'magic_super_agent_token_usage_records']{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.83] select index_name as `name`, group_concat(column_name order by seq_in_index) as `columns`, index_type as `type`, not non_unique as `unique` from information_schema.statistics where table_schema = 'magic' and table_name = 'magic_super_agent_token_usage_records' group by index_name, index_type, non_unique]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:8.41] alter table `magic_super_agent_token_usage_records` add unique `idx_token_usage_unique`(`topic_id`, `task_id`, `sandbox_id`, `model_id`)]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:1.64] insert into `migrations` (`migration`, `batch`) values ('2025_06_03_000003_add_unique_index_to_token_usage_records', '2')]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_06_03_000003_add_unique_index_to_token_usage_records
magic-service | Migrating: 2025_06_05_142500_add_cost_to_magic_super_agent_topics_table
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:15.44] alter table `magic_super_agent_topics` add `cost` decimal(10, 4) not null default '0' comment 'Topic cost amount' after `task_mode`]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:1.11] insert into `migrations` (`migration`, `batch`) values ('2025_06_05_142500_add_cost_to_magic_super_agent_topics_table', '2')]{"system_info":{"request_id":811252703136067584,"coroutine_id":1,"trace_id":""}}
magic-service | Migrated: 2025_06_05_142500_add_cost_to_magic_super_agent_topics_table
magic-service | migrate: vendor/dtyq/super-magic-module/migrations
magic-service | Initializing magic-service for the first time...
magic-service | PHP Warning: PHP Startup: Swow pdo_pgsql hook not enabled, libpq.so not found, (search paths: ) in Unknown on line 0
magic-service | Seed: initial_account_and_user_seeder
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.72] select * from `magic_contact_accounts` where `type` = '1' and (`phone` = '13812345678' or `email` = '[email protected]') limit 1]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.52] insert into `magic_contact_accounts` (`magic_id`, `type`, `status`, `country_code`, `phone`, `email`, `password`, `real_name`, `gender`, `created_at`, `updated_at`) values ('811252707137437696', '1', '0', '86', '13812345678', '[email protected]', '629c32592f44a00096ace3d29955b81ba9e3e29659c3e513471974c17a3c8307', '管理员', '1', '2025-08-05 15:08:37', '2025-08-05 15:08:37')]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | 已创建新账号: 管理员, ID: 1, Magic ID: 811252707137437696
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:1.18] select * from `magic_contact_accounts` where `type` = '1' and (`phone` = '13912345678' or `email` = '[email protected]') limit 1]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.71] insert into `magic_contact_accounts` (`magic_id`, `type`, `status`, `country_code`, `phone`, `email`, `password`, `real_name`, `gender`, `created_at`, `updated_at`) values ('811252707145826305', '1', '0', '86', '13912345678', '[email protected]', '629c32592f44a00096ace3d29955b81ba9e3e29659c3e513471974c17a3c8307', '普通用户', '2', '2025-08-05 15:08:37', '2025-08-05 15:08:37')]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | 已创建新账号: 普通用户, ID: 2, Magic ID: 811252707145826305
magic-service | 已创建 2 个新账号, IDs: 1, 2
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.38] select * from `magic_contact_users` where `magic_id` = '811252707137437696' and `organization_code` = 'test001' limit 1]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.38] insert into `magic_contact_users` (`magic_id`, `organization_code`, `user_id`, `user_type`, `status`, `nickname`, `i18n_name`, `avatar_url`, `description`, `created_at`, `updated_at`) values ('811252707137437696', 'test001', 'usi_21bb9990967506c35521ddcb25751693', '1', '1', '管理员1', '{"zh-CN":"\u7ba1\u7406\u54581","en-US":"Admin1"}', '', '这是管理员的用户账号', '2025-08-05 15:08:37', '2025-08-05 15:08:37')]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | 已为账号 811252707137437696 在组织 test001 下创建用户
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.55] select * from `magic_contact_users` where `magic_id` = '811252707137437696' and `organization_code` = 'test002' limit 1]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.43] insert into `magic_contact_users` (`magic_id`, `organization_code`, `user_id`, `user_type`, `status`, `nickname`, `i18n_name`, `avatar_url`, `description`, `created_at`, `updated_at`) values ('811252707137437696', 'test002', 'usi_6cd75263aa60cd2f5916e45a511629aa', '1', '1', '管理员2', '{"zh-CN":"\u7ba1\u7406\u54582","en-US":"Admin2"}', '', '这是管理员的用户账号', '2025-08-05 15:08:37', '2025-08-05 15:08:37')]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | 已为账号 811252707137437696 在组织 test002 下创建用户
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:1.19] select * from `magic_contact_users` where `magic_id` = '811252707145826305' and `organization_code` = 'test001' limit 1]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.63] insert into `magic_contact_users` (`magic_id`, `organization_code`, `user_id`, `user_type`, `status`, `nickname`, `i18n_name`, `avatar_url`, `description`, `created_at`, `updated_at`) values ('811252707145826305', 'test001', 'usi_4761de8369a7cb6aad8ef37b12ec3fea', '1', '1', '普通用户1', '{"zh-CN":"\u666e\u901a\u7528\u62371","en-US":"User1"}', '', '这是普通用户的用户账号', '2025-08-05 15:08:37', '2025-08-05 15:08:37')]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | 已为账号 811252707145826305 在组织 test001 下创建用户
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.45] select * from `magic_contact_users` where `magic_id` = '811252707145826305' and `organization_code` = 'test002' limit 1]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.55] insert into `magic_contact_users` (`magic_id`, `organization_code`, `user_id`, `user_type`, `status`, `nickname`, `i18n_name`, `avatar_url`, `description`, `created_at`, `updated_at`) values ('811252707145826305', 'test002', 'usi_b489010ccd81e5c70da77c1d72f15de4', '1', '1', '普通用户2', '{"zh-CN":"\u666e\u901a\u7528\u62372","en-US":"User2"}', '', '这是普通用户的用户账号', '2025-08-05 15:08:37', '2025-08-05 15:08:37')]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | 已为账号 811252707145826305 在组织 test002 下创建用户
magic-service | 账号和用户数据填充完成
magic-service | Seeded: initial_account_and_user_seeder
magic-service | Seed: initial_agent_seeder
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.59] select * from `magic_contact_users` where `user_type` = '1']{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | 为用户 usi_21bb9990967506c35521ddcb25751693 初始化助理...
magic-service | [INFO] [2025-08-05 15:08:37][App\Application\Agent\Service\MagicAgentAppService][获取 initAgents 锁成功, 开始执行初始化, orgCode: test001, userId: usi_21bb9990967506c35521ddcb25751693]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.7] select * from `magic_organizations_environment` where `magic_organization_code` = 'test001' limit 1]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.74] select * from `magic_flow_ai_models` where `enabled` = '1']{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.43] select * from `magic_api_model_configs`]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.54] select * from `service_provider_models` where `organization_code` in ('test001') and `status` = '1' and `category` = 'llm' and `model_type` = '3' and `service_provider_models`.`deleted_at` is null]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.39] select * from `service_provider_configs` where 0 = 1 and `service_provider_configs`.`deleted_at` is null]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.49] select * from `service_provider` where 0 = 1 and `service_provider`.`deleted_at` is null]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][App\Application\Agent\Service\MagicAgentAppService][释放 initAgents 锁, orgCode: test001, userId: usi_21bb9990967506c35521ddcb25751693]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | 初始化助理失败: Undefined array key 0
magic-service | file: /opt/www/runtime/container/proxy/App_Application_Agent_Service_MagicAgentAppService.proxy.php
magic-service | line: 704
magic-service | 为用户 usi_6cd75263aa60cd2f5916e45a511629aa 初始化助理...
magic-service | [INFO] [2025-08-05 15:08:37][App\Application\Agent\Service\MagicAgentAppService][获取 initAgents 锁成功, 开始执行初始化, orgCode: test002, userId: usi_6cd75263aa60cd2f5916e45a511629aa]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.4] select * from `magic_organizations_environment` where `magic_organization_code` = 'test002' limit 1]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:1.7] select * from `service_provider_models` where `organization_code` in ('test002') and `status` = '1' and `category` = 'llm' and `model_type` = '3' and `service_provider_models`.`deleted_at` is null]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.36] select * from `service_provider_configs` where 0 = 1 and `service_provider_configs`.`deleted_at` is null]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.41] select * from `service_provider` where 0 = 1 and `service_provider`.`deleted_at` is null]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][App\Application\Agent\Service\MagicAgentAppService][释放 initAgents 锁, orgCode: test002, userId: usi_6cd75263aa60cd2f5916e45a511629aa]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | 初始化助理失败: Undefined array key 0
magic-service | file: /opt/www/runtime/container/proxy/App_Application_Agent_Service_MagicAgentAppService.proxy.php
magic-service | line: 704
magic-service | 为用户 usi_4761de8369a7cb6aad8ef37b12ec3fea 初始化助理...
magic-service | [INFO] [2025-08-05 15:08:37][App\Application\Agent\Service\MagicAgentAppService][获取 initAgents 锁成功, 开始执行初始化, orgCode: test001, userId: usi_4761de8369a7cb6aad8ef37b12ec3fea]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.4] select * from `magic_organizations_environment` where `magic_organization_code` = 'test001' limit 1]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.43] select * from `service_provider_models` where `organization_code` in ('test001') and `status` = '1' and `category` = 'llm' and `model_type` = '3' and `service_provider_models`.`deleted_at` is null]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.47] select * from `service_provider_configs` where 0 = 1 and `service_provider_configs`.`deleted_at` is null]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.51] select * from `service_provider` where 0 = 1 and `service_provider`.`deleted_at` is null]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][App\Application\Agent\Service\MagicAgentAppService][释放 initAgents 锁, orgCode: test001, userId: usi_4761de8369a7cb6aad8ef37b12ec3fea]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | 初始化助理失败: Undefined array key 0
magic-service | file: /opt/www/runtime/container/proxy/App_Application_Agent_Service_MagicAgentAppService.proxy.php
magic-service | line: 704
magic-service | 为用户 usi_b489010ccd81e5c70da77c1d72f15de4 初始化助理...
magic-service | [INFO] [2025-08-05 15:08:37][App\Application\Agent\Service\MagicAgentAppService][获取 initAgents 锁成功, 开始执行初始化, orgCode: test002, userId: usi_b489010ccd81e5c70da77c1d72f15de4]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.28] select * from `magic_organizations_environment` where `magic_organization_code` = 'test002' limit 1]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.74] select * from `service_provider_models` where `organization_code` in ('test002') and `status` = '1' and `category` = 'llm' and `model_type` = '3' and `service_provider_models`.`deleted_at` is null]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.2] select * from `service_provider_configs` where 0 = 1 and `service_provider_configs`.`deleted_at` is null]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.96] select * from `service_provider` where 0 = 1 and `service_provider`.`deleted_at` is null]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][App\Application\Agent\Service\MagicAgentAppService][释放 initAgents 锁, orgCode: test002, userId: usi_b489010ccd81e5c70da77c1d72f15de4]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | 初始化助理失败: Undefined array key 0
magic-service | file: /opt/www/runtime/container/proxy/App_Application_Agent_Service_MagicAgentAppService.proxy.php
magic-service | line: 704
magic-service | 所有组织助理初始化完成
magic-service | Seeded: initial_agent_seeder
magic-service | Seed: initial_environment_seeder
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.69] select * from `magic_environments` where `id` = '10000' limit 1]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:1.47] insert into `magic_environments` (`id`, `environment_code`, `deployment`, `environment`, `open_platform_config`, `private_config`, `extra`, `created_at`, `updated_at`) values ('10000', '', 'open_source', 'production', '{}', '{"name":"\u9ea6\u5409\u5f00\u6e90","domain":[{"type":"magic"}]}', '', '2025-08-05 15:08:37', '2025-08-05 15:08:37')]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | 已创建环境配置: 生产环境 ID 10000
magic-service | Seeded: initial_environment_seeder
magic-service | Seed: organization_structure_seeder
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.39] select * from `magic_organizations_environment` where `magic_organization_code` = 'test001' limit 1]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.37] insert into `magic_organizations_environment` (`login_code`, `magic_organization_code`, `origin_organization_code`, `environment_id`, `created_at`, `updated_at`) values ('500258', 'test001', 'test001', '10000', '2025-08-05 15:08:37', '2025-08-05 15:08:37')]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | 已创建组织环境关联: test001, ID: 1
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.58] select * from `magic_contact_departments` where `organization_code` = 'test001' and `name` = '测试组织' and `parent_department_id` = '-1' limit 1]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.21] insert into `magic_contact_departments` (`department_id`, `parent_department_id`, `name`, `i18n_name`, `order`, `leader_user_id`, `organization_code`, `status`, `document_id`, `level`, `path`, `employee_sum`, `created_at`, `updated_at`) values ('-1', '-1', '测试组织', '{"zh-CN":"\u6d4b\u8bd5\u7ec4\u7ec7","en-US":"\u6d4b\u8bd5\u7ec4\u7ec7"}', '0', '', 'test001', '{"is_deleted":false}', '811252707548479489', '0', '-1', '0', '2025-08-05 15:08:37', '2025-08-05 15:08:37')]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | 已创建部门: 测试组织, ID: -1, 组织: test001
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.82] select * from `magic_contact_departments` where `organization_code` = 'test001' and `name` = '技术部' and `parent_department_id` = '-1' limit 1]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.39] insert into `magic_contact_departments` (`department_id`, `parent_department_id`, `name`, `i18n_name`, `order`, `leader_user_id`, `organization_code`, `status`, `document_id`, `level`, `path`, `employee_sum`, `created_at`, `updated_at`) values ('811252707552673794', '-1', '技术部', '{"zh-CN":"\u6280\u672f\u90e8","en-US":"Technology Department"}', '0', '', 'test001', '{"is_deleted":false}', '811252707552673795', '1', '-1/811252707552673794', '0', '2025-08-05 15:08:37', '2025-08-05 15:08:37')]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | 已创建部门: 技术部, ID: 811252707552673794, 组织: test001
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.84] select * from `magic_contact_departments` where `organization_code` = 'test001' and `name` = '前端组' and `parent_department_id` = '811252707552673794' limit 1]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.37] insert into `magic_contact_departments` (`department_id`, `parent_department_id`, `name`, `i18n_name`, `order`, `leader_user_id`, `organization_code`, `status`, `document_id`, `level`, `path`, `employee_sum`, `created_at`, `updated_at`) values ('811252707561062401', '811252707552673794', '前端组', '{"zh-CN":"\u524d\u7aef\u7ec4","en-US":"Frontend Team"}', '0', '', 'test001', '{"is_deleted":false}', '811252707561062402', '2', '-1/811252707552673794/811252707561062401', '0', '2025-08-05 15:08:37', '2025-08-05 15:08:37')]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | 已创建部门: 前端组, ID: 811252707561062401, 组织: test001
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.46] select * from `magic_contact_departments` where `organization_code` = 'test001' and `name` = '后端组' and `parent_department_id` = '811252707552673794' limit 1]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.3] insert into `magic_contact_departments` (`department_id`, `parent_department_id`, `name`, `i18n_name`, `order`, `leader_user_id`, `organization_code`, `status`, `document_id`, `level`, `path`, `employee_sum`, `created_at`, `updated_at`) values ('811252707569451009', '811252707552673794', '后端组', '{"zh-CN":"\u540e\u7aef\u7ec4","en-US":"Backend Team"}', '0', '', 'test001', '{"is_deleted":false}', '811252707569451010', '2', '-1/811252707552673794/811252707569451009', '0', '2025-08-05 15:08:37', '2025-08-05 15:08:37')]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | 已创建部门: 后端组, ID: 811252707569451009, 组织: test001
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.62] select * from `magic_contact_departments` where `organization_code` = 'test001' and `name` = '测试组' and `parent_department_id` = '811252707552673794' limit 1]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.38] insert into `magic_contact_departments` (`department_id`, `parent_department_id`, `name`, `i18n_name`, `order`, `leader_user_id`, `organization_code`, `status`, `document_id`, `level`, `path`, `employee_sum`, `created_at`, `updated_at`) values ('811252707577839616', '811252707552673794', '测试组', '{"zh-CN":"\u6d4b\u8bd5\u7ec4","en-US":"QA Team"}', '0', '', 'test001', '{"is_deleted":false}', '811252707577839617', '2', '-1/811252707552673794/811252707577839616', '0', '2025-08-05 15:08:37', '2025-08-05 15:08:37')]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | 已创建部门: 测试组, ID: 811252707577839616, 组织: test001
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.52] select * from `magic_contact_departments` where `organization_code` = 'test001' and `name` = '产品部' and `parent_department_id` = '-1' limit 1]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.74] insert into `magic_contact_departments` (`department_id`, `parent_department_id`, `name`, `i18n_name`, `order`, `leader_user_id`, `organization_code`, `status`, `document_id`, `level`, `path`, `employee_sum`, `created_at`, `updated_at`) values ('811252707582033921', '-1', '产品部', '{"zh-CN":"\u4ea7\u54c1\u90e8","en-US":"Product Department"}', '0', '', 'test001', '{"is_deleted":false}', '811252707582033922', '1', '-1/811252707582033921', '0', '2025-08-05 15:08:37', '2025-08-05 15:08:37')]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | 已创建部门: 产品部, ID: 811252707582033921, 组织: test001
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.91] select * from `magic_contact_departments` where `organization_code` = 'test001' and `name` = '设计组' and `parent_department_id` = '811252707582033921' limit 1]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.45] insert into `magic_contact_departments` (`department_id`, `parent_department_id`, `name`, `i18n_name`, `order`, `leader_user_id`, `organization_code`, `status`, `document_id`, `level`, `path`, `employee_sum`, `created_at`, `updated_at`) values ('811252707590422529', '811252707582033921', '设计组', '{"zh-CN":"\u8bbe\u8ba1\u7ec4","en-US":"Design Team"}', '0', '', 'test001', '{"is_deleted":false}', '811252707590422530', '2', '-1/811252707582033921/811252707590422529', '0', '2025-08-05 15:08:37', '2025-08-05 15:08:37')]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | 已创建部门: 设计组, ID: 811252707590422529, 组织: test001
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.95] select * from `magic_contact_departments` where `organization_code` = 'test001' and `name` = '产品组' and `parent_department_id` = '811252707582033921' limit 1]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.35] insert into `magic_contact_departments` (`department_id`, `parent_department_id`, `name`, `i18n_name`, `order`, `leader_user_id`, `organization_code`, `status`, `document_id`, `level`, `path`, `employee_sum`, `created_at`, `updated_at`) values ('811252707598811137', '811252707582033921', '产品组', '{"zh-CN":"\u4ea7\u54c1\u7ec4","en-US":"Product Team"}', '0', '', 'test001', '{"is_deleted":false}', '811252707598811138', '2', '-1/811252707582033921/811252707598811137', '0', '2025-08-05 15:08:37', '2025-08-05 15:08:37')]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | 已创建部门: 产品组, ID: 811252707598811137, 组织: test001
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.73] select * from `magic_contact_departments` where `organization_code` = 'test001' and `name` = '市场部' and `parent_department_id` = '-1' limit 1]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.23] insert into `magic_contact_departments` (`department_id`, `parent_department_id`, `name`, `i18n_name`, `order`, `leader_user_id`, `organization_code`, `status`, `document_id`, `level`, `path`, `employee_sum`, `created_at`, `updated_at`) values ('811252707607199745', '-1', '市场部', '{"zh-CN":"\u5e02\u573a\u90e8","en-US":"Marketing Department"}', '0', '', 'test001', '{"is_deleted":false}', '811252707607199746', '1', '-1/811252707607199745', '0', '2025-08-05 15:08:37', '2025-08-05 15:08:37')]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | 已创建部门: 市场部, ID: 811252707607199745, 组织: test001
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.53] select * from `magic_contact_departments` where `organization_code` = 'test001' and `name` = '营销组' and `parent_department_id` = '811252707607199745' limit 1]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.56] insert into `magic_contact_departments` (`department_id`, `parent_department_id`, `name`, `i18n_name`, `order`, `leader_user_id`, `organization_code`, `status`, `document_id`, `level`, `path`, `employee_sum`, `created_at`, `updated_at`) values ('811252707611394050', '811252707607199745', '营销组', '{"zh-CN":"\u8425\u9500\u7ec4","en-US":"Marketing Team"}', '0', '', 'test001', '{"is_deleted":false}', '811252707611394051', '2', '-1/811252707607199745/811252707611394050', '0', '2025-08-05 15:08:37', '2025-08-05 15:08:37')]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | 已创建部门: 营销组, ID: 811252707611394050, 组织: test001
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.4] select * from `magic_contact_departments` where `organization_code` = 'test001' and `name` = '销售组' and `parent_department_id` = '811252707607199745' limit 1]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.28] insert into `magic_contact_departments` (`department_id`, `parent_department_id`, `name`, `i18n_name`, `order`, `leader_user_id`, `organization_code`, `status`, `document_id`, `level`, `path`, `employee_sum`, `created_at`, `updated_at`) values ('811252707619782657', '811252707607199745', '销售组', '{"zh-CN":"\u9500\u552e\u7ec4","en-US":"Sales Team"}', '0', '', 'test001', '{"is_deleted":false}', '811252707623976960', '2', '-1/811252707607199745/811252707619782657', '0', '2025-08-05 15:08:37', '2025-08-05 15:08:37')]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | 已创建部门: 销售组, ID: 811252707619782657, 组织: test001
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.3] select * from `magic_contact_departments` where `organization_code` = 'test001' and `name` = '人事部' and `parent_department_id` = '-1' limit 1]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.56] insert into `magic_contact_departments` (`department_id`, `parent_department_id`, `name`, `i18n_name`, `order`, `leader_user_id`, `organization_code`, `status`, `document_id`, `level`, `path`, `employee_sum`, `created_at`, `updated_at`) values ('811252707628171266', '-1', '人事部', '{"zh-CN":"\u4eba\u4e8b\u90e8","en-US":"HR Department"}', '0', '', 'test001', '{"is_deleted":false}', '811252707628171267', '1', '-1/811252707628171266', '0', '2025-08-05 15:08:37', '2025-08-05 15:08:37')]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | 已创建部门: 人事部, ID: 811252707628171266, 组织: test001
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:1.04] select * from `magic_contact_users` where `organization_code` = 'test001']{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.35] select * from `magic_contact_departments` where `organization_code` = 'test001']{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.4] update `magic_contact_departments` set `leader_user_id` = 'usi_21bb9990967506c35521ddcb25751693' where `id` = '1']{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.51] select * from `magic_contact_department_users` where `user_id` = 'usi_21bb9990967506c35521ddcb25751693' and `department_id` = '-1' and `organization_code` = 'test001' limit 1]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.31] insert into `magic_contact_department_users` (`magic_id`, `user_id`, `department_id`, `is_leader`, `organization_code`, `city`, `country`, `join_time`, `employee_no`, `employee_type`, `orders`, `custom_attrs`, `is_frozen`, `created_at`, `updated_at`, `job_title`) values ('811252707137437696', 'usi_21bb9990967506c35521ddcb25751693', '-1', '1', 'test001', '北京', 'CN', '1754377717', 'EMP1693', '1', '0', '{"\u6280\u80fd":"\u7f16\u7a0b","\u7231\u597d":"\u9605\u8bfb"}', '0', '2025-08-05 15:08:37', '2025-08-05 15:08:37', '部门经理')]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.24] update `magic_contact_departments` set `employee_sum` = `employee_sum` + 1 where `department_id` = '-1']{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | 已将用户 管理员1(ID: usi_21bb9990967506c35521ddcb25751693) 设为总部主管
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.41] select * from `magic_contact_department_users` where `user_id` = 'usi_21bb9990967506c35521ddcb25751693' and `department_id` = '811252707552673794' and `organization_code` = 'test001' limit 1]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.36] insert into `magic_contact_department_users` (`magic_id`, `user_id`, `department_id`, `is_leader`, `organization_code`, `city`, `country`, `join_time`, `employee_no`, `employee_type`, `orders`, `custom_attrs`, `is_frozen`, `created_at`, `updated_at`, `job_title`) values ('811252707137437696', 'usi_21bb9990967506c35521ddcb25751693', '811252707552673794', '1', 'test001', '北京', 'CN', '1754377717', 'EMP1693', '1', '0', '{"\u6280\u80fd":"\u7f16\u7a0b","\u7231\u597d":"\u9605\u8bfb"}', '0', '2025-08-05 15:08:37', '2025-08-05 15:08:37', '部门经理')]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.36] update `magic_contact_departments` set `employee_sum` = `employee_sum` + 1 where `department_id` = '811252707552673794']{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | 已将管理员 管理员1(ID: usi_21bb9990967506c35521ddcb25751693) 分配到技术部
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.3] update `magic_contact_departments` set `leader_user_id` = 'usi_4761de8369a7cb6aad8ef37b12ec3fea' where `id` = '2']{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.32] select * from `magic_contact_department_users` where `user_id` = 'usi_4761de8369a7cb6aad8ef37b12ec3fea' and `department_id` = '811252707552673794' and `organization_code` = 'test001' limit 1]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.32] insert into `magic_contact_department_users` (`magic_id`, `user_id`, `department_id`, `is_leader`, `organization_code`, `city`, `country`, `join_time`, `employee_no`, `employee_type`, `orders`, `custom_attrs`, `is_frozen`, `created_at`, `updated_at`, `leader_user_id`) values ('811252707145826305', 'usi_4761de8369a7cb6aad8ef37b12ec3fea', '811252707552673794', '0', 'test001', '北京', 'CN', '1754377717', 'EMP3fea', '1', '0', '{"\u6280\u80fd":"\u7f16\u7a0b","\u7231\u597d":"\u9605\u8bfb"}', '0', '2025-08-05 15:08:37', '2025-08-05 15:08:37', 'usi_21bb9990967506c35521ddcb25751693')]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.34] update `magic_contact_departments` set `employee_sum` = `employee_sum` + 1 where `department_id` = '811252707552673794']{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | 已将用户 普通用户1(ID: usi_4761de8369a7cb6aad8ef37b12ec3fea) 分配到技术部
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.28] select * from `magic_organizations_environment` where `magic_organization_code` = 'test002' limit 1]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.33] insert into `magic_organizations_environment` (`login_code`, `magic_organization_code`, `origin_organization_code`, `environment_id`, `created_at`, `updated_at`) values ('107093', 'test002', 'test002', '10000', '2025-08-05 15:08:37', '2025-08-05 15:08:37')]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | 已创建组织环境关联: test002, ID: 2
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.47] select * from `magic_contact_departments` where `organization_code` = 'test002' and `name` = '演示组织' and `parent_department_id` = '-1' limit 1]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.4] insert into `magic_contact_departments` (`department_id`, `parent_department_id`, `name`, `i18n_name`, `order`, `leader_user_id`, `organization_code`, `status`, `document_id`, `level`, `path`, `employee_sum`, `created_at`, `updated_at`) values ('-1', '-1', '演示组织', '{"zh-CN":"\u6f14\u793a\u7ec4\u7ec7","en-US":"\u6f14\u793a\u7ec4\u7ec7"}', '0', '', 'test002', '{"is_deleted":false}', '811252707686891520', '0', '-1', '0', '2025-08-05 15:08:37', '2025-08-05 15:08:37')]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | 已创建部门: 演示组织, ID: -1, 组织: test002
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.34] select * from `magic_contact_departments` where `organization_code` = 'test002' and `name` = '技术部' and `parent_department_id` = '-1' limit 1]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.19] insert into `magic_contact_departments` (`department_id`, `parent_department_id`, `name`, `i18n_name`, `order`, `leader_user_id`, `organization_code`, `status`, `document_id`, `level`, `path`, `employee_sum`, `created_at`, `updated_at`) values ('811252707691085825', '-1', '技术部', '{"zh-CN":"\u6280\u672f\u90e8","en-US":"Technology Department"}', '0', '', 'test002', '{"is_deleted":false}', '811252707691085826', '1', '-1/811252707691085825', '0', '2025-08-05 15:08:37', '2025-08-05 15:08:37')]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | 已创建部门: 技术部, ID: 811252707691085825, 组织: test002
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.25] select * from `magic_contact_departments` where `organization_code` = 'test002' and `name` = '前端组' and `parent_department_id` = '811252707691085825' limit 1]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.27] insert into `magic_contact_departments` (`department_id`, `parent_department_id`, `name`, `i18n_name`, `order`, `leader_user_id`, `organization_code`, `status`, `document_id`, `level`, `path`, `employee_sum`, `created_at`, `updated_at`) values ('811252707695280130', '811252707691085825', '前端组', '{"zh-CN":"\u524d\u7aef\u7ec4","en-US":"Frontend Team"}', '0', '', 'test002', '{"is_deleted":false}', '811252707695280131', '2', '-1/811252707691085825/811252707695280130', '0', '2025-08-05 15:08:37', '2025-08-05 15:08:37')]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | 已创建部门: 前端组, ID: 811252707695280130, 组织: test002
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.26] select * from `magic_contact_departments` where `organization_code` = 'test002' and `name` = '后端组' and `parent_department_id` = '811252707691085825' limit 1]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.27] insert into `magic_contact_departments` (`department_id`, `parent_department_id`, `name`, `i18n_name`, `order`, `leader_user_id`, `organization_code`, `status`, `document_id`, `level`, `path`, `employee_sum`, `created_at`, `updated_at`) values ('811252707699474434', '811252707691085825', '后端组', '{"zh-CN":"\u540e\u7aef\u7ec4","en-US":"Backend Team"}', '0', '', 'test002', '{"is_deleted":false}', '811252707699474435', '2', '-1/811252707691085825/811252707699474434', '0', '2025-08-05 15:08:37', '2025-08-05 15:08:37')]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | 已创建部门: 后端组, ID: 811252707699474434, 组织: test002
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.5] select * from `magic_contact_departments` where `organization_code` = 'test002' and `name` = '测试组' and `parent_department_id` = '811252707691085825' limit 1]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.25] insert into `magic_contact_departments` (`department_id`, `parent_department_id`, `name`, `i18n_name`, `order`, `leader_user_id`, `organization_code`, `status`, `document_id`, `level`, `path`, `employee_sum`, `created_at`, `updated_at`) values ('811252707712057344', '811252707691085825', '测试组', '{"zh-CN":"\u6d4b\u8bd5\u7ec4","en-US":"QA Team"}', '0', '', 'test002', '{"is_deleted":false}', '811252707712057345', '2', '-1/811252707691085825/811252707712057344', '0', '2025-08-05 15:08:37', '2025-08-05 15:08:37')]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | 已创建部门: 测试组, ID: 811252707712057344, 组织: test002
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.36] select * from `magic_contact_departments` where `organization_code` = 'test002' and `name` = '产品部' and `parent_department_id` = '-1' limit 1]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.21] insert into `magic_contact_departments` (`department_id`, `parent_department_id`, `name`, `i18n_name`, `order`, `leader_user_id`, `organization_code`, `status`, `document_id`, `level`, `path`, `employee_sum`, `created_at`, `updated_at`) values ('811252707720445952', '-1', '产品部', '{"zh-CN":"\u4ea7\u54c1\u90e8","en-US":"Product Department"}', '0', '', 'test002', '{"is_deleted":false}', '811252707720445953', '1', '-1/811252707720445952', '0', '2025-08-05 15:08:37', '2025-08-05 15:08:37')]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | 已创建部门: 产品部, ID: 811252707720445952, 组织: test002
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.28] select * from `magic_contact_departments` where `organization_code` = 'test002' and `name` = '设计组' and `parent_department_id` = '811252707720445952' limit 1]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.3] insert into `magic_contact_departments` (`department_id`, `parent_department_id`, `name`, `i18n_name`, `order`, `leader_user_id`, `organization_code`, `status`, `document_id`, `level`, `path`, `employee_sum`, `created_at`, `updated_at`) values ('811252707724640257', '811252707720445952', '设计组', '{"zh-CN":"\u8bbe\u8ba1\u7ec4","en-US":"Design Team"}', '0', '', 'test002', '{"is_deleted":false}', '811252707724640258', '2', '-1/811252707720445952/811252707724640257', '0', '2025-08-05 15:08:37', '2025-08-05 15:08:37')]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | 已创建部门: 设计组, ID: 811252707724640257, 组织: test002
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.53] select * from `magic_contact_departments` where `organization_code` = 'test002' and `name` = '产品组' and `parent_department_id` = '811252707720445952' limit 1]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.21] insert into `magic_contact_departments` (`department_id`, `parent_department_id`, `name`, `i18n_name`, `order`, `leader_user_id`, `organization_code`, `status`, `document_id`, `level`, `path`, `employee_sum`, `created_at`, `updated_at`) values ('811252707728834561', '811252707720445952', '产品组', '{"zh-CN":"\u4ea7\u54c1\u7ec4","en-US":"Product Team"}', '0', '', 'test002', '{"is_deleted":false}', '811252707728834562', '2', '-1/811252707720445952/811252707728834561', '0', '2025-08-05 15:08:37', '2025-08-05 15:08:37')]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | 已创建部门: 产品组, ID: 811252707728834561, 组织: test002
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.46] select * from `magic_contact_departments` where `organization_code` = 'test002' and `name` = '市场部' and `parent_department_id` = '-1' limit 1]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.28] insert into `magic_contact_departments` (`department_id`, `parent_department_id`, `name`, `i18n_name`, `order`, `leader_user_id`, `organization_code`, `status`, `document_id`, `level`, `path`, `employee_sum`, `created_at`, `updated_at`) values ('811252707737223168', '-1', '市场部', '{"zh-CN":"\u5e02\u573a\u90e8","en-US":"Marketing Department"}', '0', '', 'test002', '{"is_deleted":false}', '811252707737223169', '1', '-1/811252707737223168', '0', '2025-08-05 15:08:37', '2025-08-05 15:08:37')]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | 已创建部门: 市场部, ID: 811252707737223168, 组织: test002
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.36] select * from `magic_contact_departments` where `organization_code` = 'test002' and `name` = '营销组' and `parent_department_id` = '811252707737223168' limit 1]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.19] insert into `magic_contact_departments` (`department_id`, `parent_department_id`, `name`, `i18n_name`, `order`, `leader_user_id`, `organization_code`, `status`, `document_id`, `level`, `path`, `employee_sum`, `created_at`, `updated_at`) values ('811252707741417473', '811252707737223168', '营销组', '{"zh-CN":"\u8425\u9500\u7ec4","en-US":"Marketing Team"}', '0', '', 'test002', '{"is_deleted":false}', '811252707741417474', '2', '-1/811252707737223168/811252707741417473', '0', '2025-08-05 15:08:37', '2025-08-05 15:08:37')]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | 已创建部门: 营销组, ID: 811252707741417473, 组织: test002
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.44] select * from `magic_contact_departments` where `organization_code` = 'test002' and `name` = '销售组' and `parent_department_id` = '811252707737223168' limit 1]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.34] insert into `magic_contact_departments` (`department_id`, `parent_department_id`, `name`, `i18n_name`, `order`, `leader_user_id`, `organization_code`, `status`, `document_id`, `level`, `path`, `employee_sum`, `created_at`, `updated_at`) values ('811252707745611777', '811252707737223168', '销售组', '{"zh-CN":"\u9500\u552e\u7ec4","en-US":"Sales Team"}', '0', '', 'test002', '{"is_deleted":false}', '811252707745611778', '2', '-1/811252707737223168/811252707745611777', '0', '2025-08-05 15:08:37', '2025-08-05 15:08:37')]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | 已创建部门: 销售组, ID: 811252707745611777, 组织: test002
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.34] select * from `magic_contact_departments` where `organization_code` = 'test002' and `name` = '人事部' and `parent_department_id` = '-1' limit 1]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.18] insert into `magic_contact_departments` (`department_id`, `parent_department_id`, `name`, `i18n_name`, `order`, `leader_user_id`, `organization_code`, `status`, `document_id`, `level`, `path`, `employee_sum`, `created_at`, `updated_at`) values ('811252707754000384', '-1', '人事部', '{"zh-CN":"\u4eba\u4e8b\u90e8","en-US":"HR Department"}', '0', '', 'test002', '{"is_deleted":false}', '811252707754000385', '1', '-1/811252707754000384', '0', '2025-08-05 15:08:37', '2025-08-05 15:08:37')]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | 已创建部门: 人事部, ID: 811252707754000384, 组织: test002
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.28] select * from `magic_contact_users` where `organization_code` = 'test002']{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.33] select * from `magic_contact_departments` where `organization_code` = 'test002']{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.2] update `magic_contact_departments` set `leader_user_id` = 'usi_6cd75263aa60cd2f5916e45a511629aa' where `id` = '13']{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.26] select * from `magic_contact_department_users` where `user_id` = 'usi_6cd75263aa60cd2f5916e45a511629aa' and `department_id` = '-1' and `organization_code` = 'test002' limit 1]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.26] insert into `magic_contact_department_users` (`magic_id`, `user_id`, `department_id`, `is_leader`, `organization_code`, `city`, `country`, `join_time`, `employee_no`, `employee_type`, `orders`, `custom_attrs`, `is_frozen`, `created_at`, `updated_at`, `job_title`) values ('811252707137437696', 'usi_6cd75263aa60cd2f5916e45a511629aa', '-1', '1', 'test002', '北京', 'CN', '1754377717', 'EMP29aa', '1', '0', '{"\u6280\u80fd":"\u7f16\u7a0b","\u7231\u597d":"\u9605\u8bfb"}', '0', '2025-08-05 15:08:37', '2025-08-05 15:08:37', '部门经理')]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.38] update `magic_contact_departments` set `employee_sum` = `employee_sum` + 1 where `department_id` = '-1']{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | 已将用户 管理员2(ID: usi_6cd75263aa60cd2f5916e45a511629aa) 设为总部主管
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.46] select * from `magic_contact_department_users` where `user_id` = 'usi_6cd75263aa60cd2f5916e45a511629aa' and `department_id` = '811252707691085825' and `organization_code` = 'test002' limit 1]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.37] insert into `magic_contact_department_users` (`magic_id`, `user_id`, `department_id`, `is_leader`, `organization_code`, `city`, `country`, `join_time`, `employee_no`, `employee_type`, `orders`, `custom_attrs`, `is_frozen`, `created_at`, `updated_at`, `job_title`) values ('811252707137437696', 'usi_6cd75263aa60cd2f5916e45a511629aa', '811252707691085825', '1', 'test002', '北京', 'CN', '1754377717', 'EMP29aa', '1', '0', '{"\u6280\u80fd":"\u7f16\u7a0b","\u7231\u597d":"\u9605\u8bfb"}', '0', '2025-08-05 15:08:37', '2025-08-05 15:08:37', '部门经理')]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.25] update `magic_contact_departments` set `employee_sum` = `employee_sum` + 1 where `department_id` = '811252707691085825']{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | 已将管理员 管理员2(ID: usi_6cd75263aa60cd2f5916e45a511629aa) 分配到技术部
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.25] update `magic_contact_departments` set `leader_user_id` = 'usi_b489010ccd81e5c70da77c1d72f15de4' where `id` = '14']{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.34] select * from `magic_contact_department_users` where `user_id` = 'usi_b489010ccd81e5c70da77c1d72f15de4' and `department_id` = '811252707691085825' and `organization_code` = 'test002' limit 1]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.29] insert into `magic_contact_department_users` (`magic_id`, `user_id`, `department_id`, `is_leader`, `organization_code`, `city`, `country`, `join_time`, `employee_no`, `employee_type`, `orders`, `custom_attrs`, `is_frozen`, `created_at`, `updated_at`, `leader_user_id`) values ('811252707145826305', 'usi_b489010ccd81e5c70da77c1d72f15de4', '811252707691085825', '0', 'test002', '北京', 'CN', '1754377717', 'EMP5de4', '1', '0', '{"\u6280\u80fd":"\u7f16\u7a0b","\u7231\u597d":"\u9605\u8bfb"}', '0', '2025-08-05 15:08:37', '2025-08-05 15:08:37', 'usi_6cd75263aa60cd2f5916e45a511629aa')]{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:37][sql][[default:0.2] update `magic_contact_departments` set `employee_sum` = `employee_sum` + 1 where `department_id` = '811252707691085825']{"system_info":{"request_id":811252707124854784,"coroutine_id":1,"trace_id":""}}
magic-service | 已将用户 普通用户2(ID: usi_b489010ccd81e5c70da77c1d72f15de4) 分配到技术部
magic-service | 组织架构数据填充完成
magic-service | Seeded: organization_structure_seeder
magic-service | Initialization completed!
magic-service | PHP Warning: PHP Startup: Swow pdo_pgsql hook not enabled, libpq.so not found, (search paths: ) in Unknown on line 0
magic-service | [INFO] [2025-08-05 15:08:38][sql][[default:2.51] select * from `magic_flow_ai_models` where `enabled` = '1']{"system_info":{"request_id":811252708978741248,"coroutine_id":2,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:38][sql][[default:0.49] select * from `magic_api_model_configs`]{"system_info":{"request_id":811252708978741248,"coroutine_id":2,"trace_id":""}}
magic-rabbitmq | 2025-08-05 07:08:38.195045+00:00 [info] <0.799.0> accepting AMQP connection 172.18.0.8:50978 -> 172.18.0.3:5672
magic-rabbitmq | 2025-08-05 07:08:38.198013+00:00 [info] <0.799.0> connection 172.18.0.8:50978 -> 172.18.0.3:5672: user 'admin' authenticated and granted access to vhost 'magic-chat'
magic-rabbitmq | 2025-08-05 07:08:38.198968+00:00 [info] <0.808.0> accepting AMQP connection 172.18.0.8:50984 -> 172.18.0.3:5672
magic-rabbitmq | 2025-08-05 07:08:38.200260+00:00 [info] <0.808.0> connection 172.18.0.8:50984 -> 172.18.0.3:5672: user 'admin' authenticated and granted access to vhost 'magic-chat'
magic-rabbitmq | 2025-08-05 07:08:38.201095+00:00 [info] <0.817.0> accepting AMQP connection 172.18.0.8:50990 -> 172.18.0.3:5672
magic-rabbitmq | 2025-08-05 07:08:38.203302+00:00 [info] <0.817.0> connection 172.18.0.8:50990 -> 172.18.0.3:5672: user 'admin' authenticated and granted access to vhost 'magic-chat'
magic-rabbitmq | 2025-08-05 07:08:38.204043+00:00 [info] <0.826.0> accepting AMQP connection 172.18.0.8:51002 -> 172.18.0.3:5672
magic-rabbitmq | 2025-08-05 07:08:38.205092+00:00 [info] <0.826.0> connection 172.18.0.8:51002 -> 172.18.0.3:5672: user 'admin' authenticated and granted access to vhost 'magic-chat'
magic-rabbitmq | 2025-08-05 07:08:38.208199+00:00 [error] <0.835.0> Channel error on connection <0.817.0> (172.18.0.8:50990 -> 172.18.0.3:5672, vhost: 'magic-chat', user: 'admin'), channel 1:
magic-rabbitmq | 2025-08-05 07:08:38.208199+00:00 [error] <0.835.0> operation exchange.declare caused a channel exception access_refused: operation not permitted on the default exchange
magic-rabbitmq | 2025-08-05 07:08:38.209591+00:00 [error] <0.843.0> Channel error on connection <0.808.0> (172.18.0.8:50984 -> 172.18.0.3:5672, vhost: 'magic-chat', user: 'admin'), channel 1:
magic-rabbitmq | 2025-08-05 07:08:38.209591+00:00 [error] <0.843.0> operation exchange.declare caused a channel exception access_refused: operation not permitted on the default exchange
magic-rabbitmq | 2025-08-05 07:08:38.211692+00:00 [error] <0.856.0> Channel error on connection <0.808.0> (172.18.0.8:50984 -> 172.18.0.3:5672, vhost: 'magic-chat', user: 'admin'), channel 2:
magic-rabbitmq | 2025-08-05 07:08:38.211692+00:00 [error] <0.856.0> operation exchange.declare caused a channel exception access_refused: operation not permitted on the default exchange
magic-service | [INFO] Process[Consumer-organization_created_message.0] start.
magic-service | [INFO] Process[Consumer-dispatch_general_agent_message.0] start.
magic-service | [INFO] Process[Consumer-super_magic_topic_task_message.0] start.
magic-service | [INFO] Process[Consumer-magic-chat-message.Highest.queue.0] start.
magic-service | [INFO] Process[Consumer-magic-chat-message.Highest.queue.1] start.
magic-service | [INFO] Process[Consumer-magic-chat-message.Low.queue.0] start.
magic-service | [INFO] Process[Consumer-magic-chat-message.Medium.queue.0] start.
magic-service | [INFO] Process[Consumer-magic-chat-message.High.queue.0] start.
magic-service | [INFO] Process[Consumer-init_default_assistant_conversation.0] start.
magic-service | [INFO] Process[Consumer-magic-chat-recording.High.queue.0] start.
magic-service | [INFO] Process[Consumer-magic-chat-seq.Low.queue.0] start.
magic-service | [INFO] Process[Consumer-magic-chat-seq.Medium.queue.0] start.
magic-service | [INFO] Process[Consumer-magic-chat-seq.Highest.queue.0] start.
magic-service | [INFO] Process[Consumer-magic-chat-seq.Highest.queue.1] start.
magic-service | [INFO] Process[Consumer-magic-chat-seq.High.queue.0] start.
magic-service | [INFO] Process[mcp_sse_broadcast_subscriber.0] start.
magic-service | [INFO] HTTP Coroutine Server listening at 0.0.0.0:9501
magic-service | [INFO] WebSocket Coroutine Server listening at 0.0.0.0:9502
magic-service | [INFO] HTTP Coroutine Server listening at 0.0.0.0:9503
magic-service | [INFO] [2025-08-05 15:08:38][sql][[default:1.54] select * from `magic_api_applications` where `code` = 'Magic' and `magic_api_applications`.`deleted_at` is null limit 1]{"system_info":{"request_id":811252708978741248,"coroutine_id":2,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:38][sql][[default:2.95] select * from `magic_api_applications` where `code` = 'Magic' and `magic_api_applications`.`deleted_at` is null limit 1]{"system_info":{"request_id":811252708978741248,"coroutine_id":2,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:38][sql][[default:2.73] insert into `magic_api_applications` (`organization_code`, `code`, `name`, `description`, `icon`, `created_uid`, `created_at`, `updated_uid`, `updated_at`, `id`) values ('DT001', 'Magic', '灯塔引擎', '灯塔引擎官方应用', '', 'system', '2025-08-05 15:08:38', 'system', '2025-08-05 15:08:38', '811252709318479872')]{"system_info":{"request_id":811252708978741248,"coroutine_id":2,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:38][sql][[default:1.2] select * from `magic_api_access_tokens` where `name` = 'Magic' and `magic_api_access_tokens`.`deleted_at` is null limit 1]{"system_info":{"request_id":811252708978741248,"coroutine_id":2,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:38][sql][[default:0.8] select count(*) as aggregate from `magic_api_access_tokens` where `relation_id` = '811252709318479872' and `magic_api_access_tokens`.`deleted_at` is null]{"system_info":{"request_id":811252708978741248,"coroutine_id":2,"trace_id":""}}
magic-service | [INFO] [2025-08-05 15:08:38][sql][[default:2.14] insert into `magic_api_access_tokens` (`organization_code`, `type`, `access_token`, `relation_id`, `name`, `description`, `models`, `ip_limit`, `expire_time`, `total_amount`, `use_amount`, `rpm`, `creator`, `modifier`, `created_at`, `updated_at`, `id`) values ('DT001', 'application', '079d368108cdafa380cdfa30e05de9c3', '811252709318479872', 'Magic', '', 'all', '', '', '0', '0', '0', 'system', 'system', '2025-08-05 15:08:38', '2025-08-05 15:08:38', '811252709364617216')]{"system_info":{"request_id":811252708978741248,"coroutine_id":2,"trace_id":""}}
magic-service-daemon | [INFO] Crontab task [TaskSchedulerCreateCrontab] skipped execution at 2025-08-05 15:09:00 caused by server mutex.
magic-service-daemon | [INFO] Crontab task [FlowBreakpointRetryCrontab] skipped execution at 2025-08-05 15:09:00 caused by server mutex.
magic-service-daemon | [INFO] Crontab task [ClearMagicMessageCrontab] skipped execution at 2025-08-05 15:09:00 caused by server mutex.
magic-service-daemon | [INFO] [2025-08-05 15:09:00][sql][[default:3.13] select `id` from `async_event_records` where `updated_at` < '2025-08-05 14:59:00' and `status` in ('0', '1') limit 100]{"system_info":{"request_id":811252800674603008,"coroutine_id":25,"trace_id":""}}
magic-service-daemon | [INFO] Crontab task [AsyncEventRetry] executed successfully at 2025-08-05 15:09:00.
magic-service-daemon | [INFO] [2025-08-05 15:09:00][sql][[default:2.31] select count(*) as aggregate from `task_scheduler` where `status` = '1' and `expect_time` <= '2025-08-05 15:09:00']{"system_info":{"request_id":811252800682991616,"coroutine_id":37,"trace_id":""}}
magic-service-daemon | [INFO] Crontab task [TaskSchedulerExecuteCrontab] executed successfully at 2025-08-05 15:09:00.
magic-service-daemon | [INFO] [2025-08-05 15:09:10][sql][[default:1.77] select `id` from `async_event_records` where `updated_at` < '2025-08-05 14:59:10' and `status` in ('0', '1') limit 100]{"system_info":{"request_id":811252842512785408,"coroutine_id":27,"trace_id":""}}
magic-service-daemon | [INFO] Crontab task [AsyncEventRetry] executed successfully at 2025-08-05 15:09:10.
magic-service-daemon | [INFO] [2025-08-05 15:09:20][sql][[default:3.04] select `id` from `async_event_records` where `updated_at` < '2025-08-05 14:59:20' and `status` in ('0', '1') limit 100]{"system_info":{"request_id":811252884464214016,"coroutine_id":29,"trace_id":""}}
magic-service-daemon | [INFO] Crontab task [AsyncEventRetry] executed successfully at 2025-08-05 15:09:20.
magic-service-daemon | [INFO] [2025-08-05 15:09:30][sql][[default:1.03] select `id` from `async_event_records` where `updated_at` < '2025-08-05 14:59:30' and `status` in ('0', '1') limit 100]{"system_info":{"request_id":811252926394671104,"coroutine_id":31,"trace_id":""}}
magic-service-daemon | [INFO] Crontab task [AsyncEventRetry] executed successfully at 2025-08-05 15:09:30.
magic-service-daemon | [INFO] [2025-08-05 15:09:40][sql][[default:0.48] select `id` from `async_event_records` where `updated_at` < '2025-08-05 14:59:40' and `status` in ('0', '1') limit 100]{"system_info":{"request_id":811252968333516800,"coroutine_id":33,"trace_id":""}}
magic-service-daemon | [INFO] Crontab task [AsyncEventRetry] executed successfully at 2025-08-05 15:09:40.
magic-service-daemon | [INFO] [2025-08-05 15:09:50][sql][[default:1.91] select `id` from `async_event_records` where `updated_at` < '2025-08-05 14:59:50' and `status` in ('0', '1') limit 100]{"system_info":{"request_id":811253010293334016,"coroutine_id":35,"trace_id":""}}
magic-service-daemon | [INFO] Crontab task [AsyncEventRetry] executed successfully at 2025-08-05 15:09:50.
magic-service-daemon | [INFO] [2025-08-05 15:10:00][sql][[default:2.15] select `id` from `async_event_records` where `updated_at` < '2025-08-05 15:00:00' and `status` in ('0', '1') limit 100]{"system_info":{"request_id":811253052563529728,"coroutine_id":54,"trace_id":""}}
magic-service-daemon | [INFO] Crontab task [AsyncEventRetry] executed successfully at 2025-08-05 15:10:00.
magic-service-daemon | [INFO] [2025-08-05 15:10:00][hyperf][ClearMagicMessageCrontab start]{"system_info":{"request_id":811253052580306944,"coroutine_id":72,"trace_id":""}}
magic-service-daemon | [INFO] [2025-08-05 15:10:00][hyperf][ClearMagicMessageCrontab time: 2025-08-05 14:40:00, lastId: 0]{"system_info":{"request_id":811253052580306944,"coroutine_id":72,"trace_id":""}}
magic-service-daemon | [INFO] [2025-08-05 15:10:00][sql][[default:0.58] select * from `magic_stream_messages` where `updated_at` > '2025-08-05 14:40:00' and `id` > '0' and `magic_stream_messages`.`deleted_at` is null order by `updated_at` asc limit 10]{"system_info":{"request_id":811253052580306944,"coroutine_id":72,"trace_id":""}}
magic-service-daemon | [INFO] [2025-08-05 15:10:00][sql][[default:6.29] select count(*) as aggregate from `task_scheduler` where `status` = '1' and `expect_time` <= '2025-08-05 15:10:00']{"system_info":{"request_id":811253052588695553,"coroutine_id":66,"trace_id":""}}
magic-service-daemon | [INFO] [2025-08-05 15:10:00][sql][[default:5.02] select count(*) as aggregate from `task_scheduler_crontab` where `last_gen_time` <= '2025-08-05 15:10:00' and `enabled` = '1']{"system_info":{"request_id":811253052588695554,"coroutine_id":68,"trace_id":""}}
magic-service-daemon | [INFO] [2025-08-05 15:10:00][hyperf][ClearMagicMessageCrontab success]{"system_info":{"request_id":811253052580306944,"coroutine_id":72,"trace_id":""}}
magic-service-daemon | [INFO] Crontab task [TaskSchedulerExecuteCrontab] executed successfully at 2025-08-05 15:10:00.
magic-service-daemon | [INFO] Crontab task [TaskSchedulerCreateCrontab] executed successfully at 2025-08-05 15:10:00.
magic-service-daemon | [INFO] Crontab task [ClearMagicMessageCrontab] executed successfully at 2025-08-05 15:10:00.
magic-service-daemon | [INFO] [2025-08-05 15:10:00][sql][[default:3.44] select * from `magic_flow_execute_logs` where `status` in ('2', '1') and `level` = '0' and `retry_count` < '1' and `created_at` > '2025-08-05 13:10:00' and `created_at` < '2025-08-05 15:00:00' limit 200 offset 0]{"system_info":{"request_id":811253052588695556,"coroutine_id":70,"trace_id":""}}
magic-service-daemon | [INFO] Crontab task [FlowBreakpointRetryCrontab] executed successfully at 2025-08-05 15:10:00.
magic-service-daemon | [INFO] [2025-08-05 15:10:10][sql][[default:2.08] select `id` from `async_event_records` where `updated_at` < '2025-08-05 15:00:10' and `status` in ('0', '1') limit 100]{"system_info":{"request_id":811253094489792512,"coroutine_id":56,"trace_id":""}}
magic-service-daemon | [INFO] Crontab task [AsyncEventRetry] executed successfully at 2025-08-05 15:10:10.
magic-service-daemon | [INFO] [2025-08-05 15:10:20][sql][[default:1.68] select `id` from `async_event_records` where `updated_at` < '2025-08-05 15:00:20' and `status` in ('0', '1') limit 100]{"system_info":{"request_id":811253136437026816,"coroutine_id":58,"trace_id":""}}
magic-service-daemon | [INFO] Crontab task [AsyncEventRetry] executed successfully at 2025-08-05 15:10:20.
magic-service-daemon | [INFO] [2025-08-05 15:10:30][sql][[default:1.2] select `id` from `async_event_records` where `updated_at` < '2025-08-05 15:00:30' and `status` in ('0', '1') limit 100]{"system_info":{"request_id":811253178375872512,"coroutine_id":60,"trace_id":""}}
magic-service-daemon | [INFO] Crontab task [AsyncEventRetry] executed successfully at 2025-08-05 15:10:30.
magic-service-daemon | [INFO] [2025-08-05 15:10:40][sql][[default:2.84] select `id` from `async_event_records` where `updated_at` < '2025-08-05 15:00:40' and `status` in ('0', '1') limit 100]{"system_info":{"request_id":811253220323106816,"coroutine_id":62,"trace_id":""}}
magic-service-daemon | [INFO] Crontab task [AsyncEventRetry] executed successfully at 2025-08-05 15:10:40.
magic-service-daemon | [INFO] [2025-08-05 15:10:50][sql][[default:0.66] select `id` from `async_event_records` where `updated_at` < '2025-08-05 15:00:50' and `status` in ('0', '1') limit 100]{"system_info":{"request_id":811253262261952512,"coroutine_id":64,"trace_id":""}}
magic-service-daemon | [INFO] Crontab task [AsyncEventRetry] executed successfully at 2025-08-05 15:10:50.
magic-service-daemon | [INFO] [2025-08-05 15:11:00][hyperf][ClearMagicMessageCrontab start]{"system_info":{"request_id":811253304288878592,"coroutine_id":108,"trace_id":""}}
magic-service-daemon | [INFO] [2025-08-05 15:11:00][sql][[default:2.14] select `id` from `async_event_records` where `updated_at` < '2025-08-05 15:01:00' and `status` in ('0', '1') limit 100]{"system_info":{"request_id":811253304288878593,"coroutine_id":90,"trace_id":""}}
magic-service-daemon | [INFO] [2025-08-05 15:11:00][hyperf][ClearMagicMessageCrontab time: 2025-08-05 14:41:00, lastId: 0]{"system_info":{"request_id":811253304288878592,"coroutine_id":108,"trace_id":""}}
magic-service-daemon | [INFO] Crontab task [AsyncEventRetry] executed successfully at 2025-08-05 15:11:00.
magic-service-daemon | [INFO] [2025-08-05 15:11:00][sql][[default:5.27] select count(*) as aggregate from `task_scheduler_crontab` where `last_gen_time` <= '2025-08-05 15:11:00' and `enabled` = '1']{"system_info":{"request_id":811253304305655808,"coroutine_id":104,"trace_id":""}}
magic-service-daemon | [INFO] [2025-08-05 15:11:00][sql][[default:5.13] select * from `magic_flow_execute_logs` where `status` in ('2', '1') and `level` = '0' and `retry_count` < '1' and `created_at` > '2025-08-05 13:11:00' and `created_at` < '2025-08-05 15:01:00' limit 200 offset 0]{"system_info":{"request_id":811253304309850112,"coroutine_id":106,"trace_id":""}}
magic-service-daemon | [INFO] [2025-08-05 15:11:00][sql][[default:5.1] select count(*) as aggregate from `task_scheduler` where `status` = '1' and `expect_time` <= '2025-08-05 15:11:00']{"system_info":{"request_id":811253304309850113,"coroutine_id":102,"trace_id":""}}
magic-service-daemon | [INFO] Crontab task [TaskSchedulerCreateCrontab] executed successfully at 2025-08-05 15:11:00.
magic-service-daemon | [INFO] Crontab task [FlowBreakpointRetryCrontab] executed successfully at 2025-08-05 15:11:00.
magic-service-daemon | [INFO] Crontab task [TaskSchedulerExecuteCrontab] executed successfully at 2025-08-05 15:11:00.
magic-service-daemon | [INFO] [2025-08-05 15:11:00][sql][[default:4.55] select * from `magic_stream_messages` where `updated_at` > '2025-08-05 14:41:00' and `id` > '0' and `magic_stream_messages`.`deleted_at` is null order by `updated_at` asc limit 10]{"system_info":{"request_id":811253304288878592,"coroutine_id":108,"trace_id":""}}
magic-service-daemon | [INFO] [2025-08-05 15:11:00][hyperf][ClearMagicMessageCrontab success]{"system_info":{"request_id":811253304288878592,"coroutine_id":108,"trace_id":""}}
magic-service-daemon | [INFO] Crontab task [ClearMagicMessageCrontab] executed successfully at 2025-08-05 15:11:00.
magic-service-daemon | [INFO] [2025-08-05 15:11:10][sql][[default:1.34] select `id` from `async_event_records` where `updated_at` < '2025-08-05 15:01:10' and `status` in ('0', '1') limit 100]{"system_info":{"request_id":811253346223529984,"coroutine_id":92,"trace_id":""}}
magic-service-daemon | [INFO] Crontab task [AsyncEventRetry] executed successfully at 2025-08-05 15:11:10.
magic-service-daemon | [INFO] [2025-08-05 15:11:20][sql][[default:0.62] select `id` from `async_event_records` where `updated_at` < '2025-08-05 15:01:20' and `status` in ('0', '1') limit 100]{"system_info":{"request_id":811253388166569984,"coroutine_id":94,"trace_id":""}}
magic-service-daemon | [INFO] Crontab task [AsyncEventRetry] executed successfully at 2025-08-05 15:11:20.
magic-service-daemon | [INFO] [2025-08-05 15:11:30][sql][[default:0.65] select `id` from `async_event_records` where `updated_at` < '2025-08-05 15:01:30' and `status` in ('0', '1') limit 100]{"system_info":{"request_id":811253430105415680,"coroutine_id":96,"trace_id":""}}
magic-service-daemon | [INFO] Crontab task [AsyncEventRetry] executed successfully at 2025-08-05 15:11:30.
magic-web | {"name":"magic-web","hostname":"9a9a1c8b0992","pid":1,"level":50,"traceId":"736b76d0-191a-4758-9126-73f5c9fd164d","namespace":"sso","data":["error","Failed to fetch"],"info":{"tOrgCode":"","mOrgCode":""},"msg":"","time":"2025-08-05T07:11:34.048Z","v":0}
magic-service-daemon | [INFO] [2025-08-05 15:11:40][sql][[default:0.98] select `id` from `async_event_records` where `updated_at` < '2025-08-05 15:01:40' and `status` in ('0', '1') limit 100]{"system_info":{"request_id":811253472052649984,"coroutine_id":98,"trace_id":""}}
magic-service-daemon | [INFO] Crontab task [AsyncEventRetry] executed successfully at 2025-08-05 15:11:40.
Gracefully Stopping... press Ctrl+C again to force
Container magic-caddy Stopping
Container magic-web Stopping
Container magic-service-daemon Stopping
Container magic-qdrant Stopping
magic-qdrant | 2025-08-05T07:11:42.887484Z INFO actix_server::server: SIGTERM received; starting graceful shutdown
magic-qdrant | 2025-08-05T07:11:42.887611Z INFO actix_server::worker: shutting down idle worker
magic-qdrant | 2025-08-05T07:11:42.887606Z INFO actix_server::accept: accept thread stopped
magic-caddy | {"level":"info","ts":1754377902.8882697,"msg":"shutting down apps, then terminating","signal":"SIGTERM"}
magic-caddy | {"level":"warn","ts":1754377902.8883083,"msg":"exiting; byeee!! 👋","signal":"SIGTERM"}
magic-caddy | {"level":"info","ts":1754377902.8883505,"logger":"http","msg":"servers shutting down with eternal grace period"}
magic-caddy | {"level":"info","ts":1754377902.8885796,"logger":"admin","msg":"stopped previous server","address":"localhost:2019"}
magic-caddy | {"level":"info","ts":1754377902.88864,"msg":"shutdown complete","signal":"SIGTERM","exit_code":0}
Container magic-qdrant Stopped
magic-qdrant exited with code 143
Container magic-caddy Stopped
magic-caddy exited with code 0
magic-service-daemon | [INFO] [2025-08-05 15:11:50][sql][[default:0.83] select `id` from `async_event_records` where `updated_at` < '2025-08-05 15:01:50' and `status` in ('0', '1') limit 100]{"system_info":{"request_id":811253513995689984,"coroutine_id":100,"trace_id":""}}
magic-service-daemon | [INFO] Crontab task [AsyncEventRetry] executed successfully at 2025-08-05 15:11:50.
magic-rabbitmq | 2025-08-05 07:11:52.916403+00:00 [warning] <0.770.0> closing AMQP connection <0.770.0> (172.18.0.9:35088 -> 172.18.0.3:5672, vhost: 'magic-chat', user: 'admin', duration: '3M, 18s'):
magic-rabbitmq | 2025-08-05 07:11:52.916403+00:00 [warning] <0.770.0> client unexpectedly closed TCP connection
magic-rabbitmq | 2025-08-05 07:11:52.916448+00:00 [warning] <0.779.0> closing AMQP connection <0.779.0> (172.18.0.9:35104 -> 172.18.0.3:5672, vhost: 'magic-chat', user: 'admin', duration: '3M, 18s'):
magic-rabbitmq | 2025-08-05 07:11:52.916448+00:00 [warning] <0.779.0> client unexpectedly closed TCP connection
magic-rabbitmq | 2025-08-05 07:11:52.920024+00:00 [warning] <0.761.0> closing AMQP connection <0.761.0> (172.18.0.9:35084 -> 172.18.0.3:5672, vhost: 'magic-chat', user: 'admin', duration: '3M, 18s'):
magic-rabbitmq | 2025-08-05 07:11:52.920024+00:00 [warning] <0.761.0> client unexpectedly closed TCP connection
magic-rabbitmq | 2025-08-05 07:11:52.921702+00:00 [warning] <0.752.0> closing AMQP connection <0.752.0> (172.18.0.9:35072 -> 172.18.0.3:5672, vhost: 'magic-chat', user: 'admin', duration: '3M, 18s'):
magic-rabbitmq | 2025-08-05 07:11:52.921702+00:00 [warning] <0.752.0> client unexpectedly closed TCP connection
Container magic-web Stopped
magic-web exited with code 137
Container magic-service-daemon Stopped
Container magic-service Stopping
magic-service-daemon exited with code 137
magic-rabbitmq | 2025-08-05 07:12:03.194675+00:00 [warning] <0.826.0> closing AMQP connection <0.826.0> (172.18.0.8:51002 -> 172.18.0.3:5672, vhost: 'magic-chat', user: 'admin', duration: '3M, 24s'):
magic-rabbitmq | 2025-08-05 07:12:03.194675+00:00 [warning] <0.826.0> client unexpectedly closed TCP connection
magic-rabbitmq | 2025-08-05 07:12:03.194742+00:00 [warning] <0.817.0> closing AMQP connection <0.817.0> (172.18.0.8:50990 -> 172.18.0.3:5672, vhost: 'magic-chat', user: 'admin', duration: '3M, 24s'):
magic-rabbitmq | 2025-08-05 07:12:03.194742+00:00 [warning] <0.817.0> client unexpectedly closed TCP connection
magic-rabbitmq | 2025-08-05 07:12:03.194836+00:00 [warning] <0.799.0> closing AMQP connection <0.799.0> (172.18.0.8:50978 -> 172.18.0.3:5672, vhost: 'magic-chat', user: 'admin', duration: '3M, 25s'):
magic-rabbitmq | 2025-08-05 07:12:03.194836+00:00 [warning] <0.799.0> client unexpectedly closed TCP connection
magic-rabbitmq | 2025-08-05 07:12:03.194902+00:00 [warning] <0.808.0> closing AMQP connection <0.808.0> (172.18.0.8:50984 -> 172.18.0.3:5672, vhost: 'magic-chat', user: 'admin', duration: '3M, 24s'):
magic-rabbitmq | 2025-08-05 07:12:03.194902+00:00 [warning] <0.808.0> client unexpectedly closed TCP connection
Container magic-service Stopped
Container magic-rabbitmq Stopping
Container db Stopping
Container magic-redis Stopping
magic-service exited with code 137
db | 2025-08-05T07:12:03.504936Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.43).
magic-rabbitmq | 2025-08-05 07:12:03.507310+00:00 [notice] <0.64.0> SIGTERM received - shutting down
magic-rabbitmq | 2025-08-05 07:12:03.507310+00:00 [notice] <0.64.0>
magic-redis | 1:signal-handler (1754377923) Received SIGTERM scheduling shutdown...
magic-rabbitmq | 2025-08-05 07:12:03.524879+00:00 [warning] <0.602.0> HTTP listener registry could not find context rabbitmq_prometheus_tls
magic-redis | 1:M 05 Aug 2025 07:12:03.533 # User requested shutdown...
magic-redis | 1:M 05 Aug 2025 07:12:03.533 * Saving the final RDB snapshot before exiting.
magic-redis | 1:M 05 Aug 2025 07:12:03.535 * DB saved on disk
magic-redis | 1:M 05 Aug 2025 07:12:03.535 # Redis is now ready to exit, bye bye...
magic-rabbitmq | 2025-08-05 07:12:03.543970+00:00 [warning] <0.602.0> HTTP listener registry could not find context rabbitmq_management_tls
magic-rabbitmq | 2025-08-05 07:12:03.560030+00:00 [info] <0.727.0> stopped TCP listener on 0.0.0.0:5672
magic-rabbitmq | 2025-08-05 07:12:03.561579+00:00 [info] <0.535.0> Virtual host 'magic-chat' is stopping
magic-rabbitmq | 2025-08-05 07:12:03.561718+00:00 [info] <0.1281.0> Closing all connections in vhost 'magic-chat' on node 'rabbit@0075a7a90978' because the vhost is stopping
magic-rabbitmq | 2025-08-05 07:12:03.573582+00:00 [info] <0.549.0> Stopping message store for directory '/var/lib/rabbitmq/mnesia/rabbit@0075a7a90978/msg_stores/vhosts/A92BKDAKQSPD3L7OSOE7MWMFG/msg_store_persistent'
magic-rabbitmq | 2025-08-05 07:12:03.576011+00:00 [info] <0.549.0> Message store for directory '/var/lib/rabbitmq/mnesia/rabbit@0075a7a90978/msg_stores/vhosts/A92BKDAKQSPD3L7OSOE7MWMFG/msg_store_persistent' is stopped
magic-rabbitmq | 2025-08-05 07:12:03.576130+00:00 [info] <0.545.0> Stopping message store for directory '/var/lib/rabbitmq/mnesia/rabbit@0075a7a90978/msg_stores/vhosts/A92BKDAKQSPD3L7OSOE7MWMFG/msg_store_transient'
magic-rabbitmq | 2025-08-05 07:12:03.578547+00:00 [info] <0.545.0> Message store for directory '/var/lib/rabbitmq/mnesia/rabbit@0075a7a90978/msg_stores/vhosts/A92BKDAKQSPD3L7OSOE7MWMFG/msg_store_transient' is stopped
Container magic-redis Stopped
magic-redis exited with code 0
db | 2025-08-05T07:12:04.587651Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.43) MySQL Community Server - GPL.
Container db Stopped
db exited with code 0
Container magic-rabbitmq Stopped
root@debian:/home/s20306/magic#
如果是部署在服务器上， .env 文件里不要有 localhost 的配置
https://docs.letsmagic.cn/zh/development/quick-start/quick-introduction.html
我遇到同样的问题，在ubuntu 24.04下安装，解决办法是： 1、运行安装脚本时，安装选项必须选择远程服务器，然后输入服务器的本地IP（如果需要使用服务器的本地IP，而服务器同时又可以访问互联网的情况下，最好先断开服务器的互联网访问，否则安装脚本会检测到互联网IP，导致无法配置本地服务器IP）； 2、dockercompose.yaml文件中，magic-service容器的监听端口必须保持9501、9502，不能修改； 3、.env文件中下面两个参数要这样配置：其中172地址是你服务器的本地IP MAGIC_SOCKET_BASE_URL=ws://172.22.1.2:9502 MAGIC_SERVICE_BASE_URL=http://172.22.1.2:9501
