-----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/[EMAIL PROTECTED]
