starred/BookStack
1
0
Fork 0
mirror of https://github.com/BookStackApp/BookStack.git synced 2026-05-04 18:08:46 +03:00
Code Issues 784 Packages Projects Releases 15 Wiki Activity

Error on initial Bookstack App Setup using Docker Image on Azure (Multiple primary key defined (SQL: alter table role_user add primary key (user_id, role_id))) #4313

New Issue
Closed
opened 2026-02-05 08:30:47 +03:00 by OVERLORD · 3 comments
OVERLORD commented 2026-02-05 08:30:47 +03:00
Owner
Copy Link

Originally created by @Cobajar on GitHub (Nov 10, 2023).

Describe the Bug

I deployed bookstack as an Azure Web App, the image is pulled from Docker Hub (
linuxserver/bookstack:version-v23.10).

Azure MySql Flexible Server is used as the database, the Bookstack data is stored in a storage account and integrated as volume mapping.

So far so good, I designed this to work wonderfully for a PoC about half a year / year ago, but I now get the following error during the initial deployment:

Waiting for DB to be available

   INFO  Preparing database.  

  Creating migration table ......................................... 89ms DONE

   INFO  Running migrations.  

  2014_10_12_000000_create_users_table ............................ 320ms DONE
  2014_10_12_100000_create_password_resets_table .................. 157ms DONE
  2015_07_12_114933_create_books_table ............................. 63ms DONE
  2015_07_12_190027_create_pages_table ............................. 64ms DONE
  2015_07_13_172121_create_images_table ............................ 63ms DONE
  2015_07_27_172342_create_chapters_table .......................... 70ms DONE
  2015_08_08_200447_add_users_to_entities ......................... 134ms DONE
  2015_08_09_093534_create_page_revisions_table .................... 83ms DONE
  2015_08_16_142133_create_activities_table ........................ 67ms DONE
  2015_08_29_105422_add_roles_and_permissions ..................... 549ms FAIL

   Illuminate\Database\QueryException 

  SQLSTATE[42000]: Syntax error or access violation: 1068 Multiple primary key defined (SQL: alter table `role_user` add primary key (`user_id`, `role_id`))

  at /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760
    756â–•         // If an exception occurs when attempting to run a query, we'll format the error
    757â–•         // message to include the bindings with SQL, which will make this exception a
    758â–•         // lot more helpful to the developer instead of just the database's errors.
    759â–•         catch (Exception $e) {
  ➜ 760▕             throw new QueryException(
    761â–•                 $query, $this->prepareBindings($bindings), $e
    762â–•             );
    763â–•         }
    764â–•     }

      [2m+9 vendor frames [22m
  10  /app/www/database/migrations/2015_08_29_105422_add_roles_and_permissions.php:35
      Illuminate\Support\Facades\Facade::__callStatic()

      [2m+25 vendor frames [22m
  36  /app/www/artisan:35
      Illuminate\Foundation\Console\Kernel::handle()
[custom-init] No custom files found, skipping...
[ls.io-init] done.

I have also tested an older version (linuxserver/bookstack:version-v23.08.1), same issue.

Steps to Reproduce

This is a proof of concept, so we dont use private endpoints etc.

Create Azure Resources

  1. Create a Flexible Azure Database for MySQL (B1ms, MySQLVersion: 8.0, MySQL-Authentication)
  2. Create a Storage Account and Fileshare named "config"
  3. Create a Azure Web App (B1 Plan)

The following Configuration Parameters are used:

PUID=1000
PGID=1000
APP_URL=https://<nameofmybookstackapp>.azurewebsites.net
DB_HOST=<nameofmysql>.mysql.database.azure.com
DB_PORT=3306
DB_USER=<mysqladmin>
DB_PASS=<mysqlpasswd>
DB_DATABASE=bookstack
WEBSITES_CONTAINER_START_TIME_LIMIT=300
MYSQL_ATTR_SSL_CA=/config/DigiCertGlobalRootCA.crt.pem

The following path mappings are used:
/config is mapped to the fileshare "config" on the storage account

Dont forget to upload the CA-certificate from Azure Database (Flexible Server). Alternatively "require-secure-transport" can be disabled on the mysql server side.

We often provide various apps as an app service, we know that this can sometimes be a bit tricky. In this case I would need support for Bookstack.

Let me know, if there is any assistance needed in reproducing the issue.

Expected Behaviour

Database migration runs without any problems

Screenshots or Additional Context

No response

Browser Details

No response

Exact BookStack Version

linuxserver/bookstack:version-v23.10

Originally created by @Cobajar on GitHub (Nov 10, 2023). ### Describe the Bug I deployed bookstack as an Azure Web App, the image is pulled from Docker Hub ( linuxserver/bookstack:version-v23.10). Azure MySql Flexible Server is used as the database, the Bookstack data is stored in a storage account and integrated as volume mapping. So far so good, I designed this to work wonderfully for a PoC about half a year / year ago, but I now get the following error during the initial deployment: ``` Waiting for DB to be available INFO Preparing database. Creating migration table ......................................... 89ms DONE INFO Running migrations. 2014_10_12_000000_create_users_table ............................ 320ms DONE 2014_10_12_100000_create_password_resets_table .................. 157ms DONE 2015_07_12_114933_create_books_table ............................. 63ms DONE 2015_07_12_190027_create_pages_table ............................. 64ms DONE 2015_07_13_172121_create_images_table ............................ 63ms DONE 2015_07_27_172342_create_chapters_table .......................... 70ms DONE 2015_08_08_200447_add_users_to_entities ......................... 134ms DONE 2015_08_09_093534_create_page_revisions_table .................... 83ms DONE 2015_08_16_142133_create_activities_table ........................ 67ms DONE 2015_08_29_105422_add_roles_and_permissions ..................... 549ms FAIL Illuminate\Database\QueryException SQLSTATE[42000]: Syntax error or access violation: 1068 Multiple primary key defined (SQL: alter table `role_user` add primary key (`user_id`, `role_id`)) at /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760 756▕ // If an exception occurs when attempting to run a query, we'll format the error 757▕ // message to include the bindings with SQL, which will make this exception a 758▕ // lot more helpful to the developer instead of just the database's errors. 759▕ catch (Exception $e) { ➜ 760▕ throw new QueryException( 761▕ $query, $this->prepareBindings($bindings), $e 762▕ ); 763▕ } 764▕ } [2m+9 vendor frames [22m 10 /app/www/database/migrations/2015_08_29_105422_add_roles_and_permissions.php:35 Illuminate\Support\Facades\Facade::__callStatic() [2m+25 vendor frames [22m 36 /app/www/artisan:35 Illuminate\Foundation\Console\Kernel::handle() [custom-init] No custom files found, skipping... [ls.io-init] done. ``` I have also tested an older version (linuxserver/bookstack:version-v23.08.1), same issue. ### Steps to Reproduce This is a proof of concept, so we dont use private endpoints etc. **Create Azure Resources** 1. Create a Flexible Azure Database for MySQL (B1ms, MySQLVersion: 8.0, MySQL-Authentication) 2. Create a Storage Account and Fileshare named "config" 3. Create a Azure Web App (B1 Plan) **The following Configuration Parameters are used:** ``` PUID=1000 PGID=1000 APP_URL=https://<nameofmybookstackapp>.azurewebsites.net DB_HOST=<nameofmysql>.mysql.database.azure.com DB_PORT=3306 DB_USER=<mysqladmin> DB_PASS=<mysqlpasswd> DB_DATABASE=bookstack WEBSITES_CONTAINER_START_TIME_LIMIT=300 MYSQL_ATTR_SSL_CA=/config/DigiCertGlobalRootCA.crt.pem ``` **The following path mappings are used:** /config is mapped to the fileshare "config" on the storage account Dont forget to upload the CA-certificate from Azure Database (Flexible Server). Alternatively "require-secure-transport" can be disabled on the mysql server side. We often provide various apps as an app service, we know that this can sometimes be a bit tricky. In this case I would need support for Bookstack. Let me know, if there is any assistance needed in reproducing the issue. ### Expected Behaviour Database migration runs without any problems ### Screenshots or Additional Context _No response_ ### Browser Details _No response_ ### Exact BookStack Version linuxserver/bookstack:version-v23.10
OVERLORD added the 🐛 Bug label 2026-02-05 08:30:47 +03:00
OVERLORD commented 2026-02-05 08:30:56 +03:00
Author
Owner
Copy Link

@ssddanbrown commented on GitHub (Nov 10, 2023):

Hi @Cobajar,
This may be due to Azure using an unexpected default.

Try following the answer on this post:
https://drupal.stackexchange.com/questions/316995/multiple-primary-key-defined-when-importing-db-to-dev

Start from an empty/fresh database instance, rather than attempt from the current migrated database state.

@ssddanbrown commented on GitHub (Nov 10, 2023): Hi @Cobajar, This may be due to Azure using an unexpected default. Try following the answer on this post: https://drupal.stackexchange.com/questions/316995/multiple-primary-key-defined-when-importing-db-to-dev Start from an empty/fresh database instance, rather than attempt from the current migrated database state.
OVERLORD commented 2026-02-05 08:30:58 +03:00
Author
Owner
Copy Link

@Cobajar commented on GitHub (Nov 11, 2023):

Setting "sql_generate_invisible_primary_key" to OFF did the trick! Thank you very much!

@Cobajar commented on GitHub (Nov 11, 2023): Setting "sql_generate_invisible_primary_key" to OFF did the trick! Thank you very much!
OVERLORD commented 2026-02-05 08:30:59 +03:00
Author
Owner
Copy Link

@ssddanbrown commented on GitHub (Nov 12, 2023):

Good to hear that sorted things! I'll therefore close this off.

@ssddanbrown commented on GitHub (Nov 12, 2023): Good to hear that sorted things! I'll therefore close this off.
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
🎨 Design
📖 Docs Update
🐛 Bug
🐛 Bug
:cat2:🐈 Possible duplicate
💿 Database
☕ Open to discussion
💻 Front-End
🐕 Support
🚪 Authentication
🌍 Translations
🔌 API Task
🏭 Back-End
⛲ Upstream
🔨 Feature Request
🛠️ Enhancement
🛠️ Enhancement
🛠️ Enhancement
❤️ Happy feedback
🔒 Security
🔍 Pending Validation
💆 UX
📝 WYSIWYG Editor
🌔 Out of scope
🔩 API Request
:octocat: Admin/Meta
🖌️ View Customization
❓ Question
🚀 Priority
🛡️ Blocked
🚚 Export System
♿ A11y
🔧 Maintenance
> Markdown Editor
pull-request
Mirrored from GitHub Pull Request
No Label 🐛 Bug
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
OVERLORD
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/BookStack#4313
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?