l: [PERF] Script start: 0.000s (total: 0.000s)
l: [PERF] Before DB connection: 0.005s (total: 0.005s)
( ! ) Warning: file_put_contents(/var/www/mssql.danmarcrm.com/dev1/bMonV3/logs2/mongodb-migration/mongo_2026-03-10.log): failed to open stream: Permission denied in /var/www/mssql.danmarcrm.com/dev1/bMonV3/mongodb/MongoLogger.php on line 44
Call Stack
#TimeMemoryFunctionLocation
10.0168443248{main}( ).../report_pricing_v1.php:0
20.0244490992mongodb( ).../report_pricing_v1.php:843
30.0244491776MongoConnection::getInstance( $config = ['host' => '127.0.0.1', 'port' => 27017, 'database' => 'booking_analysis', 'username' => NULL, 'password' => NULL, 'debug' => TRUE] ).../db.php:26
40.0244491936MongoConnection->__construct( $config = ['host' => '127.0.0.1', 'port' => 27017, 'database' => 'booking_analysis', 'username' => NULL, 'password' => NULL, 'debug' => TRUE] ).../MongoConnection.php:82
50.0244493176MongoConnection->connect( ).../MongoConnection.php:46
60.0256503776MongoLogger->success( $message = 'Connected to MongoDB database: booking_analysis', $context = ??? ).../MongoConnection.php:60
70.0256503776MongoLogger->log( $level = 'SUCCESS', $message = 'Connected to MongoDB database: booking_analysis', $context = [] ).../MongoLogger.php:86
80.0256504144file_put_contents( $filename = '/var/www/mssql.danmarcrm.com/dev1/bMonV3/logs2/mongodb-migration/mongo_2026-03-10.log', $data = '[2026-03-10 00:02:37] [SUCCESS] Connected to MongoDB database: booking_analysis\n', $flags = 10 ).../MongoLogger.php:44

l: [PERF] After DB connection: 0.004s (total: 0.008s)
l: [PERF] Before optimized room-level aggregation: 0.005s (total: 0.014s)
( ! ) Warning: file_put_contents(/var/www/mssql.danmarcrm.com/dev1/bMonV3/logs2/mongodb-migration/mongo_2026-03-10.log): failed to open stream: Permission denied in /var/www/mssql.danmarcrm.com/dev1/bMonV3/mongodb/MongoLogger.php on line 44
Call Stack
#TimeMemoryFunctionLocation
10.0168443248{main}( ).../report_pricing_v1.php:0
20.0321801864MongoConnection->aggregate( $collection = 'room_details', $pipeline = [0 => ['$match' => [...]], 1 => ['$addFields' => [...]], 2 => ['$group' => [...]], 3 => ['$sort' => [...]]] ).../report_pricing_v1.php:970
37.1214813632MongoLogger->error( $message = 'Aggregate failed', $context = ['collection' => 'room_details', 'error' => 'Sort exceeded memory limit of 104857600 bytes, but did not opt in to external sorting. Aborting operation. Pass allowDiskUse:true to opt in.'] ).../MongoConnection.php:352
47.1214813632MongoLogger->log( $level = 'ERROR', $message = 'Aggregate failed', $context = ['collection' => 'room_details', 'error' => 'Sort exceeded memory limit of 104857600 bytes, but did not opt in to external sorting. Aborting operation. Pass allowDiskUse:true to opt in.'] ).../MongoLogger.php:82
57.1214814368file_put_contents( $filename = '/var/www/mssql.danmarcrm.com/dev1/bMonV3/logs2/mongodb-migration/mongo_2026-03-10.log', $data = '[2026-03-10 00:02:44] [ERROR] Aggregate failed | {"collection":"room_details","error":"Sort exceeded memory limit of 104857600 bytes, but did not opt in to external sorting. Aborting operation. Pass allowDiskUse:true to opt in."}\n', $flags = 10 ).../MongoLogger.php:44

l: [PERF] End of PHP processing: 7.093s (total: 7.106s)
l: [PERF] Performance Summary (Total: 7.107s) ============================================================ Script start : 0.000s (total: 0.000s) Before DB connection : 0.005s (total: 0.005s) After DB connection : 0.004s (total: 0.008s) Before optimized room-level aggregation : 0.005s (total: 0.014s) End of PHP processing : 7.093s (total: 7.106s) ============================================================ : 0.000s (total: 7.107s) Pricing vs Market – Room Detail Timeline (V1)

πŸ“Š Market Intelligence Dashboard V1

Click to add hotel ID:
Error Loading Data

Error: Sort exceeded memory limit of 104857600 bytes, but did not opt in to external sorting. Aborting operation. Pass allowDiskUse:true to opt in.


Full error details logged to: __php_error.log