{"id":9958,"date":"2023-02-13T03:40:12","date_gmt":"2023-02-13T03:40:12","guid":{"rendered":"https:\/\/www.scmgalaxy.com\/tutorials\/?p=9958"},"modified":"2023-02-13T03:40:13","modified_gmt":"2023-02-13T03:40:13","slug":"kubernetes-eks-gitlab-database-issues","status":"publish","type":"post","link":"https:\/\/www.scmgalaxy.com\/tutorials\/kubernetes-eks-gitlab-database-issues\/","title":{"rendered":"Kubernetes EKS Gitlab Database issues &#8211;"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Error<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>ubuntu@ip-172-31-16-250:~\/rajesh$ kubectl logs gitlab-postgresql-0\r\nDefaulted container \"gitlab-postgresql\" out of: gitlab-postgresql, metrics\r\npostgresql 00:13:21.83\r\npostgresql 00:13:21.83 Welcome to the Bitnami postgresql container\r\npostgresql 00:13:21.84 Subscribe to project updates by watching https:\/\/github.com\/bitnami\/bitnami-docker-postgresql\r\npostgresql 00:13:21.84 Submit issues and feature requests at https:\/\/github.com\/bitnami\/bitnami-docker-postgresql\/issues\r\npostgresql 00:13:21.85\r\npostgresql 00:13:21.87 INFO  ==> ** Starting PostgreSQL setup **\r\npostgresql 00:13:21.91 INFO  ==> Validating settings in POSTGRESQL_* env vars..\r\npostgresql 00:13:21.92 INFO  ==> Loading custom pre-init scripts...\r\npostgresql 00:13:21.93 INFO  ==> Loading user's custom files from \/docker-entrypoint-preinitdb.d ...\r\npostgresql 00:13:21.94 INFO  ==> Initializing PostgreSQL database...\r\npostgresql 00:13:21.96 INFO  ==> pg_hba.conf file not detected. Generating it...\r\npostgresql 00:13:21.97 INFO  ==> Generating local authentication configuration\r\npostgresql 00:13:23.46 INFO  ==> Starting PostgreSQL in background...\r\npostgresql 00:13:23.70 INFO  ==> Changing password of postgres\r\npostgresql 00:13:23.71 INFO  ==> Creating user gitlab\r\npostgresql 00:13:23.73 INFO  ==> Granting access to \"gitlab\" to the database \"gitlabhq_production\"\r\npostgresql 00:13:23.76 INFO  ==> Setting ownership for the 'public' schema database \"gitlabhq_production\" to \"gitlab\"\r\npostgresql 00:13:23.79 INFO  ==> Configuring replication parameters\r\npostgresql 00:13:23.84 INFO  ==> Configuring fsync\r\npostgresql 00:13:23.88 INFO  ==> Loading custom scripts...\r\npostgresql 00:13:23.89 INFO  ==> Loading user's custom files from \/docker-entrypoint-initdb.d ...\r\npostgresql 00:13:23.89 INFO  ==> Starting PostgreSQL in background...\r\nCREATE EXTENSION\r\npostgresql 00:13:24.07 INFO  ==> Enabling remote connections\r\npostgresql 00:13:24.09 INFO  ==> Stopping PostgreSQL...\r\nwaiting for server to shut down.... done\r\nserver stopped\r\npostgresql 00:13:24.21 INFO  ==> ** PostgreSQL setup finished! **\r\n\r\npostgresql 00:13:24.26 INFO  ==> ** Starting PostgreSQL **\r\n2023-02-13 00:13:24.294 GMT &#91;1] LOG:  pgaudit extension initialized\r\n2023-02-13 00:13:24.294 GMT &#91;1] LOG:  starting PostgreSQL 12.7 on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit\r\n2023-02-13 00:13:24.295 GMT &#91;1] LOG:  listening on IPv4 address \"0.0.0.0\", port 5432\r\n2023-02-13 00:13:24.295 GMT &#91;1] LOG:  listening on IPv6 address \"::\", port 5432\r\n2023-02-13 00:13:24.301 GMT &#91;1] LOG:  listening on Unix socket \"\/tmp\/.s.PGSQL.5432\"\r\n2023-02-13 00:13:24.328 GMT &#91;171] LOG:  database system was shut down at 2023-02-13 00:13:24 GMT\r\n2023-02-13 00:13:24.341 GMT &#91;1] LOG:  database system is ready to accept connections\r\n2023-02-13 00:13:41.037 GMT &#91;214] ERROR:  relation \"postgres_partitioned_tables\" does not exist at character 85\r\n2023-02-13 00:13:41.037 GMT &#91;214] STATEMENT:  \/*application:web,db_config_name:main*\/ SELECT \"postgres_partitioned_tables\".* FROM \"postgres_partitioned_tables\" WHERE (identifier = concat(current_schema(), '.', 'audit_events')) LIMIT 1\r\n2023-02-13 00:13:41.039 GMT &#91;214] ERROR:  relation \"postgres_partitioned_tables\" does not exist at character 85\r\n2023-02-13 00:13:41.039 GMT &#91;214] STATEMENT:  \/*application:web,db_config_name:main*\/ SELECT \"postgres_partitioned_tables\".* FROM \"postgres_partitioned_tables\" WHERE (identifier = concat(current_schema(), '.', 'web_hook_logs')) LIMIT 1\r\n2023-02-13 00:13:41.042 GMT &#91;214] ERROR:  relation \"postgres_partitioned_tables\" does not exist at character 85\r\n2023-02-13 00:13:41.042 GMT &#91;214] STATEMENT:  \/*application:web,db_config_name:main*\/ SELECT \"postgres_partitioned_tables\".* FROM \"postgres_partitioned_tables\" WHERE (identifier = concat(current_schema(), '.', 'loose_foreign_keys_deleted_records')) LIMIT 1\r\n2023-02-13 00:13:41.044 GMT &#91;214] ERROR:  relation \"postgres_partitioned_tables\" does not exist at character 85\r\n2023-02-13 00:13:41.044 GMT &#91;214] STATEMENT:  \/*application:web,db_config_name:main*\/ SELECT \"postgres_partitioned_tables\".* FROM \"postgres_partitioned_tables\" WHERE (identifier = concat(current_schema(), '.', 'batched_background_migration_job_transition_logs')) LIMIT 1\r\n2023-02-13 00:13:41.046 GMT &#91;214] ERROR:  relation \"postgres_partitioned_tables\" does not exist at character 85\r\n2023-02-13 00:13:41.046 GMT &#91;214] STATEMENT:  \/*application:web,db_config_name:main*\/ SELECT \"postgres_partitioned_tables\".* FROM \"postgres_partitioned_tables\" WHERE (identifier = concat(current_schema(), '.', 'incident_management_pending_alert_escalations')) LIMIT 1\r\n2023-02-13 00:13:41.048 GMT &#91;214] ERROR:  relation \"postgres_partitioned_tables\" does not exist at character 85\r\n2023-02-13 00:13:41.048 GMT &#91;214] STATEMENT:  \/*application:web,db_config_name:main*\/ SELECT \"postgres_partitioned_tables\".* FROM \"postgres_partitioned_tables\" WHERE (identifier = concat(current_schema(), '.', 'incident_management_pending_issue_escalations')) LIMIT 1\r\n2023-02-13 00:13:41.050 GMT &#91;214] ERROR:  relation \"postgres_partitioned_tables\" does not exist at character 85\r\n2023-02-13 00:13:41.050 GMT &#91;214] STATEMENT:  \/*application:web,db_config_name:main*\/ SELECT \"postgres_partitioned_tables\".* FROM \"postgres_partitioned_tables\" WHERE (identifier = concat(current_schema(), '.', 'security_findings')) LIMIT 1\r\n2023-02-13 00:13:41.051 GMT &#91;214] ERROR:  relation \"postgres_partitioned_tables\" does not exist at character 85\r\n2023-02-13 00:13:41.051 GMT &#91;214] STATEMENT:  \/*application:web,db_config_name:main*\/ SELECT \"postgres_partitioned_tables\".* FROM \"postgres_partitioned_tables\" WHERE (identifier = concat(current_schema(), '.', 'verification_codes')) LIMIT 1\r\n2023-02-13 00:14:14.950 GMT &#91;284] ERROR:  duplicate key value violates unique constraint \"index_shards_on_name\"\r\n2023-02-13 00:14:14.950 GMT &#91;284] DETAIL:  Key (name)=(default) already exists.\r\n2023-02-13 00:14:14.950 GMT &#91;284] STATEMENT:  \/*application:web,db_config_name:main*\/ INSERT INTO \"shards\" (\"name\") VALUES ('default') RETURNING \"id\"\r\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Error<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_joinchat":[],"footnotes":""},"categories":[1],"tags":[],"class_list":["post-9958","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Kubernetes EKS Gitlab Database issues - scmGalaxy<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.scmgalaxy.com\/tutorials\/kubernetes-eks-gitlab-database-issues\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Kubernetes EKS Gitlab Database issues - scmGalaxy\" \/>\n<meta property=\"og:description\" content=\"Error\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.scmgalaxy.com\/tutorials\/kubernetes-eks-gitlab-database-issues\/\" \/>\n<meta property=\"og:site_name\" content=\"scmGalaxy\" \/>\n<meta property=\"article:published_time\" content=\"2023-02-13T03:40:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-02-13T03:40:13+00:00\" \/>\n<meta name=\"author\" content=\"rajeshkumar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"rajeshkumar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/kubernetes-eks-gitlab-database-issues\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/kubernetes-eks-gitlab-database-issues\\\/\"},\"author\":{\"name\":\"rajeshkumar\",\"@id\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/#\\\/schema\\\/person\\\/a40e0dd38feee7c2779460a804d49361\"},\"headline\":\"Kubernetes EKS Gitlab Database issues &#8211;\",\"datePublished\":\"2023-02-13T03:40:12+00:00\",\"dateModified\":\"2023-02-13T03:40:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/kubernetes-eks-gitlab-database-issues\\\/\"},\"wordCount\":7,\"commentCount\":0,\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/kubernetes-eks-gitlab-database-issues\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/kubernetes-eks-gitlab-database-issues\\\/\",\"url\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/kubernetes-eks-gitlab-database-issues\\\/\",\"name\":\"Kubernetes EKS Gitlab Database issues - scmGalaxy\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/#website\"},\"datePublished\":\"2023-02-13T03:40:12+00:00\",\"dateModified\":\"2023-02-13T03:40:13+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/#\\\/schema\\\/person\\\/a40e0dd38feee7c2779460a804d49361\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/kubernetes-eks-gitlab-database-issues\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/kubernetes-eks-gitlab-database-issues\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/kubernetes-eks-gitlab-database-issues\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Kubernetes EKS Gitlab Database issues &#8211;\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/#website\",\"url\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/\",\"name\":\"scmGalaxy\",\"description\":\"A Platform for Software Engineers\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/#\\\/schema\\\/person\\\/a40e0dd38feee7c2779460a804d49361\",\"name\":\"rajeshkumar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/82337e1fc8642c7f36795aa0775af055a4f38882994004b593efd31758d4434e?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/82337e1fc8642c7f36795aa0775af055a4f38882994004b593efd31758d4434e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/82337e1fc8642c7f36795aa0775af055a4f38882994004b593efd31758d4434e?s=96&d=mm&r=g\",\"caption\":\"rajeshkumar\"},\"url\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/author\\\/rajeshkumar\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Kubernetes EKS Gitlab Database issues - scmGalaxy","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.scmgalaxy.com\/tutorials\/kubernetes-eks-gitlab-database-issues\/","og_locale":"en_US","og_type":"article","og_title":"Kubernetes EKS Gitlab Database issues - scmGalaxy","og_description":"Error","og_url":"https:\/\/www.scmgalaxy.com\/tutorials\/kubernetes-eks-gitlab-database-issues\/","og_site_name":"scmGalaxy","article_published_time":"2023-02-13T03:40:12+00:00","article_modified_time":"2023-02-13T03:40:13+00:00","author":"rajeshkumar","twitter_card":"summary_large_image","twitter_misc":{"Written by":"rajeshkumar","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.scmgalaxy.com\/tutorials\/kubernetes-eks-gitlab-database-issues\/#article","isPartOf":{"@id":"https:\/\/www.scmgalaxy.com\/tutorials\/kubernetes-eks-gitlab-database-issues\/"},"author":{"name":"rajeshkumar","@id":"https:\/\/www.scmgalaxy.com\/tutorials\/#\/schema\/person\/a40e0dd38feee7c2779460a804d49361"},"headline":"Kubernetes EKS Gitlab Database issues &#8211;","datePublished":"2023-02-13T03:40:12+00:00","dateModified":"2023-02-13T03:40:13+00:00","mainEntityOfPage":{"@id":"https:\/\/www.scmgalaxy.com\/tutorials\/kubernetes-eks-gitlab-database-issues\/"},"wordCount":7,"commentCount":0,"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.scmgalaxy.com\/tutorials\/kubernetes-eks-gitlab-database-issues\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.scmgalaxy.com\/tutorials\/kubernetes-eks-gitlab-database-issues\/","url":"https:\/\/www.scmgalaxy.com\/tutorials\/kubernetes-eks-gitlab-database-issues\/","name":"Kubernetes EKS Gitlab Database issues - scmGalaxy","isPartOf":{"@id":"https:\/\/www.scmgalaxy.com\/tutorials\/#website"},"datePublished":"2023-02-13T03:40:12+00:00","dateModified":"2023-02-13T03:40:13+00:00","author":{"@id":"https:\/\/www.scmgalaxy.com\/tutorials\/#\/schema\/person\/a40e0dd38feee7c2779460a804d49361"},"breadcrumb":{"@id":"https:\/\/www.scmgalaxy.com\/tutorials\/kubernetes-eks-gitlab-database-issues\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.scmgalaxy.com\/tutorials\/kubernetes-eks-gitlab-database-issues\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.scmgalaxy.com\/tutorials\/kubernetes-eks-gitlab-database-issues\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.scmgalaxy.com\/tutorials\/"},{"@type":"ListItem","position":2,"name":"Kubernetes EKS Gitlab Database issues &#8211;"}]},{"@type":"WebSite","@id":"https:\/\/www.scmgalaxy.com\/tutorials\/#website","url":"https:\/\/www.scmgalaxy.com\/tutorials\/","name":"scmGalaxy","description":"A Platform for Software Engineers","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.scmgalaxy.com\/tutorials\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.scmgalaxy.com\/tutorials\/#\/schema\/person\/a40e0dd38feee7c2779460a804d49361","name":"rajeshkumar","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/82337e1fc8642c7f36795aa0775af055a4f38882994004b593efd31758d4434e?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/82337e1fc8642c7f36795aa0775af055a4f38882994004b593efd31758d4434e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/82337e1fc8642c7f36795aa0775af055a4f38882994004b593efd31758d4434e?s=96&d=mm&r=g","caption":"rajeshkumar"},"url":"https:\/\/www.scmgalaxy.com\/tutorials\/author\/rajeshkumar\/"}]}},"_links":{"self":[{"href":"https:\/\/www.scmgalaxy.com\/tutorials\/wp-json\/wp\/v2\/posts\/9958","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.scmgalaxy.com\/tutorials\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.scmgalaxy.com\/tutorials\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.scmgalaxy.com\/tutorials\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.scmgalaxy.com\/tutorials\/wp-json\/wp\/v2\/comments?post=9958"}],"version-history":[{"count":1,"href":"https:\/\/www.scmgalaxy.com\/tutorials\/wp-json\/wp\/v2\/posts\/9958\/revisions"}],"predecessor-version":[{"id":9959,"href":"https:\/\/www.scmgalaxy.com\/tutorials\/wp-json\/wp\/v2\/posts\/9958\/revisions\/9959"}],"wp:attachment":[{"href":"https:\/\/www.scmgalaxy.com\/tutorials\/wp-json\/wp\/v2\/media?parent=9958"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.scmgalaxy.com\/tutorials\/wp-json\/wp\/v2\/categories?post=9958"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.scmgalaxy.com\/tutorials\/wp-json\/wp\/v2\/tags?post=9958"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}