MODX Problems - SQL firing on server - leads to overload

284 Posts

novolo Reply #1, 15 years, 2 months ago

Hi all,

had an urgent call this evening. Client has copied an existing MODX site, changed all (config.inc.php / even in DB) settings. Now after working some hours on it, MODX fires dozens of SQL sessions to the server. Server’s going down!

MODX 2.1.0rc4 (works perfectly on original site)
as far as I know no special components / snippets.

What do you need to know?
Thanks!!!

MODX Free Template Base: MODX-Boilerplate | my blog (lots of MODX stuff) | my gitHub (translations) | MODX User Groups Germany (Facebook)

☆ A M B ☆
2,213 Posts

AMDbuilder Reply #2, 15 years, 2 months ago

Is the site getting a lot of traffic?

Patrick | Server Wrangler
About Me: Website | Tweets | MODX Hosting

284 Posts

novolo Reply #3, 15 years, 2 months ago

Quote from: AMDbuilder at Jul 21, 2011, 01:44 PM

Is the site getting a lot of traffic?

Site is offline. Only me and 1 other user.

MODX Free Template Base: MODX-Boilerplate | my blog (lots of MODX stuff) | my gitHub (translations) | MODX User Groups Germany (Facebook)

☆ A M B ☆
2,213 Posts

AMDbuilder Reply #4, 15 years, 2 months ago

What addons do you have installed?

Patrick | Server Wrangler
About Me: Website | Tweets | MODX Hosting

284 Posts

novolo Reply #5, 15 years, 2 months ago

Quote from: AMDbuilder at Jul 21, 2011, 01:45 PM

What addons do you have installed?

Wayfinder, selfLink, If. But seems to be somewhat other:

I deleted the page that had been edited before server overload. Now it runs again.
Nothing special in that page. Just some TVs, standard template, etc.

Any suggestions about that?

MODX Free Template Base: MODX-Boilerplate | my blog (lots of MODX stuff) | my gitHub (translations) | MODX User Groups Germany (Facebook)

1,572 Posts

Paulp Reply #6, 15 years, 2 months ago

just some TVs, standard template, etc.

Can you paste the code so we can have a look, seems weird that 1 page would cause that sort of load.

MODX Staff
730 Posts

netProphET Reply #7, 15 years, 2 months ago

Any access permissions set up? If so, how is it set up?

Mike Schell
Lead Developer, MODX Cloud
Email: [email protected]
GitHub: https://github.com/netProphET/
Twitter: @mkschell

☆ A M B ☆
2,213 Posts

AMDbuilder Reply #8, 15 years, 2 months ago

I agree, or if you restore the page does it still break?

Patrick | Server Wrangler
About Me: Website | Tweets | MODX Hosting

MODX Staff
730 Posts

netProphET Reply #9, 15 years, 2 months ago

Also details on caching setup might be useful.

Mike Schell
Lead Developer, MODX Cloud
Email: [email protected]
GitHub: https://github.com/netProphET/
Twitter: @mkschell

284 Posts

novolo Reply #10, 15 years, 2 months ago

Quote from: paulp at Jul 21, 2011, 02:01 PM

Can you paste the code so we can have a look, seems weird that 1 page would cause that sort of load.

Actually the content of the page was:
"Hello world." - not more.

with tpl:

<html>
<head>
<title>[[*pagetitle]]</title>
</head>
<body>
[[*content]]
</body>
</html>

Now after restoring the page doesn’t break the server again.

Standard caching of MODX was set up. Nothing more.

MODX Free Template Base: MODX-Boilerplate | my blog (lots of MODX stuff) | my gitHub (translations) | MODX User Groups Germany (Facebook)