| # |
May 15th 2021, 19:36 |
 ndm |
Good luck debugging that... or even testing... testing generated SQL in 3rd party code? Oh boy, the slightest change in output produced by the core and you're in maintenance hell :upside_down_face: |
| # |
May 15th 2021, 19:36 |
ndm |
And that might not even cause an error, but just give you totally wrong results. |
| # |
May 15th 2021, 19:32 |
slackebot |
conditions are moved from outer queries to inner queries :grimacing: |
| # |
May 15th 2021, 19:32 |
ndm |
Unfortunately when developing 3rd party code for CakePHP I can't solely rely on the framework doing the right thing, I must be sure that I'm using it in a way that it is actually able to do the right thing. The dialects transforming code for example can really hit you by surprise, transforming tuples for Sqlite and Sqlserver really tripped me recently, as it can cause references to aliases targeting the wrong queries when |
| # |
May 15th 2021, 19:24 |
kevin.pfeifer |
thats why we are all very grateful to our cakephp core overlords who figure those things out for us lower folks so we can use a framework which just works :bow: |
| # |
May 15th 2021, 18:50 |
slackebot |
that could slowly approach almost exponential territory, that's wild x) |
| # |
May 15th 2021, 18:50 |
ndm |
Soooo, CI for code that needs to support all DBMS (MySQL, MariaDB, Sqlite, Postgres, SQL Server) and their quirks, basically needs to run at least 4 (DB types) * 2 (min/max PHP version) * 2 (min/max CakePHP version) jobs, + 1 or 2 separate ones for SQL server (if we're not too cocky and want to make it 5*2*2), that would already be 16-18 jobs, and god forbid I'd want to test with intermediate PHP/CakePHP versions too, over time |
| # |
May 15th 2021, 15:41 |
martin |
Yes i did find that, changed it to false |
| # |
May 15th 2021, 15:41 |
martin |
but since the server env is also based on docker it is easier to also run local in the same docker container I think |
| # |
May 15th 2021, 15:41 |
slackebot |
<kevin.pfeifer> |
| # |
May 15th 2021, 15:40 |
martin |
oh let me try to disable that, hope that solves the issue :P |
| # |
May 15th 2021, 15:39 |
kevin.pfeifer |
inside the docker engine settings |
| # |
May 15th 2021, 15:38 |
kevin.pfeifer |
the only thing (related to performance) is the fact, that for some reason debug mode is default on for the MacOS client which drastically reduces performance |
| # |
May 15th 2021, 15:38 |
martin |
with my private project I don't have that issue. with normal command I don't have the issue that it does not see the changes |
| # |
May 15th 2021, 15:37 |
martin |
ah ok, we work at work with docker, but having problems that sometimes docker does not respond, for a minute or so |
| # |
May 15th 2021, 15:36 |
kevin.pfeifer |
I can only say that me and my co-workers discarded any development in docker since its just to error prone and finicky to work with. We switched to a more "native" setup running PHP, MySQL etc. on the OS directly. Could be that its a docker problem, could be that there is some config needed or there is a bug somewhere, don't know :man-shrugging: |
| # |
May 15th 2021, 15:27 |
martin |
hmm seems to be working now after restarting docker-container+redis, how is the job cached by the worker? :P |
| # |
May 15th 2021, 14:46 |
martin |
hmmm maybe that was the problem, going to test my job again |
| # |
May 15th 2021, 14:42 |
martin |
even when I restarted the worker |
| # |
May 15th 2021, 14:41 |
martin |
hmm when I update a job, it still runs the old job? |
| # |
May 15th 2021, 14:38 |
admad |
Take the trouble of reading through the issue and the related PR. |
| # |
May 15th 2021, 14:33 |
slackebot |
[/var/www/vendor/enqueue/enqueue/ArrayProcessorRegistry.php, line 33]``` it did work a few jobs, and then crash |
| # |
May 15th 2021, 14:33 |
martin |
yes: ```2021-05-15 00:05:40 Error: <some ip> updated 2021-05-15 00:05:40 Error: <some ip> updated 2021-05-15 00:05:40 Error: <some ip> updated 2021-05-15 00:05:40 Error: <some ip> updated 2021-05-15 00:05:40 Error: <some ip> updated 2021-05-15 00:05:40 Error: <some ip> updated 2021-05-15 00:05:40 Error: <some ip> updated Exception: Processor was not found. processorName: "Cake\Queue\Queue\Processor609f0e301d4d5" In |
| # |
May 15th 2021, 14:31 |
kevin.pfeifer |
so it works sometimes? |
| # |
May 15th 2021, 14:31 |
martin |
it is also random, that is strange, make my job now just go to sleep 10 seconds |
| # |
May 15th 2021, 14:26 |
kevin.pfeifer |
haven't used that queue plugin till now, would have to check that further to give you more info |
| # |
May 15th 2021, 14:21 |
kevin.pfeifer |
mhmm |
| # |
May 15th 2021, 14:21 |
kevin.pfeifer |
I would say it can be anything you like |
| # |
May 15th 2021, 14:20 |
martin |
```bin/cake worker --processor=test Exception: Processor was not found. processorName: "Cake\Queue\Queue\Processor609fc922dca73" In [/var/www/vendor/enqueue/enqueue/ArrayProcessorRegistry.php, line 33]``` still trying to use a proccesor that is unknown and not the name that I did give |
| # |
May 15th 2021, 14:18 |
martin |
I can give a processorname with --processor but what would be the right name? |
| # |
May 15th 2021, 14:14 |
martin |
@admad but that issue is fixed? or not merged yet? |
| # |
May 15th 2021, 14:05 |
admad |
@martin https://github.com/cakephp/queue/issues/50 |
| # |
May 15th 2021, 13:16 |
slackebot |
/var/www/vendor/cakephp/cakephp/src/Console/CommandRunner.php:335 - /var/www/vendor/cakephp/cakephp/src/Console/CommandRunner.php:171 - /var/www/bin/cake.php:12``` is this a issue in queue? I have nothing done with the Processor |
| # |
May 15th 2021, 13:16 |
slackebot |
/var/www/vendor/enqueue/enqueue/Consumption/QueueConsumer.php:197 - call_user_func - [internal], line ??- /var/www/vendor/enqueue/redis/RedisSubscriptionConsumer.php:75 - /var/www/vendor/enqueue/enqueue/Consumption/QueueConsumer.php:264 - /var/www/vendor/enqueue/simple-client/SimpleClient.php:209 - /var/www/vendor/cakephp/queue/src/Command/WorkerCommand.php:147 - /var/www/vendor/cakephp/cakephp/src/Console/BaseCommand.php:179 - |
| # |
May 15th 2021, 13:16 |
martin |
Hi, I've installed cakephp/queue, installed redis, created a job, it works a little bit every xxx minutes it gives the error: ```2021-05-15 00:06:40 Error: [LogicException] Processor was not found. processorName: "Cake\Queue\Queue\Processor609f0e301d4d5" in /var/www/vendor/enqueue/enqueue/ArrayProcessorRegistry.php on line 33 Stack Trace: - /var/www/vendor/enqueue/enqueue/Client/DelegateProcessor.php:38 - |
| # |
May 14th 2021, 19:41 |
kevin.pfeifer |
but as far as i know both should be present in cake3 |
| # |
May 14th 2021, 19:38 |
kevin.pfeifer |
could be that you would have to use slightly different functions if they are not present in cake3 yet |
| # |
May 14th 2021, 19:37 |
etibor |
is this could work in cake3? |
| # |
May 14th 2021, 19:36 |
etibor |
@kevin.pfeifer thank you soo much for your help |
| # |
May 14th 2021, 19:20 |
kevin.pfeifer |
i would `$query->orderDesc('id')->limit(1)` |
| # |
May 14th 2021, 19:13 |
etibor |
what is the best way to get the highest element in a group? i tried with select(['id'=>'MAX(id)'])->group(['document_id']) |