Log file Viewer

[02:45:34] <victorqueiroz> Is there any kind of embedded MongoDB?

[07:21:16] <elitas> hello, MongoDB 3.6 Release Signing Key has expired it is a new one ?

[08:04:04] <bz-> hi, .. i have a front end that provides images in base64. i want to send that to the server, and was wondering if i should first convert it to binary, or keep it in base64, and which is better for mongodb, or should i just use the FS?

[10:41:12] <Derick> elitas: I've heard that in another place too.

[10:43:15] <Bodenhaltung> Hi, i have upgraded for php7.2 from 1.5.2 to 1.5.3. Now some querys doesnt work, i get no error, the aggregate query doesnt find anything...i cant find nothing about that in the changelog, have you any suggestions?

[10:45:40] <Derick> Bodenhaltung: you need to be a bit more specific, it seems unlikely that that was changed between 1.5.2 and 1.5.3: https://github.com/mongodb/mongo-php-driver/compare/1.5.2...1.5.3

[10:49:18] <Bodenhaltung> Derick: Ok, i am at debuging, this Aggregate Query find nothing after the update: https://nopaste.xyz/?178297db0805ede5#RJXY2FYowvbHN2KyMO+VJhfUGQBqGSS/fWWeDuWvQaE=

[10:49:58] <Derick> that's not your query

[10:51:38] <Bodenhaltung> Sorry, here is the plain Query for aggregate: https://nopaste.xyz/?7cb360ca987d85a3#mzXHoSS+3xUNf0igrA8AfllEPL3VGegu0oAN3Sh8Svg=

[10:55:53] <Derick> why are you adding 3600000 to the $reg.datum?

[10:55:57] <Derick> MongoDB does timezones now

[10:59:13] <Derick> other than that, that looks good. Can I see a document or two too?

[11:00:36] <Bodenhaltung> Derick: Thats my timezone workaround, i need to implement native support asap :)

[11:04:31] <Bodenhaltung> Derick: Thanks for looking. :) 2 Documents: https://nopaste.xyz/?9560ea0d901c6838#oo0DNAfWTXRpEf3ZCZeYGf4Ze606jZkhWItkzSFOgO8=

[11:07:03] <Derick> Bodenhaltung: both these documents have a reg.datum in 2013, so of course they aren't found if you're looking for days in the last month?

[11:09:09] <Bodenhaltung> I know, thats old document, i paste some new

[11:12:59] <Bodenhaltung> Derick: Latest Documents: https://nopaste.xyz/?5f17b5c1c5804bb2#SndwZ5yW7JKG4G4FPoLvvqRcNM+DjLBbr9RGr4h/7Dc=

[11:26:49] <Bodenhaltung> Ah, and: "name": "mongodb/mongodb", "version": "1.4.2",

[11:34:33] <Derick> hmm, i can't see why that wouldn't work

[11:34:39] <Derick> Did you try running the A/F query on the shell?

[11:35:15] <Bodenhaltung> hmm, no only with php.

[11:36:15] <Bodenhaltung> i am afk a few minutes, brb.

[12:19:25] <negaduck> hello. Any idea how to write a query like this? db.account.find({'ab./.*/.x./.*/'})? Someone, not me, stores objects under keys, not in an array. So I have to traverse keys of `ab` first, then keys of `x`.

[12:24:19] <Derick> negaduck: no... don't use values as keys :-/

[12:34:21] <Bodenhaltung> Derick: Can you rephrase it for mongodb shell? I had no luck with that.

[12:46:35] <Bodenhaltung> Ok, i have reverted to 1.5.2, problem still there...so it seems to be only my problem. :D

[12:49:35] <Bodenhaltung> Strange, i have no idea...

[13:18:30] <Bodenhaltung> Hmm, okay.

[13:18:51] <Bodenhaltung> db.users.find({ "reg.datum": { $gte:ISODate("2018-12-16T00:00:00Z"), $lt: ISODate("2018-12-17T00:00:00Z") } }).count() --- Shows 11.

[13:21:51] <Bodenhaltung> So it seems the problem should be in "MongoDB\BSON\UTCDateTime Object"

[13:35:11] <CDuv> Hello, a node from my 3-node sharded cluster went out of disk space: Now I cannot make one shard to come back to life... systemd get a "timeout was exceeded" when trying to start mongod and I get a BACKTRACE in the log « exception in initAndListen: UnknownError: assertion src/mongo/db/initialize_server_global_state.cpp:103, terminating »

[13:36:36] <CDuv> Is there a documentation on how recover for a out-of-disk-space error ?

[14:17:41] <Bodenhaltung> Is this the right way? Storing dates as "ISODate" and trying to query with "UTCDateTime Object"?

[14:22:19] <Bodenhaltung> Derick: If you have a minute, can you check these code? https://nopaste.xyz/?49d876cc45e0483c#RLyphAIp0lKi+CwT/pb4xR8OkZEnRJ3CsSLN9RPABIw= I am sure that code runs since 4 Years without problems until now...can you maybe point me in the right direction?

[14:31:58] <Derick> Bodenhaltung: that looks OK

[14:33:22] <Bodenhaltung> Mhhh

[14:34:13] <Derick> I wouldn't have first created a UTCDateTime though

[14:34:32] <Derick> oh hang on

[14:34:38] <Derick> nv

[14:34:47] <Derick> You don't use the vars from line 4 and 5

[14:36:12] <Derick> Bodenhaltung: what happens if you just do the match?

[14:38:13] <Bodenhaltung> Derick: Also only the match find nothing :(

[14:39:42] <Derick> can you do a var_dump of $dateStartQ ?

[14:39:54] <Derick> and are you sure you're talking to right database and collection?

[14:42:25] <Bodenhaltung> Derick: Sure, var_dump: object(MongoDB\BSON\UTCDateTime)#8 (1) { ["milliseconds"]=> string(13) "1543618800000" }

[14:42:26] <kraem> hi! just started with mongodb for a school project. so far i've set up a mongod on a ubuntu box but i had to reinstall a couple of times before i got the hang of it. while examining the users in the "admin" db there's a user "admin.admin" is this standard or did i somehow create this user during my setup? thank you in advance!

[14:43:10] <Derick> Bodenhaltung: that looks good too, wtf.

[14:54:59] <Bodenhaltung> Derick: I have no idea why, but if i disable "ReadPreference" in my aggregate Funktion, it is working...https://nopaste.xyz/?195a3c31c2693fdf#OVlWU0qKhUSzdq6fvMDNNgCxQIMfuggSKNEcl13VA3k=

[14:55:11] <Derick> that makes little sense

[14:56:04] <Derick> Bodenhaltung: this could well be a bug as we did change something related to this between 1.5.2 and 1.5.3

[14:56:12] <Derick> you do have a replicaset environment though?

[14:56:52] <Bodenhaltung> Derick: Yes, ReplicaSet with 3 Nodes

[14:57:54] <Derick> I'll have a look locally after my upcoming meeting

[14:59:14] <Bodenhaltung> Ok, i have also to go now, i look tonight/tomorrow here again.

[14:59:23] <Bodenhaltung> Thanks for your help :)

[14:59:30] <Derick> k

[15:02:40] <Bodenhaltung> I im not really sure if it is a bug or my buggy programming. xD

[15:02:54] <Bodenhaltung> I will check later/tomorrow

[19:30:56] <binarylegit> Had a question: We have a third party tool that connects to a secondary member of a MongoDB replicaset, however it seems like it needs to also have access to our primary server in order to establish it's connection before reading from the secondary. Does that sound correct or is there some configuration that can change to prevent it from needing to connect to the primary?

[19:31:22] <Derick> that does not sound correct

[19:31:55] <Derick> There is no config for this on the MongoDB side

[19:33:28] <binarylegit> @Derick: Ok thanks, so is that possibly a configuration change that the third party tool would need to make?

[19:33:54] <Derick> it's possible... I can't really tell.

[19:37:28] <binarylegit> @Derick: ok, thanks

[23:51:30] <Bodenhaltung> Ok, my fault. Sorry Derick.