Undefined table: 7 ERROR: relation "audit_log_entries" #7330

carsonbird · 2023-04-05T02:53:54Z

carsonbird
Apr 5, 2023

Support guidelines

I've read the support guidelines

I've found a bug and checked that ...

... the documentation does not mention anything about my problem
... there are no open or closed issues that are related to my problem
... it's definitely a Firefly III issue, not me

Description

Something about my database seems to have been compromised. When I attempt to access transactions (and sometimes, other things), I get database errors. In this case, it appears the audit_log_entries table doesn't exist.

Now, for some background: I'm running firefly in a Docker container behind a Traefik reverse proxy, with an external postgres DB (in an adjacent docker container). As far as I can tell, everything with the networking is working fine. I can access Firefly and authenticate not problem.

Now, this postgres database was originally created on Heroku, then dumped and used in a HomelabOS deployment, and now, I'm running in it my own deployment. Each time, I just copied and pasted the database files from server to server. The issues started happening while on the HomelabOS server, and possibly coincided with a Firefly version change. The docker container is running v6.0.6, but I began using Firefly probably 2 years ago, so there have been many version changes since.

Any thoughts? I'm open to anything. Ideally, I get to keep my existing transaction history. Thanks!

Debug information

Debug information generated at 2023-04-04 00:00:00 America/Denver for Firefly III version 6.0.6.

Scope	Version
Firefly III	6.0.6
Firefly III API	2.0.1
Build	441, 01-04-2023 08:04:21 CEST
DB version	19 (exp. 19)
PHP	`8.2.4`
Host	`Linux`

System info	Value
System TZ	America/Denver
Browser TZ	America/Denver
App environment	heroku
App debug mode	false
App cache driver	file
App logging	info, stack
Display errors	Off
Error reporting	ALL errors
Max upload	67108864 (64 MB)
Interface	apache2handler
Default language	en_US
Default locale	equal
BCscale	12
DB drivers	mysql, pgsql, sqlite
Current driver	pgsql
Trusted proxies (.env)	`**`

User info	Value
Login provider	eloquent
User guard	web
Headers	N/A, N/A
Stateful domains
Session start	2023-03-01 00:00:00
Session end	2023-03-31 00:00:00
Session first	2020-03-01 00:00:00
User ID	1
User language	en_US
User locale	en_US
Attempt at "en_US.utf8"	'en_US.utf8'
Attempt at "en_US.UTF-8"	'en_US.UTF-8'
User agent	Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36

Expected behaviour

No response

Steps to reproduce

No response

Additional info

The follow is thrown when the error occurs.

SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "audit_log_entries" does not exist LINE 1: select * from "audit_log_entries" where "auditable_id" = $1 ... ^ (Connection: pgsql, SQL: select * from "audit_log_entries" where "auditable_id" = 2558 and "auditable_type" = FireflyIII\Models\TransactionJournal and "audit_log_entries"."deleted_at" is null)

JC5 · 2023-04-05T03:29:22Z

JC5
Apr 5, 2023
Maintainer

Every time the Firefly III container starts it will try to upgrade the database. What are the logs?

3 replies

carsonbird Apr 6, 2023
Author

Hey!! Thanks so much for your interest! The logs just output what I posted above, along with a stack trace:

[2023-04-05 20:16:20] heroku.ERROR: Exception is: {"class":"Illuminate\Database\QueryException","errorMessage":"SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "audit_log_entries" does not exist\nLINE 1: select * from "audit_log_entries" where "auditable_id" = $1 ...\n ^ (Connection: pgsql, SQL: select * from "audit_log_entries" where "auditable_id" = 2588 and "auditable_type" = FireflyIII\Models\TransactionJournal and "audit_log_entries"."deleted_at" is null)","time":"Wed, 05 Apr 2023 20:16:20 -0600","file":"/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php","line":793,"code":"42P01","version":"6.0.6","url":"https:///transactions/show/2584","userAgent":"Mozilla/5.0 (Linux; Android 12) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Mobile Safari/537.36","json":true,"method":"GET"}
[2023-04-05 20:16:20] heroku.ERROR: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "audit_log_entries" does not exist
LINE 1: select * from "audit_log_entries" where "auditable_id" = $1 ...
^ (Connection: pgsql, SQL: select * from "audit_log_entries" where "auditable_id" = 2588 and "auditable_type" = FireflyIII\Models\TransactionJournal and "audit_log_entries"."deleted_at" is null) {"userId":1,"exception":"[object] (Illuminate\Database\QueryException(code: 42P01): SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "audit_log_entries" does not exist
LINE 1: select * from "audit_log_entries" where "auditable_id" = $1 ...
^ (Connection: pgsql, SQL: select * from "audit_log_entries" where "auditable_id" = 2588 and "auditable_type" = FireflyIII\Models\TransactionJournal and "audit_log_entries"."deleted_at" is null) at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:793)
�
[stacktrace]

JC5 Apr 6, 2023
Maintainer

Every time the Firefly III container starts it will try to upgrade the database. What are the logs DURING START UP?

carsonbird Apr 6, 2023
Author

😬 Oh, right.

Now in entrypoint.sh for Firefly III
Script:       1.0.21 (2022-02-17)
User:         'root'
Group:        'root'
Working dir:  '/var/www/html'
Build number:  441
Build date:    01-04-2023 08:04:21 CEST
Now parsing _FILE variables.
done!
Touch DB file (if SQLite)...
Dump auto load...
Generating optimized autoload files
> Illuminate\Foundation\ComposerScripts::postAutoloadDump
Generated optimized autoload files containing 6295 classes
Discover packages...
   INFO  Discovering packages.  
  diglactic/laravel-breadcrumbs ......................................... DONE
  jc5/google2fa-laravel ................................................. DONE
  laravel/passport ...................................................... DONE
  laravel/sanctum ....................................................... DONE
  laravel/slack-notification-channel .................................... DONE
  laravel/ui ............................................................ DONE
  laravelcollective/html ................................................ DONE
  nesbot/carbon ......................................................... DONE
  nunomaduro/collision .................................................. DONE
  nunomaduro/termwind ................................................... DONE
  rcrowe/twigbridge ..................................................... DONE
  spatie/laravel-ignition ............................................... DONE
  therobfonz/laravel-mandrill-driver .................................... DONE
Current working dir is '/var/www/html'
Wait for the database.
wait-for-it.sh: waiting 60 seconds for fireflyiii-db:5432
wait-for-it.sh: fireflyiii-db:5432 is available after 0 seconds
�
.
Wait another 5 seconds in case the DB needs to boot.
Done waiting for the DB to boot.
Will not build the locales...
Run various artisan commands...
Running migration commands...
CreateDB does not apply to "pgsql", skipped.
   INFO  Running migrations.  
  2021_05_09_064644_add_ldap_columns_to_users_table ................. 4ms FAIL
[2023-04-04 21:00:14] heroku.ERROR: Exception is: {"class":"Illuminate\\Database\\QueryException","errorMessage":"SQLSTATE[42701]: Duplicate column: 7 ERROR:  column \"domain\" of relation \"users\" already exists (Connection: pgsql, SQL: alter table \"users\" add column \"domain\" varchar(191) null)","time":"Tue, 04 Apr 2023 21:00:14 -0600","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Database\/Connection.php","line":793,"code":"42701","version":"6.0.6","url":"https:\/\/{{MY_URL}}","userAgent":"Symfony","json":true,"method":"GET"}  
[2023-04-04 21:00:14] heroku.ERROR: SQLSTATE[42701]: Duplicate column: 7 ERROR:  column "domain" of relation "users" already exists (Connection: pgsql, SQL: alter table "users" add column "domain" varchar(191) null) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42701): SQLSTATE[42701]: Duplicate column: 7 ERROR:  column \"domain\" of relation \"users\" already exists (Connection: pgsql, SQL: alter table \"users\" add column \"domain\" varchar(191) null) at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:793)
�
[stacktrace]

and then further down

[previous exception] [object] (PDOException(code: 42701): SQLSTATE[42701]: Duplicate column: 7 ERROR:  column \"domain\" of relation \"users\" already exists at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:578)
�
[stacktrace]

and then

   Illuminate\Database\QueryException 
  SQLSTATE[42701]: Duplicate column: 7 ERROR:  column "domain" of relation "users" already exists (Connection: pgsql, SQL: alter table "users" add column "domain" varchar(191) null)
  at vendor/laravel/framework/src/Illuminate/Database/Connection.php:793
    789▕         // If an exception occurs when attempting to run a query, we'll format the error
    790▕         // message to include the bindings with SQL, which will make this exception a
    791▕         // lot more helpful to the developer instead of just the database's errors.
    792▕         catch (Exception $e) {
  ➜ 793▕             throw new QueryException(
    794▕                 $this->getName(), $query, $this->prepareBindings($bindings), $e
    795▕             );
    796▕         }
    797▕     }
      +9 vendor frames 
  10  database/migrations/2021_05_09_064644_add_ldap_columns_to_users_table.php:49
      Illuminate\Support\Facades\Facade::__callStatic()
      +25 vendor frames 
  36  artisan:35
      Illuminate\Foundation\Console\Kernel::handle()
Going to decrypt the database.
No decryption required for table "accounts".
No decryption required for table "attachments".
No decryption required for table "bills".
No decryption required for table "budgets".
No decryption required for table "categories".
No decryption required for table "piggy_banks".
No decryption required for table "preferences".
No decryption required for table "tags".
No decryption required for table "transaction_journals".
No decryption required for table "transactions".
No decryption required for table "journal_links".
Done!
Current working dir is '/var/www/html'
Going to verify PostgreSQL table sequences.
Checking the next id sequence for table "2fa_tokens".
nextval is NULL for table "2fa_tokens", go to next table.
Checking the next id sequence for table "account_meta".
Table "account_meta" autoincrement is correct.
Checking the next id sequence for table "account_types".
Table "account_types" autoincrement is correct.
Checking the next id sequence for table "accounts".
Table "accounts" autoincrement is correct.
Checking the next id sequence for table "attachments".
nextval is NULL for table "attachments", go to next table.
Checking the next id sequence for table "auto_budgets".
Table "auto_budgets" autoincrement is correct.
Checking the next id sequence for table "available_budgets".
Table "available_budgets" autoincrement is correct.
Checking the next id sequence for table "bills".
Table "bills" autoincrement is correct.
Checking the next id sequence for table "budget_limits".
Table "budget_limits" autoincrement is correct.
Checking the next id sequence for table "budget_transaction".
nextval is NULL for table "budget_transaction", go to next table.
Checking the next id sequence for table "budget_transaction_journal".
Table "budget_transaction_journal" autoincrement is correct.
Checking the next id sequence for table "budgets".
Table "budgets" autoincrement is correct.
Checking the next id sequence for table "categories".
Table "categories" autoincrement is correct.
Checking the next id sequence for table "category_transaction".
nextval is NULL for table "category_transaction", go to next table.
Checking the next id sequence for table "category_transaction_journal".
Table "category_transaction_journal" autoincrement is correct.
Checking the next id sequence for table "configuration".
Table "configuration" autoincrement is correct.
Checking the next id sequence for table "currency_exchange_rates".
nextval is NULL for table "currency_exchange_rates", go to next table.
Checking the next id sequence for table "export_jobs".
nextval is NULL for table "export_jobs", go to next table.
Checking the next id sequence for table "failed_jobs".
nextval is NULL for table "failed_jobs", go to next table.
Checking the next id sequence for table "group_journals".
nextval is NULL for table "group_journals", go to next table.
Checking the next id sequence for table "import_jobs".
nextval is NULL for table "import_jobs", go to next table.
Checking the next id sequence for table "jobs".
nextval is NULL for table "jobs", go to next table.
Checking the next id sequence for table "journal_links".
nextval is NULL for table "journal_links", go to next table.
Checking the next id sequence for table "journal_meta".
Table "journal_meta" autoincrement is correct.
Checking the next id sequence for table "limit_repetitions".
nextval is NULL for table "limit_repetitions", go to next table.
Checking the next id sequence for table "link_types".
Table "link_types" autoincrement is correct.
Checking the next id sequence for table "locations".
nextval is NULL for table "locations", go to next table.
Checking the next id sequence for table "migrations".
Table "migrations" autoincrement is correct.
Checking the next id sequence for table "notes".
Table "notes" autoincrement is correct.
Checking the next id sequence for table "oauth_clients".
Table "oauth_clients" autoincrement is correct.
Checking the next id sequence for table "oauth_personal_access_clients".
Table "oauth_personal_access_clients" autoincrement is correct.
Checking the next id sequence for table "object_groups".
nextval is NULL for table "object_groups", go to next table.
Checking the next id sequence for table "permissions".
nextval is NULL for table "permissions", go to next table.
Checking the next id sequence for table "piggy_bank_events".
nextval is NULL for table "piggy_bank_events", go to next table.
Checking the next id sequence for table "piggy_bank_repetitions".
nextval is NULL for table "piggy_bank_repetitions", go to next table.
Checking the next id sequence for table "piggy_banks".
nextval is NULL for table "piggy_banks", go to next table.
Checking the next id sequence for table "preferences".
Table "preferences" autoincrement is correct.
Checking the next id sequence for table "recurrences".
Table "recurrences" autoincrement is correct.
Checking the next id sequence for table "recurrences_meta".
nextval is NULL for table "recurrences_meta", go to next table.
Checking the next id sequence for table "recurrences_repetitions".
Table "recurrences_repetitions" autoincrement is correct.
Checking the next id sequence for table "recurrences_transactions".
Table "recurrences_transactions" autoincrement is correct.
Checking the next id sequence for table "roles".
Table "roles" autoincrement is correct.
Checking the next id sequence for table "rt_meta".
Table "rt_meta" autoincrement is correct.
Checking the next id sequence for table "rule_actions".
Table "rule_actions" autoincrement is correct.
Checking the next id sequence for table "rule_groups".
Table "rule_groups" autoincrement is correct.
Checking the next id sequence for table "rule_triggers".
Table "rule_triggers" autoincrement is correct.
Checking the next id sequence for table "rules".
Table "rules" autoincrement is correct.
Checking the next id sequence for table "tag_transaction_journal".
Table "tag_transaction_journal" autoincrement is correct.
Checking the next id sequence for table "tags".
Table "tags" autoincrement is correct.
Checking the next id sequence for table "transaction_currencies".
Table "transaction_currencies" autoincrement is correct.
Checking the next id sequence for table "transaction_groups".
Table "transaction_groups" autoincrement is correct.
Checking the next id sequence for table "transaction_journals".
Table "transaction_journals" autoincrement is correct.
Checking the next id sequence for table "transaction_types".
Table "transaction_types" autoincrement is correct.
Checking the next id sequence for table "transactions".
Table "transactions" autoincrement is correct.
Checking the next id sequence for table "users".
Table "users" autoincrement is correct.
Checking the next id sequence for table "webhook_attempts".
nextval is NULL for table "webhook_attempts", go to next table.
Checking the next id sequence for table "webhook_messages".
nextval is NULL for table "webhook_messages", go to next table.
Checking the next id sequence for table "webhooks".
nextval is NULL for table "webhooks", go to next table.
Running upgrade commands...
This command has already been executed.
Database already seems to be migrated.
This command has already been executed.
This command has already been executed.
This command has already been executed.
This command has already been executed.
This command has already been executed.
This command has already been executed.
This command has already been executed.
No incorrectly stored credit card liabilities.
This command has already been executed.
This command has already been executed.
This command has already been executed.
This command has already been executed.
This command has already been executed.
This command has already been executed.
This command has already been executed.
Running verification commands...
All piggy bank events are correct.
Verified the content of 0 piggy bank events in 0.01 seconds.
All link types OK!
Verified link types in 0.02 seconds
All access tokens OK!
Verify access tokens in 0.02 seconds.
All transaction journals have correct bill information.
Verified bills / journals in 0.02 seconds
All budget limits are OK.
2 different currencies are currently in use.
All currencies are correctly enabled or disabled.
Verified currencies in 0.03 seconds.
No invalid budget/journal entries.
Verified budget/journals in 0.02 seconds.
Amount integrity OK!
Verified amount integrity in 0.01 seconds
No zero-amount transaction journals.
Verified zero-amount integrity in 0.02 seconds
No orphaned journals.
No orphaned transactions.
No orphaned accounts.
Verified orphans in 0.02 seconds
No uneven transaction journals.
No empty transaction journals.
Verified empty journals in 0 seconds
Verified empty groups in 0.02 seconds
All account types are OK!
Verifying account types took 4.07 seconds
Verifying account order took 0.02 seconds
All meta fields are correct.
Renamed meta fields in 0.02 seconds
Going to verify 5 opening balance transactions.
There was nothing to fix in the opening balance transactions.
Verified all transaction group and journal title lengths.
Took 0.04 seconds.
Corrected recurring transactions in 0.06 seconds.
Updated inconsistent transaction groups.
All transaction journals are of the correct transaction type (in 0.23 seconds).
Verifying account preferences took 0.03 seconds
Validated group memberships in 0.02 seconds.
Could not update group information for "FireflyIII\Models\Account" because of error "SQLSTATE[42703]: Undefined column: 7 ERROR:  column "user_group_id" does not exist
LINE 1: ... = $1, "updated_at" = $2 where "user_id" = $3 and "user_grou...
                                                             ^ (Connection: pgsql, SQL: update "accounts" set "user_group_id" = 1, "updated_at" = 2023-04-04 21:00:26 where "user_id" = 1 and "user_group_id" is null and "accounts"."deleted_at" is null)"
Could not update group information for "FireflyIII\Models\Attachment" because of error "SQLSTATE[42703]: Undefined column: 7 ERROR:  column "user_group_id" does not exist
LINE 1: ... = $1, "updated_at" = $2 where "user_id" = $3 and "user_grou...
                                                             ^ (Connection: pgsql, SQL: update "attachments" set "user_group_id" = 1, "updated_at" = 2023-04-04 21:00:26 where "user_id" = 1 and "user_group_id" is null and "attachments"."deleted_at" is null)"
Could not update group information for "FireflyIII\Models\AvailableBudget" because of error "SQLSTATE[42703]: Undefined column: 7 ERROR:  column "user_group_id" does not exist
LINE 1: ... = $1, "updated_at" = $2 where "user_id" = $3 and "user_grou...
                                                             ^ (Connection: pgsql, SQL: update "available_budgets" set "user_group_id" = 1, "updated_at" = 2023-04-04 21:00:26 where "user_id" = 1 and "user_group_id" is null and "available_budgets"."deleted_at" is null)"
Could not update group information for "FireflyIII\Models\Bill" because of error "SQLSTATE[42703]: Undefined column: 7 ERROR:  column "user_group_id" does not exist
LINE 1: ... = $1, "updated_at" = $2 where "user_id" = $3 and "user_grou...
                                                             ^ (Connection: pgsql, SQL: update "bills" set "user_group_id" = 1, "updated_at" = 2023-04-04 21:00:26 where "user_id" = 1 and "user_group_id" is null and "bills"."deleted_at" is null)"
Could not update group information for "FireflyIII\Models\Budget" because of error "SQLSTATE[42703]: Undefined column: 7 ERROR:  column "user_group_id" does not exist
LINE 1: ... = $1, "updated_at" = $2 where "user_id" = $3 and "user_grou...
                                                             ^ (Connection: pgsql, SQL: update "budgets" set "user_group_id" = 1, "updated_at" = 2023-04-04 21:00:26 where "user_id" = 1 and "user_group_id" is null and "budgets"."deleted_at" is null)"
Could not update group information for "FireflyIII\Models\Category" because of error "SQLSTATE[42703]: Undefined column: 7 ERROR:  column "user_group_id" does not exist
LINE 1: ... = $1, "updated_at" = $2 where "user_id" = $3 and "user_grou...
                                                             ^ (Connection: pgsql, SQL: update "categories" set "user_group_id" = 1, "updated_at" = 2023-04-04 21:00:26 where "user_id" = 1 and "user_group_id" is null and "categories"."deleted_at" is null)"
Could not update group information for "FireflyIII\Models\CurrencyExchangeRate" because of error "SQLSTATE[42703]: Undefined column: 7 ERROR:  column "user_group_id" does not exist
LINE 1: ... = $1, "updated_at" = $2 where "user_id" = $3 and "user_grou...
                                                             ^ (Connection: pgsql, SQL: update "currency_exchange_rates" set "user_group_id" = 1, "updated_at" = 2023-04-04 21:00:26 where "user_id" = 1 and "user_group_id" is null)"
Could not update group information for "FireflyIII\Models\Recurrence" because of error "SQLSTATE[42703]: Undefined column: 7 ERROR:  column "user_group_id" does not exist
LINE 1: ... = $1, "updated_at" = $2 where "user_id" = $3 and "user_grou...
                                                             ^ (Connection: pgsql, SQL: update "recurrences" set "user_group_id" = 1, "updated_at" = 2023-04-04 21:00:26 where "user_id" = 1 and "user_group_id" is null and "recurrences"."deleted_at" is null)"
Could not update group information for "FireflyIII\Models\RuleGroup" because of error "SQLSTATE[42703]: Undefined column: 7 ERROR:  column "user_group_id" does not exist
LINE 1: ... = $1, "updated_at" = $2 where "user_id" = $3 and "user_grou...
                                                             ^ (Connection: pgsql, SQL: update "rule_groups" set "user_group_id" = 1, "updated_at" = 2023-04-04 21:00:26 where "user_id" = 1 and "user_group_id" is null and "rule_groups"."deleted_at" is null)"
Could not update group information for "FireflyIII\Models\Rule" because of error "SQLSTATE[42703]: Undefined column: 7 ERROR:  column "user_group_id" does not exist
LINE 1: ... = $1, "updated_at" = $2 where "user_id" = $3 and "user_grou...
                                                             ^
HINT:  Perhaps you meant to reference the column "rules.rule_group_id". (Connection: pgsql, SQL: update "rules" set "user_group_id" = 1, "updated_at" = 2023-04-04 21:00:26 where "user_id" = 1 and "user_group_id" is null and "rules"."deleted_at" is null)"
Could not update group information for "FireflyIII\Models\Tag" because of error "SQLSTATE[42703]: Undefined column: 7 ERROR:  column "user_group_id" does not exist
LINE 1: ... = $1, "updated_at" = $2 where "user_id" = $3 and "user_grou...
                                                             ^ (Connection: pgsql, SQL: update "tags" set "user_group_id" = 1, "updated_at" = 2023-04-04 21:00:26 where "user_id" = 1 and "user_group_id" is null and "tags"."deleted_at" is null)"
Could not update group information for "FireflyIII\Models\TransactionGroup" because of error "SQLSTATE[42703]: Undefined column: 7 ERROR:  column "user_group_id" does not exist
LINE 1: ... = $1, "updated_at" = $2 where "user_id" = $3 and "user_grou...
                                                             ^ (Connection: pgsql, SQL: update "transaction_groups" set "user_group_id" = 1, "updated_at" = 2023-04-04 21:00:26 where "user_id" = 1 and "user_group_id" is null and "transaction_groups"."deleted_at" is null)"
Could not update group information for "FireflyIII\Models\TransactionJournal" because of error "SQLSTATE[42703]: Undefined column: 7 ERROR:  column "user_group_id" does not exist
LINE 1: ... = $1, "updated_at" = $2 where "user_id" = $3 and "user_grou...
                                                             ^ (Connection: pgsql, SQL: update "transaction_journals" set "user_group_id" = 1, "updated_at" = 2023-04-04 21:00:26 where "user_id" = 1 and "user_group_id" is null and "transaction_journals"."deleted_at" is null)"
Running report commands...
User #1 ({{USER}}) has tag #1 ("Unplanned") which has no transaction journals.
User #1 ({{USER}}) has tag #3 ("Necessity") which has no transaction journals.
User #1 ({{USER}}) has tag #4 ("Fixed Expense") which has no transaction journals.
User #1 ({{USER}}) has tag #7 ("Personal Income") which has no transaction journals.
User #1 ({{USER}}) has account #390 ("Vanessa Manuel") which has no transactions.
User #1 ({{USER}}) has account #427 ("49.60") which has no transactions.
Report on empty objects finished in 0.02 seconds
Amount integrity OK for user #1
Report on total sum finished in 0.02 seconds
Restored OAuth keys from database.
Generating new OAuth keys...
Encryption keys already exist. Use the --force option to overwrite them.
Personal access client created successfully.
Client ID: 173
Client secret: {{SECRET}}
Password grant client created successfully.
Client ID: 174
Client secret: {{SECRET}}
Updated version.
+------------------------------------------------------------------------------+
|                                                                              |
| Thank you for installing Firefly III, v6.0.6!                                |
|                                                                              |
|                                                                              |
+------------------------------------------------------------------------------+
You can safely ignore the error about the 'fully qualified domain name'.
AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.16.38.3. Set the 'ServerName' directive globally to suppress this message
AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.16.38.3. Set the 'ServerName' directive globally to suppress this message
[Tue Apr 04 21:00:28.216931 2023] [mpm_prefork:notice] [pid 1] AH00163: Apache/2.4.56 (Debian) configured -- resuming normal operations
[Tue Apr 04 21:00:28.216976 2023] [core:notice] [pid 1] AH00094: Command line: 'apache2 -D FOREGROUND'

JC5 · 2023-04-07T15:46:45Z

JC5
Apr 7, 2023
Maintainer

Mmmm. At some point migrations broke or failed. I'm not sure I can fix that right now, but I'm working on more error-proof database migrations. Stay tuned.

6 replies

JC5 Apr 8, 2023
Maintainer

In 6.0.7 the migrations are a little more robust, so that could work. Migrating in and out of Firefly III is the most easy to do through the database.

Make a backup, then try running the command php artisan firefly-iii:force-migration.

carsonbird Apr 9, 2023
Author

I get the following:

root@96ce967f4494:/var/www/html# php artisan firefly-iii:force-migration
[2023-04-09 17:34:04] heroku.ERROR: Invalid access token for user #1.  
[2023-04-09 17:34:04] heroku.ERROR: Token given is "", expected something else.  
Invalid access token.

JC5 Apr 10, 2023
Maintainer

Use the --token=abc from your profile page.

carsonbird Apr 10, 2023
Author

Oh, yup, I figured that out and ran it. The logs are below. I haven't had the same issue, but now anytime the database would be modified (creating a transaction, etc), I get an HTTP 500 error, and there are no container logs specifying why.

[2023-04-09T23:05:01.137283-06:00] local.INFO: AUDIT: User #1 ("${USER}") forced migrations. (127.0.0.1 -> GET:${URL}) [] []
Dropping "migrations" table...
Done!
Re-run all migrations...
[2023-04-09 23:05:03] local.ERROR: Could not execute query: SQLSTATE[42701]: Duplicate column: 7 ERROR:  column "identifier" of relation "transactions" already exists (Connection: pgsql, SQL: alter table "transactions" add column "identifier" smallint not null default '0')  
[2023-04-09 23:05:03] local.ERROR: If the column or index already exists (see error), this is not an problem. Otherwise, please open a GitHub discussion.  
[2023-04-09 23:05:03] local.ERROR: Could not create table "notes": SQLSTATE[42P07]: Duplicate table: 7 ERROR:  relation "notes" already exists (Connection: pgsql, SQL: create table "notes" ("id" serial not null primary key, "created_at" timestamp(0) without time zone null, "updated_at" timestamp(0) without time zone null, "deleted_at" timestamp(0) without time zone null, "noteable_id" integer not null, "noteable_type" varchar(191) not null, "title" varchar(191) null, "text" text null))  
[2023-04-09 23:05:03] local.ERROR: If this table exists already (see the error message), this is not a problem. Other errors? Please open a discussion on GitHub.  
[2023-04-09 23:05:03] local.ERROR: Could not execute query: SQLSTATE[42701]: Duplicate column: 7 ERROR:  column "deleted_at" of relation "journal_meta" already exists (Connection: pgsql, SQL: alter table "journal_meta" add column "deleted_at" timestamp(0) without time zone null)  
[2023-04-09 23:05:03] local.ERROR: If the column or index already exists (see error), this is not an problem. Otherwise, please open a GitHub discussion.  
[2023-04-09 23:05:03] local.ERROR: Could not create table "available_budgets": SQLSTATE[42P07]: Duplicate table: 7 ERROR:  relation "available_budgets" already exists (Connection: pgsql, SQL: create table "available_budgets" ("id" serial not null primary key, "created_at" timestamp(0) without time zone null, "updated_at" timestamp(0) without time zone null, "deleted_at" timestamp(0) without time zone null, "user_id" integer not null, "transaction_currency_id" integer not null, "amount" decimal(32, 12) not null, "start_date" date not null, "end_date" date not null))  
[2023-04-09 23:05:03] local.ERROR: If this table exists already (see the error message), this is not a problem. Other errors? Please open a discussion on GitHub.  
[2023-04-09 23:05:03] local.ERROR: Could not execute query: SQLSTATE[42701]: Duplicate column: 7 ERROR:  column "decimal_places" of relation "transaction_currencies" already exists (Connection: pgsql, SQL: alter table "transaction_currencies" add column "decimal_places" smallint not null default '2')  
[2023-04-09 23:05:03] local.ERROR: If the column or index already exists (see error), this is not an problem. Otherwise, please open a GitHub discussion.  
[2023-04-09 23:05:03] local.ERROR: Exception is: {"class":"Doctrine\\DBAL\\Exception\\DriverException","errorMessage":"An exception occurred while executing a query: SQLSTATE[25P02]: In failed sql transaction: 7 ERROR:  current transaction is aborted, commands ignored until end of transaction block","time":"Sun, 09 Apr 2023 23:05:03 -0600","file":"\/var\/www\/html\/vendor\/doctrine\/dbal\/src\/Driver\/API\/PostgreSQL\/ExceptionConverter.php","line":87,"code":7,"version":"6.0.7","url":"https:\/\/NOPE","userAgent":"Symfony","json":true,"method":"GET"}  
[2023-04-09 23:05:03] local.ERROR: An exception occurred while executing a query: SQLSTATE[25P02]: In failed sql transaction: 7 ERROR:  current transaction is aborted, commands ignored until end of transaction block {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 7): An exception occurred while executing a query: SQLSTATE[25P02]: In failed sql transaction: 7 ERROR:  current transaction is aborted, commands ignored until end of transaction block at /var/www/html/vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:87)
[stacktrace]
#0 /var/www/html/vendor/doctrine/dbal/src/Connection.php(1931): Doctrine\\DBAL\\Driver\\API\\PostgreSQL\\ExceptionConverter->convert()
#1 /var/www/html/vendor/doctrine/dbal/src/Connection.php(1874): Doctrine\\DBAL\\Connection->handleDriverException()
#2 /var/www/html/vendor/doctrine/dbal/src/Connection.php(1099): Doctrine\\DBAL\\Connection->convertExceptionDuringQuery()
#3 /var/www/html/vendor/doctrine/dbal/src/Connection.php(615): Doctrine\\DBAL\\Connection->executeQuery()
#4 /var/www/html/vendor/doctrine/dbal/src/Connection.php(260): Doctrine\\DBAL\\Connection->fetchOne()
#5 /var/www/html/vendor/doctrine/dbal/src/Schema/AbstractSchemaManager.php(1770): Doctrine\\DBAL\\Connection->getDatabase()
#6 /var/www/html/vendor/doctrine/dbal/src/Schema/AbstractSchemaManager.php(471): Doctrine\\DBAL\\Schema\\AbstractSchemaManager->getDatabase()
#7 /var/www/html/vendor/doctrine/dbal/src/Schema/PostgreSQLSchemaManager.php(73): Doctrine\\DBAL\\Schema\\AbstractSchemaManager->doListTableDetails()
#8 /var/www/html/vendor/doctrine/dbal/src/Schema/AbstractSchemaManager.php(614): Doctrine\\DBAL\\Schema\\PostgreSQLSchemaManager->listTableDetails()
#9 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(1133): Doctrine\\DBAL\\Schema\\AbstractSchemaManager->introspectTable()
#10 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/Grammars/RenameColumn.php(29): Illuminate\\Database\\Connection->getDoctrineColumn()
#11 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/Grammars/Grammar.php(78): Illuminate\\Database\\Schema\\Grammars\\RenameColumn::compile()
#12 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/Grammars/PostgresGrammar.php(153): Illuminate\\Database\\Schema\\Grammars\\Grammar->compileRenameColumn()
#13 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(135): Illuminate\\Database\\Schema\\Grammars\\PostgresGrammar->compileRenameColumn()
#14 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(108): Illuminate\\Database\\Schema\\Blueprint->toSql()
#15 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(439): Illuminate\\Database\\Schema\\Blueprint->build()
#16 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(269): Illuminate\\Database\\Schema\\Builder->build()
#17 /var/www/html/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(353): Illuminate\\Database\\Schema\\Builder->table()
#18 /var/www/html/database/migrations/2016_12_28_203205_changes_for_v431.php(125): Illuminate\\Support\\Facades\\Facade::__callStatic()
#19 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(492): ChangesForV431->up()
#20 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(410): Illuminate\\Database\\Migrations\\Migrator->runMethod()
#21 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Concerns/ManagesTransactions.php(30): Illuminate\\Database\\Migrations\\Migrator->Illuminate\\Database\\Migrations\\{closure}()
#22 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(418): Illuminate\\Database\\Connection->transaction()
#23 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(216): Illuminate\\Database\\Migrations\\Migrator->runMigration()
#24 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(37): Illuminate\\Database\\Migrations\\Migrator->Illuminate\\Database\\Migrations\\{closure}()
#25 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(755): Illuminate\\Console\\View\\Components\\Task->render()
#26 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(216): Illuminate\\Database\\Migrations\\Migrator->write()
#27 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(181): Illuminate\\Database\\Migrations\\Migrator->runUp()
#28 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(124): Illuminate\\Database\\Migrations\\Migrator->runPending()
#29 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(88): Illuminate\\Database\\Migrations\\Migrator->run()
#30 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(632): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->Illuminate\\Database\\Console\\Migrations\\{closure}()
#31 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(81): Illuminate\\Database\\Migrations\\Migrator->usingConnection()
#32 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->handle()
#33 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#34 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure()
#35 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
#36 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\\Container\\BoundMethod::call()
#37 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(194): Illuminate\\Container\\Container->call()
#38 /var/www/html/vendor/symfony/console/Command/Command.php(312): Illuminate\\Console\\Command->execute()
#39 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(163): Symfony\\Component\\Console\\Command\\Command->run()
#40 /var/www/html/vendor/symfony/console/Application.php(1040): Illuminate\\Console\\Command->run()
#41 /var/www/html/vendor/symfony/console/Application.php(314): Symfony\\Component\\Console\\Application->doRunCommand()
#42 /var/www/html/vendor/symfony/console/Application.php(168): Symfony\\Component\\Console\\Application->doRun()
#43 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Application.php(162): Symfony\\Component\\Console\\Application->run()
#44 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(381): Illuminate\\Console\\Application->call()
#45 /var/www/html/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(353): Illuminate\\Foundation\\Console\\Kernel->call()
#46 /var/www/html/app/Console/Commands/ForceMigration.php(65): Illuminate\\Support\\Facades\\Facade::__callStatic()
#47 /var/www/html/app/Console/Commands/ForceMigration.php(52): FireflyIII\\Console\\Commands\\ForceMigration->forceMigration()
#48 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): FireflyIII\\Console\\Commands\\ForceMigration->handle()
#49 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#50 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure()
#51 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
#52 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\\Container\\BoundMethod::call()
#53 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(194): Illuminate\\Container\\Container->call()
#54 /var/www/html/vendor/symfony/console/Command/Command.php(312): Illuminate\\Console\\Command->execute()
#55 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(163): Symfony\\Component\\Console\\Command\\Command->run()
#56 /var/www/html/vendor/symfony/console/Application.php(1040): Illuminate\\Console\\Command->run()
#57 /var/www/html/vendor/symfony/console/Application.php(314): Symfony\\Component\\Console\\Application->doRunCommand()
#58 /var/www/html/vendor/symfony/console/Application.php(168): Symfony\\Component\\Console\\Application->doRun()
#59 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(200): Symfony\\Component\\Console\\Application->run()
#60 /var/www/html/artisan(35): Illuminate\\Foundation\\Console\\Kernel->handle()
#61 {main}

[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 7): SQLSTATE[25P02]: In failed sql transaction: 7 ERROR:  current transaction is aborted, commands ignored until end of transaction block at /var/www/html/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)
[stacktrace]
#0 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/PDO/Connection.php(89): Doctrine\\DBAL\\Driver\\PDO\\Exception::new()
#1 /var/www/html/vendor/doctrine/dbal/src/Connection.php(1094): Illuminate\\Database\\PDO\\Connection->query()
#2 /var/www/html/vendor/doctrine/dbal/src/Connection.php(615): Doctrine\\DBAL\\Connection->executeQuery()
#3 /var/www/html/vendor/doctrine/dbal/src/Connection.php(260): Doctrine\\DBAL\\Connection->fetchOne()
#4 /var/www/html/vendor/doctrine/dbal/src/Schema/AbstractSchemaManager.php(1770): Doctrine\\DBAL\\Connection->getDatabase()
#5 /var/www/html/vendor/doctrine/dbal/src/Schema/AbstractSchemaManager.php(471): Doctrine\\DBAL\\Schema\\AbstractSchemaManager->getDatabase()
#6 /var/www/html/vendor/doctrine/dbal/src/Schema/PostgreSQLSchemaManager.php(73): Doctrine\\DBAL\\Schema\\AbstractSchemaManager->doListTableDetails()
#7 /var/www/html/vendor/doctrine/dbal/src/Schema/AbstractSchemaManager.php(614): Doctrine\\DBAL\\Schema\\PostgreSQLSchemaManager->listTableDetails()
#8 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(1133): Doctrine\\DBAL\\Schema\\AbstractSchemaManager->introspectTable()
#9 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/Grammars/RenameColumn.php(29): Illuminate\\Database\\Connection->getDoctrineColumn()
#10 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/Grammars/Grammar.php(78): Illuminate\\Database\\Schema\\Grammars\\RenameColumn::compile()
#11 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/Grammars/PostgresGrammar.php(153): Illuminate\\Database\\Schema\\Grammars\\Grammar->compileRenameColumn()
#12 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(135): Illuminate\\Database\\Schema\\Grammars\\PostgresGrammar->compileRenameColumn()
#13 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(108): Illuminate\\Database\\Schema\\Blueprint->toSql()
#14 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(439): Illuminate\\Database\\Schema\\Blueprint->build()
#15 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(269): Illuminate\\Database\\Schema\\Builder->build()
#16 /var/www/html/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(353): Illuminate\\Database\\Schema\\Builder->table()
#17 /var/www/html/database/migrations/2016_12_28_203205_changes_for_v431.php(125): Illuminate\\Support\\Facades\\Facade::__callStatic()
#18 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(492): ChangesForV431->up()
#19 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(410): Illuminate\\Database\\Migrations\\Migrator->runMethod()
#20 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Concerns/ManagesTransactions.php(30): Illuminate\\Database\\Migrations\\Migrator->Illuminate\\Database\\Migrations\\{closure}()
#21 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(418): Illuminate\\Database\\Connection->transaction()
#22 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(216): Illuminate\\Database\\Migrations\\Migrator->runMigration()
#23 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(37): Illuminate\\Database\\Migrations\\Migrator->Illuminate\\Database\\Migrations\\{closure}()
#24 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(755): Illuminate\\Console\\View\\Components\\Task->render()
#25 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(216): Illuminate\\Database\\Migrations\\Migrator->write()
#26 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(181): Illuminate\\Database\\Migrations\\Migrator->runUp()
#27 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(124): Illuminate\\Database\\Migrations\\Migrator->runPending()
#28 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(88): Illuminate\\Database\\Migrations\\Migrator->run()
#29 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(632): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->Illuminate\\Database\\Console\\Migrations\\{closure}()
#30 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(81): Illuminate\\Database\\Migrations\\Migrator->usingConnection()
#31 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->handle()
#32 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#33 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure()
#34 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
#35 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\\Container\\BoundMethod::call()
#36 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(194): Illuminate\\Container\\Container->call()
#37 /var/www/html/vendor/symfony/console/Command/Command.php(312): Illuminate\\Console\\Command->execute()
#38 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(163): Symfony\\Component\\Console\\Command\\Command->run()
#39 /var/www/html/vendor/symfony/console/Application.php(1040): Illuminate\\Console\\Command->run()
#40 /var/www/html/vendor/symfony/console/Application.php(314): Symfony\\Component\\Console\\Application->doRunCommand()
#41 /var/www/html/vendor/symfony/console/Application.php(168): Symfony\\Component\\Console\\Application->doRun()
#42 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Application.php(162): Symfony\\Component\\Console\\Application->run()
#43 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(381): Illuminate\\Console\\Application->call()
#44 /var/www/html/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(353): Illuminate\\Foundation\\Console\\Kernel->call()
#45 /var/www/html/app/Console/Commands/ForceMigration.php(65): Illuminate\\Support\\Facades\\Facade::__callStatic()
#46 /var/www/html/app/Console/Commands/ForceMigration.php(52): FireflyIII\\Console\\Commands\\ForceMigration->forceMigration()
#47 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): FireflyIII\\Console\\Commands\\ForceMigration->handle()
#48 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#49 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure()
#50 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
#51 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\\Container\\BoundMethod::call()
#52 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(194): Illuminate\\Container\\Container->call()
#53 /var/www/html/vendor/symfony/console/Command/Command.php(312): Illuminate\\Console\\Command->execute()
#54 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(163): Symfony\\Component\\Console\\Command\\Command->run()
#55 /var/www/html/vendor/symfony/console/Application.php(1040): Illuminate\\Console\\Command->run()
#56 /var/www/html/vendor/symfony/console/Application.php(314): Symfony\\Component\\Console\\Application->doRunCommand()
#57 /var/www/html/vendor/symfony/console/Application.php(168): Symfony\\Component\\Console\\Application->doRun()
#58 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(200): Symfony\\Component\\Console\\Application->run()
#59 /var/www/html/artisan(35): Illuminate\\Foundation\\Console\\Kernel->handle()
#60 {main}

[previous exception] [object] (PDOException(code: 25P02): SQLSTATE[25P02]: In failed sql transaction: 7 ERROR:  current transaction is aborted, commands ignored until end of transaction block at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/PDO/Connection.php:83)
[stacktrace]
#0 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/PDO/Connection.php(83): PDO->query()
#1 /var/www/html/vendor/doctrine/dbal/src/Connection.php(1094): Illuminate\\Database\\PDO\\Connection->query()
#2 /var/www/html/vendor/doctrine/dbal/src/Connection.php(615): Doctrine\\DBAL\\Connection->executeQuery()
#3 /var/www/html/vendor/doctrine/dbal/src/Connection.php(260): Doctrine\\DBAL\\Connection->fetchOne()
#4 /var/www/html/vendor/doctrine/dbal/src/Schema/AbstractSchemaManager.php(1770): Doctrine\\DBAL\\Connection->getDatabase()
#5 /var/www/html/vendor/doctrine/dbal/src/Schema/AbstractSchemaManager.php(471): Doctrine\\DBAL\\Schema\\AbstractSchemaManager->getDatabase()
#6 /var/www/html/vendor/doctrine/dbal/src/Schema/PostgreSQLSchemaManager.php(73): Doctrine\\DBAL\\Schema\\AbstractSchemaManager->doListTableDetails()
#7 /var/www/html/vendor/doctrine/dbal/src/Schema/AbstractSchemaManager.php(614): Doctrine\\DBAL\\Schema\\PostgreSQLSchemaManager->listTableDetails()
#8 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(1133): Doctrine\\DBAL\\Schema\\AbstractSchemaManager->introspectTable()
#9 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/Grammars/RenameColumn.php(29): Illuminate\\Database\\Connection->getDoctrineColumn()
#10 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/Grammars/Grammar.php(78): Illuminate\\Database\\Schema\\Grammars\\RenameColumn::compile()
#11 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/Grammars/PostgresGrammar.php(153): Illuminate\\Database\\Schema\\Grammars\\Grammar->compileRenameColumn()
#12 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(135): Illuminate\\Database\\Schema\\Grammars\\PostgresGrammar->compileRenameColumn()
#13 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(108): Illuminate\\Database\\Schema\\Blueprint->toSql()
#14 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(439): Illuminate\\Database\\Schema\\Blueprint->build()
#15 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(269): Illuminate\\Database\\Schema\\Builder->build()
#16 /var/www/html/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(353): Illuminate\\Database\\Schema\\Builder->table()
#17 /var/www/html/database/migrations/2016_12_28_203205_changes_for_v431.php(125): Illuminate\\Support\\Facades\\Facade::__callStatic()
#18 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(492): ChangesForV431->up()
#19 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(410): Illuminate\\Database\\Migrations\\Migrator->runMethod()
#20 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Concerns/ManagesTransactions.php(30): Illuminate\\Database\\Migrations\\Migrator->Illuminate\\Database\\Migrations\\{closure}()
#21 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(418): Illuminate\\Database\\Connection->transaction()
#22 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(216): Illuminate\\Database\\Migrations\\Migrator->runMigration()
#23 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(37): Illuminate\\Database\\Migrations\\Migrator->Illuminate\\Database\\Migrations\\{closure}()
#24 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(755): Illuminate\\Console\\View\\Components\\Task->render()
#25 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(216): Illuminate\\Database\\Migrations\\Migrator->write()
#26 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(181): Illuminate\\Database\\Migrations\\Migrator->runUp()
#27 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(124): Illuminate\\Database\\Migrations\\Migrator->runPending()
#28 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(88): Illuminate\\Database\\Migrations\\Migrator->run()
#29 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(632): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->Illuminate\\Database\\Console\\Migrations\\{closure}()
#30 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(81): Illuminate\\Database\\Migrations\\Migrator->usingConnection()
#31 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->handle()
#32 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#33 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure()
#34 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
#35 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\\Container\\BoundMethod::call()
#36 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(194): Illuminate\\Container\\Container->call()
#37 /var/www/html/vendor/symfony/console/Command/Command.php(312): Illuminate\\Console\\Command->execute()
#38 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(163): Symfony\\Component\\Console\\Command\\Command->run()
#39 /var/www/html/vendor/symfony/console/Application.php(1040): Illuminate\\Console\\Command->run()
#40 /var/www/html/vendor/symfony/console/Application.php(314): Symfony\\Component\\Console\\Application->doRunCommand()
#41 /var/www/html/vendor/symfony/console/Application.php(168): Symfony\\Component\\Console\\Application->doRun()
#42 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Application.php(162): Symfony\\Component\\Console\\Application->run()
#43 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(381): Illuminate\\Console\\Application->call()
#44 /var/www/html/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(353): Illuminate\\Foundation\\Console\\Kernel->call()
#45 /var/www/html/app/Console/Commands/ForceMigration.php(65): Illuminate\\Support\\Facades\\Facade::__callStatic()
#46 /var/www/html/app/Console/Commands/ForceMigration.php(52): FireflyIII\\Console\\Commands\\ForceMigration->forceMigration()
#47 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): FireflyIII\\Console\\Commands\\ForceMigration->handle()
#48 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#49 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure()
#50 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
#51 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\\Container\\BoundMethod::call()
#52 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(194): Illuminate\\Container\\Container->call()
#53 /var/www/html/vendor/symfony/console/Command/Command.php(312): Illuminate\\Console\\Command->execute()
#54 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(163): Symfony\\Component\\Console\\Command\\Command->run()
#55 /var/www/html/vendor/symfony/console/Application.php(1040): Illuminate\\Console\\Command->run()
#56 /var/www/html/vendor/symfony/console/Application.php(314): Symfony\\Component\\Console\\Application->doRunCommand()
#57 /var/www/html/vendor/symfony/console/Application.php(168): Symfony\\Component\\Console\\Application->doRun()
#58 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(200): Symfony\\Component\\Console\\Application->run()
#59 /var/www/html/artisan(35): Illuminate\\Foundation\\Console\\Kernel->handle()
#60 {main}
"} 

   Doctrine\DBAL\Exception\DriverException 

  An exception occurred while executing a query: SQLSTATE[25P02]: In failed sql transaction: 7 ERROR:  current transaction is aborted, commands ignored until end of transaction block

  at vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:87
     83▕         if ($exception->getCode() === 7 && strpos($exception->getMessage(), 'SQLSTATE[08006]') !== false) {
     84▕             return new ConnectionException($exception, $query);
     85▕         }
     86▕ 
  ➜  87▕         return new DriverException($exception, $query);
     88▕     }
     89▕ }
     90▕ 

      +23 vendor frames 

  24  database/migrations/2016_12_28_203205_changes_for_v431.php:125
      Illuminate\Support\Facades\Facade::__callStatic()
      +27 vendor frames 

  52  app/Console/Commands/ForceMigration.php:65
      Illuminate\Support\Facades\Facade::__callStatic()

JC5 Apr 10, 2023
Maintainer

Mmm, curious to see what the 500 could be. Try restoring the backup, it looks like postgresql doesn't continue with the migrations once it runs into an error. I can prevent that, but I'd like to try that myself first.

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Firefly III

Undefined table: 7 ERROR: relation "audit_log_entries" #7330

{{title}}

Replies: 2 comments 9 replies

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

Select a reply

Firefly III

Undefined table: 7 ERROR: relation "audit_log_entries" #7330

carsonbird Apr 5, 2023

Support guidelines

I've found a bug and checked that ...

Description

Debug information

Expected behaviour

Steps to reproduce

Additional info

Replies: 2 comments · 9 replies

JC5 Apr 5, 2023 Maintainer

carsonbird Apr 6, 2023 Author

JC5 Apr 6, 2023 Maintainer

carsonbird Apr 6, 2023 Author

JC5 Apr 7, 2023 Maintainer

JC5 Apr 8, 2023 Maintainer

carsonbird Apr 9, 2023 Author

JC5 Apr 10, 2023 Maintainer

carsonbird Apr 10, 2023 Author

JC5 Apr 10, 2023 Maintainer

carsonbird
Apr 5, 2023

Replies: 2 comments 9 replies

JC5
Apr 5, 2023
Maintainer

carsonbird Apr 6, 2023
Author

JC5 Apr 6, 2023
Maintainer

carsonbird Apr 6, 2023
Author

JC5
Apr 7, 2023
Maintainer

JC5 Apr 8, 2023
Maintainer

carsonbird Apr 9, 2023
Author

JC5 Apr 10, 2023
Maintainer

carsonbird Apr 10, 2023
Author

JC5 Apr 10, 2023
Maintainer