Ken Snider wrote: > > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Running Linux x86 RPM's. > > Intermittently, we'll see the following error when using a > stored procedure > within the database. The error is: > > 2004-02-26 16:13:58 7617 ERR 51080 SYSERROR -9999 Otherwise > unknown errorcode > > No other queries are running against the database at the time. > > The SQL that (intermittently!) causes the error is: > > SELECT num(substr(char(TimeKey_DateTimeGMT,INTERNAL),1,10) & > LFILL(TimeKey_FiveMinuteGMT,'0',2) ) TIMEKEY, > ~ NODEKEY,TxnTypeKey, > ~ count(*) TxnCount > ,sum(Duration),min(duration),max(duration), > ~ sum(HostDuration),min(HostDuration),max(HostDuration), > ~ sum(Duration - HostDuration),min(Duration - > HostDuration),max(Duration - HostDuration) > ~ FROM DWBUILD.DWDailyTraffic > ~ GROUP BY num(substr(char(TimeKey_DateTimeGMT,INTERNAL),1,10) & > LFILL(TimeKey_FiveMinuteGMT,'0',2) ), > ~ NODEKEY,TxnTypeKey; > > Any insight provided by the error number?
Unfortunately not. What I would like to see is - the table definition - the date_and_time_format used when calling the stored procedure (which tool/client do you use?) - the kernel version. Are we speaking of 7.5.00.xy (which xy?) - the vtrace according to http://sapdb.2scale.net/moin.cgi/VTrace - the problem is reproducable or depends on time-/multi-user-effects? Elke SAP Labs Berlin > > Also, any progress toward a 7.5.00.08+ release in RPM Format? > I'd like to see > if this problem exists under the stable release. > > - -- > Ken Snider > > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.2.3 (GNU/Linux) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org > > iD8DBQFAPmnVJz/2kL0fCRgRAgkgAJ9tkBqabJvg3KXWNvDk9vqUsSDAZACeJiD0 > lQm14jK6XZAgY8UFy4CF3F8= > =NiWa > -----END PGP SIGNATURE----- > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
