Issue about "data size"
Open
Nobody has claimed this yet.
- Dominant language
- PHP
- Stars
- 4.5k
- Forks
- 884
- PR merge metrics
- No merged PRs in 30d
Description
Our file contain 483236 lines.
Should not Phinx be able to split/batch data ?
Exception: SQLSTATE[HY000]: General error: 7 number of parameters must be between 0 and 65535
In [/home/project/sources/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php, line 335]
2023-01-06 00:06:23 error: [PDOException] SQLSTATE[HY000]: General error: 7 number of parameters must be between 0 and 65535 in /home/eventmaster_testing/sources/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php on line 335
Stack Trace:
- /home/project/sources/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php:335
- /home/project/sources/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/AdapterWrapper.php:180
- /home/project/sources/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/TimedOutputAdapter.php:102
- /home/project/sources/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/AdapterWrapper.php:180
- /home/project/sources/vendor/robmorgan/phinx/src/Phinx/Db/Table.php:652
- /home/project/sources/vendor/robmorgan/phinx/src/Phinx/Db/Table.php:624
- /home/project/sources/vendor/robmorgan/phinx/src/Phinx/Db/Table.php:682
- /home/project/sources/config/Seeds/CitiesSeed.php:483236
- /home/project/sources/vendor/robmorgan/phinx/src/Phinx/Migration/Manager/Environment.php:146
- /home/project/sources/vendor/robmorgan/phinx/src/Phinx/Migration/Manager.php:416
- /home/project/sources/vendor/robmorgan/phinx/src/Phinx/Migration/Manager.php:557
- /home/project/sources/vendor/robmorgan/phinx/src/Phinx/Console/Command/SeedRun.php:102
- /home/project/sources/vendor/cakephp/migrations/src/Command/Phinx/CommandTrait.php:37
- /home/project/sources/vendor/cakephp/migrations/src/Command/Phinx/Seed.php:76
- /home/project/sources/vendor/symfony/console/Command/Command.php:298
- /home/project/sources/vendor/symfony/console/Application.php:1024
- /home/project/sources/vendor/symfony/console/Application.php:299
- /home/project/sources/vendor/symfony/console/Application.php:171
- /home/project/sources/vendor/cakephp/migrations/src/Command/MigrationsCommand.php:126
- /home/project/sources/vendor/cakephp/cakephp/src/Console/BaseCommand.php:179
- /home/project/sources/vendor/cakephp/migrations/src/Command/MigrationsCommand.php:198
- /home/project/sources/vendor/cakephp/cakephp/src/Console/CommandRunner.php:334
- /home/project/sources/vendor/cakephp/cakephp/src/Console/CommandRunner.php:172
- /home/project/sources/bin/cake.php:12
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Reproduce the seed failure from config/Seeds/CitiesSeed.php and inspect the insert path at vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php:335, together with the Table.php frames in the trace. Determine the intended behavior for data exceeding the parameter limit; done should include a defined batching approach and a seed run that no longer raises this exception.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- php
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 30/100