Seit dieser Nacht kommt es geh�uft zu unten gezeigten Fehlern. Danach startet der Dienst neu. Allerdings sind gewisse Abfragen danach sehr langsam. Nur ein Komplettes neustarten des Servers bringt kurzzeitig Besserung.
Was kann das sein? Ich verzweifel hier... *Dump thread - spid = 55, PSS = 0x2da0b248, EC = 0x2e46a098 *Stack Dump being sent to d:\Microsoft SQL Server\daten\MSSQL\log\SQLDump0029.txt * **************************************************************************** *** * * BEGIN STACK DUMP: * 02/25/03 09:44:57 spid 55 * * StackDump (all) * * Input Buffer 1352 bytes - * SELECT Artikel.id as id ,artikel.verkaufspreis FROM Kaeufer INNER JOIN A * rtikel ON Kaeufer.ID = Artikel.KaeuferID where Artikel.verkaeufer = 789 * and (1=2 or ebayname like '%3207800762%' or EbayEmail like '%3207800762% * ' or Vorname like '%3207800762%' or Nachname like '%3207800762%' or PLZ * like '%3207800762%' or Firma like '%3207800762%' or Ort like '%320780076 * 2%' or str(Artikelnummer) like '%3207800762%' or Wunschzahlart like '%32 * 07800762%' or Artikelbeschreibung like '%3207800762%' or Versand like '% * 3207800762%' or memo like '%3207800762%' or zinfo like '%3207800762%' or * history like '%3207800762%' ) and Bezahlt is null and ausblenden = 0 OR * DER BY EndeDerAuktion DESC ; * * * Edi: 00000774: * Esi: 7788377B: 0000EAB8 24548D00 C22ECD04 1CB8000C 8D000000 CD042454 * Eax: 00423857: D96CEC83 2CA164E8 53000000 D9D05DDD 56008BE8 DDC85DDD * Ebx: 00000000: * Ecx: 2E45DD30: 0098E06C 2E45DFF0 00016002 00000000 00000000 00000000 * Edx: 00000000: * Eip: 77883786: B8000CC2 0000001C 0424548D FAE92ECD B8000169 000000D4 * Ebp: 061EFA1C: 061EFA5C 410749AC 00000774 FFFFFFFF 00000001 00BD6640 * SegCs: 0000001B: * EFlags: 00000246: * Esp: 061EF9F8: 77E99B35 00000774 00000001 00000000 77E99AC4 03783CF0 * SegSs: 00000023: * **************************************************************************** *** * -------------------------------------------------------------------------- ----- * Short Stack Dump * 77883786 Module(ntdll+00003786) (NtWaitForSingleObject+0000000B) * 410749AC Module(UMS+000049AC) (UmsThreadScheduler::Switch+0000004C) * 41072495 Module(UMS+00002495) (UmsScheduler::IdleLoop+00000105) * 410721D6 Module(UMS+000021D6) (UmsScheduler::Suspend+00000066) * 41072D1E Module(UMS+00002D1E) (UmsEvent::Wait+0000008E) * 00401202 Module(sqlservr+00001202) (ExecutionContext::WaitForSignal+000001B5) * 0040DDDE Module(sqlservr+0000DDDE) (upwait0+0000017C) * 006FE2A3 Module(sqlservr+002FE2A3) (XchngWait+00000100) * 00702925 Module(sqlservr+00302925) (CXPort::Open+000000C0) * 006FBD72 Module(sqlservr+002FBD72) (CQScanExchange::Open+00000029) * 00425C9D Module(sqlservr+00025C9D) (CQScan::Open+0000001C) * 00430B79 Module(sqlservr+00030B79) (CQScanHashMatch::Iterate+00000821) * 004334AB Module(sqlservr+000334AB) (CQScanHashMatch::Open+00000065) * 00425C9D Module(sqlservr+00025C9D) (CQScan::Open+0000001C) * 00425CBE Module(sqlservr+00025CBE) (CQScanRowset::Open+00000015) * 006E20AD Module(sqlservr+002E20AD) (CQScanPreFetchDelay::Open+0000000E) * 00425C9D Module(sqlservr+00025C9D) (CQScan::Open+0000001C) * 00425CBE Module(sqlservr+00025CBE) (CQScanRowset::Open+00000015) * 00425C9D Module(sqlservr+00025C9D) (CQScan::Open+0000001C) * 004FAABE Module(sqlservr+000FAABE) (CQScanSort::BuildSortTable+00000021) * 004FAA94 Module(sqlservr+000FAA94) (CQScanSort::Open+00000032) * 00425C9D Module(sqlservr+00025C9D) (CQScan::Open+0000001C) * 00425CBE Module(sqlservr+00025CBE) (CQScanRowset::Open+00000015) * 0043BB74 Module(sqlservr+0003BB74) (CQScanRangePrefetchDelay::Open+0000000E) * 0042E6EB Module(sqlservr+0002E6EB) (CQScanNLJoin::Open+00000014) * 00425C9D Module(sqlservr+00025C9D) (CQScan::Open+0000001C) * 00425CBE Module(sqlservr+00025CBE) (CQScanRowset::Open+00000015) * 006E20AD Module(sqlservr+002E20AD) (CQScanPreFetchDelay::Open+0000000E) * 00425C9D Module(sqlservr+00025C9D) (CQScan::Open+0000001C) * 00425CBE Module(sqlservr+00025CBE) (CQScanRowset::Open+00000015) * 00425C9D Module(sqlservr+00025C9D) (CQScan::Open+0000001C) * 004FAABE Module(sqlservr+000FAABE) (CQScanSort::BuildSortTable+00000021) * 004FAA94 Module(sqlservr+000FAA94) (CQScanSort::Open+00000032) * 00425C9D Module(sqlservr+00025C9D) (CQScan::Open+0000001C) * 006FCA14 Module(sqlservr+002FCA14) (CQScanXProducer::Open+00000041) * 006FC656 Module(sqlservr+002FC656) (FnProducerThread+0000020E) * 0051274C Module(sqlservr+0011274C) (subproc_main+000000C2) * 41075002 Module(UMS+00005002) (ProcessWorkRequests+00000272) * 41074698 Module(UMS+00004698) (ThreadStartRoutine+00000098) * 7800C9EB Module(MSVCRT+0000C9EB) (beginthread+000000CE) * 00401A59 Module(sqlservr+00001A59) (CMemObj::Free+00000028) * -------------------------------------------------------------------------- ----- ***Unable to get thread context for spid 56 ***Unable to get thread context for spid 57 ***Unable to get thread context for spid 58 ***Unable to get thread context for spid 59 ***Unable to get thread context for spid 60 ***Unable to get thread context for spid 64 2003-02-25 09:44:58.62 server Stack Signature for the dump is 0x5AA04B9E 2003-02-25 09:44:58.64 server SQL Server wird abgebrochen. Schwere Ausnahmebedingung c000001d aufgetreten. ~~~~~~~~~~~~~~~~~~~~~~~~~~~sponsored by United Planet~~~~~~~~~~~~~~~~~ Intrexx.BizWalker + ODBC/OLEDB-Daten = ASP-Formular ATTACK! Download Intrexx CRM-Studio Now! http://www.intrexx.com _______________________________________________ Database.asp mailing list [EMAIL PROTECTED] http://www.glengamoi.com/mailman/listinfo/database.asp
