PRESERVING SERVER-CLIENT SESSION CONTEXT

• US 20130066952A1
• Filed: 07/05/2012
• Published: 03/14/2013
• Est. Priority Date: 09/09/2011
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Colrain, Carol L., Neel, Kevin S., Hung, Hochak
• Granted Patent: US 9,600,371 B2
• Time in Patent Office: Days
• US Class Current: 709/203
• CPC Class Codes: G06F 11/1438 Restarting or rejuvenating
• CPC Class Codes: G06F 2201/80 Database-specific techniques

Abstract

Methods, devices, and storage media are provided for preserving the context of a server-client session. A server generates an initial context and a context for each user command executed in a first session and sends context to a client with the return for each command. The context describes software, session state, returned data, and/or hardware characteristics of a server-side environment for the first session. The client receives and stores the context with each user command. Upon determining that the database session should be rebuilt in the second session, the client sends initial context. A server for the second session receives the initial context and determines whether commands should be replayed in the second session. If commands are replayed, the server validates that server environment and client-visible results for each command in the second session match that from execution in the first session using the context for that command.

Claims

1. A method comprising:

a client machine storing

one or more commands of a set of commands that were sent for execution in a first server-client session, wherein the first server-client session is distinguished from one or more other server-client sessions by one or more items of server-side environment information;

a client machine sending the one or more commands and the one or more items of server-side environment information in a second server-client session, wherein, before receiving the one or more items of server environment information, the second server-client session differs from the first server-client session with respect to at least one of the one or more items of server environment information.

2. The method of claim 1, further comprising:

the client machine detecting unavailability of the first server-client session;

wherein sending the one or more commands and the one or more items of server-side environment information is performed by the client machine in response to detecting the unavailability of the first server-client session.

3. The method of claim 1, wherein the second server-client session is compatible with the one or more items of server-side environment information, further comprising receiving an indication that the one or more commands were successfully completed in the second server-client session.

4. The method of claim 1, wherein the second server-client session is incompatible with the one or more items of server-side environment information, further comprising receiving an indication that the one or more commands were not successfully completed in the second server-client session.

5. The method of claim 1, wherein the one or more items of server-side environment information comprise one or more characteristics of server-side hardware used in the first server-client session.

6. The method of claim 1, wherein the one or more items of server-side environment information comprise one or more characteristics of server-side software used in the first server-client session.

7. The method of claim 1, further comprising:

the client machine receiving, in the first server-client session, the one or more items of server-side environment information for each command issued;

wherein the client machine sending, in the second server-client session, the one or more items of database server-side environment information comprises the client machine sending the one or more items of server-side environment information as received in the first server-client session, without modification by the client machine, for each command replayed.

8. The method of claim 1, wherein the one or more items of server-side environment information and validation information for that call are appended to a message that is received in response to execution of the one or more commands in the first server-client session.

9. One or more non-transitory storage media storing instructions which, when executed by one or more computing devices, cause performance of the method of claim 1.

26. The method of claim 1, wherein the one or more items of server-side environment information comprise protocol ordering information such that a command issued from the client is accepted or rejected for execution in the second server-client session.

27. The method of claim 1, wherein the one or more items of server-side environment information comprise one or more characteristics of server-side state that allows the second server-client session to be built to a same state that the first server-client session was built.

28. The method of claim 1, wherein the one or more items of server-side environment information comprise one or more characteristics of the data returned from command execution in the first server-client session that allows validation of data returned from command execution in the second server-client session.

10. A method comprising:

a server machine in a second server-client session receiving, from a client;

one or more items of server-side environment information for a first server-client session on which a set of commands was previously sent for execution; and

one or more commands of the set of commands for execution in the second server-client session;

in response to receiving the one or more items of server-side environment information, the server machine determining whether or not the server machine is compatible with the one or more items of server-side environment information to start executing the one or more commands in the second server-client session.

11. The method of claim 10, wherein the one or more items of server-side environment information comprise one or more characteristics of hardware used in the first server-client session.

12. The method of claim 10, wherein the one or more items of server-side environment information comprise one or more characteristics of software used in the first server-client session.

13. The method of claim 10, further comprising:

in response to determining that the second server-client session is incompatible with the one or more items of server-side environment information or that execution of the commands in the second server-client session is not valid based on the one or more items of server-side environment information, the server machine indicating, to the client, that the first server-client session cannot be restored on the second server-client session.

14. The method of claim 10, further comprising:

in response to determining that the first server-client session is compatible with the one or more items of server-side environment information, the server machine executing the set of commands in the second server-client session, and, for each command, using the one or more items of server-side environment information to validate a result of that command in the second session

15. The method of claim 14, further comprising:

verifying that second client-visible results of executing each command in the second server-client session match first client-visible results of executing each command in the first server-client session as each command is executed; and

if the second client-visible results do not match the first client-visible results or server state has diverged for any command, the server machine indicating, to the client, that the first server-client session cannot be restored on the second server-client session.

16. The method of claim 10, wherein the one or more items of server-side environment information were appended to each message that was sent to the client in response to execution of the one or more commands in the first server-client session.

17. The method of claim 10, wherein the one or more items of server-side environment information include one or more of:

an identity of an underlying database of the first server-client session, a type of the underlying database of the first server-client session, a logical state or time of the underlying database of the first server-client session, a hardware platform that is used for the first server-client session, endianness or other storage format characteristics for the first server-client session, session state signature or hash used to determine that the session state is correct for replay, security credentials used for the first server-client session, protocol information to ensure that execution in the second server-client session is in a correct order, original values that were returned from function calls in the first server-client session, versions of data against which commands were executed in the first server-client session, and an optimizer execution plan that preserves an output order of commands in the first server-client session.

29. The method of claim 10, further comprising, after determining that the server machine is compatible with the one or more items of server-side environment information to start execution of the one or more commands in the first server-client session, using one or more items of server-side environment information to validate execution of the one or more commands on a command-by-command basis.

30. The method of claim 10, wherein the one or more items of server-side environment information comprise one or more characteristics of server-side state that allows the second server-client session to be built to a same state that the first server-client session was built.

31. The method of claim 10, wherein the one or more items of server-side environment information comprise one or more characteristics of the data returned from command execution in the first server-client session that allows validation of data returned from command execution in the second server-client session.

18. One or more non-transitory storage media storing instructions which, when executed by one or more computing devices, cause performance of:

a server machine in a second server-client session receiving, from a client;

one or more items of server-side environment information for a first server-client session on which a set of commands was previously sent for execution; and

one or more commands of the set of commands for execution in the second server-client session;

in response to receiving the one or more items of server-side environment information, the server machine determining whether or not the server machine is compatible with the one or more items of server-side environment information to start executing the one or more commands in the second server-client session.

19. The one or more non-transitory storage media of claim 18, wherein the one or more items of server-side environment information comprise one or more characteristics of hardware used in the first server-client session.

20. The one or more non-transitory storage media of claim 18, wherein the one or more items of server-side environment information comprise one or more characteristics of software used in the first server-client session.

21. The one or more non-transitory storage media of claim 18, wherein the instructions, when executed, further cause performance of:

in response to determining that the second server-client session is incompatible with the one or more items of server-side environment information, the server machine indicating, to the client, that the first server-client session cannot be restored on the second server-client session.

22. The one or more non-transitory storage media of claim 18, wherein the instructions, when executed, further cause performance of:

in response to determining that the second server-client session is compatible with the one or more items of server-side environment information, the server machine executing the set of commands in the second server-client session.

23. The one or more non-transitory storage media of claim 22, wherein the instructions, when executed, further cause performance of:

verifying that first client-visible results of executing the set of commands in the first server-client session match second client-visible results of executing for each command in the second server-client session as each command is executed; and

if the first client-visible results do not match the second client-visible results, the server machine indicating, to the client, that the first server-client session cannot be restored on the second server-client session.

24. The one or more non-transitory storage media of claim 18, wherein the one or more items of server-side environment information were appended to a message that was sent to the client in response to execution of each command in the first server-client session.

25. The one or more non-transitory storage media of claim 18, wherein the one or more items of server-side environment information include one or more of:

an identity of an underlying database of the first server-client session, a type of the underlying database of the first server-client session, a logical state or time of the underlying database of the first server-client session, a hardware platform that is used for the first server-client session, endianness or other storage format characteristics for the first server-client session, session state signature or hash used to determine that the session state is correct for replay, security credentials used for the first server-client session, protocol information to ensure that execution in the second server-client session is in correct order, original values that were returned from function calls in the first server-client session, versions of data against which commands were executed in the first server-client session, and an optimizer execution plan that preserves an output order of commands in the first server-client session.

32. One or more non-transitory storage media as recited in claim 18, wherein the one or more items of server-side environment information comprise one or more characteristics of server-side state that allows the second server-client session to be built to a same state that the first server-client session was built.

33. One or more non-transitory storage media as recited in claim 18, wherein the one or more items of server-side environment information comprise one or more characteristics of the data returned from command execution in the first server-client session that allows validation of data returned from command execution in the second server-client session.