Created a transaction with id 0 that unable to edit or delete #9628

alkscr · 2025-01-05T14:07:04Z

alkscr
Jan 5, 2025

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

I accidently create a broken transaction record when using Firefly III. The transaction points to link firefly-iii.com/transactions/show/0, so it cause a 404 when trying to edit or delete. However, this record still affect my account balance.

I've checked logs from docker. It seems the database crashed when creating that transaction, and left a record with a NULL value in transaction_journals -> transaction_group_id. Not sure if there are other problems.

Is there a way to fix or delete this broken record? I haven't tried delete it directly from the database CLI, with concerning of causing new problems.

Debug information

Debug information generated at 2025-01-05 20:11:26 for Firefly III version v6.1.24.

System information
Item	Value
Firefly III	6.1.24 / v2.1.0 / 25 (exp. 25)
PHP version	8.3.13 (64bits) / apache2handler / Linux x86_64
BCscale	12
Error reporting	Display: Off, reporting: ALL errors
Max upload	67108864 (64 MB)
Database drivers	*mysql*, pgsql, sqlite,
Docker build	#1153, base #92

Firefly III information
Item	Value
Timezone	Asia/Hong_Kong + Asia/Shanghai
App environment	production, debug: false
Layout	v1
Logging	notice, stack / (empty)
Cache driver	file
Default language and locale	en_US + equal
Trusted proxies	*
Login provider & user guard	eloquent / web
Login headers	N/A + N/A
Stateful domains
Last cron job	2025-01-04 16:00:00 (20 hours ago)
Mailer	log

User-specific information
Item	Value
User	#1 of 1
User flags	💳 🐷 🕜
Session start	2024-12-06 17:21:11
Session end	2025-01-05 17:21:11
View range	1M
User language	zh_CN
User locale	zh_CN
Locale(s) supported	zh_CN.utf8: ✅ zh_CN.UTF-8: ✅
User agent	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36 Edg/131.0.0.0

Expected behaviour

Firefly iii finds out the record may be wrong and offers a method to fix or just delete it.

Steps to reproduce

No response

Additional info

Log of firefly_iii_core

[2024-12-21 10:17:30] production.ERROR: Could not create transaction: SQLSTATE[HY000] [2002] Connection refused (Connection: mysql, SQL: insert into `transactions` (`reconciled`, `account_id`, `transaction_journal_id`, `description`, `transaction_currency_id`, `amount`, `foreign_amount`, `foreign_currency_id`, `identifier`, `updated_at`, `created_at`) values (0, 133, 2214, ?, 19, 13.2, ?, ?, 0, 2024-12-21 10:17:30, 2024-12-21 10:17:30)) {"reconciled":false,"account_id":133,"transaction_journal_id":2214,"description":null,"transaction_currency_id":19,"amount":"13.2","foreign_amount":null,"foreign_currency_id":null,"identifier":0}
[2024-12-21 10:17:30] production.ERROR: SQLSTATE[HY000] [2002] Connection refused (Connection: mysql, SQL: insert into `transactions` (`reconciled`, `account_id`, `transaction_journal_id`, `description`, `transaction_currency_id`, `amount`, `foreign_amount`, `foreign_currency_id`, `identifier`, `updated_at`, `created_at`) values (0, 133, 2214, ?, 19, 13.2, ?, ?, 0, 2024-12-21 10:17:30, 2024-12-21 10:17:30))
[2024-12-21 10:17:30] production.ERROR: #0 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(979): Illuminate\Database\Connection->runQueryCallback()
#1 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(958): Illuminate\Database\Connection->tryAgainIfCausedByLostConnection()
#2 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(781): Illuminate\Database\Connection->handleQueryException()
#3 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/MySqlConnection.php(42): Illuminate\Database\Connection->run()
#4 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Processors/MySqlProcessor.php(35): Illuminate\Database\MySqlConnection->insert()
#5 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3799): Illuminate\Database\Query\Processors\MySqlProcessor->processInsertGetId()
#6 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(2049): Illuminate\Database\Query\Builder->insertGetId()
#7 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1358): Illuminate\Database\Eloquent\Builder->__call()
#8 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1323): Illuminate\Database\Eloquent\Model->insertAndSetId()
#9 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1162): Illuminate\Database\Eloquent\Model->performInsert()
#10 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1079): Illuminate\Database\Eloquent\Model->save()
#11 /var/www/html/vendor/laravel/framework/src/Illuminate/Support/helpers.php(380): Illuminate\Database\Eloquent\Builder->Illuminate\Database\Eloquent\{closure}()
#12 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(1078): tap()
#13 /var/www/html/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php(23): Illuminate\Database\Eloquent\Builder->create()
#14 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2367): Illuminate\Database\Eloquent\Model->forwardCallTo()
#15 /var/www/html/vendor/genealabs/laravel-model-caching/src/Traits/Caching.php(26): Illuminate\Database\Eloquent\Model->__call()
#16 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2379): FireflyIII\Models\Transaction->__call()
#17 /var/www/html/app/Factory/TransactionFactory.php(97): Illuminate\Database\Eloquent\Model::__callStatic()
#18 /var/www/html/app/Factory/TransactionFactory.php(184): FireflyIII\Factory\TransactionFactory->create()
#19 /var/www/html/app/Factory/TransactionJournalFactory.php(292): FireflyIII\Factory\TransactionFactory->createPositive()
#20 /var/www/html/app/Factory/TransactionJournalFactory.php(120): FireflyIII\Factory\TransactionJournalFactory->createJournal()
#21 /var/www/html/app/Factory/TransactionGroupFactory.php(60): FireflyIII\Factory\TransactionJournalFactory->create()
#22 /var/www/html/app/Repositories/TransactionGroup/TransactionGroupRepository.php(411): FireflyIII\Factory\TransactionGroupFactory->create()
#23 /var/www/html/app/Api/V1/Controllers/Models/Transaction/StoreController.php(89): FireflyIII\Repositories\TransactionGroup\TransactionGroupRepository->store()
#24 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): FireflyIII\Api\V1\Controllers\Models\Transaction\StoreController->store()
#25 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\Routing\Controller->callAction()
#26 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Route.php(264): Illuminate\Routing\ControllerDispatcher->dispatch()
#27 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Route.php(210): Illuminate\Routing\Route->runController()
#28 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(808): Illuminate\Routing\Route->run()
#29 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\Routing\Router->Illuminate\Routing\{closure}()
#30 /var/www/html/app/Api/V1/Controllers/Models/Transaction/StoreController.php(65): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#31 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(165): FireflyIII\Api\V1\Controllers\Models\Transaction\StoreController->FireflyIII\Api\V1\Controllers\Models\Transaction\{closure}()
#32 /var/www/html/app/Api/V1/Controllers/Controller.php(74): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#33 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(165): FireflyIII\Api\V1\Controllers\Controller->FireflyIII\Api\V1\Controllers\{closure}()
#34 /var/www/html/app/Http/Middleware/Binder.php(75): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#35 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): FireflyIII\Http\Middleware\Binder->handle()
#36 /var/www/html/app/Http/Middleware/Authenticate.php(66): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#37 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): FireflyIII\Http\Middleware\Authenticate->handle()
#38 /var/www/html/vendor/laravel/sanctum/src/Http/Middleware/EnsureFrontendRequestsAreStateful.php(25): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#39 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Laravel\Sanctum\Http\Middleware\EnsureFrontendRequestsAreStateful->Laravel\Sanctum\Http\Middleware\{closure}()
#40 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#41 /var/www/html/vendor/laravel/sanctum/src/Http/Middleware/EnsureFrontendRequestsAreStateful.php(24): Illuminate\Pipeline\Pipeline->then()
#42 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Laravel\Sanctum\Http\Middleware\EnsureFrontendRequestsAreStateful->handle()
#43 /var/www/html/app/Http/Middleware/AcceptHeaders.php(72): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#44 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): FireflyIII\Http\Middleware\AcceptHeaders->handle()
#45 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#46 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(807): Illuminate\Pipeline\Pipeline->then()
#47 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(786): Illuminate\Routing\Router->runRouteWithinStack()
#48 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(750): Illuminate\Routing\Router->runRoute()
#49 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(739): Illuminate\Routing\Router->dispatchToRoute()
#50 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(201): Illuminate\Routing\Router->dispatch()
#51 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}()
#52 /var/www/html/app/Http/Middleware/InstallationId.php(47): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#53 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): FireflyIII\Http\Middleware\InstallationId->handle()
#54 /var/www/html/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(58): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#55 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Http\Middleware\TrustProxies->handle()
#56 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#57 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle()
#58 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle()
#59 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#60 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(51): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle()
#61 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\TrimStrings->handle()
#62 /var/www/html/vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#63 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Http\Middleware\ValidatePostSize->handle()
#64 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(110): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#65 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle()
#66 /var/www/html/app/Http/Middleware/SecureHeaders.php(52): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#67 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(183): FireflyIII\Http\Middleware\SecureHeaders->handle()
#68 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}()
#69 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\Pipeline\Pipeline->then()
#70 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(145): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter()
#71 /var/www/html/public/index.php(73): Illuminate\Foundation\Http\Kernel->handle()
#72 {main}

Log of firefly_iii_db

2024-12-21 02:17:32+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.4.4+maria~ubu2404 started.
2024-12-21 02:17:34+00:00 [Warn] [Entrypoint]: /sys/fs/cgroup///memory.pressure not writable, functionality unavailable to MariaDB
2024-12-21 02:17:34+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2024-12-21 02:17:34+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.4.4+maria~ubu2404 started.
2024-12-21 02:17:34+00:00 [Note] [Entrypoint]: MariaDB upgrade not required
2024-12-21  2:17:34 0 [Note] Starting MariaDB 11.4.4-MariaDB-ubu2404 source revision e9a502df08bad16aa8a354e854f3c014b1380e32 server_uid Id1MgWPIiqAt2SqZRoJ9ouGDzac= as process 1
2024-12-21  2:17:34 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-12-21  2:17:34 0 [Note] InnoDB: Using transactional memory
2024-12-21  2:17:34 0 [Note] InnoDB: Number of transaction pools: 1
2024-12-21  2:17:34 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2024-12-21  2:17:34 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
2024-12-21  2:17:34 0 [Warning] mariadbd: io_uring_queue_init() failed with errno 95
2024-12-21  2:17:34 0 [Warning] InnoDB: liburing disabled: falling back to innodb_use_native_aio=OFF
2024-12-21  2:17:34 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
2024-12-21  2:17:34 0 [Note] InnoDB: Completed initialization of buffer pool
2024-12-21  2:17:34 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
2024-12-21  2:17:34 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=30525504
2024-12-21  2:17:34 0 [Note] InnoDB: End of log at LSN=33765137
2024-12-21  2:17:34 0 [Note] InnoDB: To recover: 467 pages
2024-12-21  2:17:34 0 [Note] InnoDB: Opened 3 undo tablespaces
2024-12-21  2:17:34 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
2024-12-21  2:17:34 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
2024-12-21  2:17:34 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
2024-12-21  2:17:34 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2024-12-21  2:17:34 0 [Note] InnoDB: log sequence number 33765137; transaction id 95224
2024-12-21  2:17:34 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2024-12-21  2:17:34 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-12-21  2:17:34 0 [Note] Plugin 'wsrep-provider' is disabled.
2024-12-21  2:17:34 0 [Note] Recovering after a crash using tc.log
2024-12-21  2:17:34 0 [Note] Starting table crash recovery...
2024-12-21  2:17:34 0 [Note] Crash table recovery finished.
2024-12-21  2:17:34 0 [Note] InnoDB: Buffer pool(s) load completed at 241221  2:17:34
2024-12-21  2:17:35 0 [Note] Server socket created on IP: '0.0.0.0'.
2024-12-21  2:17:35 0 [Note] Server socket created on IP: '::'.
2024-12-21  2:17:35 0 [Note] mariadbd: Event Scheduler: Loaded 0 events
2024-12-21  2:17:35 0 [Note] mariadbd: ready for connections.
Version: '11.4.4-MariaDB-ubu2404'  socket: '/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution

Answered by JC5

Jan 5, 2025

Hi, thanks for starting a discussion.

You can delete the offending entry with no trouble. Or, run php artisan firefly-iii:correct-database, it should do this for you.

View full answer

JC5 · 2025-01-05T14:22:08Z

JC5
Jan 5, 2025
Maintainer

Hi, thanks for starting a discussion.

You can delete the offending entry with no trouble. Or, run php artisan firefly-iii:correct-database, it should do this for you.

1 reply

alkscr Jan 5, 2025
Author

This works. Thanks.

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Firefly III

Created a transaction with id 0 that unable to edit or delete #9628

{{title}}

{{editor}}'s edit

{{editor}}'s edit

Replies: 1 comment 1 reply

{{title}}

{{title}}

Select a reply

Firefly III

Created a transaction with id 0 that unable to edit or delete #9628

alkscr Jan 5, 2025

Support guidelines

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

Description

Debug information

Expected behaviour

Steps to reproduce

Additional info

Log of firefly_iii_core

Log of firefly_iii_db

Replies: 1 comment · 1 reply

JC5 Jan 5, 2025 Maintainer

alkscr Jan 5, 2025 Author

alkscr
Jan 5, 2025

Replies: 1 comment 1 reply

JC5
Jan 5, 2025
Maintainer

alkscr Jan 5, 2025
Author