[ZODB-Dev] OracleStorage Problem
E. Lefty Kreouzis
lefty at internet.gr
Fri Oct 10 03:40:00 EDT 2003
Hi to all,
I have a weird problem with DCOracleStorage, basically ot works fine on
Oracle 8.0.6 and doesn't work with Oracle 9.0.1 and higher
I have the following:
Zope 2.6.2, CMF 1.3.2, Plone 1.0.5,
DCOracle2 1.3b and 1.2 production (Same response)
Oracle client libs 9.0.2
OS Client Redhat Linux 7.3,
Database OS - Oracle 8.0.6 Solaris 8 called 'openview'
Database OS - Oracle 9.0.1 Windows 2000 called 'oas'
The custom_zodb.py file is the following:
---------------------------
import DCOracle2, DCOracleStorage
import zLOG
zLOG.LOG('custom_zodb', zLOG.INFO, 'Creating Storage class')
Storage=DCOracleStorage.Full( lambda :
DCOracle2.Connect('zope/XXXX at oas'), prefix='zodb_',)
zLOG.LOG('custom_zodb', zLOG.INFO, 'Done creating Storage class')
---------------------------
When I connect to the 'openview' database zope starts fine and works
perfectly
When I connect to the 'oas' database I can delete and recreate the schema:
$ sqlplus zope/XXXX at oas @./lib/python/Products/DCOracleStorage/Full
And by starting zope I get:
$ ./start
------
2003-10-09T16:47:07 INFO(0) zdaemon Started subprocess: pid 2759
Products/Archetypes/content_driver/MSWord.py[20]:?
Failed to import the OpenOffice PyUNO content converter.
Remind me to write a doc on how to set this up as its a better
converter than wvWare and in somecases even MSWord
/opt/zope/lib/python/ts_regex.py:15: DeprecationWarning: the regex module is deprecated; please use the re module
import regex, regsub #, Sync
/opt/zope/lib/python2.1/regsub.py:15: DeprecationWarning: the regsub module is deprecated; please use re.sub()
DeprecationWarning)
------
2003-10-09T16:47:09 INFO(0) custom_zodb Creating Storage class
------
2003-10-09T16:47:10 INFO(0) custom_zodb Done creating Storage class
------
2003-10-09T16:47:10 INFO(0) ZODB Opening database for mounting: '150380216_1065707230.187107'
------
2003-10-09T16:47:10 INFO(0) ZODB Mounted database '150380216_1065707230.187107' at /temp_folder
------
2003-10-09T16:47:40 INFO(0) Zope New disk product detected, determining if we need to fix up any ZClasses.
------
2003-10-09T16:47:40 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x02J'
Traceback (innermost last):
File /opt/zope/lib/python/ZODB/Connection.py, line 554, in setstate
File /opt/zope/lib/python/ZODB/Connection.py, line 591, in _set_ghost_state
EOFError
------
2003-10-09T16:47:40 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x02J'
Traceback (innermost last):
File /opt/zope/lib/python/ZODB/Connection.py, line 554, in setstate
File /opt/zope/lib/python/ZODB/Connection.py, line 591, in _set_ghost_state
EOFError
------
2003-10-09T16:47:40 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x02J'
Traceback (innermost last):
File /opt/zope/lib/python/ZODB/Connection.py, line 554, in setstate
File /opt/zope/lib/python/ZODB/Connection.py, line 591, in _set_ghost_state
EOFError
------
2003-10-09T16:47:41 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x03\xda'
Traceback (innermost last):
File /opt/zope/lib/python/ZODB/Connection.py, line 554, in setstate
File /opt/zope/lib/python/ZODB/Connection.py, line 591, in _set_ghost_state
EOFError
------
2003-10-09T16:47:41 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x03\xda'
Traceback (innermost last):
File /opt/zope/lib/python/ZODB/Connection.py, line 554, in setstate
File /opt/zope/lib/python/ZODB/Connection.py, line 591, in _set_ghost_state
EOFError
------
2003-10-09T16:47:41 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x03\xda'
Traceback (innermost last):
File /opt/zope/lib/python/ZODB/Connection.py, line 554, in setstate
File /opt/zope/lib/python/ZODB/Connection.py, line 591, in _set_ghost_state
EOFError
------
2003-10-09T16:47:41 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x044'
Traceback (innermost last):
File /opt/zope/lib/python/ZODB/Connection.py, line 554, in setstate
File /opt/zope/lib/python/ZODB/Connection.py, line 591, in _set_ghost_state
EOFError
------
2003-10-09T16:47:41 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x044'
Traceback (innermost last):
File /opt/zope/lib/python/ZODB/Connection.py, line 554, in setstate
File /opt/zope/lib/python/ZODB/Connection.py, line 591, in _set_ghost_state
EOFError
------
2003-10-09T16:47:41 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x044'
Traceback (innermost last):
File /opt/zope/lib/python/ZODB/Connection.py, line 554, in setstate
File /opt/zope/lib/python/ZODB/Connection.py, line 591, in _set_ghost_state
EOFError
------
2003-10-09T16:47:41 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x045'
Traceback (innermost last):
File /opt/zope/lib/python/ZODB/Connection.py, line 554, in setstate
File /opt/zope/lib/python/ZODB/Connection.py, line 591, in _set_ghost_state
EOFError
------
2003-10-09T16:47:41 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x045'
Traceback (innermost last):
File /opt/zope/lib/python/ZODB/Connection.py, line 554, in setstate
File /opt/zope/lib/python/ZODB/Connection.py, line 591, in _set_ghost_state
EOFError
------
2003-10-09T16:47:41 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x045'
Traceback (innermost last):
File /opt/zope/lib/python/ZODB/Connection.py, line 554, in setstate
File /opt/zope/lib/python/ZODB/Connection.py, line 591, in _set_ghost_state
EOFError
------
2003-10-09T16:47:41 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x05F'
Traceback (innermost last):
File /opt/zope/lib/python/ZODB/Connection.py, line 554, in setstate
File /opt/zope/lib/python/ZODB/Connection.py, line 591, in _set_ghost_state
EOFError
------
2003-10-09T16:47:41 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x05F'
Traceback (innermost last):
File /opt/zope/lib/python/ZODB/Connection.py, line 554, in setstate
File /opt/zope/lib/python/ZODB/Connection.py, line 591, in _set_ghost_state
EOFError
------
2003-10-09T16:47:41 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x05F'
Traceback (innermost last):
File /opt/zope/lib/python/ZODB/Connection.py, line 554, in setstate
File /opt/zope/lib/python/ZODB/Connection.py, line 591, in _set_ghost_state
EOFError
------
2003-10-09T16:47:41 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x05L'
Traceback (innermost last):
File /opt/zope/lib/python/ZODB/Connection.py, line 554, in setstate
File /opt/zope/lib/python/ZODB/Connection.py, line 591, in _set_ghost_state
EOFError
------
2003-10-09T16:47:41 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x05L'
Traceback (innermost last):
File /opt/zope/lib/python/ZODB/Connection.py, line 554, in setstate
File /opt/zope/lib/python/ZODB/Connection.py, line 591, in _set_ghost_state
EOFError
------
2003-10-09T16:47:41 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x05L'
Traceback (innermost last):
File /opt/zope/lib/python/ZODB/Connection.py, line 554, in setstate
File /opt/zope/lib/python/ZODB/Connection.py, line 591, in _set_ghost_state
EOFError
------
2003-10-09T16:47:41 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x05I'
Traceback (innermost last):
File /opt/zope/lib/python/ZODB/Connection.py, line 554, in setstate
File /opt/zope/lib/python/ZODB/Connection.py, line 591, in _set_ghost_state
EOFError
------
2003-10-09T16:47:41 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x05I'
Traceback (innermost last):
File /opt/zope/lib/python/ZODB/Connection.py, line 554, in setstate
File /opt/zope/lib/python/ZODB/Connection.py, line 591, in _set_ghost_state
EOFError
------
2003-10-09T16:47:41 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x05I'
Traceback (innermost last):
File /opt/zope/lib/python/ZODB/Connection.py, line 554, in setstate
File /opt/zope/lib/python/ZODB/Connection.py, line 591, in _set_ghost_state
EOFError
------
2003-10-09T16:47:42 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x07\x1f'
Traceback (innermost last):
File /opt/zope/lib/python/ZODB/Connection.py, line 554, in setstate
File /opt/zope/lib/python/ZODB/Connection.py, line 591, in _set_ghost_state
EOFError
------
2003-10-09T16:47:42 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x07\x1f'
Traceback (innermost last):
File /opt/zope/lib/python/ZODB/Connection.py, line 554, in setstate
File /opt/zope/lib/python/ZODB/Connection.py, line 591, in _set_ghost_state
EOFError
------
2003-10-09T16:47:42 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x07\x1f'
Traceback (innermost last):
File /opt/zope/lib/python/ZODB/Connection.py, line 554, in setstate
File /opt/zope/lib/python/ZODB/Connection.py, line 591, in _set_ghost_state
EOFError
------
2003-10-09T16:47:42 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x0b.'
Traceback (innermost last):
File /opt/zope/lib/python/ZODB/Connection.py, line 554, in setstate
File /opt/zope/lib/python/ZODB/Connection.py, line 591, in _set_ghost_state
EOFError
------
2003-10-09T16:47:42 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x0b.'
Traceback (innermost last):
File /opt/zope/lib/python/ZODB/Connection.py, line 554, in setstate
File /opt/zope/lib/python/ZODB/Connection.py, line 591, in _set_ghost_state
EOFError
------
2003-10-09T16:47:42 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x0b.'
Traceback (innermost last):
File /opt/zope/lib/python/ZODB/Connection.py, line 554, in setstate
File /opt/zope/lib/python/ZODB/Connection.py, line 591, in _set_ghost_state
EOFError
------
2003-10-09T16:47:42 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x0b&'
Traceback (innermost last):
File /opt/zope/lib/python/ZODB/Connection.py, line 554, in setstate
File /opt/zope/lib/python/ZODB/Connection.py, line 591, in _set_ghost_state
EOFError
------
2003-10-09T16:47:42 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x0b&'
Traceback (innermost last):
File /opt/zope/lib/python/ZODB/Connection.py, line 554, in setstate
File /opt/zope/lib/python/ZODB/Connection.py, line 591, in _set_ghost_state
EOFError
------
2003-10-09T16:47:42 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x0b&'
Traceback (innermost last):
File /opt/zope/lib/python/ZODB/Connection.py, line 554, in setstate
File /opt/zope/lib/python/ZODB/Connection.py, line 591, in _set_ghost_state
EOFError
------
2003-10-09T16:47:42 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x0b#'
Traceback (innermost last):
File /opt/zope/lib/python/ZODB/Connection.py, line 554, in setstate
File /opt/zope/lib/python/ZODB/Connection.py, line 591, in _set_ghost_state
EOFError
------
2003-10-09T16:47:42 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x0b#'
Traceback (innermost last):
File /opt/zope/lib/python/ZODB/Connection.py, line 554, in setstate
File /opt/zope/lib/python/ZODB/Connection.py, line 591, in _set_ghost_state
EOFError
------
2003-10-09T16:47:42 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x0b#'
Traceback (innermost last):
File /opt/zope/lib/python/ZODB/Connection.py, line 554, in setstate
File /opt/zope/lib/python/ZODB/Connection.py, line 591, in _set_ghost_state
EOFError
------
2003-10-09T16:47:42 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x0cr'
Traceback (innermost last):
File /opt/zope/lib/python/ZODB/Connection.py, line 554, in setstate
File /opt/zope/lib/python/ZODB/Connection.py, line 591, in _set_ghost_state
EOFError
------
2003-10-09T16:47:42 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x0cr'
Traceback (innermost last):
File /opt/zope/lib/python/ZODB/Connection.py, line 554, in setstate
File /opt/zope/lib/python/ZODB/Connection.py, line 591, in _set_ghost_state
EOFError
------
2003-10-09T16:47:42 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x0cr'
Traceback (innermost last):
File /opt/zope/lib/python/ZODB/Connection.py, line 554, in setstate
File /opt/zope/lib/python/ZODB/Connection.py, line 591, in _set_ghost_state
EOFError
------
2003-10-09T16:47:42 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x0c\xd0'
Traceback (innermost last):
File /opt/zope/lib/python/ZODB/Connection.py, line 554, in setstate
File /opt/zope/lib/python/ZODB/Connection.py, line 591, in _set_ghost_state
EOFError
------
2003-10-09T16:47:42 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x0c\xd0'
Traceback (innermost last):
File /opt/zope/lib/python/ZODB/Connection.py, line 554, in setstate
File /opt/zope/lib/python/ZODB/Connection.py, line 591, in _set_ghost_state
EOFError
------
2003-10-09T16:47:42 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x0c\xd0'
Traceback (innermost last):
File /opt/zope/lib/python/ZODB/Connection.py, line 554, in setstate
File /opt/zope/lib/python/ZODB/Connection.py, line 591, in _set_ghost_state
EOFError
------
2003-10-09T16:47:43 PANIC(300) z2 Startup exception
Traceback (innermost last):
File /opt/zope/z2.py, line 659, in ?
If I try to restart zope I get
$ ./start
------
2003-10-09T16:45:35 INFO(0) zdaemon Started subprocess: pid 2754
Products/Archetypes/content_driver/MSWord.py[20]:?
Failed to import the OpenOffice PyUNO content converter.
Remind me to write a doc on how to set this up as its a better
converter than wvWare and in somecases even MSWord
/opt/zope/lib/python/ts_regex.py:15: DeprecationWarning: the regex module is deprecated; please use the re module
import regex, regsub #, Sync
/opt/zope/lib/python2.1/regsub.py:15: DeprecationWarning: the regsub module is deprecated; please use re.sub()
DeprecationWarning)
------
2003-10-09T16:45:38 INFO(0) custom_zodb Creating Storage class
------
2003-10-09T16:45:38 INFO(0) custom_zodb Done creating Storage class
------
2003-10-09T16:45:38 INFO(0) ZODB Opening database for mounting: '150380368_1065695266.414956'
------
2003-10-09T16:45:38 INFO(0) ZODB Mounted database '150380368_1065695266.414956' at /temp_folder
------
2003-10-09T16:45:39 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x05\x8d'
Traceback (innermost last):
File /opt/zope/lib/python/ZODB/Connection.py, line 554, in setstate
File /opt/zope/lib/python/ZODB/Connection.py, line 591, in _set_ghost_state
EOFError
------
2003-10-09T16:45:39 ERROR(200) Zope manage_beforeDelete() threw
Traceback (innermost last):
File /opt/zope/lib/python/OFS/ObjectManager.py, line 309, in _delObject
(Object: Help)
File /opt/zope/lib/python/HelpSys/HelpTopic.py, line 85, in manage_beforeDelete
(Object: FileField)
File /opt/zope/lib/python/HelpSys/HelpTopic.py, line 95, in unindex_object
(Object: FileField)
File /opt/zope/lib/python/Products/ZCatalog/ZCatalog.py, line 530, in uncatalog_object
(Object: catalog)
File /opt/zope/lib/python/Products/ZCatalog/Catalog.py, line 407, in uncatalogObject
File /opt/zope/lib/python/Products/PluginIndexes/TextIndex/TextIndex.py, line 368, in unindex_object
(Object: SearchableText)
File /opt/zope/lib/python/ZODB/Connection.py, line 554, in setstate
File /opt/zope/lib/python/ZODB/Connection.py, line 591, in _set_ghost_state
EOFError
------
2003-10-09T16:45:39 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x05~'
Traceback (innermost last):
File /opt/zope/lib/python/ZODB/Connection.py, line 554, in setstate
File /opt/zope/lib/python/ZODB/Connection.py, line 591, in _set_ghost_state
EOFError
------
2003-10-09T16:45:39 ERROR(200) Zope Couldn't install Formulator
Traceback (innermost last):
File /opt/zope/lib/python/OFS/Application.py, line 629, in install_product
(Object: Zope)
(Info: Formulator)
File /opt/zope/lib/python/Products/Formulator/__init__.py, line 62, in initialize
File /opt/zope/lib/python/Products/Formulator/FieldRegistry.py, line 62, in registerFieldHelp
File /opt/zope/lib/python/App/ProductContext.py, line 257, in registerHelpTopic
File /opt/zope/lib/python/OFS/ObjectManager.py, line 272, in _setObject
(Object: Help)
File /opt/zope/lib/python/HelpSys/HelpTopic.py, line 79, in manage_afterAdd
(Object: FileField)
File /opt/zope/lib/python/HelpSys/HelpTopic.py, line 92, in index_object
(Object: FileField)
File /opt/zope/lib/python/Products/ZCatalog/ZCatalog.py, line 500, in catalog_object
(Object: catalog)
File /opt/zope/lib/python/Products/ZCatalog/Catalog.py, line 365, in catalogObject
File /opt/zope/lib/python/Products/ZCatalog/Catalog.py, line 330, in updateMetadata
File /opt/zope/lib/python/ZODB/Connection.py, line 554, in setstate
File /opt/zope/lib/python/ZODB/Connection.py, line 591, in _set_ghost_state
EOFError
------
2003-10-09T16:45:39 PANIC(300) z2 Startup exception
Traceback (innermost last):
File /opt/zope/z2.py, line 585, in ?
File /opt/zope/lib/python/Zope/__init__.py, line 46, in startup
(Object: startup)
File /opt/zope/lib/python/Zope/App/startup.py, line 92, in startup
(Object: Oracle Storage)
File /opt/zope/lib/python/Products/CMFPlone/PloneInitialize.py, line 42, in go
(Object: Zope)
File /opt/zope/lib/python/OFS/Application.py, line 409, in initialize
(Object: Zope)
File /opt/zope/lib/python/OFS/Application.py, line 567, in install_products
(Object: Zope)
File /opt/zope/lib/python/OFS/Application.py, line 629, in install_product
(Object: Zope)
(Info: Formulator)
File /opt/zope/lib/python/Products/Formulator/__init__.py, line 62, in initialize
File /opt/zope/lib/python/Products/Formulator/FieldRegistry.py, line 62, in registerFieldHelp
File /opt/zope/lib/python/App/ProductContext.py, line 257, in registerHelpTopic
File /opt/zope/lib/python/OFS/ObjectManager.py, line 272, in _setObject
(Object: Help)
File /opt/zope/lib/python/HelpSys/HelpTopic.py, line 79, in manage_afterAdd
(Object: FileField)
File /opt/zope/lib/python/HelpSys/HelpTopic.py, line 92, in index_object
(Object: FileField)
File /opt/zope/lib/python/Products/ZCatalog/ZCatalog.py, line 500, in catalog_object
(Object: catalog)
File /opt/zope/lib/python/Products/ZCatalog/Catalog.py, line 365, in catalogObject
File /opt/zope/lib/python/Products/ZCatalog/Catalog.py, line 330, in updateMetadata
File /opt/zope/lib/python/ZODB/Connection.py, line 554, in setstate
File /opt/zope/lib/python/ZODB/Connection.py, line 591, in _set_ghost_state
EOFError
Thanks in advance for any help
E. Lefty Kreouzis
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.zope.org/pipermail/zodb-dev/attachments/20031010/962e2191/attachment-0001.html
More information about the ZODB-Dev
mailing list