| Title: | DECmcc user notes file. Does not replace IPMT. |
| Notice: | Use IPMT for problems. Newsletter location in note 6187 |
| Moderator: | TAEC::BEROUD |
| Created: | Mon Aug 21 1989 |
| Last Modified: | Wed Jun 04 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 6497 |
| Total number of notes: | 27359 |
I have SQL (SQL200.tar) installed on my ULTRIX system.
I started all ingres background jobs and the exporter background
process.
Show_exporting reveals that:
Exporting state ACTIVE
Export target mcc_export_rdb
Export period +0-00:15:00.0000I----
Requested by root
Number of successful polls 1
However, polling does not proceed. My export seems completely dead.
IS THERE ANYTHING I CAN DO TO INVESTIGATE FURTHER.
Dominique.
Additional info:
In fact to my knowledge and in contrast with what show_exporting says,
no data exported has been exported, but only the
information structure of my hdlc entity has been exported into the sql
database.
With
sql> help table mcc_node_hdlc_link_1
I see that mcc has written this into the db.
mgkk01> ps -auwx | grep ii
ingres 8861 0.0 3.9 4564 2124 p0 S 0:01 iidbms II 1767
ingres 8879 0.0 0.2 312 124 p0 I 0:00 iislave 1 0 2 1 @@@@@@@@@@@@@@ @@
ingres 8829 0.0 0.6 360 296 p0 S 0:00 iigcn II
ingres 8878 0.0 0.2 312 124 p0 I 0:00 iislave 1 0 2 0 @@@@@@@@@@@@@@ @@
root 9724 0.0 0.1 40 32 p4 S 0:00 grep ii
mgkk01> ps -auwx | grep exp
root 8880 0.0 4.0 2860 2188 p0 S 0:31
/usr/mcc/mmexe/mcc_exporter_fm_bg mcc_export_rdb
root 8881 0.0 1.8 2432 968 p0 S 0:00
mcc_exporter_fm_writer
d e
root 8890 0.0 3.4 2588 1856 ? S 0:23 mcc_exporter_fm 8 N
root 9722 0.0 0.1 40 32 p4 S 0:00 grep exp
isql> help *
Name: mcc_node_hdlc_link_1
Owner: root
Created: 13-may-1993 11:45:00
Type: user table
Version: ING6.0
Column Information:
Key
Column Name Type Length Nulls Defaults Seq
node char 512 yes no
link char 255 yes no
time_stamp date yes no
mcc_export_sequence char 132 yes no
mcc_export_sequen_numbe integer 4 yes no
time_identifiers date yes no
mcc_export_poll_status integer 4 yes no
exp_export_time date yes no
...
and also for
Name: mcc_node_hdlc_link_13
Name: mcc_node_hdlc_link_2
Name: mcc_node_hdlc_link_3
Name: mcc_node_hdlc_link_4
Name: mcc_node_hdlc_link_5
select * from mcc_node_hdlc_link_1
node
(0 rows)
End of Request
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 5056.1 | TOOK::SHMUYLOVICH | Thu May 13 1993 10:09 | 12 | ||
Dominique,
Did Show Exporting ever tell you that "number of successful polls" is
more that one?
Did you try to export an entity of another class?
Sorry, today we are moving to another location so we will not be able
to help you in the next couple of days.
Sam
| |||||
| 5056.2 | Also for different global entities ... | KETJE::PACCO | Gallia divisa est in partes tres | Thu May 13 1993 11:16 | 10 |
Sam,
The "number of successful polls" never has been more than 1.
I also tried on another (sub)entity from another global entity class,
but exactly the same behaviour.
The number of failed polls remains 0, also for the export failures.
The last export time is about the one of the originating request.
Dominique.
| |||||
| 5056.3 | TOOK::SHMUYLOVICH | Thu May 13 1993 12:41 | 11 | ||
Dominique,
It looks like the the exporter writer process is blocked when it
tries to write into data base.
Do you have an interactive SQL running and accessing the same table
as used by the Exporter? As far as I remember it could be an access
conflict.
Sam
| |||||
| 5056.4 | The exporter was the only process. | KETJE::PACCO | Gallia divisa est in partes tres | Fri May 14 1993 05:27 | 10 |
SAM,
At the time I am running the exporter, nothing else was running
with INGRES. If it is an access conflict, it must have to do with
ACL's, file protection or alike. But DECmcc runs under "root". This
makes impossible access very unlikely.
If I can manage it, I'll try to write into the database from isql.
Dominique.
| |||||
| 5056.5 | Write access from isql. | KETJE::PACCO | Gallia divisa est in partes tres | Fri May 14 1993 08:32 | 3 |
With isql, I can load a table from a file without problem.
Dominique
| |||||
| 5056.6 | Anybody else help...pls. | PLUNDR::LOWEG | You don't want to do it like that!! | Tue May 25 1993 06:43 | 15 |
Sam, have you any other thoughts on what could be causing Dominique's
problem.
My involvement is that Dominique's colleague (Danny Goovaerts) has
logged a call with me at the North UK CSC.
I have no knowledge on any known exporting problems, so I am attempting
to reproduce the problem to assist in my troubleshooting efforts. This
might take several hours to set up, so if anybody else has experienced
exporting problems can you supply brief details to give us pointers of
what could be wrong.
Gary Lowe NUK CSC comms..
PS. Danny if you read this before I get through I am trying to ring
you.
| |||||
| 5056.7 | So far.. | PLUNDR::LOWEG | You don't want to do it like that!! | Fri May 28 1993 12:10 | 21 |
Danny, I have spent most of the day trying to work out why nothing is
produced from the export.
Unfortunately I am drawing the same blanks as you are.
As you are more familiar with the site can you try running exporter on
a Phasev NODE rather than the decnis.
Our only other hope is that somebody knowledgeable in Ingres might
notice that we have missed something out..
I have a detailed report of what I have done so far but I would like
to see if we can get exporting working on a different entity..
Gary Lowe NUK CSC comms..
PS. Has nobody ever used exporting and ingres ?? If there is any chance
of some help on this..
| |||||
| 5056.8 | TOOK::SHMUYLOVICH | Fri May 28 1993 13:52 | 18 | ||
Gary,
Exporter and Ingres should work together.
Can you try to export a node4 entity? I just want to understand where the
problem is: in MCC or Ingres.
Also I would recommend the following:
1. to use another database name , not a mcc_export_rdb;
2. to run a Exporter background process not as a "background" but
from a different window;
3. to create only one exporting request.
Please, send me (TOOK::SHMUYLOVICH) the result of the above experiment.
BTW, what versions of MCC and Ingres are used in .0?
SAm
| |||||
| 5056.9 | Going in the right direction. | PLUNDR::LOWEG | You don't want to do it like that!! | Tue Jun 01 1993 05:23 | 11 |
Thanks Sam,
I have asked Dominique to carry out your action plan and feed the
results back to you.. T
DECmcc V1.3.0
ULTRIX/SQL Version 2.0
Gary Lowe NUK CSC comms..
| |||||