My mail server rebooted itself and when it came up, MySQL gave this error:
2020-09-20T08:41:44.966301Z 0 [ERROR] InnoDB: Your database may be corrupt or
you may have copied the InnoDB tablespace but not the InnoDB log files. Please
refer to http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html
<http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html> for
information about forcing recovery.
2020-09-20T08:41:44.966320Z 0 [ERROR] InnoDB: Page [page id: space=54, page
number=39362] log sequence number 1092955697132 is in the future! Current
system log sequence number 939392966672.
I ran:
sudo rm /usr/local/var/mysql/ib_logfile0
And
sudo rm /usr/local/var/mysql/ib_logfile1
And it started up OK and other programs (eg Dovecot) could connect to it Ok.
But ASSP is having problems connecting to it:
Sep-20-20 18:24:51 [init] Try using mysql database <ASSP> for selected tables
Sep-20-20 18:24:52 [init] Using table <whitelist> in mysql Database
<ASSP> instead of file /Applications/assp/whitelist
Sep-20-20 18:24:52 [init] Using table <persblack> in mysql Database
<ASSP> instead of file /Applications/assp/persblack
Sep-20-20 18:24:52 [init] Using table <redlist> in mysql Database
<ASSP> instead of file /Applications/assp/redlist
Sep-20-20 18:24:52 [init] Using table <delaydb> in mysql Database
<ASSP> instead of file /Applications/assp/delaydb
Sep-20-20 18:24:52 [init] Using table <delaywhitedb> in mysql Database
<ASSP> instead of file /Applications/assp/delaydb.white
Sep-20-20 18:24:52 [init] Using table <pbwhite> in mysql Database
<ASSP> instead of file /Applications/assp/pb/pbdb.white.db
Sep-20-20 18:24:52 [init] Using table <pbblack> in mysql Database
<ASSP> instead of file /Applications/assp/pb/pbdb.black.db
Sep-20-20 18:24:52 [init] Using table <rblcache> in mysql Database
<ASSP> instead of file /Applications/assp/pb/pbdb.rbl.db
Sep-20-20 18:24:52 [init] Using table <uriblcache> in mysql Database
<ASSP> instead of file /Applications/assp/pb/pbdb.uribl.db
Sep-20-20 18:24:52 [init] Using table <ptrcache> in mysql Database
<ASSP> instead of file /Applications/assp/pb/pbdb.ptr.db
Sep-20-20 18:24:52 [init] Using table <mxacache> in mysql Database
<ASSP> instead of file /Applications/assp/pb/pbdb.mxa.db
Sep-20-20 18:24:52 [init] Using table <rwlcache> in mysql Database
<ASSP> instead of file /Applications/assp/pb/pbdb.rwl.db
Sep-20-20 18:24:52 [init] Using table <spfcache> in mysql Database
<ASSP> instead of file /Applications/assp/pb/pbdb.spf.db
Sep-20-20 18:24:52 [init] Using table <sbcache> in mysql Database
<ASSP> instead of file /Applications/assp/pb/pbdb.sb.db
Sep-20-20 18:24:52 [init] Using table <pbtrap> in mysql Database
<ASSP> instead of file /Applications/assp/pb/pbdb.trap.db
Sep-20-20 18:24:52 [init] Using table <dkimcache> in mysql Database
<ASSP> instead of file /Applications/assp/pb/pbdb.dkim.db
Sep-20-20 18:24:52 [init] Using table <batvtag> in mysql Database
<ASSP> instead of file /Applications/assp/pb/pbdb.batv.db
Sep-20-20 18:24:52 [init] Using table <backdns> in mysql Database
<ASSP> instead of file /Applications/assp/pb/pbdb.back.db
Sep-20-20 18:24:52 [init] Using table <spamdb> in mysql Database
<ASSP> instead of file /Applications/assp/spamdb
Sep-20-20 18:24:52 [init] Using table <spamdbhelo> in mysql Database
<ASSP> instead of file /Applications/assp/spamdb.helo
Sep-20-20 18:24:52 [init] Using table <hmmdb> in mysql Database
<ASSP> instead of file /Applications/assp/HMMdb
Sep-20-20 18:24:52 [init] Using table <ldaplist> in mysql Database
<ASSP> instead of file /Applications/assp/ldaplist
Sep-20-20 18:24:52 [init] Info: adminusersdb
(/Applications/assp/095bf7ffa01dc5080508ff2f6c1baf3094edef43bb1819b882da2131d50868fd317544b1c4163223504f07d92f73490574184c46b340f32746c9ca702ab2ce6753a363a0641b5240c3172440e5750ba995705e4ccef8ee722059737b61b050935e2e14e8163a8e058a4a639e6dcea52e006a511da1)
- loaded
Sep-20-20 18:24:52 [init] Info: adminusersdb
(/Applications/assp/095bf7ffa01dc5080508ff2f6c1baf3094edef43bb1819b882da2131d50868fd317544b1c4163223504f07d92f73490574184c46b340f32746c9ca702ab2ce6753a363a0641b5240c3172440e5750ba995705e4ccef8ee722059737b61b050935e2e14e8163a8e058a4a639e6dcea52e006a511da1.right)
- loaded
Sep-20-20 18:24:54 [init] Database count statement failed (hmmdb): Lost
connection to MySQL server during query
Sep-20-20 18:24:54 [init] Error: FIRSTKEY (hmmdb): Can't execute select
statement: MySQL server has gone away
Running: ASSP version 2.6.4 *SPAM-Evaporator* build 20224
mySQL version 5.7
What’s the best way to restore the database tables? If I delete the table will
ASSP recreate it from file?
Thanks,
James.
_______________________________________________
Assp-test mailing list
Assp-test@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/assp-test
