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.

Sign up for GitHub

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

Jump to bottom

DEPRECATION WARNING/Database command 'update' failed: #130

Closed
optimus93 opened this issue Feb 9, 2017 · 12 comments
Closed

DEPRECATION WARNING/Database command 'update' failed: #130

optimus93 opened this issue Feb 9, 2017 · 12 comments
Labels
duplicated

Comments

@optimus93
Copy link

optimus93 commented Feb 9, 2017 •
edited
Loading

Iam geting some kind of deprication error notification as well as some kind of error at the end of a translation process even though the translation is successful. Could someone tell me how can i clear that error.
I have pasted the below details of the gems i have installed, and the errors along with the successful translation etc.

**C:\RubyDevKit\bin>gem list

*** LOCAL GEMS ***
activemodel (5.0.1, 4.2.7.1, 4.2.6)
activerecord (5.0.1, 4.2.7.1, 4.2.6)
activesupport (5.0.1, 4.2.7.1, 4.2.6)
arel (7.1.4, 6.0.4)
bigdecimal (1.2.8)
binding_of_caller (0.7.2)
bond (0.5.1)
bson (4.2.1, 1.12.5)
bson_ext (1.12.5)
builder (3.2.3)
bundler (1.14.3)
coderay (1.1.1)
columnize (0.9.0)
concurrent-ruby (1.0.4)
cucumber (2.4.0)
cucumber-core (1.5.0)
cucumber-wire (0.0.1)
debug_inspector (0.0.2)
debugger-linecache (1.2.0)
debugger-ruby_core_source (1.3.8)
did_you_mean (1.0.0)
diff-lcs (1.3)
gherkin (4.0.0)
highline (1.7.8)
i18n (0.8.0)
interception (0.5)
io-console (0.4.5)
jist (1.5.1)
json (2.0.3, 1.8.3)
metaclass (0.0.4)
method_source (0.8.2)
minitest (5.8.5)
mocha (1.2.1)
mongify (1.3.1)
mongo (1.12.5)
multi_json (1.12.1)
multi_test (0.1.2)
mysql2 (0.4.5 x64-mingw32)
net-telnet (0.1.1)
pg (0.19.0 x64-mingw32)
power_assert (0.2.6)
pry (0.10.4)
pry-rescue (1.4.4)
pry-stack_explorer (0.4.9.2)
psych (2.1.0)
rake (12.0.0, 10.4.2)
rdoc (4.2.1)
rspec (3.5.0)
rspec-core (3.5.4)
rspec-expectations (3.5.0)
rspec-mocks (3.5.0)
rspec-support (3.5.0)
slop (3.6.0)
sqlite3 (1.3.13 x64-mingw32)
test-unit (3.1.5)
thread_safe (0.3.5)
tzinfo (1.2.2)
watchr (0.7)
yard (0.9.8)

**C:/Ruby23-x64/lib/ruby/gems/2.3.0/gems/mongo-1.12.5/lib/mongo/db.rb:610:in rescue in command': Database command 'update' failed: Unknown option to update command: multi (Mongo::OperationFailure)** from C:/Ruby23-x64/lib/ruby/gems/2.3.0/gems/mongo-1.12.5/lib/mongo/db.rb:606:in command'
from C:/Ruby23-x64/lib/ruby/gems/2.3.0/gems/mongo-1.12.5/lib/mongo/collection_writer.rb:314:in block in send_write_command' from C:/Ruby23-x64/lib/ruby/gems/2.3.0/gems/mongo-1.12.5/lib/mongo/functional/logging.rb:55:in block in instrument'
from C:/Ruby23-x64/lib/ruby/gems/2.3.0/gems/mongo-1.12.5/lib/mongo/functional/logging.rb:20:in instrument' from C:/Ruby23-x64/lib/ruby/gems/2.3.0/gems/mongo-1.12.5/lib/mongo/functional/logging.rb:54:in instrument'
from C:/Ruby23-x64/lib/ruby/gems/2.3.0/gems/mongo-1.12.5/lib/mongo/collection_writer.rb:313:in send_write_command' from C:/Ruby23-x64/lib/ruby/gems/2.3.0/gems/mongo-1.12.5/lib/mongo/collection.rb:1104:in send_write'
from C:/Ruby23-x64/lib/ruby/gems/2.3.0/gems/mongo-1.12.5/lib/mongo/collection.rb:497:in update' from C:/Ruby23-x64/lib/ruby/gems/2.3.0/gems/mongify-1.3.1/lib/mongify/database/no_sql_connection.rb:145:in remove_pre_mongified_ids'
from C:/Ruby23-x64/lib/ruby/gems/2.3.0/gems/mongify-1.3.1/lib/mongify/translation/processor_common.rb:116:in block in remove_pre_mongified_ids' from C:/Ruby23-x64/lib/ruby/gems/2.3.0/gems/mongify-1.3.1/lib/mongify/translation/processor_common.rb:114:in each'
from C:/Ruby23-x64/lib/ruby/gems/2.3.0/gems/mongify-1.3.1/lib/mongify/translation/processor_common.rb:114:in remove_pre_mongified_ids' from C:/Ruby23-x64/lib/ruby/gems/2.3.0/gems/mongify-1.3.1/lib/mongify/translation/process.rb:18:in process'
from C:/Ruby23-x64/lib/ruby/gems/2.3.0/gems/mongify-1.3.1/lib/mongify/cli/command/worker.rb:72:in execute' from C:/Ruby23-x64/lib/ruby/gems/2.3.0/gems/mongify-1.3.1/lib/mongify/cli/application.rb:28:in execute!'
from C:/Ruby23-x64/lib/ruby/gems/2.3.0/gems/mongify-1.3.1/bin/mongify:15:in <top (required)>' from C:/Ruby23-x64/bin/mongify:22:in load'
from C:/Ruby23-x64/bin/mongify:22:in `

'
@anlek
Copy link
Owner

anlek commented Feb 10, 2017

Thanks for sharing. Can I ask you to uninstall bson version 4.2.1. and rerun the command.

@optimus93
Copy link
Author

Does it solve the deprication error or the error that occurs at the completion of translation process...i removed the bson 4.2.1 and the deprecation warning persists .

@anlek
Copy link
Owner

anlek commented Feb 10, 2017

I was hoping it would fix the Database command 'update' failed: Unknown option to update command.

@optimus93
Copy link
Author

Oki cool.. let me check brother... iv put it on process translation... could u tell me wats the deprication error too.. hw do i deal witth that..

@optimus93
Copy link
Author

Oki iv tried it , but the update error still persists :/ .

@anlek
Copy link
Owner

anlek commented Feb 10, 2017

Hey @optimus93, seems like same error reported in issue #124, looks like the drivers mongify is using are not compatible with version 3.4 of MongoDB.
I'm currently unable to put effort into fixing it, but will gladly review pull requests.

@anlek anlek closed this as completed Feb 10, 2017
@optimus93
Copy link
Author

optimus93 commented Feb 11, 2017 •
edited
Loading

This worked:

  1. Removing the rails (activesupport/ activemodel/ activereport) - 5.0.1 versions solved the deprication error.
  2. Downgraded to MongoDB 3.2 from 3.4 and " failed to update command " is no more there.
    Now mongify runs smooth .

@anlek It wud be nyc if you could fix the issue in 3.4 brother. Peace !!!

@anlek
Copy link
Owner

anlek commented Feb 15, 2017

Hey @optimus93, I'd love to, but currently I have a lot of contract work to do. However, I'm open to review PR that would fix the issue.

@cyrishikesh
Copy link

@anlek
error
![error](https://user-images.githubusercontent.com/28404660/59676329-f32e9c80-91e4-11e9-9f4d-4b2d726f7df1.png)

I am trying to migrate data from mysql to mongodb but I am getting below error on "process" command. Similar type of error is discussed above but solutions to downgrade version of mongodb no longer available option in ubuntu 18.04. What can be done to solve this error. My gems file is mentioned below.

*** LOCAL GEMS ***

activemodel (4.2.11.1)
activerecord (4.2.11.1)
activesupport (4.2.11.1)
arel (6.0.4)
bigdecimal (default: 1.3.4)
bson (4.2.1, 1.12.5)
bson_ext (1.12.5)
builder (3.2.3)
bundler (2.0.2)
cmath (default: 1.0.0)
concurrent-ruby (1.1.5)
csv (default: 1.0.0)
date (default: 1.0.0)
dbm (default: 1.0.0)
did_you_mean (1.2.0)
etc (default: 1.0.0)
fcntl (default: 1.0.0)
fiddle (default: 1.0.0)
fileutils (default: 1.0.2)
gdbm (default: 2.0.0)
highline (1.7.8)
i18n (0.9.5)
io-console (default: 0.4.6)
ipaddr (default: 1.2.0)
json (2.2.0, default: 2.1.0)
minitest (5.10.3)
mongify (1.3.2)
mongo (1.12.5)
mysql2 (0.4.2)
net-telnet (0.1.1)
openssl (default: 2.1.1)
power_assert (0.2.7)
psych (default: 3.0.2)
rake (12.3.1)
rdoc (default: 6.0.1)
scanf (default: 1.0.0)
sdbm (default: 1.0.0)
stringio (default: 0.0.1)
strscan (default: 1.0.0)
test-unit (3.2.5)
thread_safe (0.3.6)
tzinfo (1.2.5)
webrick (default: 1.4.2)
zlib (default: 1.0.0)

Error:

Copying patient_request_master (1/1): (5271/5271) 100% |ooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo| Time: 00:00:00
Copying patient_diagnosis_detail (1/: (10000/10000) 100% |ooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo| Time: 00:00:00
Copying patient_diagnosis_detail (2/: (2616/2616) 100% |ooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo| Time: 00:00:00
Copying patient_grouping_detail (1/1: (5269/5269) 100% |ooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo| Time: 00:00:00
Copying patient_procedure_detail (1/: (6733/6733) 100% |ooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo| Time: 00:00:00
Updating References patient_request_: (5271/5271) 100% |ooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo| Time: 00:00:01
Updating References patient_diagnosi: (12616/12616) 100% |ooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo| Time: 00:00:03
Updating References patient_grouping: (5269/5269) 100% |ooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo| Time: 00:00:01
Updating References patient_procedur: (6733/6733) 100% |ooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo| Time: 00:00:01
Traceback (most recent call last):re: (0/1) 0% | | ETA: --:--:--
18: from /usr/local/bin/mongify:23:in <main>' 17: from /usr/local/bin/mongify:23:in load'
16: from /var/lib/gems/2.5.0/gems/mongify-1.3.2/bin/mongify:17:in <top (required)>' 15: from /var/lib/gems/2.5.0/gems/mongify-1.3.2/lib/mongify/cli/application.rb:28:in execute!'
14: from /var/lib/gems/2.5.0/gems/mongify-1.3.2/lib/mongify/cli/command/worker.rb:72:in execute' 13: from /var/lib/gems/2.5.0/gems/mongify-1.3.2/lib/mongify/translation/process.rb:18:in process'
12: from /var/lib/gems/2.5.0/gems/mongify-1.3.2/lib/mongify/translation/processor_common.rb:114:in remove_pre_mongified_ids' 11: from /var/lib/gems/2.5.0/gems/mongify-1.3.2/lib/mongify/translation/processor_common.rb:114:in each'
10: from /var/lib/gems/2.5.0/gems/mongify-1.3.2/lib/mongify/translation/processor_common.rb:116:in block in remove_pre_mongified_ids' 9: from /var/lib/gems/2.5.0/gems/mongify-1.3.2/lib/mongify/database/no_sql_connection.rb:145:in remove_pre_mongified_ids'
8: from /var/lib/gems/2.5.0/gems/mongo-1.12.5/lib/mongo/collection.rb:497:in update' 7: from /var/lib/gems/2.5.0/gems/mongo-1.12.5/lib/mongo/collection.rb:1104:in send_write'
6: from /var/lib/gems/2.5.0/gems/mongo-1.12.5/lib/mongo/collection_writer.rb:313:in send_write_command' 5: from /var/lib/gems/2.5.0/gems/mongo-1.12.5/lib/mongo/functional/logging.rb:54:in instrument'
4: from /var/lib/gems/2.5.0/gems/mongo-1.12.5/lib/mongo/functional/logging.rb:20:in instrument' 3: from /var/lib/gems/2.5.0/gems/mongo-1.12.5/lib/mongo/functional/logging.rb:55:in block in instrument'
2: from /var/lib/gems/2.5.0/gems/mongo-1.12.5/lib/mongo/collection_writer.rb:314:in block in send_write_command' 1: from /var/lib/gems/2.5.0/gems/mongo-1.12.5/lib/mongo/db.rb:606:in command'
/var/lib/gems/2.5.0/gems/mongo-1.12.5/lib/mongo/db.rb:610:in `rescue in command': Database command 'update' failed: BSON field 'update.multi' is an unknown field. (Mongo::OperationFailure)

Thanks

@anlek
Copy link
Owner

anlek commented Jun 18, 2019 via email

@TheBeachMaster
Copy link

@anlek I'm facing the same error running the latest tagged image from Docker hub.

$ sudo docker exec -ti 833d1e90b962 /bin/bash
root@833d1e90b962:/# mongo -version
MongoDB shell version v4.0.10
git version: c389e7f69f637f7a1ac3cc9fae843b635f20b766
OpenSSL version: OpenSSL 1.0.2g  1 Mar 2016
allocator: tcmalloc
modules: none
build environment:
    distmod: ubuntu1604
    distarch: x86_64
    target_arch: x86_64

Here's a snippet of the log

/Library/Ruby/Gems/2.3.0/gems/mongo-1.12.5/lib/mongo/db.rb:610:in `rescue in command': Database command 'update' failed: BSON field 'update.multi' is an unknown field. (Mongo::OperationFailure)                                                                    | ETA:  --:--:--
	from /Library/Ruby/Gems/2.3.0/gems/mongo-1.12.5/lib/mongo/db.rb:606:in `command'
	from /Library/Ruby/Gems/2.3.0/gems/mongo-1.12.5/lib/mongo/collection_writer.rb:314:in `block in send_write_command'
	from /Library/Ruby/Gems/2.3.0/gems/mongo-1.12.5/lib/mongo/functional/logging.rb:55:in `block in instrument'
	from /Library/Ruby/Gems/2.3.0/gems/mongo-1.12.5/lib/mongo/functional/logging.rb:20:in `instrument'
	from /Library/Ruby/Gems/2.3.0/gems/mongo-1.12.5/lib/mongo/functional/logging.rb:54:in `instrument'
	from /Library/Ruby/Gems/2.3.0/gems/mongo-1.12.5/lib/mongo/collection_writer.rb:313:in `send_write_command'
	from /Library/Ruby/Gems/2.3.0/gems/mongo-1.12.5/lib/mongo/collection.rb:1104:in `send_write'
	from /Library/Ruby/Gems/2.3.0/gems/mongo-1.12.5/lib/mongo/collection.rb:497:in `update'
	from /Library/Ruby/Gems/2.3.0/gems/mongify-1.3.2/lib/mongify/database/no_sql_connection.rb:145:in `remove_pre_mongified_ids'
	from /Library/Ruby/Gems/2.3.0/gems/mongify-1.3.2/lib/mongify/translation/processor_common.rb:116:in `block in remove_pre_mongified_ids'
	from /Library/Ruby/Gems/2.3.0/gems/mongify-1.3.2/lib/mongify/translation/processor_common.rb:114:in `each'
	from /Library/Ruby/Gems/2.3.0/gems/mongify-1.3.2/lib/mongify/translation/processor_common.rb:114:in `remove_pre_mongified_ids'
	from /Library/Ruby/Gems/2.3.0/gems/mongify-1.3.2/lib/mongify/translation/process.rb:18:in `process'
	from /Library/Ruby/Gems/2.3.0/gems/mongify-1.3.2/lib/mongify/cli/command/worker.rb:72:in `execute'
	from /Library/Ruby/Gems/2.3.0/gems/mongify-1.3.2/lib/mongify/cli/application.rb:28:in `execute!'
	from /Library/Ruby/Gems/2.3.0/gems/mongify-1.3.2/bin/mongify:17:in `<top (required)>'
	from /usr/local/bin/mongify:22:in `load'
	from /usr/local/bin/mongify:22:in `<main>'

@TheBeachMaster
Copy link

TheBeachMaster commented Jul 13, 2019 •
edited
Loading

UPDATE :
Anyone facing this issue, kindly refer to this comment by @anlek .

What version of MongoDB are you running? Currently, only 3.2 or lower is supported.

I downgraded my MongoDB version to 3.2 and it worked; very easy when you're using Docker-compose or K8's.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
duplicated
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
4 participants
@anlek @TheBeachMaster @optimus93 @cyrishikesh