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.

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

مشکل در ریست ترافیک یوزرها #1064

Open
hayousef68 opened this issue Jun 29, 2024 · 11 comments
Open

مشکل در ریست ترافیک یوزرها #1064

hayousef68 opened this issue Jun 29, 2024 · 11 comments
Labels
Bug Something isn't working

Comments

@hayousef68
Copy link

سلام از دیروز خیلی از یوزرهام که پیام میدن برای تمدید نمیتونم ترافیک رو ریست کنم خطا میده ( بازنشانی مصرف انجام نشد، دوباره تلاش کنید)

سرور رو عوض کردن مرزبان رو ریستارت کردم بازم درست نشد میشه راهنمایی کنین
8eeddc35-47b5-45ee-b72e-abd312e2f523

@hayousef68 hayousef68 added the Bug Something isn't working label Jun 29, 2024
@M03ED
Copy link
Collaborator

M03ED commented Jul 2, 2024

لاگ مرزبان رو ارسال کنید

@hayousef68
Copy link
Author

لاگ مرزبان رو ارسال کنید

marzban-1 | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 210, in raise_
marzban-1 | raise exception
marzban-1 | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context
marzban-1 | self.dialect.do_execute(
marzban-1 | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
marzban-1 | cursor.execute(statement, parameters)
marzban-1 | sqlalchemy.exc.DatabaseError: (sqlite3.DatabaseError) database disk image is malformed
marzban-1 | [SQL: INSERT INTO node_usages (created_at, node_id, uplink, downlink) VALUES (?, ?, ?, ?)]
marzban-1 | [parameters: ('2024-07-02 11:00:00.000000', None, 0, 0)]
marzban-1 | (Background on this error at: https://sqlalche.me/e/14/4xp6)

@hayousef68
Copy link
Author

لاگ مرزبان رو ارسال کنید

marzban-1 | (Background on this error at: https://sqlalche.me/e/14/4xp6)
marzban-1 | Job "record_node_usages (trigger: interval[0:00:10], next run at: 2024-07-02 11:14:30 UTC)" raised an exception
marzban-1 | Traceback (most recent call last):
marzban-1 | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context
marzban-1 | self.dialect.do_execute(
marzban-1 | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
marzban-1 | cursor.execute(statement, parameters)
marzban-1 | sqlite3.DatabaseError: database disk image is malformed
marzban-1 |
marzban-1 | The above exception was the direct cause of the following exception:
marzban-1 |
marzban-1 | Traceback (most recent call last):
marzban-1 | File "/usr/local/lib/python3.10/site-packages/apscheduler/executors/base.py", line 125, in run_job
marzban-1 | retval = job.func(*job.args, **job.kwargs)
marzban-1 | File "/code/app/jobs/record_usages.py", line 195, in record_node_usages
marzban-1 | record_node_stats(params, node_id)
marzban-1 | File "/code/app/jobs/record_usages.py", line 94, in record_node_stats
marzban-1 | safe_execute(db, stmt)
marzban-1 | File "/code/app/jobs/record_usages.py", line 38, in safe_execute
marzban-1 | db.execute(stmt, params)
marzban-1 | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1714, in execute
marzban-1 | result = conn._execute_20(statement, params or {}, execution_options)
marzban-1 | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1705, in _execute_20
marzban-1 | return meth(self, args_10style, kwargs_10style, execution_options)
marzban-1 | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 334, in _execute_on_connection
marzban-1 | return connection._execute_clauseelement(
marzban-1 | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1572, in _execute_clauseelement
marzban-1 | ret = self._execute_context(
marzban-1 | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1943, in _execute_context
marzban-1 | self.handle_dbapi_exception(
marzban-1 | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2124, in handle_dbapi_exception
marzban-1 | util.raise
(
marzban-1 | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 210, in raise

marzban-1 | raise exception
marzban-1 | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context
marzban-1 | self.dialect.do_execute(
marzban-1 | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
marzban-1 | cursor.execute(statement, parameters)
marzban-1 | sqlalchemy.exc.DatabaseError: (sqlite3.DatabaseError) database disk image is malformed
marzban-1 | [SQL: INSERT INTO node_usages (created_at, node_id, uplink, downlink) VALUES (?, ?, ?, ?)]
marzban-1 | [parameters: ('2024-07-02 11:00:00.000000', None, 0, 0)]
marzban-1 | (Background on this error at: https://sqlalche.me/e/14/4xp6)

@M03ED
Copy link
Collaborator

M03ED commented Jul 2, 2024

دیتابیس تون به مشکل خورده

@hayousef68
Copy link
Author

دیتابیس تون به مشکل خورده

چطوری حلش کنم عزیز

@M03ED
Copy link
Collaborator

M03ED commented Jul 2, 2024

راهی برای حل این مشکل وجود نداره ، اگر میتونید یوزر ها تون رو ببینید اون ها رو به یک پنل دیگه منتقل کنید

@m0x61h0x64i
Copy link

منم این مشکل دارم
marzban-1 | Execution of job "record_node_usages (trigger: interval[0:00:10], next run at: 2024-07-05 20:57:52 UTC)" skipped: maximum number of running instances reached (1)

@m0x61h0x64i
Copy link

ولی من ریست میتونم بکنم. فقط توی لاگ ارور دارم
reeee's usage has reset successfully.

@m0x61h0x64i
Copy link

لاگ پر اروره

@m0x61h0x64i
Copy link

image
image
image
image
image
image

@LonUp
Copy link

LonUp commented Nov 9, 2024

لطفا ارور هارو به صورت فایل متنی بزارید تا قابل خوندن باشه

اروری که مشترکه بینتون عدم ارتباط با نود برای برسی حجم مصرفی کاربران هست . این مشکل هم میتونه از سمت نود و هم از سمت دیتابیس باشه . و یا میتونه بخاطر دیداس خوردن شما پیش بیاد
باید چیز های زیادی چک بشه

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug Something isn't working
Projects
None yet
Development

No branches or pull requests

4 participants