00 Server Error after deploy endpoint and change so SQL tables names ,why?
126 views
Skip to first unread message
Guy Dviri
May 5, 2021, 8:01:32 PM5/5/21
to Google App Engine
<html><head>
<meta http-equiv="content-type" content="text/html;charset=utf-8">
<title>500 Server Error</title>
</head>
<body text=#000000 bgcolor=#ffffff>
<h1>Error: Server Error</h1>
<h2>The server encountered an error and could not complete your request.<p>Please try again in 30 seconds.</h2>
<h2></h2>
</body></html>
Felipe Bergallo Corral
May 11, 2021, 4:25:22 AM5/11/21
to Google App Engine
Pardon, but that's... A bit ambiguous. 500 server error is any error within the server itself, which can refer to either the endpoint server or the sql server, would you kindly elaborate?
Felipe Bergallo Corral
May 11, 2021, 4:27:12 AM5/11/21
to Google App Engine
To be clear, would you kindly either elaborate on the changes you've performed that have lead you to this error? Or possibly look into the logs found within the Logs Explorer to see if there's a more specific error in there?
Guy Dviri
May 11, 2021, 4:59:19 AM5/11/21
to google-a...@googlegroups.com
ambiguous or not this was the only error I've got , so what can I do to figure this out?
anyway solve it after almost 3 days,, the problem was probably using jdk 16.1 instead of 11.
if the log can give me clues about it , that would save me some time ,and maybe save time for others.
thanks.
--
You received this message because you are subscribed to a topic in the Google Groups "Google App Engine" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-appengine/B73PhqjzURI/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-appengi...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-appengine/7e5bb483-668c-42bc-a37c-ff431f5147b6n%40googlegroups.com.
Felipe Bergallo Corral
May 11, 2021, 5:39:08 AM5/11/21
to Google App Engine
Well, a good jumping off point for debugging an endpoint would be the endpoint logs, following the documentation associated with it.
Following that, if the information there isn't very clear, then the issue might be in the backend, which in this case would be your SQL instance; if this SQL instance is a CloudSQL instance, then you merely need to follow the documentation associated with that. On the other hand, if your SQL instance is inside of a Compute Engine Instance or an App Engine Instance, then you might find something in the logs of those instances, however, I believe you'll have more luck accessing the logs inside of the SQL instance itself if that's the case.
That being said any advice I give on the logs of a SQL instance can be muddy because I'm not sure what SQL instance you're using? CloudSQL offers MySQL, PostgreSQL and Microsoft SQL Server, so I am somewhat well versed in those three, however if you use a different solution then my attempts at helping will mostly be a best-effort on my part, because I can't guarantee that I'll be very knowledgable.
That being said, it would be nice to have a minimum reproducible example of your code? Y'know, just the basics of how you attempt to access instance, and the query you're trying to perform. Obviously we don't need to know the keys or anything exact about it, it's best to avoid any personal or private information getting in there.
Following that, if the information there isn't very clear, then the issue might be in the backend, which in this case would be your SQL instance; if this SQL instance is a CloudSQL instance, then you merely need to follow the documentation associated with that. On the other hand, if your SQL instance is inside of a Compute Engine Instance or an App Engine Instance, then you might find something in the logs of those instances, however, I believe you'll have more luck accessing the logs inside of the SQL instance itself if that's the case.
That being said any advice I give on the logs of a SQL instance can be muddy because I'm not sure what SQL instance you're using? CloudSQL offers MySQL, PostgreSQL and Microsoft SQL Server, so I am somewhat well versed in those three, however if you use a different solution then my attempts at helping will mostly be a best-effort on my part, because I can't guarantee that I'll be very knowledgable.
That being said, it would be nice to have a minimum reproducible example of your code? Y'know, just the basics of how you attempt to access instance, and the query you're trying to perform. Obviously we don't need to know the keys or anything exact about it, it's best to avoid any personal or private information getting in there.
Guy Dviri
May 11, 2021, 6:18:56 AM5/11/21
to google-a...@googlegroups.com
The code is the same code , what I did is just move my SRC files without the gradles build files ,from the app & the appengine to an old copy of the project that I have..
then I asked if I want to upgrade the JDK ,or keep the 11 version. I choose to keep the 11 jdk version of the old project and deploy.
And just then It's works.
sorry I can reproduce the problem ,because I'm cant afford to trap myself inside this nightmare again.
any I lost the original screenshot but when I open the AS after transporting the new files to the old project ,i've get this message from this menu:
but it doesn't was that ....it was something similar to that, asking me to choose JDK. ( I can't find the exact menu after approval. ,sorry )
thanks Guy.
By the way ,can you pls help enter my endpoint portal , I have all the certification and still can't choose API ,why?
To view this discussion on the web visit https://groups.google.com/d/msgid/google-appengine/7012dd71-5075-4f9b-8a3b-2ab77ac54646n%40googlegroups.com.
Felipe Bergallo Corral
May 12, 2021, 11:58:20 AM5/12/21
to Google App Engine
While the code may be "the same code", I've yet to see it? Which is why I was asking for it, I don't know the code so I can't say for sure if it's set up in a way that would only function in one environment or what might be needed to be changed.
Also, the screen capture you're sharing is from Android Studio, I believe? And this forum is for App Engine, so I'm guessing that's not the image you've meant to send?
You mention that you've migrated the build and were asked if you wanted to upgrade the JDK or keep the 11 version, and you chose to keep version 11 and that made it work. This implies that you might need to change your code so that it is compatible with more recent versions of JDK; but the App Engine's most recent version of JDK is Java 11, so there shouldn't be any issue there.
Also... what do you mean enter your endpoint portal? I don't see where it is that you shared it...
Also, the screen capture you're sharing is from Android Studio, I believe? And this forum is for App Engine, so I'm guessing that's not the image you've meant to send?
You mention that you've migrated the build and were asked if you wanted to upgrade the JDK or keep the 11 version, and you chose to keep version 11 and that made it work. This implies that you might need to change your code so that it is compatible with more recent versions of JDK; but the App Engine's most recent version of JDK is Java 11, so there shouldn't be any issue there.
Also... what do you mean enter your endpoint portal? I don't see where it is that you shared it...
Guy Dviri
May 12, 2021, 12:13:34 PM5/12/21
to google-a...@googlegroups.com
Why can't I enter this portal?
So you see, GAE is only JDK 11, so I can't upgrade to JDK 16.1 ,so that was the problem ,wasn't it? do you have another explanation?
To view this discussion on the web visit https://groups.google.com/d/msgid/google-appengine/12a7fd82-e641-4337-b426-d5194c2938abn%40googlegroups.com.
wesley c
May 12, 2021, 1:51:41 PM5/12/21
to google-a...@googlegroups.com
As mentioned earlier, there's no way *anyone* can help you without more information.That kind error *could* be using features in Java that aren't in JDK11, or even a typo in your code. I would bet that a stack trace with your error from Cloud Logging would be quite useful to share. Sure, moving to a PaaS cloud is great because you don't have to worry about infrastructure, but that system should still give you the tools to help debug your application, and logging is the most important, perhaps even more important than the code itself, esp. if it was working before and you haven't changed anything other than the JDK version and redeployed.
Also, are you *sure* you're using App Engine? I'm not a PCF user but thought it only worked with Compute Engine VMs, at least from our documentation page on it. I mean, they're kind-of competitors where Cloud Foundry "stitches" cloud resources (VMs) together to form a PaaS whereby App Engine is itself a self-contained PaaS system.
You received this message because you are subscribed to the Google Groups "Google App Engine" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-appengi...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-appengine/CAMk5Y2c0WJnUdHo2c7C3WYWegHc7QtEqPiovwX6LD%2BFfbkzc5Q%40mail.gmail.com.
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
"A computer never does what you want... only what you tell it."
wesley chun :: @wescpy :: Software Architect & Engineer
Developer Advocate at Google Cloud by day; at night...
"A computer never does what you want... only what you tell it."
wesley chun :: @wescpy :: Software Architect & Engineer
Developer Advocate at Google Cloud by day; at night...
Python training & consulting : http://CyberwebConsulting.com
"Core Python" books : http://CorePython.com
Python blog: http://wescpy.blogspot.com
"Core Python" books : http://CorePython.com
Python blog: http://wescpy.blogspot.com
Felipe Bergallo Corral
May 13, 2021, 3:38:49 AM5/13/21
to Google App Engine
Mr Dviri, when I enter said portal I see the exact same content that you've displayed in your screen capture image. From what I can discern from the index.html, it seems like I don't have permission to view any of the APIs, so if what you wish to be able to do is see the APIs then what's wrong might just be that you've not set up the permissions within Endpoints that allow you to see the APIs.
Aside from that, I'm afraid I must concur with Wesley C. on not being able to discern the cause without at least an MRE or a small tidbit of the logs... It'd be like being told to throw darts in the dark, blindfolded, not knowing where the board even is. I might manage to hit the board somehow? But it's unlikely.
As for not using PCF, well, I'm not sure about that. As far as I know I don't think you are using it as all the screenshots you've sent, well, both of them are using Google products and not Cloud Foundry. But it doesn't hurt to ask so... Are you using Cloud Foundry?
Aside from that, I'm afraid I must concur with Wesley C. on not being able to discern the cause without at least an MRE or a small tidbit of the logs... It'd be like being told to throw darts in the dark, blindfolded, not knowing where the board even is. I might manage to hit the board somehow? But it's unlikely.
As for not using PCF, well, I'm not sure about that. As far as I know I don't think you are using it as all the screenshots you've sent, well, both of them are using Google products and not Cloud Foundry. But it doesn't hurt to ask so... Are you using Cloud Foundry?
Guy Dviri
May 13, 2021, 3:52:06 AM5/13/21
to google-a...@googlegroups.com
Felipe Felipe , i don't need help right now , that problem with the 500 error solved last saturday .
And I don't use Cloud Foundry ., never seen the logo of this product before.
about the endpoint just let me know if you want to view my log ,and I'll add you as a viewer ,have no problem with that ,
what excelly do you need to help me viewing my endpoint portal,because I've already done all the auth process ,and still I can't access my endpoint portal , why?
Guy
To view this discussion on the web visit https://groups.google.com/d/msgid/google-appengine/f6704f65-570a-45e1-b399-e8d39191503fn%40googlegroups.com.
Felipe Bergallo Corral
May 13, 2021, 4:50:51 AM5/13/21
to Google App Engine
Mr Dviri, as I implied when I linked the permissions setup for endpoints, it's not an authentication issue if what you see is that screen capture that you've sent, it's that you've not given the user you're using access to the APIs you wish to modify.
Basically, you'd have to grant the user you're using to log into the Developer Portal the Service Consumer role (the italics are to make it easier to discern subject and object in the sentence, pardon), which is indicated in the following text when you access the link provided in the documentation I've previously mentioned:
"
PS:
I don't know what the intent was behind "Felipe Felipe", I imagine it was said with no ill intent, but I would like to inform you that it does come off as... slightly, just a little bit condescending. Again, I imagine that it was not your intent, I too have a bit of trouble conveying tone from time to time when talking through text, so I figured I ought to give you a heads-up.
Basically, you'd have to grant the user you're using to log into the Developer Portal the Service Consumer role (the italics are to make it easier to discern subject and object in the sentence, pardon), which is indicated in the following text when you access the link provided in the documentation I've previously mentioned:
"
If you want to give someone the ability to enable your service in their own Cloud project and invoke its APIs, give them the Service Consumer role.
"
PS:
I don't know what the intent was behind "Felipe Felipe", I imagine it was said with no ill intent, but I would like to inform you that it does come off as... slightly, just a little bit condescending. Again, I imagine that it was not your intent, I too have a bit of trouble conveying tone from time to time when talking through text, so I figured I ought to give you a heads-up.
Guy Dviri
May 13, 2021, 5:16:26 AM5/13/21
to google-a...@googlegroups.com
no tone at all , I one how's deeply appreciated support.
and I like to thanks you for yours reply ,I don't take yours replies as granted,
To view this discussion on the web visit https://groups.google.com/d/msgid/google-appengine/ab750004-8c12-40de-9c76-ad6303a50761n%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages