Seite 1 von 5 123 ... LetzteLetzte
Ergebnis 1 bis 10 von 50

Thema: Vista - immer mehr postgres.exe im Taskmanager

  1. #1
    treFFnix ist offline Benutzer
    Registriert seit
    25.03.2010
    Beiträge
    68

    Frage Vista - immer mehr postgres.exe im Taskmanager

    Hallo,

    Ich nutze die Version 'postgresql-8.4.4-1-windows.exe' von PostgreSQL
    Windows Vista 32Bit Home Premium SP2
    Intel Core 2Duo CPU 2.00GHZ
    mit 4GM RAM.

    PostgreSQL wird bei mir genutzt um Fertigungsdaten in eine Datenbank zu schreiben.
    Dabei fällt mir immer wieder auf, dass ich mich irgendwann, nach einigen Stunden Arbeit mit der Datenbank, nicht mehr über PGAdmin III auf meinen lokalen Server verbinden kann. --> Ein Blick in den Taskmanager verrt mir immer, dass es über 100 laufende PRozesse 'postgres.exe' gibt.
    Jedes mal kommt max_connections ans Limit...

    Gestern habe ich mal einen Test gemacht und möchte euch die Ergebnisse hier mitteilen:

    Ich habe ein (AutoIt-)Tool geschrieben, welches mir eine Prozess-Liste mit PIDs von einem Bestimmten Prozess erstellt.
    AutoIt-Code:
    Code:
    HotKeySet("{ESC}","ende")
    
    Func ende()
        Exit
    EndFunc
    
    Global $pid
    Global $string
    Global $i = 1
    
    While 1
        $string = ""
        $pid = ProcessList ("postgres.exe")
        For $i = 1 To $pid[0][0]
            $string = $string & $pid[$i][1] & ","
        Next
        $string = StringTrimRight($string, 1)
        FileWriteLine(@ScriptDir & "\pid.txt", @YEAR & "-" & @MON & "-" & @MDAY & " " & @HOUR & ":" & @MIN & ":" & @SEC & ": " & $string )
        Sleep(120000)
    WEnd
    Dieses Tool Schreibt alle 2 Minuten eine Zeile mit allen PIDs vom Prozess "postgres.exe" in eine Textdatei.

  2. #2
    treFFnix ist offline Benutzer
    Registriert seit
    25.03.2010
    Beiträge
    68

    Standard

    So sah das Textfile gestern während der Arbeit aus:
    [CODE]2010-07-06 16:07:46: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620
    2010-07-06 16:09:46: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596
    2010-07-06 16:11:46: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316
    2010-07-06 16:13:46: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396
    2010-07-06 16:15:46: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396
    2010-07-06 16:17:46: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396
    2010-07-06 16:19:46: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680
    2010-07-06 16:21:46: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680
    2010-07-06 16:23:46: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680
    2010-07-06 16:25:46: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680
    2010-07-06 16:27:46: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680
    2010-07-06 16:29:46: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424
    2010-07-06 16:31:46: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424
    2010-07-06 16:33:46: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424
    2010-07-06 16:35:46: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424
    2010-07-06 16:37:46: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424
    2010-07-06 16:39:46: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224
    2010-07-06 16:41:46: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224
    2010-07-06 16:43:46: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224
    2010-07-06 16:45:46: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224
    2010-07-06 16:47:46: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224
    2010-07-06 16:49:46: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856
    2010-07-06 16:51:46: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856
    2010-07-06 16:53:46: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856
    2010-07-06 16:55:46: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856
    2010-07-06 16:57:46: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964
    2010-07-06 16:59:46: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964
    2010-07-06 17:01:46: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964
    2010-07-06 17:03:46: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964
    2010-07-06 17:05:46: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964
    2010-07-06 17:07:46: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964
    2010-07-06 17:09:46: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964
    2010-07-06 17:11:46: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964
    2010-07-06 17:13:46: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964
    2010-07-06 17:15:46: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964
    2010-07-06 17:17:46: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964
    2010-07-06 17:19:46: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640
    2010-07-06 17:21:46: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684
    2010-07-06 17:23:46: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684
    2010-07-06 17:25:46: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684
    2010-07-06 17:27:46: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684
    2010-07-06 17:29:46: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684
    2010-07-06 17:31:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684

  3. #3
    treFFnix ist offline Benutzer
    Registriert seit
    25.03.2010
    Beiträge
    68

    Standard

    2010-07-06 17:33:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684,5588
    2010-07-06 17:35:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684,5588
    2010-07-06 17:37:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684,5588
    2010-07-06 17:39:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684,5588
    2010-07-06 17:41:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684,5588
    2010-07-06 17:43:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684,5588,3324
    2010-07-06 17:45:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684,5588,3324
    2010-07-06 17:47:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684,5588,3324,1868
    2010-07-06 17:49:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684,5588,3324,1868
    2010-07-06 17:51:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684,5588,3324,1868
    2010-07-06 17:53:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684,5588,3324,1868
    2010-07-06 17:55:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684,5588,3324,1868
    2010-07-06 17:57:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684,5588,3324,1868
    2010-07-06 17:59:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684,5588,3324,1868
    2010-07-06 18:01:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684,5588,3324,1868,2684
    2010-07-06 18:03:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684,5588,3324,1868,2684
    2010-07-06 18:05:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684,5588,3324,1868,2684
    2010-07-06 18:07:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684,5588,3324,1868,2684,4820,5848
    2010-07-06 18:09:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684,5588,3324,1868,2684,4820,5848
    2010-07-06 18:11:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684,5588,3324,1868,2684,4820,5848
    2010-07-06 18:13:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684,5588,3324,1868,2684,4820,5848
    2010-07-06 18:15:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684,5588,3324,1868,2684,4820,5848
    2010-07-06 18:17:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684,5588,3324,1868,2684,4820,5848
    2010-07-06 18:19:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684,5588,3324,1868,2684,4820,5848
    2010-07-06 18:21:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684,5588,3324,1868,2684,4820,5848,5416,5676
    2010-07-06 18:23:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684,5588,3324,1868,2684,4820,5848,5416,5676
    2010-07-06 18:25:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684,5588,3324,1868,2684,4820,5848,5416,5676
    2010-07-06 18:27:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684,5588,3324,1868,2684,4820,5848,5416,5676
    2010-07-06 18:29:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684,5588,3324,1868,2684,4820,5848,5416,5676,4920 ,4824
    2010-07-06 18:31:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684,5588,3324,1868,2684,4820,5848,5416,5676,4920
    2010-07-06 18:33:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684,5588,3324,1868,2684,4820,5848,5416,5676,4920 ,4672
    2010-07-06 18:35:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684,5588,3324,1868,2684,4820,5848,5416,5676,4920 ,4672
    2010-07-06 18:37:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684,5588,3324,1868,2684,4820,5848,5416,5676,4920 ,4672,4944
    2010-07-06 18:39:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684,5588,3324,1868,2684,4820,5848,5416,5676,4920 ,4672,4944
    2010-07-06 18:41:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684,5588,3324,1868,2684,4820,5848,5416,5676,4920 ,4672,4944
    2010-07-06 18:43:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684,5588,3324,1868,2684,4820,5848,5416,5676,4920 ,4672,4944
    2010-07-06 18:45:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684,5588,3324,1868,2684,4820,5848,5416,5676,4920 ,4672,4944
    2010-07-06 18:47:47: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684,5588,3324,1868,2684,4820,5848,5416,5676,4920 ,4672,4944
    2010-07-06 19:54:52: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684,5588,3324,1868,2684,4820,5848,5416,5676,4920 ,4672,4944,5620,1432
    2010-07-06 19:56:52: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684,5588,3324,1868,2684,4820,5848,5416,5676,4920 ,4672,4944,5620
    2010-07-06 19:58:52: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684,5588,3324,1868,2684,4820,5848,5416,5676,4920 ,4672,4944,5620
    2010-07-06 20:00:52: 3764,3940,3008,3048,2968,3088,5320,6016,4848,5044, 5744,1068,5540,1632,560,4480,5564,384,600,5940,456 8,4620,4596,4316,5396,4680,424,5224,4856,5964,4640 ,4684,5588,3324,1868,2684,4820,5848,5416,5676,4920 ,4672,4944,5620
    2010-07-06 20:02:52:

  4. #4
    treFFnix ist offline Benutzer
    Registriert seit
    25.03.2010
    Beiträge
    68

    Standard

    Abends dann habe ich mein Laptop neu gestartet, dann habe ich keinen Zugriff auf keine Datenbank gemacht und habe mein Tool wieder einige Stunden laufen lassen:

    Code:
    2010-07-06 20:23:01: 3196,3380,3616,3624,3632,3640
         2010-07-06 20:25:01: 3196,3380,3616,3624,3632,3640
         2010-07-06 20:27:01: 3196,3380,3616,3624,3632,3640
         2010-07-06 20:29:01: 3196,3380,3616,3624,3632,3640
         2010-07-06 20:31:01: 3196,3380,3616,3624,3632,3640
         2010-07-06 20:33:01: 3196,3380,3616,3624,3632,3640
         2010-07-06 20:38:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 20:40:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 20:42:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 20:44:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 20:46:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 20:48:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 20:50:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 20:52:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 20:54:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 20:56:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 20:58:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 21:00:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 21:02:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 21:04:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 21:06:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 21:08:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 21:10:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 21:12:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 21:14:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 21:16:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 21:18:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 21:20:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 21:22:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 21:24:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 21:26:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 21:28:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 21:30:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 21:32:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 21:34:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 21:36:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 21:38:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 21:40:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 21:42:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 21:44:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 21:46:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 21:48:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 21:50:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 21:52:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 21:54:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 21:56:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 21:58:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 22:00:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 22:02:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 22:04:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 22:06:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 22:08:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 22:10:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 22:12:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 22:14:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 22:16:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 22:18:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 22:20:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 22:22:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 22:24:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 22:26:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 22:28:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 22:30:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 22:32:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 22:34:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 22:36:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 22:38:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 22:40:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 22:42:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 22:44:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 22:46:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 22:48:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 22:50:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 22:52:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 22:54:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 22:56:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 22:58:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 23:00:53: 3196,3380,3616,3624,3632,3640
         2010-07-06 23:02:54: 3196,3380,3616,3624,3632,3640
         2010-07-06 23:04:54: 3196,3380,3616,3624,3632,3640
         2010-07-06 23:06:54: 3196,3380,3616,3624,3632,3640
         2010-07-06 23:08:54: 3196,3380,3616,3624,3632,3640
         2010-07-06 23:10:54: 3196,3380,3616,3624,3632,3640
         2010-07-06 23:12:54: 3196,3380,3616,3624,3632,3640
    Man sieht also: Wenn man postgreSQL nicht benutzt, kommt der Fehler auch nicht...

  5. #5
    treFFnix ist offline Benutzer
    Registriert seit
    25.03.2010
    Beiträge
    68

    Standard

    Nun habe ich noch getestet, ob es an der Software liegt, die die Fertigungsdaten in die Datenbank schreibt. Das habe ich getestet, indem ich nicht unser Fertigungsprogramm, sondern nur einmal PGAdmin III gestartet habe und folgendes gemacht habe:

    PG Admin III:
    (Zugriff auf leere Datenbank: select * from t_value)
    (Zugriff auf Datenbank mit wenigen Datensätzen: select * from t_value)
    (Zugriff auf leere Datenbank: select * from t_value)

    nachdem ich mit PGAdmin III auf 3 der Datenbanken zugegriffen habe:

    [CODE]2010-07-06 23:14:54: 3196,3380,3616,3624,3632,3640,1652,2172,2524,3152, 5892
    2010-07-06 23:16:54: 3196,3380,3616,3624,3632,3640
    2010-07-06 23:18:54: 3196,3380,3616,3624,3632,3640
    2010-07-06 23:20:54: 3196,3380,3616,3624,3632,3640
    2010-07-06 23:22:54: 3196,3380,3616,3624,3632,3640
    2010-07-06 23:24:54: 3196,3380,3616,3624,3632,3640
    2010-07-06 23:26:54: 3196,3380,3616,3624,3632,3640,5316
    2010-07-06 23:28:54: 3196,3380,3616,3624,3632,3640,5316,4448
    2010-07-06 23:30:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816
    2010-07-06 23:32:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044
    2010-07-06 23:34:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280
    2010-07-06 23:36:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280
    2010-07-06 23:38:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280
    2010-07-06 23:40:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408
    2010-07-06 23:42:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408
    2010-07-06 23:44:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628
    2010-07-06 23:46:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628
    2010-07-06 23:48:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628
    2010-07-06 23:50:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628
    2010-07-06 23:54:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628
    2010-07-06 23:56:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628
    2010-07-06 23:58:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628
    2010-07-07 00:00:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628
    2010-07-07 00:02:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628
    2010-07-07 00:04:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956
    2010-07-07 00:06:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956
    2010-07-07 00:08:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092
    2010-07-07 00:10:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092
    2010-07-07 00:12:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092
    2010-07-07 00:14:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092
    2010-07-07 00:16:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092
    2010-07-07 00:18:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,4688
    2010-07-07 00:20:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092
    2010-07-07 00:22:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092
    2010-07-07 00:24:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092
    2010-07-07 00:26:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092
    2010-07-07 00:28:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092
    2010-07-07 00:30:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092
    2010-07-07 00:32:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092
    2010-07-07 00:34:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092
    2010-07-07 00:36:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092
    2010-07-07 00:38:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092
    2010-07-07 00:40:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092
    2010-07-07 00:42:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092
    2010-07-07 00:44:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092
    2010-07-07 00:46:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292
    2010-07-07 00:48:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292
    2010-07-07 00:50:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748
    2010-07-07 00:52:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748
    2010-07-07 00:54:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748
    2010-07-07 00:56:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748
    2010-07-07 00:58:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748
    2010-07-07 01:00:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748
    2010-07-07 01:02:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748
    2010-07-07 01:04:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788
    2010-07-07 01:06:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788
    2010-07-07 01:08:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788
    2010-07-07 01:10:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788
    2010-07-07 01:12:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788
    2010-07-07 01:14:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788
    2010-07-07 01:16:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160
    2010-07-07 01:18:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160
    2010-07-07 01:20:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160
    2010-07-07 01:22:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160
    2010-07-07 01:24:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776
    2010-07-07 01:26:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776
    2010-07-07 01:28:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776
    2010-07-07 01:30:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776
    2010-07-07 01:32:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776
    2010-07-07 01:34:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776
    2010-07-07 01:36:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,4744
    2010-07-07 01:38:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776
    2010-07-07 01:40:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016
    2010-07-07 01:42:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016
    2010-07-07 01:44:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016
    2010-07-07 01:46:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016
    2010-07-07 01:48:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016
    2010-07-07 01:50:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016
    2010-07-07 01:52:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016

  6. #6
    treFFnix ist offline Benutzer
    Registriert seit
    25.03.2010
    Beiträge
    68

    Standard

    2010-07-07 01:54:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016,4308
    2010-07-07 01:56:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016,4308,5040
    2010-07-07 01:58:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016,4308,5040,4660
    2010-07-07 02:00:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016,4308,5040,4660
    2010-07-07 02:02:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016,4308,5040,4660,740
    2010-07-07 02:04:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016,4308,5040,4660,740
    2010-07-07 02:06:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016,4308,5040,4660,740
    2010-07-07 02:08:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016,4308,5040,4660,740
    2010-07-07 02:10:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016,4308,5040,4660,740
    2010-07-07 02:12:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016,4308,5040,4660,740,3252
    2010-07-07 02:14:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016,4308,5040,4660,740,3252
    2010-07-07 02:16:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016,4308,5040,4660,740,3252
    2010-07-07 02:18:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016,4308,5040,4660,740,3252
    2010-07-07 02:20:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016,4308,5040,4660,740,3252
    2010-07-07 02:22:54: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016,4308,5040,4660,740,3252,5976
    2010-07-07 02:24:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016,4308,5040,4660,740,3252,5976,4124,4520
    2010-07-07 02:26:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016,4308,5040,4660,740,3252,5976,4124,4520
    2010-07-07 02:28:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016,4308,5040,4660,740,3252,5976,4124,4520,26 48
    2010-07-07 02:30:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016,4308,5040,4660,740,3252,5976,4124,4520,26 48,5000
    2010-07-07 02:32:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016,4308,5040,4660,740,3252,5976,4124,4520,26 48,5000
    2010-07-07 02:34:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016,4308,5040,4660,740,3252,5976,4124,4520,26 48,5000,4628
    2010-07-07 02:36:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016,4308,5040,4660,740,3252,5976,4124,4520,26 48,5000,4628
    2010-07-07 02:38:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016,4308,5040,4660,740,3252,5976,4124,4520,26 48,5000,4628,4924
    2010-07-07 02:40:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016,4308,5040,4660,740,3252,5976,4124,4520,26 48,5000,4628,4924
    2010-07-07 02:42:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016,4308,5040,4660,740,3252,5976,4124,4520,26 48,5000,4628,4924,4692
    2010-07-07 02:44:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016,4308,5040,4660,740,3252,5976,4124,4520,26 48,5000,4628,4924,4692
    2010-07-07 02:46:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016,4308,5040,4660,740,3252,5976,4124,4520,26 48,5000,4628,4924,4692,3176
    2010-07-07 02:48:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016,4308,5040,4660,740,3252,5976,4124,4520,26 48,5000,4628,4924,4692,3176
    2010-07-07 02:50:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016,4308,5040,4660,740,3252,5976,4124,4520,26 48,5000,4628,4924,4692,3176,2968,4188
    2010-07-07 02:52:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016,4308,5040,4660,740,3252,5976,4124,4520,26 48,5000,4628,4924,4692,3176,2968,4188,3104,5916
    2010-07-07 02:54:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016,4308,5040,4660,740,3252,5976,4124,4520,26 48,5000,4628,4924,4692,3176,2968,4188,3104,5916,51 72,2644,4848
    2010-07-07 02:56:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016,4308,5040,4660,740,3252,5976,4124,4520,26 48,5000,4628,4924,4692,3176,2968,4188,3104,5916,51 72,2644,1992
    2010-07-07 02:58:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016,4308,5040,4660,740,3252,5976,4124,4520,26 48,5000,4628,4924,4692,3176,2968,4188,3104,5916,51 72,2644,1992
    2010-07-07 03:00:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016,4308,5040,4660,740,3252,5976,4124,4520,26 48,5000,4628,4924,4692,3176,2968,4188,3104,5916,51 72,2644,1992
    2010-07-07 03:02:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016,4308,5040,4660,740,3252,5976,4124,4520,26 48,5000,4628,4924,4692,3176,2968,4188,3104,5916,51 72,2644,1992
    2010-07-07 03:04:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016,4308,5040,4660,740,3252,5976,4124,4520,26 48,5000,4628,4924,4692,3176,2968,4188,3104,5916,51 72,2644,1992
    2010-07-07 03:06:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016,4308,5040,4660,740,3252,5976,4124,4520,26 48,5000,4628,4924,4692,3176,2968,4188,3104,5916,51 72,2644,1992,316
    2010-07-07 03:08:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016,4308,5040,4660,740,3252,5976,4124,4520,26 48,5000,4628,4924,4692,3176,2968,4188,3104,5916,51 72,2644,1992,316
    2010-07-07 03:10:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016,4308,5040,4660,740,3252,5976,4124,4520,26 48,5000,4628,4924,4692,3176,2968,4188,3104,5916,51 72,2644,1992,316,1724,4112
    2010-07-07 03:12:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016,4308,5040,4660,740,3252,5976,4124,4520,26 48,5000,4628,4924,4692,3176,2968,4188,3104,5916,51 72,2644,1992,316,1724,4112,1796
    2010-07-07 03:14:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016,4308,5040,4660,740,3252,5976,4124,4520,26 48,5000,4628,4924,4692,3176,2968,4188,3104,5916,51 72,2644,1992,316,1724,4112,1796
    2010-07-07 03:16:55: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016,4308,5040,4660,740,3252,5976,4124,4520,26 48,5000,4628,4924,4692,3176,2968,4188,3104,5916,51 72,2644,1992,316,1724,4112,1796,2796
    2010-07-07 08:51:20: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016,4308,5040,4660,740,3252,5976,4124,4520,26 48,5000,4628,4924,4692,3176,2968,4188,3104,5916,51 72,2644,1992,316,1724,4112,1796,2796,6012
    2010-07-07 08:53:20: 3196,3380,3616,3624,3632,3640,5316,4448,5816,5044, 5280,668,2408,1628,5956,2092,5292,5748,1788,4160,5 776,5016,4308,5040,4660,740,3252,5976,4124,4520,26 48,5000,4628,4924,4692,3176,2968,4188,3104,5916,51 72,2644,1992,316,1724,4112,1796,2796,6012[/CODE]So das wars von meiner Seite aus.
    Können noch andere Vista-Nutzer dieses verhalten bestätigen?
    Liegt es speziell an meinem Laptop, oder hat PostgreSQL noch einen Vista-Bug?

    Was kann ich da machen (außer das Betriebssystem zu wechseln)?

  7. #7
    ads
    ads ist offline Super-Moderator
    Registriert seit
    08.02.2006
    Ort
    MD
    Beiträge
    4.055

    Standard

    Also, zuerst einmal sollte deine Anwendung niemals als Superuser auf die Datenbank zugreifen!
    Dann hättest du nämlich als Superuser immer noch 2 Verbindungen zur Verfügung, selbst wenn normale Accounts alle vorhandenen Verbindungen blockieren.
    Wenn deine Anwendung jedoch als Superuser arbeitet, werden die Reserveverbindungen logischerweise auch für diesen Nutzer verwendet.

    So, zum eigentlichen Problem: ob du uns hier seitenweise PIDs hinschreibst oder Ausschnitte aus der Bibel postest - das kommt auf das gleiche heraus. Die PIDs sind nur auf deinem Rechner gültig, damit kann hier niemand etwas anfangen.

    Du hast aber selbst schon erkannt, dass das Problem nicht auftritt, wenn du nur pgAdminIII verwendest und die Anwendung ausgeschaltet ist. Demzufolge muss das Problem bei deiner Anwendung liegen. Tust du irgendwo Datenbankverbindungen öffnen, aber nicht richtig schließen?

    Was siehst du, wenn du folgendes aufrufst:

    Code:
    SELECT waiting, current_query FROM pg_stat_activity
    Xandrian: Kurz gesagt: Du hast ein falsches Konzept und willst nicht auf ads hören

    Jetzt NEU: PostgreSQL - Datenbankpraxis für Anwender, Administratoren und Entwickler

    PostgreSQL Service & Support

  8. #8
    treFFnix ist offline Benutzer
    Registriert seit
    25.03.2010
    Beiträge
    68

    Standard

    Danke für die Antwort ads.

    Ich habe versucht zu sagen, dass es AUCH passiert, wenn ich NUR PGAdmin III nutze.
    Wenn ich sicher wäre, dass es nur an unserer Applikation liegt, wüsste ich, das das hier nichts zu suchen hat.

    Aber die postgres.exe fangen auch an, sich anzuhäufen, wenn ich über PGAdmin III ein paar Selects ausführe.

    Die Abfrage
    SELECT waiting, current_query FROM pg_stat_activity
    bringt dieses Ergebnis:
    f;"<IDLE>"
    f;"SELECT waiting, current_query FROM pg_stat_activity"
    sagt das was aus?
    Geändert von treFFnix (07.07.2010 um 10:22 Uhr)

  9. #9
    castorp ist offline Erfahrener Benutzer
    Registriert seit
    27.06.2009
    Beiträge
    524

    Standard

    Zitat Zitat von treFFnix Beitrag anzeigen
    Dabei fällt mir immer wieder auf, dass ich mich irgendwann, nach einigen Stunden Arbeit mit der Datenbank, nicht mehr über PGAdmin III auf meinen lokalen Server verbinden kann. --> Ein Blick in den Taskmanager verrt mir immer, dass es über 100 laufende PRozesse 'postgres.exe' gibt.
    Jede postgres.exe bedeutet eine Verbindung zu Deiner Datenbank.
    Für mich klingt das so, als würde Deine Anwendung Verbindungen aufbauen aber nie wieder sauber schliessen.

    Aber die postgres.exe fangen auch an, sich anzuhäufen, wenn ich über PGAdmin III ein paar Selects ausführe.
    In dem gleichen Umfang wie es Deine Anwendung macht?
    Ich glaube pgAdmin öffnet eine Verbindung für jede Datenbank die Du in der Baumansicht anklickst (so dass das rote Kreuz verschwindet) und für jedes SQL/Query Fenster welches du aufmachst.
    A SQL query walks into a bar and sees two tables. He walks up to them and says 'Can I join you?'

  10. #10
    treFFnix ist offline Benutzer
    Registriert seit
    25.03.2010
    Beiträge
    68

    Standard

    Zitat Zitat von castorp Beitrag anzeigen
    In dem gleichen Umfang wie es Deine Anwendung macht?
    Ich glaube pgAdmin öffnet eine Verbindung für jede Datenbank die Du in der Baumansicht anklickst (so dass das rote Kreuz verschwindet) und für jedes SQL/Query Fenster welches du aufmachst.
    Ja.
    Ich versuche es nochmal genauer zu beschreiben:

    Laptopneustart: 5x postgres.exe
    Wenn ich nun PGAdmin III öffne, ein Paar Selects auf verschiedene Datenbanken ausführe, sind es 9x poistgres.exe
    Dann klicke ich am Ende mit Rechter Maustaste auf den localhost-Server und klicke "Verbindung schließen" -> PGAdmin III beenden -> 5x postgres.exe
    Wenn ich jetzt nichts mache (mit Datenbanken [nichtmal indirekt!]) und meinen Laptop einfach im Leerlauf lasse, kann ich beobachten, dass sich innerhalb der nächsten 1 bis 10 Minuten ein weiteres postgres.exe geöffnet hat. -> 6x postgres.exe
    Ab jetzt kommt im Minutentakt(alle 1- 10 Minuten) 1 neues postgres.exe (bis sie irgendwann alle connections voll sind, nehme ich an).

    Ein identisches Verhalten kann ich bei unserer Applikation beobachten.
    Beim beenden unserer Applikation "gehen 1 bis 2 postgres.exe weg", die sich danach dann im Leerlauf aber wieder aufbauen/häufen/mehr werden.


    MfG
    Geändert von treFFnix (07.07.2010 um 11:08 Uhr)

Seite 1 von 5 123 ... LetzteLetzte

Ähnliche Themen

  1. Postgres startet nicht mehr
    Von KMarco im Forum Konfiguration
    Antworten: 2
    Letzter Beitrag: 05.06.2011, 19:15
  2. Antworten: 3
    Letzter Beitrag: 02.12.2010, 16:10
  3. Postgres startet nicht mehr
    Von roester im Forum Installation von PostgreSQL
    Antworten: 9
    Letzter Beitrag: 01.05.2010, 13:42
  4. postgres startest nicht mehr nach Computerabsturz
    Von payday im Forum Allgemeines
    Antworten: 3
    Letzter Beitrag: 22.10.2009, 10:43
  5. postgres ist nicht mehr zu starten
    Von Crypi im Forum Sonstige Installationsprobleme
    Antworten: 3
    Letzter Beitrag: 18.01.2006, 12:39

Stichworte

Berechtigungen

  • Neue Themen erstellen: Nein
  • Themen beantworten: Nein
  • Anhänge hochladen: Nein
  • Beiträge bearbeiten: Nein
  •  

Links: Tobias Bauer - IT- und Funkdienstleistungen   -   Bilderrahmen-kaufen.de - Der Onlineshop für Bilderrahmen & Fotorahmen   -   Funkforum