[Info-Ingres] Stack dump on auditdb - good host vs bad host

DATABASE

    Sponsored Links

    Next

  • 1. Exclusive Readlock on Record....
    Hi Group, Can I take exclusive read lock on a record of the table in Ingres? I have a table with two columns "table_name" and "id". This table is used to generate autogenerated keys for other tables in database. This is static table with fill factor set to low value to have one record per page. To avoid duplicate key generation, I want to read a record in this table with exclusive lock on it. But I couldn't succeed with "readlock = exclusive" as it locks the entire table and not the particular page or record. I tried with "readlock = exclusive, level = page" but this won't have any effect as still I'm able to read the same record from multiple sessions. How to read single record exclusively without locking the entire table? Any help would be appreciated. Thanks in advance, Regards, Unmesh Deshpande
  • 2. Error E_US0ADB in Ingres 2.6 sp2
    Hi, We applied service pack 2 for Ingres 2.6. We got the following error on a copy statement that previously worked. E_US0ADB No value specified for mandatory column 'selectionnumber'. (Thu Aug 14 15:05:14 2003) The problem column is not included in the copy statement and is 'not null not default'. The documentation for the service pack 2 patch states; INGSRV1981 (Generic) The "COPY TABLE table_name ( column_name=... ) FROM ..." SQL command doesn't assign the appropriate default value, or enforce NOT NULL NOT DEFAULT, for column names not specified in the command. Is this an unnecessary change in the behaviour of the copy statement or did we get what we deserve for our use of the copy statement? Any views? thanks, James Keane Irish Revenue ***************************** This message has been delivered to the internet by the Revenue internet mail service. *****************************

[Info-Ingres] Stack dump on auditdb - good host vs bad host

Postby Martin Bowes » Thu, 27 Sep 2007 19:20:15 GMT

Hi Everyone,

I have two hosts, both running: II 9.0.4 (a64.lnx/105)NPTL + patch 12343
                  both running: Fedora Core release 5 (Bordeaux)

If I create a brand new database(call it bowtest).
Checkpoint it turning journaling on.
Then execute: auditdb bowtest -b`date +%d-%b-%Y` (ie. Today it will
give: auditdb bowtest -b26-Sep-2007)

One host is perfectly OK with this command. 

The other generates the frontend error: 
Wed Sep 26 10:53:02 2007 E_DM904A_FATAL_EXCEPTION       A fatal error
has occurred in the DMF Facility.

And in the errlog we see a STACK TRACE message:
::[                , ac874200]: Wed Sep 26 10:53:02 2007 Segmentation
Violation (SIGSEGV) @PC 00002aaaaadc5352
RSP 00007fff37b6b120  RBP 00007fff37b6b2a8  RSI 00002aaaac6d70b0
RDI 00000000005341c0  RAX 00000000005de000  RBX 0000000000000000
RCX 0000000000548000  RDX 00007fff00000000

-----------BEGIN STACK TRACE------------
0: 00007fff37b6b2a8 libscf.1.so(sca_add_datatypes+0x312)
[0x2aaaaadc5352](0000000046fa2bfe 00002aaaaac6a8df 000000000050f533
0000000000000000)
-----------END STACK TRACE----------

I've checked the libscf.so.1 on both hosts with both a simple ls and sum
-r and they are identical.
The LD_LIBRARY_PATH is the same on both hosts.

On the bad host if I do auditdb '#c1' bowtest the output is OK!

The problem also occurs on all the existing databases in the bad host as
well. It also occurs on a secondary installation I put on the bad host.

Anyone got any ideas?

Martin Bowes
Random Farscape Quote #3:
John - If this is part of some sick experiment, I'm going to bill them
for
       the therapy.




Re: [Info-Ingres] Stack dump on auditdb - good host vs bad host

Postby Paul Mason » Thu, 27 Sep 2007 19:50:21 GMT

Hi Marty,

It's crashing in sca_add_datatypes - which is the routine that registers
UDTs. Is 'bad host' using a UDT and 'good host' not? If so, how well-tested
is the UDT?

-- 
Paul Mason

<br>Hi Marty,<br><br>It's crashing in sca_add_datatypes - which is the routine that registers UDTs. Is 'bad host' using a UDT and 'good host' not? If so, how well-tested is the UDT? <br clear="all"><br>
-- <br>Paul Mason


Re: [Info-Ingres] Stack dump on auditdb - good host vs bad host

Postby Martin Bowes » Thu, 27 Sep 2007 20:36:40 GMT

his is a multi-part message in MIME format.

Hi Guys,



Spot on! As soon as I added the user defined functions to a good host
running Ingres2006 the problem with auditdb came with it. When I added
them to a host running IngresII 2.6 the auditdb problem did not surface.




BTW. When I start the installation the errlog shows:

Adding 22. new datatype entries,

0. new datatypes,

9. new operators,

and 13. new function instances.



So there are no UDT's - quite frankly they scare me, although lately
I've been toying with the idea of Polar Co-ordinates and spherical
trigonometry functions as an example case...



My OME function code does...

static IIADD_DEFINITION register_block = {

....lots O'stuff...

0, /* add_dt_cnt */

(IIADD_DT_DFN *) 0, /* add_dt_dfn */

...etc...

};



Marty

From: XXXX@XXXXX.COM
[mailto: XXXX@XXXXX.COM ] On Behalf Of Paul
Mason
Sent: 26 September 2007 11:50
To: XXXX@XXXXX.COM
Subject: Re: [Info-Ingres] Stack dump on auditdb - good host vs bad host




Hi Marty,

It's crashing in sca_add_datatypes - which is the routine that registers
UDTs. Is 'bad host' using a UDT and 'good host' not? If so, how
well-tested is the UDT?

--
Paul Mason


<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
..MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>

<body lang=EN-GB link=blue vlink=purple>

<div class=Section1>

<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Hi Guys,<o:p></o:p></span></p>

<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D

Re: [Info-Ingres] Stack dump on auditdb - good host vs bad host

Postby Karl & Betty Schendel » Thu, 27 Sep 2007 21:43:51 GMT




That's a bug in dmfinit (single-threaded DMF initialization) that
shows up on a64, it's passing 0 instead of NULL to sca_add_datatypes
(which it is illegally calling directly!).  If you fix that, you
discover that NULL is improperly defined on a64_lnx as well.
(as (i4)0 instead of (void *)0, although it turns out that most
of Ingres manages to pick up a correct override definition from
stddef.h.

I sent over a fix for that, but I don't believe it's made it into the
regular code lines yet.

If you don't try to initialize any UDF's or UDT's, I think it
works fine.

Karl

PS I bet you can blow up infodb the same way, that's how I
found it.  Any of the standalone DMF programs should barf.

Re: [Info-Ingres] Stack dump on auditdb - good host vs bad host

Postby Richard Tyler-Jones » Thu, 27 Sep 2007 22:56:46 GMT




Marty

If you are going to do those, a little more effort could lead to
space/time co-ordinates and warp factors. For those programmers
and DBAs working extra-terrestrially they would be very useful.

Just a suggestion ;-)

All the best
Richard

Dr Richard Tyler-Jones
Information Services
The University of Nottingham
Nottingham
UK

tel:   +44 115 95 13340
fax:   +44 115 95 13358
email:  XXXX@XXXXX.COM 

This message has been checked for viruses but the contents of an attachment
may still contain software viruses, which could damage your computer system:
you are advised to perform your own checks. Email communications with the
University of Nottingham may be monitored as permitted by UK legislation.


Re: [Info-Ingres] Stack dump on auditdb - good host vs bad host

Postby Martin Bowes » Fri, 28 Sep 2007 18:29:21 GMT

> > So there are no UDT's - quite frankly they scare me, although lately


And a brilliant suggestion it is too!

Although I have to confess that the stupidest prop I have ever seen used
as an astro-navigation tool on a Science Fiction Program was a Sextant
in an episode of 'Deep Space 9'. It would be hard to top that.

Now I have to go and do a Captains Log...

Marty
Random Farscape Quote #18:
Aeryn - Its my turn, this is my plan!
John  - Thats your plan! Wile. E. Coyote comes up with better plans than
that.


Re: [Info-Ingres] Stack dump on auditdb - good host vs bad host

Postby Martin Bowes » Fri, 28 Sep 2007 18:38:16 GMT

Hi Karl,

Now that makes sense! But why it only comes out when I use the -b/-e
flags I'll probably never know!

FYI. No problems on infodb.

However, I've also just come across a new problem which is also specific
to installations on which I've installed OME functions. You'll like this
one...
If I create two procedures in sequence and the first one has a minor
syntactic error, then the second - syntactically correct - procedure
will produce errors like:
E_OP08A2_EXCEPTION   Unexpected exception occurred within query
compilation
and a stack dump in the errlog

OR

E_OP0886_QSF_PALLOC    Error calling QSF to allocate a piece of memory.
And either:
+ E_QS0001 QSF dynamic memory pool is exhausted.
+ E_QS0018 Request for an illegal piece size.  Size must be a positive
number of bytes

Isn't that Cool!

Marty
-----Original Message-----
From:  XXXX@XXXXX.COM 
[mailto: XXXX@XXXXX.COM ] On Behalf Of Karl
& Betty Schendel
Sent: 26 September 2007 13:44
To:  XXXX@XXXXX.COM 
Subject: Re: [Info-Ingres] Stack dump on auditdb - good host vs bad host



12343


That's a bug in dmfinit (single-threaded DMF initialization) that
shows up on a64, it's passing 0 instead of NULL to sca_add_datatypes
(which it is illegally calling directly!).  If you fix that, you
discover that NULL is improperly defined on a64_lnx as well.
(as (i4)0 instead of (void *)0, although it turns out that most
of Ingres manages to pick up a correct override definition from
stddef.h.

I sent over a fix for that, but I don't believe it's made it into the
regular code lines yet.

If you don't try to initialize any UDF's or UDT's, I think it
works fine.

Karl

PS I bet you can blow up infodb the same way, that's how I
found it.  Any of the standalone DMF programs should barf.
_______________________________________________
Info-Ingres mailing list
 XXXX@XXXXX.COM 
 http://www.**--****.com/ 


Similar Threads:

1."local hosts" is empty; must use "Specify Hosts"

We had a slight network meltdown this morning, from which we have
recovered 99%. The only issue is that users are having trouble logging
onto FileMaker Server.

We're running FMS 5.0 on Windows Server 2003. Clients are running FMP
6.0 on both Macs and PCs. Prior to the "meltdown," users are not able
to access the server by going through Open > Hosts > Local Hosts. The
Local Hosts screen is blank. However, if we add the local IP address
under "Specify Hosts," everything shows up fine.

I realize this might be more of a networking issue than a FileMaker
issue, but I'm not sure how to fix it.

Our network is very simple. Everyone's on the same subnet. The router
assigns DHCP to clients. DNS is controlled by our Small Business
Server.

Other services running on the Windows Server/FileMaker Server are
accessible (file sharing and printing).

Can anyone point me in the right direction on this?

Thanks.
eric

2.Host not displayed in local host section...

Our filemaker server used to be listed in the hosts dialog in the local
hosts section.
Then I messed about with some network cables to get our macs working on
the network better.

Somehow everyone got disconnected - not sure how as I didn't go near
any of the PC workstations network cables.

Now I have to manually specify the IP address of our filemaker server
to get it to show in the hosts box.

Anyone know what I've done and how I can sort it out?

Thanks

Ben

3.Deleting hosts FileMaker server host IPs.

Is it possible to delete FileMaker server host IP addresses in the
FileMaker client software that are no longer being used?
Which file has these settings?

4.[Info-ingres] Programming against multiple ingres installations on the same unix host

Hi Guys,
        We are thinking about perhaps installing two Ingres installations on the same unix host  (with different system id's).  Is it possible to write an ESQL C program that connects to databases in both installations at the same time?

Could I setup a VNODE in one installation that points to the other installation on the same host?

Or could I fork my C process and programmatically change II_SYSTEM and connect to the other installation and somehow send the query results back to my parent process? 

Any thoughts would be welcome.   

Thanks,

Michael

5.[Info-Ingres] bad procedure screws good procedure

6. [Info-Ingres] "Bad page" which isn't bad

7. [Info-ingres] auditdb report

8. rollforwarddb vs auditdb and replicator



Return to DATABASE

 

Who is online

Users browsing this forum: No registered users and 92 guest