packets received in wrong sequence

bradzo commented 9 years ago

Hi Ben

I've successfully setup mySQL for binlog and all is working fine.

We use some PHP scripts at work to aggregate stuff and store it in mySQL. I've created a couple of meteor apps that are essentially "monitors" of the PHP scripts (they write their current operation to a table just with a text string ie: "Running agg script 1" etc)

The trouble is, even when I start the meteor apps on different ports: meteor --port 3010 meteor --port 3020

and both apps connect to different mySQL databases, I get the "packets received in wrong sequence" error in the terminal of both of them.

Sorry I can't paste the actual error - the code is at work and I'm at home at the moment. Will update this on Monday.

Thanks Cheers Brad

numtel commented 9 years ago

Hi Brad, Do you have any more information on this? Make sure you have different server-id settings for each application. I have had no problems running 2 applications simultaneously on different databases from the same locally hosted MySQL server.

Ben

bradzo commented 9 years ago

Hi Ben

Thank you - damn! Now I know what I did wrong - server-id!

I will fix tomorrow and let you know. Yes, I remember now - both apps had same server id.

Good on you! Thanks

And best wishes

Brad

On Sat, May 9, 2015 at 7:08 PM, Ben Green notifications@github.com wrote:

Hi Brad, Do you have any more information on this? Make sure you have different server-id settings for each application. I have had no problems running 2 applications simultaneously on different databases from the same locally hosted MySQL server.

Ben

— Reply to this email directly or view it on GitHub https://github.com/numtel/meteor-mysql/issues/16#issuecomment-100454279.

No trees were harmed in the creation of this message, but several thousand electrons were mildly inconvenienced.

umbezt commented 9 years ago

@numtel Is it possible to run two applications on the same database? Because I am getting this error and I am running one application in production and the other locally.

anshul-budhiraja commented 9 years ago

@numtel I am also getting the same issue "packets received in wrong sequence". I am using 3 databases placed on different machines in one application. As per suggestion, I used unique serverId for each connection. Can you please help me to resolve this issue asap. My production is stuck because of this issue. Thanks in Advance !! Anshul

anil-kumar-ma commented 9 years ago

@numtel :

Make sure you have different server-id settings for each application. I have had no problems running 2 applications simultaneously on different databases from the same locally hosted MySQL server.

I have query on server-id concept. Please let me know what's wrong in the following stack. It's giving us packet sequence error:

MySQL Instance1
- db1: server_id=1
MySQL Instance2
- db2: server_id=2
Settings.json { "db1_connection": { "host" : "abc", "port" : 3306, "user" : "root", "password" : "password", "database" : "db1", "serverId" : 1, "minInterval" : 200 }, "db2_connection" : { "host" : "xyz", "port" : 3306, "user" : "root", "password" : "password", "database" : "db2", "serverId" : 2, "minInterval" : 200 } }

Thanks! Anil P.S: Initially we were having only one mysql server which was working fine. Now our business needs to collect data from two different db servers and hence we are facing this issue. Our application is in production. Please help us as soon as possible.

numtel commented 9 years ago

Can you post a link to a repo with the least amount of code possible to recreate this issue?

numtel / meteor-mysql

packets received in wrong sequence #16