[21:27:05] -!- titus_livius has joined #archlinux32
[21:27:45] <abaumann> start slave fails..
[21:28:28] <abaumann> no message no error nothign
[21:28:32] <abaumann> I hate mysql..
[21:29:28] -!- titus_livius has joined #archlinux32
[21:32:06] <abaumann> error in the database. SHOW SLAVE STATUS
[21:32:32] <abaumann> Relay log read failure: Could not parse relay log event entry. The possible reasons are: the master's binary log is corrupted (you can check this by running 'mysqlbinlog' on the binary log), the slave's relay log is corrupted (you can check this by running 'mysqlbinlog' on the relay log), a network problem, or a bug in the master's or slave's MariaDB code. If you want to check the master's binary
[21:32:38] <abaumann> log or slave's relay log, you will be able to know their names by issuing 'SHOW SLAVE STATUS' on this slave.
[21:32:41] <abaumann> yeah, this means basically it can be anything..
[21:47:14] -!- drathir_tor has joined #archlinux32
[21:52:39] -!- eschwartz has quit [Ping timeout: 244 seconds]
[21:56:37] -!- eschwartz has joined #archlinux32
[21:58:07] <abaumann> 366 mysql 20 0 5008908 3.6g 0 S 30.5 94.8 5:44.82 mariadbd
[21:58:16] <abaumann> on 3926.2 total memory
[21:58:21] <abaumann> yeah, this sounds sane.
[21:58:30] <abaumann> the machine is swapping now during import of the database..
[21:58:38] <abaumann> ERROR 2013 (HY000) at line 2330: Lost connection to server during query
[21:58:42] <abaumann> thanks mysql
[21:58:57] <abaumann> this is a joke, really
[22:00:50] <abaumann> maybe we can import it with a 4GB swap during import..
[22:04:37] <sunshavi> 4 GB swap is a lot
[22:33:09] <abaumann> Nov 08 22:32:40 archlinux32 mariadbd[1337]: 2021-11-08 22:32:40 9 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000403' at position 17069989, relay log './archlinux32-relay-bin.000872' position: 16465134
[22:33:21] <abaumann> yeah, this looks like dropping or fiddling some binlogs is now needed.
[22:42:12] <abaumann> archlinux32-relay-bin.000872m ERROR: Error in Log_event::read_log_event(): 'Event truncated', data_len: 1143, event_type: 2
[22:42:27] <abaumann> this means that this binlog has been truncated due to out of disk space (most likely)
[22:42:45] <abaumann> now, if I check the binlogs on the master, I see much higher numbers (e.g. buildmaster-relay-bin.009403)
[22:42:56] <abaumann> so archlinux32-relay-bin.000872 sounds like an old log
[22:43:25] <abaumann> also the /var/lib/mysql fill up with tons of buildmaster-relay-bin* files (which don't get wiped?)
[22:48:15] <abaumann> ok, we'll have stop the buildmaster db, kill the archlinux32.org replica, make a manual dump, remove all build logs, set up the replica again.
[22:48:37] <abaumann> but first it would make sense we don't run out of disk space again on the replica
[22:48:55] <abaumann> and it's late (here).. for now www.archlinux32.org runs with a stale database..
[22:48:56] -!- abaumann has quit [Quit: leaving]
[23:32:16] <T`aZ> just my 2 cents, last time i tried to have a working slave mysql host (that was 10 years ago), i failed. Was plagued by inconsistencies when replaying the log. It seems it has not improved. Mysql is a joke, would not recommend.
[23:59:12] -!- Hackerpcs has quit [Quit: Hackerpcs]