> 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
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
