Bug 11101 - SqueezeNetwork data center sync / acquisition issues
: SqueezeNetwork data center sync / acquisition issues
Status: RESOLVED FIXED
Product: MySqueezebox.com
Classification: Unclassified
Component: Misc
: Prod
: PC Windows XP
: P1 major (vote)
: ---
Assigned To: Andy Grundman
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2009-02-16 09:03 UTC by tdnuerf@gmail.com
Modified: 2009-09-08 09:16 UTC (History)
1 user (show)

See Also:
Category: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description tdnuerf@gmail.com 2009-02-16 09:03:53 UTC
See my posts at http://forums.slimdevices.com/showthread.php?t=58263.  

(Significant note:  I do not use SC except for debugging purposes -- I'm 100% SN.)

This morning my SBR was playing internet radio, my Boom was playing Slacker, and I turned on my SBC.  It couldn't see any players.  After 'factory resetting' it and hard-rebooting the SBR, the controller was able to see it and normal behavior resumed.  Except that the SBC still can't see the Boom, which is happily playing Slacker stuff.  SBR and Boom are on SN, playing music, but only one is seen by the SBC.  What's up?

The Boom's connected to Sunnyvale and the SBR is connected to Ashburn, that's what.  nat.dc.squeezenetwork.com shows the SBC and SBR as being connected and Boom as unconnected.  nat.sv.squeezenetwork.com shows all three devices as being connected.  Currently, www.squeezenetwork.com resolves to nat.dc.squeezenetwork.com's IP in DNS.  I'm in Petaluma, CA.

Whether SN's servers are three load balancers to centralized/replicated databases or "local" servers in the sense that geographic location X always connects to the server closest to X, something's not working right.  Either mirrored data isn't being mirrored, or location X is connecting to server Y when it's not supposed to.  

Or am I missing something?  How do I get the SBC to see both players, and how do I get www.squeezenetwork.com to see both players?
Comment 1 Andy Grundman 2009-02-16 10:21:28 UTC
Not really a bug, just a side effect of getting on multiple datacenters.
Comment 2 James Richardson 2009-02-16 10:23:56 UTC
This is a bad user experience, shouldn't all players be seen on all data centers?
Comment 3 tdnuerf@gmail.com 2009-02-16 13:54:13 UTC
If player functionality is unavailable to either SN's web UI or the SBC (or both), is this not a bug?

Please advise.
Comment 4 Andy Grundman 2009-02-16 13:56:22 UTC
You ran into an unfortunate situation where you were using multiple datacenters and there was replication lag for the database.  This is an operational issue, not a bug.  We're doing a big release tonight that includes a lot of database fixes, and may help with this.
Comment 5 tdnuerf@gmail.com 2009-02-17 08:22:27 UTC
..."unfortunate situation where you were using multiple datacenters
and there was replication lag for the database"

Is it possible that this is the cause of my alarm failure this morning?  

Last night I checked my alarms -- my 6:01 alarm was off, so I turned it on.  I then checked SN settings (connected to Sunnyvale), set the Boom for an hour of sleep, and double-checked that the next alarm was set for 0601.  So far so good.  This morning I was awake and watching the Boom as it changed to 0601 and nothing happened.  I waited until 0602 and then checked alarm status -- my 0601 alarm was off!  And I was connected to Ashburn.  

In every instance where I have noticed SN discrepancy issues, Sunnyvale knows everything that's going on, but Ashburn doesn't.  e.g., nat.sv.squeezenetwork.com knows that my devices are connected even if one or both of them are connected to Ashburn, but nat.dc.squeezenetwork.com doesn't see anything connected to Sunnyvale.  

As I was connected to Sunnyvale last night when I made an alarm change, and connected to Ashburn this morning after the alarm failure, it seems to me that a data replication bug definitely exists.  If this is truly an operational issue, please tell me how to operate my Squeezebox devices in order to avoid the problems.

Thank you.
Comment 6 Andy Grundman 2009-02-17 08:29:46 UTC
Yes, but the lag issue is resolved as of this morning.