Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Missing records after import #31

Open
wsinned opened this issue Jul 19, 2011 · 1 comment
Open

Missing records after import #31

wsinned opened this issue Jul 19, 2011 · 1 comment

Comments

@wsinned
Copy link

wsinned commented Jul 19, 2011

I ran the conversion against an existing database to see how it performs.

Everything reported OK, but the first table reported exactly 200000 rows in phppgadmin

Counting rows of addresses...
Rows counted
Loading addresses...
220000 of 223453 rows loaded. [ETA: 2011/07/19 19:31 (00h:00m:01s)]
223453 rows loaded in 1min 17s

The max(id) in the original mysql table is 236853, in the pgsql table it is 213041

At a glance this has happened to 2 other tables truncating at 10000 and 20000 rows respectively.

I am going to compare the row counts of every table now to see if this is happening elsewhere. Has anyone else encountered this?

MySQL 5.0.51a in an Ubuntu 9.04 VM
PostgreSQL 8.3.9 in an Ubuntu 9.04 VM

mysql2postgres running on OSX 10.6.8, ruby 1.8.7, pg gem 0.9.0, mysql gem 2.8.1

@Brade
Copy link

Brade commented Aug 12, 2014

DAMMIT I deleted my prior comment b/c this project has a different name than the Ruby gem so I thought I posted in the wrong place. ANYHOO, I also had rows randomly missing once I did the transfer, but with no error messages indicating anything was wrong. One table went from 4 rows to 3, another went from 4742 to 3044. I am sad about this.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants