Diese Seite verwendet Cookies, um die Navigation auf unserer Website zu verbessern. Durch Weiternutzung unserer Seite stimmst du der Verwendung von Cookies zu. Weitere Details dazu und Einstellungsmöglichkeiten findest du in unseren Cookie-Richtlinien und unserer Datenschutzerklärung.Schließen

Problem bei DB-Erzeugung

    • OJayPoker
      OJayPoker
      Bronze
      Dabei seit: 27.07.2007 Beiträge: 1.034
      Hallo zusammen,

      bin dabei den Elephant zu testen, doch leider kam ich bisher nicht sehr weit.

      Auf meinem Windows XP (SP2) System emuliere ich eine Unix-Maschine mittels cygwin, auf der ich den PostgreSQL Server laufen lasse. Der Server ist erfolgreich initialisiert und ich habe einen Superuser des Servers angelegt. Der Server horcht auf dem default-Port per TCP/IP. Die Version ist 'postmaster (PostgreSQL) 8.0.7'

      Nun starte ich den Elephant, und ich werde aufgefordert eine neue DB anzulegen. Dabei gebe ich die Login-Daten meines Superusers ein und teste die Verbindung. -> Verbindung konnte erfolgreich hergestellt werden.

      Danach gebe ich einen DB-Namen an (testdb), Elephant liefert eine Meldung 'Bei der Datenbankerzeugung ist ein Fehler aufgetreten'. Der Output des Servers ist folgender:

      FATAL: database "testdb" does not exist
      FATAL: database "testdb" does not exist
      ERROR: syntax error at or near "SUPERUSER" at character 26
      ERROR: syntax error at or near "ENUM" at character 26
      ERROR: user "Poker" does not exist
      ERROR: syntax error at or near "ENUM" at character 23
      ERROR: user "Poker" does not exist
      ERROR: syntax error at or near "ENUM" at character 21
      ERROR: user "Poker" does not exist
      ERROR: syntax error at or near "ENUM" at character 30
      ERROR: user "Poker" does not exist
      ERROR: syntax error at or near "ENUM" at character 26
      ERROR: user "Poker" does not exist
      ERROR: syntax error at or near "ENUM" at character 28
      ERROR: user "Poker" does not exist
      ERROR: syntax error at or near "ENUM" at character 23
      ERROR: user "Poker" does not exist
      ERROR: syntax error at or near "ENUM" at character 26
      LOG: could not receive data from client: Software caused connection abort
      ERROR: user "Poker" does not exist
      LOG: unexpected EOF on client connection
      ERROR: syntax error at or near "ENUM" at character 23
      ERROR: user "Poker" does not exist
      ERROR: syntax error at or near "ENUM" at character 28
      ERROR: user "Poker" does not exist
      ERROR: syntax error at or near "ENUM" at character 29
      ERROR: user "Poker" does not exist
      ERROR: syntax error at or near "ENUM" at character 30
      ERROR: user "Poker" does not exist
      ERROR: user "Poker" does not exist
      ERROR: user "Poker" does not exist
      ERROR: user "Poker" does not exist
      ERROR: user "Poker" does not exist
      ERROR: user "Poker" does not exist
      ERROR: user "Poker" does not exist
      ERROR: user "Poker" does not exist
      ERROR: user "Poker" does not exist
      ERROR: user "Poker" does not exist
      ERROR: type "moneytype" does not exist
      ERROR: relation "public.archive" does not exist
      NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "category_pkey" f
      or table "category"
      ERROR: user "Poker" does not exist
      ERROR: type "commenttype" does not exist
      ERROR: relation "comment" does not exist
      ERROR: relation "public.comment" does not exist
      ERROR: function nextval(regclass) does not exist
      HINT: No function matches the given name and argument types. You may need to ad
      d explicit type casts.
      ERROR: relation "public.comment_on_player" does not exist
      ERROR: type "card" does not exist
      ERROR: relation "game" does not exist
      ERROR: relation "game" does not exist
      ERROR: relation "game" does not exist
      ERROR: relation "public.game" does not exist
      ERROR: function nextval(regclass) does not exist
      HINT: No function matches the given name and argument types. You may need to ad
      d explicit type casts.
      ERROR: relation "public.gamechat" does not exist
      ERROR: type "card" does not exist
      ERROR: relation "gameplayer" does not exist
      ERROR: relation "gameplayer" does not exist
      ERROR: relation "public.gameplayer" does not exist
      ERROR: type "action" does not exist
      ERROR: relation "gamesequence" does not exist
      ERROR: relation "gamesequence" does not exist
      ERROR: relation "gamesequence" does not exist
      ERROR: relation "public.gamesequence" does not exist
      ERROR: function nextval(regclass) does not exist
      HINT: No function matches the given name and argument types. You may need to ad
      d explicit type casts.
      ERROR: relation "gametable" does not exist
      ERROR: relation "public.gametable" does not exist
      NOTICE: CREATE TABLE will create implicit sequence "gametype_game_type_id_seq1"
      for serial column "gametype.game_type_id"
      ERROR: type "limittype" does not exist
      ERROR: relation "gametype" does not exist
      ERROR: relation "gametype" does not exist
      ERROR: relation "public.gametype" does not exist
      NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "media_content_pk
      ey" for table "media_content"
      ERROR: user "Poker" does not exist
      ERROR: function nextval(regclass) does not exist
      HINT: No function matches the given name and argument types. You may need to ad
      d explicit type casts.
      ERROR: relation "public.player" does not exist
      ERROR: user "Poker" does not exist
      NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "playerstat_pkey"
      for table "playerstat"
      ERROR: user "Poker" does not exist
      NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "playlist_pkey" f
      or table "playlist"
      ERROR: user "Poker" does not exist
      NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "playlist_item_pk
      ey" for table "playlist_item"
      ERROR: user "Poker" does not exist
      NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "portal_pkey" for
      table "portal"
      ERROR: user "Poker" does not exist
      NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "quiz_pkey" for t
      able "quiz"
      ERROR: user "Poker" does not exist
      NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "quiz_answer_pkey
      " for table "quiz_answer"
      ERROR: user "Poker" does not exist
      NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "realplayer_pkey"
      for table "realplayer"
      ERROR: user "Poker" does not exist
      ERROR: user "Poker" does not exist
      ERROR: type "combinedcards" does not exist
      ERROR: relation "public.sorted_cards" does not exist
      ERROR: type "limittype" does not exist
      ERROR: relation "tournament" does not exist
      ERROR: relation "public.tournament" does not exist
      NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "trmt_payoutstruc
      ture_pkey" for table "trmt_payoutstructure"
      ERROR: user "Poker" does not exist
      NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "trmt_player_pkey
      " for table "trmt_player"
      ERROR: user "Poker" does not exist
      ERROR: user "Poker" does not exist
      NOTICE: CREATE TABLE will create implicit sequence "unclear_id_seq1" for serial
      column "unclear.id"
      NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "unclear_pkey" fo
      r table "unclear"
      ERROR: user "Poker" does not exist
      NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "uploader_pkey" f
      or table "uploader"
      ERROR: user "Poker" does not exist
      NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "version_pkey" fo
      r table "version"
      ERROR: user "Poker" does not exist
      ERROR: user "Poker" does not exist
      ERROR: relation "public.player" does not exist
      ERROR: relation "public.player" does not exist
      ERROR: invalid byte sequence for encoding "UNICODE": 0xdf
      ERROR: relation "public.sorted_cards" does not exist
      LOG: could not receive data from client: Software caused connection abortLOG:
      could not receive data from client: Connection reset by peerLOG: could not rece
      ive data from client: Software caused connection abort
      LOG: unexpected EOF on client connection

      LOG: unexpected EOF on client connection
      LOG: unexpected EOF on client connection






      Hoffentlich kann mir jemand helfen; oder ich muss noch mehr Infos liefer. ;-)

      Vielen Dank!!
  • 1 Antwort
    • OJayPoker
      OJayPoker
      Bronze
      Dabei seit: 27.07.2007 Beiträge: 1.034
      Nachdem ich Elephant beende bekomme ich noch folgenden Output:


      OS: Microsoft Windows NT 5.1.2600 Service Pack 2
      .NET Runtime: 2.0.50727.1433
      RAM: 1,5GB
      Processors: 1
      CPU: x86 Family 6 Model 13 Stepping 8: 0/32/2, 1995

      (10) , line 0: Npgsql.NpgsqlException:
      cannot cast type text to boolean
      Severity: ERROR
      Code: 42846
      bei Npgsql.NpgsqlConnector.CheckErrors()
      bei Npgsql.NpgsqlCommand.ExecuteCommand()
      bei Npgsql.NpgsqlCommand.ExecuteScalar()
      bei PBN.Database.PostgreSQL.ExecuteQueryScalar(String in_sQueryString)


      Dieser Error kommt mehrmals mit dem gleichen Stacktrace vor, daher poste ich ihn nur einmal.

      Schöne Grüße