14 KiB
14 KiB
2025-03-27 16:45:55.515+0800 info * =>
2025-03-27 16:45:55.626+0800 info mysql connect success !
2025-03-27 16:45:55.646+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/gorm.io/driver/mysql@v1.3.5/migrator.go:250 [19.221ms] [rows:-] SELECT DATABASE()
2025-03-27 16:45:55.681+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/gorm.io/driver/mysql@v1.3.5/migrator.go:253 [35.609ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'migu_pro%' ORDER BY SCHEMA_NAME='migu_pro' DESC,SCHEMA_NAME limit 1
2025-03-27 16:45:55.775+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/github.com/go-admin-team/gorm-adapter/v3@v3.7.8-0.20220809100335-eaf9f67b3d21/adapter.go:365 [93.935ms] [rows:-] SELECT count(*) FROM information_schema.tables WHERE table_schema = 'migu_pro' AND table_name = 'sys_casbin_rule' AND table_type = 'BASE TABLE'
2025-03-27 16:45:55.850+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/gorm.io/driver/mysql@v1.3.5/migrator.go:250 [74.881ms] [rows:-] SELECT DATABASE()
2025-03-27 16:45:55.888+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/gorm.io/driver/mysql@v1.3.5/migrator.go:253 [37.525ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'migu_pro%' ORDER BY SCHEMA_NAME='migu_pro' DESC,SCHEMA_NAME limit 1
2025-03-27 16:45:55.964+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/gorm.io/driver/mysql@v1.3.5/migrator.go:163 [75.280ms] [rows:-] SELECT * FROM `sys_casbin_rule` LIMIT 1
2025-03-27 16:45:56.220+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/gorm.io/driver/mysql@v1.3.5/migrator.go:181 [255.672ms] [rows:-] SELECT column_name, column_default, is_nullable = 'YES', data_type, character_maximum_length, column_type, column_key, extra, column_comment, numeric_precision, numeric_scale , datetime_precision FROM information_schema.columns WHERE table_schema = 'migu_pro' AND table_name = 'sys_casbin_rule' ORDER BY ORDINAL_POSITION
2025-03-27 16:45:56.296+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/gorm.io/driver/mysql@v1.3.5/migrator.go:250 [75.163ms] [rows:-] SELECT DATABASE()
2025-03-27 16:45:56.333+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/gorm.io/driver/mysql@v1.3.5/migrator.go:253 [36.410ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'migu_pro%' ORDER BY SCHEMA_NAME='migu_pro' DESC,SCHEMA_NAME limit 1
2025-03-27 16:45:56.425+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/github.com/go-admin-team/gorm-adapter/v3@v3.7.8-0.20220809100335-eaf9f67b3d21/adapter.go:371 [92.134ms] [rows:-] SELECT count(*) FROM information_schema.statistics WHERE table_schema = 'migu_pro' AND table_name = 'sys_casbin_rule' AND index_name = 'idx_sys_casbin_rule'
2025-03-27 16:45:56.500+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/github.com/go-admin-team/gorm-adapter/v3@v3.7.8-0.20220809100335-eaf9f67b3d21/adapter.go:415 [74.384ms] [rows:0] SELECT * FROM `sys_casbin_rule` ORDER BY ID
2025-03-27 16:45:56.737+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/github.com/go-admin-team/gorm-adapter/v3@v3.7.8-0.20220809100335-eaf9f67b3d21/adapter.go:415 [236.714ms] [rows:0] SELECT * FROM `sys_casbin_rule` ORDER BY ID
2025-03-27 16:45:57.692+0800 trace /Users/max/Documents/code/deovo/2024-migu/migu_music_server/app/jobs/models/sys_job.go:48 [38.975ms] [rows:0] SELECT * FROM `sys_job` WHERE status = 2 AND `sys_job`.`deleted_at` IS NULL
2025-03-27 16:45:57.883+0800 trace /Users/max/Documents/code/deovo/2024-migu/migu_music_server/app/jobs/models/sys_job.go:57 [190.273ms] [rows:0] UPDATE `sys_job` SET `entry_id`=0 WHERE entry_id > 0
2025-03-27 16:46:10.205+0800 info MusicFeedback-start
2025-03-27 16:46:10.205+0800 info Body Params:{
"MSISDN": "13590423587",
"revdate": "20250327164438",
"rescode": "0000",
"resdesc": "成功",
"msg": "BJTD@00211NV@@698039049108516515@order@1990"
}
2025-03-27 16:46:10.205+0800 info MusicFeedback req:&{13590423587 20250327164438 0000 成功 BJTD@00211NV@@698039049108516515@order@1990}
2025-03-27 16:46:10.368+0800 trace 9aa91570-5323-47ce-a7c0-557002e0cc14 /Users/max/Documents/code/deovo/2024-migu/migu_music_server/app/admin/models/strategy.go:67 [162.538ms] [rows:1] SELECT EXISTS (SELECT * FROM mg_transaction_log WHERE out_trade_no='2503272928589980694') AS record_exist;
2025-03-27 16:46:12.177+0800 trace 9aa91570-5323-47ce-a7c0-557002e0cc14 /Users/max/Documents/code/deovo/2024-migu/migu_music_server/app/admin/apis/migumanage/migu_music.go:103 [352.527ms] [rows:1] INSERT INTO `mg_transaction_log` (`created_at`,`updated_at`,`deleted_at`,`product_id`,`channel_code`,`province`,`phone_number`,`out_trade_no`,`link_id`,`channel_trade_no`,`result`,`reason`,`verification_code`,`order_time`) VALUES ('2025-03-27 16:46:11.843','2025-03-27 16:46:11.843',NULL,2,'00211NV','','13590423587','2503272928589980694','','','0000','[成功]:BJTD@00211NV@@698039049108516515@order@1990','999999',NULL)
2025-03-27 16:46:27.892+0800 info 9aa91570-5323-47ce-a7c0-557002e0cc14 MusicFeedback-end
2025-03-27 16:46:27.892+0800 127.0.0.1 25.610922959s info POST 200 /api/v1/migu/music/feedback 9aa91570-5323-47ce-a7c0-557002e0cc14
2025-03-27 16:46:41.894+0800 127.0.0.1 25.610922959s info POST 200 /api/v1/migu/music/feedback 9aa91570-5323-47ce-a7c0-557002e0cc14 MusicFeedback-start
2025-03-27 16:46:41.894+0800 127.0.0.1 25.610922959s info POST 200 /api/v1/migu/music/feedback 9aa91570-5323-47ce-a7c0-557002e0cc14 Body Params:{
"MSISDN": "13590423587",
"revdate": "20250327164438",
"rescode": "000000",
"resdesc": "成功",
"msg": "BJTD@00211NV@@698039049108516515@order@1990"
}
2025-03-27 16:46:41.895+0800 127.0.0.1 25.610922959s info POST 200 /api/v1/migu/music/feedback 9aa91570-5323-47ce-a7c0-557002e0cc14 MusicFeedback req:&{13590423587 20250327164438 000000 成功 BJTD@00211NV@@698039049108516515@order@1990}
2025-03-27 16:46:42.051+0800 trace 37817618-176f-44ce-b577-2d6330ed204a /Users/max/Documents/code/deovo/2024-migu/migu_music_server/app/admin/models/strategy.go:67 [156.763ms] [rows:1] SELECT EXISTS (SELECT * FROM mg_transaction_log WHERE out_trade_no='2503277030250887909') AS record_exist;
2025-03-27 16:46:43.620+0800 trace 37817618-176f-44ce-b577-2d6330ed204a /Users/max/Documents/code/deovo/2024-migu/migu_music_server/app/admin/apis/migumanage/migu_music.go:103 [136.040ms] [rows:1] INSERT INTO `mg_transaction_log` (`created_at`,`updated_at`,`deleted_at`,`product_id`,`channel_code`,`province`,`phone_number`,`out_trade_no`,`link_id`,`channel_trade_no`,`result`,`reason`,`verification_code`,`order_time`) VALUES ('2025-03-27 16:46:43.505','2025-03-27 16:46:43.505',NULL,2,'00211NV','','13590423587','2503277030250887909','','','000000','[成功]:BJTD@00211NV@@698039049108516515@order@1990','666666',NULL)
2025-03-27 16:46:46.986+0800 trace 37817618-176f-44ce-b577-2d6330ed204a /Users/max/Documents/code/deovo/2024-migu/migu_music_server/app/admin/apis/migumanage/migu_music.go:112 [52.577ms] [rows:1] SELECT * FROM `mg_order` WHERE phone_number = '13590423587' ORDER BY subscribe_time DESC,`mg_order`.`id` LIMIT 1
2025-03-27 16:48:08.008+0800 trace 37817618-176f-44ce-b577-2d6330ed204a /Users/max/Documents/code/deovo/2024-migu/migu_music_server/app/admin/apis/migumanage/migu_music.go:151 [174.716ms] [rows:4] UPDATE `mg_order` SET `is_one_hour_cancel`=1,`state`=2,`unsubscribe_time`='2025-03-27 16:47:24',`updated_at`='2025-03-27 16:48:07.833' WHERE phone_number = '13590423587'
2025-03-27 16:48:08.008+0800 info 37817618-176f-44ce-b577-2d6330ed204a MusicFeedback-end
2025-03-27 16:48:08.008+0800 127.0.0.1 1m28.052008166s info POST 200 /api/v1/migu/music/feedback 37817618-176f-44ce-b577-2d6330ed204a
2025-03-27 17:57:09.109+0800 info * =>
2025-03-27 17:57:09.272+0800 info mysql connect success !
2025-03-27 17:57:09.300+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/gorm.io/driver/mysql@v1.3.5/migrator.go:250 [26.383ms] [rows:-] SELECT DATABASE()
2025-03-27 17:57:09.353+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/gorm.io/driver/mysql@v1.3.5/migrator.go:253 [53.269ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'migu_pro%' ORDER BY SCHEMA_NAME='migu_pro' DESC,SCHEMA_NAME limit 1
2025-03-27 17:57:09.472+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/github.com/go-admin-team/gorm-adapter/v3@v3.7.8-0.20220809100335-eaf9f67b3d21/adapter.go:365 [118.820ms] [rows:-] SELECT count(*) FROM information_schema.tables WHERE table_schema = 'migu_pro' AND table_name = 'sys_casbin_rule' AND table_type = 'BASE TABLE'
2025-03-27 17:57:09.564+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/gorm.io/driver/mysql@v1.3.5/migrator.go:250 [91.517ms] [rows:-] SELECT DATABASE()
2025-03-27 17:57:09.620+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/gorm.io/driver/mysql@v1.3.5/migrator.go:253 [56.062ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'migu_pro%' ORDER BY SCHEMA_NAME='migu_pro' DESC,SCHEMA_NAME limit 1
2025-03-27 17:57:09.711+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/gorm.io/driver/mysql@v1.3.5/migrator.go:163 [91.182ms] [rows:-] SELECT * FROM `sys_casbin_rule` LIMIT 1
2025-03-27 17:57:09.991+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/gorm.io/driver/mysql@v1.3.5/migrator.go:181 [279.156ms] [rows:-] SELECT column_name, column_default, is_nullable = 'YES', data_type, character_maximum_length, column_type, column_key, extra, column_comment, numeric_precision, numeric_scale , datetime_precision FROM information_schema.columns WHERE table_schema = 'migu_pro' AND table_name = 'sys_casbin_rule' ORDER BY ORDINAL_POSITION
2025-03-27 17:57:10.081+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/gorm.io/driver/mysql@v1.3.5/migrator.go:250 [90.434ms] [rows:-] SELECT DATABASE()
2025-03-27 17:57:10.135+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/gorm.io/driver/mysql@v1.3.5/migrator.go:253 [53.483ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'migu_pro%' ORDER BY SCHEMA_NAME='migu_pro' DESC,SCHEMA_NAME limit 1
2025-03-27 17:57:10.253+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/github.com/go-admin-team/gorm-adapter/v3@v3.7.8-0.20220809100335-eaf9f67b3d21/adapter.go:371 [118.027ms] [rows:-] SELECT count(*) FROM information_schema.statistics WHERE table_schema = 'migu_pro' AND table_name = 'sys_casbin_rule' AND index_name = 'idx_sys_casbin_rule'
2025-03-27 17:57:10.351+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/github.com/go-admin-team/gorm-adapter/v3@v3.7.8-0.20220809100335-eaf9f67b3d21/adapter.go:415 [95.702ms] [rows:0] SELECT * FROM `sys_casbin_rule` ORDER BY ID
2025-03-27 17:57:10.379+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/github.com/go-admin-team/gorm-adapter/v3@v3.7.8-0.20220809100335-eaf9f67b3d21/adapter.go:415 [27.866ms] [rows:0] SELECT * FROM `sys_casbin_rule` ORDER BY ID
2025-03-27 17:57:12.914+0800 trace /Users/max/Documents/code/deovo/2024-migu/migu_music_server/app/jobs/models/sys_job.go:48 [59.422ms] [rows:0] SELECT * FROM `sys_job` WHERE status = 2 AND `sys_job`.`deleted_at` IS NULL
2025-03-27 17:57:13.379+0800 trace /Users/max/Documents/code/deovo/2024-migu/migu_music_server/app/jobs/models/sys_job.go:57 [464.320ms] [rows:0] UPDATE `sys_job` SET `entry_id`=0 WHERE entry_id > 0
2025-03-27 17:57:21.405+0800 info MusicFeedback-start
2025-03-27 17:57:21.405+0800 info Body Params:{
"MSISDN": "13590423587",
"revdate": "20250327164438",
"rescode": "000000",
"resdesc": "成功",
"msg": "BJHY@00211NV@@698039049108516515@order@1990"
}
2025-03-27 17:57:21.405+0800 info MusicFeedback req:&{13590423587 20250327164438 000000 成功 BJHY@00211NV@@698039049108516515@order@1990}
2025-03-27 17:57:21.587+0800 trace 34ee677a-2883-452d-9b23-c3832d7d3e82 /Users/max/Documents/code/deovo/2024-migu/migu_music_server/app/admin/models/strategy.go:67 [181.190ms] [rows:1] SELECT EXISTS (SELECT * FROM mg_transaction_log WHERE out_trade_no='2503278369208457379') AS record_exist;
2025-03-27 17:57:24.494+0800 trace 34ee677a-2883-452d-9b23-c3832d7d3e82 /Users/max/Documents/code/deovo/2024-migu/migu_music_server/app/admin/apis/migumanage/migu_music.go:103 [179.419ms] [rows:1] INSERT INTO `mg_transaction_log` (`created_at`,`updated_at`,`deleted_at`,`product_id`,`channel_code`,`province`,`phone_number`,`out_trade_no`,`link_id`,`channel_trade_no`,`result`,`reason`,`verification_code`,`order_time`) VALUES ('2025-03-27 17:57:24.344','2025-03-27 17:57:24.344',NULL,2,'00211NV','','13590423587','2503278369208457379','','','000000','[成功]:BJHY@00211NV@@698039049108516515@order@1990','666666',NULL)
2025-03-27 17:57:27.581+0800 trace 34ee677a-2883-452d-9b23-c3832d7d3e82 /Users/max/Documents/code/deovo/2024-migu/migu_music_server/app/admin/apis/migumanage/migu_music.go:112 [73.465ms] [rows:1] SELECT * FROM `mg_order` WHERE phone_number = '13590423587' ORDER BY subscribe_time DESC,`mg_order`.`id` LIMIT 1
2025-03-27 17:57:40.185+0800 trace 34ee677a-2883-452d-9b23-c3832d7d3e82 /Users/max/Documents/code/deovo/2024-migu/migu_music_server/app/admin/models/strategy.go:67 [166.355ms] [rows:1] SELECT EXISTS (SELECT * FROM mg_transaction_log WHERE out_trade_no='2503273007236894666') AS record_exist;
2025-03-27 17:57:40.185+0800 info 34ee677a-2883-452d-9b23-c3832d7d3e82 MusicFeedback-end
2025-03-27 17:57:40.185+0800 127.0.0.1 24.835398s info POST 200 /api/v1/migu/music/feedback 34ee677a-2883-452d-9b23-c3832d7d3e82
2025-03-27 16:45:55.626+0800 info mysql connect success !
2025-03-27 16:45:55.646+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/gorm.io/driver/mysql@v1.3.5/migrator.go:250 [19.221ms] [rows:-] SELECT DATABASE()
2025-03-27 16:45:55.681+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/gorm.io/driver/mysql@v1.3.5/migrator.go:253 [35.609ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'migu_pro%' ORDER BY SCHEMA_NAME='migu_pro' DESC,SCHEMA_NAME limit 1
2025-03-27 16:45:55.775+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/github.com/go-admin-team/gorm-adapter/v3@v3.7.8-0.20220809100335-eaf9f67b3d21/adapter.go:365 [93.935ms] [rows:-] SELECT count(*) FROM information_schema.tables WHERE table_schema = 'migu_pro' AND table_name = 'sys_casbin_rule' AND table_type = 'BASE TABLE'
2025-03-27 16:45:55.850+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/gorm.io/driver/mysql@v1.3.5/migrator.go:250 [74.881ms] [rows:-] SELECT DATABASE()
2025-03-27 16:45:55.888+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/gorm.io/driver/mysql@v1.3.5/migrator.go:253 [37.525ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'migu_pro%' ORDER BY SCHEMA_NAME='migu_pro' DESC,SCHEMA_NAME limit 1
2025-03-27 16:45:55.964+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/gorm.io/driver/mysql@v1.3.5/migrator.go:163 [75.280ms] [rows:-] SELECT * FROM `sys_casbin_rule` LIMIT 1
2025-03-27 16:45:56.220+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/gorm.io/driver/mysql@v1.3.5/migrator.go:181 [255.672ms] [rows:-] SELECT column_name, column_default, is_nullable = 'YES', data_type, character_maximum_length, column_type, column_key, extra, column_comment, numeric_precision, numeric_scale , datetime_precision FROM information_schema.columns WHERE table_schema = 'migu_pro' AND table_name = 'sys_casbin_rule' ORDER BY ORDINAL_POSITION
2025-03-27 16:45:56.296+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/gorm.io/driver/mysql@v1.3.5/migrator.go:250 [75.163ms] [rows:-] SELECT DATABASE()
2025-03-27 16:45:56.333+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/gorm.io/driver/mysql@v1.3.5/migrator.go:253 [36.410ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'migu_pro%' ORDER BY SCHEMA_NAME='migu_pro' DESC,SCHEMA_NAME limit 1
2025-03-27 16:45:56.425+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/github.com/go-admin-team/gorm-adapter/v3@v3.7.8-0.20220809100335-eaf9f67b3d21/adapter.go:371 [92.134ms] [rows:-] SELECT count(*) FROM information_schema.statistics WHERE table_schema = 'migu_pro' AND table_name = 'sys_casbin_rule' AND index_name = 'idx_sys_casbin_rule'
2025-03-27 16:45:56.500+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/github.com/go-admin-team/gorm-adapter/v3@v3.7.8-0.20220809100335-eaf9f67b3d21/adapter.go:415 [74.384ms] [rows:0] SELECT * FROM `sys_casbin_rule` ORDER BY ID
2025-03-27 16:45:56.737+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/github.com/go-admin-team/gorm-adapter/v3@v3.7.8-0.20220809100335-eaf9f67b3d21/adapter.go:415 [236.714ms] [rows:0] SELECT * FROM `sys_casbin_rule` ORDER BY ID
2025-03-27 16:45:57.692+0800 trace /Users/max/Documents/code/deovo/2024-migu/migu_music_server/app/jobs/models/sys_job.go:48 [38.975ms] [rows:0] SELECT * FROM `sys_job` WHERE status = 2 AND `sys_job`.`deleted_at` IS NULL
2025-03-27 16:45:57.883+0800 trace /Users/max/Documents/code/deovo/2024-migu/migu_music_server/app/jobs/models/sys_job.go:57 [190.273ms] [rows:0] UPDATE `sys_job` SET `entry_id`=0 WHERE entry_id > 0
2025-03-27 16:46:10.205+0800 info MusicFeedback-start
2025-03-27 16:46:10.205+0800 info Body Params:{
"MSISDN": "13590423587",
"revdate": "20250327164438",
"rescode": "0000",
"resdesc": "成功",
"msg": "BJTD@00211NV@@698039049108516515@order@1990"
}
2025-03-27 16:46:10.205+0800 info MusicFeedback req:&{13590423587 20250327164438 0000 成功 BJTD@00211NV@@698039049108516515@order@1990}
2025-03-27 16:46:10.368+0800 trace 9aa91570-5323-47ce-a7c0-557002e0cc14 /Users/max/Documents/code/deovo/2024-migu/migu_music_server/app/admin/models/strategy.go:67 [162.538ms] [rows:1] SELECT EXISTS (SELECT * FROM mg_transaction_log WHERE out_trade_no='2503272928589980694') AS record_exist;
2025-03-27 16:46:12.177+0800 trace 9aa91570-5323-47ce-a7c0-557002e0cc14 /Users/max/Documents/code/deovo/2024-migu/migu_music_server/app/admin/apis/migumanage/migu_music.go:103 [352.527ms] [rows:1] INSERT INTO `mg_transaction_log` (`created_at`,`updated_at`,`deleted_at`,`product_id`,`channel_code`,`province`,`phone_number`,`out_trade_no`,`link_id`,`channel_trade_no`,`result`,`reason`,`verification_code`,`order_time`) VALUES ('2025-03-27 16:46:11.843','2025-03-27 16:46:11.843',NULL,2,'00211NV','','13590423587','2503272928589980694','','','0000','[成功]:BJTD@00211NV@@698039049108516515@order@1990','999999',NULL)
2025-03-27 16:46:27.892+0800 info 9aa91570-5323-47ce-a7c0-557002e0cc14 MusicFeedback-end
2025-03-27 16:46:27.892+0800 127.0.0.1 25.610922959s info POST 200 /api/v1/migu/music/feedback 9aa91570-5323-47ce-a7c0-557002e0cc14
2025-03-27 16:46:41.894+0800 127.0.0.1 25.610922959s info POST 200 /api/v1/migu/music/feedback 9aa91570-5323-47ce-a7c0-557002e0cc14 MusicFeedback-start
2025-03-27 16:46:41.894+0800 127.0.0.1 25.610922959s info POST 200 /api/v1/migu/music/feedback 9aa91570-5323-47ce-a7c0-557002e0cc14 Body Params:{
"MSISDN": "13590423587",
"revdate": "20250327164438",
"rescode": "000000",
"resdesc": "成功",
"msg": "BJTD@00211NV@@698039049108516515@order@1990"
}
2025-03-27 16:46:41.895+0800 127.0.0.1 25.610922959s info POST 200 /api/v1/migu/music/feedback 9aa91570-5323-47ce-a7c0-557002e0cc14 MusicFeedback req:&{13590423587 20250327164438 000000 成功 BJTD@00211NV@@698039049108516515@order@1990}
2025-03-27 16:46:42.051+0800 trace 37817618-176f-44ce-b577-2d6330ed204a /Users/max/Documents/code/deovo/2024-migu/migu_music_server/app/admin/models/strategy.go:67 [156.763ms] [rows:1] SELECT EXISTS (SELECT * FROM mg_transaction_log WHERE out_trade_no='2503277030250887909') AS record_exist;
2025-03-27 16:46:43.620+0800 trace 37817618-176f-44ce-b577-2d6330ed204a /Users/max/Documents/code/deovo/2024-migu/migu_music_server/app/admin/apis/migumanage/migu_music.go:103 [136.040ms] [rows:1] INSERT INTO `mg_transaction_log` (`created_at`,`updated_at`,`deleted_at`,`product_id`,`channel_code`,`province`,`phone_number`,`out_trade_no`,`link_id`,`channel_trade_no`,`result`,`reason`,`verification_code`,`order_time`) VALUES ('2025-03-27 16:46:43.505','2025-03-27 16:46:43.505',NULL,2,'00211NV','','13590423587','2503277030250887909','','','000000','[成功]:BJTD@00211NV@@698039049108516515@order@1990','666666',NULL)
2025-03-27 16:46:46.986+0800 trace 37817618-176f-44ce-b577-2d6330ed204a /Users/max/Documents/code/deovo/2024-migu/migu_music_server/app/admin/apis/migumanage/migu_music.go:112 [52.577ms] [rows:1] SELECT * FROM `mg_order` WHERE phone_number = '13590423587' ORDER BY subscribe_time DESC,`mg_order`.`id` LIMIT 1
2025-03-27 16:48:08.008+0800 trace 37817618-176f-44ce-b577-2d6330ed204a /Users/max/Documents/code/deovo/2024-migu/migu_music_server/app/admin/apis/migumanage/migu_music.go:151 [174.716ms] [rows:4] UPDATE `mg_order` SET `is_one_hour_cancel`=1,`state`=2,`unsubscribe_time`='2025-03-27 16:47:24',`updated_at`='2025-03-27 16:48:07.833' WHERE phone_number = '13590423587'
2025-03-27 16:48:08.008+0800 info 37817618-176f-44ce-b577-2d6330ed204a MusicFeedback-end
2025-03-27 16:48:08.008+0800 127.0.0.1 1m28.052008166s info POST 200 /api/v1/migu/music/feedback 37817618-176f-44ce-b577-2d6330ed204a
2025-03-27 17:57:09.109+0800 info * =>
2025-03-27 17:57:09.272+0800 info mysql connect success !
2025-03-27 17:57:09.300+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/gorm.io/driver/mysql@v1.3.5/migrator.go:250 [26.383ms] [rows:-] SELECT DATABASE()
2025-03-27 17:57:09.353+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/gorm.io/driver/mysql@v1.3.5/migrator.go:253 [53.269ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'migu_pro%' ORDER BY SCHEMA_NAME='migu_pro' DESC,SCHEMA_NAME limit 1
2025-03-27 17:57:09.472+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/github.com/go-admin-team/gorm-adapter/v3@v3.7.8-0.20220809100335-eaf9f67b3d21/adapter.go:365 [118.820ms] [rows:-] SELECT count(*) FROM information_schema.tables WHERE table_schema = 'migu_pro' AND table_name = 'sys_casbin_rule' AND table_type = 'BASE TABLE'
2025-03-27 17:57:09.564+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/gorm.io/driver/mysql@v1.3.5/migrator.go:250 [91.517ms] [rows:-] SELECT DATABASE()
2025-03-27 17:57:09.620+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/gorm.io/driver/mysql@v1.3.5/migrator.go:253 [56.062ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'migu_pro%' ORDER BY SCHEMA_NAME='migu_pro' DESC,SCHEMA_NAME limit 1
2025-03-27 17:57:09.711+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/gorm.io/driver/mysql@v1.3.5/migrator.go:163 [91.182ms] [rows:-] SELECT * FROM `sys_casbin_rule` LIMIT 1
2025-03-27 17:57:09.991+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/gorm.io/driver/mysql@v1.3.5/migrator.go:181 [279.156ms] [rows:-] SELECT column_name, column_default, is_nullable = 'YES', data_type, character_maximum_length, column_type, column_key, extra, column_comment, numeric_precision, numeric_scale , datetime_precision FROM information_schema.columns WHERE table_schema = 'migu_pro' AND table_name = 'sys_casbin_rule' ORDER BY ORDINAL_POSITION
2025-03-27 17:57:10.081+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/gorm.io/driver/mysql@v1.3.5/migrator.go:250 [90.434ms] [rows:-] SELECT DATABASE()
2025-03-27 17:57:10.135+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/gorm.io/driver/mysql@v1.3.5/migrator.go:253 [53.483ms] [rows:1] SELECT SCHEMA_NAME from Information_schema.SCHEMATA where SCHEMA_NAME LIKE 'migu_pro%' ORDER BY SCHEMA_NAME='migu_pro' DESC,SCHEMA_NAME limit 1
2025-03-27 17:57:10.253+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/github.com/go-admin-team/gorm-adapter/v3@v3.7.8-0.20220809100335-eaf9f67b3d21/adapter.go:371 [118.027ms] [rows:-] SELECT count(*) FROM information_schema.statistics WHERE table_schema = 'migu_pro' AND table_name = 'sys_casbin_rule' AND index_name = 'idx_sys_casbin_rule'
2025-03-27 17:57:10.351+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/github.com/go-admin-team/gorm-adapter/v3@v3.7.8-0.20220809100335-eaf9f67b3d21/adapter.go:415 [95.702ms] [rows:0] SELECT * FROM `sys_casbin_rule` ORDER BY ID
2025-03-27 17:57:10.379+0800 trace /Users/max/.gvm/pkgsets/go1.16/global/pkg/mod/github.com/go-admin-team/gorm-adapter/v3@v3.7.8-0.20220809100335-eaf9f67b3d21/adapter.go:415 [27.866ms] [rows:0] SELECT * FROM `sys_casbin_rule` ORDER BY ID
2025-03-27 17:57:12.914+0800 trace /Users/max/Documents/code/deovo/2024-migu/migu_music_server/app/jobs/models/sys_job.go:48 [59.422ms] [rows:0] SELECT * FROM `sys_job` WHERE status = 2 AND `sys_job`.`deleted_at` IS NULL
2025-03-27 17:57:13.379+0800 trace /Users/max/Documents/code/deovo/2024-migu/migu_music_server/app/jobs/models/sys_job.go:57 [464.320ms] [rows:0] UPDATE `sys_job` SET `entry_id`=0 WHERE entry_id > 0
2025-03-27 17:57:21.405+0800 info MusicFeedback-start
2025-03-27 17:57:21.405+0800 info Body Params:{
"MSISDN": "13590423587",
"revdate": "20250327164438",
"rescode": "000000",
"resdesc": "成功",
"msg": "BJHY@00211NV@@698039049108516515@order@1990"
}
2025-03-27 17:57:21.405+0800 info MusicFeedback req:&{13590423587 20250327164438 000000 成功 BJHY@00211NV@@698039049108516515@order@1990}
2025-03-27 17:57:21.587+0800 trace 34ee677a-2883-452d-9b23-c3832d7d3e82 /Users/max/Documents/code/deovo/2024-migu/migu_music_server/app/admin/models/strategy.go:67 [181.190ms] [rows:1] SELECT EXISTS (SELECT * FROM mg_transaction_log WHERE out_trade_no='2503278369208457379') AS record_exist;
2025-03-27 17:57:24.494+0800 trace 34ee677a-2883-452d-9b23-c3832d7d3e82 /Users/max/Documents/code/deovo/2024-migu/migu_music_server/app/admin/apis/migumanage/migu_music.go:103 [179.419ms] [rows:1] INSERT INTO `mg_transaction_log` (`created_at`,`updated_at`,`deleted_at`,`product_id`,`channel_code`,`province`,`phone_number`,`out_trade_no`,`link_id`,`channel_trade_no`,`result`,`reason`,`verification_code`,`order_time`) VALUES ('2025-03-27 17:57:24.344','2025-03-27 17:57:24.344',NULL,2,'00211NV','','13590423587','2503278369208457379','','','000000','[成功]:BJHY@00211NV@@698039049108516515@order@1990','666666',NULL)
2025-03-27 17:57:27.581+0800 trace 34ee677a-2883-452d-9b23-c3832d7d3e82 /Users/max/Documents/code/deovo/2024-migu/migu_music_server/app/admin/apis/migumanage/migu_music.go:112 [73.465ms] [rows:1] SELECT * FROM `mg_order` WHERE phone_number = '13590423587' ORDER BY subscribe_time DESC,`mg_order`.`id` LIMIT 1
2025-03-27 17:57:40.185+0800 trace 34ee677a-2883-452d-9b23-c3832d7d3e82 /Users/max/Documents/code/deovo/2024-migu/migu_music_server/app/admin/models/strategy.go:67 [166.355ms] [rows:1] SELECT EXISTS (SELECT * FROM mg_transaction_log WHERE out_trade_no='2503273007236894666') AS record_exist;
2025-03-27 17:57:40.185+0800 info 34ee677a-2883-452d-9b23-c3832d7d3e82 MusicFeedback-end
2025-03-27 17:57:40.185+0800 127.0.0.1 24.835398s info POST 200 /api/v1/migu/music/feedback 34ee677a-2883-452d-9b23-c3832d7d3e82