Comments (6)
found another one and realized thers an modoboa job next to him:
Id | User | Host | db | Command | Time | State | Info |
---|---|---|---|---|---|---|---|
138138 | modoboa | netzwerkplan01.mivitec.net:59655 | modoboa | Sleep | 9547 | NULL | |
138139 | amavis | netzwerkplan01.mivitec.net:59656 | amavis | Query | 9547 | Sending data | SELECT COUNT(*) AS __count FROM msgrcpt INNER JOIN maddr ON ( msgrcpt .rid = maddr .id ) INNER JOIN msgs ON ( msgrcpt .mail_id = msgs .mail_id ) WHERE (msgrcpt .rs IN (' ', 'V', 'R', 'p', 'S', 'H') AND maddr .email REGEXP BINARY '(sadoni.net)' AND (msgrcpt .mail_id ) IN (SELECT U0.mail_id FROM quarantine U0 WHERE U0.chunk_ind = 1)) |
from modoboa-amavis.
That's strange... Maybe too many modoboa cron jobs are running at the same time ?
from modoboa-amavis.
sry for late reply.
the amavis database is 1.3gb big and as u go to the modoboa amavis frontend it starts such a select.
The amavis db is that big cause the cleanup script is not working (cant give the error message today iam not at work ill post it monday evening)
from modoboa-amavis.
output from cleanup script:
# /var/www/mailadmin/manage.py qcleanup
Traceback (most recent call last):
File "/var/www/mailadmin/manage.py", line 10, in <module>
execute_from_command_line(sys.argv)
File "/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py", line 354, in execute_from_command_line
utility.execute()
File "/usr/local/lib/python2.7/dist-packages/django/core/management/__init__.py", line 346, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/usr/local/lib/python2.7/dist-packages/django/core/management/base.py", line 394, in run_from_argv
self.execute(*args, **cmd_options)
File "/usr/local/lib/python2.7/dist-packages/django/core/management/base.py", line 445, in execute
output = self.handle(*args, **options)
File "/usr/local/lib/python2.7/dist-packages/modoboa_amavis/management/commands/qcleanup.py", line 55, in handle
if not msg.msgrcpt_set.exclude(rs__in=flags).count():
AttributeError: 'Msgs' object has no attribute 'msgrcpt_set'
from modoboa-amavis.
Ok, this issue shoud be fixed with 1.0.7
from modoboa-amavis.
y, fixed i had some trouble upgrading from autoinstalled modoboa.
i followed the doc
pip install -U modoboa
rm -rf instance_dir
modoboa-admin.py deploy instance --collectstatic --dburl default:mysql://modoboa:SECRET@localhost:3306/modoboa amavis:mysql://amavis:SECRET@localhost:3306/amavis --domain SECRET.net --extensions all
/etc/init.d/nginx restart
/etc/init.d/uwsgi restart
# got error 500 internel server error
fixed it by commenting out in "/etc/uwsgi/apps-available/modoboa_instance.ini"
#home = /srv/modoboa/env
if i did it "wrong/to complicated" let me know pls.
thx
from modoboa-amavis.
Related Issues (20)
- AttributeError at /quarantine/process/ - quarantined mails not being released HOT 6
- CSRF error: Cannot release or delete quarantine HOT 5
- Deleting catch all alias deletes the domain from amavis.users table
- Cannot Release Emails HOT 21
- Manual learning is not working according to bayes db HOT 3
- Only Super Admin can mark quarantined mails as spam or ham HOT 5
- Unable to release objects from quarantine:TypeError at /quarantine/process/ can't pickle memoryview objects HOT 2
- openenig quarantine page results in internal error - KeyError '?' HOT 2
- Non-latin characters FUBAR HOT 2
- Can't unblock messages in Qurantine HOT 2
- Quarantine deletion not working with MariaDb 5.5/10.0 and modoboa 1.15.0 HOT 5
- qcleanup doesn't delete messages (PostgreSQL) HOT 1
- Quarantine List Empty
- Embed Webmailer into another website HOT 1
- Cannnot release mails form quarantine as super admin HOT 11
- Migration Fails HOT 1
- How to train Spamassassin HOT 1
- Outgoing mail marked as 'BANNED' HOT 1
- Perfomance issue with manual learning
- 1.5.1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from modoboa-amavis.