Hi , So I tried using jdbc:postgresql://host:port/database?defaultRowFetchSize=10 And this didn't work and I again got Out Of Memory exception.
When i debbuged I found that (https://github.com/apache/jackrabbit-oak/blob/5af43cb29fb6cfc226eac6f89bf4985d7ce6d89f/oak-store-document/src/main/java/org/apache/jackrabbit/oak/plugins/document/rdb/RDBDocumentStoreJDBC.java#L590>) the limit in the above code is not changes and it is the value of MAX INT Value. ________________________________________ From: Julian Reschke <[email protected]> Sent: 21 October 2020 19:47 To: Tanvi Shah; [email protected] Subject: Re: Error in S3 Garbage Collection [External - Use Caution] So, what *exactly* did you try? And was the outcome exactly the same as before? Best regards, Julian Am 21.10.2020 um 15:20 schrieb Tanvi Shah: > Hi Julian, > Tried by adding 'defaultRowFetchSize' but it is still taking by default INT > value. > > Thanks. > ________________________________________ > From: Julian Reschke <[email protected]> > Sent: 21 October 2020 16:45 > To: Tanvi Shah; [email protected] > Subject: Re: Error in S3 Garbage Collection > > [External - Use Caution] > > Am 21.10.2020 um 12:41 schrieb Tanvi Shah: >> Hi, >> >> I couldn't find the option to set the limit for Query in S3 >> GC.(<https://urldefense.proofpoint.com/v2/url?u=https-3A__jdbc.postgresql.org_documentation_head_connect.html-23connection-2Dparameters&d=DwIFaQ&c=vh6FgFnduejNhPPD0fl_yRaSfZy8CWbWnIf4XJhSqx8&r=efxn8UeXcSHRO_QY23J3UMMNiX9eCS4lSzRWxErP-mo&m=2N5ynCyAkZxKcJP11i0_6FDBn8Kw93vA28vW0r9BBKk&s=CEhXZpXVRZp6VkG8bD6ErEfknIhyE59yHp8STPA2huM&e= >> <https://urldefense.proofpoint.com/v2/url?u=https-3A__jdbc.postgresql.org_documentation_head_connect.html-23connection-2Dparameters&d=DwIFaQ&c=vh6FgFnduejNhPPD0fl_yRaSfZy8CWbWnIf4XJhSqx8&r=efxn8UeXcSHRO_QY23J3UMMNiX9eCS4lSzRWxErP-mo&m=2N5ynCyAkZxKcJP11i0_6FDBn8Kw93vA28vW0r9BBKk&s=CEhXZpXVRZp6VkG8bD6ErEfknIhyE59yHp8STPA2huM&e= >> >>). >> ... > > Citing above: > >> defaultRowFetchSize = int >> >> Determine the number of rows fetched in ResultSet by one fetch with trip to >> the database. Limiting the number of rows are fetch with each trip to the >> database allow avoids unnecessary memory consumption and as a consequence >> OutOfMemoryException. >> >> The default is zero, meaning that in ResultSet will be fetch all rows at >> once. Negative number is not available. > > So something like > > jdbc:postgresql://host:port/database?defaultRowFetchSize=1000 > > might do it. > > Best regards, Julian > > ********************************************************************** > Disclaimer: This e-mail is confidential and should not be used by anyone who > is not the original intended recipient. If you have received this e-mail in > error please inform the sender and delete it from your mailbox or any other > storage mechanism. Springer Nature Technology and Publishing Solutions > Private Limited does not accept liability for any statements made which are > clearly the sender's own and not expressly made on behalf of Springer Nature > Technology and Publishing Solutions Private Limited or one of their agents. > Please note that Springer Nature Technology and Publishing Solutions Private > Limited and their agents and affiliates do not accept any responsibility for > viruses or malware that may be contained in this e-mail or its attachments > and it is your responsibility to scan the e-mail and attachments (if any). > Springer Nature Technology and Publishing Solutions Private Limited. > Registered office: Upper Ground Floor, Wing B, Tower 8, Magarpatta City SEZ, > Hadapsar Pune MH 411013 IN > Registered number: U72200PN2006FTC128967 >
