github-starred/gitea
2
0
Fork 0
mirror of https://github.com/go-gitea/gitea.git synced 2026-03-09 12:46:42 -05:00
Code Issues 2.6k Packages Projects Releases 100 Wiki Activity

Database settings invalid: sync database struct error: Error 1286 (42000): Unknown storage engine 'InnoDB' #11697

New Issue
Closed
opened 2025-11-02 09:44:57 -06:00 by GiteaMirror · 6 comments
GiteaMirror commented 2025-11-02 09:44:57 -06:00
Owner
Copy Link

Originally created by @FuckingToasters on GitHub (Sep 22, 2023).

Description

I'm currently trying to install gitea but i always face following error on the setuppage. I tried to get around it by adding the command field in the yaml file below but it havn't changed anything.
Database settings invalid: sync database struct error: Error 1286 (42000): Unknown storage engine 'InnoDB'

version: '3'

services:
  gitea:
    image: gitea/gitea:latest
    container_name: gitea
    environment:
      - USER_UID=1000
      - USER_GID=1000
      - GITEA__database__DB_TYPE=mysql
      - GITEA__database__HOST=gitea_db:3306 # Use the name of the existing MariaDB container
      - GITEA__database__NAME=gitea # Use a different database name for Gitea
      - GITEA__database__USER=InfinityMonster
      - GITEA__database__PASSWD=REDACTED
    restart: always
    networks:
      - webproxy
    volumes:
      - gitea_data:/data
      - /etc/timezone:/etc/timezone:ro
      - /etc/localtime:/etc/localtime:ro
    depends_on:
      - gitea_db

  gitea_db:
    image: jc21/mariadb-aria:latest
    container_name: gitea_db
    command: ["--innodb-buffer-pool-size=256M"]
    environment:
      - MYSQL_ROOT_PASSWORD=REDACTED
      - MYSQL_USER=InfinityMonster
      - MYSQL_PASSWORD=REDACTED
      - MYSQL_DATABASE=gitea
    networks:
      - webproxy
    volumes:
      - gitea_db_data:/var/lib/mysql

networks:
  webproxy:
    external: true

volumes:
  gitea_data:
  gitea_db_data:

Gitea Version

latest

Can you reproduce the bug on the Gitea demo site?

No

Log Gist

No response

Screenshots

chrome_YDA2EbxdL3

Git Version

2.30.2

Operating System

Debian 11 / Windows 10

How are you running Gitea?

Via Docker image

Database

MySQL/MariaDB

Originally created by @FuckingToasters on GitHub (Sep 22, 2023). ### Description I'm currently trying to install gitea but i always face following error on the setuppage. I tried to get around it by adding the command field in the yaml file below but it havn't changed anything. `Database settings invalid: sync database struct error: Error 1286 (42000): Unknown storage engine 'InnoDB'` ```yml version: '3' services: gitea: image: gitea/gitea:latest container_name: gitea environment: - USER_UID=1000 - USER_GID=1000 - GITEA__database__DB_TYPE=mysql - GITEA__database__HOST=gitea_db:3306 # Use the name of the existing MariaDB container - GITEA__database__NAME=gitea # Use a different database name for Gitea - GITEA__database__USER=InfinityMonster - GITEA__database__PASSWD=REDACTED restart: always networks: - webproxy volumes: - gitea_data:/data - /etc/timezone:/etc/timezone:ro - /etc/localtime:/etc/localtime:ro depends_on: - gitea_db gitea_db: image: jc21/mariadb-aria:latest container_name: gitea_db command: ["--innodb-buffer-pool-size=256M"] environment: - MYSQL_ROOT_PASSWORD=REDACTED - MYSQL_USER=InfinityMonster - MYSQL_PASSWORD=REDACTED - MYSQL_DATABASE=gitea networks: - webproxy volumes: - gitea_db_data:/var/lib/mysql networks: webproxy: external: true volumes: gitea_data: gitea_db_data: ``` ### Gitea Version latest ### Can you reproduce the bug on the Gitea demo site? No ### Log Gist _No response_ ### Screenshots ![chrome_YDA2EbxdL3](https://github.com/go-gitea/gitea/assets/94435104/eea0ac06-3481-41da-87f4-e628b559d9bb) ### Git Version 2.30.2 ### Operating System Debian 11 / Windows 10 ### How are you running Gitea? Via Docker image ### Database MySQL/MariaDB
GiteaMirror added the type/bug label 2025-11-02 09:44:57 -06:00
GiteaMirror commented 2025-11-02 09:44:58 -06:00
Author
Owner
Copy Link

@wxiaoguang commented on GitHub (Sep 22, 2023):

You are using jc21/mariadb-aria which doesn't have InnoDB engine.

Why not use a general and official image?

@wxiaoguang commented on GitHub (Sep 22, 2023): You are using ` jc21/mariadb-aria` which doesn't have InnoDB engine. Why not use a general and official image?
GiteaMirror commented 2025-11-02 09:44:59 -06:00
Author
Owner
Copy Link

@FuckingToasters commented on GitHub (Sep 22, 2023):

You are using jc21/mariadb-aria which doesn't have InnoDB engine.

Why not use a general and official image?

well when i was new to docker and stuff like that (few days ago) i asked chatgtp to write me an compse file and it included this specific image so i went along with it, even i future containers i created. what image should i use instead?

@FuckingToasters commented on GitHub (Sep 22, 2023): > You are using ` jc21/mariadb-aria` which doesn't have InnoDB engine. > > Why not use a general and official image? well when i was new to docker and stuff like that (few days ago) i asked chatgtp to write me an compse file and it included this specific image so i went along with it, even i future containers i created. what image should i use instead?
GiteaMirror commented 2025-11-02 09:44:59 -06:00
Author
Owner
Copy Link

@wxiaoguang commented on GitHub (Sep 22, 2023):

image

@wxiaoguang commented on GitHub (Sep 22, 2023): ![image](https://github.com/go-gitea/gitea/assets/2114189/4f08448b-7685-4ef1-b984-1dc22f859cdc)
GiteaMirror commented 2025-11-02 09:44:59 -06:00
Author
Owner
Copy Link

@eeyrjmr commented on GitHub (Sep 22, 2023):

ChatGTP...

If you ask ChatGTP how long it will take to dry 9 towels if it takes 3hours to dry 3 ... it will reply 9hours with a logical (but wrong) reasoning

@eeyrjmr commented on GitHub (Sep 22, 2023): ChatGTP... If you ask ChatGTP how long it will take to dry 9 towels if it takes 3hours to dry 3 ... it will reply 9hours with a logical (but wrong) reasoning
GiteaMirror commented 2025-11-02 09:44:59 -06:00
Author
Owner
Copy Link

@wxiaoguang commented on GitHub (Sep 22, 2023):

The author asked about ChatGPT, so I showed how to use it to get an answer for "official image" 🤣

Generally, I also would suggest that do not trust ChatGPT too much, doing a google search and reading related documents are better.

@wxiaoguang commented on GitHub (Sep 22, 2023): The author asked about ChatGPT, so I showed how to use it to get an answer for "official image" 🤣 Generally, I also would suggest that do not trust ChatGPT too much, doing a google search and reading related documents are better.
GiteaMirror commented 2025-11-02 09:45:00 -06:00
Author
Owner
Copy Link

@FuckingToasters commented on GitHub (Sep 22, 2023):

The author asked about ChatGPT, so I showed how to use it to get an answer for "official image" 🤣

Generally, I also would suggest that do not trust ChatGPT too much, doing a google search and reading related documents are better.

yea using offical image seem to have worked. thx.

@FuckingToasters commented on GitHub (Sep 22, 2023): > The author asked about ChatGPT, so I showed how to use it to get an answer for "official image" 🤣 > > Generally, I also would suggest that do not trust ChatGPT too much, doing a google search and reading related documents are better. yea using offical image seem to have worked. thx.
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
$20
$250
$50
$500
backport/done
💎 Bounty
docs-update-needed
good first issue
hacktoberfest
issue/bounty
issue/confirmed
issue/critical
issue/duplicate
issue/needs-feedback
issue/not-a-bug
issue/regression
issue/stale
issue/workaround
lgtm/need 2
modifies/api
modifies/translation
outdated/backport/v1.18
outdated/theme/markdown
outdated/theme/timetracker
performance/bigrepo
performance/cpu
performance/memory
performance/speed
pr/breaking
proposal/accepted
proposal/rejected
pr/wip
pull-request
Mirrored from GitHub Pull Request
 reviewed/wontfix
💰 Rewarded
skip-changelog
status/blocked
topic/accessibility
topic/api
topic/authentication
topic/build
topic/code-linting
topic/commit-signing
topic/content-rendering
topic/deployment
topic/distribution
topic/federation
topic/gitea-actions
topic/issues
topic/lfs
topic/mobile
topic/moderation
topic/packages
topic/pr
topic/projects
topic/repo
topic/repo-migration
topic/security
topic/theme
topic/ui
topic/ui-interaction
topic/ux
topic/webhooks
topic/wiki
type/bug
type/deprecation
type/docs
type/enhancement
type/feature
type/miscellaneous
type/proposal
type/question
type/refactoring
type/summary
type/testing
type/upstream
No Label type/bug
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
GiteaMirror ninjasurge
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/gitea#11697
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?