Discussion:
[Info-ingres] Sigsegv on optimize of imadb
(too old to reply)
Jürgen Cappel
2006-12-18 15:02:41 UTC
Permalink
Hi Martin,

I'm running command

optimizedb -zk -u'$ingres' imadb

on my installation: Ingres Linux Version II 3.0.1 (int.lnx/103)

with output:

I_OP091C optimizedb: table 'ice_active_users' in database 'imadb'
contains no rows.
I_OP091C optimizedb: table 'ice_cache' in database 'imadb'
contains no rows.
I_OP091C optimizedb: table 'ice_db_connections' in database
'imadb' contains no rows.
I_OP091C optimizedb: table 'ice_locations' in database 'imadb'
contains no rows.
I_OP091C optimizedb: table 'ice_user_cursors' in database 'imadb'
contains no rows.
I_OP091C optimizedb: table 'ice_user_transactions' in database
'imadb' contains no rows.
I_OP091C optimizedb: table 'ice_users' in database 'imadb'
contains no rows.
I_OP091C optimizedb: table 'ima_config' in database 'imadb'
contains no rows.
I_OP091C optimizedb: table 'ima_cssampler_stats' in database
'imadb' contains no rows.
I_OP091C optimizedb: table 'ima_cssampler_threads' in database
'imadb' contains no rows.
I_OP091C optimizedb: table 'ima_di_slave_info' in database
'imadb' contains no rows.
I_OP091C optimizedb: table 'ima_dmf_bm_configuration' in database
'imadb' contains no rows.
I_OP091C optimizedb: table 'ima_dmf_buffer_manager_stats' in
database 'imadb' contains no rows.
I_OP091C optimizedb: table 'ima_gcb_info' in database 'imadb'
contains no rows.
I_OP091C optimizedb: table 'ima_gcc_info' in database 'imadb'
contains no rows.
I_OP091C optimizedb: table 'ima_gcn_info' in database 'imadb'
contains no rows.
I_OP091C optimizedb: table 'ima_gcn_registrations' in database
'imadb' contains no rows.
I_OP091C optimizedb: table 'ima_qef_info' in database 'imadb'
contains no rows.
I_OP091C optimizedb: table 'ima_qsf_dbp' in database 'imadb'
contains no rows.
I_OP091C optimizedb: table 'remotecmd' in database 'imadb'
contains no rows.


Nothing new in $II_SYSTEM/ingres/files/errlog.log except:

Ingres Release II 3.0.1 (int.lnx/103) Server -- Normal Startup.

Nothing wrong. Maybe the "freeze" has something to do with temperatures
in Europe ...

Good luck,

Jürgen






-------- Original Message --------
Subject: [Info-ingres] Sigsegv on optimize of imadb
Date: Mon, 18 Dec 2006 12:22:20 -0000
From: ***@ctsu.ox.ac.uk
To: info-***@cariboulake.com



Hi Everyone,

I've just noticed that if I run optimizedb -zk -u'$ingres' imadb on IngresII
R3 or Ingres2006 I get a SIGSEGV at the front-end (and in the errlog).
At the front-end only I get:
E_OP095B System or hardware exception occurred in optimizer
utility.

The optimizedb then freezes.

Has anyone else seen this behaviour?

Martin Bowes
m***@ctsu.ox.ac.uk
2006-12-18 16:23:41 UTC
Permalink
Hi Jürgen,

Thanks for the input, that's intereesting.

I'm getting failures on II 3.0.3 (a64.lnx/211) patch11577
and: II 9.0.4 (a64.lnx/105)NPTL patch11838

Using II_EMBED_SET printqry, it looks like the errant query is:
select "classid" from "ima_mib_objects" order by 1

But that query can be executed from the SQL prompt.

optimizedb -zk -u'$ingres' imadb has output
I_OP091C optimizedb: table 'ice_active_users' in database 'imadb'
contains no rows.
I_OP091C optimizedb: table 'ice_cache' in database 'imadb'
contains no rows.
I_OP091C optimizedb: table 'ice_db_connections' in database
'imadb' contains no rows.
I_OP091C optimizedb: table 'ice_locations' in database 'imadb'
contains no rows.
I_OP091C optimizedb: table 'ice_user_cursors' in database 'imadb'
contains no rows.
I_OP091C optimizedb: table 'ice_user_transactions' in database
'imadb' contains no rows.
I_OP091C optimizedb: table 'ice_users' in database 'imadb'
contains no rows.
I_OP091C optimizedb: table 'ima_config' in database 'imadb'
contains no rows.
I_OP091C optimizedb: table 'ima_cssampler_stats' in database
'imadb' contains no rows.
I_OP091C optimizedb: table 'ima_cssampler_threads' in database
'imadb' contains no rows.
I_OP091C optimizedb: table 'ima_di_slave_info' in database
'imadb' contains no rows.
I_OP091C optimizedb: table 'ima_gcb_info' in database 'imadb'
contains no rows.
I_OP091C optimizedb: table 'ima_gcc_info' in database 'imadb'
contains no rows.
I_OP091C optimizedb: table 'ima_gcn_info' in database 'imadb'
contains no rows.
I_OP091C optimizedb: table 'ima_gcn_registrations' in database
'imadb' contains no rows.
I_OP091C optimizedb: table 'ima_instance_cnf' in database 'imadb'
contains no rows.
E_OP095B System or hardware exception occurred in optimizer
utility.
à6ÿ¿Segmentation Violation (SIGSEGV) @PC 0000002a9595b05a
RSP 0000007fbfff4710 RBP 000000004032f080 RSI
0000000000000001
RDI 000000004032f080 RAX 000000004032fb00 RBX
2e666c672e707865
RCX 0000000000000000 RDX 0000002a95bc29e0


Marty
Post by Jürgen Cappel
Hi Martin,
I'm running command
optimizedb -zk -u'$ingres' imadb
on my installation: Ingres Linux Version II 3.0.1 (int.lnx/103)
I_OP091C optimizedb: table 'ice_active_users' in database 'imadb'
contains no rows. I_OP091C optimizedb: table 'ice_cache' in database
'imadb' contains no rows. I_OP091C optimizedb: table
'ice_db_connections' in database 'imadb' contains no rows. I_OP091C
optimizedb: table 'ice_locations' in database 'imadb' contains no
rows. I_OP091C optimizedb: table 'ice_user_cursors' in database
'imadb' contains no rows. I_OP091C optimizedb: table
'ice_user_transactions' in database 'imadb' contains no rows. I_OP091C
optimizedb: table 'ice_users' in database 'imadb' contains no rows.
I_OP091C optimizedb: table 'ima_config' in database 'imadb' contains
no rows. I_OP091C optimizedb: table 'ima_cssampler_stats' in database
'imadb' contains no rows. I_OP091C optimizedb: table
'ima_cssampler_threads' in database 'imadb' contains no rows. I_OP091C
optimizedb: table 'ima_di_slave_info' in database 'imadb' contains no
rows. I_OP091C optimizedb: table 'ima_dmf_bm_configuration' in
database 'imadb' contains no rows. I_OP091C optimizedb: table
'ima_dmf_buffer_manager_stats' in database 'imadb' contains no rows.
I_OP091C optimizedb: table 'ima_gcb_info' in database 'imadb' contains
no rows. I_OP091C optimizedb: table 'ima_gcc_info' in database 'imadb'
contains no rows. I_OP091C optimizedb: table 'ima_gcn_info' in
database 'imadb' contains no rows. I_OP091C optimizedb: table
'ima_gcn_registrations' in database 'imadb' contains no rows. I_OP091C
optimizedb: table 'ima_qef_info' in database 'imadb' contains no rows.
I_OP091C optimizedb: table 'ima_qsf_dbp' in database 'imadb' contains
no rows. I_OP091C optimizedb: table 'remotecmd' in database 'imadb'
contains no rows.
Ingres Release II 3.0.1 (int.lnx/103) Server -- Normal Startup.
Nothing wrong. Maybe the "freeze" has something to do with
temperatures in Europe ...
Good luck,
Jürgen
-------- Original Message --------
[Info-ingres] Sigsegv on optimize of imadb
Mon, 18 Dec 2006 12:22:20 -0000
Hi Everyone,
I've just noticed that if I run optimizedb -zk -u'$ingres' imadb on
IngresII R3 or Ingres2006 I get a SIGSEGV at the front-end (and in the
errlog). At the front-end only I get: E_OP095B System or
hardware exception occurred in optimizer utility.
The optimizedb then freezes.
Has anyone else seen this behaviour?
Martin Bowes
_______________________________________________
Info-ingres mailing list
http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres
John Smedley
2006-12-19 16:39:03 UTC
Permalink
Funny that this should come up - I had been ready to log an issue against this problem.

The problem is when you run Optimizedb against IMADB, you are only running it against the values that the MIB server can see, the domain is not extended into the local domain and if you at some point in your use of IMA extend the domain into another remote domain, there will be no information in the statistics gathered.

I have suggested in the issue that Optimizedb should ignore IMA tables for the above reason.

I have also raised an issue about CREATE INDEX against IMA tables where there is a similar problem i.e. extending or changing the domain can lead to incorrect values being returned or no rows found via the index.

The recommendation is that it should not be possible to create an index against an IMA table.

Something else to think about -
1. It is possible to MODIFY an IMA table (by default BTREE) to a different structure. I have not yet worked out what this means or why there is a default.

2. And as for row count of 1000 as a value. That is a hint to OPF, but is it sensible to have it at 1000; there are very few IMA tables that would return 100 rows. But it is possible to set this value when you register the IMA table so maybe this is not a big deal.


Cheers

John Smedley



-----Original Message-----
From: info-ingres-***@cariboulake.com [mailto:info-ingres-***@cariboulake.com] On Behalf Of ***@ctsu.ox.ac.uk
Sent: 18 December 2006 16:06
To: Jürgen Cappel
Cc: info-***@cariboulake.com
Subject: Re: [Info-ingres] Sigsegv on optimize of imadb

Hi Jürgen,

Thanks for the input, that's intereesting.

I'm getting failures on II 3.0.3 (a64.lnx/211) patch11577
and: II 9.0.4 (a64.lnx/105)NPTL patch11838

Using II_EMBED_SET printqry, it looks like the errant query is:
select "classid" from "ima_mib_objects" order by 1

But that query can be executed from the SQL prompt.

optimizedb -zk -u'$ingres' imadb has output
I_OP091C optimizedb: table 'ice_active_users' in database 'imadb'
contains no rows.
I_OP091C optimizedb: table 'ice_cache' in database 'imadb'
contains no rows.
I_OP091C optimizedb: table 'ice_db_connections' in database
'imadb' contains no rows.
I_OP091C optimizedb: table 'ice_locations' in database 'imadb'
contains no rows.
I_OP091C optimizedb: table 'ice_user_cursors' in database 'imadb'
contains no rows.
I_OP091C optimizedb: table 'ice_user_transactions' in database
'imadb' contains no rows.
I_OP091C optimizedb: table 'ice_users' in database 'imadb'
contains no rows.
I_OP091C optimizedb: table 'ima_config' in database 'imadb'
contains no rows.
I_OP091C optimizedb: table 'ima_cssampler_stats' in database
'imadb' contains no rows.
I_OP091C optimizedb: table 'ima_cssampler_threads' in database
'imadb' contains no rows.
I_OP091C optimizedb: table 'ima_di_slave_info' in database
'imadb' contains no rows.
I_OP091C optimizedb: table 'ima_gcb_info' in database 'imadb'
contains no rows.
I_OP091C optimizedb: table 'ima_gcc_info' in database 'imadb'
contains no rows.
I_OP091C optimizedb: table 'ima_gcn_info' in database 'imadb'
contains no rows.
I_OP091C optimizedb: table 'ima_gcn_registrations' in database
'imadb' contains no rows.
I_OP091C optimizedb: table 'ima_instance_cnf' in database 'imadb'
contains no rows.
E_OP095B System or hardware exception occurred in optimizer
utility.
à6ÿ¿Segmentation Violation (SIGSEGV) @PC 0000002a9595b05a
RSP 0000007fbfff4710 RBP 000000004032f080 RSI
0000000000000001
RDI 000000004032f080 RAX 000000004032fb00 RBX
2e666c672e707865
RCX 0000000000000000 RDX 0000002a95bc29e0


Marty
Post by Jürgen Cappel
Hi Martin,
I'm running command
optimizedb -zk -u'$ingres' imadb
on my installation: Ingres Linux Version II 3.0.1 (int.lnx/103)
I_OP091C optimizedb: table 'ice_active_users' in database 'imadb'
contains no rows. I_OP091C optimizedb: table 'ice_cache' in database
'imadb' contains no rows. I_OP091C optimizedb: table
'ice_db_connections' in database 'imadb' contains no rows. I_OP091C
optimizedb: table 'ice_locations' in database 'imadb' contains no
rows. I_OP091C optimizedb: table 'ice_user_cursors' in database
'imadb' contains no rows. I_OP091C optimizedb: table
'ice_user_transactions' in database 'imadb' contains no rows. I_OP091C
optimizedb: table 'ice_users' in database 'imadb' contains no rows.
I_OP091C optimizedb: table 'ima_config' in database 'imadb' contains
no rows. I_OP091C optimizedb: table 'ima_cssampler_stats' in database
'imadb' contains no rows. I_OP091C optimizedb: table
'ima_cssampler_threads' in database 'imadb' contains no rows. I_OP091C
optimizedb: table 'ima_di_slave_info' in database 'imadb' contains no
rows. I_OP091C optimizedb: table 'ima_dmf_bm_configuration' in
database 'imadb' contains no rows. I_OP091C optimizedb: table
'ima_dmf_buffer_manager_stats' in database 'imadb' contains no rows.
I_OP091C optimizedb: table 'ima_gcb_info' in database 'imadb' contains
no rows. I_OP091C optimizedb: table 'ima_gcc_info' in database 'imadb'
contains no rows. I_OP091C optimizedb: table 'ima_gcn_info' in
database 'imadb' contains no rows. I_OP091C optimizedb: table
'ima_gcn_registrations' in database 'imadb' contains no rows. I_OP091C
optimizedb: table 'ima_qef_info' in database 'imadb' contains no rows.
I_OP091C optimizedb: table 'ima_qsf_dbp' in database 'imadb' contains
no rows. I_OP091C optimizedb: table 'remotecmd' in database 'imadb'
contains no rows.
Ingres Release II 3.0.1 (int.lnx/103) Server -- Normal Startup.
Nothing wrong. Maybe the "freeze" has something to do with
temperatures in Europe ...
Good luck,
Jürgen
-------- Original Message --------
[Info-ingres] Sigsegv on optimize of imadb
Mon, 18 Dec 2006 12:22:20 -0000
Hi Everyone,
I've just noticed that if I run optimizedb -zk -u'$ingres' imadb on
IngresII R3 or Ingres2006 I get a SIGSEGV at the front-end (and in the
errlog). At the front-end only I get: E_OP095B System or
hardware exception occurred in optimizer utility.
The optimizedb then freezes.
Has anyone else seen this behaviour?
Martin Bowes
_______________________________________________
Info-ingres mailing list
http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres
Loading...