Le 21/09/2015 18:15, Jean-Baptiste Denis a écrit : >> Try to run the report with "-l FULL" (full debug level). This will >> display the DB request used for getting entries. >> This could help to determine what is wrong with querying the DB in bulk >> mode. > Sorry, should have done that in the first place. I ran the rbh-find with > -d FULL. > > Looks like it is stuck at the very beginning : > > 2015/09/21 16:57:44 [3997/1] ListMgr | Logged on to database > 'robinhood_projets' successfully > 2015/09/21 16:57:44 [3997/1] ListMgr | SQL query: SET SESSION > TRANSACTION ISOLATION LEVEL READ COMMITTED > 2015/09/21 16:57:44 [3997/1] find | Optimization: switching to bulk DB > request mode > /pasteur/projets > 2015/09/21 16:57:44 [3997/1] ListMgr | Empty filter: all records will be > affected > 2015/09/21 16:57:44 [3997/1] ListMgr | SQL query: SELECT id FROM ENTRIES So, to summarize: when you run "rbh-find" with no criteria, you get nothing, and when you run it why no criteria and nobulk option, you get something?
> > real 8m31.306s > user 0m30.577s > sys 0m27.988s > > And that's all. > >> Also you can try running the request manually in a "mysql" command, and >> remove some criteria to understand which one cause the entries to be >> filtered. > Same behaviour from the mysql shell. Here is the mysql log output when > running SELECT id FROM ENTRIES from it. > > 150921 18:11:53 13 Connect root@localhost on robinhood_projets > 13 Query show databases > 13 Query show tables > 13 Field List ACCT_STAT > 13 Field List ANNEX_INFO > 13 Field List ENTRIES > 13 Field List NAMES > 13 Field List TAG_DIFF_1991 > 13 Field List TAG_DIFF_23445 > 13 Field List VARS > 13 Query SELECT id FROM ENTRIES > > Jean-Baptiste > > > ------------------------------------------------------------------------------ > _______________________________________________ > robinhood-support mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/robinhood-support > > --- L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus Avast. http://www.avast.com ------------------------------------------------------------------------------ _______________________________________________ robinhood-support mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/robinhood-support
