Medusa Store Error Fix

$30-250 USD

Closed

Posted

about 2 months ago

$30-250 USD

Paid on delivery

fix a medusa 2.0 store error to fetch the products cn ot fetch products as the products catalogue above 100,000 [14:58:13.000] ERROR: message: "Maximum call stack size exceeded" stack: [ { "columnNumber": 16, "fileName": "/app/.medusa/server/node_modules/@mikro-orm/core/platforms/[login to view URL]", "functionName": "[login to view URL]", "lineNumber": 8, "methodName": "convertException", "native": false, "typeName": "PostgreSqlExceptionConverter" }, { "columnNumber": 22, "fileName": "/app/.medusa/server/node_modules/@mikro-orm/postgresql/[login to view URL]", "functionName": "[login to view URL]", "lineNumber": 42, "methodName": "convertException", "native": false, "typeName": "PostgreSqlExceptionConverter" }, { "columnNumber": 54, "fileName": "/app/.medusa/server/node_modules/@mikro-orm/core/drivers/[login to view URL]", "functionName": "[login to view URL]", "lineNumber": 201, "methodName": "convertException", "native": false, "typeName": "PostgreSqlDriver" }, { "columnNumber": 24, "fileName": "/app/.medusa/server/node_modules/@mikro-orm/core/drivers/[login to view URL]", "functionName": null, "lineNumber": 205, "methodName": null, "native": false, "typeName": null }, { "columnNumber": 5, "fileName": "node:internal/process/task_queues", "functionName": "processTicksAndRejections", "lineNumber": 95, "methodName": null, "native": false, "typeName": null }, { "columnNumber": 31, "fileName": "/app/.medusa/server/node_modules/knex/lib/formatter/[login to view URL]", "functionName": "unwrapRaw", "lineNumber": 104, "methodName": null, "native": false, "typeName": null }, { "columnNumber": 15, "fileName": "/app/.medusa/server/node_modules/knex/lib/formatter/[login to view URL]", "functionName": "wrap", "lineNumber": 80, "methodName": null, "native": false, "typeName": null }, { "columnNumber": 11, "fileName": "/app/.medusa/server/node_modules/knex/lib/query/[login to view URL]", "functionName": "[login to view URL] tableName [as tableName]", "lineNumber": 1472, "methodName": "get tableName [as tableName]", "native": false, "typeName": "QueryCompiler_PG" }, { "columnNumber": 13, "fileName": "/app/.medusa/server/node_modules/knex/lib/query/[login to view URL]", "functionName": "[login to view URL]", "lineNumber": 800, "methodName": "onlyJson", "native": false, "typeName": "QueryCompiler_PG" }, { "columnNumber": 25, "fileName": "/app/.medusa/server/node_modules/knex/lib/query/[login to view URL]", "functionName": "[login to view URL]", "lineNumber": 313, "methodName": "columns", "native": false, "typeName": "QueryCompiler_PG" }, { "columnNumber": 40, "fileName": "/app/.medusa/server/node_modules/knex/lib/query/[login to view URL]", "functionName": null, "lineNumber": 135, "methodName": null, "native": false, "typeName": null }, { "columnNumber": null, "fileName": null, "functionName": "[login to view URL]", "lineNumber": null, "methodName": "forEach", "native": false, "typeName": "Array" }, { "columnNumber": 16, "fileName": "/app/.medusa/server/node_modules/knex/lib/query/[login to view URL]", "functionName": "[login to view URL]", "lineNumber": 134, "methodName": "select", "native": false, "typeName": "QueryCompiler_PG" }, { "columnNumber": 29, "fileName": "/app/.medusa/server/node_modules/knex/lib/query/[login to view URL]", "functionName": "[login to view URL]", "lineNumber": 75, "methodName": "toSQL", "native": false, "typeName": "QueryCompiler_PG" }, { "columnNumber": 41, "fileName": "/app/.medusa/server/node_modules/knex/lib/formatter/[login to view URL]", "functionName": "unwrapRaw", "lineNumber": 102, "methodName": null, "native": false, "typeName": null } ] [14:58:13.000] USERLVL: message: "[login to view URL] - - [08/Dec/2024:14:58:13 +0000] "GET /store/products?limit=1&offset=10&region_id=reg_01JEE2P8Z6ESDR4XZPEHWNTDEB HTTP/1.1" 500 86 "-" "undici"" Previous attempts at increasing server resources have been unsuccessful. The solution should involve optimizing the SQL query to handle large data sets efficiently. Refactor the SQL query to improve efficiency and reduce load times. The current database structure is a single instance. Please prioritize this project to be completed as soon as possible.

Project ID: 38873776

About the project

11 proposals

Remote project

Active 11 days ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

11 freelancers are bidding on average $158 USD for this job

@prakash2813

⭐⭐⭐⭐⭐ Hi there, I am full stack developer with 7+ years of experience in website and desktop app development with Oracle, MySQL, MariaDB, Microsoft SQL Server, PostgreSQL, MongoDB and more. I have strong expertise in Database design, Database modeling, Database optimization, Database migration, SQL, PLSQL, Dynamic queries, pivot tables, Stored Procedures, Functions, Database Normalization, UML, ER Diagrams, Rational Schemas, Data dictionary and more. Have a look at my profile for my portfolio and similar projects I've completed with reviews. Message me, I would like to discuss further details over chat.

$150 USD in 1 day

4.9

(154 reviews)

6.7

@debkumarlab

I stand confident in my ability to fix your Medusa 2.0 store error and address the scalability issue you're facing with fetching products from a catalogue of over 100,000 items. With more than a decade of experience in the IT industry, I've encountered and solved numerous complex issues just like this one. My proficiency in Java, Node.js, PostgreSQL, and React Native will prove to be particularly advantageous as these are the exact technologies at play here. During my career, I have built a strong track record of delivering top-notch digital solutions. My commitment to embodying the 3As – Agility, Adaptability, and Availability – has ensured client satisfaction consistently. On that note, you can count on my code quality & service delivery to exceed your expectations. Furthermore, as your potential partner, I offer impeccable reliability and cost-effectiveness alongside excellent post-project support. Rest assured that even as we address this issue, your data remains safe. Given my successful history and extensive domain expertise including KOTLIN MERN STACK MEAN STACK LAMP STACK PHP LARAVEL SHOPIFY WORDPRESS WOOCOMMERCE PYTHON AI/ML BLOCKCHAIN CRYPTO to support your Medusa project. Let's break down this `Maximum call stack size exceeded` hurdle together! Best, DK

$250 USD in 4 days

5.0

(13 reviews)

4.8

@TelePathyInfoTec

Hi I am expertise in node.js and react.js. let me connect and solve your problem quickly. Waiting for your response. Thank you.

$200 USD in 7 days

0.0

(0 reviews)

0.0

@codingsparrow

Hhi I am experienced in this and I can start right now but i have few doubts and questions lets have a quick chat and get it started waiting for your replyyy ! r

$140 USD in 7 days

0.0

(0 reviews)

0.0

@sarwarsikder

Hello There, I understand your Medusa 2.0 store is encountering issues fetching products due to a large catalog. With extensive experience in database optimization and scalable system design, I can efficiently refactor your SQL queries to handle over 100,000 records, ensuring seamless performance. I will implement optimized pagination, indexing strategies, and query restructuring to minimize load times and eliminate errors. Your project's priority will be my focus, delivering a robust solution promptly. Let's connect to discuss further and resolve this issue effectively. Warm Regards, Sarwar Sikder

$200 USD in 7 days

0.0

(0 reviews)

0.0

@marko551

Hi Dear, As a senior full-stack developer skilled in optimizing the SQL query to handle large data sets efficiently. I have read your description carefully and I can fix it within one day. plz, feel free to ping me at any time. Looking forward to hearing from you. Best regards, Marko

$200 USD in 7 days

0.0

(0 reviews)

0.0

@engahsanali

Hello, I would be thrilled to assist in resolving the issue you're encountering with your Medusa 2.0 store. I understand that you're experiencing a "Maximum call stack size exceeded" error when fetching products due to a large product catalog, specifically above 100,000 items. This issue is likely related to inefficient SQL queries and database handling, and I can help optimize it. What I offer: - Refactoring of SQL queries to handle large data sets efficiently - Optimizing database indexing and query execution to improve performance - Debugging and fixing layout issues caused by the query overload - Configuring server settings and optimizing database operations to reduce load times - Conducting thorough testing to ensure smooth operation after the fix I look forward to collaborating on this project and delivering a swift resolution to improve your store's performance. Best regards, Ahsan A.

$30 USD in 10 days

0.0

(0 reviews)

0.0

@SrLiath

I have a solid background and extensive experience working with e-commerce platforms, including diagnosing and resolving a wide range of issues. With over three years of experience handling local freelance projects, where the majority of my work involved troubleshooting and fixing bugs in various systems, I am confident in my ability to address this challenge. I would be more than happy to carefully investigate the Medusa 2.0 store error where fetching products fails when the product catalog exceeds 100,000 items. I will thoroughly analyze the root cause and assist in finding the most effective solution to ensure seamless functionality.

$40 USD in 3 days