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