Hi !
One of the gentoo users tried to use my ebuild for 7.5.0.23 to build
maxdb from sources. The build tools that where used where version
533920.
The system where Maxdb should be built on is a x86 with NTPL.
The build failed with the following errors:
...
Create gsp100.h first:
NOTE: NPTL s
05
>recover_replace auto_logF /data/backup/autoLOG_TESTDB.bak 006
>recover_start auto_logF LOG 006
>recover_replace auto_logF /data/backup/autoLOG_TESTDB.bak 007
>recover_start auto_logF LOG 007
>recover_replace auto_logF /data/backup/autoLOG_TESTDB.bak 008
>recover_start auto_logF
Hi,
dbmcli doesn't seem to write error message to STDERR but to STDOUT. I
wrote a cronjob to backup my database, and i'm not interested in the
whole output, but only in the error-messages if there are any. So i did
a redirected STDOUT to /dev/null. Having dbmcli print error-messages to
STDERR w
Heinrich, Tilo wrote:
hello tilo!
As was confirmed by a colleague, you should not worry about:
2005-01-27 16:44:37 18778 ERR 8 AdminERROR 'cancelled' CAUSED
EMERGENCY SHUTDOWN
That is the "normal" side effect of a recover_cancel in newer releases. So your script has to start the database a
Interesting enough, when un-commenting the _WIN32 part, the compile works
fine, however, the x_server is issuing errors...
> I would add such a change to the cvs server, but I'm afraid
> that even the smallest change to veo907.cpp will overwrite it
> again (the Perforce=>CVS mirroring always rep
Hello Raimund,
As was confirmed by a colleague, you should not worry about:
>2005-01-27 16:44:37 18778 ERR 8 AdminERROR 'cancelled' CAUSED
>EMERGENCY SHUTDOWN
That is the "normal" side effect of a recover_cancel in newer releases. So your
script has to start the database after every re
Dmitry wrote:
>
> I've tried to add records into the table three times. Two times
without
> logging and once with logging. All times I got the same result -
kernel
> crashing. As you mention above with logging I didn't loose data.
>
> What can I do to prevent craching?
>
Did I miss something?
W
Fabrice Bourdel wrote:
>
> > -Message d'origine-
> > De : Schroeder, Alexander [mailto:[EMAIL PROTECTED]
> > Envoyé : vendredi 28 janvier 2005 10:48
> > À : Fabrice Bourdel
> > Objet : RE: Performance problems ? witch parameter to change ?
> >
> >
> > Hello Fabrice,
> >
> > please tell how
On Friday 28 January 2005 15:19, [EMAIL PROTECTED] wrote:
> To confirm that you would like
>
> [EMAIL PROTECTED]
>
> removed from the maxdb mailing list, please click on
> the following link:
>
>
> http://lists.mysql.com/u/maxdb/41fa49f3b53f544a/hs4233=mail.mn-solution
>s.de
>
> This confirmati
Euke Castellano wrote:
> > I have the following table definition:
> >
> > CREATE TABLE "CONSUM"(
> >"ID" Integer NOT NULL,
> >"HOTEL" Integer NOT NULL,
> >"SERVICE" Integer NOT NULL,
> >"SEGMENT" Integer NOT NULL,
> >"GUEST" Integer,
> >"COMPANY" Fixed (38,0),
> >"AGENCY
/data/backup/autoLOG_TESTDB.bak 009
recover_start auto_logF LOG 009
recover_cancel
util_release
db_stop
db_start
The output I get is:
>recover_start auto_logF LOG 004
OK
Returncode 0
Date 20050128
Time 00094836
Server u25
Database TESTDB
Kernel Version Kernel 7.5.0 Build 018-123-079-776
Pa
We're just changing the type for processids to int8. This isn't quite completed
yet, though the code compiles with our compilers. I didn't get a date from the
developer when this will be fixed.
"veo907.cpp", line 725: Error: Overloading ambiguity between "teo42_RTE\
ReqRespVarPart::eo42_PutValu
> -Message d'origine-
> De : Schroeder, Alexander [mailto:[EMAIL PROTECTED]
> Envoyé : vendredi 28 janvier 2005 10:48
> À : Fabrice Bourdel
> Objet : RE: Performance problems ? witch parameter to change ?
>
>
> Hello Fabrice,
>
> please tell how you insert these lines (which interfaces, are
> -Message d'origine-
> De : Florian Schmitz [mailto:[EMAIL PROTECTED]
> Envoyé : vendredi 28 janvier 2005 10:11
> À : 'Fabrice Bourdel'; maxdb@lists.mysql.com
> Objet : AW: Performance problems ? witch parameter to change ?
>
>
> Hello Fabrice,
>
> for the Query-Problem, try doing a Stat
> -Message d'origine-
> De : Schroeder, Alexander [mailto:[EMAIL PROTECTED]
> Envoyé : vendredi 28 janvier 2005 10:48
> À : Fabrice Bourdel
> Objet : RE: Performance problems ? witch parameter to change ?
>
>
> Hello Fabrice,
>
> please tell how you insert these lines (which interfaces, are
I've tried to add records into the table three times. Two times without
logging and once with logging. All times I got the same result - kernel
crashing. As you mention above with logging I didn't loose data.
What can I do to prevent craching?
--
MaxDB Discussion Mailing List
For list archive
Euke Castellano wrote:
Hi all,
I have the following table definition:
CREATE TABLE "CONSUM"(
"ID" Integer NOT NULL,
"HOTEL" Integer NOT NULL,
"SERVICE" Integer NOT NULL,
"SEGMENT" Integer NOT NULL,
"GUEST" Integer,
"COMPANY" Fixed (38,0),
"AGENCY" Fixed (38,0),
"REPRESENTATI
Hi all,
I have the following table definition:
CREATE TABLE "CONSUM"(
"ID" Integer NOT NULL,
"HOTEL" Integer NOT NULL,
"SERVICE" Integer NOT NULL,
"SEGMENT" Integer NOT NULL,
"GUEST" Integer,
"COMPANY" Fixed (38,0),
"AGENCY" Fixed (38,0),
"REPRESENTATIVE" Fixed (38,0),
"I
> -Ursprüngliche Nachricht-
> Von: Dmitry [mailto:[EMAIL PROTECTED]
> Gesendet: Freitag, 28. Januar 2005 04:02
> An: Brunzema, Martin
> Betreff: Re: AW: Data lost in MaxDB 7.5.0.23
>
>
> Hello.
> There is no one error in knldiag.err.
> I attach this log.
> But there is some messages in
> Von: Michaël Fernandez wrote:
> I'm working on the usage of MaxDB in the RT System
> (http://bestpractical.com/rt/).
> I'm using MaxDB 7.0.5.19.
> I obtain really bad performances on some queries.
>
> This is the part of a query which is not well using indexes:
> SELECT main.id
> FROM Groups m
Hi,
I'm working on the usage of MaxDB in the RT System
(http://bestpractical.com/rt/).
I'm using MaxDB 7.0.5.19.
I obtain really bad performances on some queries.
This is the part of a query which is not well using indexes:
SELECT main.id
FROM Groups main, ACL ACL_1
WHERE ((ACL_1.PrincipalId = ma
Thomas Steinmaurer wrote:
>
> Hi,
>
> thanks a lot for your valueable comments!
>
> Do you also know whether MaxDB supports distributed transactions
across
> multiple databases (aka 2PC)?
No, this is not supported by MaxDB
Elke
SAP Labs Berlin
> If yes, is it XA compliant?
>
>
> Thanks,
>
Hello Fabrice,
for the Query-Problem, try doing a Statistics Update in DBMGui via Tuning ->
Optimizer Statistics and set the sample value to 50%.
This should eliminate the table scan.
If it doesn't help send an explain-output of the query (explain select
blahblah).
for the insertion-problem : i'm
Hi,
thanks a lot for your valueable comments!
Do you also know whether MaxDB supports distributed transactions across
multiple databases (aka 2PC)? If yes, is it XA compliant?
Thanks,
Thomas
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:http:/
Hello Robert,
> 1. Is there a way to specify the location of a table or an
> index on to a
> specific volume or set of volumes ( akin a tablespace)?
Not with MaxDB, as tables are usually distributed among the available
data volumes to get most I/O performance. This of course makes more sense
if
25 matches
Mail list logo
