ERROR 1030 (HY000): Got error 1 from storage engine when using select distinct

ERROR 1030 (HY000): Got error 1 from storage engine when using select distinct

Post by Jerry Stuc » Wed, 05 Nov 2008 22:56:24

Not enough information to help. What storage engine are you using?
What's your query? What's your table layout? What version of MySQL?
What's in your MySQL error log? What happened before this started

Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.

1. Now UC it, now U don't; getting error 1030

2. 1030 and 40961 errors plus Kerberos error when running DCDiag

Ok Gang:

I get the following two errors about every hour and a half on my
Windows Server 2003 Enterprise Edidtion machine. It is a member server
in a domain in which the two DCs are Windows Server 2000 machines. One
of them also runs Exchange 2003, which necesitated an Active Directory
update to 2003 standards as part of the Exchange upgrade from Exchange

As part of the troubleshooting suggestions from other posts I have run
Everything checks out except the Kerberos test, which comes up as
Failed. [FATAL] Kerberos does not have a ticket for


Greg Wallach

Event Type: Warning
Event Source: LSASRV
Event Category: SPNEGO (Negotiator)
Event ID: 40961
Date: 4/12/2005
Time: 6:27:12 PM
User: N/A
Computer: GERGAW
The Security System could not establish a secured connection with the
server ldap/ XXXX@XXXXX.COM . No
authentication protocol was available.

For more information, see Help and Support Center at
0000: 03 03 09 80 ...?

Event Type: Error
Event Source: Userenv
Event Category: None
Event ID: 1030
Date: 4/12/2005
Time: 6:27:12 PM
User: IO-MEDIA\gregwallach
Computer: GERGAW
Windows cannot query for the list of Group Policy objects. Check the
event log for possible messages previously logged by the policy engine
that describes the reason for this.

For more information, see Help and Support Center at

3. error 1030 - no another errors

4. Errors in OLAP storage engine: An error occured while ....

5. .NET TransactionScope -> ERROR [HY000] [Informix][Informix ODBC Driver]General error

6. ERROR [HY000] [Informix][Informix ODBC Driver]General error

7. Select DISTINCT...won't select DISTINCT

8. uses select statement with both distinct and not distinct

9. Invalid Parameter / HY000 Error using MSSQL and Integer param

10. 1058 and 1030 errors, 1 machine

11. constant USERENV 1030 errors

12. Error 1058 and 1030 in Application Log

13. I can't aply group policy; event id error: 1095, 1058 and 1030

14. Userenv 1030 and 1058 errors every 5 minutes

15. application error 1030