Updating to release

PP Pirate Praveen Public Seen by 308

I have prepared diaspora-installer-mysql ( 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

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


Mon 29 Aug 2016 1:02PM

I tried installing the diaspora-installer package in debian 8, but failed with a dependency error:


Pirate Praveen Mon 29 Aug 2016 3:36PM

@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 Tue 30 Aug 2016 8:57AM

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 Tue 30 Aug 2016 9:50AM

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


Pirate Praveen Tue 30 Aug 2016 10:50AM

Posted down time notice


Pirate Praveen Fri 2 Sep 2016 10:59AM 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.