Closed LenChang closed 9 years ago
Would it be possible to give the whole log output of running mosql (including the command). There might be some info there about what is going wrong since I haven't seen this before.
mosql -c collections.yaml --mongo mongodb://xx.xxx.xxx.xx --sql postgres://xx.xxx.xxx.xx/name?password=1111 -vvv
D, [2014-10-07T06:14:06.640896 #7478] DEBUG -- : (0.000319s) SET standard_conforming_strings = ON
D, [2014-10-07T06:14:06.643818 #7478] DEBUG -- : (0.000237s) SET client_min_messages = 'WARNING'
D, [2014-10-07T06:14:06.644043 #7478] DEBUG -- : (0.000129s) SET DateStyle = 'ISO'
D, [2014-10-07T06:14:06.645777 #7478] DEBUG -- : (0.001230s) SELECT NULL AS "nil" FROM "mosql_tailers" LIMIT 1
D, [2014-10-07T06:14:06.656736 #7478] DEBUG -- : (0.000554s) SELECT ("timestamp") FROM "mosql_tailers" WHERE ("service" = 'xxxxxReplSet') LIMIT 1
/usr/lib64/ruby/gems/1.8/gems/mongoriver-0.4.3/lib/mongoriver/abstract_persistent_tailer.rb:82:in read_state': read_state unimplemented! (RuntimeError) from /usr/lib64/ruby/gems/1.8/gems/mongoriver-0.4.3/lib/mongoriver/abstract_persistent_tailer.rb:95:in
read_position'
from /usr/lib64/ruby/gems/1.8/gems/mongoriver-0.4.3/lib/mongoriver/abstract_persistent_tailer.rb:25:in tail' from /usr/lib64/ruby/gems/1.8/gems/mongoriver-0.4.3/lib/mongoriver/tailer.rb:156:in
tail_from'
from /usr/lib64/ruby/gems/1.8/gems/mosql-0.3.2/lib/mosql/streamer.rb:167:in optail' from /usr/lib64/ruby/gems/1.8/gems/mosql-0.3.2/lib/mosql/cli.rb:165:in
run'
from /usr/lib64/ruby/gems/1.8/gems/mosql-0.3.2/lib/mosql/cli.rb:16:in run' from /usr/lib64/ruby/gems/1.8/gems/mosql-0.3.2/bin/mosql:5 from /usr/bin/mosql:23:in
load'
from /usr/bin/mosql:23
thanks for you help!!
Oh, it seems like you're using an old version of mosql that relied on mongoriver to also be an older version.
Update your mosql gem to be 0.4.0 and everything should start working.
Let me know if that doesn't help.
when i updated mosql. The log print some ERROR messages
Installing RDoc documentation for mongoriver-0.4.0 /usr/lib/ruby/1.8/rdoc/rdoc.rb:280: warning: conflicting chdir during another chdir block /usr/lib/ruby/1.8/rdoc/rdoc.rb:287: warning: conflicting chdir during another chdir block Installing ri documentation for mongoriver-0.4.0 /usr/lib/ruby/1.8/rdoc/rdoc.rb:280: warning: conflicting chdir during another chdir block /usr/lib/ruby/1.8/rdoc/rdoc.rb:287: warning: conflicting chdir during another chdir block ERROR: While generating documentation for mongoriver-0.4.0 ... MESSAGE: Unhandled special: Special: type=33, text="implement" ... RDOC args: --ri --op /usr/lib64/ruby/gems/1.8/doc/mongoriver-0.4.0/ri --quiet lib --title mongoriver-0.4.0 Documentation (continuing with the rest of the installation) Installing RDoc documentation for mosql-0.4.0 /usr/lib/ruby/1.8/rdoc/rdoc.rb:280: warning: conflicting chdir during another chdir block /usr/lib/ruby/1.8/rdoc/rdoc.rb:287: warning: conflicting chdir during another chdir block Installing ri documentation for mosql-0.4.0 /usr/lib/ruby/1.8/rdoc/rdoc.rb:280: warning: conflicting chdir during another chdir block /usr/lib/ruby/1.8/rdoc/rdoc.rb:287: warning: conflicting chdir during another chdir block Done installing documentation for mongoriver, mosql after 8 seconds Installing RDoc documentation for mongoriver-0.4.0 /usr/lib/ruby/1.8/rdoc/rdoc.rb:280: warning: conflicting chdir during another chdir block /usr/lib/ruby/1.8/rdoc/rdoc.rb:287: warning: conflicting chdir during another chdir block Installing ri documentation for mongoriver-0.4.0 /usr/lib/ruby/1.8/rdoc/rdoc.rb:280: warning: conflicting chdir during another chdir block /usr/lib/ruby/1.8/rdoc/rdoc.rb:287: warning: conflicting chdir during another chdir block ERROR: While generating documentation for mongoriver-0.4.0 ... MESSAGE: Unhandled special: Special: type=33, text="implement" ... RDOC args: --ri --op /usr/lib64/ruby/gems/1.8/doc/mongoriver-0.4.0/ri --quiet lib --title mongoriver-0.4.0 Documentation (continuing with the rest of the installation) Installing RDoc documentation for mosql-0.4.0 /usr/lib/ruby/1.8/rdoc/rdoc.rb:280: warning: conflicting chdir during another chdir block /usr/lib/ruby/1.8/rdoc/rdoc.rb:287: warning: conflicting chdir during another chdir block Installing ri documentation for mosql-0.4.0 /usr/lib/ruby/1.8/rdoc/rdoc.rb:280: warning: conflicting chdir during another chdir block /usr/lib/ruby/1.8/rdoc/rdoc.rb:287: warning: conflicting chdir during another chdir block
so it's correct ??
By the way. the latest version of MoSQL is working!!! it's a great product for our team, thanks a lot!!
Yeah, not sure why rdoc is yelling at you, but everything seems OK.
Glad you got it working!
i got a RuntimeError and i couldn't solve it.
/usr/lib64/ruby/gems/1.8/gems/mongoriver-0.4.3/lib/mongoriver/abstract_persistent_tailer.rb:82:in `read_state': read_state unimplemented! (RuntimeError)
So...what's the problem with this Q___Q...