Timestamps are in GMT/BST.
| 00:00:29 | | raptor Quit () |
| 06:47:39 | | Darrel Quit (Read error: Connection reset by peer) |
| 06:48:14 | | Darrel has joined |
| 07:24:26 | | LordDVG has joined |
| 08:05:08 | | Canseco has joined |
| 08:26:04 | | Darrel Quit (Ping timeout: 255 seconds) |
| 08:26:41 | | Darrel has joined |
| 08:43:59 | | Canseco Quit (Remote host closed the connection) |
| 09:41:45 | | raptor has joined |
| 09:41:45 | | ChanServ sets mode +o |
| 09:46:46 | | raptor Quit () |
| 09:53:00 | | LordDVG Quit (Ping timeout: 255 seconds) |
| 10:35:17 | | fordcars has joined |
| 10:51:02 | | LordDVG has joined |
| 12:06:25 | | raptor has joined |
| 12:06:25 | | ChanServ sets mode +o |
| 12:12:12 | sam686 | http://sam6.25u.com/bitfighter/gamereports/gamereports.php?days=30 it looks like the replication have stopped working, did the main mysql's 'backup' password got changed or what? |
| 12:12:27 | raptor | oh... |
| 12:12:30 | raptor | maybe... |
| 12:12:53 | raptor | something else was broke and I had to fix it by changing the backup user permissions... |
| 12:13:51 | raptor | ah yes |
| 12:14:01 | raptor | pleiades export was broke. see /home/master/dedicated_servers/pleiades/pleiades_export.php |
| 12:14:06 | raptor | for the new password |
| 12:14:17 | raptor | i couldn't find the old backup password, so i did change it |
| 12:14:28 | sam686 | on the main bitfighter side, 'sudo ls -l /var/log/mysql' its getting kindof big in filesize |
| 12:14:44 | sam686 | anything before/less then 'mysql-bin.000132' is probably ok to delete |
| 12:14:55 | sam686 | since thats where my side of replication stopped at |
| 12:15:06 | raptor | hmmm... let me see about doing maintenance |
| 12:15:33 | sam686 | it should pick up where it left of, as long as its there on the master side |
| 12:17:09 | sam686 | found an old screenshot http://sam6.25u.com/upload/backup_priv.png |
| 12:17:34 | sam686 | pretty much just need a username and password |
| 12:18:32 | sam686 | it can be a new username if you wish |
| 12:20:15 | raptor | you can use the same user, that's what it's for |
| 12:20:21 | raptor | password is in the file: /home/master/dedicated_servers/pleiades/pleiades_export.php |
| 12:22:11 | sam686 | i see |
| 12:22:45 | raptor | i'm sory i broke replication |
| 12:24:29 | sam686 | Seconds_Behind_Master 12224495 |
| 12:24:34 | sam686 | seems to start working now |
| 12:27:30 | sam686 | Error 'Duplicate entry '59644' for key 'PRIMARY'' on query. Default database: 'bf_stats' |
| 12:27:46 | sam686 | i might need to do a full database copy |
| 12:37:29 | sam686 | mysqldump --skip-lock-tables --single-transaction --flush-logs --hex-blob --master-data=2 -A > ~/dump.sq |
| 12:37:40 | sam686 | could you turn on "reload' privilages? |
| 12:37:46 | sam686 | looking at http://plusbryan.com/mysql-replication-without-downtime |
| 12:38:48 | sam686 | raptor? turn on reload privilages on 'backup' user |
| 12:40:23 | raptor | hi |
| 12:40:24 | raptor | ok |
| 12:40:53 | raptor | sam686: done |
| 12:42:22 | sam686 | mysqldump: Couldn't execute 'show create table `v_authenticated_game`': SHOW VIEW command denied to user 'backup'@'localhost' for table 'v_authenticated_game' |
| 12:42:32 | raptor | argh |
| 12:42:36 | sam686 | raptor turn on 'SHOW VIEW' permission too? |
| 12:42:40 | raptor | ha, ok |
| 12:43:03 | raptor | sam686: done |
| 12:45:31 | sam686 | ok, got almost all thats needed from, but will need to gzip and transfer |
| 12:58:10 | raptor | did the replication pick up where it left off? |
| 13:06:55 | sam686 | I had to do another dump (this time all except mysql database) |
| 13:17:00 | sam686 | there we go, its replicating ok |
| 13:18:02 | sam686 | loading up http://sam6.25u.com/bitfighter/gamereports/gamereports.php?days=7 is an easy way to tell if it contines to replicate |
| 13:20:07 | sam686 | I should run something like PURGE BINARY LOGS TO 'mysql-bin.010'; |
| 13:20:16 | raptor | yes |
| 13:20:23 | raptor | i was looking for how to clean those up... |
| 13:20:36 | raptor | sometimes there's an easy way through the phpmyadmin interface |
| 13:21:58 | sam686 | mysql> PURGE BINARY LOGS TO 'mysql-bin.140'; |
| 13:21:59 | sam686 | ERROR 1227 (42000): Access denied; you need the SUPER privilege for this operation |
| 13:22:10 | sam686 | i guess its best to run as root |
| 13:23:30 | sam686 | I was looking at http://dev.mysql.com/doc/refman/5.0/en/purge-binary-logs.html that where i came up with that command |
| 13:24:08 | sam686 | its now at mysql-bin.000151 so its safe to purve mysql-bin.000150 and earliear |
| 13:24:12 | sam686 | purge |
| 13:26:48 | sam686 | although, its not always good idea to purge everything except the latest one till you know all the mysql slaves are done with those. |
| 13:38:37 | | Flynnn has joined |
| 14:08:24 | raptor | sam686: i'm attempting to purge logs now... |
| 14:08:57 | raptor | it worked! I ran: purge binary logs to ‘mysql-bin.000150' |
| 14:09:03 | raptor | in the phpmyadmin interface |
| 14:15:15 | sam686 | Before purge: Used:6557700 Available:9170940 42% |
| 14:15:15 | sam686 | After purge: Used:6241008 Available:9487632 40% |
| 14:15:46 | raptor | it was using 400MB? |
| 14:16:32 | sam686 | http://sam6.25u.com/upload/text1411/141122_13-16-19.txt that was before purge |
| 14:17:01 | | Flynnn Quit (Quit: This computer has gone to sleep) |
| 14:17:08 | sam686 | most of individual files was about 1-10 MB |
| 14:18:21 | raptor | ah ok |
| 14:27:51 | | Flynnn has joined |
| 15:09:18 | | Flynnn Quit (Quit: This computer has gone to sleep) |
| 15:15:27 | | Flynnn has joined |
| 15:23:15 | | LordDVG Quit (Read error: Connection reset by peer) |
| 15:27:53 | | Invisible has joined |
| 15:54:58 | | Flynnn Quit (Quit: This computer has gone to sleep) |
| 16:04:20 | | Flynnn has joined |
| 16:13:37 | | Invisible Quit (Ping timeout: 240 seconds) |
| 17:31:50 | | Flynnn Quit (Quit: This computer has gone to sleep) |
| 17:32:02 | | Flynnn has joined |
| 17:54:53 | | Flynnn Quit (Quit: This computer has gone to sleep) |
| 18:15:02 | | BFLogBot Commit: 056ceaf43c | Author: buckyballreaction | Message: Name DMG output according to architecture that was compiled |
| 18:15:03 | | BFLogBot Commit: 90e753130e | Author: buckyballreaction | Message: Tell Sparkle not to send system profile data on OSX |
| 18:15:22 | raptor | OK Sparkle still works.. |
| 18:26:35 | | Flynnn has joined |
| 18:44:26 | | raptor Quit () |
| 19:02:46 | | amgine123 has joined |
| 19:36:54 | | Flynnn Quit (Quit: This computer has gone to sleep) |
| 19:37:35 | | Flynnn has joined |
| 20:51:11 | | Flynnn Quit (Quit: This computer has gone to sleep) |
| 20:52:43 | | Flynnn has joined |
| 21:02:19 | | Invisible has joined |
| 21:51:33 | | Flynnn Quit (Quit: This computer has gone to sleep) |
| 21:56:14 | | Flynnn has joined |
| 22:00:27 | | Flynnn Quit (Client Quit) |
| 22:18:38 | | Platskies has joined |
| 22:28:17 | | Invisible Quit (Ping timeout: 240 seconds) |
| 23:22:33 | | Invisible has joined |
| 23:32:12 | | sky_lark has joined |
| 23:32:16 | sky_lark | anyone on? |
| 23:36:32 | sky_lark | nevermind |
| 23:41:52 | | raptor has joined |
| 23:41:52 | | ChanServ sets mode +o |
| 23:41:59 | raptor | hi sky_lark, question? |
| 23:43:48 | sky_lark | nope, I solved it myself gracias |
| 23:46:13 | | Flynnn has joined |
| 23:46:25 | | amgine123 Quit (Ping timeout: 246 seconds) |
| 23:47:16 | raptor | fordcars: i cannot duplicate your chat bug |
| 23:47:31 | raptor | oh wait, you said 019c |
| 23:48:01 | raptor | nope, stilll cannot duplicate |
| 23:48:21 | raptor | is that the global chat? |
| 23:48:27 | raptor | because if so, it is global |
| 23:48:39 | fordcars | Uh |
| 23:48:49 | raptor | this bug: https://code.google.com/p/bitfighter/issues/detail?id=479 |
| 23:48:50 | fordcars | The one when it doesn't get cleared? |
| 23:48:55 | raptor | do you mean the F5 chat? |
| 23:49:02 | fordcars | No sorry |
| 23:49:07 | fordcars | I mean the in-game global |
| 23:49:13 | raptor | so press 'g' |
| 23:49:30 | fordcars | Oh sorry yeah |
| 23:49:33 | fordcars | That wasn't clear |
| 23:49:41 | raptor | ok, waht do I do? type stuff and send it |
| 23:49:51 | raptor | i've been trying to duplicate... |
| 23:51:38 | fordcars | Sorry, I'll explain |
| 23:51:51 | fordcars | 1. go in a server |
| 23:51:54 | fordcars | 2. press g |
| 23:51:56 | raptor | ok |
| 23:52:14 | fordcars | 3. type a message (don't press enter!) |
| 23:52:20 | fordcars | 4. leave server |
| 23:52:26 | fordcars | 5. join another server |
| 23:52:29 | fordcars | 6. press g |
| 23:52:38 | fordcars | Your message will be there |
| 23:52:50 | raptor | how do you leave the server with 'g' still open? |
| 23:52:58 | fordcars | Oh |
| 23:53:03 | fordcars | Well close chat with esc |
| 23:53:21 | raptor | ok |
| 23:53:30 | fordcars | Wait! |
| 23:53:34 | raptor | i'll need to test on windows 8.1 - i cannot dupe in linux |
| 23:53:39 | fordcars | No wait |
| 23:53:44 | raptor | ok |
| 23:53:47 | fordcars | You can just forget if you want, it's really small |
| 23:54:03 | raptor | what am I waiting for? |
| 23:54:06 | fordcars | Oh no sorry |
| 23:54:10 | fordcars | Gawd |
| 23:54:19 | fordcars | You don't need to spend time on this |
| 23:54:23 | fordcars | It's really small |
| 23:54:29 | fordcars | I'll rewrite the steps again |
| 23:54:37 | fordcars | 1. Host a dedicated server |
| 23:54:41 | fordcars | 2. Connect to it |
| 23:54:55 | fordcars | 3. Open global chat (g) and type a message, do not send it |
| 23:55:13 | | Platskies Quit (Read error: Connection reset by peer) |
| 23:55:20 | fordcars | 4. Close the dedicated server (while the client is still connected and has the message in the chat) |
| 23:55:26 | raptor | ohhh |
| 23:55:29 | raptor | ok, that makes sense |
| 23:55:30 | fordcars | 5. Join another server with the client |
| 23:55:42 | fordcars | 6. Hit g, your message is still there |
| 23:56:44 | fordcars | Please don't spend time on this :) |
| 23:57:03 | raptor | ok, i can mark teh bug as WontFix |
| 23:57:09 | raptor | if it'll make you feel better :) |
| 23:57:22 | fordcars | Yes :D |
| 23:58:59 | raptor | done |
| 23:59:47 | sky_lark | I demand you spend time on this bug raptor |
