chenlin/migu_music_server
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
main
migu_music_server/temp/logs/2025-03-27.log
chenlin 053b9951fe first commit
2025-03-28 14:07:20 +08:00

76 lines
14 KiB
Plaintext
Raw Permalink Blame History

This file contains invisible Unicode characters

This file contains invisible Unicode characters that are indistinguishable to humans but may be processed differently by a computer. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

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
Reference in New Issue View Git Blame Copy Permalink