Updating to release

Pirate Praveen
Pirate Praveen Public Seen by 308

I have prepared diaspora-installer-mysql (https://people.debian.org/~praveen/diaspora/) and did some basic testing. I need some help in more through testing, especially for updates as I have done some re-factoring/cleanup of the code. We should test upgrading from 0.5 to 0.6 as well. If someone can review the diaspora-common.postinst, postinst scripts that would be great too.

Repo here https://anonscm.debian.org/cgit/pkg-ruby-extras/diaspora-installer.git

We need to verify backup is working properly (last time I checked, there was some error in slave status). I will check again and announce a downtime to reset replication (we'll have to stop diaspora, copy the database files and restart replication).

Once we verify backup is proper, we can install diaspora-installer

Aurabindo J

Aurabindo J August 29th, 2016 13:02

I tried installing the diaspora-installer package in debian 8, but failed with a dependency error: http://paste.debian.net/794799/

Pirate Praveen

Pirate Praveen August 29th, 2016 15:36

@jayaura thanks! You need to enable jessie-backports as well.

Add jessie-backports to your sources.list and run
# apt-get -t jessie-backports install diaspora-installer-mysql

Pirate Praveen

Pirate Praveen August 30th, 2016 08:57

Backup server had died a month back (Jul 25 was the modification date on /var/lib/diaspora/rsync-uploads.log). Waiting for it to catch up in the next cron run.

Master status:
File: mysql-bin.000171
        Position: 1281767

Slave status:
 Master_Log_File: mysql-bin.000135
          Read_Master_Log_Pos: 8763817

Last_Errno: 1452
                   Last_Error: Error 'Cannot add or update a child row: a foreign key constraint fails (`pprod`.`notification_actors`, CONSTRAINT `notification_actors_notification_id_fk` FOREIGN KEY (`notification_id`) REFERENCES `notifications` (`id`) ON DELETE CASCADE)' on query. Default database: 'pprod'. Query: 'INSERT INTO `notification_actors` (`notification_id`, `person_id`, `created_at`, `updated_at`) VALUES (127061, 77410, '2016-03-28 01:31:40', '2016-03-28 01:31:40')'

So I'll announce a down time once rsync catches up and we'll reset replication. If anyone wants to learn replication, I'm happy to guide, we can schedule a time and hangout at our xmpp room.

Pirate Praveen

Pirate Praveen August 30th, 2016 09:50

rsync completed and I'll schedule backup for tomorrow 11 am IST.

Pirate Praveen

Pirate Praveen August 30th, 2016 10:50

Posted down time notice https://diasp.in/posts/368361

Pirate Praveen

Pirate Praveen September 2nd, 2016 10:59

poddery.com is now running on

I have restarted replication and this is the current status,

Slave is at,
Master_Log_File: mysql-bin.000174
Read_Master_Log_Pos: 1639568

and master is at,
File: mysql-bin.000174
Position: 1643876

It will take a while to catch up.