Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-8153

[Doc'd] cbworkloadgen shows error import sqlite3 module

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 2.1.0
    • Fix Version/s: 2.1.0
    • Component/s: tools
    • Security Level: Public
    • Labels:
      None
    • Environment:
      centos 5.7 64 bit
    • Sprint:
      PCI Team - Sprint 6

      Description

      Install couchbase server 2.0.2-773
      cbworkloadge does not work

      Error:

      root@cen-0408 thuan]# /opt/couchbase/bin/cbworkloadgen -h
      Error: could not import sqlite3 module
      [root@cen-0408 thuan]# cd /opt/couchbase/bin
      [root@cen-0408 bin]# ./cbworkloadgen -h
      Error: could not import sqlite3 module

      [root@cen-0408 bin]# ./cbworkloadgen
      Error: could not import sqlite3 module

      # Subject Project Status CR V
      For Gerrit Dashboard: &For+MB-8153=message:MB-8153

        Activity

        Hide
        anil Anil Kumar added a comment -

        tony to test this on clean VM to verify if this repro.

        1. installing python 2.7 on clean vm
        2. check if it comes with sqllite3 already

        Show
        anil Anil Kumar added a comment - tony to test this on clean VM to verify if this repro. 1. installing python 2.7 on clean vm 2. check if it comes with sqllite3 already
        Hide
        pavelpaulau Pavel Paulau added a comment -

        0. Package "sqlite-devel" must be installed before Python 2.7 installation.

        Show
        pavelpaulau Pavel Paulau added a comment - 0. Package "sqlite-devel" must be installed before Python 2.7 installation.
        Hide
        maria Maria McDuff (Inactive) added a comment -

        karen, pls doc sqlite-devel need to be installed first prior to python 2.7. thanks.

        tony, pls verify / close. thanks.

        Show
        maria Maria McDuff (Inactive) added a comment - karen, pls doc sqlite-devel need to be installed first prior to python 2.7. thanks. tony, pls verify / close. thanks.
        Hide
        kzeller kzeller added a comment -

        Added to RN 2.0.2:

        <rnentry>

        <version ver="2.0.0m"/>

        <class id="fix"/>

        <issue type="cb" ref="MB-8153"/>

        <rntext>

        <para>
        In the past when you used <command>cbworkloadgen</command> you see this error <literal>ImportError: No module named _sqlite3</literal>.
        This has been fixed.</para>

        </rntext>

        </rnentry>

        Show
        kzeller kzeller added a comment - Added to RN 2.0.2: <rnentry> <version ver="2.0.0m"/> <class id="fix"/> <issue type="cb" ref=" MB-8153 "/> <rntext> <para> In the past when you used <command>cbworkloadgen</command> you see this error <literal>ImportError: No module named _sqlite3</literal>. This has been fixed.</para> </rntext> </rnentry>
        Hide
        thuan Thuan Nguyen added a comment -

        Test on build 2.0.2-804 with 3 vms with python 2.4.3, 2.6.5 and 2.7.1
        cbworkloadgen works as expected

        /opt/couchbase/bin/cbworkloadgen -h
        Usage: cbworkloadgen [options]

        Generate workload to destination.

        Examples:
        cbworkloadgen -n localhost:8091
        cbworkloadgen -n 10.3.121.192:8091 -r .9 -i 100000 \
        -s 100 -b my-other-bucket --threads=10

        Options:
        -h, --help show this help message and exit
        -r .95, --ratio-sets=.95
        set/get operation ratio
        -n 127.0.0.1:8091, --node=127.0.0.1:8091
        node's ns_server ip:port
        -b default, --bucket=default
        insert data to a different bucket other than default
        -i 10000, --max-items=10000
        number of items to be inserted
        -s 10, --size=10 minimum value size
        --prefix=pymc prefix to use for memcached keys or json ids
        -j, --json insert json data
        -l, --loop loop forever until interrupted by users
        -u USERNAME, --username=USERNAME
        REST username for cluster or server node
        -p PASSWORD, --password=PASSWORD
        REST password for cluster or server node
        -t 1, --threads=1 number of concurrent workers
        -v, --verbose verbose logging; more -v's provide more verbosity

        Show
        thuan Thuan Nguyen added a comment - Test on build 2.0.2-804 with 3 vms with python 2.4.3, 2.6.5 and 2.7.1 cbworkloadgen works as expected /opt/couchbase/bin/cbworkloadgen -h Usage: cbworkloadgen [options] Generate workload to destination. Examples: cbworkloadgen -n localhost:8091 cbworkloadgen -n 10.3.121.192:8091 -r .9 -i 100000 \ -s 100 -b my-other-bucket --threads=10 Options: -h, --help show this help message and exit -r .95, --ratio-sets=.95 set/get operation ratio -n 127.0.0.1:8091, --node=127.0.0.1:8091 node's ns_server ip:port -b default, --bucket=default insert data to a different bucket other than default -i 10000, --max-items=10000 number of items to be inserted -s 10, --size=10 minimum value size --prefix=pymc prefix to use for memcached keys or json ids -j, --json insert json data -l, --loop loop forever until interrupted by users -u USERNAME, --username=USERNAME REST username for cluster or server node -p PASSWORD, --password=PASSWORD REST password for cluster or server node -t 1, --threads=1 number of concurrent workers -v, --verbose verbose logging; more -v's provide more verbosity

          People

          • Assignee:
            thuan Thuan Nguyen
            Reporter:
            thuan Thuan Nguyen
          • Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Agile

                Gerrit Reviews

                There are no open Gerrit changes