gistfile1.txt

20220924 10405227  #  -    00.000.056
20220924 10405243  #  +    mormot.rest.memserver.TRestServerFullMemory(7f35e734bd10).URI POST central/v1/wbService.repsearch in=133 B
20220924 10405243  # call       mormot.rest.memserver.TRestServerFullMemory(7f35e734bd10) IwbService.repsearch["{\"mver\":-1,\"typ\":-1,\"user\":-1,\"pver\":-1,\"tofind\":\"\",\"term\":-1,\"sdat\":\"2022-09-14\",\"edat\":\"2022-09-24\"}",0,20]
20220924 10405243  # DB         mormot.db.sql.zeos.TSqlDBZeosStatement(7f35e541a140) Prepare 449us select ID,dat,typ,mid,termnam,mariadbver,pchrver,user_ as user,ctid,app,uid,dver,build,msg from reperrors where dat>? and dat<? order by dat desc
20220924 10405518  # SQL        mormot.db.sql.zeos.TSqlDBZeosStatement(7f35e541a140) ExecutePrepared 2.58s select ID,dat,typ,mid,termnam,mariadbver,pchrver,user_ as user,ctid,app,uid,dver,build,msg from reperrors where dat>20220913 and dat<20220925 order by dat desc

20220924 10412257  $  -    00.000.043
20220924 10412300  $  +    mormot.rest.memserver.TRestServerFullMemory(7f35e734bd10).URI POST central/v1/wbService.repsearch in=133 B
20220924 10412300  $ call       mormot.rest.memserver.TRestServerFullMemory(7f35e734bd10) IwbService.repsearch["{\"mver\":-1,\"typ\":-1,\"user\":-1,\"pver\":-1,\"tofind\":\"\",\"term\":-1,\"sdat\":\"2022-09-14\",\"edat\":\"2022-09-24\"}",0,20]
20220924 10412300  $  +         mormot.db.sql.zeos.TSqlDBZeosConnection(7f35e5360040).Connect
20220924 10412300  $ trace              Connect to mysql mpcentral for 127.0.0.1 at 3306:
20220924 10412300  $ DB                 Connected to 127.0.0.1 using mpcentral 10050017
20220924 10412300  $ DB                 mormot.db.sql.zeos.TSqlDBZeosStatement(7f35e51d01a0) Prepare 310us SELECT NOW()
20220924 10412300  $ SQL                mormot.db.sql.zeos.TSqlDBZeosStatement(7f35e51d01a0) ExecutePrepared 469us SELECT NOW()
20220924 10412300  $  -         00.006.507
20220924 10412300  $ DB         mormot.db.sql.zeos.TSqlDBZeosStatement(7f35e51d0460) Prepare 269us select ID,dat,typ,mid,termnam,mariadbver,pchrver,user_ as user,ctid,app,uid,dver,build,msg from reperrors where dat>? and dat<? order by dat desc
20220924 10412545  $ SQL        mormot.db.sql.zeos.TSqlDBZeosStatement(7f35e51d0460) ExecutePrepared 2.72s select ID,dat,typ,mid,termnam,mariadbver,pchrver,user_ as user,ctid,app,uid,dver,build,msg from reperrors where dat>20220913 and dat<20220925 order by dat desc
20220924 10433654  $ EXC        ESqlDBException {Message:"TSqlDBZeosStatement.FetchAllToJson: overflow 512 MB",Statement:{Sql:"select ID,dat,typ,mid,termnam,mariadbver,pchrver
,user_ as user,ctid,app,uid,dver,build,msg from reperrors where dat>? and dat<? order by dat desc",SqlWithInlinedParams:"select ID,dat,typ,mid,termnam,mariadbver,pchrver,user_
 as user,ctid,app,uid,dver,build,msg from reperrors where dat>20220913 and dat<20220925 order by dat desc",Cache:["scPossible","scOnClient"],CurrentRow:492294,TotalRowsRetriev
ed:0,Connection:{Connected:true,ServerTimestampAtConnection:"2022-09-24T13:41:23",TotalConnectionCount:1,TransactionCount:0,InTransaction:false,RollbackOnDisconnect:true,LastE
rrorMessage:"",LastErrorException:0,LastErrorWasAboutConnection:false,Properties:{Engine:"Zeos",ServerName:"127.0.0.1",DatabaseNameSafe:"mpcentral",UserID:"user",Dbms:"dMySQL"
,DbmsEngineName:"MySQL",BatchSendingAbilities:["cCreate","cUpdate","cDelete"],BatchMaxSentAtOnce:4096,LoggedSqlMaxSize:2048,LogSqlStatementOnException:false,ForcedSchemaName:"
",FilterTableViewSchemaName:false,UseCache:true,StatementMaxMemory:536870912,StatementCacheReplicates:0,RollbackOnDisconnect:true,EnsureColumnNameUnique:false,StoreVoidStringA
sNull:false,DateTimeFirstChar:84,VariantStringAsWideString:false,ExecuteWhenConnected:[]}},StripSemicolon:true}} [R2centralv1centralv0] at 7c6e6d ../../../../../Delphi
/G/mORMot2/src/db/mormot.db.sql.pas tsqldbstatement.fetchalltojson (6348) ../../../../../Delphi/G/mORMot2/src/db/mormot.db.sql.pas tsqldbstatement.fetchallasjson (6486) ../../
../../../Delphi/G/mORMot2/src/orm/mormot.orm.server.pas trestormserver.enginelist (1073) xxxx.services.impl.pas twbservice.repsearch (137)
20220924 10433656  $ srvr         POST central/v1/wbService.research Interface=200 out=15 B in 2m13
20220924 10433656  $ ret        mormot.rest.server.TRestServerRoutingRest(7f35e5350040) {"result":[[]]}