18:19:51

#cat > config <<EOF

>  [pgqadm]
>  job_name = merkator
>  db = merkator=P
>
>  # how often to run maintenance [seconds]
>  maint_delay = 600
>
>  # how often to check for activity [seconds]
>  loop_delay = 0.1
>  logfile = ~/log/%(job_name)s.log
>  pidfile = ~/pid/%(job_name)s.pid
> EOF

18:19:57

#londiste config install

/usr/lib/pymodules/python2.6/londiste/setup.py:11: DeprecationWarning: the sets module is deprecated
  from sets import Set as set
Traceback (most recent call last):
  File "/usr/bin/londiste", line 133, in <module>
    script = Londiste(sys.argv[1:])
  File "/usr/bin/londiste", line 56, in __init__
    skytools.DBScript.__init__(self, 'londiste', args)
  File "/usr/lib/pymodules/python2.6/skytools/scripting.py", line 293, in __init__
    self.cf = self.load_config()
  File "/usr/lib/pymodules/python2.6/skytools/scripting.py", line 309, in load_config
    return Config(self.service_name, conf_file)
  File "/usr/lib/pymodules/python2.6/skytools/config.py", line 42, in __init__
    self.cf.read(filename)
  File "/usr/lib/python2.6/ConfigParser.py", line 286, in read
    self._read(fp, filename)
  File "/usr/lib/python2.6/ConfigParser.py", line 482, in _read
    raise MissingSectionHeaderError(fpname, lineno, line)
ConfigParser.MissingSectionHeaderError: File contains no section headers.
file: config, line: 1
' [pgqadm]\n'

18:20:21

#londiste config install

/usr/lib/pymodules/python2.6/londiste/setup.py:11: DeprecationWarning: the sets module is deprecated
  from sets import Set as set
Traceback (most recent call last):
  File "/usr/bin/londiste", line 133, in <module>
    script = Londiste(sys.argv[1:])
  File "/usr/bin/londiste", line 56, in __init__
    skytools.DBScript.__init__(self, 'londiste', args)
  File "/usr/lib/pymodules/python2.6/skytools/scripting.py", line 293, in __init__
    self.cf = self.load_config()
  File "/usr/lib/pymodules/python2.6/skytools/scripting.py", line 309, in load_config
    return Config(self.service_name, conf_file)
  File "/usr/lib/pymodules/python2.6/skytools/config.py", line 44, in __init__
    raise Exception("Wrong config file, no section '%s'"%main_section)
Exception: Wrong config file, no section 'londiste'

18:20:41

#londiste config install

/usr/lib/pymodules/python2.6/londiste/setup.py:11: DeprecationWarning: the sets module is deprecated
  from sets import Set as set
Traceback (most recent call last):
  File "/usr/bin/londiste", line 133, in <module>
    script = Londiste(sys.argv[1:])
  File "/usr/bin/londiste", line 56, in __init__
    skytools.DBScript.__init__(self, 'londiste', args)
  File "/usr/lib/pymodules/python2.6/skytools/scripting.py", line 297, in __init__
    self.log = _init_log(self.job_name, self.service_name, self.cf, self.log_level)
  File "/usr/lib/pymodules/python2.6/skytools/scripting.py", line 151, in _init_log
    logfile, 'a', size, num)
  File "/usr/lib/python2.6/logging/handlers.py", line 112, in __init__
    BaseRotatingHandler.__init__(self, filename, mode, encoding, delay)
  File "/usr/lib/python2.6/logging/handlers.py", line 64, in __init__
    logging.FileHandler.__init__(self, filename, mode, encoding, delay)
  File "/usr/lib/python2.6/logging/__init__.py", line 827, in __init__
    StreamHandler.__init__(self, self._open())
  File "/usr/lib/python2.6/logging/__init__.py", line 846, in _open
    stream = open(self.baseFilename, self.mode)
IOError: [Errno 2] No such file or directory: '/root/log/merkator.log'

18:22:47

#mkdir merkator

18:22:59

#londiste config install

/usr/lib/pymodules/python2.6/londiste/setup.py:11: DeprecationWarning: the sets module is deprecated
  from sets import Set as set
Traceback (most recent call last):
  File "/usr/bin/londiste", line 133, in <module>
    script = Londiste(sys.argv[1:])
  File "/usr/bin/londiste", line 56, in __init__
    skytools.DBScript.__init__(self, 'londiste', args)
  File "/usr/lib/pymodules/python2.6/skytools/scripting.py", line 297, in __init__
    self.log = _init_log(self.job_name, self.service_name, self.cf, self.log_level)
  File "/usr/lib/pymodules/python2.6/skytools/scripting.py", line 151, in _init_log
    logfile, 'a', size, num)
  File "/usr/lib/python2.6/logging/handlers.py", line 112, in __init__
    BaseRotatingHandler.__init__(self, filename, mode, encoding, delay)
  File "/usr/lib/python2.6/logging/handlers.py", line 64, in __init__
    logging.FileHandler.__init__(self, filename, mode, encoding, delay)
  File "/usr/lib/python2.6/logging/__init__.py", line 827, in __init__
    StreamHandler.__init__(self, self._open())
  File "/usr/lib/python2.6/logging/__init__.py", line 846, in _open
    stream = open(self.baseFilename, self.mode)
IOError: [Errno 2] No such file or directory: '/root/log/merkator.log'

18:23:03

#londiste config install

/usr/lib/pymodules/python2.6/londiste/setup.py:11: DeprecationWarning: the sets module is deprecated
  from sets import Set as set
Unknown command 'install', use --help for help

18:23:04

#londiste config --help

/usr/lib/pymodules/python2.6/londiste/setup.py:11: DeprecationWarning: the sets module is deprecated
  from sets import Set as set
Usage: londiste [options] INI CMD [subcmd args]
commands:
  replay                        replay events to subscriber
  provider install              installs modules, creates queue
  provider add TBL ...          add table to queue
  provider remove TBL ...       remove table from queue
  provider tables               show all tables on provider
  provider add-seq SEQ ...      add sequence to provider
...
    -r, --reload     reload config (send SIGHUP)
    -s, --stop       stop program safely (send SIGINT)
    -k, --kill       kill program immidiately (send SIGTERM)
  expert options:
    --all            add: include all possible tables
    --force          add: ignore table differences, repair: ignore lag
    --expect-sync    add: no copy needed
    --skip-truncate  add: keep old data
    --rewind         replay: sync queue pos with subscriber
    --reset          replay: forget queue pos on subscriber

18:23:07

#londiste config provider install

/usr/lib/pymodules/python2.6/londiste/setup.py:11: DeprecationWarning: the sets module is deprecated
  from sets import Set as set
Traceback (most recent call last):
  File "/usr/bin/londiste", line 133, in <module>
    script = Londiste(sys.argv[1:])
  File "/usr/bin/londiste", line 68, in __init__
    script = ProviderSetup(args)
  File "/usr/lib/pymodules/python2.6/londiste/setup.py", line 56, in __init__
    self.pgq_queue_name = self.cf.get("pgq_queue_name")
  File "/usr/lib/pymodules/python2.6/skytools/config.py", line 57, in get
    raise Exception("Config value not set: " + key)
Exception: Config value not set: pgq_queue_name

18:23:29

#londiste config provider install

/usr/lib/pymodules/python2.6/londiste/setup.py:11: DeprecationWarning: the sets module is deprecated
  from sets import Set as set
Traceback (most recent call last):
  File "/usr/bin/londiste", line 134, in <module>
    script.start()
  File "/usr/bin/londiste", line 97, in start
    self.script.start()
  File "/usr/lib/pymodules/python2.6/skytools/scripting.py", line 372, in start
    run_single_process(self, self.go_daemon, self.pidfile)
  File "/usr/lib/pymodules/python2.6/skytools/scripting.py", line 96, in run_single_process
...
    src_db = self.get_database('provider_db')
  File "/usr/lib/pymodules/python2.6/skytools/scripting.py", line 440, in get_database
    return dbc.get_connection(autocommit, isolation_level)
  File "/usr/lib/pymodules/python2.6/skytools/scripting.py", line 202, in get_connection
    self.conn = connect_database(self.loc)
  File "/usr/lib/pymodules/python2.6/skytools/psycopgwrapper.py", line 96, in connect_database
    return _pgconnect(connstr)
  File "/usr/lib/pymodules/python2.6/skytools/psycopgwrapper.py", line 74, in _pgconnect
    return _CompatConnection(cstr)
psycopg2.OperationalError: invalid connection option "merkator"

18:25:20

#mkdir /etc/skytools

18:49:54

#cat > /etc/skytools/ticker.ini <<EOF

> [pgqadm]
> job_name = merkator-ticker
> db = dbname=merkator
> maint_delay = 600
> loop_delay = 0.1
> logfile = /var/log/skytools/%(job_name)s.log
> pidfile = /var/run/skytools/%(job_name)s.pid
> EOF

18:50:06

Display all 102 possibilities? (y or n)
pager              pcp_detach_node    perl5.10.1         pg_dumpall         pg_updatedicts     pivot_root         podselect          ps                 pwdx               python
pam-auth-update    pcp_node_count     perlbug            pgfouine           pg_upgradecluster  pkill              popd               psed               pwunconv           python2.6
pam_getenv         pcp_node_info      perldoc            pgfouine_vacuum    php                pl2pm              poweroff           psql               py3_compilefiles   pyversions
pam_tally          pcp_proc_count     perlivp            pg_lsclusters      php5               plipconfig         pr                 pstruct            pycentral
pam_tally2         pcp_proc_info      perlthanks         pg_md5             pic                pmap               preconv            ptar               pyclean
partx              pcp_stop_pgpool    pg                 pgpool             pico               pod2html           prename            ptardiff           pycompile
passwd             pcp_systemdb_info  pgbouncer          pgqadm             piconv             pod2latex          print              ptx                py_compilefiles
paste              pcretest           pg_createcluster   pgrep              pidof              pod2man            printenv           pushd              pydoc
pathchk            pdb                pg_ctlcluster      pg_restore         ping               pod2text           printerbanner      pwck               pydoc2.6
pcimodules         pdb2.6             pg_dropcluster     pgsnap             ping6              pod2usage          printf             pwconv             pygettext
pcp_attach_node    perl               pg_dump            pgtune             pinky              podchecker         prove              pwd                pygettext2.6

18:50:06

#pgqadm /etc/skytools/ticker.ini install

Traceback (most recent call last):
  File "/usr/bin/pgqadm", line 195, in <module>
    script.start()
  File "/usr/bin/pgqadm", line 78, in start
    skytools.DBScript.start(self)
  File "/usr/lib/pymodules/python2.6/skytools/scripting.py", line 372, in start
    run_single_process(self, self.go_daemon, self.pidfile)
  File "/usr/lib/pymodules/python2.6/skytools/scripting.py", line 92, in run_single_process
    _write_pidfile(pidfile)
  File "/usr/lib/pymodules/python2.6/skytools/scripting.py", line 73, in _write_pidfile
    f = open(pidfile, 'w')
IOError: [Errno 2] No such file or directory: '/var/run/skytools/merkator-ticker.pid.admin'

18:50:42

#mkdir /var/run/skytools

18:50:51

#pgqadm /etc/skytools/ticker.ini ticker -d

18:50:56

#tail /var/log/skytools/merkator-ticker.log

2010-08-06 20:50:49,950 29953 INFO plpgsql is installed
2010-08-06 20:50:49,970 29953 INFO txid_current_snapshot is installed
2010-08-06 20:50:49,971 29953 INFO Installing pgq
2010-08-06 20:50:50,000 29953 INFO   Reading from /usr/share/skytools/pgq.sql
2010-08-06 20:50:56,729 29972 INFO {maint_duration: 0.110743999481}

18:51:03

#londiste /etc/skytools/londiste.ini provider install

/usr/lib/pymodules/python2.6/londiste/setup.py:11: DeprecationWarning: the sets module is deprecated
  from sets import Set as set
2010-08-06 21:06:38,000 30836 INFO plpgsql is installed
2010-08-06 21:06:38,035 30836 INFO txid_current_snapshot is installed
2010-08-06 21:06:38,036 30836 INFO pgq is installed
2010-08-06 21:06:38,036 30836 INFO londiste is installed

19:07:20

#londiste /etc/skytools/londiste.ini provider add --all

/usr/lib/pymodules/python2.6/londiste/setup.py:11: DeprecationWarning: the sets module is deprecated
  from sets import Set as set
2010-08-06 21:07:39,389 30879 INFO Adding public.rosterusers
Traceback (most recent call last):
  File "/usr/bin/londiste", line 134, in <module>
    script.start()
  File "/usr/bin/londiste", line 97, in start
    self.script.start()
  File "/usr/lib/pymodules/python2.6/skytools/scripting.py", line 372, in start
    run_single_process(self, self.go_daemon, self.pidfile)
...
  File "/usr/lib/pymodules/python2.6/londiste/setup.py", line 247, in provider_add_tables
    self.provider_add_table(tbl)
  File "/usr/lib/pymodules/python2.6/londiste/setup.py", line 271, in provider_add_table
    self.exec_provider(q, [self.pgq_queue_name, tbl])
  File "/usr/lib/pymodules/python2.6/londiste/setup.py", line 303, in exec_provider
    src_curs.execute(sql, args)
  File "/usr/lib/python2.6/dist-packages/psycopg2/extras.py", line 118, in execute
    return _cursor.execute(self, query, vars)
psycopg2.InternalError: need key column
CONTEXT:  PL/pgSQL function "provider_add_table" line 2 at RETURN

19:07:39

#londiste /etc/skytools/londiste.ini subscriber add --all

/usr/lib/pymodules/python2.6/londiste/setup.py:11: DeprecationWarning: the sets module is deprecated
  from sets import Set as set
2010-08-06 21:08:11,746 30904 ERROR Table public.rostergroups not attached to queue
2010-08-06 21:08:11,747 30904 ERROR Table public.spool not attached to queue
2010-08-06 21:08:11,747 30904 ERROR Table public.users not attached to queue
2010-08-06 21:08:11,747 30904 ERROR Table public.pubsub_node_option not attached to queue
2010-08-06 21:08:11,747 30904 ERROR Table public.pubsub_node_owner not attached to queue
2010-08-06 21:08:11,748 30904 ERROR Table public.vcard_search not attached to queue
2010-08-06 21:08:11,748 30904 ERROR Table public.rosterusers not attached to queue
2010-08-06 21:08:11,748 30904 ERROR Table public.privacy_default_list not attached to queue
2010-08-06 21:08:11,748 30904 ERROR Table public.pubsub_item not attached to queue
2010-08-06 21:08:11,748 30904 ERROR Table public.privacy_list_data not attached to queue
2010-08-06 21:08:11,748 30904 ERROR Table public.last not attached to queue
2010-08-06 21:08:11,749 30904 ERROR Table public.pubsub_node not attached to queue
2010-08-06 21:08:11,749 30904 ERROR Table public.pubsub_subscription_opt not attached to queue
2010-08-06 21:08:11,749 30904 ERROR Table public.privacy_list not attached to queue
2010-08-06 21:08:11,749 30904 ERROR Table public.roster_version not attached to queue
2010-08-06 21:08:11,749 30904 ERROR Table public.private_storage not attached to queue
2010-08-06 21:08:11,749 30904 ERROR Table public.pubsub_state not attached to queue
2010-08-06 21:08:11,750 30904 ERROR Table public.vcard not attached to queue

19:08:11

#londiste /etc/skytools/londiste.ini provider add --all

/usr/lib/pymodules/python2.6/londiste/setup.py:11: DeprecationWarning: the sets module is deprecated
  from sets import Set as set
2010-08-06 21:08:29,099 30933 INFO Adding public.rosterusers
Traceback (most recent call last):
  File "/usr/bin/londiste", line 134, in <module>
    script.start()
  File "/usr/bin/londiste", line 97, in start
    self.script.start()
  File "/usr/lib/pymodules/python2.6/skytools/scripting.py", line 372, in start
    run_single_process(self, self.go_daemon, self.pidfile)
...
  File "/usr/lib/pymodules/python2.6/londiste/setup.py", line 247, in provider_add_tables
    self.provider_add_table(tbl)
  File "/usr/lib/pymodules/python2.6/londiste/setup.py", line 271, in provider_add_table
    self.exec_provider(q, [self.pgq_queue_name, tbl])
  File "/usr/lib/pymodules/python2.6/londiste/setup.py", line 303, in exec_provider
    src_curs.execute(sql, args)
  File "/usr/lib/python2.6/dist-packages/psycopg2/extras.py", line 118, in execute
    return _cursor.execute(self, query, vars)
psycopg2.InternalError: need key column
CONTEXT:  PL/pgSQL function "provider_add_table" line 2 at RETURN

19:08:29

#londiste /etc/skytools/londiste.ini provider add --all

/usr/lib/pymodules/python2.6/londiste/setup.py:11: DeprecationWarning: the sets module is deprecated
  from sets import Set as set
2010-08-06 21:09:44,184 30975 INFO Adding public.rosterusers
Traceback (most recent call last):
  File "/usr/bin/londiste", line 134, in <module>
    script.start()
  File "/usr/bin/londiste", line 97, in start
    self.script.start()
  File "/usr/lib/pymodules/python2.6/skytools/scripting.py", line 372, in start
    run_single_process(self, self.go_daemon, self.pidfile)
...
  File "/usr/lib/pymodules/python2.6/londiste/setup.py", line 247, in provider_add_tables
    self.provider_add_table(tbl)
  File "/usr/lib/pymodules/python2.6/londiste/setup.py", line 271, in provider_add_table
    self.exec_provider(q, [self.pgq_queue_name, tbl])
  File "/usr/lib/pymodules/python2.6/londiste/setup.py", line 303, in exec_provider
    src_curs.execute(sql, args)
  File "/usr/lib/python2.6/dist-packages/psycopg2/extras.py", line 118, in execute
    return _cursor.execute(self, query, vars)
psycopg2.InternalError: need key column
CONTEXT:  PL/pgSQL function "provider_add_table" line 2 at RETURN

Журнал лабораторных работ

Журнал

Пятница (08/06/10)