db:push doesn't actually push data

[jds13]

Taps 0.3.9 on Windows... The following logs show that the "funds" table is pushed in 2 to 12 seconds, but that's because no data gets pushed. It should be 7,176 records of around 12K bytes each. (Name have been changes to protect the guilty.)

Where can I find logs or other clues that might explain what's going on? Thank you.

14:32:25 C:\hf1> heroku db:push Loaded Taps v0.3.9 Auto-detected local database: mysql://user:pswd@localhost/mydb?encoding=utf8 Warning: Data in the app 'elaborate-hoax-1' will be overwritten and will not be recoverable. Are you sure you wish to continue? (y/n)? y Sending schema Schema: 100% |==========================================| Time: 00:00:17 Sending indexes sessions: 100% |==========================================| Time: 00:00:01 schema_migrat: 100% |==========================================| Time: 00:00:00 fundscreens: 100% |==========================================| Time: 00:00:01 funds: 100% |==========================================| Time: 00:00:12 flts: 100% |==========================================| Time: 00:00:00 hfrets: 100% |==========================================| Time: 00:00:01 managers: 100% |==========================================| Time: 00:00:01 strategies: 100% |==========================================| Time: 00:00:01 Sending data 12 tables, 668,862 records sessions: 100% |==========================================| Time: 00:00:00 benchdefaults: 100% |==========================================| Time: 00:00:00 schema_migrat: 100% |==========================================| Time: 00:00:00 feedbacks: 100% |==========================================| Time: 00:00:00 portfolios: 100% |==========================================| Time: 00:00:01 fundscreens: 100% |==========================================| Time: 00:03:13 funds: 100% |==========================================| Time: 00:00:02 users: 100% |==========================================| Time: 00:00:02 hfrets: 100% |==========================================| Time: 00:45:01 flts: 100% |==========================================| Time: 00:00:33 strategies: 100% |==========================================| Time: 00:00:00 managers: 100% |==========================================| Time: 00:00:00 Resetting sequences

15:31:12 C:\hf1> heroku db:push mysql://user:pswd@localhost/mydb?encoding=utf8 --force --tables funds Loaded Taps v0.3.9 Warning: Data in the app 'elaborate-hoax-1' will be overwritten and will not be recoverable. Sending schema Schema: 100% |==========================================| Time: 00:00:01 Sending indexes funds: 100% |==========================================| Time: 00:00:14 Sending data 1 tables, 7,176 records funds: 100% |==========================================| Time: 00:00:02 Resetting sequences

15:33:35 C:\hf1>

[jds13]

The id field for this table is a primary key, auto incremented. A batch job populates this table weekly with proprietary data using negative id values (e.g. -100000 to -50000). User-created data gets positive key values.

It looks like Taps does not push records with negative key values.

[ricardochimal]

ah yeah, the negative values would not get caught, a primary key auto-incremented field is assumed to have only positive values. I'll see if I can get some time to address that.