i do:
python setup.py build --fcompiler=gnu
python setup.py install
1.6.2rc2 worked before (yesterday), but not now.
python tables.py
No handlers could be found for logger "blitz_gateway"
True
Table Columns:
Uid
MyStringColumnInit
Row count: 10
Get All Data for rows: [3, 5, 7]
Data for Column: Uid
1
2
3
4
5
6
7
8
9
10
Data for Column: MyStringColumnInit
one
two
three
four
five
six
seven
eight
nine
ten
Get Data for cols: [1] and between rows: 3 - 7
Data for Column: MyStringColumnInit
four
five
six
seven
Traceback (most recent call last):
File "tables.py", line 127, in ?
variables={}, start=0, stop=rowCount, step=0)
File "/data/applications/OMERO.server-Beta-4.3.4/lib/python/omero_Tables_ice.py", line 687, in getWhereList
return _M_omero.grid.Table._op_getWhereList.invoke(self, ((condition, variables, start, stop, step), _ctx))
omero.InternalException: exception ::omero::InternalException
{
serverStackTrace = Traceback (most recent call last):
File "/omero/OMERO.server-Beta-4.3.4/lib/python/omero/util/decorators.py", line 61, in exc_handler
File "/omero/OMERO.server-Beta-4.3.4/lib/python/omero/util/decorators.py", line 28, in handler
File "/data/applications/OMERO.server-Beta-4.3.4/lib/python/omero/tables.py", line 601, in getWhereList
rv = self.storage.getWhereList(self.stamp, condition, variables, None, start, stop, step)
File "/omero/OMERO.server-Beta-4.3.4/lib/python/omero/util/decorators.py", line 81, in with_lock
File "/data/applications/OMERO.server-Beta-4.3.4/lib/python/omero/tables.py", line 65, in check_and_update_stamp
return func(*args, **kwargs)
File "/data/applications/OMERO.server-Beta-4.3.4/lib/python/omero/tables.py", line 394, in getWhereList
return self.__mea.getWhereList(condition, variables, None, start, stop, step).tolist()
File "/usr/lib64/python2.4/site-packages/tables/table.py", line 1541, in getWhereList
coords = [ p.nrow for p in
File "/usr/lib64/python2.4/site-packages/tables/table.py", line 1437, in _where
compiled = self._compileCondition(condition, condvars)
File "/usr/lib64/python2.4/site-packages/tables/table.py", line 1316, in _compileCondition
compiled = compile_condition(condition, typemap, indexedcols, copycols)
File "/usr/lib64/python2.4/site-packages/tables/conditions.py", line 391, in compile_condition
func = NumExpr(expr, signature, copy_args=copycols)
File "/usr/lib64/python2.4/site-packages/numexpr-1.4.2-py2.4-linux-x86_64.egg/numexpr/necompiler.py", line 518, in NumExpr
input_names)
RuntimeError: invalid program: reduction operations must occur last
serverExceptionClass =
message = Internal exception
}
================================================================================
OMERO Diagnostics 4.3.4-dbcbce5a-b4
================================================================================
Commands: java -version 1.6.0 (/data/applications/jdk1.6.0_31/bin/java -- 2 others)
Commands: python -V 2.4.3 (/usr/bin/python)
Commands: icegridnode --version 3.3.1 (/usr/bin/icegridnode)
Commands: icegridadmin --version 3.3.1 (/usr/bin/icegridadmin)
Commands: psql --version 9.1.3 (/usr/bin/psql)
Server: icegridnode running
Server: Blitz-0 active (pid = 27915, enabled)
Server: DropBox active (pid = 27938, enabled)
Server: FileServer active (pid = 27947, enabled)
Server: Indexer-0 active (pid = 27943, enabled)
Server: MonitorServer active (pid = 27949, enabled)
Server: OMERO.Glacier2 active (pid = 27950, enabled)
Server: OMERO.IceStorm active (pid = 27953, enabled)
Server: PixelData-0 active (pid = 27952, enabled)
Server: Processor-0 active (pid = 27968, enabled)
Server: Tables-0 active (pid = 27977, enabled)
Server: TestDropBox inactive (enabled)
Log dir: /data/applications/OMERO.server-Beta-4.3.4/var/log exists
Log files: Blitz-0.log 249.0 MB errors=48 warnings=26
Log files: DropBox.log 25.0 KB errors=8 warnings=10
Log files: FileServer.log 4.0 KB
Log files: Indexer-0.log 239.0 KB errors=6 warnings=9
Log files: MonitorServer.log 15.0 KB errors=5 warnings=2
Log files: OMEROweb.log 205.0 KB errors=418 warnings=0
Log files: PixelData-0.log 163.0 KB errors=6 warnings=9
Log files: Processor-0.log 1.0 MB errors=0 warnings=6
Log files: Processor-0.log.1 4.0 MB
Log files: Processor-0.log.2 4.0 MB
Log files: Processor-0.log.3 4.0 MB
Log files: Processor-0.log.4 4.0 MB
Log files: Processor-0.log.5 4.0 MB
Log files: Processor-0.log.6 4.0 MB
Log files: Processor-0.log.7 4.0 MB
Log files: Processor-0.log.8 4.0 MB errors=1467 warnings=8805
Log files: Tables-0.log 0.0 KB
Log files: TestDropBox.log n/a
Log files: master.err 9.0 KB
Log files: master.out 0.0 KB
Log files: Total size 291.65 MB
Parsing Blitz-0.log:[line:863] => Server restarted <=
Parsing Blitz-0.log:[line:2047] => Server restarted <=
Parsing Blitz-0.log:[line:1534950] => Server restarted <=
Parsing Blitz-0.log:[line:1568218] => Server restarted <=
Parsing Blitz-0.log:[line:1569073] => Server restarted <=
Parsing Blitz-0.log:[line:1571086] => Server restarted <=
Parsing Blitz-0.log:[line:1607262] => Server restarted <=
Parsing Blitz-0.log:[line:1607738] => Server restarted <=
Parsing Blitz-0.log:[line:1608406] => Server restarted <=
Parsing Blitz-0.log:[line:1623460] => Server restarted <=
Environment:OMERO_HOME=/data/applications/OMERO.server-Beta-4.3.4
Environment:OMERO_NODE=(unset)
Environment:OMERO_MASTER=(unset)
Environment:PATH=/data/applications/jdk1.6.0_31/bin:/usr/share/Ice-3.3.1/bin:/data/oracle/product/11g/db_1/bin:/usr/sbin:/data/oracle/product/11g/db_1/bin:/usr/sbin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/data/applications/apache-ant-1.8.3/bin:/data/applications/jdk1.6.0_31/bin:/root/bin:/data/applications/hdf5-1.8.8/bin
Environment:ICE_HOME=/usr/share/Ice-3.3.1
Environment:LD_LIBRARY_PATH=/usr/share/java:/usr/lib:/usr/local/lib:/usr/local/hdf5/lib/
Environment:DYLD_LIBRARY_PATH=/usr/share/java:/usr/lib/:
OMERO data dir: '/OMERO' Exists? True Is writable? True
OMERO.web status... [RUNNING] (PID 27118)
2012-05-09 10:16:20,851 INFO [ omero.util.Server] (MainThread) ********************************************************************************
2012-05-09 10:16:20,851 INFO [ omero.util.Server] (MainThread) Starting
2012-05-09 10:16:20,851 INFO [ omero.util.Server] (MainThread) Loaded dependency numpy (1.6.2rc1)
2012-05-09 10:16:20,852 INFO [ omero.util.Server] (MainThread) Loaded dependency tables (2.3.1, hdf=1.8.8)
2012-05-09 10:16:20,853 INFO [ omero.util.Resources] (Thread-2 ) Starting
2012-05-09 10:16:37,352 INFO [ omero.utils] (MainThread) Failed to get session on attempt 1
2012-05-09 10:16:47,535 INFO [ omero.util.Server] (MainThread) Entering main loop
2012-05-09 10:23:48,519 INFO [ omero.remote] (Dummy-3 ) Meth: TablesI.getTable
2012-05-09 10:23:48,519 INFO [ omero.tables.TablesI] (Dummy-3 ) getTable: 401 {}
2012-05-09 10:23:48,656 INFO [ omero.tables.HdfStorage] (Dummy-3 ) Size: 0 - Attaching Table-DB329CA5-BE5A-4DEC-9331-53FC0E9EED49 to /OMERO/Files/401
2012-05-09 10:23:48,657 INFO [ omero.remote] (Dummy-3 ) Rslt: DB329CA5-BE5A-4DEC-9331-53FC0E9EED49 -t @ Tables-0.TablesAdapter
2012-05-09 10:23:48,690 INFO [ omero.remote] (Dummy-4 ) Meth: TableI.initialize
2012-05-09 10:23:48,716 INFO [ omero.tables.TableI] (Dummy-4 ) Initialized Table-DB329CA5-BE5A-4DEC-9331-53FC0E9EED49 with 2 col(s)
2012-05-09 10:23:48,716 INFO [ omero.remote] (Dummy-4 ) Rslt: None
2012-05-09 10:23:48,717 INFO [ omero.remote] (Dummy-5 ) Meth: TableI.addData
2012-05-09 10:23:48,719 INFO [ omero.tables.TableI] (Dummy-5 ) Added 10 row(s) of data to Table-DB329CA5-BE5A-4DEC-9331-53FC0E9EED49
2012-05-09 10:23:48,719 INFO [ omero.remote] (Dummy-5 ) Rslt: None
2012-05-09 10:23:48,720 INFO [ omero.remote] (Dummy-6 ) Meth: TableI.close
2012-05-09 10:23:48,720 INFO [ omero.tables.HdfStorage] (Dummy-6 ) Size: 1 - Detaching Table-DB329CA5-BE5A-4DEC-9331-53FC0E9EED49 from /OMERO/Files/401
2012-05-09 10:23:48,720 INFO [ omero.tables.HdfStorage] (Dummy-6 ) Cleaning storage: /OMERO/Files/401
2012-05-09 10:23:48,722 INFO [ omero.tables.TableI] (Dummy-6 ) Closed Table-DB329CA5-BE5A-4DEC-9331-53FC0E9EED49
2012-05-09 10:23:48,882 INFO [ omero.tables.TableI] (Dummy-6 ) Updated file object 401 to sha1=b2f0f5b019cd487d519985d3d822e5d4a54b522a (73792 bytes)
2012-05-09 10:23:48,883 INFO [ omero.remote] (Dummy-6 ) Rslt: None
2012-05-09 10:23:48,883 INFO [ omero.remote] (Dummy-7 ) Meth: TableI.getOriginalFile
2012-05-09 10:23:48,884 INFO [ omero.tables.TableI] (Dummy-7 ) Table-DB329CA5-BE5A-4DEC-9331-53FC0E9EED49.getOriginalFile() => id=401
2012-05-09 10:23:48,884 INFO [ omero.remote] (Dummy-7 ) Rslt: object #0 (::omero::model::OriginalFile)
{
_id = object #1 (::omero::RLong)
{
_val = 401
}
_deta
2012-05-09 10:23:49,033 INFO [ omero.remote] (Dummy-8 ) Meth: TablesI.getTable
2012-05-09 10:23:49,033 INFO [ omero.tables.TablesI] (Dummy-8 ) getTable: 401 {}
2012-05-09 10:23:49,051 INFO [ omero.tables.HdfStorage] (Dummy-8 ) Size: 0 - Attaching Table-6664EC7E-F8A8-4B76-8C2A-CE51AA0DED49 to /OMERO/Files/401
2012-05-09 10:23:49,052 INFO [ omero.remote] (Dummy-8 ) Rslt: 6664EC7E-F8A8-4B76-8C2A-CE51AA0DED49 -t @ Tables-0.TablesAdapter
2012-05-09 10:23:49,054 INFO [ omero.remote] (Dummy-9 ) Meth: TableI.getHeaders
2012-05-09 10:23:49,054 INFO [ omero.tables.TableI] (Dummy-9 ) Table-6664EC7E-F8A8-4B76-8C2A-CE51AA0DED49.getHeaders() => size=2
2012-05-09 10:23:49,054 INFO [ omero.remote] (Dummy-9 ) Rslt: [object #0 (::omero::grid::LongColumn)
{
name = Uid
description =
values = {}
}, object #0 (::omero::grid::
2012-05-09 10:23:49,055 INFO [ omero.remote] (Dummy-3 ) Meth: TableI.getNumberOfRows
2012-05-09 10:23:49,056 INFO [ omero.tables.TableI] (Dummy-3 ) Table-6664EC7E-F8A8-4B76-8C2A-CE51AA0DED49.getNumberOfRows() => 10
2012-05-09 10:23:49,056 INFO [ omero.remote] (Dummy-3 ) Rslt: 10
2012-05-09 10:23:49,057 INFO [ omero.remote] (Dummy-10 ) Meth: TableI.readCoordinates
2012-05-09 10:23:49,057 INFO [ omero.tables.TableI] (Dummy-10 ) Table-6664EC7E-F8A8-4B76-8C2A-CE51AA0DED49.readCoordinates(size=10)
2012-05-09 10:23:49,058 INFO [ omero.remote] (Dummy-10 ) Rslt: object #0 (::omero::grid::Data)
{
lastModification = 1336551829039
rowNumbers =
{
[0] = 0
[
2012-05-09 10:23:49,059 INFO [ omero.remote] (Dummy-4 ) Meth: TableI.read
2012-05-09 10:23:49,059 INFO [ omero.tables.TableI] (Dummy-4 ) Table-6664EC7E-F8A8-4B76-8C2A-CE51AA0DED49.read([1L], 3, 7)
2012-05-09 10:23:49,060 INFO [ omero.remote] (Dummy-4 ) Rslt: object #0 (::omero::grid::Data)
{
lastModification = 1336551829039
rowNumbers =
{
Thorondor wrote:you are sure it is the numpy version? So I should still try installing an older numpy version? Any other ideas?
>>> numpy.version.version
'1.4.1'
>>> import tables
RuntimeError: module compiled against API version 6 but this version of numpy is 4
Traceback (most recent call last):
File "<stdin>", line 1, in ?
File "/usr/lib64/python2.4/site-packages/tables/__init__.py", line 59, in ?
from tables.utilsExtension import getPyTablesVersion, getHDF5Version
ImportError: numpy.core.multiarray failed to import
{
_id = object #1 (::omero::RLong)
{
_val = 451
}
_deta
2012-05-09 16:47:23,322 INFO [ omero.remote] (Dummy-8 ) Meth: TablesI.getTable
2012-05-09 16:47:23,322 INFO [ omero.tables.TablesI] (Dummy-8 ) getTable: 451 {}
2012-05-09 16:47:23,339 INFO [ omero.tables.HdfStorage] (Dummy-8 ) Size: 0 - Attaching Table-D682A5EF-2B81-4602-879A-A2A774C3047F to /OMERO/Files/451
2012-05-09 16:47:23,339 INFO [ omero.remote] (Dummy-8 ) Rslt: D682A5EF-2B81-4602-879A-A2A774C3047F -t @ Tables-0.TablesAdapter
2012-05-09 16:47:23,342 INFO [ omero.remote] (Dummy-9 ) Meth: TableI.getHeaders
2012-05-09 16:47:23,342 INFO [ omero.tables.TableI] (Dummy-9 ) Table-D682A5EF-2B81-4602-879A-A2A774C3047F.getHeaders() => size=2
2012-05-09 16:47:23,342 INFO [ omero.remote] (Dummy-9 ) Rslt: [object #0 (::omero::grid::LongColumn)
{
name = Uid
description =
values = {}
}, object #0 (::omero::grid::
2012-05-09 16:47:23,343 INFO [ omero.remote] (Dummy-3 ) Meth: TableI.getNumberOfRows
2012-05-09 16:47:23,344 INFO [ omero.tables.TableI] (Dummy-3 ) Table-D682A5EF-2B81-4602-879A-A2A774C3047F.getNumberOfRows() => 10
2012-05-09 16:47:23,344 INFO [ omero.remote] (Dummy-3 ) Rslt: 10
2012-05-09 16:47:23,345 INFO [ omero.remote] (Dummy-10 ) Meth: TableI.readCoordinates
2012-05-09 16:47:23,345 INFO [ omero.tables.TableI] (Dummy-10 ) Table-D682A5EF-2B81-4602-879A-A2A774C3047F.readCoordinates(size=10)
2012-05-09 16:47:23,346 INFO [ omero.remote] (Dummy-10 ) Rslt: object #0 (::omero::grid::Data)
{
lastModification = 1336574843329
rowNumbers =
{
[0] = 0
[
2012-05-09 16:47:23,347 INFO [ omero.remote] (Dummy-4 ) Meth: TableI.read
2012-05-09 16:47:23,347 INFO [ omero.tables.TableI] (Dummy-4 ) Table-D682A5EF-2B81-4602-879A-A2A774C3047F.read([1L], 3, 7)
2012-05-09 16:47:23,348 INFO [ omero.remote] (Dummy-4 ) Rslt: object #0 (::omero::grid::Data)
{
lastModification = 1336574843329
rowNumbers =
{
[0] = 3
[
2012-05-09 16:47:23,349 INFO [ omero.remote] (Dummy-5 ) Meth: TableI.getWhereList
2012-05-09 16:47:23,350 INFO [ omero.remote] (Dummy-5 ) Excp: invalid program: reduction operations must occur last
2012-05-09 16:47:23,350 WARNI [ omero.remote] (Dummy-5 ) <function getWhereList at 0x1f274de8> raised a non-ServerError (<type 'instance'>): invalid program: reduction operations must occur last
2012-05-10 11:40:58,643 INFO [ omero.util.Server] (MainThread) Cleanup
2012-05-10 11:40:58,643 INFO [ omero.tables.TablesI] (MainThread) Cleaning up
2012-05-10 11:40:58,643 INFO [ omero.tables.HdfStorage] (MainThread) Size: 1 - Detaching Table-D682A5EF-2B81-4602-879A-A2A774C3047F from /OMERO/Files/451
2012-05-10 11:40:58,644 INFO [ omero.tables.HdfStorage] (MainThread) Cleaning storage: /OMERO/Files/451
2012-05-10 11:40:58,645 INFO [ omero.tables.TablesI] (MainThread) Done
2012-05-10 11:40:58,646 WARNI [ omero.util.ServerContext] (MainThread) Connection failure: Ice.ConnectionRefusedException:
Connection refused
2012-05-10 11:40:58,647 INFO [ omero.util.Server] (MainThread) Stopped
2012-05-10 11:40:58,647 INFO [ omero.util.Server] (MainThread) ********************************************************************************
Thorondor wrote:The idea behind all of this is that the biologist can later view the Images and Phenotype/Metadata in the omero client. For example he can see how many cells were found in one Image (e.g. cellcount 420)
and it should be also possible for him to select a minimum number of cells that should be in the image for example 400 and then he can view all those from one plate with more then 400 cells or even from a complete project.
124 # Query the table for rows where the 'Uid' is in a particular range
125 # =================================================================
126 queryRows = openTable.getWhereList("(Uid > 2) & (Uid <= 8)", variables={}, start=0, stop=rowCount, step=0)
127 data = openTable.readCoordinates(queryRows)
128 for col in data.columns:
129 print "Query Results for Column: ", col.name
130 for v in col.values:
131 print " ", v
132 openTable.close() # we're done
Get Data for cols: [1] and between rows: 3 - 7
Data for Column: MyStringColumnInit
four
five
six
seven
Traceback (most recent call last):
File "tables.py", line 126, in ?
queryRows = openTable.getWhereList("(Uid > 2) & (Uid <= 8)", variables={}, start=0, stop=rowCount, step=0)
File "/data/applications/OMERO.server-Beta-4.3.4/lib/python/omero_Tables_ice.py", line 687, in getWhereList
return _M_omero.grid.Table._op_getWhereList.invoke(self, ((condition, variables, start, stop, step), _ctx))
omero.InternalException: exception ::omero::InternalException
{
serverStackTrace = Traceback (most recent call last):
File "/omero/OMERO.server-Beta-4.3.4/lib/python/omero/util/decorators.py", line 61, in exc_handler
File "/omero/OMERO.server-Beta-4.3.4/lib/python/omero/util/decorators.py", line 28, in handler
File "/data/applications/OMERO.server-Beta-4.3.4/lib/python/omero/tables.py", line 601, in getWhereList
rv = self.storage.getWhereList(self.stamp, condition, variables, None, start, stop, step)
File "/omero/OMERO.server-Beta-4.3.4/lib/python/omero/util/decorators.py", line 81, in with_lock
File "/data/applications/OMERO.server-Beta-4.3.4/lib/python/omero/tables.py", line 65, in check_and_update_stamp
return func(*args, **kwargs)
File "/data/applications/OMERO.server-Beta-4.3.4/lib/python/omero/tables.py", line 394, in getWhereList
return self.__mea.getWhereList(condition, variables, None, start, stop, step).tolist()
File "/usr/lib64/python2.4/site-packages/tables/table.py", line 1541, in getWhereList
coords = [ p.nrow for p in
File "/usr/lib64/python2.4/site-packages/tables/table.py", line 1437, in _where
compiled = self._compileCondition(condition, condvars)
File "/usr/lib64/python2.4/site-packages/tables/table.py", line 1316, in _compileCondition
compiled = compile_condition(condition, typemap, indexedcols, copycols)
File "/usr/lib64/python2.4/site-packages/tables/conditions.py", line 391, in compile_condition
func = NumExpr(expr, signature, copy_args=copycols)
File "/usr/lib64/python2.4/site-packages/numexpr-2.0.1-py2.4-linux-x86_64.egg/numexpr/necompiler.py", line 544, in NumExpr
input_names)
RuntimeError: invalid program: too many buffers
serverExceptionClass =
message = Internal exception
}
Thorondor wrote:omero.tables is working with 1.6.1 numpy now.
and the script is alos running fine only problem is this part:
- Code: Select all
func = NumExpr(expr, signature, copy_args=copycols)
File "/usr/lib64/python2.4/site-packages/numexpr-2.0.1-py2.4-linux-x86_64.egg/numexpr/necompiler.py", line 544, in NumExpr
input_names)
RuntimeError: invalid program: too many buffers
serverExceptionClass =
message = Internal exception
}
I try to adapt the script to my needs, more news soon.
Users browsing this forum: Google [Bot] and 1 guest