Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

قطع ناگهانی دسترسی به دیتابیس #77

Open
Kasrafegh opened this issue Jan 11, 2025 · 4 comments
Open

قطع ناگهانی دسترسی به دیتابیس #77

Kasrafegh opened this issue Jan 11, 2025 · 4 comments

Comments

@Kasrafegh
Copy link

با تغییر در تنظیمات پنل و زدن ری استارت پنل، همه اطالاعات روی سرور نمایش داده نمیشوند.
همچنین با Logout کردن دیگر امکان لاگین نیست.
چند بار این اتفاق تکرار شده
2025-01-11 18:48:48.216 UTC [1459] elora@elora_db LOG: could not receive data from client: Connection reset by peer
2025-01-11 18:48:48.220 UTC [1442] elora@elora_db LOG: could not receive data from client: Connection reset by peer
2025-01-11 18:52:18.486 UTC [1487] elora@elora_db LOG: could not receive data from client: Connection reset by peer
2025-01-11 18:52:18.492 UTC [1469] elora@elora_db LOG: could not receive data from client: Connection reset by peer
2025-01-11 18:52:18.495 UTC [1486] elora@elora_db LOG: could not receive data from client: Connection reset by peer
2025-01-11 18:52:18.496 UTC [1485] elora@elora_db LOG: could not receive data from client: Connection reset by peer
2025-01-11 18:58:57.997 UTC [1520] elora@elora_db LOG: could not receive data from client: Connection reset by peer
2025-01-11 18:58:58.009 UTC [1519] elora@elora_db LOG: could not receive data from client: Connection reset by peer
2025-01-11 18:58:58.012 UTC [1517] elora@elora_db LOG: could not receive data from client: Connection reset by peer
2025-01-11 18:58:58.016 UTC [1501] elora@elora_db LOG: could not receive data from client: Connection reset by peer

لاگ دیتابیس
@Kasrafegh
Copy link
Author

لاگ مرتبط با این موضوع
صرفا از زمان شروع اجرای اسکریپت تا اضافه کردن s به http در ستینگ و پاک شدن موارد دیگه و عدم دسترسی به دیتابیس:
INFO: 151.238.7.47:46608 - "GET /api/users?offset=0&limit=10&sort=-created&is_debt=false HTTP/1.1" 307 Temporary Redirect
INFO: 151.238.7.47:28363 - "GET /api/users/?offset=0&limit=10&sort=-created HTTP/1.1" 200 OK
INFO: 151.238.7.47:46608 - "GET /api/users/?offset=0&limit=10&sort=-created&is_debt=false HTTP/1.1" 200 OK
INFO: 151.238.7.47:46608 - "GET /api/settings HTTP/1.1" 200 OK
INFO: 151.238.7.47:52218 - "POST /api/settings/bulk HTTP/1.1" 200 OK
INFO: 151.238.7.47:52218 - "POST /api/restart HTTP/1.1" 200 OK
2025-01-11 19:14:59,521 - INFO - server.shutdown:265 - Shutting down
2025-01-11 19:14:59,622 - INFO - on.shutdown:67 - Waiting for application shutdown.
2025-01-11 19:14:59,622 - INFO - on.shutdown:78 - Application shutdown complete.
2025-01-11 19:14:59,622 - INFO - server.serve:86 - Finished server process [2303]
Telegram Bot not set!
Telegram Payment Bot not set!
Remove disabled account JOBS are disabled!
2025-01-11 19:15:08,997 - INFO - server.serve:76 - Started server process [2337]
2025-01-11 19:15:08,997 - INFO - on.startup:48 - Waiting for application startup.
2025-01-11 19:15:08,999 - INFO - init.on_startup:175 - Application started successfully!
2025-01-11 19:15:09,000 - INFO - on.startup:62 - Application startup complete.
2025-01-11 19:15:09,001 - INFO - server._log_started_message:219 - Uvicorn running on https://0.0.0.0:8080 (Press CTRL+C to quit)
2025-01-11 19:16:08,808 - INFO - order_jobs.process_paid_orders:51 - Process Paid Orders
2025-01-11 19:16:08,821 - INFO - account_jobs.run_review_account_jobs:770 - Start Review Account Jobs
2025-01-11 19:16:08,822 - INFO - account_jobs.review_accounts:598 - Start Review Accounts
2025-01-11 19:16:08,833 - INFO - account_jobs.sync_new_accounts:376 - Start syncing new accounts in all inbounds
2025-01-11 19:16:08,849 - INFO - notification_jobs.process_pending_notifications:135 - Process Pending and approved notifications
2025-01-11 19:16:09,119 - INFO - account_jobs.review_accounts:652 - End Review Accounts
2025-01-11 19:16:09,121 - INFO - account_jobs.clean_up_inbounds:271 - Start Cleanup Inbounds
2025-01-11 19:16:09,131 - INFO - account_jobs.sync_new_accounts:436 - End Sync new accounts in all Inbounds in 0.2976500988006592 Sec
2025-01-11 19:16:09,138 - INFO - account_jobs.clean_up_inbounds:371 - End Cleanup Inbounds in 0.016304969787597656 Sec
2025-01-11 19:16:09,139 - INFO - account_jobs.run_review_account_jobs:774 - End Review Account Jobs
2025-01-11 19:17:08,814 - INFO - order_jobs.process_paid_orders:51 - Process Paid Orders
2025-01-11 19:17:08,815 - INFO - account_jobs.run_review_account_jobs:770 - Start Review Account Jobs
2025-01-11 19:17:08,817 - INFO - account_jobs.review_accounts:598 - Start Review Accounts
2025-01-11 19:17:08,815 - INFO - notification_jobs.process_pending_notifications:135 - Process Pending and approved notifications
2025-01-11 19:17:08,815 - INFO - account_jobs.sync_new_accounts:376 - Start syncing new accounts in all inbounds
2025-01-11 19:17:08,836 - INFO - account_jobs.sync_new_accounts:436 - End Sync new accounts in all Inbounds in 0.013932943344116211 Sec
2025-01-11 19:17:08,839 - INFO - account_jobs.review_accounts:652 - End Review Accounts
2025-01-11 19:17:08,839 - INFO - account_jobs.clean_up_inbounds:271 - Start Cleanup Inbounds
2025-01-11 19:17:08,845 - INFO - account_jobs.clean_up_inbounds:371 - End Cleanup Inbounds in 0.005074024200439453 Sec
2025-01-11 19:17:08,845 - INFO - account_jobs.run_review_account_jobs:774 - End Review Account Jobs
2025-01-11 19:18:08,807 - INFO - order_jobs.process_paid_orders:51 - Process Paid Orders
2025-01-11 19:18:08,810 - INFO - account_jobs.run_review_account_jobs:770 - Start Review Account Jobs
2025-01-11 19:18:08,810 - INFO - account_jobs.review_accounts:598 - Start Review Accounts
2025-01-11 19:18:08,810 - INFO - account_jobs.sync_new_accounts:376 - Start syncing new accounts in all inbounds
2025-01-11 19:18:08,814 - INFO - notification_jobs.process_pending_notifications:135 - Process Pending and approved notifications
2025-01-11 19:18:08,829 - INFO - account_jobs.review_accounts:652 - End Review Accounts
2025-01-11 19:18:08,831 - INFO - account_jobs.clean_up_inbounds:271 - Start Cleanup Inbounds
2025-01-11 19:18:08,835 - INFO - account_jobs.sync_new_accounts:436 - End Sync new accounts in all Inbounds in 0.022806167602539062 Sec
2025-01-11 19:18:08,841 - INFO - account_jobs.clean_up_inbounds:371 - End Cleanup Inbounds in 0.008022069931030273 Sec
2025-01-11 19:18:08,841 - INFO - account_jobs.run_review_account_jobs:774 - End Review Account Jobs
2025-01-11 19:19:08,809 - INFO - order_jobs.process_paid_orders:51 - Process Paid Orders
2025-01-11 19:19:08,810 - INFO - account_jobs.run_review_account_jobs:770 - Start Review Account Jobs
2025-01-11 19:19:08,812 - INFO - account_jobs.review_accounts:598 - Start Review Accounts
2025-01-11 19:19:08,810 - INFO - account_jobs.sync_new_accounts:376 - Start syncing new accounts in all inbounds
2025-01-11 19:19:08,813 - INFO - notification_jobs.process_pending_notifications:135 - Process Pending and approved notifications
2025-01-11 19:19:08,829 - INFO - account_jobs.review_accounts:652 - End Review Accounts
2025-01-11 19:19:08,831 - INFO - account_jobs.clean_up_inbounds:271 - Start Cleanup Inbounds
2025-01-11 19:19:08,830 - INFO - account_jobs.sync_new_accounts:436 - End Sync new accounts in all Inbounds in 0.015571117401123047 Sec
2025-01-11 19:19:08,836 - INFO - account_jobs.clean_up_inbounds:371 - End Cleanup Inbounds in 0.004866838455200195 Sec
2025-01-11 19:19:08,836 - INFO - account_jobs.run_review_account_jobs:774 - End Review Account Jobs
2025-01-11 19:20:08,806 - INFO - order_jobs.process_paid_orders:51 - Process Paid Orders
2025-01-11 19:20:08,809 - INFO - account_jobs.run_review_account_jobs:770 - Start Review Account Jobs
2025-01-11 19:20:08,809 - INFO - account_jobs.review_accounts:598 - Start Review Accounts
2025-01-11 19:20:08,809 - INFO - account_jobs.sync_new_accounts:376 - Start syncing new accounts in all inbounds
2025-01-11 19:20:08,813 - INFO - notification_jobs.process_pending_notifications:135 - Process Pending and approved notifications
2025-01-11 19:20:08,822 - INFO - account_jobs.review_accounts:652 - End Review Accounts
2025-01-11 19:20:08,824 - INFO - account_jobs.clean_up_inbounds:271 - Start Cleanup Inbounds
2025-01-11 19:20:08,827 - INFO - account_jobs.sync_new_accounts:436 - End Sync new accounts in all Inbounds in 0.01573801040649414 Sec
2025-01-11 19:20:08,831 - INFO - account_jobs.clean_up_inbounds:371 - End Cleanup Inbounds in 0.006348133087158203 Sec
2025-01-11 19:20:08,831 - INFO - account_jobs.run_review_account_jobs:774 - End Review Account Jobs
INFO: 151.238.7.47:60783 - "GET /static/config.json HTTP/1.1" 200 OK
INFO: 151.238.7.47:16823 - "POST /api/admin/token HTTP/1.1" 401 Unauthorized
INFO: 151.238.7.47:16823 - "GET /login HTTP/1.1" 200 OK
INFO: 151.238.7.47:16823 - "GET /static/config.json HTTP/1.1" 200 OK
^[[A^[[A^C
root@id-472306:# ^C
root@id-472306:# sudo nano /opt/elora-vpn/.env
root@id-472306:~# tail -f /var/log/elora-vpn/elora-vpn.log
2025-01-11 19:20:08,813 - INFO - notification_jobs.process_pending_notifications:135 - Process Pending and approved notifications
2025-01-11 19:20:08,822 - INFO - account_jobs.review_accounts:652 - End Review Accounts
2025-01-11 19:20:08,824 - INFO - account_jobs.clean_up_inbounds:271 - Start Cleanup Inbounds
2025-01-11 19:20:08,827 - INFO - account_jobs.sync_new_accounts:436 - End Sync new accounts in all Inbounds in 0.01573801040649414 Sec
2025-01-11 19:20:08,831 - INFO - account_jobs.clean_up_inbounds:371 - End Cleanup Inbounds in 0.006348133087158203 Sec
2025-01-11 19:20:08,831 - INFO - account_jobs.run_review_account_jobs:774 - End Review Account Jobs
INFO: 151.238.7.47:60783 - "GET /static/config.json HTTP/1.1" 200 OK
INFO: 151.238.7.47:16823 - "POST /api/admin/token HTTP/1.1" 401 Unauthorized
INFO: 151.238.7.47:16823 - "GET /login HTTP/1.1" 200 OK
INFO: 151.238.7.47:16823 - "GET /static/config.json HTTP/1.1" 200 OK
INFO: 151.238.7.47:14881 - "POST /api/admin/token HTTP/1.1" 200 OK
INFO: 151.238.7.47:14881 - "GET /api/accounts?offset=0&limit=10&sort=expire HTTP/1.1" 307 Temporary Redirect
INFO: 151.238.7.47:14881 - "GET /api/accounts/report HTTP/1.1" 200 OK
INFO: 151.238.7.47:53405 - "GET /api/accounts/?offset=0&limit=10&sort=expire HTTP/1.1" 200 OK
INFO: 151.238.7.47:22656 - "GET /api/settings HTTP/1.1" 200 OK
2025-01-11 19:21:08,807 - INFO - order_jobs.process_paid_orders:51 - Process Paid Orders
2025-01-11 19:21:08,810 - INFO - account_jobs.run_review_account_jobs:770 - Start Review Account Jobs
2025-01-11 19:21:08,810 - INFO - account_jobs.review_accounts:598 - Start Review Accounts
2025-01-11 19:21:08,810 - INFO - account_jobs.sync_new_accounts:376 - Start syncing new accounts in all inbounds
2025-01-11 19:21:08,814 - INFO - notification_jobs.process_pending_notifications:135 - Process Pending and approved notifications
2025-01-11 19:21:08,824 - INFO - account_jobs.review_accounts:652 - End Review Accounts
2025-01-11 19:21:08,826 - INFO - account_jobs.clean_up_inbounds:271 - Start Cleanup Inbounds
2025-01-11 19:21:08,825 - INFO - account_jobs.sync_new_accounts:436 - End Sync new accounts in all Inbounds in 0.013316154479980469 Sec
2025-01-11 19:21:08,833 - INFO - account_jobs.clean_up_inbounds:371 - End Cleanup Inbounds in 0.005326986312866211 Sec
2025-01-11 19:21:08,834 - INFO - account_jobs.run_review_account_jobs:774 - End Review Account Jobs
INFO: 151.238.7.47:15006 - "GET /api/hosts?sort=-created HTTP/1.1" 307 Temporary Redirect
INFO: 151.238.7.47:45626 - "GET /api/host-zones HTTP/1.1" 307 Temporary Redirect
INFO: 151.238.7.47:22145 - "GET /api/hosts?sort=-created&zone_id=0 HTTP/1.1" 307 Temporary Redirect
INFO: 151.238.7.47:15006 - "GET /api/hosts/?sort=-created HTTP/1.1" 200 OK
INFO: 151.238.7.47:45626 - "GET /api/host-zones/ HTTP/1.1" 200 OK
INFO: 151.238.7.47:22145 - "GET /api/hosts/?sort=-created&zone_id=0 HTTP/1.1" 200 OK
INFO: 151.238.7.47:22145 - "GET /api/host-zones HTTP/1.1" 307 Temporary Redirect
INFO: 151.238.7.47:22145 - "GET /api/host-zones/ HTTP/1.1" 200 OK
INFO: 151.238.7.47:59790 - "POST /api/hosts HTTP/1.1" 307 Temporary Redirect
INFO: 151.238.7.47:59790 - "POST /api/hosts/ HTTP/1.1" 200 OK
INFO: 151.238.7.47:41969 - "GET /api/host-zones?offset=0&limit=10&sort=-created HTTP/1.1" 307 Temporary Redirect
INFO: 151.238.7.47:41969 - "GET /api/host-zones/?offset=0&limit=10&sort=-created HTTP/1.1" 200 OK
2025-01-11 19:22:08,807 - INFO - order_jobs.process_paid_orders:51 - Process Paid Orders
2025-01-11 19:22:08,810 - INFO - account_jobs.run_review_account_jobs:770 - Start Review Account Jobs
2025-01-11 19:22:08,811 - INFO - account_jobs.review_accounts:598 - Start Review Accounts
2025-01-11 19:22:08,811 - INFO - account_jobs.sync_new_accounts:376 - Start syncing new accounts in all inbounds
2025-01-11 19:22:08,815 - INFO - notification_jobs.process_pending_notifications:135 - Process Pending and approved notifications
2025-01-11 19:22:08,824 - INFO - account_jobs.sync_new_accounts:436 - End Sync new accounts in all Inbounds in 0.011771917343139648 Sec
2025-01-11 19:22:08,827 - INFO - account_jobs.review_accounts:652 - End Review Accounts
2025-01-11 19:22:08,827 - INFO - account_jobs.clean_up_inbounds:271 - Start Cleanup Inbounds
2025-01-11 19:22:08,831 - INFO - account_jobs.clean_up_inbounds:371 - End Cleanup Inbounds in 0.0031731128692626953 Sec
2025-01-11 19:22:08,831 - INFO - account_jobs.run_review_account_jobs:774 - End Review Account Jobs
INFO: 151.238.7.47:45737 - "GET /api/users?offset=0&limit=10&sort=-created HTTP/1.1" 307 Temporary Redirect
INFO: 151.238.7.47:58334 - "GET /api/users?offset=0&limit=10&sort=-created&is_debt=false HTTP/1.1" 307 Temporary Redirect
INFO: 151.238.7.47:45737 - "GET /api/users/?offset=0&limit=10&sort=-created HTTP/1.1" 200 OK
INFO: 151.238.7.47:58334 - "GET /api/users/?offset=0&limit=10&sort=-created&is_debt=false HTTP/1.1" 200 OK
INFO: 151.238.7.47:49277 - "GET /api/settings HTTP/1.1" 200 OK
INFO: 151.238.7.47:49277 - "GET /api/payment-accounts?offset=0&limit=10&sort=-created HTTP/1.1" 307 Temporary Redirect
INFO: 151.238.7.47:49277 - "GET /api/payment-accounts/?offset=0&limit=10&sort=-created HTTP/1.1" 200 OK
INFO: 151.238.7.47:57330 - "POST /api/settings/bulk HTTP/1.1" 200 OK
INFO: 151.238.7.47:40195 - "POST /api/settings/bulk HTTP/1.1" 200 OK
INFO: 151.238.7.47:40195 - "POST /api/restart HTTP/1.1" 200 OK
2025-01-11 19:22:56,035 - INFO - server.shutdown:265 - Shutting down
2025-01-11 19:22:56,136 - INFO - server._wait_tasks_to_complete:305 - Waiting for connections to close. (CTRL+C to force quit)
2025-01-11 19:23:08,806 - INFO - order_jobs.process_paid_orders:51 - Process Paid Orders
2025-01-11 19:23:08,810 - INFO - account_jobs.run_review_account_jobs:770 - Start Review Account Jobs
2025-01-11 19:23:08,811 - INFO - account_jobs.review_accounts:598 - Start Review Accounts
2025-01-11 19:23:08,811 - INFO - account_jobs.sync_new_accounts:376 - Start syncing new accounts in all inbounds
2025-01-11 19:23:08,818 - INFO - notification_jobs.process_pending_notifications:135 - Process Pending and approved notifications
2025-01-11 19:23:08,826 - INFO - account_jobs.sync_new_accounts:436 - End Sync new accounts in all Inbounds in 0.009797096252441406 Sec
2025-01-11 19:23:08,836 - INFO - account_jobs.review_accounts:652 - End Review Accounts
2025-01-11 19:23:08,837 - INFO - account_jobs.clean_up_inbounds:271 - Start Cleanup Inbounds
2025-01-11 19:23:08,842 - INFO - account_jobs.clean_up_inbounds:371 - End Cleanup Inbounds in 0.00506281852722168 Sec
2025-01-11 19:23:08,842 - INFO - account_jobs.run_review_account_jobs:774 - End Review Account Jobs
2025-01-11 19:23:58,208 - INFO - on.shutdown:67 - Waiting for application shutdown.
2025-01-11 19:23:58,209 - INFO - on.shutdown:78 - Application shutdown complete.
2025-01-11 19:23:58,210 - INFO - server.serve:86 - Finished server process [2337]
Telegram Bot not set!
Telegram Payment Bot not set!
Remove disabled account JOBS are disabled!
2025-01-11 19:24:07,528 - INFO - server.serve:76 - Started server process [2387]
2025-01-11 19:24:07,528 - INFO - on.startup:48 - Waiting for application startup.
2025-01-11 19:24:07,530 - INFO - init.on_startup:175 - Application started successfully!
2025-01-11 19:24:07,530 - INFO - on.startup:62 - Application startup complete.
2025-01-11 19:24:07,531 - INFO - server._log_started_message:219 - Uvicorn running on https://0.0.0.0:8080 (Press CTRL+C to quit)
INFO: 151.238.7.47:28836 - "GET /settings HTTP/1.1" 200 OK
INFO: 151.238.7.47:28836 - "GET /static/config.json HTTP/1.1" 200 OK

@eloravpn
Copy link
Owner

در این لاگ خطایی مشاهده نمیشه.
از طریق کامند هم پنل رو ری-استارت کردید؟

@Kasrafegh
Copy link
Author

بله تست کردم و همچنین گفتم شاید به خاطر مرورگر باشه اما باز هم نشد. لاگ دیتابیس رو هم فرستادم بررسی فرمودید؟

@eloravpn
Copy link
Owner

لاگ دیتابیس مربوط به ساعت 18 و لاگ بعدی مربوط به ساعت 19 هست.
در لاگ های پنل مشکلی از عدم اتصال به دیتابیس نیست.
احتمالا در تنظیمات پنل برای base url تغییر اشتباهی دادید.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@eloravpn @Kasrafegh