Mismatched counts after backup to a staging server.

Ask community to help.

Moderators: Amaradana, TurboPT, TL Developers

Mismatched counts after backup to a staging server.

Postby istream » Wed Aug 15, 2012 4:32 pm

Hi,
Most recently, I backed up my production database (MySQL) and restored to my staging server. Restore was on a clean empty testlink (MySQL) database.
I was hoping to see everything exactly the same as production (up to the time when I backed up the dB). However in my project-->Metric Dashboard,
the numbers (active test cases etc.) reported are different than one on the production. The test cases (total, pass, fail..) in Execution, test cases associated with platforms etc. are same as production.

Any hints as to where should i be looking. I double check the testlink configuration files etc. looked ok.
Thanks
istream
Advanced user
 
Posts: 59
Joined: Wed Mar 31, 2010 10:28 pm

Re: Mismatched counts after backup to a staging server.

Postby GunnarD » Wed Aug 15, 2012 6:09 pm

How did you do backup?

Did you use mysqldump?
GunnarD
 

Re: Mismatched counts after backup to a staging server.

Postby TurboPT » Thu Aug 16, 2012 1:35 am

Was the production server still in use during the backup?
TurboPT
Member of TestLink Community
 
Posts: 339
Joined: Sun Dec 10, 2006 4:51 am

Re: Mismatched counts after backup to a staging server.

Postby istream » Thu Aug 16, 2012 4:23 pm

The server was pretty much idle. The production is running RH Enterprise 5.5 and Staging server is running Ubuntu 10.04 LTS. Both platforms running mysql 5.1.50.
Thx
istream
Advanced user
 
Posts: 59
Joined: Wed Mar 31, 2010 10:28 pm

Re: Mismatched counts after backup to a staging server.

Postby fman » Thu Aug 16, 2012 5:45 pm

1. you have not provided figures i.e. amount of differences: 10 items, 100 items ?
2. Server pretty idle is not enough, you have to be certain 100% than NOBODY is working on TL
fman
Member of TestLink Community
 
Posts: 3063
Joined: Tue Nov 15, 2005 7:19 am

Re: Mismatched counts after backup to a staging server.

Postby istream » Thu Aug 16, 2012 6:40 pm

Hi
Where can i paste the screenshots (production versus staging), if i have to?
IDLE=NO TL USERS at the time.
thx
istream
Advanced user
 
Posts: 59
Joined: Wed Mar 31, 2010 10:28 pm

Re: Mismatched counts after backup to a staging server.

Postby GunnarD » Fri Aug 17, 2012 7:00 am

Mysqldump should get everything from your database.

You are sure that nobody has used/updated your productions server after you used mysqldump?

A simple test should be to do a new mysqldump and compare the two using diff.
GunnarD
 

Re: Mismatched counts after backup to a staging server.

Postby istream » Tue Aug 21, 2012 4:30 pm

Where can i upload the screenshots, showing numbers from the databases.
istream
Advanced user
 
Posts: 59
Joined: Wed Mar 31, 2010 10:28 pm

Re: Mismatched counts after backup to a staging server.

Postby fman » Tue Aug 21, 2012 5:25 pm

Upload it on google drive or something like that and provide links.
Anyway this is not going to solve nothing. Best thing you can do is start from scratch
1. prevent ay access to TL (may be stopping web server)
2. be sure no custom procedure (i.e. developed on you company) change the DB
3. backup db
4. import on new fresh empty db
now you can compare
fman
Member of TestLink Community
 
Posts: 3063
Joined: Tue Nov 15, 2005 7:19 am


Return to Installation and configuration



Who is online

Users browsing this forum: No registered users and 2 guests

cron