-----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?
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/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx
|
