Opened 2 years ago
Closed 2 years ago
#1487694 closed Bugs (worksforme)
lots of MDB2 "Duplicate entry" errors
| Reported by: | recarep | Owned by: | |
|---|---|---|---|
| Priority: | 5 | Milestone: | 0.5.1 |
| Component: | Database | Version: | 0.5 |
| Severity: | normal | Keywords: | |
| Cc: |
Description
after upgarding from 0.4 to 0.5 a lot of errors like this appeard in the log file
[15-Jan-2011 16:21:00] MDB2 Error: constraint violation (-3): _doQuery: [Error message: Could not execute statement]
[Last executed query: EXECUTE mdb2_statement_mysql_7a87122a048af93519e18fa8c55876840b590737d USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10]
[Native code: 1062]
[Native message: Duplicate entry '26-spam.msg-50832' for key 2]
finally script crashed with:
[15-Jan-2011 16:21:17] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 20 bytes) in /var/www/poczta/program/lib/PEAR.php on line 884
all that (probably) happened during opened large folder spam that contains like 50 thousands emails.
Attachments (1)
Change History (7)
Changed 2 years ago by recarep
comment:1 Changed 2 years ago by recarep
- Component changed from Addressbook to Database
comment:2 Changed 2 years ago by alec
- Milestone changed from later to 0.5.1
comment:3 Changed 2 years ago by recarep
just now?
or should have done it during upgrade procedure?
will it fix the problem, or will help with debuging?
comment:4 Changed 2 years ago by alec
Yes, now. Do you have these errors all the time?
comment:5 Changed 2 years ago by recarep
No more errors since 15-Jan-2011 16:21:17
Didn't truncate so far.
comment:6 Changed 2 years ago by thomasb
- Resolution set to worksforme
- Status changed from new to closed
We should add TRUNCATE messages to the upgrading process anyway. Doesn't look like a real bug so closing this ticket.
Run SQL query: "TRUNCATE messages".