[Stoq-users] erro atualizando banco de dados

Daniel Borrelly daniel em importudo.com.br
Quinta Maio 27 17:10:52 BRT 2010 

Ronaldo,

Olha este agora, de outra máquina, que está com a versão velha do stoq,
puxando a base de dados da máquina do e-mail anterior via rede:


stoqdbadmin updateschema
pg_dump: server version: 8.4.4; pg_dump version: 8.3.7
pg_dump: aborting because of version mismatch  (Use the -i option to
proceed anyway.)
INFO: [A atualização do Stoq falhou.] O Stoq está tentando restaurar a
base atual, mas não está conseguindo realizar esta restauração.
Por favor, mande todas as mensagens geradas para a equipe do stoq.
INFO:

A base de dados atual foi restaurada com sucesso.


Traceback (most recent call last):
  File "/usr/bin/stoqdbadmin", line 299, in <module>
    sys.exit(main(sys.argv))
  File "/usr/bin/stoqdbadmin", line 295, in main
    return handler.run_command(options, cmd, args)
  File "/usr/bin/stoqdbadmin", line 84, in run_command
    return func(options, *args)
  File "/usr/bin/stoqdbadmin", line 183, in cmd_updateschema
    migration.update_plugins()
  File
"/var/lib/python-support/python2.6/stoqlib/database/migration.py",
line 306, in update_plugins
    for plugin in get_utility(IPluginManager).get_active_plugins():
  File "/var/lib/python-support/python2.6/stoqlib/lib/pluginmanager.py",
line 156, in get_active_plugins
    for p in InstalledPlugin.select(connection=get_connection()):
  File "/usr/lib/stoqlib/sqlobject/sresults.py", line 169, in __iter__
    return iter(list(self.lazyIter()))
  File "/usr/lib/stoqlib/sqlobject/sresults.py", line 177, in lazyIter
    return conn.iterSelect(self)
  File "/usr/lib/stoqlib/sqlobject/dbconnection.py", line 372, in
iterSelect
    select, keepConnection=False)
  File "/usr/lib/stoqlib/sqlobject/dbconnection.py", line 758, in
__init__
    self.dbconn._executeRetry(self.rawconn, self.cursor, self.query)
  File "/usr/lib/stoqlib/sqlobject/dbconnection.py", line 306, in
_executeRetry
    return cursor.execute(query)
psycopg2.ProgrammingError: ERRO:  relação "installed_plugin" não existe
LINE 1: ...plugin_name, installed_plugin.plugin_version FROM
installed_...
                                                             ^



Em Qui, 2010-05-27 às 16:33 -0300, Ronaldo Maia escreveu:
> File "/usr/lib/pymodules/python2.6/stoq/lib/configparser.py", line
> 137, in _get_option
>    (self._filename, name))
> stoqlib.exceptions.NoConfigurationError: None does not have option: dbname
> 
> Então o usuário que vc está usando não tem o arquivo de configuração,
> ou o mesmo está incompleto, ou até mesmo sem permissão de leitura
> 
> Veja em ~/.stoq/stoq.conf
> 
> On Thu, May 27, 2010 at 4:29 PM, Daniel Borrelly
> <daniel em importudo.com.br> wrote:
> > Ok, está aí o erro sem o sudo, se é isto que vc queria...
> >
> > $ stoqdbadmin updateschema
> > /usr/lib/pymodules/python2.6/gtk-2.0/gtk/__init__.py:57: GtkWarning:
> > could not open display
> >  warnings.warn(str(e), _gtk.Warning)
> > Traceback (most recent call last):
> >  File "/usr/bin/stoqdbadmin", line 299, in <module>
> >    sys.exit(main(sys.argv))
> >  File "/usr/bin/stoqdbadmin", line 295, in main
> >    return handler.run_command(options, cmd, args)
> >  File "/usr/bin/stoqdbadmin", line 84, in run_command
> >    return func(options, *args)
> >  File "/usr/bin/stoqdbadmin", line 176, in cmd_updateschema
> >    self._read_config(options, check_schema=False, load_plugins=False)
> >  File "/usr/bin/stoqdbadmin", line 51, in _read_config
> >    check_schema=check_schema, load_plugins=load_plugins)
> >  File "/usr/lib/pymodules/python2.6/stoq/lib/startup.py", line 92, in
> > setup
> >    register_config(config)
> >  File "/usr/lib/pymodules/python2.6/kiwi/argcheck.py", line 180, in
> > wrapper
> >    return func(*args, **kwargs)
> >  File "/usr/lib/pymodules/python2.6/stoq/lib/configparser.py", line
> > 334, in register_config
> >    provide_utility(IDatabaseSettings, config.get_settings())
> >  File "/usr/lib/pymodules/python2.6/stoq/lib/configparser.py", line
> > 291, in get_settings
> >    dbname = self._get_option('dbname', section='Database')
> >  File "/usr/lib/pymodules/python2.6/stoq/lib/configparser.py", line
> > 137, in _get_option
> >    (self._filename, name))
> > stoqlib.exceptions.NoConfigurationError: None does not have option:
> > dbname
> >
> >
> > Em Qui, 2010-05-27 às 16:17 -0300, Ronaldo Maia escreveu:
> >> updateschema não deve ser executado com o sudo
> >>
> >> 2010/5/27 Daniel Borrelly <daniel em importudo.com.br>:
> >> > sudo stoqdbadmin updateschema
> >> > [sudo] password for daniel:
> >> > /usr/lib/pymodules/python2.6/gtk-2.0/gtk/__init__.py:57: GtkWarning:
> >> > could not open display
> >> >  warnings.warn(str(e), _gtk.Warning)
> >> > Traceback (most recent call last):
> >> >  File "/usr/bin/stoqdbadmin", line 299, in <module>
> >> >    sys.exit(main(sys.argv))
> >> >  File "/usr/bin/stoqdbadmin", line 295, in main
> >> >    return handler.run_command(options, cmd, args)
> >> >  File "/usr/bin/stoqdbadmin", line 84, in run_command
> >> >    return func(options, *args)
> >> >  File "/usr/bin/stoqdbadmin", line 176, in cmd_updateschema
> >> >    self._read_config(options, check_schema=False, load_plugins=False)
> >> >  File "/usr/bin/stoqdbadmin", line 51, in _read_config
> >> >    check_schema=check_schema, load_plugins=load_plugins)
> >> >  File "/usr/lib/pymodules/python2.6/stoq/lib/startup.py", line 92, in
> >> > setup
> >> >    register_config(config)
> >> >  File "/usr/lib/pymodules/python2.6/kiwi/argcheck.py", line 180, in
> >> > wrapper
> >> >    return func(*args, **kwargs)
> >> >  File "/usr/lib/pymodules/python2.6/stoq/lib/configparser.py", line
> >> > 334, in register_config
> >> >    provide_utility(IDatabaseSettings, config.get_settings())
> >> >  File "/usr/lib/pymodules/python2.6/stoq/lib/configparser.py", line
> >> > 291, in get_settings
> >> >    dbname = self._get_option('dbname', section='Database')
> >> >  File "/usr/lib/pymodules/python2.6/stoq/lib/configparser.py", line
> >> > 137, in _get_option
> >> >    (self._filename, name))
> >> > stoqlib.exceptions.NoConfigurationError: None does not have option:
> >> > dbname
> >> >
> >> > Alguma dica?
> >> > Ubuntu 10.04LTS + Python 2.4 e 2.6 (padrão)
> >> > Grato,
> >> > Daniel
> >> >
> >> > _______________________________________________
> >> > Lista de mensagens Stoq-users
> >> > Stoq-users em www.async.com.br
> >> > http://www.async.com.br/mailman/listinfo/stoq-users
> >> >
> >>
> >>
> >>
> >
> > --
> > Daniel Borrelly
> > loja em importudo.com.br (MSN)
> > VoIP: (11) 4063-7023
> > cel.: (11) 8383-1544
> > www.importudo.com.br
> >
> >
> 
> 
> 

-- 
Daniel Borrelly
loja em importudo.com.br (MSN)
VoIP: (11) 4063-7023
cel.: (11) 8383-1544
www.importudo.com.br

More information about the Stoq-users mailing list